[Release] Locator SQL 100% completed + Locator.ini

Joined
Nov 18, 2004
Messages
1,279
Reaction score
222
credit to thugie

USE [GunzDB]
GO
/****** Object: Table [dbo].[ServerStatus] Script Date: 02/19/2007 20:45:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ServerStatus](
[ServerID] [int] NULL,
[ServerName] [nvarchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PlayerCount] [int] NULL,
[MaxPlayer] [int] NULL,
[CurrPlayer] [int] NULL,
[Time] [datetime] NULL,
[IP] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Port] [int] NULL,
[Opened] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StatusTime] [int] NULL,
[UpdateTime] [int] NULL,
[RecvUDP] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SendUDP] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BlockUDP] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF








set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spUpdateLocatorStatus]
@nServerID INT,
@RecvUDP VARCHAR,
@SendUDP VARCHAR,
@BlockUDP INT,
@UpdateTime INT
AS
BEGIN
SET NOCOUNT ON;
-- Update UDP Status
UPDATE ServerStatus
SET RecvUDP = @RecvUDP, SendUDP = @SendUDP, BlockUDP = @BlockUDP, UpdateTime = @UpdateTime
WHERE ServerID = @nServerID

END





set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spStartUpLocatorStatus]
@nServerID int,
@nIP varchar(50),
@nPort int,
@nStatusTime varchar(4000)
AS
-- Remove old server.
DELETE FROM ServerStatus WHERE ServerID = @nServerID
-- Add new server.
INSERT INTO ServerStatus (ServerID,IP,Port,StatusTime) VALUES (@nServerID,@nIP,@nPort,@nStatusTime)
 
Only delete mine, and leave Thuguies one.

If I don't allow to most my work, means that i don't allow.

If i report this, it could be deleted.

Oh, Rebel, what do you think that are you doing?, you first post is flaming, get banned
 
he got it from me i was bored so i booted up my pc in korean using help from web-based translators yes i know they suck but if you got a brain you can make out what they mean ;).

so i translated it :p.

and sweet i got some credits!!
 
he got it from me i was bored so i booted up my pc in korean using help from web-based translators yes i know they suck but if you got a brain you can make out what they mean ;).

so i translated it :p.

and sweet i got some credits!!


in mine only box can be seen nothing else see the file that i have attach can u give me this in eng version
 

Attachments

  • see this matchserver - [Release] Locator SQL 100% completed + Locator.ini - RaGEZONE Forums
    see this matchserver.webp
    34.5 KB · Views: 136
Back