SQL Scipt For Auto Change Class To Season 3 Class[For Luciano.A. Release]

[alex26]

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:

[MentaL]

[jorkay_adm]

Very Nice ... 10/10

[SHANG]

dont use if u have not coded s3 class or noone will be able to login :D

[alex26]

Very Nice ... 10/10

THX

[Netzo]

nice :D

[z0lik]

Nice .... "MOLDOVA RULLEZ" Fantasy BOT ninja:

[DestructiO]

good job 10/10

[alex26]

Nice .... "MOLDOVA RULLEZ" Fantasy BOT ninja:

Man On Devil TeaM No Exist Fantasy
We Have Fantazy

[URun]

65 and 49 ? omg! for what server files? original 3rd classes is 66 and 50 =(! In Endi files it's bug.

[alex26]

65 and 49 ? omg! for what server files? original 3rd classes is 66 and 50 =(! In Endi files it's bug.

Read First Post

This Release Only For Luciano Aibar Server Files

[URun]

/evo command not usefull?

[alex26]

/evo command not usefull?

[ENG]
This Is Idea Of Luciano Aibar
Character Automatic Transform From Level 400
This Script For Luciano Next Release
Luciano Have Good Idea For This

[Rus] Чувак Я Не Просто Так Это Делал Это Идея Лусиано Скоро Он Сделает Сервер с автоматической системой используя этот скрипт и у него хорошая идея по этой системе чтоб скажем при трансформе давали вещи

[UnKn]

good thx man =) 10/10

[cstnandrei]

10/10

[vova]

8.5/10 not very useful ...
i think /evo better!

but nice !!! and moldova not rullzzz!!!!! russia rullz!!!

[URun]

vova - no flame please:) I too don't know for what this script=)
alex26:
auto transform already implemented.
[Ru]
СаНеК - лучано не не настолько глуп, чтобы ему нужна была команда, которую он уже реализовал. а выдачу шмота лучше делать через сайт, ибо в игре судя по тому как ТЫ составил скрипт это сделать не выйдет.
ЗЫ: выслуживаться я ни перед кем не собираюсь, и просто слежу за движением на РЗ. нафлудил уже за своё время.

[SHANG]

9.9/10 it is useful, but only for coded GS'S :D

and.. Bulgaria RullZ!!! :P

[razorrrr]

thanks bro
luciano will be continue his release?

[HuseltAddelve]

[jlroco33]

[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

thx, good job, but i thing it

[Fantazy-MD]

Nice .... "MOLDOVA RULLEZ" Fantasy BOT ninja:

Yea Moldova Rulez z0lik=>:2up: :moon1::throw:

[Lisko]

gj 9/10

[dnmasterza]

i want scipt auto change class s3 Summonner

[laklakbangi]

SUPER BUMB THREAD!

Pls Read Rules First Before posting!

[andrelis34]

Fantastyc job. Thank you very Much :)