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