Code:
Update c set
class=65
FROM Character c
left JOIN MEMB_STAT m ON c.AccountID = m.memb___id
COLLATE Latin1_general_CI_AI
WHERE c.cLevel>=400 and m.ConnectStat = 0 AND c.Class=64
Update c set
class=34
FROM Character c
left JOIN MEMB_STAT m ON c.AccountID = m.memb___id
COLLATE Latin1_general_CI_AI
WHERE c.cLevel>=400 and m.ConnectStat = 0 AND c.Class=33
Update c set
class=49
FROM Character c
left JOIN MEMB_STAT m ON c.AccountID = m.memb___id
COLLATE Latin1_general_CI_AI
WHERE c.cLevel>=400 and m.ConnectStat = 0 AND c.Class=48
Update c set
class=2
FROM Character c
left JOIN MEMB_STAT m ON c.AccountID = m.memb___id
COLLATE Latin1_general_CI_AI
WHERE c.cLevel>=400 and m.ConnectStat = 0 AND c.Class=1
Update c set
class=18
FROM Character c
left JOIN MEMB_STAT m ON c.AccountID = m.memb___id
COLLATE Latin1_general_CI_AI
WHERE c.cLevel>=400 and m.ConnectStat = 0 AND c.Class=17
INSTRUCTION:
1)Create SQL JOB With This Script
2)Turn ON Sql Agent
Info :
Warning This Script Work 100% on MuServer By Luciano Aibar 39 Beta
And Scipt Coded For Help To Luciano Aibar
P.S: Need 400 Level
After Reach 400 Level Need to Quit Game
If All correct in the JOB
Class Will Be Changed
Credits Go To
CaHeK [Devil TeaM] [ME]
Delfin_ [Devil TeaM]
Fixes of Errors by Shared NooB [BoR TeaM] Fixes of Errors
:bash: WARNING! Dont use if u have not coded s3 class On GameServer.exe or noone will be able to login :bash:
Last edited: