Home »
Joomla »
Joomla При постоянном креше таблиц
<![CDATA[
/* + check crash tables and repair */
$db = JFactory::getDBO();
$injTables = array('pg_session','pg_kunena_whoisonline');
$q = 'CHECK TABLE `'.implode('`,`',$injTables).'`';
$db->setQuery($q);
$checkedTables = $db->loadObjectList();
$crashedTables = array();
foreach($checkedTables as $table){
if($table->Msg_text != 'OK'){
$crashedTables[$table->Table] = $table->Table;
}
}
if(!empty($crashedTables)){
$q = 'REPAIR TABLE `'.implode('`,`',$crashedTables).'`';
$db->setQuery($q);
$db->query();
}
/* - check crash tables and repair */
]]>
Свежие комментарии