基于PHP的网页游戏xnova(ogame)-银河帝国v0.8版源码.zip

[2010-04-14 20:15:05]SELECT * FROM game_config [2010-04-14 20:15:05]SELECT * FROM game_fleets WHERE `fleet_start_time` <= '1271247305'; [2010-04-14 20:15:05]SELECT * FROM game_fleets WHERE `fleet_end_time` <= '1271247305'; [2010-04-14 20:15:05]SELECT * FROM game_iraks WHERE zeit <= '1271247305' [2010-04-14 20:15:05]SELECT * FROM game_planets WHERE `id` = ''; [2010-04-14 20:15:05]SELECT * FROM game_galaxy WHERE `id_planet` = ''; [2010-04-14 20:15:05]SELECT username FROM game_users ORDER BY register_time DESC [2010-04-14 20:15:05]SELECT COUNT(DISTINCT(id)) FROM game_users WHERE onlinetime>1271246405 [2010-04-14 20:15:25]SELECT * FROM game_config [2010-04-14 20:15:25]SELECT * FROM game_fleets WHERE `fleet_start_time` <= '1271247325'; [2010-04-14 20:15:25]SELECT * FROM game_fleets WHERE `fleet_end_time` <= '1271247325'; [2010-04-14 20:15:25]SELECT * FROM game_iraks WHERE zeit <= '1271247325' [2010-04-14 20:15:25]SELECT * FROM game_planets WHERE `id` = ''; [2010-04-14 20:15:25]SELECT * FROM game_galaxy WHERE `id_planet` = ''; [2010-04-14 20:15:25]SELECT * FROM game_users WHERE `username` = 'user100' LIMIT 1 [2010-04-14 20:15:25]SELECT * FROM game_config [2010-04-14 20:15:25]SELECT * FROM game_users WHERE `username` = 'user100'; [2010-04-14 20:15:25]UPDATE game_users SET `onlinetime` = '1271247325', `user_lastip` = '127.0.0.1', `user_agent` = 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; CIBA)' WHERE `id` = '1' LIMIT 1; [2010-04-14 20:15:25]SELECT * FROM game_fleets WHERE `fleet_start_time` <= '1271247325'; [2010-04-14 20:15:25]SELECT * FROM game_fleets WHERE `fleet_end_time` <= '1271247325'; [2010-04-14 20:15:25]SELECT * FROM game_iraks WHERE zeit <= '1271247325' [2010-04-14 20:15:25]SELECT * FROM game_planets WHERE `id` = '1'; [2010-04-14 20:15:25]SELECT * FROM game_galaxy WHERE `id_planet` = '1'; [2010-04-14 20:15:26]SELECT * FROM game_config [2010-04-14 20:15:26]SELECT * FROM game_users WHERE `username` = 'user100'; [2010-04-14 20:15:26]UPDATE game_users SET `onlinetime` = '1271247326', `user_lastip` = '127.0.0.1', `user_agent` = 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; CIBA)' WHERE `id` = '1' LIMIT 1; [2010-04-14 20:15:26]SELECT * FROM game_fleets WHERE `fleet_start_time` <= '1271247326'; [2010-04-14 20:15:26]SELECT * FROM game_fleets WHERE `fleet_end_time` <= '1271247326'; [2010-04-14 20:15:26]SELECT * FROM game_iraks WHERE zeit <= '1271247326' [2010-04-14 20:15:26]SELECT * FROM game_planets WHERE `id` = '1'; [2010-04-14 20:15:26]SELECT * FROM game_galaxy WHERE `id_planet` = '1'; [2010-04-14 20:15:26]SELECT `total_rank` FROM game_statpoints WHERE `stat_code` = '1' AND `stat_type` = '1' AND `id_owner` = ''; [2010-04-14 20:15:26]SELECT * FROM game_config [2010-04-14 20:15:26]SELECT * FROM game_users WHERE `username` = 'user100'; [2010-04-14 20:15:26]UPDATE game_users SET `onlinetime` = '1271247326', `user_lastip` = '127.0.0.1', `user_agent` = 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; CIBA)' WHERE `id` = '1' LIMIT 1; [2010-04-14 20:15:26]SELECT * FROM game_fleets WHERE `fleet_start_time` <= '1271247326'; [2010-04-14 20:15:26]SELECT * FROM game_fleets WHERE `fleet_end_time` <= '1271247326'; [2010-04-14 20:15:26]SELECT * FROM game_iraks WHERE zeit <= '1271247326' [2010-04-14 20:15:26]SELECT * FROM game_planets WHERE `id` = '1'; [2010-04-14 20:15:26]SELECT * FROM game_galaxy WHERE `id_planet` = '1'; [2010-04-14 20:15:26]SELECT * FROM game_lunas WHERE `id_owner` = '1' AND `galaxy` = '1' AND `system` = '1' AND `lunapos` = '1'; [2010-04-14 20:15:26]SELECT * FROM game_fleets WHERE `fleet_owner` = '1'; [2010-04-14 20:15:26]SELECT * FROM game_fleets WHERE `fleet_target_owner` = '1'; [2010-04-14 20:15:26]SELECT * FROM game_planets WHERE id_owner='1' [2010-04-14 20:15:26]SELECT * FROM game_iraks WHERE owner = '1' [2010-04-14 20:15:26]SELECT * FROM game_statpoints WHERE `stat_type` = '1' AND `stat_code` = '1' AND `id_owner` = '1'; [2010-04-14 20:15:26]SELECT username FROM game_users ORDER BY register_time DESC [2010-04-14 20:15:26]SELECT COUNT(DISTINCT(id)) FROM game_users WHERE onlinetime>1271246426 [2010-04-14 20:15:26]SELECT COUNT(*) FROM game_users WHERE onlinetime>='1271246426' [2010-04-14 20:15:26]LOCK TABLE game_planets WRITE [2010-04-14 20:15:26]UPDATE game_planets SET `metal` = '500.266666667', `crystal` = '500.133333333', `deuterium` = '500', `last_update` = '1271247326', `b_hangar_id` = '', `metal_perhour` = '20', `crystal_perhour` = '10', `deuterium_perhour` = '0', `energy_used` = '0', `energy_max` = '0', `b_hangar` = '0' WHERE `id` = '1'; [2010-04-14 20:15:26]UNLOCK TABLES [2010-04-14 20:15:26]SELECT `id`, `name`, `galaxy`, `system`, `planet`, `planet_type` FROM game_planets WHERE `id_owner` = '1' ORDER BY `id` ASC [2010-04-14 20:15:49]SELECT * FROM game_config [2010-04-14 20:15:49]SELECT * FROM game_users WHERE `username` = 'user100'; [2010-04-14 20:15:49]UPDATE game_users SET `onlinetime` = '1271247349', `user_lastip` = '127.0.0.1', `user_agent` = 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; CIBA)' WHERE `id` = '1' LIMIT 1; [2010-04-14 20:15:49]SELECT * FROM game_fleets WHERE `fleet_start_time` <= '1271247349'; [2010-04-14 20:15:49]SELECT * FROM game_fleets WHERE `fleet_end_time` <= '1271247349'; [2010-04-14 20:15:49]SELECT * FROM game_iraks WHERE zeit <= '1271247349' [2010-04-14 20:15:49]SELECT * FROM game_planets WHERE `id` = '1'; [2010-04-14 20:15:49]SELECT * FROM game_galaxy WHERE `id_planet` = '1'; [2010-04-14 20:15:49]SELECT * FROM game_lunas WHERE `id_owner` = '1' AND `galaxy` = '1' AND `system` = '1' AND `lunapos` = '1'; [2010-04-14 20:15:49]SELECT * FROM game_fleets WHERE `fleet_owner` = '1'; [2010-04-14 20:15:49]SELECT * FROM game_fleets WHERE `fleet_target_owner` = '1'; [2010-04-14 20:15:49]SELECT * FROM game_planets WHERE id_owner='1' [2010-04-14 20:15:49]SELECT * FROM game_iraks WHERE owner = '1' [2010-04-14 20:15:49]SELECT * FROM game_statpoints WHERE `stat_type` = '1' AND `stat_code` = '1' AND `id_owner` = '1'; [2010-04-14 20:15:49]SELECT username FROM game_users ORDER BY register_time DESC [2010-04-14 20:15:49]SELECT COUNT(DISTINCT(id)) FROM game_users WHERE onlinetime>1271246449 [2010-04-14 20:15:49]SELECT COUNT(*) FROM game_users WHERE onlinetime>='1271246449' [2010-04-14 20:15:49]LOCK TABLE game_planets WRITE [2010-04-14 20:15:49]UPDATE game_planets SET `metal` = '500.522222226', `crystal` = '500.261111108', `deuterium` = '500', `last_update` = '1271247349', `b_hangar_id` = '', `metal_perhour` = '20', `crystal_perhour` = '10', `deuterium_perhour` = '0', `energy_used` = '0', `energy_max` = '0', `b_hangar` = '0' WHERE `id` = '1'; [2010-04-14 20:15:49]UNLOCK TABLES [2010-04-14 20:15:49]SELECT `id`, `name`, `galaxy`, `system`, `planet`, `planet_type` FROM game_planets WHERE `id_owner` = '1' ORDER BY `id` ASC [2010-04-14 20:15:51]SELECT * FROM game_config [2010-04-14 20:15:51]SELECT * FROM game_users WHERE `username` = 'user100'; [2010-04-14 20:15:51]UPDATE game_users SET `onlinetime` = '1271247351', `user_lastip` = '127.0.0.1', `user_agent` = 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; CIBA)' WHERE `id` = '1' LIMIT 1; [2010-04-14 20:15:51]SELECT * FROM game_fleets WHERE `fleet_start_time` <= '1271247351'; [2010-04-14 20:15:51]SELECT * FROM game_fleets WHERE `fleet_end_time` <= '1271247351'; [2010-04-14 20:15:51]SELECT * FROM game_iraks WHERE zeit <= '1271247351' [2010-04-14 20:15:51]SELECT * FROM game_planets WHERE `id` = '1'; [2010-04-14 20:15:51]SELECT * FROM game_galaxy WHERE `id_planet` = '1'; [2010-04-14 20:15:51]UPDATE game_planets SET `metal` = '500.52222223' , `crystal` = '500.26111111' , `deuterium` = '500.00000000' , `b_building` = '0' , `b_building_id` = '0' WHERE `id` = '1'; [2010-04-14 20:15:51]UPDATE game_planets SET `b_building_id` = '0', `b_building` = '0' WHERE `id` = '1';