|
|
News Archiv

"Januar", 2 => "Februar", 3 => "März", 4 => "April", 5 => "Mai", 6 => "Juni",
7 => "Juli", 8 => "August", 9 => "September", 10 => "Oktober", 11 => "November", 12 => "Dezember");
echo "\n";
echo "\n";
echo "".$year."
\n";
for($m=1; $m <=12; $m++){
$ym = $year."0".$m;
if($m > 9){
$ym = $year.$m;
}
$result = mysql_query("SELECT count(archive) archive FROM wt_news
WHERE archive=".$ym);
$row = mysql_fetch_row($result);
if($row[0] > 0){
echo "".$months[$m]." (".$row[0].") ";
}
}
echo " | | \n";
}
$currentYear = date("Y", time());
$year = $currentYear;
for($i=0; $i <= $currentYear-2004; $i++){
// ZEILEN ENDE
if($i%4 == 0 && $i != 0){
echo " \n";
}
// Neue ZEILE ANFANG
if($i%4 == 0 && $i != 0){
echo "\n";
}
fnc_year($year);
$year--;
}
?>
';
echo date("Y|m", $data2["newsdate"]);
echo "
";
$result = mysql_query("SELECT th.threadid, th.title, th.dateline, th.replycount,
th.postusername AS username, th.postuserid AS userid,
p.pagetext AS text, n.*, c.*, s.*, u.usergroupid,
u.username AS usertableusername
FROM wt_news AS n JOIN
user AS u ON n.newsuserid = u.userid JOIN
wt_newscategory AS c ON n.categoryid = c.categoryid JOIN
wt_newssymbol AS s ON n.symbolid = s.symbolid LEFT JOIN
post AS p ON n.postid=p.postid LEFT JOIN
thread AS th ON p.threadid=th.threadid
WHERE n.archive='".mysql_real_escape_string($_GET['archive'])."' AND n.deleted = 0 AND n.published = 1
ORDER BY n.newsdate DESC");
$i = 0;
$showBanner = false;
while($news = mysql_fetch_array($result)){
$news["sources"] = getSourcesByNewsId($news["id"]);
$news["maincategoryid"] = $news["supercategory"];
$news["publishdate"] = date("d.m.Y H:i:s", strtotime($news["publishdate"]));
// news state
$newsState = $NEWS_STATE["published"];
if($news["deleted"] == 1){ // deleted
$newsState = $NEWS_STATE["deleted"];
}else if($news["published"] == 0 && $news["usergroupid"] == 31){ // news saved
$newsState = $NEWS_STATE["saved"];
}else if($news["published"] == 1 && $news["publishlater"] == 1){ // publish news later
$newsState = $NEWS_STATE["publishLater"];
}else if($news["usergroupid"] != 31 && $news["published"] == 0){ // waiting for confirmation
$newsState = $NEWS_STATE["confirmationRequired"];
}
// Show news to the public?
$show = false;
if($newsState == $NEWS_STATE["published"]){
$show = true;
}
// if saved
if($news["postid"] == 0){
$news["text"] = $news["newstext"];
$news["title"] = $news["newstitle"];
$news["replycount"] = 0;
$news["dateline"] = $news["newsdate"];
$news["userid"] = $news["newsuserid"];
$news["threadid"] = 0;
$news["username"] = $news["usertableusername"];
}
if($show){
include("templates/newsBit.php");
echo "
";
$i++;
if($i == 2 && !$showBanner)
$showBanner = true;
}
if($showBanner){
$showBanner = false;
echo ' ';
}
}
}
?>
|
|
Kein Kopieren von Inhalten oder Bildern ohne Genehmigung.
Wartower.de & all Content is © 2004-2019 by Wartower.de - Layout: Eduard Seibel
Guild Wars ©2019 ArenaNet,
Inc. All rights reserved. ArenaNet, Arena.Net and the ArenaNet logo are trademarks
or registered trademarks of NCsoft Corporation in the U.S. and/or other countries.
|
|
poll_process("newest");*/ ?>
|