Gunz Databases wont import
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.
Re: Gunz Databases wont import
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?
Re: Gunz Databases wont import
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
Re: Gunz Databases wont import
GunZ uses MSSQL, not MySQL.
Re: Gunz Databases wont import
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 :(
Re: Gunz Databases wont import
Quote:
Originally Posted by
Phoenix
GunZ uses MSSQL, not MySQL.
it works but u need to do a hell lots of edits so just us MYSSQL FOR Gunz