WP-OnlineCounter (Créer un compte)

query(‘DELETE FROM wp_onlinecounter WHERE timestamp get_var(« SELECT timestamp FROM wp_onlinecounter WHERE ip = ‘$user_ip' »);
  if (empty($current_visitor_time))
  $current_visitor_time = 0;
  
  $max_onlineusers = get_option(‘wp-onlinecounter_maxonline’);

  if ($current_visitor_time == 0)
  {
    $total_count++;
    update_option(‘wp-onlinecounter_totalcount’, $total_count);
    $insert = $wpdb->query(« INSERT INTO wp_onlinecounter VALUES (‘$user_ip’, $timestamp) »);
  }
  elseif ($current_visitor_time query(« UPDATE wp_onlinecounter SET ‘timestamp’ = $timestamp WHERE ip = ‘$user_ip' »);
  
  $current_online = $wpdb->query(« SELECT COUNT(ip) FROM wp_onlinecounter »);
    
  if ($current_online > $max_onlineusers)
  	update_option(‘wp-onlinecounter_maxonline’, $current_online);

  if ($show)
  {
   	echo ‘<li>‘,$current_online,’ visiteurs en ligne actuellement</li>‘;
   	echo ‘<li>‘,$max_onlineusers,’ visiteurs connectés (record)</li>‘;
 		echo ‘<li>‘,$total_count,’ visiteurs au total</li>‘;
  }
}

//function to create the table on plugin activation
add_action(‘activate_wp-onlinecounter.php’,’wpoc_install’);
function wpoc_install () {
	global $table_prefix, $wpoc_tablename, $wpdb;

	$table = $table_prefix . $wpoc_tablename;
	if($wpdb->get_var(« show tables like ‘$table' ») != $table) {
      
		$sql = « CREATE TABLE « .$table. » (
				timestamp int(15) NOT NULL default ‘0’,
				ip varchar(15) NOT NULL default  »,
				count int(15) NOT NULL default ‘0’,
				maxon int(6) NOT NULL default ‘0’,
				maxontime int(15) NOT NULL default ‘0’,
				uri text NOT NULL default  »,
				PRIMARY KEY  (timestamp, ip)
		); »;

		require_once(ABSPATH . ‘wp-admin/upgrade-functions.php’);
		dbDelta($sql);
	}elseif($wpdb->get_var(« SHOW COLUMNS FROM « .$table. » LIKE ‘uri' ») != ‘uri’) {
  		$wpdb->query(« ALTER TABLE wp_onlinecounter ADD uri TEXT NOT NULL »);
	}
  
}
?>

query(‘DELETE FROM ‘.$table_prefix.’onlinecounter WHERE oc_timestamp get_var(‘SELECT oc_timestamp FROM ‘.$table_prefix.’onlinecounter WHERE oc_ip =  ».$_SERVER[‘REMOTE_ADDR’]. »’);

  $total_count = get_option(‘wp-onlinecounter_totalcount’);
  
  if (!$current_visitor_time)
  {
    update_option(‘wp-onlinecounter_totalcount’, ++$total_count);
    $wpdb->query(‘INSERT INTO ‘.$table_prefix.’onlinecounter (oc_ip, oc_timestamp) VALUES ( ».$_SERVER[‘REMOTE_ADDR’]. », ‘.time().’)’);
  }
  else
    $wpdb->query(‘UPDATE ‘.$table_prefix.’onlinecounter SET oc_timestamp = ‘.time().’ WHERE oc_ip =  ».$_SERVER[‘REMOTE_ADDR’]. »’);
  
  $current_online = $wpdb->get_var(‘SELECT COUNT(*) FROM ‘.$table_prefix.’onlinecounter’);
    
  if ($show)
    echo ‘<li>‘,$current_online,’ visiteurs en ligne actuellement</li><li>‘,$total_count,’ visiteurs au total</li>‘;
}


add_action(‘activate_wp-onlinecounter.php’,’wpoc_install’);
function wpoc_install ()
{
	global $table_prefix, $wpdb;

	if ($wpdb->get_var(‘SHOW TABLES LIKE ‘.$table_prefix.’onlinecounter’) != $table_prefix.’onlinecounter’)
  {
		require_once(ABSPATH.’wp-admin/upgrade-functions.php’);
		dbDelta(‘CREATE TABLE ‘.$table_prefix.’onlinecounter (oc_timestamp BIGINT (20) NOT NULL default ‘0’,
				                                                  oc_ip        VARCHAR(20) NOT NULL default  »,
                                          				        PRIMARY KEY  (oc_ip)
                                                          );’);
	}
}
?>

$wpdb->query(‘INSERT INTO table_name  (timestamp,  ip)
                                      (‘.time(). », ‘{$_SESSION[‘REMOTE_ADDR’]}’
              ON DUPLICATE KEY UPDATE
                                       timestamp = « .time());