MuCore Top Online Ranking

[Exhurtum]

Hi everyone!

I'm trying to get this Top Online Ranking working:
https://forum.ragezone.com/f197/mu-core-1-0-8-a-944572/

I run the query and after that, the TH table was added correctly to MEMB_STAT, but i just can't replace the content of the WZ_DISCONNECT_MEMB
I get this error when i try to edit:

http://vvcap.net/db/9fa7UPn8-y57KlHU1Z7g.png

The ranking is not working because i can't replace that stored procedure.

By the way, in english, that sql error says: "error 446: cannot resolve collation conflict equal operator"

I'd appreciate any advices or if somebody actually know how to get this solved.

Thanks RZ!

Edit:
I just noticed I didn't start this thread correctly >< .. Sorry about that

[MentaL]

[Mr X]

@Exhurtum
Please take Database Offline and edit it.

[Exhurtum]

@Exhurtum
Please take Database Offline and edit it.

Not solved. I remember i had a bug in MuCore.. the website wasn't showing the total online players and i found how to fix that here in RZ. To fix that i had to change WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB.
I have my server in VPS so i tried to replace WZ_DISCONNECT_MEMB in my notebook with the original db as it was before i changed those procedures and worked fine.

The thing is.. I can't find the link where i found how to fix that mucore bug and i don't remember what else did i do that time. I know i changed WZ_CONNECT and DISCONNECT but i don't remember if i did something else..

Anyway.. my current WZ_DISCONNECT_MEMB looks like this:

CREATE PROCEDURE WZ_DISCONNECT_MEMB

@uid varchar(20)
AS
Begin

BEGIN TRANSACTION

SET NOCOUNT ON

IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED)
WHERE memb___id = @uid )
Begin
UPDATE MEMB_STAT
SET DisConnectTM = (getdate()), connectstat = 0 WHERE memb___id = @uid
End
ELSE
Begin
INSERT INTO MEMB_STAT ( memb___id,DisConnectTM,connectstat) valueS (
@uid,
(getdate()),
0
)
End


IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION

SET NOCOUNT OFF
End
GO

Thanks for your help

P.S: I also tried to add ", TH = TH+(DATEDIFF(mi,ConnectTM,getdate()))" to the UPDATE in memb_stat and shows the same error.

[jacubb]

Try to edit your stored procedure and just add there logging for online time.

[Exhurtum]

Try to edit your stored procedure and just add there logging for online time.

How do i do that?
What i tried to do is to replace the whole procedure by the one in the thread and it doesn't work. Also tried to add " TH = TH+(DATEDIFF(mi,ConnectTM,getdate()))" to query in UPDATE MEMB_STAT and nothing.