/** * This file is a part of MyWebSQL package * * @file: modules/format.php * @author Samnan ur Rehman * @copyright (c) 2008-2011 Samnan ur Rehman * @web http://mywebsql.net * @license http://mywebsql.net/license */ function processRequest(&$db) { $query = v($_REQUEST["query"]); if (!$query) { print ""; } else { print "<div id='results'>" . formatSQL($query) . "</div>"; print "<script type=\"text/javascript\" language='javascript'> parent.transferQuery(); </script>\n"; } }
function createOutput($records, $sql, $description) { //Report Number and Name echo "<h3>" . $description . "</h3>"; echo "SQL Statement:"; echo "<p class='sqlStatement'> " . formatSQL($sql) . "</p>"; echo "<br>"; //Get Size of Data Array //get row count $row = sizeof($records); //get column count /*Count Recursive counts all elements in the array, But every row in the array has a title and data row thats why you have to divide with 2 and then divide with the amount of array rows*/ $column = (count($records, COUNT_RECURSIVE) - $row) / 2 / $row; //Get Titles $titles = getTitles($records); //Create Table createTable($records, $row, $column, $titles); }
/** * Shows all registered users in a list with filter and manage options */ function show_users() { global $xoopsSecurity, $rmTpl; define('RMCSUBLOCATION', 'allusers'); RMTemplate::get()->add_style('users.css', 'rmcommon'); RMTemplate::get()->add_style('js-widgets.css'); //Scripts RMTemplate::get()->add_script('users.js', 'rmcommon', array('directory' => 'include')); RMTemplate::get()->add_script('jquery.checkboxes.js', 'rmcommon', array('directory' => 'include')); RMTemplate::get()->add_head('<script type="text/javascript">var rmcu_select_message = "' . __('You have not selected any user!', 'rmcommon') . '"; var rmcu_message = "' . __('Dou you really wish to delete selected users?', 'rmcommon') . '";</script>'); $form = new RMForm('', '', ''); // Date Field $login1 = new RMFormDate('', 'login1', ''); $login1->addClass('form-control'); $login2 = new RMFormDate('', 'login2', ''); $login2->addClass('form-control'); // Registered Field $register1 = new RMFormDate('', 'registered1', ''); $register1->addClass('form-control'); $register2 = new RMFormDate('', 'registered2', ''); $register2->addClass('form-control'); RMBreadCrumb::get()->add_crumb(__('Users Management', 'rmcommon')); $rmTpl->assign('xoops_pagetitle', __('Users Management', 'rmcommon')); RMFunctions::create_toolbar(); // Show the theme xoops_cp_header(); $db = XoopsDatabaseFactory::getDatabaseConnection(); $sql = "SELECT COUNT(*) FROM " . $db->prefix("users") . " " . formatSQL(); $page = rmc_server_var($_REQUEST, 'pag', 1); $limit = rmc_server_var($_REQUEST, 'limit', 15); $order = rmc_server_var($_GET, 'order', 'uid'); list($num) = $db->fetchRow($db->query($sql)); $tpages = ceil($num / $limit); $page = $page > $tpages ? $tpages : $page; $start = $num <= 0 ? 0 : ($page - 1) * $limit; $nav = new RMPageNav($num, $limit, $page, 5); $nav->target_url('users.php?limit=' . $limit . '&order=' . $order . '&pag={PAGE_NUM}'); $sql = str_replace("COUNT(*)", '*', $sql); $sql .= "ORDER BY {$order} LIMIT {$start}, {$limit}"; $result = $db->query($sql); $users = array(); $t = array(); // Temporary while ($row = $db->fetchArray($result)) { $user = new RMUser(); $user->assignVars($row); $t = $user->getValues(); $t['groups'] = $user->getGroups(); $t = RMEvents::get()->run_event('rmcommon.loading.users.list', $t); $users[] = $t; $t = array(); } $xgh = new XoopsGroupHandler($db); $users = RMEvents::get()->run_event('rmcommon.users.list.loaded', $users); // Users template include RMTemplate::get()->get_template('rmc-users.php', 'module', 'rmcommon'); xoops_cp_footer(); }