function Commit($data) { SQLLib::Query(sprintf_esc("DELETE FROM downloadlinks WHERE prod=%d",$this->prod->id)); SQLLib::Query(sprintf_esc("DELETE FROM comments WHERE which=%d",$this->prod->id)); SQLLib::Query(sprintf_esc("DELETE FROM nfos WHERE prod=%d",$this->prod->id)); SQLLib::Query(sprintf_esc("DELETE FROM screenshots WHERE prod=%d",$this->prod->id)); SQLLib::Query(sprintf_esc("DELETE FROM prods_platforms WHERE prod=%d",$this->prod->id)); SQLLib::Query(sprintf_esc("DELETE FROM sceneorgrecommended WHERE prodid=%d",$this->prod->id)); SQLLib::Query(sprintf_esc("DELETE FROM users_cdcs WHERE cdc=%d",$this->prod->id)); SQLLib::Query(sprintf_esc("DELETE FROM affiliatedprods WHERE original=%d or derivative=%d",$this->prod->id,$this->prod->id)); SQLLib::Query(sprintf_esc("DELETE FROM prods_refs WHERE prod=%d",$this->prod->id)); SQLLib::Query(sprintf_esc("DELETE FROM prodotherparty WHERE prod=%d",$this->prod->id)); SQLLib::Query(sprintf_esc("DELETE FROM cdc WHERE which=%d",$this->prod->id)); SQLLib::Query(sprintf_esc("DELETE FROM credits WHERE prodID=%d",$this->prod->id)); SQLLib::Query(sprintf_esc("DELETE FROM watchlist WHERE prodID=%d",$this->prod->id)); SQLLib::Query(sprintf_esc("DELETE FROM listitems WHERE itemid=%d AND type='prod'",$this->prod->id)); SQLLib::Query(sprintf_esc("DELETE FROM prods_linkcheck WHERE prodID=%d LIMIT 1",$this->prod->id)); SQLLib::Query(sprintf_esc("DELETE FROM prods WHERE id=%d LIMIT 1",$this->prod->id)); @unlink( get_local_nfo_path( (int)$this->prod->id ) ); foreach( array( "jpg","gif","png" ) as $v ) @unlink( get_local_screenshot_path( (int)$this->prod->id, $v ) ); gloperator_log( "prod", (int)$this->prod->id, "prod_delete", get_object_vars($this->prod) ); return array(); }
function LoadFromDB() { parent::LoadFromDB(); $prod = $this->prod; $a = array(); unset($this->fields["name"]); unset($this->fields["download"]); unset($this->fields["group1"]); unset($this->fields["group2"]); unset($this->fields["group3"]); if ($prod->releaseDate) unset($this->fields["releaseDate"]); unset($this->fields["platform"]); unset($this->fields["type"]); if ($prod->party) { unset($this->fields["partyID"]); unset($this->fields["partyYear"]); } if ($prod->party->id == NO_PARTY_ID || $prod->placings[0]->compo) unset($this->fields["partyCompo"]); if ($prod->party->id == NO_PARTY_ID || $prod->placings[0]->ranking) unset($this->fields["partyRank"]); //unset($this->fields["sceneOrgID"]); unset($this->fields["zxdemoID"]); unset($this->fields["csdbID"]); unset($this->fields["demozooID"]); unset($this->fields["invitationParty"]); unset($this->fields["invitationYear"]); if ( file_exists( get_local_nfo_path( $prod->id ) ) ) unset($this->fields["nfofile"]); if ( glob( get_local_screenshot_path( $prod->id, "*" ) ) ) unset($this->fields["screenshot"]); }
function Commit($data) { ////////////////////////////////////////////////////////////////// // everything has been validated (..., the new album by BT!) $a = array(); $a["name"] = $data["name"]; $a["download"] = $data["download"]; $a["addedUser"] = get_login_id(); $a["addedDate"] = date("Y-m-d H:i:s"); if( $data["releaseDate_year"] && $data["releaseDate_month"] && checkdate( (int)$data["releaseDate_month"], 15, (int)$data["releaseDate_year"]) ) $a["releaseDate"] = sprintf("%04d-%02d-15",$data["releaseDate_year"],$data["releaseDate_month"]); else if ($data["releaseDate_year"]) $a["releaseDate"] = sprintf("%04d-00-15",$data["releaseDate_year"]); $a["type"] = implode(",",$data["type"]); $groups = array(); if ($data["group1"]) $groups[] = (int)$data["group1"]; if ($data["group2"]) $groups[] = (int)$data["group2"]; if ($data["group3"]) $groups[] = (int)$data["group3"]; $groups = array_unique($groups); $a["group1"] = nullify( array_shift($groups) ); $a["group2"] = nullify( array_shift($groups) ); $a["group3"] = nullify( array_shift($groups) ); $a["csdb"] = $data["csdbID"]; //$a["sceneorg"] = $data["sceneOrgID"]; //$a["zxdemo"] = $data["zxdemoID"]; $a["demozoo"] = $data["demozooID"]; $a["party"] = nullify($data["partyID"]); $a["party_year"] = $data["partyYear"]; $a["party_compo"] = nullify($data["partyCompo"]); $a["party_place"] = $data["partyRank"]; $a["invitation"] = nullify($data["invitationParty"]); $a["invitationyear"] = $data["invitationYear"]; $a["boardID"] = nullify($data["boardID"]); $this->prodID = SQLLib::InsertRow("prods",$a); $data["platform"] = array_unique($data["platform"]); foreach($data["platform"] as $k=>$v) { $a = array(); $a["prod"] = $this->prodID; $a["platform"] = $v; SQLLib::InsertRow("prods_platforms",$a); } if(is_uploaded_file($_FILES["screenshot"]["tmp_name"])) { list($width,$height,$type) = GetImageSize($_FILES["screenshot"]["tmp_name"]); $extension = "_"; switch($type) { case 1:$extension="gif";break; case 2:$extension="jpg";break; case 3:$extension="png";break; } move_uploaded_file_fake( $_FILES["screenshot"]["tmp_name"], get_local_screenshot_path( $this->prodID, $extension ) ); $a = array(); $a["prod"] = $this->prodID; $a["user"] = get_login_id(); $a["added"] = date("Y-m-d H:i:s"); SQLLib::InsertRow("screenshots",$a); } if(is_uploaded_file($_FILES["nfofile"]["tmp_name"])) { move_uploaded_file_fake( $_FILES["nfofile"]["tmp_name"], get_local_nfo_path( $this->prodID ) ); $a = array(); $a["prod"] = $this->prodID; $a["user"] = get_login_id(); $a["added"] = date("Y-m-d H:i:s"); SQLLib::InsertRow("nfos",$a); } @unlink("cache/pouetbox_latestadded.cache"); @unlink("cache/pouetbox_latestreleased.cache"); @unlink("cache/pouetbox_latestparties.cache"); return array(); }