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

[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 :|

[Blacksheep25]

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.

[gamal665]

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


[IMG][/IMG]

[GusToma]

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

[GusToma]

Thx Worked fine

i was testing it on GM Char :D

but it Working fine at Normal char thx <3

[ipod4touch]

Worked Well ! Thanks ;)))

[Tyr]

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

[ofek4003]

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?

[IBlack]

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)

[Witchy Moo]

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

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

good luck

[GM Offander]

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

[Witchy Moo]

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

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

[GM Offander]

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

[Chrysler]

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

[elfraon5]

thanks working fine

[Hossney]

pleas say to me what I must add in _AddLogChar

[VzlaR]

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

My _AddLogChar

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

[ThiqT]

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.

??? :(

[DiscoNinja]

working in CSRO-R ?

[Blacksheep25]

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.

[swo]

Where is @aemethod?

[ThiqT]

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

Where is it placed?

[mana1416]

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

[namcan9x]

i can not see addlogchar