Gunz Databases wont import

**Stefap** · 28-01-11

Dear RZ, i know i am trying to play an old/nerved game. If you are here to inform me so, please dont mix lol.

Anyhow, ive downloaded several server files from the boards, but experience the same problem with all of them:
SQL doesnt succesfully import it, it cancels on the first line. It wont show me a clear log but it gets something with ANSI_NULL.

Since the game is dated i downloaded MySQL 5.0 (The old 2006/2008 version) but it wont work. Any advice?

Thanks in advance.

**MentaL**

**Nebul** · 28-01-11

Wrong section btw

And hmmm where do you get the error at
When you install it?
SQL Management login?

what do you install to occur this error?

**Stefap** · 28-01-11

Oh sorry!

I have the SQL running (MySQL 5.0), when i try and import the database (.sql) to the server (the query) it errors me up, basicly with all of the db's for Gunz.

-- To be clear; gunz databases (all of them) --

---------- Post added at 08:51 PM ---------- Previous post was at 08:21 PM ----------

I think it has to do with the SQL version, what SQL server should i download? (year/version?)

Code:

RETURNS BIGINT
AS
BEGIN
	DECLARE @A BIGINT, @B BIGINT, @C BIGINT, @D BIGINT
	DECLARE @iBegin INT, @iEnd INT
	
	SELECT @iBegin=1
	SELECT @iEnd=CHARINDEX(''.'', @IP)
	SELECT @A=CAST(SUBSTRING(@IP, @iBegin, @iEnd-@iBegin) AS BIGINT)
	
	SELECT @iBegin=@iEnd+1
	SELECT @iEnd=CHARINDEX(''.'', @IP, @iBegin)
	SELECT @B=CAST(SUBSTRING(@IP, @iBegin, @iEnd-@iBegin) AS BIGINT)
	
	SELECT @iBegin=@iEnd+1
	SELECT @iEnd=CHARINDEX(''.'', @IP, @iBegin)
	SELECT @C=CAST(SUBSTRING(@IP, @iBegin, @iEnd-@iBegin) AS BIGINT)
	
	SELECT @iBegin=@iEnd+1
	SELECT @iEnd=CHARINDEX(''.'', @IP, @iBegin)
	SELECT @D=CAST(SUBSTRING(@IP, @iBegin, 15) AS BIGINT)
	
	DECLARE @IPNumber BIGINT
	SELECT @IPNumber=@A*16777216+@B*65536+@C*256+@D
	
	RETURN @IPNumber
END
'

This for example is completely marked red in SQLyog/HeidiSQL

**Phoenix** · 28-01-11

GunZ uses MSSQL, not MySQL.

**Stefap** · 29-01-11

MServer::Create - m_RealCPNet.Create(6000)==false is now bothering me..

---------- Post added 29-01-11 at 12:21 AM ---------- Previous post was 28-01-11 at 11:53 PM ----------

So ive fixed it, but on the client it doesnt show it on the list :(