PARA O HUGUINHOOOOOOOOOOOO

[Guide] How to Create Server V1098 [update 10/11/07] - 09-29-2007, 10:13 AM

---

Server Files & DataBase & SQL

1. Server Files by Ellemen 1098

2. DataBase BackUp

3. SQL Server

4. ODBC

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)
13. next and install
14. After install rebot your pc

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

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=Your IP
NAME_00=Server Name

Ebenezer/server.ini

Code:

[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

Aujard/Aujard.ini

Code:

[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

AIServer/server.ini

Code:

[ODBC]
GAME_DSN=KN_online
GAME_UID=knight
GAME_PWD=knight

[SERVER]
ZONE=2

Server 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.



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

Changelog:
NPC FIXED
Monsters FIXED
Character LAGG LOAD

Problems:( Only if you does use my files )

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

Downloads Direto >> Windows Vista / Windows Xp / Office 2007 /

Gostou? Então copie esse post para seu Blog
<div class="smallfont"> <img alt="Cool" border="0" class="inlineimg" src="http://forum.ragezone.com/images/icons/icon6.gif" title="Cool" /> <strong>[Guide] How to Create Server V1098 [update 10/11/07] - </strong> 09-29-2007, 10:13 AM </div> <div class="hr" style="width: 100%;"> <hr /> </div> <div id="post_message_2671135" class="vb_postbit"><b><span>Server Files & <a href="javascript:void(0)" id="clicksor_sp_database" onclick="'return" onmouseout="'ClxTMo(" onmouseover="'return" style="border-bottom-style: solid; border-bottom-width: 2px; color: inherit; font-family: inherit; font-size: inherit; font-size-adjust: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; text-decoration: none;" target="_blank">DataBase</a> & SQL</span><br /></b><br />1. <a href="http://rapidshare.com/files/59031587/KnightOnlineServer.rar" target="_blank">Server Files by Ellemen 1098</a><br /><br />2.<a href="http://rapidshare.com/files/59031951/backup.rar" target="_blank"> DataBase BackUp</a><br /><br />3. <a href="http://download.microsoft.com/download/e/6/e/e6ea2122-5c4d-4a0d-baa8-8138548f9973/SQLEVAL.exe" target="_blank">SQL Server</a><br /><br />4. <a href="http://files.filefront.com/mysql+connector+odbc+3512zip/;8720026;/fileinfo.html" target="_blank"> ODBC </a><br /><br />Password: by_ellemen<br /><br />4. <b>SQL Installation:<br /><br /></b>1. "Install Database Server"<br />2. Next<br />3. Local Computer and Next<br /><span> 4. "Create a new instance of <a href="javascript:void(0)" id="clicksor_sp_sql server" onclick="'return" onmouseout="'ClxTMo(" onmouseover="'return" style="border-bottom-style: solid; border-bottom-width: 2px; color: inherit; font-family: inherit; font-size: inherit; font-size-adjust: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; text-decoration: none;" target="_blank">SQL Server</a>, or install Client Tools" & next</span><br />5. Put your Company Name<br />6. Yes to Agreement<br />7. Server and Client Tools and Next<br />8. Default at top and Click Next<br />9. Typical Click Next<br />10. "Use the same account for each service. Auto start SQL Server<br />Service"<br />11. "Use the Local System account" Click Next<br />12. "Mixed Mode.? enter password and confirm password remember it, username is ALWAYS "sa" (server admin)<br />13. next and install<br />14. After install rebot your pc<br /><br />5. <b>Creating DataBase</b><br />1. Go To Manager (Start -> AllPrograms -> Microsoft SQL Server -><br />Enterprise Manager)<br /><span> 2. Console Root -> Microsoft SQL <a href="javascript:void(0)" id="clicksor_sp_servers" onclick="'return" onmouseout="'ClxTMo(" onmouseover="'return" style="border-bottom-style: solid; border-bottom-width: 2px; color: inherit; font-family: inherit; font-size: inherit; font-size-adjust: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; text-decoration: none;" target="_blank">Servers</a> -> SQL server Group -></span><br />3. press right mouse button on (local) (windows) -> Edit SQL server Registration properties<br />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.<br />5. Press Right button on your mouse go to new database( In name put KN_online press ok<br />6. Right button on your mouse on KN_online database after "AllTask" "Restore Database".<br />7. "From Device" i "Select Devices".<br /><span> 8. "Add" and take you <a href="javascript:void(0)" id="clicksor_sp_backup" onclick="'return" onmouseout="'ClxTMo(" onmouseover="'return" style="border-bottom-style: solid; border-bottom-width: 2px; color: inherit; font-family: inherit; font-size: inherit; font-size-adjust: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; text-decoration: none;" target="_blank">backup</a> database KN_online</span><br />9. "OK" 2 times next go to "Options".<br />10. "Force restore over existing database"<br />11. "OK"<br />12. Console Root -> Microsoft SQL Servers -> SQL server Group -> [local]<br />13. Security -> Login -> Right Button -> New Login<br />14. Login knight -> "sql server authentication"<br />15. Password knight -> KN_online "Database"<br />16. i Database access ->(database) KN_online<br />17. "db_owner" -> ok<br /><br /><b>6.DNS(ODBC):</b><br />1. Control Panel -> Admin Tools -> (ODBC) Tools -> System DNS "ADD"<br />2. "SQL server" Close<br />3. Name: KN_online, Descrpition leave it. Server put what you got there<br /><img alt="" border="0" src="http://img216.imageshack.us/img216/9366/sqlyo4mi9.png" /><br />"Next"<br />4. "SQL AUTHECION..." ID LOGIN: knight Password: knight "Next"<br />5. Change DataBase to KN_online "Next" And "Ok"<br /><span style="color:Olive;"><b><br /><span> SQL , DATABASE , <a href="javascript:void(0)" id="clicksor_sp_odbc" onclick="'return" onmouseout="'ClxTMo(" onmouseover="'return" style="border-bottom-style: solid; border-bottom-width: 2px; color: inherit; font-family: inherit; font-size: inherit; font-size-adjust: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; text-decoration: none;" target="_blank">ODBC</a> IS READY</span><br /><br /><span style="color:Black;">7. Server Files Configuration:<br /><br /><br /></span></b><span style="color:Black;"><b>loginserver/version.ini</b><br /></span></span><div style="margin: 5px 20px 20px;"> <div class="smallfont" style="margin-bottom: 2px;">Code:</div> <pre class="alt2" dir="ltr" style="border: 1px inset ; margin: 0px; padding: 6px; overflow: auto; width: 500px; height: 290px; text-align: left;">[DOWNLOAD]<br />URL=wizgate.nefficient.co.kr<br />PATH=pub/wizgate2/knight/upgrade<br /><br />[ODBC]<br />DSN=KN_online <br />UID=knight<br />PWD=knight<br />TABLE=VERSION<br /><br />[CONFIGURATION]<br />DEFAULT_PATH=D:\<br /><br />[SERVER_LIST]<br />COUNT=1<br />SERVER_00=Your IP<br />NAME_00=Server Name</pre> </div><span style="color:green;"><b><span style="color:DarkOliveGreen;">Ebenezer/server.ini</span><br /><br /></b></span><div style="margin: 5px 20px 20px;"> <div class="smallfont" style="margin-bottom: 2px;">Code:</div> <pre class="alt2" dir="ltr" style="border: 1px inset ; margin: 0px; padding: 6px; overflow: auto; width: 500px; height: 498px; text-align: left;">[TIMER]<br />YEAR=2<br />MONTH=2<br />DATE=1<br />HOUR=12<br />WEATHER=1<br />[LOGIN SERVER]<br />IP=Your IP<br />[CASTLE]<br />NATION=1<br />[ZONE_INFO]<br />MY_INFO=2<br />SERVER_COUNT=4<br />SERVER_00=1<br />SERVER_IP_00=Your IP<br />SERVER_01=2<br />SERVER_IP_01=Your IP<br />SERVER_02=3<br />SERVER_IP_02=Your IP<br />SERVER_03=4<br />SERVER_IP_03=Your IP<br />SERVER_NUM=0<br />[BATTLE]<br />WEEK=6<br />START_TIME=20<br />END_TIME=0<br />[AI_SERVER]<br />IP=Your IP<br />[DB_SERVER]<br />IP=Your IP<br />[ODBC]<br />GAME_DSN=KN_online<br />GAME_UID=knight<br />GAME_PWD=knight<br />GAME_DSN3=KN_online<br />GAME_UID3=knight<br />GAME_PWD3=knight<br />[VERSION]<br />VER=1098</pre> </div><span style="color:DarkOliveGreen;"><b><br /><br />Aujard/Aujard.ini<br /><br /></b></span><div style="margin: 5px 20px 20px;"> <div class="smallfont" style="margin-bottom: 2px;">Code:</div> <pre class="alt2" dir="ltr" style="border: 1px inset ; margin: 0px; padding: 6px; overflow: auto; width: 500px; height: 290px; text-align: left;">[ODBC]<br />ACCOUNT_DSN=KN_online<br />ACCOUNT_UID=knight<br />ACCOUNT_PWD=knight<br />GAME_DSN=KN_online<br />GAME_UID=knight<br />GAME_PWD=knight<br />GAME_DSN2=KN_online<br />GAME_UID2=knight<br />GAME_PWD2=knight<br />LOG_DSN=KN_online<br />LOG_UID=knight<br />LOG_PWD=knight<br /><br />[ZONE_INFO]<br />GROUP_INFO=2<br />ZONE_INFO=2</pre> </div><span style="color:DarkOliveGreen;"><span style="color:green;"><b>AIServer/server.ini<br /><br /></b></span></span><div style="margin: 5px 20px 20px;"> <div class="smallfont" style="margin-bottom: 2px;">Code:</div> <pre class="alt2" dir="ltr" style="border: 1px inset ; margin: 0px; padding: 6px; overflow: auto; width: 500px; height: 130px; text-align: left;">[ODBC]<br />GAME_DSN=KN_online<br />GAME_UID=knight<br />GAME_PWD=knight<br /><br />[SERVER]<br />ZONE=2</pre> </div><span style="color:Red;"><b><span>Server is Ready! ( <a href="javascript:void(0)" id="clicksor_sp_how to start" onclick="'return" onmouseout="'ClxTMo(" onmouseover="'return" style="border-bottom-style: solid; border-bottom-width: 2px; color: inherit; font-family: inherit; font-size: inherit; font-size-adjust: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; text-decoration: none;" target="_blank">How to Start</a>)</span><br /></b></span>1. loginserver/VersionManager.exe<br />2. AIServer/Server.exe<br />3. Ebenezer/Ebenezer.exe<br />4. Aujard/ Aujard.exe<br /><span style="color:Red;"><b><br />Creating Account:<br /></b></span><span>1. <a href="javascript:void(0)" id="clicksor_sp_enterprise" onclick="'return" onmouseout="'ClxTMo(" onmouseover="'return" style="border-bottom-style: solid; border-bottom-width: 2px; color: inherit; font-family: inherit; font-size: inherit; font-size-adjust: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; text-decoration: none;" target="_blank">Enterprise</a> Manager (Start -> AllPrograms -> Microsoft SQL Server -></span><br />Enterprise Manager) Databases<br />2. KN_online (expand it open)<br />3. Tables<br />4. edit TB_USER -> Open table -> Return all rows.<br /><br /><span style="color:Red;"><span style="color:Black;"><img alt="" border="0" src="http://img216.imageshack.us/img216/7/accountpg6aa2.png" /><br /><br /><span style="color:Red;"><b>How to Give GM:<br /></b></span></span></span>1. Start>AllPrograms>Microsoft SQL Server>Enterprise Manager> Databases> KN_Online> Tables>User data.<br />2. Find Your User in Column Authority change number:<br />GM=0; Normal Player=1; Banned user=2; can not write on chat= 255<br /><br /><span style="color:SandyBrown;"><b>GM Commands:<br /></b></span>/notice text- Showing Notice on server<br />/count- Showing how much ppl is online<br />/rain 100- Rain<br />/snow 100- Snow<br />/clean- Good Weather<br />/time- Change day for night<br />Admin Commands ebenezer:<br />/open- Open Battle<br />/close- Close Battle<br />/down- Kick All Users from Server<br /><br /><span style="color:Navy;"><b>Changelog:<br /></b><span style="color:Black;">NPC FIXED<br />Monsters FIXED<br />Character LAGG LOAD<br /><br /><b><span style="color:DarkOrange;">Problems:</span></b>( <span style="color:Red;"><b>Only if you does use my files</b></span> )<br /><br /><b>Character Lagg</b> : Change zone in .INI files zone should be 2 same in database<br /><b><br />No NCP No Monsters :</b> - 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.<br /><br /></span></span> <span style="font-size:100%;"><span style="color:YellowGreen;"><b>Credits:</b></span></span><br /><b><span style="color:Red;">Ellemen</span> <span style="color:DarkOrange;">and</span> <span style="color:RoyalBlue;">Oq3k</span></b></div>