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 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | ?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>'; ?> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 | <?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>' ; ?> |
1 | » |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | <?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>' ; ?> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 | <?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>' ; ?> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | <?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>' ; ?> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 | <?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>' ; ?> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 | <?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>' ; ?> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | <?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>' ; ?> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | 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 |