skill`s VIP for 28 days Zeker example

anapse · Sep 30, 2014

Code:

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

begin

if (not exists(select skillid from _Mastery_Vip where SkillID = 37235 and CharID =     [USER=551894]Char[/USER]ID ))
INSERT INTO _Mastery_Vip (CharID, SkillID, DateSkill)
VALUES     [USER=551894]Char[/USER]ID, 37235, DATEADD(DAY,28, GETdate())),     [USER=551894]Char[/USER]ID, 37239, DATEADD(DAY,28, GETdate())),     [USER=551894]Char[/USER]ID, 37240, DATEADD(DAY,28, GETdate())),     [USER=551894]Char[/USER]ID, 37241, DATEADD(DAY,28, GETdate()))
insert into _CharSkill (CharID, SkillID, Enable)
VALUES     [USER=551894]Char[/USER]ID, 37235, 1),     [USER=551894]Char[/USER]ID, 37239, 1),     [USER=551894]Char[/USER]ID, 37240, 1),     [USER=551894]Char[/USER]ID, 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 =     [USER=551894]Char[/USER]ID ))
INSERT INTO _Mastery_Vip (CharID, SkillID, DateSkill)
VALUES     [USER=551894]Char[/USER]ID, 37237, DATEADD(DAY,28, GETdate())),     [USER=551894]Char[/USER]ID, 37243, DATEADD(DAY,28, GETdate())),     [USER=551894]Char[/USER]ID, 37244, DATEADD(DAY,28, GETdate())),     [USER=551894]Char[/USER]ID, 37242, DATEADD(DAY,28, GETdate()))
insert into _CharSkill (CharID, SkillID, Enable)
VALUES     [USER=551894]Char[/USER]ID, 37237, 1),     [USER=551894]Char[/USER]ID, 37242, 1),     [USER=551894]Char[/USER]ID, 37243, 1),     [USER=551894]Char[/USER]ID, 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

anapse - skill`s VIP for 28 days Zeker example - RaGEZONE Forums

You must be registered to see links

THX RAGEZONE

MaDenGo · Sep 30, 2014

btw , we didn't understand anything

more explain and use

Code:

 and add large pics please.

CandyQ · Sep 30, 2014

MaDenGo said:
btw , we didn't understand anything more explain and use

Code:

and add large pics please.[/QUOTE] +1....

anapse · Sep 30, 2014

MaDenGo said:
btw , we didn't understand anything more explain and use

Code:

and add large pics please.[/QUOTE] just needed to GOOOOOOOGLE I had not seen this anywhere thx

MaDenGo · Oct 1, 2014

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

thebigbody · Oct 1, 2014

there is no line in skill mastery , there is no table for Mastery_VIP , there is no skilleffect
there is nothing

fail topic :thumbdown:

bares1993 · Oct 1, 2014

thebigbody said:
there is no line in skill mastery , there is no table for Mastery_VIP , there is no skilleffect
there is nothing
fail topic :thumbdown:

+1

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

anapse · Oct 1, 2014

bares1993 said:
+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 · Oct 2, 2014

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 · Oct 3, 2014

bestprem said:
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 · Oct 3, 2014

bestprem said:
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

You must be registered to see links

abdo1020 · Oct 3, 2014

i didn't get it

thebigbody · Oct 3, 2014

abdo1020 said:
i didn't get it

cuz u r nooby

:

abdo1020 · Oct 3, 2014

thebigbody said:
cuz u r nooby :

yes get over it

AngelShade · Oct 5, 2014

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 · Oct 5, 2014

AngelShade said:
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 · Oct 6, 2014

AngelShade said:
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

Welcome!

skill`s VIP for 28 days Zeker example

anapse

Junior Spellweaver

MaDenGo

SilkRoad vSro Service

CandyQ

Newbie Spellweaver

anapse

Junior Spellweaver

MaDenGo

SilkRoad vSro Service

thebigbody

Skilled Illusionist

bares1993

Junior Spellweaver

anapse

Junior Spellweaver

bestprem

Newbie Spellweaver

thebigbody

Skilled Illusionist

anapse

Junior Spellweaver

abdo1020

Newbie Spellweaver

thebigbody

Skilled Illusionist

abdo1020

Newbie Spellweaver

AngelShade

Experienced Elementalist

NourAyman

(⌐■_■)

anapse

Junior Spellweaver

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor