МОЛЯ ЗА МАЛКО ПОМОЩ.

[niki690]

Имам нужда от малко помощ това е скрипт които записва. url ,date , browser ,ip--- Но искам да се добави и потребителя на когото е ип адреса .


<?php
require_once ('Settings.php');
require_once('Sources/Load.php');


function curPageURL() {
$pageURL = 'http';
if (isset ($_SERVER["HTTPS"])&&$_SERVER["HTTPS"] == "on") {$pageURL .= "s";}
$pageURL .= "://";
if ($_SERVER["SERVER_PORT"] != "80") {
$pageURL .= $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"];
} else {
$pageURL .= $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"];
}
return $pageURL;
}

function trackIp ()
{


$pageURL=null;
$date=null;
$browser=null;
$ip=null;
global $db_server;
global $db_user;
global $db_passwd;
global $db_name;
global $db_prefix;


$pageURL=curPageURL();

$date=date('Y-m-d H:i:s');


//$browser = get_browser(null, true);
//print_r($browser);

if ( isset($_SERVER['HTTP_CLIENT_IP']) && ! empty($_SERVER['HTTP_CLIENT_IP'])) {
$ip = $_SERVER['HTTP_CLIENT_IP'];
} elseif ( isset($_SERVER['HTTP_X_FORWARDED_FOR']) && ! empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
} else {
$ip = (isset($_SERVER['REMOTE_ADDR'])) ? $_SERVER['REMOTE_ADDR'] : '0.0.0.0';
}

$ip = filter_var($ip, FILTER_VALIDATE_IP);
$ip = ($ip === false) ? '0.0.0.0' : $ip;

$conn = mysql_connect($db_server, $db_user, $db_passwd,true) or die ('Error connecting to mysql');
mysql_select_db($db_name);

$table=$db_prefix.'userlog';

if(mysql_num_rows(mysql_query("SHOW TABLES LIKE '".$table."'"))==1)
{


//$pageURL=mysql_real_escape_string($pageURL);

// $browser=mysql_real_escape_string($_SERVER['HTTP_USER_AGENT']);



/* $sql = "INSERT INTO '.$table. '(url, browser, date,ip)
VALUES ('$pageURL', '$browser','$date','$ip')";

$result = mysql_query($sql) or die (mysql_error());
mysql_close($conn);*/
}
else
{
$sql = "CREATE TABLE $table( ".
"id INT NOT NULL AUTO_INCREMENT, ".
"url VARCHAR(255) NOT NULL, ".
"date DATETIME NOT NULL, ".
"browser VARCHAR (255) NOT NULL, ".
"ip VARCHAR (255) NOT NULL, ".
"primary key ( id ))";
mysql_query($sql);


}
$pageURL=mysql_real_escape_string($pageURL);

$browser=mysql_real_escape_string($_SERVER['HTTP_USER_AGENT']);

$sql = "INSERT INTO `$table` (url, browser, date,ip)
VALUES ('$pageURL', '$browser','$date','$ip')";

$result = mysql_query($sql) or die (mysql_error());
mysql_close($conn);



}



?>