<?
// viewed.php
include "db_connection.php";
?>
<?
//Gets the id number assosiated with the webcam
$id=$_GET['id'];
// Connects to the SQL database
$dblink = mysql_connect($dbhostname,$dbusername, $dbpassword) OR DIE ("Unable to connect to database! Please try again later.");
mysql_select_db($dbname, $dblink);

// query the webcam table for the selected webcams information.
$query = "SELECT * FROM wcdatabase WHERE id = ($id) LIMIT 0, 30 ";

$result = mysql_query($query,$dblink);

$row = mysql_fetch_assoc($result);


// Obtain user IP address
$searchIP = mysql_escape_string( $_SERVER['REMOTE_ADDR'] );

// Query viewed table

$sql = "SELECT `camid` FROM `wcviewed_ip` WHERE `ip_bin`=INET_ATON('$searchIP')";

if( $resource=@mysql_unbuffered_query($sql, $dblink) )
{
    $sql = false;
    
    if( $row=@mysql_fetch_row($resource) )
    {
    
    echo ($row[0]. ' / '.$id);
        if( $row[0] != $id )
        {
            
            // insert the new visitor into the viewed table (IP Address, Cam viewed, todays date)
        
        $sql =    "INSERT INTO
                    `wcviewed_ip`
                    ( `ip_bin`, `camid`, `lastdate` )
                   VALUES
                    ( INET_ATON('$searchIP'), '$id', CURDATE() )";
                    
                    // Increment the number of time the Webcams has been viewed by 1.
                    $row["viewed"]++;
        
                    $viewed = $row["viewed"];
                    
                    // UPDATE the webcam table for the webcam viewed.
                    $query = "UPDATE wcdatabase SET viewed = ($viewed) where id = ($id)";

                    $result = mysql_query($query, $dblink); 
            
            
                        
        }
    }
    else
    {
        // Update viewed table for existing user.
           echo (update);
            $sql =    "UPDATE
                      `wcviewed_ip`
                            SET
                       `lastdate`=CURDATE()
                      
                 WHERE
                      `ip_bin`=INET_ATON('$searchIP')";
                      
                      // Increment the number of time the Webcams has been viewed by 1.
                    $row["viewed"]++;
        
                    $viewed = $row["viewed"];
                    
                    // UPDATE the webcam table for the webcam viewed.
                    $query = "UPDATE wcdatabase SET viewed = ($viewed) where id = ($id)";

                    $result = mysql_query($query, $dblink); 
                    
    }
    
    if( $sql )
    {
        @mysql_unbuffered_query( $sql, $dblink )
            or die( mysql_errno($dblink) . ' - ' . mysql_error($dblink) );
    }
}
else
{
    trigger_error( "Cannot add/update visitor data to `wcviewed_ip`; SQL query error; searchIP=$searchIP", E_USER_NOTICE );
} 
?>