Advertisement
Guest User

Untitled

a guest
Aug 8th, 2017
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.09 KB | None | 0 0
  1.                       <?
  2. $server = '';
  3. $user = '';
  4. $pass = '';
  5. $db2 = '';
  6.  
  7. $db = mysql_connect($server, $user, $pass) or die("Could not connect.");
  8. if(!$db)
  9.     die("no db");
  10. if(!mysql_select_db("$db2",$db))
  11.     die("No database selected.");
  12. $server_time=date("U");
  13. $client_ip=$_SERVER['REMOTE_ADDR'];
  14.  
  15. $query = mysql_query("SELECT * FROM current_users WHERE ip='$client_ip'");
  16. $check = mysql_fetch_array($query);
  17. if($check) {
  18.     $update="UPDATE current_users set time='$server_time' where ip='$check[ip]'";
  19.     mysql_query($update) or die("Unable to process update: " . mysql_error());
  20. } else {
  21.   $sql = "INSERT INTO `current_users` (`ip`, `time`) VALUES ('$client_ip', '$server_time')";
  22.   $result = mysql_query($sql) or die("Unable to process insert: " . mysql_error());
  23. }
  24. $time=$server_time-600;
  25. $remove = "DELETE from current_users WHERE time<'$time'"; // Remove users outside time limit
  26. mysql_query($remove) or die("Unable to delete: " . mysql_error());
  27.  
  28. // Show the count
  29. $sql2 = mysql_query("SELECT ip FROM current_users" );
  30. $currentVisitors = mysql_num_rows($sql2);
  31. echo $currentVisitors;
  32. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement