Example #1
0
                $extra_text = "<br />" . $st[42];
                $news_text_extra = sprintf($st[43], $user[login_name], $user_ship[colon]);
            } elseif ($temp == 1) {
                $extra_text = "<br />" . $st[44];
                $news_text_extra = sprintf($st[45], $user[login_name], $user_ship[colon]);
            } elseif ($temp == 2) {
                $extra_text = "<br />" . $st[46];
                $news_text_extra = sprintf($st[47], $user_ship[colon], $user[login_name]);
            } elseif ($temp == 3) {
                $extra_text = "<br />" . $st[48];
                $news_text_extra = sprintf($st[49], $user[login_name], $user_ship[colon]);
            } elseif ($temp == 4) {
                $extra_text = "<br />" . $st[50];
                $news_text_extra = sprintf($st[51], $user[login_name], $user_ship[colon]);
            }
            post_news($news_text_extra, "other, player_status");
        }
        dbn("update {$db_name}_ships set metal=0, fuel=0, elect=0, colon=0 where ship_id = '{$user_ship['ship_id']}'");
        $user_ship['metal'] = 0;
        $user_ship['fuel'] = 0;
        $user_ship['elect'] = 0;
        $user_ship['colon'] = 0;
        empty_bays($user_ship);
        $user_loc_message .= $cw['cargo_jettisoned'] . ". \n{$extra_text}<p />";
    }
}
if ($_GET['tempo']) {
    if (!$user['gdt']) {
        $user_loc_message .= "<p>" . $st[1801] . "</p>";
    } else {
        $cyclesenp = mt_rand(50, 150);
Example #2
0
        dbn("delete from {$db_name}_diary where login_id != 1" . $owner_txt);
        $out .= "Diaries erased.<br />";
        dbn("delete from {$db_name}_ships");
        $out .= "Ships deleted.<br />";
        dbn("TRUNCATE TABLE {$db_name}_clans");
        $out .= "Clans deleted.<br />";
        dbn("TRUNCATE TABLE {$db_name}_bilkos");
        $out .= "Bilkos Auction House Emptied.<br />";
        if ($GAME_VARS['alternate_play_2'] > 1) {
            $dbh->do("update se_development_time set {$db_name}_available = 0 where year_set_{$game_vars[alternate_play_2]} > 0");
            $dbh->do("update se_development_time set {$db_name}_available = 1 where year_set_{$game_vars[alternate_play_2]} = 0");
            $out .= "Year reset to 0\n<br />";
        }
        dbn("update se_games set last_reset = " . time() . ", days_left = '{$GAME_VARS['game_length']}' where db_name = '{$db_name}'");
        $out .= "Last reset date updated to now.<br />";
        post_news("Game Reset.", "game_status");
    }
    insert_history($user['login_id'], "Galaxie remise à zéro");
    print_page("Reset Game", $out);
    #list all planets in game
} elseif (isset($_GET['planet_list'])) {
    db("select login_name,planet_name,location,fighters,colon,cash,metal,fuel,elect,mining_drones from {$db_name}_planets where location != 1 order by login_name asc, fighters desc, planet_name asc");
    $planet_listing = dbr(1);
    if (isset($planet_listing)) {
        $out .= $rs . "<p />" . make_table(array("Planet Owner", "Planet Name", "Location", "Fighters", "Colonists", "Cash", "Metal", "Fuel", "Electronics", "Mining Drones"));
        while ($planet_listing) {
            $planet_listing['login_name'] = "<b class='b1'>{$planet_listing['login_name']}</b>";
            $out .= make_row($planet_listing);
            $planet_listing = dbr(1);
        }
        $out .= "</table>";
Example #3
0
                $rs = "<br /><br /><a href='javascript:history.back()'>" . $st[808] . "</a>";
                print_footer();
            }
            $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>";
    
Example #4
0
                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");
            send_message($target['login_id'], sprintf($st[749], $transfer_counter, $user[login_name]));
            insert_history($user['login_id'], sprintf($st[750], $transfer_counter, $target[login_name]));
        }
    }
    print_page($cw['transfer_ship'], $text);
}
$text .= sprintf($st[751], $target[login_name]) . "<br /><br />";
$text .= "<b class='b1'>" . $st[752] . "<br />";
$text .= "<form action=send_ship.php method=POST name=transfer_ships><table>";
db("select ship_name, class_name, location, fighters, max_fighters, shields, max_shields, armour, max_armour, config, ship_id from {$db_name}_ships where login_id = '{$user['login_id']}' && ship_id != '{$user['ship_id']}' order by class_name");
$ships = dbr(1);
if (!isset($ships)) {
    #ensure there are some ships to display
    $text .= $st[753];
} else {
Example #5
0
function retire_user($target)
{
    global $user, $db_name, $cw, $st;
    //admin can't be retired. and only Server op and retire the server op.
    if ($target < 6 || $target == OWNER_ID && $user['login_id'] != OWNER_ID) {
        print_page($cw['retire'], $st[165]);
    }
    if ($target == $user['login_id'] || $user['login_id'] == 1) {
        db("select login_name from {$db_name}_users where login_id = '{$target}'");
        $target_user = dbr(1);
        post_news("<b class='b1'>{$target_user['login_name']}</b> {$st['166']}", "player_status");
        dbn("delete from {$db_name}_ships where login_id = '{$target}'");
        dbn("update {$db_name}_bilkos set bidder_id = 0, timestamp = " . time() . " where bidder_id = '{$target}'");
        dbn("update {$db_name}_planets set login_name = 'Un-Owned', login_id=4, pass='', clan_id = 0 where login_id = '{$target}'");
        dbn("delete from {$db_name}_diary where login_id = '{$target}'");
        dbn("delete from {$db_name}_user_options where login_id = '{$target}'");
        dbn("delete from {$db_name}_users where login_id = '{$target}'");
    }
}
Example #6
0
function post_news_action()
{
    if (time() - wp_next_scheduled('post_news') > 900) {
        post_news();
        wp_reschedule_event(time(), 'apn_quarter', 'post_news');
    }
}
Example #7
0
#db(attack_planet_check($db_name,$user));
#$planets = dbr();
if (empty($planets) || $user['login_id'] == 1) {
    if ($user['gamma'] < 1 && $bomb_type == 1) {
        $error_str = $st[1079];
    } elseif ($user['delta'] < 1 && $bomb_type == 2) {
        $error_str = $st[1080];
    } elseif ($GAME_VARS['attack_sol_flag'] == 0 && $user['location'] == 1 && $user['login_id'] != 1) {
        $error_str = $st[1081];
    } elseif (!isset($sure)) {
        get_var(sprintf($st[1082], $b_text), 'bombs.php', sprintf($st[1083], $b_text), 'sure', '');
    } else {
        if ($user['login_id'] > 1) {
            dbn("update {$db_name}_users set {$b_text} = {$b_text} - 1 where login_id = {$user['login_id']}");
        }
        post_news("<b class='b1'>{$user['login_name']}</b> " . sprintf($st[1084], $b_text) . "<b>{$user_ship['location']}</b>", $cw['bomb'] . ", " . $cw['attacking']);
        get_star();
        if ($user['login_id'] == 1) {
            $bomb_damage = 10000;
        } elseif ($bomb_type == 1) {
            #gamma bomb
            $bomb_damage = 200;
        } elseif ($bomb_type == 2) {
            #delta bomb
            #clear all shields on all ships before we start.
            db("select s.ship_id from {$db_name}_ships s, {$db_name}_users u where s.location = '{$user['location']}' && u.login_id\t!= 1 && s.ship_id > 1 && s.login_id = u.login_id && u.turns_run > '{$turns_safe}'");
            while ($target_ship = dbr(1)) {
                dbn("update {$db_name}_ships set shields = 0 where ship_id = '{$target_ship['ship_id']}'");
            }
            $target_ship = "";
            $bomb_damage = 5000;
Example #8
0
            $symbol = htmlspecialchars($symbol);
            $symbol = addslashes($symbol);
            $passwd = addslashes($passwd);
            $q_string = "insert into {$db_name}_clans (";
            $q_string = $q_string . "clan_name,leader_id,passwd,symbol,sym_color";
            $q_string = $q_string . ") values(";
            $q_string = $q_string . "'{$name}','{$user['login_id']}','{$passwd}','{$symbol}','{$sym_color}')";
            db($q_string);
            $clan_id = mysql_insert_id();
            dbn("update {$db_name}_planets set clan_id = {$clan_id} where login_id = {$user['login_id']}");
            dbn("update {$db_name}_ships set clan_id = {$clan_id} where login_id = {$user['login_id']}");
            dbn("update {$db_name}_users set clan_id = {$clan_id}, clan_sym = '{$symbol}', clan_sym_color = '{$sym_color}', cash=cash-10000 where login_id = {$user['login_id']}");
            $user['clan_id'] = $clan_id;
            $user['clan_sym'] = $symbol;
            $user['clan_sym_color'] = $sym_color;
            post_news("<b class='b1'>{$user['login_name']}</b> " . $cw['created_the'] . " <b class='b1'>{$name}(<font color={$sym_color}>{$symbol}</font>)</b>", "clan, player_status");
            insert_history($user['login_id'], sprintf($st[538], $name));
        }
    }
} elseif (isset($lead_change)) {
    // Assign new leader
    db("select leader_id from {$db_name}_clans where clan_id = {$user['clan_id']}");
    $clan = dbr(1);
    if ($user['clan_id'] < 1) {
        $error_str .= $st[539];
    } elseif ($clan['leader_id'] != $user['login_id'] && $user['login_id'] != 1) {
        $error_str .= $st[540];
    } elseif (!$leader_id) {
        db2("select login_id,login_name from {$db_name}_users where clan_id = '{$user['clan_id']}' && login_id != '1' && login_id != '{$clan['leader_id']}'");
        $member_name = dbr2(1);
        if ($member_name) {
Example #9
0
} 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);
Example #10
0
    }
}
if (isset($rename)) {
    if ($user['login_id'] != $planet['login_id']) {
        $text .= $st[1671];
    } elseif ($name_to) {
        $name_to = correct_name($name_to);
        if (!$name_to || strlen($name_to) < 3) {
            $rs = "<p /><a href='javascript:history.back()'>" . $cw['try-again'] . "</a>";
            print_page($cw['invalid_name'], $st[1672]);
        }
        #$stuff = addslashes($name_to);
        #echo eregi_replace("'","",$name_to);
        $text .= sprintf($st[1673], $planet[planet_name]) . " <b class='b1'>{$name_to}</b>.";
        dbn("update {$db_name}_planets set planet_name = '{$name_to}' where planet_id = '{$planet['planet_id']}'");
        post_news("<b class='b1'>{$user['login_name']}</b> " . sprintf($st[1674], $planet[planet_name]) . " <b class='b1'>{$name_to}</b>.", $cw['planet']);
    } else {
        $text .= $st[1675];
        $text .= "<FORM method=POST action=planet.php>";
        $text .= "<input type=text name=name_to size=30 value=\"{$planet['planet_name']}\" />";
        $text .= "<input type=hidden name=rename value=1 />";
        $text .= "<input type=hidden name=planet_id value={$planet['planet_id']} />";
        $text .= "<p /><input type='submit' value='" . $cw['rename'] . "' /></form><p />";
    }
    print_page($cw['rename_planet'], $text);
}
#put any messages into a "message" box.
$messages = $output_str;
#sets the largest span distance. Allows for quicker manipulation of the page.
$span_dist = 2;
$output_str = "<table width=90%>";
Example #11
0
         post_news($st[310] . " <b>{$combat_loc}</b>.<br />" . $same_txt, $st[304]);
     } elseif ($total_ships_killed >= 100 && $planet_attack == 0) {
         //major casualties!
         if (mt_rand(0, 1) == 1) {
             //choose between funny comments.
             post_news($st[311] . " <b>{$combat_loc}</b>. {$same_txt}.<p />" . $st[312], $st[304]);
         } else {
             post_news($st[313] . " <b>{$combat_loc}</b>. {$same_txt}.<p />" . $st[314]);
         }
     } elseif ($planet_attack == 1) {
         if ($planets_beaten > 0) {
             $conq_txt = sprintf($st[315], $friends_killed);
         } else {
             $conq_txt = sprintf($st[316], $friends_killed);
         }
         post_news("<b class='b1'>{$user['login_name']}</b> " . $st[317] . " <b class='b1'>{$target_planets[$target]['planet_name']}</b> " . $st[318] . " <b>{$combat_loc}</b>.<br />" . $st[319] . " <b>{$friendly_details['ship_count']}</b> " . $cw['ships'] . ".<br />" . $conq_txt, $st[320]);
         unset($conq_txt);
     }
     //end of news posting spree.
 }
 /**********************
  *Finish the Script
  **********************/
 //Scatter any minerals from the destroyed ships into the system. But only if not in system 1.
 if ($combat_loc != 1 && $simulate_attack == 0) {
     if ($metal_scrap > 0) {
         //scrap from cargo bays
         $metal_scrap = ceil($metal_scrap / mt_rand(1, 5));
     }
     if ($fuel_scrap > 0) {
         //fuel from cargo bays
Example #12
0
            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]));
function black_hole($user, $star)
{
    global $db_name, $user_ship;
    $bh_text = "Attention ! Attention ! Un trou noir a été détecté dans le systéme <b{$star['star_id']}</b>.<br />Vous manquez de peu d'être aspiré dedans mais vous parvenez à vous échapper au dernier moment. Vous prenez la fuite mais votre flotte à été dispersée dans la galaxie !";
    db("select count(star_id) from {$db_name}_stars");
    $total1 = dbr();
    $total = $total1[0];
    if ($user_ship['ship_id']) {
        $n_text = "";
        db2("select ship_id,shields,fighters,ship_name from {$db_name}_ships where fleet_id = '{$user_ship['fleet_id']}' and location = '{$user_ship['location']}' && login_id = '{$user['login_id']}'");
        while ($tow_ship = dbr2()) {
            $rand_star = random_system_num();
            dbn("update {$db_name}_ships set location = '{$rand_star}', mine_mode=0 where ship_id = {$tow_ship['ship_id']}");
            $totaldefs = $tow_ship['shields'] + $tow_ship['fighters'];
            if ($totaldefs > 9) {
                $damtodo = round($totaldefs / 100 * 5);
                $damtodo2 = $damtodo;
                $shield_damage = $damtodo;
                if ($shield_damage > $tow_ship['shields']) {
                    $shield_damage = $tow_ship['shields'];
                }
                $damtodo -= $shield_damage;
                dbn("update {$db_name}_ships set fighters = fighters - {$damtodo}, shields = shields - {$shield_damage} where ship_id = '{$tow_ship['ship_id']}'");
                $n_text .= "<br />The <b class=b1>{$tow_ship['ship_name']}</b> took <b>{$damtodo2}</b> damage and was thrown to system #<b>{$rand_star}</b>.";
            }
        }
        $rand_star = mt_rand(2, $total);
        if ($star['star_id'] == $rand_star) {
            if ($rand_star != $total) {
                $rand_star++;
            } else {
                $rand_star = $rand_star - 1;
            }
        }
        dbn("update {$db_name}_ships set location = {$rand_star}, mine_mode=0 where ship_id = {$user_ship['ship_id']}");
        $totaldefs = $user_ship['shields'] + $user_ship['fighters'];
        if ($totaldefs > 9) {
            $damtodo = round($totaldefs / 100 * 5);
            $damtodo2 = $damtodo;
            $shield_damage = $damtodo;
            if ($shield_damage > $user_ship['shields']) {
                $shield_damage = $user_ship['shields'];
            }
            $damtodo -= $shield_damage;
            dbn("update {$db_name}_ships set fighters = fighters - {$damtodo}, shields = shields - {$shield_damage} where ship_id = '{$user_ship['ship_id']}'");
            $m_text .= "<p />The <b class=b1>{$user_ship['ship_name']}</b> took <b>{$damtodo2}</b> damage and was thrown to system #<b>{$rand_star}</b>.";
            $user_ship['shields'] -= $shield_damage;
            $user_ship['fighters'] -= $damtodo;
        }
        $bh_text .= $m_text;
        if (!empty($n_text)) {
            $bh_text .= "<p />Reports from the rest of the Fleet Follow:<br />";
            $bh_text .= $n_text;
        }
        $tow_ship = $user_ship;
        dbn("update {$db_name}_users set location = {$rand_star} where login_id = '{$user['login_id']}'");
        dbn("update {$db_name}_ships set location = {$rand_star} where ship_id = '{$user['ship_id']}'");
    }
    post_news("Mayday, Mayday. Ici le capitaine <b class=b1>{$user['login_name']}</b>. Nous avons rencontré un trou noir...... *crackle* ..... besoin d'aide.... *static*", "random_event, ship");
    print_page("Location", $bh_text);
}
Example #14
0
function retire_ood_users()
{
    global $db_name, $final_str, $cw, $st;
    //select users who have been inactive in a game for a while.
    $time = time() - 14 * 86400;
    db("select clan_id, login_id, login_name from {$db_name}_users where login_id > 5 && joined_game < '{$time}' && last_request < '{$time}' && (banned_time < " . time() . " || banned_time = 0)");
    while ($users = dbr(1)) {
        if ($users['clan_id'] > 0) {
            //user in a clan
            db2("select leader_id from {$db_name}_clans where clan_id = '{$users['clan_id']}'");
            $clan = dbr2(1);
            #if player is in clan, remove the clan.
            if ($clan['leader_id'] == $users['login_id']) {
                dbn("update {$db_name}_users set clan_id = 0 where clan_id = '{$users['clan_id']}'");
                dbn("update {$db_name}_planets set clan_id = -1 where clan_id = '{$users['clan_id']}'");
                dbn("delete from {$db_name}_clans where clan_id = '{$users['clan_id']}'");
            } else {
                dbn("update {$db_name}_planets set clan_id = -1 where login_id = '{$users['login_id']}'");
            }
        }
        dbn("delete from {$db_name}_ships where login_id = '{$users['login_id']}'");
        dbn("delete from {$db_name}_diary where login_id = '{$users['login_id']}'");
        insert_history($users['login_id'], "Was removed from {$db_name} after 14 days of in-activity.");
        dbn("delete from {$db_name}_user_options where login_id = '{$users['login_id']}'");
        dbn("delete from {$db_name}_users where login_id = '{$users['login_id']}'");
        $final_str .= "\n<br />{$users['login_name']} Removed";
        post_news("<b class=b1>{$users['login_name']}</b> " . $st[1831], "player_status");
    }
}
Example #15
0
function run_random_events()
{
    global $db_name, $random_events, $final_str, $num_stars, $GAME_VARS, $st, $cw;
    //solar storm takes out shields
    db("select star_id from {$db_name}_stars where event_random = '12'");
    while ($to_do = dbr(1)) {
        dbn("update {$db_name}_ships set shields = 0 where location = '{$to_do['star_id']}' && login_id != '1'");
    }
    #remove Solar Storm
    db("select star_id,star_name from {$db_name}_stars where event_random = '12' order by RAND()");
    while ($star_var = dbr(1)) {
        //chance of removal based on SS count
        $temp = 1800 / ($GAME_VARS['random_events'] * $num_stars) + 4;
        if (mt_rand(0, $temp) == 0) {
            dbn("update {$db_name}_stars set event_random = 0 where star_id = '{$star_var['star_id']}'");
            post_news(sprintf($st[1855], $star_var[star_name], $star_var[star_id]), "random_event");
            $final_str .= $st[1856];
        }
    }
    #create Solar Storm
    $temp = 2000 / ($GAME_VARS['random_events'] * $num_stars) + 1;
    if (mt_rand(0, $temp) < 2) {
        $to_go = mt_rand(1, $num_stars);
        db("select event_random,star_name from {$db_name}_stars where star_id = '{$to_go}'");
        $is_it = dbr(1);
        if ($is_it['event_random'] == 0) {
            dbn("update {$db_name}_stars set event_random = 12 where star_id = '{$to_go}'");
            post_news(sprintf($st[1857], $is_it[star_name], $to_go), "random_event");
            $final_str .= sprintf($st[1858], $to_go);
        }
    }
}