[Release] Safe-Zone Killing Detection

[dieguinhojeito]

help erro

Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@ActionType".
Msg 137, Level 15, State 2, Line 3
Must declare the scalar variable "@MapID".
Msg 137, Level 15, State 2, Line 10
Must declare the scalar variable "@MapID".
Msg 137, Level 15, State 2, Line 12
Must declare the scalar variable "@Value1".
Msg 137, Level 15, State 2, Line 14
Must declare the scalar variable "@UserUID".
Msg 137, Level 15, State 2, Line 17
Must declare the scalar variable "@MapID".

[SnickQ]

Originally Posted by dieguinhojeito

help erro
Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@ActionType".
Msg 137, Level 15, State 2, Line 3
Must declare the scalar variable "@MapID".
Msg 137, Level 15, State 2, Line 10
Must declare the scalar variable "@MapID".
Msg 137, Level 15, State 2, Line 12
Must declare the scalar variable "@Value1".
Msg 137, Level 15, State 2, Line 14
Must declare the scalar variable "@UserUID".
Msg 137, Level 15, State 2, Line 17
Must declare the scalar variable "@MapID".

Read first post:

Originally Posted by nubness

All you need to do is insert the following lines in PS_GameLog.dbo.usp_Insert_Action_Log_E :

[Wandyies2012]

Originally Posted by nubness

Yes, it is fairly easy to show the SafeZoneKillLog table on a website with PHP.

About jailing that person, you need a GM character online to summon the rule breaker to jail, not worth the waste of time.

I'll include the part that removes kills a little bit later, too busy with other things at the moment.

Error in line:

'SET @DeadFaction = (SELECT Country FROM PS_GameData.dbo.UserMaxGrow WHERE UserUID = @UserUID)'

[wallerus]

It says "Insert Error" which most likely means your "SafeZoneKillLog" table doesn't have the proper columns needed for the insert too work. If the table is clean, which it most likely is just delete and remake the table again:

Originally Posted by nubness

USE [PS_GameLog]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SafeZoneKillLog](
	[RowID] [tinyint] IDENTITY(1,1) NOT NULL,
	[Map] [tinyint] NOT NULL,
	[PosX] [real] NOT NULL,
	[PosZ] [real] NOT NULL,
	[KillerUserUID] [int] NOT NULL,
	[KillerCharName] [varchar](20) NOT NULL,
	[KillerCharID] [int] NOT NULL,
	[DeadCharName] [varchar](20) NOT NULL,
	[DeadCharID] [varchar](20) NOT NULL,
	[ActionTime] [datetime] NULL,
	[Punished] [bit] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

Make sure [Punished] column allows NULL values, if that doesn't work try to use this instead:

INSERT INTO SafeZoneKillLog VALUES (@MapID, @PosX, @PosY, @Text1, @Value1, @CharName, @CharID, @ActionTime, NULL)

My knowledge is very basic, but I've seen that error a few times personally and it's just the insert part of the script and the columns from the table it's using don't match.

[Cansas59]

what is x1,z1,x2,z2 in the Database script? please no stupid answer please

[wallerus]

Originally Posted by Cansas59

what is x1,z1,x2,z2 in the Database script? please no stupid answer please

x are letters, 1 & 2 are numbers. No stupid questions please.

[Cansas59]

i mean this is the coordinations? or what is it, what must i put in Db, this is new for me im sorry

[wallerus]

Originally Posted by Cansas59

i mean this is the coordinations? or what is it, what must i put in Db, this is new for me im sorry

Read the first post, it literally explains everything you need to know.