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.
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 about. |
|
|
This states which NPC holds the quest. |
|
|
When a prerequired quest ID is set to the quest, players need to complete the prerequired quest in order to accept this quest. |
... |