|
|
| [center]Willkommen auf phd-clan.de[/center] |
|
 |
'".$time_now."'
OR ".$db_tab['content'].".content_expire='0')";
if ($contentid!="" && $contentid!="new") {
$sqlcommand.=" AND
".$db_tab['content'].".content_id='".$contentid."'";
}
if ($catid!="") {
$sqlcommand.=" AND
".$db_tab['content'].".content_cat='".$catid."'";
}
$sqlcommand=" FROM ".$db_tab['content']."
LEFT JOIN ".$db_tab['contentcat']."
ON ".$db_tab['contentcat'].".contentcat_id=".$db_tab['content'].".content_cat".$sqlcommand."
AND (".sqlrights($db_tab['contentcat'].".contentcat_rights").")";
$sqlcommand2="SELECT ".$db_tab['content'].".* ".$sqlcommand;
$sqlcommand.=" ORDER by ".$db_tab['content'].".content_time DESC LIMIT
".$entries.",";
if ($contentid!="") {$sqlcommand.=1;}
else {
$sqlcommand.=$config[content_epp2];
}
$sqlcommand="SELECT ".$db_tab['content'].".* ".$sqlcommand;
$getcontentinfo=$DB->query($sqlcommand);
unset($sqlcommand);
while ($contentinfo=$DB->fetch_array($getcontentinfo)) {
$contentinfo_cache[]=$contentinfo;
if ($contentinfo[content_autorid]!=0) {
if ($sqlcommand=="") {
$sqlcommand="SELECT user_nick, user_id FROM
".$db_tab['user']." WHERE user_id='".$contentinfo['content_autorid']."'";
}
else {
$sqlcommand.=" OR user_id='".$contentinfo['content_autorid']."'";
}
}
$title=$contentinfo['content_title'];
}
if ($sqlcommand!="") {
$getuserinfo=$DB->query($sqlcommand);
while($userinfo=$DB->fetch_array($getuserinfo)){
$userinfo_cache[$userinfo[user_id]]=$userinfo;
}
}
if (is_array($contentinfo_cache)) {
$contentcat=contentcats(); $contentcat_cache=$contentcat['0'];
foreach($contentinfo_cache as $contentinfo) {
$contentcatinfo=$contentcat_cache[$contentinfo[content_cat]];
if (isset($_GET['contentid'])) $config['site_title'] = " - ".$contentcatinfo['contentcat_name']." | News: ".htmlentities($title);
if ($contentinfo['content_autorid']==0) {
$autor_info=$newsinfo['content_autor'];
}
else {
$userinfo=$userinfo_cache[$contentinfo[content_autorid]];
if ($userinfo[0]!="") {
eval ("\$autor_info=\"".getTemplate("member_showprofil_textlink")."\";");
}
else {
$autor_info=$contentinfo['content_autor'];
}
}
$news_time=formattime($contentinfo['content_time']);
$catimage_dimension=@getimagesize("images/catimages/".$contentcatinfo['contentcat_symbol']);
eval ("\$news_image= \"".getTemplate("content/cat_image_right")."\";");
if ($contentid==""){
$news_text=explode("",$contentinfo['content_text']);
$news_text=$news_text['0'];
}
else {
$news_text=str_replace("","",$contentinfo[content_text]);
}
$news_text=$PARSE->parse($news_text,$contentinfo['content_html'],$contentinfo['content_ubb'],$contentinfo['content_smilies'],1);
if ($contentid=="" && preg_match("",$contentinfo['content_text'])) {
eval("\$news_text.= \"".getTemplate("content/news_morelink")."\";");
}
$news_text=str_replace("","",$news_text);
if ($contentinfo['content_comment_status']==1) {
$commentcount=$DB->fetch_array($DB->query("SELECT COUNT(*) FROM
".$db_tab['comment']." WHERE
comment_subid='".$contentinfo['content_id']."' AND
comment_cat='cont'"));
if ($commentcount[0]>1) {$news_comments=$commentcount[0].'
'.$lang['comments'];
}
elseif ($commentcount[0]==1) {
$news_comments=" 1 ".$lang['comment'];
}
else {
$news_comments=$lang['no_comments'];
}
}
if ($contentinfo['content_altdat']!='') {
$source=explode("\n",$contentinfo['content_altdat']);
foreach($source as $s) {
if ($news_source!="") {
$news_source.=", ";
}
$news_source.=$PARSE->parse($s,0,1,0,0);
}
if ($news_source!='') {
eval ("\$news_source=\"".getTemplate("content/news_source")."\";");
}
}
$cont_title=stripslashes($contentinfo['content_title']);
$suggest_url=urlencode("path=content/news.php&contentid=".$contentinfo['content_id']);
eval ("\$site_body.= \"".getTemplate("content/news")."\";");
unset($news_source);
unset($news_comments);
unset($news_text);
unset($news_text_cut);
}
}
if ($contentid=="") {
$counter=$DB->num_rows($DB->query($sqlcommand2));
if ($counter>$config['content_epp2']) {
$page_link=sidelinkfull($counter,$config['content_epp2'],$entries,"include.php?path=content/news.php&catid=".$catid,"sitebodysmall");
}
}
eval ("\$site_body.= \"".getTemplate("content/news_navigation")."\";");
?> |
|
Register
Join SteamGrp
News
Huhu .... na ge..
Bobby
Schlagges
Slayer
