permanent Buffs Idea

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

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

Quote:

Originally Posted by Muhab Ashraf [Only registered and activated users can see links. Click Here To Register...]

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 @[Only registered and activated users can see links. Click Here To Register...] INT
DECLARE @[Only registered and activated users can see links. Click Here To Register...] INT
DECLARE @[Only registered and activated users can see links. Click Here To Register...] INT
DECLARE @[Only registered and activated users can see links. Click Here To Register...] INT
DECLARE @[Only registered and activated users can see links. Click Here To Register...]5 INT
DECLARE @[Only registered and activated users can see links. Click Here To Register...]6 INT

SET @[Only registered and activated users can see links. Click Here To Register...] = (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 @[Only registered and activated users can see links. Click Here To Register...] = (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 @[Only registered and activated users can see links. Click Here To Register...] = (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 @[Only registered and activated users can see links. Click Here To Register...] = (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 @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...],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 @[Only registered and activated users can see links. Click Here To Register...],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 @[Only registered and activated users can see links. Click Here To Register...],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 @[Only registered and activated users can see links. Click Here To Register...],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 @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]6,959200,0,0,0,0,0,0,0,0,@Serial,0
END

Quote:

Originally Posted by Muhab Ashraf [Only registered and activated users can see links. Click Here To Register...]

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

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.