AAC GEISOR AAC Online.php bug

[Tinkz]

I´m getting an error on my geisor aac, this might explain

When i reload the website it works fine but after 1 - 2 seconds it returns to that error again.


online.php

<?php
include("config/config.php");

//connection to the database
$dbhandle = mysql_connect($config['site']['sqlHost'], $config['site']['sqlUser'], $config['site']['sqlPass'])
or die("ERROR #CONN");

//select a database to work with
$selected = mysql_select_db($config['site']['sqlDatabase'],$dbhandle)
  or die("ERROR #DB");

//execute the SQL query and return records
$result = mysql_query("SELECT * FROM players, players_online WHERE players.id = players_online.player_id");
$num_rows = mysql_num_rows($result);

echo '<font color="lime" class="View">'.$num_rows.'</font> <font color="orange">/</font> <font color="red">1000</font>';

//close the connection
mysql_close($dbhandle);
?>

 

[Gesior.pl]

SQL host, user, pass is in SERVER config, not SITE config, so it would be:

$config['server']['sqlHost']

but you cannot use it this way, because you need to load Gesior acc. maker to get access to that variable.

If you want get number of players online from database in layout or in any page (file in folder '/pages') you can use:

$num_rows = $SQL->query('SELECT COUNT(1) AS players_online_count FROM players_online')->fetch()['players_online_count'];

 

[Tinkz]

SQL host, user, pass is in SERVER config, not SITE config, so it would be:

$config['server']['sqlHost']

but you cannot use it this way, because you need to load Gesior acc. maker to get access to that variable.

If you want get number of players online from database in layout or in any page (file in folder '/pages') you can use:

$num_rows = $SQL->query('SELECT COUNT(1) AS players_online_count FROM players_online')->fetch()['players_online_count'];

This is what happends, it works fine the first 2 - 3 seconds.

 

[Raggaer]

Why are you opening a new database connection using mysql_ when gesior already opens for you a connection?

You should use what gesior told you. Use the gesior connection

 

[Tinkz]

I removed the entire online.php and it fixed it. I guess geisor has already something that gets the information