change job

[jm0099]

how to change job using command or sql manage

[MentaL]

[Abry]

USE [DNWorld]
UPDATE  [dbo].[Characters]
SET CharacterClassCode=0
WHERE CharacterName='name'

Change the values in red.

[jm0099]

can u give classcode of bowmaster

[Abry]

My bad, sorry, I forgot. @kennethz008 @mesak @jm0099 @nimitz90

USE [DNWorld]
UPDATE  [dbo].[Characters]
SET CharacterClassCode=0
WHERE CharacterName='name'

and make sure you also execute this

USE [DNWorld]
UPDATE  [dbo].[CharacterStatus]
SET JobCode=0
WHERE CharacterID=(SELECT CharacterID FROM  [dbo].[Characters] WHERE CharacterName='name')

Still change the red, but use these values for
CharacterClassCode

Spoiler:

1 - warrior class
2 - archer class
3 - sorceress class
4 - cleric class
5 - tinkerer class
6 - kali class

and JobCode

Spoiler:

1 - warrior
2 - archer
3 - sorceress
4 - cleric
5 - tinkerer
6 - kali

11 - swordsman
12 - mercenary
13 - avenger

14 - sharpshooter
15 - acrobat
16 - hunter

17 - elementalist
18 - mystic
19 - warlock

20 - paladin
21 - monk
22 - priest

23 - gladiator
24 - lunar knight

25 - barbarian
26 - destroyer

29 - sniper
30 - warden

31 - tempest
32 - windwalker

35 - pyromancer
36 - ice witch

37 - war mage
38 - chaos mage

41 - guardian
42 - crusader

43 - saint
44 - inquisitor
45 - exorcist

46 - engineer
47 - shooting star

48 - gear master
49 - alchemist

50 - adept
51 - physician

54 - screamer
55 - dark summoner

56 - soul eater
57 - dancer

58 - blade dancer
59 - spirit dancer

- - - Updated - - -

Another thing

USE [DNWorld]
INSERT INTO JobChangeLogs (CharacterID, JobCode, LogDate) VALUES ((SELECT CharacterID FROM  [dbo].[Characters] WHERE CharacterName='name'), 0, (SELECT convert(varchar(25), getdate(), 120)) )

Change 0 to job code.

[kennethz008]

My bad, sorry, I forgot. @kennethz008 @mesak @jm0099 @nimitz90

USE [DNWorld]
UPDATE  [dbo].[Characters]
SET CharacterClassCode=0
WHERE CharacterName='name'

and make sure you also execute this

USE [DNWorld]
UPDATE  [dbo].[CharacterStatus]
SET JobCode=0
WHERE CharacterID=(SELECT CharacterID FROM  [dbo].[Characters] WHERE CharacterName='name')

Still change the red, but use these values for
CharacterClassCode

Spoiler:

1 - warrior class
2 - archer class
3 - sorceress class
4 - cleric class
5 - tinkerer class
6 - kali class

and JobCode

Spoiler:

1 - warrior
2 - archer
3 - sorceress
4 - cleric
5 - tinkerer
6 - kali

11 - swordsman
12 - mercenary
13 - avenger

14 - sharpshooter
15 - acrobat
16 - hunter

17 - elementalist
18 - mystic
19 - warlock

20 - paladin
21 - monk
22 - priest

23 - gladiator
24 - lunar knight

25 - barbarian
26 - destroyer

29 - sniper
30 - warden

31 - tempest
32 - windwalker

35 - pyromancer
36 - ice witch

37 - war mage
38 - chaos mage

41 - guardian
42 - crusader

43 - saint
44 - inquisitor
45 - exorcist

46 - engineer
47 - shooting star

48 - gear master
49 - alchemist

50 - adept
51 - physician

54 - screamer
55 - dark summoner

56 - soul eater
57 - dancer

58 - blade dancer
59 - spirit dancer

- - - Updated - - -

Another thing

USE [DNWorld]
INSERT INTO JobChangeLogs (CharacterID, JobCode, LogDate) VALUES ((SELECT CharacterID FROM  [dbo].[Characters] WHERE CharacterName='name'), 0, (SELECT convert(varchar(25), getdate(), 120)) )

Change 0 to job code.

@Thorin i will update my thread and post the changes that you made

[mesak]

thanks for the fix sir. i wonder that's why my character change into a monster lol.