When you use the item is it teleporting you? and when your using the query what does the log say?
When you use the item is it teleporting you? and when your using the query what does the log say?
when use itemOriginally Posted by blacksheep25
then, use the query, not work.
if close GS, Query work
Details?
Writing it as "work", "not work", bla bla... didn't explain the problem.
when i teleport i cant find the scroll!
any solution ?
Query Working Fine!
But Automatic not ANd Scroll Not Working
not working anymore!
Fixed !
Screenshot by Lightshot
You will always get problems if you're only doing copy-paste-and-use-then-complaint without learning about it on your own. You disrespect many authors by doing that since most of them put comments inside their scripts for others to read.
Last edited by Witchy Moo; 08-12-13 at 08:29 AM.
^^ I will try again
i use this
EXEC _ADD_AUTOEQUIP_GEAR 'yourchar', plus
and get this result
Validating Character...
Validating Account ID...
Validating race and gender...
Race code is: CH, gender code is: M.
Character/Mastery Level: 2, degree: 01. (Level are current +1)
Validating equipped weapon...
Weapon is: BOW.
Checking if character is using shield...
Validating current gear...
Gear type is: CLOTHES.
Setting up item codenames...
Getting item reference ID and link...
Getting items durability information...
Removing equipped items...
Adding new items...
- Helm equipped.
- Chest equipped.
- Shoulder equipped.
- Gauntlet equipped.
- Pants equipped.
- Boots equipped.
- Earring equipped.
- Necklace equipped.
- Left Ring equipped.
- Right Ring equipped.
- Weapon equipped.
- Arrow/Bolt equipped.
Updating gear attributes to +6 FB (Str/Int 7, Parry 60%, Durability 200%)
- Adding extra blue attributes to Chest: HP recovery/MP recovery 210%
Updating accessory attributes to +6 FB (Str/Int 7, Freeze 20%, Electric Shock 20%, Burn 20%, Poison 20%, Zombie 20%)
- Adding extra blue attributes to Earring: CombustionProbability 50% Reduce, SleepProbability 50% Reduce
- Adding extra blue attributes to Necklace: StunProbability 50% Reduce
- Adding extra blue attributes to Rings: DiseaseProbability 25% Reduce, FearProbability 25% Reduce
Updating weapon attributes to +6 FB (Str/Int 7, Block 100, Attack Rate 60%, Durability 200%)
- Adding extra blue attributes to Weapon: Critical 3
Sequence complete.
what now i can do to fix problem when i get lvl 57 examble and teleport i am system Auto when teleport same items i wear no changes
what i should Do ?
and here any prob
-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- @@@ BEGIN: SETTINGS
-- CHANGE THIS! -- CHANGE THIS! -- CHANGE THIS! (if needed)
-- (Represent ITEM_CH_BOW_11_A_RARE), change as you need it
DECLARE @GearSuffix VARCHAR(16) = 'C_RARE'
-- @@@ END: SETTINGS
-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
my idea for this would be low rates
anyways works like a charm
nothing's wrong the SP, it works fine (Sequence complete), your problem is related to _AddLogChar SP (if you did not get the item when level up).
Try if the scroll works, do /makeitem manually and then use the scroll. If it works, then your problem confirmed to be at _AddLogChar SP. Then you can fix the _AddLogChar SP.
Yep, you can play with the degree detection inside SP. In my server i put up to 10D ;)
And I'm glad it works for you ;), nice work!
Witchy Moo
Can you Share _AddLogChar
coz when use a scroll it's work like a charm .
but Auto Gear give me nothing ..
thanks the system work fine now ..
Scroll & Automatic ..
The Problem from _AddLogChar And Fixed .. Useful witchy Moo
its kinda funz ppl cant make it work it took me ~2mins to finish it huh
its easy if ya know how sql stuff works kinda
Excellent, nice work ;)
sure .. Skerdikas
I'm Use It From 15min ^_^ ..
And Fixed It So Fast Alone ..
To Help Ppl The Original _AddLogChar
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogChar_copy] Script Date: 09/12/2013 03:25:56 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddLogChar_copy]
@CharID int,
@EventID tinyint,
@Data1 int,
@Data2 int,
@strPos varchar(64),
@Desc varchar(128)
as
if( @EventID=4 or @EventID=6 or @EventID=9 )
BEGIN
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
--DELETE TOP (3) FROM _LogEventChar WHERE EventTime < DATEADD(week, -2, GETDATE())
END
anyways ma 2nd server will be awesome 2.5x ftw xD
Well, it happens, and that's because some ppl only did copy-paste-and-use-then-complaint without learning or have basic knowledge about it :P
Good for you, have fun ;)
Reply With Quote