Cannot see online players on map

[ghost]

I dont know what to do, please help

[ghost]

Yes i'am too, but i think what vehicles and deployables are dont must shows on live map... Maybe make a variant to see all: players online, vehicles in game, deployables in game?

[R4Z0R49]

Sorry just got home i also confirm no live maps are working here. All tiles are blank no errors reported. (ill try and get more info on Sunday)

[wriley]

On Sat, Feb 16, 2013 at 9:51 AM, Carl notifications@github.com wrote:

Sorry just got home i also confirm no live maps are working here. All tiles are blank no errors reported. (ill try and get more info on Sunday)

I am out of town this weekend with limited internet access but will try to look into it. It was working for me so maybe I screwed up the checkin.

[wriley]

On Sat, Feb 16, 2013 at 10:12 AM, William Riley william@therileys.freetcp.com wrote:

On Sat, Feb 16, 2013 at 9:51 AM, Carl notifications@github.com wrote:

Sorry just got home i also confirm no live maps are working here. All tiles are blank no errors reported. (ill try and get more info on Sunday)

I am out of town this weekend with limited internet access but will try to look into it. It was working for me so maybe I screwed up the checkin.

I just checked from another computer and the live map is working fine on OSX and Firefox. It also works fine on my home computer using Windows 7 and IE/Chome. Please ensure you have all the correct options set in config.php. Check your browsers javascript console for errors and report them.

William Riley http://workbench.freetcp.com/

[ghost]

Chrome console:

Uncaught SyntaxError: Unexpected identifier jquery.min.js:16 d.extend.globalEval jquery.min.js:16 d.ajaxSetup.converters.text script jquery.min.js:16 bS jquery.min.js:16 v jquery.min.js:16 c jquery.min.js:16 GET http://static.dayzdb.com/tiles/2/4_2.png 404 (Not Found) leaflet.js:6 GET http://static.dayzdb.com/tiles/2/-1_1.png 404 (Not Found) leaflet.js:6 GET http://static.dayzdb.com/tiles/2/4_1.png 404 (Not Found) leaflet.js:6 GET http://static.dayzdb.com/tiles/2/4_0.png 404 (Not Found) leaflet.js:6 GET http://static.dayzdb.com/tiles/2/-1_2.png 404 (Not Found) leaflet.js:6 GET http://static.dayzdb.com/tiles/2/-1_3.png 404 (Not Found) leaflet.js:6 n.TileLayer.n.Class.extend._loadTile leaflet.js:6 n.TileLayer.n.Class.extend._addTile leaflet.js:6 n.TileLayer.n.Class.extend._addTilesFromCenterOut leaflet.js:6 n.TileLayer.n.Class.extend._update leaflet.js:6 n.TileLayer.n.Class.extend.onAdd leaflet.js:6 r leaflet.js:6 n.Map.n.Class.extend.addLayer leaflet.js:6 InitMap chernarus.js:20 (anonymous function) admin.php:252 GET http://static.dayzdb.com/tiles/2/-1_0.png 404 (Not Found) leaflet.js:6 GET http://static.dayzdb.com/tiles/2/4_3.png 404 (Not Found) leaflet.js:6 6 Uncaught SyntaxError: Unexpected identifier jquery.min.js:16 d.extend.globalEval jquery.min.js:16 d.ajaxSetup.converters.text script jquery.min.js:16 bS jquery.min.js:16 v jquery.min.js:16 c

[ghost]

Panel says me what Recent Players(0), but i have playing 5 pepoles on my server

[wriley]

On Sat, Feb 16, 2013 at 12:32 PM, Max notifications@github.com wrote:

Panel says me what Recent Players(0), but i have playing 5 pepoles on my server

I'm out of town and away from my computer for the weekend but will look into this. It works fine for me on 2 different OS/browser combinations so it would help if you could post what operating system and browser version you are using.

William Riley http://workbench.freetcp.com/

[ghost]

I am using Windows 7 Home Premium x86 Chrome Version 24.0.1312.57 m FireFox 18.0.2

[jamaicada]

Same here. Tested on Win7 Pro x64, FF18 (and 17), Chrome 24, IE 9. Recent players doesnt work, but "everything" map (admin.php?view=map&show=8) seems to work fine. No errors in nginx logs

[wriley]

@Strikes please try the latest commit. I added support for setting the MySQL port to something other than the default. You can also enable database layer debug if desired, set '$db->debug = true' in db.php.

[wriley]

@Maximus2015 Please update to the latest version and try again.

[ghost]

@wriley, sorry but no works :(

[wriley]

@Strikes I use Reality and BlissAdmin works fine. The schemas have not yet diverged.

Please set '$db->debug = true;' in db.php and after logging in to BlissAdmin change the url from http://YOURSERVERPATH/admin.php to http://YOURSERVERPATH/js/map.php?id=0

You should see something like: (mysqli): select s.id, p.name, 'Player' as type, s.worldspace as worldspace, s.survival_time as survival_time, s.model as model, s.survivor_kills as survivor_kills, s.zombie_kills as zombie_kills, s.bandit_kills as bandit_kills, s.is_dead as is_dead, s.unique_id as unique_id from profile p join survivor s on p.unique_id = s.unique_id where s.is_dead = 0 and s.world_id = '1' and last_updated > now() - interval 1 minute
followed by JSON strings for each player online.

[ghost]

(mysqli): select s.id, p.name, 'Player' as type, s.worldspace as worldspace, s.survival_time as survival_time, s.model as model, s.survivor_kills as survivor_kills, s.zombie_kills as zombie_kills, s.bandit_kills as bandit_kills, s.is_dead as is_dead, s.unique_id as unique_id from profile p join survivor s on p.unique_id = s.unique_id where s.is_dead = 0 and s.world_id = '5767' and last_updated > now() - interval 1 minute ([])

[ghost]

All what i have

[ghost]

I programming into sql and now want to check your request on my database, i say the results

[wriley]

@Maximus2015 You have no players updating the database. You can confirm this by running the SQL on your database.

select s.id, p.name, 'Player' as type, s.worldspace as worldspace, s.survival_time as survival_time, s.model as model, s.survivor_kills as survivor_kills, s.zombie_kills as zombie_kills, s.bandit_kills as bandit_kills, s.is_dead as is_dead, s.unique_id as unique_id from profile p join survivor s on p.unique_id = s.unique_id where s.is_dead = 0 and s.world_id = '5767' and last_updated > now() - interval 1 minute;

EDIT I just caught that your world id is 5767. Change $world in config.php to a valid world id and see if that fixes your issue.

$world = "1"; // 1=chernarus 2=lingor 4=takistan 5=panthera2 6=fallujah 8=namalsk 10=tavi

[ghost]

i ve check this

[ghost]

Yes it is empty set

[ghost]

Your last variant returns players for me!

[ghost]

@Strikes your request returns players but my not :(

[ghost]

Maybe problem in instance? My instance 5767 @Strikes instance 1

[wriley]

@Maximus2015 Your $world variable in config.php is wrong, change it. See my comment above for appropriate values.

[ghost]

in config my $world = 1

[wriley]

@Strikes Where did you come up with 14? I'm not familiar with Lingor Skaro but id = 2 is lingor in world table.

[ghost]

Why for world_id = 5767? This is my instance id! In config $iid = 5767; $wolrd_id = 1

[wriley]

@Maximus2015 Sorry I meant $iid in config.php, not $world. $iid should match whatever is in your instance table in the database for your world.

[ghost]

Here my config:

$iid = "5767"; //Instance ID
$serverip = "127.0.0.1";  //game-server host
$serverip_internal = "127.0.0.1";  //game-server host internal IP (for hosts behind NAT, set to same as $serverip if not behind NAT)
$rconpassword = "XXXXXXXXX"; //rcon password (SECRET :) )
$serverport = 2302; //server port
$hostname = "127.0.0.1";  //Database host
$dbport = 3306; //database port (MySQL default is 3306)
$username = "dayz"; //database user
$password = "dayz"; //database password
$dbName = "dayz"; //database name
$sitename = "DayZ Administration"; //Admin panel name
$map = "chernarus"; // chernarus lingor takistan panthera2 fallujah namalsk tavi
$world = "1"; // 1=chernarus 2=lingor 4=takistan 5=panthera2 6=fallujah 8=namalsk 10=tavi
$enableclock = 1; // show game time clock in upper left corner
$timeoffset = 4; // game time offset from UTC for optional clock, should match HiveExt.ini
$enableTracking = 1; // show tracks of player/vehicle movement on the map, green dot = start of track, yellow dot = end
$maxTrackingPositions = 50; // how many positions to keep per player/vehicle when tracking
$keepTracksAfterLogout = 0; // 0 - remove player tracks after they logout, 1 - keep showing tracks

[ghost]

My world instance is 5767 i do not like 1

[ghost]

select * from instance;

+------+----------+-----------+----------------------------------------+ | id | world_id | inventory | backpack | +------+----------+-----------+----------------------------------------+ | 5767 | 1 | [] | ["DZ_Patrol_Pack_EP1",[[],[]],[[],[]]] | +------+----------+-----------+----------------------------------------+ 1 row in set

[wriley]

OK that was exhausting but I found the bug. :) On line 12 of queries.php change $iid to $world. I'll fix this and submit.

[wriley]

72 @Maximus2015 @Strikes Did that fix the issue for both of you?

[ghost]

Wait i check

[ghost]

(mysqli): select s.id, p.name, 'Player' as type, s.worldspace as worldspace, s.survival_time as survival_time, s.model as model, s.survivor_kills as survivor_kills, s.zombie_kills as zombie_kills, s.bandit_kills as bandit_kills, s.is_dead as is_dead, s.unique_id as unique_id from profile p join survivor s on p.unique_id = s.unique_id where s.is_dead = 0 and s.world_id = '1' and last_updated > now() - interval 1 minute ([{"id":"106","lat":8.42699,"lng":12.0357,"icon":"Player","title":"[RUS] M@X (8919366)","description":" [RUS] M@X - 8919366<\/a><\/h2> <\/td> <\/td> PlayerID:<\/strong> 106 CharacterID:<\/strong> 8919366 Zed Kills:<\/strong> 83 Bandit Kills:<\/strong> 0 Alive Duration:<\/strong> 0 Position:<\/strong> 120084<\/td><\/tr><\/table>"},{"id":"147","lat":7.55424,"lng":6.00515,"icon":"Player","title":"ger_al (81192966)","description":" ger_al - 81192966<\/a><\/h2> <\/td> <\/td> PlayerID:<\/strong> 147 CharacterID:<\/strong> 81192966 Zed Kills:<\/strong> 126 Bandit Kills:<\/strong> 0 Alive Duration:<\/strong> 347 Position:<\/strong> 060076<\/td><\/tr><\/table>"}])

I have output but Recent players still 0. And no markers on the map!

[ghost]

Stop! All works! Need to disable DB debug!

[ghost]

@wriley thanks :) What about you @Strikes?

[ghost]

But on Everything page i see only cars and tents but no players :(

[ghost]

@Strikes do you see palyers on Everything page?

[ghost]

Yes i'am too! And tracking works but no players

[wriley]

This bug also exists in modules/maps/8.php. On line 3 change $iid to $world. I'll get this fixed as well. I didn't catch these bugs because my world and iid are both 1. :/

[ghost]

I edit this now and check

[ghost]

Yeah issue is now fixed :) You may close this

[ghost]

Sorry for my bad English :)

[wriley]

Thanks for your patience in tracking this down guys. I found 1 more as well and submitted the fix in #73

[wriley]

Closing as resolved with #72 and #73

[wriley]

@Maximus2015 Your English is fine, thanks for the report.