- UID
- 19828
- UCC
-
- 声望
-
- 好评
-
- 贡献
-
- 最后登录
- 1970-1-1
|
发表于 2011-11-7 08:59:25
|
显示全部楼层
SQL 指令修訂:
This one should give you 700.000.001$.
Code:
UPDATE players SET savings=700000001 WHERE id=1
This should set all the research that you can already see to finish in 1 turn.
Code:
UPDATE player_techs SET research_cost=1, feasibility=1, player_feasibility=1 WHERE player_id=1 AND feasibility>0
This should set all the research that is a bit further away (not yet visible) to finish in 1 turn.
Code:
UPDATE player_tech_branches SET research_cost=1, feasibility=1 WHERE player_id=1 AND feasibility>0
And this one should give you every research
Code:
UPDATE player_techs SET state=6 WHERE player_id=1 AND feasibility>0
Set the resources of all your colonies to 10000
Code:
UPDATE planets SET resources=10000, max_resources=10000 WHERE orbital_object_id IN (SELECT orbital_object_id FROM colonies WHERE player_id=1)
Also, set the resources in all the planets in the systems you have colonies in to 10000
Code:
UPDATE planets SET resources=10000, max_resources=10000 WHERE orbital_object_id IN (SELECT id FROM orbital_objects WHERE star_system_id IN (SELECT star_system_id FROM orbital_objects WHERE id IN (SELECT orbital_object_id FROM colonies WHERE player_id=1)))
|
|