Einfache Anzeige der letzten Themen in DIV-Box mit Uhrzeit

4seven · Beitrag von **4seven** » 29.10.2008 11:06

lösung?

wär nett, wenn du es einstellen würdest

hoschl · Beitrag von **hoschl** » 29.10.2008 11:22

<?php 
// ############         Edit below         ######################################## 
$topic_length = '60';   // length of topic title 
$topic_limit = '3';   // limit of displayed topics 
$special_forums = '0';   // specify forums ('0' = no; '1' = yes) 
$forum_ids = '3,5,6,7';      // IDs of forums; separate them with a comma 

$config_path = '/';   // path to config.php 
$root_path = 'http://www.vfbfansauerbach.de/forum/';      // link path 
// ############         Edit above         ####################################### 

$path = dirname(__FILE__); 
include_once($path.$config_path .'config.php'); 
mysql_connect($dbhost, $dbuser, $dbpasswd) OR die('Unable to select server.'); 
mysql_select_db($dbname) OR die('Unable to select database.'); 

// ############## output ############## 
echo '<table border="0" cellpadding="5" cellspacing="2" style="width: 100%" id="Table_DSF-Top5"> 
<body margin="0"> <body text="#000000" link="#000000" vlink="#000000" alink="#000000"> 
         <tr> 
           <td colspan="4" bgcolor="red"><span class="small"><font color="white" face="Verdana, Arial, Helvetica, sans-serif" style="font-size:12px"> 
           Neueste Beiträge im Forum!</font></span></td><br> 
         </tr> 
		 <tr></tr>
         <tr> 
            <td style="width: 20%" bgcolor="#fcb116"><span class="small"><strong> 
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">Thema</font> 
            </strong> 
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:9px"></font 
            </strong></span></td>
            <td style="width: 20%" bgcolor="#fcb116"><span class="small"> 
            <strong> 
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">Mitglieder</font> 
            </strong> 
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:9px"></font 
            </strong></span></td> 
            <td style="width: 20%" bgcolor="#fcb116"><span class="small"> 
            <strong> 
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">Datum</font> 
            </strong></span></td> 
			<td style="width: 20%" bgcolor="#fcb116"><span class="small"> 
            <strong> 
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">Uhrzeit</font> 
            </strong></span></td>


         </tr>'; 
// ############## output ############## 

$where_forums = ( $special_forums == '0' ) ? '' : 't.forum_id NOT IN ('. $forum_ids .') AND '; 
$sql = "SELECT t.*, f.forum_id, f.forum_name, u.username AS first_poster, u.user_id AS first_poster_id, u2.username AS last_poster, u2.user_id AS last_poster_id, p.post_username AS first_poster_name, p2.post_username AS last_poster_name, p2.post_time 
   FROM ". $table_prefix ."topics t, ". $table_prefix ."forums f, ". $table_prefix ."users u, ". $table_prefix ."posts p, ". $table_prefix ."posts p2, ". $table_prefix ."users u2 
   WHERE $where_forums t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id 
   ORDER BY t.topic_last_post_id DESC LIMIT $topic_limit"; 
$result = mysql_query($sql); 
if( !$result ) 
{ 
   die('SQL Statement Error: '. mysql_error()); 
   exit(); 
} 

$line = array(); 
while( $row = mysql_fetch_array($result) ) 
{ 
   $line[] = $row; 
} 

for( $i = 0; $i < count($line); $i++ ) 
{ 
   $forum_id = $line[$i]['forum_id']; 
   $forum_url = $root_path .'viewforum.php?f='. $forum_id; 
   $topic_id = $line[$i]['topic_id']; 
   $topic_url = $root_path .'viewtopic.php?t='. $topic_id; 

   $topic_title = ( strlen($line[$i]['topic_title']) < $topic_length ) ? $line[$i]['topic_title'] : substr(stripslashes($line[$i]['topic_title']), 0, $topic_length) .'...'; 

   $topic_type =  ( $line[$i]['topic_type'] == '2' ) ? 'Announcement ': ''; 
   $topic_type .= ( $line[$i]['topic_type'] == '3' ) ? 'Global Announcement ': ''; 
   $topic_type .= ( $line[$i]['topic_type'] == '1' ) ? 'Sticky ': ''; 
   $topic_type .= ( $line[$i]['topic_vote'] ) ? 'Poll ': ''; 

   $views = $line[$i]['topic_views']; 
   $replies = $line[$i]['topic_replies']; 

   $first_time = date('d.m.Y', $line[$i]['topic_time']); 
   $first_author = ( $line[$i]['first_poster_id'] != '-1' ) ? '<a href="'. $root_path .'profile.php?mode=viewprofile&u='. $line[$i]['first_poster_id'] .'" target="_blank">'. $line[$i]['first_poster'] .'</a>' : ( ($line[$i]['first_poster_name'] != '' ) ? $line[$i]['first_poster_name'] : 'guest' ); 
   $last_time = date('d.m.Y', $line[$i]['post_time']);
   $last_hour = date('H:i' ,  $line[$i]['post_time']);
   $last_author = ( $line[$i]['last_poster_id'] != '-1' ) ? $line[$i]['last_poster'] : ( ($line[$i]['last_poster_name'] != '' ) ? $line[$i]['last_poster_name'] : 'guest' ); 
   $last_url = '<a href="'. $root_path .'viewtopic.php?p='. $line[$i]['topic_last_post_id'] .'#'. $line[$i]['topic_last_post_id'] .'" target="_blank">'. $last_author .'</a>'; 

   // ############## output ############## 
   echo '<tr> 

            <td style="width: 40%" bgcolor="#C7B197"><a href="'. $topic_url .'" target="_blank"> 
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">'. $topic_title .'</font></a></td>
            <td style="width: 20%" bgcolor="#C7B197"> 
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">'. $last_url .'</font></td> 
            <td style="width: 20%" bgcolor="#C7B197"> 
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">'. $last_time .'</font></td>
			<td style="width: 20%" bgcolor="#C7B197"> 
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">'. $last_hour .'</font></td> 


        </tr>'; 

   // ############## output ############## 
} 

echo '</table>'; 
mysql_close(); 
?>

4seven · Beitrag von **4seven** » 29.10.2008 11:24

danke, editierst du es bitte nochmal, damit man es als

Code: Alles auswählen

code

wahrnimmt

markier nochmal den ganzen block (in deinem letzten post)
und dann einfach auf code klicksen

hoschl · Beitrag von **hoschl** » 29.10.2008 11:29

Ich versuchs

hoschl · Beitrag von **hoschl** » 29.10.2008 11:32

wie mach ich das denn?
hab hier noch nicht so die ahnung[/list]

4seven · Beitrag von **4seven** » 29.10.2008 11:32

hab nochmal ein edit rein ins letztes post von mir..

hoschl · Beitrag von **hoschl** » 29.10.2008 11:33

hoschl hat geschrieben:wie mach ich das denn?
hab hier noch nicht so die ahnung[/list]

Code: Alles auswählen

hoschl · Beitrag von **hoschl** » 29.10.2008 11:35

4seven hat geschrieben:hab nochmal ein edit rein ins letztes post von mir..

wie denn was denn wo denn. ich bekomms nicht hin

4seven · Beitrag von **4seven** » 29.10.2008 11:35

egal, dann nicht

hoschl · Beitrag von **hoschl** » 29.10.2008 11:39

Code: Alles auswählen

]<?php 
// ############ Edit below ######################################## 
$topic_length = '60'; // length of topic title 
$topic_limit = '3'; // limit of displayed topics 
$special_forums = '0'; // specify forums ('0' = no; '1' = yes) 
$forum_ids = '3,5,6,7'; // IDs of forums; separate them with a comma 

$config_path = '/'; // path to config.php 
$root_path = 'http://www.vfbfansauerbach.de/forum/'; // link path 
// ############ Edit above ####################################### 

$path = dirname(__FILE__); 
include_once($path.$config_path .'config.php'); 
mysql_connect($dbhost, $dbuser, $dbpasswd) OR die('Unable to select server.'); 
mysql_select_db($dbname) OR die('Unable to select database.'); 

// ############## output ############## 
echo '<table border="0" cellpadding="5" cellspacing="2" style="width: 100%" id="Table_DSF-Top5"> 
<body margin="0"> <body text="#000000" link="#000000" vlink="#000000" alink="#000000"> 
<tr> 
<td colspan="4" bgcolor="red"><span class="small"><font color="white" face="Verdana, Arial, Helvetica, sans-serif" style="font-size:12px"> 
Neueste Beiträge im Forum!</font></span></td><br> 
</tr> 
<tr></tr> 
<tr> 
<td style="width: 20%" bgcolor="#fcb116"><span class="small"><strong> 
<font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">Thema</font> 
</strong> 
<font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:9px"></font 
</strong></span></td> 
<td style="width: 20%" bgcolor="#fcb116"><span class="small"> 
<strong> 
<font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">Mitglieder</font> 
</strong> 
<font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:9px"></font 
</strong></span></td> 
<td style="width: 20%" bgcolor="#fcb116"><span class="small"> 
<strong> 
<font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">Datum</font> 
</strong></span></td> 
<td style="width: 20%" bgcolor="#fcb116"><span class="small"> 
<strong> 
<font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">Uhrzeit</font> 
</strong></span></td> 


</tr>'; 
// ############## output ############## 

$where_forums = ( $special_forums == '0' ) ? '' : 't.forum_id NOT IN ('. $forum_ids .') AND '; 
$sql = "SELECT t.*, f.forum_id, f.forum_name, u.username AS first_poster, u.user_id AS first_poster_id, u2.username AS last_poster, u2.user_id AS last_poster_id, p.post_username AS first_poster_name, p2.post_username AS last_poster_name, p2.post_time 
FROM ". $table_prefix ."topics t, ". $table_prefix ."forums f, ". $table_prefix ."users u, ". $table_prefix ."posts p, ". $table_prefix ."posts p2, ". $table_prefix ."users u2 
WHERE $where_forums t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id 
ORDER BY t.topic_last_post_id DESC LIMIT $topic_limit"; 
$result = mysql_query($sql); 
if( !$result ) 
{ 
die('SQL Statement Error: '. mysql_error()); 
exit(); 
} 

$line = array(); 
while( $row = mysql_fetch_array($result) ) 
{ 
$line[] = $row; 
} 

for( $i = 0; $i < count($line); $i++ ) 
{ 
$forum_id = $line[$i]['forum_id']; 
$forum_url = $root_path .'viewforum.php?f='. $forum_id; 
$topic_id = $line[$i]['topic_id']; 
$topic_url = $root_path .'viewtopic.php?t='. $topic_id; 

$topic_title = ( strlen($line[$i]['topic_title']) < $topic_length ) ? $line[$i]['topic_title'] : substr(stripslashes($line[$i]['topic_title']), 0, $topic_length) .'...'; 

$topic_type = ( $line[$i]['topic_type'] == '2' ) ? 'Announcement ': ''; 
$topic_type .= ( $line[$i]['topic_type'] == '3' ) ? 'Global Announcement ': ''; 
$topic_type .= ( $line[$i]['topic_type'] == '1' ) ? 'Sticky ': ''; 
$topic_type .= ( $line[$i]['topic_vote'] ) ? 'Poll ': ''; 

$views = $line[$i]['topic_views']; 
$replies = $line[$i]['topic_replies']; 

$first_time = date('d.m.Y', $line[$i]['topic_time']); 
$first_author = ( $line[$i]['first_poster_id'] != '-1' ) ? '<a href="'. $root_path .'profile.php?mode=viewprofile&u='. $line[$i]['first_poster_id'] .'" target="_blank">'. $line[$i]['first_poster'] .'</a>' : ( ($line[$i]['first_poster_name'] != '' ) ? $line[$i]['first_poster_name'] : 'guest' ); 
$last_time = date('d.m.Y', $line[$i]['post_time']); 
$last_hour = date('H:i' , $line[$i]['post_time']); 
$last_author = ( $line[$i]['last_poster_id'] != '-1' ) ? $line[$i]['last_poster'] : ( ($line[$i]['last_poster_name'] != '' ) ? $line[$i]['last_poster_name'] : 'guest' ); 
$last_url = '<a href="'. $root_path .'viewtopic.php?p='. $line[$i]['topic_last_post_id'] .'#'. $line[$i]['topic_last_post_id'] .'" target="_blank">'. $last_author .'</a>'; 

// ############## output ############## 
echo '<tr> 

<td style="width: 40%" bgcolor="#C7B197"><a href="'. $topic_url .'" target="_blank"> 
<font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">'. $topic_title .'</font></a></td> 
<td style="width: 20%" bgcolor="#C7B197"> 
<font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">'. $last_url .'</font></td> 
<td style="width: 20%" bgcolor="#C7B197"> 
<font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">'. $last_time .'</font></td> 
<td style="width: 20%" bgcolor="#C7B197"> 
<font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">'. $last_hour .'</font></td> 


</tr>'; 

// ############## output ############## 
} 

echo '</table>'; 
mysql_close(); 
?>

phpBB.de

Einfache Anzeige der letzten Themen in DIV-Box mit Uhrzeit

Lösung Uhrzeitausgabe