Setting up server environment for quests
Before we start coding, we need to store a list of quests information and also the progress of each quest for each player. We are going to create two tables in the MySQL database. The virtual world client-side will retrieve this information through server-side extensions.
Setting up database
We need to create two tables in PhpMyAdmin
, one for storing the quests data and the other for storing the relationship between each avatar and each quest.
Let's take a look at the table structure of quests:
Column |
Type |
Description |
---|---|---|
|
|
The unique ID to reference a quest. |
|
|
The title of the quest. |
|
|
Some background information and requirements to let players know ... |
Get Flash Multiplayer Virtual Worlds now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.