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

Quote:

---

Originally Posted by silkroadgamer

I found a problem. When a character reach certain lv (for example 13) then that character got item. But when I down that character lvl back to 12 then up it lvl again to 13 -> The Shard_Manager will crash!. So how to fix this problem?

---

Fixed. But I have another problem from it. When my character back to certain lvl (example 13) it will get another coupon at lvl 13 again :|

WitchyMoo is no longer in the SRO Scene or active on RZ or EPVP so you won't get any support from her anymore however the issues you guys have been having can be easily fixed.

hey dude thnx for your gr8 work but i faced this hope you can help me ^^


[IMG]http://s23.postimg.org/5hkwbwfl7/SRO...1_44_53_86.jpg[/IMG]

hello every thing working fine

but when i reach lvl 14 for example

i didn`t get any thing

but when i get the scroll from Consol /makeitem

and use it i get the item !! what can i do about that ?

sorry for my english

Thx Worked fine

i was testing it on GM Char :D

but it Working fine at Normal char thx <3

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.

Where is @aemethod?

Quote:

---

Originally Posted by CoderWaxy

if DECLARE @AEMethod INT = 2 = Working
if DECLARE @AEMethod INT = 1 = Not Working

---

Where is it placed?

I HAVE PROBLEM AUTO EQUIP NOT WORK _AddLogChar CANN NOT ADD THIS
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

i can not see addlogchar