Kod:
CREATE TABLE `game_aks` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`name` varchar(50) collate latin1_general_ci default NULL,
`teilnehmer` text collate latin1_general_ci,
`flotten` text collate latin1_general_ci,
`ankunft` int(32) default NULL,
`galaxy` int(2) default NULL,
`system` int(4) default NULL,
`planet` int(2) default NULL,
`eingeladen` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE `game_annonce` (
`id` int(11) NOT NULL auto_increment,
`user` text collate latin1_general_ci NOT NULL,
`galaxie` int(11) NOT NULL,
`systeme` int(11) NOT NULL,
`metala` bigint(11) NOT NULL,
`cristala` bigint(11) NOT NULL,
`deuta` bigint(11) NOT NULL,
`metals` bigint(11) NOT NULL,
`cristals` bigint(11) NOT NULL,
`deuts` bigint(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE `game_alliance` (
`id` bigint(11) NOT NULL auto_increment,
`ally_name` varchar(32) character set latin1 default '',
`ally_tag` varchar(8) character set latin1 default '',
`ally_owner` int(11) NOT NULL default '0',
`ally_register_time` int(11) NOT NULL default '0',
`ally_description` text character set latin1,
`ally_web` varchar(255) character set latin1 default '',
`ally_text` text character set latin1,
`ally_image` varchar(255) character set latin1 default '',
`ally_request` text character set latin1,
`ally_request_waiting` text character set latin1,
`ally_request_notallow` tinyint(4) NOT NULL default '0',
`ally_owner_range` varchar(32) character set latin1 default '',
`ally_ranks` text character set latin1,
`ally_members` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE `game_banned` (
`id` bigint(11) NOT NULL auto_increment,
`who` varchar(11) character set latin1 NOT NULL default '',
`theme` text character set latin1 NOT NULL,
`who2` varchar(11) character set latin1 NOT NULL default '',
`time` int(11) NOT NULL default '0',
`longer` int(11) NOT NULL default '0',
`author` varchar(11) character set latin1 NOT NULL default '',
`email` varchar(20) character set latin1 NOT NULL default '',
KEY `ID` (`id`)
) ENGINE=MyISAM;
CREATE TABLE `game_buddy` (
`id` bigint(11) NOT NULL auto_increment,
`sender` int(11) NOT NULL default '0',
`owner` int(11) NOT NULL default '0',
`active` tinyint(3) NOT NULL default '0',
`text` text character set latin1,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE `game_chat` (
`messageid` int(5) unsigned NOT NULL auto_increment,
`user` varchar(255) NOT NULL default '',
`message` text NOT NULL,
`timestamp` int(11) NOT NULL default '0',
PRIMARY KEY (`messageid`)
) ENGINE=MyISAM;
CREATE TABLE `game_config` (
`config_name` varchar(64) character set latin1 NOT NULL default '',
`config_value` text character set latin1 NOT NULL
) ENGINE=MyISAM;
INSERT INTO `game_config`
(`config_name` , `config_value`) VALUES
('users_amount' , '0'),
('game_speed' , '2500'),
('fleet_speed' , '2500'),
('resource_multiplier' , '1'),
('Fleet_Cdr' , '30'),
('Defs_Cdr' , '30'),
('initial_fields' , '163'),
('COOKIE_NAME' , 'XNova'),
('game_name' , 'XNova'),
('game_disable' , '1'),
('close_reason' , 'Le jeu est clos pour le moment!'),
('metal_basic_income' , '20'),
('crystal_basic_income' , '10'),
('deuterium_basic_income', '0'),
('energy_basic_income' , '0'),
('BuildLabWhileRun' , '0'),
('LastSettedGalaxyPos' , '1'),
('LastSettedSystemPos' , '8'),
('LastSettedPlanetPos' , '3'),
('urlaubs_modus_erz' , '1'),
('noobprotection' , '1'),
('noobprotectiontime' , '5000'),
('noobprotectionmulti' , '5'),
('forum_url' , 'http://www.max-game.pl' ),
('OverviewNewsFrame' , '1' ),
('OverviewNewsText' , 'http://www.max-game.pl' ),
('OverviewExternChat' , '0' ),
('OverviewExternChatCmd' , '' ),
('OverviewBanner' , '0' ),
('OverviewClickBanner' , '' ),
('ExtCopyFrame' , '0' ),
('ExtCopyOwner' , '' ),
('ExtCopyFunct' , '' ),
('ForumBannerFrame' , '0' ),
('stat_settings' , '1000' ),
('link_enable' , '0' ),
('link_name' , '' ),
('link_url' , '' ),
('enable_announces' , '1' ),
('enable_marchand' , '1'),
('enable_notes' , '1'),
('bot_name' , 'XNoviana Reali'),
('bot_adress' , 'xnova@xnova.fr' ),
('banner_source_post' , '../images/bann.png' ),
('ban_duration' , '30' ),
('enable_bot' , '0' ),
('enable_bbcode' , '1' ),
('debug' , '0');
CREATE TABLE `game_declared` (
`declarator` TEXT NOT NULL,
`declared_1` TEXT NOT NULL,
`declared_2` TEXT NOT NULL,
`declared_3` TEXT NOT NULL,
`reason` TEXT NOT NULL,
`declarator_name` TEXT NOT NULL
) ENGINE=MyISAM;
CREATE TABLE `game_errors` (
`error_id` bigint(11) NOT NULL auto_increment,
`error_sender` varchar(32) character set latin1 NOT NULL default '0',
`error_time` int(11) NOT NULL default '0',
`error_type` varchar(32) character set latin1 NOT NULL default 'unknown',
`error_text` text character set latin1,
PRIMARY KEY (`error_id`)
) ENGINE=MyISAM;
CREATE TABLE `game_fleets` (
`fleet_id` bigint(11) NOT NULL auto_increment,
`fleet_owner` int(11) NOT NULL default '0',
`fleet_mission` int(11) NOT NULL default '0',
`fleet_amount` bigint(11) NOT NULL default '0',
`fleet_array` text character set latin1,
`fleet_start_time` int(11) NOT NULL default '0',
`fleet_start_galaxy` int(11) NOT NULL default '0',
`fleet_start_system` int(11) NOT NULL default '0',
`fleet_start_planet` int(11) NOT NULL default '0',
`fleet_start_type` int(11) NOT NULL default '0',
`fleet_end_time` int(11) NOT NULL default '0',
`fleet_end_stay` int(11) NOT NULL default '0',
`fleet_end_galaxy` int(11) NOT NULL default '0',
`fleet_end_system` int(11) NOT NULL default '0',
`fleet_end_planet` int(11) NOT NULL default '0',
`fleet_end_type` int(11) NOT NULL default '0',
`fleet_taget_owner` int(11) NOT NULL default '0',
`fleet_resource_metal` bigint(11) NOT NULL default '0',
`fleet_resource_crystal` bigint(11) NOT NULL default '0',
`fleet_resource_deuterium` bigint(11) NOT NULL default '0',
`fleet_target_owner` int(11) NOT NULL default '0',
`fleet_group` int (11) NOT NULL DEFAULT '0',
`fleet_mess` int(11) NOT NULL default '0',
`start_time` int(11) default NULL,
PRIMARY KEY (`fleet_id`)
) ENGINE=MyISAM;
CREATE TABLE `game_galaxy` (
`galaxy` int(2) NOT NULL default '0',
`system` int(3) NOT NULL default '0',
`planet` int(2) NOT NULL default '0',
`id_planet` int(11) NOT NULL default '0',
`metal` bigint(11) NOT NULL default '0',
`crystal` bigint(11) NOT NULL default '0',
`id_luna` int(11) NOT NULL default '0',
`luna` int(2) NOT NULL default '0',
KEY `galaxy` (`galaxy`),
KEY `system` (`system`),
KEY `planet` (`planet`)
) ENGINE=MyISAM;
CREATE TABLE `game_iraks` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`zeit` int(32) default NULL,
`galaxy` int(2) default NULL,
`system` int(4) default NULL,
`planet` int(2) default NULL,
`galaxy_angreifer` int(2) default NULL,
`system_angreifer` int(4) default NULL,
`planet_angreifer` int(2) default NULL,
`owner` int(32) default NULL,
`zielid` int(32) default NULL,
`anzahl` int(32) default NULL,
`primaer` int(32) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE `game_lunas` (
`id` bigint(11) NOT NULL auto_increment,
`id_luna` int(11) NOT NULL default '0',
`name` varchar(11) character set latin1 NOT NULL default 'Lune',
`image` varchar(11) character set latin1 NOT NULL default 'mond',
`destruyed` int(11) NOT NULL default '0',
`id_owner` int(11) default NULL,
`galaxy` int(11) default NULL,
`system` int(11) default NULL,
`lunapos` int(11) default NULL,
`temp_min` int(11) NOT NULL default '0',
`temp_max` int(11) NOT NULL default '0',
`diameter` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE `game_messages` (
`message_id` bigint(11) NOT NULL auto_increment,
`message_owner` int(11) NOT NULL default '0',
`message_sender` int(11) NOT NULL default '0',
`message_time` int(11) NOT NULL default '0',
`message_type` int(11) NOT NULL default '0',
`message_from` varchar(48) character set latin1 default NULL,
`message_subject` varchar(48) character set latin1 default NULL,
`message_text` text character set latin1,
PRIMARY KEY (`message_id`)
) ENGINE=MyISAM;
CREATE TABLE `game_notes` (
`id` bigint(11) NOT NULL auto_increment,
`owner` int(11) default NULL,
`time` int(11) default NULL,
`priority` tinyint(1) default NULL,
`title` varchar(32) character set latin1 default NULL,
`text` text character set latin1,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE `game_planets` (
`id` bigint(11) NOT NULL auto_increment,
`name` varchar(255) character set latin1 default NULL,
`id_owner` int(11) default NULL,
`id_level` int(11) default NULL,
`galaxy` int(11) NOT NULL default '0',
`system` int(11) NOT NULL default '0',
`planet` int(11) NOT NULL default '0',
`last_update` int(11) default NULL,
`planet_type` int(11) NOT NULL default '1',
`destruyed` int(11) NOT NULL default '0',
`b_building` int(11) NOT NULL default '0',
`b_building_id` text character set latin1 NOT NULL,
`b_tech` int(11) NOT NULL default '0',
`b_tech_id` int(11) NOT NULL default '0',
`b_hangar` int(11) NOT NULL default '0',
`b_hangar_id` text character set latin1 NOT NULL,
`b_hangar_plus` int(11) NOT NULL default '0',
`image` varchar(32) character set latin1 NOT NULL default 'normaltempplanet01',
`diameter` int(11) NOT NULL default '12800',
`points` bigint(20) default '0',
`ranks` bigint(20) default '0',
`field_current` int(11) NOT NULL default '0',
`field_max` int(11) NOT NULL default '163',
`temp_min` int(3) NOT NULL default '-17',
`temp_max` int(3) NOT NULL default '23',
`metal` double(132,8) NOT NULL default '0.00000000',
`metal_perhour` int(11) NOT NULL default '0',
`metal_max` bigint(20) default '100000',
`crystal` double(132,8) NOT NULL default '0.00000000',
`crystal_perhour` int(11) NOT NULL default '0',
`crystal_max` bigint(20) default '100000',
`deuterium` double(132,8) NOT NULL default '0.00000000',
`deuterium_perhour` int(11) NOT NULL default '0',
`deuterium_max` bigint(20) default '100000',
`energy_used` int(11) NOT NULL default '0',
`energy_max` int(11) NOT NULL default '0',
`metal_mine` int(11) NOT NULL default '0',
`crystal_mine` int(11) NOT NULL default '0',
`deuterium_sintetizer` int(11) NOT NULL default '0',
`solar_plant` int(11) NOT NULL default '0',
`fusion_plant` int(11) NOT NULL default '0',
`robot_factory` int(11) NOT NULL default '0',
`nano_factory` int(11) NOT NULL default '0',
`hangar` int(11) NOT NULL default '0',
`metal_store` int(11) NOT NULL default '0',
`crystal_store` int(11) NOT NULL default '0',
`deuterium_store` int(11) NOT NULL default '0',
`laboratory` int(11) NOT NULL default '0',
`terraformer` int(11) NOT NULL default '0',
`ally_deposit` int(11) NOT NULL default '0',
`silo` int(11) NOT NULL default '0',
`small_ship_cargo` bigint(11) NOT NULL default '0',
`big_ship_cargo` bigint(11) NOT NULL default '0',
`light_hunter` bigint(11) NOT NULL default '0',
`heavy_hunter` bigint(11) NOT NULL default '0',
`crusher` bigint(11) NOT NULL default '0',
`battle_ship` bigint(11) NOT NULL default '0',
`colonizer` bigint(11) NOT NULL default '0',
`recycler` bigint(11) NOT NULL default '0',
`spy_sonde` bigint(11) NOT NULL default '0',
`bomber_ship` bigint(11) NOT NULL default '0',
`solar_satelit` bigint(11) NOT NULL default '0',
`destructor` bigint(11) NOT NULL default '0',
`dearth_star` bigint(11) NOT NULL default '0',
`battleship` bigint(11) NOT NULL default '0',
`misil_launcher` bigint(11) NOT NULL default '0',
`small_laser` bigint(11) NOT NULL default '0',
`big_laser` bigint(11) NOT NULL default '0',
`gauss_canyon` bigint(11) NOT NULL default '0',
`ionic_canyon` bigint(11) NOT NULL default '0',
`buster_canyon` bigint(11) NOT NULL default '0',
`small_protection_shield` int(11) NOT NULL default '0',
`big_protection_shield` int(11) NOT NULL default '0',
`interceptor_misil` int(11) NOT NULL default '0',
`interplanetary_misil` int(11) NOT NULL default '0',
`metal_mine_porcent` int(11) NOT NULL default '10',
`crystal_mine_porcent` int(11) NOT NULL default '10',
`deuterium_sintetizer_porcent` int(11) NOT NULL default '10',
`solar_plant_porcent` int(11) NOT NULL default '10',
`fusion_plant_porcent` int(11) NOT NULL default '10',
`solar_satelit_porcent` int(11) NOT NULL default '10',
`mondbasis` bigint(11) NOT NULL default '0',
`phalanx` bigint(11) NOT NULL default '0',
`sprungtor` bigint(11) NOT NULL default '0',
`last_jump_time` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE `game_rw` (
`id_owner1` int(11) NOT NULL default '0',
`id_owner2` int(11) NOT NULL default '0',
`rid` varchar(72) character set latin1 NOT NULL,
`raport` text character set latin1 NOT NULL,
`a_zestrzelona` tinyint(3) unsigned NOT NULL default '0',
`time` int(10) unsigned NOT NULL default '0',
UNIQUE KEY `rid` (`rid`),
KEY `id_owner1` (`id_owner1`,`rid`),
KEY `id_owner2` (`id_owner2`,`rid`),
KEY `time` (`time`),
FULLTEXT KEY `raport` (`raport`)
) ENGINE=MyISAM;
CREATE TABLE `game_statpoints` (
`id_owner` int(11) NOT NULL,
`id_ally` int(11) NOT NULL,
`stat_type` int(2) NOT NULL,
`stat_code` int(11) NOT NULL,
`tech_rank` int(11) NOT NULL,
`tech_old_rank` int(11) NOT NULL,
`tech_points` bigint(20) NOT NULL,
`tech_count` int(11) NOT NULL,
`build_rank` int(11) NOT NULL,
`build_old_rank` int(11) NOT NULL,
`build_points` bigint(20) NOT NULL,
`build_count` int(11) NOT NULL,
`defs_rank` int(11) NOT NULL,
`defs_old_rank` int(11) NOT NULL,
`defs_points` bigint(20) NOT NULL,
`defs_count` int(11) NOT NULL,
`fleet_rank` int(11) NOT NULL,
`fleet_old_rank` int(11) NOT NULL,
`fleet_points` bigint(20) NOT NULL,
`fleet_count` int(11) NOT NULL,
`total_rank` int(11) NOT NULL,
`total_old_rank` int(11) NOT NULL,
`total_points` bigint(20) NOT NULL,
`total_count` int(11) NOT NULL,
`stat_date` int(11) NOT NULL,
KEY `TECH` (`tech_points`),
KEY `BUILDS` (`build_points`),
KEY `DEFS` (`defs_points`),
KEY `FLEET` (`fleet_points`),
KEY `TOTAL` (`total_points`)
) ENGINE=MyISAM;
CREATE TABLE `game_users` (
`id` bigint(11) unsigned NOT NULL auto_increment PRIMARY KEY,
`username` varchar(64) character set latin1 NOT NULL default '',
`password` varchar(64) character set latin1 NOT NULL default '',
`email` varchar(64) character set latin1 NOT NULL default '',
`email_2` varchar(64) character set latin1 NOT NULL default '',
`lang` varchar(8) character set latin1 NOT NULL default 'fr',
`authlevel` tinyint(4) NOT NULL default '0',
`sex` char(1) character set latin1 default NULL,
`avatar` varchar(255) character set latin1 NOT NULL default '',
`sign` text character set latin1,
`id_planet` int(11) NOT NULL default '0',
`galaxy` int(11) NOT NULL default '0',
`system` int(11) NOT NULL default '0',
`planet` int(11) NOT NULL default '0',
`current_planet` int(11) NOT NULL default '0',
`user_lastip` varchar(16) character set latin1 NOT NULL default '',
`ip_at_reg` varchar(16) character set latin1 NOT NULL default '',
`user_agent` text character set latin1 NOT NULL,
`current_page` text character set latin1 NOT NULL,
`register_time` int(11) NOT NULL default '0',
`onlinetime` int(11) NOT NULL default '0',
`dpath` varchar(255) character set latin1 NOT NULL default '',
`design` tinyint(4) NOT NULL default '1',
`noipcheck` tinyint(4) NOT NULL default '1',
`planet_sort` tinyint(1) NOT NULL default '0',
`planet_sort_order` tinyint(1) NOT NULL default '0',
`spio_anz` tinyint(4) NOT NULL default '1',
`settings_tooltiptime` tinyint(4) NOT NULL default '5',
`settings_fleetactions` tinyint(4) NOT NULL default '0',
`settings_allylogo` tinyint(4) NOT NULL default '0',
`settings_esp` tinyint(4) NOT NULL default '1',
`settings_wri` tinyint(4) NOT NULL default '1',
`settings_bud` tinyint(4) NOT NULL default '1',
`settings_mis` tinyint(4) NOT NULL default '1',
`settings_rep` tinyint(4) NOT NULL default '0',
`urlaubs_modus` tinyint(4) NOT NULL default '0',
`urlaubs_until` int(11) NOT NULL default '0',
`db_deaktjava` tinyint(4) NOT NULL default '0',
`new_message` int(11) NOT NULL default '0',
`fleet_shortcut` text character set latin1,
`b_tech_planet` int(11) NOT NULL default '0',
`spy_tech` int(11) NOT NULL default '0',
`computer_tech` int(11) NOT NULL default '0',
`military_tech` int(11) NOT NULL default '0',
`defence_tech` int(11) NOT NULL default '0',
`shield_tech` int(11) NOT NULL default '0',
`energy_tech` int(11) NOT NULL default '0',
`hyperspace_tech` int(11) NOT NULL default '0',
`combustion_tech` int(11) NOT NULL default '0',
`impulse_motor_tech` int(11) NOT NULL default '0',
`hyperspace_motor_tech` int(11) NOT NULL default '0',
`laser_tech` int(11) NOT NULL default '0',
`ionic_tech` int(11) NOT NULL default '0',
`buster_tech` int(11) NOT NULL default '0',
`intergalactic_tech` int(11) NOT NULL default '0',
`expedition_tech` int(11) NOT NULL default '0',
`graviton_tech` int(11) NOT NULL default '0',
`ally_id` int(11) NOT NULL default '0',
`ally_name` varchar(32) character set latin1 default '',
`ally_request` int(11) NOT NULL default '0',
`ally_request_text` text character set latin1,
`ally_register_time` int(11) NOT NULL default '0',
`ally_rank_id` int(11) NOT NULL default '0',
`current_luna` int(11) NOT NULL default '0',
`kolorminus` varchar(11) character set latin1 NOT NULL default 'red',
`kolorplus` varchar(11) character set latin1 NOT NULL default '#00FF00',
`kolorpoziom` varchar(11) character set latin1 NOT NULL default 'yellow',
`rpg_geologue` int(11) NOT NULL default '0',
`rpg_amiral` int(11) NOT NULL default '0',
`rpg_ingenieur` int(11) NOT NULL default '0',
`rpg_technocrate` int(11) NOT NULL default '0',
`rpg_espion` int(11) NOT NULL default '0',
`rpg_constructeur` int(11) NOT NULL default '0',
`rpg_scientifique` int(11) NOT NULL default '0',
`rpg_commandant` int(11) NOT NULL default '0',
`rpg_points` int(11) NOT NULL default '0',
`rpg_stockeur` int(11) NOT NULL default '0',
`rpg_defenseur` int(11) NOT NULL default '0',
`rpg_destructeur` int(11) NOT NULL default '0',
`rpg_general` int(11) NOT NULL default '0',
`rpg_bunker` int(11) NOT NULL default '0',
`rpg_raideur` int(11) NOT NULL default '0',
`rpg_empereur` int(11) NOT NULL default '0',
`lvl_minier` int(11) NOT NULL default '1',
`lvl_raid` int(11) NOT NULL default '1',
`xpraid` int(11) NOT NULL default '0',
`xpminier` int(11) NOT NULL default '0',
`raids` bigint(20) NOT NULL default '0',
`p_infligees` bigint(20) NOT NULL default '0',
`mnl_alliance` INT( 11 ) NOT NULL ,
`mnl_joueur` INT( 11 ) NOT NULL ,
`mnl_attaque` INT( 11 ) NOT NULL ,
`mnl_spy` INT( 11 ) NOT NULL ,
`mnl_exploit` INT( 11 ) NOT NULL ,
`mnl_transport` INT( 11 ) NOT NULL ,
`mnl_expedition` INT( 11 ) NOT NULL ,
`mnl_general` INT( 11 ) NOT NULL ,
`mnl_buildlist` INT (11) NOT NULL ,
`bana` int(11) default NULL ,
`multi_validated` int(11) default NULL ,
`banaday` int(11) default NULL ,
`raids1` int(11) default NULL ,
`raidswin` int(11) default NULL ,
`raidsloose` int(11) default NULL
) ENGINE=MyISAM;
CREATE TABLE `game_multi` (
`id` int(11) NOT NULL auto_increment,
`player` bigint(11) unsigned NOT NULL,
`sharer` bigint(11) unsigned NOT NULL,
`reason` text character set latin1 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
Zakładki