Exemple #1
0
function ShowResetAdmin($CurrentUser)
{
    global $phpEx, $lang, $db, $displays;
    if ($CurrentUser['authlevel'] < 3) {
        die($displays->message($lang['not_enough_permissions']));
    }
    $db->query("RENAME TABLE {{table}} TO {{table}}_s", 'planets');
    $db->query("RENAME TABLE {{table}} TO {{table}}_s", 'users');
    $db->query("CREATE  TABLE IF NOT EXISTS {{table}} ( LIKE {{table}}_s );", 'planets');
    $db->query("CREATE  TABLE IF NOT EXISTS {{table}} ( LIKE {{table}}_s );", 'users');
    $db->query("TRUNCATE TABLE {{table}}", 'sac');
    $db->query("TRUNCATE TABLE {{table}}", 'alliance');
    $db->query("TRUNCATE TABLE {{table}}", 'banned');
    $db->query("TRUNCATE TABLE {{table}}", 'buddy');
    $db->query("TRUNCATE TABLE {{table}}", 'galaxy');
    $db->query("TRUNCATE TABLE {{table}}", 'errors');
    $db->query("TRUNCATE TABLE {{table}}", 'fleets');
    $db->query("TRUNCATE TABLE {{table}}", 'messages');
    $db->query("TRUNCATE TABLE {{table}}", 'notes');
    $db->query("TRUNCATE TABLE {{table}}", 'rw');
    $db->query("TRUNCATE TABLE {{table}}", 'statpoints');
    $AllUsers = $db->query("SELECT `username`,`password`,`email`,\r\n\t\t\t\t      `email_2`,`authlevel`,`galaxy`,`system`,`planet`,\r\n\t\t\t\t      `dpath`, `onlinetime`, `register_time`, `id_planet`\r\n\t\t\t\t      FROM {{table}};", 'users_s');
    $LimitTime = time() - 15 * (24 * (60 * 60));
    $TransUser = 0;
    while ($TheUser = mysql_fetch_assoc($AllUsers)) {
        if ($TheUser['onlinetime'] > $LimitTime) {
            $UserPlanet = $db->query("SELECT `name`\r\n\t\t\t\t\t\t\t   FROM {{table}}\r\n\t\t\t\t\t\t\t   WHERE `id` = '" . $TheUser['id_planet'] . "';", 'planets_s', true);
            if ($UserPlanet['name'] != "") {
                $QryInsertUser = "******";
                $QryInsertUser .= "`username` = '" . $TheUser['username'] . "', ";
                $QryInsertUser .= "`email` = '" . $TheUser['email'] . "', ";
                $QryInsertUser .= "`email_2` = '" . $TheUser['email_2'] . "', ";
                $QryInsertUser .= "`id_planet` = '0', ";
                $QryInsertUser .= "`authlevel` = '" . $TheUser['authlevel'] . "', ";
                $QryInsertUser .= "`dpath` = '" . $TheUser['dpath'] . "', ";
                $QryInsertUser .= "`galaxy` = '" . $TheUser['galaxy'] . "', ";
                $QryInsertUser .= "`system` = '" . $TheUser['system'] . "', ";
                $QryInsertUser .= "`planet` = '" . $TheUser['planet'] . "', ";
                $QryInsertUser .= "`register_time` = '" . $TheUser['register_time'] . "', ";
                $QryInsertUser .= "`password` = '" . $TheUser['password'] . "';";
                $db->query($QryInsertUser, 'users');
                $NewUser = $db->query("SELECT `id`\r\n\t\t\t\t\t\t\t\t  FROM {{table}}\r\n\t\t\t\t\t\t\t\t  WHERE `username` = '" . $TheUser['username'] . "'\r\n\t\t\t\t\t\t\t\t  LIMIT 1;", 'users', true);
                CreateOnePlanetRecord($TheUser['galaxy'], $TheUser['system'], $TheUser['planet'], $NewUser['id'], $UserPlanet['name'], '', '', '', true);
                $PlanetID = $db->query("SELECT `id` FROM {{table}} WHERE `id_owner` = '" . $NewUser['id'] . "' LIMIT 1;", 'planets', true);
                $QryUpdateUser = "******";
                $QryUpdateUser .= "`id_planet` = '" . $PlanetID['id'] . "', ";
                $QryUpdateUser .= "`current_planet` = '" . $PlanetID['id'] . "' ";
                $QryUpdateUser .= "WHERE ";
                $QryUpdateUser .= "`id` = '" . $NewUser['id'] . "';";
                $db->query($QryUpdateUser, 'users');
                $TransUser++;
            }
        }
    }
    $db->query("UPDATE {{table}} SET `config_value` = '" . $TransUser . "' WHERE `config_name` = 'users_amount' LIMIT 1;", 'config');
    $db->query("DROP TABLE {{table}}", 'planets_s');
    $db->query("DROP TABLE {{table}}", 'users_s');
    header("location:admin.php?page=overview");
}
function MissionCaseColonisation($FleetRow)
{
    global $lang, $resource;
    $iPlanetCount = mysql_result(doquery("SELECT count(*) FROM {{table}} WHERE `id_owner` = '" . $FleetRow['fleet_owner'] . "' AND `planet_type` = '1'", 'planets'), 0);
    if ($FleetRow['fleet_mess'] == 0) {
        $iGalaxyPlace = mysql_result(doquery("SELECT count(*) FROM {{table}} WHERE `galaxy` = '" . $FleetRow['fleet_end_galaxy'] . "' AND `system` = '" . $FleetRow['fleet_end_system'] . "' AND `planet` = '" . $FleetRow['fleet_end_planet'] . "';", 'galaxy'), 0);
        $TargetAdress = sprintf($lang['sys_adress_planet'], $FleetRow['fleet_end_galaxy'], $FleetRow['fleet_end_system'], $FleetRow['fleet_end_planet']);
        if ($iGalaxyPlace == 0) {
            if ($iPlanetCount >= MAX_PLAYER_PLANETS) {
                $TheMessage = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_maxcolo'] . MAX_PLAYER_PLANETS . $lang['sys_colo_planet'];
                SendSimpleMessage($FleetRow['fleet_owner'], '', $FleetRow['fleet_start_time'], 0, $lang['sys_colo_mess_from'], $lang['sys_colo_mess_report'], $TheMessage);
                doquery("UPDATE {{table}} SET `fleet_mess` = '1' WHERE `fleet_id` = " . $FleetRow["fleet_id"], 'fleets');
            } else {
                $NewOwnerPlanet = CreateOnePlanetRecord($FleetRow['fleet_end_galaxy'], $FleetRow['fleet_end_system'], $FleetRow['fleet_end_planet'], $FleetRow['fleet_owner'], $lang['sys_colo_defaultname'], false);
                if ($NewOwnerPlanet == true) {
                    $TheMessage = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_allisok'];
                    SendSimpleMessage($FleetRow['fleet_owner'], '', $FleetRow['fleet_start_time'], 0, $lang['sys_colo_mess_from'], $lang['sys_colo_mess_report'], $TheMessage);
                    if ($FleetRow['fleet_amount'] == 1) {
                        doquery("DELETE FROM {{table}} WHERE fleet_id=" . $FleetRow["fleet_id"], 'fleets');
                    } else {
                        $CurrentFleet = explode(";", $FleetRow['fleet_array']);
                        $NewFleet = "";
                        foreach ($CurrentFleet as $Item => $Group) {
                            if ($Group != '') {
                                $Class = explode(",", $Group);
                                if ($Class[0] == 208) {
                                    if ($Class[1] > 1) {
                                        $NewFleet .= $Class[0] . "," . ($Class[1] - 1) . ";";
                                    }
                                } else {
                                    if ($Class[1] != 0) {
                                        $NewFleet .= $Class[0] . "," . $Class[1] . ";";
                                    }
                                }
                            }
                        }
                        $QryUpdateFleet = "UPDATE {{table}} SET ";
                        $QryUpdateFleet .= "`fleet_array` = '" . $NewFleet . "', ";
                        $QryUpdateFleet .= "`fleet_amount` = `fleet_amount` - 1, ";
                        $QryUpdateFleet .= "`fleet_mess` = '1' ";
                        $QryUpdateFleet .= "WHERE `fleet_id` = '" . $FleetRow["fleet_id"] . "';";
                        doquery($QryUpdateFleet, 'fleets');
                    }
                } else {
                    $TheMessage = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_badpos'];
                    SendSimpleMessage($FleetRow['fleet_owner'], '', $FleetRow['fleet_start_time'], 0, $lang['sys_colo_mess_from'], $lang['sys_colo_mess_report'], $TheMessage);
                    doquery("UPDATE {{table}} SET `fleet_mess` = '1' WHERE `fleet_id` = " . $FleetRow["fleet_id"], 'fleets');
                }
            }
        } else {
            $TheMessage = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_notfree'];
            SendSimpleMessage($FleetRow['fleet_owner'], '', $FleetRow['fleet_end_time'], 0, $lang['sys_colo_mess_from'], $lang['sys_colo_mess_report'], $TheMessage);
            doquery("UPDATE {{table}} SET `fleet_mess` = '1' WHERE `fleet_id` = " . $FleetRow["fleet_id"], 'fleets');
        }
    } else {
        RestoreFleetToPlanet($FleetRow, true);
        doquery("DELETE FROM {{table}} WHERE fleet_id=" . $FleetRow["fleet_id"], 'fleets');
    }
}
Exemple #3
0
function ResetUniverse($CurrentUser)
{
    global $phpEx;
    doquery("RENAME TABLE {{table}} TO {{table}}_s", 'planets');
    doquery("RENAME TABLE {{table}} TO {{table}}_s", 'users');
    doquery("CREATE  TABLE IF NOT EXISTS {{table}} ( LIKE {{table}}_s );", 'planets');
    doquery("CREATE  TABLE IF NOT EXISTS {{table}} ( LIKE {{table}}_s );", 'users');
    doquery("TRUNCATE TABLE {{table}}", 'aks');
    doquery("TRUNCATE TABLE {{table}}", 'alliance');
    doquery("TRUNCATE TABLE {{table}}", 'banned');
    doquery("TRUNCATE TABLE {{table}}", 'buddy');
    doquery("TRUNCATE TABLE {{table}}", 'galaxy');
    doquery("TRUNCATE TABLE {{table}}", 'errors');
    doquery("TRUNCATE TABLE {{table}}", 'fleets');
    doquery("TRUNCATE TABLE {{table}}", 'messages');
    doquery("TRUNCATE TABLE {{table}}", 'notes');
    doquery("TRUNCATE TABLE {{table}}", 'rw');
    doquery("TRUNCATE TABLE {{table}}", 'statpoints');
    $AllUsers = doquery("SELECT `username`,`password`,`email`, `email_2`,`authlevel`,`galaxy`,`system`,`planet`, `dpath`, `onlinetime`, `register_time`, `id_planet` FROM {{table}} WHERE 1;", 'users_s');
    $LimitTime = time() - 15 * (24 * (60 * 60));
    $TransUser = 0;
    while ($TheUser = mysql_fetch_assoc($AllUsers)) {
        if ($TheUser['onlinetime'] > $LimitTime) {
            $UserPlanet = doquery("SELECT `name` FROM {{table}} WHERE `id` = '" . $TheUser['id_planet'] . "';", 'planets_s', true);
            if ($UserPlanet['name'] != "") {
                $Time = time();
                $QryInsertUser = "******";
                $QryInsertUser .= "`username` = '" . $TheUser['username'] . "', ";
                $QryInsertUser .= "`email` = '" . $TheUser['email'] . "', ";
                $QryInsertUser .= "`email_2` = '" . $TheUser['email_2'] . "', ";
                $QryInsertUser .= "`id_planet` = '0', ";
                $QryInsertUser .= "`authlevel` = '" . $TheUser['authlevel'] . "', ";
                $QryInsertUser .= "`dpath` = '" . $TheUser['dpath'] . "', ";
                $QryInsertUser .= "`galaxy` = '" . $TheUser['galaxy'] . "', ";
                $QryInsertUser .= "`system` = '" . $TheUser['system'] . "', ";
                $QryInsertUser .= "`planet` = '" . $TheUser['planet'] . "', ";
                $QryInsertUser .= "`register_time` = '" . $TheUser['register_time'] . "', ";
                $QryInsertUser .= "`onlinetime` = '" . $Time . "', ";
                $QryInsertUser .= "`password` = '" . $TheUser['password'] . "';";
                doquery($QryInsertUser, 'users');
                doquery("UPDATE {{table}} SET `bana` = '0' WHERE `id` > '1'", "users");
                $NewUser = doquery("SELECT `id` FROM {{table}} WHERE `username` = '" . $TheUser['username'] . "' LIMIT 1;", 'users', true);
                CreateOnePlanetRecord($TheUser['galaxy'], $TheUser['system'], $TheUser['planet'], $NewUser['id'], $UserPlanet['name'], true);
                doquery("UPDATE {{table}} SET `id_level` = '" . $TheUser['authlevel'] . "' WHERE `id_owner` = '" . $NewUser['id'] . "'", "planets");
                $PlanetID = doquery("SELECT `id` FROM {{table}} WHERE `id_owner` = '" . $NewUser['id'] . "' LIMIT 1;", 'planets', true);
                $QryUpdateUser = "******";
                $QryUpdateUser .= "`id_planet` = '" . $PlanetID['id'] . "', ";
                $QryUpdateUser .= "`current_planet` = '" . $PlanetID['id'] . "' ";
                $QryUpdateUser .= "WHERE ";
                $QryUpdateUser .= "`id` = '" . $NewUser['id'] . "';";
                doquery($QryUpdateUser, 'users');
                $TransUser++;
            }
        }
    }
    doquery("UPDATE {{table}} SET `config_value` = '" . $TransUser . "' WHERE `config_name` = 'users_amount' LIMIT 1;", 'config');
    doquery("DROP TABLE {{table}}", 'planets_s');
    doquery("DROP TABLE {{table}}", 'users_s');
}
 function TargetEvent()
 {
     global $resource;
     $iPlanetCount = $GLOBALS['DATABASE']->getFirstCell("SELECT COUNT(*) FROM " . PLANETS . " WHERE `id_owner` = '" . $this->_fleet['fleet_owner'] . "' AND `planet_type` = '1' AND `destruyed` = '0';");
     $iGalaxyPlace = $GLOBALS['DATABASE']->getFirstCell("SELECT COUNT(*) FROM " . PLANETS . " WHERE `id` = '" . $this->_fleet['fleet_end_id'] . "';");
     $senderUser = $GLOBALS['DATABASE']->getFirstRow("SELECT * FROM " . USERS . " WHERE `id` = '" . $this->_fleet['fleet_owner'] . "';");
     $senderPlanet = $GLOBALS['DATABASE']->getFirstRow("SELECT * FROM " . PLANETS . " WHERE `id` = '" . $this->_fleet['fleet_start_id'] . "';");
     $senderUser['factor'] = getFactors($senderUser, 'basic', $this->_fleet['fleet_start_time']);
     $LNG = $this->getLanguage($senderUser['lang']);
     $MaxPlanets = PlayerUtil::maxPlanetCount($senderUser);
     if ($iGalaxyPlace != 0) {
         $TheMessage = sprintf($LNG['sys_colo_notfree'], GetTargetAdressLink($this->_fleet, ''));
         $this->setState(FLEET_RETURN);
     } elseif ($iPlanetCount >= $MaxPlanets) {
         $TheMessage = sprintf($LNG['sys_colo_maxcolo'], GetTargetAdressLink($this->_fleet, ''), $MaxPlanets);
         $this->setState(FLEET_RETURN);
     } elseif (PlayerUtil::allowPlanetPosition($this->_fleet['fleet_end_planet'], $senderUser) == false) {
         $TheMessage = sprintf($LNG['sys_colo_notech'], GetTargetAdressLink($this->_fleet, ''), $MaxPlanets);
         $this->setState(FLEET_RETURN);
     } else {
         require_once 'includes/functions/CreateOnePlanetRecord.php';
         $NewOwnerPlanet = CreateOnePlanetRecord($this->_fleet['fleet_end_galaxy'], $this->_fleet['fleet_end_system'], $this->_fleet['fleet_end_planet'], $this->_fleet['fleet_universe'], $this->_fleet['fleet_owner'], $LNG['fcp_colony'], false, $senderUser['authlevel']);
         if ($NewOwnerPlanet === false) {
             $TheMessage = sprintf($LNG['sys_colo_badpos'], GetTargetAdressLink($this->_fleet, ''));
             $this->setState(FLEET_RETURN);
         } else {
             $this->_fleet['fleet_end_id'] = $NewOwnerPlanet;
             $TheMessage = sprintf($LNG['sys_colo_allisok'], GetTargetAdressLink($this->_fleet, ''));
             $this->StoreGoodsToPlanet();
             if ($this->_fleet['fleet_amount'] == 1) {
                 $this->KillFleet();
             } else {
                 $CurrentFleet = explode(";", $this->_fleet['fleet_array']);
                 $NewFleet = '';
                 foreach ($CurrentFleet as $Item => $Group) {
                     if (empty($Group)) {
                         continue;
                     }
                     $Class = explode(",", $Group);
                     if ($Class[0] == 208 && $Class[1] > 1) {
                         $NewFleet .= $Class[0] . "," . ($Class[1] - 1) . ";";
                     } elseif ($Class[0] != 208 && $Class[1] > 0) {
                         $NewFleet .= $Class[0] . "," . $Class[1] . ";";
                     }
                 }
                 $this->UpdateFleet('fleet_array', $NewFleet);
                 $this->UpdateFleet('fleet_amount', $this->_fleet['fleet_amount'] - 1);
                 $this->UpdateFleet('fleet_resource_metal', 0);
                 $this->UpdateFleet('fleet_resource_crystal', 0);
                 $this->UpdateFleet('fleet_resource_deuterium', 0);
                 $this->setState(FLEET_RETURN);
             }
         }
     }
     SendSimpleMessage($this->_fleet['fleet_owner'], 0, $this->_fleet['fleet_start_time'], 4, $LNG['sys_colo_mess_from'], $LNG['sys_colo_mess_report'], $TheMessage);
     $this->SaveFleet();
 }
 function TargetEvent()
 {
     global $db, $resource, $LANG;
     $iPlanetCount = $db->countquery("SELECT count(*) FROM " . PLANETS . " WHERE `id_owner` = '" . $this->_fleet['fleet_owner'] . "' AND `planet_type` = '1' AND `destruyed` = '0';");
     $iGalaxyPlace = $db->countquery("SELECT count(*) AS plani FROM " . PLANETS . " WHERE `id` = '" . $this->_fleet['fleet_end_id'] . "';");
     $Player = $db->uniquequery("SELECT `lang`, `authlevel`, `" . $resource[124] . "` FROM " . USERS . " WHERE `id` = '" . $this->_fleet['fleet_owner'] . "';");
     $LNG = $LANG->GetUserLang($Player['lang']);
     $MaxPlanets = MaxPlanets($Player[$resource[124]]);
     if ($iGalaxyPlace != 0) {
         $TheMessage = sprintf($LNG['sys_colo_notfree'], GetTargetAdressLink($this->_fleet, ''));
         $this->UpdateFleet('fleet_mess', 1);
     } elseif ($iPlanetCount >= $MaxPlanets) {
         $TheMessage = sprintf($LNG['sys_colo_maxcolo'], GetTargetAdressLink($this->_fleet, ''), $MaxPlanets);
         $this->UpdateFleet('fleet_mess', 1);
     } else {
         require_once ROOT_PATH . 'includes/functions/CreateOnePlanetRecord.php';
         $NewOwnerPlanet = CreateOnePlanetRecord($this->_fleet['fleet_end_galaxy'], $this->_fleet['fleet_end_system'], $this->_fleet['fleet_end_planet'], $this->_fleet['fleet_universe'], $this->_fleet['fleet_owner'], $LNG['fcp_colony'], false, $Player['authlevel']);
         if ($NewOwnerPlanet === false) {
             $TheMessage = sprintf($LNG['sys_colo_badpos'], GetTargetAdressLink($this->_fleet, ''));
             $this->UpdateFleet('fleet_mess', 1);
         } else {
             $this->_fleet['fleet_end_id'] = $NewOwnerPlanet;
             $TheMessage = sprintf($LNG['sys_colo_allisok'], GetTargetAdressLink($this->_fleet, ''));
             $this->StoreGoodsToPlanet();
             if ($this->_fleet['fleet_amount'] == 1) {
                 $this->KillFleet();
             } else {
                 $CurrentFleet = explode(";", $this->_fleet['fleet_array']);
                 $NewFleet = '';
                 foreach ($CurrentFleet as $Item => $Group) {
                     if (empty($Group)) {
                         continue;
                     }
                     $Class = explode(",", $Group);
                     if ($Class[0] == 208 && $Class[1] > 1) {
                         $NewFleet .= $Class[0] . "," . ($Class[1] - 1) . ";";
                     } elseif ($Class[0] != 208 && $Class[1] > 0) {
                         $NewFleet .= $Class[0] . "," . $Class[1] . ";";
                     }
                 }
                 $this->UpdateFleet('fleet_array', $NewFleet);
                 $this->UpdateFleet('fleet_amount', $this->_fleet['fleet_amount'] - 1);
                 $this->UpdateFleet('fleet_resource_metal', 0);
                 $this->UpdateFleet('fleet_resource_crystal', 0);
                 $this->UpdateFleet('fleet_resource_deuterium', 0);
                 $this->UpdateFleet('fleet_resource_norio', 0);
                 $this->UpdateFleet('fleet_mess', 1);
             }
         }
     }
     SendSimpleMessage($this->_fleet['fleet_owner'], 0, $this->_fleet['fleet_start_time'], 4, $LNG['sys_colo_mess_from'], $LNG['sys_colo_mess_report'], $TheMessage);
     $this->SaveFleet();
 }
 function TargetEvent()
 {
     global $db, $resource;
     $iPlanetCount = $db->uniquequery("SELECT count(*) as kolo FROM " . PLANETS . " WHERE `id_owner` = '" . $this->_fleet['fleet_owner'] . "' AND `planet_type` = '1' AND `destruyed` = '0';");
     $iGalaxyPlace = $db->uniquequery("SELECT count(*) AS plani FROM " . PLANETS . " WHERE `galaxy` = '" . $this->_fleet['fleet_end_galaxy'] . "' AND `system` = '" . $this->_fleet['fleet_end_system'] . "' AND `planet` = '" . $this->_fleet['fleet_end_planet'] . "';");
     $PlayerTech = $db->uniquequery("SELECT `authlevel`, `" . $resource[124] . "` FROM " . USERS . " WHERE `id` = '" . $this->_fleet['fleet_owner'] . "';");
     $LNG = $this->GetUserLang($this->_fleet['fleet_owner']);
     if ($iGalaxyPlace['plani'] != 0) {
         $TheMessage = sprintf($LNG['sys_colo_notfree'], GetTargetAdressLink($this->_fleet, ''));
         $this->UpdateFleet('fleet_mess', 1);
     } elseif ($iPlanetCount['kolo'] >= STANDART_PLAYER_PLANETS + ceil($PlayerTech[$resource[124]] / 2) * PLANETS_PER_TECH) {
         $TheMessage = sprintf($LNG['sys_colo_maxcolo'], GetTargetAdressLink($this->_fleet, ''), STANDART_PLAYER_PLANETS + ceil($PlayerTech[$resource[124]] / 2));
         $this->UpdateFleet('fleet_mess', 1);
     } else {
         require_once ROOT_PATH . 'includes/functions/CreateOnePlanetRecord.' . PHP_EXT;
         $NewOwnerPlanet = CreateOnePlanetRecord($this->_fleet['fleet_end_galaxy'], $this->_fleet['fleet_end_system'], $this->_fleet['fleet_end_planet'], $this->_fleet['fleet_owner'], $LNG['fcp_colony'], false, $PlayerTech['authlevel']);
         if ($NewOwnerPlanet !== true) {
             $TheMessage = sprintf($LNG['sys_colo_badpos'], GetTargetAdressLink($this->_fleet, ''));
             $this->UpdateFleet('fleet_mess', 1);
         } else {
             $TheMessage = sprintf($LNG['sys_colo_allisok'], GetTargetAdressLink($this->_fleet, ''));
             $this->StoreGoodsToPlanet();
             if ($this->_fleet['fleet_amount'] == 1) {
                 $db->query("DELETE FROM " . FLEETS . " WHERE fleet_id=" . $this->_fleet["fleet_id"] . ";");
             } else {
                 $CurrentFleet = explode(";", $this->_fleet['fleet_array']);
                 $NewFleet = '';
                 foreach ($CurrentFleet as $Item => $Group) {
                     if (empty($Group)) {
                         continue;
                     }
                     $Class = explode(",", $Group);
                     if ($Class[0] == 208 && $Class[1] > 1) {
                         $NewFleet .= $Class[0] . "," . ($Class[1] - 1) . ";";
                     } elseif ($Class[0] != 208 && $Class[1] > 0) {
                         $NewFleet .= $Class[0] . "," . $Class[1] . ";";
                     }
                 }
                 $this->UpdateFleet('fleet_array', $NewFleet);
                 $this->UpdateFleet('fleet_amount', $this->_fleet['fleet_amount'] - 1);
                 $this->UpdateFleet('fleet_resource_metal', 0);
                 $this->UpdateFleet('fleet_resource_crystal', 0);
                 $this->UpdateFleet('fleet_resource_deuterium', 0);
                 $this->UpdateFleet('fleet_mess', 1);
             }
         }
     }
     SendSimpleMessage($this->_fleet['fleet_owner'], 0, $this->_fleet['fleet_start_time'], 4, $LNG['sys_colo_mess_from'], $LNG['sys_colo_mess_report'], $TheMessage);
     $this->SaveFleet();
 }
/**
 * ResetThisFuckingCheater.php
 *
 * @version $Id$
 * @copyright 2008
 */
function ResetThisFuckingCheater($UserID)
{
    $TheUser = doquery("SELECT * FROM {{table}} WHERE `id` = '" . $UserID . "';", 'users', true);
    $UserPlanet = doquery("SELECT `name` FROM {{table}} WHERE `id` = '" . $TheUser['id_planet'] . "';", 'planets', true);
    DeleteSelectedUser($UserID);
    if ($UserPlanet['name'] != "") {
        // Creation de l'utilisateur
        $QryInsertUser = "******";
        $QryInsertUser .= "`id` = '" . $TheUser['id'] . "', ";
        $QryInsertUser .= "`username` = '" . $TheUser['username'] . "', ";
        $QryInsertUser .= "`email` = '" . $TheUser['email'] . "', ";
        $QryInsertUser .= "`email_2` = '" . $TheUser['email_2'] . "', ";
        $QryInsertUser .= "`sex` = '" . $TheUser['sex'] . "', ";
        $QryInsertUser .= "`id_planet` = '0', ";
        $QryInsertUser .= "`authlevel` = '" . $TheUser['authlevel'] . "', ";
        $QryInsertUser .= "`dpath` = '" . $TheUser['dpath'] . "', ";
        $QryInsertUser .= "`galaxy` = '" . $TheUser['galaxy'] . "', ";
        $QryInsertUser .= "`system` = '" . $TheUser['system'] . "', ";
        $QryInsertUser .= "`planet` = '" . $TheUser['planet'] . "', ";
        $QryInsertUser .= "`register_time` = '" . $TheUser['register_time'] . "', ";
        $QryInsertUser .= "`password` = '" . $TheUser['password'] . "';";
        doquery($QryInsertUser, 'users');
        // On cherche le numero d'enregistrement de l'utilisateur fraichement cr??
        $NewUser = doquery("SELECT `id` FROM {{table}} WHERE `username` = '" . $TheUser['username'] . "' LIMIT 1;", 'users', true);
        CreateOnePlanetRecord($TheUser['galaxy'], $TheUser['system'], $TheUser['planet'], $NewUser['id'], $UserPlanet['name'], true);
        // Recherche de la reference de la nouvelle planete (qui est unique normalement !
        $PlanetID = doquery("SELECT `id` FROM {{table}} WHERE `id_owner` = '" . $NewUser['id'] . "' LIMIT 1;", 'planets', true);
        // Mise a jour de l'enregistrement utilisateur avec les infos de sa planete mere
        $QryUpdateUser = "******";
        $QryUpdateUser .= "`id_planet` = '" . $PlanetID['id'] . "', ";
        $QryUpdateUser .= "`current_planet` = '" . $PlanetID['id'] . "' ";
        $QryUpdateUser .= "WHERE ";
        $QryUpdateUser .= "`id` = '" . $NewUser['id'] . "';";
        doquery($QryUpdateUser, 'users');
    }
    return;
}
function MissionCaseColonisation($FleetRow)
{
    global $lang, $resource;
    $iPlanetCount = mysql_result(doquery("SELECT count(*) FROM {{table}} WHERE `id_owner` = '" . $FleetRow['fleet_owner'] . "' AND `planet_type` = '1'", 'planets'), 0);
    if ($FleetRow['fleet_mess'] == 0) {
        // Déjà, sommes nous a l'aller ??
        $iGalaxyPlace = mysql_result(doquery("SELECT count(*) FROM {{table}} WHERE `galaxy` = '" . $FleetRow['fleet_end_galaxy'] . "' AND `system` = '" . $FleetRow['fleet_end_system'] . "' AND `planet` = '" . $FleetRow['fleet_end_planet'] . "';", 'galaxy'), 0);
        $TargetAdress = sprintf($lang['sys_adress_planet'], $FleetRow['fleet_end_galaxy'], $FleetRow['fleet_end_system'], $FleetRow['fleet_end_planet']);
        if ($iGalaxyPlace == 0) {
            // Y a personne qui s'y est mis avant que je ne debarque !
            if ($iPlanetCount >= MAX_PLAYER_PLANETS) {
                $TheMessage = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_maxcolo'] . MAX_PLAYER_PLANETS . $lang['sys_colo_planet'];
                SendSimpleMessage($FleetRow['fleet_owner'], '', $FleetRow['fleet_start_time'], 0, $lang['sys_colo_mess_from'], $lang['sys_colo_mess_report'], $TheMessage);
                doquery("UPDATE {{table}} SET `fleet_mess` = '1' WHERE `fleet_id` = " . $FleetRow["fleet_id"], 'fleets');
            } else {
                $NewOwnerPlanet = CreateOnePlanetRecord($FleetRow['fleet_end_galaxy'], $FleetRow['fleet_end_system'], $FleetRow['fleet_end_planet'], $FleetRow['fleet_owner'], $lang['sys_colo_defaultname'], false);
                if ($NewOwnerPlanet == true) {
                    $TheMessage = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_allisok'];
                    SendSimpleMessage($FleetRow['fleet_owner'], '', $FleetRow['fleet_start_time'], 0, $lang['sys_colo_mess_from'], $lang['sys_colo_mess_report'], $TheMessage);
                    // Verifier ce que contient fleet_array (et le cas et cheant retirer un element '208'
                    if ($FleetRow['fleet_amount'] == 1) {
                        doquery("DELETE FROM {{table}} WHERE fleet_id=" . $FleetRow["fleet_id"], 'fleets');
                    } else {
                        $CurrentFleet = explode(";", $FleetRow['fleet_array']);
                        $NewFleet = "";
                        foreach ($CurrentFleet as $Item => $Group) {
                            if ($Group != '') {
                                $Class = explode(",", $Group);
                                if ($Class[0] == 208) {
                                    if ($Class[1] > 1) {
                                        $NewFleet .= $Class[0] . "," . ($Class[1] - 1) . ";";
                                    }
                                } else {
                                    if ($Class[1] != 0) {
                                        $NewFleet .= $Class[0] . "," . $Class[1] . ";";
                                    }
                                }
                            }
                        }
                        $QryUpdateFleet = "UPDATE {{table}} SET ";
                        $QryUpdateFleet .= "`fleet_array` = '" . $NewFleet . "', ";
                        $QryUpdateFleet .= "`fleet_amount` = `fleet_amount` - 1, ";
                        $QryUpdateFleet .= "`fleet_mess` = '1' ";
                        $QryUpdateFleet .= "WHERE `fleet_id` = '" . $FleetRow["fleet_id"] . "';";
                        doquery($QryUpdateFleet, 'fleets');
                    }
                } else {
                    $TheMessage = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_badpos'];
                    SendSimpleMessage($FleetRow['fleet_owner'], '', $FleetRow['fleet_start_time'], 0, $lang['sys_colo_mess_from'], $lang['sys_colo_mess_report'], $TheMessage);
                    doquery("UPDATE {{table}} SET `fleet_mess` = '1' WHERE `fleet_id` = " . $FleetRow["fleet_id"], 'fleets');
                }
            }
        } else {
            // Pas de bol coiffé sur le poteau !
            $TheMessage = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_notfree'];
            SendSimpleMessage($FleetRow['fleet_owner'], '', $FleetRow['fleet_end_time'], 0, $lang['sys_colo_mess_from'], $lang['sys_colo_mess_report'], $TheMessage);
            // Mettre a jour la flotte pour qu'effectivement elle revienne !
            doquery("UPDATE {{table}} SET `fleet_mess` = '1' WHERE `fleet_id` = " . $FleetRow["fleet_id"], 'fleets');
        }
    } else {
        // Retour de flotte
        RestoreFleetToPlanet($FleetRow, true);
        doquery("DELETE FROM {{table}} WHERE fleet_id=" . $FleetRow["fleet_id"], 'fleets');
    }
}
Exemple #9
0
                $SQL .= "password\t\t= '" . $GLOBALS['DATABASE']->sql_escape($md5Password) . "', ";
                $SQL .= "email\t\t\t= '" . $GLOBALS['DATABASE']->sql_escape($AdminMail) . "', ";
                $SQL .= "email_2\t\t= '" . $GLOBALS['DATABASE']->sql_escape($AdminMail) . "', ";
                $SQL .= "ip_at_reg\t\t= '" . $_SERVER['REMOTE_ADDR'] . "', ";
                $SQL .= "lang\t\t\t= '" . $LNG->getLanguage() . "', ";
                $SQL .= "authlevel\t\t= " . AUTH_ADM . ", ";
                $SQL .= "dpath \t\t\t= '" . DEFAULT_THEME . "', ";
                $SQL .= "rights\t\t\t= '', ";
                $SQL .= "id_planet\t\t= 1, ";
                $SQL .= "universe\t\t= 1, ";
                $SQL .= "galaxy\t\t\t= 1, ";
                $SQL .= "system\t\t\t= 1, ";
                $SQL .= "planet\t\t\t= 2, ";
                $SQL .= "register_time\t= " . TIMESTAMP . ";";
                $GLOBALS['DATABASE']->query($SQL);
                require_once 'includes/functions/CreateOnePlanetRecord.php';
                $PlanetID = CreateOnePlanetRecord(1, 1, 1, 1, 1, '', true, AUTH_ADM);
                $SESSION = new Session();
                $SESSION->DestroySession();
                $SESSION->CreateSession(1, $AdminUsername, $PlanetID, 1, 3, DEFAULT_THEME);
                $_SESSION['admin_login'] = $md5Password;
                @unlink($enableInstallToolFile);
                $template->show('ins_step8.tpl');
                break;
        }
        break;
    default:
        $template->assign(array('intro_text' => $LNG['intro_text'], 'intro_welcome' => $LNG['intro_welcome'], 'intro_install' => $LNG['intro_install']));
        $template->show('ins_intro.tpl');
        break;
}
    $system = $_POST['system'];
    $planet = $_POST['planet'];
    $i = 0;
    $QueryS = doquery("SELECT * FROM {{table}} WHERE `galaxy` = '" . $galaxy . "' AND `system` = '" . $system . "' AND `planet` = '" . $planet . "'", "galaxy", true);
    $QueryS2 = doquery("SELECT * FROM {{table}} WHERE `id` = '" . $id . "'", "users", true);
    if (is_numeric($_POST['id']) && isset($_POST['id']) && !$QueryS && $QueryS2) {
        if ($galaxy < 1 or $system < 1 or $planet < 1 or !is_numeric($galaxy) or !is_numeric($system) or !is_numeric($planet)) {
            $Error .= '<tr><th colspan="2"><font color=red>' . $lang['po_complete_all'] . '</font></th></tr>';
            $i++;
        }
        if ($galaxy > MAX_GALAXY_IN_WORLD or $system > MAX_SYSTEM_IN_GALAXY or $planet > MAX_PLANET_IN_SYSTEM) {
            $Error .= '<tr><th colspan="2"><font color=red>' . $lang['po_complete_all2'] . '</font></th></tr>';
            $i++;
        }
        if ($i == 0) {
            CreateOnePlanetRecord($galaxy, $system, $planet, $id, '', '', false);
            $QueryS3 = doquery("SELECT * FROM {{table}} WHERE `id_owner` = '" . $id . "'", "planets", true);
            doquery("UPDATE {{table}} SET `id_level` = '" . $QueryS3['id_level'] . "' WHERE\r\n\t\t\t`galaxy` = '" . $galaxy . "' AND `system` = '" . $system . "' AND `planet` = '" . $planet . "' AND `planet_type` = '1'", "planets");
            $parse['display'] = '<tr><th colspan="2"><font color=lime>' . $lang['po_complete_succes'] . '</font></th></tr>';
        } else {
            $parse['display'] = $Error;
        }
    } else {
        $parse['display'] = '<tr><th colspan="2"><font color=red>' . $lang['po_complete_all'] . '</font></th></tr>';
    }
} elseif ($mode == 'borrar') {
    $id = $_POST['id'];
    if (is_numeric($id) && isset($id)) {
        $QueryS = doquery("SELECT * FROM {{table}} WHERE `id` = '" . $id . "'", "planets", true);
        if ($QueryS) {
            if ($QueryS['planet_type'] == '1') {
function ShowCreateUserAdmin($user)
{
    global $lang, $db, $displays, $users;
    if ($user['authlevel'] < 2) {
        die($displays->message($lang['not_enough_permissions']));
    }
    if ($_POST) {
        $errors = 0;
        $errorlist = "";
        $_POST['email'] = strip_tags($_POST['email']);
        if (!is_email($_POST['email'])) {
            $errorlist .= $lang['cu_invalid_mail'];
            $errors++;
        }
        if (!$_POST['character']) {
            $errorlist .= $lang['cu_empty_user_field'];
            $errors++;
        }
        if (strlen($_POST['passwrd']) < 4) {
            $errorlist .= $lang['cu_password_lenght_error'];
            $errors++;
        }
        if (preg_match("/[^A-z0-9_\\-]/", $_POST['character']) == 1) {
            $errorlist .= $lang['cu_user_field_no_alphanumeric'];
            $errors++;
        }
        $ExistUser = $db->query("SELECT `username` FROM {{table}} WHERE `username` = '" . mysql_escape_string($_POST['character']) . "' LIMIT 1;", 'users', true);
        if ($ExistUser) {
            $errorlist .= $lang['cu_user_already_exists'];
            $errors++;
        }
        $ExistMail = $db->query("SELECT `email` FROM {{table}} WHERE `email` = '" . mysql_escape_string($_POST['email']) . "' LIMIT 1;", 'users', true);
        if ($ExistMail) {
            $errorlist .= $lang['cu_mail_already_exists'];
            $errors++;
        }
        if ($errors != 0) {
            $displays->message($errorlist, "admin.php?page=createuser", "5", false, false);
        } else {
            $newpass = $_POST['passwrd'];
            $UserName = $_POST['character'];
            $UserEmail = $_POST['email'];
            $random = $_POST['random'];
            $galaxy = $_POST['galaxy'];
            $system = $_POST['system'];
            $planet = $_POST['planet'];
            $md5newpass = md5($newpass);
            $QryInsertUser = "******";
            $QryInsertUser .= "`username` = '" . mysql_escape_string(strip_tags(eregi_replace("'|\"", '', $UserName))) . "', ";
            $QryInsertUser .= "`email` = '" . mysql_escape_string($UserEmail) . "', ";
            $QryInsertUser .= "`email_2` = '" . mysql_escape_string($UserEmail) . "', ";
            $QryInsertUser .= "`ip_at_reg` = '" . $lang['cu_user'] . "', ";
            $QryInsertUser .= "`id_planet` = '0', ";
            $QryInsertUser .= "`register_time` = '" . time() . "', ";
            $QryInsertUser .= "`password`='" . $md5newpass . "';";
            $db->query($QryInsertUser, 'users');
            $NewUser = $db->query("SELECT `id`,`username`,`email_2` FROM {{table}} WHERE `username` = '" . mysql_escape_string($_POST['character']) . "' LIMIT 1;", 'users', true);
            if ($random == 'on') {
                $LastSettedGalaxyPos = $db->game_config['LastSettedGalaxyPos'] != 0 ? $db->game_config['LastSettedGalaxyPos'] : 1;
                $LastSettedSystemPos = $db->game_config['LastSettedSystemPos'] != 0 ? $db->game_config['LastSettedSystemPos'] : 1;
                $LastSettedPlanetPos = $db->game_config['LastSettedPlanetPos'] != 0 ? $db->game_config['LastSettedPlanetPos'] : 1;
                while (!isset($newpos_checked)) {
                    for ($Galaxy = $LastSettedGalaxyPos; $Galaxy <= MAX_GALAXY_IN_WORLD; $Galaxy++) {
                        for ($System = $LastSettedSystemPos; $System <= MAX_SYSTEM_IN_GALAXY; $System++) {
                            for ($Posit = $LastSettedPlanetPos; $Posit <= 4; $Posit++) {
                                $Planet = round(rand(4, 12));
                                switch ($LastSettedPlanetPos) {
                                    case 1:
                                        $LastSettedPlanetPos += 1;
                                        break;
                                    case 2:
                                        $LastSettedPlanetPos += 1;
                                        break;
                                    case 3:
                                        if ($LastSettedSystemPos == MAX_SYSTEM_IN_GALAXY) {
                                            $LastSettedGalaxyPos += 1;
                                            $LastSettedSystemPos = 1;
                                            $LastSettedPlanetPos = 1;
                                            break;
                                        } else {
                                            $LastSettedPlanetPos = 1;
                                        }
                                        $LastSettedSystemPos += 1;
                                        break;
                                }
                                break;
                            }
                            break;
                        }
                        break;
                    }
                    $QrySelectGalaxy = "SELECT * ";
                    $QrySelectGalaxy .= "FROM {{table}} ";
                    $QrySelectGalaxy .= "WHERE ";
                    $QrySelectGalaxy .= "`galaxy` = '" . $Galaxy . "' AND ";
                    $QrySelectGalaxy .= "`system` = '" . $System . "' AND ";
                    $QrySelectGalaxy .= "`planet` = '" . $Planet . "' ";
                    $QrySelectGalaxy .= "LIMIT 1;";
                    $GalaxyRow = $db->query($QrySelectGalaxy, 'galaxy', true);
                    if ($GalaxyRow["id_planet"] == "0") {
                        $newpos_checked = true;
                    }
                    if (!$GalaxyRow) {
                        CreateOnePlanetRecord($Galaxy, $System, $Planet, $NewUser['id'], $UserPlanet, '', '', '', true);
                        $newpos_checked = true;
                    }
                    if ($newpos_checked) {
                        $db->query("UPDATE {{table}} SET `config_value` = '" . $LastSettedGalaxyPos . "' WHERE `config_name` = 'LastSettedGalaxyPos';", 'config');
                        $db->query("UPDATE {{table}} SET `config_value` = '" . $LastSettedSystemPos . "' WHERE `config_name` = 'LastSettedSystemPos';", 'config');
                        $db->query("UPDATE {{table}} SET `config_value` = '" . $LastSettedPlanetPos . "' WHERE `config_name` = 'LastSettedPlanetPos';", 'config');
                    }
                }
                $PlanetID = $db->query("SELECT `id` FROM {{table}} WHERE `id_owner` = '" . $NewUser['id'] . "' LIMIT 1;", 'planets', true);
                $QryUpdateUser = "******";
                $QryUpdateUser .= "`id_planet` = '" . $PlanetID['id'] . "', ";
                $QryUpdateUser .= "`current_planet` = '" . $PlanetID['id'] . "', ";
                $QryUpdateUser .= "`galaxy` = '" . $Galaxy . "', ";
                $QryUpdateUser .= "`system` = '" . $System . "', ";
                $QryUpdateUser .= "`planet` = '" . $Planet . "' ";
                $QryUpdateUser .= "WHERE ";
                $QryUpdateUser .= "`id` = '" . $NewUser['id'] . "' ";
                $QryUpdateUser .= "LIMIT 1;";
                $db->query($QryUpdateUser, 'users');
            } else {
                $QrySelectGalaxy = "SELECT * ";
                $QrySelectGalaxy .= "FROM {{table}} ";
                $QrySelectGalaxy .= "WHERE ";
                $QrySelectGalaxy .= "`galaxy` = '" . $galaxy . "' AND ";
                $QrySelectGalaxy .= "`system` = '" . $system . "' AND ";
                $QrySelectGalaxy .= "`planet` = '" . $planet . "' ";
                $QrySelectGalaxy .= "LIMIT 1;";
                $GalaxyRow = $db->query($QrySelectGalaxy, 'galaxy', true);
                if ($GalaxyRow["id_planet"] == "0") {
                    $newpos_checked = true;
                }
                if (!$GalaxyRow) {
                    CreateOnePlanetRecord($galaxy, $system, $planet, $NewUser['id'], $UserPlanet, '', '', '', true);
                    $newpos_checked = true;
                }
                $PlanetID = $db->query("SELECT `id` FROM {{table}} WHERE `id_owner` = '" . $NewUser['id'] . "' LIMIT 1;", 'planets', true);
                $QryUpdateUser = "******";
                $QryUpdateUser .= "`id_planet` = '" . $PlanetID['id'] . "', ";
                $QryUpdateUser .= "`current_planet` = '" . $PlanetID['id'] . "', ";
                $QryUpdateUser .= "`galaxy` = '" . $galaxy . "', ";
                $QryUpdateUser .= "`system` = '" . $system . "', ";
                $QryUpdateUser .= "`planet` = '" . $planet . "' ";
                $QryUpdateUser .= "WHERE ";
                $QryUpdateUser .= "`id` = '" . $NewUser['id'] . "' ";
                $QryUpdateUser .= "LIMIT 1;";
                $db->query($QryUpdateUser, 'users');
            }
            if ($db->game_config["server_mail"]) {
                $url = dirname("http://" . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF']) . "/";
                $siteurlactivationlink = $url . 'activate.php?hash=' . base64_encode($NewUser['username']) . '&stamp=' . base64_encode($NewUser['id']);
                $body = "Bienvenido a " . $db->game_config["game_name"] . "<p>\r\n\r\n                            Te has registrado con el siguiente nombre de usuario: " . $NewUser['username'] . "<br>\r\n                            Y su contraseña es: " . $_POST['passwrd'] . " (conservala bien no podra recuperarlo)<p>\r\n\r\n                            Para jugar en " . $db->game_config["game_name"] . " es necesario que actives tu cuenta.<p>\r\n\r\n                            Has click en el siguiente link para confirmar tu registro.<br>\r\n                            <a href='" . $siteurlactivationlink . "'>" . $siteurlactivationlink . "</a><p>\r\n\r\n                            Si no puedes entrar pulsando el enlace superior.<br>\r\n                            Copia y pega el siguiente enlace en tu navegador y entra para validarte.<p>\r\n\r\n                            Desde la Administración de " . $db->game_config["game_name"] . " te agradecemos tu confianza<br>\r\n                            Y esperamos que estes aqui durante mucho tiempo.";
                include $svn_root . 'includes/functions/classes/class.phpmailer.php';
                $mail = new PHPMailer();
                $mail->IsSMTP();
                // telling the class to use SMTP
                $mail->Host = "mail.gmail.com";
                // SMTP server
                $mail->SMTPAuth = true;
                // enable SMTP authentication
                $mail->SMTPSecure = $db->game_config["sec_mail"];
                // sets the prefix to the servier
                $mail->Host = "smtp.gmail.com";
                // sets GMAIL as the SMTP server
                $mail->Port = $db->game_config["port_mail"];
                // set the SMTP port for the GMAIL server
                $mail->Username = $db->game_config["server_mail"];
                // GMAIL username
                $mail->Password = $db->game_config["pass_mail"];
                // GMAIL password
                $mail->SetFrom($db->game_config["server_mail"], $db->game_config["game_name"]);
                $mail->AddAddress($NewUser['email_2'], $NewUser['username']);
                $mail->Subject = "Registro de la cuenta.";
                $mail->MsgHTML($body);
                $mail->Send();
            }
            $from = $lang['cu_welcome_message_from'];
            $sender = $lang['cu_welcome_message_sender'];
            $Subject = $lang['cu_welcome_message_subject'];
            $message = $lang['cu_welcome_message_content'];
            $users->SendSimpleMessage($NewUser['id'], $sender, $Time, 1, $from, $Subject, $message);
            $db->query("UPDATE {{table}} SET `config_value` = `config_value` + '1' WHERE `config_name` = 'users_amount' LIMIT 1;", 'config');
            /*		@include('config.php');
            		$cookie = $NewUser['id'] . "/%/" . $UserName . "/%/" . md5($md5newpass . "--" . $dbsettings["secretword"]) . "/%/" . 0;
            		setcookie($db->game_config['COOKIE_NAME'], $cookie, 0, "/", "", 0);
            
            		unset($dbsettings);
            
            		header("location:game.php?page=overview"); */
            $displays->message($lang['cu_userok'], "admin.php?page=createuser", 1);
        }
    } else {
        $displays->assignContent("adm/create_user");
        $displays->display();
    }
}
Exemple #12
0
    }
    if ($i == '0') {
        $Query1 = "INSERT INTO {{table}} SET ";
        $Query1 .= "`username` = '" . mysql_escape_string(strip_tags($name)) . "', ";
        $Query1 .= "`email` = '" . mysql_escape_string($email) . "', ";
        $Query1 .= "`email_2` = '" . mysql_escape_string($email) . "', ";
        $Query1 .= "`ip_at_reg` = '" . $_SERVER["REMOTE_ADDR"] . "', ";
        $Query1 .= "`id_planet` = '0', ";
        $Query1 .= "`register_time` = '" . $time . "', ";
        $Query1 .= "`onlinetime` = '" . $time . "', ";
        $Query1 .= "`authlevel` = '" . $auth . "', ";
        $Query1 .= "`password`='" . $pass . "';";
        doquery($Query1, "users");
        doquery("UPDATE {{table}} SET `config_value` = config_value + '1' WHERE `config_name` = 'users_amount';", 'config');
        $ID_USER = doquery("SELECT `id` FROM {{table}} WHERE `username` = '" . mysql_escape_string($name) . "' LIMIT 1", "users", true);
        CreateOnePlanetRecord($galaxy, $system, $planet, $ID_USER['id'], $UserPlanet, true);
        $ID_PLANET = doquery("SELECT `id` FROM {{table}} WHERE `id_owner` = '" . $ID_USER['id'] . "' LIMIT 1", "planets", true);
        doquery("UPDATE {{table}} SET `id_level` = '" . $auth . "' WHERE `id` = '" . $ID_PLANET['id'] . "'", "planets");
        $QryUpdateUser = "******";
        $QryUpdateUser .= "`id_planet` = '" . $ID_PLANET['id'] . "', ";
        $QryUpdateUser .= "`current_planet` = '" . $ID_PLANET['id'] . "', ";
        $QryUpdateUser .= "`galaxy` = '" . $galaxy . "', ";
        $QryUpdateUser .= "`system` = '" . $system . "', ";
        $QryUpdateUser .= "`planet` = '" . $planet . "' ";
        $QryUpdateUser .= "WHERE ";
        $QryUpdateUser .= "`id` = '" . $ID_USER['id'] . "' ";
        $QryUpdateUser .= "LIMIT 1;";
        doquery($QryUpdateUser, "users");
        $parse['display'] = '<tr><th colspan="2"><font color=lime>' . $lang['new_user_success'] . '</font></tr></th>';
    }
}
Exemple #13
0
function ShowCreatorPage()
{
    global $LNG, $db, $USER;
    $template = new template();
    $template->page_header();
    switch ($_GET['mode']) {
        case 'user':
            includeLang('PUBLIC');
            if ($_POST) {
                $UserName = request_var('name', '', UTF8_SUPPORT);
                $UserPass = request_var('password', '');
                $UserPass2 = request_var('password2', '');
                $UserMail = request_var('email', '');
                $UserMail2 = request_var('email2', '');
                $UserLang = request_var('lang', '');
                $UserAuth = request_var('authlevel', 0);
                $Galaxy = request_var('galaxy', 0);
                $System = request_var('system', 0);
                $Planet = request_var('planet', 0);
                if ($CONF['capaktiv'] === '1') {
                    require_once 'includes/libs/reCAPTCHA/recaptchalib.php';
                    $resp = recaptcha_check_answer($CONF['capprivate'], $_SERVER['REMOTE_ADDR'], request_var('recaptcha_challenge_field', ''), request_var('recaptcha_response_field', ''));
                    if (!$resp->is_valid) {
                        $errorlist .= $LNG['wrong_captcha'];
                    }
                }
                $Exist['userv'] = $db->uniquequery("SELECT username, email FROM " . USERS . " WHERE username = '******' OR email = '" . $db->sql_escape($UserEmail) . "';");
                $Exist['vaild'] = $db->uniquequery("SELECT username, email FROM " . USERS_VALID . " WHERE username = '******' OR email = '" . $db->sql_escape($UserEmail) . "';");
                if (!ValidateAddress($UserMail)) {
                    $errors .= $LNG['invalid_mail_adress'];
                }
                if (empty($UserName)) {
                    $errors .= $LNG['empty_user_field'];
                }
                if (strlen($UserPass) < 6) {
                    $errors .= $LNG['password_lenght_error'];
                }
                if ($UserPass != $UserPass2) {
                    $errors .= $LNG['different_passwords'];
                }
                if ($UserMail != $UserMail2) {
                    $errors .= $LNG['different_mails'];
                }
                if (!CheckName($UserName)) {
                    $errors .= UTF8_SUPPORT ? $LNG['user_field_no_space'] : $LNG['user_field_no_alphanumeric'];
                }
                if (isset($Exist['userv']['username']) || isset($Exist['vaild']['username']) && ($UserName == $Exist['userv']['username'] || $UserName == $Exist['vaild']['username'])) {
                    $errors .= $LNG['user_already_exists'];
                }
                if ((isset($Exist['userv']['email']) || isset($Exist['vaild']['email'])) && ($UserEmail == $Exist['userv']['email'] || $UserEmail == $Exist['vaild']['email'])) {
                    $errors .= $LNG['mail_already_exists'];
                }
                if (CheckPlanetIfExist($Galaxy, $System, $Position)) {
                    $errors .= $LNG['planet_already_exists'];
                }
                if (!empty($errors)) {
                    $template->message($errors, '?page=create&mode=user', 3, true);
                    exit;
                }
                $SQL = "INSERT INTO " . USERS . " SET ";
                $SQL .= "`username` = '" . $db->sql_escape($UserName) . "', ";
                $SQL .= "`email` = '" . $db->sql_escape($UserMail) . "', ";
                $SQL .= "`email_2` = '" . $db->sql_escape($UserMail) . "', ";
                $SQL .= "`lang` = '" . $db->sql_escape($UserLang) . "', ";
                $SQL .= "`authlevel` = '" . $UserAuth . "', ";
                $SQL .= "`ip_at_reg` = '" . $_SERVER['REMOTE_ADDR'] . "', ";
                $SQL .= "`id_planet` = '0', ";
                $SQL .= "`onlinetime` = '" . TIMESTAMP . "', ";
                $SQL .= "`register_time` = '" . TIMESTAMP . "', ";
                $SQL .= "`password` = '" . md5($UserPass) . "', ";
                $SQL .= "`dpath` = '" . DEFAULT_SKINPATH . "', ";
                $SQL .= "`uctime`= '0';";
                $db->query($SQL);
                $db->query("UPDATE " . CONFIG . " SET `config_value` = config_value + '1' WHERE `config_name` = 'users_amount';");
                $ID_USER = $db->uniquequery("SELECT `id` FROM " . USERS . " WHERE `username` = '" . $db->sql_escape($UserName) . "';");
                require_once ROOT_PATH . 'includes/functions/CreateOnePlanetRecord.' . PHP_EXT;
                CreateOnePlanetRecord($Galaxy, $System, $Planet, $ID_USER['id'], $UserPlanet, true, $UserAuth);
                $ID_PLANET = $db->uniquequery("SELECT `id` FROM " . PLANETS . " WHERE `id_owner` = '" . $ID_USER['id'] . "';");
                $SQL = "UPDATE " . USERS . " SET ";
                $SQL .= "`id_planet` = '" . $ID_PLANET['id'] . "', ";
                $SQL .= "`galaxy` = '" . $Galaxy . "', ";
                $SQL .= "`system` = '" . $System . "', ";
                $SQL .= "`planet` = '" . $Planet . "' ";
                $SQL .= "WHERE ";
                $SQL .= "`id` = '" . $ID_USER['id'] . "' ";
                $SQL .= "LIMIT 1;";
                $db->query($SQL);
                $template->message($LNG['new_user_success'], '?page=create&mode=user', 3, true);
                exit;
            }
            $AUTH[0] = $LNG['user_level'][0];
            if ($USER['authlevel'] >= AUTH_OPS) {
                $AUTH[AUTH_OPS] = $LNG['user_level'][AUTH_OPS];
            }
            if ($USER['authlevel'] >= AUTH_MOD) {
                $AUTH[AUTH_MOD] = $LNG['user_level'][AUTH_MOD];
            }
            if ($USER['authlevel'] >= AUTH_ADM) {
                $AUTH[AUTH_ADM] = $LNG['user_level'][AUTH_ADM];
            }
            $template->assign_vars(array('new_add_user' => $LNG['new_add_user'], 'new_creator_refresh' => $LNG['new_creator_refresh'], 'new_creator_go_back' => $LNG['new_creator_go_back'], 'user_reg' => $LNG['user_reg'], 'pass_reg' => $LNG['pass_reg'], 'pass2_reg' => $LNG['pass2_reg'], 'email_reg' => $LNG['email_reg'], 'email2_reg' => $LNG['email2_reg'], 'new_coord' => $LNG['new_coord'], 'new_range' => $LNG['new_range'], 'new_title' => $LNG['new_title'], 'Selector' => $AUTH));
            $template->show('adm/CreatePageUser.tpl');
            break;
        case 'moon':
            if ($_POST) {
                $PlanetID = request_var('add_moon', 0);
                $MoonName = request_var('name', '', UTF8_SUPPORT);
                $Diameter = request_var('diameter', 0);
                $FieldMax = request_var('field_max', 0);
                $MoonPlanet = $db->uniquequery("SELECT `temp_max`, `temp_min`, `id_luna`, `galaxy`, `system`, `planet`, `planet_type`, `destruyed`, `id_level`, `id_owner` FROM " . PLANETS . " WHERE `id` = '" . $PlanetID . "' AND `planet_type` = '1' AND `destruyed` = '0';");
                if (!isset($MoonPlanet)) {
                    $template->message($LNG['mo_planet_doesnt_exist'], '?page=create&mode=moon', 3, true);
                    exit;
                }
                require_once ROOT_PATH . 'includes/functions/CreateOneMoonRecord.' . PHP_EXT;
                if (CreateOneMoonRecord($MoonPlanet['galaxy'], $MoonPlanet['system'], $MoonPlanet['planet'], $MoonPlanet['id_owner'], 0, $MoonName, 20, $_POST['diameter_check'] == 'on' ? 0 : $Diameter) !== false) {
                    $template->message($LNG['mo_moon_added'], '?page=create&mode=moon', 3, true);
                } else {
                    $template->message($LNG['mo_moon_unavaible'], '?page=create&mode=moon', 3, true);
                }
                exit;
            }
            $template->assign_vars(array('po_add_moon' => $LNG['po_add_moon'], 'input_id_planet' => $LNG['input_id_planet'], 'mo_moon_name' => $LNG['mo_moon_name'], 'mo_diameter' => $LNG['mo_diameter'], 'mo_temperature' => $LNG['mo_temperature'], 'mo_fields_avaibles' => $LNG['mo_fields_avaibles'], 'button_add' => $LNG['button_add'], 'new_creator_refresh' => $LNG['new_creator_refresh'], 'mo_moon' => $LNG['fcm_moon'], 'new_creator_go_back' => $LNG['new_creator_go_back']));
            $template->show('adm/CreatePageMoon.tpl');
            break;
        case 'planet':
            if ($_POST) {
                $id = request_var('id', 0);
                $Galaxy = request_var('galaxy', 0);
                $System = request_var('system', 0);
                $Planet = request_var('planet', 0);
                $name = request_var('name', '', UTF8_SUPPORT);
                $field_max = request_var('field_max', 0);
                $ISUser = $db->uniquequery("SELECT id, authlevel FROM " . USERS . " WHERE `id` = '" . $id . "';");
                if (CheckPlanetIfExist($Galaxy, $System, $Planet) || !isset($ISUser)) {
                    $template->message($LNG['po_complete_all'], '?page=create&mode=planet', 3, true);
                    exit;
                }
                require_once ROOT_PATH . 'includes/functions/CreateOnePlanetRecord.' . PHP_EXT;
                CreateOnePlanetRecord($Galaxy, $System, $Planet, $id, '', '', false);
                $SQL = "UPDATE " . PLANETS . " SET ";
                if ($_POST['diameter_check'] != 'on' || $field_max > 0) {
                    $SQL .= "`field_max` = '" . $field_max . "', ";
                }
                if (!empty($name)) {
                    $SQL .= "`name` = '" . $db->sql_escape($name) . "', ";
                }
                $SQL .= "`id_level` = '" . $ISUser['authlevel'] . "' ";
                $SQL .= "WHERE ";
                $SQL .= "`galaxy` = '" . $Galaxy . "' AND ";
                $SQL .= "`system` = '" . $System . "' AND ";
                $SQL .= "`planet` = '" . $Planet . "' AND ";
                $SQL .= "`planet_type` = '1'";
                $db->query($SQL);
                $template->message($LNG['po_complete_succes'], '?page=create&mode=planet', 3, true);
                exit;
            }
            $template->assign_vars(array('po_add_planet' => $LNG['po_add_planet'], 'po_galaxy' => $LNG['po_galaxy'], 'po_system' => $LNG['po_system'], 'po_planet' => $LNG['po_planet'], 'input_id_user' => $LNG['input_id_user'], 'new_creator_coor' => $LNG['new_creator_coor'], 'po_name_planet' => $LNG['po_name_planet'], 'po_fields_max' => $LNG['po_fields_max'], 'button_add' => $LNG['button_add'], 'po_colony' => $LNG['fcp_colony'], 'new_creator_refresh' => $LNG['new_creator_refresh'], 'new_creator_go_back' => $LNG['new_creator_go_back']));
            $template->show('adm/CreatePagePlanet.tpl');
            break;
        default:
            $template->assign_vars(array('new_creator_title_u' => $LNG['new_creator_title_u'], 'new_creator_title_p' => $LNG['new_creator_title_p'], 'new_creator_title_l' => $LNG['new_creator_title_l'], 'new_creator_title' => $LNG['new_creator_title']));
            $template->show('adm/CreatePage.tpl');
            break;
    }
}
    function TargetEvent()
    {
        global $resource;
        $iPlanetCount = $GLOBALS['DATABASE']->getFirstCell("SELECT COUNT(*) FROM " . PLANETS . " WHERE `id_owner` = '" . $this->_fleet['fleet_owner'] . "' AND `planet_type` = '1' AND `destruyed` = '0';");
        $iGalaxyPlace = $GLOBALS['DATABASE']->getFirstCell("SELECT COUNT(*) FROM " . PLANETS . " WHERE `id` = '" . $this->_fleet['fleet_end_id'] . "';");
        $senderUser = $GLOBALS['DATABASE']->getFirstRow("SELECT * FROM " . USERS . " WHERE `id` = '" . $this->_fleet['fleet_owner'] . "';");
        $senderPlanet = $GLOBALS['DATABASE']->getFirstRow("SELECT * FROM " . PLANETS . " WHERE `id` = '" . $this->_fleet['fleet_start_id'] . "';");
        $senderUser['factor'] = getFactors($senderUser, 'basic', $this->_fleet['fleet_start_time']);
        $LNG = $this->getLanguage($senderUser['lang']);
        $MaxPlanets = PlayerUtil::maxPlanetCount($senderUser);
        if ($iGalaxyPlace != 0) {
            $TheMessage = '<div style="text-align : justify;">
        ' . sprintf($LNG['ls_fts_colo_1'], $this->_fleet['fleet_end_system'], $this->_fleet['fleet_end_planet'], $LNG['type_missionbis'][$this->_fleet['fleet_mission']]) . '
    </div>
  
    <div class="citation">
        <div class="guillemet ouvrir">«</div>
        <div class="guillemet fermer">»</div>
        
        ' . $LNG['ls_fts_colo_2'] . ' :
        <ul style="text-align : left;">
            <li>' . $LNG['ls_fts_colo_3'] . '</li>
            <li>' . $LNG['ls_fts_colo_4'] . '</li>
            <li>' . $LNG['ls_fts_colo_5'] . '</li>
            <li>' . $LNG['ls_fts_colo_6'] . '</li>
            <li>' . $LNG['ls_fts_colo_7'] . '</li>
            <li>' . $LNG['ls_fts_colo_8'] . '</li>
        </ul>
    </div>
        
    <div class="explication_utilisateur">
        ' . $LNG['ls_fts_colo_9'] . '
    </div>';
            SendSimpleMessage($this->_fleet['fleet_owner'], 0, $this->_fleet['fleet_start_time'], 7, $LNG['sys_colo_mess_from_text1'], sprintf($LNG['sys_colo_mess_report1'], $this->_fleet['fleet_end_system'], $this->_fleet['fleet_end_planet']), $TheMessage);
            $this->setState(FLEET_RETURN);
        } elseif ($iPlanetCount >= $MaxPlanets) {
            $TheMessage = '<div style="text-align : justify;">
        ' . sprintf($LNG['ls_fts_colo_1'], $this->_fleet['fleet_end_system'], $this->_fleet['fleet_end_planet'], $LNG['type_missionbis'][$this->_fleet['fleet_mission']]) . '
    </div>
  
    <div class="citation">
        <div class="guillemet ouvrir">«</div>
        <div class="guillemet fermer">»</div>
        
        ' . $LNG['ls_fts_colo_2'] . ' :
        <ul style="text-align : left;">
            <li>' . $LNG['ls_fts_colo_3'] . '</li>
            <li>' . $LNG['ls_fts_colo_4'] . '</li>
            <li>' . $LNG['ls_fts_colo_5'] . '</li>
            <li>' . $LNG['ls_fts_colo_6'] . '</li>
            <li>' . $LNG['ls_fts_colo_7'] . '</li>
            <li>' . $LNG['ls_fts_colo_8'] . '</li>
        </ul>
    </div>
        
    <div class="explication_utilisateur">
        ' . $LNG['ls_fts_colo_9'] . '
    </div>';
            SendSimpleMessage($this->_fleet['fleet_owner'], 0, $this->_fleet['fleet_start_time'], 7, $LNG['sys_colo_mess_from_text1'], sprintf($LNG['sys_colo_mess_report1'], $this->_fleet['fleet_end_system'], $this->_fleet['fleet_end_planet']), $TheMessage);
            $this->setState(FLEET_RETURN);
        } else {
            $bonus_iron = mt_rand(1, 40);
            $bonus_gold = mt_rand(1, 40);
            $bonus_crys = mt_rand(1, 40);
            $bonus_elyr = mt_rand(1, 40);
            $Color = 'vert';
            $Color1 = 'vert';
            $Color2 = 'vert';
            $Color3 = 'vert';
            $bonus_iron_perc = rand(1, 55);
            $bonus_gold_perc = rand(1, 55);
            $bonus_crys_perc = rand(1, 55);
            $bonus_elyr_perc = rand(1, 55);
            if ($bonus_iron_perc >= $bonus_iron) {
                $bonus_iron *= -1;
                $Color = 'rouge';
            }
            if ($bonus_gold_perc >= $bonus_gold) {
                $bonus_gold *= -1;
                $Color1 = 'rouge';
            }
            if ($bonus_crys_perc >= $bonus_crys) {
                $bonus_crys *= -1;
                $Color2 = 'rouge';
            }
            if ($bonus_elyr_perc >= $bonus_elyr) {
                $bonus_elyr *= -1;
                $Color3 = 'rouge';
            }
            require_once 'includes/functions/CreateOnePlanetRecord.php';
            $NewOwnerPlanet = CreateOnePlanetRecord($this->_fleet['fleet_end_galaxy'], $this->_fleet['fleet_end_system'], $this->_fleet['fleet_end_planet'], $this->_fleet['fleet_universe'], $this->_fleet['fleet_owner'], $LNG['fcp_colony'], false, $senderUser['authlevel'], $bonus_iron, $bonus_gold, $bonus_crys, $bonus_elyr, $iPlanetCount);
            if ($NewOwnerPlanet === false) {
                $TheMessage = '<div style="text-align : justify;">
        ' . sprintf($LNG['ls_fts_colo_1'], $this->_fleet['fleet_end_system'], $this->_fleet['fleet_end_planet'], $LNG['type_missionbis'][$this->_fleet['fleet_mission']]) . '
    </div>
  
    <div class="citation">
        <div class="guillemet ouvrir">«</div>
        <div class="guillemet fermer">»</div>
        
        ' . $LNG['ls_fts_colo_2'] . ' :
        <ul style="text-align : left;">
            <li>' . $LNG['ls_fts_colo_3'] . '</li>
            <li>' . $LNG['ls_fts_colo_4'] . '</li>
            <li>' . $LNG['ls_fts_colo_5'] . '</li>
            <li>' . $LNG['ls_fts_colo_6'] . '</li>
            <li>' . $LNG['ls_fts_colo_7'] . '</li>
            <li>' . $LNG['ls_fts_colo_8'] . '</li>
        </ul>
    </div>
        
    <div class="explication_utilisateur">
        ' . $LNG['ls_fts_colo_9'] . '
    </div>';
                SendSimpleMessage($this->_fleet['fleet_owner'], 0, $this->_fleet['fleet_start_time'], 7, $LNG['sys_colo_mess_from_text1'], sprintf($LNG['sys_colo_mess_report1'], $this->_fleet['fleet_end_system'], $this->_fleet['fleet_end_planet']), $TheMessage);
                $this->setState(FLEET_RETURN);
            } else {
                $this->_fleet['fleet_end_id'] = $NewOwnerPlanet;
                $TheMessage = '<div style="text-align : justify;">
       ' . $LNG['sys_col_1'] . ' [' . $this->_fleet['fleet_end_system'] . ':' . $this->_fleet['fleet_end_planet'] . '].
         ' . $LNG['sys_col_2'] . ' :
    </div>

	<div class="citation">
        <div class="guillemet ouvrir">«</div>
        <div class="guillemet fermer">»</div>
                
       ' . $LNG['sys_col_3'] . '
    </div>
        
    <h3>' . $LNG['sys_col_4'] . ' : </h3>
    <div class="conteneur_item" style="margin-top : 5px;">
                <div class="element_item">
            <img src="/media/ingame/image/metal.jpg">
            ' . $LNG['sys_col_5'] . ' « ' . $LNG['tech'][901] . ' » : <span class="' . $Color . '">' . $bonus_iron . '%</span>
        </div>
                <div class="element_item">
            <img src="/media/ingame/image/oro.jpg">
            ' . $LNG['sys_col_5'] . ' « ' . $LNG['tech'][902] . ' » : <span class="' . $Color1 . '">' . $bonus_gold . '%</span>
        </div>
                <div class="element_item">
            <img src="/media/ingame/image/crystal.jpg">
            ' . $LNG['sys_col_5'] . ' « ' . $LNG['tech'][903] . ' » : <span class="' . $Color2 . '">' . $bonus_crys . '%</span>
        </div>
                <div class="element_item">
            <img src="/media/ingame/image/elyrium.jpg">
            ' . $LNG['sys_col_5'] . ' « ' . $LNG['tech'][904] . ' » : <span class="' . $Color3 . '">' . $bonus_elyr . '%</span>
        </div>
            </div>';
                $this->StoreGoodsToPlanet();
                if ($this->_fleet['fleet_amount'] == 1) {
                    $this->KillFleet();
                } else {
                    $CurrentFleet = explode(";", $this->_fleet['fleet_array']);
                    $NewFleet = '';
                    foreach ($CurrentFleet as $Item => $Group) {
                        if (empty($Group)) {
                            continue;
                        }
                        $Class = explode(",", $Group);
                        if ($Class[0] == 208 && $Class[1] > 1) {
                            $NewFleet .= $Class[0] . "," . ($Class[1] - 1) . ";";
                        } elseif ($Class[0] != 208 && $Class[1] > 0) {
                            $NewFleet .= $Class[0] . "," . $Class[1] . ";";
                        }
                    }
                    $this->UpdateFleet('fleet_array', $NewFleet);
                    $this->UpdateFleet('fleet_amount', $this->_fleet['fleet_amount'] - 1);
                    $this->UpdateFleet('fleet_resource_metal', 0);
                    $this->UpdateFleet('fleet_resource_crystal', 0);
                    $this->UpdateFleet('fleet_resource_deuterium', 0);
                    $this->UpdateFleet('fleet_resource_elyrium', 0);
                    $this->setState(FLEET_RETURN);
                }
                SendSimpleMessage($this->_fleet['fleet_owner'], 0, $this->_fleet['fleet_start_time'], 7, $LNG['sys_colo_mess_from_text'], sprintf($LNG['sys_colo_mess_report2'], $this->_fleet['fleet_end_system'], $this->_fleet['fleet_end_planet']), $TheMessage);
            }
        }
        $this->SaveFleet();
    }
Exemple #15
0
         }
         break;
     }
     $QrySelectGalaxy = "SELECT * ";
     $QrySelectGalaxy .= "FROM {{table}} ";
     $QrySelectGalaxy .= "WHERE ";
     $QrySelectGalaxy .= "`galaxy` = '" . $Galaxy . "' AND ";
     $QrySelectGalaxy .= "`system` = '" . $System . "' AND ";
     $QrySelectGalaxy .= "`planet` = '" . $Planet . "' ";
     $QrySelectGalaxy .= "LIMIT 1;";
     $GalaxyRow = doquery($QrySelectGalaxy, 'galaxy', true);
     if ($GalaxyRow["id_planet"] == "0") {
         $newpos_checked = true;
     }
     if (!$GalaxyRow) {
         CreateOnePlanetRecord($Galaxy, $System, $Planet, $NewUser['id'], $UserPlanet, true);
         $newpos_checked = true;
     }
     if ($newpos_checked) {
         doquery("UPDATE {{table}} SET `config_value` = '" . $LastSettedGalaxyPos . "' WHERE `config_name` = 'LastSettedGalaxyPos';", 'config');
         doquery("UPDATE {{table}} SET `config_value` = '" . $LastSettedSystemPos . "' WHERE `config_name` = 'LastSettedSystemPos';", 'config');
         doquery("UPDATE {{table}} SET `config_value` = '" . $LastSettedPlanetPos . "' WHERE `config_name` = 'LastSettedPlanetPos';", 'config');
     }
 }
 // Recherche de la reference de la nouvelle planete (qui est unique normalement !
 $PlanetID = doquery("SELECT `id` FROM {{table}} WHERE `id_owner` = '" . $NewUser['id'] . "' LIMIT 1;", 'planets', true);
 // Mise a jour de l'enregistrement utilisateur avec les infos de sa planete mere
 $QryUpdateUser = "******";
 $QryUpdateUser .= "`id_planet` = '" . $PlanetID['id'] . "', ";
 $QryUpdateUser .= "`current_planet` = '" . $PlanetID['id'] . "', ";
 $QryUpdateUser .= "`galaxy` = '" . $Galaxy . "', ";
Exemple #16
0
function ResetUniverse()
{
    global $db, $USER;
    $db->query("RENAME TABLE " . PLANETS . " TO " . PLANETS . "_s;");
    $db->query("RENAME TABLE " . USERS . " TO " . USERS . "_s;");
    $db->query("CREATE TABLE IF NOT EXISTS " . PLANETS . " ( LIKE " . PLANETS . "_s );");
    $db->query("CREATE TABLE IF NOT EXISTS " . USERS . " ( LIKE " . USERS . "_s );");
    $DelRW = $db->query("SELECT `rid` FROM " . RW . ";");
    if (isset($DelRW)) {
        while ($RID = $db->fetch_array($DelRW)) {
            @unlink(ROOT_PATH . 'raports/raport_' . $RID['rid'] . '.php');
        }
    }
    $db->free_result($DelRW);
    $TKBRW = $db->query("SELECT `rid` FROM " . TOPKB . ";");
    if (isset($TKBRW)) {
        while ($RID = $db->fetch_array($TKBRW)) {
            @unlink(ROOT_PATH . 'raports/topkb_' . $RID['rid'] . '.php');
        }
    }
    $db->free_result($TKBRW);
    $db->query("TRUNCATE TABLE " . AKS . ";");
    $db->query("TRUNCATE TABLE " . ALLIANCE . ";");
    $db->query("TRUNCATE TABLE " . BANNED . ";");
    $db->query("TRUNCATE TABLE " . BUDDY . ";");
    $db->query("TRUNCATE TABLE " . ERRORS . ";");
    $db->query("TRUNCATE TABLE " . FLEETS . ";");
    $db->query("TRUNCATE TABLE " . MESSAGES . ";");
    $db->query("TRUNCATE TABLE " . NOTES . ";");
    $db->query("TRUNCATE TABLE " . RW . ";");
    $db->query("TRUNCATE TABLE " . SUPP . ";");
    $db->query("TRUNCATE TABLE " . STATPOINTS . ";");
    $db->query("TRUNCATE TABLE " . TOPKB . ";");
    $AllUsers = $db->query("SELECT `username`,`password`,`email`, `email_2`,`authlevel`,`rights`,`galaxy`,`system`,`planet`, `dpath`, `onlinetime`, `register_time`, `id_planet` FROM " . USERS . "_s;");
    $LimitTime = TIMESTAMP - 30 * (24 * (60 * 60));
    $TransUser = 0;
    require_once ROOT_PATH . 'includes/functions/CreateOnePlanetRecord.' . PHP_EXT;
    while ($TheUser = $db->fetch_array($AllUsers)) {
        if ($TheUser['onlinetime'] <= $LimitTime) {
            continue;
        }
        $SQL = "INSERT INTO " . USERS . " SET ";
        $SQL .= "`username` = '" . $TheUser['username'] . "', ";
        $SQL .= "`email` = '" . $TheUser['email'] . "', ";
        $SQL .= "`email_2` = '" . $TheUser['email_2'] . "', ";
        $SQL .= "`id_planet` = '0', ";
        $SQL .= "`authlevel` = '" . $TheUser['authlevel'] . "', ";
        $SQL .= "`rights` = '" . $TheUser['rights'] . "', ";
        $SQL .= "`dpath` = '" . $TheUser['dpath'] . "', ";
        $SQL .= "`galaxy` = '" . $TheUser['galaxy'] . "', ";
        $SQL .= "`system` = '" . $TheUser['system'] . "', ";
        $SQL .= "`planet` = '" . $TheUser['planet'] . "', ";
        $SQL .= "`register_time` = '" . $TheUser['register_time'] . "', ";
        $SQL .= "`onlinetime` = '" . TIMESTAMP . "', ";
        $SQL .= "`password` = '" . $TheUser['password'] . "';";
        $db->query($SQL);
        $NewUser = $db->uniquequery("SELECT `id` FROM " . USERS . " WHERE `username` = '" . $TheUser['username'] . "' LIMIT 1;");
        $UserPlanet = $db->uniquequery("SELECT `name` FROM " . PLANETS . "_s WHERE `id` = '" . $TheUser['id_planet'] . "';");
        CreateOnePlanetRecord($TheUser['galaxy'], $TheUser['system'], $TheUser['planet'], $NewUser['id'], $UserPlanet['name'], true, $TheUser['authlevel']);
        $PlanetID = $db->uniquequery("SELECT `id` FROM " . PLANETS . " WHERE `id_owner` = '" . $NewUser['id'] . "' LIMIT 1;");
        $SQL = "UPDATE " . USERS . " SET `id_planet` = '" . $PlanetID['id'] . "' WHERE `id` = '" . $NewUser['id'] . "';";
        $db->query($SQL);
        $TransUser++;
    }
    $db->query("UPDATE " . CONFIG . " SET `config_value` = '" . $TransUser . "' WHERE `config_name` = 'users_amount' LIMIT 1;");
    $db->query("DROP TABLE " . PLANETS . "_s;");
    $db->query("DROP TABLE " . USERS . "_s;");
}
Exemple #17
0
function ShowCreatorPage()
{
    global $LNG, $USER, $UNI, $CONF;
    $template = new template();
    switch ($_GET['mode']) {
        case 'user':
            $LNG->includeData(array('PUBLIC'));
            if ($_POST) {
                $UserName = HTTP::_GP('name', '', UTF8_SUPPORT);
                $UserPass = HTTP::_GP('password', '');
                $UserPass2 = HTTP::_GP('password2', '');
                $UserMail = HTTP::_GP('email', '');
                $UserMail2 = HTTP::_GP('email2', '');
                $UserLang = HTTP::_GP('lang', '');
                $UserAuth = HTTP::_GP('authlevel', 0);
                $Galaxy = HTTP::_GP('galaxy', 0);
                $System = HTTP::_GP('system', 0);
                $Planet = HTTP::_GP('planet', 0);
                $ExistsUser = $GLOBALS['DATABASE']->getFirstCell("SELECT (SELECT COUNT(*) FROM " . USERS . " WHERE universe = " . $_SESSION['adminuni'] . " AND username = '******'DATABASE']->sql_escape($UserName) . "') + (SELECT COUNT(*) FROM " . USERS_VALID . " WHERE universe = " . $_SESSION['adminuni'] . " AND username = '******'DATABASE']->sql_escape($UserName) . "')");
                $ExistsMails = $GLOBALS['DATABASE']->getFirstCell("SELECT (SELECT COUNT(*) FROM " . USERS . " WHERE universe = " . $_SESSION['adminuni'] . " AND (email = '" . $GLOBALS['DATABASE']->sql_escape($UserMail) . "' OR email_2 = '" . $GLOBALS['DATABASE']->sql_escape($UserMail) . "')) + (SELECT COUNT(*) FROM " . USERS_VALID . " WHERE universe = " . $_SESSION['adminuni'] . " AND email = '" . $GLOBALS['DATABASE']->sql_escape($UserMail) . "')");
                if (!ValidateAddress($UserMail)) {
                    $errors .= $LNG['invalid_mail_adress'];
                }
                if (empty($UserName)) {
                    $errors .= $LNG['empty_user_field'];
                }
                if (strlen($UserPass) < 6) {
                    $errors .= $LNG['password_lenght_error'];
                }
                if ($UserPass != $UserPass2) {
                    $errors .= $LNG['different_passwords'];
                }
                if ($UserMail != $UserMail2) {
                    $errors .= $LNG['different_mails'];
                }
                if (!CheckName($UserName)) {
                    $errors .= $LNG['user_field_specialchar'];
                }
                if ($ExistsUser != 0) {
                    $errors .= $LNG['user_already_exists'];
                }
                if ($ExistsMails != 0) {
                    $errors .= $LNG['mail_already_exists'];
                }
                if (CheckPlanetIfExist($Galaxy, $System, $Planet, $_SESSION['adminuni'])) {
                    $errors .= $LNG['planet_already_exists'];
                }
                if ($Galaxy > Config::get('max_galaxy') || $System > Config::get('max_system') || $Planet > Config::get('max_planets')) {
                    $errors .= $LNG['po_complete_all2'];
                }
                if (!empty($errors)) {
                    $template->message($errors, '?page=create&mode=user', 10, true);
                    exit;
                }
                $SQL = "INSERT INTO " . USERS . " SET\n\t\t\t\tusername\t\t= '" . $GLOBALS['DATABASE']->sql_escape($UserName) . "',\n\t\t\t\tpassword\t\t= '" . cryptPassword($UserPass) . "',\n\t\t\t\temail\t\t\t= '" . $GLOBALS['DATABASE']->sql_escape($UserMail) . "',\n\t\t\t\temail_2\t\t\t= '" . $GLOBALS['DATABASE']->sql_escape($UserMail) . "',\n\t\t\t\tlang\t\t\t= '" . $GLOBALS['DATABASE']->sql_escape($UserLang) . "',\n\t\t\t\tauthlevel\t\t= " . $UserAuth . ",\n\t\t\t\tip_at_reg\t\t= '" . $_SERVER['REMOTE_ADDR'] . "',\n\t\t\t\tid_planet\t\t= 0,\n\t\t\t\tuniverse\t\t= " . $_SESSION['adminuni'] . ",\n\t\t\t\tonlinetime\t\t= " . TIMESTAMP . ",\n\t\t\t\tregister_time\t= " . TIMESTAMP . ",\n\t\t\t\tdpath\t\t\t= '" . DEFAULT_THEME . "',\n\t\t\t\ttimezone\t\t= '" . Config::get('timezone') . "',\n\t\t\t\tuctime\t\t\t= 0;";
                $GLOBALS['DATABASE']->query($SQL);
                $UserID = $GLOBALS['DATABASE']->GetInsertID();
                require_once 'includes/functions/CreateOnePlanetRecord.php';
                $PlanerID = CreateOnePlanetRecord($Galaxy, $System, $Planet, $_SESSION['adminuni'], $UserID, $LNG['fcm_planet'], true, $UserAuth);
                $SQL = "UPDATE " . USERS . " SET \n\t\t\t\tid_planet\t= " . $PlanerID . ",\n\t\t\t\tgalaxy\t\t= " . $Galaxy . ",\n\t\t\t\tsystem\t\t= " . $System . ",\n\t\t\t\tplanet\t\t= " . $Planet . "\n\t\t\t\tWHERE\n\t\t\t\tid\t\t\t= " . $UserID . ";\n\t\t\t\tINSERT INTO " . STATPOINTS . " SET \n\t\t\t\tid_owner\t= " . $UserID . ",\n\t\t\t\tuniverse\t= " . $_SESSION['adminuni'] . ",\n\t\t\t\tstat_type\t= 1,\n\t\t\t\ttech_rank\t= " . (Config::get('users_amount') + 1) . ",\n\t\t\t\tbuild_rank\t= " . (Config::get('users_amount') + 1) . ",\n\t\t\t\tdefs_rank\t= " . (Config::get('users_amount') + 1) . ",\n\t\t\t\tfleet_rank\t= " . (Config::get('users_amount') + 1) . ",\n\t\t\t\ttotal_rank\t= " . (Config::get('users_amount') + 1) . ";";
                $GLOBALS['DATABASE']->multi_query($SQL);
                Config::update(array('users_amount' => Config::get('users_amount') + 1));
                $template->message($LNG['new_user_success'], '?page=create&mode=user', 5, true);
                exit;
            }
            $AUTH = array();
            $AUTH[AUTH_USR] = $LNG['user_level'][AUTH_USR];
            if ($USER['authlevel'] >= AUTH_OPS) {
                $AUTH[AUTH_OPS] = $LNG['user_level'][AUTH_OPS];
            }
            if ($USER['authlevel'] >= AUTH_MOD) {
                $AUTH[AUTH_MOD] = $LNG['user_level'][AUTH_MOD];
            }
            if ($USER['authlevel'] >= AUTH_ADM) {
                $AUTH[AUTH_ADM] = $LNG['user_level'][AUTH_ADM];
            }
            $template->assign_vars(array('admin_auth' => $USER['authlevel'], 'new_add_user' => $LNG['new_add_user'], 'new_creator_refresh' => $LNG['new_creator_refresh'], 'new_creator_go_back' => $LNG['new_creator_go_back'], 'universe' => $LNG['mu_universe'], 'user_reg' => $LNG['user_reg'], 'pass_reg' => $LNG['pass_reg'], 'pass2_reg' => $LNG['pass2_reg'], 'email_reg' => $LNG['email_reg'], 'email2_reg' => $LNG['email2_reg'], 'new_coord' => $LNG['new_coord'], 'new_range' => $LNG['new_range'], 'lang_reg' => $LNG['lang_reg'], 'new_title' => $LNG['new_title'], 'Selector' => array('auth' => $AUTH, 'lang' => $LNG->getAllowedLangs(false))));
            $template->show('CreatePageUser.tpl');
            break;
        case 'moon':
            if ($_POST) {
                $PlanetID = HTTP::_GP('add_moon', 0);
                $MoonName = HTTP::_GP('name', '', UTF8_SUPPORT);
                $Diameter = HTTP::_GP('diameter', 0);
                $FieldMax = HTTP::_GP('field_max', 0);
                $MoonPlanet = $GLOBALS['DATABASE']->getFirstRow("SELECT temp_max, temp_min, id_luna, galaxy, system, planet, planet_type, destruyed, id_owner FROM " . PLANETS . " WHERE id = '" . $PlanetID . "' AND universe = '" . $_SESSION['adminuni'] . "' AND planet_type = '1' AND destruyed = '0';");
                if (!isset($MoonPlanet)) {
                    $template->message($LNG['mo_planet_doesnt_exist'], '?page=create&mode=moon', 3, true);
                    exit;
                }
                require_once 'includes/functions/CreateOneMoonRecord.php';
                if (empty($MoonName)) {
                    $MoonName = $LNG['type_planet'][3];
                }
                if (CreateOneMoonRecord($MoonPlanet['galaxy'], $MoonPlanet['system'], $MoonPlanet['planet'], $_SESSION['adminuni'], $MoonPlanet['id_owner'], $MoonName, 20, TIMESTAMP, $_POST['diameter_check'] == 'on' ? 0 : $Diameter) !== false) {
                    $template->message($LNG['mo_moon_added'], '?page=create&mode=moon', 3, true);
                } else {
                    $template->message($LNG['mo_moon_unavaible'], '?page=create&mode=moon', 3, true);
                }
                exit;
            }
            $template->assign_vars(array('admin_auth' => $USER['authlevel'], 'universum' => $LNG['mu_universe'], 'po_add_moon' => $LNG['po_add_moon'], 'input_id_planet' => $LNG['input_id_planet'], 'mo_moon_name' => $LNG['mo_moon_name'], 'mo_diameter' => $LNG['mo_diameter'], 'mo_temperature' => $LNG['mo_temperature'], 'mo_fields_avaibles' => $LNG['mo_fields_avaibles'], 'button_add' => $LNG['button_add'], 'new_creator_refresh' => $LNG['new_creator_refresh'], 'mo_moon' => $LNG['fcm_moon'], 'new_creator_go_back' => $LNG['new_creator_go_back']));
            $template->show('CreatePageMoon.tpl');
            break;
        case 'planet':
            if ($_POST) {
                $id = HTTP::_GP('id', 0);
                $Galaxy = HTTP::_GP('galaxy', 0);
                $System = HTTP::_GP('system', 0);
                $Planet = HTTP::_GP('planet', 0);
                $name = HTTP::_GP('name', '', UTF8_SUPPORT);
                $field_max = HTTP::_GP('field_max', 0);
                if ($Galaxy > Config::get('max_galaxy') || $System > Config::get('max_system') || $Planet > Config::get('max_planets')) {
                    $template->message($LNG['po_complete_all2'], '?page=create&mode=planet', 3, true);
                    exit;
                }
                $ISUser = $GLOBALS['DATABASE']->getFirstRow("SELECT id, authlevel FROM " . USERS . " WHERE id = '" . $id . "' AND universe = '" . $_SESSION['adminuni'] . "';");
                if (CheckPlanetIfExist($Galaxy, $System, $Planet, $_SESSION['adminuni']) || !isset($ISUser)) {
                    $template->message($LNG['po_complete_all'], '?page=create&mode=planet', 3, true);
                    exit;
                }
                require_once 'includes/functions/CreateOnePlanetRecord.php';
                CreateOnePlanetRecord($Galaxy, $System, $Planet, $_SESSION['adminuni'], $id, '', '', false);
                $SQL = "UPDATE " . PLANETS . " SET ";
                if ($_POST['diameter_check'] != 'on' || $field_max > 0) {
                    $SQL .= "field_max = '" . $field_max . "' ";
                }
                if (!empty($name)) {
                    $SQL .= ", name = '" . $GLOBALS['DATABASE']->sql_escape($name) . "' ";
                }
                $SQL .= "WHERE ";
                $SQL .= "universe = '" . $_SESSION['adminuni'] . "' AND ";
                $SQL .= "galaxy = '" . $Galaxy . "' AND ";
                $SQL .= "system = '" . $System . "' AND ";
                $SQL .= "planet = '" . $Planet . "' AND ";
                $SQL .= "planet_type = '1'";
                $GLOBALS['DATABASE']->query($SQL);
                $template->message($LNG['po_complete_succes'], '?page=create&mode=planet', 3, true);
                exit;
            }
            $Query = $GLOBALS['DATABASE']->query("SELECT uni, game_name FROM " . CONFIG . " ORDER BY uni ASC;");
            while ($Unis = $GLOBALS['DATABASE']->fetch_array($Query)) {
                $AvailableUnis[$Unis['uni']] = $Unis;
            }
            $template->assign_vars(array('AvailableUnis' => $AvailableUnis, 'admin_auth' => $USER['authlevel'], 'universum' => $LNG['mu_universe'], 'po_add_planet' => $LNG['po_add_planet'], 'po_galaxy' => $LNG['po_galaxy'], 'po_system' => $LNG['po_system'], 'po_planet' => $LNG['po_planet'], 'input_id_user' => $LNG['input_id_user'], 'new_creator_coor' => $LNG['new_creator_coor'], 'po_name_planet' => $LNG['po_name_planet'], 'po_fields_max' => $LNG['po_fields_max'], 'button_add' => $LNG['button_add'], 'po_colony' => $LNG['fcp_colony'], 'new_creator_refresh' => $LNG['new_creator_refresh'], 'new_creator_go_back' => $LNG['new_creator_go_back']));
            $template->show('CreatePagePlanet.tpl');
            break;
        default:
            $template->assign_vars(array('new_creator_title_u' => $LNG['new_creator_title_u'], 'new_creator_title_p' => $LNG['new_creator_title_p'], 'new_creator_title_l' => $LNG['new_creator_title_l'], 'new_creator_title' => $LNG['new_creator_title']));
            $template->show('CreatePage.tpl');
            break;
    }
}
Exemple #18
0
     }
 }
 if (!empty($errors)) {
     message(implode('<br>', $errors), $lang['Reg_InvalidForm']);
 } else {
     $data = array('username' => $formData['character'], 'email' => $formData['email'], 'email_2' => $formData['email'], 'sex' => $formData['sex'], 'ip_at_reg' => $_SERVER['REMOTE_ADDR'], 'register_time' => new Zend_Db_Expr('UNIX_TIMESTAMP()'), 'password' => md5($formData['passwrd']));
     $readConnection->insert($readConnection->getDeprecatedTable('users'), $data);
     $userId = $readConnection->lastInsertId($readConnection->getDeprecatedTable('users'));
     $galaxy = $game_config['LastSettedSystemPos'] == MAX_SYSTEM_IN_GALAXY ? $game_config['LastSettedGalaxyPos'] + 1 : (int) $game_config['LastSettedGalaxyPos'];
     if ($galaxy != $game_config['LastSettedGalaxyPos']) {
         $system = 1;
     } else {
         $system = $game_config['LastSettedPlanetPos'] == 12 ? $game_config['LastSettedSystemPos'] + 1 : (int) $game_config['LastSettedSystemPos'];
     }
     $planet = $game_config['LastSettedPlanetPos'] == 12 ? 4 : $game_config['LastSettedPlanetPos'] + 4;
     $planetId = CreateOnePlanetRecord($galaxy, $system, $planet, $userId, $formData['planet'], true);
     $readConnection->update($readConnection->getDeprecatedTable('config'), array('config_value' => $galaxy), array('config_name =?' => 'LastSettedGalaxyPos'));
     $readConnection->update($readConnection->getDeprecatedTable('config'), array('config_value' => $system), array('config_name =?' => 'LastSettedSystemPos'));
     $readConnection->update($readConnection->getDeprecatedTable('config'), array('config_value' => $planet), array('config_name =?' => 'LastSettedPlanetPos'));
     $planetData = array('id_planet' => $planetId, 'current_planet' => $planetId, 'galaxy' => $galaxy, 'system' => $system, 'planet' => $planet);
     $readConnection->update($readConnection->getDeprecatedTable('users'), $planetData, array('id =?' => $userId));
     SendSimpleMessage($userId, 'Admin', time(), 1, $lang['Reg_SenderMessageIg'], $lang['Reg_SubjectMessageIg'], $lang['Reg_TextMessageIg']);
     $readConnection->update($readConnection->getDeprecatedTable('config'), array('config_value' => 'users_amount + 1'), array('config_name =?' => 'users_amount'));
     if (($x = sendPassMail($formData['email'], $formData['passwrd'])) == true) {
         $message = $lang['Reg_ThanksForRegistry'] . " ({$formData['email']})";
     } else {
         $message = $lang['Reg_ThanksForRegistry'] . " ({$formData['email']})";
         $message .= "<br><br>{$lang['error_mailsend']}<b>{$formData['passwrd']}</b>";
     }
     message($message, $lang['Reg_WellDone']);
 }
Exemple #19
0
         }
         break;
     }
     $QrySelectGalaxy = "SELECT * ";
     $QrySelectGalaxy .= "FROM {{table}} ";
     $QrySelectGalaxy .= "WHERE ";
     $QrySelectGalaxy .= "`galaxy` = '" . $Galaxy . "' AND ";
     $QrySelectGalaxy .= "`system` = '" . $System . "' AND ";
     $QrySelectGalaxy .= "`planet` = '" . $Planet . "' ";
     $QrySelectGalaxy .= "LIMIT 1;";
     $GalaxyRow = doquery($QrySelectGalaxy, 'galaxy', true);
     if ($GalaxyRow["id_planet"] == "0") {
         $newpos_checked = true;
     }
     if (!$GalaxyRow) {
         CreateOnePlanetRecord($Galaxy, $System, $Planet, $NewUser['id'], $lang['sys_pp_defaultname'], true);
         $newpos_checked = true;
     }
     if ($newpos_checked) {
         doquery("UPDATE {{table}} SET `config_value` = '" . $LastSettedGalaxyPos . "' WHERE `config_name` = 'LastSettedGalaxyPos';", 'config');
         doquery("UPDATE {{table}} SET `config_value` = '" . $LastSettedSystemPos . "' WHERE `config_name` = 'LastSettedSystemPos';", 'config');
         doquery("UPDATE {{table}} SET `config_value` = '" . $LastSettedPlanetPos . "' WHERE `config_name` = 'LastSettedPlanetPos';", 'config');
     }
 }
 $PlanetID = doquery("SELECT `id` FROM {{table}} WHERE `id_owner` = '" . $NewUser['id'] . "' LIMIT 1;", 'planets', true);
 $QryUpdateUser = "******";
 $QryUpdateUser .= "`id_planet` = '" . $PlanetID['id'] . "', ";
 $QryUpdateUser .= "`current_planet` = '" . $PlanetID['id'] . "', ";
 $QryUpdateUser .= "`galaxy` = '" . $Galaxy . "', ";
 $QryUpdateUser .= "`system` = '" . $System . "', ";
 $QryUpdateUser .= "`planet` = '" . $Planet . "' ";
Exemple #20
0
        if ($LastSettedPlanetPos < 3) {
            $LastSettedPlanetPos += 1;
        } else {
            if ($LastSettedSystemPos > $CONF['max_system']) {
                $LastSettedGalaxyPos += 1;
                $LastSettedSystemPos = 1;
                $LastSettedPlanetPos = 1;
            } else {
                $LastSettedSystemPos += 1;
                $LastSettedPlanetPos = 1;
            }
            if ($LastSettedGalaxyPos > $CONF['max_system']) {
                $LastSettedGalaxyPos = 1;
            }
        }
        $PlanetID = CreateOnePlanetRecord($LastSettedGalaxyPos, $LastSettedSystemPos, $Planet, $UNI, $NewUser, $UserPlanet, true);
    }
    $SQL = "UPDATE " . USERS . " SET ";
    $SQL .= "`id_planet` = '" . $PlanetID . "', ";
    $SQL .= "`universe` = '" . $UNI . "', ";
    $SQL .= "`galaxy` = '" . $LastSettedGalaxyPos . "', ";
    $SQL .= "`system` = '" . $LastSettedSystemPos . "', ";
    $SQL .= "`planet` = '" . $Planet . "' ";
    $SQL .= "WHERE ";
    $SQL .= "`id` = '" . $NewUser . "' ";
    $SQL .= "LIMIT 1;";
    $GLOBALS['DATABASE']->query($SQL);
    $SQL = "INSERT INTO " . BOTS . " (`id`, `player`, `last_time`, `every_time`, `last_planet`, `type`) VALUES (NULL, " . $NewUser . ", 0, 2, " . $PlanetID . ", 0);";
    $GLOBALS['DATABASE']->query($SQL);
    echo "OK - " . $Num . " - " . $NewUser . "<br>\r\n";
}
Exemple #21
0
function XNovaResetUnivers($CurrentUser)
{
    global $lang, $Adminerlaubt, $user;
    if ($user['username'] == Metusalem and in_array($user['id'], $Adminerlaubt)) {
        doquery("RENAME TABLE {{table}} TO {{table}}_s", 'planets');
        doquery("RENAME TABLE {{table}} TO {{table}}_s", 'users');
        doquery("CREATE  TABLE IF NOT EXISTS {{table}} ( LIKE {{table}}_s );", 'planets');
        doquery("CREATE  TABLE IF NOT EXISTS {{table}} ( LIKE {{table}}_s );", 'users');
        doquery("TRUNCATE TABLE {{table}}", 'aks');
        doquery("TRUNCATE TABLE {{table}}", 'alliance');
        doquery("TRUNCATE TABLE {{table}}", 'annonce');
        doquery("TRUNCATE TABLE {{table}}", 'banned');
        doquery("TRUNCATE TABLE {{table}}", 'buddy');
        doquery("TRUNCATE TABLE {{table}}", 'chat');
        doquery("TRUNCATE TABLE {{table}}", 'galaxy');
        doquery("TRUNCATE TABLE {{table}}", 'errors');
        doquery("TRUNCATE TABLE {{table}}", 'fleets');
        doquery("TRUNCATE TABLE {{table}}", 'iraks');
        doquery("TRUNCATE TABLE {{table}}", 'lunas');
        doquery("TRUNCATE TABLE {{table}}", 'messages');
        doquery("TRUNCATE TABLE {{table}}", 'notes');
        doquery("TRUNCATE TABLE {{table}}", 'rw');
        doquery("TRUNCATE TABLE {{table}}", 'statpoints');
        $AllUsers = doquery("SELECT `username`,`password`,`email`, `email_2`,`authlevel`,`galaxy`,`system`,`planet`, `volk`, `sex`, `avatar`, `dpath`, `onlinetime`, `register_time`, `id_planet` FROM {{table}} WHERE 1;", 'users_s');
        $LimitTime = time() - 15 * (24 * (60 * 60));
        $TransUser = 0;
        while ($TheUser = mysql_fetch_assoc($AllUsers)) {
            if ($TheUser['onlinetime'] > $LimitTime) {
                $UserPlanet = doquery("SELECT `name` FROM {{table}} WHERE `id` = '" . $TheUser['id_planet'] . "';", 'planets_s', true);
                if ($UserPlanet['name'] != "") {
                    $QryInsertUser = "******";
                    $QryInsertUser .= "`username` = '" . $TheUser['username'] . "', ";
                    $QryInsertUser .= "`email` = '" . $TheUser['email'] . "', ";
                    $QryInsertUser .= "`email_2` = '" . $TheUser['email_2'] . "', ";
                    $QryInsertUser .= "`volk` = '" . $TheUser['volk'] . "', ";
                    $QryInsertUser .= "`sex` = '" . $TheUser['sex'] . "', ";
                    $QryInsertUser .= "`avatar` = '" . $TheUser['avatar'] . "', ";
                    $QryInsertUser .= "`id_planet` = '1', ";
                    $QryInsertUser .= "`authlevel` = '" . $TheUser['authlevel'] . "', ";
                    $QryInsertUser .= "`dpath` = '" . $TheUser['dpath'] . "', ";
                    $QryInsertUser .= "`galaxy` = '" . $TheUser['galaxy'] . "', ";
                    $QryInsertUser .= "`system` = '" . $TheUser['system'] . "', ";
                    $QryInsertUser .= "`planet` = '" . $TheUser['planet'] . "', ";
                    $QryInsertUser .= "`register_time` = '" . $TheUser['register_time'] . "', ";
                    $QryInsertUser .= "`password` = '" . $TheUser['password'] . "';";
                    doquery($QryInsertUser, 'users');
                    $NewUser = doquery("SELECT `id` FROM {{table}} WHERE `username` = '" . $TheUser['username'] . "' LIMIT 1;", 'users', true);
                    CreateOnePlanetRecord($TheUser['galaxy'], $TheUser['system'], $TheUser['planet'], $NewUser['id'], $UserPlanet['name'], true);
                    $PlanetID = doquery("SELECT `id` FROM {{table}} WHERE `id_owner` = '" . $NewUser['id'] . "' LIMIT 1;", 'planets', true);
                    $QryUpdateUser = "******";
                    $QryUpdateUser .= "`id_planet` = '" . $PlanetID['id'] . "', ";
                    $QryUpdateUser .= "`current_planet` = '" . $PlanetID['id'] . "' ";
                    $QryUpdateUser .= "WHERE ";
                    $QryUpdateUser .= "`id` = '" . $NewUser['id'] . "';";
                    doquery($QryUpdateUser, 'users');
                    $TransUser++;
                }
            }
        }
        doquery("UPDATE {{table}} SET `config_value` = '" . $TransUser . "' WHERE `config_name` = 'users_amount' LIMIT 1;", 'config');
        //Piraten einfügen in Galaxy
        $QryTableGalaxypirat = "INSERT INTO `{{table}}` (`galaxy`, `system`, `planet`, `id_planet`, `metal`, `crystal`,  `deuterium`, `appolonium`,`id_luna`, `luna`) VALUES";
        $QryTableGalaxypirat .= "(1, 22, 7, 2, 0, 0, 0, 0, 0, 0),";
        $QryTableGalaxypirat .= "(1, 27, 12, 3, 0, 0, 0, 0, 0, 0),";
        $QryTableGalaxypirat .= "(1, 40, 6, 4, 0, 0, 0, 0, 0, 0);";
        doquery($QryTableGalaxypirat, 'galaxy');
        //Ende
        //Pirat einfügen in Planets
        $QryTablePlanetspirat = "INSERT INTO `{{table}}` (`id`, `name`, `id_owner`, `id_level`, `galaxy`, `system`, `planet`, `last_update`, `planet_type`, `destruyed`, `b_building`, `b_building_id`, `b_tech`, `b_tech_id`, `b_hangar`, `b_hangar_id`, `b_hangar_plus`, `image`, `diameter`, `points`, `ranks`, `field_current`, `field_max`, `temp_min`, `temp_max`, `metal`, `metal_perhour`, `metal_max`, `crystal`, `crystal_perhour`, `crystal_max`, `deuterium`, `deuterium_perhour`, `deuterium_max`, `appolonium`, `appolonium_perhour`, `appolonium_max`, `energy_used`, `energy_max`, `metal_mine`, `crystal_mine`, `deuterium_sintetizer`, `appolonium_mine`,`solar_plant`, `fusion_plant`, `robot_factory`, `nano_factory`, `hangar`, `defence_factory`, `metal_store`, `crystal_store`, `deuterium_store`, `appolonium_store`, `laboratory`, `technodrom`, `ressgate`, `mondtransformer`, `terraformer`, `ally_deposit`, `silo`, `small_ship_cargo`, `big_ship_cargo`, `light_hunter`, `heavy_hunter`, `crusher`, `battle_ship`, `colonizer`, `recycler`, `spy_sonde`, `bomber_ship`, `solar_satelit`, `destructor`, `dearth_star`, `battleship`, `lune_noir`, `ev_transporter`, `star_crasher`, `giga_recykler`, `misil_launcher`, `small_laser`, `big_laser`, `gauss_canyon`, `ionic_canyon`, `buster_canyon`, `Gravitonka`, `small_protection_shield`, `big_protection_shield`, `gig_protection_shield`, `interceptor_misil`, `interplanetary_misil`, `metal_mine_porcent`, `crystal_mine_porcent`, `deuterium_sintetizer_porcent`, `appolonium_mine_porcent`, `solar_plant_porcent`, `fusion_plant_porcent`, `solar_satelit_porcent`, `mondbasis`, `phalanx`, `sprungtor`, `last_jump_time`, `last_beam_time`, `deuterium_used`) VALUES";
        $QryTablePlanetspirat .= "(2, 'Piratentraum', 2, 0, 1, 22, 7, 1269344553, 1, 0, 0, '0', 0, 0, 0, '', 0, 'piratenplanet', 74475, 844901055, 0, 292, 1000, -11, 29, 1373487083, 222862, 60455000000, 1093524482, 148574, 60455000000, 756888034, 90557, 60455000000, 0, 0, 15000000, -314091, 1643471, 30, 30, 30, 0, 50, 0, 16, 12, 22, 1, 20, 20, 20, 0, 20, 0, 0, 1, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 10000, 0, 5000, 5000, 10000, 1000, 0, 1893, 19367, 0, 1851, 1537, 5726, 5700, '', '', '', 0, 0, 10, 10, 10, 10, 10, 10, 10, 0, 0, 0, 0, 0, 0, 0, '0'),";
        $QryTablePlanetspirat .= "(3, 'Piratenbay', 3, 0, 1, 27, 12, 1268088532, 1, 0, 0, '0', 0, 0, 0, '', 0, 'piratenplanet', 74475, 79382496920, 0, 126, 1000, -68, -28, 7625585342, 0, 15000000, 3786419255, 0, 15000000, 209142083, 0, 15000000, 15428405293, 0, 15000000, 0, 0, 0, 0, 0, 0, 0, 0, 11, 25, 20, 18, 0, 0, 0, 0, 22, 0, 0, 0, 30, 23898, 95964, 10000, 10000, 20000, 21996, 0, 0, 0, 12000, 0, 25000, 30300, 53003, 23000, 30000, 54000, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0', 0, 0, 10, 10, 10, 10, 10, 10, 10, 0, 0, 0, 0, 0, 0, 0, '0'),";
        $QryTablePlanetspirat .= "(4, 'Pirateninsel', 4, 0, 1, 40, 6, 1268088673, 1, 0, 0, '0', 0, 0, 0, '', 0, 'piratenplanet', 74475, 25536577446, 0, 319, 1000, 65, 105, 19814353549, 7820799, 154750000000, 2399046214, 4093531, 154750000000, 2935250625, 1714689, 154750000000, 12384079222, 0, 15000000, -7991672, 16904282, 40, 38, 0, 36, 50, 0, 18, 20, 22, 0, 22, 22, 22, 0, 16, 0, 0, 1, 12, 1832, 0, 0, 0, 0, 0, 0, 0, 0, 4113, 0, 5545, 24254, 0, 12276, 0, 50150, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 0, 10, 10, 10, 10, 10, 10, 10, 0, 0, 0, 0, 0, 0, 0, '0');";
        doquery($QryTablePlanetspirat, 'planets');
        //Ende
        //Pirat einfügen in Users
        $QryTableUserspirat = "INSERT INTO `{{table}}` (`id`, `username`, `password`, `email`, `email_2`, `lang`, `authlevel`, `volk`, `sex`, `avatar`, `sign`, `id_planet`, `galaxy`, `system`, `planet`, `current_planet`, `user_lastip`, `ip_at_reg`, `user_agent`, `current_page`, `register_time`, `onlinetime`, `dpath`, `design`, `noipcheck`, `planet_sort`, `planet_sort_order`, `spio_anz`, `settings_tooltiptime`, `settings_fleetactions`, `settings_allylogo`, `settings_esp`, `settings_wri`, `settings_bud`, `settings_mis`, `settings_rep`, `urlaubs_modus`, `urlaubs_modus_time`, `urlaubs_until`, `db_deaktjava`, `new_message`, `fleet_shortcut`, `b_tech_planet`, `spy_tech`, `prod_op`, `computer_tech`, `military_tech`, `defence_tech`, `shield_tech`, `energy_tech`, `hyperspace_tech`, `combustion_tech`, `impulse_motor_tech`, `hyperspace_motor_tech`, `laser_tech`, `ionic_tech`, `buster_tech`, `intergalactic_tech`, `expedition_tech`, `graviton_tech`, `ally_id`, `ally_name`, `ally_request`, `ally_request_text`, `ally_register_time`, `ally_rank_id`, `current_luna`, `kolorminus`, `kolorplus`, `kolorpoziom`, `rpg_geologue`, `rpg_amiral`, `rpg_ingenieur`, `rpg_technocrate`, `rpg_espion`, `rpg_constructeur`, `rpg_scientifique`, `rpg_commandant`, `rpg_points`, `rpg_stockeur`, `rpg_defenseur`, `rpg_destructeur`, `rpg_general`, `rpg_bunker`, `rpg_raideur`, `rpg_empereur`, `lvl_minier`, `lvl_raid`, `xpraid`, `xpminier`, `raids`, `p_infligees`, `mnl_alliance`, `mnl_joueur`, `mnl_attaque`, `mnl_spy`, `mnl_exploit`, `mnl_transport`, `mnl_expedition`, `mnl_general`, `mnl_buildlist`, `bana`, `multi_validated`, `banaday`, `raids1`, `raidswin`, `raidsloose`, `wons`, `loos`, `draws`, `kbmetal`, `kbcrystal`, `kbappolonium`, `lostunits`, `desunits`, `inaktivitaet`, `deltime`, `NoteOp`, `angriffszone`) VALUES";
        $QryTableUserspirat .= "(2, 'Sorry', 'd3e9a99a09a8c6d7fb8c78cf4e5a9a2c', '*****@*****.**', '*****@*****.**', 'de', 0, 'A', 'M', 'A', NULL, 2, 1, 22, 7, 2, '101.96.157.19', '', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)', '/V4/galaxy.php?mode=0', 1262876845, 1269344553, '', 1, 1, 0, 0, 1, 5, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, NULL, 0, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 9, 0, ' ', 0, NULL, 0, 0, 0, 'red', '#00FF00', 'yellow', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 22, 0, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 10, 12, 16, 11, 1, 826982958900, 404100470600, 0, 1663651468000, 528635861544, 1, 0, NULL, 15),";
        $QryTableUserspirat .= "(3, 'Piratenbraut', 'd3e9a99a09a8c6d7fb8c78cf4e5a9a2c', '*****@*****.**', '*****@*****.**', 'de', 0, 'B', 'F', 'http://metusalem.spacequadrat.de/XNovav3/images/Piratenbraut.gif', NULL, 3, 1, 27, 12, 3, '102.130.71.234', '', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.2) Gecko/20100115 Firefox/3.6 (.NET CLR 3.5.30729)', '/V4/logout.php', 1264720663, 1268088537, '', 1, 1, 0, 0, 1, 5, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, NULL, 0, 40, 22, 20, 30, 30, 30, 20, 20, 30, 28, 26, 25, 20, 20, 14, 20, 9, 0, ' ', 0, NULL, 0, 0, 0, '', '', '', 13, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 1, 18, 357, 0, 357, 0, 0, 5, 436, 13, 0, 2, 0, 0, 2, 0, NULL, 0, NULL, 59, 298, 60, 303, 6, 78538938741600, 39038059820800, 0, 181926332209000, 5103990687710, 1, 0, NULL, 15),";
        $QryTableUserspirat .= "(4, 'Rotzloeffel', 'd3e9a99a09a8c6d7fb8c78cf4e5a9a2c', '*****@*****.**', '*****@*****.**', 'de', 0, 'C', 'M', 'C', NULL, 4, 1, 40, 6, 4, '103.130.71.234', '', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.2) Gecko/20100115 Firefox/3.6 (.NET CLR 3.5.30729)', '/V4/overview.php', 1266780179, 1268088673, '', 1, 1, 0, 0, 1, 5, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, NULL, 0, 30, 22, 20, 33, 33, 33, 22, 20, 22, 21, 20, 25, 20, 20, 14, 15, 9, 0, ' ', 0, NULL, 0, 0, 0, 'red', '#00FF00', 'yellow', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 28, 0, 28, 0, 0, 1, 44, 2, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 11, 17, 20, 13, 0, 2937103255370, 1754575698710, 0, 7528558047000, 1484141972300, 0, 0, NULL, 15);";
        doquery($QryTableUserspirat, 'users');
        //Ende
        doquery("DROP TABLE {{table}}", 'planets_s');
        doquery("DROP TABLE {{table}}", 'users_s');
        AdminMessage($TransUser . $lang['adm_rz_done'], $lang['adm_rz_ttle']);
    } else {
        AdminMessage($lang['sys_noalloaw'], $lang['sys_noaccess']);
    }
    return $Page;
}
function ResetThisFuckingCheater($UserID)
{
    global $lang, $user;
    includeLang('error/cheat');
    $page = $lang;
    $TheUser = doquery("SELECT * FROM {{table}} WHERE `id` = '" . $UserID . "';", 'users', true);
    $UserPlanet = doquery("SELECT `name` FROM {{table}} WHERE `id` = '" . $TheUser['id_planet'] . "';", 'planets', true);
    DeleteSelectedUser($UserID);
    if ($UserPlanet['name'] != "") {
        $Now = time();
        // Aktuelles Datum
        $BanTime = 259200;
        // Sperrzeit 60(Sekunden) mal 60(Minuten) mal 24(Stunden) mal 3(Tage) = 259200
        $BannedUntil = $Now + $BanTime;
        // Aktuelles Datum mal Sperrzeit
        $QryInsertUser = "******";
        $QryInsertUser .= "`id`            = '" . $TheUser['id'] . "', ";
        $QryInsertUser .= "`username`      = '" . $TheUser['username'] . "', ";
        $QryInsertUser .= "`email`         = '" . $TheUser['email'] . "', ";
        $QryInsertUser .= "`email_2`       = '" . $TheUser['email_2'] . "', ";
        $QryInsertUser .= "`sex`           = '" . $TheUser['sex'] . "', ";
        $QryInsertUser .= "`volk`          = '" . $TheUser['volk'] . "', ";
        $QryInsertUser .= "`avatar`        = '" . $TheUser['avatar'] . "', ";
        $QryInsertUser .= "`id_planet`     = '" . $TheUser['id_planet'] . "', ";
        $QryInsertUser .= "`authlevel`     = '" . $TheUser['authlevel'] . "', ";
        $QryInsertUser .= "`dpath`         = '" . $TheUser['dpath'] . "', ";
        $QryInsertUser .= "`galaxy`        = '" . $TheUser['galaxy'] . "', ";
        $QryInsertUser .= "`system`        = '" . $TheUser['system'] . "', ";
        $QryInsertUser .= "`planet`        = '" . $TheUser['planet'] . "', ";
        $QryInsertUser .= "`register_time` = '" . $TheUser['register_time'] . "', ";
        $QryInsertUser .= "`password`      = '" . $TheUser['password'] . "'; ";
        doquery($QryInsertUser, 'users');
        $QryInsertBan = "INSERT INTO {{table}} SET ";
        $QryInsertBan .= "`id`     = '" . $TheUser['id'] . "', ";
        $QryInsertBan .= "`who`    = '" . $TheUser['username'] . "', ";
        $QryInsertBan .= "`theme`  = '" . $lang['cheat_001'] . "',";
        $QryInsertBan .= "`who2`   = '',";
        $QryInsertBan .= "`time`   = '" . $Now . "',";
        $QryInsertBan .= "`longer` = '" . $BannedUntil . "',";
        $QryInsertBan .= "`author` = '" . $lang['cheat_002'] . "',";
        $QryInsertBan .= "`email`  = '';";
        doquery($QryInsertBan, 'banned');
        $NewUser = doquery("SELECT `id` FROM {{table}} WHERE `username` = '" . $TheUser['username'] . "' LIMIT 1;", 'users', true);
        CreateOnePlanetRecord($TheUser['galaxy'], $TheUser['system'], $TheUser['planet'], $NewUser['id'], $UserPlanet['name'], true);
        $PlanetID = doquery("SELECT `id` FROM {{table}} WHERE `id_owner` = '" . $NewUser['id'] . "' LIMIT 1;", 'planets', true);
        $QryUpdateUser = "******";
        $QryUpdateUser .= "`id_planet` = '" . $PlanetID['id'] . "', ";
        $QryUpdateUser .= "`current_planet` = '" . $PlanetID['id'] . "' ";
        $QryUpdateUser .= "WHERE ";
        $QryUpdateUser .= "`id` = '" . $NewUser['id'] . "';";
        doquery($QryUpdateUser, 'users');
    }
    $QryUpdateUser = "******";
    $QryUpdateUser .= "`bana` = '1', ";
    $QryUpdateUser .= "`banaday` = '" . $BannedUntil . "' ";
    $QryUpdateUser .= "WHERE ";
    $QryUpdateUser .= "`username` = \"" . $TheUser['username'] . "\";";
    doquery($QryUpdateUser, 'users');
    if ($TheUser) {
        $sq = doquery("SELECT * FROM {{table}}", "users");
        $Time = time();
        $From = "<font color='#FF0000'><b>" . $lang['cheat_002'] . "</b></font>";
        $Subject = "<font color='#FF0000'><b>" . $lang['cheat_001'] . "</b></font>";
        $Message = "<font color='#FF0000'><b>" . $lang['cheat_003'] . "" . $TheUser['username'] . "" . $lang['cheat_004'] . "" . $lang['cheat_005'] . "" . $lang['cheat_006'] . "" . $lang['cheat_007'] . "" . $lang['cheat_008'] . "" . $lang['cheat_009'] . "" . $lang['cheat_010'] . "" . $lang['cheat_011'] . "" . $lang['cheat_012'] . "" . $lang['cheat_013'] . "</b></font>";
        $summery = 0;
        while ($u = mysql_fetch_array($sq)) {
            SendSimpleMessage($u['id'], $user['id'], $Time, 1, $From, $Subject, $Message);
        }
    }
    echo $page;
}
Exemple #23
0
function XNovaResetUnivers($CurrentUser)
{
    global $lang, $Adminerlaubt, $user;
    if ($user['id'] == 1 and in_array($user['id'], $Adminerlaubt)) {
        doquery("RENAME TABLE {{table}} TO {{table}}_s", 'planets');
        doquery("RENAME TABLE {{table}} TO {{table}}_s", 'users');
        doquery("CREATE  TABLE IF NOT EXISTS {{table}} ( LIKE {{table}}_s );", 'planets');
        doquery("CREATE  TABLE IF NOT EXISTS {{table}} ( LIKE {{table}}_s );", 'users');
        doquery("TRUNCATE TABLE {{table}}", 'aks');
        doquery("TRUNCATE TABLE {{table}}", 'alliance');
        doquery("TRUNCATE TABLE {{table}}", 'annonce');
        doquery("TRUNCATE TABLE {{table}}", 'banned');
        doquery("TRUNCATE TABLE {{table}}", 'buddy');
        doquery("TRUNCATE TABLE {{table}}", 'chat');
        doquery("TRUNCATE TABLE {{table}}", 'galaxy');
        doquery("TRUNCATE TABLE {{table}}", 'errors');
        doquery("TRUNCATE TABLE {{table}}", 'fleets');
        doquery("TRUNCATE TABLE {{table}}", 'iraks');
        doquery("TRUNCATE TABLE {{table}}", 'lunas');
        doquery("TRUNCATE TABLE {{table}}", 'messages');
        doquery("TRUNCATE TABLE {{table}}", 'notes');
        doquery("TRUNCATE TABLE {{table}}", 'rw');
        doquery("TRUNCATE TABLE {{table}}", 'statpoints');
        $AllUsers = doquery("SELECT `username`,`password`,`email`, `email_2`,`authlevel`,`galaxy`,`system`,`planet`, `sex`, `dpath`, `onlinetime`, `register_time`, `id_planet` FROM {{table}} WHERE 1;", 'users_s');
        $LimitTime = time() - 15 * (24 * (60 * 60));
        $TransUser = 0;
        while ($TheUser = mysql_fetch_assoc($AllUsers)) {
            if ($TheUser['onlinetime'] > $LimitTime) {
                $UserPlanet = doquery("SELECT `name` FROM {{table}} WHERE `id` = '" . $TheUser['id_planet'] . "';", 'planets_s', true);
                if ($UserPlanet['name'] != "") {
                    $QryInsertUser = "******";
                    $QryInsertUser .= "`username` = '" . $TheUser['username'] . "', ";
                    $QryInsertUser .= "`email` = '" . $TheUser['email'] . "', ";
                    $QryInsertUser .= "`email_2` = '" . $TheUser['email_2'] . "', ";
                    $QryInsertUser .= "`sex` = '" . $TheUser['sex'] . "', ";
                    $QryInsertUser .= "`id_planet` = '0', ";
                    $QryInsertUser .= "`authlevel` = '" . $TheUser['authlevel'] . "', ";
                    $QryInsertUser .= "`dpath` = '" . $TheUser['dpath'] . "', ";
                    $QryInsertUser .= "`galaxy` = '" . $TheUser['galaxy'] . "', ";
                    $QryInsertUser .= "`system` = '" . $TheUser['system'] . "', ";
                    $QryInsertUser .= "`planet` = '" . $TheUser['planet'] . "', ";
                    $QryInsertUser .= "`register_time` = '" . $TheUser['register_time'] . "', ";
                    $QryInsertUser .= "`password` = '" . $TheUser['password'] . "';";
                    doquery($QryInsertUser, 'users');
                    $NewUser = doquery("SELECT `id` FROM {{table}} WHERE `username` = '" . $TheUser['username'] . "' LIMIT 1;", 'users', true);
                    CreateOnePlanetRecord($TheUser['galaxy'], $TheUser['system'], $TheUser['planet'], $NewUser['id'], $UserPlanet['name'], true);
                    $PlanetID = doquery("SELECT `id` FROM {{table}} WHERE `id_owner` = '" . $NewUser['id'] . "' LIMIT 1;", 'planets', true);
                    $QryUpdateUser = "******";
                    $QryUpdateUser .= "`id_planet` = '" . $PlanetID['id'] . "', ";
                    $QryUpdateUser .= "`current_planet` = '" . $PlanetID['id'] . "' ";
                    $QryUpdateUser .= "WHERE ";
                    $QryUpdateUser .= "`id` = '" . $NewUser['id'] . "';";
                    doquery($QryUpdateUser, 'users');
                    $TransUser++;
                }
            }
        }
        doquery("UPDATE {{table}} SET `config_value` = '" . $TransUser . "' WHERE `config_name` = 'users_amount' LIMIT 1;", 'config');
        doquery("DROP TABLE {{table}}", 'planets_s');
        doquery("DROP TABLE {{table}}", 'users_s');
        AdminMessage($TransUser . $lang['adm_rz_done'], $lang['adm_rz_ttle']);
    } else {
        AdminMessage($lang['sys_noalloaw'], $lang['sys_noaccess']);
    }
    return $Page;
}
Exemple #24
0
function XNovaResetUnivers($CurrentUser)
{
    global $lang;
    if ($CurrentUser['authlevel'] == 4) {
        // Copier la table users et planets vers des tables de replis !
        doquery("RENAME TABLE {{table}} TO {{table}}_s", 'planets');
        doquery("RENAME TABLE {{table}} TO {{table}}_s", 'users');
        // Recreer la structure des tables renommées
        doquery("CREATE  TABLE IF NOT EXISTS {{table}} ( LIKE {{table}}_s );", 'planets');
        doquery("CREATE  TABLE IF NOT EXISTS {{table}} ( LIKE {{table}}_s );", 'users');
        // Vider toutes les tables !
        doquery("TRUNCATE TABLE {{table}}", 'aks');
        doquery("TRUNCATE TABLE {{table}}", 'alliance');
        doquery("TRUNCATE TABLE {{table}}", 'annonce');
        doquery("TRUNCATE TABLE {{table}}", 'banned');
        doquery("TRUNCATE TABLE {{table}}", 'buddy');
        doquery("TRUNCATE TABLE {{table}}", 'chat');
        doquery("TRUNCATE TABLE {{table}}", 'galaxy');
        doquery("TRUNCATE TABLE {{table}}", 'errors');
        doquery("TRUNCATE TABLE {{table}}", 'fleets');
        doquery("TRUNCATE TABLE {{table}}", 'iraks');
        doquery("TRUNCATE TABLE {{table}}", 'lunas');
        doquery("TRUNCATE TABLE {{table}}", 'messages');
        doquery("TRUNCATE TABLE {{table}}", 'notes');
        doquery("TRUNCATE TABLE {{table}}", 'rw');
        doquery("TRUNCATE TABLE {{table}}", 'statpoints');
        $AllUsers = doquery("SELECT `username`,`password`,`email`, `email_2`,`authlevel`,`galaxy`,`system`,`planet`, `sex`, `dpath`, `onlinetime`, `register_time`, `id_planet` FROM {{table}} WHERE 1;", 'users_s');
        $LimitTime = time() - 15 * (24 * (60 * 60));
        $TransUser = 0;
        while ($TheUser = mysql_fetch_assoc($AllUsers)) {
            if ($TheUser['onlinetime'] > $LimitTime) {
                $UserPlanet = doquery("SELECT `name` FROM {{table}} WHERE `id` = '" . $TheUser['id_planet'] . "';", 'planets_s', true);
                if ($UserPlanet['name'] != "") {
                    // Creation de l'utilisateur
                    $QryInsertUser = "******";
                    $QryInsertUser .= "`username` = '" . $TheUser['username'] . "', ";
                    $QryInsertUser .= "`email` = '" . $TheUser['email'] . "', ";
                    $QryInsertUser .= "`email_2` = '" . $TheUser['email_2'] . "', ";
                    $QryInsertUser .= "`sex` = '" . $TheUser['sex'] . "', ";
                    $QryInsertUser .= "`id_planet` = '0', ";
                    $QryInsertUser .= "`authlevel` = '" . $TheUser['authlevel'] . "', ";
                    $QryInsertUser .= "`dpath` = '" . $TheUser['dpath'] . "', ";
                    $QryInsertUser .= "`galaxy` = '" . $TheUser['galaxy'] . "', ";
                    $QryInsertUser .= "`system` = '" . $TheUser['system'] . "', ";
                    $QryInsertUser .= "`planet` = '" . $TheUser['planet'] . "', ";
                    $QryInsertUser .= "`register_time` = '" . $TheUser['register_time'] . "', ";
                    $QryInsertUser .= "`password` = '" . $TheUser['password'] . "';";
                    doquery($QryInsertUser, 'users');
                    // On cherche le numero d'enregistrement de l'utilisateur fraichement cr��
                    $NewUser = doquery("SELECT `id` FROM {{table}} WHERE `username` = '" . $TheUser['username'] . "' LIMIT 1;", 'users', true);
                    CreateOnePlanetRecord($TheUser['galaxy'], $TheUser['system'], $TheUser['planet'], $NewUser['id'], $UserPlanet['name'], true);
                    // Recherche de la reference de la nouvelle planete (qui est unique normalement !
                    $PlanetID = doquery("SELECT `id` FROM {{table}} WHERE `id_owner` = '" . $NewUser['id'] . "' LIMIT 1;", 'planets', true);
                    // Mise a jour de l'enregistrement utilisateur avec les infos de sa planete mere
                    $QryUpdateUser = "******";
                    $QryUpdateUser .= "`id_planet` = '" . $PlanetID['id'] . "', ";
                    $QryUpdateUser .= "`current_planet` = '" . $PlanetID['id'] . "' ";
                    $QryUpdateUser .= "WHERE ";
                    $QryUpdateUser .= "`id` = '" . $NewUser['id'] . "';";
                    doquery($QryUpdateUser, 'users');
                    $TransUser++;
                }
            }
        }
        // while
        // Mise a jour du nombre de joueurs inscripts
        doquery("UPDATE {{table}} SET `config_value` = '" . $TransUser . "' WHERE `config_name` = 'users_amount' LIMIT 1;", 'config');
        // Menage on vire les tables transitoires
        doquery("DROP TABLE {{table}}", 'planets_s');
        doquery("DROP TABLE {{table}}", 'users_s');
        AdminMessage($TransUser . $lang['adm_rz_done'], $lang['adm_rz_ttle']);
    } else {
        AdminMessage($lang['sys_noalloaw'], $lang['sys_noaccess']);
    }
    return $Page;
}
function MissionCaseColonisation($FleetRow)
{
    global $lang, $resource, $formulas;
    //Get the current user (note it must be $currentUser for the $formulas eval'd code to work, see includes/formulas.php
    $CurrentUser = doquery("SELECT * FROM {{table}} WHERE `id` = '" . idstring($FleetRow['owner_userid']) . "' LIMIT 1 ;", 'users', true);
    //How many planets do we have?
    $userplanets = mysql_num_rows(doquery("SELECT `id` FROM {{table}} WHERE `id_owner` = '" . $CurrentUser['id'] . "' AND `planet_type` = '1'", 'planets'));
    //How many planets are allowed?
    $maxplanets = eval($formulas['max_planets_c']);
    //If we have less than (but not equal to) the max planets count.
    if ($userplanets < $maxplanets) {
        //Now the slightly trickbit, as we were not messing around with gal sys and planet in the database we now had to have a numeric id for the gsp.
        $g = strlen(MAX_GALAXY_IN_WORLD);
        $s = strlen(MAX_SYSTEM_IN_GALAXY);
        $p = strlen(MAX_PLANET_IN_SYSTEM);
        $galaxy = substr($FleetRow['target_id'], 0, $g) * 1;
        $system = substr($FleetRow['target_id'], $g, $s) * 1;
        $planet = substr($FleetRow['target_id'], $g + $s, $p) * 1;
        unset($g, $s, $p);
        //Check that these planets are within the allowed range
        if ($CurrentUser[$resource[124]] < 4) {
            $minpos = 4;
        } elseif ($CurrentUser[$resource[124]] < 6) {
            $minpos = 3;
        } elseif ($CurrentUser[$resource[124]] < 8) {
            $minpos = 2;
        } else {
            $minpos = 1;
        }
        $maxpos = MAX_PLANET_IN_SYSTEM + 1 - $minpos;
        if ($planet >= $minpos && $planet <= $maxpos) {
            //Now get the target position
            $TargetAdress = sprintf($lang['sys_adress_planet'], $galaxy, $system, $planet);
            //See if we have a planet here already?
            $cur = doquery("SELECT `id` FROM {{table}} WHERE `galaxy` = '" . $galaxy . "' AND `system` = '" . $system . "' AND `planet` = '" . $planet . "';", 'planets', true);
            if ($cur['id'] > 0) {
                $message = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_notfree'];
                PM($CurrentUser['id'], 0, $message, $lang['sys_colo_mess_report'], $lang['sys_colo_mess_from'], 2);
            } else {
                //No planet lets carry on.
                if (CreateOnePlanetRecord($galaxy, $system, $planet, $CurrentUser['id'], $lang['sys_colo_defaultname'], false)) {
                    //Message them that the planet has been made.
                    $message = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_allisok'];
                    PM($CurrentUser['id'], 0, $message, $lang['sys_colo_mess_report'], $lang['sys_colo_mess_from'], 2);
                    //If there is more than just a colony ship then we should put that fleet on the planet.
                    if ($FleetRow['shipcount'] > 0) {
                        $fleet = explode(";", $FleetRow['array']);
                        $sql = "";
                        $upd = 0;
                        foreach ($fleet as $info) {
                            if (strlen($info) > 0) {
                                $ship = explode(",", $info);
                                if ($ship[0] == 208) {
                                    $ship[1]--;
                                }
                                if ($ship[1] > 0) {
                                    $sql .= "`" . $resource[$ship[0]] . "` = '" . idstring($ship[1]) . "' , ";
                                    $upd += $ship[1];
                                }
                            }
                        }
                        if ($upd > 0 && strlen(substr_replace($sql, '', -2)) > 3) {
                            doquery("UPDATE {{table}} SET " . substr_replace($sql, '', -2) . " WHERE `galaxy` = '" . $galaxy . "' AND `system` = '" . $system . "' AND `planet` = '" . $planet . "' ;", 'planets');
                        }
                    }
                    //And put resources on the planet.
                    doquery("UPDATE {{table}} SET `metal` = '" . $FleetRow['metal'] . "' , `crystal` = '" . $FleetRow['crystal'] . "' , `deuterium` = '" . $FleetRow['deuterium'] . "'  WHERE `galaxy` = '" . $galaxy . "' AND `system` = '" . $system . "' AND `planet` = '" . $planet . "' LIMIT 1 ;", 'planets');
                } else {
                    //We could not make the colony
                    $message = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_badpos'];
                    PM($CurrentUser['id'], 0, $message, $lang['sys_colo_mess_report'], $lang['sys_colo_mess_from'], 2);
                }
            }
        } else {
            //We don't have astro-physics high enough
            $message = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_outside_range'] . $lang['sys_colo_slots'] . "[" . $minpos . "-" . $maxpos . "]!";
            PM($CurrentUser['id'], 0, $message, $lang['sys_colo_mess_report'], $lang['sys_colo_mess_from'], 2);
        }
    } else {
        //We don't have astro-physics high enough
        $message = $lang['sys_colo_arrival'] . $TargetAdress . $lang['sys_colo_maxcolo'] . $maxplanets . $lang['sys_colo_planet'];
        PM($CurrentUser['id'], 0, $message, $lang['sys_colo_mess_report'], $lang['sys_colo_mess_from'], 2);
    }
}