Newbie Spellweaver
- Joined
- Nov 1, 2010
- Messages
- 33
- Reaction score
- 8
1. REQUIRED FILES
1.1 Database
SQL Server 2008 Express:
SQL Server 2008 Management Studio:
SQL Server 2008 Service Pack 1 (available via Windows Update) (optional, mandatory in Windows 7)
Scripts of database for SQL 2008:
Server 1.2
Game Client 1.3
Client Files (game):
2. INSTALLATION
Note: Clean up temporary data from Windows using a cleaning program (eg CCleaner), before continuing with the tutorial.
2.1 Installing SQL Server 2008 Express
Run the installer for SQL Server 2008 Express. By default, the filename is SQLEXPR32_x86_PTB.exe 32bit version and 64bit version SQLEXPR_x64_PTB.exe.
Expect to continue extracting files.
On the screen that opens, select the left option "Setup". Then click New SQL Server stand-alone installation or add features to an existing installation.
Wait until a new window opens.
In the first step, the installer will check availability for installation on your computer. If errors occur in the test, try to correct them before proceeding.
Wait until a new window opens.
If everything is correct, click OK.
The window will close automatically. Wait until a new window opens.
You need to install support files. Click Install.
Please wait until the installation to continue.
In "Setup Support Rules," the installer will check again for availability. If errors occur in the test, try to correct them before proceeding. If all went well, click "Next."
Under "Product Key (Product Key)," make sure "Express" is selected and click Next.
In "License Terms" check box and click Next.
In "Feature Selection", select the "Engine Services Database" and click Next.
In "Instance Configuration", highlight the "Named Instance" with value SQLExpress, the rest leave it as is. Click Next.
In "Disk space requirements", then click Next.
(you must have enough disk space to be successful in this stage)
In "Server Settings", click Use the same account for all SQL services and put your user name and password of Windows. Automatically fields of the tab "Service Accounts" will be filled with data. Click Next.
In "Engine Configuration Database", select the "Mixed Mode (SQL Server Authentication and Windows)" and enter a password of your choice. We recommend a password with six characters (letters and / or numbers). This is your SQL password is used in almost everything.
Under "Specify SQL Server Administrators", click "Add current user." You can also add other Windows users, in the "Add ...". Then click Next.
In "Use Error Reporting", leave everything unchecked and click Next.
Again will be considered the availability of installation. Wait and click Next.
"Ready to Install", confirm the settings and click Install.
Wait for the progress of the installation before going to the next step.
2.3 Installing SQL Server 2008 SP1
Open Windows Update and check for updates. Update before installing the Management Studio, Windows 7.
2.2 Installing SQL Server 2008 Management Studio
Run the installation file in Management Studio.
If you see any warnings of incompatibility, just click "run program".
On the screen that opens, select the left option "Setup". Then click New SQL Server stand-alone installation or add features to an existing installation.
Wait until a new window opens.
Now follow the model of the previous installation. The only differences here that should be done differently, are:
Under "Installation Type", choose "Run a new installation of SQL Server" and click Next.
In "Feature Selection", select the "SQL Server Management Studio" and click Next.
Note: Restart the computer after installation.
2.4 Installing the Client
PristonTale run (test) _setup (1989). Exe and follow the installer instructions.
3. SETTING UP THE DATABASE
3.1 Opening SQL Management Studio
Open SQL Server 2008 Management Studio, you can find it in the Start Menu.
Once opened, change the form of authentication for SQL Server Authentication.
In "Logon", type sa.
In "Password", enter the password you entered when you install SQL Server Express in "Mixed Mode".
Check the Remember password and click Connect.
Note: Computer Go to Properties and check what the computer name. See if you like the section "Server Name" followed by \ EXPRESS.
When the SQL is done, expand the key database.
3.2 Creating Database
Right-click the key "Database" and select New Database.
On the screen that opens, type the name of the database in the field "Database" and click "OK".
Create the following databases:
3.3 Running Scripts
Go to where you stored the scripts available at the beginning of the topic and open one at a time with the notebook. Note that part of the script LevelListfaz accountdb database.
You should open each script with Notepad and copy all the text file. Then go to the database for and click New Query. Then paste all the copied text.
After pasting, click Run or press the F5 key.
If it appears that the command was executed successfully, you did it correctly.
You have to do the procedure with all databases. Follow the order in accordance with the following quote:
3.4 Enabling Protocols
For some functions of the server to function properly, we must enable the SQL protocols.
Open SQL Server Configuration Manager, found in the Start Menu.
In the window that opens, expand the key settings SQL Server Network Protocols and click the key to SQLEXPRESS.
On the right there will be some protocols. Right-click the Protocol "Named Pipes" and select Enable. Do the same with TCP / IP.
After you enable the two protocols, right-click on "TCP / IP" and choose Properties.
In the window that opens, go to the IP Addresses tab. Note that all IPs are in the "Enabled" is not marked. Unlock all the IPs were present. That is, where it says enabled, but not for a change.
In the last address, IPAll, enter the value 1433 in "TCP Dynamic Ports" and click "OK".
Then close everything and go to the next step.
Creating ODBC 3.5
Enter in Start Menu "ODBC", or go to Control Panel> Administrative Tools> Data Source (ODBC).
In the window that opens, click Add ....
In the window that opens, select SQL Server and click Finish.
A new window will open.
In "Name", type c8master.
In "Server", enter the name of your instance of SQL in the case NOMEDOPC \ SQLEXPRESS, and click Next.
Click Next again.
Check the Change the default database to and select accountdb. Click Next.
Click Finish.
ODBC data source on the set up.
4. SERVER SETTINGS
Once downloaded the files from the server, open the file Hotuk.ini.
4.1 Configuring Hotuk
Hotuk.ini Open with Notepad.
With it open, you must change the settings contained therein to your server. First, find the IP that is in hotuk (usually 127.0.0.1) and press Ctrl + H. It will open a pop-up.
We will replace all values of the document.
In the field of typing up (amount to be replaced), type the current IP: 127.0.0.1. In the lower box (new value), enter the desired IP.
Note: If you want to play alone, you can leave the default IP (127.0.0.1). If you want to play with others, change to your current IP / Hamachi / server-dedicated. In all the files that will change, you must put the same IP.
Once changed all IPs, change the following lines
5. Client Settings
Once installed Korean client, go to the folder and run the launcher. Wait until the game automatically update the launcher.
After upgrading, copy the folders and Field Char and paste them in the root directory.
Now remove all files in the root folder of the client, except HanDes.dll and folders.
Then take all the files cofiguração and put in folders, according to the following quote:
Registro.reg Open the file with a notepad and edit the following lines:
In "ServerName", put the name of your server.
In "Version" and "TestVersion" change to the version used game.exe to play the game. If you do not put the same version of game.exe, you can not enter the game through it.
After all, save and close.
Open the files and ldata.bmp ptReg.rgx with a notepad and edit them following the model of the previous step.
6. TESTING THE GAME
Note: To proceed with this step, the folders and Char Field should have been copied to the root folder of the server.
6.1 Creating Your Account
Open again the SQL Server 2008 Management Studio.
Expand the key database, and then the key accountdb the key tables.
You will see several tables.
If you entered any hotuk.ini ID in the file, we set up earlier, you should put that same ID in this step.
Now do the following:
For IDs that start with the letter A, open the table dbo.AGameUser. For IDs that start with the letter R, to follow dbo.RGameUser.
When you find the table for the first letter of your ID, right-click on it and select Edit Top 200 Rows.
It will open on the right side, complete the table for you. Enter your information in accordance with the following quote:
userid - your ID in the game. You should start with the same letter of the table.
Passwd - The password to log into the game. Maximum of eight characters, letters and numbers.
RegistDay - The current date.
DisuseDay - The current date.
StartDay - The current date.
Lastday - Put, for example, 31/12/2999.
EditDay - The current date.
In other fields, just put a 0 (zero).
After that you can close everything.
Note # 1: Do not click "Run" as it did in previous versions of SQL Management Studio. If you do, the data will be erased and will have to type everything again. Only close SQL Management Studio that data will be saved automatically. The next time you create a new account on the same table, add a line below normal.
Note # 2: SQL Server 2008 will automatically change your date. For example, DD / MM / YYYY to MM / DD / YYYY. This will prevent problems with the clan system.
Now go in the root folder of your server and run the account creation. Usually one or MakeAccUser.exe Contas.exe Creator.
With the tool opens, enter your ID in the first field and fill the rest with nicks, class and levels of their characters.
Then click Create.
If the server folder there called a LevelEditor.exe Apps, you can use it to change the level of your character, to the maximum level allowed by the server.
Just type the nickname and the new level and click the button to change.
Then just shut everything down.
6.2 Connecting the
Run Server.exe wait loading...
after run game.exe
6.3 Entering the Game
Now we go to client folder and run the game.exe. By default, you will log into the game like a normal player. To log the Game Master, make sure that the game.exe is not running, then take the file hotuk.ini GM, which can be found in the folder of your server (not the same hotuk.ini we set in previous steps) and place it in the root folder of your client.
After that, rerun the game.exe.
When the login screen appears, enter the ID and password you put in SQL Server 2008 Management Studio and hotuk.ini, both of which should be equal.
If everything is right, you will enter the game normally and have fun!
RECOMMENDED PROGRAMS
Hamachi
If you do not have a dedicated-server, use Hamachi to create and use a fixed IP on your server. Only those who have installed Hamachi can enter the server.
1.1 Database
SQL Server 2008 Express:
You must be registered to see links
|
You must be registered to see links
SQL Server 2008 Management Studio:
You must be registered to see links
|
You must be registered to see links
SQL Server 2008 Service Pack 1 (available via Windows Update) (optional, mandatory in Windows 7)
Scripts of database for SQL 2008:
You must be registered to see links
Server 1.2
You must be registered to see links
You must be registered to see links
Game Client 1.3
Client Files (game):
You must be registered to see links
You must be registered to see links
2. INSTALLATION
Note: Clean up temporary data from Windows using a cleaning program (eg CCleaner), before continuing with the tutorial.
2.1 Installing SQL Server 2008 Express
Run the installer for SQL Server 2008 Express. By default, the filename is SQLEXPR32_x86_PTB.exe 32bit version and 64bit version SQLEXPR_x64_PTB.exe.
Expect to continue extracting files.
On the screen that opens, select the left option "Setup". Then click New SQL Server stand-alone installation or add features to an existing installation.
Wait until a new window opens.
In the first step, the installer will check availability for installation on your computer. If errors occur in the test, try to correct them before proceeding.
Wait until a new window opens.
If everything is correct, click OK.
The window will close automatically. Wait until a new window opens.
You need to install support files. Click Install.
Please wait until the installation to continue.
In "Setup Support Rules," the installer will check again for availability. If errors occur in the test, try to correct them before proceeding. If all went well, click "Next."
Under "Product Key (Product Key)," make sure "Express" is selected and click Next.
In "License Terms" check box and click Next.
In "Feature Selection", select the "Engine Services Database" and click Next.
In "Instance Configuration", highlight the "Named Instance" with value SQLExpress, the rest leave it as is. Click Next.
In "Disk space requirements", then click Next.
(you must have enough disk space to be successful in this stage)
In "Server Settings", click Use the same account for all SQL services and put your user name and password of Windows. Automatically fields of the tab "Service Accounts" will be filled with data. Click Next.
In "Engine Configuration Database", select the "Mixed Mode (SQL Server Authentication and Windows)" and enter a password of your choice. We recommend a password with six characters (letters and / or numbers). This is your SQL password is used in almost everything.
Under "Specify SQL Server Administrators", click "Add current user." You can also add other Windows users, in the "Add ...". Then click Next.
In "Use Error Reporting", leave everything unchecked and click Next.
Again will be considered the availability of installation. Wait and click Next.
"Ready to Install", confirm the settings and click Install.
Wait for the progress of the installation before going to the next step.
2.3 Installing SQL Server 2008 SP1
Open Windows Update and check for updates. Update before installing the Management Studio, Windows 7.
Run the installation file in Management Studio.
If you see any warnings of incompatibility, just click "run program".
On the screen that opens, select the left option "Setup". Then click New SQL Server stand-alone installation or add features to an existing installation.
Wait until a new window opens.
Now follow the model of the previous installation. The only differences here that should be done differently, are:
Under "Installation Type", choose "Run a new installation of SQL Server" and click Next.
Note: Restart the computer after installation.
2.4 Installing the Client
PristonTale run (test) _setup (1989). Exe and follow the installer instructions.
3. SETTING UP THE DATABASE
3.1 Opening SQL Management Studio
Open SQL Server 2008 Management Studio, you can find it in the Start Menu.
Once opened, change the form of authentication for SQL Server Authentication.
In "Logon", type sa.
In "Password", enter the password you entered when you install SQL Server Express in "Mixed Mode".
Check the Remember password and click Connect.
Note: Computer Go to Properties and check what the computer name. See if you like the section "Server Name" followed by \ EXPRESS.
When the SQL is done, expand the key database.
3.2 Creating Database
Right-click the key "Database" and select New Database.
On the screen that opens, type the name of the database in the field "Database" and click "OK".
Create the following databases:
Note: You must create one at a time. Remember to create them in the same order mentioned just above.account_db
accountdb
BillingDb
BillingLogDb
ClanDB
GameLogDB
ItemLogDB
LogDB
PCRoom
PCRoomLog
rPTDB
SoD2DB
SodDb
3.3 Running Scripts
Go to where you stored the scripts available at the beginning of the topic and open one at a time with the notebook. Note that part of the script LevelListfaz accountdb database.
You should open each script with Notepad and copy all the text file. Then go to the database for and click New Query. Then paste all the copied text.
After pasting, click Run or press the F5 key.
If it appears that the command was executed successfully, you did it correctly.
You have to do the procedure with all databases. Follow the order in accordance with the following quote:
After running all the scripts, close everything. If you are prompted to save the data, click Yes and press OK.LevelList script> database accountdb
account_db script> database account_db
accountdb script> database accountdb
BillingDb script> database BillingDb
BillingLogDb script> database BillingLogDb
ClanDB script> database ClanDB
GameLogDB script> database GameLogDB
ItemLogDB script> database ItemLogDB
LogDB script> database LogDB
PCRoom script> database PCRoom
PCRoomLog script> database PCRoomLog
rPTDB script> database rPTDB
SoD2DB script> database SoD2DB
SodDb script> database SodDb
3.4 Enabling Protocols
For some functions of the server to function properly, we must enable the SQL protocols.
Open SQL Server Configuration Manager, found in the Start Menu.
In the window that opens, expand the key settings SQL Server Network Protocols and click the key to SQLEXPRESS.
On the right there will be some protocols. Right-click the Protocol "Named Pipes" and select Enable. Do the same with TCP / IP.
After you enable the two protocols, right-click on "TCP / IP" and choose Properties.
In the window that opens, go to the IP Addresses tab. Note that all IPs are in the "Enabled" is not marked. Unlock all the IPs were present. That is, where it says enabled, but not for a change.
In the last address, IPAll, enter the value 1433 in "TCP Dynamic Ports" and click "OK".
Then close everything and go to the next step.
Creating ODBC 3.5
Enter in Start Menu "ODBC", or go to Control Panel> Administrative Tools> Data Source (ODBC).
In the window that opens, click Add ....
In the window that opens, select SQL Server and click Finish.
A new window will open.
In "Name", type c8master.
In "Server", enter the name of your instance of SQL in the case NOMEDOPC \ SQLEXPRESS, and click Next.
Click Next again.
Check the Change the default database to and select accountdb. Click Next.
Click Finish.
ODBC data source on the set up.
4. SERVER SETTINGS
Once downloaded the files from the server, open the file Hotuk.ini.
4.1 Configuring Hotuk
Hotuk.ini Open with Notepad.
With it open, you must change the settings contained therein to your server. First, find the IP that is in hotuk (usually 127.0.0.1) and press Ctrl + H. It will open a pop-up.
We will replace all values of the document.
In the field of typing up (amount to be replaced), type the current IP: 127.0.0.1. In the lower box (new value), enter the desired IP.
Note: If you want to play alone, you can leave the default IP (127.0.0.1). If you want to play with others, change to your current IP / Hamachi / server-dedicated. In all the files that will change, you must put the same IP.
Once changed all IPs, change the following lines
In this section, change the three lines, respectively, which serves to activate the GM level 1/2/3. In this case, the command Master1, will activate the GM level 1, when typed in the game: /; Ativate Master1.*GAME_SERVER Alfa 127.0.0.1 127.0.0.1 127.0.0.1
*SERVER_NAME Priston Tale
*DEBUG_ID id for gm and admin login
*ADMIN_LOGIN
*ADMIN_NAME "Ativate"
*ADMIN_COMMAND "Master1"
*ADMIN_COMMAND "Master2"
*ADMIN_COMMAND "Master3"
5. Client Settings
Once installed Korean client, go to the folder and run the launcher. Wait until the game automatically update the launcher.
After upgrading, copy the folders and Field Char and paste them in the root directory.
Now remove all files in the root folder of the client, except HanDes.dll and folders.
Then take all the files cofiguração and put in folders, according to the following quote:
5.1 Setting Filesedit:
ldata.bmp
ptReg.rgx
Registro.reg
Registro.reg Open the file with a notepad and edit the following lines:
Change all the IP to the IP you put in Hotuk."Server1"="127.0.0.1"
"Server2"="127.0.0.1"
"Server3"="127.0.0.1"
"ServerName"="Priston Tale"
"Version"="1871"
"TestVersion"="1871"
In "ServerName", put the name of your server.
In "Version" and "TestVersion" change to the version used game.exe to play the game. If you do not put the same version of game.exe, you can not enter the game through it.
After all, save and close.
Open the files and ldata.bmp ptReg.rgx with a notepad and edit them following the model of the previous step.
6. TESTING THE GAME
Note: To proceed with this step, the folders and Char Field should have been copied to the root folder of the server.
6.1 Creating Your Account
Open again the SQL Server 2008 Management Studio.
Expand the key database, and then the key accountdb the key tables.
You will see several tables.
If you entered any hotuk.ini ID in the file, we set up earlier, you should put that same ID in this step.
Now do the following:
For IDs that start with the letter A, open the table dbo.AGameUser. For IDs that start with the letter R, to follow dbo.RGameUser.
When you find the table for the first letter of your ID, right-click on it and select Edit Top 200 Rows.
It will open on the right side, complete the table for you. Enter your information in accordance with the following quote:
userid - your ID in the game. You should start with the same letter of the table.
Passwd - The password to log into the game. Maximum of eight characters, letters and numbers.
RegistDay - The current date.
DisuseDay - The current date.
StartDay - The current date.
Lastday - Put, for example, 31/12/2999.
EditDay - The current date.
In other fields, just put a 0 (zero).
After that you can close everything.
Note # 1: Do not click "Run" as it did in previous versions of SQL Management Studio. If you do, the data will be erased and will have to type everything again. Only close SQL Management Studio that data will be saved automatically. The next time you create a new account on the same table, add a line below normal.
Note # 2: SQL Server 2008 will automatically change your date. For example, DD / MM / YYYY to MM / DD / YYYY. This will prevent problems with the clan system.
Now go in the root folder of your server and run the account creation. Usually one or MakeAccUser.exe Contas.exe Creator.
With the tool opens, enter your ID in the first field and fill the rest with nicks, class and levels of their characters.
Then click Create.
If the server folder there called a LevelEditor.exe Apps, you can use it to change the level of your character, to the maximum level allowed by the server.
Just type the nickname and the new level and click the button to change.
Then just shut everything down.
6.2 Connecting the
Run Server.exe wait loading...
after run game.exe
6.3 Entering the Game
Now we go to client folder and run the game.exe. By default, you will log into the game like a normal player. To log the Game Master, make sure that the game.exe is not running, then take the file hotuk.ini GM, which can be found in the folder of your server (not the same hotuk.ini we set in previous steps) and place it in the root folder of your client.
After that, rerun the game.exe.
When the login screen appears, enter the ID and password you put in SQL Server 2008 Management Studio and hotuk.ini, both of which should be equal.
If everything is right, you will enter the game normally and have fun!
RECOMMENDED PROGRAMS
Hamachi
If you do not have a dedicated-server, use Hamachi to create and use a fixed IP on your server. Only those who have installed Hamachi can enter the server.
Credits: Destroyzer
Last edited by a moderator: