Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

Worked Well ! Thanks ;)))

After using this many times, it always made my shardmanager go red. i don't recommend using it ^^

i got problem that i dont get any item / the copone and if i makeitem copone it didnt give me any thing i think here is the problem:
PRINT 'Validating race and gender...'
SET @CharRace = CASE
WHEN (@RefCharID BETWEEN 1907 AND 1919) OR (@RefCharID BETWEEN 1920 AND 1932) THEN 'CH' -- Chinese (vSRO/BR110)
WHEN (@RefCharID BETWEEN 14875 AND 14887) OR (@RefCharID BETWEEN 14888 AND 14900) THEN 'EU' -- Euro (vSRO)
WHEN (@RefCharID BETWEEN 14717 AND 14729) OR (@RefCharID BETWEEN 14730 AND 14742) THEN 'EU' -- Euro (BR110)

and my CharID is 7846 or 7845 or 7844) can u fix it for me with the correct charid?

https://forum.ragezone.com/cache.php...%2F2hfmi37.png

why?
edit:
weard it fixed it self...


_RefObjCommon
Code:
INSERT INTO _RefObjCommon VALUES (1,46030,'ITEM_EVENT_AUTOEQUIP_COUPON','???? ???? ??? (???)','xxx','SN_ITEM_EVENT_AUTOEQUIP_COUPON','SN_ITEM_GM_GEAR_COUPON_TT_DESC',1,0,3,3,3,1,180000,3,0,1,1,1,3,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\coupon_weapon.ddj','xxx','xxx',46030)


here is the problem that ppl say (why loading screen freeze...) so there was problem and it till there... (but if you check it even once you can see it)

Try by executing the SP directly from your SQL and teleport the char, see if it works.

Code:

---

EXEC [SRO_VT_SHARD].[dbo].[_ADD_AUTOEQUIP_GEAR] 'CharacterName', 7

---

good luck

scroll work but it isn't come to player automatically
i don't know what is the wrong

You need to make your own "delivery" system for it. I removed the query for automatic scroll delivery on level up because it might spike your server resources (say, 100+ players level up at same time, might burden the SQL)...

Safest way is to make some kind of trigger for it, for example, create a button in your website user panel to get auto equipment coupon, then deliver it to their storage using

Code:

---

[_ADD_ITEM_EXTERN_CHEST_FAST] <UserJID_here>, <ScrollItemID>, 1, 0

---

i made it by a message but i dont know how to make character take just on scroll on every DG
Because the system i made
every time i send a message i got 1 scroll
if you know how to make it
or if you have a webpage for this thing
i will be Grateful to you

I cant make this work.
It wont give me the items :<

thanks working fine

pleas say to me what I must add in _AddLogChar

Where is the "@AEMethod" in _AddLogChar? i dont find it

My _AddLogChar

Code:

---

ALTER  procedure [dbo].[_AddLogChar]
 @CharID                int,
 @eventID                tinyint,
 @Data1                int,
 @Data2                int,
@strPos                varchar(64),
 @desc                varchar(128)
as
        declare @Len_pos        int
        declare @Len_desc        int
        set @Len_pos = len(@strPos)
        set @Len_desc = len @desc)
        if  @Len_pos > 0 and @Len_desc > 0)
        begin       
                insert _LogEventChar values @CharID, GetDate(), @eventID, @Data1, @Data2, @strPos, @desc)       
        end
        else if  @Len_pos > 0 and @Len_desc = 0)
        begin       
                insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, EventPos) values @CharID, GetDate(), @eventID, @Data1, @Data2, @strPos)
        end
        else if  @Len_pos = 0 and @Len_desc > 0)
        begin       
                insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, strDesc) values @CharID, GetDate(), @eventID, @Data1, @Data2, @desc)
        end
        else
        begin
                insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2) values @CharID, GetDate(), @eventID, @Data1, @Data2)
        end

        IF (@Operation = 41) -- scroll is used
        BEGIN
                IF (@ItemRefID = 46030) -- Auto-equipment Coupon
                BEGIN
                        DECLARE @CharNameEQ VARCHAR(64) = (SELECT CharName16 from [SRO_VT_SHARD].[dbo].[_Char] WHERE CharID = @CharID)
                        EXEC [SRO_VT_SHARD].[dbo].[_ADD_AUTOEQUIP_GEAR] @CharNameEQ, 7
                END
        END

---

Hello, How are you. I would like to add, but it gives me some fear since I do not understand much English and I did not understand everything you wrote.

I would like you to make a video of how you add the auto equipment.

And how to change the items "NOVA" to items "NPC"

Thank you very much ;)

- - - Updated - - -

The module '_AddLogItem' depends on the missing object 'SRO_VT_SHARD.dbo._ADD_AUTOEQUIP_GEAR'. The module will still be created; however, it cannot run successfully until the object exists.

??? :(

working in CSRO-R ?

Quote:

---

Originally Posted by DiscoNinja

working in CSRO-R ?

---

Should work, if it doesn't just make sure the character "RefObjID" match with the ones in the procedure. You can find those ID's in the table "_RefCharGen" in SRO_VT_SHARD.