[Guide]Hosting Knight OnLine Private Server v.1299 using MSSQL 2005

m9amjadi · 07-06-2008, 03:20 PM

Wait is it not possible to run server on vista??

AlphaForce · 07-07-2008, 12:12 AM

Quote: Originally Posted by OMEGAbuffer

When there's no NPCs, I think it's because ebenezer didn't connect AiServer successfully. Check in your ebenezer window. Does it say Ai Server Connect Success!! - 0, all the way up to 9? Does it spam All monster info received!!?

NOTE: Database backup directions added.

Yeah it shows tht its connected, but only up to -4 :S .......seems thers no errors (appart from quest info one)

and it shows the monsters info but doesnt spam it. :( followed the instructions completley, will check my ini files again.

do you think its a db problem or server files?

DACRepair · 07-07-2008, 01:02 AM

^^^ i am getting that same problem, any ideas? i do know that you'll need a user sknight with that crazy pass (qlfjajrmf6), but either way it didnt make a difference.

pablok83 · 07-07-2008, 01:33 AM

Hi, i got the same problem that ceelen1, i ask her but i dont recive any answer, and well, i try asking here, i have all fine, and start the launcher and i put the acc and psw and enter but dont do anything, only still in the orc screen. Can any1 help me plz, thanks and sorry for english errors xD

AlphaForce · 07-07-2008, 02:16 AM

Quote: Originally Posted by DACRepair

^^^ i am getting that same problem, any ideas? i do know that you'll need a user sknight with that crazy pass (qlfjajrmf6), but either way it didnt make a difference.

fixed it i think...... in the obdc make sure that the entries are the correct cases.... i.e. KN_online as apposed to KN_Online and KN_Data as apposed to KN_data.

seemed to work for me ;) let me know how it goes

adidishen · 10:09 PM

It seems like the knightonline.exe file is having trojan issues (scanned with AVG free 8, bitdefender online scanner and both find a trojan)
Other than that, the client works fine if I disable AVG..

Edit:

This is the scan result of KnightOnLine.exe client file you provided, not any of the server files.

Code:

A-Squared  Found Trojan-Spy.Win32.Agent.cda  
AntiVir  Found TR/Spy.Agent.cda.4  
ArcaVir  Found Dialer.Riskware.Ge  
Avast  Found nothing 
AVG Antivirus  Found PSW.Agent.STG  
BitDefender  Found Trojan.Generic.264642  
ClamAV  Found Trojan.Spy-32806  
CPsecure  Found Troj.Spy.W32.Agent.cda  
Dr.Web  Found nothing 
F-Prot Antivirus  Found nothing 
F-Secure Anti-Virus  Found Trojan-Spy.Win32.Agent.cda  
Fortinet  Found nothing 
Ikarus  Found Trojan-Spy.Win32.ProAgent.21  
Kaspersky Anti-Virus  Found Trojan-Spy.Win32.Agent.cda  
NOD32  Found nothing 
Norman Virus Control  Found W32/Agent.FGIA  
Panda Antivirus  Found nothing 
Sophos Antivirus  Found Mal/Generic-A  
VirusBuster  Found nothing 
VBA32  Found Trojan-Spy.Win32.Agent.cda

DACRepair · 07-08-2008, 06:20 PM

Quote: Originally Posted by AlphaForce

fixed it i think...... in the obdc make sure that the entries are the correct cases.... i.e. KN_online as apposed to KN_Online and KN_Data as apposed to KN_data.

seemed to work for me ;) let me know how it goes

Yeah it seems to keep doing it, checked the obdc's too, they are all proper, just dunno what else to try >.>

nMkjordon · 07-11-2008, 04:05 AM

mine keeps showing up this

Code:

http://i36.tinypic.com/30wxw76.jpg

OMEGAbuffer · 07-11-2008, 05:27 AM

Quote: Originally Posted by AlphaForce

Yeah it shows tht its connected, but only up to -4 :S .......seems thers no errors (appart from quest info one)

and it shows the monsters info but doesnt spam it. :( followed the instructions completley, will check my ini files again.

do you think its a db problem or server files?

Probably. When you run ebenezer, there should be 10 AiServer Connect Success messages from 0-9. Also, All Monster Info Received should be spammed like 30~50 times. If not, it might be the database or server files...

@m9am, a lot of people have been having trouble running the server on Vista. These directions I posted are for Windows XP because I use Windows XP. It might be a bit different on Vista, maybe not that much. I haven't seen anyone with a PS on Vista yet. If you have one, gratz.

@pablok, .INI error. Also, these directions are for hosting your server internally, which means only YOU can connect.

@adidishen, I haven't seen a KnightOnLine.exe without a dead trojan in it, bro. I was told USKO GMs used to check people for 3rd party programs using it. I think I saw one released by GoatCheeze, but I'm not sure if it still has that trojan error. I'm VERY sure that it is harmless. I would advise turning off your anti-virus temporarily so you can play. If you think I'm just one of those predators, don't download it and wait for someone to get ya a clean one, if one ever comes out.

@jordan, did you type ComputerName\SQLEXPRESS right?

pablok83 · 07-12-2008, 07:08 AM

But i am doing all in my computer, the server and i use the client in the same computer, :(

OMEGAbuffer · 08-03-2008, 04:31 AM

Well, k, I guess I'll release the .INIs now to make your server public. A lot of people have been bugging me for it because they're "lonely" being the only one on their server.

Keep these in mind.

Internal IP = 127.0.0.1
External IP = IP you get from whatsmyip.org
Computer IP = IP you get from Run...->cmd->ipconfig

Login Server // Version.INI

Code:

[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:\

[SERVER_LIST]
COUNT=1
SERVER_00=EXTERNAL IP
NAME_00=ServerName

AiServer // Server.ini

Code:

[SERVER]
ZONE=1
PARTYEXP=0
GROUP=0
[ODBC]
GAME_DSN=KN_online
GAME_UID=knight
GAME_PWD=knight
[SERVER]
ZONE=1
PARTYEXP=0
GROUP=0

Aujard // Aujard.INI

Code:

[ODBC]
ACCOUNT_DSN=KN_online
ACCOUNT_UID=knight
ACCOUNT_PWD=knight
LOG_DSN=KN_online
LOG_UID=knight
LOG_PWD=knight
GAME_DSN=KN_online
GAME_UID=knight
GAME_PWD=knight
GAME_DSN2=KN_online
GAME_UID2=knight
GAME_PWD2=knight

[ZONE_INFO]
GROUP_INFO=1
ZONE_INFO=1

[SESSION]
IP1=INTERNAL IP OR COMPUTER IP
IP2=INTERNAL IP OR COMPUTER IP
[BILLING]
IP=INTERNAL IP OR COMPUTER IP
PORT=15100
NUM=1

[PREMIUM_ITEM]
ITEM_NUM1=16000
ITEM_NUM2=16001

NOTE: People have found changing PORT=15100 to PORT=15001 and it worked. So, if Aujard is retarded, try changing that.

Ebenezer // GameServer.ini

Code:

[TIMER]
YEAR=2008
MONTH=3
DATE=14
HOUR=6
WEATHER=1
[LOGIN SERVER]
IP=EXTERNAL IP
[CASTLE]
NATION=1

[ZONE_INFO]
MY_INFO=1
SERVER_COUNT=4
SERVER_00=1
SERVER_IP_00=INTERNAL IP OR COMPUTER IP
SERVER_01=2
SERVER_IP_01=INTERNAL IP OR COMPUTER IP
SERVER_02=3
SERVER_IP_02=INTERNAL IP OR COMPUTER IP
SERVER_03=4
SERVER_IP_03=INTERNAL IP OR COMPUTER IP
SERVER_NUM=1
MAX_USER=2000
[BATTLE]
WEEK=6
START_TIME=20
END_TIME=0
AUTO=0
WEEK2=6
MWEEK=5
LIMITBATTLE=200
[AI_SERVER]
IP=INTERNAL IP OR COMPUTER IP
[DB_SERVER]
IP=INTERNAL IP OR COMPUTER IP
[ODBC]
GAME_DSN=KN_online
GAME_UID=knight
GAME_PWD=knight
GAME_DSN3=KN_online
GAME_UID3=knight
GAME_PWD3=knight
Account_DSN=KN_online
Account_UID=knight
Account_PWD=knight
[VERSION]
VER=1299
[SG_INFO]
GMY_INFO=1
GSERVER_COUNT=1
GSERVER_00=1
GSERVER_IP_00=INTERNAL IP OR COMPUTER IP
SERVER_INDEX=1
[NATION]
NATION_ID=1
[FREE_ZONE]
MAX_USER=1000
[EVENT]
EVENT_NUMBER=0
[MATURE_SETTING]
PK_PERMIT=0
[MONSTER_CHALLENGE]
ACTIVATE=1
LEVEL=1
[BONUS_EVENT]
MONEY=0
EXP=0

Ebenezer // Server.ini

Code:

[TIMER]
YEAR=1
MONTH=1
DATE=1
HOUR=1
WEATHER=1
[VERSION]
VER=1299
[BATTLE]
WEEK=5
START_TIME=20
END_TIME=0
AUTO=0
WEEK2=6
MWEEK=5
LIMITBATTLE=200
[CASTLE]
NATION=1
[ZONE_INFO]
MY_INFO=1
SERVER_NUM=0
SERVER_COUNT=1
SERVER_00=1
SERVER_IP_00=INTERNAL IP OR COMPUTER IP
MAX_USER=2000
[NATION]
NATION_ID=1
[FREE_ZONE]
MAX_USER=5000
[EVENT]
EVENT_NUMBER=0
[MATURE_SETTING]
PK_PERMIT=0
[MONSTER_CHALLENGE]
ACTIVATE=1
LEVEL=1
[BONUS_EVENT]
MONEY=0
EXP=0
[SG_INFO]
SERVER_INDEX=0
[MEMBER]
MEMBER=0
[GO]
THROUGH=0
[WXDZ]
WXDZ=0
[BATTLE2]
WEEK=5
START_TIME=20
END_TIME=0

In order for your server to be public, however, you MUST port forward correctly and disable any firewalls.

Have Fun

pkerkid · 08-07-2008, 06:10 PM

I need help! i can't get pass this part.

Quote:

17)Now, go to your ODBC. Located at Start->Administrative Tools->Data Sources(ODBC). There's 7 tabs on the top of the window that pops-up. Click on the System DSN one. Press "Add..." Scroll down to SQL Server and press Finish. For the name, put KN_online. For server, put "\SQLEXPRESS". Press "Next". Tick SQL Server Identification. Login ID, put knight. Password, put knight. Press "Next". Tick change default database. Adjust it to KN_online. Press "Next". Press "Finish". Press "OK".

18)Do the same for KN_Data, knight, and Knight_Account

19)Make sknight ODBC System DSN, same directions as Step#18. However, for Login ID//Password, put sknight//qlfjajrmf6.

20)Your server is ready! To launch your server, run the following executables in order:

Quote:
Login Server//VersionManager.exe
AiServer//AiServer.exe
Ebenezer//1298.exe
Aujard//Aujard.exe

When ever i try to add KN_online i get an error.

and when i try to run
Login Server//VersionManager.exe
AiServer//AiServer.exe
Ebenezer//1298.exe
Aujard//Aujard.exe

i get and error message but it still opens the file.

Can anyone help me?

UnNamedXD · 03:45 PM

Ill got a lot problems at 2nd step and 3nd step.
I am just trying to create my own server.
I never been gm so i dont know alot :)
The screenshots are in a order with my problems.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

OMEGAbuffer · 08-14-2008, 03:55 PM

Quote: Originally Posted by pkerkid

I need help! i can't get pass this part.
When ever i try to add KN_online i get an error.

and when i try to run
Login Server//VersionManager.exe
AiServer//AiServer.exe
Ebenezer//1298.exe
Aujard//Aujard.exe

i get and error message but it still opens the file.

Can anyone help me?

Quote:

For server, put "\SQLEXPRESS".

Change to "ComputerName\SQLEXPRESS" without the quotes, and putting in your real computer name.

Editted in my guide.

UnNamedXD · 08-16-2008, 06:38 PM

Ill still need help, plz help me

~~ wildwindow

OMEGAbuffer · 08-16-2008, 09:10 PM

Delete all versions of .NET framework and msx and MSSQL, then try again

Deloka · 11:30 AM

Hi!
My main problem is that: I cannot see theese databases :KN_Data,knight,Knight_Account,sknight.
So I can see just theese:
[Only Registered and Activated Users Can See Links. Click Here To Register...]
[Only Registered and Activated Users Can See Links. Click Here To Register...]

OMEGAbuffer · 08-17-2008, 03:35 PM

deloka, just set it to KN_online. You're not supposed to see the other ones, lol

Deloka · 08-17-2008, 04:48 PM

Oh yeah , but when I try to loggin that says: login failed (10061)
And when I start 1298.exe It says cannot find the dataabase or something? (I think it is an odbc error.

trias · 08-20-2008, 11:49 AM

m8 can u send this file "
a. SQL Installers[Jonny helped me host my server, so I put the installers in a folder named Jonny's SQL. Disregard the name. Creditz to Jonny for giving me the knowledge to make this guide] "
to rapidshare please. filefront doesnt have this file now

OMEGAbuffer · 08-20-2008, 04:12 PM

Deloka, I think you restored the database wrong.

xtom · 08-21-2008, 04:03 AM

Hello,
I got a problem, I did, like explained in guide, got no errors, configured all configs, but then i start game, enter id and pwd happens nothing... here is a ss of those game servers exe working. [Only Registered and Activated Users Can See Links. Click Here To Register...]
thanks

OMEGAbuffer · 08-21-2008, 05:49 AM

@xtom, are you sure you got no errors? No "Ai Server Connect Fail!" or anything running ebenezer? Because according to your ebenezer window, your ebenezer didn't connect to AiServer...

xtom · 08-21-2008, 10:44 PM

Yeah, all runs without any errors. Searched all forum for this kinda error, but didn't find anything. I even reinstalled windows:) but the again the same.

FluffyDai · 08-22-2008, 01:12 AM

i get this error when trying to create a new data source to SQL server ..
[Only Registered and Activated Users Can See Links. Click Here To Register...]
can u help me ? ^^
thx