$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>';
}
