Skip to content

accountextensionspent

Timothy C edited this page Dec 10, 2017 · 4 revisions

Description

This table contains a log of all Extension Point expenditure that has ever happened.

Table Structure

ID Type Name Description Properties Links
1 Number accountid The ID of the account that has spent the EP on skills. ???
2 DateTime eventtime The timestamp at which the account spent the EP on skills. ???
3 Number points The number of EP spent for this particular skill. ???
4 Number extensionid The ID of the skill that EP was spent on. ???
5 Number extensionlevel The level at which the upgrade was spent for. ???
6 Number characterid Which character was the EP spent on? ???
7 Number id The index of this EP expenditure entry. PRIMARY None

Notes

extensionid & extensionlevel

The combination of these two skills should NEVER repeat twice for any particular player, since it's impossible to (for example) buy Thelodica Light Bots Level 5 twice. You can only buy a level once since it gets upgraded.

// todo: Figure out does the server delete entries from here if you were to refund skill points?

So: yes, the same combination may appear multiple times, but for any one player, it should only appear ONCE.

Clone this wiki locally