Thumbs up Thief Horse In Town Where Fix

[denise456]

hey guys i need one help for get dc in player using job and horse in city

Thief Horse In Town Where Fix

[Dr.Abdelfattah]

Hello denise,

Well u have 1 way to do that, a query linked with logdb,
then a simple explain :
1 - if ()
2- a player wear thief suit and summon thief vehicle (hourse, camel or whatelse);
2 - is in region of (towns ..);
3 - Do a return -
/*-- Link this query with log db and use the operation of opening NPC or teleport .. (or even all operations) > the operation of logdb
4 - don't forgot while writing ur query to write the table name like that sharddbname.dbo.tablename (to make logdb connect to sharddb while executing the log)
u may also make the query execute before teleporting or casting a return scroll ..

At last , if(){return}; make a dc , then under return make a query which dismount the camel and delete all goods with it..

So the query will do : anyone will try to enter the town with camel while wearing a thief cap , DC and unsummon the camel and no goods ..

Sorry, i can't write such a query will take much time , hope i explained good

Good luck

[denise456]

u say This

--THİEFTOWNBUG DC--    if (@Operation = 114 and @targetStorage = 2 and @slot_From = 255)
  begin
    declare @isbattle tinyint
    declare @jobtype int
    select @isbattle = IsBattleField from SRO_VT_SHARD.dbo._RefRegion where wRegionID = (Select LatestRegion from SRO_VT_SHARD.dbo._Char where CharID = @charID)
    select @jobtype = jobtype from SRO_VT_SHARD.dbo._CharTrijob where CharID = @charID
    if(@isbattle = 0 and @jobtype = 2)
    begin
    Declare @cosID int = (select ID from SRO_VT_SHARD.dbo._CharCOS where OwnerCharID = @charID)    
    Delete from SRO_VT_SHARD.dbo._InvCOS where COSID = @cosID
    Delete from SRO_VT_SHARD.dbo._CharCOS  where 
    OwnerCharID = @charID and RefCharID between '2187' and '2189'
    or OwnerCharID = @charID and RefCharID between '3915' and '3917'
    or OwnerCharID = @charID and RefCharID between '3912' and '3914'
    or OwnerCharID = @charID and RefCharID between '2184' and '2186'
    or OwnerCharID = @charID and RefCharID between '23250' and '23257'
    or OwnerCharID = @charID and RefCharID between '23258' and '23265'
    or OwnerCharID = @charID and RefCharID between '23905' and '23912'
    end
    end

[Dr.Abdelfattah]

something like that,
But why u write it like this :

OwnerCharID = @charID and RefCharID between '2187' and '2189'     or OwnerCharID = @charID and RefCharID between '3915' and '3917'     or OwnerCharID = @charID and RefCharID between '3912' and '3914'     or OwnerCharID = @charID and RefCharID between '2184' and '2186'     or OwnerCharID = @charID and RefCharID between '23250' and '23257'     or OwnerCharID = @charID and RefCharID between '23258' and '23265'     or OwnerCharID = @charID and RefCharID between '23905' and '23912'

?!
Also if i were u , i would make much check points as well (like making more checks on more operations and so on) ..

[​Exo]

Syloxx has released something for that. Check his releases.

[tschulian]

Originally Posted by ​Exo

Syloxx has released something for that. Check his releases.

It doesnt work smooth.

Originally Posted by denise456

Delete from SRO_VT_SHARD.dbo._InvCOS where COSID = @cosID

Note: This will delete items from your pickpet if your pet picks smth in the Town.