Groups: group ID, group name, group type, treasury, resources (ore, wood, food), private group & secret society*, group owner, members
Example: 2 The Adminship Foundation 3 28040 12 20 4 2 0 1 103 150
City Settings: City Name, group (that owns the city, by group ID), tax rate, tourism enabled, trading enabled
Blockopolis 3 14 1 1
Expelled List:
ids
Example: 4161, 212, 183
= 0 means none are checked, 1 means Private Group is checked, 2 means both are checked. Private Group must be checked before SS can be checked, too. This is a way to make it 1 variable instead of 2 variables that could easily be made to where PG = 0 SS = 1 and cause the server to have errors.
Information subject to change and can be organized and arranged in anyway that makes it easier to process.
Write to DB:
Users: BL_ID, name, alias, cash, group (by ID), items, backpack items Example: 3810 Randomness "Randy Adrian" 38200 3 "HammerItem, WrenchItem, PrinterItem" "TomatoItem, HeavyOre, PillBottle"
Groups: group ID, group name, group type, treasury, resources (ore, wood, food), private group & secret society*, group owner, members Example: 2 The Adminship Foundation 3 28040 12 20 4 2 0 1 103 150
City Settings: City Name, group (that owns the city, by group ID), tax rate, tourism enabled, trading enabled Blockopolis 3 14 1 1
Expelled List: ids Example: 4161, 212, 183
Information subject to change and can be organized and arranged in anyway that makes it easier to process.