- Joined
- Sep 16, 2007
- Messages
- 1,206
- Reaction score
- 541
Episode 3 to Episode 7 Database Guide
GS Database Guide
Database | Table | Purpose |
RanGame1 | ChaFriend | Character's Friendlist |
ChaInfo | Character Data | |
GuildInfo | Guild Data | |
GuildRegion | Club Wars E-Room Owner list | |
GuildAlliance | Guild Alliance list | |
PetInfo | Character Pet Data | |
PetInven | Pet Inventory | |
UserInven | User Locker | |
VehicleInfo | Character Vehicle Data | |
RanLog | LogAction | Character, Accounts Log (see EMLOGACTION enum on source code for Type) |
LogItemExchange | Item and Gold flow history (based on chanum and or usernum, see EMIDTYPE for the basis of ItemFrom and ItemTo) | |
LogItemRandom | Item randomizer logs | |
LogPetAction | Pet related history | |
LogVehicleAction | Vehicle related history | |
LogServerState | Session Server Heartbeat, logs the current peak player count of the server | |
RanShop | ShopItemMap | List of items for the item shop |
ShopPurchase | User item bank, depends on ShopItemMap ProductNum | |
RanUser | UserInfo | User Account List |
LogLogin | User Login record history | |
StatGameTime | Daily tally of all gametime of accounts | |
StatLogin | Hourly tally of online count |
GS Database Guide
Database | Table | Purpose |
RanGameS1 | ActivityInfo | Character Activity Data |
ActivityRewardBadge | Badges acquired by Character | |
ActivityRewardPoint | Points acquired by Character | |
AttendanceInfo | Character Attendance Info | |
AttendanceTaskInfo | Character Ongoing Attendance | |
ChaFriend | Character's Friend List | |
ChaFriendGroup | Character Friend list Group | |
ChaHireSummonInfo | Character Summon Hiring Data | |
ChaInfo | Character Data | |
ChaSlotsInfo | Character Slots Info (See A, B, C, D on Character Window), SelectCharSlot on usefeatures_gs.lua must be true to enable this feature | |
GuildAlliance | Guild Alliance List | |
GuildBattle | Guild Wars History | |
GuildInfo | Guild Data | |
GuildRegion | Club Wars E-Room Owner list | |
Item | Item Data (Equivalent to EP7's UserInven, ChaInven and other item related info, it's not binary anymore, it's now human readable) | |
LottoBuyList LottoBuyMoney LottoDrawingMachine LottoNumInfo LottoSystemInfo LottoSystemTurn LotoTurnInfo LottoWinManList | Lotto related tables, these are system generated, so don't touch it unless you know what you are doing. | |
PetInfo | Character Pet Data | |
PetInven | Pet Inventory | |
PostInfo | Mailbox Data | |
ProductBook | Crafting Category Data | |
RanLog | LogAction | Character, Accounts Log (see EMLOGACTION enum on source code for Type) |
LogItemExchange | Item and Gold flow history (based on chanum and or usernum, see EMIDTYPE for the basis of ItemFrom and ItemTo) | |
LogItemRandom | Item randomizer logs | |
LogPetAction | Pet related history | |
LogVehicleAction | Vehicle related history | |
LogServerState | Session Server Heartbeat, logs the current peak player count of the server | |
AttendanceLog AttendanceTaskLog | Attendance Related logs | |
CTFPlayLog CTFResult CTFStatLog | Tyranny Related logs (rewards sent to character, items sent to each school, how many participated on specific tyranny battle time) | |
ItemLog | Item Transaction history | |
ItemLogAddon | Logs for Item Addon Value | |
ItemLogBasicStat | Item Basic Stats History (if OPItemCheck is true on usefeatures_gs.lua, it will automatically delete overpowered item) | |
ItemLogRandom | Item Rebuild Card Item RV Logs | |
LogGMChat | GM Character chat audit log | |
LogGmCommand | GM Character command audit log | |
LogMoney | Money related logs see EMGAME_MONEY_CHANGE on MoneyLogDefine.h | |
RanShop | ShopItemMap | List of items for the item shop |
ShopPurchase | User item bank, depends on ShopItemMap ProductNum | |
PointShop | In-game Itemshop using RanPoint as currency | |
ConsignmentSale | Item for sale by character via ranpoint | |
RanUser | GSUserInfo | User Account List |
LogLogin | User Login record history | |
StatGameTime | Daily tally of all gametime of accounts | |
StatLogin | Hourly tally of online count |
Last edited: