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 } ?>