Fejl i statistik-funktion
Jeg har et problem med min funktion, som gør at jeg får en hvid skærm frem når den er aktiv, men når jeg deaktivere den, så kommer siden frem. Det skal siges at jeg har fået det til at virke, men så efter et stykke tid så virker det ikke.Er der en der kan finde fejlen ?
function stats() {
global $ip, $id, $actions, $adminid, $level, $host, $refere, $current_date, $userid;
global $HTTP_USER_AGENT, $REMOTE_ADDR, $HTTP_REFERER;
$ids = $id;
$id = \'\';
if ($ids != \'\') {
if ($actions == \'nyheder\') { $level = 3; }
elseif ($actions == \'artikler\') { $level = 1; }
elseif ($actions == \'interviews\') { $level = 2; }
elseif ($actions == \'klumme\') { $level = 4; }
elseif ($actions == \'indlaeg\') {
$level = 5;
$rs_check1 = mysql_fetch_row( sql(\"SELECT * FROM articles WHERE id = \'$ids\' AND typeid = \'$level\' AND adminid = \'$adminid\'\"));
if ($rs_check1 == (false)) {
header(\"Location: http://www.fck-online.dk\");
exit;
}
}
$rs_check = mysql_fetch_row(sql(\"SELECT * FROM articles WHERE id = \'$ids\' AND typeid = \'$level\'\"));
if ($rs_check == (false)) {
header(\"Location: http://www.fck-online.dk\");
exit;
}
}
$ip = $REMOTE_ADDR;
$host = gethostbyaddr($ip);
$refere = $HTTP_REFERER;
if (empty($refere)) { $refere = \'Direkte\'; }
$current_date = date(time());
// Get the Browser data
if((ereg(\"Nav\", getenv(\"HTTP_USER_AGENT\"))) || (ereg(\"Gold\", getenv(\"HTTP_USER_AGENT\"))) || (ereg(\"X11\", getenv(\"HTTP_USER_AGENT\"))) || (ereg(\"Mozilla\", getenv(\"HTTP_USER_AGENT\"))) || (ereg(\"Netscape\", getenv(\"HTTP_USER_AGENT\"))) AND (!ereg(\"MSIE\", getenv(\"HTTP_USER_AGENT\")))) $browser = \"Netscape\";
elseif(ereg(\"MSIE\", getenv(\"HTTP_USER_AGENT\"))) $browser = \"MSIE\";
elseif(ereg(\"Lynx\", getenv(\"HTTP_USER_AGENT\"))) $browser = \"Lynx\";
elseif(ereg(\"Opera\", getenv(\"HTTP_USER_AGENT\"))) $browser = \"Opera\";
elseif(ereg(\"WebTV\", getenv(\"HTTP_USER_AGENT\"))) $browser = \"WebTV\";
elseif(ereg(\"Konqueror\", getenv(\"HTTP_USER_AGENT\"))) $browser = \"Konqueror\";
elseif((eregi(\"bot\", getenv(\"HTTP_USER_AGENT\"))) || (ereg(\"Google\", getenv(\"HTTP_USER_AGENT\"))) || (ereg(\"Slurp\", getenv(\"HTTP_USER_AGENT\"))) || (ereg(\"Scooter\", getenv(\"HTTP_USER_AGENT\"))) || (eregi(\"Spider\", getenv(\"HTTP_USER_AGENT\"))) || (eregi(\"Infoseek\", getenv(\"HTTP_USER_AGENT\")))) $browser = \"Bot\";
else $browser = \"Other\";
/* Get the Operating System data */
if(ereg(\"Win\", getenv(\"HTTP_USER_AGENT\"))) $os = \"Windows\";
elseif((ereg(\"Mac\", getenv(\"HTTP_USER_AGENT\"))) || (ereg(\"PPC\", getenv(\"HTTP_USER_AGENT\")))) $os = \"Mac\";
elseif(ereg(\"Linux\", getenv(\"HTTP_USER_AGENT\"))) $os = \"Linux\";
elseif(ereg(\"FreeBSD\", getenv(\"HTTP_USER_AGENT\"))) $os = \"FreeBSD\";
elseif(ereg(\"SunOS\", getenv(\"HTTP_USER_AGENT\"))) $os = \"SunOS\";
elseif(ereg(\"IRIX\", getenv(\"HTTP_USER_AGENT\"))) $os = \"IRIX\";
elseif(ereg(\"BeOS\", getenv(\"HTTP_USER_AGENT\"))) $os = \"BeOS\";
elseif(ereg(\"OS/2\", getenv(\"HTTP_USER_AGENT\"))) $os = \"OS/2\";
elseif(ereg(\"AIX\", getenv(\"HTTP_USER_AGENT\"))) $os = \"AIX\";
else $os = \"Other\";
$stat = mysql_fetch_row( sql(\"SELECT * FROM stats WHERE endDate > \'$current_date\' - 3600 AND ip = \'$ip\' AND browser = \'$browser\' AND os = \'$os\'\")) or die(mysql_error());
if ($stat == (true)) {
$ok = sql(\"UPDATE stats SET endDate = \'$current_date\' WHERE ip = \'$ip\' AND browser = \'$browser\' AND os = \'$os\'\");
} else {
$ok = sql(\"INSERT INTO stats (ip, hostname, statsdate, endDate, wherefrom, browser, os, userid) VALUES (\'$ip\', \'$host\', \'$current_date\', \'$current_date\', \'$refere\', \'$browser\', \'$os\')\") or die(mysql_error());
}
$rs_stats = sql(\"SELECT id AS statsid FROM stats WHERE endDate > \'$current_date\' - 3600 AND ip = \'$ip\' AND browser = \'$browser\' AND os = \'$os\'\") or die(mysql_error());
if ($row_stats = mysql_fetch_array($rs_stats)) { extract($row_stats); }
if (isset($actions)) {
$rs_menu = sql(\"SELECT id AS menuid FROM menu WHERE actions = \'$actions\'\");
if ($row_menu = mysql_fetch_array($rs_menu)) { extract($row_menu); }
$stat1 = mysql_fetch_row(sql(\"SELECT * FROM statsMenu WHERE statsID = \'$statsid\' AND menuID = \'$menuid\' AND endDate > \'$current_date\' - 300\"));
if ($stat1 == (true)) {
$ok = sql(\"UPDATE statsMenu SET endDate = \'$current_date\' WHERE statsID = \'$statsid\' AND menuID = \'$menuid\'\") or die(mysql_error());
} else {
$ok = sql(\"INSERT INTO statsMenu (statsID, menuID, beginDate, endDate) VALUES (\'$statsid\', \'$menuid\', \'$current_date\', \'$current_date\')\") or die (mysql_error());
}
}
if ($ids != \'\') {
if ($actions == \'indlaeg\') {
$stat2 = mysql_fetch_row(sql(\"SELECT * FROM statsArticle WHERE statsID = \'$statsid\' AND articleID = \'$id\' AND endDate > \'$current_date\' - 300 AND levelID = \'$level\' AND adminID = \'$adminid\'\"));
} else {
$stat2 = mysql_fetch_row(sql(\"SELECT * FROM statsArticle WHERE statsID = \'$statsid\' AND articleID = \'$id\' AND endDate > \'$current_date\' - 300 AND levelID = \'$level\'\"));
}
if ($stat2 == (true)) {
if ($action == \'indlaeg\') {
$ok = sql(\"UPDATE statsArticle SET endDate = \'$current_date\' WHERE statsID = \'$statsid\' AND articleID = \'$ids\' AND levelID = \'$level\' AND adminID = \'$adminid\'\") or die(mysql_error());
} else {
$ok = sql(\"UPDATE statsArticle SET endDate = \'$current_date\' WHERE statsID = \'$statsid\' AND articleID = \'$ids\' AND levelID = \'$level\'\") or die(mysql_error());
}
} else {
$ok = sql(\"INSERT INTO statsArticle (statsID, articleID, levelID, adminID, beginDate, endDate) VALUES (\'$statsid\', \'$ids\', \'$level\', \'$adminid\', \'$current_date\', \'$current_date\')\") or die (mysql_error());
}
}
if ($ok == \'\') { $ok = \"fejl\"; }
return print $ok;
}
