i dont need testing it i just need it support win xp service pack 2 all others things i can fix and edited alone.Originally Posted by Saige
i will just wait for santa come and make that files
working.
thanks for help anyway.
have a nice day.
BARAMOS.
NewAgeMU Family.
when i change the database that i use i from this release.got a problem again on registration how to fix this?
reinstall your web and run this query inside muonlinedb:
use non md5 for better result :)CREATE FUNCTION [dbo].[fn_md5] (@data VARCHAR(10), @data2 VARCHAR(10))
RETURNS BINARY(16) AS
BEGIN
DECLARE @hash BINARY(16)
EXEC master.dbo.XP_MD5_EncodeKeyVal @data, @data2, @hash OUT
RETURN @hash
END
Last edited by Saige; 10-02-11 at 06:12 AM.
MD5-based or not?
nvm already in ^^. thanks will test this :D
Last edited by Saige; 10-02-11 at 06:11 AM.
I get this error:
"There is already an object named 'fn_md5' in the database.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master.dbo.XP_MD5_EncodeKeyVal'. The stored procedure will still be created."
yes you get that error because query for masterdb is already exist means you already add that query in master db:) make sure you have WZ_MD5_MOD.dll see instruction bellow.
apply the query that i post in muonline db. no need to repeat the masterdb query. :)
1 Copy WZ_MD5_MOD.dll from MD5 Stuffs folder to <drive>:\<path>\microsoft sql server\80\tools\binn
2 Run the following codes in Query Analyzer on Master database
exec sp_addextendedproc 'XP_MD5_EncodeKeyVal', 'WZ_MD5_MOD.dll'
3 Run the following codes in Query Analyzer on MUOnline database only if your MUOnline Server use only MUOnline database, if use MUOnline and Me_Muonline databases run them on Me_Muonline database.
CREATE FUNCTION [dbo].[fn_md5] (@data VARCHAR(10), @data2 VARCHAR(10))
RETURNS BINARY(16) AS
BEGIN
DECLARE @hash BINARY(16)
EXEC master.dbo.XP_MD5_EncodeKeyVal @data, @data2, @hash OUT
RETURN @hash
END
---------- Post added at 01:36 PM ---------- Previous post was at 01:24 PM ----------
Bugs:
-Bug warp: Dungeon 3 cant warp it say. Event Doesn't start yet gate prob? :D
-Kalrutan map warps to valley of loren. must be fix in gate? ^^ :D
Last edited by Saige; 10-02-11 at 06:56 AM.
Thanks for the tute, I can create account but the client says "Your account is invalid.". Tried restoring from a NON-MD5 pack, I can login fine. Can you share the NON-MD5 backup database (SQL2000)?
i got a fix. the database is on md5 support. to turn of the md5 simply run this on query
and reinstall the mucore.Code:ALTER TABLE MEMB_INFO ALTER COLUMN memb__pwd VARCHAR(10) NOT NULL
go edit your muonline database in SQL manager>database>muonline>tables>MEMB_INFO>Design Table>mem_password change varbinary to varchar and check allow nulls also change nso_num from 13 to 18 :D
Good Luck :)
---------- Post added at 01:50 PM ---------- Previous post was at 01:48 PM ----------
you can do that in SQL manager manually :D
Last edited by Saige; 10-02-11 at 06:51 AM.
i have a question how to fix this problem?
its rage fighter problem. i can't enter on the game
not happened to me. are you using the db attach here or not?i have a question how to fix this problem?
its rage fighter problem. i can't enter on the game
Time now for some bug hunting. Maraming salamat kabayan! (Thank you my fellow countryman).
yup i use the database from this release
weird your the only one who got that problem ^^ :)
Reply With Quote