if (submitImage($objid, $uploadError == _UPL_NO_FILE ? "" : "submission", $uploadErrorThumb == _UPL_NO_FILE ? "" : "thumb", $uploadErrorThumb, $imageChanged)) { if ($imageChanged) { if (isset($_POST["sendNotification"]) && $_POST["sendNotification"]) { 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); } notifyClubWatchers($objData["objCreator"], $objid, "objForClub"); notifyClubWatchers($objData["objCreator"], $objid, "objForClub2"); notifyClubWatchers($objData["objCreator"], $objid, "objForClub3"); removeDupeArtUpdates($objid); } // Increase object's number of edits and also set abuse report // to "enabled" because the submission content has changed. $result = sql_query("SELECT `objNumEdits` FROM {$_objExtData} " . "WHERE `objEid` = '{$objid}' LIMIT 1"); $numEdits = mysql_result($result, 0) + 1; sql_query("UPDATE {$_objExtData} SET `objNoAbuse` = '0', " . "`objNumEdits` = '{$numEdits}'{$oekakiExtras} " . "WHERE `objEid` = '{$objid}' LIMIT 1"); } // Redirect the user to view the submission. redirect(url("view/" . $objid)); } } if (!$uploadError && $uploadErrorThumb) { $uploadError = _SUBMIT_THUMBNAIL_ERROR; } }
// 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); } redirect(url("view/" . $objData["objid"]));