Job Types

[LastThief*]

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

Thanks,
Jean

[PortalDark]

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

[鳳凰城]

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 .

[PortalDark]

#moved to correct section

[IceAmStiel]

1 Trader
2 Thief
3 Hunter..

[Kape7]

1 Hunter
2 Thief
3 Trader

We are here playing the lotto right?

[LastThief*]

Thanks

[鳳凰城]

Y.W Anytime.

[IceAmStiel]

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;

Ding ding ding, Caipi won the million!

[鳳凰城]

Originally Posted by IceAmStiel

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;

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

Anyway, thanks for the query

[IceAmStiel]

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

Anyway, thanks for the query

Caipi doesn't use SMC!

[AllEyezOnMe-]

Hunter
Thief
Trader