Request Account on database, player on database etc. on Gesior 1.0.1

[Lightonia]

Hi, i request something like this on my Gesior 1.0.1 2012 latestnews.

 

[StreamSide]

lol, try to learn bro

 

[Potar]

$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();
$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
$bans = $SQL->query('SELECT COUNT(*) FROM `bans`;')->fetch();
$guilds = $SQL->query('SELECT COUNT(*) FROM `guilds`;')->fetch();

And read it by php like:

$accounts[0];
$players[0];
$bans[0];
$guilds[0];

 

[Lightonia]

Ive tried it, didnt work

 

[Potar]

It have to work ^_^.

Paste it and try.

<?php
$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();
$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
?>

<tr><td>Characters:</td>
<td><?php echo $players[0]; ?> </td></tr>
<tr><td>Accounts:</td>
<td><?php echo $accounts[0]; ?></td></tr>

 

[Lightonia]

Doesnt work at all m8

 

[Ninja]

Layout.php, insert this.

 

[Lightonia]

Ninja, it did work thank you but where exactly do i insert it so that it comes to Latestnews?

 

[Ninja]

You could make a new "box" like this in latestnews.php only if you would like that.

 

[Lightonia]

I have no idea how to do that

 

[Ninja]

Send me a PM and I'll help you out with that.

 

[Cornex]

Use my latestnews, http://otland.net/f118/gesior-2012-1-0-1-latestnews-php-178741/

 

[Lightonia]

Cant cuz i got lots of other edited stuff on my latest news and it took too long time to get them on the exact spot where i wanted it to be

- - - Updated - - -

Solved!