Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Mobile [MOBILE] Empire: War of Kings

Newbie Spellweaver
Joined
Aug 30, 2017
Messages
93
Reaction score
12
Thank you guys, I'll try what you suggest, atm I'm stuck with Windows 10.

Just out of curiosity would I be able to setup on shared hosting environment as a temporary solution?
 
Newbie Spellweaver
Joined
Aug 30, 2017
Messages
93
Reaction score
12
@elswing got a demo?

Also I think there must be certain restrictions in place on Windows 10 as mysqld doesnt start with everything. I check in task manager and cp using telnet to check the port.

I am unable to start mysqld something about db credentials being refused



\WOKServer\Server\zones\COK1.zone.xml
PHP:
<driverName>com.mysql.jdbc.Driver</driverName> 
<connectionString>jdbc:mysql://127.0.0.1:3306/cokdb1?characterEncoding=utf-8&autoReconnect=true</connectionString>    
<userName>root</userName>    
<password>123456</password>
\WOKServer\Server\extensions\COK1\config.properties
PHP:
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; Database Connection Parameters ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; local mybatis
; cross mybatis connection parameters (user, password, driver)
; smartfox mysql connnection parameters (user, password, driver)
local.jdbc.user=rootlocal.jdbc.password=123456
local.jdbc.driver=com.mysql.jdbc.Driver
realtime_local.jdbc.url=jdbc:mysql://127.0.0.1:3306/cokdb1?characterEncoding=utf-8
local.poolMaximumActiveConnections=150
local.poolMaximumIdleConnections=10
; smartfox mysql global database connection

global_db_maxActiveConnections=40

global_db_maxIdleConnections=10

global_db_blockTime=60000

global_db_exhaustedPoolAction=GROW

global_db_url=jdbc:mysql://127.0.0.1:3306/cokdb_global?characterEncoding=utf-8&autoReconnect=true

global_db_username=root

global_db_password=123456

; smartfox mysql global database connection

global_db_maxActiveConnections=40

global_db_maxIdleConnections=10

global_db_blockTime=60000

global_db_exhaustedPoolAction=GROW

global_db_url=jdbc:mysql://127.0.0.1:3306/cokdb_global?characterEncoding=utf-8&autoReconnect=true

global_db_username=root

global_db_password=123456
; smartfox mysql pay database connection

pay_db_maxActiveConnections=10

pay_db_maxIdleConnections=2

pay_db_blockTime=60000

pay_db_exhaustedPoolAction=GROW

pay_db_url=jdbc:mysql://127.0.0.1:3306/cokdb_pay?characterEncoding=utf-8

pay_db_username=root

pay_db_password=123456

Hi I checked the files and the code you shared is already there :)
 
Newbie Spellweaver
Joined
Aug 30, 2017
Messages
93
Reaction score
12
@klugor like virtualbox for example?


gereksizbiri I've been working on a mobile game similar to this but it's not a private server it's been built from scratch. At the moment it has no admin panel. It is compatible with ios currently. Although I do have plans on making a android and web based version eventually.

I on wanted to run this as I kinda liked the game

I did post on here time ago as I was looking for help in finishing it so I can release it as open source
But no one was interested at that time
 
Newbie Spellweaver
Joined
Aug 30, 2017
Messages
93
Reaction score
12
@elswing rss and monsters not appearing are in the apk, I forget which file now. But I may skip trying to get this to run as it seems it would take to much to run with the issues with my laptop. Anyways thanks to all for the advice and help guys
 
Newbie Spellweaver
Joined
Oct 19, 2015
Messages
91
Reaction score
19
got this working on 3 diffrent platforms windows 10 was first then debian and now freebsd

if you having db issues and errors reset the database by dropping them all and adding them again through the .sql files provided

inital startup will take a while but should sort issues

i got/had monsters etc only thing i couldnt get working was the wonder and the second event
 
Newbie Spellweaver
Joined
Aug 30, 2017
Messages
93
Reaction score
12
got this working on 3 diffrent platforms windows 10 was first then debian and now freebsd

if you having db issues and errors reset the database by dropping them all and adding them again through the .sql files provided

inital startup will take a while but should sort issues

i got/had monsters etc only thing i couldnt get working was the wonder and the second event

Just out of curiosity how would I drop the db if I can't get the mysqld file running on start-up?
 
Newbie Spellweaver
Joined
Oct 19, 2015
Messages
91
Reaction score
19
well thats a issue for you sure i start mine from cmd
D:
cd cok\mysql
bin\mysql

make sure nothing else is sitting on 3306? check services some wamps install service based mysql server and you might need to disable and stop that first

honestly though out of the box only a few edits are needed to get it working
 
Newbie Spellweaver
Joined
Jul 22, 2015
Messages
18
Reaction score
4
got this working on 3 diffrent platforms windows 10 was first then debian and now freebsd

if you having db issues and errors reset the database by dropping them all and adding them again through the .sql files provided

inital startup will take a while but should sort issues

i got/had monsters etc only thing i couldnt get working was the wonder and the second event

how did you fix the monsters and rss?
 
Newbie Spellweaver
Joined
Oct 19, 2015
Messages
91
Reaction score
19
used a clean database theres sql files provided i droppped the databases and refilled them from the sql
mysqladmin -u root -p drop cokdb1
mysqladmin -u root -p create cokdb1

mysql -u root -p cokdb1 < cokdb1.sql

did that with all the sql files
 
Newbie Spellweaver
Joined
Jul 22, 2015
Messages
18
Reaction score
4
used a clean database theres sql files provided i droppped the databases and refilled them from the sql
mysqladmin -u root -p drop cokdb1
mysqladmin -u root -p create cokdb1

mysql -u root -p cokdb1 < cokdb1.sql

did that with all the sql files
to fix mobs and rss ?
 
Newbie Spellweaver
Joined
Oct 19, 2015
Messages
91
Reaction score
19
well it seemed to fix some of it tbh first time i ran it with there databases it all worked but there was still alot of errors with placing monsters on the map so i cleared it and redone the sql and it took lil longer to start up as it placed everything again but after that it was working perfectly fine for the limited game that it is
 
Newbie Spellweaver
Joined
Oct 19, 2015
Messages
91
Reaction score
19
mysqladmin -u root -p123456 drop cokdb1
mysqladmin -u root -p123456 create cokdb1
mysql -u root -p123456 < cokdb1.sql
mysqladmin -u root -p123456 drop cokdb_global
mysqladmin -u root -p123456 create cokdb_global
mysql -u root -p123456 < cokdb_global
mysqladmin -u root -p123456 drop cokdb_monitor
mysqladmin -u root -p123456 create cokdb_monitor
mysql -u root -p123456 < cokdb_monitor
mysqladmin -u root -p123456 drop cokdb_pay
mysqladmin -u root -p123456 create cokdb_pay
mysql -u root -p123456 < cokdb_pay
 
Newbie Spellweaver
Joined
Jul 22, 2015
Messages
18
Reaction score
4
mysqladmin -u root -p123456 drop cokdb1
mysqladmin -u root -p123456 create cokdb1
mysql -u root -p123456 < cokdb1.sql
mysqladmin -u root -p123456 drop cokdb_global
mysqladmin -u root -p123456 create cokdb_global
mysql -u root -p123456 < cokdb_global
mysqladmin -u root -p123456 drop cokdb_monitor
mysqladmin -u root -p123456 create cokdb_monitor
mysql -u root -p123456 < cokdb_monitor
mysqladmin -u root -p123456 drop cokdb_pay
mysqladmin -u root -p123456 create cokdb_pay
mysql -u root -p123456 < cokdb_pay
KK. Got it. Thanks.
 
Back
Top