Files
Testing/include/functions_stats.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

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
?>