Hi leute....
Wollte ich mal fragen wie man so einen forenticker erstellt !
externer Link
Den hab ich per zufall gefunden.
Kann mir jemand dabei helfen.
Wäre echt nett !
THX
betroffene Homepage: ejs-cz.de
Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
Geschlossen |
?php # Copyright by Manuel # Support www.ilch.de defined ('main') or die ( 'no direct access' ); $query = "SELECT a.id, a.name, a.rep, c.erst as last, c.id as pid, c.time FROM prefix_topics a LEFT JOIN prefix_forums b ON b.id = a.fid LEFT JOIN prefix_posts c ON c.id = a.last_post_id LEFT JOIN prefix_groupusers vg ON vg.uid = ".$_SESSION['authid']." AND vg.gid = b.view LEFT JOIN prefix_groupusers rg ON rg.uid = ".$_SESSION['authid']." AND rg.gid = b.reply LEFT JOIN prefix_groupusers sg ON sg.uid = ".$_SESSION['authid']." AND sg.gid = b.start WHERE ((".$_SESSION['authright']." <= b.view AND b.view < 1) OR (".$_SESSION['authright']." <= b.reply AND b.reply < 1) OR (".$_SESSION['authright']." <= b.start AND b.start < 1) OR vg.fid IS NOT NULL OR rg.fid IS NOT NULL OR sg.fid IS NOT NULL OR -9 >= ".$_SESSION['authright'].") ORDER BY c.time DESC LIMIT 0,7"; //direkt über diesem Kommentar kann die Anzahl der angezeigten Beiträge geändert werden echo '<marquee align="center" direction="up" width="150" height="100" scrollAmount="1" scrolldelay="1" onMouseover="this.scrollAmount=0" onMouseout="this.scrollAmount=1" style="border:none;">'; echo '<div align="center">'; $resultID = db_query($query); while ($row = db_fetch_assoc($resultID)) { $row['date'] = date('d.m.y - H:i',$row['time']); $row['page'] = ceil ( ($row['rep']+1) / $allgAr['Fpanz'] ); echo '<b> | </b><a href="?forum-showposts-'.$row['id'].'-p'.$row['page'].'#'.$row['pid'].'" title="'.$row['date'].'">'.((strlen($row['name'])<50) ? $row['name'] : substr($row['name'],0,15).'...').'<span class="smalfont"> von '.$row['last'].'</span></a>'; } echo ' <b>|</b> ...</marquee>'; ?>
<?php # Copyright by Manuel # Support www.ilch.de defined ('main') or die ( 'no direct access' ); $query = "SELECT a.id, a.name, a.rep, c.erst as last, c.id as pid, c.time FROM prefix_topics a LEFT JOIN prefix_forums b ON b.id = a.fid LEFT JOIN prefix_posts c ON c.id = a.last_post_id LEFT JOIN prefix_groupusers vg ON vg.uid = ".$_SESSION['authid']." AND vg.gid = b.view LEFT JOIN prefix_groupusers rg ON rg.uid = ".$_SESSION['authid']." AND rg.gid = b.reply LEFT JOIN prefix_groupusers sg ON sg.uid = ".$_SESSION['authid']." AND sg.gid = b.start WHERE ((".$_SESSION['authright']." <= b.view AND b.view < 1) OR (".$_SESSION['authright']." <= b.reply AND b.reply < 1) OR (".$_SESSION['authright']." <= b.start AND b.start < 1) OR vg.fid IS NOT NULL OR rg.fid IS NOT NULL OR sg.fid IS NOT NULL OR -9 >= ".$_SESSION['authright'].") ORDER BY c.time DESC LIMIT 0,10"; $resultID = db_query($query); echo '<table>'; echo '<marquee direction="up" width="160" height="120" scrollAmount="1" scrolldelay="1" onMouseover="this.scrollAmount=0" onMouseout="this.scrollAmount=1" style="border:none;">'; while ($row = db_fetch_object($resultID)) { $query2 = "SELECT id, name, recht FROM `prefix_user` WHERE name = '$row->last'"; $result = db_query($query2); $row2 = db_fetch_object($result); echo '<br><b>»</b><a title="Last Post zum Thema '.$row->name.'" href="index.php?forum-showposts-'.$row->id.'#'.$row->pid.'">'.$row->name.'</a><br>Last Post: <a href="index.php?user-details-'.$row2->id.'">'.$row->last.'</a><br>'; } echo '</maquee>'; echo '</table>'; ?>
»
<?php # Copyright by Manuel # Support www.ilch.de defined ('main') or die ( 'no direct access' ); $abf = 'SELECT * FROM prefix_news WHERE news_recht >= '.$_SESSION['authright'].' ORDER BY news_time DESC LIMIT 0,3'; $erg = db_query($abf); echo '<table>'; while ($row = db_fetch_object($erg)) { echo '<tr><td valign="top"><b> » </b></td><td><a class="box" href="index.php?news-'.$row->news_id.'">'.$row->news_title.'</a></td></tr>'; } echo '</table>'; ?>
<?php # Copyright by Manuel # Support www.ilch.de defined ('main') or die ( 'no direct access' ); $abf = 'SELECT * FROM prefix_news WHERE news_recht >= '.$_SESSION['authright'].' ORDER BY news_time DESC LIMIT 0,3'; $erg = db_query($abf); echo '<table>'; echo '<marquee direction="up" width="160" height="120" scrollAmount="1" scrolldelay="1" onMouseover="this.scrollAmount=0" onMouseout="this.scrollAmount=1" style="border:none;">'; while ($row = db_fetch_object($erg)) { echo '<tr><td valign="top"><b> » </b></td><td><a class="box" href="index.php?news-'.$row->news_id.'">'.$row->news_title.'</a></td></tr>'; } echo '</maquee>'; echo '</table>'; ?>
<?php defined ('main') or die ( 'no direct access' ); $abf = 'SELECT * FROM prefix_news WHERE news_recht >= '.$_SESSION['authright'].' ORDER BY news_time DESC LIMIT 0,5'; $erg = db_query($abf); echo '<table>'; echo '<tr>'; echo '<td width="160" height="20"> <marquee direction="up" width="160" height="120" scrollAmount="1" scrolldelay="2" onMouseover="this.scrollAmount=0" onMouseout="this.scrollAmount=1" style="border:none;"'; while ($row = db_fetch_object($erg)){ echo '<br><b> » </b><a class="box" href="index.php?news-'.$row->news_id.'">'.$row->news_title.'</a><br><p>'; } echo '</marquee></td>'; echo '</tr>'; echo '</table>'; ?>
<?php # Copyright by Manuel # Support www.ilch.de defined ('main') or die ( 'no direct access' ); $query = "SELECT a.id, a.name, a.rep, c.erst as last, c.id as pid, c.time FROM prefix_topics a LEFT JOIN prefix_forums b ON b.id = a.fid LEFT JOIN prefix_posts c ON c.id = a.last_post_id LEFT JOIN prefix_groupusers vg ON vg.uid = ".$_SESSION['authid']." AND vg.gid = b.view LEFT JOIN prefix_groupusers rg ON rg.uid = ".$_SESSION['authid']." AND rg.gid = b.reply LEFT JOIN prefix_groupusers sg ON sg.uid = ".$_SESSION['authid']." AND sg.gid = b.start WHERE ((".$_SESSION['authright']." <= b.view AND b.view < 1) OR (".$_SESSION['authright']." <= b.reply AND b.reply < 1) OR (".$_SESSION['authright']." <= b.start AND b.start < 1) OR vg.fid IS NOT NULL OR rg.fid IS NOT NULL OR sg.fid IS NOT NULL OR -9 >= ".$_SESSION['authright'].") ORDER BY c.time DESC LIMIT 0,10"; $resultID = db_query($query); echo '<table>'; echo '<marquee direction="up" width="160" height="120" scrollAmount="1" scrolldelay="1" onMouseover="this.scrollAmount=0" onMouseout="this.scrollAmount=1" style="border:none;">'; while ($row = db_fetch_object($resultID)) { $query2 = "SELECT id, name, recht FROM `prefix_user` WHERE name = '$row->last'"; $result = db_query($query2); $row2 = db_fetch_object($result); echo '<br><b>»</b><a title="Last Post zum Thema '.$row->name.'" href="index.php?forum-showposts-'.$row->id.'#'.$row->pid.'">'.$row->name.'</a><br>Last Post: <a href="index.php?user-details-'.$row2->id.'">'.$row->last.'</a><br>'; } echo '</maquee>'; echo '</table>'; ?>
<?php # Copyright by Manuel # Support www.ilch.de defined ('main') or die ( 'no direct access' ); $query = "SELECT a.id, a.name, a.rep, c.erst as last, c.id as pid, c.time FROM prefix_topics a LEFT JOIN prefix_forums b ON b.id = a.fid LEFT JOIN prefix_posts c ON c.id = a.last_post_id LEFT JOIN prefix_groupusers vg ON vg.uid = ".$_SESSION['authid']." AND vg.gid = b.view LEFT JOIN prefix_groupusers rg ON rg.uid = ".$_SESSION['authid']." AND rg.gid = b.reply LEFT JOIN prefix_groupusers sg ON sg.uid = ".$_SESSION['authid']." AND sg.gid = b.start WHERE ((".$_SESSION['authright']." <= b.view AND b.view < 1) OR (".$_SESSION['authright']." <= b.reply AND b.reply < 1) OR (".$_SESSION['authright']." <= b.start AND b.start < 1) OR vg.fid IS NOT NULL OR rg.fid IS NOT NULL OR sg.fid IS NOT NULL OR -9 >= ".$_SESSION['authright'].") ORDER BY c.time DESC LIMIT 0,5"; $resultID = db_query($query); echo '<table>'; echo '<marquee direction="up" width="160" height="120" scrollAmount="1" scrolldelay="1" onMouseover="this.scrollAmount=0" onMouseout="this.scrollAmount=1" style="border:none;">'; while ($row = db_fetch_object($resultID)) { $query2 = "SELECT id, name, recht FROM `prefix_user` WHERE name = '$row->last'"; $result = db_query($query2); $row2 = db_fetch_object($result); echo '<br><b>»</b><a title="Last Post zum Thema '.$row->name.'" href="index.php?forum-showposts-'.$row->id.'#'.$row->pid.'">'.$row->name.'</a><br>Last Post: <a href="index.php?user-details-'.$row2->id.'">'.$row->last.'</a><br>'; } echo '</maquee>'; echo '</table>'; ?>
<?php defined ('main') or die ( 'no direct access' ); $abf = 'SELECT * FROM prefix_news WHERE news_recht >= '.$_SESSION['authright'].' ORDER BY news_time DESC LIMIT 0,10'; $erg = db_query($abf); echo '<table>'; echo '<tr>'; echo '<td width="160" height="20"> <marquee direction="up" width="160" height="120" scrollAmount="1" scrolldelay="2" onMouseover="this.scrollAmount=0" onMouseout="this.scrollAmount=1" style="border:none;"'; while ($row = db_fetch_object($erg)){ echo '<br><b> » </b><a class="box" href="index.php?news-'.$row->news_id.'">'.$row->news_title.'</a><br><p>'; } echo '</marquee></td>'; echo '</tr>'; echo '</table>'; ?>
lastwars.php <?php # Copyright by Manuel # Support www.ilch.de defined ('main') or die ( 'no direct access' ); $farbe = ''; $farb2 = ''; echo '<table width="100%" border="0" cellpadding="2" cellspacing="0">'; $erg = db_query('SELECT * FROM prefix_wars WHERE status = "3" ORDER BY datime DESC LIMIT 3'); while ($row = db_fetch_object($erg) ) { $row->tag = ( empty($row->tag) ? $row->gegner : $row->tag ); if ($row->wlp == 1) { $bild = 'include/images/icons/win.gif'; } elseif ($row->wlp == 2) { $bild = 'include/images/icons/los.gif'; } elseif ($row->wlp == 3) { $bild = 'include/images/icons/pad.gif'; } echo '<tr><td>'.get_wargameimg($row->game).'</td><td align="left">'; echo '<a href="index.php?wars-more-'.$row->id.'">'; echo $row->owp.' '.$lang['at2'].' '.$row->opp.' - '.$row->tag.'</a></td><td><img src="'.$bild.'"></td></tr>'; } echo '</table>'; ?>
Geschlossen | ||
Zurück zu Module und Modifikationen |