";
echo "";
echo "STATSolved ";
echo "
id'");
}
}
/* Max Counts/Hits */
if($register_max=="ok")
{
$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);
$db_counts=$aus_latest->counts;
$db_hits=$aus_latest->hits;
if($db_counts>$aus_max->counts_max)
{
mysql_query("UPDATE $prefix"."_counter_other SET counts_max=counts_max+1");
}
if($db_hits>$aus_max->hits_max)
{
mysql_query("UPDATE $prefix"."_counter_other SET hits_max=hits_max+1");
}
}
/* User */
$result = mysql_query("UPDATE {$prefix}_recentusers SET timestamp='{$timestamp}' WHERE user_ip='{$ip_v}';");
if(mysql_affected_rows() == 0)
{
$r_date=date("Y-m-d H:i:s");
mysql_query("INSERT INTO {$prefix}_recentusers (user_agent,user_hostmark,user_ip,timestamp,date) VALUES ('{$user_agent}','{$hostmark}','{$ip_v}','{$timestamp}','{$r_date}');");
}
} //IP Exclude
## 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);
$get_settings=mysql_query("SELECT * FROM $prefix"."_settings");
$aus_settings=mysql_fetch_object($get_settings);
/* Stats zusenden */
if($aus_settings->send_stats==1)
{
$datum_gestern=time()-86400;
$datum_gestern=date("Y-m-d",$datum_gestern);
$get_sendcheck=mysql_query("SELECT * FROM $prefix"."_counter WHERE date='$datum_gestern' AND sent_stats='0'");
if(mysql_num_rows($get_sendcheck)==true)
{
$aus_sendcheck=mysql_fetch_object($get_sendcheck);
$zieladdi=$aus_settings->send_stats_to;
$subject="Stats - ".$datum_gestern;
$message="
Die Stats von: ".$datum_gestern.":
-----------------------------------------
Counts gesamt: ".$aus_sendcheck->counts."
Hits gesamt: ".$aus_sendcheck->hits."
Stundenauflistung:
24 Uhr - 01 Uhr: ".$aus_sendcheck->h00."
01 Uhr - 02 Uhr: ".$aus_sendcheck->h01."
02 Uhr - 03 Uhr: ".$aus_sendcheck->h02."
03 Uhr - 04 Uhr: ".$aus_sendcheck->h03."
04 Uhr - 05 Uhr: ".$aus_sendcheck->h04."
05 Uhr - 06 Uhr: ".$aus_sendcheck->h05."
06 Uhr - 07 Uhr: ".$aus_sendcheck->h06."
07 Uhr - 08 Uhr: ".$aus_sendcheck->h07."
08 Uhr - 09 Uhr: ".$aus_sendcheck->h08."
09 Uhr - 10 Uhr: ".$aus_sendcheck->h09."
10 Uhr - 11 Uhr: ".$aus_sendcheck->h10."
11 Uhr - 12 Uhr: ".$aus_sendcheck->h11."
12 Uhr - 13 Uhr: ".$aus_sendcheck->h12."
13 Uhr - 14 Uhr: ".$aus_sendcheck->h13."
14 Uhr - 15 Uhr: ".$aus_sendcheck->h14."
15 Uhr - 16 Uhr: ".$aus_sendcheck->h15."
16 Uhr - 17 Uhr: ".$aus_sendcheck->h16."
17 Uhr - 18 Uhr: ".$aus_sendcheck->h17."
18 Uhr - 19 Uhr: ".$aus_sendcheck->h18."
19 Uhr - 20 Uhr: ".$aus_sendcheck->h19."
20 Uhr - 21 Uhr: ".$aus_sendcheck->h20."
21 Uhr - 22 Uhr: ".$aus_sendcheck->h21."
22 Uhr - 23 Uhr: ".$aus_sendcheck->h22."
23 Uhr - 24 Uhr: ".$aus_sendcheck->h23."
";
$header="From: STATSolved";
@mail($zieladdi, $subject, $message, $header);
mysql_query("UPDATE $prefix"."_counter SET sent_stats='1' WHERE date='$datum_gestern'");
}
}
############################################################
$get_layout=mysql_query("SELECT * FROM $prefix"."_layout");
$aus_layout=mysql_fetch_object($get_layout);
echo "table_bgcolor."\" background=\"".$aus_layout->table_background."\">";
echo "table_width."\" style=\"padding-left:2\">";
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 "font_face.";font-size:".$aus_layout->font_size."pt;color:".$aus_layout->font_color.";\">Statistik:
font_face.";font-size:".$aus_layout->font_size."pt;color:".$aus_layout->font_color.";\">".
$aus_visible->order_name
.":
font_face.";font-size:".$aus_layout->font_size."pt;color:".$aus_layout->font_color.";\">";
############## User Online ######################################
if($aus_visible->id=="2")
{
if($aus_visible->order_show=="1")
{
$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;
}
echo "$u_online";
}
############## Counts gesamt ######################################
if($aus_visible->id=="3")
{
$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;
echo "$counts_gesamt";
}
############## Counts Schnitt ######################################
if($aus_visible->id=="4")
{
$get_counts_avg=mysql_query("SELECT avg(counts) AS counts_avg FROM $prefix"."_counter");
if(mysql_num_rows($get_counts_avg)!=0)
{
$aus_counts_avg=mysql_fetch_object($get_counts_avg);
$counts_avg=$aus_counts_avg->counts_avg;
$counts_avg=sprintf("%.0f", $counts_avg);
}
else
{
$counts_avg="0";
}
echo "$counts_avg";
}
############## Counts Max. ######################################
if($aus_visible->id=="5")
{
$get_maxstats=mysql_query("SELECT counts_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;
}
else
{
$counts_max="0";
}
echo "$counts_max";
}
############## Counts Heute ######################################
if($aus_visible->id=="6")
{
$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;
}
else
{
$counts_h=0;
}
echo "$counts_h";
}
############## Counts Gestern ######################################
if($aus_visible->id=="7")
{
$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;
}
else
{
$counts_g=0;
}
echo "$counts_g";
}
############## Counts Vorgestern ######################################
if($aus_visible->id=="8")
{
$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;
}
else
{
$counts_vg=0;
}
echo "$counts_vg";
}
############## Hits gesamt ######################################
if($aus_visible->id=="9")
{
$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;
echo "$hits_gesamt";
}
############## Hits Schnitt ######################################
if($aus_visible->id=="10")
{
$get_hits_avg=mysql_query("SELECT avg(hits) AS hits_avg FROM $prefix"."_counter");
if(mysql_num_rows($get_hits_avg)!=0)
{
$aus_hits_avg=mysql_fetch_object($get_hits_avg);
$hits_avg=$aus_hits_avg->hits_avg;
$hits_avg=sprintf("%.0f", $hits_avg);
}
else
{
$hits_avg="0";
}
echo "$hits_avg";
}
############## Hits Max. ######################################
if($aus_visible->id=="11")
{
$get_maxstats=mysql_query("SELECT hits_max FROM $prefix"."_counter_other");
if(mysql_num_rows($get_maxstats)!=0)
{
$aus_maxstats=mysql_fetch_object($get_maxstats);
$hits_max=$aus_maxstats->hits_max;
}
else
{
$hits_max="0";
}
echo "$hits_max";
}
############## Hits Heute ######################################
if($aus_visible->id=="12")
{
$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);
$hits_h=$aus_date_heute->hits;
}
else
{
$hits_h=0;
}
echo "$hits_h";
}
############## Hits Gestern ######################################
if($aus_visible->id=="13")
{
$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);
$hits_g=$aus_date_gestern->hits;
}
else
{
$hits_g=0;
}
echo "$hits_g";
}
############## Hits Vorgestern ######################################
if($aus_visible->id=="14")
{
$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);
$hits_vg=$aus_date_vgestern->hits;
}
else
{
$hits_vg=0;
}
echo "$hits_vg";
}
echo " font_face."; font-size:".$aus_layout->font_size."pt; color:".$aus_layout->font_color.";\">» font_face."; font-size:".$aus_layout->font_size."pt; color:".$aus_layout->font_color.";\">Statistik font_face."; font-size:".$aus_layout->font_size."pt; color:".$aus_layout->font_color.";\">© font_face."; font-size:".$aus_layout->font_size."pt; color:".$aus_layout->font_color.";\">usolved.net
";
echo "
";
##########################################################################
echo "";
echo " 
