[HELP]To insert Into to a new table

[SnickQ]

I try to witre auto ban for players who play in both fraction
First i cerate table 'bot" to wirte logs

USE [PS_GameLog]
GO

/****** Object:  Table [dbo].[Bot]    Script Date: 2014-09-27 16:13:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Bot](
	[row] [int] IDENTITY(1,1) NOT NULL,
	[UserUID] [int] NULL,
	[UserID] [int] NULL,
	[UserIP] [tinyint] NULL,
	[Country] [int] NULL,
	[Actiontime] [datetime] NULL
) ON [PRIMARY]

GO

And next i try to add Insert logs to new table in usp_Insert_Action_Log_E
Like that:

IF (@ActionType = '107')
BEGIN	
	IF EXISTS (SELECT * FROM PS_GameLog.dbo.Bot)
	BEGIN
        DECLARE @UserIP varchar(15)
		DECLARE @Country tinyint
		SET @UserUID= (Select UserIP from PS_UserData.dbo.Users_Master where UserUID=@UserUID)
		SET @UserID= (Select UserID from PS_UserData.dbo.Users_Master where UserUID=@UserUID)
		SET @UserIP= (Select UserIP from PS_UserData.dbo.Users_Master where UserUID=@UserUID)
		SET @Country = (SELECT Country FROM PS_GameData.dbo.UserMaxGrow WHERE UserUID=@UserUID)
		SET @ActionTime =GETDATE()
		IF (@ActionType ='107')
		BEGIN
			INSERT INTO PS_GameLog.dbo.Bot(UserUID,UserID,UserIP,Country,ActionTime) values (@UserUID,@UserID,@UserIP,@Country,@ActionTime)
		END
	END
END

But logs is not inserted to a ew table ;/

[nubness]

This is confusing. You said you want to cerate table, and you're using the CREATE TABLE instruction. This could be the problem, I think.

[SnickQ]

But i have a problem with insert log on this table:

IF (@ActionType = '107')
BEGIN	
	IF EXISTS (SELECT * FROM PS_GameLog.dbo.Bot)
	BEGIN
        DECLARE @UserIP varchar(15)
		DECLARE @Country tinyint
		SET @UserUID= (Select UserIP from PS_UserData.dbo.Users_Master where UserUID=@UserUID)
		SET @UserID= (Select UserID from PS_UserData.dbo.Users_Master where UserUID=@UserUID)
		SET @UserIP= (Select UserIP from PS_UserData.dbo.Users_Master where UserUID=@UserUID)
		SET @Country = (SELECT Country FROM PS_GameData.dbo.UserMaxGrow WHERE UserUID=@UserUID)
		SET @ActionTime =GETDATE()
		IF (@ActionType ='107')
		BEGIN
			INSERT INTO PS_GameLog.dbo.Bot(UserUID,UserID,UserIP,Country,ActionTime) values (@UserUID,@UserID,@UserIP,@Country,@ActionTime)
		END
	END
END

I try that to insert logs but is not insertef
Sorry fom my english

[nubness]

In the first post you said something about wirting logs, maybe you can try something like:

WIRTE INTO PS_GameLog.dbo.Bot(UserUID,UserID,UserIP,Country,ActionTime) values (@UserUID,@UserID,@UserIP,@Country,@ActionTime)

Please let me know if that works.

[SnickQ]

Not work

EDIT: I try like that

insert into PS_GameLog.dbo.Bot
SELECT @UserUID AS UserUID, @UserID AS UserID, @UserIP AS UserIP, @Country AS Country, GETDATE() AS ActionTime
FROM PS_GameLog.dbo.Bot
Where UserUID=@userUID

and still have nothing >.<

[nubness]

Trolling.Enabled = false;

• This is a terrible way to prevent people from cheating.
• Your UserID column in the Bot table is an INT, when it should be a VARCHAR(18).
• Learn some english.
• Check your posts for grammar or spelling mistakes before submitting them.

[SnickQ]

Yes my English is suck
But i need logs with every log with Country
Then i can banned ppl who play in Country 0 and 1
This is not a trolling

Request for close

[nubness]

Yes, I understand this is not trolling, this is serious business. The trolling part was on my end.

[SnickQ]

Originally Posted by nubness

Yes, I understand this is not trolling, this is serious business

No is not
But need auto ban for ppl who play in both faction. on our server is too many ppl who play in faction who bosses have and unbalanced pvp because of that
With dbo.bot we can put in game_Log_out

Update ps_UserData.dbo.Users_Master
Set Status ='-5'
Where UserUID+@UserUID and @Country 0 and 1

But because logs dont want inserted in dbo.bot i ask for help here

[Autrux]

#closed as request