Das Diskussionsforum zum Open Source Content Management System
https://forum.contenido.org/
Code: Alles auswählen
if (move_uploaded_file($filetemp, $sPath.$filename) && !$dir_error) {
chmod($sPath.$filename,0664);
$newArr=mysql_fetch_assoc(mysql_query("SELECT * FROM ".$cfg['sql']['sqlprefix']."_upl ORDER BY idupl DESC LIMIT 1"));
$newID=$newArr[idupl]+1;
$qry=mysql_query("SELECT * FROM ".$cfg['sql']['sqlprefix']."_upl WHERE filename='".$filename."' AND dirname='".$sDirname."'");
if (mysql_num_rows($qry)==0) $qry=mysql_query("INSERT INTO ".$cfg['sql']['sqlprefix']."_upl VALUES('".$newID."', '".$client."', '".$filename."', '".$sDirname."', '".strtolower(array_pop(explode('.',$filename)))."', '".$filesize."', '".$fileDesc."', '0', '".$auth->auth["uid"] ."', '".date('Y-m-d H:i:s')."', '".date('Y-m-d H:i:s')."', '".$auth->auth["uid"]."')");
$newArr=mysql_fetch_assoc(mysql_query("SELECT * FROM ".$cfg['sql']['sqlprefix']."_upl_meta ORDER BY id_uplmeta DESC LIMIT 1"));
$newIDMeta=$newArr[id_uplmeta]+1;
$qry=mysql_query("INSERT INTO ".$cfg['sql']['sqlprefix']."_upl_meta VALUES('".$newIDMeta."', '".$newID."', '".$lang."', '".$fileTitle."', '".$fileDesc."', '".$fileKeywords."', 'downloads%3A0%7C%7Cstatus%3A".$fileStatus."%7C%7C', '', '".date('Y-m-d H:i:s')."', '".date('Y-m-d H:i:s')."', '', '')");
// Set new ID in database to avoid problems with Dateiverwaltung
$newDBID=$newID+1;
$qry=mysql_query("UPDATE ".$cfg[sql][sqlprefix]."_sequence SET nextid='".$newDBID."' WHERE seq_name='".$cfg[tab][upl]."' LIMIT 1");
$newDBMetaID=$newIDMeta+1;
$qry=mysql_query("UPDATE ".$cfg[sql][sqlprefix]."_sequence SET nextid='".$newDBMetaID."' WHERE seq_name='".$cfg[tab][upl_meta]."' LIMIT 1");
}
