getTableList(); $k = 0; foreach ($tables as $tn) { // make sure we get the right tables based on prefix if (!preg_match( "/^".$mainframe->getCfg('dbprefix')."/i", $tn )) { continue; } $fields = $db->getTableFields( array( $tn ) ); $foundCO = false; $foundCOT = false; $foundE = false; $foundCO = isset( $fields[$tn]['checked_out'] ); $foundCOT = isset( $fields[$tn]['checked_out_time'] ); $foundE = isset( $fields[$tn]['editor'] ); if ($foundCO && $foundCOT) { if ($foundE) { $query = 'SELECT checked_out, editor FROM '.$tn.' WHERE checked_out > 0'; } else { $query = 'SELECT checked_out FROM '.$tn.' WHERE checked_out > 0'; } $db->setQuery( $query ); $res = $db->query(); $num = $db->getNumRows( $res ); if ($foundE) { $query = 'UPDATE '.$tn.' SET checked_out = 0, checked_out_time = '.$db->Quote($nullDate).', editor = NULL WHERE checked_out > 0'; } else { $query = 'UPDATE '.$tn.' SET checked_out = 0, checked_out_time = '.$db->Quote($nullDate).' WHERE checked_out > 0'; } $db->setQuery( $query ); $res = $db->query(); if ($res == 1) { if ($num > 0) { echo ""; echo "\n "; echo "\n "; echo "\n "; echo "\n "; echo "\n"; } else { echo ""; echo "\n "; echo "\n "; echo "\n "; echo "\n "; echo "\n"; } $k = 1 - $k; } } } ?>

". JText::_( 'Checking table' ) ." - ". $tn ."	". JText::_( 'Checked-In' ) ." ". $num ." ". JText::_( 'items' ) ."
". JText::_( 'Checking table' ) ." - ". $tn ."	". JText::_( 'Checked-In' ) ." ". $num ." ". JText::_( 'items' ) ."