function Commit($post) { $message = trim($post["message"]); $r = SQLLib::SelectRow("SELECT count(0) as c FROM bbs_posts WHERE topic=".$this->topic); $a = array(); $a["userlastpost"] = get_login_id(); $a["lastpost"] = date("Y-m-d H:i:s"); $a["count"] = $r->c; SQLLib::UpdateRow("bbs_topics",$a,"id=".$this->topic); $a = array(); $a["added"] = date("Y-m-d H:i:s"); $a["author"] = get_login_id(); $a["post"] = $message; $a["topic"] = $this->topic; SQLLib::InsertRow("bbs_posts",$a); @unlink("cache/pouetbox_latestbbs.cache"); return array(); }
function Commit($post) { $message = trim($post["comment"]); $rating = $post["rating"]; if ($this->myVote) $rating = "isok"; // user already has a vote $vote = 0; switch($rating) { case "rulez": $vote = 1; break; case "sucks": $vote = -1; break; default: $vote = 0; break; } $a = array(); $a["addedDate"] = date("Y-m-d H:i:s"); $a["who"] = get_login_id(); $a["which"] = $this->prod; $a["comment"] = $message; $a["rating"] = $vote; SQLLib::InsertRow("comments",$a); $rulez=0; $piggie=0; $sucks=0; $total=0; $checktable = array(); $r = SQLLib::SelectRows("SELECT rating,who FROM comments WHERE which=".$this->prod); foreach ($r as $t) if(!array_key_exists($t->who, $checktable) || $t->rating != 0) $checktable[$t->who] = $t->rating; foreach($checktable as $k=>$v) { if($v==1) $rulez++; else if($v==-1) $sucks++; else $piggie++; $total++; } if ($total!=0) $avg = sprintf("%.2f",(float)($rulez*1+$sucks*-1)/(float)$total); else $avg = "0.00"; $a = array(); $a["voteup"] = $rulez; $a["votepig"] = $piggie; $a["votedown"] = $sucks; $a["voteavg"] = $avg; SQLLib::UpdateRow("prods",$a,"id=".$this->prod); @unlink("cache/pouetbox_latestcomments.cache"); @unlink("cache/pouetbox_topmonth.cache"); @unlink("cache/pouetbox_stats.cache"); return array(); }
function Commit($data) { global $partyID; $sql = array(); $sql["download"] = $data["download"]; $sql["csdb"] = $data["csdbID"]; $sql["slengpung"] = $data["slengpungID"]; //$sql["zxdemo"] = $data["zxdemoID"]; $sql["demozoo"] = $data["demozooID"]; $sql["artcity"] = $data["artcity"]; $links = SQLLib::selectRow(sprintf_esc("select * from partylinks where party = %d and year = %d",$this->id,$this->year)); if ($links) { SQLLib::UpdateRow("partylinks",$sql,sprintf_esc("party = %d and year = %d",$this->id,$this->year)); } else { $sql["party"] = $this->id; $sql["year"] = $this->year; SQLLib::InsertRow("partylinks",$sql); } if (is_uploaded_file($_FILES["results"]["tmp_name"])) { move_uploaded_file_fake($_FILES["results"]["tmp_name"],get_local_partyresult_path($this->id,$this->year)); } gloperator_log( "party", (int)$this->id, "party_edit_links", array("year"=>$this->year) ); return array(); }
function Commit($data) { $post = array(); global $REQUESTTYPES; if ($REQUESTTYPES[ $_POST["requestType"] ]) { $error = $REQUESTTYPES[ $_POST["requestType"] ]::ValidateRequest($data,$post); if ($error) return $error; } else { return array("no such request type!"); } $a = array(); $a["requestType"] = $data["requestType"]; if($_REQUEST["prod"]) { $a["itemID"] = (int)$_REQUEST["prod"]; $a["itemType"] = "prod"; } $a["requestDate"] = date("Y-m-d H:i:s"); $a["userID"] = get_login_id(); $a["requestBlob"] = serialize($post); global $reqID; $reqID = SQLLib::InsertRow("modification_requests",$a); return array(); }
function Create() { $a = array(); $a["id"] = $this->id; $a["nickname"] = $this->nickname; $a["avatar"] = $this->avatar; $a["registerDate"] = date("Y-m-d H:i:s"); $a["lastip"] = $_SERVER["REMOTE_ADDR"]; $a["lasthost"] = gethostbyaddr($_SERVER["REMOTE_ADDR"]); SQLLib::InsertRow("users",$a); }
function Commit( $data ) { $a = array(); $a["name"] = trim($data["name"]); $a["desc"] = $data["desc"]; $a["upkeeper"] = get_login_id(); $a["addedUser"] = get_login_id(); $a["addedDate"] = date("Y-m-d H:i:s"); $this->listID = SQLLib::InsertRow("lists",$a); return array(); }
function Commit( $data ) { $a = array(); $a["download"] = trim($data["download"]); $a["csdb"] = $data["csdbID"]; //$a["zxdemo"] = $data["zxdemoID"]; $a["demozoo"] = $data["demozooID"]; $a["slengpung"] = $data["slengpungID"]; $a["artcity"] = $data["artcity"]; SQLLib::InsertRow("partylinks",$a); return array(); }
function Commit($data) { global $currentUser; $filename = strtolower( basename( $_FILES["logo"]["name"] ) ); move_uploaded_file_fake( $_FILES["logo"]["tmp_name"], POUET_CONTENT_LOCAL . "/logos/".$filename ); $a = array(); $a["author1"] = $currentUser->id; $a["author2"] = NULL; $a["file"] = $filename; SQLLib::InsertRow("logos",$a); return array(); }
function Commit($post) { global $currentUser; $message = trim($post["message"]); $a = array(); $a["who"] = $currentUser->id; $a["addedDate"] = date("Y-m-d H:i:s"); $a["message"] = $message; SQLLib::InsertRow("oneliner",$a); $this->ForceCacheUpdate(); return array(); }
function Commit($data) { global $groupID; $a = array(); $a["name"] = trim($data["name"]); $a["acronym"] = $data["acronym"]; $a["web"] = $data["website"]; $a["addedUser"] = get_login_id(); $a["csdb"] = $data["csdbID"]; //$a["zxdemo"] = $data["zxdemoID"]; $a["demozoo"] = $data["demozooID"]; $a["addedDate"] = date("Y-m-d H:i:s"); $this->groupID = SQLLib::InsertRow("groups",$a); return array(); }
function ParsePostMessage($post) { global $currentUser; if (!$currentUser) return "you have to be logged in!"; if (!$currentUser->CanPostInBBS()) return "not allowed lol."; $message = trim($post["message"]); if (!$message) return "not too meaningful, is it..."; $title = trim($post["topic"]); if (strlen($title) < 2) return "not too meaningful, is it..."; $r = SQLLib::SelectRow(sprintf_esc("SELECT id FROM bbs_topics where topic='%s'",$title)); if ($r) return "DOUBLEPOST == ROB IS JARIG"; $a = array(); $a["topic"] = $title; $a["category"] = $post["category"]; $a["userfirstpost"] = $a["userlastpost"] = get_login_id(); $a["firstpost"] = $a["lastpost"] = date("Y-m-d H:i:s"); $id = SQLLib::InsertRow("bbs_topics",$a); $a = array(); $a["added"] = date("Y-m-d H:i:s"); $a["author"] = get_login_id(); $a["post"] = $message; $a["topic"] = $id; SQLLib::InsertRow("bbs_posts",$a); @unlink("cache/pouetbox_latestbbs.cache"); return ""; }
function Commit($data) { global $currentUser; $a = array(); $a["category"] = $data["category"]; $a["question"] = $data["question"]; $a["answer"] = $data["answer"]; $a["deprecated"] = $data["deprecated"] == "on"; if ($data["faqID"]) { //gloperator_log( "faq", $data["faqID"], "faq_edit" ); SQLLib::UpdateRow("faq",$a,"id=".(int)$data["faqID"]); } else { //gloperator_log( "faq", 0, "faq_add" ); SQLLib::InsertRow("faq",$a); } return array(); }
function Commit($data) { global $boardID; $a = array(); $a["name"] = trim($data["name"]); $a["sysop"] = trim($data["sysop"]); if( $data["started_year"] && $data["started_month"] && checkdate( (int)$data["started_month"], 15, (int)$data["started_year"]) ) $a["started"] = sprintf("%04d-%02d-15",$data["started_year"],$data["started_month"]); else if ($data["started_year"]) $a["started"] = sprintf("%04d-00-15",$data["started_year"]); if( $data["closed_year"] && $data["closed_month"] && checkdate( (int)$data["closed_month"], 15, (int)$data["closed_year"]) ) $a["closed"] = sprintf("%04d-%02d-15",$data["closed_year"],$data["closed_month"]); else if ($data["closed_year"]) $a["closed"] = sprintf("%04d-00-15",$data["closed_year"]); $a["phonenumber"] = trim($data["phonenumber"]); $a["telnetip"] = trim($data["telnetip"]); SQLLib::UpdateRow("boards",$a,"id=".$this->id); $data["platform"] = array_unique($data["platform"]); SQLLib::Query(sprintf_esc("delete from boards_platforms where board = %d",(int)$this->id)); foreach($data["platform"] as $v) { $a = array(); $a["board"] = (int)$this->id; $a["platform"] = $v; SQLLib::InsertRow("boards_platforms",$a); } gloperator_log( "board", $this->id, "board_edit" ); return array(); }
function Commit( $data ) { global $currentUser; $a = array(); $a["name"] = trim($data["name"]); $a["sysop"] = trim($data["sysop"]); if( $data["started_year"] && $data["started_month"] && checkdate( (int)$data["started_month"], 15, (int)$data["started_year"]) ) $a["started"] = sprintf("%04d-%02d-15",$data["started_year"],$data["started_month"]); else if ($data["started_year"]) $a["started"] = sprintf("%04d-00-15",$data["started_year"]); if( $data["closed_year"] && $data["closed_month"] && checkdate( (int)$data["closed_month"], 15, (int)$data["closed_year"]) ) $a["closed"] = sprintf("%04d-%02d-15",$data["closed_year"],$data["closed_month"]); else if ($data["closed_year"]) $a["closed"] = sprintf("%04d-00-15",$data["closed_year"]); $a["phonenumber"] = trim($data["phonenumber"]); $a["telnetip"] = trim($data["telnetip"]); $a["addedUser"] = $currentUser->id; $a["addedDate"] = date("Y-m-d H:i:s"); $this->boardID = SQLLib::InsertRow("boards",$a); $data["platform"] = array_unique($data["platform"]); foreach($data["platform"] as $k=>$v) { $a = array(); $a["board"] = $this->boardID; $a["platform"] = $v; SQLLib::InsertRow("boards_platforms",$a); } return array(); }
} $csrf = new CSRFProtect(); if ($_POST["wlAction"] && $currentUser) { if (!$csrf->ValidateToken()) exit(); if ($_POST["wlAction"]=="removeFromWatchlist") { SQLLib::Query(sprintf_esc("delete from watchlist where prodID = %d and userID = %d",$prodid,$currentUser->id)); } else if ($_POST["wlAction"]=="addToWatchlist") { $a = array("prodID"=>$prodid,"userID"=>$currentUser->id); SQLLib::InsertRow("watchlist",$a); } if ($_POST["partial"]) { $csrf->PrintToken(); if ($_POST["wlAction"]=="addToWatchlist") { echo "<input type='hidden' name='wlAction' value='removeFromWatchlist'>"; echo "<input type='submit' value='remove from watchlist' class='remove'/>"; } else if ($_POST["wlAction"]=="removeFromWatchlist") { echo "<input type='hidden' name='wlAction' value='addToWatchlist'>"; echo "<input type='submit' value='add to watchlist' class='add'/>"; } exit();
function Commit($data) { $this->LoadFromDB(); $prodID = (int)$this->prod->id; $sql = array(); if ($this->fields["releaseDate"]) { if ($data["releaseDate_month"] && $data["releaseDate_year"] && checkdate( (int)$data["releaseDate_month"], 15, (int)$data["releaseDate_year"]) ) $sql["releaseDate"] = sprintf("%04d-%02d-15",$data["releaseDate_year"],$data["releaseDate_month"]); else if ($data["releaseDate_year"]) $sql["releaseDate"] = sprintf("%04d-00-15",$data["releaseDate_year"]); else $sql["releaseDate"] = null; } if ($this->fields["partyCompo"]) $sql["party_compo"] = nullify($data["partyCompo"]); if ($this->fields["partyRank"]) $sql["party_place"] = $data["partyRank"]; if ($sql) SQLLib::UpdateRow("prods",$sql,"id=".$prodID); if ($this->fields["screenshot"]) { if(is_uploaded_file($_FILES["screenshot"]["tmp_name"])) { foreach( array( "jpg","gif","png" ) as $v ) @unlink( get_local_screenshot_path( $prodID, $v ) ); 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( $prodID, $extension ) ); $a = array(); $a["prod"] = $prodID; $a["user"] = get_login_id(); $a["added"] = date("Y-m-d H:i:s"); SQLLib::InsertRow("screenshots",$a); } } if ($this->fields["nfofile"]) { if(is_uploaded_file($_FILES["nfofile"]["tmp_name"])) { move_uploaded_file_fake( $_FILES["nfofile"]["tmp_name"], get_local_nfo_path( $prodID ) ); $a = array(); $a["prod"] = $prodID; $a["user"] = get_login_id(); $a["added"] = date("Y-m-d H:i:s"); SQLLib::InsertRow("nfos",$a); } } return array(); }
function Commit($post) { $items = array("prod","group","party","user"); $added = false; foreach($items as $v) { if ($post[$v."ID"]) { $a = array(); $a["list"] = $this->list->id; $a["type"] = $v; $a["itemid"] = $post[$v."ID"]; SQLLib::InsertRow("listitems",$a); $added = true; } } return $added ? array() : array("you didn't add anything ! :("); }
if (get_login_id() && $_POST["logoID"] && $_POST["submit"]) { $vote = 0; if ($_POST["submit"] == "rulez") $vote = 1; if ($_POST["submit"] == "sucks") $vote = -1; $csrf = new CSRFProtect(); if ($vote && $csrf->ValidateToken()) { SQLLib::Query(sprintf_esc("delete from logos_votes where logo = %d and user = %d",$_POST["logoID"],$currentUser->id)); $a = array(); $a["logo"] = (int)$_POST["logoID"]; $a["user"] = $currentUser->id; $a["vote"] = $vote; SQLLib::InsertRow("logos_votes",$a); } SQLLib::Query(sprintf_esc("update logos set vote_count = (select sum(vote) from logos_votes where logo = %d) where id = %d",(int)$_POST["logoID"],(int)$_POST["logoID"])); // ajax if ($_POST["partial"]==1) { $s = clone $sel; $visibleLogos = $_POST["visibleLogos"]; foreach($visibleLogos as $k=>$v) $visibleLogos[$k] = (int)$v; $s->AddWhere(sprintf_esc("logos.id not in (%s)",implode(",",$visibleLogos))); $s->SetLimit(1); $logo = SQLLib::SelectRow($s->GetQuery()); if ($logo)
static function Process($itemID, $reqData) { $a = array(); $a["prodID"] = $itemID; $a["userID"] = $reqData["userID"]; $a["role"] = $reqData["userRole"]; SQLLib::InsertRow("credits",$a); return array(); }
function Commit($data) { if ($data["delAffil"]) { SQLLib::Query("delete from affiliatedprods where id=".(int)$data["delAffil"]); gloperator_log( "prod", (int)$this->prod->id, "prod_rel_del" ); return array(); } list($direction,$type) = explode(":",$data["type"],2); $a = array(); $a["type"] = $type; $a["original"] = $direction == "o" ? $this->prod->id : $data["prod"]; $a["derivative"] = $direction == "d" ? $this->prod->id : $data["prod"]; if ($data["editAffilID"]) { SQLLib::UpdateRow("affiliatedprods",$a,"id=".(int)$data["editAffilID"]); $a["id"] = $data["editAffilID"]; gloperator_log( "prod", (int)$this->prod->id, "prod_rel_edit", array("id"=>$a["id"]) ); } else { $a["id"] = SQLLib::InsertRow("affiliatedprods",$a); gloperator_log( "prod", (int)$this->prod->id, "prod_rel_add", array("id"=>$a["id"]) ); } if ($data["partial"]) { $o = toObject($a); $o->prodOriginal = PouetProd::Spawn($a["original"]); $o->prodDerivative = PouetProd::Spawn($a["derivative"]); $this->RenderNormalRow($o); $this->RenderNormalRowEnd($o); exit(); } return array(); }
function gloperator_log( $itemType, $itemID, $action, $additionalData = array() ) { global $currentUser; $sql = array(); $sql["gloperatorID"] = $currentUser->id; $sql["itemID"] = $itemID; $sql["itemType"] = $itemType; $sql["action"] = $action; $sql["date"] = date("Y-m-d H:i:s"); $sql["additionalData"] = json_encode($additionalData); SQLLib::InsertRow("gloperator_log",$sql); }
function Commit($data) { global $currentUser; global $currentUserSettings; global $ephemeralStorage; require_once("include_pouet/default_usersettings.php"); $a = get_object_vars( $DEFAULT_USERSETTINGS ); if (SQLLib::SelectRow(sprintf_esc("select id from usersettings where id=%d",(int)$currentUser->id))) SQLLib::UpdateRow("usersettings",$a,"id=".(int)$currentUser->id); else SQLLib::InsertRow("usersettings",array_merge(array("id"=>(int)$currentUser->id),$a) ); $currentUserSettings = $DEFAULT_USERSETTINGS; $ephemeralStorage->set( "settings:".$currentUser->id, $currentUserSettings ); return array(); }
static function UpdateOrInsertRow($table,$o,$where) { if (SQLLib::SelectRow(sprintf("SELECT * FROM %s WHERE %s",$table,$where))) return SQLLib::UpdateRow($table,$o,$where); else return SQLLib::InsertRow($table,$o); }
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(); }