How to Create a Private Server Updated (1/4/08)
Server Files & DataBase & SQL1. Server Files by Ellemen 1098
2. DataBase BackUp
3. SQL Server
Password: by_ellemen
4. SQL Installation:
1. "Install Database Server"
2. Next
3. Local Computer and Next
4. "Create a new instance of SQL Server, or install Client Tools" & next
5. Put your Company Name
6. Yes to Agreement
7. Server and Client Tools and Next
8. Default at top and Click Next
9. Typical Click Next
10. "Use the same account for each service. Auto start SQL Server Service"
11. "Use the Local System account" Click Next
12. "Mixed Mode.? enter password and confirm password remember it, username is ALWAYS "sa" (server admin) <-- twostars edit: SUPER admin, not server admin..
13. next and install
14. After install rebot your pc <-- twostars edit: reboot not rebot
5. Creating DataBase
1. Go To Manager (Start -> AllPrograms -> Microsoft SQL Server -> Enterprise Manager)
2. Console Root -> Microsoft SQL Servers -> SQL server Group ->
3. press right mouse button on (local) (windows) -> Edit SQL server Registration properties
4 .Take Use SQL Server authentication -> Login name (You can change if you wont) -> put your password " You typing it in Installation look at point 12 -> Always prompt for login name and password *Let`s go to Databases.
5. Press Right button on your mouse go to new database( In name put KN_online press ok
6. Right button on your mouse on KN_online database after "AllTask" "Restore Database".
7. "From Device" i "Select Devices".
8. "Add" and take you backup database KN_online
9. "OK" 2 times next go to "Options".
10. "Force restore over existing database"
11. "OK"
12. Console Root -> Microsoft SQL Servers -> SQL server Group ->
13. Security -> Login -> Right Button -> New Login
14. Login knight -> "sql server authentication"
15. Password knight -> KN_online "Database"
16. i Database access ->(database) KN_online
17. "db_owner" -> ok
6.DNS(ODBC):
1. Control Panel -> Admin Tools -> (ODBC) Tools -> System DNS "ADD"
2. "SQL server" Close
3. Name: KN_online, Descrpition leave it. Server put what you got there
http://img216.imageshack.us/img216/9366/sqlyo4mi9.png
"Next"
4. "SQL AUTHECION..." ID LOGIN: knight Password: knight "Next"5. Change DataBase to KN_online "Next" And "Ok"
SQL , DATABASE , ODBC IS READY
7. Server Files Configuration:
loginserver/version.ini
URL=wizgate.nefficient.co.kr
PATH=pub/wizgate2/knight/upgrade
DSN=KN_online
UID=knight
PWD=knight
TABLE=VERSION
DEFAULT_PATH=D:\
COUNT=1
SERVER_00=Your IP
NAME_00=Server NameEbenezer/server.ini
YEAR=2
MONTH=2
DATE=1
HOUR=12
WEATHER=1
IP=Your IP
NATION=1
MY_INFO=2
SERVER_COUNT=4
SERVER_00=1
SERVER_IP_00=Your IP
SERVER_01=2
SERVER_IP_01=Your IP
SERVER_02=3
SERVER_IP_02=Your IP
SERVER_03=4
SERVER_IP_03=Your IP
SERVER_NUM=0
WEEK=6
START_TIME=20
END_TIME=0
IP=Your IP
IP=Your IP
GAME_DSN=KN_online
GAME_UID=knight
GAME_PWD=knight
GAME_DSN3=KN_online
GAME_UID3=knight
GAME_PWD3=knight
VER=1098Aujard/Aujard.ini
ACCOUNT_DSN=KN_online
ACCOUNT_UID=knight
ACCOUNT_PWD=knight
GAME_DSN=KN_online
GAME_UID=knight
GAME_PWD=knight
GAME_DSN2=KN_online
GAME_UID2=knight
GAME_PWD2=knight
LOG_DSN=KN_online
LOG_UID=knight
LOG_PWD=knight
GROUP_INFO=2
ZONE_INFO=2AIServer/server.ini
GAME_DSN=KN_online
GAME_UID=knight
GAME_PWD=knight
ZONE=2Server is Ready! ( How to Start)
1. loginserver/VersionManager.exe
2. AIServer/Server.exe
3. Ebenezer/Ebenezer.exe
4. Aujard/ Aujard.exe
Creating Account:
1. Enterprise Manager (Start -> AllPrograms -> Microsoft SQL Server ->
Enterprise Manager) Databases
2. KN_online (expand it open)
3. Tables
4. edit TB_USER -> Open table -> Return all rows.
http://img216.imageshack.us/img216/7/accountpg6aa2.png
How to Give GM:
1. Start>AllPrograms>Microsoft SQL Server>Enterprise Manager> Databases> KN_Online> Tables>User data.
2. Find Your User in Column Authority change number:
GM=0; Normal Player=1; Banned user=2; can not write on chat= 255
GM Commands:
/notice text- Showing Notice on server
/count- Showing how much ppl is online
/rain 100- Rain
/snow 100- Snow
/clean- Good Weather
/time- Change day for night
Admin Commands ebenezer:
/open- Open Battle
/close- Close Battle
/down- Kick All Users from Server
Character Lagg : Change zone in .INI files zone should be 2 same in database
No NCP No Monsters : - If you got error on running ebenzer Can not connect to AISERVER then you put wrong login or password to Access to your database or you didnt give premisions to your db user.
Credits:
Ellemen and Oq3k From RageZone 我好想买但是我买金币郁闷~~~~~~~~~:'( CT大哥可以免费给我个不呵呵 我急用呢郁闷了单机 自己想拿你的教程参考下呢可惜没5毛钱买5555555555 谢谢分享了 我来学习学习 原帖由 6680 于 2008-1-6 20:20 发表 http://www.kofans.cn/bbs/static/image/common/back.gif
我急用呢郁闷了单机 自己想拿你的教程参考下呢可惜没5毛钱买5555555555
有免费地址可以下，仔细看贴啊 好东西，我为人人，人人为我:victory: