obj['sql_database'] = $dbname;
$DB->obj['sql_user'] = $dbusername;
$DB->obj['sql_pass'] = $dbpassword;
$DB->obj['sql_host'] = $servername;
$DB->obj['sql_port'] = $port;
$DB->obj['sql_tbl_prefix'] = $tableprefix;
}
else
{
// DBaccess for vBulletin 3.5.x
$DB->obj['sql_database'] = $config['Database']['dbname'];
$DB->obj['sql_user'] = $config['MasterServer']['username'];
$DB->obj['sql_pass'] = $config['MasterServer']['password'];
$DB->obj['sql_host'] = $config['MasterServer']['servername'];
$DB->obj['sql_port'] = $config['MasterServer']['port'];
$DB->obj['sql_tbl_prefix'] = $config['Database']['tableprefix'];
}
$DB->connect();
// read settings
$DB->query("SELECT * FROM ibf_games_settings");
$arcade = $DB->fetch_row();
$arcade['league_scores'] = explode("," , $arcade['league_scores'] );
$show_active = unserialize($arcade['show_active']);
if ($vbversion == "3.0")
{
$ibforums->member['id'] = $bbuserinfo['userid'];
}
else
{
$ibforums->member['id'] = $vbulletin->userinfo['userid'];
}
// load languagepack
$languageid = $arcade['arcade_language'];
$langfile = "lang_Arcade_".$languageid;
$ibforums->lang = $std->load_words($ibforums->lang, $langfile, $ibforums->lang_id );
// check if file is valid and compatible
if ($ibforums->lang['acp_on'] == "")
{
// incompatible language-file, load english (default)
$ibforums->lang = $std->load_words($ibforums->lang, 'lang_Arcade_en', $ibforums->lang_id );
}
if ($EMULATE_VBPLAZA==1)
{
$vbulletin->options['vbbux_enabled'] = 1;
$vbulletin->options['vbbux_arcadeintegration'] = 1;
}
// parse all incoming data
$IN = $std->parse_incoming();
foreach($_POST as $key => $value)
{
$IN[$key] = $value;
}
foreach($_GET as $key => $value)
{
$IN[$key] = $value;
}
$action = $_GET['code'];
if ($action == "")
{
$action = "gamelist";
}
switch ($_POST['do'])
{
case "updatesettings":
$action = "updatesettings";
break;
case "jumpsettings":
$action = "settings";
break;
case "updategroups":
$action = "updategroups";
break;
case "sort_games":
$action = "sortgames";
break;
case "edit_categories":
$action = "do_cat_stuff";
$IN['do'] = "edit";
break;
case "cat":
$action = "cat";
break;
case "add_category":
$action = "do_cat_stuff";
$IN['do'] = "add";
break;
case "usermanager":
$action = "usermanager";
break;
case "save_user":
$action = "save_user";
break;
case "save_ipban":
$action = "save_ipban";
break;
case "score_tools":
$action = "score_tools";
break;
case "tool_scores":
$action = "tool_scores";
break;
case "tool_multi_del":
$action = "tool_multi_del";
break;
case "tool_actnames":
$action = "tool_actnames";
break;
case "tool_champs":
$action = "tool_champs";
break;
case "tool_best":
$action = "tool_best";
break;
case "tool_league":
$action = "tool_league";
break;
case "games_setmulticat":
$action = "games_setmulticat";
break;
case "user_search":
$action = "user_search";
break;
case "prunet":
$action = "tourney_stuff";
$IN['do'] = "prunet";
break;
case "newt":
$action = "tourney_stuff";
$IN['do'] = "newt";
break;
case "add_t_confirm":
$action = "tourney_stuff";
$IN['do'] = "add_t_confirm";
break;
case "do_add_t":
$action = "tourney_stuff";
$IN['do'] = "do_add_t";
break;
case "confirm_r":
$action = "tourney_stuff";
$IN['do'] = "confirm_r";
break;
case "viewtourney":
$action = "tourney_stuff";
$IN['do'] = "view";
break;
case "do_replace":
$action = "tourney_stuff";
$IN['do'] = "do_replace";
break;
case "add_game":
$action = "add_game";
break;
case "del":
$action = "del";
break;
case "do_edit":
$action = "do_editgame";
break;
case "edit_comment":
$action = "edit_comment";
break;
case "do_add":
$action = "do_addgame";
break;
case "do_add_sql":
$action = "do_add_sql";
break;
case "tourneysettings":
$action = "tourneysettings";
break;
case "savemessages":
$action = "savemessages";
break;
}
// ##### some functionality for some following operations #####
function update_cat_game_nums()
{
global $DB;
$new_amounts = array();
$this_query = $DB->query("SELECT c_id, show_all FROM ibf_games_cats ORDER BY c_id");
while( $CAT = $DB->fetch_row($this_query) )
{
$query_extra = "";
if( !$CAT['show_all'] )
{
$query_extra = "AND gcat=".$CAT['c_id'];
}
$DB->query("SELECT COUNT(gid) AS amount FROM ibf_games_list WHERE active=1 ".$query_extra);
$the = $DB->fetch_row();
$new_amounts[ $CAT['c_id'] ] = $the['amount'];
}
foreach( $new_amounts as $cat=>$amount )
{
$db_string = $DB->compile_db_update_string( array ( 'num_of_games' => $amount ) );
$DB->query("UPDATE ibf_games_cats SET ".$db_string." WHERE c_id='".$cat."'");
}
}
function do_champ_update($auto_run = 0)
{
global $IN, $DB;
$query_extra = "";
if( !$auto_run )
{
if( !in_array("0" , $IN['in_game']) )
{
$query_extra .= "WHERE gid IN (".implode("," , $IN['in_game']).")";
}
}
$the_champs = array();
if( $query_extra == "" )
{
$DB->query("DELETE FROM ibf_games_champs");
}
$game_query = $DB->query("SELECT gid, highscore_type, gtitle FROM ibf_games_list ".$query_extra." ORDER by gtitle");
while( $game = $DB->fetch_row($game_query) )
{
$order = ($game['highscore_type'] == "high") ? "DESC" : "ASC";
$DB->query("SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
FROM ibf_games_scores AS s, ibf_games_list AS g
WHERE s.gid=g.gid AND s.gid=".$game['gid']."
ORDER BY score ".$order.", timespent ASC");
if( $DB->get_num_rows() )
{
$champ = $DB->fetch_row();
$the_champs[] = array( 'gid' => $champ['gid'],
'gtitle' => $champ['gtitle'],
'mid' => $champ['mid'],
'name' => $champ['name'],
'date' => $champ['datescored'],
'score' => $champ['score'] );
}
}
foreach( $the_champs as $this_champ )
{
if( $query_extra != "" )
{
$db_string = $DB->compile_db_update_string( array ( 'champ_gid' => $this_champ['gid'],
'champ_gtitle' => $this_champ['gtitle'],
'champ_mid' => $this_champ['mid'],
'champ_name' => $this_champ['name'],
'champ_date' => $this_champ['date'],
'champ_score' => $this_champ['score']
) );
$DB->query("UPDATE ibf_games_champs SET ".$db_string." WHERE champ_gid=".$this_champ['gid']);
}
else
{
$db_string = $DB->compile_db_insert_string( array ( 'champ_gid' => $this_champ['gid'],
'champ_gtitle' => $this_champ['gtitle'],
'champ_mid' => $this_champ['mid'],
'champ_name' => $this_champ['name'],
'champ_date' => $this_champ['date'],
'champ_score' => $this_champ['score']
) );
$DB->query("INSERT INTO ibf_games_champs (".$db_string['FIELD_NAMES'].") VALUES (".$db_string['FIELD_VALUES'].")");
}
}
if( !$auto_run )
{
/*
if( $arcade['log'] )
{
$ADMIN->save_log("Highscores aktualisiert");
}
*/
define('CP_REDIRECT', 'arcade.php?code=score_tools');
print_stop_message('saved_settings_successfully');
}
}
function do_league_update($auto_run = 0)
{
global $IN, $DB;
$DB->query("DELETE FROM ibf_games_league");
$game_query = $DB->query("SELECT * FROM ibf_games_list WHERE active=1");
while ($ginfo = $DB->fetch_row($game_query))
{
$ordering = ($ginfo['highscore_type'] == "high") ? "DESC" : "ASC";
$ctr = 1;
$this_query = $DB->query("SELECT mid FROM ibf_games_scores WHERE gid='".$ginfo['gid']."' ORDER BY score ".$ordering.", timespent ASC LIMIT 0,10");
if ($DB->get_num_rows($this_query))
{
while($lboard = $DB->fetch_row($this_query))
{
switch($ctr)
{
case 1: $points = $arcade['league_scores'][0];
break;
case 2: $points = $arcade['league_scores'][1];
break;
case 3: $points = $arcade['league_scores'][2];
break;
case 4: $points = $arcade['league_scores'][3];
break;
case 5: $points = $arcade['league_scores'][4];
break;
case 6: $points = $arcade['league_scores'][5];
break;
case 7: $points = $arcade['league_scores'][6];
break;
case 8: $points = $arcade['league_scores'][7];
break;
case 9: $points = $arcade['league_scores'][8];
break;
case 10: $points = $arcade['league_scores'][9];
break;
default: $points = $arcade['league_scores'][10];
}
if ($points > 0)
{
extract($ginfo);
$lid = $lboard['mid'];
$db_string = $DB->compile_db_insert_string( array ( 'mid' => $lid,
'gid' => $gid,
'position' => $ctr,
'points' => $points,
'cat' => $gcat,
) );
$DB->query("INSERT INTO ibf_games_league (" .$db_string['FIELD_NAMES']. ") VALUES (". $db_string['FIELD_VALUES'] .")");
}
$ctr++;
}
}
}
if (!$auto_run)
{
/*
if( $arcade['log'] )
{
$ADMIN->save_log("Rangliste aktualisiert");
}
*/
define('CP_REDIRECT', 'arcade.php?code=score_tools');
print_stop_message('saved_settings_successfully');
}
}
function confirm($game_id = "")
{
global $IN, $DB, $ibforums;
$game_id = $IN['gid'];
$DB->query("SELECT gtitle, gname FROM ibf_games_list WHERE gid=".$game_id);
$GAME = $DB->fetch_row();
$existsf = ( file_exists($INFO['base_dir']."arcade/".$GAME['gname'].".swf") ) ? "".$ibforums->lang['acp_yes']." " : "".$ibforums->lang['acp_no']." ".$ibforums->lang['acp_yes']." " : "".$ibforums->lang['acp_no']." ".$ibforums->lang['acp_yes']." " : "".$ibforums->lang['acp_no']." ".$ibforums->lang['acp_yes']." " : "".$ibforums->lang['acp_no']." ".$ibforums->lang['acp_yes']." " : "".$ibforums->lang['acp_no']." ".$ibforums->lang['acp_yes']." " : "".$ibforums->lang['acp_no']." ".$ibforums->lang['acp_game_tar_confirm1']."
";
$header[] = $ibforums->lang['acp_game_tar_confirm2'];
$header[] = "".$ibforums->lang['acp_game_tar_confirm3']."
";
$colspan = sizeof($header);
print_table_header($ibforums->lang['acp_game_tar_removehead'].$GAME['gtitle'], $colspan);
print_cells_row($header, 1);
$cell = array();
$cell[] = "".$GAME['gname'].".swf
";
$cell[] = "".$existsf."
";
$cell[] = "".$removablef."
";
print_cells_row($cell);
$cell = array();
$cell[] = "".$GAME['gname']."1.gif
";
$cell[] = "".$existsi1."
";
$cell[] = "".$removablei1."
";
print_cells_row($cell);
$cell = array();
$cell[] = "".$GAME['gname']."2.gif
";
$cell[] = "".$existsi2."
";
$cell[] = "".$removablei2."
";
print_cells_row($cell);
print_table_break('', "90%");
print_select_row($ibforums->lang['acp_game_tar_select'], 'confirm', array('0' => $ibforums->lang['acp_game_tar_select1'], '1' => $ibforums->lang['acp_game_tar_select2'], '2' => $ibforums->lang['acp_game_tar_select3']), 0);
construct_hidden_code('gid', $game_id);
print_submit_row($ibforums->lang['acp_save_settings'], 0);
print_cp_footer();
exit;
}
function timeoutput($temptime)
// show correct date/time information, by MrZeropage
{
global $languageid;
$bbuserinfo['tzoffset'] = $bbuserinfo['timezoneoffset'];
if ($bbuserinfo['dstonoff'])
{
$bbuserinfo['tzoffset']++;
if (substr($bbuserinfo['tzoffset'], 0, 1) != '-')
{
// recorrect so that it has + sign, if necessary
$bbuserinfo['tzoffset'] = '+' . $bbuserinfo['tzoffset'];
}
}
if ($bbuserinfo['tzoffset'])
{
if ($bbuserinfo['tzoffset'] > 0 AND strpos($bbuserinfo['tzoffset'], '+') === false)
{
$bbuserinfo['tzoffset'] = '+' . $bbuserinfo['tzoffset'];
}
}
if (substr($bbuserinfi['tzoffset'],1,0) == "+")
{
$temptime = $temptime + strval(substr($bbuserinfo['tzoffset'],1)) * 3600;
}
else
{
$temptime = $temptime - strval(substr($bbuserinfo['tzoffset'],1)) * 3600;
}
if ($languageid == "de")
{
$dateformat = "d.m.Y H:i";
}
else
{
$dateformat = "Y-m-d h:i a";
}
$output = vbdate($dateformat, $temptime);
return $output;
}
// ##############################
// notifications / messages
// ##############################
if ($action == "messages")
{
$commoncodes = " %NAME% = ".$ibforums->lang['acp_notifi_NAME']."%GAME% = ".$ibforums->lang['acp_notifi_GAME'];
$additional1 = " %CHAMP% = ".$ibforums->lang['acp_notifi_CHAMP']."%LINKGAME| text % = ".$ibforums->lang['acp_notifi_LINKG']."%LINKHIGH| text % = ".$ibforums->lang['acp_notifi_LINKH'];
$additional2 = " %LINK| text % = ".$ibforums->lang['acp_notifi_LINKT'];
$additional3 = " %OTHER% = ".$ibforums->lang['acp_notifi_OPPONENT']."%LINK| text % = ".$ibforums->lang['acp_notifi_LINKT'];
$additional4 = " %OTHER% = ".$ibforums->lang['acp_notifi_OPPONENT']."%LINK| text % = ".$ibforums->lang['acp_notifi_LINKT'];
$additional5 = " %LINK| text % = ".$ibforums->lang['acp_notifi_LINKT'];
$additional6 = " %LINK| text % = ".$ibforums->lang['acp_notifi_LINKT'];
$additional7 = " %LINK| text % = ".$ibforums->lang['acp_notifi_LINKT']."%LIMIT% = ".$ibforums->lang['acp_notifi_DAYS'];
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'savemessages');
print_table_header($ibforums->lang['acp_notifi_head']);
print_description_row($ibforums->lang['acp_notifi_global']."".$commoncodes." ");
print_yes_no_row($ibforums->lang['acp_notifi_sendwhen'].$ibforums->lang['acp_notifi_msg1desc'], 'msgsys_hscore', $arcade['msgsys_hscore']);
print_textarea_row($ibforums->lang['acp_notifi_msgtxt']."".$ibforums->lang['acp_notifi_msg1name']." ".$ibforums->lang['acp_notifi_additional']." ", 'msgsys_hscore_text', $arcade['msgsys_hscore_text'], 6, 45);
print_yes_no_row($ibforums->lang['acp_notifi_sendwhen'].$ibforums->lang['acp_notifi_msg2desc'], 'msgsys_tstart', $arcade['msgsys_tstart']);
print_textarea_row($ibforums->lang['acp_notifi_msgtxt']."".$ibforums->lang['acp_notifi_msg2name']." ".$ibforums->lang['acp_notifi_additional']." ", 'msgsys_tstart_text', $arcade['msgsys_tstart_text'], 6, 45);
print_yes_no_row($ibforums->lang['acp_notifi_sendwhen'].$ibforums->lang['acp_notifi_msg3desc'], 'msgsys_tadvance', $arcade['msgsys_tadvance']);
print_textarea_row($ibforums->lang['acp_notifi_msgtxt']."".$ibforums->lang['acp_notifi_msg3name']." ".$ibforums->lang['acp_notifi_additional']." ", 'msgsys_tadvance_text', $arcade['msgsys_tadvance_text'], 6, 45);
print_yes_no_row($ibforums->lang['acp_notifi_sendwhen'].$ibforums->lang['acp_notifi_msg4desc'], 'msgsys_telim', $arcade['msgsys_telim']);
print_textarea_row($ibforums->lang['acp_notifi_msgtxt']."".$ibforums->lang['acp_notifi_msg4name']." ".$ibforums->lang['acp_notifi_additional']." ", 'msgsys_telim_text', $arcade['msgsys_telim_text'], 6, 45);
print_yes_no_row($ibforums->lang['acp_notifi_towinner'], 'msgsys_twin', $arcade['msgsys_twin']);
print_textarea_row($ibforums->lang['acp_notifi_msgtxt']."".$ibforums->lang['acp_notifi_msg5name']." ".$ibforums->lang['acp_notifi_additional']." ", 'msgsys_twin_text', $arcade['msgsys_twin_text'], 6, 45);
print_textarea_row($ibforums->lang['acp_notifi_msgtxt']."".$ibforums->lang['acp_notifi_msg6name']." ".$ibforums->lang['acp_notifi_additional']." ", 'msgsys_tremind_text', $arcade['msgsys_tremind_text'], 6, 45);
print_textarea_row($ibforums->lang['acp_notifi_msgtxt']."".$ibforums->lang['acp_notifi_msg7name']." ".$ibforums->lang['acp_notifi_additional']." ", 'msgsys_tdisqual_text', $arcade['msgsys_tdisqual_text'], 6, 45);
print_submit_row($ibforums->lang['acp_save_settings'], 0);
print_cp_footer();
exit;
}
// ##############################
// save messages
// ##############################
if ($action == "savemessages")
{
global $IN;
$db_string = $DB->compile_db_update_string( array ( 'msgsys_hscore' => $IN['msgsys_hscore'],
'msgsys_hscore_text' => $IN['msgsys_hscore_text'],
'msgsys_tstart' => $IN['msgsys_tstart'],
'msgsys_tstart_text' => $IN['msgsys_tstart_text'],
'msgsys_tadvance' => $IN['msgsys_tadvance'],
'msgsys_tadvance_text' => $IN['msgsys_tadvance_text'],
'msgsys_telim' => $IN['msgsys_telim'],
'msgsys_telim_text' => $IN['msgsys_telim_text'],
'msgsys_twin' => $IN['msgsys_twin'],
'msgsys_twin_text' => $IN['msgsys_twin_text'],
'msgsys_tremind_text' => $IN['msgsys_tremind_text'],
'msgsys_tdisqual_text' => $IN['msgsys_tdisqual_text']
) );
$DB->query("UPDATE ibf_games_settings SET ".$db_string);
/*
if( $arcade['log'] )
{
$ADMIN->save_log("");
}
*/
define('CP_REDIRECT', 'arcade.php?code=messages');
print_stop_message('saved_settings_successfully');
}
// ##############################
// main settings
// ##############################
if ($action == "settings")
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'updatesettings');
// read the language-files
// de => name
$files = array();
$dir = ROOT_PATH."arcade/lang";
$langfiles = array();
if ( is_dir($dir) )
{
$the_dir = opendir($dir);
while( ($filename = readdir($the_dir)) !== false )
{
if( ($filename != ".") && ($filename != "..") )
{
if (substr($filename,0,12) == "lang_Arcade_")
{
$langid = substr($filename,12,2);
switch ($langid)
{
case "en": $langname = "english"; break;
case "de": $langname = "deutsch"; break;
case "fr": $langname = "francais"; break;
case "nl": $langname = "nederlands"; break;
case "it": $langname = "italiano"; break;
case "tr": $langname = "turkiye"; break;
case "es" : $langname = "espaniol"; break;
case "pt" : $langname = "portuguese"; break;
case "ar" : $langname = "arabic"; break;
default: $langname = "?"; break;
}
$langfiles[$langid] = $langname;
}
}
}
closedir($the_dir);
}
print_table_header($ibforums->lang['acp_main_header']);
print_select_row($ibforums->lang['acp_main_arcade_status'], 'arcade_status', array('1' => $ibforums->lang['acp_on'], '0' => $ibforums->lang['acp_off']), $arcade['arcade_status']);
print_select_row($ibforums->lang['acp_main_arcade_lang'], 'arcade_language', $langfiles, $arcade['arcade_language']);
print_input_row($ibforums->lang['acp_main_arcade_timeout'], 'scoretimeout', $arcade['scoretimeout'], 0);
print_select_row($ibforums->lang['acp_main_g_display_sort'], 'g_display_sort', array('gtitle' => $ibforums->lang['acp_alphabetic'], 'gcount' => $ibforums->lang['acp_oftenplayed'], 'added' => $ibforums->lang['dateadded'], 'position' => $ibforums->lang['acp_userdefined']), $arcade['g_display_sort']);
print_select_row($ibforums->lang['acp_main_g_disp_order'], 'g_display_order', array('ASC' => $ibforums->lang['acp_ASC'], 'DESC' => $ibforums->lang['acp_DESC']), $arcade['g_display_order']);
print_input_row($ibforums->lang['acp_main_games_pr'], 'games_pr', $arcade['games_pr'], 0);
print_input_row($ibforums->lang['acp_main_games_pp'], 'games_pp', $arcade['games_pp'], 0);
print_input_row($ibforums->lang['acp_main_scores_amount'], 'scores_amount', $arcade['scores_amount'], 0);
print_input_row($ibforums->lang['acp_main_user_choices'], 'user_choices', $arcade['user_choices'], 0);
print_select_row($ibforums->lang['acp_main_skin'], 'skin', array('0' => "ibProArcade", '1' => "v3arcade"), $arcade['skin']);
print_yes_no_row($ibforums->lang['acp_main_user_skin'], 'allow_user_skin', $arcade['allow_user_skin']);
$selectedmin = ""; $selectedhour = ""; $selectedday = "";
if ($arcade['show_new_frame'] == "60") { $selectedmin = "selected='selected'"; }
if ($arcade['show_new_frame'] == "3600") { $selectedhour = "selected='selected'"; }
if ($arcade['show_new_frame'] == "86400") { $selectedday = "selected='selected'"; }
$output = array();
$output[] = $ibforums->lang['acp_main_show_new'];
$output[] = "
\n
".$ibforums->lang['acp_minutes']." \n
".$ibforums->lang['acp_hours']." \n
".$ibforums->lang['acp_days']." \n
\n
";
print_cells_row($output);
print_input_row($ibforums->lang['acp_main_games_new'], 'games_new', $arcade['games_new'], 0);
print_input_row($ibforums->lang['acp_main_games_popular'], 'games_popular', $arcade['games_popular'], 0);
print_select_row($ibforums->lang['acp_main_score_type'], 'score_type', array('all' => $ibforums->lang['acp_allscores'], 'top' => $ibforums->lang['acp_bestscores']), $arcade['score_type']);
print_select_row($ibforums->lang['acp_main_scores_sep'], 'score_sep', array('0' => $ibforums->lang['acp_main_seperator1'], ',' => $ibforums->lang['acp_main_seperator2'], ' ' => $ibforums->lang['acp_main_seperator3'], '.' => $ibforums->lang['acp_main_seperator4']), $arcade['score_sep']);
//print_input_row($ibforums->lang['acp_main_decimal_amount'], 'dec_amount', $arcade['dec_amount'], 0);
print_yes_no_row($ibforums->lang['acp_main_show_crowns'], 'show_crowns', $arcade['show_crowns']);
print_yes_no_row($ibforums->lang['acp_main_show_t_won'], 'show_t_won', $arcade['show_t_won']);
print_select_row($ibforums->lang['acp_main_crown_type'], 'crown_type', array('0' => "Standard", '1' => $ibforums->lang['acp_marquee_hori'], '2' => $ibforums->lang['acp_marquee_verti'], '3' => $ibforums->lang['acp_nomarquee'], '4' => $ibforums->lang['acp_trophy']), $arcade['crown_type']);
print_select_row($ibforums->lang['acp_main_notification'], 'notification', array('none' => $ibforums->lang['acp_main_notify_pm1'], 'pm' => $ibforums->lang['acp_main_notify_pm2'], 'mail' => $ibforums->lang['acp_main_notify_pm3'], 'pm+mail' => $ibforums->lang['acp_main_notify_pm4']), $arcade['notification']);
print_yes_no_row($ibforums->lang['acp_main_use_cats'], 'use_cats', $arcade['use_cats']);
print_input_row($ibforums->lang['acp_main_cats_per_tr'], 'cats_per_tr', $arcade['cats_per_tr'], 0);
$DB->query("SELECT * FROM ibf_games_cats WHERE active=1 ORDER BY pos, cat_name");
$cat_list = array();
while( $CAT = $DB->fetch_row() )
{
$cat_list[$CAT['c_id']] = $CAT['cat_name'];
}
print_select_row($ibforums->lang['acp_main_def_cat'], 'def_cat', $cat_list, $arcade['def_cat']);
print_yes_no_row($ibforums->lang['acp_main_use_announce'], 'use_announce', $arcade['use_announce']);
print_textarea_row($ibforums->lang['acp_main_announce'], 'announcement', $arcade['announcement'], 6, 45);
print_yes_no_row($ibforums->lang['acp_main_log'], 'log', $arcade['log']);
if ($arcade['htmltitle']=="") { $arcade['htmltitle'] = "%FORUMNAME% - %IBPRO% - %ACTION%"; }
print_input_row("HTML-Title format%FORUMNAME% = your forums name ", 'htmltitle', $arcade['htmltitle'], 0);
print_table_break('', "90%");
print_table_header($ibforums->lang['acp_main_prune_header']);
print_yes_no_row($ibforums->lang['acp_main_prune_auto'], 'auto_prune', $arcade['auto_prune']);
$selectedhour = ""; $selectedday = ""; $selectedmonth = "";
if ($arcade['auto_prune_time2'] == "3600") { $selectedhour = "selected='selected'"; }
if ($arcade['auto_prune_time2'] == "86400") { $selectedday = "selected='selected'"; }
if ($arcade['auto_prune_time2'] == "2592000") { $selectedmonth = "selected='selected'"; }
$output = array();
$output[] = $ibforums->lang['acp_main_prune_time1'];
$output[] = "
\n
".$ibforums->lang['acp_hours']." \n
".$ibforums->lang['acp_days']." \n
".$ibforums->lang['acp_months']." \n
\n
";
print_cells_row($output);
print_table_break('', "90%");
print_table_header($ibforums->lang['acp_main_online_header']);
print_yes_no_row($ibforums->lang['acp_main_online_main'], 'show_active_glist', $show_active['glist']);
print_yes_no_row($ibforums->lang['acp_main_online_game'], 'show_active_play', $show_active['play']);
print_yes_no_row($ibforums->lang['acp_main_online_tourney'], 'show_active_playtourney', $show_active['playtourney']);
print_yes_no_row($ibforums->lang['acp_main_online_comment'], 'show_active_newscore', $show_active['newscore']);
print_yes_no_row($ibforums->lang['acp_main_online_scores'], 'show_active_stats', $show_active['stats']);
print_yes_no_row($ibforums->lang['acp_main_online_tourna1'], 'show_active_viewtournaments', $show_active['viewtournaments']);
print_yes_no_row($ibforums->lang['acp_main_online_tourna2'], 'show_active_viewtourney', $show_active['viewtourney']);
print_table_break('', "90%");
print_table_header($ibforums->lang['acp_main_league_header']);
for ($count=0; $count<10; $count++)
{
print_input_row($ibforums->lang['acp_main_league_rank'].($count+1), "league_score".$count, $arcade['league_scores'][$count], 0);
construct_hidden_code("oldleague".$count, $arcade['league_scores'][$count]);
}
print_input_row($ibforums->lang['acp_main_league_last'], 'league_score10', $arcade['league_scores'][10], 0);
construct_hidden_code("oldleague10", $arcade['league_scores'][10]);
construct_hidden_code("old_language", $arcade['arcade_language']);
construct_hidden_code("old_scoretype", $arcade['score_type']);
$vbversion = substr($vboptions[templateversion],0,3);
if ($vbversion != "3.0")
{
($hook = vBulletinHook::fetch_hook('ibproarcade_acp_mainsettings')) ? eval($hook) : false;
}
print_submit_row($ibforums->lang['acp_save_settings'], 0);
print_cp_footer();
exit;
}
// ################################
// store main settings to DB
// ################################
if ($action == "updatesettings")
{
global $IN;
/* $IN[glist] = $show_active[glist];
$IN[newscore] = $show_active[newscore];
$IN[stats] = $show_active[stats];
$IN[viewtournaments] = $show_active[viewtournaments];
$IN[playtourney] = $show_active[playtourney];
$IN[viewtourney] = $show_active[viewtourney];
*/
// Überprüfung der Werte auf Plausibilität
$IN['scores_amount'] = intval($IN['scores_amount']);
if ( empty($IN['arcade_language']) )
{
// default language is english
$IN['arcade_language'] = "en";
}
if( empty($IN['scores_amount']) || $IN['scores_amount'] < 1 || $IN['scores_amount'] > 100)
{
$IN['scores_amount']=10;
}
$changedleague = false;
for ($x=0; $x<=10; $x++)
{
$arcade['league_scores'][$x] = $IN["league_score".$x];
if ($IN["league_score".$x] != $IN["oldleague".$x])
{
$changedleague = true;
}
}
$arcade['league_scores'] = implode("," ,$arcade['league_scores']);
if( empty($IN['time_frame_num']) || !is_numeric($IN['time_frame_num']) || $IN['time_frame_num'] < 0 )
{
$IN['time_frame_num'] = 0;
}
$IN['auto_prune_time'] = intval($IN['auto_prune_time']);
if( $IN['auto_prune_time'] < 0 )
{
$IN['auto_prune_time'] = 0;
}
$IN['games_pp'] = intval($IN['games_pp']);
if( ($IN['games_pp'] < 1) || ($IN['games_pp'] > 200))
{
$IN['games_pp'] = 200;
}
$IN['cats_per_tr'] = intval($IN['cats_per_tr']);
if( $IN['cats_per_tr'] < 0 )
{
$IN['cats_per_tr'] = 0;
}
$IN['dec_amount'] = intval($IN['dec_amount']);
if( $IN['dec_amount'] < 0 )
{
$IN['dec_amount'] = 0;
}
$IN['games_pr'] = intval($IN['games_pr']);
if( $IN['games_pr'] < 1 )
{
$IN['games_pr'] = 1;
}
if ($IN['games_new'] < 1)
{
$IN['games_new'] = 1;
}
if ($IN['games_popular'] < 1)
{
$IN['games_popular']=1;
}
$IN['scoretimeout'] = intval($IN['scoretimeout']);
if ($IN['scoretimeout'] < 1)
{
$IN['scoretimeout'] = 1;
}
$announcement = $IN['announcement'];
if ($vbversion == "3.0")
{
require_once('./includes/functions_bbcodeparse.php');
$announcement_parsed = parse_bbcode($IN['announcement']);
}
else
{
require_once('./includes/class_bbcode.php');
$bbcode_parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());
$announcement_parsed = $bbcode_parser->parse($IN['announcement'],0,1);
}
$show_active = array();
$tmp = array();
$tmp['glist'] = $IN['show_active_glist'];
$tmp['play'] = $IN['show_active_play'];
$tmp['newscore'] = $IN['show_active_newscore'];
$tmp['stats'] = $IN['show_active_stats'];
$tmp['viewtournaments'] = $IN['show_active_viewtournaments'];
$tmp['playtourney'] = $IN['show_active_playtourney'];
$tmp['viewtourney'] = $IN['show_active_viewtourney'];
$show_active = serialize($tmp);
$queryprepare = array ( 'arcade_status' => $IN['arcade_status'],
'arcade_language' => $IN['arcade_language'],
'g_display_sort' => $IN['g_display_sort'],
'g_display_order' => $IN['g_display_order'],
'scores_amount' => $IN['scores_amount'],
'score_type' => $IN['score_type'],
'log' => $IN['log'],
'skin' => $IN['skin'],
'use_cats' => $IN['use_cats'],
'crown_type' => $IN['crown_type'],
'notification' => $IN['notification'],
'show_new' => $IN['show_new'],
'show_new_frame' => $IN['show_new_frame'],
'show_active' => $show_active,
'auto_prune' => $IN['auto_prune'],
'auto_prune_time' => $IN['auto_prune_time'],
'auto_prune_time2' => $IN['auto_prune_time2'],
'games_pr' => $IN['games_pr'],
'games_pp' => $IN['games_pp'],
'user_choices' => $IN['user_choices'],
'allow_user_skin' => $IN['allow_user_skin'],
'def_cat' => $IN['def_cat'],
'cats_per_tr' => $IN['cats_per_tr'],
'show_crowns' => $IN['show_crowns'],
'show_t_won' => $IN['show_t_won'],
'score_sep' => $IN['score_sep'],
'dec_amount' => $IN['dec_amount'],
'league_scores' => $arcade['league_scores'],
'use_announce' => $IN['use_announce'],
'announcement' => $announcement,
'announcement_parsed' => $announcement_parsed,
'games_new' => $IN['games_new'],
'games_popular' => $IN['games_popular'],
'scoretimeout' => $IN['scoretimeout'],
'htmltitle' => addslashes($IN['htmltitle'])
);
$vbversion = substr($vboptions[templateversion],0,3);
if ($vbversion != "3.0")
{
($hook = vBulletinHook::fetch_hook('ibproarcade_acp_mainsettings_query')) ? eval($hook) : false;
}
$db_string = $DB->compile_db_update_string($queryprepare);
$DB->query("UPDATE ibf_games_settings SET ".$db_string);
/*
if( $arcade['log'] )
{
$ADMIN->save_log("");
}
*/
if (($IN['old_scoretype'] != $IN['score_type']) && ($IN['score_type']=="top"))
{
// prune scores, just keep the top per game from each player
}
if ($IN['old_language'] != $IN['arcade_language'])
// language changed, so update the vB-phrases for leftside menu :-)
{
// read new languagefile
$languageid = $IN['arcade_language'];
$langfile = "lang_Arcade_".$languageid;
$ibforums->lang = $std->load_words($ibforums->lang, $langfile, $ibforums->lang_id );
// check if file is valid and compatible
if ($ibforums->lang['acp_on'] == "")
{
// incompatible language-file, load english (default)
$ibforums->lang = $std->load_words($ibforums->lang, 'lang_Arcade_en', $ibforums->lang_id );
}
// update phrases to fit the new language
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['acp_menu0'].'" WHERE varname="ibparcade_acpmenu0"');
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['acp_menu1'].'" WHERE varname="ibparcade_acpmenu1"');
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['acp_menu2'].'" WHERE varname="ibparcade_acpmenu2"');
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['acp_menu3'].'" WHERE varname="ibparcade_acpmenu3"');
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['acp_menu4'].'" WHERE varname="ibparcade_acpmenu4"');
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['acp_menu5'].'" WHERE varname="ibparcade_acpmenu5"');
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['acp_menu6'].'" WHERE varname="ibparcade_acpmenu6"');
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['acp_menu7'].'" WHERE varname="ibparcade_acpmenu7"');
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['acp_menu8'].'" WHERE varname="ibparcade_acpmenu8"');
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['acp_menu9'].'" WHERE varname="ibparcade_acpmenu9"');
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['acp_menu10'].'" WHERE varname="ibparcade_acpmenu10"');
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['acp_menu11'].'" WHERE varname="ibparcade_acpmenu11"');
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['wol_home'].'" WHERE varname="ibproarcade_home"');
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['wol_play'].'" WHERE varname="ibproarcade_playing_game"');
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['wol_viewscore'].'" WHERE varname="ibproarcade_viewing_highscores"');
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['wol_viewhome'].'" WHERE varname="ibproarcade_viewing_home"');
$DB->query('UPDATE ibf_phrase SET text="'.$ibforums->lang['postbit_tourney'].'" WHERE varname="ibpa_tourney"');
// make sure to rebuild the language after saving data
$finalcommand = "language.php?do=rebuild&goto=arcade.php?code=settings";
if ($changedleague)
{
// update league after rebuilding language
$finalcommand = "language.php?do=rebuild&goto=arcade.php?code=tool_league";
}
define('CP_REDIRECT', $finalcommand);
print_stop_message('saved_settings_successfully');
}
if ($changedleague)
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'tool_league');
print_table_header($ibforums->lang['acp_gamesort_err_header']);
print_description_row($ibforums->lang['acp_main_updleague']);
print_submit_row($ibforums->lang['acp_main_league_button'], 0);
print_cp_footer();
exit;
}
else
{
define('CP_REDIRECT', 'arcade.php?code=settings');
print_stop_message('saved_settings_successfully');
}
}
// ##############################
// show games
// ##############################
if ($action == "gamelist")
{
global $IN, $std, $vbulletin, $vboptions;
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'games_setmulticat');
print_table_header($ibforums->lang['acp_games_header_az']);
$extrainfo = "";
if( (isset($IN['cat'])) && ($IN['cat'] == 0) )
{
$extrainfo = "".$ibforums->lang['acp_games_headerinfo2']." ";
}
print_description_row("".$ibforums->lang['acp_games_headerinfo'].$extrainfo."
");
$the_links = "";
// additional Sort-Options
$the_links .= "";
$prefix = ""; $suffix=" | ";
$link1 = "";
$link3 = " ";
$type = "dateasc";
$text = $ibforums->lang['acp_games_filter1'];
if ($IN['sort']==$type)
{
$the_links.= $link1.$type.$link2.$prefix.$text.$suffix.$link3;
}
else
{
$the_links.= $link1.$type.$link2.$text.$link3;
}
$the_links.=$separator;
$type = "datedesc";
$text = $ibforums->lang['acp_games_filter2'];
if ($IN['sort']==$type)
{
$the_links.= $link1.$type.$link2.$prefix.$text.$suffix.$link3;
}
else
{
$the_links.= $link1.$type.$link2.$text.$link3;
}
$the_links.=$separator;
$type = "timesplayed";
$text = $ibforums->lang['acp_games_filter3'];
if ($IN['sort']==$type)
{
$the_links.= $link1.$type.$link2.$prefix.$text.$suffix.$link3;
}
else
{
$the_links.= $link1.$type.$link2.$text.$link3;
}
$the_links.=$separator;
$type = "inactive";
$text = $ibforums->lang['acp_games_filter4'];
if ($IN['sort']==$type)
{
$the_links.= $link1.$type.$link2.$prefix.$text.$suffix.$link3;
}
else
{
$the_links.= $link1.$type.$link2.$text.$link3;
}
// detect vBplaza
if (($vbulletin->options['vbbux_enabled'] == 1) && ($vbulletin->options['vbbux_arcadeintegration'] == 1))
{
$the_links.=" ";
$suffix = " ".$prefix.$letter.$suffix." ";
}
if( isset($IN['filter']) || isset($IN['cat']) || isset($IN['sort']) )
{
$the_links .= " ".$ibforums->lang['acp_all']." ";
}
else
{
$the_links .= " ".$ibforums->lang['acp_all']." ";
$suffix = " ";
$suffix = " ".$suffix;
}
$suffix = " (".$CAT['howmany'].") ".$suffix;
$the_links .= " ".$prefix.$CAT['cat_name'].$suffix." ";
$charcount = $charcount + strlen($CAT['cat_name']);
if ($charcount > 60) // max. 60 characters per row
{
$the_links .= "".$the_links."
");
print_table_break('', "90%");
$header = array();
$header[] = $ibforums->lang['acp_gamesort_icon'];
$header[] = $ibforums->lang['acp_gamesort_game'];
$header[] = $ibforums->lang['acp_gamesort_info'];
$header[] = $ibforums->lang['acp_gamesort_cat'];
$header[] = $ibforums->lang['acp_gamesort_active'];
$header[] = $ibforums->lang['acp_gamesort_tourney'];
$header[] = $ibforums->lang['acp_gamesort_edit'];
$header[] = $ibforums->lang['acp_gamesort_delete'];
$header[] = $ibforums->lang['acp_result_empty'];
$colspan = sizeof($header);
print_table_header($ibforums->lang['acp_games_header'], $colspan);
print_cells_row($header, 1);
$status['color'] = array( 0 => "".$ibforums->lang['acp_games_active_n']." ".$ibforums->lang['acp_games_active_y']." " );
$query_extra = "";
if( isset($IN['filter']) )
{
if( $IN['filter'] != "0-9" )
{
$query_extra = "WHERE gtitle LIKE '".$IN['filter']."%'";
}
else
{
$query_extra = "WHERE gtitle REGEXP '^[0-9]'";
}
}
if( isset($IN['cat']) )
{
$query_extra = "WHERE gcat=".$IN['cat'];
}
if ((isset($IN['cat'])) || (isset($IN['filter'])))
{
if ($IN['sort']=="inactive")
{
// although multiple filters are not clickable, but who knows ;)
$query_extra .= " AND active<>1";
}
}
else
{
if ($IN['sort']=="inactive")
{
$query_extra = "WHERE active<>1";
}
}
$counter = 0;
//$DB->query("SELECT * FROM ibf_games_cats WHERE show_all<>1 ORDER BY pos, cat_name");
$DB->query("SELECT * FROM ibf_games_cats ORDER BY pos, cat_name");
$cat_list = array();
while( $CAT = $DB->fetch_row() )
{
$cat_list[$counter] = array( $CAT['c_id'] , $CAT['cat_name'] , $CAT['password'] );
$counter++;
}
$sortextra = "";
if (($IN['sort']=="dateasc") || ($IN['sort']=="datedesc") || ($IN['sort']=="timesplayed") || ($IN['sort']=="inactive") || ($IN['sort']=="costs") || ($IN['sort']=="jpraise") || ($IN['sort']=="jpstatic"))
{
if ($IN['sort']=="dateasc") { $sortextra = "added ASC,"; }
if ($IN['sort']=="datedesc") { $sortextra = "added DESC,"; }
if ($IN['sort']=="timesplayed") { $sortextra = "gcount DESC,"; }
if ($IN['sort']=="costs") { $sortextra = "cost DESC,"; }
if ($IN['sort']=="jpraise")
{
$sortextra = "jackpot DESC,";
if ($query_extra=="") { $query_extra ="WHERE jackpot_type='-1'";}
else { $query_extra.=" AND jackpot_type='-1'";}
}
if ($IN['sort']=="jpstatic")
{
$sortextra = "jackpot_type DESC,";
if ($query_extra=="") { $query_extra ="WHERE jackpot_type<>'-1'";}
else { $query_extra.=" AND jackpot_type<>'-1'";}
}
}
$counter=1;
$this_query = $DB->query("SELECT * FROM ibf_games_list ".$query_extra." ORDER BY ".$sortextra."gtitle");
while( $GAME = $DB->fetch_row($this_query) )
{
$counter++;
$filesize = "";
if( $GAME['filesize'] )
{
$filesize = $std->size_format($GAME['filesize']);
}
else
{
$filesize = "---";
}
$top['score'] = "---";
$top['name'] = "---";
$score_query = $DB->query("SELECT * FROM ibf_games_champs WHERE champ_gid=".$GAME['gid']);
if( $DB->get_num_rows($score_query) )
{
$top = $DB->fetch_row();
// Punkte formatieren ?
$top['score'] = $top['champ_score'];
$top['name'] = "".$top['champ_name']." ";
}
$playlink1 = "";
$playlink2 = " ";
$status['play_link'] = ($GAME['active']) ? $playlink1.$GAME['gtitle'].$playlink2 : $playlink1."".$GAME['gtitle']." ".$playlink2;
$catname = "---";
$catpassed = false;
foreach ($cat_list as $k => $v)
{
if ($v[0] == $GAME['gcat'])
{
$catname = $v[1];
if ($v[2] != "")
{
$catpassed = true;
}
}
}
$catpasspre = ""; $catpasssuf = "";
if ($catpassed)
{
$catpasspre = "";
$catpasssuf = " ";
}
$costinfo = "";
$jackpotinfo = "";
// detect vBplaza
if (($vbulletin->options['vbbux_enabled'] == 1) && ($vbulletin->options['vbbux_arcadeintegration'] == 1))
{
$costinfo = $ibforums->lang['costs_pgame'].$GAME['cost']."Jackpot ".$ibforums->lang['acp_game_jack_static']."
";
}
else
{
$jackpotinfo = "Jackpot ".$ibforums->lang['acp_game_jack_raise']."
";
}
}
$vbversion = substr($vboptions[templateversion],0,3);
if ($vbversion != "3.0")
{
($hook = vBulletinHook::fetch_hook('ibproarcade_acp_gamebit')) ? eval($hook) : false;
}
$hscorename = "";
if ($top['score']!="---")
{
$hscorename = " (".$top['name'].")";
}
$securegame = "";
// if ($GAME['game_type']==1)
if ( ( file_exists(ROOT_PATH.'arcade/gamedata/'.$GAME['gname'].'/v32game.txt' ) ) || ( file_exists(ROOT_PATH.'arcade/gamedata/'.$GAME['gname'].'/v3game.txt' ) ) )
{
$securegame = "".$std->size_format($GAME['filesize'])." ";
}
$cell = array();
$cell[] = "".$playlink1."
".$playlink2."
".$status['play_link']."
".$jackpotinfo;
$cell[] = "".$ibforums->lang['acp_games_info1'].": ".$top['score'].$hscorename."
";
$cell[] = "".$catpasspre.$catname.$catpasssuf." ".$securegame;
$cell[] = $status['color'][$GAME['active']];
$cell[] = $status['color'][$GAME['tourney_use']];
$cell[] = "";
$cell[] = "".$ibforums->lang['acp_games_delete']." ".$filesize;
$cell[] = "".$ibforums->lang['acp_games_multibox1']."
";
$header[] = "".$ibforums->lang['acp_games_multibox2']."
";
$header[] = "".$ibforums->lang['acp_games_multibox3']."
";
$colspan = sizeof($header);
print_table_header($ibforums->lang['acp_games_multibox'], $colspan);
print_cells_row($header, 1);
$dropdown = "\n";
foreach ($cat_list as $k => $v)
{
$dropdown = $dropdown . "".$v[1]." \n";
}
$dropdown = $dropdown . " \n";
$cell = array();
$cell[] = "
";
$cell[] = "".$ibforums->lang['acp_games_movetocat1']."
";
$cell[] = "".$dropdown.$ibforums->lang['acp_games_movetocat2']."
";
print_cells_row($cell);
$cell = array();
$cell[] = "
";
$cell[] = "".$ibforums->lang['acp_game_active']."
";
$cell[] = "\n
".$ibforums->lang['acp_on']." \n
".$ibforums->lang['acp_off']." \n
";
print_cells_row($cell);
$cell = array();
$cell[] = "
";
$cell[] = "".$ibforums->lang['acp_game_tourney']."
";
$cell[] = "\n
".$ibforums->lang['acp_on']." \n
".$ibforums->lang['acp_off']." \n
";
print_cells_row($cell);
// detect vBplaza
if (($vbulletin->options['vbbux_enabled'] == 1) && ($vbulletin->options['vbbux_arcadeintegration'] == 1))
{
$cell = array();
$cell[] = "
";
$cell[] = "".$ibforums->lang['acp_game_costs']."
";
$cell[] = "
";
print_cells_row($cell);
$cell = array();
$cell[] = "
";
$cell[] = "".$ibforums->lang['acp_game_jackpottype']."
";
$cell[] = "\n
".$ibforums->lang['acp_game_jack_raise']." \n
".$ibforums->lang['acp_game_jack_static']." \n
";
print_cells_row($cell);
$cell = array();
$cell[] = "
";
$cell[] = "".$ibforums->lang['acp_game_static']."
";
$cell[] = "
";
print_cells_row($cell);
$cell = array();
$cell[] = "
";
$cell[] = "".$ibforums->lang['acp_game_jackpot']."
";
$cell[] = "
";
print_cells_row($cell);
}
$vbversion = substr($vboptions[templateversion],0,3);
if ($vbversion != "3.0")
{
($hook = vBulletinHook::fetch_hook('ibproarcade_acp_gameoptions')) ? eval($hook) : false;
}
$cell = array();
$cell[] = "
";
$cell[] = "".$ibforums->lang['acp_game_resettimes']."
";
$cell[] = " ";
print_cells_row($cell);
$cell = array();
$cell[] = "
";
$cell[] = "".$ibforums->lang['acp_game_resettime']."
";
$cell[] = " ";
print_cells_row($cell);
$cell = array();
$cell[] = "
";
$cell[] = "".$ibforums->lang['acp_game_resetscores']."
";
$cell[] = " ";
print_cells_row($cell);
$cell = array();
$cell[] = "
";
$cell[] = "".$ibforums->lang['acp_game_resetbest']."
";
$cell[] = " ";
print_cells_row($cell);
$cell = array();
$cell[] = "
";
$cell[] = "".$ibforums->lang['acp_game_resetsize']."
";
$cell[] = " ";
print_cells_row($cell);
$cell = array();
$cell[] = "
";
$cell[] = "".$ibforums->lang['acp_game_delgame']."
";
$cell[] = " ";
print_cells_row($cell);
}
print_submit_row($ibforums->lang['acp_start'], 0, $colspan);
print_cp_footer();
exit;
}
// ##############################
// set options for multiple games
// ##############################
if ($action == "games_setmulticat")
{
global $IN;
// get the GameIDs that where selected
$cat_string = "(0)";
if( !empty($IN['move_to']) )
{
$cat_string = "(".implode("," , $IN['move_to']).")";
}
// move to category
if ($IN['opt_movecat']==1)
{
$db_string = $DB->compile_db_update_string( array ( 'gcat' => $IN['put_in_cat'] ) );
$DB->query("UPDATE ibf_games_list SET ".$db_string." WHERE gid IN ".$cat_string);
$new_amounts = array();
$this_query = $DB->query("SELECT c_id, show_all FROM ibf_games_cats ORDER BY c_id");
while( $CAT = $DB->fetch_row($this_query) )
{
$query_extra = "";
if( !$CAT['show_all'] )
{
$query_extra = "AND gcat=".$CAT['c_id'];
}
$DB->query("SELECT COUNT(gid) AS amount FROM ibf_games_list WHERE active=1 ".$query_extra);
$the = $DB->fetch_row();
$new_amounts[ $CAT['c_id'] ] = $the['amount'];
}
foreach( $new_amounts as $cat=>$amount )
{
$db_string = $DB->compile_db_update_string( array ( 'num_of_games' => $amount ) );
$DB->query("UPDATE ibf_games_cats SET ".$db_string." WHERE c_id='".$cat."'");
}
}
// set active on/off
if ($IN['opt_active']==1)
{
$db_string = $DB->compile_db_update_string( array ( 'active' => $IN['select_active'] ) );
$DB->query("UPDATE ibf_games_list SET ".$db_string." WHERE gid IN ".$cat_string);
updateleague();
}
// set tournament-game on/off
if ($IN['opt_tourney']==1)
{
$db_string = $DB->compile_db_update_string( array ( 'tourney_use' => $IN['select_tourney'] ) );
$DB->query("UPDATE ibf_games_list SET ".$db_string." WHERE gid IN ".$cat_string);
}
// filesize
if ($IN['opt_filesize']==1)
{
$games = array();
$getgames=$DB->query("SELECT gid, gname FROM ibf_games_list WHERE gid IN ".$cat_string);
while( $GAME = $DB->fetch_row($getgames) )
{
$games[] = array('gid' => $GAME['gid'], 'gname' => $GAME['gname']);
}
$dir = getcwd()."/arcade";
foreach ($games AS $this_game)
{
$filesize=0;
$file = $dir."/".$this_game['gname'].".swf";
if(file_exists($file))
{
@chmod( $file , 0777 );
$filesize = filesize($file);
}
$DB->query("UPDATE ibf_games_list SET filesize='".$filesize."' WHERE gid='".$this_game['gid']."'");
}
}
// set costs
if (($IN['opt_costs']==1) && (intval($IN['select_costs'])>=0))
{
$db_string = $DB->compile_db_update_string( array ( 'cost' => $IN['select_costs'] ) );
$DB->query("UPDATE ibf_games_list SET ".$db_string." WHERE gid IN ".$cat_string);
}
// set static jackpot (if possible)
$staticjp = false;
if ($IN['opt_jackpotstatic']==1)
{
if (intval($IN['select_jackpotstatic'])>=0)
{
$staticjackpot = $IN['select_jackpotstatic'];
$staticjp = true;
}
}
// set jackpot-type
if ($IN['opt_jackpottype']==1)
{
if ($IN['select_jackpottype']==0)
{
// static Jackpot
if ($staticjp)
{
$db_string = $DB->compile_db_update_string( array ( 'jackpot_type' => $IN['select_jackpotstatic'] ) );
}
else
{
$db_string = $DB->compile_db_update_string( array ( 'jackpot_type' => '0' ));
}
}
else
{
// raising Jackpot
$db_string = $DB->compile_db_update_string( array ( 'jackpot_type' => '-1' ) );
}
$DB->query("UPDATE ibf_games_list SET ".$db_string." WHERE gid IN ".$cat_string);
}
else
{
// no changes on Jackpot-Type, so finally store static value if that was changed
if ($staticjp)
{
// check if Jackpot-Type of that Game isn't set to RAISING (done via Query)
$db_string = $DB->compile_db_update_string( array ( 'jackpot_type' => $staticjackpot ) );
$DB->query("UPDATE ibf_games_list SET ".$db_string." WHERE jackpot_type<>'-1' AND gid IN ".$cat_string);
}
}
// set Jackpot (raising)
if ($IN['opt_jackpot']==1)
{
$db_string = $DB->compile_db_update_string( array ( 'jackpot' => $IN['select_jackpot'] ) );
$DB->query("UPDATE ibf_games_list SET ".$db_string." WHERE gid IN ".$cat_string);
}
// reset times played
if ($IN['opt_resettimes']==1)
{
$db_string = $DB->compile_db_update_string( array ( 'gcount' => '0' ) );
$DB->query("UPDATE ibf_games_list SET ".$db_string." WHERE gid IN ".$cat_string);
}
// reset time played
if ($IN['opt_resettime']==1)
{
$db_string = $DB->compile_db_update_string( array ( 'gtime' => '0' ) );
$DB->query("UPDATE ibf_games_list SET ".$db_string." WHERE gid IN ".$cat_string);
}
// reset scores
if ($IN['opt_resetscores']==1)
{
$DB->query("DELETE FROM ibf_games_scores WHERE gid IN ".$cat_string);
}
// reset best result ever
if ($IN['opt_resetbest']==1)
{
$db_string = $DB->compile_db_update_string( array ( 'bestscore' => '0', 'bestmid' => '', 'besttime' => '0' ) );
$DB->query("UPDATE ibf_games_list SET ".$db_string." WHERE gid IN ".$cat_string);
}
// delete game from database
if ($IN['opt_delgame']==1)
{
// look for existing tournaments of that Game
$looktourney = $DB->query("SELECT tid FROM ibf_tournaments WHERE gid IN ".$cat_string);
while ($tourney=$DB->fetch_row($looktourney))
{
$tid=$tourney[tid];
$DB->query("DELETE FROM ibf_tournament_players WHERE tid=".$tid);
$DB->query("DELETE FROM ibf_tournament_players_statut WHERE tid=".$tid);
$DB->query("DELETE FROM ibf_tournaments WHERE tid=".$tid);
}
$DB->query("DELETE FROM ibf_games_scores WHERE gid IN ".$cat_string);
$DB->query("DELETE FROM ibf_games_league WHERE gid IN ".$cat_string);
$DB->query("DELETE FROM ibf_games_list WHERE gid IN ".$cat_string);
do_champ_update(1);
update_cat_game_nums();
do_league_update(1);
}
/*
if( $arcade['log'] )
{
$ADMIN->save_log("...");
}
*/
define('CP_REDIRECT', 'arcade.php?code=gamelist&cat=0');
print_stop_message('saved_settings_successfully');
}
// ##############################
// categories
// ##############################
if ($action == "cat")
{
global $IN;
print_cp_header($ibforums->lang['acp_header']);
$header = array();
$header[] = $ibforums->lang['acp_catlist_sort'];
$header[] = $ibforums->lang['acp_catlist_name'] ;
$header[] = $ibforums->lang['acp_catlist_newname'];
$header[] = $ibforums->lang['acp_catlist_pass'];
$header[] = $ibforums->lang['acp_catlist_icon'];
$header[] = $ibforums->lang['acp_catlist_active'];
$header[] = $ibforums->lang['acp_catlist_all'];
$header[] = $ibforums->lang['acp_catlist_remove'];
$colspan = sizeof($header);
print_form_header('arcade', 'edit_categories');
print_table_header($ibforums->lang['acp_cat_header1'], $colspan);
print_cells_row($header, 1);
$DB->query("SELECT COUNT(c_id) AS many FROM ibf_games_cats");
$how = $DB->fetch_row();
$the_list = array();
for( $a = 0 ; $a < $how['many'] ; $a++)
{
$the_list[$a] = array( $a+1 , $a+1 );
}
$DB->query("SELECT * FROM ibf_games_cats ORDER BY pos");
while( $CAT = $DB->fetch_row() )
{
$remove_link = ( $CAT['c_id'] !=1 ) ? "" : "";
$cell = array();
$celloutput = "\n";
foreach ($the_list AS $k => $v)
{
$selected = "";
if ( ($CAT['pos'] != "") AND ($v[0] == $CAT['pos']) )
{
$selected = " selected";
}
$celloutput = $celloutput . "".$v[1]." \n";
}
$celloutput = $celloutput . "
";
$cell[] = $celloutput;
$cell[] = "".$CAT['cat_name']."
";
$cell[] = "
";
$cell[] = "
";
$cell[] = "".$CAT['c_id'].".gif
";
$selected1 = "";
$selected0 = "";
if ($CAT['active'] == 1)
{
$selected1 = " selected";
}
else
{
$selected0 = " selected";
}
$cell[] = " \n
".$ibforums->lang['acp_games_active_y']." \n
".$ibforums->lang['acp_games_active_n']." \n
";
$selected1 = "";
$selected0 = "";
if ($CAT['show_all'] == 1)
{
$selected1 = " selected";
}
else
{
$selected0 = " selected";
}
$cell[] = " \n
".$ibforums->lang['acp_games_active_y']." \n
".$ibforums->lang['acp_games_active_n']." \n
";
$cell[] = $remove_link;
print_cells_row($cell);
}
print_description_row($ibforums->lang['acp_cat_describeall'], 0, $colspan);
print_submit_row($ibforums->lang['acp_save'], 0, $colspan);
print_table_break('', "90%");
print_table_header($ibforums->lang['acp_cat_header2']);
print_form_header('arcade', 'add_category');
print_input_row($ibforums->lang['acp_cat_newcat'], 'cat_name', '', 0);
print_submit_row($ibforums->lang['acp_cat_newcatbutton'], 0);
print_cp_footer();
exit;
}
// ##############################
// do category function
// ##############################
if ($action == "do_cat_stuff")
{
global $ADMIN, $IN, $DB, $INFO;
$error = array();
switch( $IN['do'] )
{
case add:
$name = $IN['cat_name'];
if( empty($name) || strlen($name) > 32 || strlen($name) < 4 )
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'cat');
print_table_header($ibforums->lang['acp_tool_prune_errhead']);
print_description_row($ibforums->lang['acp_cat_error1']);
print_submit_row($ibforums->lang['acp_back'], 0);
print_cp_footer();
exit;
}
$DB->query("SELECT * FROM ibf_games_cats WHERE cat_name='".$name."'");
if( $DB->get_num_rows() )
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'cat');
print_table_header($ibforums->lang['acp_tool_prune_errhead']);
print_description_row($ibforums->lang['acp_cat_error2_1'].$name.$ibforums->lang['acp_cat_error2_2']);
print_submit_row($ibforums->lang['acp_back'], 0);
print_cp_footer();
exit;
}
$db_string = $DB->compile_db_insert_string( array ( 'cat_name' => $name,
'active' => 1,
'show_all' => 0,
'pos' => 1,
'password' => "",
'description' => "",
) );
$DB->query("INSERT INTO ibf_games_cats (" .$db_string['FIELD_NAMES']. ") VALUES (". $db_string['FIELD_VALUES'] .")");
break;
case edit:
$this_query = $DB->query("SELECT * FROM ibf_games_cats");
while( $this_cat = $DB->fetch_row($this_query) )
{
$query = "";
$name = "";
if( $this_cat['active'] != $IN[ "active_".$this_cat['c_id'] ] )
{
$active = ( $this_cat['active'] == 1 ) ? 0 : 1;
$query .= "active=".$active;
}
if( $this_cat['show_all'] != $IN[ "show_".$this_cat['c_id'] ] )
{
$show = ( $this_cat['show_all'] == 1 ) ? 0 : 1;
$query .= ($query != "") ? ", " : " ";
$query .= "show_all=".$show;
}
if( $IN[ "name_".$this_cat['c_id'] ] != "" )
{
$name = $IN[ "name_".$this_cat['c_id'] ];
if( strlen($name) > 32 || strlen($name) < 4 )
{
$error[$this_cat['c_id'] ] = $this_cat['cat_name'];
}
$query .= ($query != "") ? ", " : " ";
$query .= "cat_name='".addslashes($name)."' ";
}
$pass = trim($IN[ "pass_".$this_cat['c_id'] ]);
if( (strlen($pass) > 32 || strlen($pass) < 4) && (!empty($pass) || $pass != "") )
{
$error[ $this_cat['c_id'] ] = $this_cat['cat_name'];
}
$query .= ($query != "") ? ", " : " ";
$query .= "password='".$pass."' ";
if( $query != "" && $error[ $this_cat['c_id'] ] == "")
{
$DB->query("UPDATE ibf_games_cats SET ".$query." WHERE c_id=".$this_cat['c_id']);
}
}
$order = array();
$counter = 0;
foreach( $IN as $key=>$value )
{
$counter++;
if( preg_match("#_order#", $key) )
{
$key = intval($key);
$order[$key] = $value;
}
}
unset($key);
unset($value);
foreach( $order as $key=>$value )
{
$db_string = $DB->compile_db_update_string( array ( 'pos' => $value ) );
$DB->query("UPDATE ibf_games_cats SET ".$db_string." WHERE c_id='".$key."'");
}
// check if the show_all settings are ok
$cntquery = $DB->query("SELECT COUNT(*) AS howmany FROM ibf_games_cats");
$cntresult = $DB->fetch_row($cntquery);
$counter = $cntresult['howmany'];
$cntquery = $DB->query("SELECT COUNT(*) AS howmany FROM ibf_games_cats WHERE show_all=1");
$cntresult = $DB->fetch_row($cntquery);
$cnt_showall = $cntresult['howmany'];
if ($counter==$cnt_showall)
{
$query = "";
if ($counter > 1)
{
$query = "WHERE c_id=1";
}
$DB->query("UPDATE ibf_games_cats SET show_all = 0 ".$query);
}
break;
case del:
if( $IN['c'] == 1 )
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'cat');
print_table_header($ibforums->lang['acp_tool_prune_errhead']);
print_description_row($ibforums->lang['acp_cat_error3']);
print_submit_row($ibforums->lang['acp_back'], 0);
print_cp_footer();
exit;
}
$DB->query("DELETE FROM ibf_games_cats WHERE c_id=".$IN['c']);
$DB->query("UPDATE ibf_games_list SET gcat=1 WHERE gcat=".$IN['c']);
break;
default:
break;
}
update_cat_game_nums();
/*
if( $this->arcade['log'] )
{
$ADMIN->save_log("Edited Arcade Categories".$gtitle);
}
*/
if( count($error) == 0 )
{
define('CP_REDIRECT', 'arcade.php?code=cat');
print_stop_message('saved_settings_successfully');
}
else
{
$errmsg = "";
foreach( $error as $k=>$v )
{
$errmsg .= "".$v." ";
}
$errmsg = " ";
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'cat');
print_table_header($ibforums->lang['acp_cat_donehead']);
print_description_row($ibforums->lang['acp_cat_error4'].$errmsg);
print_submit_row($ibforums->lang['acp_back'], 0);
print_cp_footer();
exit;
}
}
// ##############################
// add game
// ##############################
if ($action == "add_game")
{
global $IN, $vboptions;
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'do_add');
print_table_header($ibforums->lang['acp_game_header']);
print_description_row($ibforums->lang['acp_game_info']);
print_input_row($ibforums->lang['acp_game_name'], 'gtitle', $ibforums->lang['acp_game_namedefault'], 0);
print_select_row($ibforums->lang['acp_game_active'], 'active', array('1' => $ibforums->lang['acp_on'], '0' => $ibforums->lang['acp_off']), 1);
print_select_row($ibforums->lang['acp_game_scoretype'], 'highscore_type', array('high' => $ibforums->lang['acp_high'], 'low' => $ibforums->lang['acp_low']), 'high');
// print_select_row($ibforums->lang['acp_game_gametype'], 'game_type', array('1' => $ibforums->lang['acp_on'], '0' => $ibforums->lang['acp_off']), '0');
//if( $arcade['use_cats'] )
//{
$DB->query("SELECT * FROM ibf_games_cats WHERE show_all<>1 ORDER BY pos, cat_name");
$cat_list = array();
while( $CAT = $DB->fetch_row() )
{
$cat_list[$CAT['c_id']] = $CAT['cat_name'];
}
print_select_row($ibforums->lang['acp_game_cat'], 'in_cat', $cat_list, '1');
//}
print_input_row($ibforums->lang['acp_game_gname'], 'gname', '', 0);
print_input_row($ibforums->lang['acp_game_decimal'], 'decpoints', '0', 0);
print_input_row($ibforums->lang['acp_game_bgcolor'], 'bgcolor', '000000', 0);
print_input_row($ibforums->lang['acp_game_width'], 'gwidth', '400', 0);
print_input_row($ibforums->lang['acp_game_height'], 'gheight', '400', 0);
print_table_break('', "90%");
// detect vBplaza
if (($vbulletin->options['vbbux_enabled'] == 1) && ($vbulletin->options['vbbux_arcadeintegration'] == 1))
{
print_table_header($ibforums->lang['acp_game_vbplaza']);
print_input_row($ibforums->lang['acp_game_costs'], 'cost', '25', 0);
print_select_row($ibforums->lang['acp_game_jackpottype'], 'jackpottype', array('1' => $ibforums->lang['acp_game_jack_raise'], '0' => $ibforums->lang['acp_game_jack_static']), 1);
print_input_row($ibforums->lang['acp_game_static'], 'static', '100', 0);
print_input_row($ibforums->lang['acp_game_jackpot'], 'jackpot', '0', 0);
print_table_break('', "90%");
}
$vbversion = substr($vboptions[templateversion],0,3);
if ($vbversion != "3.0")
{
($hook = vBulletinHook::fetch_hook('ibproarcade_acp_addgame')) ? eval($hook) : false;
}
print_table_header($ibforums->lang['acp_game_optheader']);
print_textarea_row($ibforums->lang['acp_game_descr'], 'gwords', '', 6, 45);
print_textarea_row($ibforums->lang['acp_game_object'], 'object', '', 6, 45);
print_textarea_row($ibforums->lang['acp_game_keys'], 'keys', '', 6, 45);
print_input_row($ibforums->lang['acp_game_pnfglic'], 'license', '', 0);
print_submit_row($ibforums->lang['acp_game_addbutton'], 0);
print_table_break('', "90%");
$header = array();
$header[] = "".$ibforums->lang['acp_game_targame']."
";
$header[] = $ibforums->lang['acp_game_tarfile'];
$header[] = $ibforums->lang['acp_gamesort_game'];
$header[] = "".$ibforums->lang['acp_game_tararchive']."
";
$colspan = sizeof($header);
print_table_header($ibforums->lang['acp_game_tarheader'], $colspan);
print_description_row($ibforums->lang['acp_game_tarinfo'], 0, $colspan);
print_cells_row($header, 1);
$files = array();
$dir = ROOT_PATH."arcade/tar";
if ( is_dir($dir) )
{
$the_dir = opendir($dir);
while( ($filename = readdir($the_dir)) !== false )
{
if( ($filename != ".") && ($filename != "..") )
{
// $files[] = preg_match("/^(game).+?\.(tar)$/", $filename);
if( preg_match("/^(game).+?\.(tar)$/", $filename) )
{
$files[] = $filename;
}
}
}
closedir($the_dir);
}
asort($files);
$install_link = "";
if( count($files) > 0 )
{
foreach( $files as $this_file )
{
$name = preg_replace( "/^(game)_(.+?)\.(\S+)$/", "\\2", $this_file );
$DB->query("SELECT gid, gname FROM ibf_games_list WHERE gname='".$name."'");
if( $DB->get_num_rows() )
{
$gid = $DB->fetch_row();
$install_link = "".$ibforums->lang['acp_game_tar_uninstall']."
".$ibforums->lang['acp_game_tar_install']."
".$name."
";
$cell[] = "".$this_file."
";
$cell[] = "".$install_link."
";
$cell[] = "";
print_cells_row($cell);
}
print_description_row("", 0, $colspan);
}
else
{
print_description_row("- ".$ibforums->lang['acp_game_tar_empty']." -
", 0, $colspan);
}
print_table_break('', "90%");
$header = array();
$header[] = "".$ibforums->lang['acp_game_targame']."
";
$header[] = $ibforums->lang['acp_game_tarfile'] ;
$header[] = $ibforums->lang['acp_gamesort_game'];
$header[] = "".$ibforums->lang['acp_game_ziparchive']."
";
$colspan = sizeof($header);
print_table_header($ibforums->lang['acp_game_zipheader'], $colspan);
print_description_row($ibforums->lang['acp_game_zipinfo'], 0, $colspan);
print_cells_row($header, 1);
$files = array();
$dir = ROOT_PATH."arcade/zip";
if ( is_dir($dir) )
{
$zip_dir = opendir($dir);
while( ($filename = readdir($zip_dir)) !== false )
{
if( ($filename != ".") && ($filename != "..") )
{
$ext = substr(strrchr($filename, "."), 1);
if($ext == "zip")
{
$files[] = str_replace(".zip","",$filename);
}
}
}
closedir($zip_dir);
}
asort($files);
$install_link = "";
if( count($files) > 0 )
{
foreach( $files as $this_file )
{
$name = $this_file;
$DB->query("SELECT gid, gname FROM ibf_games_list WHERE gname='".$name."'");
if( $DB->get_num_rows() )
{
$gid = $DB->fetch_row();
$install_link = "".$ibforums->lang['acp_game_tar_uninstall']."
".$ibforums->lang['acp_game_tar_install']."
".$name."
";
$cell[] = "".$this_file.".zip
";
$cell[] = "".$install_link."
";
$cell[] = "";
print_cells_row($cell);
}
print_description_row("", 0, $colspan);
}
else
{
print_description_row("- ".$ibforums->lang['acp_game_tar_empty']." -
", 0, $colspan);
}
print_table_break('', "90%");
print_table_header($ibforums->lang['acp_game_sqlheader']);
print_form_header('arcade', 'do_add_sql');
print_description_row($ibforums->lang['acp_game_sqlinfo']);
print_input_row($ibforums->lang['acp_game_sql'], 'the_query', '', 0);
print_submit_row($ibforums->lang['acp_game_sqlbutton'], 0);
print_cp_footer();
exit;
}
// ##############################
// store gamedata to DB after add game
// ##############################
if ($action == "do_addgame")
{
global $IN;
$checks = array( 'gtitle' => $IN['gtitle'],
'gname' => $IN['gname'],
'bgcolor' => $IN['bgcolor'], );
foreach($checks as $check_key=>$check_value)
{
if( empty($check_value) )
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'add_game');
construct_hidden_code('gid', $gid);
print_table_header($ibforums->lang['acp_tool_prune_errhead']);
print_description_row($ibforums->lang['acp_game_error1']);
print_submit_row($ibforums->lang['acp_back'], 0);
print_cp_footer();
exit;
}
$$check_key = $check_value;
}
unset($checks);
$checks = array( 'gwidth' => $IN['gwidth'],
'gheight' => $IN['gheight'] );
foreach($checks as $check_key=>$check_value)
{
$check_value = intval($check_value);
if($check_value == 0)
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'add_game');
construct_hidden_code('gid', $gid);
print_table_header($ibforums->lang['acp_tool_prune_errhead']);
print_description_row($ibforums->lang['acp_game_error2']);
print_submit_row($ibforums->lang['acp_back'], 0);
print_cp_footer();
exit;
}
$$check_key = $check_value;
}
$gname = $IN['gname'];
$active = $IN['active'];
$gwords = $IN['gwords'];
$keys = $IN['keys'];
$object = $IN['object'];
$license = $IN['license'];
$cat = ($arcade['use_cats'] != 0) ? $IN['in_cat'] : 1;
$hscore = $IN['highscore_type'];
$jackpottype = $IN['jackpottype'];
$jackpot = $IN['jackpot'];
$static = $IN['static'];
$costs = $IN['cost'];
if (strtolower(substr($gname,-4)) == ".swf")
{
$gname = substr($gname,0,(strlen($gname)-4));
}
$game_type = 0;
if ( ( file_exists(ROOT_PATH.'arcade/gamedata/'.$gname.'/v32game.txt' ) ) || ( file_exists(ROOT_PATH.'arcade/gamedata/'.$gname.'/v3game.txt' ) ) )
{
$game_type = 1;
}
if( (!is_numeric($costs)) || ($costs < 0) )
{
$costs = 0;
}
if (($jackpottype<0) || ($jackpottype>1))
{
$jackpottype = 1;
}
if( (!is_numeric($jackpot)) || ($jackpot < 0) )
{
$jackpot = 0;
}
if( (!is_numeric($static)) || ($static < 0) )
{
$static = 0;
}
if ($jackpottype == 1)
{
// if raising Jackpot set the Jackpot itself to Zero
$jackpottype = "-1";
}
else
{
// static Jackpot
$jackpottype = $static;
}
$dir = getcwd()."/arcade";
$filesize=0;
$file = $dir."/".$gname.".swf";
if(file_exists($file))
{
@chmod( $file , 0777 );
$filesize = filesize($file);
}
if (intval($cat) < 1) { $cat = 1; }
if (game_exists($gname))
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'add_game');
print_table_header($ibforums->lang['acp_tool_prune_errhead']);
print_description_row("".$gname." - ".$ibforums->lang['acp_game_tar_error0']."".$file_dir." ".$ibforums->lang['acp_game_tar_error0']."".$file_dir." ".$ibforums->lang['acp_game_tar_error1']."".$tar_dir." ".$ibforums->lang['acp_game_tar_error2']."".$tmp_dir." ".$ibforums->lang['acp_game_tar_error2']."".$arcade_dir." ".$ibforums->lang['acp_game_tar_error2']."".$images_dir." ".$ibforums->lang['acp_game_tar_error2']."".$multi_dir." ".$ibforums->lang['acp_game_tar_error2']."".$config['gname']." - ".$ibforums->lang['acp_game_tar_error0']."".$file_dir." ".$ibforums->lang['acp_game_tar_error0']."".$file_dir." ".$ibforums->lang['acp_game_tar_error1']."".$zip_dir." ".$ibforums->lang['acp_game_tar_error2']."".$arcade_dir." ".$ibforums->lang['acp_game_tar_error2']."".$images_dir." ".$ibforums->lang['acp_game_tar_error2']."".$multi_dir." ".$ibforums->lang['acp_game_tar_error2']."".$tar_dir." ".$ibforums->lang['acp_game_zip_error8']."extract(PCLZIP_OPT_BY_NAME, $filename, PCLZIP_OPT_EXTRACT_AS_STRING);
$buf = $output[0]['content'];
// PHP Parsing messy :(
if (!strpos($buf, "game_width"))
{
//It's the older type with the insert statement written directly, so we need to find it and take it apart
$fileStart = strpos($buf, "highscore) VALUES (");
$buf = substr($buf,$fileStart+19);
$fileEnd = strpos($buf, ", NULL)");
$buf = substr($buf,0,$fileEnd);
//This is very buggy, if there is a comma in the description the array will be out of wack So far when this occurs it is only the description, width and height that get messed up.
$arv3legacy = explode(",",str_replace("'","",$buf));
$title = trim($arv3legacy[2]);
$shortname = trim($arv3legacy[0]);
$game_width = trim($arv3legacy[5]);
$game_height = trim($arv3legacy[6]);
$description = trim($arv3legacy[3]);
$config = array(
gname => $shortname,
gtitle => $title,
bgcolor => '000000',
gwidth => $game_width,
gheight => $game_height,
active => '1',
gcat => '1',
gwords => $description,
object => $description,
gkeys => '',);
}
else
{
//It's the newer type with predefined vars
$fileStart = strpos($buf, "global.php");
$buf = substr($buf,$fileStart+13);
$fileEnd = strpos($buf, "print_cp_header");
$buf = substr($buf,0,$fileEnd);
$tmpfilename = $zip_dir.'/'.rand().'.php';
$tmpfile = fopen($tmpfilename, "x");
fwrite($tmpfile, '');
fclose($tmpfile);
require_once($tmpfilename);
unlink($tmpfilename);
$config = array(
gname => $shortname,
gtitle => $title,
bgcolor => '000000',
gwidth => $game_width,
gheight => $game_height,
active => '1',
gcat => '1',
gwords => $description,
object => $description,
gkeys => '',);
}
//End PHP Parsing
}
else if ($ext == "swf")
{
$savefile = $arcade_dir.'/'.$filename;
$filesize=0;
if( file_exists($savefile) )
{
@chmod($savefile , 0777);
$filesize = filesize($savefile);
@unlink($savefile);
}
$output = $zip->extract(PCLZIP_OPT_BY_NAME, $filename, PCLZIP_OPT_EXTRACT_AS_STRING);
$savefile = fopen($savefile, "x");
fwrite($savefile, $output[0]['content']);
fclose($savefile);
}
else if ($ext == "gif")
{
$savefile = $images_dir.'/'.$filename;
if( file_exists($savefile) )
{
@chmod($savefile , 0777);
@unlink($savefile);
}
$output = $zip->extract(PCLZIP_OPT_BY_NAME, $filename, PCLZIP_OPT_EXTRACT_AS_STRING);
$savefile = fopen($savefile, "x");
fwrite($savefile, $output[0]['content']);
fclose($savefile);
}
}
}
}
if (!$shortname)
{
//incompatible game please add manually
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'add_game');
print_table_header($ibforums->lang['acp_tool_prune_errhead']);
print_description_row("".$tar_dir." ".$ibforums->lang['acp_game_zip_error8']."".$config['gname']." - ".$ibforums->lang['acp_game_tar_error0']."";
foreach( $del as $key=>$value )
{
if( !$value )
{
$error = 1;
$files .= "";
$files .= $GAME['gname'];
$files .= ( preg_match("#gif#" , $key) ) ? substr( $key , 3 , 1).".".substr( $key , 0 , 3) : ".".substr( $key , 0 , 3);
$files .= " ";
}
}
$files .= " ";
}
// look for existing tournaments of that Game
$looktourney = $DB->query("SELECT tid FROM ibf_tournaments WHERE gid=".$gid);
while ($tourney=$DB->fetch_row($looktourney))
{
$tid=$tourney[tid];
$DB->query("DELETE FROM ibf_tournament_players WHERE tid=".$tid);
$DB->query("DELETE FROM ibf_tournament_players_statut WHERE tid=".$tid);
$DB->query("DELETE FROM ibf_tournaments WHERE tid=".$tid);
}
$DB->query("DELETE FROM ibf_games_scores WHERE gid=".$gid);
$DB->query("DELETE FROM ibf_games_league WHERE gid=".$gid);
$DB->query("DELETE FROM ibf_games_list WHERE gid=".$gid);
do_champ_update(1);
update_cat_game_nums();
do_league_update(1);
/*
if( $arcade['log'] )
{
$ADMIN->save_log("Spiel ".$GAME['gtitle']." gelöscht.");
}
*/
if( !$error )
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'add_game');
print_table_header($ibforums->lang['acp_game_tar_confhead']);
print_description_row($ibforums->lang['acp_game_tar_error7']);
print_submit_row($ibforums->lang['acp_continue'], 0);
print_cp_footer();
exit;
}
else
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'add_game');
print_table_header($ibforums->lang['acp_tool_prune_errhead']);
print_description_row($GAME['gname'].$ibforums->lang['acp_game_tar_error4'].$files);
print_submit_row($ibforums->lang['acp_continue'], 0);
print_cp_footer();
exit;
}
}
}
// ##############################
// remove TAR archive
// ##############################
if ($action == "remove_tar")
{
global $IN;
$dir = ROOT_PATH."arcade/tar/";
$file = $dir."game_".$IN['file'].".tar";
if( !file_exists($file) )
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'add_game');
print_table_header($ibforums->lang['acp_tool_prune_errhead']);
print_description_row("".$file." ".$ibforums->lang['acp_game_tar_error1']."".$file." ".$ibforums->lang['acp_game_tar_error5']."".$file." ".$ibforums->lang['acp_game_zip_error1']."".$file." ".$ibforums->lang['acp_game_zip_error5']."".$tar_dir." ".$ibforums->lang['acp_game_tar_error2']."".$arcade_dir." ".$ibforums->lang['acp_game_tar_error2']."".$images_dir." ".$ibforums->lang['acp_game_tar_error2']."".$multi_dir." ".$ibforums->lang['acp_game_tar_error2']."".$tmp_dir." ".$ibforums->lang['acp_game_tar_error2']."".$ibforums->lang['acp_game_tar_massinfo1']."".$installcounter."/".$tarcounter." ".$ibforums->lang['acp_game_tar_massinfo2']."
");
print_submit_row($ibforums->lang['acp_game_tar_massbutton'], 0);
print_cp_footer();
exit;
}
// ##############################
// Install ALL ZIP-Games at once
// ##############################
if ($action == "install_all_zip")
{
global $IN;
$dir = ROOT_PATH."arcade/zip";
$zip_dir = getcwd().'/arcade/zip';
$arcade_dir = getcwd().'/arcade';
$images_dir = getcwd().'/arcade/images';
$multi_dir = getcwd().'/arcade/gamedata';
$tar = '';
if( !is_writable($zip_dir) )
{
if( !@chmod($zip_dir , 0777) )
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'add_game');
print_table_header($ibforums->lang['acp_tool_prune_errhead']);
print_description_row("".$zip_dir." ".$ibforums->lang['acp_game_tar_error2']."".$arcade_dir." ".$ibforums->lang['acp_game_tar_error2']."".$images_dir." ".$ibforums->lang['acp_game_tar_error2']."".$file_dir." ".$ibforums->lang['acp_game_zip_error8']."extract(PCLZIP_OPT_BY_NAME, $filename, PCLZIP_OPT_EXTRACT_AS_STRING);
$buf = $output[0]['content'];
//PHP Parsing messy :(
if (!strpos($buf, "game_width"))
{
//It's the older type with the insert statement written directly so we need to find it and take it apart
$fileStart = strpos($buf, "highscore) VALUES (");
$buf = substr($buf,$fileStart+19);
$fileEnd = strpos($buf, ", NULL)");
$buf = substr($buf,0,$fileEnd);
//This is very buggy, if there is a comma in the descritpion the array will be out of wack So far when this occurs it is only the description, width and height that get messed up.
$arv3legacy = explode(",",str_replace("'","",$buf));
$title = trim($arv3legacy[2]);
$shortname = trim($arv3legacy[0]);
$game_width = trim($arv3legacy[5]);
$game_height = trim($arv3legacy[6]);
$description = trim($arv3legacy[3]);
$config = array(
gname => $shortname,
gtitle => $title,
bgcolor => '000000',
gwidth => $game_width,
gheight => $game_height,
active => '1',
gcat => '1',
gwords => $description,
object => $description,
gkeys => '',);
}
else
{
//It's the newer type with predefined vars
$fileStart = strpos($buf, "global.php");
$buf = substr($buf,$fileStart+13);
$fileEnd = strpos($buf, "print_cp_header");
$buf = substr($buf,0,$fileEnd);
$tmpfilename = $zip_dir.'/'.rand().'.php';
$tmpfile = fopen($tmpfilename, "x");
fwrite($tmpfile, '');
fclose($tmpfile);
require_once($tmpfilename);
unlink($tmpfilename);
$config = array(
gname => $shortname,
gtitle => $title,
bgcolor => '000000',
gwidth => $game_width,
gheight => $game_height,
active => '1',
gcat => '1',
gwords => $description,
object => $description,
gkeys => '',);
}
//End PHP Parsing
}
else if ($ext == "swf")
{
$filename2 = substr(strrchr($list[$i][$key], "/"), 1);
if (!$filename2) {$filename2 = $list[$i][$key];}
$savefile = $arcade_dir.'/'.$filename2;
$filesize=0;
if( file_exists($savefile) )
{
@chmod($savefile , 0777);
$filesize = filesize($savefile);
@unlink($savefile);
}
$output = $zip->extract(PCLZIP_OPT_BY_NAME, $filename, PCLZIP_OPT_EXTRACT_AS_STRING);
$savefile = fopen($savefile, "x");
fwrite($savefile, $output[0]['content']);
fclose($savefile);
}
else if ($ext == "gif")
{
$filename2 = substr(strrchr($list[$i][$key], "/"), 1);
if (!$filename2){$filename2 = $list[$i][$key];}
$savefile = $images_dir.'/'.$filename2;
if( file_exists($savefile) )
{
@chmod($savefile , 0777);
@unlink($savefile);
}
$output = $zip->extract(PCLZIP_OPT_BY_NAME, $filename, PCLZIP_OPT_EXTRACT_AS_STRING);
$savefile = fopen($savefile, "x");
fwrite($savefile, $output[0]['content']);
fclose($savefile);
}
}
}
}
if (!$shortname)
{
//incompatible game please add manually
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'add_game');
print_table_header($ibforums->lang['acp_tool_prune_errhead']);
print_description_row("".$tar_dir." ".$ibforums->lang['acp_game_zip_error8']."".$ibforums->lang['acp_game_tar_massinfo1']."".$zipcounter." ".$ibforums->lang['acp_game_tar_massinfo2']."
");
print_submit_row($ibforums->lang['acp_game_tar_massbutton'], 0);
print_cp_footer();
exit;
}
// ##############################
// Tournaments
// ##############################
if ($action == "tourney")
{
global $IN;
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'tourneysettings');
print_table_header($ibforums->lang['acp_tourney_settings']);
print_input_row($ibforums->lang['acp_main_tourneylimit1'], 'tourney_limit1', $arcade['tourney_limit1'], 0);
print_input_row($ibforums->lang['acp_main_tourneylimit2'], 'tourney_limit2', $arcade['tourney_limit2'], 0);
print_table_header($ibforums->lang['acp_main_tourney_head']);
print_input_row($ibforums->lang['acp_main_tourney_col1'], 'ladder_color', $arcade['ladder_color'], 0);
print_input_row($ibforums->lang['acp_main_tourney_col2'], 'ladder_empty_color', $arcade['ladder_empty_color'], 0);
print_input_row($ibforums->lang['acp_main_tourney_col3'], 'ladder_qual_color', $arcade['ladder_qual_color'], 0);
print_input_row($ibforums->lang['acp_main_tourney_col4'], 'ladder_disqual_color', $arcade['ladder_disqual_color'], 0);
print_input_row($ibforums->lang['acp_main_tourney_col5'], 'ladder_elim_color', $arcade['ladder_elim_color'], 0);
print_submit_row($ibforums->lang['acp_save_settings'], 0);
print_table_break('', "90%");
$header = array();
$header[] = "".$ibforums->lang['acp_gamesort_icon']."
";
$header[] = $ibforums->lang['acp_gamesort_game'];
$header[] = $ibforums->lang['acp_gamesort_player'];
$header[] = $ibforums->lang['acp_tourneylist_start'];
$header[] = $ibforums->lang['acp_tourneylist_player'];
$header[] = $ibforums->lang['acp_empty'];
$colspan = sizeof($header);
print_table_header($ibforums->lang['acp_tourneylist_head'], $colspan);
print_form_header('arcade', 'tourney_stuff');
print_cells_row($header, 1);
print_description_row("- ".$ibforums->lang['acp_tourneylist_active']." -
", 0, $colspan);
$this_query = $DB->query("SELECT * FROM ibf_tournaments WHERE champion=''");
if( $DB->get_num_rows($this_query) )
{
while( $TOURNEY = $DB->fetch_row($this_query) )
{
$DB->query("SELECT gname, gtitle FROM ibf_games_list WHERE gid=".$TOURNEY['gid']);
$GAME = $DB->fetch_row();
$cell = array();
$cell[] = "";
$cell[] = "".$GAME['gtitle']."
";
$cell[] = "".$TOURNEY['numplayers']."
";
$cell[] = "".timeoutput($TOURNEY['datestarted'])."
";
$cell[] = "";
$cell[] = "";
print_cells_row($cell);
}
}
else
{
print_description_row("".$ibforums->lang['acp_tourneylist_none']."
", 0, $colspan);
}
print_description_row("- ".$ibforums->lang['acp_tourneylist_ready']." -
", 0, $colspan);
$this_query = $DB->query("SELECT * FROM ibf_tournaments WHERE champion<>''");
if( $DB->get_num_rows($this_query) )
{
while( $TOURNEY = $DB->fetch_row($this_query) )
{
$DB->query("SELECT gname, gtitle FROM ibf_games_list WHERE gid=".$TOURNEY['gid']);
$GAME = $DB->fetch_row();
$cell = array();
$cell[] = "";
$cell[] = "".$GAME['gtitle']." ~ ".$TOURNEY['champion']."
";
$cell[] = "".$TOURNEY['numplayers']."
";
$cell[] = "".timeoutput($TOURNEY['datestarted'])."
";
$cell[] = "";
$cell[] = "";
print_cells_row($cell);
}
}
else
{
print_description_row("".$ibforums->lang['acp_tourneylist_none']."
", 0, $colspan);
}
print_table_break('', "90%");
print_table_header($ibforums->lang['acp_tourneylist_newhead']);
$output = "\n";
$game_list = array();
$cat=""; $catquery="";
if ($arcade['use_cats'] == 1) { $catquery="cat.pos, cat.c_id, "; }
$DB->query(" SELECT g.*, cat.password, cat.cat_name
FROM ibf_games_list AS g, ibf_games_cats AS cat
WHERE g.active = 1 AND g.gcat=cat.c_id AND trim(password)=''
ORDER BY ".$catquery."gtitle");
while( $GAME = $DB->fetch_row() )
{
if( $GAME['cat_name'] != $cat && $arcade['use_cats'] == 1 )
{
if( preg_match("/optgroup/i", $form) )
{
$output .= "";
}
$output .= "";
$cat = $GAME['cat_name'];
}
$output .= "".$GAME['gtitle']." ";
}
$output = $output . " ";
$output = $output . "\n
2 ".$ibforums->lang['acp_tourneylist_player']." \n
4 ".$ibforums->lang['acp_tourneylist_player']." \n
8 ".$ibforums->lang['acp_tourneylist_player']." \n
";
$output = $output . "\n
1 ".$ibforums->lang['try']." \n
2 ".$ibforums->lang['tries']." \n
3 ".$ibforums->lang['tries']." \n
4 ".$ibforums->lang['tries']." \n
5 ".$ibforums->lang['tries']." \n
";
print_description_row($ibforums->lang['acp_tourney_create']." ".$output, 0);
construct_hidden_code('do', 'newt');
print_submit_row($ibforums->lang['acp_tourneylist_button'], 0);
print_form_header('arcade', 'tourney_stuff');
print_table_header($ibforums->lang['acp_tourney_prune_head']);
$output1 = "\n
".$ibforums->lang['acp_tourney_prune_fin']." \n
".$ibforums->lang['acp_tourney_prune_run']." \n
".$ibforums->lang['acp_tourney_prune_open']." \n
";
$output2 = "".$USER['name']." ".$ibforums->lang['acp_tourneylist_player']."
";
$header[] = $ibforums->lang['acp_empty'];
$colspan = sizeof($header);
print_table_header($ibforums->lang['acp_tourney_edit'], $colspan);
$javascript = " ";
print_description_row($ibforums->lang['acp_tourney_editinfo'].$javascript, 0, $colspan);
construct_hidden_code('tid', $IN['tid']);
construct_hidden_code('userid', '');
print_cells_row($header, 1);
// make it lookup the first round of the tournament
$lookup_query = $DB->query("SELECT numplayers FROM ibf_tournaments WHERE tid=".$IN['tid']);
$lookup = $DB->fetch_row($lookup_query);
switch ($lookup['numplayers'])
{
case '2': $selectrung=" AND t.rung=1"; break;
case '4': $selectrung=" AND t.rung=2"; break;
case '8': $selectrung=" AND t.rung=3"; break;
default : $selectrung="";
}
$this_query = $DB->query("SELECT t.*, m.name AS username, m.id as userid
FROM ibf_tournament_players AS t
LEFT JOIN ibf_members AS m
ON (t.mid = m.id)
WHERE tid=".$IN['tid'].$selectrung);
while($TOURNEY = $DB->fetch_row($this_query))
{
$cell = array();
$cell[] = "";
$cell[] = "";
print_cells_row($cell);
}
print_table_break('', "90%");
print_table_header($ibforums->lang['acp_tourney_edituser']);
print_description_row($ibforums->lang['acp_tourney_editusertxt']."".$IN['username']." ".$ibforums->lang['acp_tourney_replacetxt2']."".$USER['name']." ".$ibforums->lang['acp_tourney_replacetxt3']);
construct_hidden_code('tid', $IN['tid']);
construct_hidden_code('oldmid', $IN['userid']);
construct_hidden_code('newmid', $IN['replaceid']);
print_submit_row($ibforums->lang['acp_confirm'], 0);
print_cp_footer();
}
else
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'viewtourney');
print_table_header($ibforums->lang['acp_tool_prune_errhead']);
print_description_row($ibforums->lang['acp_tourney_error3']);
construct_hidden_code('tid', $IN['tid']);
print_submit_row($ibforums->lang['acp_back'], 0);
print_cp_footer();
exit;
break;
}
break;
// ##### do replace user in tourney #####
case do_replace:
$DB->query("UPDATE ibf_tournament_players SET mid=".$IN['newmid'].", notified=0 WHERE tid=".$IN['tid']." AND mid=".$IN['oldmid']);
$DB->query("UPDATE ibf_tournament_players_statut SET mid=".$IN['newmid']." WHERE tid=".$IN['tid']." AND mid=".$IN['oldmid']);
/*
if( $arcade['log'] )
{
$ADMIN->save_log("Turnier-Teilnehmer ersetzt.");
}
*/
define('CP_REDIRECT', 'arcade.php?code=tourney');
print_stop_message('saved_settings_successfully');
break;
// ##### remove tournament #####
case remove:
$DB->query("DELETE FROM ibf_tournaments WHERE tid=".$IN['tid']);
$DB->query("DELETE FROM ibf_tournament_players_statut WHERE tid=".$IN['tid']);
$DB->query("DELETE FROM ibf_tournament_players WHERE tid=".$IN['tid']);
/*
if( $arcade['log'] )
{
$ADMIN->save_log("Turnier gelöscht.");
}
*/
define('CP_REDIRECT', 'arcade.php?code=tourney');
print_stop_message('saved_settings_successfully');
break;
default:
break;
}
}
// ##############################
// usergroup permissions
// ##############################
if ($action == "groups")
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'updategroups');
// generate Category-List for Permission-Selection
$cats=array();
$cats[0] = "-- ".$ibforums->lang['acp_all']." --";
$counter = 1;
$DB->query("SELECT * FROM ibf_games_cats ORDER BY pos, cat_name");
while( $CAT = $DB->fetch_row() )
{
$protected = "";
if ($CAT['password']!='') { $protected=" (*)"; }
$cats[$CAT['c_id']] = $CAT['cat_name'].$protected;
$counter++;
}
if ($counter > 10) { $counter = 10; }
$DB->query("SELECT g_id, g_title, arcade_access, p_require, max_play, ppd_require, ibpa_cats, tourney FROM ibf_groups");
while( $GROUP = $DB->fetch_row() )
{
print_table_header($GROUP['g_title']);
if ($GROUP['g_id'] == 1) // UserGroupID 1 = unregistered / Guest
{
print_select_row($ibforums->lang['acp_group_guest'], $GROUP['g_id']."_access", array('0' => $ibforums->lang['acp_group_noperm'], '1' => $ibforums->lang['acp_group_viewperm'], '3' => $ibforums->lang['acp_group_guestplay'], '4' => $ibforums->lang['acp_group_guestplaysave']), $GROUP['arcade_access']);
print_input_row($ibforums->lang['acp_group_guestid'], $GROUP['g_id']."_p_require", $GROUP['p_require'], 0);
$selected = explode(',', $GROUP['ibpa_cats']);
print_select_row($ibforums->lang['acp_group_catperm'], $GROUP['g_id'].'_catperm[]', $cats, $selected, 0, $counter, true);
}
else
{
print_select_row($ibforums->lang['acp_group'], $GROUP['g_id']."_access", array('0' => $ibforums->lang['acp_group_noperm'], '1' => $ibforums->lang['acp_group_viewperm'], '2' => $ibforums->lang['acp_group_playperm']), $GROUP['arcade_access']);
print_input_row($ibforums->lang['acp_group_posts'], $GROUP['g_id']."_p_require", $GROUP['p_require'], 0);
print_input_row($ibforums->lang['acp_group_ppd'], $GROUP['g_id']."_ppd_require", $GROUP['ppd_require'], 0);
print_input_row($ibforums->lang['acp_group_gpd'], $GROUP['g_id']."_max_play", $GROUP['max_play'], 0);
print_yes_no_row($ibforums->lang['acp_group_tourney'], $GROUP['g_id'].'_tourney', $GROUP['tourney']);
// Cat-Permissions per UG
$selected = explode(',', $GROUP['ibpa_cats']);
print_select_row($ibforums->lang['acp_group_catperm'], $GROUP['g_id'].'_catperm[]', $cats, $selected, 0, $counter, true);
}
print_table_break('', "90%");
}
print_submit_row($ibforums->lang['acp_save_settings'], 0);
print_cp_footer();
exit;
}
// ################################
// store usergroup-permissions to DB
// ################################
if ($action == "updategroups")
{
$the_groups = array();
$access = "";
$posts = "";
$max = "";
$ppd = "";
$tourney = "";
$DB->query("SELECT g_id FROM ibf_groups");
while( $g = $DB->fetch_row() )
{
$the_groups[] = $g['g_id'];
}
foreach( $the_groups as $id )
{
$access = $_POST[ $id."_access" ];
$posts = intval($_POST[ $id."_p_require" ]);
$max = intval($_POST[ $id."_max_play" ]);
$ppd = intval($_POST[ $id."_ppd_require" ]);
$tourney = intval($_POST[$id."_tourney"]);
$categories = $_POST[ $id."_catperm" ];
$cats = "";
if ($categories != "")
{
$cats = implode("," , $categories);
}
if( $posts < 0 )
{
$posts = 0;
}
if( $max < 0 )
{
$max = 0;
}
if( $ppd < 0 )
{
$ppd = 0;
}
if( ($tourney < 0) || ($tourney > 1) || (empty($tourney)) )
{
$tourney = 0;
}
if ( ($id == 1) && ($posts < 1) && ($access == 4) )
{
// make sure userid is set for guest-saving scores!
$access = 3;
}
if ( ($id == 1) && ($access < 4) )
{
// reset guestplayer-id if scoresaving is off
$posts = 0;
}
if ($id==1)
{
// fixed values for guests
$tourney=0;
$ppd=0;
$max=0;
}
$db_string = $DB->compile_db_update_string( array (
'arcade_access' => $access,
'p_require' => $posts,
'max_play' => $max,
'ppd_require' => $ppd,
'ibpa_cats' => $cats,
'tourney' => $tourney,
) );
$DB->query("UPDATE ibf_groups SET ".$db_string." WHERE g_id=".$id);
}
/*
if( $arcade['log'] )
{
$ADMIN->save_log("");
}
*/
define('CP_REDIRECT', 'arcade.php?code=groups');
print_stop_message('saved_settings_successfully');
}
// ##############################
// user-search
// ##############################
if ($action == "user_search")
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'usermanager');
print_table_header($ibforums->lang['acp_usersearch_header']);
construct_hidden_code('limitstart', 0);
construct_hidden_code('limitnumber', 10); // 10 user per result-page
print_input_row($ibforums->lang['acp_usersearch_name'], 'name', "", 0);
print_membergroup_row($ibforums->lang['acp_usersearch_group'], 'group_list', 0, $user);
print_select_row($ibforums->lang['acp_usersearch_ban'], 'is_banned', array('0' => $ibforums->lang['acp_usersearch_ban_null'], '1' => $ibforums->lang['acp_usersearch_ban_yes'], '2' => $ibforums->lang['acp_usersearch_ban_no']), 0);
print_select_row($ibforums->lang['acp_usersearch_sort'], 'sort_by', array('name' => $ibforums->lang['username'], 'id' =>$ibforums->lang['acp_usersearch_id'], 'g_title' => $ibforums->lang['acp_usersearch_ugid'], 'posts' => $ibforums->lang['acp_usersearch_posts']), 'name');
print_select_row($ibforums->lang['acp_usersearch_order'], 'sort_order', array('ASC' => $ibforums->lang['acp_ASC'], 'DESC' => $ibforums->lang['acp_DESC']), 'ASC');
print_submit_row($ibforums->lang['acp_search'], 0);
print_cp_footer();
exit;
}
// ################################
// user-manager
// ################################
if ($action == "usermanager")
{
$name = $_POST['name'];
$IN['is_banned'] = $_POST['is_banned'];
$IN['sort_by'] = $_POST['sort_by'];
$IN['sort_order'] = $_POST['sort_order'];
$IN['in_group'] = $_POST['group_list'];
$limitstart = $_POST['limitstart'];
$limitnumber = $_POST['limitnumber'];
$limitfinish = $limitstart + $limitnumber;
if (empty($name))
{
$name = "*";
/*
define('CP_REDIRECT', 'arcade.php?code=user_search');
print_stop_message('no_users_matched_your_query');
*/
}
if ($name == "*")
{
$name = "%";
}
$query = "";
$a = 0;
if ($IN['in_group'])
{
foreach($IN['in_group'] AS $group)
{
if( !($a) )
{
$query .= "AND ";
$query .= "g__id IN (";
}
$query .= ($a) ? "," : "";
$query .= $group;
$a++;
}
}
$query .= ") ";
if( $a == 0 )
{
$query = "";
}
if( $IN['is_banned'] != 0 )
{
$query .= " AND ";
if( $IN['is_banned'] == 1 )
{
$query .= "arcade_ban=1";
}
else
{
$query .= "arcade_ban=0";
}
}
$this_query = $DB->query(" SELECT m.id, m.name, m.mgroup, m.ip_address AS ip, m.posts, g.g_title
FROM ibf_members AS m
LEFT JOIN ibf_groups AS g
ON (m.mgroup = g.g_id)
WHERE name LIKE '%".$name."%' AND id<>0 ".$query."
ORDER BY ".$IN['sort_by']." ".$IN['sort_order']."
");
$countusers['users'] = $DB->get_num_rows($this_query);
$this_query = $DB->query(" SELECT m.id, m.name, m.mgroup, m.ip_address AS ip, m.posts, g.g_title
FROM ibf_members AS m
LEFT JOIN ibf_groups AS g
ON (m.mgroup = g.g_id)
WHERE name LIKE '%".$name."%' AND id<>0 ".$query."
ORDER BY ".$IN['sort_by']." ".$IN['sort_order']."
LIMIT $limitstart, $limitnumber
");
if( $DB->get_num_rows($this_query) )
{
$header = array();
$header[] = $ibforums->lang['acp_result_name'];
$header[] = $ibforums->lang['acp_result_usergroup'];
$header[] = $ibforums->lang['acp_result_postings'];
$header[] = $ibforums->lang['acp_result_options'];
$colspan = sizeof($header);
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'usermanager');
print_table_header($ibforums->lang['acp_result_showing1'].($limitstart+1).$ibforums->lang['acp_result_showing2'].iif($limitfinish > $countusers['users'], $countusers['users'], $limitfinish).$ibforums->lang['acp_result_showing3'].$countusers['users'], $colspan);
print_cells_row($header, 1);
}
else
{
define('CP_REDIRECT', 'arcade.php?code=user_search');
print_stop_message('no_users_matched_your_query');
}
// Ausgabe der Ergebnisse
while( $member = $DB->fetch_row($this_query) )
{
$cell = array();
$cell[] = "$member[name] ".$ibforums->lang['acp_result_editperm']." ".$ibforums->lang['acp_result_editscore']." ".$SCORE['name']." ".$ibforums->lang['acp_gamesort_delete']." ";
$cell[] = "".$ibforums->lang['acp_gamesort_edit']." ]";
$cell[] = "".$ibforums->lang['acp_remove']." ";
$cell[] = "
");
construct_hidden_code('userid', $USER['id']);
construct_hidden_code('score', "");
print_submit_row($ibforums->lang['acp_score_comment'], 0);
}
else
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'user_search');
print_table_header($ibforums->lang['acp_score_scoredel'].$USER['name'], $colspan);
print_description_row($ibforums->lang['acp_score_noscoreuser']);
print_submit_row($ibforums->lang['acp_back'], 0);
}
print_cp_footer();
}
}
else
{
if( $IN['remove'] == 'user' )
{
$id = $IN['user'];
$DB->query("SELECT name FROM ibf_members WHERE id=".$id);
$USER = $DB->fetch_row();
$DB->query("DELETE FROM ibf_games_scores WHERE mid=".$id);
do_champ_update(1);
do_league_update();
/*
if( $arcade['log'] )
{
$ADMIN->save_log("Ergebnisse von ".$USER['name']." entfernt.");
}
*/
define('CP_REDIRECT', 'arcade.php?code=gamelist');
print_stop_message('saved_settings_successfully');
}
elseif( $IN['remove'] == 'game' )
{
$gid = $IN['game_id'];
$DB->query("DELETE FROM ibf_games_scores WHERE gid=".$gid);
do_champ_update(1);
do_league_update();
/*
if( $arcade['log'] )
{
$ADMIN->save_log("Ergebnisse gelöscht");
}
*/
define('CP_REDIRECT', 'arcade.php?code=gamelist');
print_stop_message('saved_settings_successfully');
}
else
{
$score = $IN['sid'];
$DB->query("DELETE FROM ibf_games_scores WHERE s_id=".$score);
do_champ_update(1);
do_league_update();
/*
if( $arcade['log'] )
{
$ADMIN->save_log("Ergebnisse gelöscht");
}
*/
define('CP_REDIRECT', 'arcade.php?code=gamelist&cat=0');
print_stop_message('saved_settings_successfully');
}
}
}
// ##############################
// comment editing
// ##############################
if ($action == "edit_comment")
{
global $IN;
$DB->query("UPDATE ibf_games_scores SET comment='".cleansql($IN['comment_input'])."' WHERE s_id=".$IN['score']);
define('CP_REDIRECT', 'arcade.php?code=scores&do=user&user='.$IN['userid']);
print_stop_message('saved_settings_successfully');
}
// ##############################
// IP banning
// ##############################
if ($action == "ip_ban")
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'save_ipban');
print_table_header($ibforums->lang['acp_ipban_header']);
print_description_row($ibforums->lang['acp_ipban_text']);
$arcade['banned_ips'] = str_replace("|", "\n", $arcade['banned_ips']);
print_textarea_row($ibforums->lang['acp_ipban_field'], 'the_ips', $arcade['banned_ips'], 10, 16);
print_submit_row($ibforums->lang['acp_save'], 0);
print_cp_footer();
exit;
}
// ##############################
// save IP banning settings to DB
// ##############################
if ($action == "save_ipban")
{
$ip = $_POST['the_ips'];
$ip = trim($std->txt_stripslashes($ip));
$ip = str_replace('|', "|", $ip);
$ip = preg_replace( "/\n/", '|', str_replace( "\n\n", "\n", str_replace( "\r", "\n", $ip ) ) );
$ip = preg_replace( "/\|{1,}\s{1,}?/s", "|", $ip );
$ip = preg_replace( "/^\|/", "", $ip );
$ip = preg_replace( "/\|$/", "", $ip );
$ip = str_replace( "'", ''', $ip );
$db_string = $DB->compile_db_update_string( array ( 'banned_ips' => $ip ) );
$DB->query("UPDATE ibf_games_settings SET ".$db_string);
/*
if( $arcade['log'] )
{
$ADMIN->save_log("gesperrte IP-Adressen aktualisiert");
}
*/
define('CP_REDIRECT', 'arcade.php?code=ip_ban');
print_stop_message('saved_settings_successfully');
}
// ##############################
// score tools page
// ##############################
if ($action == "score_tools")
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'tool_scores');
print_table_header($ibforums->lang['acp_scoretool_header']);
print_description_row($ibforums->lang['acp_scoretool_text']);
print_input_row($ibforums->lang['acp_scoretool_name'], 'uname', "", 0);
$game_list = array();
$games = array();
$games[0] = $ibforums->lang['acp_scoretool_allgames'];
$counter = 1;
$DB->query("SELECT * FROM ibf_games_list ORDER BY gtitle");
while( $GAME = $DB->fetch_row() )
{
$games[$GAME['gid']] = $GAME['gtitle'];
}
print_select_row($ibforums->lang['acp_scoretool_games'], 'in_game[]', $games, '', 0, 10, true);
$output = array();
$output[] = $ibforums->lang['acp_scoretool_age'];
$output[] = " \n".$ibforums->lang['acp_scoretool_age_old']." \n".$ibforums->lang['acp_scoretool_age_new']." \n \n\n
\n".$ibforums->lang['acp_hours']." \n".$ibforums->lang['acp_days']." \n".$ibforums->lang['acp_months']." \n \n\n
";
print_cells_row($output);
print_select_row($ibforums->lang['acp_scoretool_sortby'], 'sort', array('name' => $ibforums->lang['acp_scoretool_sname'], 'gid' => $ibforums->lang['acp_scoretool_sgid'], 'score' => $ibforums->lang['acp_scoretool_sscore'], 'datescored' => $ibforums->lang['acp_scoretool_sdate']), 'name');
print_select_row($ibforums->lang['acp_scoretool_sortorder'], 'order', array('ASC' => $ibforums->lang['acp_ASC'], 'DESC' => $ibforums->lang['acp_DESC']), 'ASC');
print_select_row($ibforums->lang['acp_scoretool_logic'], 'search_type', array('AND' => $ibforums->lang['acp_AND'], 'OR' => $ibforums->lang['acp_OR']), 'AND');
print_input_row($ibforums->lang['acp_scoretool_amount'], 'limit', "", 0);
$javascript = "";
$description = "";
print_description_row($description.$javascript);
print_submit_row($ibforums->lang['acp_search'], 0);
print_table_break('', "90%");
print_table_header($ibforums->lang['acp_tool_actnames']);
print_form_header('arcade', 'tool_actnames');
print_description_row($ibforums->lang['acp_tool_actnamestext']);
print_input_row($ibforums->lang['acp_tool_actnamesamount'], 'amount_per_row', 500, 0);
$DB->query("SELECT COUNT(s_id) AS amount FROM ibf_games_scores");
$scores = $DB->fetch_row();
construct_hidden_code('total', $scores['amount']);
construct_hidden_code('start', 1);
print_submit_row($ibforums->lang['acp_start'], 0);
print_table_break('', "90%");
print_table_header($ibforums->lang['acp_tool_champs']);
print_form_header('arcade', 'tool_champs');
print_description_row($ibforums->lang['acp_tool_champstext']);
print_select_row($ibforums->lang['acp_tool_champsgames'], 'in_game[]', $games, '', 0, 10, true);
print_submit_row($ibforums->lang['acp_start'], 0);
print_table_break('', "90%");
print_table_header($ibforums->lang['acp_tool_best']);
print_form_header('arcade', 'tool_best');
print_description_row($ibforums->lang['acp_tool_besttext']);
print_select_row($ibforums->lang['acp_tool_champsgames'], 'in_game[]', $games, '', 0, 10, true);
print_submit_row($ibforums->lang['acp_start'], 0);
print_table_break('', "90%");
print_table_header($ibforums->lang['acp_tool_league']);
print_form_header('arcade', 'tool_league');
print_description_row($ibforums->lang['acp_tool_leaguetext']);
print_submit_row($ibforums->lang['acp_start'], 0);
print_cp_footer();
exit;
}
// ##############################
// score-tool: prune scores
// ##############################
if ($action == "tool_scores")
{
global $IN;
$type = $IN['search_type'];
$query = "";
if( !empty($IN['uname']) )
{
$query .= " name LIKE '%".$IN['uname']."%' ";
}
if( !in_array("0" , $IN['in_game']) )
{
if( !empty($query) )
{
$query .= $type;
}
$query .= " gid IN (".implode("," , $IN['in_game']).")";
}
if( !empty($IN['age']) )
{
if( !empty($query) )
{
$query .= $type;
}
if( $IN['time_frame'] == 'h' )
{
$time = $IN['age']*(60*60);
}
elseif( $IN['time_frame'] == 'd' )
{
$time = $IN['age']*(60*60*24);
}
else
{
$time = $IN['age']*(60*60*24*30);
}
$thetime = time()-$time;
$op = ($IN['old_new'] == 'o') ? "<" : ">";
$query .= " datescored".$op.$thetime." ";
}
if( !empty($query) )
{
$query .= " ORDER BY ".$IN['sort']." ".$IN['order'];
}
if( !empty($IN['limit']) )
{
if( !empty($query) && is_numeric($IN['limit']) && $IN['limit'] > 0 )
{
$query .= " LIMIT 0, ".$IN['limit'];
}
}
if( empty($query) )
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'score_tools');
print_table_header($ibforums->lang['acp_tool_prune_errhead']);
print_description_row($ibforums->lang['acp_tool_prune_errtext']);
print_submit_row($ibforums->lang['acp_tool_prune_errbutt'], 0);
print_cp_footer();
exit;
}
$this_query = $DB->query("SELECT * FROM ibf_games_scores WHERE ".$query);
if( $DB->get_num_rows($this_query) )
{
$header = array();
$header[] = $ibforums->lang['acp_result_score'];
$header[] = $ibforums->lang['acp_result_name'] ;
$header[] = $ibforums->lang['acp_result_empty'];
$header[] = $ibforums->lang['acp_result_empty'];
$colspan = sizeof($header);
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'tool_multi_del');
print_table_header($ibforums->lang['acp_tool_prune_header'], $colspan);
$javascript = " ";
print_description_row($ibforums->lang['acp_tool_prune_headtxt'].$javascript, 0, $colspan);
print_cells_row($header, 1);
$gnames = array();
$counter = 1;
while( $RESULT = $DB->fetch_row($this_query) )
{
if( !isset($gnames[ $RESULT['gid'] ]) )
{
$DB->query("SELECT gtitle FROM ibf_games_list WHERE gid=".$RESULT['gid']);
$g = $DB->fetch_row();
$gnames[ $RESULT['gid'] ] = $g['gtitle'];
}
// Datumformat Zeitzone ?!
$time = timeoutput($RESULT['datescored']);
$cell = array();
$cell[] = $ibforums->lang['score'].": ".$RESULT['score']."".$RESULT['name']." ".$ibforums->lang['acp_remove']." ";
$cell[] = "".$row['score_name'].$ibforums->lang['acp_tool_userrename'].$row['name']." ";
$db_string = $DB->compile_db_update_string( array ( 'name' => $row['name'] ) );
$DB->query("UPDATE ibf_games_scores SET ".$db_string." WHERE mid=".$row['id']);
$DB->query("UPDATE ibf_games_champs SET champ_name='".$row['name']."' WHERE champ_mid=".$row['id']);
// update finished tournaments...
$tourcheck_query = $DB->query("SELECT tid FROM ibf_tournaments WHERE champion='".$row['score_name']."'");
while ($tourcheck = $DB->fetch_row($tourcheck_query))
{
$DB->query("UPDATE ibf_tournaments SET champion='".$row['name']."' WHERE tid=".$tourcheck['tid']);
}
}
if( (empty($row['name'])) && (!in_array($row['score_name'] , $cache)) )
{
$cache[] = $row['score_name'];
$changed .= "".$row['score_name'].$ibforums->lang['acp_tool_userdelete']." ";
$DB->query("DELETE FROM ibf_games_scores WHERE mid=".$row['mid']);
}
}
if( !$end )
{
$new_start = ($start + $per_row);
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'tool_actnames');
print_table_header($ibforums->lang['acp_result_showing0'].$start.$ibforums->lang['acp_result_showing2'].($new_start-1).$ibforums->lang['acp_result_showing3'].$total);
construct_hidden_code('total', $total);
construct_hidden_code('amount_per_row', $per_row);
construct_hidden_code('start', $new_start);
print_description_row($ibforums->lang['acp_tool_userupdate']);
if( !empty($changed) )
{
$changed_names = "".$changed." ";
}
else
{
$changed_names .= "".$ibforums->lang['acp_tourneylist_none']." ";
}
print_description_row($ibforums->lang['acp_tool_userupdatelist'].$changed_names);
print_submit_row($ibforums->lang['acp_continue'], 0);
print_cp_footer();
define('CP_REDIRECT', 'arcade.php?code=score_tools');
exit;
}
else
{
/*
if( $arcade['log'] )
{
$ADMIN->save_log("Benutzernamen aktualisiert.");
}
*/
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'tool_champs');
print_table_header($ibforums->lang['acp_done']);
construct_hidden_code('in_game[]', 0);
print_description_row($ibforums->lang['acp_tool_userdone']);
define('CP_REDIRECT', 'arcade.php?code=tool_champs');
print_submit_row($ibforums->lang['acp_continue'], 0);
print_cp_footer();
exit;
}
}
// ##############################
// score-tools: update champs
// ##############################
if ($action == "tool_champs")
{
global $IN;
$query_extra = "";
if( !in_array("0" , $IN['in_game']) )
{
$query_extra .= "WHERE gid IN (".implode("," , $IN['in_game']).")";
}
$the_champs = array();
if( $query_extra == "" )
{
$DB->query("DELETE FROM ibf_games_champs");
}
$game_query = $DB->query("SELECT gid, highscore_type, gtitle FROM ibf_games_list ".$query_extra." ORDER by gid");
while( $game = $DB->fetch_row($game_query) )
{
$order = ($game['highscore_type'] == "high") ? "DESC" : "ASC";
$DB->query(" SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
FROM ibf_games_scores AS s, ibf_games_list AS g
WHERE s.gid=g.gid AND s.gid=".$game['gid']."
ORDER BY score ".$order.", timespent ASC");
if( $DB->get_num_rows() )
{
$champ = $DB->fetch_row();
$the_champs[] = array( 'gid' => $champ['gid'],
'gtitle' => $champ['gtitle'],
'mid' => $champ['mid'],
'name' => $champ['name'],
'date' => $champ['datescored'],
'score' => $champ['score'] );
}
}
foreach( $the_champs as $this_champ )
{
if( $query_extra != "" )
{
$db_string = $DB->compile_db_update_string( array ( 'champ_gid' => $this_champ['gid'],
'champ_gtitle' => $this_champ['gtitle'],
'champ_mid' => $this_champ['mid'],
'champ_name' => $this_champ['name'],
'champ_date' => $this_champ['date'],
'champ_score' => $this_champ['score'] ) );
$DB->query("UPDATE ibf_games_champs SET ".$db_string." WHERE champ_gid=".$this_champ['gid']);
}
else
{
$db_string = $DB->compile_db_insert_string( array ( 'champ_gid' => $this_champ['gid'],
'champ_gtitle' => $this_champ['gtitle'],
'champ_mid' => $this_champ['mid'],
'champ_name' => $this_champ['name'],
'champ_date' => $this_champ['date'],
'champ_score' => $this_champ['score'] ) );
$DB->query("INSERT INTO ibf_games_champs (".$db_string['FIELD_NAMES'].") VALUES (".$db_string['FIELD_VALUES'].")");
}
}
/*
if( $arcade['log'] )
{
$ADMIN->save_log("Spiele-Sortierung angepasst.");
}
*/
define('CP_REDIRECT', 'arcade.php?code=score_tools');
print_stop_message('saved_settings_successfully');
}
// ##############################
// score-tools: update best results
// ##############################
if ($action == "tool_best")
{
global $IN;
$query_extra = "";
if( !in_array("0" , $IN['in_game']) )
{
$query_extra .= "WHERE champ_gid IN (".implode("," , $IN['in_game']).")";
}
$this_query=$DB->query("SELECT champ_gid, champ_mid, champ_score, champ_time FROM ibf_games_champs ".$query_extra);
WHILE ($champinfo=$DB->fetch_row($this_query))
{
$check_query=$DB->query("SELECT gid, bestscore, besttime, highscore_type FROM ibf_games_list WHERE gid=".$champinfo['champ_gid']);
$gameinfo=$DB->fetch_row($check_query);
// update the best result only if current champ-result is really better
if (($gameinfo['bestscore'] < $champinfo['champ_score'] && $gameinfo['highscore_type']=="high") || ($gameinfo['bestscore'] > $champinfo['champ_score'] && $gameinfo['highscore_type']=="low") || (($gameinfo['bestscore'] == $champinfo['champ_score']) && ($champinfo['champ_time']) < $gameinfo['besttime'] || $gameinfo['besttime']==0))
{
$DB->query("UPDATE ibf_games_list SET bestmid=".$champinfo['champ_mid'].", bestscore='".$champinfo['champ_score']."', besttime='".$champinfo['champ_time']."' WHERE gid=".$champinfo['champ_gid']);
}
// force update if the is no best result and "the lower the better"
if (((intval($gameinfo['bestscore'])==0) || ($gameinfo['bestscore']=="")) && ($gameinfo['highscore_type']=="low"))
{
$DB->query("UPDATE ibf_games_list SET bestmid=".$champinfo['champ_mid'].", bestscore='".$champinfo['champ_score']."', besttime='".$champinfo['champ_time']."' WHERE gid=".$champinfo['champ_gid']);
}
}
/*
if( $arcade['log'] )
{
$ADMIN->save_log("aktualisiert.");
}
*/
define('CP_REDIRECT', 'arcade.php?code=score_tools');
print_stop_message('saved_settings_successfully');
}
// ##############################
// score-tools: update league
// ##############################
if ($action == "tool_league")
{
global $IN;
$DB->query("DELETE FROM ibf_games_league");
$game_query = $DB->query("SELECT * FROM ibf_games_list WHERE active=1");
while ($ginfo = $DB->fetch_row($game_query))
{
$ordering = ($ginfo['highscore_type'] == "high") ? "DESC" : "ASC";
$ctr = 1;
$this_query = $DB->query("SELECT mid FROM ibf_games_scores WHERE gid='".$ginfo['gid']."' ORDER BY score ".$ordering.", timespent ASC LIMIT 0,10");
if ($DB->get_num_rows($this_query))
{
while($lboard = $DB->fetch_row($this_query))
{
switch($ctr)
{
case 1: $points = $arcade['league_scores'][0];
break;
case 2: $points = $arcade['league_scores'][1];
break;
case 3: $points = $arcade['league_scores'][2];
break;
case 4: $points = $arcade['league_scores'][3];
break;
case 5: $points = $arcade['league_scores'][4];
break;
case 6: $points = $arcade['league_scores'][5];
break;
case 7: $points = $arcade['league_scores'][6];
break;
case 8: $points = $arcade['league_scores'][7];
break;
case 9: $points = $arcade['league_scores'][8];
break;
case 10: $points = $arcade['league_scores'][9];
break;
default: $points = $arcade['league_scores'][10];
}
if ($points > 0)
{
extract($ginfo);
$lid = $lboard['mid'];
$db_string = $DB->compile_db_insert_string( array ( 'mid' => $lid,
'gid' => $gid,
'position' => $ctr,
'points' => $points,
'cat' => $gcat, ) );
$DB->query("INSERT INTO ibf_games_league (" .$db_string['FIELD_NAMES']. ") VALUES (". $db_string['FIELD_VALUES'] .")");
}
$ctr++;
}
}
}
/*
if( $arcade['log'] )
{
$ADMIN->save_log("Spiele-Sortierung angepasst.");
}
*/
define('CP_REDIRECT', 'arcade.php?code=score_tools');
print_stop_message('saved_settings_successfully');
}
// ##############################
// custom game sorting
// ##############################
if ($action == "custom")
{
if( !$DB->field_exists("position","ibf_games_list") )
{
$DB->query("ALTER TABLE ibf_games_list ADD position MEDIUMINT( 8 ) DEFAULT '1' NOT NULL");
}
$DB->query("SELECT g_display_sort AS sort FROM ibf_games_settings");
$CONFIG = $DB->fetch_row();
if( $CONFIG['sort'] != 'position' )
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'jumpsettings');
print_table_header($ibforums->lang['acp_gamesort_err_header']);
print_description_row($ibforums->lang['acp_gamesort_err_text']);
print_submit_row($ibforums->lang['acp_gamesort_err_button'], 0);
print_cp_footer();
exit;
}
else
{
$DB->query("SELECT * FROM ibf_games_list ORDER BY position");
$header = array();
$header[] = "".$ibforums->lang['acp_gamesort_pos']."
";
$header[] = "".$ibforums->lang['acp_gamesort_icon']."
";
$header[] = "".$ibforums->lang['acp_gamesort_game']."
";
$colspan = sizeof($header);
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'sort_games');
print_table_header($ibforums->lang['acp_gamesort_header'], $colspan);
print_cells_row($header, 1);
while( $GAME = $DB->fetch_row() )
{
$input_name = $GAME['gid']."_position";
$cell = array();
$cell[] = "".$GAME['gtitle']."
";
print_cells_row($cell);
}
print_submit_row($ibforums->lang['acp_gamesort_button'], 0, $colspan);
print_cp_footer();
exit;
}
}
// ##############################
// store custom game-order to DB
// ##############################
if ($action == "sortgames")
{
global $IN;
$order = array();
foreach( $IN as $key=>$value )
{
if( preg_match("#_position#", $key) )
{
if( !is_numeric($value) || $value < 0 )
{
$value = 1;
}
$key = intval($key);
$order[$key] = $value;
}
}
unset($key);
unset($value);
foreach( $order as $key=>$value )
{
$db_string = $DB->compile_db_update_string( array ( 'position' => $value ) );
$DB->query("UPDATE ibf_games_list SET ".$db_string." WHERE gid='".$key."'");
}
/*
if( $arcade['log'] )
{
$ADMIN->save_log("Spiele-Sortierung angepasst.");
}
*/
define('CP_REDIRECT', 'arcade.php?code=custom');
print_stop_message('saved_settings_successfully');
}
// ##############################
// information
// ##############################
if ($action == "info")
{
$query = $DB->query("SELECT arcade_language FROM ibf_games_settings");
$setting = $DB->fetch_row($query);
$indexcheck = "";
$javascript = ' ';
if ($vbulletin->options['forumhome'] != "index")
{
if ($vboptions['forumhome'] != "index")
{
$homefile = $vbulletin->options['forumhome'].$vboptions['forumhome'];
if ($setting['arcade_language']=="de")
{
$indexcheck = $javascript;
$indexcheck.= "Hinweis: ".$homefile.".php - deshalb muss die Datei /index.php angepasst werden, ansonsten werden keine Punkte gespeichert!";
$indexcheck.= "Genaue Informationen zur notwendigen Anpassung sind im ibProArcade-Archiv enthalten: INFO - vbadvanced or other Portal.txt oder in diesem ";
$indexcheck.= "Popup-Fenster ";
$indexcheck.= " ";
$indexcheck.= "Notice: ".$homefile.".php - please make sure to adapt your /index.php otherwise scores won't be recorded!";
$indexcheck.= "You will find detailed instructions in the ibProArcade-archive: INFO - vbadvanced or other Portal.txt or in this ";
$indexcheck.= "popup-window ";
$indexcheck.= " ";
$indexcheck.= "ACHTUNG holdsession.php fehlt im Hauptverzeichnis des Forums, bitte umgehend dort hochladen!ATTENTION holdsession.php is missing in your forums root directory, please upload it.ibProArcade v2.7.0+ by MrZeropage hier zu finden.hier klicken.".$paypal_donate_de." Freiwillige Spenden als Danksagung, zur Unterstützung usw. sind jederzeit willkommen - DANKE :)Der Spendenbetrag kann frei eingegeben werden.
");
print_description_row("".$paypal_link_de." Um die Versions- und Copyright-Informationen in der Spielhalle zu entfernen, wird eine Branding-Free 40,- Euro Die Lizenz ist für eine Installation, eine URL, eine Website gültig.vb3hack@gmail.com melden für Anweisung, wie das Copyright entfernt wird.
".$paypal_link_de_special." ** SONDERAKTION bis 31.12.2009 ** Branding-Free Sonderpreis (gültig bis 31.12.2009) für die Lizenz liegt bei 25,- Euro (statt 40,-)Die Lizenz ist für eine Installation, eine URL, eine Website gültig.vb3hack@gmail.com melden für Anweisung, wie das Copyright entfernt wird.
Zahlungen können auch manuell per PayPal an die Adresse vb3hack@gmail.com ");
}
else
{
print_description_row("You can get the actual version here .click here .".$paypal_donate_en." Donations to express your THANKS and support for further development are welcome :)You can donate any amount, every dollar is welcome.
");
print_description_row("".$paypal_link_en." To remove the Copyright-Information from the Arcade, we offer a Branding-Free 50,- US$ One license is valid for one installation, one site, one URL.vb3hack@gmail.com to get instructions about removement.
".$paypal_link_en_special." ** SPECIAL OFFER valid until 31st december 2009 ** Branding-Free special price (valid until 31st december 2009) for one license is 35,- US$ (instead of 50,- US$)One license is valid for one installation, one site, one URL.vb3hack@gmail.com to get instructions about removement.
You can pay manually via PayPal to vb3hack@gmail.com ");
}
print_cp_footer();
}
if ($action=="showtext_index")
{
$query = $DB->query("SELECT arcade_language FROM ibf_games_settings");
$setting = $DB->fetch_row($query);
if ($setting['arcade_language']=="de")
{
$t1 = "Öffne";
$t2 = "Suche nach: (ganz am Anfang der Datei)";
$t3 = "Darunter füge hinzu:";
$t4 = "Speichere die Veränderung auf dem Server.";
}
else
{
$t1 = "Open";
$t2 = "Search for: (very top of file)";
$t3 = "Below that add:";
$t4 = "Save and upload your index.php back to your server.";
}
$instructions = '
'.$t1.' "/index.php"
'.$t4.'
';
echo <<
ibProArcade
Error : '.$err.'Error : '.$err.' ![".$GAME[](../arcade/images/".$GAME[ "\".$GAME[")
".$playlink2."
";
}
$filesize="";
if ($GAME['filesize'] > 0)
{
$filesize = "![".$SCORE[](../arcade/images/".$SCORE[ "\".$SCORE["){kind=small}
";
$cell[] = $SCORE['gtitle'];
$cell[] = $SCORE['score'];
$cell[] = $SCORE['comment'].$linebreak."[ ".$ibforums->lang['acp_gamesort_edit']." ]";
$cell[] = "".$ibforums->lang['acp_remove']."";
$cell[] = "";
print_cells_row($cell);
$counter++;
}
print_table_break('', "90%");
$counter++;
print_description_row("");
$counter--;
print_submit_row($ibforums->lang['acp_score_removechoice'], 0);
print_form_header('arcade', 'edit_comment');
print_table_header($ibforums->lang['acp_score_commentheader']);
print_description_row($ibforums->lang['acp_score_commenttext']);
print_description_row("");
construct_hidden_code('userid', $USER['id']);
construct_hidden_code('score', "");
print_submit_row($ibforums->lang['acp_score_comment'], 0);
}
else
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'user_search');
print_table_header($ibforums->lang['acp_score_scoredel'].$USER['name'], $colspan);
print_description_row($ibforums->lang['acp_score_noscoreuser']);
print_submit_row($ibforums->lang['acp_back'], 0);
}
print_cp_footer();
}
}
else
{
if( $IN['remove'] == 'user' )
{
$id = $IN['user'];
$DB->query("SELECT name FROM ibf_members WHERE id=".$id);
$USER = $DB->fetch_row();
$DB->query("DELETE FROM ibf_games_scores WHERE mid=".$id);
do_champ_update(1);
do_league_update();
/*
if( $arcade['log'] )
{
$ADMIN->save_log("Ergebnisse von ".$USER['name']." entfernt.");
}
*/
define('CP_REDIRECT', 'arcade.php?code=gamelist');
print_stop_message('saved_settings_successfully');
}
elseif( $IN['remove'] == 'game' )
{
$gid = $IN['game_id'];
$DB->query("DELETE FROM ibf_games_scores WHERE gid=".$gid);
do_champ_update(1);
do_league_update();
/*
if( $arcade['log'] )
{
$ADMIN->save_log("Ergebnisse gelöscht");
}
*/
define('CP_REDIRECT', 'arcade.php?code=gamelist');
print_stop_message('saved_settings_successfully');
}
else
{
$score = $IN['sid'];
$DB->query("DELETE FROM ibf_games_scores WHERE s_id=".$score);
do_champ_update(1);
do_league_update();
/*
if( $arcade['log'] )
{
$ADMIN->save_log("Ergebnisse gelöscht");
}
*/
define('CP_REDIRECT', 'arcade.php?code=gamelist&cat=0');
print_stop_message('saved_settings_successfully');
}
}
}
// ##############################
// comment editing
// ##############################
if ($action == "edit_comment")
{
global $IN;
$DB->query("UPDATE ibf_games_scores SET comment='".cleansql($IN['comment_input'])."' WHERE s_id=".$IN['score']);
define('CP_REDIRECT', 'arcade.php?code=scores&do=user&user='.$IN['userid']);
print_stop_message('saved_settings_successfully');
}
// ##############################
// IP banning
// ##############################
if ($action == "ip_ban")
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'save_ipban');
print_table_header($ibforums->lang['acp_ipban_header']);
print_description_row($ibforums->lang['acp_ipban_text']);
$arcade['banned_ips'] = str_replace("|", "\n", $arcade['banned_ips']);
print_textarea_row($ibforums->lang['acp_ipban_field'], 'the_ips', $arcade['banned_ips'], 10, 16);
print_submit_row($ibforums->lang['acp_save'], 0);
print_cp_footer();
exit;
}
// ##############################
// save IP banning settings to DB
// ##############################
if ($action == "save_ipban")
{
$ip = $_POST['the_ips'];
$ip = trim($std->txt_stripslashes($ip));
$ip = str_replace('|', "|", $ip);
$ip = preg_replace( "/\n/", '|', str_replace( "\n\n", "\n", str_replace( "\r", "\n", $ip ) ) );
$ip = preg_replace( "/\|{1,}\s{1,}?/s", "|", $ip );
$ip = preg_replace( "/^\|/", "", $ip );
$ip = preg_replace( "/\|$/", "", $ip );
$ip = str_replace( "'", ''', $ip );
$db_string = $DB->compile_db_update_string( array ( 'banned_ips' => $ip ) );
$DB->query("UPDATE ibf_games_settings SET ".$db_string);
/*
if( $arcade['log'] )
{
$ADMIN->save_log("gesperrte IP-Adressen aktualisiert");
}
*/
define('CP_REDIRECT', 'arcade.php?code=ip_ban');
print_stop_message('saved_settings_successfully');
}
// ##############################
// score tools page
// ##############################
if ($action == "score_tools")
{
print_cp_header($ibforums->lang['acp_header']);
print_form_header('arcade', 'tool_scores');
print_table_header($ibforums->lang['acp_scoretool_header']);
print_description_row($ibforums->lang['acp_scoretool_text']);
print_input_row($ibforums->lang['acp_scoretool_name'], 'uname', "", 0);
$game_list = array();
$games = array();
$games[0] = $ibforums->lang['acp_scoretool_allgames'];
$counter = 1;
$DB->query("SELECT * FROM ibf_games_list ORDER BY gtitle");
while( $GAME = $DB->fetch_row() )
{
$games[$GAME['gid']] = $GAME['gtitle'];
}
print_select_row($ibforums->lang['acp_scoretool_games'], 'in_game[]', $games, '', 0, 10, true);
$output = array();
$output[] = $ibforums->lang['acp_scoretool_age'];
$output[] = "