Counter - adv

200 point er mere realistisk :)

Ja, det vil jeg også mene :)

så siger vi 200 =D

har du mysql mulighed?

yes yes

lukker. nu..

Hvorfor?

Tabellen reggedvisitors i databasen counter:

CREATE TABLE reggedvisitors (
  id int(11) NOT NULL auto_increment,
  ip varchar(15) NOT NULL default '',
  tid timestamp(14) NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

visitip.php:
<?php
$visitor = $_SERVER['REMOTE_ADDR'];
$cn = mysql_connect("localhost", "root", "");
mysql_select_db("counter", $cn) OR DIE(mysql_error());
$ipquery = "SELECT * FROM reggedvisitors WHERE ip='" . $visitor . "'";
$resultset = mysql_query($ipquery);
if($tidligere = mysql_fetch_array($resultset))
{
    if(date("d-M-Y", $tidligere['tid']) < date("d-M-Y", time()))
    {
    $timequery = "UPDATE reggedvisitors SET tid = " . time() . ", ip ='" . $visitor . "' WHERE id = " . $tidligere['id'];
    }
} else {
    $timequery = "INSERT INTO reggedvisitors (ip, tid) VALUES ('$visitor', " . time() . ")";
}
mysql_query($timequery) OR DIE(mysql_error());
?>

taelleren.php:
<?php
include("./visitip.php");
$idag = 0;
$maaned = 0;
$aar = 0;
$idagquery = "SELECT id, ip, UNIX_TIMESTAMP(tid) FROM reggedvisitors";
$resultat = mysql_query($idagquery);
$visittotal = mysql_num_rows($resultat);
while($dagresult = mysql_fetch_array($resultat))
{

$idag += date("d", strtotime($dagresult['tid'])) == date("d", time());
$maaned += date("n", strtotime($dagresult['tid'])) == date("n", time());
$aar += date("Y", strtotime($dagresult['tid'])) == date("Y", time());
}

// Her definerer du hvordan tabellen skal være //
?>
<center>
<table cols="1" rows="4" width="250" bgcolor="#AAAAAA">
<tr><td><?php echo "Idag: " . $idag ?></td></tr>
<tr><td><?php echo "Denne Måned: " . $maaned ?></td></tr>
<tr><td><?php echo "Dette År: " . $aar ?></td></tr>
<tr><td><?php echo "Gæster ialt: " . $visittotal ?></td></tr>
</table>
</center>
<?php
mysql_close($cn);
?>

//sostack