Server Files & DataBase & SQL
1. 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 -> [local]
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
"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-
- [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=Your IP
- NAME_00=Server Name
- [TIMER]
- YEAR=2
- MONTH=2
- DATE=1
- HOUR=12
- WEATHER=1
- [LOGIN SERVER]
- IP=Your IP
- [CASTLE]
- NATION=1
- [ZONE_INFO]
- 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
- [BATTLE]
- WEEK=6
- START_TIME=20
- END_TIME=0
- [AI_SERVER]
- IP=Your IP
- [DB_SERVER]
- IP=Your IP
- [ODBC]
- GAME_DSN=KN_online
- GAME_UID=knight
- GAME_PWD=knight
- GAME_DSN3=KN_online
- GAME_UID3=knight
- GAME_PWD3=knight
- [VERSION]
- VER=1098
- [ODBC]
- 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
- [ZONE_INFO]
- GROUP_INFO=2
- ZONE_INFO=2
- [ODBC]
- GAME_DSN=KN_online
- GAME_UID=knight
- GAME_PWD=knight
- [SERVER]
- ZONE=2
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.
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 |
