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

[kingmoka]

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

 Spoiler

if(@JobID= '90022') --Remove Premium--
begin
declare @RemovePrem1 int
declare @RemovePrem2 int
declare @RemovePrem3 int
declare @RemovePrem4 int
declare @RemovePrem5 int
declare @RemovePrem6 int
declare @RemovePrem7 int
declare @RemovePrem8 int
DECLARE @REMOVEPREM9 INT
SET @RemovePrem1 = (Select ID From _TimedJob Where CharID=@CharID and Data2=3847)
SET @RemovePrem2 = (Select ID From _TimedJob Where CharID=@CharID and Data2=3783)
SET @RemovePrem3 = (Select ID From _TimedJob Where CharID=@CharID and Data2=3769)
SET @RemovePrem4 = (Select ID From _TimedJob Where CharID=@CharID and Data2=3795)
SET @RemovePrem5 = (Select ID From _TimedJob Where CharID=@CharID and Data2=10800)
SET @RemovePrem6 = (Select ID From _TimedJob Where CharID=@CharID and Data2=224)
SET @RemovePrem7 = (Select ID From _TimedJob Where CharID=@CharID and Data2=1)
SET @RemovePrem8 = (Select ID From _TimedJob Where CharID=@CharID and Data2=2)
SET @REMOVEPREM9 = (SELECT ID FROM _TIMEDJOB WHERE CharID=@CharID AND Data2=707799600)
delete from _TimedJob WHERE ID=@RemovePrem1
delete from _TimedJob WHERE ID=@RemovePrem2
delete from _TimedJob WHERE ID=@RemovePrem3
delete from _TimedJob WHERE ID=@RemovePrem4
delete from _TimedJob WHERE ID=@RemovePrem5
delete from _TimedJob WHERE ID=@RemovePrem6
delete from _TimedJob WHERE ID=@RemovePrem7
delete from _TimedJob WHERE ID=@RemovePrem8
delete from _TimedJob WHERE ID=@REMOVEPREM9
end

2- Reset Stats

 Spoiler

if(@JobID = '90019') -- remove stats
begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
select @MaxLevel = MaxLevel from _Char where CharID = @CharID
set @RemainStatPoint = (@MaxLevel*3)-3
set @MaxLevel = @MaxLevel+19
UPDATE _Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID
end

3- Reset Skills .

 Spoiler

if(@JobID= '90020') -- remove skills
begin
declare @TotalSP int
declare @TotalSPMastery int
SELECT @TotalSP = SUM(_RefSkill.ReqLearn_SP) FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '130'
SELECT @TotalSPMastery = SUM(_RefLevel.Exp_M) FROM _CharSkillMastery, _RefLevel WHERE _RefLevel.Lvl=_CharSkillMastery.Level AND _CharSkillMastery.CharID=@CharID AND _CharSkillMastery.Level <= '130'
UPDATE _Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalS PMastery+200000 WHERE CharID=@CharID
DELETE _CharSkill FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '130' AND _RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,115 26,10625)
UPDATE _CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '130'
end

4- Change name

 Spoiler

if(@JobID = '91720') --Change Name--
begin
declare @CharName16 varchar(64)
Select @CharName16=CharName16 from _Char where CharID = @CharID
Update _Char Set CharName16 = '@'+ @CharName16 Where CharID = @CharID

end

5- Remove Advance.

 Spoiler

if(@JobID = '90015') -- Adv Remover
begin
DECLARE @ItemID varchar (64)
SELECT @ItemID=ItemID from _Inventory where CharID = @CharID AND Slot = '13'
DELETE FROM _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory WHERE Slot = '13' AND CharID=@CharID) and bOptType=2
end

Iam going to release more reset/remove systems as soon as i get them

Press Thanks If i helped .

[Jon.Gamexen]

Remove Blue Avatar

PHP Code:

    if(@JobID= '34038') ---Remove Avatar Blue---
        begin 
            Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 in (select ItemID from _Inventoryforavatar where CharID = @CharID and Slot between 0 and 2 and ItemID>0)
        end 


And Remove Maximum

PHP Code:

    if(@JobID= '787880') ---Remove Maximum---
        begin 
            Update _Items
             Set MagParamNum = 0 , MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = 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 


[™_[GM]Viper_™]

Good jab

[Muhab*]

Originally Posted by kingmoka

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:

 Spoiler

delete from SRO_VT_SHARD.._TimedJob WHERE Date2 IN(3847,3783,3769,3795,10800,224,1,2,707799600) AND CharID = @CharID

Stats:

 Spoiler

UPDATE SRO_VT_SHARD.._Char SET Strength = MaxLevel+19, Intellect = MaxLevel+19,RemainStatPoint = (MaxLevel-1)*3 Where CharID = @CharID

Change name:

 Spoiler

UPDATE SRO_VT_SHARD.._Char SET CharName16 = '@'+CharName16 WHERE CharID = @CharID

this way better eh?

[fxreklam]

Good work

[Immortality-Sro]

Need QUERY Remove From all players

[Holosco*]

a good release thanks

[Junkle]

[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

[abdo2elnagar15]

can you release too media lines and db lines