<?
$filename="formel_main.php";

require("./global.php");
if (!ini_get('register_globals')) { //globals = OFF ??

		$types_to_register = array('GET','POST','COOKIE','SESSION','SERVER');

		foreach ($types_to_register as $type){

			if (@count(${'HTTP_' . $type . '_VARS'}) > 0){

				extract(${'HTTP_' . $type . '_VARS'}, EXTR_OVERWRITE);

			}

		}

	}
if(!$wbbuserdata['userid']) access_error();

if($location == "main" || $location == "") { 
 $box = "";
 $result = $db->query_first("SELECT * FROM bb".$n."_formel_config");
 $akt_rennen = $result['akt_rennen'];
 if($result['akt_rennen']!=0) {
  $tipp_ende = date("d.m.Y - H:i", $result['akt_tippende']);
  $boardid = $result['tipp_board'];
  $result = $db->query_first("SELECT * FROM bb".$n."_formel_rennen WHERE rennid = '".$akt_rennen."'");
  $threadid = $result['threadid'];
  $postid = $result['postid'];
  $name = stripslashes($result['name']);
  $streckenid = $result['streckenid'];
  $datum = date("d.m.Y", $result['datum']);
  $result2 = $db->query_first("SELECT * FROM bb".$n."_formel_strecken WHERE streckenid = '".$streckenid."'");
  $s_name = stripslashes($result2['name']);
  $s_land = stripslashes($result2['land']);
  $s_ort = stripslashes($result2['ort']);
  $s_laenge11 = intval($result2['laenge']);
  $s_runden = intval($result2['runden']);
  $s_laenge21 = $s_runden * $s_laenge11;
  $s_laenge12 = number_format(($s_laenge11/1000), 3, ',', '');
  $s_laenge22 = number_format(($s_laenge21/1000), 3, ',', '');
  $s_last_pole = stripslashes($result2['last_pole']);
  $s_last_sieger = stripslashes($result2['last_sieger']);
  $s_rekord = stripslashes($result2['rekord_strecke']);
  $s_image = makeimgtag(stripslashes($result2['image']), $s_name);
  $s_url = makehreftag(stripslashes($result2['url']), "&raquo; hier &laquo;", "_target");
  $result = $db->query_first("SELECT * FROM bb".$n."_formel_tipps WHERE rennid = '".$akt_rennen."' AND userid = '".$wbbuserdata['userid']."'");
  if($result['datum']) {
   $usertipp = "am ".date("d.m.Y", $result['datum'])." um ".date("H:i", $result['datum']);
  } else {
   $usertipp = "noch nicht";
  } 
  eval ("\$showrennen = \"".$tpl->get("formel_main_showrennen")."\";");
  eval ("\$akt_rennbit = \"".$tpl->get("formel_main_aktrennen")."\";");
 } else {
  eval ("\$akt_rennbit = \"".$tpl->get("formel_main_aktrennen_leer")."\";");  
 } 
 eval ("\$formelbit = \"".$tpl->get("formel_main")."\";");
} 

if($location == "rennen") {
 if(isset($_GET['rennid'])) $rennid = $_GET['rennid'];
 if($rennid) {
  $result = $db->query_first("SELECT * FROM bb".$n."_formel_rennen WHERE rennid = '".$rennid."'");
  $streckenid = $result['streckenid'];
  $r_name1 = $result['name'];
  $r_datum1 = date("d.m.Y", $result['datum']);
  $result2 = $db->query_first("SELECT * FROM bb".$n."_formel_strecken WHERE streckenid = '".$streckenid."'");
  $r_name = stripslashes($result2['name']);
  $r_land = stripslashes($result2['land']);
  $r_ort = stripslashes($result2['ort']);
  $r_laenge11 = intval($result2['laenge']);
  $r_runden = intval($result2['runden']);
  $r_laenge21 = $r_runden * $r_laenge11;
  $r_laenge12 = number_format(($r_laenge11/1000), 3, ',', '');
  $r_laenge22 = number_format(($r_laenge21/1000), 3, ',', '');
  $r_last_pole = stripslashes($result2['last_pole']);
  $r_last_sieger = stripslashes($result2['last_sieger']);
  $r_rekord = stripslashes($result2['rekord_strecke']);
  if($result2['image']) $r_image = makeimgtag(stripslashes($result2['image']), $r_name);
  else $r_image = makeimgtag("./images/formel1/strecken/nopic.jpg");
  if($result2['url']) $r_url = makehreftag(stripslashes($result2['url']), "&raquo; hier &laquo;", "_target");
  else $r_url = "";
  eval ("\$formelbit = \"".$tpl->get("formel_rennen_showbit")."\";");  
 } else  eval ("\$formelbit = \"".$tpl->get("formel_rennen_showbit_leer")."\";");  
 $result = $db->query("SELECT * FROM bb".$n."_formel_rennen ORDER BY datum"); 
 if($db->num_rows()) {
  while($row = $db->fetch_array($result)) {
   $r_name = stripslashes($row['name']);
   $r_datum = date("d.m.Y", $row['datum']);
   $rennid = $row['rennid'];
   if($row['checked']) $checked = "[*]"; else $checked = "";
   eval ("\$rennliste_bit .= \"".$tpl->get("formel_main_box_rennen_bit")."\";");  
  }
 } else eval ("\$rennliste_bit = \"".$tpl->get("formel_main_box_rennen_leer")."\";");  
 eval ("\$box = \"".$tpl->get("formel_main_box_rennen")."\";");  
}

if($location == "fahrer") {
 if(isset($_GET['fahrerid'])) $rennid = $_GET['fahrerid'];
 if($fahrerid) {  
  $result2 = $db->query_first("SELECT * FROM bb".$n."_formel_fahrer WHERE fahrerid = '".$fahrerid."'");
  $f_name = stripslashes($result2['name']);
  $f_vorname = stripslashes($result2['vorname']);
  $f_land = stripslashes($result2['land']);
  $f_team = stripslashes($result2['team']);  
  if($result2['image']) $f_image = makeimgtag(stripslashes($result2['image']), $f_name);
  else $f_image = makeimgtag("./images/formel1/fahrer/nopic.jpg");
  if($result2['url']) $f_url = makehreftag(stripslashes($result2['url']), "&raquo; hier &laquo;", "_target");
  else $f_url = "";
  eval ("\$formelbit = \"".$tpl->get("formel_fahrer_showbit")."\";");  
 } else  eval ("\$formelbit = \"".$tpl->get("formel_fahrer_showbit_leer")."\";");  
 $result = $db->query("SELECT * FROM bb".$n."_formel_fahrer ORDER BY name"); 
 if($db->num_rows()) {
  while($row = $db->fetch_array($result)) {
   $f_name = stripslashes($row['name']);
   $f_vorname = stripslashes($row['vorname']);
   $fahrerid = $row['fahrerid'];
   eval ("\$fahrerliste_bit .= \"".$tpl->get("formel_main_box_fahrer_bit")."\";");  
  }
 } else eval ("\$fahrerliste_bit = \"".$tpl->get("formel_main_box_fahrer_leer")."\";");  
 eval ("\$box = \"".$tpl->get("formel_main_box_fahrer")."\";");  
}

if($location == "tippen") {
 if(isset($_POST['action']) && $_POST['action'] == "abgeben") {
  $result = $db->query_first("SELECT * FROM bb".$n."_formel_config");
  $saison = $result['saison'];
  $boardid = $result['tipp_board'];  
  $posterid = $result['tipp_user'];  
  $time = time();
  $result = $db->query_first("SELECT * FROM bb".$n."_users WHERE userid = '".$posterid."'");
  $postername = $result['username'];
  $result = $db->query_first("SELECT * FROM bb".$n."_formel_rennen WHERE rennid = '".intval($_POST['rennid'])."'");
  $rennname = $result['name'];
  $renndatum = date("d.m.Y", $result['datum']);
  $threadid = $result['threadid'];
  $username = $wbbuserdata['username'];
  for($i=1; $i<=8; $i++) {
    eval("\$what = \"platz$i\";");
    $fahrerid = $_POST[$what];
    $result2 = $db->query_first("SELECT * FROM bb".$n."_formel_fahrer WHERE fahrerid = '".$fahrerid."'");
    $platz[$i] = stripslashes($result2['vorname'])." ".stripslashes($result2['name'])." (".stripslashes($result2['team']).")";
   }
  eval ("\$tippposting = \"".$tpl->get("formel_tippen_posting")."\";");
  eval ("\$tippposting_title = \"".$tpl->get("formel_tippen_posting_title")."\";");  
  $result=$db->query_first("SELECT * FROM bb".$n."_posts WHERE threadid='$threadid' ORDER BY postid DESC LIMIT 1");
  $parentpostid = $result['postid'];
  $db->unbuffered_query("UPDATE bb".$n."_threads SET lastposttime = '$time', lastposterid = '$posterid', lastposter = '".addslashes($postername)."', replycount = replycount+1, closed='1' WHERE threadid = '$threadid'",1);
  $db->query("INSERT INTO bb".$n."_posts (postid,parentpostid,threadid,userid,username,iconid,posttopic,posttime,message,allowsmilies,showsignature,ipaddress,visible) VALUES (NULL,'$parentpostid','$threadid','$posterid','".addslashes($postername)."','','".addslashes(htmlspecialchars($tippposting_title))."','$time','".addslashes($tippposting)."','1','','".$REMOTE_ADDR."','1')");
  $db->query("UPDATE bb".$n."_boards SET threadcount=threadcount+1, postcount=postcount+1, lastthreadid='$threadid', lastposttime='$time', lastposterid='$posterid', lastposter='".addslashes($postername)."' WHERE boardid IN ($boardid)");
  $datum = time();
  $db->query("INSERT INTO bb".$n."_formel_tipps (userid, rennid, datum, platz1, platz2, platz3, platz4, platz5, platz6, platz7, platz8) VALUES ('".$wbbuserdata['userid']."','".intval($_POST['rennid'])."','".$datum."','".intval($_POST['platz1'])."','".intval($_POST['platz2'])."','".intval($_POST['platz3'])."','".intval($_POST['platz4'])."','".intval($_POST['platz5'])."','".intval($_POST['platz6'])."','".intval($_POST['platz7'])."','".intval($_POST['platz8'])."')");
  $result = $db->query("SELECT * FROM bb".$n."_formel_highscore_saison WHERE userid = '".$wbbuserdata['userid']."'");
  $test = $db->num_rows();
  if(!$test) {
   $db->query("INSERT INTO bb".$n."_formel_highscore_saison (userid,punkte) VALUES ('".$wbbuserdata['userid']."','0')");
  }
  $result = $db->query("SELECT * FROM bb".$n."_formel_highscore WHERE userid = '".$wbbuserdata['userid']."' AND saison = '".$saison."'");
  $test2 = $db->num_rows();
  if(!$test2) {
   $db->query("INSERT INTO bb".$n."_formel_highscore (userid,punkte,saison) VALUES ('".$wbbuserdata['userid']."','0','".$saison."')");
  }  
 }
 $result = $db->query_first("SELECT * FROM bb".$n."_formel_config"); 
 $akt_rennen = $result['akt_rennen'];
 if($akt_rennen) {  
  $tipp_ende = date("d.m.Y - H:i", $result['akt_tippende']);
  $tipp_ende2 = $result['akt_tippende'];
  $boardid = $result['tipp_board'];
  $posterid = $result['tipp_user'];
  $result = $db->query_first("SELECT * FROM bb".$n."_formel_rennen WHERE rennid = '".$akt_rennen."'");
  $rennen_checked = $result['checked'];
  $threadid = $result['threadid'];
  $postid = $result['postid'];
  $name = stripslashes($result['name']);  
  $datum = date("d.m.Y", $result['datum']);  
  $result = $db->query_first("SELECT * FROM bb".$n."_formel_tipps WHERE rennid = '".$akt_rennen."' AND userid = '".$wbbuserdata['userid']."'");
  if($result['datum']) {
   $usertipp = "am ".date("d.m.Y", $result['datum'])." um ".date("H:i", $result['datum']);
   $userdatum = date("d.m.Y - H:i", $result['datum']);
   for($i=1; $i<=8; $i++) {
    eval("\$what = \"platz$i\";");
    $fahrerid = $result[$what];
    $result2 = $db->query_first("SELECT * FROM bb".$n."_formel_fahrer WHERE fahrerid = '".$fahrerid."'");
    $platz[$i] = stripslashes($result2['vorname'])." ".stripslashes($result2['name'])." (".stripslashes($result2['team']).")";
   }
   eval ("\$tippen = \"".$tpl->get("formel_tippen_usertipp_show")."\";");
  } else {
   $usertipp = "noch nicht";
   $fahrer_options = "";
   $result = $db->query("SELECT * FROM bb".$n."_formel_fahrer ORDER BY name");
   while($row = $db->fetch_array($result)) {
    $fahrer_options .= "<option value=\"".$row['fahrerid']."\">".stripslashes($row['name']).". ".stripslashes($row['vorname'])." (".stripslashes($row['team']).")</option>\n";
   }
   if(time() < $tipp_ende2) {  
    eval ("\$tippen = \"".$tpl->get("formel_tippen_usertipp_leer")."\";");   
   } else {
    eval ("\$tippen = \"".$tpl->get("formel_tippen_usertipp_pech")."\";");
   }     
  }  
  eval ("\$akt_rennbit = \"".$tpl->get("formel_main_aktrennen")."\";");    
  if($rennen_checked) eval ("\$tippen = \"".$tpl->get("formel_tippen_usertipp_ende")."\";");
 } else {
  eval ("\$akt_rennbit = \"".$tpl->get("formel_main_aktrennen_leer")."\";");  
 }
 eval ("\$formelbit = \"".$tpl->get("formel_tippen")."\";");
}  

if($location == "high") {
 $saison_high = "";
 $all_high = "";
 $result = $db->query("SELECT f.*, u.username FROM bb".$n."_formel_highscore_saison f LEFT JOIN bb".$n."_users u USING(userid) ORDER BY f.punkte DESC LIMIT 10");
 if($db->num_rows()) {
  $platz = 1;
  while($row = $db->fetch_array($result)) {
   $username = stripslashes($row['username']);
   $punkte = $row['punkte'];
   $userid = $row['userid'];
   eval ("\$saison_high .= \"".$tpl->get("formel_highscore_userbit")."\";");
   $platz++;
  }
 }
 $result = $db->query("SELECT f.*, u.username FROM bb".$n."_formel_highscore f LEFT JOIN bb".$n."_users u USING(userid) ORDER BY f.punkte DESC LIMIT 10");
 if($db->num_rows()) {
  $platz = 1;
  while($row = $db->fetch_array($result)) {
   $username = stripslashes($row['username']);
   $punkte = $row['punkte'];
   $userid = $row['userid'];
   eval ("\$all_high .= \"".$tpl->get("formel_highscore_userbit")."\";");
   $platz++;
  }
 }
 $result = $db->query_first("SELECT * FROM bb".$n."_formel_highscore_saison WHERE userid = '".$wbbuserdata['userid']."'"); 
 $user_punkte = $result['punkte']; 
 $result = $db->query_first("SELECT * FROM bb".$n."_formel_tipps WHERE userid = '".$wbbuserdata['userid']."' ORDER BY datum DESC LIMIT 1"); 
 $last_user = $result['punkte'];  
 $result = $db->query("SELECT * FROM bb".$n."_formel_highscore ORDER BY punkte DESC"); 
 $platz_array = array();
 while($row = $db->fetch_array($result)) {
  $platz_array[] = $row['userid'];
 }
 $user_platz = intval(array_search($wbbuserdata['userid'], $platz_array) + 1);
 $anzahl_user = count($platz_array);
 eval ("\$formelbit = \"".$tpl->get("formel_highscore")."\";");
}

eval("\$tpl->output(\"".$tpl->get("formel")."\");");
?>