PT Server download (Unfinished)

Server Setup Guide

There are a few server setup guides around but some are badly worded or outdated so I got bored and decided to make this. This will be revised and updated as time moves on to accommodate for new features and files. I would like to thank Redhunt for a lot of the pictures used in this guide.

Right off the bat I would suggest not running a PT server for the public on anything under 2GB of ram, a 100mbit line and a 3Ghz+ Processor and Windows Server 2003 (Dedicated Hosting is the best idea) along with a good understanding of how PT works.

Downloading Needed Files

1.) Download and install [Only registered and activated users can see links. Click Here To Register...]
(Used for unzipping most of the server files)

2.) Download [Only registered and activated users can see links. Click Here To Register...]
(SQL is used to store a lot of the player data, mainly clan information and login information)

3.) Download [Only registered and activated users can see links. Click Here To Register...]
(Used to manipulate SQL much easier.)

4.) If your running the server off of Windows XP ensure you have [Only registered and activated users can see links. Click Here To Register...] installed.

5.) Download any of the the files under the ---[Server Files]--- section in the [Only registered and activated users can see links. Click Here To Register...], I would suggest the McMadness Repack or the 1855 Server & Client. I might pack a couple sets of pre-configured server files with different rates later on.
(The in fact server software used for players to login and play, etc etc)

6.) Download the [Only registered and activated users can see links. Click Here To Register...].

7.) Download the clan files from the [Only registered and activated users can see links. Click Here To Register...] under the ---[Clan Files]--- section, I would suggest the Sandurr 2.0 Files [Only registered and activated users can see links. Click Here To Register...] or [Only registered and activated users can see links. Click Here To Register...]
(Only if you plan on having working clans)

Installing of SQL & Manager

6.) Start the install for the MsSQL Server 2005 Express Edition, continue pressing the next button until you reach the Features screen.

7.) Click Client Components like in this [Only registered and activated users can see links. Click Here To Register...] and select "Entire Feature will be installed on local hard drive"

8.) Continue pressing next until the screen prompting you to decide between "SQL Server Authentication" or "Windows Authentication".

9.) Choose SQL Server Authentication and choose a good password and right it down you will need to know this password later.

10.) Continue pressing next until the installer is finished.

11. Find the MsSQL Server Managment Studio installer you downloaded earlier. Just press next until the installer is done, no need to change any settings.

Setting Up SQL Database

12.) Go to your start menu and run SQL Server Management.
( Start > All Programs >Microsoft SQL Server 2005 > SQL Server Management Studio Express)

13.) You should arrive at [Only registered and activated users can see links. Click Here To Register...], don't touch the login name. Enter the password from step 9 created while installing SQL. Press connect and you'll arrive at [Only registered and activated users can see links. Click Here To Register...]

14.) Unzip (right click, extract to folder) the PT SQL Files to any folder.

15.) Click the expand tab "+" next to Databases, right click Database and select "Create New Database" the names of all 11 Databases are the same names as the PT SQL Files names. List:

Account_DB
AccountDB
BillingDB
BillingLogDB
ClanDb
GamelogDb
ItemLogDb
PCRoom
SoD2Db
SoDDb

It should look like [Only registered and activated users can see links. Click Here To Register...] when done.

16.) After finished making all of the Databases (DB's) go back and right click Account_DB and select "New Query" like [Only registered and activated users can see links. Click Here To Register...], once that is done open up the coresspending named Text file from the PT SQL Files folder.

17.) Copy and paste the entire text files contents into the Query window and press "!Execute"18.) Repeat steps 16 & 17 for all 11 Database's. When it asks you to save for all of the query's you can either pick yes or no, it makes no difference.

19.) When done check back on your DB's to make sure when expanded they look like [Only registered and activated users can see links. Click Here To Register...]

Setting up ODBC or SQL.dll

This step is a little optional because you have a choice, either use ODBC or setup the SQL.dll properly, for this guide I will list the ODBC method, for the SQL.dll method I might make a guide later on, or look around the forums for it (Searching never hurt anyone)

20.) Click Start > Programs > Accessories > Administrative Tools > (ODBC)Data Source. (Administrative Tools can also be reached via the Control Panel)

21.) Choose the "DSN System" tab and then proceed to click "Add", scroll down to the very bottom and pick "[Only registered and activated users can see links. Click Here To Register...]" and then finish.

22.) After finish is pressed a window should pop up asking for: Name, Description and SQL Server Name.

Name: c8master

Description: Whatever you want.

Name: The name of your SQL Server Instance (Should look like XXXXX\SQLEXPRESS)
(If you forget just open your Studio Manager and look at the server name)

23.) Click next twice until you reach [Only registered and activated users can see links. Click Here To Register...], change the default Database to AccountDB (Not Account_DB theres a difference) and click next until done.

Connecting to Your Server

24.) Create a registry file using this code (Use notepad):

Code:

               Windows Registry Editor Version 5.00
 
[HKEY_LOCAL_MACHINESOFTWARETriglow Pictures]
 
[HKEY_LOCAL_MACHINESOFTWARETriglow PicturesPristonTale]
"Version"="3096"
"Account"=""
"CameraInvert"="false"
"CameraSight"="OFF"
"ColorBPP"="32"
"Graphic"="1"
"MicOption"="OFF"
"MotionBlur"="false"
"Network"="1"
"ScreenSize"="0"
"Server1"="xxx.xxx.xxx.xxx"<---your IP here
"Server2"="xxx.xxx.xxx.xxx"<---your IP here
"Server3"="xxx.xxx.xxx.xxx"<---your IP here
"ServerName"="Server Name"
"Sound"="On"

Make sure you change the IPs to your Lan/Wan IPs or the local host IP (127.0.0.1)

25.) Create a .bmp using this code (Use notepad to edit it)

Code:

A8ת $1@Q?y��(                                                                *Graphic 1 
*Network 1 
*ColorBPP 32 
*MotionBlur false 
*CameraSight OFF 
*ScreenSize 0 
*MicOption OFF 
*Sound On 
*CameraInvert false 
*Server1 xxx.xxx.xxx.xxx<---YOUR IP
*Server2 xxx.xxx.xxx.xxx<---YOUR IP
*Server3 xxx.xxx.xxx.xxx<---YOUR IP
*ServerName YOUR PT NAME
*Version 3096 
*TestVersion 0

Once again make sure to change the IPs, place this file in your PT folder (Client folder NOT server folder) within the images directory, it will ask you to replace, select yes.

26.) Make sure you have the correct client for the server version your using: kPT = 1840 - 1860 and 2331 (for older kPT servers), jPT = 3096 - 3100.

Configuring Your Server

27.) Extract your choice of server files (McMadness Repack, dPT, 1855, whatever) to a folder on the desktop named "PT Server"

28.) Go into your PT Client folder and copy the "Field" and "Char" folders into your "PT Server" folder (Make sure to COPY and not CUT)

29.) After thats done, open up the file called Hotuk.ini and go to this line:

*GAMSERVER

First parameter is the name that appears when players are connecting like this:

*GAMESERVER WhateverPT

The next 3 parameters are your Lan/Wan/Local IP

*GAMSERVER WhateverPT 127.0.0.1 127.0.0.1 127.0.0.1

30.) While your here you may want to set your exp rate on with the *EVENT_EXPUP command.

Setting the number decides the exp multiplier. Such as:

*EVENT_EXPUP 400 would be something around "40x" rates

*EVENT_EXPUP 500 would be something around "50x" rates

*EVENT_EXPUP 600 would be...well you get the idea.

30.) I'll post some pre-configured Hotuk.ini's below somewhere.

Thats the end of the basic server setup guide, continue to the next post for the FAQ's

Frequently Asked Questions (FAQ)

Q: Question
A: Answer

Mostly importantly I would just like to reiterate [Only registered and activated users can see links. Click Here To Register...] is your friend, use it when questions arise!
______________________________________________

Q: Why does my server crash every hour on the dot?
A: Remove daeth_night.ini from your monster folder. Also may be a lack of ram.
----------------------------------------------------------------------
Q: I did everything the guide said but can't connect!
A: Make sure you edited your Idata.bmp and your registry.
-----------------------------------------------------------------------
Q: I keep getting "Conn. Failed", whats wrong?
A: You forgot to edit the *GAMESERVER parameter or forgot to change the IP's in the registry / Idata.bmp
------------------------------------------------------------------------
Q: Why do I get the message "Version does not match"?
A: Your using the incorrect version for your server, or you have the *VERSION parameter with the wrong client value there.
-------------------------------------------------------------------------
Q: I've been messing with clans for DAYS and can't get them to work!
A: [Only registered and activated users can see links. Click Here To Register...] or [Only registered and activated users can see links. Click Here To Register...]
-------------------------------------------------------------------------
Q: Uh, how do I make an account!?
A: Use a register script, makes your day much easier.
--------------------------------------------------------------------------
Q: Where do I get a register script?
A: The RFT Thread
---------------------------------------------------------------------------
Q: Well how do I use a register script?
A: Install a Webserver (HTTP)
---------------------------------------------------------------------------
Q: A webserver!?
A: Yes a webserver, I would suggest Apache or IIS, you could also try Baby Webserver
----------------------------------------------------------------------------
Q: How do I make uber super cool items!
A: You shouldn't, but if your going to anyway go [Only registered and activated users can see links. Click Here To Register...].
----------------------------------------------------------------------------
Q: What are the GM Commands?
A: Search for things in the future, [Only registered and activated users can see links. Click Here To Register...].
-----------------------------------------------------------------------------
Q: Why doesn't everyone help me!
A: Because their here to share, and if your just taking, why help you?
------------------------------------------------------------------------------
Q: If I want to seriously host a server, what should I do?
A: Get a dedicated team, either get [Only registered and activated users can see links. Click Here To Register...] or get a good computer at home (2GB+ Ram, 3Ghz+ processor) on its own DSL (30 - 40 people), T1 (50 - 80 people) or a FiOS line (100+ people).
-------------------------------------------------------------------------------
Q: I've read all the guides, I've read this FAQ, I even bugged 30 people to death on MSN and I can't figure any of this out!
A: May I suggest you give up?
--------------------------------------------------------------------------------
Q: I do not know of these "files" and "resources" of which you speak.
A: Amazingly enough, the thread tagged [Only registered and activated users can see links. Click Here To Register...] contains, resources! (Reading is a wonderful skill)

Troubleshooting Guide

Hotuk.ini Problems

The Hotuk controls a lot of things, such as EXP rate (Could manually edit the monsters themselves but this is cleaner) and GM status and such. Lets start with a Hotuk thats already more or less preconfigured (IPs still need to be changed for public playing)

Code:

//Cleaned and Explained Hotuk by SiK
//www.rz.com

//Dont Edit these 3 lines
*MODE SERVER
*SERVER_CODE 0
*SERVER_AUTOPLAY

//Your Server Name
*SERVER_NAME YourPT

// Leave as 127.0.0.1 if playing with yourself, change to external IP if going public.
*GAME_SERVER Alpha 127.0.0.1 127.0.0.1 127.0.0.1

//Only enable if you have clans installed. 
//Delete the // before *CLAN_SERVER and *ENABLE_CLAN to enable
//*CLAN_SERVER  127.0.0.1 80 127.0.0.1 80

//Max amount of people able to login.
*MAX_USERS 20

// No need to change
*SERVER_RECORD_MEM
*CHECK_POTION_COUNT 10000
*ENABLE_PARTYITEM
*PERMIT_EXP    20000000
*ENABLE_SERVER_EXP  20000000
*PERMIT_MONEY    20000000

//Events that run themselves (Some require NPCs to function)
*EVENT_MOLLYWOLF
*EVENT_POTION 20
*EVENT_HARDCORE
*EVENT_MORIFSHELTOM
*EVENT_VALENTINEDAY
*EVENT_SANTAGOBLIN
*EVENT_BIRTHDAY
*EVENT_BABELHORN
*EVENT_PUZZLE

//Changes the server exp rates (Dont do anything stupid like 100000) Default rate: 50x
*EVENT_EXPUP 500 

//*PK_FIELD Picks a field where players can attack each other (PK)
*PK_FIELD 16

//Other Events
*EVENT_BLESSCASTLE
*EVENT_CHILD
*EVENT_SUMMER_CHICKEN
*EVENT_NINEFOX
*EVENT_BITMASK     32

//Sets Bless Castle to automatically turn itself on.
*EVENT_BLESSCASTLE  20
*EVENT_SIEGE_TIME  7

//Displays sometime of message upon player login
//*DISP_BILLING_TIME

//Leave 127.0.0.1 if playing by yourself, external IP or disable if public.
*LOGIN_SERVER_IP 127.0.0.1 127.0.0.1 127.0.0.1
*SERVER_LINK_IP  127.0.0.1 127.0.0.1 127.0.0.1

//Denotes your directory that backups are stored within.
*BACKUP_FOLDER_NAME "c:databasebackup"
*BACKUP_PATH "c:databasebackup"

//DEBUG_ID are the names of your GM(s) accounts
*DEBUG_ID GM1 GM2 GM3 

//DEBUG_IP are the IPs of your GM(s)
*DEBUG_IP 127.0.0.1 127.0.0.1 127.0.0.1 127.0.0.1

//Admin Login is the master password to login any account
*ADMIN_LOGIN "Admin" 

//*ADMIN_NAME is the name used when giving yourself GM powers in this case level 3 would be "/;Admin Hello3" and level 3 would be "/;Admin Hello2" 
*ADMIN_NAME "Admin"

//*ADMIN_COMMAND are your GM passphrases, if going public change these.
*ADMIN_COMMAND "Hello1"
*ADMIN_COMMAND "Hello2"
*ADMIN_COMMAND "Hello3"

SQL.dll Problems

Other Problems

Credits and Thanks

QuantumFusion - Great guy, helped me so much when I didn't know what the hell I was doing, also releases so many things to help the community. # 1 in my book.

Teletaro - Turned into a behind the scenes guy, but if there are big breakthroughs its pretty much guaranteed that Teletaro helped on it.

Shagpub - Another behind the scenes guy, but releases his work when he can, helps the community a tremendous amount.

Operz - Helps a lot when he can, tries to help make people help themselves which is what they SHOULD do.

Sandurr - Helps in the form of cryptic vague clues, but still has a lot of his stuff floating around. No one tends to give him credit for anything.

HappyHardcore - Still helped a lot prior to mod-dome, and I'm sure he'll do a great job now that he has the power to enforce rules around here.

Well sorry to anyone who felt they should have been included but a thank you is in order to the rz community in general, no other place like this!

[/CENTER]

<hr>Append on Apr 28 2007, 15:39<hr> bitte html erlauben sonst fehlerhafte anzeige
thx

<hr>Append on Apr 28 2007, 15:40<hr> 
heisst --> ?