Stendhal Achievement Development: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Madmetzger |
imported>Madmetzger |
||
| Line 14: | Line 14: | ||
** table for achievment types? maybe not needed, strings could be applied in the reached achievements table |
** table for achievment types? maybe not needed, strings could be applied in the reached achievements table |
||
** table for player has reached achievement |
** table for player has reached achievement |
||
CREATE TABLE achievement IF NOT EXISTS ( |
|||
id INTEGER AUTO_INCREMENT NOT NULL, |
|||
character_id INTEGER, |
|||
achievement_category STRING, |
|||
achievement_title STRING, |
|||
timedate TIMESTAMP default CURRENT_TIMESTAMP |
|||
PRIMARY KEY(id) |
|||
) |
|||
* check if player has fulfilled an achievement |
* check if player has fulfilled an achievement |
||
** "polling" every x turns via TurnListener, but could be a bad idea as checking might be expensive |
** "polling" every x turns via TurnListener, but could be a bad idea as checking might be expensive |
||