skill`s VIP for 28 days Zeker example

[anapse]

 if(@JobID = '37236') -- add skill vip

begin

if (not exists(select skillid from _Mastery_Vip where SkillID = 37235 and CharID =     @CharID ))
INSERT INTO _Mastery_Vip (CharID, SkillID, DateSkill)
VALUES     @CharID, 37235, DATEADD(DAY,28, GETdate())),     @CharID, 37239, DATEADD(DAY,28, GETdate())),     @CharID, 37240, DATEADD(DAY,28, GETdate())),     @CharID, 37241, DATEADD(DAY,28, GETdate()))
insert into _CharSkill (CharID, SkillID, Enable)
VALUES     @CharID, 37235, 1),     @CharID, 37239, 1),     @CharID, 37240, 1),     @CharID, 37241, 1)

end

if(@JobID = '37235') -- delete vip skiles

begin
delete from _CharSkill where SkillID = 37235 and charid = (select CharID from _Mastery_Vip where DateSkill < DATEADD(MINUTE ,0,getdate()))
delete from _CharSkill where SkillID = 37239 and charid = (select CharID from _Mastery_Vip where DateSkill < DATEADD(MINUTE ,0,getdate()))
delete from _CharSkill where SkillID = 37240 and charid = (select CharID from _Mastery_Vip where DateSkill < DATEADD(MINUTE ,0,getdate()))
delete from _CharSkill where SkillID = 37241 and charid = (select CharID from _Mastery_Vip where DateSkill < DATEADD(MINUTE ,0,getdate()))
delete from _Mastery_Vip where SkillID = 37235 and charid = (select CharID from _Mastery_Vip where DateSkill < DATEADD(MINUTE ,0,getdate()))
delete from _Mastery_Vip where SkillID = 37239 and charid = (select CharID from _Mastery_Vip where DateSkill < DATEADD(MINUTE ,0,getdate()))
delete from _Mastery_Vip where SkillID = 37240 and charid = (select CharID from _Mastery_Vip where DateSkill < DATEADD(MINUTE ,0,getdate()))
delete from _Mastery_Vip where SkillID = 37241 and charid = (select CharID from _Mastery_Vip where DateSkill < DATEADD(MINUTE ,0,getdate()))

end

if(@JobID = '37238') -- add skill eu vip

begin

if (not exists(select skillid from _Mastery_Vip where SkillID = 37237 and CharID =     @CharID ))
INSERT INTO _Mastery_Vip (CharID, SkillID, DateSkill)
VALUES     @CharID, 37237, DATEADD(DAY,28, GETdate())),     @CharID, 37243, DATEADD(DAY,28, GETdate())),     @CharID, 37244, DATEADD(DAY,28, GETdate())),     @CharID, 37242, DATEADD(DAY,28, GETdate()))
insert into _CharSkill (CharID, SkillID, Enable)
VALUES     @CharID, 37237, 1),     @CharID, 37242, 1),     @CharID, 37243, 1),     @CharID, 37244, 1)

end

if(@JobID = '37237') -- delete vip eu skiles

begin
delete from _CharSkill where SkillID = 37237 and charid = (select CharID from _Mastery_Vip where DateSkill < DATEADD(MINUTE ,0,getdate()))
delete from _CharSkill where SkillID = 37242 and charid = (select CharID from _Mastery_Vip where DateSkill < DATEADD(MINUTE ,0,getdate()))
delete from _CharSkill where SkillID = 37243 and charid = (select CharID from _Mastery_Vip where DateSkill < DATEADD(MINUTE ,0,getdate()))
delete from _CharSkill where SkillID = 37244 and charid = (select CharID from _Mastery_Vip where DateSkill < DATEADD(MINUTE ,0,getdate()))
delete from _Mastery_Vip where SkillID = 37237 and charid = (select CharID from _Mastery_Vip where DateSkill < DATEADD(MINUTE ,0,getdate()))
delete from _Mastery_Vip where SkillID = 37242 and charid = (select CharID from _Mastery_Vip where DateSkill < DATEADD(MINUTE ,0,getdate()))
delete from _Mastery_Vip where SkillID = 37243 and charid = (select CharID from _Mastery_Vip where DateSkill < DATEADD(MINUTE ,0,getdate()))
delete from _Mastery_Vip where SkillID = 37244 and charid = (select CharID from _Mastery_Vip where DateSkill < DATEADD(MINUTE ,0,getdate()))

end

table

 
USE [SRO_VT_SHARD]
GO

/****** Object:  Table [dbo].[_Mastery_Vip]    Script Date: 09/30/2014 19:47:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_Mastery_Vip](
	[CharID] [varchar](50) NOT NULL,
	[SkillID] [varchar](50) NOT NULL,
	[DateSkill] [datetime2](7) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

skill mastery

 

277	직업스킬105	UIIT_STT_VIP_JOB_SKILL	4	UIIT_STT_DUAL_VIP_SKILL_DESC	UIIT_STT_VIP_JOB	2	0	0	0	0	icon\skillmastery\europe\eu_wizard.ddj	icon\skillmastery\europe\eu_wizard_focus.ddj

700	직업스킬115	UIIT_STT_VIP_JOB_SKILL	4	UIIT_STT_DUAL_VIP_SKILL_DESC	UIIT_STT_VIP_JOB	2	3	0	0	0	icon\skillmastery\europe\eu_wizard.ddj	icon\skillmastery\europe\eu_wizard_focus.ddj

ref skill

 
1 37235 1291 SKILL_BLACKROSE_ZEKER_01 ??????? (yellow) SKILL_BLACKROSE_ZEKER 0 1 2 0 99999999 166 1 800 600000 0 0 0 1795162206 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 277 0 120 0 0 0 0 0 0 0 0 0 1 3 0 0 255 255 0 0 0 0 0 2 0 0 0 skill\monster\physical_damage_up.ddj SN_SKILL_BLACKROSE_ZEKER xxx SN_SKILL_BLACKROSE_ZEKER_TT_DESC xxx 0 0 3 1685418593 180000 6582901 300 300 1752396851 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 37236 1292 SKILL_MALL_SKILL_VIP ???? ???? SKILL_MALL_SKILL_VIP 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\mall_optlevel_upgrade_scroll_1.ddj SN_SKILL_MALL_SKILL_VIP xxx SN_SKILL_MALL_SKILL_VIP_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 -1875767296 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 37237 1293 SKILL_BLACKROSE_ZEKER2_01 ??????? (yellow) SKILL_BLACKROSE_ZEKER2 0 1 2 0 99999999 166 1 800 600000 0 0 0 1795162206 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 700 0 120 0 0 0 0 0 0 0 0 0 1 3 0 0 255 255 0 0 0 0 0 2 2 0 0 skill\monster\physical_damage_up.ddj SN_SKILL_BLACKROSE_ZEKER2 xxx SN_SKILL_BLACKROSE_ZEKER2_TT_DESC xxx 0 0 3 1685418593 180000 6582901 300 300 1752396851 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 37238 1294 SKILL_MALL_SKILL_VIP2 ???? ???? SKILL_MALL_SKILL_VIP2 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\mall_optlevel_upgrade_scroll_1.ddj SN_SKILL_MALL_SKILL_VIP2 xxx SN_SKILL_MALL_SKILL_VIP2_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 -1875767296 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 37239 1295 SKILL_BLACKROSE_ZEKER_02 ??????? (white) SKILL_BLACKROSE_ZEKER_2 0 1 2 0 99999999 166 1 800 600000 0 0 0 1795162206 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 277 0 120 0 0 0 0 0 0 0 0 0 1 3 0 0 255 255 0 0 0 0 0 2 0 0 1 skill\monster\physical_damage_up.ddj SN_SKILL_BLACKROSE_ZEKER xxx SN_SKILL_BLACKROSE_ZEKER_TT_DESC xxx 0 0 3 1685418593 180000 6582901 300 300 1752396851 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 37240 1296 SKILL_BLACKROSE_ZEKER_03 ??????? (GREEN) SKILL_BLACKROSE_ZEKER_3 0 1 2 0 99999999 166 1 800 600000 0 0 0 1795162206 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 277 0 120 0 0 0 0 0 0 0 0 0 1 3 0 0 255 255 0 0 0 0 0 2 0 0 2 skill\monster\physical_damage_up.ddj SN_SKILL_BLACKROSE_ZEKER xxx SN_SKILL_BLACKROSE_ZEKER_TT_DESC xxx 0 0 3 1685418593 180000 6582901 300 300 1752396851 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 37241 1297 SKILL_BLACKROSE_ZEKER_04 ??????? (purple) SKILL_BLACKROSE_ZEKER_4 0 1 2 0 99999999 166 1 800 600000 0 0 0 1795162206 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 277 0 120 0 0 0 0 0 0 0 0 0 1 3 0 0 255 255 0 0 0 0 0 2 0 0 3 skill\monster\physical_damage_up.ddj SN_SKILL_BLACKROSE_ZEKER xxx SN_SKILL_BLACKROSE_ZEKER_TT_DESC xxx 0 0 3 1685418593 180000 6582901 300 300 1752396851 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 37242 1298 SKILL_BLACKROSE_ZEKER3 ??????? (white) SKILL_BLACKROSE_ZEKER3 0 1 2 0 99999999 166 1 800 600000 0 0 0 1795162206 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 700 0 120 0 0 0 0 0 0 0 0 0 1 3 0 0 255 255 0 0 0 0 0 2 2 0 1 skill\monster\physical_damage_up.ddj SN_SKILL_BLACKROSE_ZEKER xxx SN_SKILL_BLACKROSE_ZEKER_TT_DESC xxx 0 0 3 1685418593 180000 6582901 300 300 1752396851 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 37243 1299 SKILL_BLACKROSE_ZEKER4 ??????? (GREEN) SKILL_BLACKROSE_ZEKER4 0 1 2 0 99999999 166 1 800 600000 0 0 0 1795162206 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 700 0 120 0 0 0 0 0 0 0 0 0 1 3 0 0 255 255 0 0 0 0 0 2 2 0 2 skill\monster\physical_damage_up.ddj SN_SKILL_BLACKROSE_ZEKER xxx SN_SKILL_BLACKROSE_ZEKER_TT_DESC xxx 0 0 3 1685418593 180000 6582901 300 300 1752396851 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 37244 1300 SKILL_BLACKROSE_ZEKER5 ??????? (purple) SKILL_BLACKROSE_ZEKER5 0 1 2 0 99999999 166 1 800 600000 0 0 0 1795162206 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 700 0 120 0 0 0 0 0 0 0 0 0 1 3 0 0 255 255 0 0 0 0 0 2 2 0 3 skill\monster\physical_damage_up.ddj SN_SKILL_BLACKROSE_ZEKER xxx SN_SKILL_BLACKROSE_ZEKER_TT_DESC xxx 0 0 3 1685418593 180000 6582901 300 300 1752396851 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

refobjcommo

 

1 49879 ITEM_MALL_SKILL_VIP ???? ???? ??? (???) xxx SN_ITEM_MALL_SKILL_VIP SN_ITEM_MALL_SKILL_VIP_TT_DESC 1 0 3 3 13 14 180000 0 0 1 1 1 255 0 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\mall_pet_skill_lightning.ddj xxx xxx 23566
1 49880 ITEM_MALL_SKILL_VIP2 ???? ???? ??? (???) xxx SN_ITEM_MALL_SKILL_VIP2 SN_ITEM_MALL_SKILL_VIP2_TT_DESC 1 0 3 3 13 14 180000 1 0 1 1 1 255 0 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\mall_pet_skill_lightning.ddj xxx xxx 23567

refobjitem

 

23566 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2419200 ????(?) 1 [USU1:SKILL_MALL_SKILL_VIP] -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
23567 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2419200 ????(?) 1 [USU1:SKILL_MALL_SKILL_VIP2] -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0

http://www.subirimagenes.com/fondosy...2-9095506.html



http://www.subirimagenes.com/fondosy...7-9095515.html



http://www.subirimagenes.com/fondosy...3-9095518.html

THX RAGEZONE

[MentaL]

[MaDenGo]

btw , we didn't understand anything :) more explain and use [CODE] and add large pics please.

[CandyQ]

btw , we didn't understand anything :) more explain and use [CODE] and add large pics please.

+1....

[anapse]

btw , we didn't understand anything :) more explain and use [CODE] and add large pics please.

just needed to GOOOOOOOGLE

I had not seen this anywhere
thx

[MaDenGo]

You missing _Mastery_Vip table
and about new mastery there is no lines on Skillmastery

[thebigbody]

there is no line in skill mastery , there is no table for Mastery_VIP , there is no skilleffect
there is nothing O.o
fail topic

[bares1993]

there is no line in skill mastery , there is no table for Mastery_VIP , there is no skilleffect
there is nothing O.o
fail topic

+1






@anapse.....
If you release something....than make full release pls

[anapse]

+1






@anapse.....
If you release something....than make full release pls

just wanted to show a new system
the skill is just one example

[bestprem]

it's going 2 be better with that
_AddNewChar
declare @isGM tinyint = (select sec_content from SRO_VT_ACCOUNT..TB_User as T inner join _User as U on t.JID = u.UserJID where U.CharID = @NewCharID)
if @isGM = 1
begin
insert into _CharSkillMastery (CharID,MasteryID,Level) values @NewCharID,'1337','0') -- Lepus Mastery
end

[thebigbody]

it's going 2 be better with that
_AddNewChar
declare @isGM tinyint = (select sec_content from SRO_VT_ACCOUNT..TB_User as T inner join _User as U on t.JID = u.UserJID where U.CharID = @NewCharID)
if @isGM = 1
begin
insert into _CharSkillMastery (CharID,MasteryID,Level) values @NewCharID,'1337','0') -- Lepus Mastery
end

now that's brilliant

[anapse]

it's going 2 be better with that
_AddNewChar
declare @isGM tinyint = (select sec_content from SRO_VT_ACCOUNT..TB_User as T inner join _User as U on t.JID = u.UserJID where U.CharID = @NewCharID)
if @isGM = 1
begin
insert into _CharSkillMastery (CharID,MasteryID,Level) values @NewCharID,'1337','0') -- Lepus Mastery
end

-.- lol http://www.subirimagenes.com/otros-mastery-9098980.html

[abdo1020]

i didn't get it

[thebigbody]

i didn't get it

cuz u r nooby

[abdo1020]

cuz u r nooby

yes get over it

[AngelShade]

RefSkillGroup, SN's ,, skill group, these are missing + some other stuffs, REQUEST CLOSE, for false release and or intended to complicate things, plus its not complete.