|
[ Autoren gesucht! ]
|
PHP-Homepage.de sucht laufend Autoren für News und Artikel
Interesse?
|
|
 |
|
[Start] [Suche] [Neue Einträge]
| VisualUserlog |
<?PHP
/*************************************************************************************************************
* UserLog: loggt den host bis auf die letzte Stelle bzw. das Class-C-Netz eines jeden Users
* i.e.: *.proxy.srv.ibm.com OR 127.0.0.*
* Referer: loggt den referer (zB: www.zend.com), dh die Seiten auf denen Links zu der eigenen Website befinden
* version: v0.0.4
* author: e-voc [Uwe Pries]
* greetz: Dr. Olaf Guckelberger [olaf@guckelberger.de]
* mailto: webmaster@judas-price.de
* date: 2000-11-20
*************************************************************************************************************/
?>
//MySQL TABLE DEFINITIONS
<?
# CREATE TABLE loguser (host VARCHAR(64) NOT NULL, INDEX(host), PRIMARY KEY(host), counts INTEGER)
# CREATE TABLE referer (referer VARCHAR(64) NOT NULL, INDEX(referer), PRIMARY KEY(referer), counts INTEGER)
?>
//Aufruf für File "userlog.inc"
<?PHP include( "userlog.inc"); ?>
//Der eigentliche Counter - fügt neue User der Tabelle hinzu
//File "userlog.inc"
<?
$db_host = "...";
$db_user = "...";
$db_passwd = "...";
$db_db = "...";
$db_table = "userlog";
$db_table2 = "referer";
$HOST = gethostbyaddr($REMOTE_ADDR);
$db_link = @mysql_connect($db_host, $db_user, $db_passwd) OR DIE( "Couldn't connect to MySQL server!");
@mysql_select_db($db_db, $db_link) OR DIE( "Couldn't select database!");
$subHost=explode( ".", $HOST);
$countSubHosts=count($subHost);
if (ereg( "^[0-9]+$", $subHost[$countSubHosts-1]))
$new_host = $subHost[$countSubHosts-4] . "." . $subHost[$countSubHosts-3] . "." . $subHost[$countSubHosts-2] . ".*";
else {
$new_host = "*";
for ($i = $countSubHosts - 1; $i >= 1 ; $i--) {
$new_host = $new_host . "." . $subHost[$countSubHosts-$i];
}
}
$result = @mysql_query( "SELECT host, counts FROM $db_table WHERE host=\"$new_host\"", $db_link) OR DIE( "Unable to query db!");
if (mysql_num_rows($result)>0) {
@mysql_query( "UPDATE $db_table SET counts=counts+1 WHERE host=\"$new_host\"", $db_link) OR DIE( "Unable to query db!");
} else {
@mysql_query( "INSERT INTO $db_table VALUES(\"$new_host\", \"1\")", $db_link) OR DIE( "Unable to query db!");
}
//referer
$ref = $HTTP_REFERER;
$httphost = $HTTP_HOST;
$new_ref = explode( "/", $ref);
if ($new_ref[2]<>$httphost) {
if ($new_ref[2]> "") {
$result = @mysql_query( "SELECT referer, counts FROM $db_table2 WHERE referer=\"$new_ref[2]\"", $db_link) OR DIE( "Unable to query db!");
if (mysql_num_rows($result)>0) {
@mysql_query( "UPDATE $db_table2 SET counts=counts+1 WHERE referer=\"$new_ref[2]\"", $db_link) OR DIE( "Unable to query db!");
}
else {
@mysql_query( "INSERT INTO $db_table2 VALUES ('$new_ref[2]', '1')", $db_link) OR DIE( "UNABLE TO QUERY");
}
}
}
//referer
//Show klicks
$result = @mysql_query( "SELECT SUM(counts) as counts FROM $db_table", $db_link) OR DIE( "UNABLE TO QUERY");
$rows = mysql_fetch_array($result);
$click_counts = $rows[ "counts"];
//Show klicks
########################################## AUSGABE DER HITS ##########################################
# nach dem Aufruf der "userlog.inc" im selben File kann man dann, z.B.
# echo $click_counts;
########################################## AUSGABE DER HITS ##########################################
?>
//Der grafische Viewer [der Balken kann von meiner Website heruntergeladen werden...]
//Zeigt alle User an die die seiten besucht haben + (wenn vorhanden) woher sie gekommen sind
//File "visual.php3"
<?PHP
$db_host = "...";
$db_user = "...";
$db_passwd = "...";
$db_db = "...";
$db_table = "userlog";
$db_table2 = "referer";
$min_loguser = 50;
$min_referer = 20;
$db_link = mysql_connect($db_host, $db_user, $db_passwd);
mysql_select_db($db_db, $db_link);
echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" cellspacing=\"0\" align=\"center\" bordercolor=\"#004477\">\n";
echo "<tr><th colspan=\"3\" class='whitesmall'>Which users come to http://www.judas-price.de [since 2000-04-09]</th></tr>\n";
$result = mysql_query( "SELECT host, counts FROM $db_table WHERE counts>=$min_loguser ORDER BY counts DESC", $db_link);
$myrow = mysql_fetch_array($result);
echo "<tr><td class='whitesmall' align=\"right\"><b>[host >= $min_loguser hits]</b></td><td class='whitesmall' align=\"left\" colspan=\"2\"><b>[hits]</b></td></tr>";
do {
printf( "<tr><td class='whitesmall' align=\"right\">%s</td><td class='whitesmall' align=\"center\">%s</td><td><img src=\"images/graph.jpg\" width=\"%s\" height=\"5\"></td></tr>", $myrow[ "host"], $myrow[ "counts"], ($myrow[ "counts"]/4));
} while ($myrow = mysql_fetch_array($result));
$result = mysql_query( "SELECT SUM(counts) AS counts FROM $db_table WHERE counts<$min_loguser", $db_link);
$myrow = mysql_fetch_array($result);
do {
printf( "<tr><td class='whitesmall' align=\"right\">Others [less than $min_loguser hits each]</td><td class='whitesmall' align=\"left\" colspan=\"2\"> %s</td></tr>", $myrow[ "counts"]);
} while ($myrow = mysql_fetch_array($result));
$result = mysql_query( "SELECT SUM(counts) AS counts FROM $db_table", $db_link);
$myrow = mysql_fetch_array($result);
do {
printf( "<tr><td class='whitesmall' align=\"right\"><b>Total</b></td><td class='whitesmall' align=\"left\" colspan=\"2\"> <b>%s</b></td></tr>", $myrow[ "counts"]);
} while ($myrow = mysql_fetch_array($result));
echo "</table>\n";
echo "<br><br>\n";
$result = mysql_query( "SELECT referer, counts FROM $db_table2 WHERE counts>=$min_referer ORDER BY counts DESC", $db_link);
if (mysql_num_rows($result)>0) {
echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" cellspacing=\"0\" align=\"center\" bordercolor=\"#004477\">\n";
echo "<tr><th colspan=\"3\" class='whitesmall'>Where do users come from to http://www.judas-price.de [since 2000-05-14 14:25]</th></tr>\n";
$myrow = mysql_fetch_array($result);
echo "<tr><td class='whitesmall' align=\"right\"><b>[referer >= $min_referer hits]</b></td><td class='whitesmall' align=\"left\" colspan=\"2\"><b>[counts]</b></td></tr>";
do {
$width = round($myrow[ "counts"]/4);
if ($width < "1") $width= "1";
printf( "<tr><td class='whitesmall' align=\"right\"><a href=\"http://%s\" target=\"_blank\"><font class='whitesmall'>%s</a></td><td class='whitesmall' align=\"center\">%s</td><td><img src=\"images/graph.jpg\" width=\"%s\" height=\"5\"></td></tr>", $myrow[ "referer"], $myrow[ "referer"], $myrow[ "counts"], $width);
} while ($myrow = mysql_fetch_array($result));
$result = mysql_query( "SELECT SUM(counts) AS counts FROM $db_table2 WHERE counts<$min_referer", $db_link);
$myrow = mysql_fetch_array($result);
do {
printf( "<tr><td class='whitesmall' align=\"right\">Others [less than $min_referer hits each]</td><td class='whitesmall' align=\"left\" colspan=\"2\"> %s</td></tr>", $myrow[ "counts"]);
} while ($myrow = mysql_fetch_array($result));
echo "</table>\n";
}
echo "<p align=\"center\"><a href=\"show_source2.dhtml\" target=\"_blank\"><font class='white'>SourceCode</font></a></p>";
?> |
|
