Snre3n 94 Report post Posted August 12, 2016 (edited) EDIT: This guide didn't develop into what I intially had in mind, and is now being deprecated. My suggestion is use to this guide: GUIDE UNDER CONSTRUCTION - NO SUPPORT IS GIVEN FOR THINGS IN DEVELOPMENT This guide is intended to help you setup a server, and a client in the easiest possible way, therefore this guide is in first hand focused on setting up a server & client that work on your PC, and only your PC.If you intend to host a public server, see Change IP - Client & Server, and Opening Ports. SQL Server 2014 Setup: Spoiler 1. Acquire SQL Server 2014 Setup executable. First you'll need SQL Server 2014, it can be obtained here: https://www.microsoft.com/en-US/download/details.aspx?id=42299 If you have a 32bit Operating System: ExpressAndTools 32BIT\SQLEXPRWT_x86_ENU.exe If you have a 64bit Operating System: ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe 2. SQL Server 2014 Setup Spoiler DISCLAIMER: Server name does not have to be the same as mine, Im using the default option given, this can be/is different for you! Run the executable you downloaded and let it extract. Once extraction is done, run "SETUP" in the newly extracted folder. * Microsoft Update - It's up to whether you check it or not. -> Next. * Installation Type - Perform a new installation of SQL Server 2014. -> Next. * License Terms - Check "I accept the license terms." -> Next. * Feature Selection - -> Next. * Instance Configuration - Default Instance. -> Next. * Server Configuration - Next. * Database Engine Configuration - Mixed Mode (SQL Server Auth and Win Auth) Password: Y87dc#$98 Also "Add Current User" if prompt pops up. -> Next. * Installation Progress should now begin, Click "Close" after completion and your done! 3. Attaching Database to SQL. Spoiler * Run SQL Server 2014 Management Studio * Databases -> Right Click -> Attach * Click Add -> Choose accountserver.MDF -> Click OK -> Repeat the same for gamedb.MDF. * Edit Owner to "sa" on both databases. -> OK -> Close SQL Management Studio. 4. Enable TCP/IP . ( Fix for AccountServer Hang ) Spoiler Open: SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER -> Right click TCP/IP -> Enable. Restart SQL Server (MSSQLSERVER) PKO II Server Setup: In development Spoiler 1. Download Database. ( See Resources ) Download PKOII - Server Files. ( See Resources ) 2. Extract PKOII - Server Files,then extract Database in you server file folder. eg: C:/PKOII - Server Files C:/PKOII - Server Files/DB Start Server: Spoiler Use Server Launcher.exe to start the server, you will need to launch: - AccountServer - GroupServer - GateServer - GameServer PKO II Client Setup: In development Spoiler Download PKO II - Client: See "Resources" To run the game, use Start Game.bat. Change IP - Client & Server: In development Spoiler The default IP is set to 127.0.0.1 in the server files and client files provided in this guide, to connect, your server has to be hosted on the same PC as you run your client. If you intend to let other players connect to your server, you will have to make a few changes to your server files, and to the client. Client: Spoiler ServerSet.txt - can be found in your client folder, PKOII/scripts/table. //ID Name Region IP #1 IP #2 IP #3 IP #4 IP #5 Description ? 1 ServerName RegionName 127.0.0.1 0 0 0 0 - Replace 127.0.0.1 with the IP address shown at https://www.whatismyip.com/ - Run Bin Compiler.bat located in client folder to compile ServerSet.txt to ServerSet.bin. Server: Spoiler Open your command prompt, type ipconfig, then hit enter. Look for your IPv4 Address, IPv4 Address. . . . . . . . . . . : 192.168.1.X You will use this IP address to replace 127.0.0.1 in AccountServer.cfg, GameServer.cfg, GateServer.cfg, GroupServer.cfg. Protip: Spoiler If you are using notepad++, you can open up your configuration files, CTRL + H, Replace All in All Opened Documents. Opening Ports: In development Spoiler Resources: Spoiler MEGA library: https://mega.nz/#F!xw4SFLoS!RmzYX7PdcbcNG2PplfK9jA Edited April 23, 2019 by Snre3n 14 Quote Share this post Link to post Share on other sites
Red 1 Report post Posted August 12, 2016 Much appreciated sir @Snre3n im used to SQL 2000 ( thats how long its been since i worked on servers ) and i wanted to set this up. Thank you again. Please let me know if i can help you with anything. Scripts or code etc ^^ Quote Share this post Link to post Share on other sites
Shako 97 Report post Posted September 4, 2016 @Snre3n Comprehensive guide. 1 Quote Sunny Go! Online pko.host Share this post Link to post Share on other sites
ChinO 0 Report post Posted October 29, 2016 how to fix this? Quote Share this post Link to post Share on other sites
Snre3n 94 Report post Posted October 30, 2016 Have you checked what the log file says? ( The one mentioned at the end of your error. ) 1 Quote Share this post Link to post Share on other sites
ChinO 0 Report post Posted October 31, 2016 (edited) On 10/30/2016 at 8:58 AM, Snre3n said: Have you checked what the log file says? ( The one mentioned at the end of your error. ) i already installed it correctly.. im having trouble in attach DB what DB is compatible with this SQL? Edited November 1, 2016 by ChinO Quote Share this post Link to post Share on other sites
Snre3n 94 Report post Posted November 1, 2016 On 2016-10-31 at 3:54 AM, ChinO said: i already installed it correctly.. im having trouble in attach DB what DB is compatible with this SQL? Try the DB's from these server files, said to be working fine with SQL2014. On 2016-07-19 at 2:26 PM, V3ct0r said: @GummyBear check if table 'account' in GameDB is empty. It should have at least one record. DBs from these files are working fine with MSSQL 2014 1 Quote Share this post Link to post Share on other sites
ChinO 0 Report post Posted November 2, 2016 2 hours ago, Snre3n said: Try the DB's from these server files, said to be working fine with SQL2014. Quote Share this post Link to post Share on other sites
V3ct0r 2,117 Report post Posted November 2, 2016 @ChinO Try attach databases under administrator mode Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites
ChinO 0 Report post Posted November 2, 2016 7 hours ago, V3ct0r said: @ChinO Try attach databases under administrator mode how? can u show me? Quote Share this post Link to post Share on other sites
V3ct0r 2,117 Report post Posted November 2, 2016 2 часа назад, ChinO сказал: how? can u show me? Right click on .exe or label -> Context menu -> Run as administrator Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites
ChinO 0 Report post Posted November 3, 2016 On 11/2/2016 at 10:10 PM, V3ct0r said: Right click on .exe or label -> Context menu -> Run as administrator did u mean i should run as administrator the sql management studio? Quote Share this post Link to post Share on other sites
V3ct0r 2,117 Report post Posted November 3, 2016 1 час назад, ChinO сказал: did u mean i should run as administrator the sql management studio? Yes, I mean MSSQL Management Studio Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites
theone 3 Report post Posted November 21, 2016 I am getting same error as above (acces denied) even tho i tried running as administrator, any help? Quote Share this post Link to post Share on other sites
Snre3n 94 Report post Posted November 21, 2016 (edited) @theone @ChinO I think this error can happen if the database files is "read only". For those who don't know how to do this: Right click folder containing database -> Properties -> Remove check on "Read Only" -> "Apply". Tell me if it helped. Edited November 21, 2016 by Snre3n 2 Quote Share this post Link to post Share on other sites
theone 3 Report post Posted November 21, 2016 @Snre3n I did tried it , but it didnt worked ... Quote Share this post Link to post Share on other sites
theone 3 Report post Posted November 21, 2016 (edited) bump! Edit: i have fixed database ataching issues by going to services.msc dobble click on sql server->log on->and used Local System Account! thnaks everyone for replying!! Edited November 21, 2016 by theone 2 Quote Share this post Link to post Share on other sites
mkhzaleh 131 Report post Posted January 13, 2017 any help i did same step Quote Share this post Link to post Share on other sites
Snre3n 94 Report post Posted January 16, 2017 (edited) Updated the guide with following: * Included Server files ( DB's excluded ) * Included Database ( The old one was missing act_album table ) * Included fix for AccountServer Hang, it has been confirmed to work by @snowolf @mkhzalehplease check 5. Enable TCP/IP . ( Fix for AccountServer Hang ) Edited January 16, 2017 by Snre3n 1 Quote Share this post Link to post Share on other sites
mkhzaleh 131 Report post Posted January 16, 2017 59 minutes ago, Snre3n said: Updated the guide with following: * Included Server files ( DB's excluded ) * Included Database ( The old one was missing act_album table ) * Included fix for AccountServer Hang, it has been confirmed to work by @snowolf @mkhzalehplease check 5. Enable TCP/IP . ( Fix for AccountServer Hang ) thx i will try it hope it's work if i'm going use my ip should i change the port in accc.cfg too? Quote Share this post Link to post Share on other sites
Snre3n 94 Report post Posted January 16, 2017 @mkhzaleh Just change your ip and leave the port as is. 1 Quote Share this post Link to post Share on other sites
mkhzaleh 131 Report post Posted January 16, 2017 Just now, Snre3n said: @mkhzaleh Just change your ip and leave the port as is. oky thx can use another website for uploading this website have alot of problem i can't download the files thx Quote Share this post Link to post Share on other sites
mkhzaleh 131 Report post Posted January 16, 2017 it's work thx Quote Share this post Link to post Share on other sites
kalpador 0 Report post Posted January 27, 2017 On 12.08.2016 at 11:05 AM, Snre3n said: GUIDE UNDER CONSTRUCTION PKO II Server Setup: In development Reveal hidden contents PKO II Client Setup: In development Reveal hidden contents SQL Server 2014 Setup: Reveal hidden contents 1. Acquire SQL Server 2014 Setup executable. First you'll need SQL Server 2014, it can be obtained here: https://www.microsoft.com/en-US/download/details.aspx?id=42299 If you have a 32bit Operating System: ExpressAndTools 32BIT\SQLEXPRWT_x86_ENU.exe If you have a 64bit Operating System: ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe 2. SQL Server 2014 Setup Reveal hidden contents DISCLAIMER: Server name does not have to be the same as mine, Im using the default option given, this can be/is different for you! Run the executable you downloaded and let it extract. Once extraction is done, run "SETUP" in the newly extracted folder. * Microsoft Update - It's up to whether you check it or not. -> Next. * Installation Type - Perform a new installation of SQL Server 2014. -> Next. * License Terms - Check "I accept the license terms." -> Next. * Feature Selection - -> Next. * Instance Configuration - Default Instance. -> Next. * Server Configuration - Next. * Database Engine Configuration - Mixed Mode (SQL Server Auth and Win Auth) Password: Y87dc#$98 Also "Add Current User" if prompt pops up. -> Next. * Installation Progress should now begin, Click "Close" after completion and your done! 3. Attaching Database to SQL. Reveal hidden contents * Run SQL Server 2014 Management Studio * Databases -> Right Click -> Attach * Click Add -> Choose accountserver.MDF -> Click OK -> Repeat the same for gamedb.MDF. * Edit Owner to "sa" on both databases. -> OK -> Close SQL Management Studio. 5. Enable TCP/IP . ( Fix for AccountServer Hang ) Reveal hidden contents Open: SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER -> Right click TCP/IP -> Enable. Restart SQL Server (MSSQLSERVER) Resources used in guide: Reveal hidden contents Database only: http://www.filedropper.com/topiidbs Server files v2.7 ( Database excluded ) : http://www.filedropper.com/topiiserverfileslastused MEGA library: https://mega.nz/#F!xw4SFLoS!RmzYX7PdcbcNG2PplfK9jA Can u upload databases to another site? Quote Share this post Link to post Share on other sites
Mr.LiM 0 Report post Posted February 4, 2017 On 8/12/2016 at 0:05 PM, Snre3n said: GUIDE UNDER CONSTRUCTION PKO II Server Setup: In development Hide contents PKO II Client Setup: In development Hide contents SQL Server 2014 Setup: Reveal hidden contents 1. Acquire SQL Server 2014 Setup executable. First you'll need SQL Server 2014, it can be obtained here: https://www.microsoft.com/en-US/download/details.aspx?id=42299 If you have a 32bit Operating System: ExpressAndTools 32BIT\SQLEXPRWT_x86_ENU.exe If you have a 64bit Operating System: ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe 2. SQL Server 2014 Setup Reveal hidden contents DISCLAIMER: Server name does not have to be the same as mine, Im using the default option given, this can be/is different for you! Run the executable you downloaded and let it extract. Once extraction is done, run "SETUP" in the newly extracted folder. * Microsoft Update - It's up to whether you check it or not. -> Next. * Installation Type - Perform a new installation of SQL Server 2014. -> Next. * License Terms - Check "I accept the license terms." -> Next. * Feature Selection - -> Next. * Instance Configuration - Default Instance. -> Next. * Server Configuration - Next. * Database Engine Configuration - Mixed Mode (SQL Server Auth and Win Auth) Password: Y87dc#$98 Also "Add Current User" if prompt pops up. -> Next. * Installation Progress should now begin, Click "Close" after completion and your done! 3. Attaching Database to SQL. Reveal hidden contents * Run SQL Server 2014 Management Studio * Databases -> Right Click -> Attach * Click Add -> Choose accountserver.MDF -> Click OK -> Repeat the same for gamedb.MDF. * Edit Owner to "sa" on both databases. -> OK -> Close SQL Management Studio. 5. Enable TCP/IP . ( Fix for AccountServer Hang ) Reveal hidden contents Open: SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER -> Right click TCP/IP -> Enable. Restart SQL Server (MSSQLSERVER) Resources used in guide: Hide contents Database only: http://www.filedropper.com/topiidbs Server files v2.7 ( Database excluded ) : http://www.filedropper.com/topiiserverfileslastused MEGA library: https://mega.nz/#F!xw4SFLoS!RmzYX7PdcbcNG2PplfK9jA does anyone have the RESOURCES USED GUIDE files? kindly reupload them pls?!.... thanks!!!! Quote Share this post Link to post Share on other sites