Ticket to Remove ADV from Weapon

[MGProjects]

RefObjCommon

1    43603    ITEM_MALL_ADVDOWN    ???? ???? ??? (???)    xxx    SN_ITEM_MALL_ADVDOWN    SN_ITEM_MALL_ADVDOWN_TT_DESC    1    0    3    3    13    14    180000    3    0    1    1    1    255    0    1    0    0    129    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    Premium\etc\advdown.ddj    xxx    xxx    22003 

RefObjItem

22003    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????(?)    1    [USU1:SKILL_MALL_ADVDOWN]                                                                                                            -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0 

RefSkill

1    34003    1013    SKILL_MALL_ADVDOWN    ???? ????    SKILL_MALL_ADVDOWN    0    1    1    0    0    0    0    0    1000    0    0    0    3599    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    3    0    0    255    255    0    0    0    0    0    255    255    255    255    item\etc\mall_optlevel_upgrade_scroll_1.ddj    SN_SKILL_MALL_ADVDOWN    xxx    SN_SKILL_MALL_ADVDOWN_TT_DESC    xxx    0    0    3    1667396966    1851946342    1685418593    1500    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0 

Procedure

_TimedJob

              if(@JobID = '34003') -- Adv Remover
        begin
declare @Time int

                        SELECT @ItemID=ItemID from _Inventory where CharID = @CharID AND Slot = '13'
                        insert into _RegistationPenalityADV(CharID,ItemID,Time) values(@CharID, @ItemID, '1')
                        Select @Time=Time From _RegistationPenalityADV Where CharID = @CharID AND ItemID = @ItemID
                        If @Time <=3
                         Begin
                        Update _RegistationPenalityADV Set Time = @Time +1 Where CharID = @CharID AND ItemID = @ItemID
                        DELETE FROM _BindingOptionWithItem WHERE nItemDBID = @ItemID
                        End
            return -3
        end 

[MentaL]

[lemoniscool]

from your SQL i see you remove the adv of the current equiped weapon, do you think its possible to make an item that will be used like the repair hammer? i mean you right click the scroll, the you have to right click the item you want to remove adv from? think you can do that? a scroll like that would be awesome ^^ but your idea isnt bad ..

[Showtek]

_BindingOptionWithItem, _RegistationPenalityADV tables missing :)

[Madelyn]

Testing..

[Csarmy]

Good job

[Hex1337]

Sry for this.. but its missing media lines?

and why u didnt upload a .txt? better

[Isoline]

Sry for this.. but its missing media lines?

and why u didnt upload a .txt? better

evil , db=media lines you just need to know which txt are equivalent to the db.

[Hex1337]

evil , db=media lines you just need to know which txt are equivalent to the db.

Well i guss its release..

so it should be full.
i know which txt are equivalent to the db.

[lemoniscool]

Pure3viL is right, if this is intended to be a release he should provide everything not just the concept .. like icons, media lines, database lines, full explanation on where to add what etc etc .. this isnt a real release in my opinion but anyways the item is doing its job after you added it right but still .. its always disconnecting players as i said in other threads already i dont like that and my players dont either .. use an item and be disconnected s*cks

[Hex1337]

Pure3viL is right, if this is intended to be a release he should provide everything not just the concept .. like icons, media lines, database lines, full explanation on where to add what etc etc .. this isnt a real release in my opinion but anyways the item is doing its job after you added it right but still .. its always disconnecting players as i said in other threads already i dont like that and my players dont either .. use an item and be disconnected s*cks

Ture.. but i should thnx him anyways he released good stuff.. but if it was a full release it would be amazing.

[CoderWaxy]

NuckerTube please Speak To me In Skype My name (Waxy)

[arabcart]

Thanks For Good Stuff but All Can use this Prod Will be Easy
Remove Adv From All Euip Items

if(@JobID= '38003') --Remover Blue Avatar 
		begin 
			DELETE FROM  _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory WHERE Slot BETWEEN 0 AND 12 AND CharID=@CharID)
			return -3 
		end

Not Need Table or Anything :D
Soon Remove Adv Like Switch Gender i work on it

[MaDenGo]

Thanks For Good Stuff but All Can use this Prod Will be Easy
Remove Adv From All Euip Items

if(@JobID= '38003') --Remover Blue Avatar 
		begin 
			DELETE FROM  _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory WHERE Slot BETWEEN 0 AND 12 AND CharID=@CharID)
			return -3 
		end

Not Need Table or Anything :D
Soon Remove Adv Like Switch Gender i work on it

Thank you :) going to test but better remove

             return -3 

to ignore DC , Teleporting is better xD

1# Edit : Working fine Ty but if like Repair / Switch gender scroll will be better :) waiting your Releace Arabcart

[arabcart]

i test and Work :D Work Fine and No DC :D
Oh Yeah i Get how to remove gold from Stoarge also :D
_AccountJID @ SRO_VT_SHARD

[Madelyn]

Thanks For Good Stuff but All Can use this Prod Will be Easy
Remove Adv From All Euip Items

if(@JobID= '38003') --Remover Blue Avatar 
		begin 
			DELETE FROM  _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory WHERE Slot BETWEEN 0 AND 12 AND CharID=@CharID)
			return -3 
		end

Not Need Table or Anything :D
Soon Remove Adv Like Switch Gender i work on it

But this delete all Like sockets and ADV..

I edit: (Only ADV is Removed)

if(@JobID= '38003') --Remover Blue Avatar 
		begin 
			DELETE FROM  _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory WHERE Slot BETWEEN 0 AND 12 AND CharID=@CharID) and bOptType=2
			return -3 
		end