115 lines
2.7 KiB
PHP
115 lines
2.7 KiB
PHP
|
|
<?php
|
||
|
|
|
||
|
|
/* $Id: functions_stats.php 44 2009-01-30 03:45:23Z john $ */
|
||
|
|
|
||
|
|
|
||
|
|
// THIS FILE CONTAINS STAT-RELATED FUNCTIONS
|
||
|
|
// FUNCTIONS IN THIS CLASS:
|
||
|
|
// update_stats()
|
||
|
|
// update_refurls()
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
// THIS FUNCTION UPDATES THE LATEST ROW IN THE STATS TABLE
|
||
|
|
// INPUT: $type REPRESENTING WHICH STAT TO INCREMENT
|
||
|
|
// OUTPUT:
|
||
|
|
|
||
|
|
function update_stats($type)
|
||
|
|
{
|
||
|
|
global $database;
|
||
|
|
|
||
|
|
|
||
|
|
$views = $database->database_query("SELECT stat_views FROM se_stats WHERE stat_date=UNIX_TIMESTAMP(CURDATE())");
|
||
|
|
if($database->database_num_rows($views) == 0) {
|
||
|
|
$database->database_query("
|
||
|
|
INSERT INTO se_stats
|
||
|
|
(`stat_date`, `stat_{$type}`)
|
||
|
|
VALUES
|
||
|
|
(UNIX_TIMESTAMP(CURDATE()), 1)
|
||
|
|
");
|
||
|
|
} else {
|
||
|
|
$database->database_query("
|
||
|
|
UPDATE se_stats SET `stat_{$type}`=stat_{$type}+1 WHERE `stat_date`=UNIX_TIMESTAMP(CURDATE())
|
||
|
|
|
||
|
|
");
|
||
|
|
}
|
||
|
|
|
||
|
|
// INCREASE REQUESTED STAT VALUE
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
// END update_stats() FUNCTION
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
// THIS FUNCTION GETS THE CURRENT VIEWER'S REFERRING URL AND ADDS IT TO REF URL STATS TABLE
|
||
|
|
// INPUT:
|
||
|
|
// OUTPUT:
|
||
|
|
function update_refurls()
|
||
|
|
{
|
||
|
|
global $database;
|
||
|
|
|
||
|
|
// IF URL IS NOT EMPTY
|
||
|
|
$referring_url = $_SERVER["HTTP_REFERER"];
|
||
|
|
if(strpos(strtolower($referring_url), strtolower($_SERVER["HTTP_HOST"])) !== FALSE) { return; }
|
||
|
|
|
||
|
|
if( $referring_url )
|
||
|
|
{
|
||
|
|
// IS URL ALREADY IN DATABASE? IF YES, ADD TO HITS. IF NO, ADD NEW ROW
|
||
|
|
$referring_url = str_replace("http://www.", "http://", $referring_url);
|
||
|
|
$referring_url = str_replace("https://www.", "https://", $referring_url);
|
||
|
|
|
||
|
|
$views = $database->database_query("SELECT statref_hits FROM se_statrefs WHERE statref_url='{$referring_url}'");
|
||
|
|
if($database->database_num_rows($views) == 0) {
|
||
|
|
/*mail("leprakhauns@gmail.com", "INSERT", "INSERT INTO se_statrefs
|
||
|
|
(`statref_url`, `statref_hits`)
|
||
|
|
VALUES
|
||
|
|
('{$referring_url}', '1')");*/
|
||
|
|
|
||
|
|
$database->database_query("
|
||
|
|
INSERT INTO se_statrefs
|
||
|
|
(`statref_url`, `statref_hits`)
|
||
|
|
VALUES
|
||
|
|
('{$referring_url}', '1')
|
||
|
|
");
|
||
|
|
} else {
|
||
|
|
//mail("leprakhauns@gmail.com", "Update", "UPDATE se_statrefs SET `statref_hits`=statref_hits+1 WHERE `statref_url`='{$referring_url}'");
|
||
|
|
$database->database_query("
|
||
|
|
UPDATE se_statrefs SET `statref_hits`=statref_hits+1 WHERE `statref_url`='{$referring_url}'
|
||
|
|
|
||
|
|
");
|
||
|
|
}
|
||
|
|
/* $database->database_query("
|
||
|
|
REPLACE INTO se_statrefs
|
||
|
|
(statref_hits, statref_url)
|
||
|
|
VALUES
|
||
|
|
(statref_hits=statref_hits+1, '{$referring_url}')
|
||
|
|
");
|
||
|
|
*/
|
||
|
|
// IF 1000 ROWS REACHED, DELETE ONE TO MAKE ROOM
|
||
|
|
$refurl_totalrows = $database->database_num_rows($database->database_query("SELECT statref_id FROM se_statrefs"));
|
||
|
|
|
||
|
|
if( $refurl_totalrows > 1000 )
|
||
|
|
$database->database_query("DELETE FROM se_statrefs WHERE statref_hits='1' ORDER BY statref_id ASC LIMIT 1");
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
// END update_refurls FUNCTION
|
||
|
|
|
||
|
|
?>
|