skill`s VIP for 28 days Zeker example

**anapse** · 30-09-14

Code:

 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

Code:

 
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

Code:

 

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

Code:

 
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

Code:

 

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

Code:

 

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** · 30-09-14

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

**CandyQ** · 30-09-14

Originally Posted by MaDenGo

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

+1....

**anapse** · 01-10-14

Originally Posted by MaDenGo

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** · 01-10-14

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

**thebigbody** · 01-10-14

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** · 01-10-14

Originally Posted by 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

+1

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

**anapse** · 01-10-14

Originally Posted by bares1993

+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** · 03-10-14

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** · 03-10-14

Originally Posted by 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

now that's brilliant

**anapse** · 03-10-14

Originally Posted by 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

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

**abdo1020** · 03-10-14

i didn't get it

**thebigbody** · 03-10-14

Originally Posted by abdo1020

i didn't get it

cuz u r nooby

**abdo1020** · 03-10-14

Originally Posted by thebigbody

cuz u r nooby

yes get over it

**AngelShade** · 05-10-14

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.

**NourAyman** · 06-10-14

Originally Posted by 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.

lawl .. why request to close ??!

Simply you can get the refskillgroup lines from refskill ..

**anapse** · 06-10-14

Originally Posted by 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.

the only thing missing is skill effect

you can do this from any color

and the subject was to skill for 28 days this is just an example

skill`s VIP for 28 days Zeker example

Thread Tools

Search Thread

skill`s VIP for 28 days Zeker example

Re: skill`s VIP for 28 days Zeker example

Re: skill`s VIP for 28 days Zeker example

Re: skill`s VIP for 28 days Zeker example

Re: skill`s VIP for 28 days Zeker example

Re: skill`s VIP for 28 days Zeker example

Re: skill`s VIP for 28 days Zeker example

Re: skill`s VIP for 28 days Zeker example

Re: skill`s VIP for 28 days Zeker example

Re: skill`s VIP for 28 days Zeker example

Re: skill`s VIP for 28 days Zeker example

Re: skill`s VIP for 28 days Zeker example

Re: skill`s VIP for 28 days Zeker example

Re: skill`s VIP for 28 days Zeker example

Re: skill`s VIP for 28 days Zeker example

Re: skill`s VIP for 28 days Zeker example

Re: skill`s VIP for 28 days Zeker example

Advertisement