Gösterim Stili 30 günlük başlangiç rünleri

[by_coder]

Arkadaşlar daha önçe verdigim slq kodunu 30 günlük rünler için geçerliydi çanta kilidi aşırı rün ekipman rünü

bu verçegim kod tüm rünleri içeriyor altin madeni depo rünü ekipman rünü aşırı rünü ve diger gereken rünler
USE [PS_GameData] GO /****** Object: StoredProcedure [dbo].[usp_Read_Char_ApplySkills_R] by player1up psudo code ( what the code does in laymans terms ): 1. Applies skills during toon login when the skills for the toon are read by the login procedure. 2. Checks to see if the skill is already applied. b. if skill is applied, reset the timer to full term. c. if skill is not applied, add it. 3. Returns the applied skills ( including ones we just added ) to the client Comments at the begining of the section describe what is being added. If your skill table is different than mine, you will need to adjust the skillid's to match what is in YOUR database table. If you don't want the skill added, add -- in front of each line of the section, or add /* at the begining of the section and */ at the end In a SQL query window, items that will not be executed have green as the font color. These comments will not be added to your database stored procedure as comments unless you include them below the line that starts with Alter Proc Happy gaming! --player1up ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER Proc [dbo].[usp_Read_Char_ApplySkills_R] @CharID int AS SET NOCOUNT ON ---add conti if exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=286 and skilllevel=1) begin update charapplyskills set LeftResettime=2592000 where CharID=@charID and skillid=286 end if not exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=286) begin insert into CharApplySkills (CharID, SkillID, SkillLevel,LeftResetTime) Values (@CharID, 286,1,2592000) end ---end conti ---add eternal endurance if exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=224 and skilllevel=1) begin update charapplyskills set LeftResettime=604800 where CharID=@charID and skillid=224 end if not exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=224) begin insert into CharApplySkills (CharID, SkillID, SkillLevel,LeftResetTime) Values (@CharID, 224,1,604800) end ---end eternal endurance ---add PID if exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=226 and skilllevel=1) begin update charapplyskills set LeftResettime=604800 where CharID=@charID and skillid=226 end if not exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=226) begin insert into CharApplySkills (CharID, SkillID, SkillLevel,LeftResetTime) Values (@CharID, 226,1,604800) end ---end PID ---add PEID if exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=236 and skilllevel=1) begin update charapplyskills set LeftResettime=2592000 where CharID=@charID and skillid=236 end if not exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=236) begin insert into CharApplySkills (CharID, SkillID, SkillLevel,LeftResetTime) Values (@CharID, 236,1,2592000) end ---end PEID ---add large gold drop if exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=235 and skilllevel=1) begin update charapplyskills set LeftResettime=2592000 where CharID=@charID and skillid=235 end if not exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=235) begin insert into CharApplySkills (CharID, SkillID, SkillLevel,LeftResetTime) Values (@CharID, 235,1,2592000) end ---end large gold drop ---add red phoenix charm if exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=233 and skilllevel=1) begin update charapplyskills set LeftResettime=2592000 where CharID=@charID and skillid=233 end if not exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=233) begin insert into CharApplySkills (CharID, SkillID, SkillLevel,LeftResetTime) Values (@CharID, 233,1,2592000) end ---end red phoenix charm ---add double warehouse if exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=234 and skilllevel=1) begin update charapplyskills set LeftResettime=2592000 where CharID=@charID and skillid=234 end if not exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=234) begin insert into CharApplySkills (CharID, SkillID, SkillLevel,LeftResetTime) Values (@CharID, 234,1,2592000) end ---end double warehouse SELECT SkillID,SkillLevel,LeftResetTime FROM CharApplySkills WHERE CharID=@CharID SET NOCOUNT OFF