Remove premium scroll

Page 1 of 2 1 2
12/22/2014 18:14 Hamza FiGo#1
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.

[Only registered and activated users can see links. Click Here To Register...]

Whats wrong ?
12/22/2014 18:41 ​Exo#2
Show the lines
12/22/2014 21:00 Hamza FiGo#3
skilldata_enc

Code:
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	xxx	SN_SKILL_MALL_PKREMOVER_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
itemdata_xxx

Code:
1	70006	ITEM_MALL_PREMIUM_REMOVE	???? ???? ??? (???)	xxx	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	xxx	item\etc\drop_mall_scroll.bsr	item\etc\event_ghost_bottle.ddj	xxx	xxx	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	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
It can be from the procedure ?
12/22/2014 21:15 Crue*#4
sure it's from procedure lel
12/22/2014 22:34 Hamza FiGo#5
Quote:
Originally Posted by Crue* View Post
sure it's from procedure lel
Code:
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
12/23/2014 12:15 Anonymous-6723#6
Quote:
Originally Posted by hamzafigo View Post
Code:
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 :)
12/23/2014 12:37 Hamza FiGo#7
So what is wrong with it ?
12/23/2014 12:59 ​Exo#8
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.
12/23/2014 13:39 Hamza FiGo#9
Quote:
Originally Posted by xExorcist View Post
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?

Code:
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.

Code:
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
12/23/2014 14:00 ​Exo#10
-_- 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.
12/23/2014 14:55 Hamza FiGo#11
Quote:
Originally Posted by xExorcist View Post
-_- 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.

Quote:
Originally Posted by Crue* View Post
do you know that
you're a piece of shit
:confused:
12/23/2014 16:01 Anonymous-6723#12
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
12/23/2014 16:14 Syloxx#13
Quote:
Originally Posted by xExorcist View Post
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
12/23/2014 16:33 ​Exo#14
Quote:
Originally Posted by Syloxx View Post
Syntax Error :P
Crawl back, not feeling like arguing today, you should know why, so shutap..
12/23/2014 19:40 Hamza FiGo#15
Quote:
Originally Posted by Zed* View Post
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.
Page 1 of 2 1 2