hey guys can any one help me out im trying to run a server on win7 x64 and ive encountered errors well everything runs fine except when i try to log in it doesnt work and in log it shows that some error occurred im running on centos 5 and using chumpy's repack 2.8 i also used this :
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER FUNCTION [dbo].[fn_md5] (@data varchar(255))
RETURNS CHAR(32) AS
BEGIN
return SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', @data)), 3, 32)
END
to get md5 working on x64 bit i dont know whats wrong i wanna run it :( help me out plz ive included logs from my server.
Run the following query and if you get letters and numbers back md5 is working, if you get NULL it is not. Your function is correct assuming it is in the account database. The logs do show that it can't work out your user number (it's returning a usernum of 0).
select account.dbo.fn_md5('test')
I'm using Win7 x64, sql 2005 express (64-bit version) and that same function so it definitely works.
ty chumpy its all good fixed it ^^ one other little problem im having is 3rd and 4th inventory slot if i try to add something in there in game or i puck up something and it goes to 3rd/4th inventory slots it will DC me for some weird reason any idea whats up?.thx :)
Getting DB Error on win7 x64.
Reply With Quote
