### sitename detection ### //------------------------------------------------------------------ include ( "func/func_pattern_matching.php" ); // include pattern maching detection //------------------------------------------------------------------ $temp_site_name = substr ( strstr ( substr ( $js_url , 7 ) , "/" ) , 1 ); $temp_url = parse_url ( $js_url ); parse_str ( $temp_url [ "query" ] , $temp_parameter ); $temp_check_name_value = 0; if ( dirname ( $temp_site_name ) != "." ) { $temp_dir_name = dirname ( $temp_site_name )."/"; } else { $temp_dir_name = substr ( dirname ( $temp_site_name ) , 1 ); } $temp_name = $temp_dir_name.substr ( basename ( $js_url ) , 0 , strpos ( basename ( $js_url ) , "?" ) ); foreach ( $temp_parameter as $key=>$value ) { if ( in_array ( $key , $url_parameter ) ) { $temp_check_name.= $key."=".$value."&"; $temp_check_name_value = 1; } } if ( $temp_check_name_value == 1 ) { $temp_check_name = $temp_name."?".substr ( $temp_check_name , 0 , strlen ( $temp_check_name ) - 1 ); $site_name = pattern_matching ( "site_name" , $temp_check_name ); // check site name } if ( $temp_check_name_value == 0 ) { if ( strpos ( $temp_site_name , "?" ) > 0 ) { $temp_site_name = substr ( $temp_site_name , 0 , strpos ( $temp_site_name , "?" ) ); } if ( strpos ( $temp_site_name , "." ) === FALSE ) { $temp_site_name = $temp_site_name.$home_site_name; } $site_name = pattern_matching ( "site_name" , $temp_site_name ); // check site name } unset ( $temp_url ); unset ( $temp_parameter ); unset ( $temp_name ); unset ( $temp_site_name ); unset ( $temp_check_name ); unset ( $temp_check_name_value );
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/> </head> <body> <table border ="2" align ="left" cellspacing="0" > <tr> <td WIDTH="50"><b>ip_Adresse</b></td> <td WIDTH="300"><b>Referrer</b></td> <td WIDTH="65"><b>year</b></td> <td WIDTH="65"><b>month</b></td> <td WIDTH="65"><b>day</b></td> </tr> <?php // Datenbankeinstellungen $host = " "; // Adresse des Datenbankservers, in der Regel "localhost"; $user = " "; // Benutzername fuer die Datenbank $pass = " "; // Passwort fuer die Datenbank $database = " "; // Name der Datenbank $dz = mysql_connect($host, $user, $pass); mysql_select_db($database, $dz); // Ende Datenbank öffnen $query = "SELECT * FROM stat_main AS a INNER JOIN stat_referrer AS b ON a.referrer = b.id ORDER By timestamp DESC LIMIT 100"; $sql = mysql_query($query); while ($ds = mysql_fetch_object($sql)){ $ip_Adresse = $ds -> ip_address; $referrer = substr($ds -> referrer,7,70); $year = $ds -> year; $month = $ds -> month; $day = $ds -> day; ?> <tr> <td><i><?= $ip_Adresse ?></i></td> <td><i><a href= "<?= $referrer ?>" target="_blank"><?= $referrer ?></a></i></td> <td><i><?= $year ?></i></td> <td><i><?= $month ?></i></td> <td><i><?= $day ?></i></td> </tr> <? } mysql_close($dz); ?> </table> </body> </html>