-
[Help]loginserver
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
-
Re: loginserver
Run This In Query manager
Code:
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
-
Re: loginserver
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.
-
Re: loginserver
then its something in your version.ini
-
Re: loginserver
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
-
Re: loginserver
your db name is KN_online?
-
Re: [Help]loginserver
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
-
Re: [Help]loginserver
delete the old VERSION table and use that one he posted
-
Re: [Help]loginserver
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?
-
Re: [Help]loginserver
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..
-
Re: [Help]loginserver
have the same prob nothing helps
-
Re: [Help]loginserver
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 :)
-
Re: [Help]loginserver
could someone point out where query is? shook my kn_online db upside down still cant find the damn file xD
-
Re: [Help]loginserver
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.
-
Re: [Help]loginserver
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...