+++ /dev/null
-<?php\r
-/*\r
-Admin LDAP statistics page\r
-\r
-Maintainer smal (Serhiy Voyt)\r
-smalgroup@gmail.com\r
-\r
-Version 0.2\r
-10.11.2008\r
-\r
-Distributed under GPL (c)Sehiy Voyt 2005-2009\r
-*/\r
-define('AT_INCLUDE_PATH', '../include/');\r
-require (AT_INCLUDE_PATH.'vitals.inc.php');\r
-if ($_SERVER['REQUEST_METHOD'] == 'POST'){\r
- /* Get POST variables from jqGrid request */\r
- $page = intval($_POST['page']);\r
- $limit = intval($_POST['rows']);\r
- $sidx = addslashes($_POST['sidx']);\r
- $sord = addslashes($_POST['sord']);\r
- if(!$sidx) $sidx = 1;\r
- if ($sord == 'desc'){\r
- $sord = 'DESC';\r
- }else{\r
- $sord = 'ASC';\r
- }\r
- $sql = "SELECT COUNT(*) as count FROM ".TABLE_PREFIX."ldap_log";\r
- $result = mysql_query($sql, $db);\r
- $row = mysql_fetch_assoc($result);\r
- $count = $row['count'];\r
- if ($count > 0 ) {\r
- $total_pages = ceil($count/$limit);\r
- } else {\r
- $total_pages = 0;\r
- }\r
- if ($page > $total_pages) $page = $total_pages;\r
- $start = $limit*$page - $limit;\r
- if ($start < 0) $start = 0;\r
- $sql = "SELECT L.member_id, M.login, CONCAT(M.last_name, ' ', M.first_name, ' ', M.second_name) AS full_name, \r
- M.email, L.create_date, L.ldap_source FROM AT_ldap_log L LEFT JOIN AT_members M USING (member_id) ORDER BY ".$sidx." ".$sord. " \r
- LIMIT ".$start." , ".$limit;\r
- $result = mysql_query($sql, $db);\r
- // Construct the json data\r
- $response->page = $page; // current page\r
- $response->total = $total_pages; // total pages\r
- $response->records = $count; // total records\r
- $i=0;\r
- while($row = mysql_fetch_array($result)) {\r
- $response->rows[$i]['id']=$row[member_id]; //id \r
- $response->rows[$i]['cell']=array($row[member_id],\r
- $row[login],\r
- addslashes($row[full_name]),\r
- $row[email],\r
- $row[create_date],\r
- $row[ldap_source]);\r
- $i++;\r
- } \r
- echo json_encode($response);\r
- exit();\r
-}\r
-require (AT_INCLUDE_PATH.'header.inc.php'); \r
-?>\r
-<link rel="stylesheet" type="text/css" media="screen" href="/jscripts/jqgrid/themes/basic/grid.css" />\r
-<link rel="stylesheet" type="text/css" media="screen" href="/jscripts/jqgrid/themes/jqModal.css" />\r
-<script src="/jscripts/jqgrid/jquery.js" type="text/javascript"></script>\r
-<script src="/jscripts/jqgrid/jquery.jqGrid.js" type="text/javascript"></script>\r
-<script src="/jscripts/jqgrid/js/jqModal.js" type="text/javascript"></script>\r
-<script src="/jscripts/jqgrid/js/jqDnR.js" type="text/javascript"></script>\r
-<script type="text/javascript"> \r
- jQuery(document).ready(function(){ \r
- jQuery("#ldapuserlist").jqGrid({ \r
- url:'/admin/ldap_auth_log.php', \r
- datatype: 'json', \r
- mtype: 'POST', \r
- colNames:[\r
- '<?php echo(addslashes(_AT('ID')));?>',\r
- '<?php echo(addslashes(_AT('login_name')));?>', \r
- '<?php echo(addslashes(_AT('full_name')));?>',\r
- '<?php echo(addslashes(_AT('email')));?>', \r
- '<?php echo(addslashes(_AT('created_date')));?>',\r
- '<?php echo(addslashes(_AT('ldap_source')));?>'], \r
- colModel :[ \r
- {name:'member_id', index:'member_id', width:30}, \r
- {name:'login', index:'login', width:85},\r
- {name:'last_name', index:'last_name', width:200},\r
- {name:'email', index:'email', width:130},\r
- {name:'create_date', index:'create_date', width:110},\r
- {name:'ldap_source', index:'ldap_source', width:90}], \r
- pager: jQuery('#pager'), \r
- rowNum:50, \r
- rowList:[50,100,150],\r
- sortname: 'create_date', \r
- sortorder: "desc", \r
- viewrecords: true, \r
- imgpath: '/jscripts/jqgrid/themes/basic/images', \r
- caption: 'LDAP Auth Log',\r
- width: 850,\r
- height: 'auto'\r
- }).navGrid('#pager',{\r
- refresh:true,\r
- edit: false,\r
- add: false,\r
- del: false,\r
- search: false,\r
- position: 'right'\r
- } \r
- ); \r
- }); \r
-</script> \r
-<div>\r
-<table id="ldapuserlist" class="scroll"></table> \r
-<div id="pager" class="scroll" style="text-align:center;"></div>\r
-</div>\r
-<?php\r
-require (AT_INCLUDE_PATH.'footer.inc.php'); ?>\r