Last edited by silkroadgamer; 16-05-14 at 01:20 PM.
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.
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?
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)
Last edited by IBlack; 03-08-15 at 07:50 AM.
Try by executing the SP directly from your SQL and teleport the char, see if it works.
good luckCode:EXEC [SRO_VT_SHARD].[dbo].[_ADD_AUTOEQUIP_GEAR] 'CharacterName', 7
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 usingCode:[_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 :<
Last edited by Chrysler; 27-09-15 at 08:59 PM.
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 ?
Where is @aemethod?
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