"; echo ""; echo ""; echo ""; echo ""; echo ""; ## 2.0 ################################################################## //------------------------------ Staten -------------------------------- $get_time=mysql_query("SELECT ipsperre_time FROM $prefix"."_settings"); $aus_time=mysql_fetch_object($get_time); $timestamp=time(); $zeit_v=time(); $reload_v=$aus_time->ipsperre_time; $zeitdel_v=$zeit_v-($reload_v*60); $zeitdel_d=$zeit_v-($reload_v*2880); $ip_v=$REMOTE_ADDR; ##### Bereinigen der DB ##### mysql_query("DELETE FROM $prefix"."_ipsperre WHERE zeit<='$zeitdel_d'"); mysql_query("DELETE FROM $prefix"."_recentusers WHERE timestamp<='$zeitdel_d'"); $get_ip_check=mysql_query("SELECT id FROM $prefix"."_ipsperre WHERE ip='$ip_v' AND time>='$zeitdel_v'"); if (mysql_num_rows($get_ip_check)==0) { #### Alles aktualisieren mysql_query("INSERT INTO $prefix"."_ipsperre (ip, time) VALUES ('$ip_v', '$zeit_v')"); ################################################# ### Counter ##################################### $get_daycheck=mysql_query("SELECT id,date FROM $prefix"."_counter ORDER BY id DESC"); $aus_daycheck=mysql_fetch_object($get_daycheck); $d_date=$aus_daycheck->date; $t_date=date("Y-m-d"); $a_hour=date("H",time()); //aktuelle stunde im 00-23 format $a_hour="h".$a_hour; if($d_date==$t_date) { mysql_query("UPDATE $prefix"."_counter SET counts=counts+1,hits=hits+1,$a_hour=$a_hour+1 WHERE id='$aus_daycheck->id'"); } else { mysql_query("INSERT INTO $prefix"."_counter (date,counts,hits,$a_hour) VALUES ('$t_date','1','1','1')"); } ##### Maximale Counts, Hits / Tag ##### $get_maxinsert=mysql_query("SELECT id FROM $prefix"."_counter_other"); if(mysql_num_rows($get_maxinsert)==0) { mysql_query("INSERT INTO $prefix"."_counter_other (counts_max,hits_max) VALUES ('1','1')"); } else { $get_max=mysql_query("SELECT counts_max,hits_max FROM $prefix"."_counter_other"); $aus_max=mysql_fetch_object($get_max); $get_maxid=mysql_query("SELECT max(id) AS maxid FROM $prefix"."_counter"); $aus_maxid=mysql_fetch_object($get_maxid); $maxid=$aus_maxid->maxid; $get_latest=mysql_query("SELECT * FROM $prefix"."_counter WHERE id='$maxid'"); $aus_latest=mysql_fetch_object($get_latest); if($aus_latest->counts>$aus_max->counts_max) { mysql_query("UPDATE $prefix"."_counter_other SET counts_max=counts_max+1"); } if($aus_latest->hits>$aus_max->hits_max) { mysql_query("UPDATE $prefix"."_counter_other SET hits_max=hits_max+1"); } } ################################################# ################################################# ### Browser #################################### $get_browser=mysql_query("SELECT * FROM $prefix"."_browser"); while($aus_browser=mysql_fetch_object($get_browser)) { if(@stristr($HTTP_USER_AGENT,$aus_browser->browser1)==true) { $query_browser=$aus_browser->browser1; } } $get_stats_browser=mysql_query("SELECT id FROM $prefix"."_browser WHERE browser1 LIKE '%$query_browser%'"); if(mysql_num_rows($get_stats_browser)!=0) { $aus_stats_browser=mysql_fetch_object($get_stats_browser); mysql_query("UPDATE $prefix"."_browser SET hits=hits+1 WHERE id='$aus_stats_browser->id'"); } else { mysql_query("UPDATE $prefix"."_browser SET hits=hits+1 WHERE browser1=''"); } ### OS #################################### $get_os=mysql_query("SELECT * FROM $prefix"."_os"); while($aus_os=mysql_fetch_object($get_os)) { if(@stristr($HTTP_USER_AGENT,$aus_os->os1)==true) { $query_os=$aus_os->os1; } } $get_stats_os=mysql_query("SELECT id FROM $prefix"."_os WHERE os1 LIKE '%$query_os%'"); if(mysql_num_rows($get_stats_os)!=0) { $aus_stats_os=mysql_fetch_object($get_stats_os); mysql_query("UPDATE $prefix"."_os SET hits=hits+1 WHERE id='$aus_stats_os->id'"); } else { mysql_query("UPDATE $prefix"."_os SET hits=hits+1 WHERE os1=''"); } ### Sprache #################################### $get_stats_language=mysql_query("SELECT id FROM $prefix"."_language WHERE language1='$HTTP_ACCEPT_LANGUAGE'"); if(mysql_num_rows($get_stats_language)!=0) { $aus_stats_language=mysql_fetch_object($get_stats_language); mysql_query("UPDATE $prefix"."_language SET hits=hits+1 WHERE id='$aus_stats_language->id'"); } else { mysql_query("UPDATE $prefix"."_language SET hits=hits+1 WHERE language1=''"); } ### Referer #################################### if($HTTP_REFERER) { $referer=parse_url("$HTTP_REFERER"); $referer=$referer["host"]; } else { $referer="Direkte Eingabe"; } $get_stats_referer=mysql_query("SELECT id FROM $prefix"."_referer WHERE referer='$referer'"); if(mysql_num_rows($get_stats_referer)==0) { $aktuelle_url=$_SERVER["HTTP_HOST"]; if(stristr($referer,$aktuelle_url)!=true) { mysql_query("INSERT INTO $prefix"."_referer (referer,hits) VALUES ('$referer','1')"); } } else { $aktuelle_url=$_SERVER["HTTP_HOST"]; if(stristr($referer,$aktuelle_url)!=true) { mysql_query("UPDATE $prefix"."_referer SET hits=hits+1 WHERE referer='$referer'"); } } ### RefererC #################################### if($HTTP_REFERER) { $referer_c=$HTTP_REFERER; } else { $referer_c="Direkte Eingabe"; } $get_stats_referer_c=mysql_query("SELECT id FROM $prefix"."_referer_c WHERE referer_c='$referer_c'"); if(mysql_num_rows($get_stats_referer_c)==0) { $aktuelle_url=$_SERVER["HTTP_HOST"]; if(stristr($referer_c,$aktuelle_url)!=true) { mysql_query("INSERT INTO $prefix"."_referer_c (referer_c,hits) VALUES ('$referer_c','1')"); } } else { $aktuelle_url=$_SERVER["HTTP_HOST"]; if(stristr($referer_c,$aktuelle_url)!=true) { mysql_query("UPDATE $prefix"."_referer_c SET hits=hits+1 WHERE referer_c='$referer_c'"); } } ### Referer Own #################################### if($REQUEST_URI) { $referer_own=$REQUEST_URI; $get_stats_referer_own=mysql_query("SELECT id FROM $prefix"."_referer_own WHERE referer_own='$referer_own'"); if(mysql_num_rows($get_stats_referer_own)==0) { mysql_query("INSERT INTO $prefix"."_referer_own (referer_own,hits) VALUES ('$referer_own','1')"); } else { mysql_query("UPDATE $prefix"."_referer_own SET hits=hits+1 WHERE referer_own='$referer_own'"); } } ### Suchwort #################################### if($HTTP_REFERER) { $searchwords=$HTTP_REFERER; $searchwords_site=parse_url("$HTTP_REFERER"); $searchwords_site=$searchwords_site["host"]; if(strstr($searchwords,"?q=")==true || strstr($searchwords,"&q=")==true) { $searchwords_zahl1=strpos($searchwords,"q="); $searchwords=substr($searchwords,$searchwords_zahl1+2); $searchwords_zahl2=strpos($searchwords,"&"); $searchwords=substr($searchwords,0,$searchwords_zahl2); $searchwords=str_replace("+", " ", $searchwords); $searchwords=str_replace("%22", "\"", $searchwords); $searchwords=str_replace("%2B", "+", $searchwords); $searchwords=str_replace("+-", " -", $searchwords); $searchwords=str_replace("+OR+", " OR ", $searchwords); $found="ok"; } if(strstr($searchwords,"?p=")==true || strstr($searchwords,"&p=")==true) { $searchwords_zahl1=strpos($searchwords,"p="); $searchwords=substr($searchwords,$searchwords_zahl1+2); $searchwords_zahl2=strpos($searchwords,"&"); $searchwords=substr($searchwords,0,$searchwords_zahl2); $searchwords=str_replace("+", " ", $searchwords); $searchwords=str_replace("%22", "\"", $searchwords); $searchwords=str_replace("%2B", "+", $searchwords); $searchwords=str_replace("+-", " -", $searchwords); $searchwords=str_replace("+OR+", " OR ", $searchwords); $found="ok"; } if(strstr($searchwords,"?su=")==true || strstr($searchwords,"&su=")==true) { $searchwords_zahl1=strpos($searchwords,"su="); $searchwords=substr($searchwords,$searchwords_zahl1+3); $searchwords_zahl2=strpos($searchwords,"&"); $searchwords=substr($searchwords,0,$searchwords_zahl2); $searchwords=str_replace("+", " ", $searchwords); $searchwords=str_replace("%22", "\"", $searchwords); $searchwords=str_replace("%2B", "+", $searchwords); $searchwords=str_replace("+-", " -", $searchwords); $searchwords=str_replace("+OR+", " OR ", $searchwords); $found="ok"; } if(strstr($searchwords,"?query=")==true || strstr($searchwords,"&query=")==true) { $searchwords_zahl1=strpos($searchwords,"query="); $searchwords=substr($searchwords,$searchwords_zahl1+6); $searchwords_zahl2=strpos($searchwords,"&"); $searchwords=substr($searchwords,0,$searchwords_zahl2); $searchwords=str_replace("+", " ", $searchwords); $searchwords=str_replace("%22", "\"", $searchwords); $searchwords=str_replace("%2B", "+", $searchwords); $searchwords=str_replace("+-", " -", $searchwords); $searchwords=str_replace("+OR+", " OR ", $searchwords); $found="ok"; } if($found=="ok") { $get_searchwords_c=mysql_query("SELECT id FROM $prefix"."_searchwords WHERE searchwords='$searchwords'"); if(mysql_num_rows($get_searchwords_c)==0) { mysql_query("INSERT INTO $prefix"."_searchwords (searchwords_site,searchwords,hits) VALUES ('$searchwords_site','$searchwords','1')"); } else { mysql_query("UPDATE $prefix"."_searchwords SET hits=hits+1 WHERE searchwords='$searchwords'"); } } } ### User #################################### $hostmark=gethostbyaddr($REMOTE_ADDR); $r_date=date("Y-m-d H:i:s"); $get_recent_check=mysql_query("SELECT id FROM $prefix"."_recentusers WHERE user_ip='$REMOTE_ADDR'"); if(mysql_num_rows($get_recent_check)==0) { mysql_query("INSERT INTO $prefix"."_recentusers (user_agent,user_hostmark,user_ip,timestamp,date) VALUES ('$HTTP_USER_AGENT','$hostmark','$REMOTE_ADDR','$timestamp','$r_date')"); } else { mysql_query("UPDATE $prefix"."_recentusers SET timestamp='$timestamp',date='$r_date' WHERE user_ip='$REMOTE_ADDR'"); } } else { #### Nichts mehr zählen außer Hits $get_daycheck=mysql_query("SELECT id,date FROM $prefix"."_counter ORDER BY id DESC"); $aus_daycheck=mysql_fetch_object($get_daycheck); $d_date=$aus_daycheck->date; $t_date=date("Y-m-d"); if($d_date==$t_date) { mysql_query("UPDATE $prefix"."_counter SET hits=hits+1 WHERE id='$aus_daycheck->id'"); } else { mysql_query("INSERT INTO $prefix"."_counter (date,counts,hits) VALUES ('$t_date','0','1')"); } ##### Maximale Counts, Hits / Tag ##### $get_maxinsert=mysql_query("SELECT id FROM $prefix"."_counter_other"); if(mysql_num_rows($get_maxinsert)==0) { mysql_query("INSERT INTO $prefix"."_counter_other (counts_max,hits_max) VALUES ('1','1')"); } else { $get_max=mysql_query("SELECT hits_max FROM $prefix"."_counter_other"); $aus_max=mysql_fetch_object($get_max); $get_maxid=mysql_query("SELECT max(id) AS maxid FROM $prefix"."_counter"); $aus_maxid=mysql_fetch_object($get_maxid); $maxid=$aus_maxid->maxid; $get_latest=mysql_query("SELECT * FROM $prefix"."_counter WHERE id='$maxid'"); $aus_latest=mysql_fetch_object($get_latest); if($aus_latest->hits>$aus_max->hits_max) { mysql_query("UPDATE $prefix"."_counter_other SET hits_max=hits_max+1"); } } ### User Aktualisieren für User Online Anzeige ########### $hostmark=gethostbyaddr($REMOTE_ADDR); $r_date=date("Y-m-d H:i:s"); $get_recent_check=mysql_query("SELECT id FROM $prefix"."_recentusers WHERE user_ip='$REMOTE_ADDR'"); if(mysql_num_rows($get_recent_check)==0) { mysql_query("INSERT INTO $prefix"."_recentusers (user_agent,user_hostmark,user_ip,timestamp,date) VALUES ('$HTTP_USER_AGENT','$hostmark','$REMOTE_ADDR','$timestamp','$r_date')"); } else { mysql_query("UPDATE $prefix"."_recentusers SET timestamp='$timestamp',date='$r_date' WHERE user_ip='$REMOTE_ADDR'"); } mysql_query("UPDATE $prefix"."_ipsperre SET time='$zeit_v' WHERE ip='$ip_v' AND time>'$zeitdel_v'"); } ## 1.0 ################################################################## //----------------------------- Ausgabe -------------------------------- $heute_date=date("Y-m-d"); $gestern_timestamp=time()-86400; $gestern_date=date("Y-m-d",$gestern_timestamp); $vgestern_timestamp=time()-86400*2; $vgestern_date=date("Y-m-d",$vgestern_timestamp); ############## User Online ###################################### $get_settings=mysql_query("SELECT * FROM $prefix"."_settings"); $aus_settings=mysql_fetch_object($get_settings); $u_limit=time()-$aus_settings->useronline_time*60; $get_user_online=mysql_query("SELECT count(id) AS u_online FROM $prefix"."_recentusers WHERE timestamp>'$u_limit'"); $aus_user_online=mysql_fetch_object($get_user_online); $u_online=$aus_user_online->u_online; ############## Holen der heutigen Counts, Hits ################## $get_date_heute=mysql_query("SELECT * FROM $prefix"."_counter WHERE date='$heute_date'"); if(mysql_num_rows($get_date_heute)!=0) { $aus_date_heute=mysql_fetch_object($get_date_heute); $counts_h=$aus_date_heute->counts; $hits_h=$aus_date_heute->hits; } else { $counts_h=0; $hits_h=0; } ############## Holen der gestrigen Counts, Hits ################## $get_date_gestern=mysql_query("SELECT * FROM $prefix"."_counter WHERE date='$gestern_date'"); if(mysql_num_rows($get_date_gestern)!=0) { $aus_date_gestern=mysql_fetch_object($get_date_gestern); $counts_g=$aus_date_gestern->counts; $hits_g=$aus_date_gestern->hits; } else { $counts_g=0; $hits_g=0; } ############## Holen der gestrigen Counts, Hits ################## $get_date_vgestern=mysql_query("SELECT * FROM $prefix"."_counter WHERE date='$vgestern_date'"); if(mysql_num_rows($get_date_vgestern)!=0) { $aus_date_vgestern=mysql_fetch_object($get_date_vgestern); $counts_vg=$aus_date_vgestern->counts; $hits_vg=$aus_date_vgestern->hits; } else { $counts_vg=0; $hits_vg=0; } ############# Auslesen der direkten Ausgaben ############## $get_counts_g=mysql_query("SELECT sum(counts) AS counts_g FROM $prefix"."_counter"); $aus_counts_g=mysql_fetch_object($get_counts_g); $counts_gesamt=$aus_counts_g->counts_g+$aus_settings->edit_gcounts; $get_hits_g=mysql_query("SELECT sum(hits) AS hits_g FROM $prefix"."_counter"); $aus_hits_g=mysql_fetch_object($get_hits_g); $hits_gesamt=$aus_hits_g->hits_g+$aus_settings->edit_ghits; $get_maxstats=mysql_query("SELECT counts_max,hits_max FROM $prefix"."_counter_other"); if(mysql_num_rows($get_maxstats)!=0) { $aus_maxstats=mysql_fetch_object($get_maxstats); $counts_max=$aus_maxstats->counts_max; $hits_max=$aus_maxstats->hits_max; } else { $counts_max="0"; $hits_max="0"; } ############################################################ echo ""; echo ""; echo "

"; echo ""; $get_order_h=mysql_query("SELECT order_show FROM $prefix"."_settings_order WHERE id='1'"); $aus_order_h=mysql_fetch_object($get_order_h); if($aus_order_h->order_show=="1") { echo ""; echo ""; } $get_order=mysql_query("SELECT * FROM $prefix"."_settings_order ORDER by order_number"); while($aus_order=mysql_fetch_object($get_order)) { $get_visible=mysql_query("SELECT * FROM $prefix"."_settings_order WHERE id='$aus_order->id' AND id<>'1'"); $aus_visible=mysql_fetch_object($get_visible); if($aus_visible->order_show=="1") { echo ""; } } echo ""; echo ""; echo " Statistik: $aus_visible->order_name: "; if($aus_visible->id=="2"){echo "$u_online";} if($aus_visible->id=="3"){echo "$counts_gesamt";} if($aus_visible->id=="4"){echo "$counts_max";} if($aus_visible->id=="5"){echo "$counts_h";} if($aus_visible->id=="6"){echo "$counts_g";} if($aus_visible->id=="7"){echo "$counts_vg";} if($aus_visible->id=="8"){echo "$hits_gesamt";} if($aus_visible->id=="9"){echo "$hits_max";} if($aus_visible->id=="10"){echo "$hits_h";} if($aus_visible->id=="11"){echo "$hits_g";} if($aus_visible->id=="12"){echo "$hits_vg";} echo " © by usolved.net

"; ########################################################################## echo ""; echo ""; ?>