Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Database Familiarity Guide

Joined
Sep 16, 2007
Messages
1,206
Reaction score
541
Episode 3 to Episode 7 Database Guide

DatabaseTablePurpose
RanGame1ChaFriendCharacter's Friendlist
ChaInfoCharacter Data
GuildInfoGuild Data
GuildRegionClub Wars E-Room Owner list
GuildAllianceGuild Alliance list
PetInfoCharacter Pet Data
PetInvenPet Inventory
UserInvenUser Locker
VehicleInfoCharacter Vehicle Data
RanLogLogActionCharacter, Accounts Log (see EMLOGACTION enum on source code for Type)
LogItemExchangeItem and Gold flow history (based on chanum and or usernum, see EMIDTYPE for the basis of ItemFrom and ItemTo)
LogItemRandomItem randomizer logs
LogPetActionPet related history
LogVehicleActionVehicle related history
LogServerStateSession Server Heartbeat, logs the current peak player count of the server
RanShopShopItemMapList of items for the item shop
ShopPurchaseUser item bank, depends on ShopItemMap ProductNum
RanUserUserInfoUser Account List
LogLoginUser Login record history
StatGameTimeDaily tally of all gametime of accounts
StatLoginHourly tally of online count


GS Database Guide


DatabaseTablePurpose
RanGameS1ActivityInfoCharacter Activity Data
ActivityRewardBadgeBadges acquired by Character
ActivityRewardPointPoints acquired by Character
AttendanceInfoCharacter Attendance Info
AttendanceTaskInfoCharacter Ongoing Attendance
ChaFriendCharacter's Friend List
ChaFriendGroupCharacter Friend list Group
ChaHireSummonInfoCharacter Summon Hiring Data
ChaInfoCharacter Data
ChaSlotsInfoCharacter Slots Info (See A, B, C, D on Character Window),

SelectCharSlot on usefeatures_gs.lua must be true to enable this feature
GuildAllianceGuild Alliance List
GuildBattleGuild Wars History
GuildInfoGuild Data
GuildRegionClub Wars E-Room Owner list
ItemItem 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.
PetInfoCharacter Pet Data
PetInvenPet Inventory
PostInfoMailbox Data
ProductBookCrafting Category Data
RanLogLogActionCharacter, Accounts Log (see EMLOGACTION enum on source code for Type)
LogItemExchangeItem and Gold flow history (based on chanum and or usernum, see EMIDTYPE for the basis of ItemFrom and ItemTo)
LogItemRandomItem randomizer logs
LogPetActionPet related history
LogVehicleActionVehicle related history
LogServerStateSession 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)
ItemLogItem Transaction history
ItemLogAddonLogs for Item Addon Value
ItemLogBasicStatItem Basic Stats History (if OPItemCheck is true on usefeatures_gs.lua, it will automatically delete overpowered item)
ItemLogRandomItem Rebuild Card Item RV Logs
LogGMChatGM Character chat audit log
LogGmCommandGM Character command audit log
LogMoneyMoney related logs see EMGAME_MONEY_CHANGE on MoneyLogDefine.h
RanShopShopItemMapList of items for the item shop
ShopPurchaseUser item bank, depends on ShopItemMap ProductNum
PointShopIn-game Itemshop using RanPoint as currency
ConsignmentSaleItem for sale by character via ranpoint
RanUserGSUserInfoUser Account List
LogLoginUser Login record history
StatGameTimeDaily tally of all gametime of accounts
StatLoginHourly tally of online count
 
Last edited:
Skilled Illusionist
Joined
May 25, 2014
Messages
354
Reaction score
29
Correction for ItemLogAddon is the logs for Item Addon Value (The green stats of Item ). this is when one uses Additional Stats Reform Card.
Based on my tests if OPItemCheck is set to true, if the addon stats is greater than the max addon value. it will not delete the item. OPItem check is for RV Only, it checks if RV is greater than the max RV then it will be deleted
 
Initiate Mage
Joined
Aug 30, 2021
Messages
4
Reaction score
0
Hello Seifer do you know what part of the source where SQL queries is?
 
Joined
May 17, 2021
Messages
28
Reaction score
17
can u help me for scripts this ,because i cant read unix code,please help me script change the text windows ...... more power
 
Back
Top