[Help]loginserver

[skippy_san]

i have searched and prodded forums trying to figure out what im doing wrong ......maybe someone can help me here ...

i keep getting error "load version list failed" i have read several guides trying to fix it .....

please help me ...what am i doing wrong

[MentaL]

[midgetmaster]

Run This In Query manager

CREATE TABLE [dbo].[VERSION] (
	[version] [smallint] NULL ,
	[filename] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[compname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[hisversion] [smallint] NULL 
) ON [PRIMARY]
GO

[skippy_san]

ok do i run it in query manager under my KN_online db or in something else?

this is what i got from running in KN_online

Server: Msg 2714, Level 16, State 6, Line 1
There is already an object named 'VERSION' in the database.

[Lagalos]

then its something in your version.ini

[skippy_san]

ok this is what is in my version.ini without ip addy for obvious reasons


[DOWNLOAD]
URL=wizgate.nefficient.co.kr
PATH=pub/wizgate2/knight/upgrade

[ODBC]
DSN=KN_online
UID=knight
PWD=knight
TABLE=VERSION

[CONFIGURATION]
DEFAULT_PATH=D:\KOserver

[SERVER_LIST]
COUNT=4
SERVER_00=*
NAME_00=Eddie

[Lagalos]

your db name is KN_online?

[skippy_san]

yes my db is KN_online and i set all other db's the way the guide said...


this is what im getting in the log file for version manager

*** 37000, 170, [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'N'., 81 ***


thx in advance for any help

also im not understanding why the client is so hard to find... all the links seem to dead

[Lagalos]

delete the old VERSION table and use that one he posted

[skippy_san]

did that and still getting load version list fail ....i dunno the guide is very consice and i followed it to the letter ...maybe the 1098 server isnt gonna work for me....any suggestions?

[JoshfromJMKO]

ok check your knight user permissions make sure you add him on security logins and users...
make sure the password is knight
and then right click on KN_online
Properties then permission and check all rows for knight...

donno if you have done that already..

[pega88]

have the same prob nothing helps

[budsmoker997]

CREATE PROCEDURE MYST_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT

AS


DECLARE @Nation tinyint, @CharNum smallint
SET @Nation = 0
SET @CharNum = 0

DECLARE @pwd varchar(13)

SET @pwd = null

SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID
IF @pwd IS null
BEGIN
SET @nRet = 0
RETURN
END

ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 0
RETURN
END

SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @CharNum = 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = @Nation+1
RETURN
END


GO










RUN THAT IN QUERY

i would give credits but i forgot who posted it :)

[GM420]

could someone point out where query is? shook my kn_online db upside down still cant find the damn file xD

[jrock75]

This may sound dum but are you trying to run this on vista? Because I did that, when I first tried setting up my server and got the same errors you posted.

[GM420]

ya, i've just recently realized that vista sucks balls... login server kept giving me that dam "load version list fail!!" error, then i transfered my server files, to my xp desktop, and the login manager worked perfectly, so i've been spending some time learning how to downgrade my laptop to xp. good times...