1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720 |
- <?php
- /**
- * Forum maintenance. Important stuff.
- *
- * Simple Machines Forum (SMF)
- *
- * @package SMF
- * @author Simple Machines http://www.simplemachines.org
- * @copyright 2011 Simple Machines
- * @license http://www.simplemachines.org/about/smf/license.php BSD
- *
- * @version 2.0
- */
- if (!defined('SMF'))
- die('Hacking attempt...');
- /**
- * Main dispatcher, the maintenance access point.
- * This, as usual, checks permissions, loads language files, and forwards to the actual workers.
- */
- function ManageMaintenance()
- {
- global $txt, $modSettings, $scripturl, $context, $options;
- // You absolutely must be an admin by here!
- isAllowedTo('admin_forum');
- // Need something to talk about?
- loadLanguage('ManageMaintenance');
- loadTemplate('ManageMaintenance');
- // This uses admin tabs - as it should!
- $context[$context['admin_menu_name']]['tab_data'] = array(
- 'title' => $txt['maintain_title'],
- 'description' => $txt['maintain_info'],
- 'tabs' => array(
- 'routine' => array(),
- 'database' => array(),
- 'members' => array(),
- 'topics' => array(),
- ),
- );
- // So many things you can do - but frankly I won't let you - just these!
- $subActions = array(
- 'routine' => array(
- 'function' => 'MaintainRoutine',
- 'template' => 'maintain_routine',
- 'activities' => array(
- 'version' => 'VersionDetail',
- 'repair' => 'MaintainFindFixErrors',
- 'recount' => 'AdminBoardRecount',
- 'logs' => 'MaintainEmptyUnimportantLogs',
- 'cleancache' => 'MaintainCleanCache',
- ),
- ),
- 'database' => array(
- 'function' => 'MaintainDatabase',
- 'template' => 'maintain_database',
- 'activities' => array(
- 'optimize' => 'OptimizeTables',
- 'backup' => 'MaintainDownloadBackup',
- 'convertentities' => 'ConvertEntities',
- 'convertutf8' => 'ConvertUtf8',
- ),
- ),
- 'members' => array(
- 'function' => 'MaintainMembers',
- 'template' => 'maintain_members',
- 'activities' => array(
- 'reattribute' => 'MaintainReattributePosts',
- 'purgeinactive' => 'MaintainPurgeInactiveMembers',
- ),
- ),
- 'topics' => array(
- 'function' => 'MaintainTopics',
- 'template' => 'maintain_topics',
- 'activities' => array(
- 'massmove' => 'MaintainMassMoveTopics',
- 'pruneold' => 'MaintainRemoveOldPosts',
- ),
- ),
- 'destroy' => array(
- 'function' => 'Destroy',
- 'activities' => array(),
- ),
- );
- // Yep, sub-action time!
- if (isset($_REQUEST['sa']) && isset($subActions[$_REQUEST['sa']]))
- $subAction = $_REQUEST['sa'];
- else
- $subAction = 'routine';
- // Doing something special?
- if (isset($_REQUEST['activity']) && isset($subActions[$subAction]['activities'][$_REQUEST['activity']]))
- $activity = $_REQUEST['activity'];
- // Set a few things.
- $context['page_title'] = $txt['maintain_title'];
- $context['sub_action'] = $subAction;
- $context['sub_template'] = !empty($subActions[$subAction]['template']) ? $subActions[$subAction]['template'] : '';
- // Finally fall through to what we are doing.
- $subActions[$subAction]['function']();
- // Any special activity?
- if (isset($activity))
- $subActions[$subAction]['activities'][$activity]();
- //converted to UTF-8? show a small maintenance info
- if (isset($_GET['done']) && $_GET['done'] == 'convertutf8')
- $context['maintenance_finished'] = $txt['utf8_title'];
- }
- /**
- * Supporting function for the database maintenance area.
- */
- function MaintainDatabase()
- {
- global $context, $db_type, $db_character_set, $modSettings, $smcFunc, $txt;
- // Show some conversion options?
- $context['convert_utf8'] = $db_type == 'mysql' && (!isset($db_character_set) || $db_character_set !== 'utf8' || empty($modSettings['global_character_set']) || $modSettings['global_character_set'] !== 'UTF-8') && version_compare('4.1.2', preg_replace('~\-.+?$~', '', $smcFunc['db_server_info']())) <= 0;
- $context['convert_entities'] = $db_type == 'mysql' && isset($db_character_set, $modSettings['global_character_set']) && $db_character_set === 'utf8' && $modSettings['global_character_set'] === 'UTF-8';
- if (isset($_GET['done']) && $_GET['done'] == 'convertutf8')
- $context['maintenance_finished'] = $txt['utf8_title'];
- if (isset($_GET['done']) && $_GET['done'] == 'convertentities')
- $context['maintenance_finished'] = $txt['entity_convert_title'];
- }
- /**
- * Supporting function for the routine maintenance area.
- */
- function MaintainRoutine()
- {
- global $context, $txt;
- if (isset($_GET['done']) && $_GET['done'] == 'recount')
- $context['maintenance_finished'] = $txt['maintain_recount'];
- }
- /**
- * Supporting function for the members maintenance area.
- */
- function MaintainMembers()
- {
- global $context, $smcFunc, $txt;
- // Get membergroups - for deleting members and the like.
- $result = $smcFunc['db_query']('', '
- SELECT id_group, group_name
- FROM {db_prefix}membergroups',
- array(
- )
- );
- $context['membergroups'] = array(
- array(
- 'id' => 0,
- 'name' => $txt['maintain_members_ungrouped']
- ),
- );
- while ($row = $smcFunc['db_fetch_assoc']($result))
- {
- $context['membergroups'][] = array(
- 'id' => $row['id_group'],
- 'name' => $row['group_name']
- );
- }
- $smcFunc['db_free_result']($result);
- }
- /**
- * Supporting function for the topics maintenance area.
- */
- function MaintainTopics()
- {
- global $context, $smcFunc, $txt;
- // Let's load up the boards in case they are useful.
- $result = $smcFunc['db_query']('order_by_board_order', '
- SELECT b.id_board, b.name, b.child_level, c.name AS cat_name, c.id_cat
- FROM {db_prefix}boards AS b
- LEFT JOIN {db_prefix}categories AS c ON (c.id_cat = b.id_cat)
- WHERE {query_see_board}
- AND redirect = {string:blank_redirect}',
- array(
- 'blank_redirect' => '',
- )
- );
- $context['categories'] = array();
- while ($row = $smcFunc['db_fetch_assoc']($result))
- {
- if (!isset($context['categories'][$row['id_cat']]))
- $context['categories'][$row['id_cat']] = array(
- 'name' => $row['cat_name'],
- 'boards' => array()
- );
- $context['categories'][$row['id_cat']]['boards'][] = array(
- 'id' => $row['id_board'],
- 'name' => $row['name'],
- 'child_level' => $row['child_level']
- );
- }
- $smcFunc['db_free_result']($result);
- if (isset($_GET['done']) && $_GET['done'] == 'purgeold')
- $context['maintenance_finished'] = $txt['maintain_old'];
- elseif (isset($_GET['done']) && $_GET['done'] == 'massmove')
- $context['maintenance_finished'] = $txt['move_topics_maintenance'];
- }
- /**
- * Find and fix all errors on the forum.
- */
- function MaintainFindFixErrors()
- {
- global $sourcedir;
- require_once($sourcedir . '/RepairBoards.php');
- RepairBoards();
- }
- /**
- * Wipes the whole cache directory.
- * This only applies to SMF's own cache directory, though.
- */
- function MaintainCleanCache()
- {
- global $context, $txt;
- // Just wipe the whole cache directory!
- clean_cache();
- $context['maintenance_finished'] = $txt['maintain_cache'];
- }
- /**
- * Empties all uninmportant logs
- */
- function MaintainEmptyUnimportantLogs()
- {
- global $context, $smcFunc, $txt;
- checkSession();
- // No one's online now.... MUHAHAHAHA :P.
- $smcFunc['db_query']('', '
- DELETE FROM {db_prefix}log_online');
- // Dump the banning logs.
- $smcFunc['db_query']('', '
- DELETE FROM {db_prefix}log_banned');
- // Start id_error back at 0 and dump the error log.
- $smcFunc['db_query']('truncate_table', '
- TRUNCATE {db_prefix}log_errors');
- // Clear out the spam log.
- $smcFunc['db_query']('', '
- DELETE FROM {db_prefix}log_floodcontrol');
- // Clear out the karma actions.
- $smcFunc['db_query']('', '
- DELETE FROM {db_prefix}log_karma');
- // Last but not least, the search logs!
- $smcFunc['db_query']('truncate_table', '
- TRUNCATE {db_prefix}log_search_topics');
- $smcFunc['db_query']('truncate_table', '
- TRUNCATE {db_prefix}log_search_messages');
- $smcFunc['db_query']('truncate_table', '
- TRUNCATE {db_prefix}log_search_results');
- updateSettings(array('search_pointer' => 0));
- $context['maintenance_finished'] = $txt['maintain_logs'];
- }
- // Oh noes!
- function Destroy()
- {
- global $context;
- echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml"', $context['right_to_left'] ? ' dir="rtl"' : '', '><head><title>', $context['forum_name_html_safe'], ' deleted!</title></head>
- <body style="background-color: orange; font-family: arial, sans-serif; text-align: center;">
- <div style="margin-top: 8%; font-size: 400%; color: black;">Oh my, you killed ', $context['forum_name_html_safe'], '!</div>
- <div style="margin-top: 7%; font-size: 500%; color: red;"><strong>You lazy bum!</strong></div>
- </body></html>';
- obExit(false);
- }
- /**
- * Convert both data and database tables to UTF-8 character set.
- * It requires the admin_forum permission.
- * This only works if UTF-8 is not the global character set.
- * It supports all character sets used by SMF's language files.
- * It redirects to ?action=admin;area=maintain after finishing.
- * This action is linked from the maintenance screen (if it's applicable).
- * Accessed by ?action=admin;area=maintain;sa=database;activity=convertutf8.
- *
- * @uses the convert_utf8 sub template of the Admin template.
- */
- function ConvertUtf8()
- {
- global $scripturl, $context, $txt, $language, $db_character_set;
- global $modSettings, $user_info, $sourcedir, $smcFunc, $db_prefix;
- // Show me your badge!
- isAllowedTo('admin_forum');
- // The character sets used in SMF's language files with their db equivalent.
- $charsets = array(
- // Chinese-traditional.
- 'big5' => 'big5',
- // Chinese-simplified.
- 'gbk' => 'gbk',
- // West European.
- 'ISO-8859-1' => 'latin1',
- // Romanian.
- 'ISO-8859-2' => 'latin2',
- // Turkish.
- 'ISO-8859-9' => 'latin5',
- // West European with Euro sign.
- 'ISO-8859-15' => 'latin9',
- // Thai.
- 'tis-620' => 'tis620',
- // Persian, Chinese, etc.
- 'UTF-8' => 'utf8',
- // Russian.
- 'windows-1251' => 'cp1251',
- // Greek.
- 'windows-1253' => 'utf8',
- // Hebrew.
- 'windows-1255' => 'utf8',
- // Arabic.
- 'windows-1256' => 'cp1256',
- );
- // Get a list of character sets supported by your MySQL server.
- $request = $smcFunc['db_query']('', '
- SHOW CHARACTER SET',
- array(
- )
- );
- $db_charsets = array();
- while ($row = $smcFunc['db_fetch_assoc']($request))
- $db_charsets[] = $row['Charset'];
- $smcFunc['db_free_result']($request);
- // Character sets supported by both MySQL and SMF's language files.
- $charsets = array_intersect($charsets, $db_charsets);
- // This is for the first screen telling backups is good.
- if (!isset($_POST['proceed']))
- {
- // Character set conversions are only supported as of MySQL 4.1.2.
- if (version_compare('4.1.2', preg_replace('~\-.+?$~', '', $smcFunc['db_server_info']())) > 0)
- fatal_lang_error('utf8_db_version_too_low');
- // Use the messages.body column as indicator for the database charset.
- $request = $smcFunc['db_query']('', '
- SHOW FULL COLUMNS
- FROM {db_prefix}messages
- LIKE {string:body_like}',
- array(
- 'body_like' => 'body',
- )
- );
- $column_info = $smcFunc['db_fetch_assoc']($request);
- $smcFunc['db_free_result']($request);
- // A collation looks like latin1_swedish. We only need the character set.
- list($context['database_charset']) = explode('_', $column_info['Collation']);
- $context['database_charset'] = in_array($context['database_charset'], $charsets) ? array_search($context['database_charset'], $charsets) : $context['database_charset'];
- // No need to convert to UTF-8 if it already is.
- if ($db_character_set === 'utf8' && !empty($modSettings['global_character_set']) && $modSettings['global_character_set'] === 'UTF-8')
- fatal_lang_error('utf8_already_utf8');
- // Cannot do conversion if using a fulltext index
- if (!empty($modSettings['search_index']) && $modSettings['search_index'] == 'fulltext')
- fatal_lang_error('utf8_cannot_convert_fulltext');
- // Grab the character set from the default language file.
- loadLanguage('index', $language, true);
- $context['charset_detected'] = $txt['lang_character_set'];
- $context['charset_about_detected'] = sprintf($txt['utf8_detected_charset'], $language, $context['charset_detected']);
- // Go back to your own language.
- loadLanguage('index', $user_info['language'], true);
- // Show a warning if the character set seems not to be supported.
- if (!isset($charsets[strtr(strtolower($context['charset_detected']), array('utf' => 'UTF', 'iso' => 'ISO'))]))
- {
- $context['charset_warning'] = sprintf($txt['utf8_charset_not_supported'], $txt['lang_character_set']);
- // Default to ISO-8859-1.
- $context['charset_detected'] = 'ISO-8859-1';
- }
- $context['charset_list'] = array_keys($charsets);
- $context['page_title'] = $txt['utf8_title'];
- $context['sub_template'] = 'convert_utf8';
- return;
- }
- // After this point we're starting the conversion. But first: session check.
- checkSession();
- // Translation table for the character sets not native for MySQL.
- $translation_tables = array(
- 'windows-1255' => array(
- '0x81' => '\'\'', '0x8A' => '\'\'', '0x8C' => '\'\'',
- '0x8D' => '\'\'', '0x8E' => '\'\'', '0x8F' => '\'\'',
- '0x90' => '\'\'', '0x9A' => '\'\'', '0x9C' => '\'\'',
- '0x9D' => '\'\'', '0x9E' => '\'\'', '0x9F' => '\'\'',
- '0xCA' => '\'\'', '0xD9' => '\'\'', '0xDA' => '\'\'',
- '0xDB' => '\'\'', '0xDC' => '\'\'', '0xDD' => '\'\'',
- '0xDE' => '\'\'', '0xDF' => '\'\'', '0xFB' => '\'\'',
- '0xFC' => '\'\'', '0xFF' => '\'\'', '0xC2' => '0xFF',
- '0x80' => '0xFC', '0xE2' => '0xFB', '0xA0' => '0xC2A0',
- '0xA1' => '0xC2A1', '0xA2' => '0xC2A2', '0xA3' => '0xC2A3',
- '0xA5' => '0xC2A5', '0xA6' => '0xC2A6', '0xA7' => '0xC2A7',
- '0xA8' => '0xC2A8', '0xA9' => '0xC2A9', '0xAB' => '0xC2AB',
- '0xAC' => '0xC2AC', '0xAD' => '0xC2AD', '0xAE' => '0xC2AE',
- '0xAF' => '0xC2AF', '0xB0' => '0xC2B0', '0xB1' => '0xC2B1',
- '0xB2' => '0xC2B2', '0xB3' => '0xC2B3', '0xB4' => '0xC2B4',
- '0xB5' => '0xC2B5', '0xB6' => '0xC2B6', '0xB7' => '0xC2B7',
- '0xB8' => '0xC2B8', '0xB9' => '0xC2B9', '0xBB' => '0xC2BB',
- '0xBC' => '0xC2BC', '0xBD' => '0xC2BD', '0xBE' => '0xC2BE',
- '0xBF' => '0xC2BF', '0xD7' => '0xD7B3', '0xD1' => '0xD781',
- '0xD4' => '0xD7B0', '0xD5' => '0xD7B1', '0xD6' => '0xD7B2',
- '0xE0' => '0xD790', '0xEA' => '0xD79A', '0xEC' => '0xD79C',
- '0xED' => '0xD79D', '0xEE' => '0xD79E', '0xEF' => '0xD79F',
- '0xF0' => '0xD7A0', '0xF1' => '0xD7A1', '0xF2' => '0xD7A2',
- '0xF3' => '0xD7A3', '0xF5' => '0xD7A5', '0xF6' => '0xD7A6',
- '0xF7' => '0xD7A7', '0xF8' => '0xD7A8', '0xF9' => '0xD7A9',
- '0x82' => '0xE2809A', '0x84' => '0xE2809E', '0x85' => '0xE280A6',
- '0x86' => '0xE280A0', '0x87' => '0xE280A1', '0x89' => '0xE280B0',
- '0x8B' => '0xE280B9', '0x93' => '0xE2809C', '0x94' => '0xE2809D',
- '0x95' => '0xE280A2', '0x97' => '0xE28094', '0x99' => '0xE284A2',
- '0xC0' => '0xD6B0', '0xC1' => '0xD6B1', '0xC3' => '0xD6B3',
- '0xC4' => '0xD6B4', '0xC5' => '0xD6B5', '0xC6' => '0xD6B6',
- '0xC7' => '0xD6B7', '0xC8' => '0xD6B8', '0xC9' => '0xD6B9',
- '0xCB' => '0xD6BB', '0xCC' => '0xD6BC', '0xCD' => '0xD6BD',
- '0xCE' => '0xD6BE', '0xCF' => '0xD6BF', '0xD0' => '0xD780',
- '0xD2' => '0xD782', '0xE3' => '0xD793', '0xE4' => '0xD794',
- '0xE5' => '0xD795', '0xE7' => '0xD797', '0xE9' => '0xD799',
- '0xFD' => '0xE2808E', '0xFE' => '0xE2808F', '0x92' => '0xE28099',
- '0x83' => '0xC692', '0xD3' => '0xD783', '0x88' => '0xCB86',
- '0x98' => '0xCB9C', '0x91' => '0xE28098', '0x96' => '0xE28093',
- '0xBA' => '0xC3B7', '0x9B' => '0xE280BA', '0xAA' => '0xC397',
- '0xA4' => '0xE282AA', '0xE1' => '0xD791', '0xE6' => '0xD796',
- '0xE8' => '0xD798', '0xEB' => '0xD79B', '0xF4' => '0xD7A4',
- '0xFA' => '0xD7AA', '0xFF' => '0xD6B2', '0xFC' => '0xE282AC',
- '0xFB' => '0xD792',
- ),
- 'windows-1253' => array(
- '0x81' => '\'\'', '0x88' => '\'\'', '0x8A' => '\'\'',
- '0x8C' => '\'\'', '0x8D' => '\'\'', '0x8E' => '\'\'',
- '0x8F' => '\'\'', '0x90' => '\'\'', '0x98' => '\'\'',
- '0x9A' => '\'\'', '0x9C' => '\'\'', '0x9D' => '\'\'',
- '0x9E' => '\'\'', '0x9F' => '\'\'', '0xAA' => '\'\'',
- '0xD2' => '\'\'', '0xFF' => '\'\'', '0xCE' => '0xCE9E',
- '0xB8' => '0xCE88', '0xBA' => '0xCE8A', '0xBC' => '0xCE8C',
- '0xBE' => '0xCE8E', '0xBF' => '0xCE8F', '0xC0' => '0xCE90',
- '0xC8' => '0xCE98', '0xCA' => '0xCE9A', '0xCC' => '0xCE9C',
- '0xCD' => '0xCE9D', '0xCF' => '0xCE9F', '0xDA' => '0xCEAA',
- '0xE8' => '0xCEB8', '0xEA' => '0xCEBA', '0xEC' => '0xCEBC',
- '0xEE' => '0xCEBE', '0xEF' => '0xCEBF', '0xC2' => '0xFF',
- '0xBD' => '0xC2BD', '0xED' => '0xCEBD', '0xB2' => '0xC2B2',
- '0xA0' => '0xC2A0', '0xA3' => '0xC2A3', '0xA4' => '0xC2A4',
- '0xA5' => '0xC2A5', '0xA6' => '0xC2A6', '0xA7' => '0xC2A7',
- '0xA8' => '0xC2A8', '0xA9' => '0xC2A9', '0xAB' => '0xC2AB',
- '0xAC' => '0xC2AC', '0xAD' => '0xC2AD', '0xAE' => '0xC2AE',
- '0xB0' => '0xC2B0', '0xB1' => '0xC2B1', '0xB3' => '0xC2B3',
- '0xB5' => '0xC2B5', '0xB6' => '0xC2B6', '0xB7' => '0xC2B7',
- '0xBB' => '0xC2BB', '0xE2' => '0xCEB2', '0x80' => '0xD2',
- '0x82' => '0xE2809A', '0x84' => '0xE2809E', '0x85' => '0xE280A6',
- '0x86' => '0xE280A0', '0xA1' => '0xCE85', '0xA2' => '0xCE86',
- '0x87' => '0xE280A1', '0x89' => '0xE280B0', '0xB9' => '0xCE89',
- '0x8B' => '0xE280B9', '0x91' => '0xE28098', '0x99' => '0xE284A2',
- '0x92' => '0xE28099', '0x93' => '0xE2809C', '0x94' => '0xE2809D',
- '0x95' => '0xE280A2', '0x96' => '0xE28093', '0x97' => '0xE28094',
- '0x9B' => '0xE280BA', '0xAF' => '0xE28095', '0xB4' => '0xCE84',
- '0xC1' => '0xCE91', '0xC3' => '0xCE93', '0xC4' => '0xCE94',
- '0xC5' => '0xCE95', '0xC6' => '0xCE96', '0x83' => '0xC692',
- '0xC7' => '0xCE97', '0xC9' => '0xCE99', '0xCB' => '0xCE9B',
- '0xD0' => '0xCEA0', '0xD1' => '0xCEA1', '0xD3' => '0xCEA3',
- '0xD4' => '0xCEA4', '0xD5' => '0xCEA5', '0xD6' => '0xCEA6',
- '0xD7' => '0xCEA7', '0xD8' => '0xCEA8', '0xD9' => '0xCEA9',
- '0xDB' => '0xCEAB', '0xDC' => '0xCEAC', '0xDD' => '0xCEAD',
- '0xDE' => '0xCEAE', '0xDF' => '0xCEAF', '0xE0' => '0xCEB0',
- '0xE1' => '0xCEB1', '0xE3' => '0xCEB3', '0xE4' => '0xCEB4',
- '0xE5' => '0xCEB5', '0xE6' => '0xCEB6', '0xE7' => '0xCEB7',
- '0xE9' => '0xCEB9', '0xEB' => '0xCEBB', '0xF0' => '0xCF80',
- '0xF1' => '0xCF81', '0xF2' => '0xCF82', '0xF3' => '0xCF83',
- '0xF4' => '0xCF84', '0xF5' => '0xCF85', '0xF6' => '0xCF86',
- '0xF7' => '0xCF87', '0xF8' => '0xCF88', '0xF9' => '0xCF89',
- '0xFA' => '0xCF8A', '0xFB' => '0xCF8B', '0xFC' => '0xCF8C',
- '0xFD' => '0xCF8D', '0xFE' => '0xCF8E', '0xFF' => '0xCE92',
- '0xD2' => '0xE282AC',
- ),
- );
- // Make some preparations.
- if (isset($translation_tables[$_POST['src_charset']]))
- {
- $replace = '%field%';
- foreach ($translation_tables[$_POST['src_charset']] as $from => $to)
- $replace = 'REPLACE(' . $replace . ', ' . $from . ', ' . $to . ')';
- }
- // Grab a list of tables.
- if (preg_match('~^`(.+?)`\.(.+?)$~', $db_prefix, $match) === 1)
- $queryTables = $smcFunc['db_query']('', '
- SHOW TABLE STATUS
- FROM `' . strtr($match[1], array('`' => '')) . '`
- LIKE {string:table_name}',
- array(
- 'table_name' => str_replace('_', '\_', $match[2]) . '%',
- )
- );
- else
- $queryTables = $smcFunc['db_query']('', '
- SHOW TABLE STATUS
- LIKE {string:table_name}',
- array(
- 'table_name' => str_replace('_', '\_', $db_prefix) . '%',
- )
- );
- while ($table_info = $smcFunc['db_fetch_assoc']($queryTables))
- {
- // Just to make sure it doesn't time out.
- if (function_exists('apache_reset_timeout'))
- @apache_reset_timeout();
- $table_charsets = array();
- // Loop through each column.
- $queryColumns = $smcFunc['db_query']('', '
- SHOW FULL COLUMNS
- FROM ' . $table_info['Name'],
- array(
- )
- );
- while ($column_info = $smcFunc['db_fetch_assoc']($queryColumns))
- {
- // Only text'ish columns have a character set and need converting.
- if (strpos($column_info['Type'], 'text') !== false || strpos($column_info['Type'], 'char') !== false)
- {
- $collation = empty($column_info['Collation']) || $column_info['Collation'] === 'NULL' ? $table_info['Collation'] : $column_info['Collation'];
- if (!empty($collation) && $collation !== 'NULL')
- {
- list($charset) = explode('_', $collation);
- if (!isset($table_charsets[$charset]))
- $table_charsets[$charset] = array();
- $table_charsets[$charset][] = $column_info;
- }
- }
- }
- $smcFunc['db_free_result']($queryColumns);
- // Only change the column if the data doesn't match the current charset.
- if ((count($table_charsets) === 1 && key($table_charsets) !== $charsets[$_POST['src_charset']]) || count($table_charsets) > 1)
- {
- $updates_blob = '';
- $updates_text = '';
- foreach ($table_charsets as $charset => $columns)
- {
- if ($charset !== $charsets[$_POST['src_charset']])
- {
- foreach ($columns as $column)
- {
- $updates_blob .= '
- CHANGE COLUMN ' . $column['Field'] . ' ' . $column['Field'] . ' ' . strtr($column['Type'], array('text' => 'blob', 'char' => 'binary')) . ($column['Null'] === 'YES' ? ' NULL' : ' NOT NULL') . (strpos($column['Type'], 'char') === false ? '' : ' default \'' . $column['Default'] . '\'') . ',';
- $updates_text .= '
- CHANGE COLUMN ' . $column['Field'] . ' ' . $column['Field'] . ' ' . $column['Type'] . ' CHARACTER SET ' . $charsets[$_POST['src_charset']] . ($column['Null'] === 'YES' ? '' : ' NOT NULL') . (strpos($column['Type'], 'char') === false ? '' : ' default \'' . $column['Default'] . '\'') . ',';
- }
- }
- }
- // Change the columns to binary form.
- $smcFunc['db_query']('', '
- ALTER TABLE {raw:table_name}{raw:updates_blob}',
- array(
- 'table_name' => $table_info['Name'],
- 'updates_blob' => substr($updates_blob, 0, -1),
- )
- );
- // Convert the character set if MySQL has no native support for it.
- if (isset($translation_tables[$_POST['src_charset']]))
- {
- $update = '';
- foreach ($table_charsets as $charset => $columns)
- foreach ($columns as $column)
- $update .= '
- ' . $column['Field'] . ' = ' . strtr($replace, array('%field%' => $column['Field'])) . ',';
- $smcFunc['db_query']('', '
- UPDATE {raw:table_name}
- SET {raw:updates}',
- array(
- 'table_name' => $table_info['Name'],
- 'updates' => substr($update, 0, -1),
- )
- );
- }
- // Change the columns back, but with the proper character set.
- $smcFunc['db_query']('', '
- ALTER TABLE {raw:table_name}{raw:updates_text}',
- array(
- 'table_name' => $table_info['Name'],
- 'updates_text' => substr($updates_text, 0, -1),
- )
- );
- }
- // Now do the actual conversion (if still needed).
- if ($charsets[$_POST['src_charset']] !== 'utf8')
- $smcFunc['db_query']('', '
- ALTER TABLE {raw:table_name}
- CONVERT TO CHARACTER SET utf8',
- array(
- 'table_name' => $table_info['Name'],
- )
- );
- }
- $smcFunc['db_free_result']($queryTables);
- // Let the settings know we have a new character set.
- updateSettings(array('global_character_set' => 'UTF-8', 'previousCharacterSet' => (empty($translation_tables[$_POST['src_charset']])) ? $charsets[$_POST['src_charset']] : $translation_tables[$_POST['src_charset']]));
- // Store it in Settings.php too because it's needed before db connection.
- require_once($sourcedir . '/Subs-Admin.php');
- updateSettingsFile(array('db_character_set' => '\'utf8\''));
- // The conversion might have messed up some serialized strings. Fix them!
- require_once($sourcedir . '/Subs-Charset.php');
- fix_serialized_columns();
- redirectexit('action=admin;area=maintain;done=convertutf8');
- }
- /**
- * Converts HTML-entities to their UTF-8 character equivalents.
- * This requires the admin_forum permission.
- * Pre-condition: UTF-8 has been set as database and global character set.
- *
- * It is divided in steps of 10 seconds.
- * This action is linked from the maintenance screen (if applicable).
- * It is accessed by ?action=admin;area=maintain;sa=database;activity=convertentities.
- *
- * @uses Admin template, convert_entities sub-template.
- */
- function ConvertEntities()
- {
- global $db_character_set, $modSettings, $context, $sourcedir, $smcFunc;
- isAllowedTo('admin_forum');
- // Check to see if UTF-8 is currently the default character set.
- if ($modSettings['global_character_set'] !== 'UTF-8' || !isset($db_character_set) || $db_character_set !== 'utf8')
- fatal_lang_error('entity_convert_only_utf8');
- // Some starting values.
- $context['table'] = empty($_REQUEST['table']) ? 0 : (int) $_REQUEST['table'];
- $context['start'] = empty($_REQUEST['start']) ? 0 : (int) $_REQUEST['start'];
- $context['start_time'] = time();
- $context['first_step'] = !isset($_REQUEST[$context['session_var']]);
- $context['last_step'] = false;
- // The first step is just a text screen with some explanation.
- if ($context['first_step'])
- {
- $context['sub_template'] = 'convert_entities';
- return;
- }
- // Otherwise use the generic "not done" template.
- $context['sub_template'] = 'not_done';
- $context['continue_post_data'] = '';
- $context['continue_countdown'] = 3;
- // Now we're actually going to convert...
- checkSession('request');
- // A list of tables ready for conversion.
- $tables = array(
- 'ban_groups',
- 'ban_items',
- 'boards',
- 'calendar',
- 'calendar_holidays',
- 'categories',
- 'log_errors',
- 'log_search_subjects',
- 'membergroups',
- 'members',
- 'message_icons',
- 'messages',
- 'package_servers',
- 'personal_messages',
- 'pm_recipients',
- 'polls',
- 'poll_choices',
- 'smileys',
- 'themes',
- );
- $context['num_tables'] = count($tables);
- // This function will do the conversion later on.
- $entity_replace = create_function('$string', '
- $num = substr($string, 0, 1) === \'x\' ? hexdec(substr($string, 1)) : (int) $string;
- return $num < 0x20 || $num > 0x10FFFF || ($num >= 0xD800 && $num <= 0xDFFF) ? \'\' : ($num < 0x80 ? \'&#\' . $num . \';\' : ($num < 0x800 ? chr(192 | $num >> 6) . chr(128 | $num & 63) : ($num < 0x10000 ? chr(224 | $num >> 12) . chr(128 | $num >> 6 & 63) . chr(128 | $num & 63) : chr(240 | $num >> 18) . chr(128 | $num >> 12 & 63) . chr(128 | $num >> 6 & 63) . chr(128 | $num & 63))));');
- // Loop through all tables that need converting.
- for (; $context['table'] < $context['num_tables']; $context['table']++)
- {
- $cur_table = $tables[$context['table']];
- $primary_key = '';
- // Make sure we keep stuff unique!
- $primary_keys = array();
- if (function_exists('apache_reset_timeout'))
- @apache_reset_timeout();
- // Get a list of text columns.
- $columns = array();
- $request = $smcFunc['db_query']('', '
- SHOW FULL COLUMNS
- FROM {db_prefix}' . $cur_table,
- array(
- )
- );
- while ($column_info = $smcFunc['db_fetch_assoc']($request))
- if (strpos($column_info['Type'], 'text') !== false || strpos($column_info['Type'], 'char') !== false)
- $columns[] = strtolower($column_info['Field']);
- // Get the column with the (first) primary key.
- $request = $smcFunc['db_query']('', '
- SHOW KEYS
- FROM {db_prefix}' . $cur_table,
- array(
- )
- );
- while ($row = $smcFunc['db_fetch_assoc']($request))
- {
- if ($row['Key_name'] === 'PRIMARY')
- {
- if (empty($primary_key) || ($row['Seq_in_index'] == 1 && !in_array(strtolower($row['Column_name']), $columns)))
- $primary_key = $row['Column_name'];
- $primary_keys[] = $row['Column_name'];
- }
- }
- $smcFunc['db_free_result']($request);
- // No primary key, no glory.
- // Same for columns. Just to be sure we've work to do!
- if (empty($primary_key) || empty($columns))
- continue;
- // Get the maximum value for the primary key.
- $request = $smcFunc['db_query']('', '
- SELECT MAX(' . $primary_key . ')
- FROM {db_prefix}' . $cur_table,
- array(
- )
- );
- list($max_value) = $smcFunc['db_fetch_row']($request);
- $smcFunc['db_free_result']($request);
- if (empty($max_value))
- continue;
- while ($context['start'] <= $max_value)
- {
- // Retrieve a list of rows that has at least one entity to convert.
- $request = $smcFunc['db_query']('', '
- SELECT {raw:primary_keys}, {raw:columns}
- FROM {db_prefix}{raw:cur_table}
- WHERE {raw:primary_key} BETWEEN {int:start} AND {int:start} + 499
- AND {raw:like_compare}
- LIMIT 500',
- array(
- 'primary_keys' => implode(', ', $primary_keys),
- 'columns' => implode(', ', $columns),
- 'cur_table' => $cur_table,
- 'primary_key' => $primary_key,
- 'start' => $context['start'],
- 'like_compare' => '(' . implode(' LIKE \'%&#%\' OR ', $columns) . ' LIKE \'%&#%\')',
- )
- );
- while ($row = $smcFunc['db_fetch_assoc']($request))
- {
- $insertion_variables = array();
- $changes = array();
- foreach ($row as $column_name => $column_value)
- if ($column_name !== $primary_key && strpos($column_value, '&#') !== false)
- {
- $changes[] = $column_name . ' = {string:changes_' . $column_name . '}';
- $insertion_variables['changes_' . $column_name] = preg_replace('~(&#(\d{1,7}|x[0-9a-fA-F]{1,6});)~e', '$entity_replace(\'\\2\')', $column_value);
- }
- $where = array();
- foreach ($primary_keys as $key)
- {
- $where[] = $key . ' = {string:where_' . $key . '}';
- $insertion_variables['where_' . $key] = $row[$key];
- }
- // Update the row.
- if (!empty($changes))
- $smcFunc['db_query']('', '
- UPDATE {db_prefix}' . $cur_table . '
- SET
- ' . implode(',
- ', $changes) . '
- WHERE ' . implode(' AND ', $where),
- $insertion_variables
- );
- }
- $smcFunc['db_free_result']($request);
- $context['start'] += 500;
- // After ten seconds interrupt.
- if (time() - $context['start_time'] > 10)
- {
- // Calculate an approximation of the percentage done.
- $context['continue_percent'] = round(100 * ($context['table'] + ($context['start'] / $max_value)) / $context['num_tables'], 1);
- $context['continue_get_data'] = '?action=admin;area=maintain;sa=database;activity=convertentities;table=' . $context['table'] . ';start=' . $context['start'] . ';' . $context['session_var'] . '=' . $context['session_id'];
- return;
- }
- }
- $context['start'] = 0;
- }
- // Make sure all serialized strings are all right.
- require_once($sourcedir . '/Subs-Charset.php');
- fix_serialized_columns();
- // If we're here, we must be done.
- $context['continue_percent'] = 100;
- $context['continue_get_data'] = '?action=admin;area=maintain;sa=database;done=convertentities';
- $context['last_step'] = true;
- $context['continue_countdown'] = -1;
- }
- /**
- * Optimizes all tables in the database and lists how much was saved.
- * It requires the admin_forum permission.
- * It shows as the maintain_forum admin area.
- * It is accessed from ?action=admin;area=maintain;sa=database;activity=optimize.
- * It also updates the optimize scheduled task such that the tables are not automatically optimized again too soon.
- * @uses the rawdata sub template (built in.)
- */
- function OptimizeTables()
- {
- global $db_type, $db_name, $db_prefix, $txt, $context, $scripturl, $sourcedir, $smcFunc;
- isAllowedTo('admin_forum');
- checkSession('post');
- ignore_user_abort(true);
- db_extend();
- // Start with no tables optimized.
- $opttab = 0;
- $context['page_title'] = $txt['database_optimize'];
- $context['sub_template'] = 'optimize';
- // Only optimize the tables related to this smf install, not all the tables in the db
- $real_prefix = preg_match('~^(`?)(.+?)\\1\\.(.*?)$~', $db_prefix, $match) === 1 ? $match[3] : $db_prefix;
- // Get a list of tables, as well as how many there are.
- $temp_tables = $smcFunc['db_list_tables'](false, $real_prefix . '%');
- $tables = array();
- foreach ($temp_tables as $table)
- $tables[] = array('table_name' => $table);
- // If there aren't any tables then I believe that would mean the world has exploded...
- $context['num_tables'] = count($tables);
- if ($context['num_tables'] == 0)
- fatal_error('You appear to be running SMF in a flat file mode... fantastic!', false);
- // For each table....
- $context['optimized_tables'] = array();
- foreach ($tables as $table)
- {
- // Optimize the table! We use backticks here because it might be a custom table.
- $data_freed = $smcFunc['db_optimize_table']($table['table_name']);
- // Optimizing one sqlite table optimizes them all.
- if ($db_type == 'sqlite')
- break;
- if ($data_freed > 0)
- $context['optimized_tables'][] = array(
- 'name' => $table['table_name'],
- 'data_freed' => $data_freed,
- );
- }
- // Number of tables, etc....
- $txt['database_numb_tables'] = sprintf($txt['database_numb_tables'], $context['num_tables']);
- $context['num_tables_optimized'] = count($context['optimized_tables']);
- // Check that we don't auto optimise again too soon!
- require_once($sourcedir . '/ScheduledTasks.php');
- CalculateNextTrigger('auto_optimize', true);
- }
- /**
- * Recount many forum totals that can be recounted automatically without harm.
- * it requires the admin_forum permission.
- * It shows the maintain_forum admin area.
- * Totals recounted:
- * - fixes for topics with wrong num_replies.
- * - updates for num_posts and num_topics of all boards.
- * - recounts instant_messages but not unread_messages.
- * - repairs messages pointing to boards with topics pointing to other boards.
- * - updates the last message posted in boards and children.
- * - updates member count, latest member, topic count, and message count.
- *
- * The function redirects back to ?action=admin;area=maintain when complete.
- * It is accessed via ?action=admin;area=maintain;sa=database;activity=recount.
- */
- function AdminBoardRecount()
- {
- global $txt, $context, $scripturl, $modSettings, $sourcedir;
- global $time_start, $smcFunc;
- isAllowedTo('admin_forum');
- checkSession('request');
- $context['page_title'] = $txt['not_done_title'];
- $context['continue_post_data'] = '';
- $context['continue_countdown'] = '3';
- $context['sub_template'] = 'not_done';
- // Try for as much time as possible.
- @set_time_limit(600);
- // Step the number of topics at a time so things don't time out...
- $request = $smcFunc['db_query']('', '
- SELECT MAX(id_topic)
- FROM {db_prefix}topics',
- array(
- )
- );
- list ($max_topics) = $smcFunc['db_fetch_row']($request);
- $smcFunc['db_free_result']($request);
- $increment = min(max(50, ceil($max_topics / 4)), 2000);
- if (empty($_REQUEST['start']))
- $_REQUEST['start'] = 0;
- $total_steps = 8;
- // Get each topic with a wrong reply count and fix it - let's just do some at a time, though.
- if (empty($_REQUEST['step']))
- {
- $_REQUEST['step'] = 0;
- while ($_REQUEST['start'] < $max_topics)
- {
- // Recount approved messages
- $request = $smcFunc['db_query']('', '
- SELECT /*!40001 SQL_NO_CACHE */ t.id_topic, MAX(t.num_replies) AS num_replies,
- CASE WHEN COUNT(ma.id_msg) >= 1 THEN COUNT(ma.id_msg) - 1 ELSE 0 END AS real_num_replies
- FROM {db_prefix}topics AS t
- LEFT JOIN {db_prefix}messages AS ma ON (ma.id_topic = t.id_topic AND ma.approved = {int:is_approved})
- WHERE t.id_topic > {int:start}
- AND t.id_topic <= {int:max_id}
- GROUP BY t.id_topic
- HAVING CASE WHEN COUNT(ma.id_msg) >= 1 THEN COUNT(ma.id_msg) - 1 ELSE 0 END != MAX(t.num_replies)',
- array(
- 'is_approved' => 1,
- 'start' => $_REQUEST['start'],
- 'max_id' => $_REQUEST['start'] + $increment,
- )
- );
- while ($row = $smcFunc['db_fetch_assoc']($request))
- $smcFunc['db_query']('', '
- UPDATE {db_prefix}topics
- SET num_replies = {int:num_replies}
- WHERE id_topic = {int:id_topic}',
- array(
- 'num_replies' => $row['real_num_replies'],
- 'id_topic' => $row['id_topic'],
- )
- );
- $smcFunc['db_free_result']($request);
- // Recount unapproved messages
- $request = $smcFunc['db_query']('', '
- SELECT /*!40001 SQL_NO_CACHE */ t.id_topic, MAX(t.unapproved_posts) AS unapproved_posts,
- COUNT(mu.id_msg) AS real_unapproved_posts
- FROM {db_prefix}topics AS t
- LEFT JOIN {db_prefix}messages AS mu ON (mu.id_topic = t.id_topic AND mu.approved = {int:not_approved})
- WHERE t.id_topic > {int:start}
- AND t.id_topic <= {int:max_id}
- GROUP BY t.id_topic
- HAVING COUNT(mu.id_msg) != MAX(t.unapproved_posts)',
- array(
- 'not_approved' => 0,
- 'start' => $_REQUEST['start'],
- 'max_id' => $_REQUEST['start'] + $increment,
- )
- );
- while ($row = $smcFunc['db_fetch_assoc']($request))
- $smcFunc['db_query']('', '
- UPDATE {db_prefix}topics
- SET unapproved_posts = {int:unapproved_posts}
- WHERE id_topic = {int:id_topic}',
- array(
- 'unapproved_posts' => $row['real_unapproved_posts'],
- 'id_topic' => $row['id_topic'],
- )
- );
- $smcFunc['db_free_result']($request);
- $_REQUEST['start'] += $increment;
- if (array_sum(explode(' ', microtime())) - array_sum(explode(' ', $time_start)) > 3)
- {
- $context['continue_get_data'] = '?action=admin;area=maintain;sa=routine;activity=recount;step=0;start=' . $_REQUEST['start'] . ';' . $context['session_var'] . '=' . $context['session_id'];
- $context['continue_percent'] = round((100 * $_REQUEST['start'] / $max_topics) / $total_steps);
- return;
- }
- }
- $_REQUEST['start'] = 0;
- }
- // Update the post count of each board.
- if ($_REQUEST['step'] <= 1)
- {
- if (empty($_REQUEST['start']))
- $smcFunc['db_query']('', '
- UPDATE {db_prefix}boards
- SET num_posts = {int:num_posts}
- WHERE redirect = {string:redirect}',
- array(
- 'num_posts' => 0,
- 'redirect' => '',
- )
- );
- while ($_REQUEST['start'] < $max_topics)
- {
- $request = $smcFunc['db_query']('', '
- SELECT /*!40001 SQL_NO_CACHE */ m.id_board, COUNT(*) AS real_num_posts
- FROM {db_prefix}messages AS m
- WHERE m.id_topic > {int:id_topic_min}
- AND m.id_topic <= {int:id_topic_max}
- AND m.approved = {int:is_approved}
- GROUP BY m.id_board',
- array(
- 'id_topic_min' => $_REQUEST['start'],
- 'id_topic_max' => $_REQUEST['start'] + $increment,
- 'is_approved' => 1,
- )
- );
- while ($row = $smcFunc['db_fetch_assoc']($request))
- $smcFunc['db_query']('', '
- UPDATE {db_prefix}boards
- SET num_posts = num_posts + {int:real_num_posts}
- WHERE id_board = {int:id_board}',
- array(
- 'id_board' => $row['id_board'],
- 'real_num_posts' => $row['real_num_posts'],
- )
- );
- $smcFunc['db_free_result']($request);
- $_REQUEST['start'] += $increment;
- if (array_sum(explode(' ', microtime())) - array_sum(explode(' ', $time_start)) > 3)
- {
- $context['continue_get_data'] = '?action=admin;area=maintain;sa=routine;activity=recount;step=1;start=' . $_REQUEST['start'] . ';' . $context['session_var'] . '=' . $context['session_id'];
- $context['continue_percent'] = round((200 + 100 * $_REQUEST['start'] / $max_topics) / $total_steps);
- return;
- }
- }
- $_REQUEST['start'] = 0;
- }
- // Update the topic count of each board.
- if ($_REQUEST['step'] <= 2)
- {
- if (empty($_REQUEST['start']))
- $smcFunc['db_query']('', '
- UPDATE {db_prefix}boards
- SET num_topics = {int:num_topics}',
- array(
- 'num_topics' => 0,
- )
- );
- while ($_REQUEST['start'] < $max_topics)
- {
- $request = $smcFunc['db_query']('', '
- SELECT /*!40001 SQL_NO_CACHE */ t.id_board, COUNT(*) AS real_num_topics
- FROM {db_prefix}topics AS t
- WHERE t.approved = {int:is_approved}
- AND t.id_topic > {int:id_topic_min}
- AND t.id_topic <= {int:id_topic_max}
- GROUP BY t.id_board',
- array(
- 'is_approved' => 1,
- 'id_topic_min' => $_REQUEST['start'],
- 'id_topic_max' => $_REQUEST['start'] + $increment,
- )
- );
- while ($row = $smcFunc['db_fetch_assoc']($request))
- $smcFunc['db_query']('', '
- UPDATE {db_prefix}boards
- SET num_topics = num_topics + {int:real_num_topics}
- WHERE id_board = {int:id_board}',
- array(
- 'id_board' => $row['id_board'],
- 'real_num_topics' => $row['real_num_topics'],
- )
- );
- $smcFunc['db_free_result']($request);
- $_REQUEST['start'] += $increment;
- if (array_sum(explode(' ', microtime())) - array_sum(explode(' ', $time_start)) > 3)
- {
- $context['continue_get_data'] = '?action=admin;area=maintain;sa=routine;activity=recount;step=2;start=' . $_REQUEST['start'] . ';' . $context['session_var'] . '=' . $context['session_id'];
- $context['continue_percent'] = round((300 + 100 * $_REQUEST['start'] / $max_topics) / $total_steps);
- return;
- }
- }
- $_REQUEST['start'] = 0;
- }
- // Update the unapproved post count of each board.
- if ($_REQUEST['step'] <= 3)
- {
- if (empty($_REQUEST['start']))
- $smcFunc['db_query']('', '
- UPDATE {db_prefix}boards
- SET unapproved_posts = {int:unapproved_posts}',
- array(
- 'unapproved_posts' => 0,
- )
- );
- while ($_REQUEST['start'] < $max_topics)
- {
- $request = $smcFunc['db_query']('', '
- SELECT /*!40001 SQL_NO_CACHE */ m.id_board, COUNT(*) AS real_unapproved_posts
- FROM {db_prefix}messages AS m
- WHERE m.id_topic > {int:id_topic_min}
- AND m.id_topic <= {int:id_topic_max}
- AND m.approved = {int:is_approved}
- GROUP BY m.id_board',
- array(
- 'id_topic_min' => $_REQUEST['start'],
- 'id_topic_max' => $_REQUEST['start'] + $increment,
- 'is_approved' => 0,
- )
- );
- while ($row = $smcFunc['db_fetch_assoc']($request))
- $smcFunc['db_query']('', '
- UPDATE {db_prefix}boards
- SET unapproved_posts = unapproved_posts + {int:unapproved_posts}
- WHERE id_board = {int:id_board}',
- array(
- 'id_board' => $row['id_board'],
- 'unapproved_posts' => $row['real_unapproved_posts'],
- )
- );
- $smcFunc['db_free_result']($request);
- $_REQUEST['start'] += $increment;
- if (array_sum(explode(' ', microtime())) - array_sum(explode(' ', $time_start)) > 3)
- {
- $context['continue_get_data'] = '?action=admin;area=maintain;sa=routine;activity=recount;step=3;start=' . $_REQUEST['start'] . ';' . $context['session_var'] . '=' . $context['session_id'];
- $context['continue_percent'] = round((400 + 100 * $_REQUEST['start'] / $max_topics) / $total_steps);
- return;
- }
- }
- $_REQUEST['start'] = 0;
- }
- // Update the unapproved topic count of each board.
- if ($_REQUEST['step'] <= 4)
- {
- if (empty($_REQUEST['start']))
- $smcFunc['db_query']('', '
- UPDATE {db_prefix}boards
- SET unapproved_topics = {int:unapproved_topics}',
- array(
- 'unapproved_topics' => 0,
- )
- );
- while ($_REQUEST['start'] < $max_topics)
- {
- $request = $smcFunc['db_query']('', '
- SELECT /*!40001 SQL_NO_CACHE */ t.id_board, COUNT(*) AS real_unapproved_topics
- FROM {db_prefix}topics AS t
- WHERE t.approved = {int:is_approved}
- AND t.id_topic > {int:id_topic_min}
- AND t.id_topic <= {int:id_topic_max}
- GROUP BY t.id_board',
- array(
- 'is_approved' => 0,
- 'id_topic_min' => $_REQUEST['start'],
- 'id_topic_max' => $_REQUEST['start'] + $increment,
- )
- );
- while ($row = $smcFunc['db_fetch_assoc']($request))
- $smcFunc['db_query']('', '
- UPDATE {db_prefix}boards
- SET unapproved_topics = unapproved_topics + {int:real_unapproved_topics}
- WHERE id_board = {int:id_board}',
- array(
- 'id_board' => $row['id_board'],
- 'real_unapproved_topics' => $row['real_unapproved_topics'],
- )
- );
- $smcFunc['db_free_result']($request);
- $_REQUEST['start'] += $increment;
- if (array_sum(explode(' ', microtime())) - array_sum(explode(' ', $time_start)) > 3)
- {
- $context['continue_get_data'] = '?action=admin;area=maintain;sa=routine;activity=recount;step=4;start=' . $_REQUEST['start'] . ';' . $context['session_var'] . '=' . $context['session_id'];
- $context['continue_percent'] = round((500 + 100 * $_REQUEST['start'] / $max_topics) / $total_steps);
- return;
- }
- }
- $_REQUEST['start'] = 0;
- }
- // Get all members with wrong number of personal messages.
- if ($_REQUEST['step'] <= 5)
- {
- $request = $smcFunc['db_query']('', '
- SELECT /*!40001 SQL_NO_CACHE */ mem.id_member, COUNT(pmr.id_pm) AS real_num,
- MAX(mem.instant_messages) AS instant_messages
- FROM {db_prefix}members AS mem
- LEFT JOIN {db_prefix}pm_recipients AS pmr ON (mem.id_member = pmr.id_member AND pmr.deleted = {int:is_not_deleted})
- GROUP BY mem.id_member
- HAVING COUNT(pmr.id_pm) != MAX(mem.instant_messages)',
- array(
- 'is_not_deleted' => 0,
- )
- );
- while ($row = $smcFunc['db_fetch_assoc']($request))
- updateMemberData($row['id_member'], array('instant_messages' => $row['real_num']));
- $smcFunc['db_free_result']($request);
- $request = $smcFunc['db_query']('', '
- SELECT /*!40001 SQL_NO_CACHE */ mem.id_member, COUNT(pmr.id_pm) AS real_num,
- MAX(mem.unread_messages) AS unread_messages
- FROM {db_prefix}members AS mem
- LEFT JOIN {db_prefix}pm_recipients AS pmr ON (mem.id_member = pmr.id_member AND pmr.deleted = {int:is_not_deleted} AND pmr.is_read = {int:is_not_read})
- GROUP BY mem.id_member
- HAVING COUNT(pmr.id_pm) != MAX(mem.unread_messages)',
- array(
- 'is_not_deleted' => 0,
- 'is_not_read' => 0,
- )
- );
- while ($row = $smcFunc['db_fetch_assoc']($request))
- updateMemberData($row['id_member'], array('unread_messages' => $row['real_num']));
- $smcFunc['db_free_result']($request);
- if (array_sum(explode(' ', microtime())) - array_sum(explode(' ', $time_start)) > 3)
- {
- $context['continue_get_data'] = '?action=admin;area=maintain;sa=routine;activity=recount;step=6;start=0;' . $context['session_var'] . '=' . $context['session_id'];
- $context['continue_percent'] = round(700 / $total_steps);
- return;
- }
- }
- // Any messages pointing to the wrong board?
- if ($_REQUEST['step'] <= 6)
- {
- while ($_REQUEST['start'] < $modSettings['maxMsgID'])
- {
- $request = $smcFunc['db_query']('', '
- SELECT /*!40001 SQL_NO_CACHE */ t.id_board, m.id_msg
- FROM {db_prefix}messages AS m
- INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic AND t.id_board != m.id_board)
- WHERE m.id_msg > {int:id_msg_min}
- AND m.id_msg <= {int:id_msg_max}',
- array(
- 'id_msg_min' => $_REQUEST['start'],
- 'id_msg_max' => $_REQUEST['start'] + $increment,
- )
- );
- $boards = array();
- while ($row = $smcFunc['db_fetch_assoc']($request))
- $boards[$row['id_board']][] = $row['id_msg'];
- $smcFunc['db_free_result']($request);
- foreach ($boards as $board_id => $messages)
- $smcFunc['db_query']('', '
- UPDATE {db_prefix}messages
- SET id_board = {int:id_board}
- WHERE id_msg IN ({array_int:id_msg_array})',
- array(
- 'id_msg_array' => $messages,
- 'id_board' => $board_id,
- )
- );
- $_REQUEST['start'] += $increment;
- if (array_sum(explode(' ', microtime())) - array_sum(explode(' ', $time_start)) > 3)
- {
- $context['continue_get_data'] = '?action=admin;area=maintain;sa=routine;activity=recount;step=6;start=' . $_REQUEST['start'] . ';' . $context['session_var'] . '=' . $context['session_id'];
- $context['continue_percent'] = round((700 + 100 * $_REQUEST['start'] / $modSettings['maxMsgID']) / $total_steps);
- return;
- }
- }
- $_REQUEST['start'] = 0;
- }
- // Update the latest message of each board.
- $request = $smcFunc['db_query']('', '
- SELECT m.id_board, MAX(m.id_msg) AS local_last_msg
- FROM {db_prefix}messages AS m
- WHERE m.approved = {int:is_approved}
- GROUP BY m.id_board',
- array(
- 'is_approved' => 1,
- )
- );
- $realBoardCounts = array();
- while ($row = $smcFunc['db_fetch_assoc']($request))
- $realBoardCounts[$row['id_board']] = $row['local_last_msg'];
- $smcFunc['db_free_result']($request);
- $request = $smcFunc['db_query']('', '
- SELECT /*!40001 SQL_NO_CACHE */ id_board, id_parent, id_last_msg, child_level, id_msg_updated
- FROM {db_prefix}boards',
- array(
- )
- );
- $resort_me = array();
- while ($row = $smcFunc['db_fetch_assoc']($request))
- {
- $row['local_last_msg'] = isset($realBoardCounts[$row['id_board']]) ? $realBoardCounts[$row['id_board']] : 0;
- $resort_me[$row['child_level']][] = $row;
- }
- $smcFunc['db_free_result']($request);
- krsort($resort_me);
- $lastModifiedMsg = array();
- foreach ($resort_me as $rows)
- foreach ($rows as $row)
- {
- // The latest message is the latest of the current board and its children.
- if (isset($lastModifiedMsg[$row['id_board']]))
- $curLastModifiedMsg = max($row['local_last_msg'], $lastModifiedMsg[$row['id_board']]);
- else
- $curLastModifiedMsg = $row['local_last_msg'];
- // If what is and what should be the latest message differ, an update is necessary.
- if ($row['local_last_msg'] != $row['id_last_msg'] || $curLastModifiedMsg != $row['id_msg_updated'])
- $smcFunc['db_query']('', '
- UPDATE {db_prefix}boards
- SET id_last_msg = {int:id_last_msg}, id_msg_updated = {int:id_msg_updated}
- WHERE id_board = {int:id_board}',
- array(
- 'id_last_msg' => $row['local_last_msg'],
- 'id_msg_updated' => $curLastModifiedMsg,
- 'id_board' => $row['id_board'],
- )
- );
- // Parent boards inherit the latest modified message of their children.
- if (isset($lastModifiedMsg[$row['id_parent']]))
- $lastModifiedMsg[$row['id_parent']] = max($row['local_last_msg'], $lastModifiedMsg[$row['id_parent']]);
- else
- $lastModifiedMsg[$row['id_parent']] = $row['local_last_msg'];
- }
- // Update all the basic statistics.
- updateStats('member');
- updateStats('message');
- updateStats('topic');
- // Finally, update the latest event times.
- require_once($sourcedir . '/ScheduledTasks.php');
- CalculateNextTrigger();
- redirectexit('action=admin;area=maintain;sa=routine;done=recount');
- }
- /**
- * Perform a detailed version check. A very good thing ;).
- * The function parses the comment headers in all files for their version information,
- * and outputs that for some javascript to check with simplemachines.org.
- * It does not connect directly with simplemachines.org, but rather expects the client to.
- *
- * It requires the admin_forum permission.
- * Uses the view_versions admin area.
- * Accessed through ?action=admin;area=maintain;sa=routine;activity=version.
- * @uses Admin template, view_versions sub-template.
- */
- function VersionDetail()
- {
- global $forum_version, $txt, $sourcedir, $context;
- isAllowedTo('admin_forum');
- // Call the function that'll get all the version info we need.
- require_once($sourcedir . '/Subs-Admin.php');
- $versionOptions = array(
- 'include_ssi' => true,
- 'include_subscriptions' => true,
- 'sort_results' => true,
- );
- $version_info = getFileVersions($versionOptions);
- // Add the new info to the template context.
- $context += array(
- 'file_versions' => $version_info['file_versions'],
- 'default_template_versions' => $version_info['default_template_versions'],
- 'template_versions' => $version_info['template_versions'],
- 'default_language_versions' => $version_info['default_language_versions'],
- 'default_known_languages' => array_keys($version_info['default_language_versions']),
- );
- // Make it easier to manage for the template.
- $context['forum_version'] = $forum_version;
- $context['sub_template'] = 'view_versions';
- $context['page_title'] = $txt['admin_version_check'];
- }
- /**
- * Re-attribute posts.
- */
- function MaintainReattributePosts()
- {
- global $sourcedir, $context, $txt;
- checkSession();
- // Find the member.
- require_once($sourcedir . '/Subs-Auth.php');
- $members = findMembers($_POST['to']);
- if (empty($members))
- fatal_lang_error('reattribute_cannot_find_member');
- $memID = array_shift($members);
- $memID = $memID['id'];
- $email = $_POST['type'] == 'email' ? $_POST['from_email'] : '';
- $membername = $_POST['type'] == 'name' ? $_POST['from_name'] : '';
- // Now call the reattribute function.
- require_once($sourcedir . '/Subs-Members.php');
- reattributePosts($memID, $email, $membername, !empty($_POST['posts']));
- $context['maintenance_finished'] = $txt['maintain_reattribute_posts'];
- }
- /**
- * Handling function for the backup stuff.
- */
- function MaintainDownloadBackup()
- {
- global $sourcedir;
- require_once($sourcedir . '/DumpDatabase.php');
- DumpDatabase2();
- }
- /**
- * Removing old members. Done and out!
- * @todo refactor
- */
- function MaintainPurgeInactiveMembers()
- {
- global $sourcedir, $context, $smcFunc, $txt;
- $_POST['maxdays'] = (int) $_POST['maxdays'];
- if (!empty($_POST['groups']) && $_POST['maxdays'])
- {
- checkSession();
- $groups = array();
- foreach ($_POST['groups'] as $id => $dummy)
- $groups[] = (int) $id;
- $time_limit = (time() - ($_POST['maxdays'] * 24 * 3600));
- $where_vars = array(
- 'time_limit' => $time_limit,
- );
- if ($_POST['del_type'] == 'activated')
- {
- $where = 'mem.date_registered < {int:time_limit} AND mem.is_activated = {int:is_activated}';
- $where_vars['is_activated'] = 0;
- }
- else
- $where = 'mem.last_login < {int:time_limit}';
- // Need to get *all* groups then work out which (if any) we avoid.
- $request = $smcFunc['db_query']('', '
- SELECT id_group, group_name, min_posts
- FROM {db_prefix}membergroups',
- array(
- )
- );
- while ($row = $smcFunc['db_fetch_assoc']($request))
- {
- // Avoid this one?
- if (!in_array($row['id_group'], $groups))
- {
- // Post group?
- if ($row['min_posts'] != -1)
- {
- $where .= ' AND mem.id_post_group != {int:id_post_group_' . $row['id_group'] . '}';
- $where_vars['id_post_group_' . $row['id_group']] = $row['id_group'];
- }
- else
- {
- $where .= ' AND mem.id_group != {int:id_group_' . $row['id_group'] . '} AND FIND_IN_SET({int:id_group_' . $row['id_group'] . '}, mem.additional_groups) = 0';
- $where_vars['id_group_' . $row['id_group']] = $row['id_group'];
- }
- }
- }
- $smcFunc['db_free_result']($request);
- // If we have ungrouped unselected we need to avoid those guys.
- if (!in_array(0, $groups))
- {
- $where .= ' AND (mem.id_group != 0 OR mem.additional_groups != {string:blank_add_groups})';
- $where_vars['blank_add_groups'] = '';
- }
- // Select all the members we're about to murder/remove...
- $request = $smcFunc['db_query']('', '
- SELECT mem.id_member, IFNULL(m.id_member, 0) AS is_mod
- FROM {db_prefix}members AS mem
- LEFT JOIN {db_prefix}moderators AS m ON (m.id_member = mem.id_member)
- WHERE ' . $where,
- $where_vars
- );
- $members = array();
- while ($row = $smcFunc['db_fetch_assoc']($request))
- {
- if (!$row['is_mod'] || !in_array(3, $groups))
- $members[] = $row['id_member'];
- }
- $smcFunc['db_free_result']($request);
- require_once($sourcedir . '/Subs-Members.php');
- deleteMembers($members);
- }
- $context['maintenance_finished'] = $txt['maintain_members'];
- }
- /**
- * Removing old posts doesn't take much as we really pass through.
- */
- function MaintainRemoveOldPosts()
- {
- global $sourcedir, $context, $txt;
- // Actually do what we're told!
- require_once($sourcedir . '/RemoveTopic.php');
- RemoveOldTopics2();
- }
- /**
- * Moves topics from one board to another.
- *
- * @uses not_done template to pause the process.
- */
- function MaintainMassMoveTopics()
- {
- global $smcFunc, $sourcedir, $context, $txt;
- // Only admins.
- isAllowedTo('admin_forum');
- checkSession('request');
- // Set up to the context.
- $context['page_title'] = $txt['not_done_title'];
- $context['continue_countdown'] = '3';
- $context['continue_post_data'] = '';
- $context['continue_get_data'] = '';
- $context['sub_template'] = 'not_done';
- $context['start'] = empty($_REQUEST['start']) ? 0 : (int) $_REQUEST['start'];
- $context['start_time'] = time();
- // First time we do this?
- $id_board_from = isset($_POST['id_board_from']) ? (int) $_POST['id_board_from'] : (int) $_REQUEST['id_board_from'];
- $id_board_to = isset($_POST['id_board_to']) ? (int) $_POST['id_board_to'] : (int) $_REQUEST['id_board_to'];
- // No boards then this is your stop.
- if (empty($id_board_from) || empty($id_board_to))
- return;
- // How many topics are we converting?
- if (!isset($_REQUEST['totaltopics']))
- {
- $request = $smcFunc['db_query']('', '
- SELECT COUNT(*)
- FROM {db_prefix}topics
- WHERE id_board = {int:id_board_from}',
- array(
- 'id_board_from' => $id_board_from,
- )
- );
- list ($total_topics) = $smcFunc['db_fetch_row']($request);
- $smcFunc['db_free_result']($request);
- }
- else
- $total_topics = (int) $_REQUEST['totaltopics'];
- // Seems like we need this here.
- $context['continue_get_data'] = '?action=admin;area=maintain;sa=topics;activity=massmove;id_board_from=' . $id_board_from . ';id_board_to=' . $id_board_to . ';totaltopics=' . $total_topics . ';start=' . $context['start'] . ';' . $context['session_var'] . '=' . $context['session_id'];
- // We have topics to move so start the process.
- if (!empty($total_topics))
- {
- while ($context['start'] <= $total_topics)
- {
- // Lets get the topics.
- $request = $smcFunc['db_query']('', '
- SELECT id_topic
- FROM {db_prefix}topics
- WHERE id_board = {int:id_board_from}
- LIMIT 10',
- array(
- 'id_board_from' => $id_board_from,
- )
- );
- // Get the ids.
- $topics = array();
- while ($row = $smcFunc['db_fetch_assoc']($request))
- $topics[] = $row['id_topic'];
- // Just return if we don't have any topics left to move.
- if (empty($topics))
- {
- cache_put_data('board-' . $id_board_from, null, 120);
- cache_put_data('board-' . $id_board_to, null, 120);
- redirectexit('action=admin;area=maintain;sa=topics;done=massmove');
- }
- // Lets move them.
- require_once($sourcedir . '/MoveTopic.php');
- moveTopics($topics, $id_board_to);
- // We've done at least ten more topics.
- $context['start'] += 10;
- // Lets wait a while.
- if (time() - $context['start_time'] > 3)
- {
- // What's the percent?
- $context['continue_percent'] = round(100 * ($context['start'] / $total_topics), 1);
- $context['continue_get_data'] = '?action=admin;area=maintain;sa=topics;activity=massmove;id_board_from=' . $id_board_from . ';id_board_to=' . $id_board_to . ';totaltopics=' . $total_topics . ';start=' . $context['start'] . ';' . $context['session_var'] . '=' . $context['session_id'];
- // Let the template system do it's thang.
- return;
- }
- }
- }
- // Don't confuse admins by having an out of date cache.
- cache_put_data('board-' . $id_board_from, null, 120);
- cache_put_data('board-' . $id_board_to, null, 120);
- redirectexit('action=admin;area=maintain;sa=topics;done=massmove');
- }
- ?>
|