Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open
← All solutions
Server setupX-TeamS2, S15, S17, S18

What is in the X-Team MuOnline database (password column, VIP, coins, resets, gens, master level)?

Written by MuADMINS from the sourceNot verified

X-Team uses one database, MuOnline, with the MuEmu procedure set.

  • Accounts: MEMB_INFO.memb__pwd varchar(10) (plain; no MD5 function in the scripts), sno__numb char(18), AccountLevel / AccountExpireDate NOT NULL with defaults (VIP).
  • Online: MEMB_STAT (ConnectStat, ServerName varchar(50), IP, ConnectTM, DisConnectTM), no OnlineHours. WZ_CONNECT_MEMB(@memb___id, @ServerName varchar(50), @IP varchar(20)).
  • Characters: AccountCharacter GameID1 to GameID10 (S17), Character ResetCount / ResetDay / ResetWek / ResetMon, MasterResetCount ..., CtlCode, Ruud, ExtInventory.
  • Master level: MasterSkillTree (Name, MasterLevel, MasterPoint, MasterExperience, MasterSkill).
  • Coins: CashShopData (AccountID, WCoinC, WCoinP, GoblinPoint) in Season 17 (Season 2 has none).
  • Gens: Gens_Rank (Name, Family, Contribution) with views Gens_Duprian and Gens_Varnert.
  • Season 17 update folder EX1601_EX1702: PentagramJewel.SetOptionIndex, new WZ_CreateCharacter / WZ_DeleteCharacter / WZ_RenameCharacter, MasterSkillTreeExt.MasterSkill varbinary(1080), new tables JewelOfHarmonyItem, MonsterSoulData, PlayTimeEvent.

Source: X-Team S17 MuServer 20.10 DB/MuOnline.sql and DB/EX1601_EX1702, X-Team S2 DB/MuOnline.sql.

Written by MuADMINS
Did this help?

Still stuck? Search MuGPS Ask the MU Assistant

MuADMINS Community Alpha: free and community made, in active development.