<?php
/* session display stuff */
require_once 'TableEditor.php';
$editor = new TableEditor($conn, 'sesview');
$editor->setConfig('allowCSV', false);
$editor->setConfig('allowView', false);
$editor->setConfig('allowAdd', false);
$editor->setConfig('allowEdit', false);
$editor->setConfig('allowCopy', false);
$editor->setConfig('allowDelete', false);
$editor->setConfig('title', 'Live Sessions Monitor');
$editor->setConfig('footerfile', 'footer.html');
$editor->setConfig('perPage', 30);
$editor->setDisplayNames(array('node' => 'Domain:Terminal', 'username' => 'Login Name', 'timestamp' => 'Sess. Start Time', 'Screen' => 'Live'));
$editor->setSearchableFields('username', 'node', 'timestamp');
$editor->setRequiredFields('username', 'node', 'domain', 'timestamp', 'status', 'clearedtime', 'sessionid', 'ipadress', 'port');
$editor->noDisplay('sessionid');
$editor->noDisplay('ipaddress');
$editor->noDisplay('port');
$editor->noDisplay('clearedtime');
$editor->noDisplay('lastping');
#$editor->noDisplay('status');
$editor->setDefaultOrderby('username');
$editor->display();
?>
<?php
include '../document.php';
require_once 'TableEditor.php';
if (isset($bzID)) {
$substr = explode("|", $bzID);
$result = mysql_query("SELECT * FROM passwd WHERE password = '******'1']}' AND username = '******'0']}' AND access = '{$substr['2']}'");
if (mysql_num_rows($result) == 1 && $substr[2] >= 1) {
$editor = new TableEditor($db, 'motd');
$editor->setDefaultOrderby('title');
$editor->setConfig('allowCopy', false);
$editor->setConfig('allowCSV', false);
$editor->noDisplay('id');
$editor->display();
} else {
$doc = new Document();
$doc->begin("Edit MOTD", 1);
print "Unable to find any any MOTD results";
$doc->end();
}
} else {
$doc = new Document();
$doc->accessDenied();
}
<?php
$conn = mysql_connect('localhost', 'rautor', '\\pass');
$db_selected = mysql_select_db('rautor', $conn);
require_once 'TableEditor.php';
$editor = new TableEditor($conn, 'sessions');
$editor->setConfig('allowAdd', false);
$editor->setConfig('allowEdit', false);
$editor->setConfig('allowCopy', false);
#$editor->setConfig('allowDelete', false);
#$editor->setConfig('allowCSV', false);
#$editor->setConfig('allowView', false);
$editor->setConfig('title', 'Manage All Sessions');
$editor->setConfig('footerfile', 'footer.html');
$editor->setConfig('perPage', 20);
$editor->setDisplayNames(array('domain' => 'Domain', 'node' => 'PC name', 'username' => 'username', 'timestamp' => 'Start Time', 'sessionid' => 'Session ID', 'status' => 'Status', 'clearedtime' => 'Cleared Time', 'ipadress' => 'IP Address', 'port' => 'Port', 'url' => 'URL'));
$editor->setSearchableFields('username', 'node', 'timestamp');
$editor->setRequiredFields('username', 'node', 'domain', 'timestamp', 'status', 'clearedtime', 'sessionid', 'ipadress', 'port');
#$editor->noDisplay('sessionid');
$editor->noDisplay('ipaddress');
$editor->noDisplay('port');
$editor->noDisplay('lastping');
#$editor->noDisplay('clearedtime');
#$editor->noDisplay('status');
$editor->setDefaultOrderby('timestamp,username');
$editor->display();
?>
require_once 'TableEditor.php';
$editor = new TableEditor($conn, 'rautor');
// $editor->setConfig('allowView', false);
// $editor->setConfig('allowAdd', false);
// $editor->setConfig('allowEdit', false);
// $editor->setConfig('allowCopy', false);
// $editor->setConfig('allowDelete', false);
$editor->setConfig('perPage', 30);
$editor->setDisplayNames(array('te_id' => 'ID', 'te_name' => 'Name', 'te_password' => 'Password', 'te_email' => 'Email', 'te_datetime' => 'Date Added', 'te_age' => 'Age', 'te_live' => 'Live', 'te_desc' => 'Description'));
// $editor->noDisplay('te_password');
$editor->noEdit('te_live');
$editor->setInputType('te_password', 'password');
$editor->setInputType('te_email', 'email');
$editor->setSearchableFields('te_name', 'te_age', 'te_id', 'te_desc', 'te_live');
$editor->setRequiredFields('te_name', 'te_email', 'te_datetime', 'te_age', 'te_desc');
$editor->setDefaultOrderby('te_id');
$editor->setDefaultValues(array('te_id' => '0', 'te_live' => 'NOT LIVE'));
//$editor->addAdditionCallback(create_function('$data', 'foreach($data as $k => $v) {$body[] = "$k => $v";} mail("*****@*****.**", "Row added", implode("\n", $body));'));
//$editor->addEditCallback(create_function('$data', 'foreach($data as $k => $v) {$body[] = "$k => $v";} mail("*****@*****.**", "Row edited", implode("\n", $body));'));
//$editor->addCopyCallback(create_function('$data', 'foreach($data as $k => $v) {$body[] = "$k => $v";} mail("*****@*****.**", "Row copied", implode("\n", $body));'));
//$editor->addDeleteCallback(create_function('$data', 'foreach($data as $k => $v) {$body[] = "$k => $v";} mail("*****@*****.**", "Row deleted", implode("\n", $body));'));
function validateAge(&$obj, $data)
{
$data = (int) $data;
if ($data < 18 or $data > 80) {
$obj->addError('Invalid age! Please enter an age between 18 and 80');
}
return $data;
}
$editor->addValidationCallback('te_age', 'validateAge');
$editor->addDisplayFilter('te_desc', create_function('$v', 'return substr($v, 0, 100) . "...";'));
