Can any one tell me how to add Procedure Database
ummm let's say Procedure for FGW reset.
THis Database side RefObjCommon
RefObjItem
RefSkill
Procedure
_TimedJob
Where can i add this Procedure and how add it in _TimedJob
Please someone tell me with Boring details.
Thanks for give me try to help...!
So sorry I'm Beginner at Vsro :D
All codes Copyrights: MGProjects
ummm let's say Procedure for FGW reset.
THis Database side RefObjCommon
PHP Code:
1 43600 ITEM_MALL_FW_RESET ???? ???? ??? (???) xxx SN_ITEM_MALL_FW_RESET SN_ITEM_MALL_FW_RESET_TT_DESC 1 0 3 3 13 14 180000 3 0 1 1 1 255 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 Premium\etc\mall_dungeon_free_ticket_forgotten_world.ddj xxx xxx 22000
PHP Code:
22000 1 2 0 0 1 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 1000 ????(?) 1 [USU1:SKILL_MALL_FW_RESET] -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 -1 xxx 0 0 0
PHP Code:
1 34000 1013 SKILL_MALL_FW_RESET ???? ???? SKILL_MALL_FW_RESET 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\mall_dungeon_free_ticket_forgotten_world.ddj SN_SKILL_MALL_FW_RESET xxx SN_SKILL_MALL_FW_RESET_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 3600 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
_TimedJob
PHP Code:
if(@JobID = '34000') -- forgot World remove
begin
UPDATE _TimedJob SET TimeToKeep='7', Data1='0' WHERE CharID=@CharID AND Category='12'
DELETE FROM _TimedJob WHERE CharID=@CharID AND Category='6'
return -3
end
Please someone tell me with Boring details.
Thanks for give me try to help...!
So sorry I'm Beginner at Vsro :D
All codes Copyrights: MGProjects