<?php // Confirm/Refuse a collaborative work. $accept = isset($_GET["accept"]) ? $_GET["accept"] != "0" : false; $sql = "SELECT `objid`, `objCreator` FROM `objects`, `objExtData`" . dbWhere(array("objid*" => "objEid", "objid" => intval($_cmd[1]), "objCollab" => $_auth["useid"], "objCollabConfirmed" => 0, "objPending" => 0, "objDeleted" => 0)); $objResult = sql_query($sql); if (!($objData = mysql_fetch_assoc($objResult))) { include INCLUDES . "p_notfound.php"; return; } mysql_free_result($objResult); if ($accept) { $sql = "UPDATE `objExtData`" . dbSet(array("objCollabConfirmed" => 1)) . dbWhere(array("objEid" => $objData["objid"])); sql_query($sql); // Send to watchers. addArtUpdateToWatchers($_auth["useid"], $objData["objid"], 0, $objData["objCreator"]); removeDupeArtUpdates($objData["objid"]); // Move all associated comments from the last 10 days to Updates. $sql = "SELECT `comid`, `comCreator` FROM `comments`" . dbWhere(array("|1" => "`comSubmitDate` > DATE_SUB( CURDATE(), INTERVAL 10 DAY )", "comObj" => $objData["objid"], "comObjType" => "obj")); $comResult = sql_query($sql); while ($comData = mysql_fetch_assoc($comResult)) { if ($comData["comCreator"] == $_auth["useid"]) { continue; } addUpdate(updTypeComment, $_auth["useid"], $comData["comid"], $comData["comCreator"]); } mysql_free_result($comResult); } else { $sql = "UPDATE `objects`" . dbSet(array("objCollab" => 0)) . dbWhere(array("objid" => $objData["objid"])); sql_query($sql); }
function notifyClubWatchers($objCreator, $objid, $clubField) { global $_objects; // If this submission is going into some club, notify the club's watchers. $result = sql_query("SELECT `objForClub` FROM {$_objects} WHERE `objid` = '{$objid}' LIMIT 1"); $forClub = mysql_result($result, 0); // Notify the watchers. addArtUpdateToWatchers($objCreator, $objid, $forClub); }
$gift = isset($_POST["gift"]) ? intval($_POST["gift"]) : 0; // Submit new title and receive the object id. $filters = implode(",", getFiltersByKeywords(preg_split('/\\s/', $_POST["keywordList"], -1, PREG_SPLIT_NO_EMPTY))); $objid = submitNewTitle($_POST["title"], $_POST["comment"], $filters, $forClub, $folder, $collab, $gift, $forClub2, $forClub3); submitKeywords($objid, $_POST["keywordList"]); if (submitImage($objid, "submission", $uploadErrorThumb == _UPL_NO_FILE ? "" : "thumb", $uploadErrorThumb, $imageChanged)) { // Make the submission accessible by setting // `objDeleted` = '0'. sql_query("UPDATE `objects` " . "SET `objDeleted` = '0' " . "WHERE `objid` = '{$objid}' LIMIT 1"); if ($oekakiExtras != "") { sql_query("UPDATE `objExtData` " . "SET {$oekakiExtras} " . "WHERE `objEid` = '{$objid}' LIMIT 1"); } // Notify the watchers. addArtUpdateToWatchers($_auth["useid"], $objid, $forClub); addArtUpdateToWatchers($_auth["useid"], $objid, $forClub2); addArtUpdateToWatchers($_auth["useid"], $objid, $forClub3); removeDupeArtUpdates($objid); // Clean up the objects table - remove // submissions that failed uploading. $result = sql_query("SELECT `objid` " . "FROM `objects`, `objExtData` " . "WHERE `objid` = `objEid` " . "AND `objExtension` = '' " . "AND `objDeleted` = '1'"); while ($delData = mysql_fetch_assoc($result)) { sql_query("DELETE FROM `objects` " . "WHERE `objid` = '" . $delData["objid"] . "'"); sql_query("DELETE FROM `objExtData` " . "WHERE `objEid` = '" . $delData["objid"] . "'"); } include_once INCLUDES . "submission.php"; updateObjCount($_auth["useid"]); // Redirect the user to the newly submitted artwork... redirect(url("view/" . $objid)); } if (!$uploadError && $uploadErrorThumb) { $uploadError = _SUBMIT_THUMBNAIL_ERROR;