Directions on how to host a Knight OnLine v.1299 Private Server on Microsoft SQL 2005.
1)Download all of the files here:
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]
b. Server Files complete with Yeni Klasor Database[I use Heavenskhan's files, so I'll post it here. Creditz to him for Server Files]
c. 1299 Client[Optional
NOTE: When you run SQLEXPR32.exe, when you get to the tab where you can tick Windows Authen or Mixed Mode, tick Mixed Mode.[Creditz to Aixu for finding this out.]
2)In the SQL Installers Files, there are for executables: "dotnetfx.exe" "msxml6_x86.exe" "SQLEXPR32.exe" and "SQLServer2005_SSMSEE.exe". Launch them and install them in this order:
dotnetfx.exe
msxml6_x86.exe
SQLServer2005_SSMSEE.exe
SQLEXPR32.exe
3)Run Microsoft SQL Server Management Studio Express. Located at: Start->All Programs->Microsoft SQL Server 2005->SQL Server Management Studio Express
4)Studio Express should open up. A pop-up will occur with 3 things there: Server Type=Database Engine, Server Name=Blank, and Authentification=Windows Authentification. For Server Name, type your computer name, then back-slash it with SQLEXPRESS. For example, ImGay\SQLEXPRESS if ImGay is your computer name.
To find your computer name, right-click "My Computer" and press Properties. A pop-up should occur with System Restore, Automatic Updates, Remote, General, Computer Name, Hardware, and Advanced. Click the Computer Name tab, and your computer name should be posted in that Window.
5)Right-click the databases folder. Press "New Database..." Name it KN_online, then press ok. Located at <ComputerName>\SQLEXPRESS->Databases in your Server Management Studio.
6)KN_online folder should appear now at <ComputerName>\SQLEXPRESS->Databases->KN_online. Right-click it, go to tasks, go to restore, then press database[Tasks->Restore->Database].
7)Whatever database you have, make sure it is extracted to "C:\", without the quotations. If not, do that now. If yeah, disregard this step.
8)Go back to your Server Management Studio. In the Restore Database Window, tick "From Device". Then click the "..." button next to "From Device". Press "Add". On "Files of Type:", put "All Files*". Then, look for your database. It should be under "C:\". When you've found it, click on it, and press "OK". You should be back to Restore Database Window. Tick the "Restore" check next to "kn_online backup" dadadada stuff. Now, on the top left, there should be 2 tabs: General and Options. Go to Options. Tick the check next to "Overwrite the existing database". Then click "OK".
9)Go to Schemas under KN_online security. The only schemas you should have are the following. Located at: <ComputerName>\SQLEXPRESS->Databases->KN_online->Security->Schemas
Quote:
db_accessadmin
db_backupoperator
db_datareader
db_datawriter
db_ddladmin
db_denydatareader
db_denydatawriter
db_owner
db_securityadmin
dbo
guest
INFORMATION_SCHEMA
sys
Delete all other schemas.
10)Go to Users under KN_online security. The only users you should have are the following. Located at: <ComputerName>\SQLEXPRESS->Databases->KN_online->Security->Users
Quote:
dbo
guest
INFORMATION_SCHEMA
sys
11)Now, you gotta make two users. Go to the Logins folder in the security folder, not the KN_online security. It is located at <ComputerName>\SQLEXPRESS->Security->Logins. Right-click Logins, and press "New Login..." For login name, enter knight. Tick SQL Server Authentification. Enter your password as knight, and in the confirm password as well. For default database, put KN_online. OK, do you see 5 tabs on the top left? Click on Server Roles. Tick all of the roles so that they all have a check next to them. Go back to the tabs, and press User Mapping. Tick the box in Map next to KN_online. In database role membership, tick all of the roles. Press ok.
NOTE: When you make the logins, knight and sknight, in the General Tab, there's 3 tabs regarding password policy under the password fields. Untick them all. [Creditz to Aixu for finding this out.]
12)Do the same for user sknight. However, for the password, put qlfjajrmf6. Your password will be different if you use a different EXE in your Server Files folder. You can change that via hex editting[I think].
13)OK, you can close Server Management Studio if you want. If not, minimize it.
14)Go to your Server Start Files, aka Login Server, AiServer, Ebenezer, and Aujard folders.
15)Go to your Login Server. Edit your Version.ini in there so that it looks like the following:
Quote:
[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=YourIP
NAME_00=ServerName
Keep in mind if it says YourIP, put your IP address of your computer; don't leave that there. You can obtain it by going to Start->Run...->cmd->ipconfig.
Now, go back, and go to your AiServer folder. Edit your Server.ini in there so that it looks like the following:
Quote:
[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
Now, go back, and go to your Aujard folder. Edit your Aujard.ini in there so that it looks like the following:
Quote:
[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=YourIP
IP2=YourIP
[BILLING]
IP=YourIP
PORT=15100
NUM=1
[PREMIUM_ITEM]
ITEM_NUM1=16000
ITEM_NUM2=16001
Now, go back, and go to your Ebenezer folder. Edit your GameServer.ini in there so that it looks like the following:
Quote:
[TIMER]
YEAR=2008
MONTH=3
DATE=14
HOUR=6
WEATHER=1
[LOGIN SERVER]
IP=YourIP
[CASTLE]
NATION=1
[ZONE_INFO]
MY_INFO=1
SERVER_COUNT=4
SERVER_00=1
SERVER_IP_00=YourIP
SERVER_01=2
SERVER_IP_01=YourIP
SERVER_02=3
SERVER_IP_02=YourIP
SERVER_03=4
SERVER_IP_03=YourIP
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=YourIP
[DB_SERVER]
IP=YourIP
[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=YourIP
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
Staying in the ebenezer folder, scroll down to Server.ini and edit it so it looks like the following:
Quote:
[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=YourIp
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
NOTE: If you want to run your server internally, put 127.0.0.1 into all of the YourIPs.
16)Now, you must forward a couple ports. Find more information about how to forward ports with your router here:
[Only Registered and Activated Users Can See Links. Click Here To Register...]
You must forward the following ports:
Quote:
Name - TCP/UDP - Port#
Battlefield Connections - TCP/UDP - 10040
Elmorad Connections - TCP/UDP - 10030
Game Server - TCP/UDP - 15100
Karus Connections - TCP/UDP - 10020
Login Server - TCP/UDP - 15001
UDP Backport - TCP/TCP - 8888
Web Server - TCP/TCP - 80
Listening Port - TCP/UDP - 15000
NOTE: If it says TCP/TCP, that means you only have to forward a TCP port.
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 "<ComputerName>\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
To make accounts, go back to the Server Management Studio. Go to <ComputerName>\SQLEXPRESS->Databases->KN_online->Tables->dbo.TB_User . Right-click it, press Open Table. Put your ID//PW in the approppriate column. The column next to PW should be 1, and the column next to that should be 6.
[Only Registered and Activated Users Can See Links. Click Here To Register...]
A scan for one of them. I can't get a decent screenshot of the scan for the SQL.exes. All I can say is ask another member to scan if for you if you still don't trust me.
Hope this helps,
-OMEGAbuffer
P.S. If you need guided help, add my MSN at
OMEGA_buffer@hotmail.com, and I'll try to help you out as best I can.
P.P.S. If, when you launch either AiServer or Ebenezer, there's a "MAP\<WhoCaresAboutTheFileName>.smd" error, please download this. Extract it to both your AiServer and your Ebenezer folder.
Code:
MAPS = http://files.filefront.com/MAPrar/;10679530;/fileinfo.html
TIP: Manually backing up the database every hour or so is good, just incase of rollbacks. Backing up the database gives you the MOST recent database, meaning everything that has happened from the first time you restored database till now. This can prevent a lot of wipes and huge rollbacks.
To back up database, follow these steps:
1) Go to ComputerName\SQLEXPRESS\KN_online. Right-Click KN_online, go to Tasks, and press "Backup..."
2) Look down to the section labled "Destination". If there's anything in that list, highlight it, and press Remove. If there's nothing there in the first place, disregard this step.
3) Press Add...
4) Make sure "File Name:" is ticked. Look to the right of that, and there should be a "...". Press it.
5) A new window should pop-up. Look near the bottom. There's 3 drop-down lists. Go to the own that says Files of Type, and change it to All Files.
6) Look for C:\Documents and Settings\All Users\Desktop. When you click on Desktop, name the file whatever you want. That will be the name of the database when it appears on the desktop. Then, press ok. Press OK again. Press OK again. And, after finished, your MOST recent database should appear on the desktop.
