[Release]Most of the Reset/Remove Systems ..

09/22/2014 21:59 kingmoka#1
First of all these systems are tested by me and they're 100% working , as i know .. haters are going to hate and say 'Released Before !' i will say: released reset/remove systems are not working ..

Let's start ! ..
Note: All of these should be in _AddTimedJob @SHARD_DB
1-: Premium Remove ..

2- Reset Stats
3- Reset Skills .
4- Change name
5- Remove Advance.
Iam going to release more reset/remove systems as soon as i get them ;)

Quote:
Press Thanks If i helped .
09/22/2014 22:34 Jon.Gamexen#2
Remove Blue Avatar
PHP Code:
    if(@JobID'34038') ---Remove Avatar Blue---
        
begin 
            Update _Items Set MagParamNum 
0MagParam1 NULLMagParam2 NULLMagParam3 NULLMagParam4 NULLMagParam5 NULLMagParam6 NULLMagParam7 NULLMagParam8 NULLMagParam9 NULLMagParam10 NULLMagParam11 NULLMagParam12 NULL where ID64 in (select ItemID from _Inventoryforavatar where CharID = @CharID and Slot between 0 and and ItemID>0)
        
end 
And Remove Maximum

PHP Code:
    if(@JobID'787880') ---Remove Maximum---
        
begin 
            Update _Items
             Set MagParamNum 
MagParam1 NULLMagParam2 NULLMagParam3 NULLMagParam4 NULLMagParam5 NULLMagParam6 NULLMagParam7 NULLMagParam8 NULLMagParam9 NULLMagParam10 NULLMagParam11 NULLMagParam12 NULL where ID64 in (select ItemID from _Inventory where CharID = @CharID and Slot between 0 and 12 and ItemID Between 1 AND 999999999)
        
end 
Remove PK
PHP Code:
if(@JobID    =    '34005')---Remove PK---
begin

Update    _Char    Set    DailyPK    
=    0    Where    CharID    =    @CharID
Update    _Char    Set    TotalPK    
=    0    Where    CharID    =    @CharID
Update    _Char    Set    PKPenaltyPoint    
=    0    Where    CharID    =    @CharID
end 
09/22/2014 23:44 ™_[GM]Viper_™#3
Good jab
09/23/2014 00:16 Muhab*#4
Quote:
Originally Posted by kingmoka View Post
First of all these systems are tested by me and they're 100% working , as i know .. haters are going to hate and say 'Released Before !' i will say: released reset/remove systems are not working ..

Let's start ! ..
Note: All of these should be in _AddTimedJob @SHARD_DB
1-: Premium Remove ..

2- Reset Stats
3- Reset Skills .
4- Change name
5- Remove Advance.
Iam going to release more reset/remove systems as soon as i get them ;)
what about
Premium:
Stats:
Change name:
this way better eh?
09/23/2014 17:40 fxreklam#5
Good work :)
04/22/2015 17:10 Immortality-Sro#6
Need QUERY Remove From all players
04/22/2015 22:50 Holosco*#7
a good release thanks
04/22/2015 23:12 Junkle#8
[QUOTE=kingmoka;29662864]First of all these systems are tested by me and they're 100% working , as i know .. haters are going to hate and say 'Released Before !' i will say: released reset/remove systems are not working ..

Let's start ! ..
Note: All of these should be in _AddTimedJob @SHARD_DB
1-: Premium Remove ..
Idon't Read all but Read thats why you take All thats 'S ? ineed Know Pleas
PHP Code:
If (@jobid='' and exists (select from _timedjob where CharID=@Charid and jobid in (5412,31104,29723,37411,37394,9278,22925,22928,5412,24487,47588,47572,47058,9277,200)))
begin
delete _TimedJob where charid
=@charid and JobID in (5412,31104,29723,37411,37394,9278,22925,22928,5412,24487,47588,47572,47058,9277,200)
end 
Take That's And Stop For Relase Anthor Producers ^_^
Sorry For My english So bad
04/24/2015 00:34 abdo2elnagar15#9
can you release too media lines and db lines :)