<?php

/***************************************************************************
*                                proarcade.php
*                            -------------------
*   fait le                : Mercredi,19 Mai, 2003
*   Par : giefca - http://www.gf-phpbb.com
*
***************************************************************************/
/*
if (!eregi("modules.php", $_SERVER['PHP_SELF'])) {
    die ("You can't access this file directly...");
}*/

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
//include($phpbb_root_path . 'common.'.php);

include('../../config.php');
include('db/db.php');
include('includes/functions.php');
include('includes/constants.php');
include('includes/sessions.php');
include('common_arcade.php');

while( list($var, $param) = @each($HTTP_POST_VARS) )
{
   $$var = $param ;
}

while( list($var, $param) = @each($HTTP_GET_VARS) )
{
   $$var = $param ;
}


//$header_location = ( @preg_match("/Microsoft|WebSTAR|Xitami/", getenv("SERVER_SOFTWARE")) ) ? "Refresh: 0; URL=" : "Location: ";

//
// Start session management
//

$userdata = session_pagestart($user_ip, PAGE_GAME, $nukeuser);
init_userprefs($userdata);

//
// End session management
//
// Start auth check
//

$header_location = ( @preg_match("/Microsoft|WebSTAR|Xitami/", getenv("SERVER_SOFTWARE")) ) ? "Refresh: 0; URL=" : "Location: ";

$sql = "SELECT * FROM " . GAMES_TABLE . " WHERE game_id = '$gid'";
if( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, "Impossible d'acceder à la table des jeux", '', __LINE__, __FILE__, $sql);
}
if ( !( $row = $db->sql_fetchrow($result) ) )
{// Si l'utilisateur n'a encore aucun score pour ce jeu'
   message_die(GENERAL_ERROR, "Aucun jeu ne correspond.") ;
}

if ( $row['game_type'] == 0 )
{
   $deb = 32 - $hashoffset ;
   $gamehash_id = substr( $newhash , $deb , $hashoffset ) . substr( $newhash , 0 , $deb ) ;
}

if ( $row['game_type'] == 1 )
{
$gamehash_id = $gamehash ;
}

if ( $row['game_type'] == 2 )
{
if ( $vpaver == "100B" )
{
$gamehash_id = $gamehash ;
$vpaver = "100B2" ;
}
}
$vscore = $row['game_scorevar'] ;
$score = $$vscore ;

if (  !$userdata['session_logged_in']  && !isset($valid) )
{
   header("Location: http://" . $board_config['server_name']."/modules/Forums/proarcade.php?$vscore=$score&gid=$gid&valid=X&newhash=$newhash&gamehash_id=$gamehash_id&gamehash=$gamehash&hashoffset=$hashoffset&settime=$settime&sid=$sid&vpaver=$vpaver&sid=$sid");
      exit;
}

if ( !$userdata['session_logged_in'] )
{
   header("Refresh: 0; url= http://" . $board_config['server_name']."/modules.php?name=Your_Account");
   exit;
}

$sql = "SELECT * FROM " . GAMEHASH_TABLE . " WHERE gamehash_id = '$gamehash_id' and game_id = '$gid' and user_id = '" . $userdata['user_id'] . "'";

if( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, "Impossible d'acceder à la tables des hash game", '', __LINE__, __FILE__, $sql);
}

// Tentative de hack ?
if ( !( $row = $db->sql_fetchrow($result) ) or ($vpaver != "100B2") or (!isset($$vscore)) )
{
   $sql = "INSERT INTO " . HACKGAME_TABLE . " ( user_id , game_id , date_hack ) VALUES ( '" . $userdata['user_id'] . "' , '$gid' , '" . time() . "')" ;
   $db->sql_query($sql) ;

   header("Location: http://" . $board_config['server_name']."/modules.php?name=Forums&file=arcade&sid=$sid");
   exit;
}

$sql = "DELETE FROM " . GAMEHASH_TABLE . " WHERE gamehash_id = '$gamehash_id' and game_id = $gid and user_id = " . $userdata['user_id'] ;

$db->sql_query($sql) ;



//
// End of auth check
//
      //Arcade Points Addon Telli
   $aconf = array();
   $sql = "SELECT * FROM ".$prefix."_arcade_config";
   $result = $db->sql_query($sql);
   while(list($config_name, $config_value) = $db->sql_fetchrow($result)){
      $aconf[$config_name] = $config_value;
   }
      $highscore = $aconf['highscore'];
      $topscore = $aconf['topscore'];
      $pergame = $aconf['pergame'];
      $pname = $aconf['pname'];
      if ($pergame > 0) {
   $db->sql_query("UPDATE ".$prefix."_users SET $pname=$pname - $pergame WHERE username='$userdata[username]'");
      //End Arcade Points Addon
}


$sql = "SELECT * FROM " . SCORES_TABLE . " WHERE game_id = $gid and user_id = " . $userdata['user_id'] ;

if( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, "Impossible d'acceder à la tables des scores", '', __LINE__, __FILE__, $sql);
}

$datenow = time();
$ecart = $datenow - $settime ;

if ( !( $row = $db->sql_fetchrow($result) ) )
{// Si l'utilisateur n'a encore aucun score pour ce jeu'
   $sql = "INSERT INTO " . SCORES_TABLE . " (game_id , user_id , score_game , score_date , score_time , score_set )
   VALUES ( $gid , " . $userdata['user_id'] . " , $score , $datenow , $ecart , 1 ) ";
   $result = $db->sql_query($sql) ;
}
else
{
  if ( $row['score_game'] < $score )
  {
  $sql = "UPDATE " . SCORES_TABLE . " set score_game = $score , score_set = score_set + 1 , score_date = $datenow , score_time = score_time + $ecart 
   WHERE game_id = $gid and user_id = " . $userdata['user_id'] ;
  $result = $db->sql_query($sql) ;
                //Arcade Points Addon Telli
   $db->sql_query("UPDATE ".$prefix."_users SET $pname=$pname + $topscore WHERE username='$userdata[username]'");
                //End Arcade Points Addon
  }   
  else
  {
    $sql = "UPDATE " . SCORES_TABLE . " set score_set = score_set + 1  , score_time = score_time + $ecart
   WHERE game_id = $gid and user_id = " . $userdata['user_id'] ;
    $result = $db->sql_query($sql) ;
  }
}


$sql = "SELECT * FROM " . GAMES_TABLE . " WHERE game_id = " . $gid ;
if( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, "Impossible d'acceder à la tables des jeux", '', __LINE__, __FILE__, $sql);
}

if ( ( $row = $db->sql_fetchrow($result) ) && ( $row['game_highscore']< $score) )
{
   $sql = "UPDATE " . GAMES_TABLE . " set game_highscore = $score , game_highuser = "
   . $userdata['user_id'] . " , game_highdate = " . time() . " WHERE game_id = $gid" ;
   $result = $db->sql_query($sql);
                //Arcade Points Addon Telli
   $db->sql_query("UPDATE ".$prefix."_users SET $pname=$pname + $highscore WHERE username='$userdata[username]'");
                //End Arcade Points Addon
}

   header("Location: http://" . $board_config['server_name']."/modules.php?name=Forums&file=games&gid=$gid&sid=$sid");
   exit;

?>>