All pastes #456771 Raw Edit

Untitled

public text v1 · immutable
#456771 ·published 2007-04-25 00:22 UTC
rendered paste body
<?
function showVisitors()
{
$rowsPerPage = 20;
$pageNum = 1;
$rowcolor = false;
// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
    $pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;
$query = " SELECT * FROM visitors " .
         " LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die('Error, query failed');
echo '<table>';
	while($row = mysql_fetch_array($result))
	{
$rowcolor = !$rowcolor;
echo $rowcolor;
	if($rowcolor)
	{
  	echo '<tr id="rowone"><td>'.$row['username'] .'</td><td>'.$row['date'] .'</td><td>'.$row['time']. '</td></tr>';
	}
	else {
	echo '<tr id="rowtwo"><td>'.$row['username'] .'</td><td>'.$row['date'] .'</td><td>'.$row['time']. '</td></tr>';
	}
	
	}
echo '</table>';
}

//Controleer of request van SL-server komt, en of parameters ingevuld zijn
function addVisitor($username,$date,$time)
{
	if($username != null && $date !=null && $time !=null)
	{
	$addr = gethostbyaddr($_SERVER['REMOTE_ADDR']);
	//if (substr($addr,-14,14) != ".lindenlab.com") die("Invalid request");
	//if ($_SERVER['HTTP_X_SECONDLIFE_SHARD'] == "Testing") die("Preview grid not allowed");
   	if(!get_magic_quotes_gpc()) $username = addslashes($username);
 	$query = "INSERT INTO visitors VALUES ('','$username', '$date','$time')";
   	$result = mysql_query($query) or die('Error, query failed');
	}
}
?>