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.

Real Time is the best way ;) ( like AddSilk )
by me it was just a bit "Testing" whats possible :P

Quote:

---

Originally Posted by Isoline

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

---

This is actually an excellent idea, like combining this Adv removal scroll with return scroll, rather than make the char auto dc. I hope it's possible

Quote:

---

Originally Posted by witchymoo

This is actually an excellent idea, like combining this Adv removal scroll with return scroll, rather than make the char auto dc. I hope it's possible

---

it is possible (im not going to make a proc because my sql sucks)
but one of the tables in log db "record" when you use a item/or pick up a item
if you use a teleport scroll, it record the itemid and dome data1, data2, etc
simply create a new tele scroll, and get the procedure filter for that itemid, then the rest is easy

@Caosfox

Thats a rly good idee ;) i write a proc soon hehe

if u got more let me know ^^


edit : maybe its not good becuse the log is creating after use ( so if u teleport fast ) its unless i think i will try if i got time

use the slow basic teleport, it takes like 5 seconds to teleport (the most lame basic teleport, i think is beginner teleport)

and the log creates 2 values if im not wrong, when is clicked (used) and when the teleport is done

ok i check ur idee soon if it works i send to ya ;)

yup is working, i did a quick and dirty code (i know you can do a 1000000x times faster and better, mainly is like the old timejob codes but on diferent db)

can you share?

What's the SP or event trigger to handle return scroll? perhaps I might look there

Quote:

---

Originally Posted by witchymoo

What's the SP or event trigger to handle return scroll? perhaps I might look there

---

+1 me too need know.