Requesting Help From the Best!!!

[freestyle123]

Hello Guys i would like to thank the forum for the help they give =), I Would also like to ask for the help of the Best on here In the Following Order:HappyHardcore - shagpub & Sik if i missed anyone that is just as good im sry =(. for my request me and my cuzin are making a server for priston tale we have went through Tons and Tons of posts and found many things that helped but... just didnt cut it as far as getting to our Goal our goal natualy is to have a working private server for our use and a cpl of our friends the problem is that every time we follow any guide we get f***ed over sry for the language and were back at the start again because everything we follow always seems to leave somthing out and were stuck not knowing what it is and having to sit there and not have a server so if the 3 PPL i mentioned could all lend a helping hand to us that would be perfect to getting our server finaly up, were using kpt v1871 and yes i know you guys have lots of ppl asking the same thing over and over but trust me ive been through this whole thread about a good 1000+ times reading every post 3x over and still cant get what were looking for so please guys, i know some may say to give up but im no quiter if i can get 1 on 1 with each of you i know i can getter done and dont mistake this post as Begging of any kind or asking you to hand me your server files because thats unrespectfull just a lil help thats all, thats pretty much it and if you got spare time to glance over to this post and wanna add your input ty in advance. Big props to the Community in advance, peace out guys.

[MentaL]

[DarkKnightH20]

Really, just following the server setup guide by SiK covers 99% of it. After that, it's just a matter of tweaking things depending on the current results. How far did you get before you ran into issues?

What client are you using? What server? You said 1871, but is it a repack posted here?

Have you manually added accounts to the SQL?

Do you get an error message when trying to login? If so, what is it?

What did you setup your ODBC as (include every step--the name, SQL, etc)? Try using NT Auth if SQL Auth doesn't work.

Did you edit ldata, ptReg.rgx, and the client registry? Are you using a client hotuk?

Did you edit the SQL.dll, SQL.dll Reg.reg, and the Hotuk.ini? Show us the Hotuk.ini.


I asked a lot of questions. Be sure to answers them all. Also, I'd suggest looking at error logs (SQL created ones, ODBC created ones, and PT created ones).

[Superman666]

Its a dedi or a home pc?

[freestyle123]

Hey Dark and Superman thnx for the replies,can i ask of you is there an email i can reach you at because i realy dont want to waste the forums space up with my questions,seems nonsence to me i can answer straite forward on msn and tell you exactly what our issues are and maby you can help me fixer up if you dont mind, my email is demon_within_me@hotmail.com to get in touch just add me and ill do my best to fill in those important Q. thnx again.

[DarkKnightH20]

I pretty much only use the forums as a means of communication. No MSN or anything for me.

Also, it's not a waste of space. People can learn from these posts and solve issues they may be having as well. Answer the questions on here and we'll guide you through.

[freestyle123]

Np man i just didnt want to be a burden but for the info, ill have to wait for my cuzin because he hosts the server i just try to help in anyway i can so when he gets on ill be back, on as for as the server being dedi or home hes got 2 comps 1 is the dedi machine the other he plays on but ya ill get back on here when he gets on msn.

[bbchamps2000]

its like me. a home pc and a 'dedi'. its still considered a home pc cuz ur using the same internet line. dont get me wrong it functions as the same.

and like DarkKnight said, follow sik's guide.

some u need to kno from past experience but im sure someone will lend a hand.

[Superman666]

Well with a dedi its alot easier to setup a server, it just is... dont ask why. I have never had a problem with connecting to the game on a dedi, but PC's you got to make sure to open ports.

[bbchamps2000]

well not necessarily. im not sure about the rest of the people, but me its straight forward. my home network is just setup wonderfully i guess. its called the dmz computer.

i set the dmz computer as my server and its good to go

[freestyle123]

Aight guys im back an update for the Questions DarkKnight asked, here is my answers

Q.What client are you using? What server? You said 1871, but is it a repack posted here?
A.We tried using dPT and currently trying FusionPT client files and the server files is Fusion_Dev_Repack_kpt_1871 from the RTF thread

Q.Have you manually added accounts to the SQL?
A.We are manually adding accounts to the sql db

Q.Do you get an error message when trying to login? If so, what is it?
A.When we try and login we get "Connection Failed" (we tried the unable to connect thread)

Q.What did you setup your ODBC as (include every step--the name, SQL, etc)? Try using NT Auth if SQL Auth doesn't work.
A.We tried setting up the SQL.dll but that didn't work so were using ODBC:

name: c8master
server: SERVER\SQLEXPRESS
(tried win auth and sql auth)
defaultdb: accountdb not account_db
ODBC test completed successfully


Q.Did you edit ldata, ptReg.rgx, and the client registry? Are you using a client hotuk?
A.All IP's and versions in ldata.bmp, ptReg.rgx, client registry are set to our hosted server pc's IP (and the verision is set to 1871)

Q.Did you edit the SQL.dll, SQL.dll Reg.reg, and the Hotuk.ini? Show us the Hotuk.ini.

A.//Server IP and Name
//Hotuk.ini assembled by Superman666 aka Ryder
//Credits to Sik and Crackaddict also for me using his post on RFT for some of these command line

//*GAME_GUARD
*MODE SERVER
*SERVER_CODE 0
*SERVER_NAME SlaughtPT
//*VERSION 1871
*SERVER_AUTOPLAY
//*NOTICE_URL
*GAME_SERVER SlaughtPT xxx.xxx.xxx xxx.xxx.xxx xxx.xxx.xxx
//*AREA_SERVER xxx.xxx.xxx xxx.xxx.xxx xxx.xxx.xxx
*LOGIN_SERVER_IP xxx.xxx.xxx
*SYSTEM_IP xxx.xxx.xxx
*ENABLE_CLAN xxx.xxx.xxx 80 xxx.xxx.xxx 80
*CLAN_SERVER xxx.xxx.xxx 80 xxx.xxx.xxx 80
*TT_DATA_SERVER
*SERVER_LINK_IP

//Server Settings

*MAX_USERS 50
//*CRAZY_PACKET
*ENABLE_PARTYITEM
*PERMIT_MONEY 1000000000
*PERMIT_EXP 1000000000
*ENABLE_SERVER_EXP 1000000000
*ENABLE_PK 1
*PK_FIELD 9
//*DISABLE_THROWITEM
*START_FIELD 3
//*DISABLE_QUEST
//*DISABLE_DEC_SKILLPOINT
*SERVER_RECORD_MEM
//*CLIENT_CHECK_FUNC 1
//*BLOCK_LEVEL 1
//*DISCONNECT_ITEM_ERROR
*CHECK_POTION_COUNT 10000
*CLIENT_CHECK_PROCESS_TIME 30
//*CLIENT_PROCESS_TIME_OUT
//*ENABLE_CLAN
*RECORD_JOBCHANGER
//*TEST_SERVER //USER THIS DURRING MAINT!*RECORD COPIED ITEM IN WAREHOUSE*RECORD COPIED ITEM*RECORD ITEM


//Event's

*EVENT_EXPUP 5000
*EVENT_POTION 30
*EVENT_BITMASK
//*EVENT_BLESSCASTLE
*EVENT_SUMMER_CHICKEN
*EVENT_SANTAGOBLIN
*EVENT_GHOST
*EVENT_MOLLYWOLF
*EVENT_MORIFSHELTOM
*EVENT_WHITEDAY
*EVENT_VALENTINEDAY
*EVENT_NINEFOX
*EVENT_BABELHORN
*EVENT_PUZZLE
//*EVENT_BIRTHDAY
//*EVENT_STARPOINT
*EVENT_CRISTAL
*EVENT_CHILD
*EVENT_DAMAGEOFF
*EVENT_HARDCORE
*EVENT_MANDOO

//Server Protection

*CONNECT_CLIENT_CODE -869703011
*CL_PROTECT
//*DISCONNECT_CLIENT_BADCODE
//*CLSAFE_CODE 100
//*DISCONNECT_CLSAFE_CODE

//Database Backup DIR

*BACKUP_FOLDER_NAME "c:\databasebackup"
*BACKUP_PATH "c:\databasebackup"

// [ Admin Stuff ]

*REC_ADMIN_CMD

*DEBUG_ID slaught

*ADMIN_IP xxx.xxx.xxx
*ADMINISTRATOR_IP xxx.xxx.xxx
*ADMIN_LOGIN "zigzag"
*ADMIN_NAME "zigzag"
*ADMIN_COMMAND "sex1"
*ADMIN_COMMAND "sex2"
*ADMIN_COMMAND "sex3"

xxx.xxx.xxx = the hosting computers external ip

Edit: we deleted the sql.dll when using ODBC and also we enabled dmz
I Hope this answerd all your question and can maby help you to giving us an answer to our problems Thnx again guys.

[Phatkone]

well not necessarily. im not sure about the rest of the people, but me its straight forward. my home network is just setup wonderfully i guess. its called the dmz computer.

i set the dmz computer as my server and its good to go

yea jus if its in the DMZ make sure it doesnt hav access to the other pcs on ur network.bcuz hackers can then access ur pcs easier.

[shabeb]

Man its very easy to fix the connc failed...
i had it
u have to setup the sql.dll
open it in notepad and in between u will see a big space with small writing ull see other people ip address and the sql password and username change them to urs and i pritting sure it will work i did it and it worked im using the same thing and my server is up but it crashes i ndunno y but dark is helping me if anyone wants to help me pm me ty

[freestyle123]

Ok guys im here to say i got my server up and its 100% working now so all problems solved thank you for the help that you gave me to get my goal ps. you can remove this post/thread thnx again a million guys. peace out.