search

Abstrct / Schemaverse

The Schemaverse is a space-based strategy game implemented entirely within a PostgreSQL database. Compete against other players using raw SQL commands to command your fleet. Or, if your PL/pgSQL-foo is strong, wield it to write AI and have your fleet command itself!
schemaverse.com
PostgreSQL License
356 stars 39 forks source link

Can't create new ships #25

Closed wolever closed 11 years ago

wolever commented 11 years ago

When trying to create a new ship:

schemaverse=> insert into my_ships(name) values ('Shippy');
INSERT 0 0
schemaverse=> select count(*) from my_ships;
 count 
-------
     0
(1 row)

This is with a newly created account:

schemaverse=> select * from my_player;
 id  | username |          created           | balance | fuel_reserve |                 password                 | error_channel | starting_fleet | symbol | rgb 
-----+----------+----------------------------+---------+--------------+------------------------------------------+---------------+----------------+--------+-----
 908 | wolever  | 2011-09-13 19:46:27.010203 |   10000 |       100000 | md5xxxxx7b7687b0d93b8cd4080cb2xxxxx      | xxxxxxxxxx    |                |        |
wolever commented 11 years ago

Oh… it's because I don't have a planet yet: https://schemaverse.com/tutorial/tutorial.php?page=CreatingAShip

Abstrct commented 11 years ago

This is a pretty common problem for new players. We are working on resolving in in a couple different ways but, in the mean time, the best way a player can get back into the action is by just creating a new account. When you create a new account, if there is no new planet available for you to make home, the system will generate a new planet to assign to you, allowing you to create ships (at least until it is taken over!).

Many players have two or three accounts so don't be concerned if you need to create a couple.