RPG Map

Apollo_Ares

I am creating a multiplayer RPG and I need to create a map for the game. I am a bit lost on how to do this.

What I have been thinking is to setup a table in my tao_game database on MySQL called "sectors" there I would create a row for sector_id (autoincrament), location_x, location_y, description (this is text that would show up describing the sector to the player), type (this would determine what type and whether a computer generated character would be produced), ownership (which "race" controls the sector). The player would have his sector_id stored in a session cooky.

What I want to do is preduce a HTML table from this information. Graphics would be called up and would be placed in their proper location in the table, the table would always be 8 x 8 and would center on the location of the player.

I have no idea how to make this happen. Any suggestion would really help.

drawmack

I've thought about this problem and come up with a theoretical solution. I have never implemented this but it should work:

Think of the database table like a map grid the columns and rows making the squares. Then you create a series of tables like this

world:
city:
block:
building:

then you can place the pc on the grid by assigning them and row and column setting in the appropriate tables and you can have the information about a particular grid square stored in another table with with actual data.

Apollo_Ares

Yah but I am not sure how to place grapice in the appropare row and column of the HTML table.

I need to somehow name the cells in the table. Make sure that I can coralate these names to changing coord (as the character moves). And place the graphics in those named cells.

With alot of thinking...
I may be able to figure it out but that might take a long time.

Again... Any help! Please.

drawmack

set the table up like this:

table_world
    auto_id bigint auto_increment,
    col_1
    col_2
    ...
    col_n

now you can name the cells table_name_auto_id_col_n.

Then you know the database placement of the cell just by its name.

In the cell store a link to the graphic contained in that cell.

Apollo_Ares

I thought of two other ways before I read your post. I don't have time but I will read your suggestion.

Thanks.