// Lese Umgebung aus
$twiturl_request=str_replace("/","",$_SERVER["REQUEST_URI"]);
// Wenn es einen Code gibt
if(!empty($twiturl_request)) {
$tmp_query=mysql_query("SELECT * FROM twiturl_urls WHERE code LIKE '$twiturl_request' AND hide LIKE '0'");
while ($row = mysql_fetch_array($tmp_query)) {
$url_id=$row["id"];
$url_url=$row["url"];
$url_created=$row["created"];
}
if(!empty($url_id)) {
$query="SELECT * , COUNT( * ) FROM twiturl_visits WHERE url_id LIKE '$url_id' GROUP BY url_id";
$tmp_query=mysql_query("$query");
while ($row = mysql_fetch_array($tmp_query)) {
$url_count=$row["COUNT( * )"];
}
if(empty($url_count)) { $url_count="0"; }
// Datumsmanipulation
$url_datum=strtotime("$url_created");
$url_neuesdatum=strftime("%d. %B %Y",$url_datum);
?>
/**
$query="SELECT * , COUNT( * ) FROM twiturl_visits WHERE url_id LIKE '$url_id' GROUP BY date(timestamp) DESC LIMIT 0,7";
$tmp_query=mysql_query("$query");
$heute=$tmp_query;
$gestern=$tmp_query;
$tage2=$tmp_query;
$tage3=$tmp_query;
$tage4=$tmp_query;
$tage5=$tmp_query;
$tage6=$tmp_query;
// Heute
$tmp_heute = mktime(0, 0, 0, date("m"),date("d"),date("Y"));
while ($row = mysql_fetch_array($heute)) {
if(eregi(date("Y-m-d",$tmp_heute),$row["timestamp"])) {
$hits_heute=$row["COUNT( * )"];
}
}
if(empty($hits_heute)) { $hits_heute="0"; }
// Gestern
$tmp_gestern = mktime(0, 0, 0, date("m"),date("d")-1,date("Y"));
while ($row = mysql_fetch_array($gestern)) {
if(eregi(date("Y-m-d",$tmp_gestern),$row["timestamp"])) {
$hits_gestern=$row["COUNT( * )"];
}
}
if(empty($hits_gestern)) { $hits_gestern="0"; }
// Vor 2 Tagen
$tmp_tage2 = mktime(0, 0, 0, date("m"),date("d")-2,date("Y"));
while ($row = mysql_fetch_array($tage2)) {
if(eregi(date("Y-m-d",$tmp_tage2),$row["timestamp"])) {
$hits_tage2=$row["COUNT( * )"];
}
}
if(empty($hits_tage2)) { $hits_tage2="0"; }
// Vor 3 Tagen
$tmp_tage3 = mktime(0, 0, 0, date("m"),date("d")-3,date("Y"));
while ($row = mysql_fetch_array($tage3)) {
if(eregi(date("Y-m-d",$tmp_tage3),$row["timestamp"])) {
$hits_tage3=$row["COUNT( * )"];
}
}
if(empty($hits_tage3)) { $hits_tage3="0"; }
// Vor 4 Tagen
$tmp_tage4 = mktime(0, 0, 0, date("m"),date("d")-4,date("Y"));
while ($row = mysql_fetch_array($tage4)) {
if(eregi(date("Y-m-d",$tmp_tage4),$row["timestamp"])) {
$hits_tage4=$row["COUNT( * )"];
}
}
if(empty($hits_tage4)) { $hits_tage4="0"; }
// Vor 5 Tagen
$tmp_tage5 = mktime(0, 0, 0, date("m"),date("d")-5,date("Y"));
while ($row = mysql_fetch_array($tage5)) {
if(eregi(date("Y-m-d",$tmp_tage5),$row["timestamp"])) {
$hits_tage5=$row["COUNT( * )"];
}
}
if(empty($hits_tage5)) { $hits_tage5="0"; }
// Vor sechs Tagen
$tmp_tage6 = mktime(0, 0, 0, date("m"),date("d")-6,date("Y"));
while ($row = mysql_fetch_array($tage6)) {
if(eregi(date("Y-m-d",$tmp_tage6),$row["timestamp"])) {
$hits_tage6=$row["COUNT( * )"];
}
}
if(empty($hits_tage6)) { $hits_tage6="0"; }
// Wochenanzeige:
print "
Die Woche
";
print "
Heute, ".strftime("%d. %B %Y",$tmp_heute). ", ganze $hits_heute Mal";
print "Vorgestern, ".strftime("%d. %B %Y",$tmp_gestern). ", ganze $hits_gestern Mal";
print "Am ".strftime("%d. %B %Y",$tmp_tage2). " ganze $hits_tage2 Mal";
print "Am ".strftime("%d. %B %Y",$tmp_tage3). " ganze $hits_tage3 Mal";
print "Am ".strftime("%d. %B %Y",$tmp_tage4). " ganze $hits_tage4 Mal";
print "Am ".strftime("%d. %B %Y",$tmp_tage5). " ganze $hits_tage5 Mal";
print "Am ".strftime("%d. %B %Y",$tmp_tage6). " ganze $hits_tage6 Mal";
**/
}
if(empty($url_id)) {
unset($twiturl_request);
}
}
// Wenn es keinen Code gibt
if(empty($twiturl_request)) {
$tmp_time=date("Y")."-".date("m")."-".date("d");
$query="SELECT * , COUNT( * ) FROM twiturl_visits WHERE timestamp LIKE '$tmp_time%' GROUP BY date( timestamp ) ";
$tmp_query=mysql_query("$query");
while ($row = mysql_fetch_array($tmp_query)) {
$tmp_visitsid=$row["COUNT( * )"];
}
$tmp_query=mysql_query("SELECT * , COUNT( * ) FROM twiturl_urls WHERE created LIKE '$tmp_time%' GROUP BY date( created ) ");
while ($row = mysql_fetch_array($tmp_query)) {
$tmp_newid=$row["COUNT( * )"];
}
?>
}
?>