skill`s VIP for 28 days Zeker example
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://s2.subirimagenes.com/fondosyc...0-14125014.jpg
http://www.subirimagenes.com/fondosy...2-9095506.html
http://s2.subirimagenes.com/fondosyc...3-03441417.jpg
http://www.subirimagenes.com/fondosy...7-9095515.html
http://s2.subirimagenes.com/fondosyc...3-03174363.jpg
http://www.subirimagenes.com/fondosy...3-9095518.html
THX RAGEZONE
Re: skill`s VIP for 28 days Zeker example
btw , we didn't understand anything :) more explain and use [CODE] and add large pics please.
Re: skill`s VIP for 28 days Zeker example
Quote:
Originally Posted by
MaDenGo
btw , we didn't understand anything :) more explain and use [CODE] and add large pics please.
+1....
Re: skill`s VIP for 28 days Zeker example
Quote:
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
Re: skill`s VIP for 28 days Zeker example
You missing _Mastery_Vip table
and about new mastery there is no lines on Skillmastery :?:
Re: skill`s VIP for 28 days Zeker example
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 :thumbdown:
Re: skill`s VIP for 28 days Zeker example
Quote:
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 :thumbdown:
+1
@anapse.....
If you release something....than make full release pls
Re: skill`s VIP for 28 days Zeker example
Quote:
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
Re: skill`s VIP for 28 days Zeker example
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
Re: skill`s VIP for 28 days Zeker example
Quote:
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 :):
Re: skill`s VIP for 28 days Zeker example
Quote:
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
http://www.subirimagenes.com/imageda...980mastery.jpg
Re: skill`s VIP for 28 days Zeker example
Re: skill`s VIP for 28 days Zeker example
Quote:
Originally Posted by
abdo1020
i didn't get it
cuz u r nooby :P:
Re: skill`s VIP for 28 days Zeker example
Quote:
Originally Posted by
thebigbody
cuz u r nooby :P:
yes get over it
Re: skill`s VIP for 28 days Zeker example
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.
