function addLocation() { global $strVenueName, $strVenueAddress, $strAPIId, $strLocationId, $strLatitude, $strLongitude; //some data is missing; if ($strVenueName == "" || $strVenueAddress == "" || $strAPIId == "" || $strLatitude == "" || $strLongitude == "") { return 0; } $strLocationId = ""; //Check to see if the actual location exists db("SELECT LocationId FROM locations WHERE LocationName = '" . $strVenueName . "' AND LocationAddress = '" . $strVenueAddress . "' AND API_ID = '" . $strAPIId . "'"); $location_exists = dbr(); if (empty($location_exists) == true) { //Check to see if the locationname is in use db("SELECT LocationId FROM locations WHERE API_ID = '" . $strAPIId . "'"); $apiID_exists = dbr(); if (empty($apiID_exists) == true) { //Insert our new location dbn("INSERT INTO locations (LocationName, LocationAddress, API_ID, LocationLat, LocationLong) VALUES ('" . $strVenueName . "', '" . $strVenueAddress . "', '" . $strAPIId . "', '" . $strLatitude . "', '" . $strLongitude . "')"); db("SELECT LocationId FROM locations WHERE LocationName = '" . $strVenueName . "' AND LocationAddress = '" . $strVenueAddress . "' AND API_ID = '" . $strAPIId . "'"); $location_created = dbr(); //location has successfully registered if (empty($location_created) == false) { $strLocationId = $location_created['LocationId']; return $location_created['LocationId']; } else { return -1; } } else { return -2; } } else { $strLocationId = $location_exists['LocationId']; return $location_exists['LocationId']; } }
function updateReview() { global $intReviewId, $strWhichRating; if ($intReviewId == "" || $strWhichRating == "") { return 0; } dbn("UPDATE locationreview SET " . $strWhichRating . " = " . $strWhichRating . " + 1 WHERE ReviewId = '" . $intReviewId . "'"); return 1; }
function addReview() { global $intLocationId, $intUserId, $strReview, $fltRating; if ($intLocationId == "" || $intUserId == "") { return 0; } if ($strReview == "" && $fltRating == "") { return -1; } dbn("INSERT INTO locationreview (LocationId, UserId, DateTime, ReviewText, ReviewRating) VALUES ('" . $intLocationId . "', '" . $intUserId . "', '" . Time() . "', '" . $strReview . "', '" . $fltRating . "')"); if ($fltRating > 0.0) { db("SELECT AVG(ReviewRating) as Average FROM locationreview WHERE LocationId = '" . $intLocationId . "' AND ReviewRating > 0.0"); $avg = dbr(); if ($avg['Average'] != null) { dbn("UPDATE locations SET LocationRatings = '" . $avg['Average'] . "', LocationUseRatings = '1' WHERE LocationId = '" . $intLocationId . "'"); } } return 1; }
$elect_sold = $elect_sold + $user_ship['elect']; $fuel_sold = $fuel_sold + $user_ship['fuel']; $metal_sold = $metal_sold + $user_ship['metal']; # if ($user_ship[metal] > 0) { $error_str .= "You sold $user_ship[metal] units of metal.<p />"; } # if ($user_ship[fuel] > 0) { $error_str .= "You sold $user_ship[fuel] units of fuel.<p />"; # if ($user_ship[elect] > 0) { $error_str .= "You sold $user_ship[elect] units of electronics.<p />"; charge_turns(1); $error_str .= $st[785] . "<p />"; $error_str .= "<p />{$st['774']}: <b>{$metal_sold}</b><br />{$st['775']}: <b>{$fuel_sold}</b><br />{$st['776']}: <b>{$elect_sold}</b>"; $error_str .= "<p />{$st['777']}: <b>"; $total_goods = $metal_sold + $fuel_sold + $elect_sold; $error_str .= "{$total_goods}</b>"; $error_str .= "<br />{$st['778']}: <b>{$sold_worth}</b>.<p />"; } } dbn("update {$db_name}_users set cash = cash + {$sold_worth} where login_id = {$user['login_id']}"); $user['cash'] += $sold_worth; $user_ship['metal'] = 0; $user_ship['fuel'] = 0; $user_ship['elect'] = 0; # $user_ship[colon] = 0; } empty_bays($user_ship); $sold_worth = 0; $ship_count = 0; db("select elect,fuel,metal,ship_id from {$db_name}_ships where location = {$user['location']} and login_id = {$user['login_id']}"); while ($current_ship = dbr()) { $sold_worth += $current_ship['elect'] * $elect_sell + $current_ship['fuel'] * $fuel_sell + $current_ship['metal'] * $metal_sell; $elect_sold = $elect_sold + $current_ship['elect']; $fuel_sold = $fuel_sold + $current_ship['fuel']; $metal_sold = $metal_sold + $current_ship['metal'];
dbn("update se_games set description = '{$new_descr}' where db_name = '{$db_name}'"); $out .= "The description of the game has been changed."; } print_page("Change Description", $out); insert_history($user['login_id'], "Game description changed."); //change ships available to players. } elseif (isset($_REQUEST['admin_choose'])) { if (isset($_POST['add_ship'])) { db("select type_id from se_ship_types where type_id > 2 && auction = 0"); while ($list_ships = dbr(1)) { if (!isset($add_ship[$list_ships['type_id']])) { //admin has turned ship off. dbn("update se_admin_ships set {$db_name}_ship_status = 0 where ship_type_id = '{$list_ships['type_id']}'"); } else { //ship is turned on. dbn("update se_admin_ships set {$db_name}_ship_status = 1 where ship_type_id = '{$list_ships['type_id']}'"); } } $out .= "Selected ships have now been made available to the players. The rest of the ships are un-available."; } else { $out .= "Select the ships that you would like users to be able to use within the game:"; $out .= "\n<form name='select_ships' action='{$_SERVER['PHP_SELF']}' method='POST'>"; $out .= "\n<input type='hidden' name='admin_choose' value='1' />"; $out .= make_table(array("<b class='b1'>Ship Name</b>", "Available")); db("select s.type_id,s.name,a.{$db_name}_ship_status as status from se_ship_types s, se_admin_ships a where s.type_id > 2 && a.ship_type_id = s.type_id && s.auction = 0"); while ($list_ships = dbr(1)) { if ($list_ships['status'] == 1) { $out .= "\n" . quick_row("{$list_ships['name']}", "<input type='checkbox' name='add_ship[{$list_ships['type_id']}]' value='{$list_ships['type_id']}' checked='checked' />"); } else { $out .= "\n" . quick_row("{$list_ships['name']}", "<input type='checkbox' name='add_ship[{$list_ships['type_id']}]' value='{$list_ships['type_id']}' />"); }
continue; } elseif (config_check("oo", $this_ship)) { //trying to transfer a flagship $loop_txt .= $st[742] . "<br />"; continue; } elseif ($target_ship_count['warships'] >= $GAME_VARS['max_warships'] && $this_ship['is_warship'] == 1) { $loop_txt .= "{$target['login_name']} {$st['743']}<br />"; continue; } elseif ($target_ship_count['other_ships'] >= $GAME_VARS['max_other_ships'] && $this_ship['is_warship'] == 0) { $loop_txt .= "{$target['login_name']} {$st['744']}<br />"; continue; } elseif ($ship_id == $user_ship['ship_id']) { $loop_txt .= $st[745]; } else { $loop_txt .= "<b class='b1'>{$this_ship['ship_name']}</b> {$st['746']}<br />"; dbn("update {$db_name}_ships set login_id = '{$target['login_id']}', fleet_id = '1', clan_id = {$target['clan_id']}, metal=0, fuel=0, elect=0, colon=0 where ship_id = '{$ship_id}'"); //ensure don't go over the limit if ($this_ship['is_warship'] == 1) { $target_ship_count['warships']++; } else { $target_ship_count['other_ships']++; } $transfer_counter++; } } $text .= sprintf($st[747], $transfer_counter, $num_ships) . "<p />" . $loop_txt; if ($transfer_counter > 0) { $total_cost = $cost_per_transfer * $transfer_counter; $text .= "<p />{$st['7480']} {$total_cost} " . $cw['credits']; take_cash($total_cost); post_news("<b class='b1'>" . sprintf($st[748], $user[login_name], $transfer_counter, $target[login_name]), "ship");
if (!avail_check(4001)) { $out .= $st[432]; } elseif ($user['turns'] < 1) { $out .= $st[433]; } elseif ($amount <= 0) { get_var('Take Colonists', $_SERVER['PHP_SELF'], "<a href='{$_SERVER['PHP_SELF']}?all_colon=1'>Fill Ship</a><p />Combien de colons voulez-vous acheter ?<br />Chaque colon coûte <b>{$GAME_VARS['cost_colonist']}</b> crédits.<p />", 'amount', $fill); } elseif ($fill < 1) { $out .= $st[1892] . "<p />"; } elseif ($amount > $user_ship['empty_bays']) { $out .= "You can't carry that many colonists.<p />"; } elseif ($amount * $GAME_VARS['cost_colonist'] > $user['cash']) { $out .= "You can't afford that many colonists.<p />"; } else { take_cash($GAME_VARS['cost_colonist'] * $amount); charge_turns(1); dbn("update {$db_name}_ships set colon = colon + '{$amount}' where ship_id = '{$user['ship_id']}'"); $user_ship['colon'] += $amount; $user_ship['empty_bays'] -= $amount; } //the ship shop. listing ships } elseif (isset($_GET['ship_shop'])) { $out .= $st[1800] . '<br /><br />'; $array_ships = array("Cargo" => "", "Bataille" => "", "Transport" => "", "Modulaires" => "", "Autres" => ""); $ship_types = load_ship_types(0); foreach ($ship_types as $type_id => $ship_stats) { if ($type_id < 3 || $ship_stats['tcost'] != 0) { //skip the EP and SD, as well as BM ships. continue; } else { $buy_many_link = "<a href='ship_build.php?mass={$type_id}'>" . $cw['buy_many'] . "</a>"; if ($ship_stats['type'] == "Cargo") {
function setAutoLoginCookie($login_id, $login_name, $mdp) { if (isset($_POST['auto_login']) && $_POST['auto_login'] && !isset($_COOKIE['astravires_auto_login'])) { dbn("update user_accounts set auto_login = 1 where login_id = {$login_id} limit 1"); $hash = md5($login_id . $login_name . $mdp) . '|' . $login_id; $expire = time() + 7 * 24 * 60 * 60; setcookie('astravires_auto_login', $hash, $expire); } elseif (isset($_COOKIE['astravires_auto_login']) && isset($_POST['submit']) && !isset($_POST['auto_login'])) { dbn("update user_accounts set auto_login = 0 where login_id = {$login_id} limit 1"); setcookie('astravires_auto_login', '', time() - 3600); } }
} elseif ($target_id == -5 && $clan_id > 0) { send_message($target_id, $text, $clan_id); $error_str = $cw['message_sent'] . "."; //send message to central forum } elseif ($target_id == -99 || $target_id == -50) { if ($user['login_id'] == OWNER_ID) { //server admin $sender_name = "<b class=\"b1\">" . $p_user['login_name'] . "</b> (" . $cw['server_admin'] . ")"; } elseif ($user['login_id'] == 1) { //admin $sender_name = "<b class=\"b1\">" . $cw['admin'] . "</b> - ({$game_info['admin_name']} - {$game_info['name']})"; } else { //regular player $sender_name = "<b class=\"b1\">" . $p_user['login_name'] . "</b> - {$game_info['name']}"; } dbn("insert into se_central_messages (timestamp, forum_id, sender_id, sender_name, text, game_id) values(" . time() . ", '{$target_id}', '{$user['login_id']}', '{$sender_name}', '" . mysql_escape_string(substr($text, 0, 5000)) . "', '{$game_info['game_id']}')"); $error_str = $st[911]; } else { send_message($target_id, $text); send_templated_email($target_id, 'message'); $error_str = $st[912]; } if ($target_id == -1 || $target_id == -50) { $error_str .= "<br /><br /><a href='forum.php?target_id={$target_id}'>" . $cw['back_forum'] . "</a>"; } elseif ($target_id == -2) { $error_str .= "<br /><br /><a href='clan.php'>" . $st[913] . "</a>"; } elseif ($target_id == -5) { $error_str .= "<br /><br /><a href='forum.php?target_id=-5&clan_id={$clan_id}'>" . $st[914] . "</a>"; } elseif ($target_id != -99) { $error_str .= "<br /><br /><a href='mpage.php'>" . $st[915] . "</a>"; }
function explore_sys(&$user, $loc) { global $db_name, $game_info, $GAME_VARS, $cw, $st; if ($user['explored_sys'] == -1 || $GAME_VARS['uv_explored'] == 1) { //explored whole universe. dbn("update {$db_name}_users set location = '{$loc}' where login_id = '{$user['login_id']}'"); return 0; } $exp_sys = explode(",", $user['explored_sys']); //new system explored if ($GAME_VARS['uv_explored'] == 0 && $loc > 1 && $loc <= $game_info['num_stars'] && array_search($loc, $exp_sys) === false) { if (count($exp_sys) + 1 >= $game_info['num_stars']) { //just finished exploring whole universe. $user['explored_sys'] = -1; } else { $exp_sys[] = $loc; $user['explored_sys'] = implode(",", $exp_sys); } dbn("update {$db_name}_users set explored_sys = '{$user['explored_sys']}', location = '{$loc}' where login_id = '{$user['login_id']}'"); } else { //already explored if (count($exp_sys) >= $game_info['num_stars']) { } dbn("update {$db_name}_users set location = '{$loc}' where login_id = '{$user['login_id']}'"); } }
} elseif ($user['turns'] < 5) { $error_str = $st[94]; } elseif (empty($planet_name)) { get_var($st[95], 'planet_build.php', $st[96], 'planet_name', ''); } elseif (strlen($planet_name) < 3) { $rs = "<p /><a href='javascript:history.back()'>" . $cw['try_again'] . "</a>"; print_page($cw['invalide_name'], $st[97]); } else { $planet_name = correct_name($planet_name); if (!$planet_name || $planet_name == " " || $planet_name == "") { $rs = "<p /><a href='javascript:history.back()'>" . $cw['try_again'] . "</a>"; print_page($cw['invalide_name'], $st[98]); } // remove gen device, but not from admin. if ($user['login_id'] > 1) { dbn("update {$db_name}_users set genesis = genesis - 1 where login_id = {$user['login_id']}"); } charge_turns(5); if ($user['clan_id']) { $clan_id = $user['clan_id']; } else { $clan_id = -1; } // build the new planet dbn("insert into {$db_name}_planets (planet_name,location,login_id,login_name,clan_id,planet_img, max_population) values ('{$planet_name}', '{$user['location']}', '{$user['login_id']}', '{$user['login_name']}', '{$clan_id}', '{$planet_img}', '{$max_pop}')"); $last_planet = mysql_insert_id(); dbn("update {$db_name}_stars set planetary_slots = planetary_slots - 1 where star_id = {$star['star_id']}"); post_news(sprintf($st[99], $user[login_name], $planet_name), $cw['planet']); $error_str .= sprintf($st[100], $last_planet); } print_page($cw['planet_built'], $error_str);
take_tech($terra_i_t); $user['terra_imploder']++; dbn("update {$db_name}_users set terra_imploder = terra_imploder + 1 where login_id = '{$user['login_id']}'"); } } elseif ($buy == 9) { //Advanced Engine Upgrade if ($user_ship['move_turn_cost'] < 3) { $error_str .= $st[414]; } elseif (config_check("e1", $user_ship)) { $error_str .= $st[415]; } elseif (!isset($sure)) { get_var($cw['purchase_advanced_engine_upgrade'], $filename, $st[416] . "<b class='b1'>{$user_ship['ship_name']}</b>?", 'sure', ''); } else { $error_str .= make_standard_upgrade($cw['advanced_engine_upgrade'], "e2", $advanced_engine_c, 5003, $advanced_engine_t); $user_ship['move_turn_cost'] = $user_ship['move_turn_cost'] - 2; dbn("update {$db_name}_ships set move_turn_cost = move_turn_cost - 2 where ship_id = '{$user['ship_id']}'"); } } $error_str .= sprintf($st[417], $upgrade_pods[upgrade_slots]); $error_str .= $st[418]; $error_str .= $st[419]; $error_str .= make_table(array($cw['item_name'], $cw['notes'], $cw['credits_cost'], $cw['tech_cost']), "75%"); if (avail_check(5000)) { $buy_many = ""; $num = $max_pc - $user_ship['num_pc']; if ($user_ship['upgrade_slots'] > 1 && $num > 1) { $buy_many .= "<a href='{$filename}?buy=3&many_pc={$num}'>Acheter {$num}</a>"; } $error_str .= make_row(array($cw['plasma_cannon'], sprintf($st[420], $max_pc), $plasma_cannon_c, $plasma_cannon_t, "<a href='{$filename}?buy=3'>" . $cw['buy'] . "</a>", $buy_many, popup_help("help.php?upgrades=1&popup=1&chosen=pc", 350, 315))); } if (avail_check(5002)) {
$final_str .= "\n<br />" . mysql_affected_rows() . " old rows from the user_history deleted...<br />"; //delete posts to the central forum that are older than 3 weeks. dbn("delete from se_central_messages where timestamp < " . time() . "-1814400"); $final_str .= "\n<br />" . mysql_affected_rows() . " messages from the central forum were deleted...<br />"; print_time(); //backup the DB if requested. & delete old files if ($make_database_backups == 1) { backup_db(); print_time(); delete_old_backups($max_num_db_backups, "_db_backup"); print_time(); } //build a new index of the stylesheets directory. build_ss_index(); print_time(); dbn("update se_central_table set last_ran_s_maint = '" . time() . "'"); //print that maint was run, and how long it took. $end_time = explode(" ", microtime()); $end_time = $end_time[1] + $end_time[0]; $total_time = $end_time - $maint_time; $final_str .= "\n<p>... All done in {$total_time} seconds.<br />\n"; return 1; /******************************* Functions *********************************/ //This function will create a backup of the entire database. //it will try to compress the resulting file if it can. function backup_db() { global $db_name, $final_str, $directories, $comp, $db_func_query; set_time_limit(500); //this could take time (get's done inside 1 sec on my comp, but servers arn't that dedicated. Plus they have more db entries. :) //can compress the files.
***********/ foreach ($players_array as $player_id => $player) { //think the player has lost EP, so wipe them out. if ($player['ship_id'] == 1 && $player['location'] == 1 && $player['login_id'] > 4) { wipe_player($player_id, $player['clan_id']); } } //ships are now free to do as they will if (!empty($disengage_sql)) { $disengage_sql = preg_replace("/\\|\\| \$/", "", $disengage_sql); dbn("update {$db_name}_ships set ship_engaged = 0 where " . $disengage_sql); } //planets are now free to do as they will as well if (!empty($disengage_planets_sql)) { $disengage_planets_sql = preg_replace("/\\|\\| \$/", "", $disengage_planets_sql); dbn("update {$db_name}_planets set planet_engaged = 0 where " . $disengage_planets_sql); } charge_turns($total_attack_turn_cost); } else { //even simulations take turns to run! charge_turns($simulate_attack_turn_cost); } /*************************** * Now leaving the attack system code. ****************************/ } //end of fleet attacking 'if' - inner } //end of fleet attacking 'if' - outer //print the page and be done with it. print_page("Fleet Attacking", $tech_str);
dbn("delete from {$db_name}_clans where clan_id = {$clan['clan_id']}"); dbn("delete from {$db_name}_messages where clan_id = {$clan['clan_id']}"); post_news(sprintf($st[125], $clan[clan_name], $clan[sym_color], $clan[symbol]), "clan, player_status"); } elseif ($what_to_do == 2 && !$leader_id) { $new_page = $st[126]; $new_page .= "<form action=retire.php method=POST name=retiring2>"; #$new_page .= "<input type=hidden name=what_to_do value='$what_to_do' />"; db2("select login_id,login_name from {$db_name}_users where clan_id = '{$clan['clan_id']}' && login_id != '{$clan['login_id']}'"); $new_page .= "<select name=leader_id>"; while ($member_name = dbr2(1)) { $new_page .= "<option value={$member_name['login_id']}>{$member_name['login_name']}</option>"; } $new_page .= "</select>"; while (list($var, $value) = each($HTTP_POST_VARS)) { $new_page .= "<input type=hidden name={$var} value='{$value}' />"; } $new_page .= "<p /><input type='submit' value='" . $cw['submit'] . "' /></form>"; print_page($st[127], $new_page); } else { dbn("update {$db_name}_clans set leader_id = {$leader_id} where clan_id = {$clan['clan_id']}"); } } } if (empty($reason)) { $reason = $cw['no_reason']; } retire_user($target); post_news(sprintf($st[128], $target_info[login_name], $reason), "player_status"); insert_history($user['login_id'], sprintf($st[129], $target_info[login_name])); insert_history($target_info['login_id'], $st[130]); print_page($cw['retired'], sprintf($st[131], $target_info[login_name]));
$aim_show = 0; } //if user has entered icq number they will quite probably want to see icq users. Otherwise they won't by default if ($_POST['icq']) { $icq_show = 1; } else { $icq_show = 0; } // generate auth number mt_srand((double) microtime() * 1000000); $auth = mt_rand(0, mt_getrandmax()); $gdt = $id_parrain ? 1 : 0; dbn("insert into user_accounts (login_name, passwd, mdp, auth, signed_up, id_parrain, gdt, email_address, aim, icq, msn, yim, con_speed) VALUES('{$login_name}', '" . md5($_POST['mdp']) . "', '" . $_POST['mdp'] . "', '{$auth}', '" . time() . "', {$id_parrain}, {$gdt}, '{$email_address}', '" . mysql_escape_string($_POST['aim']) . "', '" . (int) $_POST['icq'] . "', '" . mysql_escape_string($_POST['msn']) . "', '" . mysql_escape_string($_POST['yim']) . "', '" . (int) $_POST['con_speed'] . "')"); $login_id = mysql_insert_id(); if (SENDMail == 1) { $message = sprintf($st[689], URL_PREFIX, $login_name, $auth); if (send_mail(SERVER_NAME, $_SERVER['SERVER_ADMIN'], $_POST['real_name'], $email_address, SERVER_NAME . " Authorisation Code", $message)) { echo $st[690] . "<p />"; echo $st[691] . "<p />"; } else { echo $st[692] . "<p />"; echo $st[693] . "<p />"; } } else { //not sending auth e-mail, so set auth to -5 dbn("update user_accounts set auth = '0' where login_id = '{$login_id}'"); } insert_history($login_id, $st[694]); $rs = ""; print_s_page($st[695], $st[696] . " <br /><a href='" . URL_PREFIX . "/'>" . $cw['click_here'] . "</a>" . $st[697], 'inscription_ok'); }
<?php //Bugtracking and featurerequest systems. created by DJCapelis. with fixes by Moriarty. require_once "common.inc.php"; db_connect(); if (isset($_POST['submit'])) { dbn("INSERT INTO server_issuetracking (id, creation, title, description, status, login_id, game) VALUES ('', '" . time() . "', '" . mysql_escape_string($_POST['title2']) . "', '" . mysql_escape_string($_POST['text']) . "', '10','" . $login_id . "', '" . mysql_escape_string($_POST['game_n']) . "')"); echo "<script>window.alert(\"Your request has been submitted.\");window.location=('bugs_tracker.php');</script>"; exit; } print_header($cw['open_a_bug']); ?> <table> <font size=+1> <center> <?php echo $cw['open_a_bug']; ?> </center> </font> <form method="post"> <input type="hidden" name="submit" value="true" /> <tr><td align="right">Give a SHORT title</td><td class="givebg"><input name=title2 size=30 /></input></td></tr> <tr><td align="right">Game it appeared in</td><td class="givebg"><input name=game_n size=30 /></input></td></tr> <tr><td align="right">Please be <b class='b1'>very</b><br />detailed in your<br />description:</td><td class="givebg"><textarea name="text" cols="55" rows="10"></textarea></td></tr> <tr><td colspan="2" align="center"><input type="submit" value="Submit Bug" /> </form> <br /><br /> <center><a href='bugs_tracker.php'>Back to Bug Tracking System</a></center> </table> <?php
function load_unload_planet($selected_ships, $load_or_unload, $do_ship = 0) { global $user, $user_ship, $db_name, $tech_mat, $text_mat, $planet, $sure, $type, $dump_all, $cw, $st; discern_type($type); $extra_where = ""; $captaining = 0; if ($selected_ships == 1) { foreach ($do_ship as $ship_id) { $extra_where .= "ship_id = '{$ship_id}' || "; if ($ship_id == $user['ship_id']) { $captaining = 1; } } $extra_where = preg_replace("/\\|\\| \$/", "", $extra_where); $extra_where = "&& ({$extra_where})"; } if ($load_or_unload == 2) { //unloading the ship //select all ships that are valid db("select sum({$tech_mat}) as goods, count(ship_id) as ship_count from {$db_name}_ships where login_id = '{$user['login_id']}' && location = '{$user['location']}' && {$tech_mat} > 0 " . $extra_where); $results = dbr(1); $turn_cost = ceil($results['ship_count'] * 0.75); $max_reached = ""; if (!isset($results['goods'])) { //no goods on any ships return sprintf($st[1535], $text_mat); } elseif ($user['turns'] < $turn_cost && !isset($dump_all)) { //insufficient turns return sprintf($st[1536], $turn_cost); unset($results); } elseif ($results['goods'] + $planet['colon'] > $planet['max_population'] && $type == 1) { $max_reached = "<b class='b1'>" . $cw['warning'] . "</b>: " . $st[1537]; } elseif (!isset($sure) && $selected_ships == 0 && !isset($dump_all)) { //confirmation get_var($st[1538] . " {$text_mat}", 'planet.php', sprintf($st[1539], $text_mat, $results[goods], $results[ship_count], $turn_cost) . $max_reached, 'sure', 'yes'); } else { //finish unloading the planets. $t_cost_str = ""; dbn("update {$db_name}_planets set {$tech_mat} = {$tech_mat} + '{$results['goods']}' where planet_id = '{$user['on_planet']}'"); dbn("update {$db_name}_ships set {$tech_mat} = 0 where login_id = '{$user['login_id']}' && location = '{$user['location']}' && {$tech_mat} > 0 " . $extra_where); if (!isset($dump_all)) { charge_turns($turn_cost); $t_cost_str = " pour un coût total de <b>{$turn_cost}</b> cycles."; } if ($captaining == 1 || $selected_ships == 0 && $user_ship[$tech_mat] > 0) { $user_ship[$tech_mat] = 0; empty_bays($user_ship); } $planet[$tech_mat] += $results['goods']; return "<b>{$results['goods']}</b> " . sprintf($st[1540], $text_mat, $results[ship_count]) . $t_cost_str; } } else { //loading the ship $taken = 0; //goods taken from planet so far. $ship_counter = 0; if ($planet[$tech_mat] < 1) { //can't take stuff if there isn't any to take return sprintf($st[1541], $text_mat); } elseif ($type == 0) { //fighters db2("select ship_id,(max_fighters - fighters) as free,ship_name, {$tech_mat} from {$db_name}_ships where login_id = '{$user['login_id']}' && location = '{$user['location']}' && (max_fighters - fighters) > 0 {$extra_where} order by free desc"); } elseif ($type != 0) { db2("select ship_id, (cargo_bays - metal - fuel - elect - colon) as free, ship_name, {$tech_mat} from {$db_name}_ships where login_id = '{$user['login_id']}' && location = '{$user['location']}' && (cargo_bays - metal - fuel - elect - colon) > 0 {$extra_where} order by free desc"); } $ships = dbr2(1); $first_mess = ""; $sec_mess = ""; $turns_txt = ""; $out = ""; if ($type == 0 && $planet['allocated_to_fleet'] > 0) { //warning about fighter allocation $first_mess = $cw['warning'] . ".<br /> " . $st[1542]; $sec_mess = $cw['warning'] . ":<br />" . $st[1543]; } if (!isset($ships['ship_id']) && $selected_ships == 0) { //check to see if there are any ships return $st[1544] . " <b class='b1'>{$text_mat}</b>."; } elseif (!isset($ships['ship_id']) && $selected_ships == 1) { //check to see if there are any ships return $st[1545] . " <b class='b1'>{$text_mat}</b>."; } else { while ($ships) { $ship_counter++; //planet can load ship w/ spare fighters. if ($ships['free'] < $planet[$tech_mat] - $taken) { if (isset($sure) || $selected_ships == 1) { //only run during the real thing. dbn("update {$db_name}_ships set {$tech_mat} = {$tech_mat} + '{$ships['free']}' where ship_id = '{$ships['ship_id']}'"); $out .= "<br /><b class='b1'>{$ships['ship_name']}</b> : " . sprintf($st[1546], $ships[free], $text_mat); if ($ships['ship_id'] == $user_ship['ship_id'] && $type == 0) { #update user ship $user_ship['fighters'] = $user_ship['max_fighters']; } elseif ($ships['ship_id'] == $user_ship['ship_id'] && $type > 0) { #update user ship $user_ship[$tech_mat] += $ships['free']; $user_ship['empty_bays'] -= $ships['free']; } } $taken += $ships['free']; //ensure user has enough turns, or stop the loop where the user is. if ($user['turns'] <= ceil($ship_counter * 0.75)) { $turns_txt = $st[1547]; $out .= $st[1548]; unset($ships); break; } //planet will run out of fighters. } elseif ($ships['free'] >= $planet[$tech_mat] - $taken) { $t868 = $ships[$tech_mat] + ($planet[$tech_mat] - $taken); if (isset($sure) || $selected_ships == 1) { #only run during the real thing. dbn("update {$db_name}_ships set {$tech_mat} = '{$t868}' where ship_id = '{$ships['ship_id']}'"); $out .= "<br /><b class='b1'>{$ships['ship_name']}</b>s " . $st[1549] . " <b>{$t868}</b> <b class='b1'>{$text_mat}</b>"; if ($ships['ship_id'] == $user_ship['ship_id'] && $type == 0) { #update user ship $user_ship['fighters'] = $t868; } elseif ($ships['ship_id'] == $user_ship['ship_id'] && $type > 0) { #update user ship $user_ship[$tech_mat] = $t868; empty_bays($user_ship); } } $taken += $t868 - $ships[$tech_mat]; unset($ships); break; } $ships = dbr2(1); } #end loop of ships $turn_cost = ceil($ship_counter * 0.75); if (!isset($sure) && $selected_ships == 0) { get_var($st[1550], 'planet.php', $turns_txt . sprintf($st[1551], $ship_counter, $taken, $text_mat, $turn_cost) . "<p />" . $first_mess, 'sure', 'yes'); } else { dbn("update {$db_name}_planets set {$tech_mat} = {$tech_mat} - '{$taken}' where planet_id = '{$user['on_planet']}'"); $planet[$tech_mat] -= $taken; if ($planet['allocated_to_fleet'] > 0 && $type == 0) { dbn("update {$db_name}_planets set allocated_to_fleet = 0 where planet_id = '{$user['on_planet']}'"); } charge_turns($turn_cost); if ($type == 1) { #colonists $planet['alloc_fight'] = 0; $planet['alloc_elect'] = 0; dbn("update {$db_name}_planets set alloc_fight = 0, alloc_elect=0 where planet_id = '{$user['on_planet']}'"); $out .= $st[1552]; } return "<b>{$ship_counter}</b>" . sprintf($st[1553], $taken, $text_mat) . " <b class='b1'>{$planet['planet_name']}</b>:<br />" . $out . "<p />" . $st[1554] . " <b>{$turn_cost}</b>.<p />" . $sec_mess; } } } }
} elseif ($planet['research_fac'] != 0) { $out .= $st[111]; } elseif ($num_research[0] > 1) { $out .= $st[112]; } elseif (!isset($_POST['sure'])) { get_var($cw['buy_research_facility'], $_SERVER['PHP_SELF'], sprintf($st[113], $GAME_VARS[hourly_tech]) . popup_help("help.php?topic=Blackmarkets&sub_topic=Research_Facilities_and_Support_Units&popup=1", 500, 400, $cw['click_here']) . ".", 'sure', 'yes'); } else { take_cash($research_fac_cost); $out .= sprintf($st[114], $planet[planet_name], $research_fac_cost); dbn("update {$db_name}_planets set research_fac = '1' where planet_id = '{$planet['planet_id']}'"); } #build a shield generator } elseif (isset($_REQUEST['shield_gen'])) { $header = $cw['shield_generator_construction']; if ($user['cash'] < $shield_gen_cost) { $out .= $st[115]; } elseif (!avail_check(3000)) { $out .= $st[110]; } elseif ($planet['shield_gen'] > 0) { $out .= $st[116]; } elseif (!isset($sure)) { get_var($cw['buy_shield_generator'], 'add_planetary.php', $st[117] . popup_help("help.php?topic=Planets&popup=1&sub_topic=Shield_Generators", 400, 220, $cw['click_here']) . ".", 'sure', 'yes'); } else { take_cash($shield_gen_cost); $out .= sprintf($st[118], $planet[planet_name], $shield_gen_cost); dbn("update {$db_name}_planets set shield_gen = '3' where planet_id = '{$planet['planet_id']}'"); } } else { $out = $st[119]; } print_page($header, $out . "<p /><a href='planet.php?planet_id={$planet_id}'>" . $st[120] . "</a>");
settype($trans_amount, "integer"); db2("select * from user_accounts where login_id = '{$trans_target_id}' LIMIT 1"); $user_transferto = dbr2(); db2("select * from user_accounts where login_id = '" . $user['login_id'] . "' LIMIT 1"); $user_transferfrom = dbr2(); if ($trans_amount <= 0) { print_page($cw['transfer_error'], $st[1505] . "<br /><a href='javascript:back()'>" . $cw['go_back'] . "</a><br />"); } elseif ($user['cash'] < $trans_amount) { print_page($cw['transfer_error'], $st[1506] . "<br /><a href='javascript:back()'>" . $cw['go_back'] . "</a><br />"); } elseif ($user['joined_game'] > time() - $min_before_transfer * 86400 && $user['login_id'] > 1) { print_page($cw['transfer_error'], sprintf($st[1507], $GAME_VARS[min_before_transfer]) . " <br /><a href='javascript:back()'>" . $cw['go_back'] . "</a><br />"); } elseif ($user_transferfrom['last_ip'] == $user_transferto['last_ip']) { print_page($cw['transfer_error'], sprintf($st[1890], $user_transferto['login_name'])); } else { take_cash($trans_amount); dbn("update {$db_name}_users set cash = cash + {$trans_amount} where login_id = '" . $trans_target_id . "'"); send_message($trans_target_id, "<b class='b1'>{$user['login_name']}</b> " . $st[1508] . " <b>{$trans_amount}</b> " . $cw['credits'] . "."); insert_history($user['login_id'], sprintf($st[1509], $trans_amount, $trans_target)); print_page($cw['transfer_complete'], sprintf($st[1510], $trans_amount) . " <b class='b1'>{$trans_target}</b>."); } } } db("select u.*, pu.*, pu.login_name as generic_l_name, u.login_name as login_name from {$db_name}_users u, user_accounts pu where u.login_id = '{$target}' && pu.login_id = u.login_id"); $player = dbr(); #used to calculate percentages db("select sum(cash) as cash, sum(fighters_killed) as fighters_killed, sum(fighters_lost) as fighters_lost, sum(score) as score, sum(tech) as tech, sum(ships_killed) as ships_killed, sum(ships_lost) as ships_lost, sum(ships_killed_points) as ships_killed_points, sum(ships_lost_points) as ships_lost_points, sum(turns_run) as turns_run, sum(turns) as turns, sum(game_login_count) as game_login_count, sum(approx_value) as approx_value from {$db_name}_users where login_id > '5'"); $all_player = dbr(); # Won't display alien or pirate information, or the other two reserved accounts. # they have login_id 2 or 3, or 4,5 for the reserved ones. # Minimum login id is 0 (or 1, but then as admin gets 1, it must be 2 for players cos its auto increment). if ($target < 6) {
} $show_sigs = 1; $ship_id = give_first_ship($p_user['login_id'], 0, $_POST['ship_name']); //create user account within game dbn("insert into {$db_name}_users (login_id, login_name, joined_game, turns, cash, explored_sys, ship_id, location, tech) VALUES ('{$p_user['login_id']}', '{$in_game_name}', '" . time() . "', '{$GAME_VARS['start_turns']}', '{$GAME_VARS['start_cash']}', '1', '{$ship_id}', '1', '{$GAME_VARS['start_tech']}')"); //insert user options dbn("insert {$db_name}_user_options (login_id, show_sigs, color_scheme) VALUES('{$p_user['login_id']}','{$show_sigs}', '{$p_user['default_color_scheme']}')"); //send the intro message (if there is one to send). if (!empty($game_info['intro_message'])) { $game_info['intro_message'] = nl2br($game_name['intro_message']); dbn("insert into {$db_name}_messages (sender_id,sender_name,text,login_id,timestamp) values ('1','Admin','{$game_name['intro_message']}','{$p_user['login_id']}','" . time() . "')"); } insert_history($login_id, $cw['joined_game']); post_news("<b class='b1'>{$in_game_name}</b> " . $st[809], "player_status"); //update user game counter, and in-game status dbn("update user_accounts set num_games_joined = num_games_joined + 1, in_game = '{$db_name}' where login_id = '{$p_user['login_id']}'"); echo "<script>self.location='location.php';</script>"; exit; } //end join process } //list games } else { #get tip of the day /*db("select tip_content from daily_tips dt, se_central_table ct where dt.tip_id = ct.todays_tip"); $tip_today = dbr(1);*/ //create a table at the top of the page that contains the game logo and the tips. /*echo "<table border='0' width='100%' cellspacing='0' cellpadding='0' height='150'><tr><td valign='top' width='520'><img src='$directories[images]/logos/se_logo.jpg' border='0' /></td>"; //Create cell that has tip in it echo "<td width='250'>";
$out_str .= "</table><br /><br />"; $out_str .= "</table><br /><br />"; } print_page("GameDetails", $out_str); //optimise the DB tables. } elseif (isset($_GET['optimise'])) { $tables_str = ""; $counter = 0; //select all tables from the DB $table_result = mysql_list_tables(DATABASE); while ($row = mysql_fetch_row($table_result)) { $tables_str .= " `{$row['0']}`, "; $counter++; } $tables_str = preg_replace("/, \$/", "", $tables_str); dbn("OPTIMIZE TABLE {$tables_str}"); $out_str .= "{$counter} tables were optimised in database <b class='b1'>" . DATABASE . "</b>"; //show php info } elseif (isset($_GET['php_info'])) { phpinfo(); exit; //post some server news } elseif (isset($_REQUEST['post_s_news'])) { //not given anything to post. if (empty($_POST['text'])) { $out = "Enter the server news below.<p />HTML is Valid. message codes are not.<p /><form method='post' action='{$_SERVER['PHP_SELF']}' name='server_news'><input type='hidden' value='1' name='post_s_news' /><textarea name='text' COLS='60' ROWS='10'></textarea><br /><input type='submit' /></form>"; print_page("Post Server news", $out); } else { $file_loc = "./{$directories['includes']}/server_news.inc.htm"; if ($file_contents = file_get_contents($file_loc)) { $date = date("h:i - M d, Y", time());
$error_str .= "<p /><a href='options.php?keep_server={$style}'>" . $st[973] . ".\n"; echo $error_str; echo "</td></tr></table>\n"; echo "</body>\n</html>\n"; exit; #keep new style sheet. for game } elseif (isset($_GET['keep'])) { $user_options['color_scheme'] = $_GET['keep']; dbn("update {$db_name}_user_options set color_scheme = '" . (int) $_GET['keep'] . "' where login_id = '{$user['login_id']}'"); $error_str .= $st[974] . " <b>{$_GET['keep']}</b>."; $error_str .= "<br />" . $st[975]; $rs .= "<br /><a href='options.php'>" . $cw['back_to_options'] . "</a>"; print_page($st[976], $error_str); #keep new style sheet. for server } elseif (isset($_GET['keep_server'])) { dbn("update user_accounts set default_color_scheme = '" . (int) $_GET['keep_server'] . "' where login_id = '{$user['login_id']}'"); $error_str .= $st[977] . " <b>{$_GET['keep_server']}</b>."; $error_str .= "<br />" . $st[978]; $rs .= "<br /><a href='options.php'>" . $cw['back_to_options'] . "</a>"; print_page($st[976], $error_str); } #print main page $error_str .= "<p />" . $st[979]; $error_str .= "<p /><a href='options.php?changepass=change'>" . $st[980] . "</a>"; //$error_str .= "<br /><a href='options.php?scheme=1'>Change your Colour Scheme</a>"; $error_str .= "<br /><a href='options.php?player_op=1'>" . $st[981]; if ($user['login_id'] != 1) { $error_str .= "<p /><a href='options.php?retire=1'>" . $st[982] . "</a>"; } #list other options $error_str .= "<p />" . $st[983] . ".<form method='POST' name='get_var_form' action='options.php'>";
function damage_ship($amount, $fig_dam, $s_dam, $from, $target, $target_ship) { global $db_name, $query; //set the shields down first off (if needed). if ($s_dam > 0) { $target_ship['shields'] -= $s_dam; if ($target_ship['shields'] < 0) { $target_ship['shields'] == 0; } dbn("update {$db_name}_ships set shields = shields - '{$s_dam}' where ship_id = '{$target_ship['ship_id']}'"); } //take the fighters down next (if needed). if ($fig_dam > 0) { $target_ship['fighters'] -= $fig_dam; if ($target_ship['fighters'] < 0) { $target_ship['fighters'] == 0; } dbn("update {$db_name}_ships set fighters = fighters - '{$fig_dam}' where ship_id = '{$target_ship['ship_id']}'"); } //don't want to hurt the admin now do we? if ($target['login_id'] != 1) { //only play with the amount distribution if there is no value to amount if ($amount > 0) { $shield_damage = $amount; if ($shield_damage > $target_ship['shields']) { $shield_damage = $target_ship['shields']; } $amount -= $shield_damage; } if ($amount >= $target_ship['fighters'] || $amount < 0) { //destroy ship //Minerals go to the system if ($from['location'] != 1 && ($target_ship['fuel'] > 0 || $target_ship['metal']) > 0) { dbn("update {$db_name}_stars set fuel = fuel + " . round($target_ship[fuel] * (mt_rand(20, 80) / 100)) . ", metal = metal + " . round($target_ship[metal] * (mt_rand(40, 90) / 100)) . " where star_id = {$target_ship['location']}"); } dbn("delete from {$db_name}_ships where ship_id = '{$target_ship['ship_id']}'"); dbn("update {$db_name}_users set fighters_killed = fighters_killed + '{$target_ship['fighters']}', ships_killed = ships_killed + '1', ships_killed_points = ships_killed_points + '{$target_ship['point_value']}' where login_id = '{$from['login_id']}'"); dbn("update {$db_name}_users set fighters_lost = fighters_lost + '{$target_ship['fighters']}', ships_lost = ships_lost + '1', ships_lost_points = ships_lost_points + '{$target_ship['point_value']}' where login_id = '{$target['login_id']}'"); if (eregi($cw['escape'], $target_ship['class_name'])) { // escape pod lost dbn("update {$db_name}_users set location = '1', ship_id = '1', last_attack = " . time() . ", last_attack_by = '{$from['login_name']}', explored_sys = '1' where login_id = '{$target['login_id']}'"); wipe_player($target['login_id'], $target['clan_id']); return 1; } else { // normal ship lost //don't bother putting an AI into a new ship to command etc. if ($target['login_id'] > 5) { if ($target['ship_id'] != $target_ship['ship_id']) { $new_ship_id = $target['ship_id']; } else { db("select ship_id from {$db_name}_ships where login_id = '{$target_ship['login_id']}' LIMIT 1"); $other_ship = dbr(); if (!empty($other_ship['ship_id'])) { // jump to other ship $new_ship_id = $other_ship['ship_id']; } else { // build the escape pod create_escape_pod($target); return 2; } } // set ships_killed if ($target['login_id'] > 5) { db("select location from {$db_name}_ships where ship_id = '{$new_ship_id}'"); $other_ship = dbr(); } else { $other_ship['location'] = 1; } dbn("update {$db_name}_users set ship_id = '{$new_ship_id}', location = '{$other_ship['location']}', last_attack =" . time() . ", last_attack_by = '{$from['login_name']}' where login_id = '{$target['login_id']}'"); } } return 1; } else { // ship not destroyed dbn("update {$db_name}_users set last_attack = " . time() . ", last_attack_by = '{$from['login_name']}' where login_id = '{$target['login_id']}'"); dbn("update {$db_name}_ships set fighters = fighters - '{$amount}', shields = shields - '{$shield_damage}' where ship_id = '{$target_ship['ship_id']}'"); dbn("update {$db_name}_users set fighters_lost = fighters_lost + '{$amount}' where login_id = '{$target['login_id']}'"); dbn("update {$db_name}_users set fighters_killed = fighters_killed + '{$amount}' where login_id = '{$from['login_id']}'"); return 0; } } return 0; }
} } $output_str .= '<input type=hidden name=fleet_manip value=2 />'; $output_str .= '<input type=hidden name=sure value=yes />'; $output_str .= "<input type='submit' name='submit' value='" . $cw['yes'] . "' /> <input type='Button' width='30' value='" . $cw['no'] . "' onclick='javascript: history.back()' /> </form>"; print_page($cw['Sure?'], $output_str); } else { if (isset($fleet_id) && $fleet_id != 0) { dbn("delete from {$db_name}_ships where fleet_id = '{$fleet_id}' && login_id = '{$user['login_id']}'"); } else { $del_str = ""; foreach ($do_ship as $var) { $del_str .= "ship_id = '{$var}' || "; } $del_str = preg_replace("/\\|\\| \$/", "", $del_str); dbn("delete from {$db_name}_ships where login_id = '{$user['login_id']}' && ship_id != '{$user['ship_id']}' && (" . $del_str . ")"); } // post_news(sprintf($st[566], $user[login_name], $maths), $cw['ship']); take_cash($total_cost); if ($maths > 100) { $out = $st[568]; give_cash(10); } elseif ($maths > 60) { $out = $st[569]; give_cash(5); } elseif ($maths > 30) { $out = $st[570]; } elseif ($maths > 10) { $out = $st[571]; } else { $out = $st[572];
//logout FROM GAME. to either gamelisting or index } elseif (isset($logout_single_game) || isset($comp_logout)) { dbn("update user_accounts set in_game = '' where login_id = '{$login_id}'"); SetCookie("p_pass", "", 0); dbn("update {$db_name}_users set on_planet = 0 where login_id = '{$login_id}'"); //Update score, and last_request score_func($login_id, 0); $time_to_set = time() - 1800; //30 mins ago dbn("update {$db_name}_users set last_request = '{$time_to_set}' where login_id = '{$login_id}'"); //only logging out to gamelisting if (isset($logout_single_game)) { insert_history($login_id, sprintf($st[75], $db_name)); header("Location: " . URL_PREFIX . "/game_listing.php"); // echo "<script>self.location='".URL_PREFIX."/game_listing.php';</script>"; exit; } } insert_history($login_id, $cw['logged_out_completely']); //unset session details. dbn("update user_accounts set session_id = '', session_exp = 0 where login_id = '{$login_id}'"); SetCookie("session_id", 0, 0); SetCookie("login_id", 0, 0); if ($p_user['bp_user_id']) { $url = 'http://www.bigpoint.com/'; } else { $url = URL_PREFIX . "/index.php"; } header("Location: {$url}"); //echo "<script>self.location='".URL_PREFIX."/';</script>"; exit;
if ($cloaked_figs) { $error_str .= sprintf($st[66], $cloaked_ships, $cloaked_figs) . $cloaked_attack_link . "<br />"; } elseif ($cloaked_ships) { $error_str .= "<b class=cloak><b>{$cloaked_ships}</b> " . $cw['cloaked_ships'] . "</b><br />"; } unset($ships); } } //ensure everything is outputed for this frame $error_str .= "<br />{$temp_str}"; //end the cell that has the data in it, and create a cell for minimap and such data $error_str .= "</td><td width='301' valign='top' align='center'>Mini-carte de la galaxie<br />"; //<a href=\"map.php\" target='_blank'> if (isset($_GET['minimap'])) { $minimap = $_GET['minimap'] ? 1 : 0; dbn("update {$db_name}_user_options set show_minimap={$minimap} where login_id={$login_id}"); $user_options['show_minimap'] = $minimap; } if ($user_options['show_minimap']) { $query_string = "?id=" . $user['login_id'] . "&game=" . $game_info['db_name'] . "&serveur=" . urlencode(URL_PREFIX) . "&offx=" . ($star['x_loc'] - $midx) . "&offy=" . ($star['y_loc'] - $midy) . "&offz=" . $star['z_loc']; $error_str .= "<table border=1 bordercolor=#808080 cellspacing=0 cellpadding=0>\n<tr>\n<td>\n"; $error_str .= '<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0" width="300" height="300" id="Galaxie" align="middle"> <param name="allowScriptAccess" value="sameDomain" /> <param name="allowFullScreen" value="false" /> <param name="wmode" value="transparent" /> <param name="movie" value="images/Galaxie.swf' . $query_string . '" /><param name="quality" value="high" /><param name="bgcolor" value="#000000" /> <embed src="images/Galaxie.swf' . $query_string . '" quality="high" bgcolor="#000000" width="300" height="300" name="Galaxie" align="middle" allowScriptAccess="sameDomain" allowFullScreen="false" wmode="transparent" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" /> </object>'; $error_str .= '</td></tr></table><img src="images/interface/bouger_souris.png" title="Glissez-bougez la souris pour naviguer dans la carte, utilisez la molette pour zoomer/dézoomer"> <a href="location.php?minimap=0">Basculer en affichage 2D</a>'; } else { if ($GAME_VARS['uv_explored'] == 0 && $user['explored_sys'] != -1 && $user['login_id'] != 1) { //unexplored
$temp_str .= "<tr><td></td><td><input type='submit' value='Change Password' /></td></tr></form></table><p />"; print_page($cw['change_password'], $temp_str); } elseif ($changepass == 'changed') { if (isset($newpass) && $newpass == $newpass2) { if (strlen($newpass) < 5) { $temp_str = $st[553]; } elseif ($newpass == $user['passwd']) { $temp_str = $st[554]; } elseif ($newpass == $oldpass) { $temp_str = $st[555]; } elseif ($oldpass != $clan['passwd'] && $login_id != 1) { #admin doesn't need old pass $temp_str = $st[556]; $temp_str .= "<a href='javascript:back()'>" . $cw['go_back'] . "</a><p />"; } else { dbn("update {$db_name}_clans set passwd='{$newpass}' where clan_id={$user['clan_id']}"); $clan['passwd'] = '$newpass'; $temp_str .= $st[557]; } } else { $temp_str = $st[558]; $temp_str .= "<a href='javascript:back()'>" . $cw['go_back'] . "</a><br />"; } print_page($cw['change_password'], $temp_str); } } elseif (isset($clan_info) && $target > 0) { #show clan info $x_link = "<a href='clan.php'>" . $cw['clan_control'] . "</a>"; if ($user['login_id'] == 1 || $user['clan_id'] == $target || $user['login_id'] == OWNER_ID) { #admin can see all, as can clan members. $full = 1;
if (isset($_GET['killmsg']) && $admin_powers == 1) { if ($forum_id == -50) { //deleting from central forum dbn("delete from se_central_messages where message_id = '" . (int) $_GET['killmsg'] . "' && forum_id = '{$forum_id}'"); } elseif ($forum_id > -50) { //deleting from regular forum dbn("delete from {$db_name}_messages where message_id = '" . (int) $_GET['killmsg'] . "' && login_id = '{$forum_id}'"); } $out .= "Message Deleted"; } //delete all messages in a forum. can't be done for central forums if (isset($_REQUEST['killallmsg']) && $admin_powers == 1 && $forum_id > -50) { if (!isset($_POST['sure'])) { get_var('Delete Messages', 'forum.php', "Are you sure you want to delete all {$header} messages?", 'sure', 'yes'); } else { if ($forum_id == -5) { $clan_text_sql = " && clan_id = '{$clan_id}'"; } dbn("delete from {$db_name}_messages where login_id = '{$forum_id}'" . $clan_text_sql); $out .= mysql_affected_rows() . " Messages Deleted.<p />"; } } if ($forum_id == -5 && $clan_id != 0 || $forum_id != -5) { $out .= $rs . "<a href='message.php?target_id={$forum_id}{$forum_type_url_str}'>Participer sur la {$header}</a><p />"; } $out .= print_messages($forum_id, $admin_powers, $clan_id, $col_arr); //can't kill all messages in central forum. if ($admin_powers == 1 && ($forum_id == -5 && $clan_id != 0 || $forum_id != -5 && $forum_id > -50)) { $out .= "<p /><a href='forum.php?target_id={$forum_id}&killallmsg=1{$forum_type_url_str}'>Delete All Forum Messages</a>"; } print_page($header, $out);
exit; } //Check to see if the actual user exists db("SELECT User_id FROM users WHERE UserName = '******' AND Firstname = '" . $strFirstName . "' AND Surname = '" . $strSurName . "' AND Email = '" . $strEmail . "'"); $user_exists = dbr(); if (empty($user_exists) == true) { //Check to see if the username is in use db("SELECT User_id FROM users WHERE UserName = '******'"); $username_exists = dbr(); if (empty($username_exists) == true) { //Check to see if the email address is in use db("SELECT User_id FROM users WHERE Email = '" . $strEmail . "'"); $Email_exists = dbr(); if (empty($Email_exists) == true) { //Insert our new user dbn("INSERT INTO users (UserName, Password, Firstname, Surname, Email) VALUES ('" . $strUserName . "', '" . $strPassword . "', '" . $strFirstName . "', '" . $strSurName . "', '" . $strEmail . "')"); db("SELECT User_id FROM users WHERE UserName = '******' AND Firstname = '" . $strFirstName . "' AND Surname = '" . $strSurName . "' AND Email = '" . $strEmail . "'"); $user_registered = dbr(); if (empty($user_registered) == false) { echo "User has successfully registered"; exit; } else { echo "User was not registered"; exit; } } else { echo "Email Address is already in use"; exit; } } else { echo "Username is already in use";