'$newlinkDB' and datum < '$stopadd' and '$nowdate' < enddate and isValidated = 'Yes' and isChanged = 'No'", $dbi); $totallinks = sql_num_rows($result, $dbi); $counter++; $alldaylinks = $alldaylinks + $totallinks; } // Last week $counter = 0; $allweeklinks = 0; while ($counter <= 7-1){ $newlinkdayRaw = (time()-(86400 * $counter)); $stopadd=$newlinkdayRaw+86400; // $newlinkday = date("d-M-Y", $newlinkdayRaw); $newlinkDB = $newlinkdayRaw; $nowdate=time(); $result = sql_query("select * FROM ".$prefix."_add_adds WHERE datum > '$newlinkDB' and datum < '$stopadd' and '$nowdate' < enddate and isValidated = 'Yes' and isChanged = 'No'", $dbi); $totallinks = sql_num_rows($result, $dbi); $counter++; $allweeklinks = $allweeklinks + $totallinks; } // Last 2 weeks $counter = 0; $all2weeklinks = 0; while ($counter <= 7-1){ $newlinkdayRaw = (time()-(86400 * $counter)); $stopadd=$newlinkdayRaw+86400; // $newlinkday = date("d-M-Y", $newlinkdayRaw); $newlinkDB = $newlinkdayRaw; $nowdate=time(); $result = sql_query("select * FROM ".$prefix."_add_adds WHERE datum > '$newlinkDB' and datum < '$stopadd' and '$nowdate' < enddate and isValidated = 'Yes' and isChanged = 'No'", $dbi); $totallinks = sql_num_rows($result, $dbi); $counter++; $all2weeklinks = $all2weeklinks + $totallinks; } /* $counter = 0; while ($counter <=7-1){ $newlinkdayRaw = (time()-(86400 * $counter)); $stopadd=$newlinkdayRaw+86400; $newlinkDB = $newlinkdayRaw; $nowdate=time(); $result = sql_query("select * FROM ".$prefix."_add_adds WHERE datum > '$newlinkDB' and datum < '$stopadd' and '$nowdate' < enddate and isValidated = 'Yes' and isChanged = 'No'", $dbi); $totallinks = sql_num_rows($result, $dbi); $allmonthlinks = $allmonthlinks + $totallinks; $counter++; } */ echo ""._CSF_NEWADDS.":" ." "._CSF_TODAY."($alldaylinks) - "._CSF_1WEEK."($allweeklinks) - SOS-Archiv" ."
"; /* List Last VARIABLE Days of Links */ if (!isset($newaddshowdays)) { $newaddshowdays = 1; } if ($newaddshowdays >= 8) { $newaddshowdays = 7; } echo "
"._CSF_TOTALADDLAST." $newaddshowdays "._CSF_DAYS." :

"; $counter = 0; $allweeklinks = 0; echo "
\n"; while ($counter <= $newaddshowdays-1) { $newlinkdayRaw = (time()-(86400 * ($counter+1))); $stopadd=$newlinkdayRaw+86400; $newlinkday = date("d-M-Y", $newlinkdayRaw); $newlinkView = date("d.m.Y", $newlinkdayRaw); $newlinkDB = $newlinkdayRaw; $nowdate=time(); $result = sql_query("select * FROM ".$prefix."_add_adds WHERE datum > '$newlinkDB' and datum < '$stopadd' and '$nowdate' < enddate and isValidated = 'Yes' and isChanged = 'No'", $dbi); $totallinks = sql_num_rows($result, $dbi); $counter++; $alldaylinks = $alldaylinks + $totallinks; // New Links View $nowdate=time(); $result=sql_query("select lid, cid, sid, title, datum, hits, pic, contacter from ".$prefix."_add_adds where datum > '$newlinkDB' and datum < '$stopadd' and '$nowdate' < enddate and isValidated = 'Yes' and isChanged = 'No' order by datum DESC", $dbi); $anzahl=sql_num_rows($result,$dbi); if ($anzahl > "0"){ $x=0; while(list($lid, $cid, $sid, $title, $time, $hits, $pic, $contacter)=sql_fetch_row($result, $dbi)) { $title = stripslashes($title); $datetime=date("d.m.Y",$time); $result2=sql_query("select title from ".$prefix."_add_categories where cid=$cid", $dbi); list($ctitle) = sql_fetch_row($result2, $dbi); $cnewsline_light = "naddsline_light"; $cnewsline = "naddsline"; if ($newsline == $cnewsline) { $newsline = $cnewsline_light; } else { $newsline = $cnewsline; } echo "
"; echo "
$datetime
(${hits} gelesen)
"; echo "
\n"; /* Ende newsline */ $x++; }} // else{echo "

"._NOADDS."

";} } echo "
"; /* Ende newsadds */ $counter = 0; $allmonthlinks = 0; echo ""; copyright(); include("footer.php"); ?>