"Just for fun - Nothing to do" GM gear coupon :P

I already tried that withchymoo. I have every single 'A_Rare' item which is seal of star from degree 1 to 10 perfectly enabled and working. Only thing is, with this SP it would only work with degree 10 or higher like 11. Just not under 10. If i try 9 or 8 or 7 it just gives me something wrong with the item id reference link. But if i add the item manually in game , it works fine.

Ive uploaded pics to show that i have all 01 degree sos enabled , ive also check the devil and avatar. Changed the gm uniform from 'item_etc_avatar_gm_uniform_ to item_mall_avatar , so i did change what was needed.

i know the pics shows me doing the Heavy instead of light , but i did check for heavy and its all enabled as well. IF i do change the degree to 10 , the script works just fine no issue whats so ever.

Attachment 141273Attachment 141271Attachment 141272Attachment 141270

OH, I understand your problem... it's the "leading 0" problem on number below "10", you did put something like:

"EXEC _ADD_GM_GEAR 'yourname', 'CLOTHES', 7, 12" <-- "7" = degree, right?

And of course, the item is NOT "ITEM_CH_BLADE_7_A_RARE"... but it should be "ITEM_CH_BLADE_07_A_RARE" (with 0)

Yes that's my mistake, forgot to add leading "0" to single digit, thanks for trying and informing, well, here's the fix:

edit the _ADD_GM_GEAR SP, find this line:

Code:

---

    -- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

    SET NOCOUNT ON

---

And replace with this:

Code:

---

    -- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

    SET NOCOUNT ON

    /* Update 2013/11/28 - Add leading '0' to single digit degree */
    SET @EQDegree = CASE WHEN CAST(@EQDegree AS INT) < 10 AND LEFT(@EQDegree,1) NOT LIKE '[0]' THEN '0' + @EQDegree ELSE @EQDegree END

---

Save, Re-run the SP, and try executing with single digit degree like:

Code:

---

EXEC [_ADD_GM_GEAR] 'yourchar', 'LIGHT', 9, 12

---

See if it works now ;)

cheers

PS: I updated the SP attachment on first page also ;)

Yes now works :P , thnkx ^.^ , i knew i wasnt going crazy :). Bah i need to learn sql more lol.

and yeah i did put '7' , but i also tried '07' and it was same thing. But you're update fixed it so now its all good ^.^

Quote:

---

Originally Posted by witchymoo

You can run it with EXEC [dbo].[_ADD_GM_GEAR] 'charname', 'TYPE', <degree>, <plus> <-- put degree 9 or 8 or something, it doesn't matter as long as the representative code exists, it works ;)



Yes, thank you for this, but where's the fix? you forgot to put comments on the lines you modified :P

Or was it the remark on GM check sequence?

---

Char Ref ID's were different in the 110 Blackrogue files, so i had to modify them in the procedure for it to know what character you were using to give you the items.

Quote:

---

Originally Posted by blacksheep25

Char Ref ID's were different in the 110 Blackrogue files, so i had to modify them in the procedure for it to know what character you were using to give you the items.

---

what was different ? o.O im using same files. Havent found any issue apart from what i have posted here

Quote:

---

Originally Posted by P0kemonMast

Yes now works :P , thnkx ^.^ , i knew i wasnt going crazy :). Bah i need to learn sql more lol.

and yeah i did put '7' , but i also tried '07' and it was same thing. But you're update fixed it so now its all good ^.^

---

Excellent :), nice work, btw without my update you can make it work though, see the data type of "@EQDegree" in the SP, it's VARCHAR(2) not INT, means even without the update, you can run correctly from SQL window: EXEC _ADD_GM_GEAR 'yourchar', 'LIGHT', '07', 12 <-- put '07' (with ' ') instead of 07.

cheers

Quote:

---

Originally Posted by blacksheep25

Char Ref ID's were different in the 110 Blackrogue files, so i had to modify them in the procedure for it to know what character you were using to give you the items.

---

Well, I did made it on vsro 188, but if @RefCharID in BR files are different, what's the RefCharID for Chinesse Male, Chinesse Female, Euro Male, and Euro Female on BR110 db? perhaps i can combine it so it will work on your BR server without breaking it's original function to work on vsro 188.

thanks

Quote:

---

Originally Posted by P0kemonMast

what was different ? o.O im using same files. Havent found any issue apart from what i have posted here

---

Euro characters werent getting anything because the RefChar ID's are wrong, so without my fixed proc it shouldnt of worked for you.

Quote:

---

Originally Posted by blacksheep25

Euro characters werent getting anything because the RefChar ID's are wrong, so without my fixed proc it shouldnt of worked for you.

---

Well i never did try with euro's. But thanx for that update of the char id. Changed it alrdy in mines :p

Excellent, I got your PM about RefCharID, it's the same for chinese chars, but different on euro, i'll update the SP attachment now to make it work on both vSRO and BR110. Thanks a lot for your info

cheers

--

Alright, this is the update: (Attachment on first page also updated)

Find these lines:

Code:

---

    IF (@RefCharID BETWEEN 14875 AND 14887) -- European Male
    BEGIN
        SET @CharRace = 'EU'
        SET @CharGender = 'M'
    END
    IF (@RefCharID BETWEEN 14888 AND 14900) -- European Female
    BEGIN
        SET @CharRace = 'EU'
        SET @CharGender = 'W'
    END

---

And change to this:

Code:

---

    IF (@RefCharID BETWEEN 14875 AND 14887) -- European Male (vSRO)
    OR (@RefCharID BETWEEN 14717 AND 14729) -- European Male (BR110)
    BEGIN
        SET @CharRace = 'EU'
        SET @CharGender = 'M'
    END
    IF (@RefCharID BETWEEN 14888 AND 14900) -- European Female (vSRO)
    OR (@RefCharID BETWEEN 14730 AND 14742) -- European Female (BR110)
    BEGIN
        SET @CharRace = 'EU'
        SET @CharGender = 'W'
    END

---

Thanks to you both, now it should work for Euro Char on both vSRO and BR110 db :)

Quote:

---

Originally Posted by blacksheep25

Yeah i uncommented that and its now logging correctly

---

How did you get it working on br110 files? I Just can't get the scroll work. Logs work fine, the query works fine but the scroll just doesn't work...:?: (Also i couldn't figure out where to put the textdata_object lines at the txt)

Screens: Screenshot by Lightshot Screenshot by Lightshot

SRO_VT_SHARD.dbo._ADD_GM_GEAR
underlined why ?

Quote:

---

Originally Posted by Exelja

How did you get it working on br110 files? I Just can't get the scroll work. Logs work fine, the query works fine but the scroll just doesn't work...:?: (Also i couldn't figure out where to put the textdata_object lines at the txt)

Screens: Screenshot by Lightshot Screenshot by Lightshot

---

Well according to the 2nd screenshot you posted there its working when using the command to give you the gear, but your saying when your using the scroll your just getting teleported and getting no items?

The only problem i still have which i cant be bothered to fix at the moment is the scroll will work when giving 1D-10D set but will not give you a higher set than 10D. Try going to _ADD_GM_GEAR procedure and making the gear suffix

Code:

---

DECLARE @GearSuffix VARCHAR(16) = 'C_RARE'

---

And then try and use the scroll and see if it works.

By the way, if you want to delete your characters properly from your account in blackrogue if your doing alot of testing here's a fixed procedure for _DeleteCharPermanently_NoTX.

Code:

---

USE [BR_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_DeleteCharPermanently_NoTX]    Script Date: 11/29/2013 08:54:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

--------------------------------------------------------------------------------------------------------------------------
-- PROC #5
-- _DeleteCharPermanently ?????????? ???????? ?????? ?????? ?????? ?????????? ?????? ???? ?????? ?????? ????! - by zone0000 (??????)
--------------------------------------------------------------------------------------------------------------------------
ALTER  PROCEDURE [dbo].[_DeleteCharPermanently_NoTX]
        @UserJID        int,
        @CharID        int
as
        ------------------------------------
        -- Inventory?? ?????? ?????? ???? ???????? ??????????...
        ------------------------------------
        -------------- ?? ???? ?????????? ???? ???? ----------------
        declare @result int
        declare @Slot tinyint
        declare @RefItemID int
       
        declare pc_inv_cursor cursor fast_forward for
        select inv.slot
        from _Inventory as inv join _Items as it on inv.ItemID = it.ID64
        where
        (inv.CharID = @CharID and inv.Slot >= 13 and inv.ItemID > 0) and        -- ?????? ???????? ?????? ???? ???? ???????? ???? ??????????
        (it.Data <> 0)                                                                                          and        -- ???????? ?????? ????
        (exists (select top 1 ID from _RefObjCommon where ID = it.RefItemID and TypeID1 = 3 and TypeID2 = 2)) -- ?????? ???????? ??????~
       
        open pc_inv_cursor
        fetch next from pc_inv_cursor  into @slot
        while @@fetch_status = 0
        begin
                        exec @result = _STRG_DEL_ITEM_NoTX 1, @CharID, @Slot       
                        if (@result < 0)
                        begin
                                close pc_inv_cursor
                                deallocate pc_inv_cursor
                                return @result
                        end
                                               
                        fetch next from pc_inv_cursor  into @Slot
        end
       
        close pc_inv_cursor
        deallocate pc_inv_cursor
        ------------------- ???? ???????? ???? ????  -------------------
        -- ???????? ???????? ??????...
        if (exists (select top 1 itemID from _Inventory where CharID = @CharID AND ItemID <> 0))
        begin
                update _ItemPool Set InUse = 0
                from _ItemPool as pool join _Inventory as inv on pool.ItemID = Inv.ItemID
                where Inv.CharID = @CharID and Inv.ItemID <> 0
        end
        ----------- ???????? ???????? ?????????? ???????? ????  ------------
        delete from _Inventory where CharID = @CharID
        if (@@error <> 0)
        begin
                return -10001
        end

        --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        --                APPLY_AVATAR_SYSTEM (??????)
        --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

        ------------------- ???? ?????? ???????? ???????? ???? ????  -------------------
        -- ???????? ???????? ??????...
        if (exists (select top 1 itemID from _InventoryForAvatar where CharID = @CharID AND ItemID <> 0))
        begin
                update _ItemPool Set InUse = 0
                from _ItemPool as pool join _InventoryForAvatar as InvAva on pool.ItemID = InvAva.ItemID
                where InvAva.CharID = @CharID and InvAva.ItemID <> 0
        end
        ----------- ???????? ???????? ?????????? ?????? ???????? ????  ------------
        delete from _InventoryForAvatar where CharID = @CharID
        if (@@error <> 0)
        begin
                return -10008
        end

        --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        --                APPLY_AVATAR_SYSTEM (??????)
        --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

        ------------------------------------
        -- COS ????
        ------------------------------------
/*
        declare @engaged_cos int
        set @engaged_cos = 0
        select @engaged_cos = EngagedCOS from _char with (nolock) where CharID = @CharID
       
        if (@engaged_cos = 0)
        begin
                -- ?? ???????? ?? ?? ??????????... ???? ?????? COS ?? ???????? ?????? ????????... -_-;
                select @engaged_cos = ID from _CharCOS with (nolock) where OwnerCharID = @CharID
                if (@engaged_cos is null)
                        set @engaged_cos = 0
        end
        if (@engaged_cos is not null and @engaged_cos <> 0)
        begin
                declare @Return_Del_COS int
                exec @Return_Del_COS = _DeleteCharCOS_NoTX  @CharID, @engaged_cos
                if (@Return_Del_COS < 0)
                begin
                        return -10002
                end
        end
*/

        ------------------------------------
        -- TrijobSafeTrade ?????? ????
        ------------------------------------
        delete from _CharTrijobSafeTrade where CharID = @CharID

        ------------------------------------
        -- Trijob ?????? ????
        ------------------------------------
        delete from _CharTrijob where CharID = @CharID
        ------------------------------------
        -- ???? ????
        ------------------------------------
        delete _CharSkill where CharId = @CharID
        delete _CharSkillMastery where charId = @CharID
        ------------------------------------
        -- ?????? ????
        ------------------------------------
        delete _CharQuest where CharID = @CharID
        ------------------------------------
        -- ???? ???? ????
        ------------------------------------
        -- !!! ???? ?????? Guild ???? ?????? ???????? ?????? ShardManager ????
        -- _Guild_DelMember ?????? ?????? ???????? ????! ?????? ?? ?????? Skip????
        -- ?????????? ?????? ???????? ???? ??????...
        declare @GuildID int
        set @GuildID = 0
        select @GuildID = GuildID from _char where charid = @CharID
        if (@GuildID is not null and @GuildID <> 0)
        begin
                if (not exists (select ID from _Guild where ID = @GuildID))
                begin
                        update _Char set GuildID = 0 where CharID = @CharID
                end
                else
                begin
                        declare @Return_Del_GuildMember int
                        exec @Return_Del_GuildMember = _Guild_DelMember_NoTX @GuildID, @CharID
                        if (@Return_Del_GuildMember < 0)
                                return -10003
                end
        end

        --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        --                APPLY_MENTOR_SYSTEM (??????)
        --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        DECLARE @CampID INT
        SET @CampID = 0
        SELECT @CampID = CampID FROM _TrainingCampMember WHERE CharID = @CharID
        IF (@CampID IS NOT NULL AND @CampID <> 0)
        BEGIN
                DECLARE @Ret_DelCampMember INT
                EXEC @Ret_DelCampMember = _TRAINING_CAMP_DELMEMBER @CampID, @CharID, 0
                IF (@Ret_DelCampMember < 0)
                        RETURN -10007
        END

        -- ?????? ??????????~ ??.
        DELETE FROM _TrainingCampSubMentorHonorPoint WHERE CharID = @CharID

        -- ?????? ???? ????????~~ ????
        DELETE FROM _TrainingCampBuffStatus WHERE CampID = @CampID

        --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        --                APPLY_MENTOR_SYSTEM (??????)
        --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

        -----------------------------------
        -- ???? ?????? ???? ( ???? ???? ?????? + ?????? ???? ???????? ?? )
        -----------------------------------
        -- ?? ??????..
        declare @FriendCharID        int
        declare @cursor_var        cursor
       
        set @cursor_var = cursor fast_forward
        for
        select FriendCharID
        from _Friend
        where CharID = @CharID
       
        open @cursor_var
       
        fetch next from @cursor_var into @FriendCharID
       
        while( @@FETCH_STATUS = 0 )
        begin
                delete _Friend where CharID = @FriendCharID and FriendCharID = @CharID
       
                fetch next from @cursor_var into @FriendCharID
        end
        close @cursor_var
        deallocate @cursor_var
        -- ??..
        delete _Friend where CharID = @CharID
        -----------------------------------
        -- ???? ????
        -----------------------------------
        delete _Memo where CharID = @CharID
        ------------------------------------
        -- TimedJob ????????
        ------------------------------------
        delete _TimedJob where CharID = @CharID
        ------------------------------------
        -- Static Avatar ???? ????
        ------------------------------------       
        delete from _staticavatar where charid = @charid
        ------------------------------------
        -- ฑำธป บํทฐ มคบธ ป่มฆ
        ------------------------------------       
        delete from _BlockedWhisperers where OwnerID = @charid


-- 2010-05-10 Rs1017 ร฿ฐก
        ------------------------------------
        -- CharCos ป่มฆ
        ------------------------------------

        UPDATE _ItemPool
        SET InUse = 0
        FROM _ItemPool AS pool
        JOIN _InvCOS AS inv
        ON pool.ItemID = Inv.ItemID
        join _CharCos as ccos
        on ccos.ID = Inv.CosID
        WHERE ccos.OwnerCharID = @charid and Inv.ItemID <> 0

        DELETE FROM _InvCOS where COSID in ( select ID from _CharCos where OwnerCharID = @charid )

        delete from _CharCos where OwnerCharId = @charid

        ------------------------------------
        -- _DeletedChar Entry ป่มฆ
        ------------------------------------
        delete from _DeletedChar where CharID = @CharID
        if (@@error <> 0)
        begin
                return -10004
        end
        -- start by novice.
        DELETE FROM _User WHERE UserJID = @UserJID and CharID = @CharID
        -- finish by novice.
        ------------------------------------
        -- ?????? ???? ????
        ------------------------------------
        delete _Char where CharID = @CharID
        if (@@error <> 0)
        begin
                return -10006
        end
       
        delete _CharNameList where CharID = @CharID

        ------------------------------------
        -- commit !!!
        ------------------------------------
       
        -- ???????????? ?????? ???? ???? ?????? ??????!!!
        exec _RemoveClientConfig @CharID                -- by novice...... for saving client configurations...
        return @GuildID

---

* What was missing from this proc? Ill mark it in RED. This procedure had missing a part which would free the name used on that character after it was deleted. Now you will beable to permanently delete a character and use that name again

Then all you need to do is exec the procedure like this.

exec _DeleteCharPermanently_NoTX @UserJID, @CharID

example: exec _DeleteCharPermanently_NoTX 1, 7301

Excellent, what your marked as red is something that also missing from vSRO 1.88 SP, thank you ;)

No problem, Im actually going through Every single procedure in all the released databases to improve the 110 blackrogue database as much as I can, Goal is to make a stable, clean and nice feature database for everyone on Ragezone making a blackrogue server.

If anyone has a unreleased database and doesn't mind sharing the procedures for it send me a pm ;)

I'm doing the same for vSRO 1.88, most of the SP full of junk and dirty codes :P, need a lill tweak