} else {
$sql->execute(array($categorie));
}
if ($useSQLite === TRUE) {
$buffer = array();
foreach ($sql as $row) {
$buffer[] = $row;
}
$counter = count($buffer);
} else {
$counter = $sql->rowCount();
}
echo '<div class="col-xs-12 col-sm-6 col-md-4">';
echo '<div class="text-left rounded border boxer">';
echo '<a href="./?categorie=' . $categorie . '" style="text-decoration: none;">';
echo '<img class="img-thumbnail" src="' . getImageByName("img/", $categorie, 1) . '" alt="' . $categorie . '" >';
echo '<div class="regions">';
echo '<p>' . $categorie . ' <span class="badge pull-right">' . $counter . '</span></p>';
echo '</div>';
echo '</a>';
echo '</div>';
echo '</div>';
} catch (PDOException $e) {
$message = '
<pre>
Unable to query database ...
Error code: ' . $e->getCode() . '
Error file: ' . $e->getFile() . '
Error line: ' . $e->getLine() . '
Error data: ' . $e->getMessage() . '
</pre>
// $object_uuid = $row->object_uuid;
$categorie_name = $row->categorie_name;
$http_server_url = $row->http_server_url;
$agents_online = $row->agents_online;
// $locX = $row['locX'];
// $locY = $row['locY'];
// $sizeX = $row['sizeX'];
// $sizeY = $row['sizeY'];
// $aera = $sizeX * $sizeY;
$local_position = $row->local_position;
$region_aera = 65536;
$last_update = $row->date;
echo '<div class="col-md-6">';
echo '<div class="text-left rounded border boxer">';
echo '<a href="secondlife://' . $region_name . '/' . $local_position . '" target="_self" style="text-decoration: none;">';
echo '<img class="img-thumbnail" src="' . getImageByName("img/", $region_name, 1) . '" alt="' . $region_name . '" >';
echo '</a>';
echo '</div>';
echo '</div>';
echo '<div class="col-md-6">';
echo '<div class="regiondetails rounded border">';
echo '<p>';
echo $region_name . ' <span class="pull-right">' . $region_aera . ' m²</span><br />';
echo 'Owner name : <span class="pull-right">' . $owner_name . '</span><br />';
echo 'Agents online : <span class="badge pull-right">' . $agents_online . '</span><br />';
echo 'Categorie name : <span class="pull-right">' . $categorie_name . '</span><br />';
echo 'Last Update : <span class="pull-right">' . $last_update . '</span><br />';
echo 'Terminal Name : <span class="pull-right">' . $object_name . '</span><br />';
echo 'Local Position : <span class="pull-right">' . $local_position . '</span><br />';
echo '</p>';
echo '<form class="form-horizontal" role="form" action="?refresh=' . $region_name . '&url=' . base64_encode($http_server_url) . '" method="post">';
$query->execute();
/* SQLITE */
if ($useSQLite === TRUE) {
$buffer = array();
foreach ($query as $row) {
$buffer[] = $row;
}
$counter = count($buffer);
} else {
$counter = $query->rowCount();
}
echo '<div class="regionspics shadows radius">';
echo '<div class="boxer radius">';
echo '<hr class="up"><hr class="down">';
echo '<a href="destinations.php?categorie=' . $categorie_number . '" target="_self" style="text-decoration: none;">';
echo '<img class="" src="' . getImageByName("../img/", $categorie_name, 2) . '" alt="' . $categorie_name . '" >';
echo '<div class="regions">';
echo '<hr class="up">';
echo '<hr class="down">' . $categorie_name;
echo '<span>' . $counter . '</span>';
echo '<hr class="up">';
echo '<hr class="down">';
echo '<hr class="up">';
echo '<hr class="down">';
echo '</div>';
echo '</a>';
echo '</div>';
echo '</div>';
}
echo '</div>';
echo '</div>';
