Übersicht - Druckversion

Code:
--- overview.php    2009-04-21 17:59:54.000000000 +0200

+++ overview.php    2010-04-23 17:43:51.458876888 +0200

@@ -721,6 +721,7 @@

 function overview_do_newestthreads($overview_unviewwhere) {

 

     global $mybb, $db, $templates, $theme, $lang, $trow;

+    global $cache;

 

     if($mybb->settings['overview_newest_threads'] == 1)

     {

@@ -735,19 +736,29 @@

 

         // Daten für neueste Themen aus Datenbank auslesen

         $query = $db->query("

-            SELECT subject, username, uid, tid, replies

+            SELECT subject, username, uid, tid, replies, icon

             FROM ".TABLE_PREFIX."threads

             WHERE visible = '1' {$overview_unviewwhere} AND closed NOT LIKE 'moved|%'

             ORDER BY dateline DESC

             LIMIT 0,{$mybb->settings['overview_max']}

         ;");

 

+        $iconcache = $cache->read("posticons");

+

         // Daten ausgeben

         while ($threads = $db->fetch_array($query))

         {

             $val1 = overview_parsesubject($threads['subject'], $threads['tid']);

             $val2 = overview_parseuser($threads['uid'], $threads['username']);

             $val3 = "<a href=\"javascript:MyBB.whoPosted({$threads['tid']});\">{$threads['replies']}</a>";

+

+            $icon = $iconcache[$threads['icon']];

+

+            if($icon)

+            {

+                $val1 = "<img src=\"{$icon['path']}\" alt=\"{$icon['name']}\" /> {$val1}";

+            }

+

             eval("\$table_content .= \"".$templates->get("index_overview_3_columns_row")."\";");

         }

         eval("\$output = \"".$templates->get("index_overview_3_columns")."\";");

@@ -834,6 +845,7 @@

 function overview_do_newestposts($overview_unviewwhere) {

 

     global $mybb, $db, $templates, $theme, $lang, $trow;

+    global $cache;

 

     if($mybb->settings['overview_newest_posts'] == 1)

     {

@@ -847,18 +859,34 @@

 

         // Daten für neueste Beiträge aus Datenbank auslesen

         $query = $db->query("

-            SELECT subject, username, uid, pid, tid

-            FROM ".TABLE_PREFIX."posts

+            SELECT subject, username, uid, pid, tid, icon,

+                   (SELECT icon FROM ".TABLE_PREFIX."threads t WHERE p.tid=t.tid) AS threadicon

+            FROM ".TABLE_PREFIX."posts p

             WHERE visible='1' {$overview_unviewwhere}

             ORDER BY dateline DESC

             LIMIT 0,{$mybb->settings['overview_max']}

         ;");

 

+        $iconcache = $cache->read("posticons");

+

         // Daten ausgeben

         while($posts = $db->fetch_array($query))

         {

             $val1 = overview_parsesubject($posts['subject'], $posts['tid'], $posts['pid'], 0, 1);

             $val2 = overview_parseuser($posts['uid'], $posts['username']);

+

+            $icon = $iconcache[$posts['icon']];

+

+            if(!$icon)

+            {

+                $icon = $iconcache[$posts['threadicon']];

+            }

+

+            if($icon)

+            {

+                $val1 = "<img src=\"{$icon['path']}\" alt=\"{$icon['name']}\" /> {$val1}";

+            }

+

             eval("\$table_content .= \"".$templates->get("index_overview_2_columns_row")."\";");

         }

         eval("\$output = \"".$templates->get("index_overview_2_columns")."\";");