input->clean_array_gpc('r', array(
'perpage' => TYPE_UINT,
'startat' => TYPE_UINT
));
// ###################### Start clear cache ########################
if ($_REQUEST['do'] == 'clear_cache')
{
print_cp_header($vbphrase['clear_system_cache']);
vB_Cache::instance()->clean(false);
print_cp_message($vbphrase['cache_cleared']);
}
else
{
print_cp_header($vbphrase['maintenance']);
}
// ###################### Clear Autosave option #######################
if ($_REQUEST['do'] == 'clearauto')
{
print_form_header('misc', 'doclearauto');
print_table_header($vbphrase['clear_autosave_title']);
print_description_row($vbphrase['clear_autosave_desc']);
print_input_row($vbphrase['clear_autosave_limit'], 'cleandays', 21);
print_submit_row($vbphrase['clear_autosave_run']);
}
if ($_POST['do'] == 'rebuildactivity')
{
vB_ActivityStream_Manage::rebuild();
vB_ActivityStream_Manage::updateScores();
print_stop_message('rebuild_activity_stream_done');
}
if ($_POST['do'] == 'doclearauto')
{
$vbulletin->input->clean_array_gpc('p', array(
'cleandays' => TYPE_UINT
));
if ($vbulletin->GPC['cleandays'] < 7)
{
print_stop_message('clear_autosave_toolow');
}
// Clear out the actual autosave entries
$cleandate = TIMENOW - ($vbulletin->GPC['cleandays'] * 86400);
$vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "autosave WHERE dateline < $cleandate");
print_stop_message('clear_autosave_done');
}
// ###################### Rebuild all style info #######################
if ($_POST['do'] == 'rebuildstyles')
{
require_once(DIR . '/includes/adminfunctions_template.php');
$vbulletin->input->clean_array_gpc('p', array(
'renumber' => TYPE_BOOL,
'install' => TYPE_BOOL
));
build_all_styles($vbulletin->GPC['renumber'], $vbulletin->GPC['install'], 'misc.php?' . $vbulletin->session->vars['sessionurl'] . 'do=chooser#style', false, 'standard', false);
build_all_styles($vbulletin->GPC['renumber'], $vbulletin->GPC['install'], 'misc.php?' . $vbulletin->session->vars['sessionurl'] . 'do=chooser#style', false, 'mobile');
print_stop_message('updated_styles_successfully');
}
// ###################### Start emptying the index #######################
if ($_REQUEST['do'] == 'emptyindex')
{
print_form_header('misc', 'doemptyindex');
print_table_header($vbphrase['confirm_deletion']);
print_description_row($vbphrase['are_you_sure_empty_index']);
print_submit_row($vbphrase['yes'], '', 2, $vbphrase['no']);
}
// ###################### Start emptying the index #######################
if ($_POST['do'] == 'doemptyindex')
{
define('CP_REDIRECT', 'misc.php');
require_once(DIR . '/vb/search/core.php');
vB_Search_Core::get_instance()->get_core_indexer()->empty_index();
define('CP_REDIRECT', 'misc.php');
print_stop_message('emptied_search_index_successfully');
}
// ###################### Start build search index #######################
if ($_REQUEST['do'] == 'doindextypes')
{
require_once(DIR . '/includes/functions_misc.php');
require_once(DIR . '/vb/search/core.php');
$vbulletin->input->clean_array_gpc('r', array(
'doprocess' => TYPE_UINT,
'autoredirect' => TYPE_BOOL,
'totalitems' => TYPE_UINT,
'indextypes' => TYPE_UINT
));
$starttime = microtime();
$end = false;
// Init Search & get the enabled types to be re-indexed
$types = vB_Search_Core::get_instance();
$indexed_types = $types->get_indexed_types();
if ($vbulletin->GPC['indextypes'] == 0)
{
// Try getting an exsisting stack
$stack = $db->query_first("SELECT text FROM " . TABLE_PREFIX . "adminutil WHERE title='searchstack'");
if ($stack['text'])
{
$stack = unserialize($stack['text']);
if (!$stack['current'])
{
$stack['current'] = @array_shift($stack['next']);
if (!$stack['current'])
{
$end = true;
}
}
}
else
{ // or create a new one with all type that can be searched
$db->query_first("REPLACE INTO " . TABLE_PREFIX . "adminutil SET text='', title='searchstack'");
foreach ($indexed_types AS $id => $details)
{
$stack['next'][] = array('package' => $details['package'], 'classname' => $details['class']);
}
$stack['current'] = array_shift($stack['next']);
}
if (ctype_alpha($stack['current']['package']) AND ctype_alpha($stack['current']['classname']))
{
$indexer = vB_Search_Core::get_instance()->get_index_controller($stack['current']['package'], $stack['current']['classname']);
$indexed_types[$vbulletin->GPC['indextypes']]['class'] = $stack['current']['classname'];
}
}
elseif (array_key_exists($vbulletin->GPC['indextypes'], $indexed_types))
{
$indexer = vB_Search_Core::get_instance()->get_index_controller($indexed_types[$vbulletin->GPC['indextypes']]['package'], $indexed_types[$vbulletin->GPC['indextypes']]['class']);
}
else
{
print_stop_message('search_no_indexer');
}
$max_id = $indexer->get_max_id();
$finishat = min($vbulletin->GPC['startat'] + $vbulletin->GPC['perpage'], $max_id);
echo '' . $vbphrase['building_search_index'] . ' ' .
vB_Search_Core::get_instance()->get_search_type_from_id($vbulletin->GPC['indextypes'])->get_display_name() . ' ' .
$vbulletin->GPC['startat'] . ' :: ' .
$vbulletin->GPC['perpage'] . '
';
vbflush();
// Do the indexing
if (!$end)
{
$indexer->index_id_range($vbulletin->GPC['startat'], $finishat);
}
$pagetime = vb_number_format(fetch_microtime_difference($starttime), 2);
echo '' . construct_phrase($vbphrase['processing_time_x'], $pagetime) . '
' . construct_phrase($vbphrase['total_items_processed_x'], $indexer->range_indexed) . '
';
vbflush();
// There is more to do of that type
if ($finishat < $max_id)
{
if ($vbulletin->GPC['autoredirect'] == 1)
{
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] .
"do=doindextypes&startat=$finishat&pp=" . $vbulletin->GPC['perpage'] .
"&autoredirect=" . $vbulletin->GPC['autoredirect'] .
"&doprocess=" . $vbulletin->GPC['doprocess'] .
"&totalitems=" . $vbulletin->GPC['totalitems'] .
"&indextypes=" . $vbulletin->GPC['indextypes']);
}
echo "session->vars['sessionurl'] .
"do=doindextypes&startat=$finishat&pp=" . $vbulletin->GPC['perpage'] .
"&autoredirect=" . $vbulletin->GPC['autoredirect'] .
"&doprocess=" . $vbulletin->GPC['doprocess'] .
"&totalitems=" . $vbulletin->GPC['indextypes'] .
"&indextypes=" . $vbulletin->GPC['indextypes'] . "\">" .
$vbphrase['click_here_to_continue_processing'] . "
";
}
else
{
// If there is more on the stack to do
if (count($stack['next']))
{
// Save the stack, clear null, so next type is chosen
$stack['current'] = null;
$db->query_first("UPDATE " . TABLE_PREFIX . "adminutil SET text='" . $db->escape_string(serialize($stack)) . "' WHERE title='searchstack'");
if ($vbulletin->GPC['autoredirect'] == 1)
{
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=doindextypes&startat=0&pp=" . $vbulletin->GPC['perpage'] . "&autoredirect=" . $vbulletin->GPC['autoredirect'] . "&doprocess=" . $vbulletin->GPC['doprocess'] . "&totalitems=" . $vbulletin->GPC['totalitems'] . "&indextypes=" . $vbulletin->GPC['indextypes']);
}
echo "session->vars['sessionurl'] . "do=doindextypes&startat=0&pp=" . $vbulletin->GPC['perpage'] . "&autoredirect=" . $vbulletin->GPC['autoredirect'] . "&doprocess=" . $vbulletin->GPC['doprocess'] . "&totalitems=" . $vbulletin->GPC['indextypes'] . "&indextypes=" . $vbulletin->GPC['indextypes'] . "\">" . $vbphrase['click_here_to_continue_processing'] . "
";
}
else
{
$end = true;
}
}
if ($end)
{
// Delete the stack
$db->query_first("DELETE FROM " . TABLE_PREFIX . "adminutil WHERE title='searchstack'");
define('CP_REDIRECT', 'misc.php');
print_stop_message('rebuilt_search_index_successfully');
}
}
// ###################### Start update post counts ################
if ($_REQUEST['do'] == 'updateposts')
{
if (empty($vbulletin->GPC['perpage']))
{
$vbulletin->GPC['perpage'] = 1000;
}
$finishat = $vbulletin->GPC['startat'] + $vbulletin->GPC['perpage'];
echo '' . $vbphrase['updating_post_counts'] . '
';
$forums = $db->query_read("
SELECT forumid
FROM " . TABLE_PREFIX . "forum AS forum
WHERE (forum.options & " . $vbulletin->bf_misc_forumoptions['countposts'] . ")
");
$gotforums = '';
while ($forum = $db->fetch_array($forums))
{
$gotforums .= ',' . $forum['forumid'];
}
$users = $db->query_read("
SELECT *
FROM " . TABLE_PREFIX . "user
WHERE userid >= " . $vbulletin->GPC['startat'] . "
ORDER BY userid
LIMIT " . $vbulletin->GPC['perpage']
);
$finishat = $vbulletin->GPC['startat'];
while ($user = $db->fetch_array($users))
{
$totalposts = $db->query_first("
SELECT COUNT(*) AS posts
FROM " . TABLE_PREFIX . "post AS post
INNER JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = post.threadid)
WHERE post.userid = $user[userid]
AND thread.forumid IN (0$gotforums)
AND thread.visible = 1
AND post.visible = 1
");
$userdm =& datamanager_init('User', $vbulletin, ERRTYPE_CP);
$userdm->set_existing($user);
$userdm->set('posts', $totalposts['posts']);
$userdm->set_ladder_usertitle($totalposts['posts']);
$userdm->save();
unset($userdm);
echo construct_phrase($vbphrase['processing_x'], $user['userid']) . "
\n";
vbflush();
$finishat = ($user['userid'] > $finishat ? $user['userid'] : $finishat);
}
$finishat++;
if ($checkmore = $db->query_first("SELECT userid FROM " . TABLE_PREFIX . "user WHERE userid >= $finishat LIMIT 1"))
{
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=updateposts&startat=$finishat&pp=" . $vbulletin->GPC['perpage']);
echo "session->vars['sessionurl'] . "do=updateposts&startat=$finishat&pp=" . $vbulletin->GPC['perpage'] . "\">" . $vbphrase['click_here_to_continue_processing'] . "
";
}
else
{
define('CP_REDIRECT', 'misc.php');
print_stop_message('updated_post_counts_successfully');
}
}
// ###################### Start update user #######################
if ($_REQUEST['do'] == 'updateuser')
{
require_once(DIR . '/includes/functions_infractions.php');
if (empty($vbulletin->GPC['perpage']))
{
$vbulletin->GPC['perpage'] = 1000;
}
echo '' . $vbphrase['updating_user_info'] . '
';
$tmp_usergroup_cache = array();
$infractiongroups = array();
$groups = $vbulletin->db->query_read("
SELECT usergroupid, orusergroupid, pointlevel, override
FROM " . TABLE_PREFIX . "infractiongroup
ORDER BY pointlevel
");
while ($group = $vbulletin->db->fetch_array($groups))
{
$infractiongroups["$group[usergroupid]"]["$group[pointlevel]"][] = array(
'orusergroupid' => $group['orusergroupid'],
'override' => $group['override'],
);
}
$users = $db->query_read("
SELECT user.*, usertextfield.rank,
IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield USING (userid)
WHERE user.userid >= " . $vbulletin->GPC['startat'] . "
ORDER BY user.userid
LIMIT " . $vbulletin->GPC['perpage']
);
$finishat = $vbulletin->GPC['startat'];
while ($user = $db->fetch_array($users))
{
$userdm =& datamanager_init('User', $vbulletin, ERRTYPE_CP);
$userdm->set_existing($user);
cache_permissions($user, false);
$userdm->set_usertitle(
($user['customtitle'] ? $user['usertitle'] : ''),
false,
$vbulletin->usergroupcache["$user[displaygroupid]"],
($user['customtitle'] == 1 OR $user['permissions']['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canusecustomtitle']) ? true : false,
($user['customtitle'] == 1) ? true : false
);
if ($lastpost = $db->query_first("SELECT MAX(dateline) AS dateline FROM " . TABLE_PREFIX . "post WHERE userid = $user[userid]"))
{
$lastpost['dateline'] = intval($lastpost['dateline']);
}
else
{
$lastpost['dateline'] = 0;
}
$infractioninfo = fetch_infraction_groups($infractiongroups, $user['userid'], $user['ipoints'], $user['usergroupid']);
$userdm->set('infractiongroupids', $infractioninfo['infractiongroupids']);
$userdm->set('infractiongroupid', $infractioninfo['infractiongroupid']);
$userdm->set('posts', $user['posts']); // This will activate the rank update
$userdm->set('lastpost', $lastpost['dateline']);
$userdm->save();
unset($userdm);
echo construct_phrase($vbphrase['processing_x'], $user['userid']) . "
\n";
vbflush();
$finishat = ($user['userid'] > $finishat ? $user['userid'] : $finishat);
}
$finishat++;
if ($checkmore = $db->query_first("SELECT userid FROM " . TABLE_PREFIX . "user WHERE userid >= $finishat LIMIT 1"))
{
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=updateuser&startat=$finishat&pp=" . $vbulletin->GPC['perpage']);
echo "session->vars['sessionurl'] . "do=updateuser&startat=$finishat&pp=" . $vbulletin->GPC['perpage'] . "\">" . $vbphrase['click_here_to_continue_processing'] . "
";
}
else
{
define('CP_REDIRECT', 'misc.php');
print_stop_message('updated_user_titles_successfully');
}
}
// ###################### Start update usernames #######################
if ($_REQUEST['do'] == 'updateusernames')
{
if (empty($vbulletin->GPC['perpage']))
{
$vbulletin->GPC['perpage'] = 1000;
}
echo '' . $vbphrase['updating_usernames'] . '
';
$users = $db->query_read("
SELECT *
FROM " . TABLE_PREFIX . "user
WHERE userid >= " . $vbulletin->GPC['startat'] . "
ORDER BY userid
LIMIT " . $vbulletin->GPC['perpage']
);
$finishat = $vbulletin->GPC['startat'];
while ($user = $db->fetch_array($users))
{
$userman =& datamanager_init('User', $vbulletin, ERRTYPE_SILENT);
$userman->set_existing($user);
$userman->update_username($user['userid'], $user['username']);
unset($userman);
echo construct_phrase($vbphrase['processing_x'], $user['userid']) . "
\n";
vbflush();
$finishat = ($user['userid'] > $finishat ? $user['userid'] : $finishat);
}
$finishat++; // move past the last processed user
if ($checkmore = $db->query_first("SELECT userid FROM " . TABLE_PREFIX . "user WHERE userid >= $finishat LIMIT 1"))
{
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=updateusernames&startat=$finishat&pp=" . $vbulletin->GPC['perpage']);
echo "session->vars['sessionurl'] . "do=updateusernames&startat=$finishat&pp=" . $vbulletin->GPC['perpage'] . "\">" . $vbphrase['click_here_to_continue_processing'] . "
";
}
else
{
define('CP_REDIRECT', 'misc.php');
print_stop_message('updated_usernames_successfully');
}
}
// ###################### Start update forum #######################
if ($_REQUEST['do'] == 'updateforum')
{
if (empty($vbulletin->GPC['perpage']))
{
$vbulletin->GPC['perpage'] = 100;
}
echo '' . $vbphrase['updating_forums'] . '
';
$forums = $db->query_read("
SELECT forumid
FROM " . TABLE_PREFIX . "forum
WHERE forumid >= " . $vbulletin->GPC['startat'] . "
ORDER BY forumid
LIMIT " . $vbulletin->GPC['perpage']
);
$finishat = $vbulletin->GPC['startat'];
while($forum = $db->fetch_array($forums))
{
build_forum_counters($forum['forumid'], true);
echo construct_phrase($vbphrase['processing_x'], $forum['forumid']) . "
\n";
vbflush();
$finishat = ($forum['forumid'] > $finishat ? $forum['forumid'] : $finishat);
}
$finishat++;
if ($checkmore = $db->query_first("SELECT forumid FROM " . TABLE_PREFIX . "forum WHERE forumid >= $finishat LIMIT 1"))
{
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=updateforum&startat=$finishat&pp=" . $vbulletin->GPC['perpage']);
echo "session->vars['sessionurl'] . "do=updateforum&startat=$finishat&pp=" . $vbulletin->GPC['perpage'] . "\">" . $vbphrase['click_here_to_continue_processing'] . "
";
}
else
{
// get rid of "ghost" moderators who are not attached to a valid forum
$deadmods = $db->query_read("
SELECT moderatorid
FROM " . TABLE_PREFIX . "moderator AS moderator
LEFT JOIN " . TABLE_PREFIX . "forum AS forum USING (forumid)
WHERE forum.forumid IS NULL AND forum.forumid <> -1
");
$mods = '';
while ($mod = $db->fetch_array($deadmods))
{
if (!empty($mods))
{
$mods .= ' , ';
}
$mods .= $mod['moderatorid'];
}
if (!empty($mods))
{
$db->query_write("DELETE FROM " . TABLE_PREFIX . "moderator WHERE moderatorid IN (" . $mods . ")");
}
// and finally rebuild the forumcache
unset($forumarraycache, $vbulletin->forumcache);
build_forum_permissions();
define('CP_REDIRECT', 'misc.php');
print_stop_message('updated_forum_successfully');
}
}
// ###################### Start update threads #######################
if ($_REQUEST['do'] == 'updatethread')
{
if (empty($vbulletin->GPC['perpage']))
{
$vbulletin->GPC['perpage'] = 2000;
}
echo '' . $vbphrase['updating_threads'] . '
';
$threads = $db->query_read("
SELECT threadid
FROM " . TABLE_PREFIX . "thread
WHERE threadid >= " . $vbulletin->GPC['startat'] . "
ORDER BY threadid
LIMIT " . $vbulletin->GPC['perpage']
);
$finishat = $vbulletin->GPC['startat'];
while ($thread = $db->fetch_array($threads))
{
build_thread_counters($thread['threadid']);
echo construct_phrase($vbphrase['processing_x'], $thread['threadid'])."
\n";
vbflush();
$finishat = ($thread['threadid'] > $finishat ? $thread['threadid'] : $finishat);
}
$finishat++;
if ($checkmore = $db->query_first("SELECT threadid FROM " . TABLE_PREFIX . "thread WHERE threadid >= $finishat LIMIT 1"))
{
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=updatethread&startat=$finishat&pp=" . $vbulletin->GPC['perpage']);
echo "session->vars['sessionurl'] . "do=updatethread&startat=$finishat&pp=" . $vbulletin->GPC['perpage'] . "\">" . $vbphrase['click_here_to_continue_processing'] . "
";
}
else
{
define('CP_REDIRECT', 'misc.php');
print_stop_message('updated_threads_successfully');
}
}
// ###################### Start update similar threads #######################
if ($_REQUEST['do'] == 'updatesimilar')
{
require_once(DIR . '/includes/functions_search.php');
if (empty($vbulletin->GPC['perpage']))
{
$vbulletin->GPC['perpage'] = 100;
}
echo '' . $vbphrase['updating_similar_threads'] . '
';
$threads = $db->query_read("
SELECT title, threadid
FROM " . TABLE_PREFIX . "thread
WHERE threadid >= " . $vbulletin->GPC['startat'] . "
ORDER BY threadid
LIMIT " . $vbulletin->GPC['perpage']
);
$finishat = $vbulletin->GPC['startat'];
while ($thread = $db->fetch_array($threads))
{
require_once(DIR . '/vb/search/core.php');
$searchcontroller = vB_Search_Core::get_instance()->get_search_controller();
$similarthreads = $searchcontroller->get_similar_threads($thread['title'], $thread['threadid']);
$threadman =& datamanager_init('Thread', $vbulletin, ERRTYPE_CP, 'threadpost');
$threadman->set_existing($thread);
$threadman->set('similar', implode(',', $similarthreads));
$threadman->save();
echo construct_phrase($vbphrase['processing_x'], $thread['threadid']) . "
\n";
vbflush();
$finishat = ($thread['threadid'] > $finishat ? $thread['threadid'] : $finishat);
}
$finishat++;
if ($checkmore = $db->query_first("SELECT threadid FROM " . TABLE_PREFIX . "thread WHERE threadid >= $finishat LIMIT 1"))
{
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=updatesimilar&startat=$finishat&pp=" . $vbulletin->GPC['perpage']);
echo "session->vars['sessionurl'] . "do=updatesimilar&startat=$finishat&pp=" . $vbulletin->GPC['perpage'] . "\">" . $vbphrase['click_here_to_continue_processing'] . "
";
}
else
{
define('CP_REDIRECT', 'misc.php');
print_stop_message('updated_similar_threads_successfully');
}
}
// ################## Start rebuilding user reputation ######################
if ($_POST['do'] == 'rebuildreputation')
{
$vbulletin->input->clean_array_gpc('p', array(
'reputation_base' => TYPE_INT,
));
$users = $db->query_read("
SELECT reputation.userid, SUM(reputation.reputation) AS totalrep
FROM " . TABLE_PREFIX . "reputation AS reputation
GROUP BY reputation.userid
");
$userrep = array();
while ($user = $db->fetch_array($users))
{
$user['totalrep'] += $vbulletin->GPC['reputation_base'];
$userrep["$user[totalrep]"] .= ",$user[userid]";
}
if (!empty($userrep))
{
foreach ($userrep AS $reputation => $ids)
{
$usercasesql .= " WHEN userid IN (0$ids) THEN $reputation";
}
}
if ($usercasesql)
{
$db->query_write("
UPDATE " . TABLE_PREFIX . "user
SET reputation =
CASE
$usercasesql
ELSE " . $vbulletin->GPC['reputation_base'] . "
END
");
}
else // there is no reputation
{
$db->query_write("
UPDATE " . TABLE_PREFIX . "user
SET reputation = " . $vbulletin->GPC['reputation_base'] . "
");
}
require_once(DIR . '/includes/adminfunctions_reputation.php');
build_reputationids();
define('CP_REDIRECT', 'misc.php');
print_stop_message('rebuilt_user_reputation_successfully');
}
// ################## Start rebuilding attachment thumbnails ################
if ($_REQUEST['do'] == 'rebuildthumbs')
{
$vbulletin->input->clean_array_gpc('r', array(
'quality' => TYPE_UINT,
'autoredirect' => TYPE_BOOL,
));
if (($memory_limit = ini_size_to_bytes(@ini_get('memory_limit'))) < 128 * 1024 * 1024 AND $memory_limit > 0)
{
@ini_set('memory_limit', 128 * 1024 * 1024);
}
require_once(DIR . '/includes/class_image.php');
$image =& vB_Image::fetch_library($vbulletin);
$validtypes =& $image->thumb_extensions;
$extensions = array();
foreach ($vbulletin->attachmentcache AS $key => $value)
{
$key = strtolower($key);
if ($key != 'extensions' AND !empty($validtypes["$key"]))
{
$extensions[] = "'$key'";
}
}
$extensions = implode(',', $extensions);
if (!$extensions)
{
print_stop_message('you_have_no_attachments_set_to_thumb');
}
if ($vbulletin->options['imagetype'] != 'Magick' AND !function_exists('imagetypes'))
{
//define('CP_REDIRECT', 'misc.php');
print_stop_message('your_version_no_image_support');
}
if (empty($vbulletin->GPC['perpage']))
{
$vbulletin->GPC['perpage'] = 20;
}
if (!$vbulletin->GPC['startat'])
{
$firstattach = $db->query_first("
SELECT MIN(filedataid) AS min
FROM " . TABLE_PREFIX . "filedata"
);
$vbulletin->GPC['startat'] = intval($firstattach['min']);
}
echo '' . construct_phrase($vbphrase['building_attachment_thumbnails'], "misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=rebuildthumbs&startat=" . $vbulletin->GPC['startat'] . "&pp=" . $vbulletin->GPC['perpage'] . "&autoredirect=" . $vbulletin->GPC['autoredirect'] . "&quality=" . $vbulletin->GPC['quality']) . '
';
if ($vbulletin->options['attachfile'])
{
require_once(DIR . '/includes/functions_file.php');
}
$attachments = $db->query_read("
SELECT
filedataid, filedata, userid, extension, dateline, CONCAT('file.', extension) AS filename
FROM " . TABLE_PREFIX . "filedata
WHERE filedataid >= " . $vbulletin->GPC['startat'] . "
AND extension IN ($extensions)
ORDER BY filedataid
LIMIT " . $vbulletin->GPC['perpage']
);
$finishat = $vbulletin->GPC['startat'];
while ($attachment = $db->fetch_array($attachments))
{
if (!$vbulletin->options['attachfile']) // attachments are in the database
{
if ($vbulletin->options['safeupload'])
{
$filename = $vbulletin->options['tmppath'] . '/' . md5(uniqid(microtime()) . $vbulletin->userinfo['userid']);
}
else
{
$filename = tempnam(ini_get('upload_tmp_dir'), 'vbthumb');
}
$filenum = fopen($filename, 'wb');
fwrite($filenum, $attachment['filedata']);
fclose($filenum);
}
else
{
$filename = fetch_attachment_path($attachment['userid'], $attachment['filedataid']);
}
echo construct_phrase($vbphrase['processing_x'], "$vbphrase[attachment] : $attachment[filedataid] ($attachment[extension])");
if (!is_readable($filename) OR !@filesize($filename))
{
echo '' . $vbphrase['error_attachment_missing'] . '
';
continue;
}
$labelimage = ($vbulletin->options['attachthumbs'] == 3 OR $vbulletin->options['attachthumbs'] == 4);
$drawborder = ($vbulletin->options['attachthumbs'] == 2 OR $vbulletin->options['attachthumbs'] == 4);
$thumbnail = $image->fetch_thumbnail($attachment['filename'], $filename, $vbulletin->options['attachthumbssize'], $vbulletin->options['attachthumbssize'], $vbulletin->GPC['quality'], $labelimage, $drawborder);
// Remove temporary file we used to generate thumbnail
if (!$vbulletin->options['attachfile'])
{
@unlink($filename);
}
$attachdata =& datamanager_init('Filedata', $vbulletin, ERRTYPE_SILENT, 'attachment');
$attachdata->set_existing($attachment);
$attachdata->set('width', $thumbnail['source_width']);
$attachdata->set('height', $thumbnail['source_height']);
if (!empty($thumbnail['filedata']))
{
$attachdata->setr('thumbnail', $thumbnail['filedata']);
$attachdata->set('thumbnail_dateline', TIMENOW);
$attachdata->set('thumbnail_width', $thumbnail['width']);
$attachdata->set('thumbnail_height', $thumbnail['height']);
}
if (!($result = $attachdata->save()))
{
if (!empty($attachdata->errors[0]))
{
echo $attacherror =& $attachdata->errors[0];
}
}
unset($attachdata);
if (!empty($thumbnail['imageerror']))
{
echo ' ' . $vbphrase["error_$thumbnail[imageerror]"] . '';
}
else if (empty($thumbnail['filedata']))
{
echo ' ' . $vbphrase['error'] . '';
}
echo '
';
vbflush();
$finishat = ($attachment['filedataid'] > $finishat ? $attachment['filedataid'] : $finishat);
}
$finishat++;
if ($checkmore = $db->query_first("SELECT filedataid FROM " . TABLE_PREFIX . "filedata WHERE filedataid >= $finishat AND extension IN ($extensions) ORDER BY filedataid LIMIT 1"))
{
if ($vbulletin->GPC['autoredirect'] == 1)
{
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=rebuildthumbs&startat=$finishat&pp=" . $vbulletin->GPC['perpage'] . "&quality=" . $vbulletin->GPC['quality'] . "&autoredirect=1");
}
echo "session->vars['sessionurl'] . "do=rebuildthumbs&startat=$finishat&pp=" . $vbulletin->GPC['perpage'] . "&quality=" . $vbulletin->GPC['quality'] . '">' . $vbphrase['click_here_to_continue_processing'] . "
";
}
else
{
define('CP_REDIRECT', 'misc.php');
print_stop_message('rebuilt_attachment_thumbnails_successfully');
}
}
// ################## Start rebuilding avatar thumbnails ################
if ($_REQUEST['do'] == 'rebuildavatars')
{
$vbulletin->input->clean_array_gpc('r', array(
'autoredirect' => TYPE_BOOL,
));
if (($memory_limit = ini_size_to_bytes(@ini_get('memory_limit'))) < 128 * 1024 * 1024 AND $memory_limit > 0)
{
@ini_set('memory_limit', 128 * 1024 * 1024);
}
if ($vbulletin->options['imagetype'] != 'Magick' AND !function_exists('imagetypes'))
{
//define('CP_REDIRECT', 'misc.php');
print_stop_message('your_version_no_image_support');
}
if ($vbulletin->options['usefileavatar'] AND !is_writable($vbulletin->options['avatarpath']))
{
print_stop_message('custom_avatarpath_not_writable', $vbulletin->options['avatarpath']);
}
if (empty($vbulletin->GPC['perpage']))
{
$vbulletin->GPC['perpage'] = 20;
}
if (!$vbulletin->GPC['startat'])
{
$firstattach = $db->query_first("SELECT MIN(userid) AS min FROM " . TABLE_PREFIX . "customavatar");
$vbulletin->GPC['startat'] = intval($firstattach['min']);
}
echo '' . construct_phrase($vbphrase['building_avatar_thumbnails'], "misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=rebuildavatars&startat=" . $vbulletin->GPC['startat'] . "&pp=" . $vbulletin->GPC['perpage'] . "&autoredirect=" . $vbulletin->GPC['autoredirect']) . '
';
$avatars = $db->query_read("
SELECT user.userid, user.avatarrevision, customavatar.filedata, customavatar.filename, customavatar.dateline, customavatar.width, customavatar.height
FROM " . TABLE_PREFIX . "customavatar AS customavatar
INNER JOIN " . TABLE_PREFIX . "user AS user ON(user.userid=customavatar.userid)
WHERE customavatar.userid >= " . $vbulletin->GPC['startat'] . "
ORDER BY customavatar.userid
LIMIT " . $vbulletin->GPC['perpage']
);
$finishat = $vbulletin->GPC['startat'];
while ($avatar = $db->fetch_array($avatars))
{
echo construct_phrase($vbphrase['processing_x'], "$vbphrase[avatar] : $avatar[userid] (" . file_extension($avatar['filename']) . ') ');
if ($vbulletin->options['usefileavatar'])
{
$avatarurl = $vbulletin->options['avatarurl'] . "/avatar$avatar[userid]_$avatar[avatarrevision].gif";
$avatar['filedata'] = @file_get_contents($avatarurl);
}
if (!empty($avatar['filedata']))
{
$dataman =& datamanager_init('Userpic_Avatar', $vbulletin, ERRTYPE_STANDARD, 'userpic');
$dataman->set_existing($avatar);
$dataman->save();
unset($dataman);
}
echo '
';
vbflush();
$finishat = ($avatar['userid'] > $finishat ? $avatar['userid'] : $finishat);
}
$finishat++;
if ($checkmore = $db->query_first("SELECT userid FROM " . TABLE_PREFIX . "customavatar WHERE userid >= $finishat LIMIT 1"))
{
if ($vbulletin->GPC['autoredirect'] == 1)
{
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=rebuildavatars&startat=$finishat&pp=" . $vbulletin->GPC['perpage'] . "&autoredirect=1");
}
echo "session->vars['sessionurl'] . "do=rebuildavatars&startat=$finishat&pp=" . $vbulletin->GPC['perpage'] . '">' . $vbphrase['click_here_to_continue_processing'] . "
";
}
else
{
define('CP_REDIRECT', 'misc.php');
print_stop_message('rebuilt_avatar_thumbnails_successfully');
}
}
// ################## Start rebuilding admin avatar thumbnails ################
if ($_REQUEST['do'] == 'rebuildadminavatars')
{
$vbulletin->input->clean_array_gpc('r', array(
'autoredirect' => TYPE_BOOL,
));
if (($current_memory_limit = ini_size_to_bytes(@ini_get('memory_limit'))) < 128 * 1024 * 1024 AND $current_memory_limit > 0)
{
@ini_set('memory_limit', 128 * 1024 * 1024);
}
require_once(DIR . '/includes/class_image.php');
if ($vbulletin->options['imagetype'] != 'Magick' AND !function_exists('imagetypes'))
{
//define('CP_REDIRECT', 'misc.php');
print_stop_message('your_version_no_image_support');
}
$avatarpath = DIR . '/images/avatars/thumbs';
if (!is_writable($avatarpath))
{
print_stop_message('avatarpath_not_writable');
}
if (empty($vbulletin->GPC['perpage']))
{
$vbulletin->GPC['perpage'] = 20;
}
if (!$vbulletin->GPC['startat'])
{
$firstavatar = $db->query_first("SELECT MIN(avatarid) AS min FROM " . TABLE_PREFIX . "avatar");
$vbulletin->GPC['startat'] = intval($firstavatar['min']);
}
echo '' . construct_phrase($vbphrase['building_avatar_thumbnails'], "misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=rebuildadminavatars&startat=" . $vbulletin->GPC['startat'] . "&pp=" . $vbulletin->GPC['perpage'] . "&autoredirect=" . $vbulletin->GPC['autoredirect']) . '
';
$avatars = $db->query_read("
SELECT avatarid, avatarpath, title
FROM " . TABLE_PREFIX . "avatar
WHERE avatarid >= " . $vbulletin->GPC['startat'] . "
ORDER BY avatarid
LIMIT " . $vbulletin->GPC['perpage']
);
$finishat = $vbulletin->GPC['startat'];
while ($avatar = $db->fetch_array($avatars))
{
$finishat = ($avatar['avatarid'] > $finishat ? $avatar['avatarid'] : $finishat);
echo construct_phrase($vbphrase['processing_x'], "$vbphrase[avatar] : $avatar[avatarid] ($avatar[title])");
$imagepath = $avatar['avatarpath'];
$destination = $avatarpath . '/' . $avatar['avatarid'] . '.gif';
$remotefile = false;
if ($avatar['avatarpath'][0] == '/')
{
// absolute web path -- needs to be translated into a full path and handled that way
$avatar['avatarpath'] = create_full_url($avatar['avatarpath']);
}
if (substr($avatar['avatarpath'], 0, 7) == 'http://')
{
if ($vbulletin->options['safeupload'])
{
$imagepath = $vbulletin->options['tmppath'] . '/' . md5(uniqid(microtime()) . $avatar['avatarid']);
}
else
{
$imagepath = tempnam(ini_get('upload_tmp_dir'), 'vbthumb');
}
if ($filenum = @fopen($imagepath, 'wb'))
{
require_once(DIR . '/includes/class_vurl.php');
$vurl = new vB_vURL($vbulletin);
$vurl->set_option(VURL_URL, $avatar['avatarpath']);
$vurl->set_option(VURL_HEADER, true);
$vurl->set_option(VURL_RETURNTRANSFER, true);
if ($result = $vurl->exec())
{
@fwrite($filenum, $result['body']);
}
unset($vurl);
@fclose($filenum);
$remotefile = true;
}
}
if (!file_exists($imagepath))
{
echo " ... $vbphrase[unable_to_read_avatar]
\n";
vbflush();
continue;
}
$image =& vB_Image::fetch_library($vbulletin);
$imageinfo = $image->fetch_image_info($imagepath);
if ($imageinfo[0] > FIXED_SIZE_AVATAR_WIDTH OR $imageinfo[1] > FIXED_SIZE_AVATAR_HEIGHT)
{
$file = 'file.' . ($imageinfo[2] == 'JPEG' ? 'jpg' : strtolower($imageinfo[2]));
$thumbnail = $image->fetch_thumbnail($file, $imagepath, FIXED_SIZE_AVATAR_WIDTH, FIXED_SIZE_AVATAR_HEIGHT);
if ($thumbnail['filedata'] AND $filenum = @fopen($destination, 'wb'))
{
@fwrite($filenum, $thumbnail['filedata']);
@fclose($filenum);
}
unset($thumbnail);
}
else if ($filenum = fopen($destination, 'wb'))
{
@fwrite($filenum, file_get_contents($imagepath));
fclose($filenum);
}
if ($remotefile)
{
@unlink($imagepath);
}
echo "
\n";
vbflush();
}
$finishat++;
if ($checkmore = $db->query_first("SELECT avatarid FROM " . TABLE_PREFIX . "avatar WHERE avatarid >= $finishat LIMIT 1"))
{
if ($vbulletin->GPC['autoredirect'] == 1)
{
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=rebuildadminavatars&startat=$finishat&pp=" . $vbulletin->GPC['perpage'] . "&autoredirect=1");
}
echo "session->vars['sessionurl'] . "do=rebuildadminavatars&startat=$finishat&pp=" . $vbulletin->GPC['perpage'] . '">' . $vbphrase['click_here_to_continue_processing'] . "
";
}
else
{
define('CP_REDIRECT', 'misc.php');
print_stop_message('rebuilt_avatar_thumbnails_successfully');
}
}
// ################## Start rebuilding sgicon thumbnails ################
if ($_REQUEST['do'] == 'rebuildsgicons')
{
$vbulletin->input->clean_array_gpc('r', array(
'quality' => TYPE_UINT,
'autoredirect' => TYPE_BOOL,
'perpage' => TYPE_UINT,
'startat' => TYPE_UINT
));
// Increase memlimit
if (($memory_limit = ini_size_to_bytes(@ini_get('memory_limit'))) < 128 * 1024 * 1024 AND $memory_limit > 0)
{
@ini_set('memory_limit', 128 * 1024 * 1024);
}
// Get dimension constants
require_once(DIR . '/includes/functions_socialgroup.php');
// Get image handler
require_once(DIR . '/includes/class_image.php');
$image = vB_Image::fetch_library($vbulletin);
// Check if image manip is supported
if ($vbulletin->options['imagetype'] != 'Magick' AND !function_exists('imagetypes'))
{
print_stop_message('your_version_no_image_support');
}
$vbulletin->GPC['perpage'] = max($vbulletin->GPC['perpage'], 20);
echo '' . construct_phrase($vbphrase['building_sgicon_thumbnails'], "misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=rebuildsgicons&startat=" . $vbulletin->GPC['startat'] . "&pp=" . $vbulletin->GPC['perpage'] . "&autoredirect=" . $vbulletin->GPC['autoredirect'] . "&quality=" . $vbulletin->GPC['quality']) . '
';
// Get group info
$result = $vbulletin->db->query_read("
SELECT socialgroupicon.dateline, socialgroupicon.userid, socialgroupicon.filedata, socialgroupicon.extension,
socialgroupicon.width, socialgroupicon.height, socialgroupicon.groupid
FROM " . TABLE_PREFIX . "socialgroupicon AS socialgroupicon
LIMIT " . intval($vbulletin->GPC['startat']) . ', ' . intval($vbulletin->GPC['perpage'])
);
$checkmore = ($vbulletin->db->num_rows($result) >= $vbulletin->GPC['perpage']);
// Create dm for icon and ensure icon filedata is set but thumbdata is empty, so that thumbs are rebuilt by the dm
while ($icon = $vbulletin->db->fetch_array($result))
{
// some transaltion for group info
$icon['icondateline'] = $icon['dateline'];
echo construct_phrase($vbphrase['processing_x'], "$vbphrase[socialgroup_icon] $icon[groupid]
\n");
vbflush();
$filedata = false;
if ($vbulletin->options['usefilegroupicon'])
{
$iconpath = fetch_socialgroupicon_url($icon, false, true, true);
$thumbpath = fetch_socialgroupicon_url($group, true, true, true);
$filedata = @file_get_contents($iconpath);
}
else
{
$filedata = $icon['filedata'];
}
if ($filedata)
{
$icondm = datamanager_init('SocialGroupIcon', $vbulletin, ERRTYPE_CP);
$icondm->set_existing($icon);
$icondm->set('thumbnail_filedata', false);
$icondm->set('filedata', $filedata);
$icondm->set_info('thumbnail_quality', $vbulletin->GPC['quality']);
if (!$icondm->save())
{
echo ('' . (!empty($icondm->errors[0]) ? $icondm->errors[0] : $vbphrase['error']) . '');
}
}
}
$vbulletin->db->free_result($result);
echo '
';
vbflush();
$startat = $vbulletin->GPC['startat'] + $vbulletin->GPC['perpage'];
if ($checkmore)
{
if ($vbulletin->GPC['autoredirect'] == 1)
{
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=rebuildsgicons&startat=$startat&pp=" . $vbulletin->GPC['perpage'] . "&quality=" . $vbulletin->GPC['quality'] . "&autoredirect=1");
}
echo "session->vars['sessionurl'] . "do=rebuildsgicons&startat=$startat&pp=" . $vbulletin->GPC['perpage'] . '&quality=' . $vbulletin->GPC['quality'] . '>' . $vbphrase['click_here_to_continue_processing'] . '
';
}
else
{
// rebuild newest groups cache
fetch_socialgroup_newest_groups(true, false, !$vbulletin->options['sg_enablesocialgroupicons']);
define('CP_REDIRECT', 'misc.php');
print_stop_message('rebuilt_sgicon_thumbnails_successfully');
}
}
// ###################### Start rebuilding post cache #######################
if ($_POST['do'] == 'rebuildalbumupdates')
{
if (!$vbulletin->options['album_recentalbumdays'])
{
define('CP_REDIRECT', 'misc.php');
print_stop_message('recent_album_updates_disabled');
}
require_once(DIR . '/includes/functions_album.php');
exec_rebuild_album_updates();
define('CP_REDIRECT', 'misc.php');
print_stop_message('recent_album_updates_rebuilt');
}
// ###################### Start rebuilding post cache #######################
if ($_REQUEST['do'] == 'buildpostcache')
{
$bbcodelist = array();
$bbcodes = $db->query_read("
SELECT templateid, template
FROM " . TABLE_PREFIX . "template
WHERE title IN ('bbcode_quote', 'bbcode_php', 'bbcode_code', 'bbcode_html', 'bbcode_video')
");
while ($bbcode = $db->fetch_array($bbcodes))
{
$bbcodelist["$bbcode[templateid]"] = $bbcode['template'];
}
$stylelist = array();
//$uniquelist = array();
$styles = $db->query_read("
SELECT * FROM " . TABLE_PREFIX . "style
");
while ($style = $db->fetch_array($styles))
{
$tlist = unserialize($style['templatelist']);
$stylelist["$style[styleid]"]['templatelist'] = array(
'bbcode_code' =>& $bbcodelist["$tlist[bbcode_code]"],
'bbcode_quote' =>& $bbcodelist["$tlist[bbcode_quote]"],
'bbcode_php' =>& $bbcodelist["$tlist[bbcode_php]"],
'bbcode_html' =>& $bbcodelist["$tlist[bbcode_html]"],
'bbcode_video' =>& $bbcodelist["$tlist[bbcode_video]"],
);
$stylelist["$style[styleid]"]['idlist'] = array(
'bbcode_code' => intval($tlist['bbcode_code_styleid']),
'bbcode_quote' => intval($tlist['bbcode_quote_styleid']),
'bbcode_php' => intval($tlist['bbcode_php_styleid']),
'bbcode_html' => intval($tlist['bbcode_html_styleid']),
'bbcode_video' => intval($tlist['bbcode_video_styleid']),
);
$stylelist["$style[styleid]"]['newstylevars'] = unserialize($style['newstylevars']);
}
$stylelist["0"] =& $stylelist["{$vbulletin->options['styleid']}"];
require_once(DIR . '/includes/class_bbcode.php');
$bbcode_parser = new vB_BbCodeParser($vbulletin, fetch_tag_list());
if (empty($vbulletin->GPC['perpage']))
{
$vbulletin->GPC['perpage'] = 1000;
}
if ($vbulletin->GPC['startat'] == 0)
{
$db->query_write("TRUNCATE TABLE " . TABLE_PREFIX . "postparsed");
$firstpost = $db->query_first("SELECT MIN(postid) AS min FROM " . TABLE_PREFIX . "post");
$vbulletin->GPC['startat'] = intval($firstpost['min']);
}
echo '' . $vbphrase['building_post_cache'] . '
';
$posts = $db->query_read("
SELECT postid, forumid, pagetext, allowsmilie, thread.lastpost
FROM " . TABLE_PREFIX . "post AS post, " . TABLE_PREFIX . "thread AS thread
WHERE post.threadid = thread.threadid AND
postid >= " . $vbulletin->GPC['startat'] . " AND
thread.lastpost >= " . (TIMENOW - ($vbulletin->options['cachemaxage'] * 60 * 60 * 24)) . "
ORDER BY postid
LIMIT " . $vbulletin->GPC['perpage']
);
$finishat = $vbulletin->GPC['startat'];
$saveparsed = '';
while ($post = $db->fetch_array($posts))
{
# Only cache posts for the chosen style if this post belongs to a forum with a styleoverride
if ($vbulletin->forumcache["$post[forumid]"]['options'] & $vbulletin->bf_misc_forumoptions['styleoverride'])
{
$styleid = $vbulletin->forumcache["$post[forumid]"]['styleid'];
$vbulletin->templatecache =& $stylelist["$styleid"]['templatelist'];
// The fact that we use $userinfo here means that if you were to use any language specific stylevars in these templates (which we don't do by default), they would be of this user's language
// The only remedy for this is to create even more scenarios in the post parsed table with left -> right, right -> left and the imageoverride folder :eek:
$vbulletin->stylevars = $stylelist["$styleid"]['newstylevars'];
fetch_stylevars($stylelist["$styleid"], $vbulletin->userinfo);
$parsedtext = $bbcode_parser->parse($post['pagetext'], $post['forumid'], $post['allowsmilie'], false, '', false, true);
$saveparsed .= ", ($post[postid],
" . intval($post['lastpost']) . ",
" . intval($bbcode_parser->cached['has_images']) . ",
'" . $db->escape_string($bbcode_parser->cached['text']) . "',
" . intval($styleid) . ",
" . intval(LANGUAGEID) . "
)";
echo construct_phrase($vbphrase['processing_x'], $post['postid']) . "
\n";
}
else
{
echo construct_phrase($vbphrase['processing_x'], $post['postid']) . "\n";
$count = 0;
foreach (array_keys($stylelist) AS $styleid)
{
if ($styleid == 0)
{
continue;
}
$count++;
if ($count > 1)
{
echo ',';
}
echo " $count";
$vbulletin->templatecache =& $stylelist["$styleid"]['templatelist'];
// The fact that we use $userinfo here means that if you were to use any language specific stylevars in these templates (which we don't do by default), they would be of this user's language
// The only remedy for this is to create even more scenarios in the post parsed table with left -> right, right -> left and the imageoverride folder :eek:
$vbulletin->stylevars = $stylelist["$styleid"]['newstylevars'];
fetch_stylevars($stylelist["$styleid"], $vbulletin->userinfo);
$parsedtext = $bbcode_parser->parse($post['pagetext'], $post['forumid'], $post['allowsmilie'], false, '', false, true);
$saveparsed .= ", ($post[postid],
" . intval($post['lastpost']) . ",
" . intval($bbcode_parser->cached['has_images']) . ",
'" . $db->escape_string($bbcode_parser->cached['text']) . "',
" . intval($styleid) . ",
" . intval(LANGUAGEID) . "
)";
}
echo "
\n";
}
if (strlen($saveparsed) > 500000)
{
// break the query every 500k
$saveparsed = substr($saveparsed, 1);
/*insert query*/
$db->query_write("
REPLACE INTO " . TABLE_PREFIX . "postparsed
(postid, dateline, hasimages, pagetext_html , styleid, languageid)
VALUES
$saveparsed
");
$saveparsed = '';
}
$finishat = ($post['postid'] > $finishat ? $post['postid'] : $finishat);
}
if ($saveparsed)
{
$saveparsed = substr($saveparsed, 1);
/*insert query*/
$db->query_write("
REPLACE INTO " . TABLE_PREFIX . "postparsed
(postid, dateline, hasimages, pagetext_html , styleid, languageid)
VALUES
$saveparsed
");
}
vbflush();
$finishat++;
if ($checkmore = $db->query_first("SELECT postid FROM " . TABLE_PREFIX . "post WHERE postid >= $finishat LIMIT 1"))
{
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=buildpostcache&startat=$finishat&pp=" . $vbulletin->GPC['perpage']);
echo "session->vars['sessionurl'] . "do=buildpostcache&startat=$finishat&pp=" . $vbulletin->GPC['perpage'] . "\">" . $vbphrase['click_here_to_continue_processing'] . "
";
}
else
{
define('CP_REDIRECT', 'misc.php');
print_stop_message('updated_post_cache_successfully');
}
}
if ($_POST['do'] == 'truncatesigcache')
{
$db->query_write("TRUNCATE TABLE " . TABLE_PREFIX . "sigparsed");
define('CP_REDIRECT', 'misc.php');
print_stop_message('updated_signature_cache_successfully');
}
// ###################### Start remove dupe #######################
if ($_REQUEST['do'] == 'removedupe')
{
if (empty($vbulletin->GPC['perpage']))
{
$vbulletin->GPC['perpage'] = 500;
}
echo '' . $vbphrase['removing_duplicate_threads'] . '
';
$threads = $db->query_read("
SELECT threadid, title, forumid, postusername, dateline
FROM " . TABLE_PREFIX . "thread WHERE threadid >= " . $vbulletin->GPC['startat'] . "
ORDER BY threadid
LIMIT " . $vbulletin->GPC['perpage']
);
$finishat = $vbulletin->GPC['startat'];
while ($thread = $db->fetch_array($threads))
{
$deletethreads = $db->query_read("
SELECT *
FROM " . TABLE_PREFIX . "thread
WHERE title = '" . $db->escape_string($thread['title']) . "' AND
forumid = $thread[forumid] AND
postusername = '" . $db->escape_string($thread['postusername']) . "' AND
dateline = $thread[dateline] AND
threadid > $thread[threadid]
");
while ($deletethread = $db->fetch_array($deletethreads))
{
$threadman =& datamanager_init('Thread', $vbulletin, ERRTYPE_SILENT, 'threadpost');
$threadman->set_existing($deletethread);
$threadman->delete($vbulletin->forumcache["$deletethread[forumid]"]['options'] & $vbulletin->bf_misc_forumoptions['countposts']);
unset($threadman);
echo " ".construct_phrase($vbphrase['delete_x'], $deletethread['threadid'])."
";
}
echo construct_phrase($vbphrase['processing_x'], $thread['threadid'])."
\n";
vbflush();
$finishat = ($thread['threadid'] > $finishat ? $thread['threadid'] : $finishat);
}
$finishat++;
if ($checkmore = $db->query_first("SELECT threadid FROM " . TABLE_PREFIX . "thread WHERE threadid >= $finishat LIMIT 1"))
{
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=removedupe&startat=$finishat&pp=" . $vbulletin->GPC['perpage']);
echo "session->vars['sessionurl'] . "do=removedupe&startat=$finishat&pp=" . $vbulletin->GPC['perpage'] . "\">" . $vbphrase['click_here_to_continue_processing'] . "
";
}
else
{
define('CP_REDIRECT', 'misc.php');
print_stop_message('deleted_duplicate_threads_successfully');
}
}
// ###################### Start find lost users #######################
if ($_POST['do'] == 'lostusers')
{
$users = $db->query_read("
SELECT user.userid
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield USING(userid)
WHERE userfield.userid IS NULL
");
$userids = array();
while ($user = $db->fetch_array($users))
{
$userids[] = $user['userid'];
}
if (!empty($userids))
{
/*insert query*/
$db->query_write("INSERT INTO " . TABLE_PREFIX . "userfield (userid) VALUES (" . implode('),(', $userids) . ")");
}
$users = $db->query_read("
SELECT user.userid
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield USING(userid)
WHERE usertextfield.userid IS NULL
");
$userids = array();
while ($user = $db->fetch_array($users))
{
$userids[] = $user['userid'];
}
if (!empty($userids))
{
/*insert query*/
$db->query_write("INSERT INTO " . TABLE_PREFIX . "usertextfield (userid) VALUES (" . implode('),(', $userids) . ")");
}
define('CP_REDIRECT', 'misc.php');
print_stop_message('user_records_repaired');
}
// ###################### Start add missing keywords #######################
if ($_REQUEST['do'] == 'addmissingkeywords')
{
require_once(DIR . '/includes/functions_newpost.php');
if (empty($vbulletin->GPC['perpage']))
{
$vbulletin->GPC['perpage'] = 50;
}
$finishat = intval($vbulletin->GPC['startat']);
$threads = $db->query_read($query = "
SELECT thread.threadid, thread.taglist, thread.prefixid, thread.title, post.pagetext AS firstpost
FROM " . TABLE_PREFIX . "thread AS thread
LEFT JOIN " . TABLE_PREFIX . "post AS post ON(post.postid = thread.firstpostid)
WHERE thread.keywords IS NULL
ORDER BY threadid ASC
LIMIT " . $vbulletin->GPC['startat'] . ", " . $vbulletin->GPC['perpage'] . "
");
while ($thread = $db->fetch_array($threads))
{
$gotsome = true;
$threadinfo = fetch_threadinfo($thread['threadid']);
if (!$threadinfo)
{
$finishat++;
continue;
}
$keywords = fetch_keywords_list($threadinfo, $thread['firstpost']);
$threadman =& datamanager_init('Thread', $vbulletin, ERRTYPE_SILENT, 'threadpost');
$threadman->set_existing($threadinfo);
$threadman->set('keywords', $keywords);
$threadman->save();
unset($threadman);
echo construct_phrase($vbphrase['processing_x'], $thread['threadid'])."
\n";
vbflush();
}
if ($gotsome)
{
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=addmissingkeywords&pp=" . $vbulletin->GPC['perpage'] . "&startat=$finishat");
echo "session->vars['sessionurl'] . "do=addmissingkeywords&pp=" . $vbulletin->GPC['perpage'] . "&startat=$finishat\">" . $vbphrase['click_here_to_continue_processing'] . "
";
}
else
{
define('CP_REDIRECT', 'misc.php');
print_stop_message('added_missing_keywords_successfully');
}
}
// ###################### Start build statistics #######################
if ($_REQUEST['do'] == 'buildstats')
{
$timestamp =& $vbulletin->GPC['startat'];
$vbulletin->GPC['perpage'] = 10 * 86400;
if (empty($timestamp))
{
// this is the first page of a stat rebuild
// so let's clear out the old stats
$db->query_write("TRUNCATE TABLE " . TABLE_PREFIX . "stats");
// and select a suitable start time
$timestamp = $db->query_first("SELECT MIN(joindate) AS start FROM " . TABLE_PREFIX . "user WHERE joindate > 0");
if ($timestamp['start'] == 0 OR $timestamp['start'] < 915166800)
{ // no value found or its before 1999 lets just make it the year 2000
$timestamp['start'] = 946684800;
}
$month = date('n', $timestamp['start']);
$day = date('j', $timestamp['start']);
$year = date('Y', $timestamp['start']);
$timestamp = mktime(0, 0, 0, $month, $day, $year);
}
if ($timestamp + $vbulletin->GPC['perpage'] >= TIMENOW)
{
$endstamp = TIMENOW;
}
else
{
$endstamp = $timestamp + $vbulletin->GPC['perpage'];
}
while ($timestamp <= $endstamp)
{
// new users
$newusers = $db->query_first('SELECT COUNT(userid) AS total FROM ' . TABLE_PREFIX . 'user WHERE joindate >= ' . $timestamp . ' AND joindate < ' . ($timestamp + 86400));
// new threads
$newthreads = $db->query_first('SELECT COUNT(threadid) AS total FROM ' . TABLE_PREFIX . 'thread WHERE dateline >= ' . $timestamp . ' AND dateline < ' . ($timestamp + 86400));
// new posts
$newposts = $db->query_first('SELECT COUNT(threadid) AS total FROM ' . TABLE_PREFIX . 'post WHERE dateline >= ' . $timestamp . ' AND dateline < ' . ($timestamp + 86400));
// active users
$activeusers = $db->query_first('SELECT COUNT(userid) AS total FROM ' . TABLE_PREFIX . 'user WHERE lastactivity >= ' . $timestamp . ' AND lastactivity < ' . ($timestamp + 86400));
$inserts[] = "($timestamp, $newusers[total], $newthreads[total], $newposts[total], $activeusers[total])";
echo $vbphrase['done'] . " $timestamp
\n";
vbflush();
$timestamp += 3600 * 24;
}
if (!empty($inserts))
{
/*insert query*/
$db->query_write("
REPLACE INTO " . TABLE_PREFIX . "stats
(dateline, nuser, nthread, npost, ausers)
VALUES
" . implode(',', $inserts) . "
");
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=buildstats&startat=$timestamp");
}
else
{
define('CP_REDIRECT', 'misc.php');
print_stop_message('rebuilt_statistics_successfully');
}
}
// ###################### Start remove dupe threads #######################
if ($_REQUEST['do'] == 'removeorphanthreads')
{
if (empty($vbulletin->GPC['perpage']))
{
$vbulletin->GPC['perpage'] = 50;
}
$result = fetch_adminutil_text('orphanthread');
if ($result == 'done')
{
build_adminutil_text('orphanthread');
define('CP_REDIRECT', 'misc.php');
print_stop_message('deleted_orphan_threads_successfully');
}
else if ($result != '')
{
$threadarray = unserialize($result);
}
else
{
$threadarray = array();
// Fetch IDS
$threads = $db->query_read("
SELECT thread.threadid
FROM " . TABLE_PREFIX . "thread AS thread
LEFT JOIN " . TABLE_PREFIX . "forum AS forum USING(forumid)
WHERE forum.forumid IS NULL
");
while ($thread = $db->fetch_array($threads))
{
$threadarray[] = $thread['threadid'];
$count++;
}
}
echo '' . $vbphrase['removing_orphan_threads'] . '
';
while ($threadid = array_pop($threadarray) AND $count < $vbulletin->GPC['perpage'])
{
$threadinfo = fetch_threadinfo($threadid);
if (!$threadinfo)
{
continue;
}
$threadman =& datamanager_init('Thread', $vbulletin, ERRTYPE_SILENT, 'threadpost');
$threadman->set_existing($threadinfo);
$threadman->delete();
unset($threadman);
echo construct_phrase($vbphrase['processing_x'], $threadid)."
\n";
vbflush();
$count++;
}
if (empty($threadarray))
{
build_adminutil_text('orphanthread', 'done');
}
else
{
build_adminutil_text('orphanthread', serialize($threadarray));
}
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=removeorphanthreads&pp=" . $vbulletin->GPC['perpage']);
echo "session->vars['sessionurl'] . "do=removeorphanthreads&pp=" . $vbulletin->GPC['perpage'] . "\">" . $vbphrase['click_here_to_continue_processing'] . "
";
}
// ###################### Start remove posts #######################
if ($_REQUEST['do'] == 'removeorphanposts')
{
if (empty($vbulletin->GPC['perpage']))
{
$vbulletin->GPC['perpage'] = 50;
}
$finishat = $vbulletin->GPC['startat'] + $vbulletin->GPC['perpage'];
$posts = $db->query_read("
SELECT *
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "thread AS thread USING(threadid)
WHERE thread.threadid IS NULL
LIMIT " . $vbulletin->GPC['startat'] . ", " . $vbulletin->GPC['perpage'] . "
");
while ($post = $db->fetch_array($posts))
{
$postman =& datamanager_init('Post', $vbulletin, ERRTYPE_SILENT, 'threadpost');
$postman->set_existing($post);
$postman->delete();
unset($postman);
echo construct_phrase($vbphrase['processing_x'], $post['postid'])."
\n";
vbflush();
$gotsome = true;
}
if($gotsome)
{
print_cp_redirect("misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=removeorphanposts&pp=" . $vbulletin->GPC['perpage'] . "&startat=$finishat");
echo "session->vars['sessionurl'] . "do=removeorphanposts&pp=" . $vbulletin->GPC['perpage'] . "&startat=$finishat\">" . $vbphrase['click_here_to_continue_processing'] . "
";
}
else
{
define('CP_REDIRECT', 'misc.php');
print_stop_message('deleted_orphan_posts_successfully');
}
}
// ###################### Start remove orphaned stylevars #######################
if ($_REQUEST['do'] == 'removeorphanstylevars')
{
// Get installed products (includes any that are disabled)
$products = "'" . implode("','", array_keys($vbulletin->products)) . "'";
/* Mark any definitions that arent
part of an installed product as old */
$vbulletin->db->query_write("
UPDATE " . TABLE_PREFIX . "stylevardfn
SET styleid = IF(styleid = -1, -10, -20)
WHERE product NOT IN ($products)
");
// Zap old definitions
$vbulletin->db->query_write("
DELETE FROM " . TABLE_PREFIX . "stylevardfn
WHERE styleid IN (-10, -20)
");
// Get master stylevars that dont have a definition
$svdata = $vbulletin->db->query_read("
SELECT stylevar.stylevarid, stylevar.styleid
FROM " . TABLE_PREFIX . "stylevar AS stylevar
LEFT JOIN " . TABLE_PREFIX . "stylevardfn AS stylevardfn ON (stylevar.stylevarid = stylevardfn.stylevarid AND stylevar.styleid = stylevardfn.styleid)
WHERE
stylevar.styleid IN(-1, -2)
AND
stylevardfn.product IS NULL
");
$orphans = array();
$deletelist = array();
$masterlist = array();
// Build list, phrases will be removed later
while ($stylevar = $vbulletin->db->fetch_array($svdata))
{
$deletelist[$stylevar['styleid']][$stylevar['stylevarid']][] = $stylevar['styleid'];
$orphans[$stylevar['styleid']][] = "'" . $stylevar['stylevarid'] . "'";
}
// Zap em !
if (!empty($orphans))
{
foreach ($orphans AS $masterstyleid => $orphans2)
{
$vbulletin->db->query_write("
DELETE FROM " . TABLE_PREFIX . "stylevar
WHERE
stylevarid IN (" . implode(',', $orphans2) . ")
AND
styleid = {$masterstyleid}
");
}
}
// Get remaining stylevar data
$svdata = $db->query_read("
SELECT stylevar.stylevarid, stylevar.styleid, style.type
FROM " . TABLE_PREFIX . "stylevar AS stylevar
LEFT JOIN " . TABLE_PREFIX . "style AS style ON (style.styleid = stylevar.styleid)
");
// Generate master and delete lists
while ($svlist = $db->fetch_array($svdata))
{
$style = $svlist['styleid'];
$stylevar = $svlist['stylevarid'];
if ($style == -1 OR $style == -2)
{
$masterlist[$style][$stylevar] = true;
}
else
{
$masterstyleid = ($svlist['type'] == 'standard') ? -1 : -2;
$deletelist[$masterstyleid][$stylevar][] = $style;
}
}
// Clear valid stylevars from delete list
foreach ($deletelist AS $masterstyleid => $deletelist2)
{
foreach($deletelist2 AS $stylevar => $styles)
{
if ($masterlist[$masterstyleid][$stylevar])
{
unset($deletelist[$masterstyleid][$stylevar]);
}
}
}
require_once(DIR . '/includes/adminfunctions_template.php');
cache_styles();
$standardstyles = array(-1);
$mobilestyles = array(-2);
foreach ($stylecache AS $styleid => $style)
{
if ($style['type'] == 'mobile')
{
$mobilestyles[] = $styleid;
}
else
{
$standardstyles[] = $styleid;
}
}
$mobileids = implode(',', $mobilestyles);
$standardids = implode(',', $standardstyles);
foreach ($deletelist AS $masterstyleid => $deletelist2)
{
/* What we have left is orphaned stylevars,
so now its time to get rid of them */
foreach($deletelist2 AS $stylevar => $styles)
{
foreach($styles AS $style)
{
$rundelete = false;
if ($style == -1)
{
echo construct_phrase($vbphrase['orphan_stylevar_deleted_master'], $stylevar);
}
else if ($style == -2)
{
echo construct_phrase($vbphrase['orphan_stylevar_deleted_mobile_master'], $stylevar);
}
else
{
$rundelete = true; // We only deleted the master version earlier
echo construct_phrase($vbphrase['orphan_stylevar_deleted'], $stylevar, $style);
}
}
// Zap stylevar
if ($rundelete)
{
$db->query_write("
DELETE FROM " . TABLE_PREFIX . "stylevar
WHERE
stylevarid = '$stylevar'
AND
styleid IN (" . ($masterstyleid == -1 ? $standardids : $mobileids) . ")
");
}
$name = "stylevar_{$stylevar}_name" . ($masterstyleid == -1) ? '' : '_mobile';
$desc = "stylevar_{$stylevar}_description" . ($masterstyleid == -1) ? '' : '_mobile';
// Zap phrases
$db->query_write("
DELETE FROM " . TABLE_PREFIX . "phrase
WHERE fieldname = 'style' AND varname
IN ('" . $db->escape_string($name) . "', '" . $db->escape_string($desc) . "')
");
}
}
// Rebuild languages
require_once(DIR . '/includes/adminfunctions_language.php');
build_language();
// define('CP_REDIRECT', 'misc.php'); // removed for now so the list stays visible.
print_stop_message('deleted_orphan_stylevars_successfully');
}
// ###################### Anonymous Survey Code #######################
if ($_REQUEST['do'] == 'survey')
{
// first we'd like extra phrase groups from the cphome
fetch_phrase_group('cphome');
/*
All the functions are prefixed with @ to supress errors, this allows us to get feedback from hosts which have almost everything
useful disabled
*/
// What operating system is the webserver running
$os = @php_uname('s');
// Using 32bit or 64bit
$architecture = @php_uname('m');//php_uname('r') . ' ' . php_uname('v') . ' ' . //;
// Webserver Signature
$web_server = $_SERVER['SERVER_SOFTWARE'];
// PHP Web Server Interface
$sapi_name = @php_sapi_name();
// If Apache is used, what sort of modules, mod_security?
if (function_exists('apache_get_modules'))
{
$apache_modules = @apache_get_modules();
}
else
{
$apache_modules = null;
}
// Check to see if a recent version is being used
$php = PHP_VERSION;
// Check for common PHP Extensions
$php_extensions = @get_loaded_extensions();
// Various configuration options regarding PHP
$php_safe_mode = SAFEMODE ? $vbphrase['on'] : $vbphrase['off'];
$php_open_basedir = ((($bd = @ini_get('open_basedir')) AND $bd != '/') ? $vbphrase['on'] : $vbphrase['off']);
$php_memory_limit = ((function_exists('memory_get_usage') AND ($limit = @ini_get('memory_limit'))) ? htmlspecialchars($limit) : $vbphrase['off']);
// what version of MySQL
$mysql = $db->query_first("SELECT VERSION() AS version");
$mysql = $mysql['version'];
// Post count
$posts = $db->query_first("SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . "post");
$posts = $posts['total'];
// User Count
$users = $db->query_first("SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . "user");
$users = $users['total'];
// Forum Count
$forums = $db->query_first("SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . "forum");
$forums = $forums['total'];
// Usergroup Count
$usergroups = $db->query_first("SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . "usergroup");
$usergroups = $usergroups['total'];
// First Forum Post
$firstpost = $db->query_first("SELECT MIN(dateline) AS firstpost FROM " . TABLE_PREFIX . "post");
$firstpost = $firstpost['firstpost'];
// Last upgrade performed
$lastupgrade = $db->query_first("SELECT MAX(dateline) AS lastdate FROM " . TABLE_PREFIX . "upgradelog");
$lastupgrade = $lastupgrade['lastdate'];
// percentage of users not using linear mode
$nonlinear = $db->query_first("SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . "user WHERE threadedmode <> 0");
$nonlinear = number_format(100 * ($nonlinear['total'] / $users), 2, '.', '');
// character sets in use within all languages
$charsets_result = $db->query_read("SELECT DISTINCT charset AS charset FROM " . TABLE_PREFIX . "language");
$charsets = array();
while ($charset = $db->fetch_array($charsets_result))
{
$charset_name = trim(htmlspecialchars($charset['charset']));
if ($charset_name != '')
{
$charsets["$charset_name"] = $charset_name;
}
}
$db->free_result($charsets_result);
?>