function gnavi_update_desc($mode, $lid, $cid, $title, $submitter, $valid, $ext, $ext1, $ext2, $resx, $resy, $resx1, $resy1, $resx2, $resy2, $caption, $caption1, $caption2, $desc, $arrowhtml, $addinfo)
{
global $xoopsDB, $gnavi_addposts;
global $table_photos, $table_text, $table_cat, $mod_url, $isadmin;
$myts =& GNaviTextSanitizer::getInstance();
$caption = $ext == '' ? '' : $caption;
$caption1 = $ext1 == '' ? '' : $caption1;
$caption2 = $ext2 == '' ? '' : $caption2;
$sql = "UPDATE {$table_photos} SET caption='" . addSlashes($caption) . "',caption1='" . addSlashes($caption1) . "',caption2='" . addSlashes($caption2) . "',ext='{$ext}',ext1='{$ext1}',ext2='{$ext2}',res_x={$resx},res_y={$resy},res_x1={$resx1},res_y1={$resy1},res_x2={$resx2},res_y2={$resy2} WHERE lid='{$lid}'";
$xoopsDB->query($sql) or die("DB error: UPDATE text table");
if ($mode == G_INSERT) {
$sql = "INSERT INTO {$table_text} (lid, description,arrowhtml,addinfo) VALUES ({$lid},'" . addSlashes($desc) . "',{$arrowhtml},'" . addSlashes($addinfo) . "')";
$xoopsDB->query($sql) or die("DB error: INSERT desc table");
// Update User's Posts (Should be modified when need admission.)
$user_handler =& xoops_gethandler('user');
$submitter_obj =& $user_handler->get($submitter);
if (is_object($submitter_obj)) {
for ($i = 0; $i < $gnavi_addposts; $i++) {
$submitter_obj->incrementPost();
}
}
} else {
// not admin can only touch photos status>0
$whr_status = $isadmin ? '' : 'AND status>0';
$sql = "UPDATE {$table_text} SET description='" . addSlashes($desc) . "',arrowhtml={$arrowhtml},addinfo='" . addSlashes($addinfo) . "' WHERE lid='{$lid}'";
$xoopsDB->query($sql) or die("DB error: UPDATE text table");
}
// Trigger Notification if Change Or submit
if ($valid == 1) {
$notification_handler =& xoops_gethandler('notification');
$tags = array();
$tags['PHOTO_TITLE'] = $title;
$tags['PHOTO_URI'] = $mod_url . "/index.php?lid=" . $lid;
// Global Notification
gnavi_trigger_event('global', 0, 'new_item', $tags);
// Category Notification
$rs = $xoopsDB->query("SELECT title FROM {$table_cat} WHERE cid={$cid}");
list($cat_title) = $xoopsDB->fetchRow($rs);
$tags['CATEGORY_TITLE'] = $cat_title;
$tags['PHOTO_URI'] = $mod_url . "/index.php?lid=" . $lid . "&cid=" . $cid;
gnavi_trigger_event('category', $cid, 'new_item', $tags);
}
}
$whr .= "lid={$id} OR ";
}
$xoopsDB->query("UPDATE {$table_photos} SET status=1 WHERE {$whr} 0");
// Trigger Notification
$notification_handler =& xoops_gethandler('notification');
$rs = $xoopsDB->query("SELECT l.lid,l.cid,l.submitter,l.title,c.title FROM {$table_photos} l LEFT JOIN {$table_cat} c ON l.cid=c.cid WHERE {$whr} 0");
while (list($lid, $cid, $submitter, $title, $cat_title) = $xoopsDB->fetchRow($rs)) {
$tags = array();
$tags['PHOTO_TITLE'] = $title;
$tags['PHOTO_URI'] = $mod_url . "/index.php?lid=" . $lid;
// Global Notification
gnavi_trigger_event('global', 0, 'new_item', $tags);
// Category Notification
$tags['CATEGORY_TITLE'] = $cat_title;
$tags['PHOTO_URI'] = $mod_url . "/index.php?lid=" . $lid . "&cid=" . $cid;
gnavi_trigger_event('category', $cid, 'new_item', $tags);
}
redirect_header('index.php?page=admission', 2, _MD_A_GNAVI_ADMITTING);
exit;
} else {
if (!empty($_POST['action']) && $_POST['action'] == 'delete' && isset($_POST['ids']) && is_array($_POST['ids'])) {
// remove records
// Ticket Check
if (!$xoopsGTicket->check()) {
redirect_header(XOOPS_URL . '/', 3, $xoopsGTicket->getErrors());
}
foreach ($_POST['ids'] as $lid) {
gnavi_delete_photos("lid=" . intval($lid));
}
redirect_header("index.php?page=admission", 2, _MD_GNAV_SMT_DELETINGITEM);
exit;