MuADMINS
Solutions
Des correctifs courts pour les problèmes courants de serveur, de client et de site web MU Online, chacun avec sa source et sa date. “Confirmé” signifie que la personne qui a posé la question a indiqué que le correctif a fonctionné.
2 solutions pour “procedure” dans Outils · Effacer
IGC.EssentialTools: creating an account fails with "Could not find stored procedure master.dbo.XP_MD5_EncodeKeyVal"
1. The tool hashes the password with the MD5 extended procedure, which is not installed in your SQL Server. 2. Install the MD5 procedure for your SQL Server: the fix in the thread is the...
✓ Confirmé par l'auteur du sujetRaGEZONE · 2018-10-21MU DB Helper: how do I install the item, inventory and vault database editor for Ex702 and newer servers?
1. Requirements: Visual Studio 2013, SQL Server 2012 or newer, ODBC Driver 13 and a MU Online Ex702+ database. 2. Clone the repository and make sure a MuOnline database exists (CREATE DAT...
Plus de réponses pour « procedure »
2 dans Outils, 31 dans d'autres catégories et fichiers serveur :
Could not find stored procedure 'WZ_CONNECT_MEMB' (or WZ_DISCONNECT_MEMB): what they do and how to restore them
WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB keep MEMB_STAT up to date (ConnectStat 1 at login, 0 at logout). They must exist in the database the JoinServer / DataServer connects to: - IGCN: in...
Not verifiedRédigé par MuADMINSWhich databases and procedures do WebZen 97d, Season 2 and Season 3 files use?
- 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_MEM...
Not verifiedRédigé par MuADMINSLouis update 27: CashShopData is not updated with the Custom Arena reward when the event ends.
1. The procedure WZ_CustomArenaRanking only rewards arena index 0 (IF @ArenaNumber = 0), so check which arena number you use. 2. Add the reward for your arena index if it is not 0. 3. The...
✓ Confirmé par l'auteur du sujetCreandoMU · 2021-09-19Web JM final: rankings show nothing although the site works.
1. Check the procedure WZ_SetResetInfo in the MuOnline database (Louis emulator). 2. Fix it so resets are written where the site reads them. 3. Reload the rankings.
✓ Confirmé par l'auteur du sujetCreandoMU · 2020-08-11How do I give GoblinPoints each time a character resets (Season 6 MuEmu)?
1. In SSMS edit the procedure WZ_SetResetInfo. 2. Below the line that starts with UPDATE Character add UPDATE CashShopData SET GoblinPoint=GoblinPoint+100 WHERE AccountID=@Account. 3. Exe...
✓ Confirmé par l'auteur du sujetCreandoMU · 2021-01-21IGCN WZ_MD5 (PasswordEncryptType 1): fn_md5 fails or XP_MD5_EncodeKeyVal is not found
IGCN's fn_md5(@data VARCHAR(20), @data2 VARCHAR(10)) RETURNS BINARY(16) does only one thing: EXEC master.dbo.XP_MD5_EncodeKeyVal @data, @data2, @hash OUT (password first, account second)....
Not verifiedRédigé par MuADMINSNew characters show 65535 kills and deaths.
1. Fix existing ones: UPDATE dbo.Character SET Kills=0 WHERE Kills=65535 and the same for Deads. 2. In SSMS design the Character table and set the Default Value of Kills and Deads to 0. 3...
✓ Confirmé par l'auteur du sujetCreandoMU · 2020-08-20DarksTeam Season 3 Episode 2 (Beta 19) Cash Shop: a bought Seal disappears after reconnect
The seal was saved with a wrong date format in t_perioditem_info. 1. Open the stored procedure t_perioditem_insert in the MuOnline database. 2. Fix the datetime format it uses when insert...
✓ Confirmé par l'auteur du sujetDarksTeam · 2009-08-09