PHP TableEditor::setConfig Examples

Example #1

File: index.php Project: kangelos/Rautor-and-friends

<?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();
?>
 

Example #2

File: index.php Project: kangelos/Rautor-and-friends

$conn = mysql_connect('localhost', 'rautor', '\\pass');
$db_selected = mysql_select_db('rautor', $conn);
$ip = $_SERVER['REMOTE_ADDR'];
$user = $_SERVER['PHP_AUTH_USER'];
mysql_query("insert into admin_logins (username,ip,lastreview) values('{$user}','{$ip}',now())");
mysql_query("update admin_logins set username='******',lastreview=now() where ip='{$ip}'");
?>




<?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');

Example #3

File: MainDisplay 15ene2014.php Project: alexlqi/adminte_git

$ResultTables = mysql_list_tables(DB_NAME);
$iTables = 0;
while ($iTables < mysql_num_rows($ResultTables)) {
    $TName[$iTables] = mysql_tablename($ResultTables, $iTables);
    if ($table == $TName[$iTables]) {
        require_once '' . TEFunctionsPath . 'ClassTableEditor.php';
        $link = mysql_connect(DB_HOST, DB_USER, DB_PASS);
        mysql_select_db(DB_NAME);
        $editor = new TableEditor($link, $table);
        if (TEditorActions == true) {
            $ActionButtons = 1;
        } else {
            $ActionButtons = 0;
        }
        $editor->setConfig('allowView', $ActionButtons);
        $editor->setConfig('allowAdd', $ActionButtons);
        $editor->setConfig('allowEdit', $ActionButtons);
        $editor->setConfig('allowCopy', $ActionButtons);
        $editor->setConfig('allowDelete', $ActionButtons);
        $editor->setConfig('perPage', 20);
        if (!valida_acceso($table)) {
            ?>
	  <script language="javascript">
	  	 alert("Usted no tiene privilegios a este módulo");
	     history.back(1);
      </script>
	<?php 
        }
        if (file_exists(TEditorPath . 'TE_TODAS_LAS_TABLAS_javascript_inicio.php')) {
            include TEditorPath . 'TE_TODAS_LAS_TABLAS_javascript_inicio.php';

Example #4

File: index.php Project: kangelos/Rautor-and-friends

$conn = mysql_connect('localhost', 'rautor', '\\pass');
$db_selected = mysql_select_db('rautor', $conn);
$ip = $_SERVER['REMOTE_ADDR'];
$user = $_SERVER['PHP_AUTH_USER'];
?>




<?php 
/* session display stuff */
require_once 'TableEditor.php';
$editor = new TableEditor($conn, 'rautor_sessions');
#$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', 'Rautor Sessions\' Listing');
$editor->setConfig('footerfile', 'footer.html');
$editor->setConfig('perPage', 50);
$editor->setDisplayNames(array('path' => 'Full Path where files were saved && PC Name', 'node' => 'Terminal', 'domain' => 'Domain', 'username' => 'Login Name', 'starttime' => 'Session Start Time', 'lastping' => 'Session Last Update', 'clearedtime' => 'Session Stop Time'));
$editor->setSearchableFields('username', 'node', 'starttime', 'domain');
$editor->setRequiredFields('username', 'node', 'domain', 'timestamp', 'status', 'clearedtime', 'sessionid', 'ipadress', 'port');
$editor->noDisplay('node');
$editor->noDisplay('ipaddress');
$editor->noDisplay('clearedtime');
#$editor->noDisplay('status');
$editor->setDefaultOrderby('username');

Example #5

File: editMOTD.php Project: szakats/bzflag_mirror

<?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();
}

Example #6

File: tabledemo.php Project: kangelos/Rautor-and-friends

*   `te_email` varchar(32) NOT NULL default '',
*   `te_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
*   `te_age` tinyint(3) unsigned NOT NULL default '0',
*   `te_live` enum('LIVE','NOT LIVE') default NULL,
*   `te_desc` mediumtext NOT NULL,
*   PRIMARY KEY  (`te_id`)
* ) TYPE=MyISAM;
*/
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)
{

Example #7

File: table.php Project: kangelos/Rautor-and-friends

<?php

$conn = mysql_connect('localhost', 'root', 'banana');
$db_selected = mysql_select_db('rautor', $conn);
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('perPage', 30);
$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('clearedtime');
$editor->noDisplay('status');
$editor->setDefaultOrderby('username');
#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;