Town statistics [supporting multiworld]

Zonet · Feb 21, 2010

Very easy script. I'm improving my skills in PHP, so any suggestions would be really appreciated

.
This counts how many players are citizen in X town.
Configuration in config, you have to set the town ids and town names.

PHP:

<?php
$main_content .= '<table border="0px" cellspacing="1" cellpadding="4" width="100%">
<tr><th>Town</th><th>Citizens</th></tr>';
$row = 1;
$worlds = $config['site']['worlds'];
$main_content .= '<b>Towns:</b> ';
    foreach($worlds as $wid => $wname) {
        switch($_GET['world']) {
            case $wid:
                $towns = $towns_list[$wid];
            break;
        }
        $main_content .= '<a href="?subtopic=country&world='.$wid.'">'.$wname.'</a>, ';           
		foreach($towns as $idd => $name) {
			$color = ($row % 2 ? $config['site']['darkborder'] : $config['site']['lightborder']);
			$row++;
			$main_content .= '<tr bgcolor="'.$color.'"><td>'.$name.'</td>';
			$c = $SQL->query('SELECT id, COUNT(town_id) FROM players WHERE town_id = '.$idd.' AND world_id = '.$wid)->fetch();    
			$main_content .= '<td>'.$c[COUNT(town_id)].'</td></tr>';
		}
	}
$main_content .= '</table>';
?>

:$

nsanee · Feb 21, 2010

Hehe nice, of course approved

Zonet · Feb 22, 2010

Thanks, little bugfix with multiworld (in query)

PHP:

<?php
$main_content .= '<table border="0px" cellspacing="1" cellpadding="4" width="100%">
<tr><th>Town</th><th>Citizens</th></tr>';
$row = 1;
$worlds = $config['site']['worlds'];
$main_content .= '<b>Towns:</b> ';
    foreach($worlds as $wid => $wname) {
        switch($_GET['world']) {
            case $wid:
                $towns = $towns_list[$wid];
            break;
        }
        $main_content .= '<a href="?subtopic=country&world='.$wid.'">'.$wname.'</a>, ';           
		foreach($towns as $idd => $name) {
			$color = ($row % 2 ? $config['site']['darkborder'] : $config['site']['lightborder']);
			$row++;
			$main_content .= '<tr bgcolor="'.$color.'"><td>'.$name.'</td>';
			$c = $SQL->query('SELECT id, COUNT(town_id) FROM players WHERE town_id = '.$idd.' AND world_id = '.$wid)->fetch();    
			$main_content .= '<td>'.$c[COUNT(town_id)].'</td></tr>';
		}
	}
$main_content .= '</table>';
?>

hodleo · Feb 22, 2010

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\houses.php on line 14

PHP:

foreach($towns as $idd => $name) {

Zonet · Feb 22, 2010

Cyb3rmastr said:
PHP:

foreach($towns as $idd => $name) {

Works properly for me.
Change the name of the variables, because there may be $towns in houses.php

#edit try this, changed variable names:

PHP:

   <?php
$main_content .= '<table border="0px" cellspacing="1" cellpadding="4" width="100%">
<tr><th>Town</th><th>Citizens</th></tr>';
$row = 1;
$_worlds = $config['site']['worlds'];
$main_content .= '<b>Towns:</b> ';
    foreach($_worlds as $wid => $wname) {
        switch($_GET['world']) {
            case $wid:
                $_towns = $towns_list[$wid];
            break;
        }
        $main_content .= '<a href="?subtopic=country&world='.$wid.'">'.$wname.'</a>, ';           
        foreach($_towns as $_idd => $_name) {
            $color = ($row % 2 ? $config['site']['darkborder'] : $config['site']['lightborder']);
            $row++;
            $main_content .= '<tr bgcolor="'.$color.'"><td>'.$_name.'</td>';
            $c = $SQL->query('SELECT id, COUNT(town_id) FROM players WHERE town_id = '.$_idd.' AND world_id = '.$wid)->fetch();    
            $main_content .= '<td>'.$c[COUNT(town_id)].'</td></tr>';
        }
    }
$main_content .= '</table>';
?>

widnet · Feb 22, 2010

Nice idea

Zonet · Feb 22, 2010

elf · Feb 23, 2010

Why quering each town? :| Resources waste.

Zonet · Feb 24, 2010

elf said:
Why quering each town? :| Resources waste.

I didn't really understand what you mean quering each town, but yes I'm bad at PHP & MySQL, just learning this

Zonet · Feb 27, 2010

Agraeln · Mar 1, 2010

Nice, Rep++

Synthetic_ · Mar 7, 2010

Your getting really good, REP+

Migxxx · Mar 7, 2010

Zonet said:
I didn't really understand what you mean quering each town, but yes I'm bad at PHP & MySQL, just learning this

He means this:

PHP:

SELECT `town_id`, COUNT('town_id') FROM `players` WHERE `world_id` = '.$wid.' GROUP BY `town_id`

Zonet · Mar 7, 2010

Migxxx said:
He means this:

PHP:

SELECT `town_id`, COUNT('town_id') FROM `players` WHERE `world_id` = '.$wid.' GROUP BY `town_id`

I dont find any problem with it

?

Migxxx · Mar 7, 2010

Zonet said:
I dont find any problem with it ?

Ok... More clear for you:

SELECT `town_id`, COUNT('town_id') FROM `players` WHERE `world_id` = '.$wid.' GROUP BY `town_id`

With this you don't need to query every city.

HeberPcL · Mar 12, 2010

Nice Job!

=p

Khanio · Mar 12, 2010

Haha very nice

Diazapam · Mar 12, 2010

What elf means is that every time the foreach is done it will send another request to get the sql data, costs more resources (memory/cpu)

Ped0bear · Mar 16, 2010

thanks for script, can be usefull

Zonet · May 6, 2011

A bump for my old script

Town statistics [supporting multiworld]

Web Developer

Member

Web Developer

Formerly cbrm -Crypto enthusiast, Retired scripter

Web Developer

Banned User

Web Developer

Sing, sing blue silver

Web Developer

Web Developer

New Member

deathzot.net

◥▶◀◤

Web Developer

◥▶◀◤

[PowerOT.com.br]

New Member

!ROFLMAO!

Haters keep hating

Web Developer

Similar threads