Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
Geschlossen |
<?php // Copyright by: Manuel Staechele // Support: www.ilch.de // Modded by Mairu für News Extended defined ('main') or die ('no direct access'); $title = $allgAr['title'] . ' :: News'; $hmenu = 'News'; $design = new design ($title , $hmenu); $design->addheader('<link rel="alternate" type="application/atom+xml" title="News (Atom)" href="index.php?news-atom" /> <link rel="alternate" type="application/rss+xml" title="News (RSS)" href="index.php?news-rss" />'); function news_find_kat ($kat) { $katpfad = 'include/images/news/'; $katjpg = $katpfad . $kat . '.jpg'; $katgif = $katpfad . $kat . '.gif'; $katpng = $katpfad . $kat . '.png'; if (file_exists($katjpg)) { $pfadzumBild = $katjpg; } elseif (file_exists ($katgif)) { $pfadzumBild = $katgif; } elseif (file_exists ($katpng)) { $pfadzumBild = $katpng; } if (!empty($pfadzumBild)) { $kategorie = '<img style="" src="' . $pfadzumBild . '" alt="' . $kat . '">'; } else { $kategorie = '<b>' . $kat . '</b><br /><br />'; } return ($kategorie); } // Schaut ob ein Name so oder ähnlich in der Datenbank vorhanden ist // gibt true zurück falls der Name noch nicht verwendet ist function checkName($name) { if (db_count_query("SELECT COUNT(name) FROM prefix_user WHERE name LIKE '$name'")) { return false; } else { return true; } } function checkKomName($name) { $resp = new xajaxResponse(); if (checkName($name) OR loggedin()) { $resp->script('document.forms["komform"].submit();'); } else { $resp->assign('komname', 'value' , ''); $resp->alert('Dieser Name ist bereits an einen User vergeben, benutze bitte einen anderen.'); $resp->script("document.getElementById('komname').focus();"); } return $resp; } // xajax für namencheck $xajax = new xajax(); $xajax->configureMany(array('decodeUTF8Input' => true ,'characterEncoding' => 'ISO-8859-1', 'requestURI' => 'admin.php?news-ajax')); $xajax->register(XAJAX_FUNCTION, 'checkKomName'); $xajax->processRequest(); if ($menu->get(1) == 'ajax') { exit(); } if (!is_numeric($menu->get(1))) { if ($menu->get(1) == 'rss' || $menu->get(1) == 'atom') { // ob_clean(); $feed_type = $menu->get(1); $abf = "SELECT MAX(news_time) AS last_update FROM prefix_news"; $erg = db_query($abf); $row = db_fetch_assoc($erg); $last_update = str_replace(' ', 'T', $row['last_update']) . 'Z'; $tn_id = intval(@db_result($news_opts = db_query("SELECT v1 FROM prefix_allg WHERE k = 'news' LIMIT 1"), 0)); $abf = "SELECT a.news_title as title, a.news_id as id,"; $abf .= ($feed_type == 'atom') ? 'a.news_time as datum,' : "DATE_FORMAT(a.news_time,'%a, %e %b %y %H:%i:%s') as datum,"; $abf .= "a.news_kat as kate, a.news_text as text, b.name as username, a.html FROM prefix_news as a LEFT JOIN prefix_user as b ON a.user_id = b.id WHERE (a.news_recht | 1) = a.news_recht AND a.`show` > 0 AND a.`show` <= UNIX_TIMESTAMP() AND a.news_id != $tn_id AND a.`archiv` != 1 AND (a.endtime IS NULL OR a.endtime > UNIX_TIMESTAMP()) ORDER BY news_time DESC LIMIT 15"; $erg = db_query($abf); $tpl = new tpl('news_' . $menu->get(1) . '.htm'); header('Content-type: application/' . $menu->get(1) . '+xml'); $tpl->set_ar_out(array('FEEDTITLE' => $allgAr['title'], 'UPDATED' => $last_update, 'SITEURL' => 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF'])), 0); while ($row = db_fetch_assoc($erg)) { if ($feed_type == 'atom') { $Z = (date('Z') > 0 ? '+' : '') . date('H:i:s', date('Z') + 23 * 3600); $row['datum'] = str_replace(' ', 'T', $row['datum']) . $Z; } $a = explode('[PREVIEWENDE]', $row['text']); $tpl->set_ar_out(array('TITLE' => $row['title'], 'TXT' => $row['html'] ? $a[0] : bbcode($a[0]), 'LINK' => 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . '/index.php?news-' . $row['id'], 'AUTHOR' => $row['username'], 'DATE' => $row['datum'] ), 1); } $tpl->out(2); exit; } else { $design->header(); $limit = $allgAr['Nlimit']; $page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1); // Topnews ausgeben $tn_id = intval(@db_result($news_opts = db_query("SELECT v1, v2 FROM prefix_allg WHERE k = 'news' LIMIT 1"), 0, 0)); $tn_koms = @db_result($news_opts, 0, 1); $tn_sql = db_query("SELECT news_title, news_text, news_kat, news_recht, news_groups, html FROM prefix_news WHERE news_id = $tn_id AND `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND (endtime IS NULL OR endtime > UNIX_TIMESTAMP())"); if (db_num_rows($tn_sql) > 0) { $tn_r = db_fetch_object($tn_sql); $dontShow = false; if ((pow(2, abs($_SESSION['authright'])) | $tn_r->news_recht) != $tn_r->news_recht) { $dontShow = true; } if ($dontShow) { foreach($_SESSION['authgrp'] as $id => $bool) { if ($bool and (pow(2, abs($id)) | $tn_r->news_groups) == $tn_r->news_groups) { $dontShow = false; break; } } } if (!$dontShow) { $tn_tpl = new tpl ('news/top'); $tn_tpl->set('title', $tn_r->news_title); $tn_tpl->set('koms', $tn_koms == '1' ? '<br /><a href="index.php?news-' . $tn_id . '">' . db_count_query("SELECT COUNT(id) FROM prefix_koms WHERE uid = $tn_id AND cat = 'NEWS'") . ' ' . $lang['comments'] . ' </a>' : ''); if (strpos ($tn_r->news_text , '[PREVIEWENDE]') !== false) { $a = explode('[PREVIEWENDE]' , $tn_r->news_text); $tn_r->news_text = $a[0]; $tn_tpl->set('readwholenews', '<a href="index.php?news-' . $tn_id . '" alt="mehr lesen" title="mehr lesen"><img src="include/images/icons/news/more.gif" alt="mehr lesen" border="0"></a>'); } else { $tn_tpl->set('readwholenews', ''); } $tn_tpl->set('kate', news_find_kat($tn_r->news_kat)); $tn_tpl->set_out('txt', $tn_r->html ? $tn_r->news_text : bbcode($tn_r->news_text), 0); unset($tn_tpl); } } //Kategorie einschränken if ($menu->get(1) != '' and ($menu->getA(1) != 'p' or $menu->getE(1) == 0)) { $kats = $katssql = array(); #collect given kats $i = 1; while($kat = escape($menu->get($i), 'string')){ $kats[] = $kat; $katssql[] = '"' . $kat . '"'; $i++; } $news_kat = 'news_kat IN ('.implode(',', $katssql).') AND'; $katmpl = '-'.implode('-', $kats); $page = $menu->getE('p'); if ($page < 1) { $page = 1; } $katmpl = str_replace('-p'.$page, '', $katmpl); } else { $news_kat = $katmpl = ''; $page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1); } $anfang = ($page - 1) * $limit; //Gruppenrechte $groups = getGroupRights(); $MPL = db_make_sites ($page , "WHERE (((" . pow(2, abs($_SESSION['authright'])) . " | news_recht) = news_recht) OR (news_groups != 0 AND ((news_groups ^ $groups) != (news_groups | $groups)))) AND $news_kat `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND news_id != $tn_id AND archiv != 1 AND (endtime IS NULL OR endtime > UNIX_TIMESTAMP())" , $limit , '?news'.$katmpl , 'news'); // Normale News $tpl = new tpl ('news/news.htm'); $abf = "SELECT a.news_title as title, a.news_id as id, DATE_FORMAT(a.news_time,'%d. %m. %Y - %H:%i Uhr') as datum, DATE_FORMAT(a.news_time,'%W') as dayofweek, a.news_kat as kate, a.news_text as text, b.name as username, c.name as editorname, a.html, a.edit_time, a.klicks, b.id as uid FROM prefix_news as a LEFT JOIN prefix_user as b ON a.user_id = b.id LEFT JOIN prefix_user as c ON a.editor_id = c.id WHERE (((" . pow(2, abs($_SESSION['authright'])) . " | a.news_recht) = a.news_recht) OR (a.news_groups != 0 AND ((a.news_groups ^ $groups) != (a.news_groups | $groups)))) AND $news_kat a.`show` > 0 AND a.`show` <= UNIX_TIMESTAMP() AND news_id != $tn_id AND a.`archiv` != 1 AND (a.endtime IS NULL OR a.endtime > UNIX_TIMESTAMP()) ORDER BY a.news_time DESC LIMIT " . $anfang . "," . $limit; // echo '<pre>'.$abf.'</pre>'; $erg = db_query($abf); if (db_num_rows($erg) == 0 and !empty($news_kat)) { echo 'Keine News in dieser Kategorie gefunden.<br /> <a href="index.php?news">Newsübersichtsseite aufrufen</a>'; $design->footer(1); } while ($row = db_fetch_assoc($erg)) { $k0m = db_query("SELECT COUNT(ID) FROM `prefix_koms` WHERE uid = " . $row['id'] . " AND cat = 'NEWS'"); $row['kom'] = db_result($k0m, 0); $row['kate'] = news_find_kat($row['kate']); $row['datum'] = $lang[$row['dayofweek']] . ' ' . $row['datum']; if (strpos ($row['text'] , '[PREVIEWENDE]') !== false) { $a = explode('[PREVIEWENDE]' , $row['text']); $row['text'] = $a[0]; $row['readwholenews'] = '<a href="index.php?news-' . $row['id'] . '" alt="mehr lesen" title="mehr lesen"><img src="include/images/icons/news/more.gif" alt="mehr lesen" border="0"></a>'; } else { $row['readwholenews'] = ''; } $row['klicks'] = '<img src="include/images/icons/news/counter.gif" alt="' . $row['klicks'] . ' mal gelesen" title="' . $row['klicks'] . ' mal gelesen" border="0">'; if (!$row['html']) { $row['text'] = bbcode($row['text']); } { $row['edit'] .= '</i>'; } $tpl->set_ar_out($row, 0); } $tpl->set_out('SITELINK', $MPL, 1); unset($tpl); } } else { $design->header(); $xajax->printJavascript(); $nid = escape($menu->get(1), 'integer'); $erg = db_query("SELECT * FROM `prefix_news` WHERE `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND news_id = '" . $nid . "'"); if (db_num_rows($erg) == 0) { $dontShow = true; } else { $dontShow = false; $row = db_fetch_object($erg); if ((pow(2, abs($_SESSION['authright'])) | $row->news_recht) != $row->news_recht) { $dontShow = true; } if ($dontShow) { foreach($_SESSION['authgrp'] as $id => $bool) { if ($bool and (pow(2, abs($id)) | $row->news_groups) == $row->news_groups) { $dontShow = false; break; } } } } if ($dontShow) { echo 'News existiert nicht oder Sie haben keine Rechte sie zu sehen. <a href="javascript:history.back();">zurück</a>'; $design->footer(1); } $komsOK = true; if ($allgAr['Ngkoms'] == 0) { if (loggedin()) { $komsOK = true; } else { $komsOK = false; } } if ($allgAr['Nukoms'] == 0) { $komsOK = false; } $kom_info = ''; // kommentar add if ((loggedin() OR chk_antispam ('newskom')) AND $komsOK AND !empty($_POST['name']) AND !empty($_POST['txt'])) { $_POST['txt'] = escape($_POST['txt'], 'string'); $_POST['name'] = escape($_POST['name'], 'string'); if (checkName($_POST['name']) or loggedin()) { if (loggedin()) { $_POST['name'] = $_SESSION['authname']; } db_query("INSERT INTO `prefix_koms` (`uid`,`cat`,`name`,`text`) VALUES (" . $nid . ",'NEWS','" . $_POST['name'] . "','" . $_POST['txt'] . "')"); } else { $kom_info = '<span style="color:red;">Dieser Name ist bereits an einen User vergeben, benutze bitte einen anderen.</span><br />'; } } // kommentar add // kommentar loeschen if ($menu->getA(2) == 'd' AND is_numeric($menu->getE(2)) AND has_right(- 7, 'news')) { $kommentar_id = escape($menu->getE(2), 'integer'); db_query("DELETE FROM prefix_koms WHERE uid = " . $nid . " AND cat = 'NEWS' AND id = " . $kommentar_id); } // kommentar loeschen $kategorie = news_find_kat($row->news_kat); $textToShow = $row->html ? $row->news_text : bbcode($row->news_text); $textToShow = str_replace('[PREVIEWENDE]', '', $textToShow); if (!empty($such)) { $textToShow = markword($textToShow, $such); } // klicks zaehlen db_query("UPDATE prefix_news SET klicks = klicks + 1 WHERE news_id = " . $nid); $tpl = new tpl ('news/news.htm'); $ar = array ( 'TEXT' => $textToShow, 'KATE' => $kategorie, 'NID' => $nid, 'uname' => $_SESSION['authname'], 'ANTISPAM' => (loggedin()?'':get_antispam ('newskom', 0)), 'NAME' => $row->news_title, 'info' => $kom_info ); $tpl->set_ar_out($ar, 2); if ($komsOK) { $tpl->set_ar_out (array ('NAME' => $row->news_title , 'NID' => $nid, 'style' => loggedin() ? 'style="display:none;"' : ''), 3); } $erg1 = db_query("SELECT text, name, id FROM `prefix_koms` WHERE uid = " . $nid . " AND cat = 'NEWS' ORDER BY id DESC"); $ergAnz1 = db_num_rows($erg1); if ($ergAnz1 == 0) { echo '<b>' . $lang['nocomments'] . '</b>'; } else { $zahl = $ergAnz1; while ($row1 = db_fetch_assoc($erg1)) { $row1['text'] = bbcode(trim($row1['text'])); if (has_right(- 7, 'news')) { $row1['text'] .= '<a href="javascript:delkom(' . $nid . ',' . $row1['id'] . ')"><img src="include/images/icons/del.gif" alt="löschen" border="0" title="löschen" /></a>'; } $tpl->set_ar_out(array('NAME' => $row1['name'], 'TEXT' => $row1['text'], 'ZAHL' => $zahl) , 4); $zahl--; } } $tpl->out(5); } $design->footer(); ?>
<img src="include/designs/shooterbase/images/news_top.jpg" width="567" height="27"> <table background="include/designs/shooterbase/images/news_bg.jpg" width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="newsbg"> <tr> <td width="10"></td> <td> <table width="100%" border="0" align="center" cellpadding="5" cellspacing="0"> <tr> <td class="smalfont">{datum} - <strong><a href="index.php?news-{id}">{title}</a></strong></td> </tr> <table width="98%" border="0" cellspacing="0" cellpadding="2"> <tr> <td><hr style="height: 0px; border: dotted #000000 0px; border-top-width: 1px; " /></td> </tr> </table> <table width="100%" border="0" align="center" cellpadding="1" cellspacing="0" class="cbg1"> <tr> <td align="center">{kate}</td> </tr> </table> <table width="98%" border="0" cellspacing="0" cellpadding="2"> <tr> <td>{text}</td> </tr> <tr> <td><hr style="height: 0px; border: dotted #000000 0px; border-top-width: 1px; " /></td> </tr> </table> <table width="98%" border="0" cellspacing="0" cellpadding="1"> <tr> <td align="left" width="60%" class="smalfont">Geschrieben von <strong>{username}</strong>{edit}</td> <td align="right" width="40%"> <div align="right">{readwholenews} </div></td> </td> <td width="10"></td> </tr> </table> </td></tr></table> <img src="include/designs/shooterbase/images/news_bt.jpg" width="567" height="25"> <br /> <br /> {EXPLODE} <br /> <br /><center>{SITELINK}</center> {EXPLODE} <script language="JavaScript" type="text/javascript"> function delkom (NID, ID) { var Check = confirm("Kommentar wirklich löschen?") if (Check == true) window.open("index.php?news-"+NID+"-d"+ID,"_self"); }</script> <!-- News Kommentare und Mehr lesen --> <table width="100%" cellpadding="5" cellspacing="1" border="0"> <tr class="Chead"> <th height="25"><b>{NAME}</b></th> </tr> <tr> <td height="25">{_lang_message}</td> </tr> <tr> <td align="center">{KATE}</td> </tr> <tr> <td > <div style="float:left; padding-left:10px; ">{TEXT}</div><br style="clear:both; " /> <p></p> <a href="javascript:history.back(1)"><b>«</b>{_lang_back}</a> </td> </tr> <tr> <td height="25">{_lang_commentsfor} {NAME}</td> </tr> <tr> <td> {EXPLODE} <form action="index.php?news-{NID}" method="POST"> <fieldset> <legend>{_lang_writecomment}</legend> <input type="text" name="name" value="{uname}" /> {ANTISPAM} <input type="submit" value="{_lang_enter}"><br /> <textarea style="width: 98%" cols="50" rows="2" name="txt"></textarea><br /> </fieldset> </form> <br /> {EXPLODE} <span class="Cmite"># <b>{ZAHL}</b> von {NAME}</span> <br />{TEXT}<br /><br /> {EXPLODE} <br /> <a href="javascript:history.back(1)"><b>«</b> {_lang_back}</a> </td> </tr> </table>
<?php // Copyright by: Manuel Staechele // Support: www.ilch.de // Modded by Mairu für News Extended defined ('main') or die ('no direct access'); $title = $allgAr['title'] . ' :: News'; $hmenu = 'News'; $design = new design ($title , $hmenu); $design->addheader('<link rel="alternate" type="application/atom+xml" title="News (Atom)" href="index.php?news-atom" /> <link rel="alternate" type="application/rss+xml" title="News (RSS)" href="index.php?news-rss" />'); function news_find_kat ($kat) { $katpfad = 'include/images/news/'; $katjpg = $katpfad . $kat . '.jpg'; $katgif = $katpfad . $kat . '.gif'; $katpng = $katpfad . $kat . '.png'; if (file_exists($katjpg)) { $pfadzumBild = $katjpg; } elseif (file_exists ($katgif)) { $pfadzumBild = $katgif; } elseif (file_exists ($katpng)) { $pfadzumBild = $katpng; } if (!empty($pfadzumBild)) { $kategorie = '<img style="" src="' . $pfadzumBild . '" alt="' . $kat . '">'; } else { $kategorie = '<b>' . $kat . '</b><br /><br />'; } return ($kategorie); } // Schaut ob ein Name so oder ähnlich in der Datenbank vorhanden ist // gibt true zurück falls der Name noch nicht verwendet ist function checkName($name) { if (db_count_query("SELECT COUNT(name) FROM prefix_user WHERE name LIKE '$name'")) { return false; } else { return true; } } function checkKomName($name) { $resp = new xajaxResponse(); if (checkName($name) OR loggedin()) { $resp->script('document.forms["komform"].submit();'); } else { $resp->assign('komname', 'value' , ''); $resp->alert('Dieser Name ist bereits an einen User vergeben, benutze bitte einen anderen.'); $resp->script("document.getElementById('komname').focus();"); } return $resp; } // xajax für namencheck $xajax = new xajax(); $xajax->configureMany(array('decodeUTF8Input' => true ,'characterEncoding' => 'ISO-8859-1', 'requestURI' => 'admin.php?news-ajax')); $xajax->register(XAJAX_FUNCTION, 'checkKomName'); $xajax->processRequest(); if ($menu->get(1) == 'ajax') { exit(); } if (!is_numeric($menu->get(1))) { if ($menu->get(1) == 'rss' || $menu->get(1) == 'atom') { // ob_clean(); $feed_type = $menu->get(1); $abf = "SELECT MAX(news_time) AS last_update FROM prefix_news"; $erg = db_query($abf); $row = db_fetch_assoc($erg); $last_update = str_replace(' ', 'T', $row['last_update']) . 'Z'; $tn_id = intval(@db_result($news_opts = db_query("SELECT v1 FROM prefix_allg WHERE k = 'news' LIMIT 1"), 0)); $abf = "SELECT a.news_title as title, a.news_id as id,"; $abf .= ($feed_type == 'atom') ? 'a.news_time as datum,' : "DATE_FORMAT(a.news_time,'%a, %e %b %y %H:%i:%s') as datum,"; $abf .= "a.news_kat as kate, a.news_text as text, b.name as username, a.html FROM prefix_news as a LEFT JOIN prefix_user as b ON a.user_id = b.id WHERE (a.news_recht | 1) = a.news_recht AND a.`show` > 0 AND a.`show` <= UNIX_TIMESTAMP() AND a.news_id != $tn_id AND a.`archiv` != 1 AND (a.endtime IS NULL OR a.endtime > UNIX_TIMESTAMP()) ORDER BY news_time DESC LIMIT 15"; $erg = db_query($abf); $tpl = new tpl('news_' . $menu->get(1) . '.htm'); header('Content-type: application/' . $menu->get(1) . '+xml'); $tpl->set_ar_out(array('FEEDTITLE' => $allgAr['title'], 'UPDATED' => $last_update, 'SITEURL' => 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF'])), 0); while ($row = db_fetch_assoc($erg)) { if ($feed_type == 'atom') { $Z = (date('Z') > 0 ? '+' : '') . date('H:i:s', date('Z') + 23 * 3600); $row['datum'] = str_replace(' ', 'T', $row['datum']) . $Z; } $a = explode('[PREVIEWENDE]', $row['text']); $tpl->set_ar_out(array('TITLE' => $row['title'], 'TXT' => $row['html'] ? $a[0] : bbcode($a[0]), 'LINK' => 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . '/index.php?news-' . $row['id'], 'AUTHOR' => $row['username'], 'DATE' => $row['datum'] ), 1); } $tpl->out(2); exit; } else { $design->header(); $limit = $allgAr['Nlimit']; $page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1); // Topnews ausgeben $tn_id = intval(@db_result($news_opts = db_query("SELECT v1, v2 FROM prefix_allg WHERE k = 'news' LIMIT 1"), 0, 0)); $tn_koms = @db_result($news_opts, 0, 1); $tn_sql = db_query("SELECT news_title, news_text, news_kat, news_recht, news_groups, html FROM prefix_news WHERE news_id = $tn_id AND `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND (endtime IS NULL OR endtime > UNIX_TIMESTAMP())"); if (db_num_rows($tn_sql) > 0) { $tn_r = db_fetch_object($tn_sql); $dontShow = false; if ((pow(2, abs($_SESSION['authright'])) | $tn_r->news_recht) != $tn_r->news_recht) { $dontShow = true; } if ($dontShow) { foreach($_SESSION['authgrp'] as $id => $bool) { if ($bool and (pow(2, abs($id)) | $tn_r->news_groups) == $tn_r->news_groups) { $dontShow = false; break; } } } if (!$dontShow) { $tn_tpl = new tpl ('news/top'); $tn_tpl->set('title', $tn_r->news_title); $tn_tpl->set('koms', $tn_koms == '1' ? '<br /><a href="index.php?news-' . $tn_id . '">' . db_count_query("SELECT COUNT(id) FROM prefix_koms WHERE uid = $tn_id AND cat = 'NEWS'") . ' ' . $lang['comments'] . ' </a>' : ''); if (strpos ($tn_r->news_text , '[PREVIEWENDE]') !== false) { $a = explode('[PREVIEWENDE]' , $tn_r->news_text); $tn_r->news_text = $a[0]; $tn_tpl->set('readwholenews', '<a href="index.php?news-' . $tn_id . '" alt="mehr lesen" title="mehr lesen"><img src="include/images/icons/news/more.gif" alt="mehr lesen" border="0"></a>'); } else { $tn_tpl->set('readwholenews', ''); } $tn_tpl->set('kate', news_find_kat($tn_r->news_kat)); $tn_tpl->set_out('txt', $tn_r->html ? $tn_r->news_text : bbcode($tn_r->news_text), 0); unset($tn_tpl); } } //Kategorie einschränken if ($menu->get(1) != '' and ($menu->getA(1) != 'p' or $menu->getE(1) == 0)) { $kats = $katssql = array(); #collect given kats $i = 1; while($kat = escape($menu->get($i), 'string')){ $kats[] = $kat; $katssql[] = '"' . $kat . '"'; $i++; } $news_kat = 'news_kat IN ('.implode(',', $katssql).') AND'; $katmpl = '-'.implode('-', $kats); $page = $menu->getE('p'); if ($page < 1) { $page = 1; } $katmpl = str_replace('-p'.$page, '', $katmpl); } else { $news_kat = $katmpl = ''; $page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1); } $anfang = ($page - 1) * $limit; //Gruppenrechte $groups = getGroupRights(); $MPL = db_make_sites ($page , "WHERE (((" . pow(2, abs($_SESSION['authright'])) . " | news_recht) = news_recht) OR (news_groups != 0 AND ((news_groups ^ $groups) != (news_groups | $groups)))) AND $news_kat `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND news_id != $tn_id AND archiv != 1 AND (endtime IS NULL OR endtime > UNIX_TIMESTAMP())" , $limit , '?news'.$katmpl , 'news'); // Normale News $tpl = new tpl ('news/news.htm'); $abf = "SELECT a.news_title as title, a.news_id as id, DATE_FORMAT(a.news_time,'%d. %m. %Y - %H:%i Uhr') as datum, DATE_FORMAT(a.news_time,'%W') as dayofweek, a.news_kat as kate, a.news_text as text, b.name as username, c.name as editorname, a.html, a.edit_time, a.klicks, b.id as uid FROM prefix_news as a LEFT JOIN prefix_user as b ON a.user_id = b.id LEFT JOIN prefix_user as c ON a.editor_id = c.id WHERE (((" . pow(2, abs($_SESSION['authright'])) . " | a.news_recht) = a.news_recht) OR (a.news_groups != 0 AND ((a.news_groups ^ $groups) != (a.news_groups | $groups)))) AND $news_kat a.`show` > 0 AND a.`show` <= UNIX_TIMESTAMP() AND news_id != $tn_id AND a.`archiv` != 1 AND (a.endtime IS NULL OR a.endtime > UNIX_TIMESTAMP()) ORDER BY a.news_time DESC LIMIT " . $anfang . "," . $limit; // echo '<pre>'.$abf.'</pre>'; $erg = db_query($abf); if (db_num_rows($erg) == 0 and !empty($news_kat)) { echo 'Keine News in dieser Kategorie gefunden.<br /> <a href="index.php?news">Newsübersichtsseite aufrufen</a>'; $design->footer(1); } while ($row = db_fetch_assoc($erg)) { $k0m = db_query("SELECT COUNT(ID) FROM `prefix_koms` WHERE uid = " . $row['id'] . " AND cat = 'NEWS'"); $row['kom'] = db_result($k0m, 0); $row['kate'] = news_find_kat($row['kate']); $row['datum'] = $lang[$row['dayofweek']] . ' ' . $row['datum']; if (strpos ($row['text'] , '[PREVIEWENDE]') !== false) { $a = explode('[PREVIEWENDE]' , $row['text']); $row['text'] = $a[0]; $row['readwholenews'] = '<a href="index.php?news-' . $row['id'] . '" alt="mehr lesen" title="mehr lesen"><img src="include/images/icons/news/more.gif" alt="mehr lesen" border="0"></a>'; } else { $row['readwholenews'] = ''; } $row['klicks'] = '<img src="include/images/icons/news/counter.gif" alt="' . $row['klicks'] . ' mal gelesen" title="' . $row['klicks'] . ' mal gelesen" border="0">'; if (!$row['html']) { $row['text'] = bbcode($row['text']); } { $row['edit'] .= '</i>'; } $tpl->set_ar_out($row, 0); } $tpl->set_out('SITELINK', $MPL, 1); unset($tpl); } } else { $design->header(); $xajax->printJavascript(); $nid = escape($menu->get(1), 'integer'); $erg = db_query("SELECT * FROM `prefix_news` WHERE `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND news_id = '" . $nid . "'"); if (db_num_rows($erg) == 0) { $dontShow = true; } else { $dontShow = false; $row = db_fetch_object($erg); if ((pow(2, abs($_SESSION['authright'])) | $row->news_recht) != $row->news_recht) { $dontShow = true; } if ($dontShow) { foreach($_SESSION['authgrp'] as $id => $bool) { if ($bool and (pow(2, abs($id)) | $row->news_groups) == $row->news_groups) { $dontShow = false; break; } } } } if ($dontShow) { echo 'News existiert nicht oder Sie haben keine Rechte sie zu sehen. <a href="javascript:history.back();">zurück</a>'; $design->footer(1); } $komsOK = true; if ($allgAr['Ngkoms'] == 0) { if (loggedin()) { $komsOK = true; } else { $komsOK = false; } } if ($allgAr['Nukoms'] == 0) { $komsOK = false; } $kom_info = ''; // kommentar add if ((loggedin() OR chk_antispam ('newskom')) AND $komsOK AND !empty($_POST['name']) AND !empty($_POST['txt'])) { $_POST['txt'] = escape($_POST['txt'], 'string'); $_POST['name'] = escape($_POST['name'], 'string'); if (checkName($_POST['name']) or loggedin()) { if (loggedin()) { $_POST['name'] = $_SESSION['authname']; } db_query("INSERT INTO `prefix_koms` (`uid`,`cat`,`name`,`text`) VALUES (" . $nid . ",'NEWS','" . $_POST['name'] . "','" . $_POST['txt'] . "')"); } else { $kom_info = '<span style="color:red;">Dieser Name ist bereits an einen User vergeben, benutze bitte einen anderen.</span><br />'; } } // kommentar add // kommentar loeschen if ($menu->getA(2) == 'd' AND is_numeric($menu->getE(2)) AND has_right(- 7, 'news')) { $kommentar_id = escape($menu->getE(2), 'integer'); db_query("DELETE FROM prefix_koms WHERE uid = " . $nid . " AND cat = 'NEWS' AND id = " . $kommentar_id); } // kommentar loeschen $kategorie = news_find_kat($row->news_kat); $textToShow = $row->html ? $row->news_text : bbcode($row->news_text); $textToShow = str_replace('[PREVIEWENDE]', '', $textToShow); if (!empty($such)) { $textToShow = markword($textToShow, $such); } // klicks zaehlen db_query("UPDATE prefix_news SET klicks = klicks + 1 WHERE news_id = " . $nid); $tpl = new tpl ('news/news.htm'); $ar = array ( 'TEXT' => $textToShow, 'KATE' => $kategorie, 'NID' => $nid, 'uname' => $_SESSION['authname'], 'ANTISPAM' => (loggedin()?'':get_antispam ('newskom', 0)), 'NAME' => $row->news_title, 'info' => $kom_info ); $tpl->set_ar_out($ar, 2); if ($komsOK) { $tpl->set_ar_out (array ('NAME' => $row->news_title , 'NID' => $nid, 'style' => loggedin() ? 'style="display:none;"' : ''), 3); } $erg1 = db_query("SELECT `a`.`text`, `a`.`name`, `a`.`id`, `b`.`id` AS `userid`, `b`.`name` AS `username`, `b`.`avatar` FROM `prefix_koms` AS `a` LEFT JOIN `prefix_user` AS `b` ON `a`.`name` = `b`.`name` WHERE `a`.`uid` = " . $nid . " AND `a`.`cat` = 'NEWS' ORDER BY `a`.`id` DESC"); $ergAnz1 = db_num_rows($erg1); if ( $ergAnz1 == 0 ) { echo '<b>'.$lang['nocomments'].'</b>'; } else { $zahl = $ergAnz1; while ($row1 = db_fetch_assoc($erg1)) { $username = empty($row1['userid']) ? '<em>Gast:</em> '.$row1['name'] : '<a href="index.php?user-details-'.$row1['userid'].'">'.$row1['username'].'</a>'; $komavatar = (empty($row1['userid']) ? '' : (!empty($row1['avatar']) && file_exists($row1['avatar']) ? '<a href="index.php?user-details-'.$row1['userid'].'"><img src="'.$row1['avatar'].'" border="0" alt="'.$row1['username'].'" title="'.$row1['username'].'"></a>' : '<img src="include/images/avatars/wurstegal.jpg" alt="Kein Avatar" />')); $row1['text'] = bbcode(trim($row1['text'])); if (has_right(-7, 'news')) { $row1['text'] .= '<a href="?news-'.$nid.'-d'.$row1['id'].'"><img src="include/images/icons/del.gif" alt="löschen" border="0" title="löschen" /></a>'; } $tpl->set_ar_out( array('NAME' => $username, 'AVATAR' => $komavatar, 'TEXT' => $row1['text'], 'ZAHL' => $zahl ) , 4 ); $zahl--; } } $tpl->out(5); } $design->footer(); ?>
<img src="include/designs/shooterbase/images/news_top.jpg" width="567" height="27"> <table background="include/designs/shooterbase/images/news_bg.jpg" width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="newsbg"> <tr> <td width="10"></td> <td> <table width="100%" border="0" align="center" cellpadding="5" cellspacing="0"> <tr> <td class="smalfont">{datum} - <strong><a href="index.php?news-{id}">{title}</a></strong></td> </tr> <table width="98%" border="0" cellspacing="0" cellpadding="2"> <tr> <td><hr style="height: 0px; border: dotted #000000 0px; border-top-width: 1px; " /></td> </tr> </table> <table width="100%" border="0" align="center" cellpadding="1" cellspacing="0" class="cbg1"> <tr> <td align="center">{kate}</td> </tr> </table> <table width="98%" border="0" cellspacing="0" cellpadding="2"> <tr> <td>{text}</td> </tr> <tr> <td><hr style="height: 0px; border: dotted #000000 0px; border-top-width: 1px; " /></td> </tr> </table> <table width="98%" border="0" cellspacing="0" cellpadding="1"> <tr> <td align="left" width="60%" class="smalfont">Geschrieben von <strong>{username}</strong>{edit}</td> <td align="right" width="40%"> <div align="right"><a href="index.php?news-{id}" alt="Kommentare ({kom})" title="Kommentare ({kom})"><img src="include/images/icons/news/comments.gif" alt="Kommentare ({kom})" border="0"></a> {readwholenews} </div></td> </td> <td width="10"></td> </tr> </table> </td></tr></table> <img src="include/designs/shooterbase/images/news_bt.jpg" width="567" height="25"> <br /> <br /> {EXPLODE} <br /> <br /><center>{SITELINK}</center> {EXPLODE} <script language="JavaScript" type="text/javascript"> function delkom (NID, ID) { var Check = confirm("Kommentar wirklich löschen?") if (Check == true) window.open("index.php?news-"+NID+"-d"+ID,"_self"); }</script> <!-- News Kommentare und Mehr lesen --> <table width="100%" cellpadding="5" cellspacing="1" border="0"> <tr class="Chead"> <th height="25"><b>{NAME}</b></th> </tr> <tr> <td height="25">{_lang_message}</td> </tr> <tr> <td align="center">{KATE}</td> </tr> <tr> <td > <div style="float:left; padding-left:10px; ">{TEXT}</div><br style="clear:both; " /> <p></p> <a href="javascript:history.back(1)"><b>«</b>{_lang_back}</a> </td> </tr> <tr> <td height="25">{_lang_commentsfor} {NAME}</td> </tr> <tr> <td> {EXPLODE} <form action="index.php?news-{NID}" method="POST"> <fieldset> <legend>{_lang_writecomment}</legend> <input type="text" name="name" value="{uname}" /> {ANTISPAM} <input type="submit" value="{_lang_enter}"><br /> <textarea style="width: 98%" cols="50" rows="2" name="txt"></textarea><br /> </fieldset> </form> <br /> {EXPLODE} <div style="float:left; margin:4px; width:20%; padding:2px 4px 2px 2px; border-right:4px solid #fe9500;"><span class="Cmite"># <b>{ZAHL}</b> von {NAME}</span><br/> <div style="height:7px;"></div><span style="text-align:center; display:block;">{AVATAR}</span></div> <div style="float:left; margin:4px; width:70%; padding:3px;">{TEXT}</div> <br style="clear:both;"> <div style="background:#2a2a2a; padding:1px; margin:2px 0 2px 0; width:100%"></div> {EXPLODE} <br /> <a href="javascript:history.back(1)"><b>«</b> {_lang_back}</a> </td> </tr> </table>
MySQL Error: 1267 : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german1_ci,IMPLICIT) for operation '=' in Query: SELECT `a`.`text`, `a`.`name`, `a`.`id`, `b`.`id` AS `userid`, `b`.`name` AS `username`, `b`.`avatar` FROM `ic1_koms` AS `a` LEFT JOIN `ic1_user` AS `b` ON `a`.`name` = `b`.`name` WHERE `a`.`uid` = 3 AND `a`.`cat` = 'NEWS' ORDER BY `a`.`id` DESC Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ news.php:332 -- db_query(...) @ news.php:21 -- require_once(...) @ index.php:35 -- require_once(...) Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in E:\server\xampp\htdocs\ilchclan_dev\include\includes\func\db\mysql.php on line 71
Geschlossen | ||
Zurück zu Module und Modifikationen |