18 reputation
2
bio website
location
age
visits member for 2 years, 1 month
seen Mar 24 '13 at 19:14

Aug
31
comment PHP city-sim castle layout
So i could save the 6X6 of the inner castle with their respective X, Y and inner castle defining attribute and letting players expand on that with buildings and letting them define empty spaces with inner castle attribute. At which point ill add that record to the table.
Aug
31
awarded  Scholar
Aug
31
accepted PHP city-sim castle layout
Aug
31
comment PHP city-sim castle layout
Thanks on your input so far. The problem with the first approach is that if i don't have a record in that spot i cannot know if its an inner or outer tile. And the thought of having to deal with 324 rows per castle isn't really attractive. The solution i think i will use is to make a table where the value of X are a 9 number string and using substr i can figure out if its unoccupied, has a building or is a inner castle tile. And from that i can build the inner castle based on the outer castle layout and using the records in the inner castle to populate the tiles. Thanks for your help again.
Aug
31
comment PHP city-sim castle layout
@BerndBrot 10 castle tiles and 71 free tiles on the outer layer (3x3 + 1 adjacent castle tiles) and 40 castle tiles on the inner layer? (6x6 + 2x2 adjacent castle tiles) This is correct and the way i want to do it. i just don't like my current solution.
Aug
30
awarded  Student
Aug
30
comment PHP city-sim castle layout
in the beginning the 81 tiles will consist of 72 buildable tiles and 9 which will show a castle and once you clicked on that you see the inside of the 3X3. the outer 72 can become encased by the wall at a price if they are next to another one. which will lead to more room in the inner castle. The inner castle has double the amount of tiles so 3X3 in the outer is 6X6 in the inner. and my question is what the best way would be to store them in the database and differentiate between inner and outer castle.
Aug
30
asked PHP city-sim castle layout