Gesior Count storage

[xLosT]

How do I display the total number of storage on a page?
gesior 1.0

exemple

db.query('SELECT COUNT(*) as `player_storage` FROM 'key' = 81262 ...?
[code]

Show 'value' number from storage 81262

 

[margoh]

Select count (*) FROM table name where(?) key = value

I think properly it should look like this :d

 

[xLosT]

I did not understand how to do it.

Here example

`player_storage` SET `value` = '53' WHERE `player_storage` AND `player_storage`.`key` =81262;

test this dont work

   $kills = $SQL->query('SELECT COUNT(*) as (`player_storage`) AS `value` FROM `key` = 24034;'

 

[Danger II]

I think it should be more like this one...

$kills = $SQL->query('SELECT COUNT(*) as (`player_storage`) AS `value` FROM `player_storage` WHERE `key` = 24034 AND `player_id` = '.$player->getId())->fetch();

 

[xLosT]

dont work, no need add player id?

WHERE `player_id` = '.$player->getId())->fetch();

 

[margoh]

But what you want to achieve? Count kills of all players or only one player?

 

[xLosT]

one player, is for frags
earch kill +1 of storage 24034
i have this

        $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Killed:</TD><TD>'.$kills['frags'].'</TD></TR>';

and need the code '.$kills

 

[xLosT]

use this now, but no error and not count

        $kills = $SQL->query('SELECT COUNT(*) as `value` FROM `player_storage` WHERE `key` = 24034 AND `player_id` = '.$player->getId())->fetch();

 

[StreamSide]

$kills['value']

 

[xLosT]

$kills['value']

yes, thx
now if no have storage count = 0
if have any storage value exemple 50 on gesior show 1

 

[xLosT]

up