Ich hätte gerne, das Avatar und Signatur in den News angezeigt werden.
Hab ich da nur eine Einstellung falsch, oder muss ich evl. in den PHP Dateien was ändern?
verwendete ilchClan Version: 1.1 P
betroffene Homepage: test-41364.alfa3044.alfahosting-server.de/index.php?news
Beitrag zur Merkliste hinzufügen
Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
ilch Forum » Ilch Clan 1.1 » Allgemein » Avatar/Signatur im Newsbereich
| Geschlossen | ||
-
-
Di. 22.10.2013
07:50 Uhr
#2
- Registriert seit
- 17.11.2005
- Beiträge
- 4.606
- Beitragswertungen
wie meinst du das? wo soll der avatar angezeigt werden? und vor allem welcher avatar? -
Also das Avatar da wo der Rote Kasten ist (entsprechend eingerückt natürlich
)
Und die Sig. natürlich unter dem Beitrag -
Di. 22.10.2013
08:06 Uhr
#4
- Registriert seit
- 17.11.2005
- Beiträge
- 4.606
- Beitragswertungen
du meinst die kategorie?
gibt es die bilder im include/images/news order?
heißt das bild wie die kategorie? schreibweise identisch? -
Di. 22.10.2013
08:08 Uhr
#5
- Registriert seit
- 31.03.2013
- Beiträge
- 1.337
- Beitragswertungen
Ich glaube, er meint Avatar des Verfassers, wie im Forum neben den Posts
Zuletzt modifiziert von Outi77 am 22.10.2013 - 08:09:00Die richtige Formulierung eines Problems ist nicht selten bereits die halbe Lösung.
»Albert Einstein« -
Di. 22.10.2013
08:20 Uhr
#6
- Registriert seit
- 17.11.2005
- Beiträge
- 4.606
- Beitragswertungen
ja das gibt es bei den news aber nicht per default ... da muss man in den news.php und news.htm was ändenr und zwar die db abfrage dahingehend das das user bild aus der db importiert wird und anstadt des news kategoriebildes angezeigt wird ... -
Outi, Genau das meinte ich
Zitat geschrieben von holz
Also nix für Dummis
Schade, wäre schön gewesen
Dank für eure Antworten -
Di. 22.10.2013
09:32 Uhr
#8
- Registriert seit
- 08.02.2007
- Beiträge
- 6.558
- Beitragswertungen
Naja du schreibst die db abfrage um bzw fügst avatar hinzu.$abf = "SELECT a.news_title as title, a.news_id as id, DATE_FORMAT(a.news_time,'%d. %m. %Y') as datum, DATE_FORMAT(a.news_time,'%W') as dayofweek, a.news_kat as kate, a.news_text as text, b.name as username, b.avatar FROM prefix_news as a LEFT JOIN prefix_user as b ON a.user_id = b.id WHERE " . $_SESSION['authright'] . " <= a.news_recht OR a.news_recht = 0 ORDER BY news_time DESC LIMIT " . $anfang . "," . $limit;
dann als bsp wenn avatar vorhanden soll er das useravatar nehmen wenn nicht dann das kategorie bzw den kategorienamen
if (!empty($row['avatar'])) { $row['kate'] = '<img src="' . $row['avatar'] . '" alt="" border="0">'; } else { $row['kate'] = news_find_kat($row['kate']); }
und das gleiche wäre es halt mit der Signatur.
Dies ändert auch nur das Bild in der Gesamt News ansicht nicht in der Ansicht wo man die news aufruft aber das kann man ja selbst machen mit den bsp dann
-
OK, da es ja nr eine Testinstallation ist, kann ich ja nix falsch machen
-
Di. 22.10.2013
18:07 Uhr
#10
- Registriert seit
- 31.03.2013
- Beiträge
- 1.337
- Beitragswertungen
Man kann auch mal was in echt falsch machen, wenn man vorher ein Backup gemacht hat
Die richtige Formulierung eines Problems ist nicht selten bereits die halbe Lösung.
»Albert Einstein« -
Ich hab die news.php natürlich vorher gesichert
Jetzt bekomme ich beim aufrufen der News die MeldungZitat
Hier mal der Code$tpl = new tpl ( 'news.htm' ); $abf = "SELECT a.news_title as title, a.news_id as id, DATE_FORMAT(a.news_time,'%d. %m. %Y') as datum, DATE_FORMAT(a.news_time,'%W') as dayofweek, a.news_kat as kate, a.news_text as text, b.name as username b.avatar FROM prefix_news as a LEFT JOIN prefix_user as b ON a.user_id = b.id WHERE ".$_SESSION['authright']." <= a.news_recht OR a.news_recht = 0 ORDER BY news_time DESC LIMIT ".$anfang.",".$limit; #echo '<pre>'.$abf.'</pre>'; $erg = db_query($abf); 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); if (!empty($row['avatar'])) { $row['kate'] = '<img src="' . $row['avatar'] . '" alt="" border="0">'; } else { $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'].'">'.$lang['readwholenews'].'</a> «'; } else { $row['readwholenews'] = ''; } $row['text'] = bbcode($row['text']); $tpl->set_ar_out($row,0); } $tpl->set_out('SITELINK', $MPL,1); unset($tpl); } -
Di. 22.10.2013
18:23 Uhr
#12
- Registriert seit
- 07.08.2008
- Beiträge
- 3.003
- Beitragswertungen
Schließ mal die else Anweisung. -
Da steht 2 mal was von else
Wo iund wie schließt man die?
Ich bin mit php überhaupt nicht vertraut, tut mir leid -
Di. 22.10.2013
18:32 Uhr
#14
- Registriert seit
- 07.08.2008
- Beiträge
- 3.003
- Beitragswertungen
Kein Problem
$tpl = new tpl ( 'news.htm' ); $abf = "SELECT a.news_title as title, a.news_id as id, DATE_FORMAT(a.news_time,'%d. %m. %Y') as datum, DATE_FORMAT(a.news_time,'%W') as dayofweek, a.news_kat as kate, a.news_text as text, b.name as username b.avatar FROM prefix_news as a LEFT JOIN prefix_user as b ON a.user_id = b.id WHERE ".$_SESSION['authright']." <= a.news_recht OR a.news_recht = 0 ORDER BY news_time DESC LIMIT ".$anfang.",".$limit; #echo '<pre>'.$abf.'</pre>'; $erg = db_query($abf); 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); if (!empty($row['avatar'])) { $row['kate'] = '<img src="' . $row['avatar'] . '" alt="" border="0">'; } else { $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'].'">'.$lang['readwholenews'].'</a> «'; } else { $row['readwholenews'] = ''; } $row['text'] = bbcode($row['text']); $tpl->set_ar_out($row,0); } $tpl->set_out('SITELINK', $MPL,1); unset($tpl); } -
Di. 22.10.2013
18:34 Uhr
#15
- Registriert seit
- 31.03.2013
- Beiträge
- 1.337
- Beitragswertungen
Wenn Du Deinen Code ordentlich einrückst, siehst Du es!
Mist, zu spät
Zuletzt modifiziert von Outi77 am 22.10.2013 - 18:35:07Die richtige Formulierung eines Problems ist nicht selten bereits die halbe Lösung.
»Albert Einstein« -
Nun ist der Fehler in Zeile 147
-
Di. 22.10.2013
18:46 Uhr
#17
- Registriert seit
- 21.03.2007
- Beiträge
- 7.634
- Beitragswertungen
Poste mal den gesamten Code und setze bitte noch in der Abfrage ein Komma nach b.name as username --> b.name as username, -
Komma ist gesetzt, hier der gesamte Code
<?php # Copyright by: Manuel # Support: www.ilch.de 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 ); } 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'; $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 FROM prefix_news as a LEFT JOIN prefix_user as b ON a.user_id = b.id WHERE a.news_recht = 0 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' => 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 ); $MPL = db_make_sites ($page , "WHERE news_recht >= ".$_SESSION['authright'] , $limit , '?news' , 'news' ); $anfang = ($page - 1) * $limit; $tpl = new tpl ( 'news.htm' ); $abf = "SELECT a.news_title as title, a.news_id as id, DATE_FORMAT(a.news_time,'%d. %m. %Y') as datum, DATE_FORMAT(a.news_time,'%W') as dayofweek, a.news_kat as kate, a.news_text as text, b.name as username, b.avatar FROM prefix_news as a LEFT JOIN prefix_user as b ON a.user_id = b.id WHERE ".$_SESSION['authright']." <= a.news_recht OR a.news_recht = 0 ORDER BY news_time DESC LIMIT ".$anfang.",".$limit; #echo '<pre>'.$abf.'</pre>'; $erg = db_query($abf); 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); if (!empty($row['avatar'])) { $row['kate'] = '<img src="' . $row['avatar'] . '" alt="" border="0">'; } else { $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'].'">'.$lang['readwholenews'].'</a> «'; } else { $row['readwholenews'] = ''; } $row['text'] = bbcode($row['text']); $tpl->set_ar_out($row,0); } $tpl->set_out('SITELINK', $MPL,1); unset($tpl); } } else { $design->header(); $nid = escape($menu->get(1), 'integer'); $row = db_fetch_object(db_query("SELECT * FROM `prefix_news` WHERE news_id = '".$nid."'")); if ( has_right(array($row->news_recht)) ) { $komsOK = true; if ( $allgAr['Ngkoms'] == 0 ) { if ( loggedin() ) { $komsOK = true; } else { $komsOK = false; } } if ( $allgAr['Nukoms'] == 0 ) { $komsOK = false; } # 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'); db_query("INSERT INTO `prefix_koms` (`uid`,`cat`,`name`,`text`) VALUES (".$nid.",'NEWS','".$_POST['name']."','".$_POST['txt']."')"); } # 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 = bbcode($row->news_text); $textToShow = str_replace('[PREVIEWENDE]','',$textToShow); if ( !empty($such) ) { $textToShow = markword($textToShow,$such); } $tpl = new tpl ( 'news.htm' ); $ar = array ( 'TEXT' => $textToShow, 'KATE' => $kategorie, 'NID' => $nid, 'uname' => $_SESSION['authname'], 'ANTISPAM' => (loggedin()?'':get_antispam ('newskom', 0)), 'NAME' => $row->news_title ); $tpl->set_ar_out($ar, 2 ); if ($komsOK) { $tpl->set_ar_out ( array ( 'NAME' => $row->news_title , 'NID' => $nid ), 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="?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' => $row1['name'], 'TEXT' => $row1['text'], 'ZAHL' => $zahl ) , 4 ); $zahl--; } } } $tpl->out(5); } $design->footer(); ?> -
Di. 22.10.2013
18:59 Uhr
#19
- Registriert seit
- 21.03.2007
- Beiträge
- 7.634
- Beitragswertungen
Probiers mal:
<?php # Copyright by: Manuel # Support: www.ilch.de 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); } 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'; $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 FROM prefix_news as a LEFT JOIN prefix_user as b ON a.user_id = b.id WHERE a.news_recht = 0 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' => 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); $MPL = db_make_sites($page, "WHERE news_recht >= " . $_SESSION['authright'], $limit, '?news', 'news'); $anfang = ($page - 1) * $limit; $tpl = new tpl('news.htm'); $abf = "SELECT a.news_title as title, a.news_id as id, DATE_FORMAT(a.news_time,'%d. %m. %Y') as datum, DATE_FORMAT(a.news_time,'%W') as dayofweek, a.news_kat as kate, a.news_text as text, b.name as username, b.avatar FROM prefix_news as a LEFT JOIN prefix_user as b ON a.user_id = b.id WHERE " . $_SESSION['authright'] . " <= a.news_recht OR a.news_recht = 0 ORDER BY news_time DESC LIMIT " . $anfang . "," . $limit; #echo '<pre>'.$abf.'</pre>'; $erg = db_query($abf); 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); if (!empty($row['avatar'])) { $row['kate'] = '<img src="' . $row['avatar'] . '" alt="" border="0">'; } else { $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'] . '">' . $lang['readwholenews'] . '</a> «'; } else { $row['readwholenews'] = ''; } $row['text'] = bbcode($row['text']); $tpl->set_ar_out($row, 0); } $tpl->set_out('SITELINK', $MPL, 1); unset($tpl); } } else { $design->header(); $nid = escape($menu->get(1), 'integer'); $row = db_fetch_object(db_query("SELECT * FROM `prefix_news` WHERE news_id = '" . $nid . "'")); if (has_right(array( $row->news_recht ))) { $komsOK = true; if ($allgAr['Ngkoms'] == 0) { if (loggedin()) { $komsOK = true; } else { $komsOK = false; } } if ($allgAr['Nukoms'] == 0) { $komsOK = false; } # 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'); db_query("INSERT INTO `prefix_koms` (`uid`,`cat`,`name`,`text`) VALUES (" . $nid . ",'NEWS','" . $_POST['name'] . "','" . $_POST['txt'] . "')"); } # 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 = bbcode($row->news_text); $textToShow = str_replace('[PREVIEWENDE]', '', $textToShow); if (!empty($such)) { $textToShow = markword($textToShow, $such); } $tpl = new tpl('news.htm'); $ar = array( 'TEXT' => $textToShow, 'KATE' => $kategorie, 'NID' => $nid, 'uname' => $_SESSION['authname'], 'ANTISPAM' => (loggedin() ? '' : get_antispam('newskom', 0)), 'NAME' => $row->news_title ); $tpl->set_ar_out($ar, 2); if ($komsOK) { $tpl->set_ar_out(array( 'NAME' => $row->news_title, 'NID' => $nid ), 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="?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' => $row1['name'], 'TEXT' => $row1['text'], 'ZAHL' => $zahl ), 4); $zahl--; } } } $tpl->out(5); } $design->footer(); ?>
Es ist schon gewohlt, dass das Kategoriebild durch das Avatar ersetzt wird? -
Zitat geschrieben von Lord|Schirmer
Jaaaaaaaa, und jetzt funktioniert es auch, recht vielen Dank (Y)*freu*
Ma gucke, ob ich das dann mit der Sig auch noch hinbekomme -
Di. 22.10.2013
19:05 Uhr
#21
- Registriert seit
- 21.03.2007
- Beiträge
- 7.634
- Beitragswertungen
Ich hab´s nur formatiert ... das ist Siggi & -saarlonz- work
Prinzip ist das Gleiche! Abfrage --> Prüfung --> Ausgabe
Zuletzt modifiziert von Lord|Schirmer am 22.10.2013 - 19:55:20 -
Wie gesagt, PHP ist für mich Böhmische Dörfer, da steig ich überhaupt nicht durch
-
Di. 22.10.2013
19:55 Uhr
#23
- Registriert seit
- 21.03.2007
- Beiträge
- 7.634
- Beitragswertungen
-
Zitat geschrieben von Lord|Schirmer
Ne, da hab ich mich jetzt noch nicht dran gesetzt
Die Sig sollte da hin
[img][/img]
Also unter "1 Kommentar"
Am besten zentriert
Zuletzt modifiziert von herku am 22.10.2013 - 20:11:46 -
Di. 22.10.2013
20:29 Uhr
#25
- Registriert seit
- 21.03.2007
- Beiträge
- 7.634
- Beitragswertungen
OK... zur Erklärung
ich schaue wieder in die Datenbank und sehe in der Tabelle user die Spalte sig, deshalb setze ich in die Abfrage zusätzlich sig ein.
Nach der Abfrage kommt die Prüfung und die Vorbereitung der Ausgabe an das Template
if (!empty($row['sig'])) { // wenn Signatur nicht leer $row['signatur'] = bbcode($row['sig']); // gib diese aus } else { // ansonsten $row['signatur'] = ''; // gib nichts aus } // fertig
<?php # Copyright by: Manuel # Support: www.ilch.de 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); } 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'; $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 FROM prefix_news as a LEFT JOIN prefix_user as b ON a.user_id = b.id WHERE a.news_recht = 0 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' => 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); $MPL = db_make_sites($page, "WHERE news_recht >= " . $_SESSION['authright'], $limit, '?news', 'news'); $anfang = ($page - 1) * $limit; $tpl = new tpl('news.htm'); $abf = "SELECT a.news_title as title, a.news_id as id, DATE_FORMAT(a.news_time,'%d. %m. %Y') as datum, DATE_FORMAT(a.news_time,'%W') as dayofweek, a.news_kat as kate, a.news_text as text, b.name as username, b.avatar, b.sig FROM prefix_news as a LEFT JOIN prefix_user as b ON a.user_id = b.id WHERE " . $_SESSION['authright'] . " <= a.news_recht OR a.news_recht = 0 ORDER BY news_time DESC LIMIT " . $anfang . "," . $limit; #echo '<pre>'.$abf.'</pre>'; $erg = db_query($abf); 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); if (!empty($row['avatar'])) { $row['kate'] = '<img src="' . $row['avatar'] . '" alt="" border="0">'; } else { $row['kate'] = news_find_kat($row['kate']); } if (!empty($row['sig'])) { $row['signatur'] = bbcode($row['sig']); } else { $row['signatur'] = ''; } $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'] . '">' . $lang['readwholenews'] . '</a> «'; } else { $row['readwholenews'] = ''; } $row['text'] = bbcode($row['text']); $tpl->set_ar_out($row, 0); } $tpl->set_out('SITELINK', $MPL, 1); unset($tpl); } } else { $design->header(); $nid = escape($menu->get(1), 'integer'); $row = db_fetch_object(db_query("SELECT * FROM `prefix_news` WHERE news_id = '" . $nid . "'")); if (has_right(array( $row->news_recht ))) { $komsOK = true; if ($allgAr['Ngkoms'] == 0) { if (loggedin()) { $komsOK = true; } else { $komsOK = false; } } if ($allgAr['Nukoms'] == 0) { $komsOK = false; } # 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'); db_query("INSERT INTO `prefix_koms` (`uid`,`cat`,`name`,`text`) VALUES (" . $nid . ",'NEWS','" . $_POST['name'] . "','" . $_POST['txt'] . "')"); } # 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 = bbcode($row->news_text); $textToShow = str_replace('[PREVIEWENDE]', '', $textToShow); if (!empty($such)) { $textToShow = markword($textToShow, $such); } $tpl = new tpl('news.htm'); $ar = array( 'TEXT' => $textToShow, 'KATE' => $kategorie, 'NID' => $nid, 'uname' => $_SESSION['authname'], 'ANTISPAM' => (loggedin() ? '' : get_antispam('newskom', 0)), 'NAME' => $row->news_title ); $tpl->set_ar_out($ar, 2); if ($komsOK) { $tpl->set_ar_out(array( 'NAME' => $row->news_title, 'NID' => $nid ), 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="?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' => $row1['name'], 'TEXT' => $row1['text'], 'ZAHL' => $zahl ), 4); $zahl--; } } } $tpl->out(5); } $design->footer(); ?>
Nun musst du nur noch an die passende Stelle im Template include/templates/news.htm den Platzhalter {signatur} einfügen! Am Besten vielleicht als <div style="text-align:center">{signatur}</div>!
Zuletzt modifiziert von Lord|Schirmer am 22.10.2013 - 20:29:36 -
Entschuldigung das ic mich jetzt erst später wieder melde, aber das Mittwochskaraoke darf ich mir immer nicht entgehen lassen
Nun hab ich die news.php aus Deinem Code übernommen und den html Code in der news.html eingefügt.
Die Stelle passt schon mal, aber er gibt mir nicht die Signatur aus, sondern nur das da eine sein soll
-
Do. 24.10.2013
08:48 Uhr
#27
- Registriert seit
- 08.02.2007
- Beiträge
- 6.558
- Beitragswertungen
Na das liegt daran weil das was gecodet wurde für die Hauptansicht gilt und nicht für die Newsdetail ansicht
Versuche es mal so.<?php # Copyright by: Manuel # Support: www.ilch.de 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); } 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'; $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 FROM prefix_news as a LEFT JOIN prefix_user as b ON a.user_id = b.id WHERE a.news_recht = 0 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' => 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); $MPL = db_make_sites($page, "WHERE news_recht >= " . $_SESSION['authright'], $limit, '?news', 'news'); $anfang = ($page - 1) * $limit; $tpl = new tpl('news.htm'); $abf = "SELECT a.news_title as title, a.news_id as id, DATE_FORMAT(a.news_time,'%d. %m. %Y') as datum, DATE_FORMAT(a.news_time,'%W') as dayofweek, a.news_kat as kate, a.news_text as text, b.name as username, b.avatar, b.sig FROM prefix_news as a LEFT JOIN prefix_user as b ON a.user_id = b.id WHERE " . $_SESSION['authright'] . " <= a.news_recht OR a.news_recht = 0 ORDER BY news_time DESC LIMIT " . $anfang . "," . $limit; #echo '<pre>'.$abf.'</pre>'; $erg = db_query($abf); 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); if (!empty($row['avatar'])) { $row['kate'] = '<img src="' . $row['avatar'] . '" alt="" border="0">'; } else { $row['kate'] = news_find_kat($row['kate']); } if (!empty($row['sig'])) { $row['signatur'] = bbcode($row['sig']); } else { $row['signatur'] = ''; } $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'] . '">' . $lang['readwholenews'] . '</a> «'; } else { $row['readwholenews'] = ''; } $row['text'] = bbcode($row['text']); $tpl->set_ar_out($row, 0); } $tpl->set_out('SITELINK', $MPL, 1); unset($tpl); } } else { $design->header(); $nid = escape($menu->get(1), 'integer'); $row = db_fetch_object(db_query("SELECT a.*, b.* FROM `prefix_news` as a LEFT JOIN prefix_user as b ON a.user_id = b.id WHERE news_id = '" . $nid . "'")); if (has_right(array( $row->news_recht ))) { $komsOK = true; if ($allgAr['Ngkoms'] == 0) { if (loggedin()) { $komsOK = true; } else { $komsOK = false; } } if ($allgAr['Nukoms'] == 0) { $komsOK = false; } if (!empty($row->sig)) { $signatur = bbcode($row->sig); } else { $signatur = ''; } # 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'); db_query("INSERT INTO `prefix_koms` (`uid`,`cat`,`name`,`text`) VALUES (" . $nid . ",'NEWS','" . $_POST['name'] . "','" . $_POST['txt'] . "')"); } # 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 = bbcode($row->news_text); $textToShow = str_replace('[PREVIEWENDE]', '', $textToShow); if (!empty($such)) { $textToShow = markword($textToShow, $such); } $tpl = new tpl('news.htm'); $ar = array( 'TEXT' => $textToShow, 'KATE' => $kategorie, 'NID' => $nid, 'uname' => $_SESSION['authname'], 'ANTISPAM' => (loggedin() ? '' : get_antispam('newskom', 0)), 'NAME' => $row->news_title, 'signatur' => $signatur ); $tpl->set_ar_out($ar, 2); if ($komsOK) { $tpl->set_ar_out(array( 'NAME' => $row->news_title, 'NID' => $nid ), 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="?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' => $row1['name'], 'TEXT' => $row1['text'], 'ZAHL' => $zahl ), 4); $zahl--; } } } $tpl->out(5); } $design->footer(); ?> -
SO kappt es
Recht vielen Dank Siggi
| Geschlossen | ||
 |
Zurück zu Allgemein | |
Optionen: Bei einer Antwort zu diesem Thema eine eMail erhalten