Changeset 372
- Timestamp:
- 01/19/05 15:43:28 (8 years ago)
- Location:
- trunk/wifidog-auth/wifidog/classes
- Files:
-
- 2 modified
-
Session.php (modified) (6 diffs)
-
Statistics.php (modified) (4 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/wifidog-auth/wifidog/classes/Session.php
r216 r372 24 24 class Session{ 25 25 26 function Session() 27 { 26 function Session() { 28 27 $session_id = session_id(); 29 if(empty($session_id)) 30 { 28 if(empty($session_id)) { 31 29 session_start(); 32 30 } … … 39 37 * @return void 40 38 */ 41 function set($name,$value) 42 { 43 $_SESSION[$name]=$value; 39 function set($name,$value) { 40 $_SESSION[$name] = $value; 44 41 } 45 42 … … 49 46 * @return mixed value of session varaible 50 47 */ 51 function get($name) 52 { 53 if (isset($_SESSION[$name])) 54 { 48 function get($name) { 49 if (isset($_SESSION[$name])) { 55 50 return $_SESSION[$name]; 56 } 57 else 58 { 51 } else { 59 52 return false; 60 }53 } 61 54 } 62 55 … … 66 59 * @return boolean 67 60 */ 68 function remove($name) 69 { 70 if (isset($_SESSION[$name])) 71 { 61 function remove($name) { 62 if (isset($_SESSION[$name])) { 72 63 unset($_SESSION[$name]); 73 64 return true; 74 } 75 else 76 { 65 } else { 77 66 return false; 78 }67 } 79 68 } 80 69 … … 83 72 * @return void 84 73 */ 85 function destroy() 86 { 74 function destroy() { 87 75 $_SESSION = array(); 88 76 session_destroy(); … … 93 81 * @return void 94 82 */ 95 function dump() 96 { 83 function dump() { 97 84 echo "<pre>"; 98 85 print_r($_SESSION); -
trunk/wifidog-auth/wifidog/classes/Statistics.php
r296 r372 28 28 class Statistics{ 29 29 30 function Statistics() 31 { 30 function Statistics() { 32 31 } 33 32 … … 37 36 * @return Number of online users 38 37 */ 39 function getNumOnlineUsers($node_id=null) 40 { 41 global $db; 42 if($node_id!=null) 43 { 44 $node_id=$db->EscapeString($node_id); 45 $sql_node=" AND connections.node_id='$node_id'"; 46 } 47 else 48 { 49 $sql_node=""; 50 } 51 $db->ExecSqlUniqueRes("SELECT COUNT(DISTINCT users.user_id) FROM users,connections " . 38 function getNumOnlineUsers($node_id = null) { 39 global $db; 40 if ($node_id != null) { 41 $node_id = $db->EscapeString($node_id); 42 $sql_node = " AND connections.node_id='$node_id'"; 43 } else { 44 $sql_node = ""; 45 } 46 47 $db->ExecSqlUniqueRes("SELECT COUNT(DISTINCT users.user_id) FROM users,connections " . 52 48 "WHERE connections.token_status='" . TOKEN_INUSE . "' " . 53 "AND users.user_id=connections.user_id $sql_node " 54 ,$row, false); 55 return $row['count']; 49 "AND users.user_id=connections.user_id $sql_node ",$row, false); 50 return $row['count']; 56 51 } 57 52 … … 60 55 * @return Number of valid users 61 56 */ 62 function getNumValidUsers() 63 {64 global $db; 65 $db->ExecSqlUniqueRes("SELECT COUNT(user_id) FROM users WHERE account_status = ".ACCOUNT_STATUS_ALLOWED, $row, false);66 return $row['count'];57 function getNumValidUsers() { 58 global $db; 59 60 $db->ExecSqlUniqueRes("SELECT COUNT(user_id) FROM users WHERE account_status = " . ACCOUNT_STATUS_ALLOWED, $row, false); 61 return $row['count']; 67 62 } 68 63 … … 71 66 * @return Number of users 72 67 */ 73 function getNumUsers() 74 { 75 global $db; 76 $db->ExecSqlUniqueRes("SELECT COUNT(user_id) FROM users", $row, false); 77 return $row['count']; 68 function getNumUsers() { 69 global $db; 70 $db->ExecSqlUniqueRes("SELECT COUNT(user_id) FROM users", $row, false); 71 return $row['count']; 78 72 } 79 80 73 81 /**74 /** 82 75 * Find out the date of the most recent successfull (meaning with data transferred) connection to a HotSpot. 83 76 * @param $node_id Optionnal. The id of the node used for which you want the last successfull connection date 84 77 * @return Textual date 85 78 */ 86 function getLastConnDate($node_id=null) 87 { 88 global $db; 89 if($node_id!=null) 90 { 91 $node_id=$db->EscapeString($node_id); 92 $sql_node=" AND connections.node_id='$node_id'"; 93 } 94 else 95 { 96 $sql_node=""; 97 } 98 $db->ExecSqlUniqueRes("SELECT timestamp_in FROM connections WHERE incoming!=0 $sql_node ORDER BY timestamp_in DESC LIMIT 1",$row, false); 99 return $row['timestamp_in']; 79 function getLastConnDate($node_id = null) { 80 global $db; 81 82 if ($node_id != null) { 83 $node_id = $db->EscapeString($node_id); 84 $sql_node = " AND connections.node_id='$node_id'"; 85 } else { 86 $sql_node=""; 87 } 88 89 $db->ExecSqlUniqueRes("SELECT timestamp_in FROM connections WHERE incoming!=0 $sql_node ORDER BY timestamp_in DESC LIMIT 1", $row, false); 90 return $row['timestamp_in']; 100 91 } 101 92
