[MOBILE] Empire: War of Kings

[Stuart Jones]

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

[elswing]

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?

[Stuart Jones]

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

[elswing]

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 ?

[Stuart Jones]

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

[elswing]

so i cleared it and redone the sql

Would you be more specific ? Which table you cleared and what do you mean by redone the SQL ?

[Stuart Jones]

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

[elswing]

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.

[Stuart Jones]

KK. Got it. Thanks.

let me know how it goes

[vladiks9]

not monsters and resurce :(

[paoxbr]

Everything seems working,

Account Facebook bind is working but can't log in with it yet,

To Edtir Facebook Bind Edit res/values/strings.xml search for fb_app_id, you need to create new facebook app, edit your facebook App Id into strings.xml, App must be Live on facebook,

Very nice files, easy to setup and many languages availiable,

https://bit.ly/2OGnWXZ APK Running Public Server,


Can't find adminCP Password, anyone?


If your game get stuck(account problem) after restoring DB, try adding data in wordpoint table:

INSERT INTO `worldpoint` VALUES (1, 0, 0, 1, 1, 1, 2, 0, 10, '9413', NULL, NULL, NULL, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, 0, NULL, 1533323487973, NULL, 0, 1533237087973, NULL, 0, 0, 0, 0, -1, NULL);


Edit facebook Like link(inside game Details -> Configuration-> Fan Community): lib/libgame.so search for facebook.com/ (link must have same length)

[gereksizbiri]

working but no wonder

[demonlord21]

anyone got an update on how to get event status to show up? have everything working aside from that from what i can tell.
side note currently looking into how to get the builtin app updating to work.
in WOKServer\Server\extensions\COK1 there is this config.prop file. if you open it and scroll down

Spoiler:

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; Application Version ;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

; decide client to update app or update xml version by current client version
; if client version is equal app_version, then find key(app_1.0.76) corresponding value (0|1.0.1315)
; before | represents update type, 0(not update), 1(suggest update), 2(force update)
; after | represents xml version
; if client version is 1.0.1 then can not find key, so must update client
; if client version is greater than app_version, then if request user is gm, then suggest update, or force update
realtime_app_version=0.1.86
realtime_US_face_version=0.0.2
realtime_app_0.1.86=0|0.0.519
realtime_app_0.1.86=0|0.0.519

i know that this is tied into the folders in here WOKServer\Server\resource along with all the drconfig0.x.xx.xml files tried
creating new drconfig file with a new 0.1.xx folder copying files from one folder into new one adding a new edited bat file and paxheader bat file reflecting the new version with the updated files. but cant figure out how it gets the hash value

Spoiler:

<ItemSpec id="1" name="Common_4" checksize="1024" iosmd5="07fbf126f02b5eda8d11495ca2fd6679" androidmd5="a36e270147a5dede809d798334af8ed0" version="1.0.1" />

also anyone know the GMflag for inside userprofile table. trying to figure out what value is required for account to be GM ingame.
also looking into how to use the admin web panel type thing. currently not working atm

- - - Updated - - -

<remoteAdmin>
<administrators>
<adminUser>
<login>root</login>
<password>admin123</password>
</adminUser>
</administrators>
<allowedRemoteAddresses/>
<adminTcpPort>8088</adminTcpPort>
</remoteAdmin>

in server\config\server.xml
closest thing could find to what ur looking for

[gereksizbiri]

http://skin-empire.sytes.net/

bimbogames make beta

[stuartmoseley]

Missing monsters/resource tiles:
When you first extract and run the monster and resource tiles are missing due to the world table being incomplete.

Also just so you know there are quite a number of tables missing. For eg. A complete sql dump of db cokdb1 file size would be 140mb+

To fix the incomplete/missing tables/data
Open navicat or similar and trunicate all tables
Then start up the server and wait a while.

Once complete you will have everything working except wonder and events

Now for your help. Can anyone help me figure out where a certain image is located and also the messages in the kingdom/global chat are?