y.html">Blueberry
  • Vanilla
  • Cherry
  • How To
  • F.A.Q
  • Shop
  • About
  • Contact
  • Wholesale

    • Tsunami Tobacco Medium Nicotine

    Tsunami Tobacco Medium Nicotine lightens up a bit with an extremely smooth, odorless smoking experience. The water vapor inhaled mimics the taste of a conventional light cigarette, minus the smell! A light flow of vapor provides the user with a pleasant taste accompanied by a satisfying 11mg of nicotine. Revolutionary in taste, size and dependability Tsunami medium is a top pick among light smokers!

    ame forum it's already in but allow copying to the same forum if ($destforuminfo['forumid'] == $threadinfo['forumid'] AND $vbulletin->GPC['redirect']) { eval(standard_error(fetch_error('movesameforum'))); } ($hook = vBulletinHook::fetch_hook('threadmanage_move_start')) ? eval($hook) : false; if ($vbulletin->GPC['title'] != '' AND $vbulletin->GPC['title'] != $threadinfo['title']) { $oldtitle = $threadinfo['title']; $threadinfo['title'] = unhtmlspecialchars($vbulletin->GPC['title']); $updatetitle = true; } else { $oldtitle = $threadinfo['title']; $updatetitle = false; } if (!$vbulletin->GPC['redirect']) { $method = 'copy'; } else if ($vbulletin->GPC['redirect'] == 'none') { rget="_blank" href="http://www.shareasale.com/r.cfm?b=72081&u=231516&m=11683&urllink=&afftrack=">My Yoga Online

    Blessed Easter...Marking the Season of Rebirth and Renewal :
    3-21-2008

    In every culture and spiritual tradition, you can find a symbol and time of Rebirth and Renewal. Easter is such a time and is commonly celebrated on the first Sunday following the Full Moon which marks the Vernal Equinox. Springtime and Easter represents the Season of Renewal with eggs, rabbits, the colors of spring flowers, and certain foods which herald our Rebirth. You can give this wondrous gift to yourself!

    Center for the Healing Arts

    Easter Chocolate Truffles...Healthy Goodies for Adults :
    3-21-2008

    My Easter Eggs on Sunday. As adults, it's always nice to have some healthy Goodies that are just for us on any Holiday. Easter Chocolate Truffles are perfect this year. They are the shape of things to come!

    Organic Bouquet

    Seattle Bans Bottled Water...and Goes Back to the Tap :
    3-20-2008

    San Francisco first started the movement away from plastic bottles which add to landfill problems and release toxic chemicals into the water over time. Then Chicago began to tax Bottled Water. Today, Seattle issued a statement saying that the city will not purchase Bottled Water for events and sent the citizens back to the Tap. Seattle's water supply comes from a healthy source, but most other cities have unreliable source water. The natural alternative is to get your own Distiller and use glass bottles. But if you cannot do this; then here are some choices that will be shipped to you as the healthiest possible Bottled Water you can find on the market. Our Daily Tip is to put your purified water in specialty designer dispensing units which will keep your Water in excellent condition and decorate your living environment!

    Aqua Verve

    Water.com

    A Healthy Easter Deserves Free Range Eggs and Natural Dyes :
    3-19-2008

    Don't get lazy when it comes to making healthy Easter Eggs for your Easter Egg Hunt and subsequent egg feast! Buy eggs from a farm that allows their chickens to roam free. Purchase natural dyes to color your eggs with, so you don't poison the kids or yourself with the artificial dyes that are commonly used at this time of year. Go and have fun with healthy Easter Eggs!

    Local Harvest

    One Green Day is Never Enough! Go Green for Good :
    3-18-2008

    St. Patrick's Day may have allowed more people to try Green on for size. Now that ecttitle'])); } } require_once(DIR . '/includes/functions_prefix.php'); if (can_use_prefix($vbulletin->GPC['redirectprefixid'])) { $redir->set('prefixid', $vbulletin->GPC['redirectprefixid']); } ($hook = vBulletinHook::fetch_hook('threadmanage_move_redirect_notice')) ? eval($hook) : false; if ($redirthreadid = $redir->save() AND $vbulletin->GPC['redirect'] == 'expires') { switch($vbulletin->GPC['frame']) { case 'h': $expires = mktime(date('H') + $vbulletin->GPC['period'], date('i'), date('s'), date('m'), date('d'), date('y')); break; case 'd': $expires = mktime(date('H'), date('i'), date('s'), date('m'), date('d') + $vbulletin->GPC['period'], date('y')); break; case 'w': $expires = $vbulletin->GPC['period'] * 60 * 60 * 24 * 7 + TIMENOW; break; case 'y': $expires = mktime(date('H'), date('i'), date('s'), date('m'), date('d'), date('y') + $vbulletin->GPC['period']); break; case 'm': default: $expires = mktime(date('H'), date('i'), date('s'), date('m') + $vbulletin->GPC['period'], date('d'), date('y')); } $db->query_write(" REPLACE INTO " . TABLE_PREFIX . "threadredirect (threadid, expires) VALUES ($redirthreadid, $expires) "); } unset($redir); } else { // leave no redirect for hidden or deleted threads log_moderator_action($threadinfo, 'thread_moved_to_x', $destforuminfo['title']); } break; // *************************************************************** // *************************************************************** // make a copy of the thread in the redirect forum case 'copy': log_moderator_action($threadinfo, 'thread_copied_to_x', $destforuminfo['title']); if ($threadinfo['pollid'] AND $threadinfo['open'] != 10) { // We have a poll, need to duplicate it! if ($pollinfo = $db->query_first_slave("SELECT * FROM " . TABLE_PREFIX . "poll WHERE pollid = $threadinfo[pollid]")) { $poll =& datamanager_init('Poll', $vbulletin, ERRTYPE_STANDARD); $poll->set('question', $pollinfo['question']); $poll->set('dateline', $pollinfo['dateline']); foreach (explode('|||', $pollinfo['options']) AS $option) { $option = rtrim($option); $poll->set_option($option); } $poll->set('active', $pollinfo['active']); $poll->set('timeout', $pollinfo['timeout']); $poll->set('multiple', $pollinfo['multiple']); $poll->set('public', $pollinfo['public']); if ($pollinfo['multiple']) { $poll->set('voters', $pollinfo['voters']); } $oldpollid = $threadinfo['pollid']; $threadinfo['pollid'] = $poll->save(); $pollvotes = $db->query_read_slave(" SELECT * FROM " . TABLE_PREFIX . "pollvote WHERE pollid = $oldpollid "); while ($pollvote = $db->fetch_array($pollvotes)) { $new_pollvote =& datamanager_init('PollVote', $vbulletin, ERRTYPE_STANDARD); if ($pollinfo['multiple']) { $new_pollvote->set_info('skip_voters', true); } $new_pollvote->set('pollid', $threadinfo['pollid']); $new_pollvote->set('votedate', $pollvote['votedate']); $new_pollvote->set('voteoption', $pollvote['voteoption']); $new_pollvote->set('votetype', $pollvote['votetype']); if (!$pollvote['userid']) { $new_pollvote->set('userid', NULL, false); } else { $new_pollvote->set('userid', $pollvote['userid']); } $new_pollvote->save(); } } } // duplicate thread, save a few columns $newthreadinfo = $threadinfo; $delinfo = array( 'userid' => $threadinfo['del_userid'], 'username' => $threadinfo['del_username'], 'reason' => $threadinfo['del_reason'], 'dateline' => $threadinfo['del_dateline'], ); unset($newthreadinfo['vote'], $newthreadinfo['threadid'], $newthreadinfo['votenum'], $newthreadinfo['votetotal'], $newthreadinfo['isdeleted'], $newthreadinfo['del_userid'], $newthreadinfo['del_username'], $newthreadinfo['del_reason'], $newthreadinfo['issubscribed'], $newthreadinfo['emailupdate'], $newthreadinfo['folderid']); $newthreadinfo['forumid'] = $destforuminfo['forumid']; // If mod can not manage threads in destination forum then unstick thread if (!can_moderate($destforuminfo['forumid'], 'canmanagethreads')) { unset($newthreadinfo['sticky']); } $threadcopy =& datamanager_init('Thread', $vbulletin, ERRTYPE_ARRAY, 'threadpost'); foreach (array_keys($threadcopy->validfields) AS $field) { if (isset($newthreadinfo["$field"])) { // bypassing the verify_* calls; this data should be valid as is $threadcopy->setr($field, $newthreadinfo["$field"], true, false); } } if ($updatetitle AND $vbulletin->options['similarthreadsearch']) { require_once(DIR . '/includes/functions_search.php'); $threadcopy->set('similar', fetch_similar_threads(fetch_censored_text($vbulletin->GPC['title']), $threadinfo['threadid'])); } ($hook = vBulletinHook::fetch_hook('threadmanage_move_copy_threadcopy')) ? eval($hook) : false; $newthreadid = $threadcopy->save(); $newthreadinfo['threadid'] = $newthreadid; $posts = $db->query_write(" INSERT IGNORE INTO " . TABLE_PREFIX . "tagthread (threadid, tagid, userid, dateline) SELECT $newthreadid, tagid, userid, dateline FROM " . TABLE_PREFIX . "tagthread WHERE threadid = $threadid "); unset($threadcopy); require_once(DIR . '/includes/functions_file.php'); // duplicate posts $posts = $db->query_read_slave(" SELECT post.*, deletionlog.userid AS deleteduserid, deletionlog.username AS deletedusername, deletionlog.reason AS deletedreason, NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.dateline AS deleteddateline, moderation.dateline AS moderateddateine FROM " . TABLE_PREFIX . "post AS post LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON (deletionlog.primaryid = post.postid AND deletionlog.type = 'post') LEFT JOIN " . TABLE_PREFIX . "moderation AS moderation ON (moderation.primaryid = post.postid AND moderation.type = 'reply') WHERE post.threadid = $threadid ORDER BY dateline "); $done_firstpost = false; $userbyuserid = array(); $postarray = array(); $postassoc = array(); $deleteinfo = array(); $hiddeninfo = array(); while ($post = $db->fetch_array($posts)) { if ($post['title'] == $oldtitle AND $updatetitle) { $post['title'] = $threadinfo['title']; $update_post_title = true; } else { $update_post_title = false; } $oldpostid = $post['postid']; unset($post['postid']); unset($post['infraction']); $post['threadid'] = $newthreadid; $postcopy =& datamanager_init('Post', $vbulletin, ERRTYPE_ARRAY, 'threadpost'); $postcopy->set_info('is_automated', true); foreach (array_keys($postcopy->validfields) AS $field) { if (isset($post["$field"])) { // bypassing the verify_* calls; this data should be valid as is $postcopy->setr($field, $post["$field"], true, false); } } ($hook = vBulletinHook::fetch_hook('threadmanage_move_copy_postcopy')) ? eval($hook) : false; $newpostid = $postcopy->save(); $errors = $postcopy->errors; unset($postcopy); if (!$done_firstpost) { if (!$threadinfo['visible']) { // Insert Moderation Record $db->query_write(" INSERT INTO " . TABLE_PREFIX . "moderation (primaryid, type, dateline) VALUES ($newthreadid, 'thread', " . (!empty($post['moderateddateline']) ? $post['moderateddateline'] : TIMENOW) . ") "); } else if ($threadinfo['visible'] == 2) { $deletionman =& datamanager_init('Deletionlog_ThreadPost', $vbulletin, ERRTYPE_SILENT, 'deletionlog'); $deletionman->set('primaryid', $newthreadinfo['threadid']); $deletionman->set('type', 'thread'); $deletionman->set('userid', $delinfo['userid']); $deletionman->set('username', $delinfo['username']); $deletionman->set('dateline', $delinfo['dateline']); // bypassing the verify_* calls; this data should be valid as is $deletionman->setr('reason', $delinfo['reason'], true, false); $deletionman->save(); unset($deletionman); } $threadman =& datamanager_init('Thread', $vbulletin, ERRTYPE_ARRAY, 'threadpost'); $threadman->set_existing($newthreadinfo); $threadman->set('firstpostid', $newpostid); $threadman->save(); unset($threadman); $done_firstpost = true; } if (!$newpostid) { // the saving of the post failed, skip it continue; } if (!$post['visible']) { $hiddeninfo[] = "($newpostid, 'post', " . (!empty($post['moderateddateline']) ? $post['moderateddateline'] : TIMENOW) . ")"; } else if ($post['visible'] == 2) { $deleteinfo[] = "($newpostid, 'post', " . intval($post['deleteduserid']) . ", '" . $db->escape_string($post['deletedusername']) . "', '". $db->escape_string($post['deletedreason']) . "', $post[deleteddateline])"; } $parentcasesql .= " WHEN parentid = $oldpostid THEN $newpostid"; $parentids .= ",$oldpostid"; // doubles as a list of original post IDs $postassoc["$oldpostid"] = $newpostid; // same as $postarray, but set in all cases; for attachments // Source forum doesn't indexposts so we must generate these new words if (!$foruminfo['indexposts'] AND $destforuminfo['indexposts']) { build_post_index($newpostid, $destforuminfo); } else if ($foruminfo['indexposts'] AND $destforuminfo['indexposts']) { if ($update_post_title == true) { // we have a new title for this post, so it needs to be reindexed build_post_index($newpostid, $destforuminfo); } else { // Source forum indexes posts so we can duplicate the words we already have $postarray["$oldpostid"] = $newpostid; } } build_thread_counters($newthreadinfo['threadid']); if ($destforuminfo['countposts'] AND $post['userid'] AND $threadinfo['visible'] == 1 AND $post['visible'] == 1) { if (!isset($userbyuserid["$post[userid]"])) { $userbyuserid["$post[userid]"] = 1; } else { $userbyuserid["$post[userid]"]++; } } } $find_attach = array(); $replace_attach = array(); // need to read filedata in chunks and update in chunks! $attachments = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "attachment WHERE postid IN (-1$parentids) ORDER BY attachmentid"); while ($attachment = $db->fetch_array($attachments)) { $attachdata =& datamanager_init('Attachment', $vbulletin, ERRTYPE_SILENT); $attachdata->setr('userid', $attachment['userid']); $attachdata->setr('dateline', $attachment['dateline']); $attachdata->setr('thumbnail_dateline', $attachment['thumbnail_dateline']); $attachdata->setr('filename', $attachment['filename']); $attachdata->setr('postid', $postassoc["$attachment[postid]"]); $attachdata->setr('visible', $attachment['visible']); if ($vbulletin->options['attachfile']) { $attachdata->set('filedata', @file_get_contents(fetch_attachment_path($attachment['userid'], $attachment['attachmentid']))); $attachdata->set('thumbnail', @file_get_contents(fetch_attachment_path($attachment['userid'], $attachment['attachmentid'], true))); } else { $attachdata->setr('filedata', $attachment['filedata']); $attachdata->setr('thumbnail', $attachment['thumbnail']); } $newattachmentid = $attachdata->save(); unset($attachdata); $find_attach[$postassoc["$attachment[postid]"]][] = '#\[attach\]' . $attachment['attachmentid']. '\[/attach\]#si'; $replace_attach[$postassoc["$attachment[postid]"]][] = '[attach]' . $newattachmentid . '[/attach]'; } // update [attach]ABC[/attach] Entries if (!empty($find_attach)) { $posts = $db->query_read_slave(" SELECT post.pagetext, post.postid FROM " . TABLE_PREFIX . "post AS post WHERE post.postid IN (" . implode(', ', array_keys($find_attach)) . ") "); while ($post = $db->fetch_array($posts)) { $pagetext = preg_replace($find_attach["$post[postid]"], $replace_attach["$post[postid]"], $post['pagetext']); $postcopy =& datamanager_init('Post', $vbulletin, ERRTYPE_SILENT, 'threadpost'); $postcopy->set_existing($post); $postcopy->set_info('is_automated', true); // bypassing the verify_* calls; this data should be valid as is $postcopy->setr('pagetext', $pagetext, true, false); $postcopy->save(); } } // Duplicate word entries in the postindex if (!empty($postarray) AND $vbulletin->options['copypostindex'] AND !$vbulletin->options['fulltextsearch']) { $db->query_write("CREATE TABLE " . TABLE_PREFIX . "postindex_temp$newthreadid ( wordid INT UNSIGNED NOT NULL DEFAULT '0', postid INT UNSIGNED NOT NULL DEFAULT '0', intitle SMALLINT UNSIGNED NOT NULL DEFAULT '0', score SMALLINT UNSIGNED NOT NULL DEFAULT '0' )"); // indexes left off intentionally $postcase = ''; foreach ($postarray AS $oldid => $newid) { $postcase .= "WHEN $oldid THEN $newid\n"; } /*insert query*/ $db->query_write(" INSERT INTO " . TABLE_PREFIX . "postindex_temp$newthreadid (wordid, postid, intitle, score) SELECT wordid, CASE postid $postcase ELSE postid END AS postid, intitle, score FROM " . TABLE_PREFIX . "postindex AS postindex WHERE postid IN (" . implode(',', array_keys($postarray)) . ") "); /*insert query*/ $db->query_write(" INSERT INTO " . TABLE_PREFIX . "postindex (wordid, postid, intitle, score) SELECT wordid, postid, intitle, score FROM " . TABLE_PREFIX . "postindex_temp$newthreadid "); $db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "postindex_temp$newthreadid"); } // Insert Moderated Posts if (!empty($hiddeninfo)) { /*insert query*/ $db->query_write(" INSERT INTO " . TABLE_PREFIX . "moderation (primaryid, type, dateline) VALUES " . implode(', ', $hiddeninfo) . " "); } // Insert Deleted Posts if (!empty($deleteinfo)) { /*insert query*/ $db->query_write(" INSERT INTO " . TABLE_PREFIX . "deletionlog (primaryid, type, userid, username, reason, dateline) VALUES " . implode(', ', $deleteinfo) . " "); } // reconnect parent/child posts in the new thread if ($parentcasesql) { $db->query_write(" UPDATE " . TABLE_PREFIX . "post SET parentid = CASE $parentcasesql ELSE parentid END WHERE threadid = $newthreadid AND parentid IN (0$parentids) "); } // Update User Post Counts if (!empty($userbyuserid)) { $userbypostcount = array(); foreach ($userbyuserid AS $postuserid => $postcount) { $alluserids .= ",$postuserid"; $userbypostcount["$postcount"] .= ",$postuserid"; } foreach ($userbypostcount AS $postcount => $userids) { $postcasesql .= " WHEN userid IN (0$userids) THEN $postcount"; } $db->query_write(" UPDATE " . TABLE_PREFIX . "user SET posts = posts + CASE $postcasesql ELSE 0 END WHERE userid IN (0$alluserids) "); } break; // *************************************************************** } // end switch($method) // kill the cache for the old thread delete_post_cache_threads(array($threadinfo['threadid'])); // Update Post Count if we move from a counting forum to a non counting or vice-versa.. // Source Dest Visible Thread Hidden Thread // Yes Yes ~ ~ // Yes No -visible ~ // No Yes +visible ~ // No No ~ ~ if ($threadinfo['visible'] AND ($method == 'move' OR $method == 'movered') AND (($foruminfo['countposts'] AND !$destforuminfo['countposts']) OR (!$foruminfo['countposts'] AND $destforuminfo['countposts']))) { $posts = $db->query_read_slave(" SELECT userid FROM " . TABLE_PREFIX . "post WHERE threadid = $threadinfo[threadid] AND userid > 0 AND visible = 1 "); $userbyuserid = array(); while ($post = $db->fetch_array($posts)) { if (!isset($userbyuserid["$post[userid]"])) { $userbyuserid["$post[userid]"] = 1; } else { $userbyuserid["$post[userid]"]++; } } if (!empty($userbyuserid)) { $userbypostcount = array(); foreach ($userbyuserid AS $postuserid => $postcount) { $alluserids .= ",$postuserid"; $userbypostcount["$postcount"] .= ",$postuserid"; } foreach ($userbypostcount AS $postcount => $userids) { $casesql .= " WHEN userid IN (0$userids) THEN $postcount"; } $operator = ($destforuminfo['countposts'] ? '+' : '-'); $db->query_write(" UPDATE " . TABLE_PREFIX . "user SET posts = CAST(posts AS SIGNED) $operator CASE $casesql ELSE 0 END WHERE userid IN (0$alluserids) "); } } if ($updatetitle) { // Reindex first post to set up title properly. $getfirstpost = $db->query_first_slave(" SELECT postid, title, pagetext FROM " . TABLE_PREFIX . "post WHERE threadid = $threadid ORDER BY dateline, postid LIMIT 1 "); delete_post_index($getfirstpost['postid'], $getfirstpost['title'], $getfirstpost['pagetext']); build_post_index($getfirstpost['postid'] , $foruminfo); } build_forum_counters($threadinfo['forumid']); if ($threadinfo['forumid'] != $destforuminfo['forumid']) { build_forum_counters($destforuminfo['forumid']); } // Update canview status of thread subscriptions update_subscriptions(array('threadids' => array($threadid))); if ($method == 'copy' AND $newthreadid) { $threadid = $newthreadid; } ($hook = vBulletinHook::fetch_hook('threadmanage_move_complete')) ? eval($hook) : false; $vbulletin->url = 'showthread.php?' . $vbulletin->session->vars['sessionurl'] . "t=$threadid"; eval(print_standard_redirect('redirect_movethread')); } // ############################### start manage post ############################### if ($_REQUEST['do'] == 'managepost') { $templatename = 'threadadmin_managepost'; if ($postinfo['postid'] == $threadinfo['firstpostid']) { // first post // redirect to edit thread $_REQUEST['do'] = 'editthread'; } else { if (!can_moderate($threadinfo['forumid'], 'candeleteposts')) { print_no_permission(); } verify_forum_password($foruminfo['forumid'], $foruminfo['password']); $show['undeleteoption'] = iif($postinfo['isdeleted'] AND (can_moderate($threadinfo['forumid'], 'canremoveposts') OR can_moderate($threadinfo['forumid'], 'candeleteposts')), true, false); if (!$show['undeleteoption']) { standard_error(fetch_error('invalidid', $vbphrase['post'], $vbulletin->options['contactuslink'])); } require_once(DIR . '/includes/class_bbcode.php'); $bbcode_parser = new vB_BbCodeParser($vbulletin, fetch_tag_list()); $postinfo['pagetext'] = $bbcode_parser->parse($postinfo['pagetext'], $forumid); $postinfo['postdate'] = vbdate($vbulletin->options['dateformat'], $postinfo['dateline'], 1); $postinfo['posttime'] = vbdate($vbulletin->options['timeformat'], $postinfo['dateline']); $visiblechecked = iif($postinfo['visible'], 'checked="checked"'); // draw nav bar $navbits = construct_postings_nav($foruminfo, $threadinfo); } } // ############################### start edit thread ############################### if ($_REQUEST['do'] == 'editthread') { $templatename = 'threadadmin_editthread'; // only mods with the correct permissions should be able to access this if (!can_moderate($threadinfo['forumid'], 'caneditthreads') OR ($threadinfo['isdeleted'] AND !can_moderate($threadinfo['forumid'], 'candeleteposts') AND !can_moderate($threadinfo['forumid'], 'canremoveposts')) OR (!$threadinfo['visible'] AND !can_moderate($threadinfo['forumid'], 'canmoderateposts'))) { print_no_permission(); } // check if there is a forum password and if so, ensure the user has it set verify_forum_password($foruminfo['forumid'], $foruminfo['password']); $show['undeleteoption'] = ($threadinfo['visible'] == 2 AND can_moderate($threadinfo['forumid'], 'candeleteposts')) ? true : false; $show['removeoption'] = ($threadinfo['visible'] == 2 AND can_moderate($threadinfo['forumid'], 'canremoveposts')) ? true : false; $show['moderateoption'] = (can_moderate($threadinfo['forumid'], 'canmoderateposts') AND $threadinfo['visible'] != 2) ? true : false; // draw nav bar $navbits = construct_postings_nav($foruminfo, $threadinfo); $visiblechecked = iif($threadinfo['visible'], 'checked="checked"'); $visiblehidden = iif($threadinfo['visible'], 'yes'); $openchecked = iif($threadinfo['open'], 'checked="checked"'); $stickychecked = iif($threadinfo['sticky'], 'checked="checked"'); require_once(DIR . '/includes/functions_newpost.php'); $posticons = construct_icons($threadinfo['iconid'], $foruminfo['allowicons']); require_once(DIR . '/includes/functions_prefix.php'); $prefix_options = fetch_prefix_html($foruminfo['forumid'], $threadinfo['prefixid'], true); $show['ipaddress'] = can_moderate($threadinfo['forumid'], 'canviewips') ? true : false; $logs = $db->query_read_slave(" SELECT moderatorlog.dateline, moderatorlog.userid, moderatorlog.action, moderatorlog.type, moderatorlog.postid, moderatorlog.ipaddress, user.username, post.title FROM " . TABLE_PREFIX . "moderatorlog AS moderatorlog LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = moderatorlog.userid) LEFT JOIN " . TABLE_PREFIX . "post AS post ON (moderatorlog.postid = post.postid) WHERE moderatorlog.threadid = $threadid ORDER BY dateline "); while ($log = $db->fetch_array($logs)) { exec_switch_bg(); if ($log['type']) { $phrase = fetch_modlogactions($log['type']); if ($unserialized = unserialize($log['action'])) { array_unshift($unserialized, $vbphrase["$phrase"]); $log['action'] = call_user_func_array('construct_phrase', $unserialized); } else { $log['action'] = construct_phrase($vbphrase["$phrase"], $log['action']); } } if ($log['title'] == '') { $log['title'] = $vbphrase['n_a']; } $log['dateline'] = vbdate($vbulletin->options['logdateformat'], $log['dateline']); $log['ipaddress'] = htmlspecialchars_uni($log['ipaddress']); // Sanity ;0 eval('$logbits .= "' . fetch_template('threadadmin_logbit') . '";'); } $show['modlog'] = iif($logbits, true, false); if ($threadinfo['open'] == 10) // Thread redirect { $posticons = ''; $show['undeleteoptions'] = $show['options'] = false; if ($redirect = $db->query_first_slave("SELECT expires FROM " . TABLE_PREFIX . "threadredirect WHERE threadid = $threadinfo[threadid]")) { $show['expires'] = true; $show['cpermanent'] = true; $threadinfo['expiredate'] = vbdate($vbulletin->options['dateformat'], $redirect['expires']); $threadinfo['expiretime'] = vbdate($vbulletin->options['timeformat'], $redirect['expires']); } else { $show['cexpires'] = true; } $show['redirect'] = true; } else { $show['options'] = true; } } // ############################### start update thread ############################### if ($_POST['do'] == 'updatethread') { $vbulletin->input->clean_array_gpc('p', array( 'visible' => TYPE_BOOL, 'open' => TYPE_BOOL, 'sticky' => TYPE_BOOL, 'iconid' => TYPE_UINT, 'notes' => TYPE_NOHTML, 'threadstatus' => TYPE_UINT, 'reason' => TYPE_NOHTML, 'title' => TYPE_STR, 'prefixid' => TYPE_NOHTML, 'redirect' => TYPE_STR, 'frame' => TYPE_STR, 'period' => TYPE_UINT, 'keepattachments' => TYPE_BOOL )); // only mods with the correct permissions should be able to access this if (!can_moderate($threadinfo['forumid'], 'caneditthreads')) { print_no_permission(); } // check if there is a forum password and if so, ensure the user has it set verify_forum_password($foruminfo['forumid'], $foruminfo['password']); if ($vbulletin->GPC['title'] == '') { eval(standard_error(fetch_error('notitle'))); } if (!can_moderate($threadinfo['forumid'], 'canopenclose') AND !$forumperms['canopenclose']) { $vbulletin->GPC['open'] = $threadinfo['open']; } if (!can_moderate($threadinfo['forumid'], 'canmanagethreads')) { $vbulletin->GPC['sticky'] = $threadinfo['sticky']; } if ($threadinfo['visible'] == 2) { // Editing a deleted thread if ($vbulletin->GPC['threadstatus'] == 1 AND can_moderate($threadinfo['forumid'], 'candeleteposts')) { // undelete undelete_thread($threadinfo['threadid'], $foruminfo['countposts']); $threaddeleted = -1; } else if ($vbulletin->GPC['threadstatus'] == 2 AND can_moderate($threadinfo['forumid'], 'canremoveposts')) { // remove $threadman =& datamanager_init('Thread', $vbulletin, ERRTYPE_STANDARD, 'threadpost'); $threadman->set_existing($threadinfo); $threadman->delete($foruminfo['countposts'], true); unset($threadman); $threaddeleted = 1; } else { if ($vbulletin->GPC['reason'] != '') { $deletionman =& datamanager_init('Deletionlog_Threadpost', $vbulletin, ERRTYPE_STANDARD, 'deletionlog'); $deletioninfo = array('type' => 'thread', 'primaryid' => $threadinfo['threadid']); $deletionman->set_existing($deletioninfo); $deletionman->set('reason', $vbulletin->GPC['reason']); $deletionman->save(); unset($deletionman, $deletioninfo); } $threaddeleted = 0; } if ($threaddeleted != 1 AND !$vbulletin->GPC['keepattachments']) { // want to remove attachments $postids = ''; $posts = $db->query_read(" SELECT post.postid FROM " . TABLE_PREFIX . "post AS post WHERE post.threadid = $threadinfo[threadid] "); while ($post = $db->fetch_array($posts)) { $postids .= "$post[postid],"; } $attachdata =& datamanager_init('Attachment', $vbulletin, ERRTYPE_SILENT); $attachdata->condition = "attachment.postid IN ($postids" . "0)"; $attachdata->delete(); } } else { // Editing a non deleted thread if (can_moderate($threadinfo['forumid'], 'canmoderateposts') AND $threadinfo['open'] != 10) { if ($threadinfo['visible'] == 1 AND !$vbulletin->GPC['visible']) { unapprove_thread($threadid, $foruminfo['countposts'], true, $threadinfo); } else if (!$threadinfo['visible'] AND $vbulletin->GPC['visible']) { approve_thread($threadid, $foruminfo['countposts'], true, $threadinfo); } } $threaddeleted = 0; } if ($threaddeleted != 1) { $threadman =& datamanager_init('Thread', $vbulletin, ERRTYPE_STANDARD, 'threadpost'); $threadman->set_existing($threadinfo); if ($threadinfo['open'] != 10) { // Reindex first post to set up title properly. $getfirstpost = $db->query_first_slave(" SELECT * FROM " . TABLE_PREFIX . "post WHERE threadid = $threadinfo[threadid] ORDER BY dateline, postid LIMIT 1 "); $getfirstpost['threadtitle'] =& $vbulletin->GPC['title']; delete_post_index($getfirstpost['postid'], $getfirstpost['title'], $getfirstpost['pagetext']); build_post_index($getfirstpost['postid'] , $foruminfo, 1, $getfirstpost); $threadman->set_info('skip_moderator_log', true); $threadman->set('open', $vbulletin->GPC['open']); $threadman->set('sticky', $vbulletin->GPC['sticky']); $threadman->set('iconid', $vbulletin->GPC['iconid'], true, false); if ($vbulletin->options['similarthreadsearch']) { require_once(DIR . '/includes/functions_search.php'); $threadman->set('similar', fetch_similar_threads($vbulletin->GPC['title'], $threadinfo['threadid'])); } } $threadman->set('notes', $vbulletin->GPC['notes']); // re-enable mod logging for the title since we don't include it in the other log info $threadman->set_info('skip_moderator_log', false); $threadman->set('title', $vbulletin->GPC['title']); require_once(DIR . '/includes/functions_prefix.php'); if (can_use_prefix($vbulletin->GPC['prefixid'])) { $threadman->set('prefixid', $vbulletin->GPC['prefixid']); } ($hook = vBulletinHook::fetch_hook('threadmanage_update')) ? eval($hook) : false; $threadman->save(); } build_forum_counters($threadinfo['forumid']); if ($threadinfo['open'] == 10) { if ($vbulletin->GPC['redirect'] == 'perm') { $db->query_write("DELETE FROM " . TABLE_PREFIX . "threadredirect WHERE threadid = $threadinfo[threadid]"); } else if ($vbulletin->GPC['redirect'] == 'expires') { switch($vbulletin->GPC['frame']) { case 'h': $expires = mktime(date('H') + $vbulletin->GPC['period'], date('i'), date('s'), date('m'), date('d'), date('y')); break; case 'd': $expires = mktime(date('H'), date('i'), date('s'), date('m'), date('d') + $vbulletin->GPC['period'], date('y')); break; case 'w': $expires = $vbulletin->GPC['period'] * 60 * 60 * 24 * 7 + TIMENOW; break; case 'y': $expires = mktime(date('H'), date('i'), date('s'), date('m'), date('d'), date('y') + $vbulletin->GPC['period']); break; case 'm': default: $expires = mktime(date('H'), date('i'), date('s'), date('m') + $vbulletin->GPC['period'], date('d'), date('y')); } $db->query_write(" REPLACE INTO " . TABLE_PREFIX . "threadredirect (threadid, expires) VALUES ($threadinfo[threadid], $expires) "); } log_moderator_action($threadinfo, 'thread_edited_visible_x_open_y_sticky_z', array($threadinfo['visible'], intval((bool)$threadinfo['open']), $threadinfo['sticky'])); } else { log_moderator_action($threadinfo, 'thread_edited_visible_x_open_y_sticky_z', array($vbulletin->GPC['visible'], $vbulletin->GPC['open'], $vbulletin->GPC['sticky'])); } if ($threadinfo['open'] == 10 OR (!$vbulletin->GPC['visible'] AND !can_moderate($threadinfo['forumid'], 'canmoderateposts')) OR $threaddeleted == 1 OR ($threadinfo['isdeleted'] AND $threaddeleted != -1)) { $vbulletin->url = 'forumdisplay.php?' . $vbulletin->session->vars['sessionurl'] . "f=$threadinfo[forumid]"; } else { $vbulletin->url = 'showthread.php?' . $vbulletin->session->vars['sessionurl'] . "t=$threadinfo[threadid]"; } eval(print_standard_redirect('redirect_editthread')); } // ############################### start merge threads ############################### if ($_REQUEST['do'] == 'mergethread') { $templatename = 'threadadmin_mergethread'; if (($threadinfo['isdeleted'] AND !can_moderate($threadinfo['forumid'], 'candeleteposts')) OR (!$threadinfo['visible'] AND !can_moderate($threadinfo['forumid'], 'canmoderateposts'))) { if (can_moderate($threadinfo['forumid'])) { print_no_permission(); } else { eval(standard_error(fetch_error('invalidid', $idname, $vbulletin->options['contactuslink']))); } } // check forum permissions for this forum if (!can_moderate($threadinfo['forumid'], 'canmanagethreads')) { print_no_permission(); } // draw nav bar $navbits = construct_postings_nav($foruminfo, $threadinfo); } // ############################### start do merge threads ############################### if ($_POST['do'] == 'domergethread') { $vbulletin->input->clean_array_gpc('p', array( 'mergethreadurl' => TYPE_STR, 'title' => TYPE_STR, 'redirect' => TYPE_STR, 'period' => TYPE_UINT, 'frame' => TYPE_STR, )); if (($threadinfo['isdeleted'] AND !can_moderate($threadinfo['forumid'], 'candeleteposts')) OR (!$threadinfo['visible'] AND !can_moderate($threadinfo['forumid'], 'canmoderateposts'))) { if (can_moderate($threadinfo['forumid'])) { print_no_permission(); } else { eval(standard_error(fetch_error('invalidid', $idname, $vbulletin->options['contactuslink']))); } } // check forum permissions for this forum if (!can_moderate($threadinfo['forumid'], 'canmanagethreads')) { print_no_permission(); } // relative URLs will do bad things here, so don't let them through; thanks Paul! :) if (stristr($vbulletin->GPC['mergethreadurl'], 'goto=next')) { eval(standard_error(fetch_error('mergebadurl'))); } // eliminate everything but the query string if (($strpos = strpos($vbulletin->GPC['mergethreadurl'], '?')) !== false) { $vbulletin->GPC['mergethreadurl'] = substr($vbulletin->GPC['mergethreadurl'], $strpos); } else { eval(standard_error(fetch_error('mergebadurl'))); } // pull out the thread/postid if (preg_match('#[\?&](threadid|t)=([0-9]+)#', $vbulletin->GPC['mergethreadurl'], $matches)) { $mergethreadid = intval($matches[2]); } else if (preg_match('#[\?&](postid|p)=([0-9]+)#', $vbulletin->GPC['mergethreadurl'], $matches)) { $mergepostid = verify_id('post', $matches[2], 0); if ($mergepostid == 0) { // do invalid url eval(standard_error(fetch_error('mergebadurl'))); } $postinfo = fetch_postinfo($mergepostid); $mergethreadid = $postinfo['threadid']; } else { eval(standard_error(fetch_error('mergebadurl'))); } $mergethreadid = verify_id('thread', $mergethreadid); $mergethreadinfo = fetch_threadinfo($mergethreadid); $mergeforuminfo = fetch_foruminfo($mergethreadinfo['forumid']); if ($mergethreadinfo['open'] == 10 OR $mergethreadid == $threadid) { if (can_moderate($mergethreadinfo['forumid'])) { eval(standard_error(fetch_error('mergebadurl'))); } else { eval(standard_error(fetch_error('invalidid', $idname, $vbulletin->options['contactuslink']))); } } if (($mergethreadinfo['isdeleted'] AND !can_moderate($mergethreadinfo['forumid'], 'candeleteposts')) OR (!$mergethreadinfo['visible'] AND !can_moderate($mergethreadinfo['forumid'], 'canmoderateposts'))) { if (can_moderate($mergethreadinfo['forumid'])) { print_no_permission(); } else { eval(standard_error(fetch_error('invalidid', $idname, $vbulletin->options['contactuslink']))); } } // check forum permissions for the merge forum $mergeforumperms = fetch_permissions($mergethreadinfo['forumid']); if ( (($mergethreadinfo['postuserid'] != $vbulletin->userinfo['userid']) AND !($mergeforumperms & $vbulletin->bf_ugp_forumpermissions['canviewothers'])) OR !($mergeforumperms & $vbulletin->bf_ugp_forumpermissions['canview']) OR !($mergeforumperms & $vbulletin->bf_ugp_forumpermissions['canviewthreads']) ) { print_no_permission(); } // check if there is a forum password and if so, ensure the user has it set verify_forum_password($mergeforuminfo['forumid'], $mergeforuminfo['password']); // get the first post from each thread -- we only need to reindex those $thrd_firstpost = $db->query_first_slave(" SELECT * FROM " . TABLE_PREFIX . "post WHERE threadid = $threadinfo[threadid] ORDER BY dateline, postid LIMIT 1 "); $mrgthrd_firstpost = $db->query_first_slave(" SELECT * FROM " . TABLE_PREFIX . "post WHERE threadid = $mergethreadinfo[threadid] ORDER BY dateline, postid LIMIT 1 "); ($hook = vBulletinHook::fetch_hook('threadmanage_merge_start')) ? eval($hook) : false; $threadman =& datamanager_init('Thread', $vbulletin, ERRTYPE_STANDARD, 'threadpost'); $threadman->set_existing($threadinfo); $threadman->set('title', $vbulletin->GPC['title']); $threadman->set('views', $threadinfo['views'] + $mergethreadinfo['views']); // sort out polls if ($mergethreadinfo['pollid'] != 0) { // merge thread has poll ... if ($threadinfo['pollid'] == 0) { // ... and original thread doesn't $threadman->set('pollid', $mergethreadinfo['pollid']); $threadcache["$mergethreadinfo[threadid]"]['pollid'] = 0; } else { // ... and original does // if the poll isn't found anywhere else, delete the merge thread's poll if (!$poll = $db->query_first_slave(" SELECT threadid FROM " . TABLE_PREFIX . "thread WHERE pollid = $mergethreadinfo[pollid] AND threadid <> $mergethreadinfo[threadid] AND open <> 10 ")) { $pollman =& datamanager_init('Poll', $vbulletin, ERRTYPE_STANDARD); $pollman->set_existing($mergethreadinfo); $pollman->delete(); } } } $threadman->save(); // Update Post Count if we merge from a counting forum to a non counting or vice-versa.. hidden thread to a visible thread, moderated to visible (and so on) // Source Dest Visible Thread Hidden Thread // Yes Yes +hidden -visible // Yes No -visible -visible // No Yes +visible,+hidden ~ // No No ~ ~ if (($threadinfo['visible'] AND $foruminfo['countposts'] AND ($mergethreadinfo['visible'] != 1 OR ($mergethreadinfo['visible'] == 1 AND !$mergeforuminfo['countposts']))) OR ($mergethreadinfo['visible'] == 1 AND $mergeforuminfo['countposts'] AND ($threadinfo['visible'] != 1 OR ($threadinfo['visible'] == 1 AND !$foruminfo['countposts'])))) { $posts = $db->query_read(" SELECT userid, threadid FROM " . TABLE_PREFIX . "post WHERE threadid = $mergethreadinfo[threadid] AND visible = 1 AND userid > 0 "); while ($post = $db->fetch_array($posts)) { $set = 0; // Visible thread that merges a visible thread from a non counting forum into a counting forum - Increment post counts belonging to visible threads // visible thread that merges a moderated or deleted thread into a counting forum - increment post counts belonging to a hidden/deleted source thread if ($threadinfo['visible'] AND $foruminfo['countposts'] AND ($mergethreadinfo['visible'] != 1 OR ($mergethreadinfo['visible'] == 1 AND !$mergeforuminfo['countposts']))) { $set = 1; } // hidden thread that merges a visible thread from a counting forum // OR visible thread that merges a visible thread from a counting forum into a non counting forum // decrement post counts belonging to a visible source thread else if ($mergethreadinfo['visible'] == 1 AND $mergeforuminfo['countposts'] AND ($threadinfo['visible'] != 1 OR ($threadinfo['visible'] == 1 AND !$foruminfo['countposts']))) { $set = -1; } if ($set != 0) { if (!isset($userbyuserid["$post[userid]"])) { $userbyuserid["$post[userid]"] = $set; } else if ($set == -1) { $userbyuserid["$post[userid]"]--; } else { $userbyuserid["$post[userid]"]++; } } } if (!empty($userbyuserid)) { $userbypostcount = array(); $alluserids = ''; foreach ($userbyuserid AS $postuserid => $postcount) { $alluserids .= ",$postuserid"; $userbypostcount["$postcount"] .= ",$postuserid"; } foreach($userbypostcount AS $postcount => $userids) { $casesql .= " WHEN userid IN (0$userids) THEN $postcount\n"; } $db->query_write(" UPDATE " . TABLE_PREFIX . "user SET posts = CAST(posts AS SIGNED) + CASE $casesql ELSE 0 END WHERE userid IN (0$alluserids) "); } } // move posts $db->query_write(" UPDATE " . TABLE_PREFIX . "post SET threadid = $threadinfo[threadid] WHERE threadid = $mergethreadinfo[threadid] "); // kill the cache for the dest thread delete_post_cache_threads(array($threadinfo['threadid'])); // update first post relationships if ($thrd_firstpost['dateline'] > $mrgthrd_firstpost['dateline']) { if (!$threadinfo['visible']) { // Update original first post to now be moderated, insert moderation record $db->query_write(" INSERT INTO " . TABLE_PREFIX . "moderation (primaryid, type, dateline) VALUES ($thrd_firstpost[postid], 'reply', " . TIMENOW . ") "); } // thread being merged into is newer, so the merged thread's first post should become this thread's first post $postman =& datamanager_init('Post', $vbulletin, ERRTYPE_ARRAY, 'threadpost'); $postman->set_existing($thrd_firstpost); $postman->set('parentid', $mrgthrd_firstpost['postid']); // Update original first post to now be moderated if (!$threadinfo['visible']) { $postman->set('visible', 0); } $postman->save(); } else { if (!$mergethreadinfo['visible']) { // Change moderation entry for a hidden thread to point to a hidden post $db->query_write(" UPDATE IGNORE " . TABLE_PREFIX . "moderation SET primaryid = $threadinfo[firstpostid], type = 'reply' WHERE primaryid = $mergethreadinfo[threadid] AND type = 'thread' "); } $postman =& datamanager_init('Post', $vbulletin, ERRTYPE_ARRAY, 'threadpost'); $postman->set_existing($mrgthrd_firstpost); $postman->set('parentid', $thrd_firstpost['postid']); // Update merged thread's first post to be hidden since the thread was if (!$mergethreadinfo['visible']) { $postman->set('visible', 0); } $postman->save(); } unset($postman); $users = array(); $ratings = $db->query_read(" SELECT threadrateid, threadid, userid, vote, ipaddress FROM " . TABLE_PREFIX . "threadrate WHERE threadid IN($mergethreadinfo[threadid], $threadinfo[threadid]) "); while ($rating = $db->fetch_array($ratings)) { $id = (!empty($rating['userid'])) ? $rating['userid'] : $rating['ipaddress']; $users["$id"]['vote'] += $rating['vote']; $users["$id"]['total'] += 1; } if (!empty($users)) { $sql = array(); $db->query_write(" DELETE FROM " . TABLE_PREFIX . "threadrate WHERE threadid IN($mergethreadinfo[threadid], $threadinfo[threadid]) "); foreach ($users AS $id => $rating) { if (is_int($id)) { $userid = $id; $ipaddress = ''; } else { $userid = 0; $ipaddress = $id; } $vote = round($rating['vote'] / $rating['total']); $sql[] = "($threadinfo[threadid], $userid, $vote, '" . $db->escape_string($ipaddress) . "')"; } unset($users); if (!empty($sql)) { $db->query_write(" INSERT INTO " . TABLE_PREFIX . "threadrate (threadid, userid, vote, ipaddress) VALUES " . implode(",\n", $sql) ); unset($sql); } } // Update redirects $db->query_write(" UPDATE " . TABLE_PREFIX . "thread SET pollid = $threadinfo[threadid] WHERE open = 10 AND pollid = $mergethreadinfo[threadid] "); // Update subscribed threads $db->query_write(" UPDATE IGNORE " . TABLE_PREFIX . "subscribethread SET threadid = $threadinfo[threadid] WHERE threadid = $mergethreadinfo[threadid] "); // We had multiple subscriptions so remove all but the main one now $db->query_write(" DELETE FROM " . TABLE_PREFIX . "subscribethread WHERE threadid = $mergethreadinfo[threadid] "); // Update Moderation Log entries $db->query_write(" UPDATE " . TABLE_PREFIX . "moderatorlog SET threadid = $threadinfo[threadid] WHERE threadid = $mergethreadinfo[threadid] "); if ($mergethreadinfo['forumid'] != $threadinfo['forumid']) { // update canview status of thread subscriptions update_subscriptions(array('threadids' => array($threadinfo['threadid']))); } if ($vbulletin->GPC['redirect'] == 'expires') { switch($vbulletin->GPC['frame']) { case 'h': $expires = mktime(date('H') + $vbulletin->GPC['period'], date('i'), date('s'), date('m'), date('d'), date('y')); break; case 'd': $expires = mktime(date('H'), date('i'), date('s'), date('m'), date('d') + $vbulletin->GPC['period'], date('y')); break; case 'w': $expires = $vbulletin->GPC['period'] * 60 * 60 * 24 * 7 + TIMENOW; break; case 'y': $expires = mktime(date('H'), date('i'), date('s'), date('m'), date('d'), date('y') + $vbulletin->GPC['period']); break; case 'm': default: $expires = mktime(date('H'), date('i'), date('s'), date('m') + $vbulletin->GPC['period'], date('d'), date('y')); } } $merge_thread =& datamanager_init('Thread', $vbulletin, ERRTYPE_ARRAY, 'threadpost'); $merge_thread->set_existing($mergethreadinfo); if ($vbulletin->GPC['redirect'] AND $vbulletin->GPC['redirect'] != 'none') { $merge_thread->set('open', 10); $merge_thread->set('pollid', $threadinfo['threadid']); $merge_thread->set('visible', 1); $merge_thread->set('dateline', TIMENOW); $merge_thread->save(); if ($vbulletin->GPC['redirect'] == 'expires') { $db->query_write(" INSERT INTO " . TABLE_PREFIX . "threadredirect (threadid, expires) VALUES ($mergethreadinfo[threadid], $expires) "); } } else { // remove remnants of merge thread $merge_thread->delete(false, true, NULL, false); } unset($merge_thread); // update postindex for the 2 posts who's titles may have changed (first post of each thread) delete_post_index($thrd_firstpost['postid']); delete_post_index($mrgthrd_firstpost['postid']); build_post_index($thrd_firstpost['postid'] , $foruminfo); build_post_index($mrgthrd_firstpost['postid'] , $foruminfo); build_thread_counters($threadinfo['threadid']); build_forum_counters($threadinfo['forumid']); if ($mergethreadinfo['forumid'] != $threadinfo['forumid']) { build_forum_counters($mergethreadinfo['forumid']); } log_moderator_action($threadinfo, 'thread_merged_with_x', $mergethreadinfo['title']); ($hook = vBulletinHook::fetch_hook('threadmanage_merge_complete')) ? eval($hook) : false; $vbulletin->url = 'showthread.php?' . $vbulletin->session->vars['sessionurl'] . "t=$threadinfo[threadid]"; eval(print_standard_redirect('redirect_mergethread')); } // ############################### start stick / unstick thread ############################### if ($_POST['do'] == 'stick') { if (($threadinfo['isdeleted'] AND !can_moderate($threadinfo['forumid'], 'candeleteposts')) OR (!$threadinfo['visible'] AND !can_moderate($threadinfo['forumid'], 'canmoderateposts'))) { if (can_moderate($threadinfo['forumid'])) { print_no_permission(); } else { eval(standard_error(fetch_error('invalidid', $idname, $vbulletin->options['contactuslink']))); } } if (!can_moderate($threadinfo['forumid'], 'canmanagethreads')) { print_no_permission(); } // check if there is a forum password and if so, ensure the user has it set verify_forum_password($foruminfo['forumid'], $foruminfo['password']); // handles mod log $threadman =& datamanager_init('Thread', $vbulletin, ERRTYPE_ARRAY, 'threadpost'); $threadman->set_existing($threadinfo); $threadman->set('sticky', ($threadman->fetch_field('sticky') == 1 ? 0 : 1)); ($hook = vBulletinHook::fetch_hook('threadmanage_stickunstick')) ? eval($hook) : false; $threadman->save(); if ($threadinfo['sticky']) { $action = $vbphrase['unstuck']; } else { $action = $vbphrase['stuck']; } $vbulletin->url = 'showthread.php?' . $vbulletin->session->vars['sessionurl'] . "t=$threadid"; eval(print_standard_redirect('redirect_sticky', true, true)); } // ############################### start remove redirects ############################### if ($_POST['do'] == 'removeredirect') { if (!can_moderate($threadinfo['forumid'], 'canmanagethreads')) { print_no_permission(); } verify_forum_password($foruminfo['forumid'], $foruminfo['password']); // Really need thread.* for set_existing -> delete_thread() $redirects = $db->query_read_slave(" SELECT * FROM " . TABLE_PREFIX . "thread WHERE open = 10 AND pollid = $threadid "); while ($redirect = $db->fetch_array($redirects)) { verify_forum_password($redirect['forumid'], $vbulletin->forumcache["$redirect[forumid]"]['password']); $old_redirect =& datamanager_init('Thread', $vbulletin, ERRTYPE_ARRAY, 'threadpost'); $old_redirect->set_existing($redirect); $old_redirect->delete(false, true); unset($old_redirect); } ($hook = vBulletinHook::fetch_hook('threadmanage_removeredirect')) ? eval($hook) : false; $vbulletin->url = 'showthread.php?' . $vbulletin->session->vars['sessionurl'] . "t=$threadid"; eval(print_standard_redirect('redirects_removed', true, true)); } // ############################### start manage post ############################### if ($_POST['do'] == 'domanagepost') { $vbulletin->input->clean_array_gpc('p', array( 'poststatus' => TYPE_UINT, 'reason' => TYPE_NOHTML, )); if (!can_moderate($threadinfo['forumid'], 'candeleteposts')) { print_no_permission(); } verify_forum_password($foruminfo['forumid'], $foruminfo['password']); if ($vbulletin->GPC['poststatus'] == 1) { // undelete $postdeleted = -1; } else if ($vbulletin->GPC['poststatus'] == 2 AND can_moderate($threadinfo['forumid'], 'canremoveposts')) { // remove $postdeleted = 1; } else { // leave as is $postdeleted = 0; } if ($postdeleted != 1) { $deletionman =& datamanager_init('Deletionlog_ThreadPost', $vbulletin, ERRTYPE_STANDARD, 'deletionlog'); $deletioninfo = array('type' => 'post', 'primaryid' => $postid); $deletionman->set_existing($deletioninfo); $deletionman->set('reason', $vbulletin->GPC['reason']); $deletionman->save(); unset($deletionman, $deletioninfo); } if ($postdeleted == -1) { undelete_post($postid, $foruminfo['countposts'], $postinfo, $threadinfo); } else if ($postdeleted == 1) { $postman =& datamanager_init('Post', $vbulletin, ERRTYPE_ARRAY, 'threadpost'); $postman->set_existing($postinfo); $postman->delete($foruminfo['countposts'], $threadinfo['threadid'], 1); unset($postman); build_thread_counters($threadinfo['threadid']); build_forum_counters($threadinfo['forumid']); } ($hook = vBulletinHook::fetch_hook('threadmanage_managepost')) ? eval($hook) : false; if ($postdeleted != 1) { $vbulletin->url = 'showthread.php?' . $vbulletin->session->vars['sessionurl'] . "p=$postid#post$postid"; } else { $vbulletin->url = 'showthread.php?' . $vbulletin->session->vars['sessionurl'] . "t=$threadinfo[threadid]"; } eval(print_standard_redirect('redirect_post_manage')); } // ############################### start moderate thread ############################### if ($_POST['do'] == 'moderatethread') { if (!can_moderate($threadinfo['forumid'], 'canmoderateposts')) { print_no_permission(); } if ($threadinfo['open'] != 10) { if ($threadinfo['visible'] == 0) { approve_thread($threadid, $foruminfo['countposts'], true, $threadinfo); eval(print_standard_redirect('thread_approved')); } else { unapprove_thread($threadid, $foruminfo['countposts'], true, $threadinfo); eval(print_standard_redirect('thread_unapproved')); } } } // ############################### all done, do shell template ############################### if ($templatename != '') { // draw navbar eval('$navbar = "' . fetch_template('navbar') . '";'); ($hook = vBulletinHook::fetch_hook('threadmanage_complete')) ? eval($hook) : false; // spit out the final HTML if we have got this far eval('$HTML = "' . fetch_template($templatename) . '";'); eval('print_output("' . fetch_template('THREADADMIN') . '");'); } ?> >'; echo "\n"; ?>'; echo "\n"; ?>'; echo "\n"; ?>'; echo "\n"; ?>'; echo "\n"; ?>'; echo "\n"; ?>'; echo "\n"; ?>'; echo "\n"; ?>'; echo "\n"; ?>"; $plugins->run_hooks("modcp_banuser_end"); eval("\$banuser = \"".$templates->get("modcp_banuser")."\";"); output_page($banuser); } if($mybb->input['action'] == "do_modnotes") { // Verify incoming POST request verify_post_check($mybb->input['my_post_key']); $plugins->run_hooks("modcp_do_modnotes_start"); // Update Moderator Notes cache $update_cache = array( "modmessage" => $mybb->input['modnotes'] ); $cache->update("modnotes", $update_cache); $plugins->run_hooks("modcp_do_modnotes_end"); redirect("modcp.php", $lang->redirect_modnotes); } if(!$mybb->input['action']) { $query = $db->query(" SELECT COUNT(aid) AS unapprovedattachments FROM ".TABLE_PREFIX."attachments a LEFT JOIN ".TABLE_PREFIX."posts p ON (p.pid=a.pid) LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid) WHERE a.visible='0' {$tflist} "); $unapproved_attachments = $db->fetch_field($query, "unapprovedattachments"); if($unapproved_attachments > 0) { $query = $db->query(" SELECT t.tid, p.pid, p.uid, t.username, a.filename, a.dateuploaded FROM ".TABLE_PREFIX."attachments a LEFT JOIN ".TABLE_PREFIX."posts p ON (p.pid=a.pid) LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid) WHERE a.visible='0' {$tflist} ORDER BY a.dateuploaded DESC LIMIT 1 "); $attachment = $db->fetch_array($query); $attachment['date'] = my_date($mybb->settings['dateformat'], $attachment['dateuploaded']); $attachment['time'] = my_date($mybb->settings['timeformat'], $attachment['dateuploaded']); $attachment['profilelink'] = build_profile_link($attachment['username'], $attachment['uid']); $attachment['link'] = get_post_link($attachment['pid'], $attachment['tid']); $attachment['filename'] = htmlspecialchars_uni($attachment['filename']); eval("\$latest_attachment = \"".$templates->get("modcp_lastattachment")."\";"); } else { $latest_attachment = "{$lang->lastpost_never}"; } $query = $db->query(" SELECT COUNT(pid) AS unapprovedposts FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid) WHERE p.visible='0' {$tflist} AND t.firstpost != p.pid "); $unapproved_posts = $db->fetch_field($query, "unapprovedposts"); if($unapproved_posts > 0) { $query = $db->query(" SELECT p.pid, p.tid, p.subject, p.uid, p.username, p.dateline FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid) WHERE p.visible='0' {$tflist} AND t.firstpost != p.pid ORDER BY p.dateline DESC LIMIT 1 "); $post = $db->fetch_array($query); $post['date'] = my_date($mybb->settings['dateformat'], $post['dateline']); $post['time'] = my_date($mybb->settings['timeformat'], $post['datelsubject'] = $parser->parse_badwords($post['subject']); if(my_strlen($post['subject']) > 25) { $post['subject'] = my_substr($post['subject'], 0, 25)."..."; } $post['subject'] = htmlspecialchars_uni($post['subject']); $post['fullsubject'] = htmlspecialchars_uni($post['fullsubject']); eval("\$latest_post = \"".$templates->get("modcp_lastpost")."\";"); } else { $latest_post = "{$lang->lastpost_never}"; } $query = $db->simple_select("threads", "COUNT(tid) AS unapprovedthreads", "visible=0 {$flist}"); $unapproved_threads = $db->fetch_field($query, "unapprovedthreads"); if($unapproved_threads > 0) { $query = $db->simple_select("threads", "tid, subject, uid, username, dateline", "visible=0 {$flist}", array('order_by' => 'dateline', 'order_dir' => 'DESC', 'limit' => 1)); $thread = $db->fetch_array($query); $thread['date'] = my_date($mybb->settings['dateformat'], $thread['dateline']); $thread['time'] = my_date($mybb->settings['timeformat'], $thread['dateline']); $thread['profilelink'] = build_profile_link($thread['username'], $thread['uid']); $thread['link'] = get_thread_link($thread['tid']); $thread['subject'] = $thread['fullsubject'] = $parser->parse_badwords($thread['subject']); if(my_strlen($thread['subject']) > 25) { $post['subject'] = my_substr($thread['subject'], 0, 25)."..."; } $thread['subject'] = htmlspecialchars_uni($thread['subject']); $thread['fullsubject'] = htmlspecialchars_uni($thread['fullsubject']); eval("\$latest_thread = \"".$templates->get("modcp_lastthread")."\";"); } else { $latest_thread = "{$lang->lastpost_never}"; } $where = ''; if($tflist) { $where = "WHERE (t.fid <> 0 {$tflist}) OR (!l.fid)"; } $query = $db->query(" SELECT l.*, u.username, u.usergroup, u.displaygroup, t.subject AS tsubject, f.name AS fname, p.subject AS psubject FROM ".TABLE_PREFIX."moderatorlog l LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=l.uid) LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=l.tid) LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=l.fid) LEFT JOIN ".TABLE_PREFIX."posts p ON (p.pid=l.pid) {$where} ORDER BY l.dateline DESC LIMIT 5 "); while($logitem = $db->fetch_array($query)) { $information = ''; $logitem['action'] = htmlspecialchars_uni($logitem['action']); $log_date = my_date($mybb->settings['dateformat'], $logitem['dateline']); $log_time = my_date($mybb-t=\"_blank\">".htmlspecialchars_uni($logitem['tsubject'])."
    "; } if($logitem['fname']) { $information .= "{$lang->forum} ".htmlspecialchars_uni($logitem['fname'])."
    "; } if($logitem['psubject']) { $information .= "{$lang->post} ".htmlspecialchars_uni($logitem['psubject']).""; } // Edited a user? if(!$logitem['tsubject'] || !$logitem['fname'] || !$logitem['psubject']) { $data = unserialize($logitem['data']); if($data['uid']) { $information = $lang->sprintf($lang->edited_user_info, htmlspecialchars_uni($data['username']), get_profile_link($data['uid'])); } } eval("\$modlogresults .= \"".$templates->get("modcp_modlogs_result")."\";"); } if(!$modlogresults) { eval("\$modlogresults = \"".$templates->get("modcp_modlogs_noresults")."\";"); } $query = $db->query(" SELECT b.*, a.username AS adminuser, u.username, (b.lifted-".TIME_NOW.") AS remaining FROM ".TABLE_PREFIX."banned b LEFT JOIN ".TABLE_PREFIX."users u ON (b.uid=u.uid) LEFT JOIN ".TABLE_PREFIX."users a ON (b.admin=a.uid) WHERE b.bantime != '---' AND b.bantime != 'perm' ORDER BY remaining ASC LIMIT 5 "); // Get the banned users while($banned = $db->fetch_array($query)) { $profile_link = build_profile_link($banned['username'], $banned['uid']); // Only show the edit & lift links if current user created ban, or is super mod/admin $edit_link = ''; if($mybb->user['uid'] == $banned['admin'] || !$banned['adminuser'] || $mybb->usergroup['issupermod'] == 1 || $mybb->usergroup['cancp'] == 1) { $edit_link = "
    {$lang->edit_ban} | post_code}\">{$lang->lift_ban}"; } $admin_profile = build_profile_link($banned['adminuser'], $banned['admin']); $trow = alt_trow(); if($banned['reason']) { $banned['reason'] = htmlspecialchars_uni($parser->parse_badwords($banned['reason'])); } else { $banned['reason'] = $lang->na; } if($banned['lifted'] == 'perm' || $banned['lifted'] == '' || $banned['bantime'] == 'perm' || $banned['bantime'] == '---') { $banlength = $lang->permanent; $timeremaining = $lang->na; } else { $banlength = $bantimes[$banned['bantime']]; $remaining = $banned['remaining']; $timeremaining = nice_time($remaining, array('short' => 1, 'seconds' => false)).""; if($remaining <= 0) { $timeremaining = "({$lang->ban_ending_imminently})"; } else if($remaining < 3600) { $timeremaining = "({$timeremaining} {$lang->ban_remaining})"; } else if($remaining < 86400) { $timeremaining = "({$timeremaining} {$lang->ban_remaining})"; } else if($remaining < 604800) { $timeremaining = "({$timeremaining} {$lang->ban_remaining})"; } else { $timeremaining = "({$timeremaining} {$lang->ban_remaining})"; } } eval("\$bannedusers .= \"".$templates->get("modcp_banning_ban")."\";"); } if(!$bannedusers) { eval("\$bannedusers = \"".$templates->get("modcp_banning_nobanned")."\";"); } $modnotes = $cache->read("modnotes"); $modnotes = htmlspecialchars_uni($modnotes['modmessage']); $plugins->run_hooks("modcp_end"); eval("\$modcp = \"".$templates->get("modcp")."\";"); output_page($modcp); } ?> $cache->read("modnotes"); $modnotes = htmlspecialchars_uni($modnotes['modmessage']); $plugins->run_hooks("modcp_end"); eval("\$modcp = \"".$templates->get("modcp")."\";"); output_page($modcp); } ?>