$num_stories++; if ($_POST['delPostMigrate'] == 1) { DB_query("DELETE FROM {$_TABLES['storysubmission']} WHERE sid='" . DB_escapeString($sid) . "'"); } } else { $topic = DB_getItem($_TABLES['stories'], "tid", "sid='" . DB_escapeString($sid) . "'"); $sql = DB_query("SELECT sid,tid,date,uid,title,introtext,bodytext,hits from {$_TABLES['stories']} WHERE sid='" . DB_escapeString($sid) . "'"); list($sid, $tid, $storydate, $uid, $subject, $introtext, $bodytext, $hits) = DB_fetchArray($sql); $num_posts = _ff_migratetopic($forum, $sid, $tid, $storydate, $uid, $subject, $introtext, $bodytext, $hits) + $num_posts; $num_stories++; if (isset($_POST['delPostMigrate']) && $_POST['delPostMigrate'] == 1) { migrate_deletestory($sid); } } } gf_resyncforum($forum); CTL_clearCache(); echo COM_refresh($_CONF['site_admin_url'] . "/plugins/forum/migrate.php?num_stories=" . $num_stories . "&num_posts=" . $num_posts); exit; } function _ff_migratetopic($forum, $sid, $tid, $storydate, $uid, $subject, $introtext, $bodytext, $hits) { global $_TABLES; $num_posts = 0; $comment = $introtext . $bodytext; $comment = prepareStringForDB($comment); $subject = prepareStringForDB($subject); $postmode = "html"; $name = DB_getITEM($_TABLES['users'], 'username', "uid=" . (int) $uid); $email = DB_getITEM($_TABLES['users'], 'email', "uid=" . (int) $uid); $website = DB_getITEM($_TABLES['users'], 'homepage', "uid=" . (int) $uid);
$num_stories++; if ($dpm == 1) { PLG_deleteSubmission('story', $sid); } } else { $sql = "SELECT sid,date,uid,title,introtext,bodytext,hits " . "FROM {$_TABLES['stories']} WHERE sid='{$sid}'"; $result = DB_query($sql); list($sid, $storydate, $uid, $subject, $introtext, $bodytext, $hits) = DB_fetchArray($result); $num_posts = migratetopic($selforum, $sid, $storydate, $uid, $subject, $introtext, $bodytext, $hits) + $num_posts; $num_stories++; if ($dpm == 1) { STORY_doDeleteThisStoryNow($sid); } } } gf_resyncforum($selforum); echo COM_refresh($_CONF['site_admin_url'] . "/plugins/forum/migrate.php?num_stories=" . $num_stories . "&num_posts=" . $num_posts); exit; } function migratetopic($forum, $sid, $storydate, $uid, $subject, $introtext, $bodytext, $hits) { global $_TABLES; $comment = $introtext . $bodytext; $comment = prepareStringForDB($comment); $subject = prepareStringForDB($subject); $postmode = "HTML"; $name = DB_getItem($_TABLES['users'], 'username', "uid={$uid}"); $email = DB_getItem($_TABLES['users'], 'email', "uid={$uid}"); $website = DB_getItem($_TABLES['users'], 'homepage', "uid={$uid}"); $datetime = explode(" ", $storydate); $date = explode("-", $datetime[0]);
function board_resync_category($id) { global $_CONF, $_FF_CONF, $_TABLES, $LANG_GF93; $retval = false; $statusMessage = array(); $query = DB_query("SELECT forum_id FROM {$_TABLES['ff_forums']} WHERE forum_cat=" . (int) $id); while (list($forum_id) = DB_fetchArray($query)) { gf_resyncforum($forum_id); } $retval = true; $statusMessage[] = $LANG_GF93['category_resynced']; return array($retval, $statusMessage); }
function forum_mergeForum($id, $new_id) { global $_TABLES; DB_query("UPDATE {$_TABLES['forum_topic']} SET forum='{$new_id}' WHERE forum='{$id}'"); DB_query("UPDATE {$_TABLES['forum_watch']} SET forum_id='{$new_id}' WHERE forum_id='{$id}'"); DB_query("UPDATE {$_TABLES['forum_log']} SET forum='{$new_id}' WHERE forum='{$id}'"); // Resynch forum now gf_resyncforum($new_id); // Delete old forum now and any records we do not need forum_deleteForum($id); return true; }
$privgroup = 2; } $attachmentgroup = COM_applyFilter($_POST['attachmentgroup'], true); if ($attachmentgroup == 0) { $privgroup = 1; } $sql = "UPDATE {$_TABLES['gf_forums']} SET forum_name='{$name}',forum_dscp='{$dscp}', grp_id={$privgroup}, "; $sql .= "is_hidden='{$is_hidden}', is_readonly='{$is_readonly}', no_newposts='{$no_newposts}',use_attachment_grpid={$attachmentgroup} "; $sql .= "WHERE forum_id='{$id}'"; DB_query($sql); forum_statusMessage($LANG_GF93['forumedited'], $_CONF['site_admin_url'] . '/plugins/forum/boards.php', $LANG_GF93['forumedited']); echo COM_endBlock(); echo COM_siteFooter(); exit; } elseif ($mode == $LANG_GF01['RESYNC']) { gf_resyncforum($id); } elseif ($mode == $LANG_GF01['EDIT']) { $sql = "SELECT forum_name,forum_cat,forum_dscp,grp_id,use_attachment_grpid,forum_order,is_hidden,is_readonly,no_newposts "; $sql .= "FROM {$_TABLES['gf_forums']} WHERE (forum_id='{$id}')"; $resForum = DB_query($sql); list($forum_name, $forum_category, $forum_dscp, $privgroup, $attachgroup, $forum_order, $is_hidden, $is_readonly, $no_newposts) = DB_fetchArray($resForum); $resGroups = DB_query("SELECT DISTINCT grp_id,grp_name FROM {$_TABLES['groups']}"); $nrows = DB_numRows($resGroups); $grouplist = ''; $attachgrouplist = ''; while (list($grp, $name) = DB_fetchARRAY($resGroups)) { if ($grp == $privgroup) { $grouplist .= '<option value="' . $grp . '" Selected >' . $name . '</option>'; } else { $grouplist .= '<option value="' . $grp . '">' . $name . '</option>'; }