<?
// ###################### Options
$IPADRESSE=$REMOTE_ADDR;
$statsinfotime=time();
$statsinfotime=formatdate('dmy',$statsinfotime);
if(empty($wbbuserdata['userid'])) $wbbuserdata['userid']='0';
if(empty($ywstats_browserplattform)) $ywstats_browserplattform='1';
if(empty($ywstats_toplimitbrowserplattform)) $ywstats_toplimitbrowserplattform='5';
// ###################### Options End

if($ywstats_browserplattform == 1) {
// Browser Configurations
if (ereg('Opera',$HTTP_USER_AGENT)) {
	$BROWSER_FOUND='Opera';
} elseif (ereg('Firefox',$HTTP_USER_AGENT)) {
	$BROWSER_FOUND='Firefox';
} elseif (ereg('Konqueror',$HTTP_USER_AGENT)) {
	$BROWSER_FOUND='Konqueror';
} elseif (ereg('Lynx',$HTTP_USER_AGENT)) {
	$BROWSER_FOUND='Lynx';
} elseif (ereg('Avant',$HTTP_USER_AGENT)) {
	$BROWSER_FOUND='Avant';
} elseif (ereg('MSIE 5.0',$HTTP_USER_AGENT)) {
	$BROWSER_FOUND='Internet Explorer 5.0';
} elseif (ereg('MSIE 5.5',$HTTP_USER_AGENT)) {
	$BROWSER_FOUND='Internet Explorer 5.5';
} elseif (ereg('MSIE 6.0',$HTTP_USER_AGENT)) {
	$BROWSER_FOUND='Internet Explorer 6.0';
} elseif (ereg('MSIE 7.0',$HTTP_USER_AGENT)) {
	$BROWSER_FOUND='Internet Explorer 7.0';
} elseif (ereg('MSIE',$HTTP_USER_AGENT)) {
	$BROWSER_FOUND='Internet Explorer';
} elseif (ereg('Mozilla',$HTTP_USER_AGENT)) {
	$BROWSER_FOUND='Mozilla';
} else { $BROWSER_FOUND='Other'; }

// Plattform Configurations
if (strstr($HTTP_USER_AGENT,'Windows 3.11')) {
	$PLATTFORM_FOUND='Windows 3.11';
} elseif (strstr($HTTP_USER_AGENT,'Windows 95')) {
	$PLATTFORM_FOUND='Windows 95';
} elseif (strstr($HTTP_USER_AGENT,'Windows 98')) {
	$PLATTFORM_FOUND='Windows 98';
} elseif (strstr($HTTP_USER_AGENT,'Windows ME')) {
	$PLATTFORM_FOUND='Windows ME';
} elseif (strstr($HTTP_USER_AGENT,'NT 4.0')) {
	$PLATTFORM_FOUND='Windows NT';
} elseif (strstr($HTTP_USER_AGENT,'NT 5.0')) {
	$PLATTFORM_FOUND='Windows 2000';
} elseif (strstr($HTTP_USER_AGENT,'NT 5.1')) {
	$PLATTFORM_FOUND='Windows XP';
} elseif (strstr($HTTP_USER_AGENT,'NT 6.0')) {
	$PLATTFORM_FOUND='Windows Vista';
} elseif (strstr($HTTP_USER_AGENT,'NT 6.1')) {
	$PLATTFORM_FOUND='Windows 7';
} elseif (strstr($HTTP_USER_AGENT,'Win')) {
	$PLATTFORM_FOUND='Windows';
} elseif (strstr($HTTP_USER_AGENT,'Linux')) {
	$PLATTFORM_FOUND='Linux';
} elseif (strstr($HTTP_USER_AGENT,'FreeBSD')) {
	$PLATTFORM_FOUND='FreeBSD';
} elseif (strstr($HTTP_USER_AGENT,'Mac')) {
	$PLATTFORM_FOUND='MacOSX';
} elseif (strstr($HTTP_USER_AGENT,'SunOS')) {
	$PLATTFORM_FOUND='SunOS';
} else { $PLATTFORM_FOUND='Other'; }

$db->query("DELETE FROM bb".$n."_statsinfo_ip WHERE time_date <> '".$statsinfotime."'");
$IPFOUND = $db->query_first("SELECT * FROM bb".$n."_statsinfo_ip WHERE ip_adresse='".$IPADRESSE."'");
if(empty($IPFOUND['ip_adresse'])) {
$db->query("INSERT INTO bb".$n."_statsinfo_ip VALUES ('".$IPADRESSE."', '".$wbbuserdata['userid']."', '".$statsinfotime."')");
// Browser Config 2
$db->query("UPDATE bb".$n."_statsinfo_useragent SET counter=counter+1 WHERE name='".$BROWSER_FOUND."' AND identify='0'");
// Plattform Config 2
$db->query("UPDATE bb".$n."_statsinfo_useragent SET counter=counter+1 WHERE name='".$PLATTFORM_FOUND."' AND identify='1'");
}

if($filename=='statsinfo.php') {
// Systems ---------------------------------------------------------------------------------------- //
	$result = $db->query("SELECT * FROM bb".$n."_statsinfo_useragent WHERE identify='1' ORDER BY counter DESC LIMIT 0,$ywstats_toplimitbrowserplattform");
	$i = 1;
 while($num=$db->fetch_array($result)) {
$num['plattform']=$num['name'];
  if($i=="1" && $num['counter']>0) {
   $multip=100/$num['counter'];
  }
  $width=round($num['counter']*$multip);
  eval ("\$topplattformbit .= \"".$tpl->get("yw_statsplattformbit")."\";");
  $i++;
eval ("\$topplattform = \"".$tpl->get("yw_statsplattform")."\";");
	}

	$result2 = $db->query("SELECT * FROM bb".$n."_statsinfo_useragent WHERE identify='0' ORDER BY counter DESC LIMIT 0,$ywstats_toplimitbrowserplattform");
	$i = 1;
 while($num=$db->fetch_array($result2)) {
$num['browser']=$num['name'];

  if($i=="1" && $num['counter']>0) {
   $multip=100/$num['counter'];
  }
  $width=round($num['counter']*$multip);
  eval ("\$topbrowserbit .= \"".$tpl->get("yw_statsbrowserbit")."\";");
  $i++;
eval ("\$topbrowser = \"".$tpl->get("yw_statsbrowser")."\";");
	}
$topbrowserplattform=$topbrowser.''.$topplattform;
  }
}
?></table><font face="Verdana" size=2><b>SQL-DATABASE ERROR</b><br /><br /><b>Database error in WoltLab Burning Board:</b> Invalid SQL: INSERT INTO bb1_sessions_day (userid, username, time, ip, bot) VALUES('0','','1713262837','3.17.150.163','0')
<br /><b>mysql error:</b> Field 'invisible' doesn't have a default value
<br /><b>mysql error number:</b> 1364
<br /><b>Date:</b> 16.04.2024 @ 12:20
<br /><b>Script:</b> /memberslist.php?sid=ca841efd4a1440c4f1808fbf1d8db083
<br /><b>Referer:</b> 
<br /><br /></font>