Database Familiarity Guide

[SeiferXIII]

Episode 3 to Episode 7 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

[MentaL]

[soske98]

Thanks seiferxiii for the info.

[SeiferXIII]

Updated with GS database guide

[arwekaj09]

Updated with GS database guide

Hi sir Seifer, may I know where to get the Character PK Win / Loss?

[amperejr]

RanGame1>Chainfo

[arwekaj09]

RanGame1>Chainfo

Yeah, but for the GS is different. I cant find it

[chumleader]

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

[harazuku]

Can u give me code source file RandomAddon

[garinggo20]

seifer is always helping us. keep it up man

[elpixel]

Hello Seifer do you know what part of the source where SQL queries is?

[harazuku]

can u help me for scripts this https://www.mediafire.com/file/prcul...5_300.luc/file ,because i cant read unix code,please help me script change the text windows ...... more power