Remove premium scroll

[Hamza FiGo]

I made the scroll and worked. But som times worked and remove the prem with the Expert package service and some times no. Just remove the prem and leave this Expert hand ON.



Whats wrong ?

[​Exo]

Show the lines

[Hamza FiGo]

skilldata_enc

1	59704	1013	SKILL_MALL_PREMIUM_REMOVE	???? ????	SKILL_MALL_PREMIUM_REMOVE	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_PKREMOVER	***	SN_SKILL_MALL_PKREMOVER_TT_DESC	***	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

itemdata_xxx

1	70006	ITEM_MALL_PREMIUM_REMOVE	???? ???? ??? (???)	***	SN_ITEM_MALL_PREMIUM_REMOVE	SN_ITEM_MALL_PREMIUM_REMOVE_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	***	item\etc\drop_mall_scroll.bsr	item\etc\event_ghost_bottle.ddj	***	***	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_PREMIUM_REMOVE]                                                                                                 	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	0	0

It can be from the procedure ?

[Crue*]

sure it's from procedure lel

[Hamza FiGo]

Originally Posted by Crue*

sure it's from procedure lel

if
(@JobID= '59704')
		 BEGIN 
        DECLARE @CharName16 Varchar (MAX) 
     Select @CharName16=CharName16 from _Char where CharID = @CharID 
      Begin
     DELETE FROM _TimedJob WHERE Data2 between  1 AND 11000 AND CharID = @CharID 

   	end
   	end

[Anonymous-6723]

Originally Posted by hamzafigo

if
(@JobID= '59704')
		 BEGIN 
        DECLARE @CharName16 Varchar (MAX) 
     Select @CharName16=CharName16 from _Char where CharID = @CharID 
      Begin
     DELETE FROM _TimedJob WHERE Data2 between  1 AND 11000 AND CharID = @CharID 

   	end
   	end

The answer is right BETWEEN 1 AND 11 000

[Hamza FiGo]

So what is wrong with it ?

[​Exo]

Okay use this to select the Data2 of the expert thing.

PHP Code:

SELECT DATA2 FTOM _TimedJob WHERE CharID = 'whatever' 


now you get the required number simply add it to the other query.

[Hamza FiGo]

Originally Posted by xExorcist

Okay use this to select the Data2 of the expert thing.

PHP Code:

SELECT DATA2 FTOM _TimedJob WHERE CharID = 'whatever' 


now you get the required number simply add it to the other query.

You mean it`ll be like that?

if
(@JobID= '59704')
		 BEGIN 
        DECLARE @CharName16 Varchar (MAX) 
     Select @CharName16=CharName16 from _Char where CharID = @CharID 
      Begin
     DELETE FROM _TimedJob WHERE Data2 between  1 AND 11000 AND CharID = @CharID 
SELECT DATA2 FROM _TimedJob WHERE CharID = 'whatever'
   	end
   	end

Event tried this and didn`t work.

if
(@JobID= '59704')
		 BEGIN 
        DECLARE @CharName16 Varchar (MAX) 
     Select @CharName16=CharName16 from _Char where CharID = @CharID 
      Begin
     DELETE DATA2 FROM _TimedJob WHERE CharID = 'whatever' 
	 
   	end
   	end

[​Exo]

-_- no I didn't mean like that just

PHP Code:

DELETE FROM _TimedJob WHERE CharID = @CharID 


-- this will work but it will remove everything, so you need to get the exact Data2.

[Hamza FiGo]

Originally Posted by xExorcist

-_- no I didn't mean like that just

PHP Code:

DELETE FROM _TimedJob WHERE CharID = @CharID 


-- this will work but it will remove everything, so you need to get the exact Data2.

Ya it removed every scroll i have. hmm. So its from 1 and 11000

Ty xExorcist for help.

Originally Posted by Crue*

do you know that
you're a piece of ****

[Anonymous-6723]

Gosh for real ? Find the item you are using, select Link from _refobjcommon where codename128 like '%CODENAME OF ITEM HERE%' get the link =>

SELECT * FROM _refobjitem where ID = LINKHERE

go to the right and find the skill name used

select * from _refskill where basic_code like '%skillnamehere%'

check the SkillID and in your procedure add
delete from _TimedJob where CharID = @CharID and JobID = SkillIDHERE

that should do it..

Since you placed the query as was given the one ending with 'whatever'.. Where you see the word HERE in the queries.. you have to edit by yourself. Have pHun

[Syloxx]

Originally Posted by xExorcist

Okay use this to select the Data2 of the expert thing.

PHP Code:

SELECT DATA2 FTOM _TimedJob WHERE CharID = 'whatever' 


now you get the required number simply add it to the other query.

Syntax Error :P

[​Exo]

Originally Posted by Syloxx

Syntax Error :P

Crawl back, not feeling like arguing today, you should know why, so shutap..

[Hamza FiGo]

Originally Posted by Zed*

Gosh for real ? Find the item you are using, select Link from _refobjcommon where codename128 like '%CODENAME OF ITEM HERE%' get the link =>

SELECT * FROM _refobjitem where ID = LINKHERE

go to the right and find the skill name used

select * from _refskill where basic_code like '%skillnamehere%'

check the SkillID and in your procedure add
delete from _TimedJob where CharID = @CharID and JobID = SkillIDHERE

that should do it..

Since you placed the query as was given the one ending with 'whatever'.. Where you see the word HERE in the queries.. you have to edit by yourself. Have pHun

Ah ty for the hint.