while ($row = mysql_fetch_array($query)) {
$url = $row[url];
$hits = $row[hits];
$clr = word2color($url);
$clr = color_mkwebsafe($clr);
echo "<set name='{$url}' value='{$hits}' color='{$clr}' link='{$url}' />";
}
echo "</graph>";
}
if ($sortby == "referer") {
$sql = "SELECT COUNT(id) AS whole FROM {$table}";
$year = date("Y");
$query = mysql_db_query("{$db}", "{$sql}");
while ($row = mysql_fetch_array($query)) {
$whole = $row[whole];
}
$sql = "SELECT ref, COUNT(ID) AS hits FROM {$table} GROUP BY ref ORDER BY hits DESC";
$query = mysql_db_query("{$db}", "{$sql}");
echo "<graph bgcolor='ffffff' caption='Übersicht der aufgerufenen Dateien' yaxisminvalue='0' showgridbg='1' showcanvas='0' hovercapbg='FFFFDD' hovercapborder='CECE00' numdivlines='{$hits}' >";
while ($row = mysql_fetch_array($query)) {
$hits = $row[hits];
$ref = $row[ref];
if ($ref == "") {
$reftext = "Keine Herkunft erkennbar";
}
$clr = word2color($url);
$clr = color_mkwebsafe($clr);
echo "<set name='{$ref}' value='{$hits}' color='{$clr}' link='stats.php?sortby=referer&ref={$ref}' />";
}
echo "</graph>";
}
?>
</ul>
<?php
}
?>
</td>
<td class="col_mineral_common_name">
<?php
if (isset($common_names['mineralogy'][$spec->getMineralRef()])) {
?>
<ul class="common_name_tags">
<?php
foreach ($common_names['mineralogy'][$spec->getChronoRef()]['community'] as $lang => $tag) {
?>
<li style="border-left:6px solid #<?php
echo word2color($lang);
?>
;" title="<?php
echo $lang;
?>
"><?php
echo $tag;
?>
</li>
<?php
}
?>
</ul>
<?php
}
?>
