Re: "Just for fun - Nothing to do" GM gear coupon :P
SRO_VT_SHARD.dbo._ADD_GM_GEAR
underlined why ?
Re: "Just for fun - Nothing to do" GM gear coupon :P
Quote:
Originally Posted by
LeMbo
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?
Re: "Just for fun - Nothing to do" GM gear coupon :P
Quote:
Originally Posted by
blacksheep25
No problem, Im actually going through Every single procedure in all the released databases to improve the 110 blackrogue database as much as I can, Goal is to make a stable, clean and nice feature database for everyone on Ragezone making a blackrogue server.
Good luck on that :):
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 :/:)
Re: "Just for fun - Nothing to do" GM gear coupon :P
Quote:
Originally Posted by
Exelja
Good luck on that :):
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. ;)
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:
Re: "Just for fun - Nothing to do" GM gear coupon :P
Quote:
Originally Posted by
witchymoo
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. ;)
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.
@witchymoo
Nice!, keep up the good work ;)
Re: "Just for fun - Nothing to do" GM gear coupon :P
Quote:
Originally Posted by
witchymoo
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.
Ty for the help, i just had to change the place of the text few spaces backwards cuz br110 has different "language".
Re: "Just for fun - Nothing to do" GM gear coupon :P
@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".
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
Fix is added in after @WPClass = 'STAFF'. Just add the extra bit in RED for the fix guys ;)
Re: "Just for fun - Nothing to do" GM gear coupon :P
Ah yes, thanks for that fix, I forgot dark staff (warlocks) needed shield also :P
Re: "Just for fun - Nothing to do" GM gear coupon :P
no it's added lol i am not noob :D
Re: "Just for fun - Nothing to do" GM gear coupon :P
Quote:
Originally Posted by
LeMbo
no it's added lol i am not noob :D
NOBODY ever said you are a noob ;) (lol too)
Quote:
Originally Posted by
blacksheep25
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.
@witchymoo
Nice!, keep up the good work ;)
Here you go, "Alternative new [Auto Equipment] sytem (Coupon OR automatic, your choice)" ;)
have fun ;)
Re: "Just for fun - Nothing to do" GM gear coupon :P
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)
Re: "Just for fun - Nothing to do" GM gear coupon :P
Quote:
Originally Posted by
Exelja
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.
Re: "Just for fun - Nothing to do" GM gear coupon :P
The fastest way to clear character inventory:
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
Put your char ID there and run it.
Re: "Just for fun - Nothing to do" GM gear coupon :P
i make all step but when i open scroll nothing happen and i'm not see any item in my char
Re: "Just for fun - Nothing to do" GM gear coupon :P
Quote:
Originally Posted by
xaviar
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.
Code:
EXEC [SRO_VT_SHARD].[dbo].[_ADD_GM_GEAR] 'yourcharname', 'LIGHT', <degree>, <plus>
<degree> = item degree
<plus> = item plus