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 setupWebZen 97d / 99b97d, 99b, S2, S3

Which databases and procedures do WebZen 97d, Season 2 and Season 3 files use?

Written by MuADMINS from the sourceNot verified
  • 97d (RaGEZONE pack): MuOnline.bak and Ranking.bak, SQL Server 2000 backups (restore them on 2005, 2008 or 2008 R2 first: 2012 and newer cannot restore a SQL 2000 backup). WZ_CONNECT_MEMB(@uid varchar(20), @server varchar(20), @uip varchar(20)) and WZ_DISCONNECT_MEMB(@uid) write MEMB_STAT inside a transaction. The old billing tables VI_CURR_INFO and MEMB_DETA exist (WebEngine "season_1_support" inserts VI_CURR_INFO on register). The 97p RankingServer has its own scripts: SP_SETT_EVENT_INSERT, SP_SETT_EVENT_RESULT, USP_EVENT_EDIT, USP_EVENT_LIST, table T_Event_Barunson.
  • Season 2 (namech): MuOnline, MuOnline_Event and MuOnline_Ranking; MD5 functions UFN_MD5_ENCODEVALUE / UFN_MD5_CHECKVALUE / SP_MD5_ENCODE_VALUE; vault procedures WHS_SELECT and WHS_UPD_MnyPwDbv.
  • Season 3 (mumatrix): SP_MD5_ENCODE_VALUE; the backup also holds DmN CMS procedures (it was used with DmN).

Back up and restore all databases of a pack together (MuOnline with its Ranking / Event databases).

Source: MU 97D-[RaGEZONE].zip (MuServer/backupDB, MuServer/RankingServer), 97p MuServer RankingServer scripts, Season 2 namech "Database Files", Season 3 mumatrix configs (mu/Database/MuOnline.bak); module texts read from the backups as bytes.

Written by MuADMINS
Did this help?

Still stuck? Search MuGPS Ask the MU Assistant

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