Development/lmsweb/stat.php

<?php
$i=imagecreatefromgif('empty.gif');
imagegif($i);
require_once('lmsdb.php');

$hostname = $_GET['h'];
$ipaddr = str_replace("::ffff:","",$_SERVER['REMOTE_ADDR']);
list($version, $codename) = split(' ', $_GET['v']);

if($DB->GetOne('SELECT count FROM stat WHERE hostname=? AND version=?', array($hostname, $version)))
{
        echo mysql_error();
        $DB->Execute('UPDATE stat SET count=count+1, timestamp=UNIX_TIMESTAMP() WHERE hostname=? AND version=?', array($hostname, $version));
}
else
        $DB->Execute('INSERT INTO stat (hostname, version, count, timestamp) VALUES (?, ?, 1, UNIX_TIMESTAMP())', array($hostname, $version));


?>
1	<?php
2	$i=imagecreatefromgif('empty.gif');
3	imagegif($i);
4	require_once('lmsdb.php');
5
6	$hostname = $_GET['h'];
7	$ipaddr = str_replace("::ffff:","",$_SERVER['REMOTE_ADDR']);
8	list($version, $codename) = split(' ', $_GET['v']);
9
10	if($DB->GetOne('SELECT count FROM stat WHERE hostname=? AND version=?', array($hostname, $version)))
11	{
12	echo mysql_error();
13	$DB->Execute('UPDATE stat SET count=count+1, timestamp=UNIX_TIMESTAMP() WHERE hostname=? AND version=?', array($hostname, $version));
14	}
15	else
16	$DB->Execute('INSERT INTO stat (hostname, version, count, timestamp) VALUES (?, ?, 1, UNIX_TIMESTAMP())', array($hostname, $version));
17
18
19	?>