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

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:

Very Nice ... 10/10:kiss:

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

Quote:

---

Originally Posted by jorkay_adm

Very Nice ... 10/10:kiss:

---

THX

nice :D

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

good job 10/10

Quote:

---

Originally Posted by z0lik

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

---

Man On Devil TeaM No Exist Fantasy
We Have Fantazy

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

Quote:

---

Originally Posted by URun

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

/evo command not usefull?

Quote:

---

Originally Posted by URun

/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] Чувак Я Не Просто Так Это Делал Это Идея Лусиано Скоро Он Сделает Сервер с автоматической системой используя этот скрипт и у него хорошая идея по этой системе чтоб скажем при трансформе давали вещи

good thx man =) 10/10

10/10

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

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

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

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

and.. Bulgaria RullZ!!! :P

thanks bro
luciano will be continue his release?

Quote:

---

Originally Posted by alex26

[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

Quote:

---

Originally Posted by z0lik

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

---

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

gj 9/10

i want scipt auto change class s3 Summonner

SUPER BUMB THREAD!

Pls Read Rules First Before posting!

Fantastyc job. Thank you very Much :)