"Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWriter!

Quote:

---

Originally Posted by B1QB0SS

can you give me this noticewriter source code?

---

I cannot, because it's already in the FIRST PAGE of this topic.... duh? :blink:

why my strdesc is null. I used SP on first page

0 461933 320888 3 2014-01-02 14:09:00.057 ?? ?(0x5faa) (546, 127) NULL

so Tool writenoice dont send msg and crash

All OKE But when many people PVP , Windown noitece GLOBAL is full
I Want edit to this notifice show in a newwindow
Can u Fix it
http://d.f21.photo.zdn.vn/upload/ori...11_574_574.jpg

well..is eazy and same time hard...

Quote:

---

Originally Posted by mylove0990

All OKE But when many people PVP , Windown noitece GLOBAL is full
I Want edit to this notifice show in a newwindow
Can u Fix it

---

No I cannot, I'm not the one who created PlusNotice, I simply modified it to work with my Stored Procedure, if you have questions related to PlusNotice features (such as changing notice to system window and so on so forth), you can post in original thread of PlusNotice, right here.

Error:
Msg 137, Level 15, State 2, Line 1Must declare the scalar variable "@EventID".
Msg 137, Level 15, State 2, Line 3
Must declare the scalar variable "@desc".
Msg 137, Level 15, State 2, Line 10
Must declare the scalar variable "@desc".
Msg 102, Level 15, State 1, Line 12
Incorrect syntax near '@killername'.
Msg 102, Level 15, State 1, Line 13
Incorrect syntax near '@killername'.
Msg 137, Level 15, State 2, Line 14
Must declare the scalar variable "@killername".
Msg 102, Level 15, State 1, Line 16
Incorrect syntax near '@desc'.
Msg 137, Level 15, State 2, Line 18
Must declare the scalar variable "@jobString".
Msg 137, Level 15, State 2, Line 23
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 29
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 30
Must declare the scalar variable "@jobType".
Msg 137, Level 15, State 2, Line 32
Must declare the scalar variable "@jobString".
Msg 137, Level 15, State 2, Line 36
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 37
Must declare the scalar variable "@CharnickName".
Msg 137, Level 15, State 2, Line 41
Must declare the scalar variable "@killername".
Msg 137, Level 15, State 2, Line 44
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 46
Must declare the scalar variable "@CharID".

Quote:

---

Originally Posted by MeGZONE

Error:

---

SQL 2005 i presume?

http://forum.ragezone.com/f722/simpl...ml#post7922535

Quote:

---

Originally Posted by Witchy Moo

SQL 2005 i presume?

http://forum.ragezone.com/f722/simpl...ml#post7922535

---

No i have SQL Server 2008 R2

Give me ur Skype

Quote:

---

Originally Posted by MeGZONE

No i have SQL Server 2008 R2

Give me ur Skype

---

Then you put wrong variables at declaration statement lines. Those error were simply SQL errors in general which can happen in any SP at anytime. So take your time to review your own statements in the SP, doing raw copy + paste + complaint won't get your anywhere.

Or better yet, attach your SP here.

Quote:

---

Originally Posted by Witchy Moo

Then you put wrong variables at declaration statement lines. Those error were simply SQL errors in general which can happen in any SP at anytime. So take your time to review your own statements in the SP, doing raw copy + paste + complaint won't get your anywhere.

Or better yet, attach your SP here.

---

Code:

---

USE [LOG_DB]GO
/****** Object:  StoredProcedure [dbo].[_AddLogChar]    Script Date: 01/09/2014 20:12:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




ALTER  procedure [dbo].[_AddLogChar]  @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

---

no no... don't paste your SP, i said "ATTACH", not "PASTE", RageZone has weird feature translating words began with "@" as link to user profile, which is annoying, it'll mess up some codes.. so attach it as file.

Quote:

---

Originally Posted by Witchy Moo

no no... don't paste your SP, i said "ATTACH", not "PASTE", RageZone has weird feature translating words began with "@" as link to user profile, which is annoying, it'll mess up some codes.. so attach it as file.

---

OK uploaded

After change declaration to 2005 Version I still have errors

Code:

---

Msg 102, Level 15, State 1, Procedure _AddLogChar, Line 46
Incorrect syntax near '@killername'.
Msg 102, Level 15, State 1, Procedure _AddLogChar, Line 47
Incorrect syntax near '@killername'.
Msg 102, Level 15, State 1, Procedure _AddLogChar, Line 51
Incorrect syntax near '@desc'.

---

Quote:

---

Originally Posted by lewy1000

After change declaration to 2005 Version I still have errors

Code:

---

Msg 102, Level 15, State 1, Procedure _AddLogChar, Line 46
Incorrect syntax near '@killername'.
Msg 102, Level 15, State 1, Procedure _AddLogChar, Line 47
Incorrect syntax near '@killername'.
Msg 102, Level 15, State 1, Procedure _AddLogChar, Line 51
Incorrect syntax near '@desc'.

---

---

No offense but if you dont master SQL basics, you shouldn't waste your time on db editing.

Hey man check please