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.

[InPanic Kev]

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

[Witchy Moo]

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

[Caosfox]

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

[InPanic Kev]

@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

[Caosfox]

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

[InPanic Kev]

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

[Caosfox]

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)

[BadFist]

can you share?

[Witchy Moo]

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

[karemsame]

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

+1 me too need know.