<?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;
