[Release] Comatose's Mastery scroll

Page 2 of 2 1 2
09/24/2014 02:09 ipause#16
what should it do
08/31/2015 21:11 thebigbody#17
first that's only CH
second well i guess it's missing one thing to check if the char is already have max mastery
otherwise anyone will be able to open all skills :)

NOTE : edit your addlogchar proc to your proc name "_ADD_SKILL_MASTERY"
08/31/2015 21:56 Crue*#18
Quote:
Originally Posted by thebigbody View Post
first that's only CH
second well i guess it's missing one thing to check if the char is already have max mastery
otherwise anyone will be able to open all skills :)

NOTE : edit your addlogchar proc to your proc name "_ADD_SKILL_MASTERY"
3rd it's too old topic, did you even read the date?
09/01/2015 02:23 thebigbody#19
Quote:
Originally Posted by Crue* View Post
3rd it's too old topic, did you even read the date?
it's about 1.5 year and that's for other ppl who will try to look for scroll like these " like i did " will be easier for them to see some wrong staff ... iam just saying
09/01/2015 14:21 desal12533#20
Quote:
Originally Posted by bestprem View Post
(Create)

#Proc
PHP Code:
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_ADD_ITEM_SKILL]    Script Date: 03/23/2014 08:56:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/*##### By Kiro #####*/
/*##### By Kiro #####*/
create proc [dbo].[_ADD_SKILL_MASTERY]  /*##### By Kiro #####*/
@ChID  int,
@id2    int
as
DECLARE @USERJID int 
declare @CharID int
declare @NewUserID varchar
declare @ItemID    bigint 
declare @RefItemID int
declare @CharName varchar(max) 
DECLARE @RefCharID INT
/*##### By Kiro #####*/                                        
/*##### By Kiro #####*/
        declare @skilllvl  int 
        set @skilllvl = '80'

     if (@id2 = 1)
        begin

        set @charname = (select CharName16  from _Char where CharID=@ChID)
        SELECT @CharID = CharID, @RefCharID = RefObjID FROM [_Char] WHERE CharName16 = @CharName
    update _CharSkillMastery set [Level] = @skilllvl where ((MasteryID = 257  ) and CharID =  @CharID) --blade 
    end/*##### By Kiro #####*/
    
    
    else if (@id2 = 2)
        begin
        set @charname = (select CharName16  from _Char where CharID=@ChID)
        SELECT @CharID = CharID, @RefCharID = RefObjID FROM [_Char] WHERE CharName16 = @CharName
    update _CharSkillMastery set [Level] = @skilllvl where ((MasteryID = 258  ) and CharID =  @CharID) --glaive 
    end/*##### By Kiro #####*/
    
    else if (@id2 = 3)
        begin
        set @charname = (select CharName16  from _Char where CharID=@ChID)
        SELECT @CharID = CharID, @RefCharID = RefObjID FROM [_Char] WHERE CharName16 = @CharName
    update _CharSkillMastery set [Level] = @skilllvl where ((MasteryID = 259  ) and CharID =  @CharID) --bow 
    end/*##### By Kiro #####*/
    
    else if (@id2 = 4)
        begin
        set @charname = (select CharName16  from _Char where CharID=@ChID)
        SELECT @CharID = CharID, @RefCharID = RefObjID FROM [_Char] WHERE CharName16 = @CharName
    update _CharSkillMastery set [Level] = @skilllvl where ((MasteryID = 273  ) and CharID =  @CharID) --force recovery 
    end/*##### By Kiro #####*/
    
        else if (@id2 = 5)
        begin
        set @charname = (select CharName16  from _Char where CharID=@ChID)
        SELECT @CharID = CharID, @RefCharID = RefObjID FROM [_Char] WHERE CharName16 = @CharName
    update _CharSkillMastery set [Level] = @skilllvl where ((MasteryID = 274) and CharID =  @CharID) --force recovery 
    end/*##### By Kiro #####*/
    
        else if (@id2 = 6)
        begin
        set @charname = (select CharName16  from _Char where CharID=@ChID)
        SELECT @CharID = CharID, @RefCharID = RefObjID FROM [_Char] WHERE CharName16 = @CharName
    update _CharSkillMastery set [Level] = @skilllvl where ((MasteryID = 275  ) and CharID =  @CharID) --force recovery 
    end/*##### By Kiro #####*/
    
    
    
    else if (@id2 = 7)
        begin
        set @charname = (select CharName16  from _Char where CharID=@ChID)
        SELECT @CharID = CharID, @RefCharID = RefObjID FROM [_Char] WHERE CharName16 = @CharName
    update _CharSkillMastery set [Level] = @skilllvl where ((MasteryID = 276  ) and CharID =  @CharID) --recovery 
    end/*##### By Kiro #####*/
        
/*##### By Kiro #####*/
/*##### By Kiro #####*/
/*##### By Kiro #####*/ 
(Old proc)

#AddLogItem (ShardLog) Procedure
PHP Code:
IF (@Operation = 41) -- skill scroll
        begin
          IF (@ItemRefID = 47374) -- ID ITEM
            begin
                exec SRO_VT_SHARD.dbo._ADD_ITEM_SKILL @CharID,1
        end
              IF (@ItemRefID = 47375) -- ID ITEM
            begin
                exec SRO_VT_SHARD.dbo._ADD_ITEM_SKILL @CharID,2
        end
                begin
          IF (@ItemRefID = 47376) -- ID ITEM
            begin
                exec SRO_VT_SHARD.dbo._ADD_ITEM_SKILL @CharID,3
                end
        end
                begin
          IF (@ItemRefID = 47377) -- ID ITEM
            begin
                exec SRO_VT_SHARD.dbo._ADD_ITEM_SKILL @CharID,4
                end
        end
                begin
          IF (@ItemRefID = 47378) -- ID ITEM
            begin
                exec SRO_VT_SHARD.dbo._ADD_ITEM_SKILL @CharID,5
                end
        end
          IF (@ItemRefID = 47379) -- ID ITEM
            begin
                exec SRO_VT_SHARD.dbo._ADD_ITEM_SKILL @CharID,6
                end
        end
          IF (@ItemRefID = 47380) -- ID ITEM
            begin
                exec SRO_VT_SHARD.dbo._ADD_ITEM_SKILL @CharID,7
                end
        end

        end 

Notice Create scroll lines by ur self copy it from [Only registered and activated users can see links. Click Here To Register...]


Good Job But why it will change the lvl of the skills only
It will not Upgrade the skills to max lvl i mean the mastery lvl not the lvl of skills
05/02/2018 14:15 Boodeali#21
Ty
05/09/2018 19:11 emirhanemir#22
it is creating problems :/
05/10/2018 13:54 ScarOnline#23
nice work mate, thank you
Page 2 of 2 1 2