3 Attachment(s)
(Caosfox, lemmoniscool) Notice V3, weird and unbelievable :P
Hey. I Tryed yesterday with normal Auto Plus notice i mean that of Comandante , and its work, showing alchemy notice in game and writing notice in DB PlusNotice etc.
But i decided today to try a Notice V3 relased by Caosfox. First i fight abt 4 hours cuz cannot get some permissions in my own db, after i handle this shity DB, i excuted rest queries etc etc etc from
this ofc:
http://forum.ragezone.com/f722/plus-...9/index10.html
SO in 1 word -> EVERYTHING i did "SUCCESS". ( I did everything STEP by STEP from Caosfox tutorial)
Well:
1* - i dont care abt writing notice to DB PlusNotice in SRO_VT_SHARDLOG so i cuted from MainProcedure
2* - Notice V3 its working but -> its not making any .txt file or any other file in C:\MSSQLTips
I dont know why and i dont care abt that , cuz Main THING (NOTICE PLUS) is working(but not in a 100%): Look at that
1st screenshot Alchemy ON TOTLY CLEAN ITEM: NO VISUAL ERRORS
Attachment 155721
2th screenshot Alchemy with 1 lucky stone , WTH IS that ? :/
Attachment 155719
My Notice V3 program:
Attachment 155720
This is how looks like my _AddLogItem procedure:
Code:
-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase : Shard Log
ALTER procedure [dbo].[_AddLogItem]
@CharID int,
@ItemRefID int,
@ItemSerial bigint,
@dwData int,
@TargetStorage tinyint,
@operation tinyint,
@slot_From tinyint,
@slot_To tinyint,
@eventPos varchar(64),
@strDesc varchar(128),
@Gold bigint -- #ifdef EXTEND_GOLD_TYPE »ðÀÔ
as
declare @Len_pos int
declare @Len_desc int
set @Len_pos = len @eventPos)
set @Len_desc = len(@strDesc)
if @Len_pos > 0 and @Len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @operation, @slot_From, @slot_To, @eventPos, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
else if @Len_pos > 0 and @Len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @operation, @slot_From, @slot_To, @eventPos, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
else if @Len_pos = 0 and @Len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @operation, @slot_From, @slot_To, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
else if @Len_pos = 0 and @Len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @operation, @slot_From, @slot_To, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
-- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀ̸é!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
if @operation = 35)
begin
insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)
values(@ItemRefID, @CharID, @dwData, GetDate(), @ItemSerial)
end
if @operation = 90)
begin
declare @iname varchar(129)
declare @iid int
declare @plus varchar(5)
declare @CnaMe varchar(64)
select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial
select @iname = Name from SRO_VT_SHARD.dbo._ItemName where CodeName128 in(select CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid)
select @CnaMe = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
select @plus = SUBSTRING(@strDesc, CHARINDEX('+',@strDesc,0) + 1, LEN(@strDesc))
declare @Veremos varchar(200)
select @Veremos = '[' + @CnaMe +']'+ ' has increased '+'[' + @iname + ']'+' to level [' + @plus
declare @Azar INT
declare @randomfile varchar(50)
SELECT top 1 @Azar = (ABS(CHECKSUM(NEWID())) % 10000) FROM Master.dbo.Syscolumns
select @randomfile = 'C:\MSSQLTips\' + convert(varchar, @Azar) + '.txt'
SELECT dbo.WriteTextFile @Veremos, @randomfile, 0)
end
I also tryed with INsert PlusNotice , it write well to DB , but VISUAL error still the same.
I try to modify this row in few ways:
select @Veremos = '[' + @CnaMe +']'+ ' has increased '+'[' + @iname + ']'+' to level [' + @plus
But still the same wich means nothing ;/
What can i do with that?
Please help me somehow ;p :)
ps. sql 2008r2
I THINK IS FIXED: I ADD THIS TO MY PROCEDURE:
Code:
if @operation = 90 OR @operation = 160)
begin
set @Len_desc = CHARINDEX (']',@strDesc)
if @Len_desc = 9)
begin
set @strDesc = SUBSTRING(@strDesc,0,9)
end
else if @Len_desc = 10)
begin
set @strDesc = SUBSTRING(@strDesc,0,10)
end
BUhahahhah finally after over 6 hours >< >< >< :D :) IT seems be correct, btw it still dont writhing .TXT files but who cares :D :P :)
Now its looks liks this :)
[Notice][party1] has increased [Hell Dragon Blade] to level [7]
[Notice][party1] has increased [Hell Dragon Blade] to level [1]
[Notice][party1] has increased [Hell Dragon Blade] to level [2]
Ohh btw:
Big THANKS TO Caosfox , lemmoniscool,Comandante,Awesome , Great Job Guys !!! <3 ;)