permanent Buffs Idea

[kotsh]

Hello guys
i saw many servers using permanent buffs system
but when i try to force add skill at timed job game server crash
any idea how it work ?
thank you

[Muhab*]

[TrashBag]

Originally Posted by Muhab Ashraf

he just did XD

HERE YOU GO it's not well coded but will do what u want
~~ not mine~~
Addlogchar
IF (@EventID IN (4,6,9)) -- Permanent Buffs
BEGIN
EXEC _BLA_BLA_BUFFS @CharID
END
/////////////////////////////////
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_BLA_BLA_BUFFS] Script Date: 6/14/2016 3:14:01 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
Create Procedure [dbo].[_BLA_BLA_BUFFS]
@CharID INT
as
DECLARE @Serial BIGINT
SELECT @Serial = (SELECT TOP 1 Serial64 + 1 FROM SRO_VT_SHARD.._TimedJob ORDER BY Serial64 DESC)

DECLARE @ INT
DECLARE @ INT
DECLARE @ INT
DECLARE @ INT
DECLARE @5 INT
DECLARE @6 INT

SET @ = (SELECT Max (SkillID) FROM SRO_VT_SHARD.dbo._CharSkill WHERE CharID=@CharID AND SkillID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_FIRE_SHIELD_%'))
SET @ = (SELECT Max (SkillID) FROM SRO_VT_SHARD.dbo._CharSkill WHERE CharID=@CharID AND SkillID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_FIRE_GONGUP_%'))
SET @ = (SELECT Max (SkillID) FROM SRO_VT_SHARD.dbo._CharSkill WHERE CharID=@CharID AND SkillID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_FIRE_GANGGI_%'))
SET @ = (SELECT Max (SkillID) FROM SRO_VT_SHARD.dbo._CharSkill WHERE CharID=@CharID AND SkillID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_LIGHTNING_JIPJUNG_%'))
SET @5 = (SELECT Max (SkillID) FROM SRO_VT_SHARD.dbo._CharSkill WHERE CharID=@CharID AND SkillID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_LIGHTNING_GWANTONG_%'))
SET @6 = (SELECT Max (SkillID) FROM SRO_VT_SHARD.dbo._CharSkill WHERE CharID=@CharID AND SkillID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_COLD_GANGGI_%'))

IF (SELECT Max (SkillID) FROM SRO_VT_SHARD.dbo._CharSkill WHERE CharID=@CharID AND SkillID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_FIRE_SHIELD_%')) NOT IN (SELECT [JobID] FROM SRO_VT_SHARD.dbo._TimedJob WHERE CharID=@CharID)
BEGIN
DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE [CharID]=@CharID AND [JobID] IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_FIRE_SHIELD_%')
INSERT SRO_VT_SHARD.dbo._TimedJob SELECT @CharID,0 @,959200,0,0,0,0,0,0,0,0,@Serial,0
END
IF (SELECT Max (SkillID) FROM SRO_VT_SHARD.dbo._CharSkill WHERE CharID=@CharID AND SkillID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_FIRE_GONGUP_%')) NOT IN (SELECT [JobID] FROM SRO_VT_SHARD.dbo._TimedJob WHERE CharID=@CharID)
BEGIN
DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE [CharID]=@CharID AND [JobID] IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_FIRE_GONGUP_%')
INSERT SRO_VT_SHARD.dbo._TimedJob SELECT @CharID,0 @,959200,0,0,0,0,0,0,0,0,@Serial,0
END
IF (SELECT Max (SkillID) FROM SRO_VT_SHARD.dbo._CharSkill WHERE CharID=@CharID AND SkillID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_FIRE_GANGGI_%')) NOT IN (SELECT [JobID] FROM SRO_VT_SHARD.dbo._TimedJob WHERE CharID=@CharID)
BEGIN
DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE [CharID]=@CharID AND [JobID] IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_FIRE_GANGGI_%')
INSERT SRO_VT_SHARD.dbo._TimedJob SELECT @CharID,0 @,959200,0,0,0,0,0,0,0,0,@Serial,0
END
IF (SELECT Max (SkillID) FROM SRO_VT_SHARD.dbo._CharSkill WHERE CharID=@CharID AND SkillID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_LIGHTNING_JIPJUNG_%')) NOT IN (SELECT [JobID] FROM SRO_VT_SHARD.dbo._TimedJob WHERE CharID=@CharID)
BEGIN
DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE [CharID]=@CharID AND [JobID] IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_LIGHTNING_JIPJUNG_%')
INSERT SRO_VT_SHARD.dbo._TimedJob SELECT @CharID,0 @,959200,0,0,0,0,0,0,0,0,@Serial,0
END
IF (SELECT Max (SkillID) FROM SRO_VT_SHARD.dbo._CharSkill WHERE CharID=@CharID AND SkillID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_LIGHTNING_GWANTONG_%')) NOT IN (SELECT [JobID] FROM SRO_VT_SHARD.dbo._TimedJob WHERE CharID=@CharID)
BEGIN
DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE [CharID]=@CharID AND [JobID] IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_LIGHTNING_GWANTONG_%')
INSERT SRO_VT_SHARD.dbo._TimedJob SELECT @CharID,0 @5,959200,0,0,0,0,0,0,0,0,@Serial,0
END
IF (SELECT Max (SkillID) FROM SRO_VT_SHARD.dbo._CharSkill WHERE CharID=@CharID AND SkillID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_COLD_GANGGI_%')) NOT IN (SELECT [JobID] FROM SRO_VT_SHARD.dbo._TimedJob WHERE CharID=@CharID)
BEGIN
DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE [CharID]=@CharID AND [JobID] IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefSkill WHERE Basic_Code LIKE 'SKILL_CH_COLD_GANGGI_%')
INSERT SRO_VT_SHARD.dbo._TimedJob SELECT @CharID,0 @6,959200,0,0,0,0,0,0,0,0,@Serial,0
END

[kotsh]

Originally Posted by Muhab Ashraf

OMG OMG OMG You my Hero thank you
i dont know what i was gonna do with out you

please you google it and try it
if worked tell me for Big Thanks

[Monarch MVP]

We are acquainted perma buffs from Electus, Electus buffs are misleading, fake. And other servers too. When you down at PvP you must teleport for get buffs. But only few players know this. TrashBag codes is trash too . Danke, gracias.

Edit: Ask him if you dont belive me. Stop sending msg to me.