Job Types

04/12/2013 12:43 LastThief*#1

At _CharTriJob on shard database there is 3 jobs types 1 , 2 , 3 which one is trader , hunter and thief ?

Thanks,
Jean

04/12/2013 12:54 PortalDark#2

only way, without knowing, is to test them
idk, never examined that table

04/12/2013 12:56 鳳凰城#3

1= Trader
2= Hunter
3= Thief

You can check em by creating any character and, join any job and, you can check the value @SMC.
By the way, Portal, You lost your job.. It's wrong section anyway :awesome:.

04/12/2013 12:58 PortalDark#4

#moved to correct section

04/12/2013 12:59 IceAmStiel#5

1 Trader
2 Thief
3 Hunter..

04/12/2013 13:04 Kape7#6

1 Hunter
2 Thief
3 Trader

We are here playing the lotto right?

04/12/2013 14:18 LastThief*#7

Thanks :)

04/12/2013 14:19 鳳凰城#8

Y.W Anytime. :)

04/12/2013 14:43 IceAmStiel#9

Code:

SELECT TOP 1 CodeName128, TypeID4 FROM dbo._RefObjCommon WHERE TypeID1 = 3 AND TypeID2 = 1 AND TypeID3 = 7 AND TypeID4 = 1 UNION ALL
SELECT TOP 1 CodeName128, TypeID4 FROM dbo._RefObjCommon WHERE TypeID1 = 3 AND TypeID2 = 1 AND TypeID3 = 7 AND TypeID4 = 2 UNION ALL
SELECT TOP 1 CodeName128, TypeID4 FROM dbo._RefObjCommon WHERE TypeID1 = 3 AND TypeID2 = 1 AND TypeID3 = 7 AND TypeID4 = 3;

[Only registered and activated users can see links. Click Here To Register...]

Ding ding ding, Caipi won the million!

04/12/2013 14:45 鳳凰城#10

Quote:

Originally Posted by IceAmStiel

Code:

SELECT TOP 1 CodeName128, TypeID4 FROM dbo._RefObjCommon WHERE TypeID1 = 3 AND TypeID2 = 1 AND TypeID3 = 7 AND TypeID4 = 1 UNION ALL
SELECT TOP 1 CodeName128, TypeID4 FROM dbo._RefObjCommon WHERE TypeID1 = 3 AND TypeID2 = 1 AND TypeID3 = 7 AND TypeID4 = 2 UNION ALL
SELECT TOP 1 CodeName128, TypeID4 FROM dbo._RefObjCommon WHERE TypeID1 = 3 AND TypeID2 = 1 AND TypeID3 = 7 AND TypeID4 = 3;

[Only registered and activated users can see links. Click Here To Register...]

Ding ding ding, Caipi won the million!

Thats right, But, Did you looked towards smc ? I had saw it like I wrote up there at once. Maybe the database I had was just fucked up.

Anyway, thanks for the query :p

04/12/2013 14:46 IceAmStiel#11

Quote:

Originally Posted by Phoenix 1337

Thats right, But, Did you looked towards smc ? I had saw it like I wrote up there at once. Maybe the database I had was just fucked up.

Anyway, thanks for the query :p

Caipi doesn't use SMC!

04/18/2013 02:43 AllEyezOnMe-#12

Hunter
Thief
Trader