USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_skill_manage] Script Date: 3/27/2020 10:37:30 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER procedure [dbo].[_skill_manage]
@job int,
@charid int,
@param1 int,
@param2 int
as
if( @job = 0) -- 스킬 배우기
begin
if( @param1 != 0)
begin
delete _CharSkill where CharID = @charid and SkillId = @param1
end
insert _CharSkill values( @charid, @param2, 1)
IF (@param2 in (select oldID From RI3O_VT_SYSTEMS.dbo.PermenantBuff))
Begin
DECLARE @GroupID smallint = (Select GroupID From RI3O_VT_SYSTEMS.dbo.PermenantBuff Where OldID=@param2)
DECLARE @OldSkill int = (Select Top 1 JobID From SRO_VT_SHARD.dbo._TimedJob T with (nolock) Inner Join RI3O_VT_SYSTEMS.dbo.PermenantBuff P on T.JobID=P.SkillID Where T.CharID=@CharID And P.GroupID=@GroupID)
DECLARE @NewID int = (Select SkillID From RI3O_VT_SYSTEMS.dbo.PermenantBuff Where OldID=@param2)
IF (@OldSkill is null)
Begin
DECLARE @Serial bigint = (SELECT Max (Serial64) + 1 FROM SRO_VT_SHARD.dbo._TimedJob with (nolock))
INSERT INTO SRO_VT_SHARD.dbo._TimedJob with (rowlock) (CharID, Category, JobID, TimeToKeep, Data1, Data2, Data3, Data4, Data5, Data6, Data7, Data8, Serial64) VALUES (@CharID, 0, @NewID, 1875767296, 0, 0, 0, 0, 0, 0, 0, 0, @Serial)
END
ELSE
Begin
Update SRO_VT_SHARD.dbo._TimedJob with (rowlock) Set JobID=@NewID Where JobID=@OldSkill And CharID=@CharID
END
END
end
else if( @job = 1) -- 마스터리 강화
begin
update _CharSkillMastery set Level = @param2 where CharID = @charid and MasteryID = @param1
end
else if( @job = 2) -- 스킬 회수
begin
delete _CharSkill where CharID = @charid and SkillId = @param1
delete from SRO_VT_SHARD.dbo._TimedJob where JobID in (Select SkillID From RI3O_VT_SYSTEMS.dbo.PermenantBuff) And CharID=@charid
if( @param2 != 0)
begin
insert _CharSkill values( @charid, @param2, 1)
end
end
else if( @job = 3) -- 마스터리 회수
begin
update _CharSkillMastery set [Level] = @param2 where CharID = @charid and MasteryID = @param1
end
premenantbuff table
Code:
USE [RI3O_VT_SYSTEMS]
GO
/****** Object: Table [dbo].[PermenantBuff] Script Date: 3/27/2020 3:09:18 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PermenantBuff](
[OldID] [smallint] NULL,
[SkillID] [int] NULL,
[GroupID] [smallint] NULL,
[SkillCode] [varchar](64) NULL
) ON [PRIMARY]
GO
IF NOT EXISTS (Select Top 1 JobID From SRO_VT_SHARD.dbo._TimedJob T with (nolock) Inner Join RI3O_VT_SYSTEMS.dbo.PermenantBuff P on T.JobID=P.SkillID Where T.CharID=@CharID And P.GroupID=@GroupID)
Begin
INSERT INTO SRO_VT_SHARD.dbo._TimedJob with (rowlock) (CharID, Category, JobID, TimeToKeep, Data1, Data2, Data3, Data4, Data5, Data6, Data7, Data8, Serial64) VALUES (@CharID, 0, @NewID, 1875767296, 0, 0, 0, 0, 0, 0, 0, 0, @Serial)
END
ELSE IF EXISTS (Select Top 1 JobID From SRO_VT_SHARD.dbo._TimedJob T with (nolock) Inner Join RI3O_VT_SYSTEMS.dbo.PermenantBuff P on T.JobID=P.SkillID Where T.CharID=@CharID And P.GroupID=@GroupID)
Begin
DECLARE @OldSkill int = (Select Top 1 JobID From SRO_VT_SHARD.dbo._TimedJob T with (nolock) Inner Join RI3O_VT_SYSTEMS.dbo.PermenantBuff P on T.JobID=P.SkillID Where T.CharID=@CharID And P.GroupID=@GroupID)
Update SRO_VT_SHARD.dbo._TimedJob with (rowlock) Set JobID=@NewID Where JobID=@OldSkill And CharID=@CharID
END
Could be:
Code:
DECLARE @OldSkill int = (Select Top 1 JobID From SRO_VT_SHARD.dbo._TimedJob T with (nolock) Inner Join RI3O_VT_SYSTEMS.dbo.PermenantBuff P on T.JobID=P.SkillID Where T.CharID=@CharID And P.GroupID=@GroupID)
IF @OldSkill IS NOT NULL
INSERT INTO SRO_VT_SHARD.dbo._TimedJob with (rowlock) (CharID, Category, JobID, TimeToKeep, Data1, Data2, Data3, Data4, Data5, Data6, Data7, Data8, Serial64) VALUES (@CharID, 0, @NewID, 1875767296, 0, 0, 0, 0, 0, 0, 0, 0, @Serial)
ELSE Update SRO_VT_SHARD.dbo._TimedJob with (rowlock) Set JobID=@NewID Where JobID=@OldSkill And CharID=@CharID
For a way better performance.
also i suggest editing Old Skills instead, that will make _RefSkill table with less rows, for a better performance on executing skill_manage.
IF NOT EXISTS (Select Top 1 JobID From SRO_VT_SHARD.dbo._TimedJob T with (nolock) Inner Join RI3O_VT_SYSTEMS.dbo.PermenantBuff P on T.JobID=P.SkillID Where T.CharID=@CharID And P.GroupID=@GroupID)
Begin
INSERT INTO SRO_VT_SHARD.dbo._TimedJob with (rowlock) (CharID, Category, JobID, TimeToKeep, Data1, Data2, Data3, Data4, Data5, Data6, Data7, Data8, Serial64) VALUES (@CharID, 0, @NewID, 1875767296, 0, 0, 0, 0, 0, 0, 0, 0, @Serial)
END
ELSE IF EXISTS (Select Top 1 JobID From SRO_VT_SHARD.dbo._TimedJob T with (nolock) Inner Join RI3O_VT_SYSTEMS.dbo.PermenantBuff P on T.JobID=P.SkillID Where T.CharID=@CharID And P.GroupID=@GroupID)
Begin
DECLARE @OldSkill int = (Select Top 1 JobID From SRO_VT_SHARD.dbo._TimedJob T with (nolock) Inner Join RI3O_VT_SYSTEMS.dbo.PermenantBuff P on T.JobID=P.SkillID Where T.CharID=@CharID And P.GroupID=@GroupID)
Update SRO_VT_SHARD.dbo._TimedJob with (rowlock) Set JobID=@NewID Where JobID=@OldSkill And CharID=@CharID
END
Could be:
Code:
DECLARE @OldSkill int = (Select Top 1 JobID From SRO_VT_SHARD.dbo._TimedJob T with (nolock) Inner Join RI3O_VT_SYSTEMS.dbo.PermenantBuff P on T.JobID=P.SkillID Where T.CharID=@CharID And P.GroupID=@GroupID)
IF @OldSkill IS NOT NULL
INSERT INTO SRO_VT_SHARD.dbo._TimedJob with (rowlock) (CharID, Category, JobID, TimeToKeep, Data1, Data2, Data3, Data4, Data5, Data6, Data7, Data8, Serial64) VALUES (@CharID, 0, @NewID, 1875767296, 0, 0, 0, 0, 0, 0, 0, 0, @Serial)
ELSE Update SRO_VT_SHARD.dbo._TimedJob with (rowlock) Set JobID=@NewID Where JobID=@OldSkill And CharID=@CharID
For a way better performance.
also i suggest editing Old Skills instead, that will make _RefSkill table with less rows, for a better performance on executing skill_manage.
this won't insert the skill for that first time it must be null to insert
two checks same codes where the better perf you talking about ?
oh you mean begin & end ? lol
why should i declare variable in case i don't need it lol again
less lines of _refskill for a better performance on executing skill_manage. ? wwhat ?
Quote:
Originally Posted by ceavk2
u cant make video tutorial ?
sorry i can't just copy|past lines and execute queries
two checks same codes where the better perf you talking about ?
oh you mean begin & end ? lol
why should i declare variable in case i don't need it lol again
both codes do the same job, but hell yeah, you enter the table 2 times
Code:
IF NOT EXISTS (Select Top 1 JobID From SRO_VT_SHARD.dbo._TimedJob T with (nolock) Inner Join RI3O_VT_SYSTEMS.dbo.PermenantBuff P on T.JobID=P.SkillID Where T.CharID=@CharID And P.GroupID=@GroupID)
Entering timed job and permanent buffs first time
Code:
ELSE IF EXISTS (Select Top 1 JobID From SRO_VT_SHARD.dbo._TimedJob T with (nolock) Inner Join RI3O_VT_SYSTEMS.dbo.PermenantBuff P on T.JobID=P.SkillID Where T.CharID=@CharID And P.GroupID=@GroupID)
second time
Code:
DECLARE @OldSkill int = (Select Top 1 JobID From SRO_VT_SHARD.dbo._TimedJob T with (nolock) Inner Join RI3O_VT_SYSTEMS.dbo.PermenantBuff P on T.JobID=P.SkillID Where T.CharID=@CharID And P.GroupID=@GroupID)
third time and still talking about both do the same job? lmao
Quote:
Originally Posted by White Ros3
less lines of _refskill for a better performance on executing skill_manage. ? wwhat ?
meant GS*
Also that should be a while loop, not executing those in each skill increase!
both codes do the same job, but hell yeah, you enter the table 2 times
Code:
IF NOT EXISTS (Select Top 1 JobID From SRO_VT_SHARD.dbo._TimedJob T with (nolock) Inner Join RI3O_VT_SYSTEMS.dbo.PermenantBuff P on T.JobID=P.SkillID Where T.CharID=@CharID And P.GroupID=@GroupID)
Entering timed job and permanent buffs first time
Code:
ELSE IF EXISTS (Select Top 1 JobID From SRO_VT_SHARD.dbo._TimedJob T with (nolock) Inner Join RI3O_VT_SYSTEMS.dbo.PermenantBuff P on T.JobID=P.SkillID Where T.CharID=@CharID And P.GroupID=@GroupID)
second time
Code:
DECLARE @OldSkill int = (Select Top 1 JobID From SRO_VT_SHARD.dbo._TimedJob T with (nolock) Inner Join RI3O_VT_SYSTEMS.dbo.PermenantBuff P on T.JobID=P.SkillID Where T.CharID=@CharID And P.GroupID=@GroupID)
third time and still talking about both do the same job? lmao
meant GS*
Also that should be a while loop, not executing those in each skill increase!
It won't bug anything buddy, but managing to execute this on every skill upgrade/downgrade is not fine.. Way lot CPU usage for nothing
Also you cannot add lightning speed buff as permanent buff using this code, that will be buggy. as i see he couldn't add it in the topic.
It won't bug anything buddy, but managing to execute this on every skill upgrade/downgrade is not fine.. Way lot CPU usage for nothing
Also you cannot add lightning speed buff as permanent buff using this code, that will be buggy. as i see he couldn't add it in the topic.
So finally what is the correct query, that u posted above?
So finally what is the correct query, that u posted above?
Nope, not even a good way to create this system, but easier and better to use the old skill codes and external code that gets executed on login/logout only, not every skill upgrade/downgrade.
ninja saga premium mission hack(permanent/may not permanent) 02/17/2013 - Facebook - 9 Replies 1.open ninja saga
2.open cheat engine 5.6.1
3.play ninja saga
4.in cheat engine,change the value type from <4bytes> to <text>
5.then,scan <premium>
6.select all address and change the value to <free user>
7.go to mission room
8.now you can do all the PREMIUM mission NOW
9.ENJOY THE HACK =) :bandit:
Permanent M249 Minimi is Live!, Get your Permanent M249 today!!! 09/16/2011 - WarRock - 3 Replies Posted by Jericho
M248 Minimi
http://www.gamersfirst.com/_img/products/en/457.j pg
Description: The M249 Minimi fires 5.56 x 45mm NATO rounds at 725 rounds per minute, and is designed to be a lightweight, one-man anti-infantry weapon.
Branch: Assault
Slot: 5th
![[Release] China Permanent buff](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/release-china-permanent-buff_ltr.gif){kind=small}
[Release] China Permanent buff
