[Help] Auto Character Bug Fix (2nd time)

[bextbox]

The previous post deleted for unkown reason, so I have to repost to get people help here. Please response b4 it is gone again(?).

I hope our expert in sql script here like John_D, Marcus84 and other smartguy and gal would take this problem as challenge and see who could solve this problem first.

Problem surfaced:

The server is MU season II game server based on HasteMU.
The new character created by the client got stuck and can't move with the following setting:

Experience = -100
PkCount = -100
PkLevel = -100
PkTime = -86

What is the possible caused for this adnormal results? dataserver fault?

If I go to MSSQL2005 or using editor to change all these negative figure to 0 (zero), the character behavior will be back to normal. Therefore I am thinking of writing a sql script to do the job for all newly character instead of doing it one by one by hand.

So here is the half-cookded script:

UPDATE Character
SET Experience = ('0'),
PkCount = ('0'),
PkLevel = ('0'),
PlTime = ('0'),
WHERE Experience < ('0') and PkCount < ('0') and PkLevel < ('0') and PkTime < ('0') and ConnectStat = 0

I keyed in all these into MSSQL and connect it to MuOnline database and when test it, it failed at ConnectStat = 0 saying it is not recognised. May be ConnectStat is not one of the database variables therefore not recognised?

After I remove ConnectStat = 0 and test it, it is ok. So I activate it and check in the game, nothing has happened. The script doesn't work at all. I wondering why.

I also noticed there were two database - Me_MuOnline and MuOnline. I tried both, again nothing happened.

I also want to know if we want to do character auto reset using the sql script suggested by John_d and marcus84 (in old posting) which database to be used and why ConnectStat = 0 not working?

[MentaL]

[bextbox]

Another thing, database is from 1.02d mu game server after conversion. Old/Existing characters work just fine except newly created. The JS is rather unstable and with the following error after a while:

Error: [D:\Work\Muproject\MUConnectServer\giocp:cpp] line: [497]
Get QueueCompletionStatus() (183, The Semaphore timeout period has expired)
Get QueueCompletionStatus() (183, The Network Connect was aborted by local system)

Also noticed this error:

error: LogoutInsert Log Update whenever player logout

CS icon on the right hand corner turn orange (or red?) showing you some error occur and players disconnect from server or cannot login any more.

Have to Shut down all server files and restart all of them to make it working again.

What could be the problem? dataserver, game server or database??

[cool110]

UPDATE Character
SET Experience = 0,PkCount = 0,PkLevel = 0,PlTime = 0
from character join memb_stat ON Character.AccountID =
MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (character.Experience < 0) and (character.PkCount < 0) and (character.character.PkLevel < 0) and (character.PkTime < 0) and (memb_stat.ConnectStat = 0)


======== try it if wrong try put more __ in memb__stat

[bextbox]

Thanks. I will sure try it later.

[bextbox]

Cool110,

Test the script = good but no change in Expeprience, PkCount etc. They are still negative :(

I even changed condition to make sure any one conditions fullfilled to change the negative but still nothing. Pls help

My amended script:

UPDATE Character
SET Experience = 0,PkCount = 0,PkLevel = 3,PkTime = 0
from character join memb_stat ON Character.AccountID =
MEMB_STAT.memb___id
COLLATE SQL_Latin1_General_CP1_CI_AS
WHERE (character.Experience < 0) or (character.PkCount < 0) or (character.PkTime < 0) or (memb_stat.ConnectStat = 0)

Nothing also, what is going on? I am using MSSQL2005 Developer Edition, Windows 2003 Server.

[bextbox]

Forgot to mention, the script shows error on :

MEMB_STAT.memb___id and
memb_stat

if I connect the script to MuOnline and test it. No error if I use Me_MuOnline. But the negative bugs are found in MuOnline and not in Me_MuOnline.

Any helpful suggestion to make the script worked or any solution to fix the negative figures without using the script?

My database is supposed to be MD5? Could it be the possible source of error? My MU version is supposed to be 1.03N but buggy.

[Hidemitsu]

wow none got it?=\

[bextbox]

Ya, all good programmers are having holiday :(