Enabling Mercenaries

[silkroadnet]

Hello everybody
I hope everyone know mean of mercenaries.
There is already mercenaries on guild NPCs.But there appear a problem;
You are not allowed to use items.

I made some tries on TypeID3 and TypeID4 but fail

RefObjCommon Select Code for mercenaries

SELECT     Service, ID, CodeName128, ObjName128, OrgObjCodeName128, NameStrID128, DescStrID128, CashItem, Bionic, TypeID1, TypeID2, TypeID3, TypeID4, DecayTime, 
                      Country, Rarity, CanTrade, CanSell, CanBuy, CanBorrow, CanDrop, CanPick, CanRepair, CanRevive, CanUse, CanThrow, Price, CostRepair, CostRevive, CostBorrow, 
                      KeepingFee, SellPrice, ReqLevelType1, ReqLevel1, ReqLevelType2, ReqLevel2, ReqLevelType3, ReqLevel3, ReqLevelType4, ReqLevel4, MaxContain, RegionID, Dir, 
                      OffsetX, OffsetY, OffsetZ, Speed1, Speed2, Scale, BCHeight, BCRadius, EventID, AssocFileObj128, AssocFileDrop128, AssocFileIcon128, AssocFile1_128, 
                      AssocFile2_128, Link
FROM         _RefObjCommon
WHERE     (CodeName128 LIKE 'ITEM_ETC_GUILD_%SOLDIER%')

[MentaL]

[saxz]

Hello everybody
I hope everyone know mean of mercenaries.
There is already mercenaries on guild NPCs.But there appear a problem;
You are not allowed to use items.

I made some tries on TypeID3 and TypeID4 but fail

RefObjCommon Select Code for mercenaries

SELECT     Service, ID, CodeName128, ObjName128, OrgObjCodeName128, NameStrID128, DescStrID128, CashItem, Bionic, TypeID1, TypeID2, TypeID3, TypeID4, DecayTime, 
                      Country, Rarity, CanTrade, CanSell, CanBuy, CanBorrow, CanDrop, CanPick, CanRepair, CanRevive, CanUse, CanThrow, Price, CostRepair, CostRevive, CostBorrow, 
                      KeepingFee, SellPrice, ReqLevelType1, ReqLevel1, ReqLevelType2, ReqLevel2, ReqLevelType3, ReqLevel3, ReqLevelType4, ReqLevel4, MaxContain, RegionID, Dir, 
                      OffsetX, OffsetY, OffsetZ, Speed1, Speed2, Scale, BCHeight, BCRadius, EventID, AssocFileObj128, AssocFileDrop128, AssocFileIcon128, AssocFile1_128, 
                      AssocFile2_128, Link
FROM         _RefObjCommon
WHERE     (CodeName128 LIKE 'ITEM_ETC_GUILD_%SOLDIER%')

what you mean?
what's the problem with them?
when use them the client crash or something?

[stemale]

If im not wrong for example zszc \wsro have them and the db + server files is released
So why dont take them from their db?

[silkroadnet]

If im not wrong for example zszc \wsro have them and the db + server files is released
So why dont take them from their db?

Don't need database.I think i need itemdata.txt files only from server with these mercenaries.
But idk which servers have them

[stemale]

Don't need database.I think i need itemdata.txt files only from server with these mercenaries.
But idk which servers have them

Like u can enable in ObjCommon new Premium but u cant use it..i didnt test it but i think u need enable in RefSkill cuz i saw Premium skill in this table. So i think u should enable them in RefSkill and try to use

[TryToMakeServer]

Your guild lvl 4?
CanUse = 1 ?

[silkroadnet]

Your guild lvl 4?
CanUse = 1 ?

Yes they are.

And there isnt anything about mercenaries in _RefSkill

[TryToMakeServer]

_RefObjCommon
Look there if CanUse = 1

[Larkon]

Yeah that same issues happens here. I dont think their enabled.

[Caipi]

Why don't you look at other items/mobs with ~ the same properties. Probably there's something really necessary missing at the DB.
Like Taese or Hang-A scrolls+mobs. Can also only be used by the Guild leader, are working and are also "mobs" :)

Just to mention it..

SELECT * FROM _RefObjCommon
WHERE CodeName128 like 'ITEM_ETC_GUILD_%SOLDIER%' 

Would work too ;D

[enis1994]

caipi this is query ?
SELECT * FROM _RefObjCommon
WHERE CodeName128 like 'ITEM_ETC_GUILD_%SOLDIER%'

[Caipi]

I just shows every row which contains "ITEM_ETC_GUILD_...SOLDIER..." at CodeName128 - results in the same what silkroadnet already made, nothing more.

[silkroadnet]

I just shows every row which contains "ITEM_ETC_GUILD_...SOLDIER..." at CodeName128 - results in the same what silkroadnet already made, nothing more.

I tried a lot thing.But there is nothing

[vista1]

bro very hard enable..

[fabien31]

Maybe the problem it's not on DB :P
Cause everything is fine into DB so maybe a problem whit media.pk2 or sro_client didn't search it !