Remover Adv Scroll

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

http://u1311.hizliresim.com/1h/g/ujf0c.jpg

Credits Goes krmfrnc

good Job

very good

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

Code:

---

/_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 :)

how i make it Remove only one item ?

Quote:

---

Originally Posted by karemsame

how i make it Remove only one item ?

---

yea me2

Quote:

---

Originally Posted by karemsame

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

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.

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

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

Quote:

---

Originally Posted by karemsame

how i make it Remove only one item ?

---

change slot numbers

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):

Code:

---

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

---

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

Code:

---

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

Quote:

---

Originally Posted by witchymoo

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):

Code:

---

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

---

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

Code:

---

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

Quote:

---

Originally Posted by Crue

if you don't want get dc

just remove return -3

---

I did, still got dc

Quote:

---

Originally Posted by BadFist

so hard woww

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

---

some dont have :laugh:

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 :
http://www.youtube.com/watch?v=Xxe590vDOaA

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