Jobs command

[RappelzFenix]

Hi,

i've search the jobs code but i dont find it.

You can help me?

[Raskim2000]

Originally Posted by RappelzFenix

Hi,

i've search the jobs code but i dont find it.

You can help me?

use arcadia
select* from stringresource 
where value like '%Search_Here%'

[Xijezu]

Database?
AdCon 4.x ?

Edit:
Raskim was faster, postet a sql-script, better answer then mine.

I was thinking about writing this command, too, but was working otherwise. ;D

Edit 2:

USE Arcadia
SELECT id, StringResource.value
FROM JobResource
LEFT JOIN StringResource ON StringResource.code = text_id
WHERE
StringResource.code = text_id

Graah, I have Join's. But It is working, LOL.

Edit: damnt, wait a sec, wrong command...

Last Edit: Finally!
There is it.

[RappelzFenix]

no guys im not sql admin i search codes on web

[Raskim2000]

Originally Posted by RappelzFenix

no guys im not sql admin i search codes on web

Your`e a GM on a Server without an own TestServer on your Computer? ... i have no word`s for this...

I don`t know why, but i will give you the Job Id`s in some min here...

[Xijezu]

id value
100 Rogue
101 Fighter
102 Kahuna
103 Spell Singer
110 Champion
111 Archer
112 Druid
113 Battle Kahuna
114 Evoker
120 Berserker
121 Master Archer
122 High Druid
123 Great Kahuna
124 Beast Master
200 Guide
201 Holy Warrior
202 Cleric
203 Breeder
210 Knight
211 Soldier
212 Bishop
213 Priest
214 Soul Breeder
220 Crusader
221 Blader
222 Arch Bishop
223 High Priest
224 Master Breeder
300 Stepper
301 Strider
302 Dark Magician
303 Sorcerer
310 Assassin
311 Shadow Hunter
312 Chaos Magician
313 Warlock
314 Battle Summoner
320 Slayer
321 Night Stalker
322 Lich
323 Fiend
324 Necromancer

Just because I didn't closed the SQL-Command.

[RappelzFenix]

im only gm raskim ^^
we're two ahah

thanks xijezu