SRO_VT_SHARD.dbo._ADD_GM_GEAR
underlined why ?
Printable View
SRO_VT_SHARD.dbo._ADD_GM_GEAR
underlined why ?
Because you haven't add the _ADD_GM_GEAR SP in your SRO_VT_SHARD database?Quote:
Originally Posted by LeMbo
Good luck on that :):Quote:
Originally Posted by blacksheep25
Anyway i got the scroll working now (didn't know what was wrong, just did whole thing again from scratch and it worked. :huh:) But now i have a second problem Screenshot by Lightshot . I have placed the textdata from the txt to textdata_object but it doesn't show any text ingame. I assume you can't just dump the text data to the end of the txt? If so then where to put the text?
(btw sorry if my english sucks :/:)
there's funny thing about how textdata_object works, try slipping it in the middle, between ITEM_ lines that has similar usage. I always put new things in the middle of file never at the end. ;)Quote:
Originally Posted by Exelja
Btw, check also in your itemdata, see if the SN_XXXXX_TT_DESC thing matched to your textdata_object :)
In this case it should be "SN_ITEM_GM_GEAR_COUPON_TT_DESC" for ALL 3 times, and not separated between HA, LA, and GA.
good luck
And for you guys who enjoyed my stuff, my next one would be:
:ott1:Spoiler:
I usually add custom lines to the top of the file because its easy to know whats been added/changed and always seems to work no matter what and doesn't mess with anything.Quote:
Originally Posted by witchymoo
@witchymoo
Nice!, keep up the good work ;)
Ty for the help, i just had to change the place of the text few spaces backwards cuz br110 has different "language".Quote:
Originally Posted by witchymoo
@witchymoo Found a mistake you have made, you forgot to add in the check for seeing if a player has made a warlock character "darkstaff".
Fix is added in after @WPClass = 'STAFF'. Just add the extra bit in RED for the fix guys ;)Code:/* Update 2013/11/05 */
-- Set no shield by default, if the weapon used is 1H, then add shield automatically.
PRINT 'Checking if character is using shield...'
DECLARE @useShield TINYINT = 0
IF (@WPClass = 'SWORD' OR @WPClass = 'BLADE' OR @WPClass = 'STAFF' OR @WPClass = 'DARKSTAFF')
BEGIN
PRINT '- 1H weapon is used, new shield will be added.'
SET @useShield = 1
END
Ah yes, thanks for that fix, I forgot dark staff (warlocks) needed shield also :P
no it's added lol i am not noob :D
NOBODY ever said you are a noob ;) (lol too)Quote:
Originally Posted by LeMbo
Here you go, "Alternative new [Auto Equipment] sytem (Coupon OR automatic, your choice)" ;)Quote:
Originally Posted by blacksheep25
have fun ;)
Hi again, i got another problem (yay) with the scroll now (didn't do anything special after i got it working)... When i use the scroll i get tped to town like any scroll would do, inventory is cleaned but i don't have any items and when i teleport again i get stuck in loading screen. And if i just close the client when i'm stuck @ the loading screen, i can't login again unless i restart sql server.
(add exelja @ skype if you want to talk there)
Try clearing your inventory first directly from SQL, perhaps some of the item in the code are in disabled state or something.Quote:
Originally Posted by Exelja
The fastest way to clear character inventory:
Put your char ID there and run it.Code:USE [SRO_VT_SHARD]
GO
DECLARE @CharID INT = <YourCharIDHere>
DECLARE @TSlots INT = 0
DECLARE @CharSlot INT = 0
SELECT @TSlots = COUNT(Slot) from _Inventory WHERE CharID = @CharID
WHILE @CharSlot <= @TSlots
BEGIN
EXEC [_STRG_DEL_ITEM_NoTX] 1, @CharID, @CharSlot
SET @CharSlot = @CharSlot + 1
END
i make all step but when i open scroll nothing happen and i'm not see any item in my char
Run this, see if you got any error.Quote:
Originally Posted by xaviar
<degree> = item degreeCode:EXEC [SRO_VT_SHARD].[dbo].[_ADD_GM_GEAR] 'yourcharname', 'LIGHT', <degree>, <plus>
<plus> = item plus