[Guide][Any Files] Server Setup | FAQ | Troubleshooting Guide

[SiK]

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

You must be registered to see links

(Used for unzipping most of the server files)
​

​

2.) Download

You must be registered to see links

(SQL is used to store a lot of the player data, mainly clan information and login information)

3.) Download

You must be registered to see links

(Used to manipulate SQL much easier.)

4.) If your running the server off of Windows XP ensure you have

You must be registered to see links

installed.

5.) Download any of the the files under the ---[Server Files]--- section in the RFT Thread, 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 [strike]

You must be registered to see links

[/strike]. View attachment script.rar

7.) Download the clan files from the RFT Thread under the ---[Clan Files]--- section, I would suggest the Sandurr 2.0 Files *Help topic here* or *HappHardcore's General Clan Troubleshooting Guide*
(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

You must be registered to see links

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

You must be registered to see links

, don't touch the login name. Enter the password from step 9 created while installing SQL. Press connect and you'll arrive at

You must be registered to see links

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

You must be registered to see links

when done.

16.) After finished making all of the Databases (DB's) go back and right click Account_DB and select "New Query" like

You must be registered to see links

, 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

You must be registered to see links

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 "

You must be registered to see links

" 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

You must be registered to see links

, 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):

                              Windows Registry Editor Version 5.00
 
[HKEY_LOCAL_MACHINE\SOFTWARE\Triglow Pictures]
 
[HKEY_LOCAL_MACHINE\SOFTWARE\Triglow Pictures\PristonTale]
"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)

A8ת $1@Qšy�

 

[SiK]

Frequently Asked Questions (FAQ)

Q: Question
A: Answer

Mostly importantly I would just like to reiterate Search 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: Here or Here
-------------------------------------------------------------------------
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 here.
----------------------------------------------------------------------------
Q: What are the GM Commands?
A: Search for things in the future, commands here.
-----------------------------------------------------------------------------
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

You must be registered to see links

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 [Resources] contains, resources! (Reading is a wonderful skill)

​

 

[SiK]

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)

//Cleaned and Explained Hotuk by SiK
//www.RaGEZONE.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

Bless Castle auto stops after just starting!:

You must have at least 1 spawn flag in the map (Control + Insert) - Credits to rriikk

​

 

[SiK]

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 RaGEZONE community in general, no other place like this!



​

 

[ShadowPT]

Ehm, I dont wanna sound annoying or something..
And your guide is super! But..
I can't login to Microsoft SQL Server Management Studio Express.
When I open up the program, and I do NOT touch the login name (Like it is written in guide) And click ''Authentication:'' and choose ''SQL Server Autenthication''
And press in ''Server Name'' , ShadowPT and Write in ''Password''-field my password ( I know it is really good one, and it is the same as step 9) and type in ''Login'' , sa
Then it says this:

 Cannot connect to ShadowPT.
Additional information:
An error has occurred while establishing a new connection to the server. When connecting to SQL server 2005, this failure may be caused by the fact that under the default settings 
SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Couldt not open a connection to SQL server) (Microsoft SQL Server, Error:53)

I hope someone of you nice guys can help me out with my problem, and let me make my own server. Thanks alot.
And thanks alot for making this guilde, its awesome!

 

[SiK]

ShadowPT\SQLEXPRESS would be the full database name.

 

[ghost1011]

plzzz help me i dont found the Client folder plzz tell me where i can find it i have been download renhunt server filles and i dont found client folder in it
plzzzzzzzzzzzzzzzzzzzzzzz help

 

[SiK]

The client folder is any PT game client + the game.exe for your version.

 

[ghost1011]

:lol_1: ok tnx for the help man you the best

 

[glennx]

can you make a tutorial onto how to setup SOD Crown for Sandur Clan 2.0 please?

 

[SiK]

There's a post in the Sandurr Clan 2.0 threads by Shagpub saying how to do it.

 

[Chibi_tr3]

sik wat client i start the game with one of the jpt ones
??????????????????????

 

[SiK]

A 3096,3098 or 3100 client.

 

[ShadowPT]

Ehm sik, u told me that if I press in servername-field this: ShadowPT\SQLEXPRESS that it'll work, but it doesnt. It gives another error.
Look, here a screenshot:

I really know for sure the password is good, I really know.
But i dont know whats the problem, I hope you know what the problem is.

 

[SiK]

Did you NAME your SQL database ShadowPT while installing?

 

[ShadowPT]

Omfg, i tougth this was a great tutorial.
I do evrything what you say and 2 days later you say that i need to name something.
Sorry, but that doesnt says in your tut. :sq_yellow

 

[SiK]

Well yes you have to name your sql server something on install....quick question did you in fact install SQL or just the SQL Manager?

 

[ShadowPT]

I installed SQLExpress and Manager

Can you explain how to name it? would be very handy

 

[shagpub]

turn on Remote connections and use 127.0.0.1 to connect to your sql server (already said how to do - follow this link )

 

[SiK]

You name the SQL server during installation.