|
SQL:
CREATE TABLE `logger` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`datum` VARCHAR( 30 ) NOT NULL ,
`nev` VARCHAR( 30 ) NOT NULL ,
`felhnev` VARCHAR( 30 ) NOT NULL ,
`mail` VARCHAR( 30 ) NOT NULL ,
`ok` VARCHAR( 30 ) NOT NULL ,
`ipcim` VARCHAR( 30 ) NOT NULL
) ENGINE = MYISAM ;
Itt: includes/joomla.php
Ez után: // @return float The current time in milliseconds
function getip()
{
if (isset($_SERVER))
{
if (isset($_SERVER["HTTP_X_FORWARDED_FOR"]))
{
$realip = $_SERVER["HTTP_X_FORWARDED_FOR"];
}
elseif (isset($_SERVER["HTTP_CLIENT_IP"]))
{
$realip = $_SERVER["HTTP_CLIENT_IP"];
}
else
{
$realip = $_SERVER["REMOTE_ADDR"];
}
}
else
{
if ( getenv( 'HTTP_X_FORWARDED_FOR' ) )
{
$realip = getenv( 'HTTP_X_FORWARDED_FOR' );
}
elseif ( getenv( 'HTTP_CLIENT_IP' ) )
{
$realip = getenv( 'HTTP_CLIENT_IP' );
}
else
{
$realip = getenv( 'REMOTE_ADDR' );
}
}
return $realip;
}
Ez előtt: // platform neurtral url handling
Itt: includes/joomla.php
Ez után: // update user visit data
$query = "SELECT name, username, email"
. "\n FROM #__users"
. "\n WHERE username = ". $this->_db->Quote( $username )
;
$this->_db->setQuery($query);
$this->_db->loadObject( $row );
$felhnev = $row->username;
$nev= $row->name;
$postafiok= $row->email;
$datum=Date("Y-m-d; H:i:s");
mysql_query("INSERT INTO logger ( id, datum, nev, felhnev, mail, ok, ipcim ) VALUES ( '', '" . $datum ."', '" . $nev . "', '" . $felhnev . "', '" . $postafiok . "', 'Bejelentkezett, valami.hu', '" . getip() ."')");
Ez elé: // set remember me cookie if selected
|
