<?php
/*
##########################################################################
# #
# Version 4 / / / #
# -----------__---/__---__------__----__---/---/- #
# | /| / /___) / ) (_ ` / ) /___) / / #
# _|/_|/__(___ _(___/_(__)___/___/_(___ _/___/___ #
# Free Content / Management System #
# / #
# #
# #
# Copyright 2005-2010 by webspell.org #
# #
# visit webSPELL.org, webspell.info to get webSPELL for free #
# - Script runs under the GNU GENERAL PUBLIC LICENSE #
# - It's NOT allowed to remove this copyright-tag #
# -- http://www.fsf.org/licensing/licenses/gpl.html #
# #
# Code based on WebSPELL Clanpackage (Michael Gruber - webspell.at), #
# Far Development by Development Team - webspell.org #
# #
# visit webspell.org #
# #
##########################################################################
*/
if(isset($_GET['action'])) $action = $_GET['action'];
else $action = '';
if($action=="save") {
include("_mysql.php");
include("_settings.php");
include("_functions.php");
$_language->read_module('articles');
if(!isnewswriter($userID)) die($_language->module['no_access']);
$title = $_POST['title'];
$message = $_POST['message'];
$link1 = $_POST['link1'];
$url1 = $_POST['url1'];
$window1 = $_POST['window1'];
$link2 = $_POST['link2'];
$url2 = $_POST['url2'];
$window2 = $_POST['window2'];
$link3 = $_POST['link3'];
$url3 = $_POST['url3'];
$window3 = $_POST['window3'];
$link4 = $_POST['link4'];
$url4 = $_POST['url4'];
$window4 = $_POST['window4'];
$r_v = $_POST['r_v'];
$b_v = $_POST['b_v'];
$m_v = $_POST['m_v'];
$c_v = $_POST['c_v'];
$lb_v = $_POST['lb_v'];
$s_v = $_POST['s_v'];
$a_v = $_POST['a_v'];
$e_v = $_POST['e_v'];
$k_v = $_POST['k_v'];
$schwere = $_POST['schwere'];
$general = $_POST['general'];
$content_a = $_POST['content_a'];
$comments = $_POST['comments'];
$rubricID=$_POST['rubric'];
$articlesID = $_POST['articlesID'];
safe_query("UPDATE ".PREFIX."articles SET
title='".$title."',
link1='".$link1."',
url1='".$url1."',
window1='".$window1."',
link2='".$link2."',
url2='".$url2."',
window2='".$window2."',
link3='".$link3."',
url3='".$url3."',
window3='".$window3."',
link4='".$link4."',
url4='".$url4."',
window4='".$window4."',
r_v='".$r_v."',
b_v='".$b_v."',
m_v='".$m_v."',
c_v='".$c_v."',
lb_v='".$lb_v."',
s_v='".$s_v."',
a_v='".$a_v."',
e_v='".$e_v."',
k_v='".$k_v."',
schwere='".$schwere."',
general='".$general."',
content_a='".$content_a."',
rubricID='".$rubricID."',
saved='1',
comments='".$comments."' WHERE articlesID='".$articlesID."'");
$anzpages = mysql_num_rows(safe_query("SELECT * FROM ".PREFIX."articles_contents WHERE articlesID='".$articlesID."'"));
if($anzpages > count($message)) {
safe_query("DELETE FROM `".PREFIX."articles_contents` WHERE `articlesID` = '".$articlesID."' and `page` > ".count($message));
}
for($i = 0; $i <= count($message); $i++) {
if(isset($message[$i])){
if($i >= $anzpages) {
safe_query("INSERT INTO ".PREFIX."articles_contents (articlesID, content, page) VALUES ('".$articlesID."', '".$message[$i]."', '".$i."')");
}
else {
safe_query("UPDATE ".PREFIX."articles_contents SET content = '".$message[$i]."' WHERE articlesID = '".$articlesID."' and page = '".$i."'");
}
}
}
for($x=$_POST['language_count'];$x<100;$x++){
safe_query("DELETE FROM ".PREFIX."articles_contents WHERE articlesID = '".$articlesID."' and page = '".$x."'");
}
// delete the entries that are older than 2 hour and contain no text
safe_query("DELETE FROM `".PREFIX."articles` WHERE `saved` = '0' and ".time()." - `date` > ".(2 * 60 * 60));
die('<body onload="window.close()"></body>');
}
elseif(isset($_GET['delete'])) {
include("_mysql.php");
include("_settings.php");
include("_functions.php");
$_language->read_module('articles');
$ds=mysql_fetch_array(safe_query("SELECT screens,poster FROM ".PREFIX."articles WHERE articlesID='".$_GET['articlesID']."'"));
if($userID != $ds['poster'] or !isnewsadmin($userID)) die($_language->module['no_access']);
if($ds['screens']) {
$screens=explode("|", $ds['screens']);
if(is_array($screens)) {
$filepath = "./images/articles-pics/";
foreach($screens as $screen) {
if(file_exists($filepath.$screen)) @unlink($filepath.$screen);
}
}
}
safe_query("DELETE FROM ".PREFIX."articles WHERE articlesID='".$_GET['articlesID']."'");
safe_query("DELETE FROM ".PREFIX."articles_contents WHERE articlesID='".$_GET['articlesID']."'");
safe_query("DELETE FROM ".PREFIX."comments WHERE parentID='".$_GET['articlesID']."' AND type='ar'");
if(isset($close)) echo'<body onload="window.close()"></body>';
else header("Location: index.php?site=articles");
}
function top5() {
$pagebg=PAGEBG;
$border=BORDER;
$bghead=BGHEAD;
$bgcat=BGCAT;
global $_language;
$_language->read_module('articles');
echo'<table cellspacing="0" cellpadding="0" width="100%"><tr><td align="center"><div class="top_5"><table border="0" cellspacing="0" cellpadding="0" width="100%">
<tr>
<td width="49%" valign="top">';
if(empty($_GET['rubricID'])) $rub=""; else $rub="and rubricID='".$_GET['rubricID']."'";
// RATING
$ergebnis=safe_query("SELECT * FROM ".PREFIX."articles WHERE saved='1' $rub ORDER BY rating DESC LIMIT 0,5");
$top=$_language->module['top5_rating'];
eval ("\$top5_head = \"".gettemplate("top5_head")."\";");
echo $top5_head;
$n=1;
while($ds=mysql_fetch_array($ergebnis)) {
if($n%2) {
$bg1=BG_1;
$bg2=BG_2;
}
else {
$bg1=BG_3;
$bg2=BG_4;
}
$title='<a href="index.php?site=articles&action=show&articlesID='.$ds['articlesID'].'">'.clearfromtags($ds['title']).'</a>';
$poster='<a href="index.php?site=profile&id='.$ds['poster'].'">'.getnickname($ds['poster']).'</a>';
$viewed='('.$ds['viewed'].')';
$ratings=array(0,0,0,0,0,0,0,0,0,0);
for($i=0; $i<$ds['rating']; $i++) {
$ratings[$i]=1;
}
$ratingpic='<img src="images/icons/rating_'.$ratings[0].'_start.gif" width="1" height="5" alt="" />';
foreach($ratings as $pic) {
$ratingpic.='<img src="images/icons/rating_'.$pic.'.gif" width="4" height="5" alt="" />';
}
echo'<tr>
<td align="center"><b>'.$n.'.</b></td>
<td align="center" style="white-space:nowrap;">'.$ratingpic.'</td>
<td>'.$title.'</td>
</tr>';
unset($ratingpic);
$n++;
}
echo'</table>';
echo'</td><td width="49%" valign="top">';
// POINTS
$ergebnis=safe_query("SELECT * FROM ".PREFIX."articles WHERE saved='1' $rub ORDER BY points DESC LIMIT 0,5");
$top=$_language->module['top5_points'];
eval ("\$top5_head = \"".gettemplate("top5_head")."\";");
echo $top5_head;
$n=1;
while($ds=mysql_fetch_array($ergebnis)) {
if($n%2) {
$bg1=BG_1;
$bg2=BG_2;
}
else {
$bg1=BG_3;
$bg2=BG_4;
}
$title='<a href="index.php?site=articles&action=show&articlesID='.$ds['articlesID'].'">'.clearfromtags($ds['title']).'</a>';
$viewed='('.$ds['viewed'].')';
echo'<tr>
<td align="center"><b>'.$n.'.</b></td>
<td align="center">'.$ds['points'].'</td>
<td>'.$title.'</td>
</tr>';
$n++;
}
echo'</table></td></tr></table></div></td></tr></table>';
}
if($action=="new") {
include("_mysql.php");
include("_settings.php");
include("_functions.php");
$_language->read_module('articles');
$_language->read_module('bbcode', true);
$pagebg=PAGEBG;
$border=BORDER;
$bghead=BGHEAD;
$bgcat=BGCAT;
if(isnewswriter($userID)) {
safe_query("INSERT INTO ".PREFIX."articles ( date, poster, saved ) VALUES( '".time()."', '$userID', '0' ) ");
$articlesID=mysql_insert_id();
$selects='';
for($i=1;$i<100;$i++) {
$selects .= '<option value="'.$i.'">'.$i.'</option>';
}
if($ds['r_v'])
$r_v='<input type="checkbox" name="r_v" value="icon_recruit.png" checked="checked" />';
else $r_v='<input type="checkbox" name="r_v" value="icon_recruit.png" />';
if($ds['b_v'])
$b_v='<input type="checkbox" name="b_v" value="icon_bowman.png" checked="checked" />';
else $b_v='<input type="checkbox" name="b_v" value="icon_bowman.png" />';
if($ds['m_v'])
$m_v='<input type="checkbox" name="m_v" value="icon_militia.png" checked="checked" />';
else $m_v='<input type="checkbox" name="m_v" value="icon_militia.png" />';
if($ds['c_v'])
$c_v='<input type="checkbox" name="c_v" value="icon_cavalry.png" checked="checked" />';
else $c_v='<input type="checkbox" name="c_v" value="icon_cavalry.png" />';
if($ds['lb_v'])
$lb_v='<input type="checkbox" name="lb_v" value="icon_longbowman.png" checked="checked" />';
else $lb_v='<input type="checkbox" name="lb_v" value="icon_longbowman.png" />';
if($ds['s_v'])
$s_v='<input type="checkbox" name="s_v" value="icon_soldier.png" checked="checked" />';
else $s_v='<input type="checkbox" name="s_v" value="icon_soldier.png" />';
if($ds['a_v'])
$a_v='<input type="checkbox" name="a_v" value="icon_crossbowman.png" checked="checked" />';
else $a_v='<input type="checkbox" name="a_v" value="icon_crossbowman.png" />';
if($ds['e_v'])
$e_v='<input type="checkbox" name="e_v" value="icon_elite_soldier.png" checked="checked" />';
else $e_v='<input type="checkbox" name="e_v" value="icon_elite_soldier.png" />';
if($ds['k_v'])
$k_v='<input type="checkbox" name="k_v" value="icon_cannoneer.png" checked="checked" />';
else $k_v='<input type="checkbox" name="k_v" value="icon_cannoneer.png" />';
$schwere='<option value="">Schwierigkeit Wählen:</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>';
$general='<option value="">General Wählen:</option>
<option value="200">200</option>
<option value="250">250</option>';
$rubrics='<option value="">Abendteuer Wählen:</option>';
$articlesrubrics=safe_query("SELECT rubricID, rubric FROM ".PREFIX."articles_rubrics ORDER BY rubric");
while($dr=mysql_fetch_array($articlesrubrics)) {
$rubrics.='<option value="'.$dr['rubricID'].'">'.$dr['rubric'].'</option>';
}
$pages = 1;
$bg1=BG_1;
eval ("\$addbbcode = \"".gettemplate("addbbcode")."\";");
eval ("\$addflags = \"".gettemplate("flags")."\";");
eval ("\$articles_post = \"".gettemplate("articles_post")."\";");
echo $articles_post;
}
else redirect('index.php?site=articles', $_language->module['no_access']);
}
elseif($action=="edit") {
include("_mysql.php");
include("_settings.php");
include("_functions.php");
$_language->read_module('articles');
$_language->read_module('bbcode', true);
$articlesID = $_GET['articlesID'];
$pagebg=PAGEBG;
$border=BORDER;
$bghead=BGHEAD;
$bgcat=BGCAT;
if($userID = $ds['poster'] or isnewsadmin($userID)) {
$ds=mysql_fetch_array(safe_query("SELECT * FROM ".PREFIX."articles WHERE articlesID = '".$articlesID."'"));
$title=getinput($ds['title']);
$rubricID =getinput($ds['rubricID']);
$message = array();
$query = safe_query("SELECT content FROM ".PREFIX."articles_contents WHERE articlesID = '".$articlesID."' ORDER BY page ASC");
while($qs = mysql_fetch_array($query)) {
$message[] = $qs['content'];
}
$message_vars='';
$i=0;
foreach($message as $val) {
$message_vars .= "message[".$i."] = '".js_replace($val)."';\n";
$i++;
}
$pages = count($message);
$selects='';
for($i=1;$i<100;$i++) {
if($i==$pages) $selected = "selected='selected'";
else $selected = NULL;
$selects .= '<option value="'.$i.'" '.$selected.'>'.$i.'</option>';
}
if($ds['r_v'])
$r_v='<input type="checkbox" name="r_v" value="icon_recruit.png" checked="checked" />';
else $r_v='<input type="checkbox" name="r_v" value="icon_recruit.png" />';
if($ds['b_v'])
$b_v='<input type="checkbox" name="b_v" value="icon_bowman.png" checked="checked" />';
else $b_v='<input type="checkbox" name="b_v" value="icon_bowman.png" />';
if($ds['m_v'])
$m_v='<input type="checkbox" name="m_v" value="icon_militia.png" checked="checked" />';
else $m_v='<input type="checkbox" name="m_v" value="icon_militia.png" />';
if($ds['c_v'])
$c_v='<input type="checkbox" name="c_v" value="icon_cavalry.png" checked="checked" />';
else $c_v='<input type="checkbox" name="c_v" value="icon_cavalry.png" />';
if($ds['lb_v'])
$lb_v='<input type="checkbox" name="lb_v" value="icon_longbowman.png" checked="checked" />';
else $lb_v='<input type="checkbox" name="lb_v" value="icon_longbowman.png" />';
if($ds['s_v'])
$s_v='<input type="checkbox" name="s_v" value="icon_soldier.png" checked="checked" />';
else $s_v='<input type="checkbox" name="s_v" value="icon_soldier.png" />';
if($ds['a_v'])
$a_v='<input type="checkbox" name="a_v" value="icon_crossbowman.png" checked="checked" />';
else $a_v='<input type="checkbox" name="a_v" value="icon_crossbowman.png" />';
if($ds['e_v'])
$e_v='<input type="checkbox" name="e_v" value="icon_elite_soldier.png" checked="checked" />';
else $e_v='<input type="checkbox" name="e_v" value="icon_elite_soldier.png" />';
if($ds['k_v'])
$k_v='<input type="checkbox" name="k_v" value="icon_cannoneer.png" checked="checked" />';
else $k_v='<input type="checkbox" name="k_v" value="icon_cannoneer.png" />';
$rubrics='test';
$articlesrubrics=safe_query("SELECT rubricID, rubric FROM ".PREFIX."articles_rubrics ORDER BY rubric");
while($dr=mysql_fetch_array($articlesrubrics)) {
$rubrics.='<option value="'.$dr['rubricID'].'">'.$dr['rubric'].'</option>';
}
$schwere='<option value="'.$ds['schwere'].'">Schwierigkeit: '.$ds['schwere'].'</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>';
$general='<option value="'.$ds['general'].'">General: '.$ds['general'].'</option>
<option value="200">200</option>
<option value="250">250</option>';
/*
$articlesrubrics=safe_query("SELECT * FROM ".PREFIX."articles_rubrics ORDER BY rubric");
$rubrics='<option value="'.$dr['rubricID'].'">'.getinput($dr['rubric']).'</option>';
while($dr=mysql_fetch_array($articlesrubrics)) {
if($dr['rubric']==$dr['rubricID']) $rubrics.='<option value="'.$dr['rubricID'].'" selected="selected">'.getinput($dr['rubric']).'</option>';
else $rubrics.='<option value="'.$dr['rubricID'].'">'.getinput($dr['rubric']).'</option>';
}
*/
$link1=getinput($ds['link1']);
$link2=getinput($ds['link2']);
$link3=getinput($ds['link3']);
$link4=getinput($ds['link4']);
$url1=getinput($ds['url1']);
$url2=getinput($ds['url2']);
$url3=getinput($ds['url3']);
$url4=getinput($ds['url4']);
if($ds['window1']) $window1='<input class="input" name="window1" type="radio" value="1" checked="checked" /> '.$_language->module['new_window'].' <input class="input" type="radio" name="window1" value="0" /> '.$_language->module['self'].'';
else $window1='<input class="input" name="window1" type="radio" value="1" /> '.$_language->module['new_window'].' <input class="input" type="radio" name="window1" value="0" checked="checked" /> '.$_language->module['self'].'';
if($ds['window2']) $window2='<input class="input" name="window2" type="radio" value="1" checked="checked" /> '.$_language->module['new_window'].' <input class="input" type="radio" name="window2" value="0" /> '.$_language->module['self'].'';
else $window2='<input class="input" name="window2" type="radio" value="1" /> '.$_language->module['new_window'].' <input class="input" type="radio" name="window2" value="0" checked="checked" /> '.$_language->module['self'].'';
if($ds['window3']) $window3='<input class="input" name="window3" type="radio" value="1" checked="checked" /> '.$_language->module['new_window'].' <input class="input" type="radio" name="window3" value="0" /> '.$_language->module['self'].'';
else $window3='<input class="input" name="window3" type="radio" value="1" /> '.$_language->module['new_window'].' <input class="input" type="radio" name="window3" value="0" checked="checked" /> '.$_language->module['self'].'';
if($ds['window4']) $window4='<input class="input" name="window4" type="radio" value="1" checked="checked" /> '.$_language->module['new_window'].' <input class="input" type="radio" name="window4" value="0" /> '.$_language->module['self'].'';
else $window4='<input class="input" name="window4" type="radio" value="1" /> '.$_language->module['new_window'].' <input class="input" type="radio" name="window4" value="0" checked="checked" /> '.$_language->module['self'].'';
$comments='<option value="0">'.$_language->module['no_comments'].'</option><option value="1">'.$_language->module['user_comments'].'</option>';
$comments=str_replace('value="'.$ds['comments'].'"', 'value="'.$ds['comments'].'" selected="selected"', $comments);
$bg1=BG_1;
eval ("\$addbbcode = \"".gettemplate("addbbcode")."\";");
eval ("\$addflags = \"".gettemplate("flags")."\";");
eval ("\$articles_edit = \"".gettemplate("articles_edit")."\";");
echo $articles_edit;
}
else redirect('index.php?site=articles', $_language->module['no_access']);
}
elseif($action=="show") {
$_language->read_module('articles');
eval ("\$title_articles = \"".gettemplate("title_articles")."\";");
echo $title_articles;
$articlesID = (int)$_GET['articlesID'];
if(isset($_GET['page'])) $page = (int)$_GET['page'];
else $page = 1;
if($page==1) safe_query("UPDATE ".PREFIX."articles SET viewed=viewed+1 WHERE articlesID='".$articlesID."'");
$result=safe_query("SELECT * FROM ".PREFIX."articles WHERE articlesID='".$articlesID."'");
if(mysql_num_rows($result)) {
$ds=mysql_fetch_array($result);
$date = date("d.m.Y", $ds['date']);
$time = date("H:i", $ds['date']);
$title = clearfromtags($ds['title']);
$content_a = htmloutput($ds['content_a']);
$content = array();
$query = safe_query("SELECT * FROM ".PREFIX."articles_contents WHERE articlesID = '".$articlesID."' ORDER BY page ASC");
while($qs = mysql_fetch_array($query)) {
$content[] = $qs['content'];
}
$pages = count($content);
$content = htmloutput($content[$page-1]);
$content = toggle($content, $ds['articlesID']);
if($pages>1) $page_link = makepagelink("index.php?site=articles&action=show&articlesID=$articlesID", $page, $pages);
else $page_link='';
$poster='<a href="index.php?site=profile&id='.$ds['poster'].'"><b>'.getnickname($ds['poster']).'</b></a>';
$related="";
if($ds['link1'] && $ds['url1']!="http://" && $ds['window1']) $related.='<a href="'.$ds['url1'].'" target="_blank">'.$ds['link1'].'</a> ';
if($ds['link1'] && $ds['url1']!="http://" && !$ds['window1']) $related.='<a href="'.$ds['url1'].'">'.$ds['link1'].'</a> ';
if($ds['link2'] && $ds['url2']!="http://" && $ds['window2']) $related.='<a href="'.$ds['url2'].'" target="_blank">'.$ds['link2'].'</a> ';
if($ds['link2'] && $ds['url2']!="http://" && !$ds['window2']) $related.='<a href="'.$ds['url2'].'">'.$ds['link2'].'</a> ';
if($ds['link3'] && $ds['url3']!="http://" && $ds['window3']) $related.='<a href="'.$ds['url3'].'" target="_blank">'.$ds['link3'].'</a> ';
if($ds['link3'] && $ds['url3']!="http://" && !$ds['window3']) $related.='<a href="'.$ds['url3'].'">'.$ds['link3'].'</a> ';
if($ds['link4'] && $ds['url4']!="http://" && $ds['window4']) $related.='<a href="'.$ds['url4'].'" target="_blank">'.$ds['link4'].'</a> ';
if($ds['link4'] && $ds['url4']!="http://" && !$ds['window4']) $related.='<a href="'.$ds['url4'].'">'.$ds['link4'].'</a> ';
if(empty($related)) $related="n/a";
$rubricID = $ds['rubricID'];
$comments_allowed = $ds['comments'];
$kath=safe_query("SELECT * FROM ".PREFIX."articles_rubrics WHERE rubricID='".$rubricID."'");
while($dk=mysql_fetch_array($kath)) {
$rubname = "".$dk['rubric']."";
}
$ratings=array(0,0,0,0,0,0,0,0,0,0);
for($i=0; $i<$ds['rating']; $i++) {
$ratings[$i]=1;
}
$ratingpic='<img src="images/icons/rating_'.$ratings[0].'_start.gif" width="1" height="5" alt="" />';
foreach($ratings as $pic) {
$ratingpic.='<img src="images/icons/rating_'.$pic.'.gif" width="4" height="5" alt="" />';
}
if(($userID == $ds['poster'] or isnewsadmin($userID))) $actions='<td><input type="button" onclick="MM_openBrWindow(\'articles.php?action=edit&articlesID='.$ds['articlesID'].'\',\'News\',\'toolbar=no,status=no,scrollbars=yes,width=520,height=500\');" value="'.$_language->module['edit'].'" /></td>
<td><input type="button" onclick="MM_confirm(\''.$_language->module['really_delete'].'\', \'articles.php?delete=true&articlesID='.$ds['articlesID'].'\');" value="'.$_language->module['delete'].'" /></td>';
else $actions='';
if($loggedin) {
$getarticles=safe_query("SELECT articles FROM ".PREFIX."user WHERE userID='$userID'");
$found=false;
if(mysql_num_rows($getarticles)) {
$ga=mysql_fetch_array($getarticles);
if($ga['articles']!="") {
$string=$ga['articles'];
$array=explode(":", $string);
$anzarray=count($array);
for($i=0; $i<$anzarray; $i++) {
if($array[$i]==$articlesID) $found=true;
}
}
}
if($found) $rateform=$_language->module['already_rated'];
else $rateform='<form method="post" action="rating.php">
<table cellspacing="0" cellpadding="2" align="right">
<tr>
<td>'.$_language->module['rate_with'].'
<select name="rating">
<option>0 - '.$_language->module['poor'].'</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10 - '.$_language->module['perfect'].'</option>
</select>
<input type="hidden" name="userID" value="'.$userID.'" />
<input type="hidden" name="type" value="ar" />
<input type="hidden" name="id" value="'.$ds['articlesID'].'" />
<input type="submit" name="Submit" value="'.$_language->module['rate'].'" /></td>
</tr>
</table>
</form>';
}
else $rateform=$_language->module['login_for_rate'];
$bg1=BG_1;
eval ("\$articles = \"".gettemplate("articles")."\";");
echo $articles;
unset($related);
unset($comments);
unset($lang);
unset($ds);
unset($ratingpic);
unset($page);
unset($pages);
$parentID = $articlesID;
$type = "ar";
$referer = "index.php?site=articles&action=show&articlesID=$articlesID";
include("comments.php");
}
else echo $_language->module['no_entries'];
}
elseif($action=="rubric") {
$_language->read_module('articles');
if(isset($_GET['page'])) $page=(int)$_GET['page'];
else $page = 1;
$sort="date";
if(isset($_GET['sort'])){
if(($_GET['sort']=='date') || ($_GET['sort']=='poster') || ($_GET['sort']=='rating') || ($_GET['sort']=='schwere') || ($_GET['sort']=='viewed')) $sort=$_GET['sort'];
}
$type="DESC";
if(isset($_GET['type'])){
if(($_GET['type']=='ASC') || ($_GET['type']=='DESC')) $type=$_GET['type'];
}
$kath=safe_query("SELECT * FROM ".PREFIX."articles_rubrics WHERE rubricID='".$rubricID."'");
while($dk=mysql_fetch_array($kath)) {
$rubname = "".$dk['rubric']."";
}
$rubricID = $_GET['rubricID'];
$get = safe_query("SELECT * FROM ".PREFIX."articles_rubrics WHERE rubricID='".$rubricID."'");
$dc = mysql_fetch_assoc($get);
$map = $dc['map'];
$ep = $dc['ep'];
$spieler = $dc['spieler'];
$tage = $dc['tage'];
$sg = $dc['sg'];
$rubname = $dc['rubric'];
$typ = $dc['typ'];
$erhaltbar = $dc['erhaltbar'];
$spielerstufe = $dc['spielerstufe'];
$unterrichtung = $dc['unterrichtung'];
$siegbedingung = $dc['siegbedingung'];
$niederlage = $dc['niederlage'];
$missionserfolg = $dc['missionserfolg'];
$truppen = $dc['truppen'];
eval ("\$title_articles = \"".gettemplate("title_articles_1")."\";");
echo $title_articles;
if(isnewswriter($userID)) echo'<input type="button" onclick="MM_openBrWindow(\'articles.php?action=new\',\'Articles\',\'toolbar=no,status=no,scrollbars=yes,width=520,height=500\');" value="'.$_language->module['new_article'].'" /><br>';
$alle=safe_query("SELECT articlesID FROM ".PREFIX."articles WHERE saved='1' and rubricID='".$_GET['rubricID']."'");
$gesamt = mysql_num_rows($alle);
$pages=1;
$max=$maxarticles;
for ($n=$max; $n<=$gesamt; $n+=$max) {
if($gesamt>$n) $pages++;
}
if($pages>1) $page_link = makepagelink("index.php?site=articles&action=rubric&rubricID=".$_GET['rubricID']."&sort=".$sort."&type=".$type, $page, $pages);
else $page_link='';
if ($page == "1") {
$ergebnis = safe_query("SELECT * FROM ".PREFIX."articles WHERE saved='1' and rubricID='".$_GET['rubricID']."' ORDER BY $sort $type LIMIT 0,$max");
if($type=="DESC") $n=$gesamt;
else $n=1;
}
else {
$start=$page*$max-$max;
$ergebnis = safe_query("SELECT * FROM ".PREFIX."articles WHERE saved='1' and rubricID='".$_GET['rubricID']."' ORDER BY $sort $type LIMIT $start,$max");
if($type=="DESC") $n = ($gesamt)-$page*$max+$max;
else $n = ($gesamt+1)-$page*$max+$max;
}
if($gesamt) {
if($type=="ASC")
echo'<table cellspacing="1" border="0" cellpadding="4">
<tr>
<td width="590"><a href="index.php?site=articles&action=rubric&rubricID='.$_GET['rubricID'].'&page='.$page.'&sort='.$sort.'&type=DESC">'.$_language->module['sort'].'</a> <img src="images/icons/asc.gif" width="9" height="7" border="0" alt="" /></td>
</tr>
</table>';
else
echo'<table cellspacing="1" border="0" cellpadding="4">
<tr>
<td width="590"><a href="index.php?site=articles&action=rubric&rubricID='.$_GET['rubricID'].'&page='.$page.'&sort='.$sort.'&type=ASC">'.$_language->module['sort'].'</a> <img src="images/icons/desc.gif" width="9" height="7" border="0" alt="" /></td>
</tr>
</table>';
if($pages>1) echo $page_link;
$rubricID=$_GET['rubricID'];
eval ("\$articles_head = \"".gettemplate("articles_head")."\";");
echo $articles_head;
$n=1;
while($ds=mysql_fetch_array($ergebnis)) {
if($n%2) {
$bg1=BG_1;
$bg2=BG_2;
}
else {
$bg1=BG_3;
$bg2=BG_4;
}
$date=date("d.m.Y", $ds['date']);
$title='<a href="index.php?site=articles&action=show&articlesID='.$ds['articlesID'].'">'.clearfromtags($ds['title']).'</a>';
$poster='<a href="index.php?site=profile&id='.$ds['poster'].'">'.getnickname($ds['poster']).'</a>';
$viewed=$ds['viewed'];
$schwere = $ds['schwere'];
$general = $ds['general'];
$rubricpic=$ds['rubricpic'];
$ratings=array(0,0,0,0,0,0,0,0,0,0);
for($i=0; $i<$ds['rating']; $i++) {
$ratings[$i]=1;
}
$ratingpic='<img src="images/icons/rating_'.$ratings[0].'_start.gif" width="1" height="5" alt="" />';
foreach($ratings as $pic) {
$ratingpic.='<img src="images/icons/rating_'.$pic.'.gif" width="4" height="5" alt="" />';
}
if($ds['r_v'])
$r_v = '<img src="images/siedler/armee/'.$ds['r_v'].'">';
else $r_v = '';
if($ds['b_v'])
$b_v = '<img src="images/siedler/armee/'.$ds['b_v'].'">';
else $b_v = '';
if($ds['m_v'])
$m_v = '<img src="images/siedler/armee/'.$ds['m_v'].'">';
else $m_v = '';
if($ds['c_v'])
$c_v = '<img src="images/siedler/armee/'.$ds['c_v'].'">';
else $c_v = '';
if($ds['lb_v'])
$lb_v = '<img src="images/siedler/armee/'.$ds['lb_v'].'">';
else $lb_v = '';
if($ds['s_v'])
$s_v = '<img src="images/siedler/armee/'.$ds['s_v'].'">';
else $s_v = '';
if($ds['a_v'])
$a_v = '<img src="images/siedler/armee/'.$ds['a_v'].'">';
else $a_v = '';
if($ds['e_v'])
$e_v = '<img src="images/siedler/armee/'.$ds['e_v'].'">';
else $e_v = '';
if($ds['k_v'])
$k_v = '<img src="images/siedler/armee/'.$ds['k_v'].'">';
else $k_v = '';
$rubrikname=getrubname($ds['rubricID']);
if(!file_exists($rubricpic)) $rubricpic.='<img src="./images/articles-rubrics/'.getrubpic($ds['rubricID']).'" alt="" />';
else $rubricpic = '';
eval ("\$articles_content = \"".gettemplate("articles_content")."\";");
echo $articles_content;
unset($ratingpic);
$n++;
}
eval ("\$articles_foot = \"".gettemplate("articles_foot")."\";");
echo $articles_foot;
unset($ds);
}
else echo $_language->module['no_entries'];
}else{
$_language->read_module('articles');
/*
echo '<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr><td align="right">';
include("login.php");
echo '</td>';
echo '<td align="left">';
echo '
<div id="mygallery" class="stepcarousel">
<div class="belt">
<div class="panel"><div class="menu_slide">
<div class="menu_slide_kat">Neuste Taktikkarten</div>';
include("sc_articles.php");
echo '
</div>
</div>
<div class="panel"><div class="menu_slide">
<div class="menu_slide_kat">Zufalls Bild</div>';
include("sc_randompic.php");
echo '
</div>
</div>
<div class="panel"><div class="menu_slide">
<div class="menu_slide_kat">Umfrage</div>';
include("poll.php");
echo '
</div>
</div>
<div class="panel">
<div class="menu_slide">
<div class="menu_slide_kat">Online Liste</div>';
include("sc_useronline.php");
echo '
</div>
</div>
<div class="panel">
<div class="menu_slide">
<div class="menu_slide_kat">Letzten Registrationen</div>';
include("sc_lastregistered.php");
echo '
</div>
</div>
</div>
</div>';
echo '</td>';
echo '</tr>';
echo '</table>';
*/
eval ("\$title_articles = \"".gettemplate("title_articles")."\";");
echo $title_articles;
// Create a MySQL table
mysql_query("CREATE TABLE IF NOT EXISTS ".PREFIX."articles_rubrics (
`rubricID` int(11) NOT NULL AUTO_INCREMENT,
`rubric` varchar(255) NOT NULL DEFAULT '',
`pic` varchar(255) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL,
PRIMARY KEY (`rubricID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ");
mysql_query("ALTER TABLE `".PREFIX."articles` ADD `rubricID` INT( 11 ) NOT NULL DEFAULT '0' AFTER `title`");
top5();
$rubcats=safe_query("SELECT * FROM ".PREFIX."articles_rubrics ORDER BY farbe ASC, rubric ASC");
$anzcats=mysql_num_rows($rubcats);
if($anzcats) {
eval ("\$artikel_category_head = \"".gettemplate("artikel_category_head")."\";");
echo $artikel_category_head;
$i=1;
while($ds=mysql_fetch_array($rubcats)) {
$anzarticle=mysql_num_rows(safe_query("SELECT articlesID FROM ".PREFIX."articles WHERE rubricID='".$ds['rubricID']."'"));
if($i%2) {
$bg1=BG_1;
$bg2=BG_2;
}
else {
$bg1=BG_3;
$bg2=BG_4;
}
$spieler = $ds['spieler'];
$tage = $ds['tage'];
$sg = $ds['sg'];
$ep_k = $ds['ep_k'];
$ep = $ds['ep'];
$rubricID = $ds['rubricID'];
$rubname='<a href="index.php?site=articles&action=rubric&rubricID='.$ds['rubricID'].'"><b>'.$ds['rubric'].'</b></a>';
$description=htmloutput($ds['description']);
$rubpic='<a href="index.php?site=articles&action=rubric&rubricID='.$ds['rubricID'].'""><img src="./images/articles-rubrics/'.$ds['pic'].'" alt="'.$ds['rubric'].'" title="'.$ds['rubric'].'" /></a>';
eval ("\$artikel_category = \"".gettemplate("artikel_category")."\";");
echo $artikel_category;
$i++;
}
eval ("\$artikel_foot = \"".gettemplate("artikel_foot")."\";");
echo $artikel_foot;
}
else echo $_language->module['no_entries'];
}
?> | 
1 2 › »
21.05.2013 - 13:18 - 7 Replies
28.03.2013 -