[charmechulo]

Hi! Thank you for the work!

Can i have some help please?

I have put the files in the game...they are saving data to database, ok!

I have put the files in the webserver, and the connection to dabatase was ok, i think...!

The problem is that is not showing the players!
like in the print: https://image.prntscr.com/image/T8ME...3p4ecqp93w.png

The site is reading how many players are in database but not listing it!

EDIT: PHP version is 7

Can you help me?
Thank you

[Notifications]

Originally Posted by charmechulo Hi! Thank you for the work! Can i have some help please? I have put the files in the game...they are saving data to database, ok! I have put the files in the webserver, and the connection to dabatase was ok, i think...! The problem is that is not showing the players! like in the print: https://image.prntscr.com/image/T8ME...3p4ecqp93w.png The site is reading how many players are in database but not listing it! EDIT: PHP version is 7 Can you help me? Thank you

Check your errorlog in game and it will let you know if it's having issues with the DB. Also, in your logs there should be a file named something along the lines of mostactive_0.log, check it has user info like:

L 10/08/2017 - 05:01:34: Query CREATE TABLE IF NOT EXISTS `mostactive` (`playername` varchar(128) NOT NULL, `steamid` varchar(32) PRIMARY KEY NOT NULL,`last_accountuse` int(64) NOT NULL, `timeCT` INT( 16 ), `timeTT` INT( 16 ),`timeSPE` INT( 16 ), `total` INT( 16 ))
L 10/08/2017 - 05:01:34: Query DELETE FROM `mostactive` WHERE `last_accountuse`<'1505188894' AND `last_accountuse`>'0';
L 10/08/2017 - 05:01:39: Query SELECT timeCT, timeTT, timeSPE FROM mostactive WHERE steamid = 'STEAM_1:0:119623883'
L 10/08/2017 - 05:01:39: Query INSERT INTO mostactive(playername, steamid, last_accountuse, timeCT, timeTT, timeSPE, total) VALUES('rush ^', 'STEAM_1:0:119623883', '1507435299', '0', '0', '0', '0');

[charmechulo]

Hi!

yes it has:

10/07/2017 - 20:48:39: Query CREATE TABLE IF NOT EXISTS `mostactive` (`playername` varchar(128) NOT NULL, `steamid` varchar(32) PRIMARY KEY NOT NULL,`last_accountuse` int(64) NOT NULL, `timeCT` INT( 16 ), `timeTT` INT( 16 ),`timeSPE` INT( 16 ), `total` INT( 16 ))
L 10/07/2017 - 20:48:39: Query DELETE FROM `mostactive` WHERE `last_accountuse`<'1505177319' AND `last_accountuse`>'0';
L 10/07/2017 - 20:50:31: Query SELECT timeCT, timeTT, timeSPE FROM mostactive WHERE steamid = 'STEAM_1:1:110599217'
L 10/07/2017 - 20:50:44: Query UPDATE mostactive SET last_accountuse = 1507423844, playername = 'Chul0^ @AzoresMadeira.pt',timeCT = '2626',timeTT = '652', timeSPE = '737',total = '4015' WHERE steamid = 'STEAM_1:1:110599217';

The connection to database is ok! and data being saved in database from the game

As we can see in the image, the players are being save in the database with no problem!


But when listing in the website they just dont show!


TEST: With a empty database the footer shows up! with a database the footer desapears!
https://image.prntscr.com/image/BfkF...IZk3i0Sz0A.png

[shanapu]

Originally Posted by charmechulo ... The problem is that is not showing the players! like in the print: https://image.prntscr.com/image/T8ME...3p4ecqp93w.png ...

This screenshot looks like an php error.

Please post your php error log from webspace.

Or put this snipped to the top of index.php, reload site and report back the error message.

PHP Code:

<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
?>

[charmechulo]

hi shanapu,
this is what i get

[shanapu]

Originally Posted by charmechulo hi shanapu, this is what i get

nope

PHP Code:

<?php 
ini_set('display_errors', 1); 
ini_set('display_startup_errors', 1); 
error_reporting(E_ALL); 
?>

<?php
// *************************************************************************
//  This file is part of MostActive sourcemod plugin.
//
//  Copyright (C) 2017 MostActive Dev Team 
//  https://github.com/Franc1sco/MostActive/graphs/contributors
//

...

https://gist.github.com/shanapu/2743...02b32d94ca818f

[charmechulo]

oh sorry...
here it is:

[shanapu]

The php extention 'BC Math' is not enabled/installed on your webserver.

Please search a tutorial for yourself according to your operating system.

[charmechulo]

OMGG!! Thank you!!!!!

2 easy steps!

[charmechulo]

There is still one minor bug....


When i click the player name to go the steam page, it is adding .0000000000 in from of the link like this:
http://steamcommunity.com/profiles/7...163.0000000000
and it should be : http://steamcommunity.com/profiles/76561198181464163

You know why?