Files
@ 9a29f073412c
Branch filter:
Location: hot67beta/administrator/components/com_checkin/admin.checkin.php
9a29f073412c
3.3 KiB
text/x-php
pad
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 | <?php
/**
* @version $Id: admin.checkin.php 10381 2008-06-01 03:35:53Z pasamio $
* @package Joomla
* @subpackage Checkin
* @copyright Copyright (C) 2005 - 2008 Open Source Matters. All rights reserved.
* @license GNU/GPL, see LICENSE.php
* Joomla! is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
* See COPYRIGHT.php for copyright notices and details.
*/
// no direct access
defined( '_JEXEC' ) or die( 'Restricted access' );
// Make sure the user is authorized to view this page
$user = & JFactory::getUser();
if (!$user->authorize( 'com_checkin', 'manage' )) {
$mainframe->redirect( 'index.php', JText::_('ALERTNOTAUTH') );
}
$db =& JFactory::getDBO();
$nullDate = $db->getNullDate();
?>
<div id="tablecell">
<table class="adminform">
<tr>
<th class="title">
<?php echo JText::_( 'Database Table' ); ?>
</th>
<th class="title">
<?php echo JText::_( 'Num of Items' ); ?>
</th>
<th class="title">
<?php echo JText::_( 'Checked-In' ); ?>
</th>
<th class="title">
</th>
</tr>
<?php
$tables = $db->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 "<tr class=\"row$k\">";
echo "\n <td width=\"350\">". JText::_( 'Checking table' ) ." - ". $tn ."</td>";
echo "\n <td width=\"150\">". JText::_( 'Checked-In' ) ." <b>". $num ."</b> ". JText::_( 'items' ) ."</td>";
echo "\n <td width=\"100\" align=\"center\"><img src=\"images/tick.png\" border=\"0\" alt=\"". JText::_( 'tick' ) ."\" /></td>";
echo "\n <td> </td>";
echo "\n</tr>";
} else {
echo "<tr class=\"row$k\">";
echo "\n <td width=\"350\">". JText::_( 'Checking table' ) ." - ". $tn ."</td>";
echo "\n <td width=\"150\">". JText::_( 'Checked-In' ) ." <b>". $num ."</b> ". JText::_( 'items' ) ."</td>";
echo "\n <td width=\"100\"> </td>";
echo "\n <td> </td>";
echo "\n</tr>";
}
$k = 1 - $k;
}
}
}
?>
<tr>
<td colspan="4">
<strong>
<?php echo JText::_( 'Checked out items have now been all checked in' ); ?>
</strong>
</td>
</tr>
</table>
</div>
|