 |
| |
|
|
Aeson
|
 |
orangesoda
Nov 2001
time: 22:29
|
|
code:
player
id
name
password
email
notify
title
This will probably expand to allow for more security (IP, cookies, ect) in the registration and login pages. Right now they are very basic.
Title is a reference to the id in the title table.
code:
title
id
name
tilerequirement
unitrequirement
connectionrequirement
titlesrequirement
cost
bonus
commandleader
code:
tile
id
name
owner
x
y
type
resource
road
mine
irrigation
railroad
harbor
offshoreplatform
This will hold the actual tiles. The name would be so the player could name their mountain, hill, whatever. x and y are the coordinates, and I think using a square grid naming system instead of the ingame isoteric system would be best. Basically rotate the map 45 degrees, which won't result in a square map, but it will be obvious which tiles are next to each other with minimal math.
Type references the id field of the tile_type table. That way we only have to store the Food, Production, and Commerce numbers once for each terrain type, instead of 10000 times for each individual tile.
Same thing with resource, it references the id field in the resource table.
The improvements could be consolidated into a single binary field.
code:
tile_types
id
name
food
production
commerce
roadbonus
minebonus
irrigationbonus
railroadbonus
harborbonus
offshoreplatformbonus
This is pretty straightforward. It's just what you'd find in the editor.
code:
resource
id
name
fbonus
pbonus
cbonus
Same here.
|
|
| |
|
|
|
Aeson
|
|
orangesoda
Nov 2001
time: 22:29
|
|
Pages in the works: (suggestions needed)
Player overview page. (available to anyone?) Shows what the player owns. Their title, stocks, tiles, units, buildings
Player admin page. (available only to the Player) Bid on units, tiles, or sell/trade them. Buy/sell/trade/give stocks. Buy/upgrade/modify buildings. Order unit movement. Apply for title. Vote on issues?
City overview page (available to everyone). View build queues, city improvements, units under city control, tiles owned and by whom, tiles up for sale.
City admin page. (available only to the Mayor of that city) Assign laborers, build queues, order movement of city owned units. Put units up for sale.
Demogame overview page. (available to everyone) Shows unit movement orders from owners/mayors. Laborer assignments from Mayors. Build queues from Mayors. Diplomatic status with AI. Financial reports. Latest save for downloading.
Demogame admin page. (available to elected leaders) Set up polls. (not sure if we shouldn't just use the forum for this) Upload saves. This could automatically extract some of the game status for the overview page like is done in the CFC GOTM submission process. Depends on the php processing limit on the hosted server, as php is slow at the decompression.
|
|
| |
|
|
|
Lord Nuclear
|
|
quote:
Originally posted by Aeson
About how much room do you want to allocate to this? The pages themself, and the database, won't take up much room at all. Probably around a couple MB's. The 130x65 tile table takes up around 200k, and eventually the unit, bid, and building tables will be somewhat large too.
There are some fun things we can do that will take up extra space... and I'm sure we can fill up whatever you are willing to allocate. 
You mentioned jousting, which I think is a really cool idea. There could be an option to throw a tournament for a certain amount of gold/labor (with prizes). The site (tile) and date (turn) would be chosen, and to enter a unit would need to be there in-game on that turn, and pay an entry fee determined by the host(s). Units fighting could gain experience and levels affecting the outcome of later events they enter. Owners of the units would gain fame based on how well their champions did, and the host(s) would gain fame as well as a commerce bonus (based off the population of the city?). |
I support all fun things 
GF, I am asking this again. When do you think this will be up and running?
|
|
| |
All times are GMT. The time now is 05:29.
Apolyton Time is 00:29. |
top of page
|
|
|
Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is ON
vB code is ON
Smilies are ON
[IMG] code is ON
|
|
|
|
|
|
29-08-2003 02:11
|
|