acl_check( 'administration', 'config', 'users', $my->usertype )) { mosRedirect( 'index2.php?', _NOT_AUTH ); } $nullDate = $database->getNullDate(); ?>

Global Check-in

getTableList(); $k = 0; foreach ($tables as $tn) { // make sure we get the right tables based on prefix if (!preg_match( "/^".$mosConfig_dbprefix."/i", $tn )) { continue; } $fields = $database->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" . "\n FROM $tn" . "\n WHERE checked_out > 0" ; } else { $query = "SELECT checked_out" . "\n FROM $tn" . "\n WHERE checked_out > 0" ; } $database->setQuery( $query ); $res = $database->query(); $num = $database->getNumRows( $res ); if ($foundE) { $query = "UPDATE $tn" . "\n SET checked_out = 0, checked_out_time = " . $database->Quote( $nullDate ) . ", editor = NULL" . "\n WHERE checked_out > 0" ; } else { $query = "UPDATE $tn" . "\n SET checked_out = 0, checked_out_time = " . $database->Quote( $nullDate ) . "\n WHERE checked_out > 0" ; } $database->setQuery( $query ); $res = $database->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; } } } ?>

Database Table	# of Items	Checked-In
Checking table - $tn	Checked in $num items
Checking table - $tn	Checked in $num items
Checked out items have now been all checked in