Jobs command

11/17/2011 20:16 RappelzFenix#1

Hi,

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

You can help me?

11/17/2011 20:19 Raskim2000#2

Quote:

Originally Posted by RappelzFenix

Hi,

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

You can help me?

Code:

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

11/17/2011 20:19 Xijezu#3

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:

Quote:

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.

11/17/2011 20:21 RappelzFenix#4

no guys im not sql admin :D i search codes on web :D

11/17/2011 20:24 Raskim2000#5

Quote:

Originally Posted by RappelzFenix

no guys im not sql admin :D i search codes on web :D

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...

11/17/2011 20:31 Xijezu#6

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.

11/17/2011 20:32 RappelzFenix#7

im only gm raskim ^^
we're two ahah

thanks xijezu :)