11-07-2004 13:47									#1
	Feudal System Script Developers: Early Discussion Support Apolyton, buy Galactic Civilizations

Current Developers:
Uber KruX
Aeson
Esoteric

This is early discussion because, well, I am not exactly sure how the entire feudal system is, and to be honest, I don't think anyone but Farb knows that (or if he even does).

Farb has given each of the three original developers seperate directories on his website, www.ghengisfarb.com. I would propose we use his webspace for the project, since we all have accounts and he seems willing to allow us to mess around and get it all up and running.

I would, however, request that we all have access to a shared directory, so that we could work on the same scripts (not at the same time, of course). If we are going to work collectively on this project, we will need to be able to access eachother's files. I would suggest a "feudal" directory be made on the website, and access be given to the developers (ie, www.ghengisfarb.com/feudal).

Now, down to business.

We need to enumerate pretty much everything that makes up the $mini-demogame, so that rules can be coded. As stated many times, I do not know everything about the game, and would need to fully understand it before I could design an appropiate system for it.

The basics are easy. I would first propose that we build the system around a forum (IPB, PHPBB, whatever). We're probably going to want our own forums for each city / guilds / whatever in the near future, so why not just create it on GF's site, and then have our scripts link to the forum's user data etc?

Tile ownership could easily be transferred to a MySQL database, and could be done in two ways, brute force or careful planning. Brute force would basically have a person enter the values for each tile, and when they changed, an admin would have to update them and type in the new values. I do not like this idea, because I am a man of automation. Simple things like building a mine, changing governments, etc, can impact tiles every round, and people may miss changes or enter data incorrectly.

I would propose that we hard-code the base values for each terrain, and then have the tile table only store several small values: terrain, roaded, irrigated, mined and city. In this system, an admin would only have to update the status of the improvements on a tile, which could be easily done through a control panel.

In fact, I believe it would be extremely easy to make a script to ask you for a city name, and then create a graphical representation of the city and it's 20 workable tiles, and allow the admin to easily click buttons to road, mine, or irrigate the tiles to match the in-game tiles. In fact, maybe we could pass this job down to Town Elders, to split the work into small chunks.

Some sort of tile numbering system would be needed for my plan, but if I'm not mistaken Aeson has already found our coordinates from the minimap. It shouldn't be that hard to devise a system based on that.

It's late, so I'll leave it like this for now. Fellow developers, feel free to post in this thread with your ideas / suggestions. And Aeson, please inform me of the coordinates of our start

edit: We would need a forum system where people could join groups, much like poly's "civgroups", sometimes only when invited in. Also, I'd like some of them to have icons, but not all of them (ie, secret guilds do not need icons to broadcast their intentions).

Last edited by Inverse Icarus on 11-07-2004 at 13:57

	11-07-2004 14:24									#2
	Support Apolyton, buy Call to Power 2

Actually, we would really only need that shared directory- I am not entirely certain what to do to a whole folder on GF's site- I suppose I could plop a forum in there with some modifications, and we could copy it over to the shared folder and take turns butchering.

I think that whatever we come up with should involve an easy and definitely automated db manager- If we could create a extension of the cash mod, players can make exchanges and it would be communicated to the 'accounts' database instantly, all we would want to add would be the input and payout modifications- that and the tile tracking...and, er, the aaaaaaaaaaaaaaaa....
dang, I wish I understood the feudal system a little better- Aeson you wrote a version for the $minigame, share your wisdom. please

	11-07-2004 19:45									#3
	Lose 30 kilos (of popups)

Attached is the structure to the database I had put together. I'll go over some of the details for some of the tables. More if the sun doesn't come out today.. (marine layer looks thick! )

Basically I went with more of the "careful planning" approach. The tiles held values that were pointers to tile types.

code:
CREATE TABLE feudemo_tile (
  id smallint(5) unsigned NOT NULL auto_increment,
  name varchar(64) NOT NULL default '',
  owner tinyint(3) unsigned NOT NULL default '0',
  x tinyint(3) unsigned NOT NULL default '0',
  y tinyint(3) unsigned NOT NULL default '0',
  type tinyint(3) unsigned NOT NULL default '0',
  resource tinyint(3) unsigned NOT NULL default '0',
  improvements int(10) unsigned NOT NULL default '0',
  escrow tinyint(3) unsigned NOT NULL default '0',
  visible tinyint(3) unsigned NOT NULL default '0',
  UNIQUE KEY id (id)

Attachment: database.zip
This has been downloaded 1 time(s).

	11-07-2004 19:59									#4
	Get a bigger avatar today!

code:
CREATE TABLE feudemo_tile_types (
  id tinyint(3) unsigned NOT NULL auto_increment,
  name varchar(64) NOT NULL default '',
  food tinyint(3) unsigned NOT NULL default '0',
  production tinyint(3) unsigned NOT NULL default '0',
  commerce tinyint(3) unsigned NOT NULL default '0',
  ibonus tinyint(3) unsigned NOT NULL default '0',
  mbonus tinyint(3) unsigned NOT NULL default '0',
  rbonus tinyint(3) unsigned NOT NULL default '0',
  UNIQUE KEY id (id)
) ENGINE=MyISAM;

code:
CREATE TABLE feudemo_improvements (
  id tinyint(3) unsigned NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
  UNIQUE KEY id (id)
) TYPE=MyISAM;

code:
CREATE TABLE feudemo_map (
  id tinyint(3) unsigned NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
  tiles int(10) unsigned NOT NULL default '0',
  width smallint(5) unsigned NOT NULL default '0',
  height smallint(5) unsigned NOT NULL default '0',
  UNIQUE KEY id (id)
) TYPE=MyISAM;

code:
CREATE TABLE feudemo_player (
  id tinyint(3) unsigned NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
  password varchar(32) NOT NULL default '',
  email varchar(64) NOT NULL default '',
  title tinyint(3) unsigned NOT NULL default '0',
  UNIQUE KEY id (id)
) TYPE=MyISAM;

code:
CREATE TABLE feudemo_stock (
  id tinyint(3) unsigned NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
  UNIQUE KEY id (id)
) TYPE=MyISAM;

code:
CREATE TABLE feudemo_stockpile (
  id tinyint(3) unsigned NOT NULL auto_increment,
  food smallint(5) unsigned NOT NULL default '0',
  production smallint(5) unsigned NOT NULL default '0',
  commerce smallint(5) unsigned NOT NULL default '0',
  labor smallint(5) unsigned NOT NULL default '0',
  tobacco smallint(5) unsigned NOT NULL default '0',
  fruit smallint(5) unsigned NOT NULL default '0',
  sugar smallint(5) unsigned NOT NULL default '0',
  grain smallint(5) unsigned NOT NULL default '0',
  beef smallint(5) unsigned NOT NULL default '0',
  fish smallint(5) unsigned NOT NULL default '0',
  venison smallint(5) unsigned NOT NULL default '0',
  whale smallint(5) unsigned NOT NULL default '0',
  iron smallint(5) unsigned NOT NULL default '0',
  coal smallint(5) unsigned NOT NULL default '0',
  crude_oil smallint(5) unsigned NOT NULL default '0',
  aluminum smallint(5) unsigned NOT NULL default '0',
  uranium smallint(5) unsigned NOT NULL default '0',
  horses smallint(5) unsigned NOT NULL default '0',
  saltpeter smallint(5) unsigned NOT NULL default '0',
  petroleum smallint(5) unsigned NOT NULL default '0',
  fuel_coal smallint(5) unsigned NOT NULL default '0',
  rubber smallint(5) unsigned NOT NULL default '0',
  fuel_cell_uranium smallint(5) unsigned NOT NULL default '0',
  dye smallint(5) unsigned NOT NULL default '0',
  incense smallint(5) unsigned NOT NULL default '0',
  spice smallint(5) unsigned NOT NULL default '0',
  ivory smallint(5) unsigned NOT NULL default '0',
  gems smallint(5) unsigned NOT NULL default '0',
  gold smallint(5) unsigned NOT NULL default '0',
  wine smallint(5) unsigned NOT NULL default '0',
  rum smallint(5) unsigned NOT NULL default '0',
  beer smallint(5) unsigned NOT NULL default '0',
  ale smallint(5) unsigned NOT NULL default '0',
  flour smallint(5) unsigned NOT NULL default '0',
  snacks smallint(5) unsigned NOT NULL default '0',
  pastries smallint(5) unsigned NOT NULL default '0',
  paper smallint(5) unsigned NOT NULL default '0',
  books smallint(5) unsigned NOT NULL default '0',
  pamphlets smallint(5) unsigned NOT NULL default '0',
  UNIQUE KEY id (id)
) TYPE=MyISAM;

	11-07-2004 20:06									#5
	Full PM-box? Change here!

code:
CREATE TABLE feudemo_unit (
  id smallint(5) unsigned NOT NULL auto_increment,
  tile smallint(5) unsigned NOT NULL default '0',
  owner double NOT NULL default '0',
  type smallint(5) unsigned NOT NULL default '0',
  name varchar(64) NOT NULL default '',
  hp tinyint(3) unsigned NOT NULL default '0',
  escrow tinyint(3) unsigned NOT NULL default '0',
  alive tinyint(3) unsigned NOT NULL default '1',
  UNIQUE KEY id (id)
) ENGINE=MyISAM;

code:
CREATE TABLE feudemo_unit_types (
  id tinyint(3) unsigned NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
  a tinyint(3) unsigned NOT NULL default '0',
  d tinyint(3) unsigned NOT NULL default '0',
  m tinyint(3) unsigned NOT NULL default '0',
  UNIQUE KEY id (id)
) TYPE=MyISAM;

code:
CREATE TABLE feudemo_auction (
  id tinyint(3) unsigned NOT NULL auto_increment,
  seller tinyint(3) unsigned NOT NULL default '0',
  title varchar(128) NOT NULL default '',
  item_type set('Tile','Unit','Building') NOT NULL default '',
  item_id smallint(5) unsigned NOT NULL default '0',
  bidding_opens date NOT NULL default '0000-00-00',
  bidding_closes date NOT NULL default '0000-00-00',
  minimum_bid smallint(5) unsigned NOT NULL default '0',
  current_bid smallint(5) unsigned NOT NULL default '0',
  UNIQUE KEY id (id)
) TYPE=MyISAM;

code:
CREATE TABLE feudemo_bid (
  id smallint(5) unsigned NOT NULL auto_increment,
  player tinyint(3) unsigned NOT NULL default '0',
  amount smallint(5) unsigned NOT NULL default '0',
  auction smallint(5) unsigned NOT NULL default '0',
  UNIQUE KEY id (id)
) TYPE=MyISAM;

code:
CREATE TABLE feudemo_building (
  id smallint(5) unsigned NOT NULL auto_increment,
  tile smallint(5) unsigned NOT NULL default '0',
  owner tinyint(3) unsigned NOT NULL default '0',
  type tinyint(3) unsigned NOT NULL default '0',
  specialty tinyint(3) unsigned NOT NULL default '0',
  name varchar(64) NOT NULL default '',
  escrow tinyint(3) unsigned NOT NULL default '0',
  UNIQUE KEY id (id)
) TYPE=MyISAM;

code:
CREATE TABLE feudemo_business (
  id tinyint(3) unsigned NOT NULL auto_increment,
  name varchar(64) NOT NULL default '',
  requirements int(11) NOT NULL default '0',
  cost tinyint(3) unsigned NOT NULL default '0',
  upgrade tinyint(3) unsigned NOT NULL default '0',
  upgrade_cost tinyint(3) unsigned NOT NULL default '0',
  labor_required tinyint(3) unsigned NOT NULL default '0',
  labor_max tinyint(3) unsigned NOT NULL default '0',
  consumed_stock tinyint(3) unsigned NOT NULL default '0',
  consumed_rate tinyint(3) unsigned NOT NULL default '0',
  output_stock tinyint(3) unsigned NOT NULL default '0',
  output_rate tinyint(3) unsigned NOT NULL default '0',
  bonus_stock tinyint(3) unsigned NOT NULL default '0',
  bonus_rate tinyint(3) unsigned NOT NULL default '0',
  UNIQUE KEY id (id)
) TYPE=MyISAM;

code:
CREATE TABLE feudemo_title (
  id tinyint(3) unsigned NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
  tilerequirement tinyint(3) unsigned NOT NULL default '0',
  unitrequirement tinyint(3) unsigned NOT NULL default '0',
  connectionrequirement tinyint(3) unsigned NOT NULL default '0',
  titlesrequirement tinyint(3) unsigned NOT NULL default '0',
  cost smallint(5) unsigned NOT NULL default '0',
  bonus tinyint(3) unsigned NOT NULL default '0',
  commandleader tinyint(3) unsigned NOT NULL default '0',
  UNIQUE KEY id (id)
) TYPE=MyISAM;

	11-07-2004 20:22									#6
	Get a bigger avatar today!

A brief description of the scripts contained in the uploaded file:

admin_business.php - Create new business types. Fills in the feudemo_business table.
admin_map.php - Create a new map (and all the tiles therein). Enter/Edit tile data.
admin_unit.php - Create new units. Enter/Edit unit details.

/auction/index.php - Create new auction for tiles or units the player $_SESSION[id] owns. View/Bid on auctions other players have created. Date references haven't been made yet, so the auctions never 'open' or 'close'.

/login/index.php and /register/index.php - very simple scripts to do just that. We won't need these I guess... but if you want to point out all my security vulnerabilities I could use the input.

/include/database.php - holds the connection stuff so the database, name, password is centralized. Should be using classes for all this stuff but I work best if I get the basic functionality created first, then organize it properly later.

/include/date.php - just barely started in on this. same deal.

/include/encrypt.php - basic encryption I was using for passwords.

/include/html_header.php and /include/html_footer.php - web page formatting of course. Nothing really done here except stealing a bit of GF's website.

/include/session.php - the $_SESSION stuff. I didn't know if anything else would be needed (first time using sessions), or if cookies would be desirable/necessary... so just separated it out to allow easy updating later if it turned out I was doing everything backasswords.

Attachment: feudal.zip
This has been downloaded 1 time(s).

	11-07-2004 20:32									#7
	Remove this text

Stuff that comes to mind as needed:

feudemo_city - holds population, income splits (F/P/C) for the session, road connection status, ect.

_government and _technology. Somewhere to hold data about our tech level, government level, ect. As that will affect tile production, resources viewable, market connections, businesses available, ect.

Admin pages to start and end a trading session, create city polls, fight inter-civ 'battles' or player tournaments of some sort.

	12-07-2004 09:29									#9
	Full PM-box? Change here!

I have no idea as to what that means, but thanks, Aeson.

	12-07-2004 23:47									#10
	Put an end to popups!

Looks good to me, I can get into it later this week more thoroughly, but it seems you have done a lot of the thinking for us already. I would figure we could leave out the password and login for now, and just try for functionality.

	13-07-2004 03:06									#11
	Tired of ads?

If it's going to be built into a forum system, we can just use that for login purposes. If not, the registration/login I have already set up works fine, and is easy to work with.

	13-07-2004 06:55									#12
	Enter the AD-FREE zone

Would any of you Script Developers be willing to help make the Apolyton University a website? It would be PHP run.

	13-07-2004 11:44									#13
	Inflate your Upload Space

quote: Would any of you Script Developers be willing to help make the Apolyton University a website? It would be PHP run.

What do you want it to be able to do?

	13-07-2004 18:24									#14
	Enter the AD-FREE zone

I hadn't thought about forums. My new host gives me unmetered bandwidth as long as I obey specific rules (such as no mass distribution of software, etc.). If we have someone willing to set up and run the forums I see no problem with it.

Can anyone recommend some websites with good php/mysql tutorials/lessons?

Last edited by GhengisFarb on 13-07-2004 at 18:59

	14-07-2004 00:55									#15
	Avatar Enlargement: We've got the solution

The PHP website itself has very good documentation for any function you could ever need, and has a very extensive library you can search online.

I don't know any tutorial sites offhand, but MZ mentioned a few @ MZO a while back.

Also, I'd love to set up / help run the forums. I really think all three of our FTP accounts should go to the same directory though (/feudal/).

Then, I'd set up www.ghengisfarb.com/feudal/forums/, and we'd get crackin'.

	14-07-2004 01:45									#16
	Put an end to popups!

quote: Originally posted by TORARADICAL What do you want it to be able to do?

Would you happen to have MSN, AIM, or YIM so we can discuss it?

	14-07-2004 03:27									#17
	Increase Your PM Length

All three actually. TORARADICAL on msn and yahoo, and Noitazilivic on AIM.

	26-07-2004 10:32									#18
	Tired of ads?

I got the phpBB2 forum software because it has a whole bunch of game oriented mods that you can use as snap on components. One of these is a mod that allows the admin to create curriencies and set trade rates between them, then the system tracks all the members cash.

I was thinking it would be extremely easy to add a few more functions to the mod script that allowed us to run the more complex feudal figurin and trade sessions- basically automatically.

phpBB home page

cash mod details

The thing is, we could easily create a trading only forum- continue to play here but conduct the trades in a forum designed to manage the results.