|
From: Jon O. <jon...@us...> - 2005-04-12 19:48:32
|
Update of /cvsroot/mxbb/mx_act/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14412/modules/mx_act/admin Modified Files: admin_activity.php admin_ina_category.php admin_ina_disable.php admin_ina_scores_edit.php Log Message: Index: admin_ina_disable.php =================================================================== RCS file: /cvsroot/mxbb/mx_act/admin/admin_ina_disable.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** admin_ina_disable.php 9 Jan 2005 21:30:34 -0000 1.2 --- admin_ina_disable.php 12 Apr 2005 19:48:19 -0000 1.3 *************** *** 1,168 **** ! <?php ! ! /** ! * admin_ina_disable.php ! * ---------------------- ! * Version : 1.0.3 ! * Email : aus...@ho... ! * Site : austin-inc.com/Blend/ ! * Copyright : © aUsTiN-Inc 2003/4 (Blend Portal System) ! */ ! define( 'IN_PORTAL', 1 ); ! ! if ( !empty( $setmodules ) ) ! { ! $file = basename( __FILE__ ); ! $module['Activities']['Hide/Show Games'] = 'modules/mx_act/admin/' . "$file"; ! return; ! } ! ! $mx_root_path = '../../../'; ! $module_root_path = "../"; ! require( $mx_root_path . 'extension.inc' ); ! require( $mx_root_path . '/admin/pagestart.' . $phpEx ); ! require( $module_root_path . 'includes/act_constants.' . $phpEx ); ! ! include( $module_root_path . 'includes/act_functions.' . $phpEx ); ! ! /* ! define('IN_PHPBB', 1); ! if( !empty($setmodules) ) ! { ! $file = basename(__FILE__); ! $module['Activities']['Hide/Show Games'] = "$file"; ! return; ! } ! ! $phpbb_root_path = "./../"; ! require($phpbb_root_path . 'extension.inc'); ! ! require('./pagestart.' . $phpEx); ! include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_activity.' . $phpEx); ! ! */ ! ! if ( isset( $HTTP_POST_VARS['mode'] ) || isset( $HTTP_GET_VARS['mode'] ) ) ! { ! $mode = ( isset( $HTTP_POST_VARS['mode'] ) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode']; ! } ! else ! { ! $mode = ''; ! } ! ! $link = append_sid( "admin_ina_disable." . $phpEx ); ! ! if ( $mode == "main" || !$mode ) ! { ! echo "<table width='100%' border='0' class='forumline' cellspacing='2' align='center' valign='middle'>"; ! echo " <tr>"; ! echo " <th class='thHead' colspan='2'>"; ! echo " " . $lang['a_disable_1']; ! echo " </th>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br><br>"; ! ! echo "<table border='0' align='center' valign='top' class='forumline' width='100%'>"; ! echo " <tr>"; ! echo " <td align='center' valign='top' width='100%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " " . $lang['a_disable_2']; ! echo " </span>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<form name='do_it' action='$link' method='post'>"; ! echo "<table border='0' align='center' valign='middle' class='forumline' width='100%'>"; ! echo " <tr>"; ! echo " <td align='left' valign='middle' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " " . $lang['a_disable_3']; ! echo " </span>"; ! echo " </td>"; ! echo " <td align='center' valign='middle' width='50%' class='row2'>"; ! echo " <select name='game_choice'>"; ! echo " <option selected value=''>" . $lang['a_disable_4'] . "</option>"; ! ! $q = "SELECT * ! FROM " . iNA_GAMES . " ! ORDER BY game_id ASC"; ! $r = $db->sql_query( $q ); ! while ( $row = $db->sql_fetchrow( $r ) ) ! { ! $g_name = $row['game_name']; ! $g_id = $row['game_id']; ! $g_dis = $row['disabled']; ! ! if ( $g_dis == "2" ) ! { ! $new_name = "($g_id) $g_name*"; ! } ! else ! { ! $new_name = "($g_id) $g_name"; ! } ! ! echo " <option value='$g_id'>$new_name</option>"; ! } ! ! echo " </select>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br>"; ! echo "<table border='0' align='center' valign='top'>"; ! echo " <tr>"; ! echo " <td align='center' valign='middle' width='100%' class='row2'>"; ! echo " <input type='hidden' name='mode' value='hide_show'>"; ! echo " <input type='submit' class='mainoption' value='" . $lang['a_disable_5'] . "' onchange='document.do_it.submit()'>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "</form>"; ! echo "<br><br>"; ! } ! ! if ( $mode == "hide_show" ) ! { ! $id = $_POST['game_choice']; ! ! if ( !$id ) ! { ! mx_message_die( GENERAL_ERROR, $lang['a_disable_6'] . "<a href='" . $link . "'>" . $lang['a_disable_7'], $lang['ban_error'] ); ! } ! ! $q = "SELECT disabled ! FROM " . iNA_GAMES . " ! WHERE game_id = '$id'"; ! $r = $db->sql_query( $q ); ! $row = $db->sql_fetchrow( $r ); ! $disabled = $row['disabled']; ! ! if ( $disabled == "2" ) ! { ! $q = "UPDATE " . iNA_GAMES . " ! SET disabled = '1' ! WHERE game_id = '$id'"; ! $r = $db->sql_query( $q ); ! ! mx_message_die( GENERAL_MESSAGE, $lang['a_disable_8'] . "<a href='" . $link . "'>" . $lang['a_disable_9'] , $lang['a_ban_22'] ); ! }elseif ( $disabled == "1" ) ! { ! $q = "UPDATE " . iNA_GAMES . " ! SET disabled = '2' ! WHERE game_id = '$id'"; ! $r = $db->sql_query( $q ); ! ! mx_message_die( GENERAL_MESSAGE, $lang['a_disable_10'] . "<a href='" . $link . "'>" . $lang['a_disable_11'], $lang['a_ban_22'] ); ! } ! else ! { ! mx_message_die( GENERAL_ERROR, $lang['a_disable_13'] . "<a href='" . $link . "'>" . $lang['a_disable_12'], $lang['ban_error'] ); ! } ! } ! ! include( $mx_root_path . 'admin/page_footer_admin.' . $phpEx ); ! ?> \ No newline at end of file --- 1,168 ---- ! <?php ! ! /** ! * admin_ina_disable.php ! * ---------------------- ! * Version : 1.0.3 ! * Email : aus...@ho... ! * Site : austin-inc.com/Blend/ ! * Copyright : © aUsTiN-Inc 2003/4 (Blend Portal System) ! */ ! define( 'IN_PORTAL', 1 ); ! ! if ( !empty( $setmodules ) ) ! { ! $file = basename( __FILE__ ); ! $module['Activities']['Hide/Show Games'] = 'modules/mx_act/admin/' . "$file"; ! return; ! } ! ! $mx_root_path = '../../../'; ! $module_root_path = "../"; ! require( $mx_root_path . 'extension.inc' ); ! require( $mx_root_path . '/admin/pagestart.' . $phpEx ); ! require( $module_root_path . 'includes/act_constants.' . $phpEx ); ! ! include( $module_root_path . 'includes/act_functions.' . $phpEx ); ! ! /* ! define('IN_PHPBB', 1); ! if( !empty($setmodules) ) ! { ! $file = basename(__FILE__); ! $module['Activities']['Hide/Show Games'] = "$file"; ! return; ! } ! ! $phpbb_root_path = "./../"; ! require($phpbb_root_path . 'extension.inc'); ! ! require('./pagestart.' . $phpEx); ! include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main.' . $phpEx); ! ! */ ! ! if ( isset( $HTTP_POST_VARS['mode'] ) || isset( $HTTP_GET_VARS['mode'] ) ) ! { ! $mode = ( isset( $HTTP_POST_VARS['mode'] ) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode']; ! } ! else ! { ! $mode = ''; ! } ! ! $link = append_sid( "admin_ina_disable." . $phpEx ); ! ! if ( $mode == "main" || !$mode ) ! { ! echo "<table width='100%' border='0' class='forumline' cellspacing='2' align='center' valign='middle'>"; ! echo " <tr>"; ! echo " <th class='thHead' colspan='2'>"; ! echo " " . $lang['a_disable_1']; ! echo " </th>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br><br>"; ! ! echo "<table border='0' align='center' valign='top' class='forumline' width='100%'>"; ! echo " <tr>"; ! echo " <td align='center' valign='top' width='100%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " " . $lang['a_disable_2']; ! echo " </span>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<form name='do_it' action='$link' method='post'>"; ! echo "<table border='0' align='center' valign='middle' class='forumline' width='100%'>"; ! echo " <tr>"; ! echo " <td align='left' valign='middle' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " " . $lang['a_disable_3']; ! echo " </span>"; ! echo " </td>"; ! echo " <td align='center' valign='middle' width='50%' class='row2'>"; ! echo " <select name='game_choice'>"; ! echo " <option selected value=''>" . $lang['a_disable_4'] . "</option>"; ! ! $q = "SELECT * ! FROM " . iNA_GAMES . " ! ORDER BY game_id ASC"; ! $r = $db->sql_query( $q ); ! while ( $row = $db->sql_fetchrow( $r ) ) ! { ! $g_name = $row['game_name']; ! $g_id = $row['game_id']; ! $g_dis = $row['disabled']; ! ! if ( $g_dis == "2" ) ! { ! $new_name = "($g_id) $g_name*"; ! } ! else ! { ! $new_name = "($g_id) $g_name"; ! } ! ! echo " <option value='$g_id'>$new_name</option>"; ! } ! ! echo " </select>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br>"; ! echo "<table border='0' align='center' valign='top'>"; ! echo " <tr>"; ! echo " <td align='center' valign='middle' width='100%' class='row2'>"; ! echo " <input type='hidden' name='mode' value='hide_show'>"; ! echo " <input type='submit' class='mainoption' value='" . $lang['a_disable_5'] . "' onchange='document.do_it.submit()'>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "</form>"; ! echo "<br><br>"; ! } ! ! if ( $mode == "hide_show" ) ! { ! $id = $_POST['game_choice']; ! ! if ( !$id ) ! { ! mx_message_die( GENERAL_ERROR, $lang['a_disable_6'] . "<a href='" . $link . "'>" . $lang['a_disable_7'], $lang['ban_error'] ); ! } ! ! $q = "SELECT disabled ! FROM " . iNA_GAMES . " ! WHERE game_id = '$id'"; ! $r = $db->sql_query( $q ); ! $row = $db->sql_fetchrow( $r ); ! $disabled = $row['disabled']; ! ! if ( $disabled == "2" ) ! { ! $q = "UPDATE " . iNA_GAMES . " ! SET disabled = '1' ! WHERE game_id = '$id'"; ! $r = $db->sql_query( $q ); ! ! mx_message_die( GENERAL_MESSAGE, $lang['a_disable_8'] . "<a href='" . $link . "'>" . $lang['a_disable_9'] , $lang['a_ban_22'] ); ! }elseif ( $disabled == "1" ) ! { ! $q = "UPDATE " . iNA_GAMES . " ! SET disabled = '2' ! WHERE game_id = '$id'"; ! $r = $db->sql_query( $q ); ! ! mx_message_die( GENERAL_MESSAGE, $lang['a_disable_10'] . "<a href='" . $link . "'>" . $lang['a_disable_11'], $lang['a_ban_22'] ); ! } ! else ! { ! mx_message_die( GENERAL_ERROR, $lang['a_disable_13'] . "<a href='" . $link . "'>" . $lang['a_disable_12'], $lang['ban_error'] ); ! } ! } ! ! include( $mx_root_path . 'admin/page_footer_admin.' . $phpEx ); ! ?> \ No newline at end of file Index: admin_ina_category.php =================================================================== RCS file: /cvsroot/mxbb/mx_act/admin/admin_ina_category.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** admin_ina_category.php 9 Jan 2005 21:30:34 -0000 1.2 --- admin_ina_category.php 12 Apr 2005 19:48:19 -0000 1.3 *************** *** 1,666 **** ! <?php ! ! /** ! * admin_ina_category.php ! * ------------------------ ! * Version : 1.0.3 ! * Email : aus...@ho... ! * Site : austin-inc.com/Blend/ ! * Copyright : © aUsTiN-Inc 2003/4 (Blend Portal System) ! */ [...1305 lines suppressed...] ! WHERE cat_id = '$cat'"; ! $r = $db->sql_query( $q ); ! $row = $db->sql_fetchrow( $r ); ! $check = $row['cat_name']; ! ! $q = "DELETE FROM " . INA_CATEGORY . " ! WHERE cat_id = '$cat'"; ! $r = $db->sql_query( $q ); ! ! $q = "DELETE FROM " . INA_CATEGORY_DATA . " ! WHERE cat_id = '$cat'"; ! $r = $db->sql_query( $q ); ! ! mx_message_die( GENERAL_MESSAGE, "All Data For The Category [<b> " . $check . " </b>] Has Been Deleted.<br>Click <a href='" . $link . "'>Here</a> To Return To The Categories Page.", "Success" ); ! } ! ! include( $mx_root_path . 'admin/page_footer_admin.' . $phpEx ); ! ?> \ No newline at end of file Index: admin_activity.php =================================================================== RCS file: /cvsroot/mxbb/mx_act/admin/admin_activity.php,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** admin_activity.php 9 Jan 2005 21:30:34 -0000 1.3 --- admin_activity.php 12 Apr 2005 19:48:19 -0000 1.4 *************** *** 1,814 **** ! <?php ! /** ! * admin_activity.php ! * -------------------- ! * begin : Tuesday, October 15, 2002 ! * copyright : (c)2002 www.iNetAngel.com ! * email : su...@iN... ! * ! * $Id : admin_activity.php, v2.0.0 2003/12/18 59:59:59 Napoleon Exp $ ! * [...1599 lines suppressed...] ! "S_USE_PSM_YES" => $use_point_system_yes, ! "S_USE_PSM_NO" => $use_point_system_no, ! "S_USE_CASH_YES" => $use_cash_system_yes, ! "S_USE_CASH_NO" => $use_cash_system_no, ! "S_USE_ASM_YES" => $use_allowance_system_yes, ! "S_USE_ASM_NO" => $use_allowance_system_no, ! "S_USE_REWARDS_YES" => $use_rewards_yes, ! "S_USE_REWARDS_NO" => $use_rewards_no, ! ! "S_GAMES_PATH" => $games_path, ! "S_GAMELIB_PATH" => $gamelib_path, ! "S_GAMES_PER_PAGE" => $games_per_page, ! "S_HIDDEN_FIELDS" => '' ) ! ); ! } ! // Generate the page ! $template->pparse( 'body' ); ! include( $mx_root_path . 'admin/page_footer_admin.' . $phpEx ); ! ! ?> Index: admin_ina_scores_edit.php =================================================================== RCS file: /cvsroot/mxbb/mx_act/admin/admin_ina_scores_edit.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** admin_ina_scores_edit.php 9 Jan 2005 21:30:34 -0000 1.2 --- admin_ina_scores_edit.php 12 Apr 2005 19:48:19 -0000 1.3 *************** *** 1,428 **** ! <?php ! ! /** ! * admin_ina_scores_edit.php ! * --------------------------- ! * Version : 1.0.3 ! * Email : aus...@ho... ! * Site : austin-inc.com/Blend/ ! * Copyright : © aUsTiN-Inc 2003/4 (Blend Portal System) ! */ ! define( 'IN_PORTAL', 1 ); ! ! if ( !empty( $setmodules ) ) ! { ! $file = basename( __FILE__ ); ! $module['Activities']['Scores Editor'] = 'modules/mx_act/admin/' . "$file"; ! return; ! } ! ! $mx_root_path = '../../../'; ! $module_root_path = "../"; ! require( $mx_root_path . 'extension.inc' ); ! require( $mx_root_path . '/admin/pagestart.' . $phpEx ); ! require( $module_root_path . 'includes/act_constants.' . $phpEx ); ! ! include( $module_root_path . 'includes/act_functions.' . $phpEx ); ! ! /* ! define('IN_PHPBB', 1); ! if( !empty($setmodules) ) ! { ! $file = basename(__FILE__); ! $module['Activities']['Scores Editor'] = "$file"; ! return; ! } ! ! $phpbb_root_path = "./../"; ! require($phpbb_root_path . 'extension.inc'); ! ! require('./pagestart.' . $phpEx); ! include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_activity.' . $phpEx); ! ! */ ! if ( isset( $HTTP_POST_VARS['mode'] ) || isset( $HTTP_GET_VARS['mode'] ) ) ! { ! $mode = ( isset( $HTTP_POST_VARS['mode'] ) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode']; ! } ! else ! { ! $mode = ''; ! } ! ! $link = append_sid( "admin_ina_scores_edit." . $phpEx ); ! ! echo "<table width='100%' border='0' class='forumline' cellspacing='2' align='center' valign='middle'>"; ! echo " <tr>"; ! echo " <th class='thHead' colspan='2'>"; ! echo " Activity Scores Edit Admin"; ! echo " </th>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br><br>"; ! ! if ( $mode == "main" || !$mode ) ! { ! echo "<table width='100%' border='0' class='forumline' cellspacing='2' align='center' valign='middle'>"; ! echo " <tr>"; ! echo " <td align='left' valign='top' width='100%' class='row2'>"; ! echo " <span class='gensmall'>"; ! echo " This feature is provided for changing players scores a little up or down etc. This ! feature <b>is NOT</b> for moving trophy holders around, that will cause issues ! among the tables. If you want to move trophy holders around, please do that via ! the top of your activity_top_scores.php page & not here."; ! echo " </span>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br><br>"; ! echo "<table border='0' align='center' valign='top' class='forumline' width='100%'>"; ! echo " <tr>"; ! echo " <td align='center' valign='top' width='100%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " Edit A Normal Score"; ! echo " </span>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<table border='0' align='center' valign='top' class='forumline' width='100%'>"; ! echo "<form name='edit_score' action='$link' method='post'>"; ! echo " <tr>"; ! echo " <td align='left' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " Select Game"; ! echo " </span>"; ! echo " </td>"; ! echo " <td align='center' valign='top' width='50%' class='row2'>"; ! echo " <select name='game_selected'>"; ! echo " <option selected value=''>Choose A Game</option>"; ! ! $q = "SELECT game_name ! FROM " . iNA_GAMES . " ! WHERE game_id > '0'"; ! $r = $db->sql_query( $q ); ! while ( $row = $db->sql_fetchrow( $r ) ) ! { ! $game_name = $row['game_name']; ! echo " <option value='" . $game_name . "'>" . $game_name . "</option>"; ! } ! echo " </select>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br>"; ! echo "<table border='0' align='center' valign='top'>"; ! echo " <tr>"; ! echo " <td align='center' valign='middle' width='100%' class='row2'>"; ! echo " <input type='hidden' name='mode' value='edit_game_score'>"; ! echo " <input type='submit' class='mainoption' value=' Find Scores ' onchange='document.edit_score.submit()'>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "</form>"; ! echo "<br><br>"; ! ! echo "<table border='0' align='center' valign='top' class='forumline' width='100%'>"; ! echo " <tr>"; ! echo " <td align='center' valign='top' width='100%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " Edit A Trophy Score"; ! echo " </span>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<table border='0' align='center' valign='top' class='forumline' width='100%'>"; ! echo "<form name='edit_trophy' action='$link' method='post'>"; ! echo " <tr>"; ! echo " <td align='left' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " Select Game"; ! echo " </span>"; ! echo " </td>"; ! echo " <td align='center' valign='top' width='50%' class='row2'>"; ! echo " <select name='trophy_game_selected'>"; ! echo " <option selected value=''>Choose A Game</option>"; ! ! $q = "SELECT game_name ! FROM " . iNA_GAMES . " ! WHERE game_id > '0'"; ! $r = $db->sql_query( $q ); ! while ( $row = $db->sql_fetchrow( $r ) ) ! { ! $game_name = $row['game_name']; ! echo " <option value='" . $game_name . "'>" . $game_name . "</option>"; ! } ! echo " </select>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br>"; ! echo "<table border='0' align='center' valign='top'>"; ! echo " <tr>"; ! echo " <td align='center' valign='middle' width='100%' class='row2'>"; ! echo " <input type='hidden' name='mode' value='edit_trophy_game_score'>"; ! echo " <input type='submit' class='mainoption' value=' Edit Trophy Score ' onchange='document.edit_trophy.submit()'>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "</form>"; ! echo "<br><br>"; ! } ! ! if ( $mode == "edit_game_score" ) ! { ! $game = $_POST['game_selected']; ! ! if ( !$game ) ! { ! mx_message_die( GENERAL_ERROR, "Please Specify A Game.", "Error" ); ! } ! ! echo "<table border='0' align='center' valign='top' class='forumline' width='100%'>"; ! echo "<form name='edit_trophy_player' action='$link' method='post'>"; ! echo " <tr>"; ! echo " <td align='left' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " Select A Player"; ! echo " </span>"; ! echo " </td>"; ! echo " <td align='center' valign='top' width='50%' class='row2'>"; ! echo " <select name='player_selected'>"; ! echo " <option selected value=''>Choose A Player</option>"; ! ! $q = "SELECT player ! FROM " . iNA_SCORES . " ! WHERE game_name = '$game' ! GROUP BY player"; ! $r = $db->sql_query( $q ); ! while ( $row = $db->sql_fetchrow( $r ) ) ! { ! $player_name = $row['player']; ! echo " <option value='" . $player_name . "'>" . $player_name . "</option>"; ! } ! echo " </select>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br>"; ! echo "<table border='0' align='center' valign='top'>"; ! echo " <tr>"; ! echo " <td align='center' valign='middle' width='100%' class='row2'>"; ! echo " <input type='hidden' name='mode' value='edit_player'>"; ! echo " <input type='hidden' name='game_selected' value='$game'>"; ! echo " <input type='submit' class='mainoption' value=' Edit Player ' onchange='document.edit_trophy_player.submit()'>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "</form>"; ! } ! ! if ( $mode == "edit_player" ) ! { ! $player = $_POST['player_selected']; ! $game = $_POST['game_selected']; ! ! $q = "SELECT * ! FROM " . iNA_SCORES . " ! WHERE game_name = '$game' ! AND player = '$player' ! GROUP BY player ! ORDER BY score ASC ! LIMIT 0, 1"; ! $r = $db->sql_query( $q ); ! $row = $db->sql_fetchrow( $r ); ! $player_name = $row['player']; ! $player_score = $row['score']; ! ! echo "<table border='0' align='center' valign='top' class='forumline' width='100%'>"; ! echo "<form name='save_score' action='$link' method='post'>"; ! echo " <tr>"; ! echo " <td align='left' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " Current Score For $player_name On $game"; ! echo " </span>"; ! echo " </td>"; ! echo " <td align='center' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " $player_score"; ! echo " </span>"; ! echo " </td>"; ! echo " </tr>"; ! echo " <tr>"; ! echo " <td align='left' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " New Score For $player_name"; ! echo " </span>"; ! echo " </td>"; ! echo " <td align='center' valign='top' width='50%' class='row2'>"; ! echo " <input type='text' name='new_score' value='$player_score' class='post'>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br>"; ! echo "<table border='0' align='center' valign='top'>"; ! echo " <tr>"; ! echo " <td align='center' valign='middle' width='100%' class='row2'>"; ! echo " <input type='hidden' name='mode' value='save_new_score'>"; ! echo " <input type='hidden' name='game_selected' value='$game'>"; ! echo " <input type='hidden' name='player_selected' value='$player_name'>"; ! echo " <input type='submit' class='mainoption' value=' Save Score ' onchange='document.save_score.submit()'>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "</form>"; ! } ! ! if ( $mode == "save_new_score" ) ! { ! $game = $_POST['game_selected']; ! $player = $_POST['player_selected']; ! $score = $_POST['new_score']; ! ! $q = "SELECT * ! FROM " . INA_TROPHY . " ! WHERE game_name = '" . $game . "'"; ! $r = $db->sql_query( $q ); ! $row = $db->sql_fetchrow( $r ); ! $trophy_id = $row['player']; ! $trophy_sc = $row['score']; ! ! $q = "SELECT user_id ! FROM " . USERS_TABLE . " ! WHERE username = '" . $player . "'"; ! $r = $db->sql_query( $q ); ! $row = $db->sql_fetchrow( $r ); ! $player_id = $row['user_id']; ! ! if ( $trophy_id == $player_id ) ! { ! $q = "UPDATE " . iNA_SCORES . " ! SET score = '" . $score . "' ! WHERE player = '" . $player . "' ! AND game_name = '" . $game . "'"; ! $r = $db->sql_query( $q ); ! ! $q = "UPDATE " . INA_TROPHY . " ! SET score = '" . $score . "' ! WHERE player = '" . $player_id . "' ! AND game_name = '" . $game . "'"; ! $r = $db->sql_query( $q ); ! } ! else ! { ! $q = "UPDATE " . iNA_SCORES . " ! SET score = '" . $score . "' ! WHERE player = '" . $player . "' ! AND game_name = '" . $game . "'"; ! $r = $db->sql_query( $q ); ! } ! mx_message_die( GENERAL_MESSAGE, $player . "'s New Score Was Saved.", "Success" ); ! } ! ! if ( $mode == "edit_trophy_game_score" ) ! { ! $game = $_POST['trophy_game_selected']; ! ! if ( !$game ) ! { ! mx_message_die( GENERAL_ERROR, "Please Specify A Game.", "Error" ); ! } ! ! $q = "SELECT * ! FROM " . INA_TROPHY . " ! WHERE game_name = '$game'"; ! $r = $db->sql_query( $q ); ! $row = $db->sql_fetchrow( $r ); ! $player_score = $row['score']; ! $player_id = $row['player']; ! ! $q = "SELECT username ! FROM " . USERS_TABLE . " ! WHERE user_id = '" . $player_id . "'"; ! $r = $db->sql_query( $q ); ! $row = $db->sql_fetchrow( $r ); ! $player = $row['username']; ! ! echo "<table border='0' align='center' valign='top' class='forumline' width='100%'>"; ! echo "<form name='save_score' action='$link' method='post'>"; ! echo " <tr>"; ! echo " <td align='left' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " Current Score For $player On $game"; ! echo " </span>"; ! echo " </td>"; ! echo " <td align='center' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " $player_score"; ! echo " </span>"; ! echo " </td>"; ! echo " </tr>"; ! echo " <tr>"; ! echo " <td align='left' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " New Score For $player"; ! echo " </span>"; ! echo " </td>"; ! echo " <td align='center' valign='top' width='50%' class='row2'>"; ! echo " <input type='text' name='new_score' value='$player_score' class='post'>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br>"; ! echo "<table border='0' align='center' valign='top'>"; ! echo " <tr>"; ! echo " <td align='center' valign='middle' width='100%' class='row2'>"; ! echo " <input type='hidden' name='mode' value='save_new_t_score'>"; ! echo " <input type='hidden' name='game_selected' value='$game'>"; ! echo " <input type='hidden' name='player_selected' value='$player'>"; ! echo " <input type='hidden' name='player_id_selected' value='$player_id'>"; ! echo " <input type='submit' class='mainoption' value=' Save Score ' onchange='document.save_score.submit()'>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "</form>"; ! } ! ! if ( $mode == "save_new_t_score" ) ! { ! $game = $_POST['game_selected']; ! $player = $_POST['player_selected']; ! $score = $_POST['new_score']; ! $id = $_POST['player_id_selected']; ! ! $q = "SELECT * ! FROM " . INA_TROPHY . " ! WHERE game_name = '" . $game . "'"; ! $r = $db->sql_query( $q ); ! $row = $db->sql_fetchrow( $r ); ! $trophy_id = $row['player']; ! $trophy_sc = $row['score']; ! ! if ( $trophy_id == $id ) ! { ! $q = "UPDATE " . iNA_SCORES . " ! SET score = '" . $score . "' ! WHERE player = '" . $player . "' ! AND game_name = '" . $game . "'"; ! $r = $db->sql_query( $q ); ! ! $q = "UPDATE " . INA_TROPHY . " ! SET score = '" . $score . "' ! WHERE player = '" . $id . "' ! AND game_name = '" . $game . "'"; ! $r = $db->sql_query( $q ); ! } ! else ! { ! $q = "UPDATE " . iNA_SCORES . " ! SET score = '" . $score . "' ! WHERE player = '" . $player . "' ! AND game_name = '" . $game . "'"; ! $r = $db->sql_query( $q ); ! } ! mx_message_die( GENERAL_MESSAGE, $player . "'s New Score Was Saved.", "Success" ); ! } ! ! include( $mx_root_path . 'admin/page_footer_admin.' . $phpEx ); ! ?> \ No newline at end of file --- 1,428 ---- ! <?php ! ! /** ! * admin_ina_scores_edit.php ! * --------------------------- ! * Version : 1.0.3 ! * Email : aus...@ho... ! * Site : austin-inc.com/Blend/ ! * Copyright : © aUsTiN-Inc 2003/4 (Blend Portal System) ! */ ! define( 'IN_PORTAL', 1 ); ! ! if ( !empty( $setmodules ) ) ! { ! $file = basename( __FILE__ ); ! $module['Activities']['Scores Editor'] = 'modules/mx_act/admin/' . "$file"; ! return; ! } ! ! $mx_root_path = '../../../'; ! $module_root_path = "../"; ! require( $mx_root_path . 'extension.inc' ); ! require( $mx_root_path . '/admin/pagestart.' . $phpEx ); ! require( $module_root_path . 'includes/act_constants.' . $phpEx ); ! ! include( $module_root_path . 'includes/act_functions.' . $phpEx ); ! ! /* ! define('IN_PHPBB', 1); ! if( !empty($setmodules) ) ! { ! $file = basename(__FILE__); ! $module['Activities']['Scores Editor'] = "$file"; ! return; ! } ! ! $phpbb_root_path = "./../"; ! require($phpbb_root_path . 'extension.inc'); ! ! require('./pagestart.' . $phpEx); ! include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main.' . $phpEx); ! ! */ ! if ( isset( $HTTP_POST_VARS['mode'] ) || isset( $HTTP_GET_VARS['mode'] ) ) ! { ! $mode = ( isset( $HTTP_POST_VARS['mode'] ) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode']; ! } ! else ! { ! $mode = ''; ! } ! ! $link = append_sid( "admin_ina_scores_edit." . $phpEx ); ! ! echo "<table width='100%' border='0' class='forumline' cellspacing='2' align='center' valign='middle'>"; ! echo " <tr>"; ! echo " <th class='thHead' colspan='2'>"; ! echo " Activity Scores Edit Admin"; ! echo " </th>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br><br>"; ! ! if ( $mode == "main" || !$mode ) ! { ! echo "<table width='100%' border='0' class='forumline' cellspacing='2' align='center' valign='middle'>"; ! echo " <tr>"; ! echo " <td align='left' valign='top' width='100%' class='row2'>"; ! echo " <span class='gensmall'>"; ! echo " This feature is provided for changing players scores a little up or down etc. This ! feature <b>is NOT</b> for moving trophy holders around, that will cause issues ! among the tables. If you want to move trophy holders around, please do that via ! the top of your activity_top_scores.php page & not here."; ! echo " </span>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br><br>"; ! echo "<table border='0' align='center' valign='top' class='forumline' width='100%'>"; ! echo " <tr>"; ! echo " <td align='center' valign='top' width='100%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " Edit A Normal Score"; ! echo " </span>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<table border='0' align='center' valign='top' class='forumline' width='100%'>"; ! echo "<form name='edit_score' action='$link' method='post'>"; ! echo " <tr>"; ! echo " <td align='left' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " Select Game"; ! echo " </span>"; ! echo " </td>"; ! echo " <td align='center' valign='top' width='50%' class='row2'>"; ! echo " <select name='game_selected'>"; ! echo " <option selected value=''>Choose A Game</option>"; ! ! $q = "SELECT game_name ! FROM " . iNA_GAMES . " ! WHERE game_id > '0'"; ! $r = $db->sql_query( $q ); ! while ( $row = $db->sql_fetchrow( $r ) ) ! { ! $game_name = $row['game_name']; ! echo " <option value='" . $game_name . "'>" . $game_name . "</option>"; ! } ! echo " </select>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br>"; ! echo "<table border='0' align='center' valign='top'>"; ! echo " <tr>"; ! echo " <td align='center' valign='middle' width='100%' class='row2'>"; ! echo " <input type='hidden' name='mode' value='edit_game_score'>"; ! echo " <input type='submit' class='mainoption' value=' Find Scores ' onchange='document.edit_score.submit()'>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "</form>"; ! echo "<br><br>"; ! ! echo "<table border='0' align='center' valign='top' class='forumline' width='100%'>"; ! echo " <tr>"; ! echo " <td align='center' valign='top' width='100%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " Edit A Trophy Score"; ! echo " </span>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<table border='0' align='center' valign='top' class='forumline' width='100%'>"; ! echo "<form name='edit_trophy' action='$link' method='post'>"; ! echo " <tr>"; ! echo " <td align='left' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " Select Game"; ! echo " </span>"; ! echo " </td>"; ! echo " <td align='center' valign='top' width='50%' class='row2'>"; ! echo " <select name='trophy_game_selected'>"; ! echo " <option selected value=''>Choose A Game</option>"; ! ! $q = "SELECT game_name ! FROM " . iNA_GAMES . " ! WHERE game_id > '0'"; ! $r = $db->sql_query( $q ); ! while ( $row = $db->sql_fetchrow( $r ) ) ! { ! $game_name = $row['game_name']; ! echo " <option value='" . $game_name . "'>" . $game_name . "</option>"; ! } ! echo " </select>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br>"; ! echo "<table border='0' align='center' valign='top'>"; ! echo " <tr>"; ! echo " <td align='center' valign='middle' width='100%' class='row2'>"; ! echo " <input type='hidden' name='mode' value='edit_trophy_game_score'>"; ! echo " <input type='submit' class='mainoption' value=' Edit Trophy Score ' onchange='document.edit_trophy.submit()'>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "</form>"; ! echo "<br><br>"; ! } ! ! if ( $mode == "edit_game_score" ) ! { ! $game = $_POST['game_selected']; ! ! if ( !$game ) ! { ! mx_message_die( GENERAL_ERROR, "Please Specify A Game.", "Error" ); ! } ! ! echo "<table border='0' align='center' valign='top' class='forumline' width='100%'>"; ! echo "<form name='edit_trophy_player' action='$link' method='post'>"; ! echo " <tr>"; ! echo " <td align='left' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " Select A Player"; ! echo " </span>"; ! echo " </td>"; ! echo " <td align='center' valign='top' width='50%' class='row2'>"; ! echo " <select name='player_selected'>"; ! echo " <option selected value=''>Choose A Player</option>"; ! ! $q = "SELECT player ! FROM " . iNA_SCORES . " ! WHERE game_name = '$game' ! GROUP BY player"; ! $r = $db->sql_query( $q ); ! while ( $row = $db->sql_fetchrow( $r ) ) ! { ! $player_name = $row['player']; ! echo " <option value='" . $player_name . "'>" . $player_name . "</option>"; ! } ! echo " </select>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br>"; ! echo "<table border='0' align='center' valign='top'>"; ! echo " <tr>"; ! echo " <td align='center' valign='middle' width='100%' class='row2'>"; ! echo " <input type='hidden' name='mode' value='edit_player'>"; ! echo " <input type='hidden' name='game_selected' value='$game'>"; ! echo " <input type='submit' class='mainoption' value=' Edit Player ' onchange='document.edit_trophy_player.submit()'>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "</form>"; ! } ! ! if ( $mode == "edit_player" ) ! { ! $player = $_POST['player_selected']; ! $game = $_POST['game_selected']; ! ! $q = "SELECT * ! FROM " . iNA_SCORES . " ! WHERE game_name = '$game' ! AND player = '$player' ! GROUP BY player ! ORDER BY score ASC ! LIMIT 0, 1"; ! $r = $db->sql_query( $q ); ! $row = $db->sql_fetchrow( $r ); ! $player_name = $row['player']; ! $player_score = $row['score']; ! ! echo "<table border='0' align='center' valign='top' class='forumline' width='100%'>"; ! echo "<form name='save_score' action='$link' method='post'>"; ! echo " <tr>"; ! echo " <td align='left' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " Current Score For $player_name On $game"; ! echo " </span>"; ! echo " </td>"; ! echo " <td align='center' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " $player_score"; ! echo " </span>"; ! echo " </td>"; ! echo " </tr>"; ! echo " <tr>"; ! echo " <td align='left' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " New Score For $player_name"; ! echo " </span>"; ! echo " </td>"; ! echo " <td align='center' valign='top' width='50%' class='row2'>"; ! echo " <input type='text' name='new_score' value='$player_score' class='post'>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br>"; ! echo "<table border='0' align='center' valign='top'>"; ! echo " <tr>"; ! echo " <td align='center' valign='middle' width='100%' class='row2'>"; ! echo " <input type='hidden' name='mode' value='save_new_score'>"; ! echo " <input type='hidden' name='game_selected' value='$game'>"; ! echo " <input type='hidden' name='player_selected' value='$player_name'>"; ! echo " <input type='submit' class='mainoption' value=' Save Score ' onchange='document.save_score.submit()'>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "</form>"; ! } ! ! if ( $mode == "save_new_score" ) ! { ! $game = $_POST['game_selected']; ! $player = $_POST['player_selected']; ! $score = $_POST['new_score']; ! ! $q = "SELECT * ! FROM " . INA_TROPHY . " ! WHERE game_name = '" . $game . "'"; ! $r = $db->sql_query( $q ); ! $row = $db->sql_fetchrow( $r ); ! $trophy_id = $row['player']; ! $trophy_sc = $row['score']; ! ! $q = "SELECT user_id ! FROM " . USERS_TABLE . " ! WHERE username = '" . $player . "'"; ! $r = $db->sql_query( $q ); ! $row = $db->sql_fetchrow( $r ); ! $player_id = $row['user_id']; ! ! if ( $trophy_id == $player_id ) ! { ! $q = "UPDATE " . iNA_SCORES . " ! SET score = '" . $score . "' ! WHERE player = '" . $player . "' ! AND game_name = '" . $game . "'"; ! $r = $db->sql_query( $q ); ! ! $q = "UPDATE " . INA_TROPHY . " ! SET score = '" . $score . "' ! WHERE player = '" . $player_id . "' ! AND game_name = '" . $game . "'"; ! $r = $db->sql_query( $q ); ! } ! else ! { ! $q = "UPDATE " . iNA_SCORES . " ! SET score = '" . $score . "' ! WHERE player = '" . $player . "' ! AND game_name = '" . $game . "'"; ! $r = $db->sql_query( $q ); ! } ! mx_message_die( GENERAL_MESSAGE, $player . "'s New Score Was Saved.", "Success" ); ! } ! ! if ( $mode == "edit_trophy_game_score" ) ! { ! $game = $_POST['trophy_game_selected']; ! ! if ( !$game ) ! { ! mx_message_die( GENERAL_ERROR, "Please Specify A Game.", "Error" ); ! } ! ! $q = "SELECT * ! FROM " . INA_TROPHY . " ! WHERE game_name = '$game'"; ! $r = $db->sql_query( $q ); ! $row = $db->sql_fetchrow( $r ); ! $player_score = $row['score']; ! $player_id = $row['player']; ! ! $q = "SELECT username ! FROM " . USERS_TABLE . " ! WHERE user_id = '" . $player_id . "'"; ! $r = $db->sql_query( $q ); ! $row = $db->sql_fetchrow( $r ); ! $player = $row['username']; ! ! echo "<table border='0' align='center' valign='top' class='forumline' width='100%'>"; ! echo "<form name='save_score' action='$link' method='post'>"; ! echo " <tr>"; ! echo " <td align='left' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " Current Score For $player On $game"; ! echo " </span>"; ! echo " </td>"; ! echo " <td align='center' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " $player_score"; ! echo " </span>"; ! echo " </td>"; ! echo " </tr>"; ! echo " <tr>"; ! echo " <td align='left' valign='top' width='50%' class='row2'>"; ! echo " <span class='genmed'>"; ! echo " New Score For $player"; ! echo " </span>"; ! echo " </td>"; ! echo " <td align='center' valign='top' width='50%' class='row2'>"; ! echo " <input type='text' name='new_score' value='$player_score' class='post'>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "<br>"; ! echo "<table border='0' align='center' valign='top'>"; ! echo " <tr>"; ! echo " <td align='center' valign='middle' width='100%' class='row2'>"; ! echo " <input type='hidden' name='mode' value='save_new_t_score'>"; ! echo " <input type='hidden' name='game_selected' value='$game'>"; ! echo " <input type='hidden' name='player_selected' value='$player'>"; ! echo " <input type='hidden' name='player_id_selected' value='$player_id'>"; ! echo " <input type='submit' class='mainoption' value=' Save Score ' onchange='document.save_score.submit()'>"; ! echo " </td>"; ! echo " </tr>"; ! echo "</table>"; ! echo "</form>"; ! } ! ! if ( $mode == "save_new_t_score" ) ! { ! $game = $_POST['game_selected']; ! $player = $_POST['player_selected']; ! $score = $_POST['new_score']; ! $id = $_POST['player_id_selected']; ! ! $q = "SELECT * ! FROM " . INA_TROPHY . " ! WHERE game_name = '" . $game . "'"; ! $r = $db->sql_query( $q ); ! $row = $db->sql_fetchrow( $r ); ! $trophy_id = $row['player']; ! $trophy_sc = $row['score']; ! ! if ( $trophy_id == $id ) ! { ! $q = "UPDATE " . iNA_SCORES . " ! SET score = '" . $score . "' ! WHERE player = '" . $player . "' ! AND game_name = '" . $game . "'"; ! $r = $db->sql_query( $q ); ! ! $q = "UPDATE " . INA_TROPHY . " ! SET score = '" . $score . "' ! WHERE player = '" . $id . "' ! AND game_name = '" . $game . "'"; ! $r = $db->sql_query( $q ); ! } ! else ! { ! $q = "UPDATE " . iNA_SCORES . " ! SET score = '" . $score . "' ! WHERE player = '" . $player . "' ! AND game_name = '" . $game . "'"; ! $r = $db->sql_query( $q ); ! } ! mx_message_die( GENERAL_MESSAGE, $player . "'s New Score Was Saved.", "Success" ); ! } ! ! include( $mx_root_path . 'admin/page_footer_admin.' . $phpEx ); ! ?> \ No newline at end of file |