Printable View
Btw, I checked the action flow of of this Adv scroll, it's similar to KaRa's reset stat scroll, which has TypeID4 "14" (rent item), and it runs AddTimedJob SP after the scroll is used.
I also found this video, it has TypeID4 "13" (reset item), and it resets everything without requiring the char to teleports:
http://www.youtube.com/watch?v=Cz23tQXa8ms
Just wondering...
ok, this is how is working for me
at _AddLogItem
id 60454 is simply a copy of beginer teleport scroll with diferent name and idPHP Code:if @ItemRefID = '60454' and @Operation ='41' -- scrolls de cosas
BEGIN
your code here
END
41 is when is activated, if you dont use that, it simply activate proc when you buy or pick up the scroll
ya it works :)
means can create scroll with "all function" :D
yup, only limit is your sql knowlege
Perfect! this method it works, however, should've put the new scroll as TypeID of "return scroll", not sure how to make TypeID "reset item" or "premium service", or even "expendables" to be able to teleport the character automatically.
And also, if we use TypeID of "return scroll", we won't need the _RefSkill line.
I'll also try another method
Another note, if we use Evangelion, we should set "disableLog = 0" in misc.ini and restart the gameserver
---
Alright here's my test video.
This using TypeID3 = 3 and TypeID4 = 1 (return scroll sort of item) conjunction with _AddLogItem SP, without [USU1:SKILL_MALL_ADV_REMOVAL] skill parameter. (didn't add anything to _AddTimedJob SP also)
http://www.youtube.com/watch?v=xxlCxICYTsA
Hope we can find a way to make the item type other than "return scroll" ;)
cheers ;)
Bro i try to add your cod,s In my LogItem
if @ItemRefID = '60454' and @Operation ='41' -- scrolls de cosas
BEGIN
your code here
END
but give me somthing worng ?
60454 is the id of MY item, put the id of YOUR item
@Caosfox about ur idee its not possible Return Scrolls are not logged in the ItemLog :/ rly bad
It's logged. And one of the way to make the effect occurs instantly is to set the item as "Return scroll", watch my video post, it works perfectly. I also mentioned that if you use Evangelion SR_GameServer, you should set "disableLog = 0" in misc.ini and restart the gameserver.Quote:
Originally Posted by InPanic Kev
Good luck, and if you done with it, let us discuss about how to make the item type OTHER THAN return scroll, because I tried to make it as "reset item", and even "expendables", and I always have to teleport the char after using the scroll. (Kinda annoying)
FYI, these are my settings: (Return scroll type like in the video)
_RefObjCommon
_RefObjItemCode:1 46012 ITEM_MALL_ADV_REMOVAL ???? ???? ??? (???) xxx SN_ITEM_MALL_ADV_REMOVAL SN_ITEM_MALL_ADV_REMOVAL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 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 item\etc\advdown.ddj xxx xxx 46012
Stored Procedure: [SRO_VT_LOG].[dbo].[_AddLogItem]Code:46012 1 2 0 0 3 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 1500 ???? 1 ?????? -1 RESURRECT -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
itemdata_45000.txtCode:IF (@Operation = 41) -- scroll is used
BEGIN
IF (@ItemRefID = 46012) -- Adv removal
BEGIN
DELETE FROM [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] where nItemDBID IN (SELECT ItemID FROM [SRO_VT_SHARD].[dbo].[_Inventory] WHERE Slot BETWEEN 0 AND 12 AND CharID = @CharID) and bOptType = 2
END
END
textdata_object.txtCode:1 46012 ITEM_MALL_ADV_REMOVAL ???? ???? ??? (???) xxx SN_ITEM_MALL_ADV_REMOVAL SN_ITEM_MALL_ADV_REMOVAL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 0 3 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 item\etc\advdown.ddj xxx xxx 1 2 0 0 3 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 1500 ???? 1 ?????? -1 RESURRECT -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
Code:1 SN_ITEM_MALL_ADV_REMOVAL Adv removal scroll
1 SN_ITEM_MALL_ADV_REMOVAL_TT_DESC <sml2>Remove Adv effect on items.<br><br><strong><font color="255,236,219,156">WARNING!</font></strong><br>This will remove Adv effects from ALL equipped items and teleports you back to town.<br><br></sml2>
cheers ;)
Quote:
Originally Posted by witchymoo
Nice Bro :) Keep it up
greatQuote:
Originally Posted by witchymoo
mean this is will use it like scroll and will teleport u after open it right ?
Exactly, once you understand how it works you can easily make other scrolls based on this "return scroll". I made several multi-purposed scrolls based on this, and it's a lot easier since you don't need to add skills, effects, whatsoever.Quote:
Originally Posted by thebigbody
Though I'm still wondering how to make the REAL reset scroll works, I tried once but when i right-click on it nothing happens.
lol when i use it
no DC no teleport nothing happen
only effect and then nothing
this is my Procedure
Quote:
if(@JobID= '59669') -- Remover ADV Ticket added by krmfrnc
begin
DELETE FROM _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory WHERE Slot = 1 AND CharID=@CharID) and bOptType=2
return -3
end
Quote:
Originally Posted by Witchy Moo
About
IF (@Operation = 41) -- scroll is used
BEGIN
IF (@ItemRefID = 46012) -- Adv removal
41= what ?
ItemRedID= what ? objitem ID Common id ?
:glare::stupido3: I think, the words next to it already explains what it is. It is it not?Quote:
Originally Posted by bestprem
This works like wonders on br files. ^.^Quote:
Originally Posted by Witchy Moo
didn't work anyway with me :DQuote:
Originally Posted by Witchy Moo