set_filenames(array( "header" => 'card_duel_header.tpl') ); $template->set_filenames(array( "body" => 'card_duel_game_field_body.tpl') ); //check if in game if ( 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); ?>