rendered paste body<?php/*************************************************************************** * card_duel.php * ------------------- * begin : 7/26/2006 * copyright : (C) 2006 William Hughes aka Sim * email : william@po2mob.com * * * * ***************************************************************************//*************************************************************************** * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * ***************************************************************************//* game status 0 = game over game status 1 = accepted game status 2 = global challenge game status 3 = challenged */define('IN_PHPBB', true);$phpbb_root_path = './';include($phpbb_root_path . 'extension.inc');include($phpbb_root_path . 'common.'.$phpEx);include($phpbb_root_path . 'includes/card_duel_constants.'.$phpEx);include($phpbb_root_path . 'includes/card_duel_functions.'.$phpEx);include($phpbb_root_path . 'language/lang_english/lang_duel_cards.php');//// Start session management//$userdata = session_pagestart($user_ip, PAGE_INDEX);init_userprefs($userdata);//// End session management//include($phpbb_root_path . 'includes/page_header.'.$phpEx);$template->set_filenames(array( "header" => 'card_duel_header.tpl')); $template->set_filenames(array( "body" => 'card_duel_game_field_body.tpl') );//check if in gameif ( isset($HTTP_POST_VARS['game_id']) || isset($HTTP_GET_VARS['game_id'])) { //check if user belongs in this game //sql command $sql = "SELECT * FROM " . CARD_DUELS_GAMES_TABLE ." WHERE game_status = '1' AND oppoment_user_id='" . $userdata['user_id'] . "' OR challenger_user_id='" . $userdata['user_id'] . "' AND id='" . $HTTP_GET_VARS['game_id'] . "'"; //if didn't succeed if ( ! ( $result = $db->sql_query($sql) ) ) { message_die(GENERAL_ERROR, 'Error retreiving game challenges data ', '', __LINE__, __FILE__, $sql); } $row = $db->sql_fetchrow($result); //if user belogns in game if ($row['id'] <> "") { play1_magic = array(); play2_magic = array(); play1_potion = array(); play2_potion = array(); play1_weapon = array(); play2_weapon = array(); play1_armor = array(); play2_armor = array(); play1_summon = array(); play2_summon = array(); play1_acc = array(); play2_acc = array(); //playing card. //else //if players turn is yours if ($row['user_turn_id'] == $userdata['user_id']) { //sql command $sql = "SELECT * FROM " . CARD_DUELS_GAME_DECKS_TABLE . " WHERE user_id='" . $userdata['user_id'] . "' AND game_id='" . $HTTP_GET_VARS['game_id'] . "' AND in_play='2'"; //if didn't succeed if ( ! ( $result = $db->sql_query($sql) ) ) { message_die(GENERAL_ERROR, 'Error retrieving decks data ', '', __LINE__, __FILE__, $sql); } //get all records while ( $row = $db->sql_fetchrow($result) ) { //sql command $sql2 = "SELECT * FROM " . CARD_DUELS_USER_CARDS_TABLE . " WHERE id='" . $row['user_card_id'] . "'"; //if didn't succeed if ( ! ( $result2 = $db->sql_query($sql2) ) ) { message_die(GENERAL_ERROR, 'Error retrieving card data ', '', __LINE__, __FILE__, $sql2); } //get record $row2 = $db->sql_fetchrow($result2); //sql command $sql2 = "SELECT * FROM " . CARD_DUELS_CARDS_TABLE . " WHERE id='" . $row2['card_id'] . "'"; //if didn't succeed if ( ! ( $result2 = $db->sql_query($sql2) ) ) { message_die(GENERAL_ERROR, 'Error retrieving card data ', '', __LINE__, __FILE__, $sql2); } //get record $row2 = $db->sql_fetchrow($result2); switch ($row2['card_type']) { case "Character"; $template->assign_vars(array("CHARACTER_2" => $row2['card_image'] )); break; case "Card Backs"; $card_back = $row2['card_image']; break; case "Armor"; $play1_armor[] = $row2['card_image']; break; case "Accessory"; $play1_acc[] = $row2['card_image']; break; case "Magic"; $play1_magic[] = $row2['card_image']; break; case "Weapon"; $play1_magic[] = $row2['card_image']; break; case "Potion"; $play1_potion[] = $row2['card_image']; break; case "Weapon"; $play1_summon[] = $row2['card_image']; break; } } } else { //sql command $sql = "SELECT * FROM " . CARD_DUELS_GAME_DECKS_TABLE . " WHERE user_id='" . $userdata['user_id'] . "' AND game_id='" . $HTTP_GET_VARS['game_id'] . "' AND in_play='2'"; //if didn't succeed if ( ! ( $result = $db->sql_query($sql) ) ) { message_die(GENERAL_ERROR, 'Error retrieving decks data ', '', __LINE__, __FILE__, $sql); } //get all records while ( $row = $db->sql_fetchrow($result) ) { //sql command $sql2 = "SELECT * FROM " . CARD_DUELS_USER_CARDS_TABLE . " WHERE id='" . $row['user_card_id'] . "'"; //if didn't succeed if ( ! ( $result2 = $db->sql_query($sql2) ) ) { message_die(GENERAL_ERROR, 'Error retrieving card data ', '', __LINE__, __FILE__, $sql2); } //get record $row2 = $db->sql_fetchrow($result2); //sql command $sql2 = "SELECT * FROM " . CARD_DUELS_CARDS_TABLE . " WHERE id='" . $row2['card_id'] . "'"; //if didn't succeed if ( ! ( $result2 = $db->sql_query($sql2) ) ) { message_die(GENERAL_ERROR, 'Error retrieving card data ', '', __LINE__, __FILE__, $sql2); } //get record $row2 = $db->sql_fetchrow($result2); switch ($row2['card_type']) { case "Character"; $template->assign_vars(array("CHARACTER_1" => $row2['card_image'] )); break; case "Card Backs"; $card_back = $row2['card_image']; break; } } } }} $template->pparse("body");$template->set_filenames(array( "footer" => 'card_duel_footer.tpl'));$template->pparse("footer");include($phpbb_root_path . 'includes/page_tail.'.$phpEx);?>