- Joined
- Sep 16, 2007
- Messages
- 1,204
- Reaction score
- 551
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:
