Remover Adv Scroll

[denise456]

https://mega.co.nz/#!RUMnQaZQ!Uw7OKz...V00JOv5wuMCO0Q



Credits Goes krmfrnc

[MentaL]

[Crue]

good Job

[ongamanext]

very good

[InPanic Kev]

This Item remove all Adv Elix from all Items !! ;)

/_AddTimedJob (Procedure)
-----------------------------
		---------designed by krmfrnc--------------
        if(@JobID= '36873') -- Remover ADV Ticket added by krmfrnc
		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
		---------designed by krmfrnc--------------

i prefer my MSG System to Remove Adv from Slot1 :)

[karemsame]

how i make it Remove only one item ?

[fuddreckers2]

how i make it Remove only one item ?

yea me2

[BadFist]

how i make it Remove only one item ?

so hard woww

WHERE Slot BETWEEN 0 AND 12 replace WHERE Slot = 1 or WHERE Slot 1
use your brain...

[karemsame]

i think for make it work for one item, need to make 12 Scroll :( and edit slot Number

@BadFist
i think you need Use Your brain not me, i mean Make it like alchmy or like Repair one item.

[BadFist]

if you want to work like alchemy them call joymax and say to them to make this :) you can't make like alchemy bcz gameserver dont know what to do with item and for theat we make with time job bcz you dont know in game are scroll who "rename char/ remove skill" but dont work bcz gs dont know what to make with item...


L.E you can make only 1 scroll for all item if you have a brain. is eazy...

[krmfrnc]

https://www.virustotal.com/tr/file/6...is/1384365261/

how i make it Remove only one item ?

change slot numbers

[Witchy Moo]

Hello

thanks for this awesome item... it works great, but I always got dc after using the scroll, is that normal?

If there are items with Adv, no query error in GS log, just this (when dc):

AQ Failed! Log out!! [AQType: 10]

But if there are no items with Adv, got dc also, with additional error:

DB Query Error(100): {?=CALL _ADDTIMEDJOB (56,0,33821,1384462398,0,1,0,0,0,0,0,0,100000000003584,0)}
AQ Failed! Log out!! [AQType: 10]

thank you

[Crue]

Hello

thanks for this awesome item... it works great, but I always got dc after using the scroll, is that normal?

If there are items with Adv, no query error in GS log, just this (when dc):

AQ Failed! Log out!! [AQType: 10]

But if there are no items with Adv, got dc also, with additional error:

DB Query Error(100): {?=CALL _ADDTIMEDJOB (56,0,33821,1384462398,0,1,0,0,0,0,0,0,100000000003584,0)}
AQ Failed! Log out!! [AQType: 10]

thank you

if you don't want get dc

just remove return -3

[Witchy Moo]

if you don't want get dc

just remove return -3

I did, still got dc

[InPanic Kev]

so hard woww

WHERE Slot BETWEEN 0 AND 12 replace WHERE Slot = 1 or WHERE Slot 1
use your brain...

some dont have

import Brain.Service;

bzw better use some method like me :

[Guild Reset / Job Reset / Adv Remove / Premium Remove / Change Name ]
+ Upgrade Items 11 -> 12 and much more i think some know how to get it working.

YouTube Video about the System :

[Isoline]

acutally, made it automatically that it will teleport the char on a real-time base after execution is completed.