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();
}
