Esempio n. 1
0
         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;
     }
 }
Esempio n. 2
0
// 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"]));