Community AlphaAlpha MUADMINS
FILFilipino
Mag-sign in
Sa MuADMINSConfig ScannerI-upload ang zip ng mga file mo: rate, drop, spot, limitBuksanSa MuADMINSMakipagkita sa amin sa DiscordHumingi ng tulong, ibahagi ang ginagawa mo at makipag-usap tungkol sa MU sa ibang may-ari ng server.Buksan
← Lahat ng solusyon
Server setupMSProS2, S3, S6

What are the MSPro database settings (ODBC, MD5Encryption, DisconnectOnlineAccount) and the update queries?

Isinulat ng MuADMINS mula sa sourceNot verified

MSPro files connect through the ODBC DSN named MuOnline:

  • JoinServer\JoinServer.ini: JoinServerODBC = MuOnline, CaseSensitive = 0, MD5Encryption = 0, MaxIPLimit = 0, MaxHwIDLimit = 0, DisconnectOnlineAccount = 0, JoinServerUSER = sa.
  • DataServer\DataServer.ini: ODBC = MuOnline, SQLUser = sa, WriteQueryLog = 1.

The database is MuEmu based (WZ_GetAccountLevel / WZ_SetAccountLevel, WZ_SetCoin, WZ_DesblocAccount, WZ_GetResetInfo ...) plus MSPro procedures (MSP_AddCountFortuneWheel, MSP_SetKillLog, WZ_GetMarryInfo, WZ_SetMarryInfo, WZ_UpdateAccountLevel, WZ_GetGremorySerial).

Updates: Tools - Querys Y Otros\Query-Sql has 36 scripts named by version (V3 to V14): run the ones newer than your database, in order, server closed, backup first. Examples: V6 AccountCharacter 10 slots + WZ_CreateCharacter 10 slots, V7 UpdateAccountLevel / PenaltyData / PlayerDieLog, V11 ResetSystem, Flag System, JewelBank AutoSave, V12 Gremory Case, V13 Daily Bonus, V14 Fortune Wheel, Lock Manager, Kill Log.

Watch out: MOD_WzCustomRakingNoGM.sql starts with USE [MSProyect]. Change that line to your database name (normally MuOnline) before running it, or it fails / changes another database.

Source: MSPro S2-S3 (MuServer) V14.0: JoinServer/JoinServer.ini, DataServer/DataServer.ini, DB/MuOnline.bak (procedure names read from the file), Tools - Querys Y Otros/Query-Sql.

Isinulat ng MuADMINS
Nakatulong ba ito?

Naipit pa rin? Maghanap sa MuGPS Magtanong sa MU Assistant

MuADMINS Community Alpha: libre, gawa ng komunidad, at patuloy na dine-develop.