Schiffe schenken (Weihnachten)

Entity-ID vom Marktplatz rausfinden:

SELECT * FROM entities where code = 'm';

Für jeden User eine Marktflotte auf den HP starten:

insert into fleet (user_id,entity_from,entity_to,launchtime,landtime,action,res_fuel) select q.uid,'1837',q.pid,'1356346800','1356368400','market','42' from (select p.`id` as pid,p.`planet_user_id` as uid from planets p where p.`planet_user_main` = '1') as q;

Alle Geschenkflotten raussuchen:

select id from fleet where entity_from='1837' and launchtime='1356346800' and landtime='1356368400';

Allen Geschenkflotten ein Schiff anhängen:

insert into fleet_ships (fs_fleet_id,fs_ship_id,fs_ship_cnt) select q.id,'86','1' from (select id from fleet where entity_from='1837' and launchtime='1356346800' and landtime='1356368400') as q;

Kampfschlitten hinzufügen

insert into ships (`ship_id`, `ship_name`, `ship_type_id`, `ship_shortcomment`, `ship_longcomment`, `ship_costs_metal`, `ship_costs_crystal`, `ship_costs_fuel`, `ship_costs_plastic`, `ship_costs_food`, `ship_co