Witam, mam pewny problem zrobiłem sobie stronę w php-fusionie(wsumie to w extreme fusionie ktory bazuje na PHP-Fusion 6.01.6) (wiem brzmi to kiczowato ale nie o to tu chodzi). I sprawa wygląda tak ze mam 2 tabelki oto one: . Wyswietlają one najnowsze posty i tematy a chciałbym aby pojawiło sie tam np. Najnowsze artykuły napisane przez użytkowników. z tego co mi sie wydaje ten kawałek odpowiada za lewą częsc tabelki

[PHP] pobierz, plaintext 
 <table width='$theme_width' align='center' cellspacing='0' cellpadding='0'><tr>
       <td style='background-image: url(".THEME."images/szablon_18.jpg); ' class='panel1'> ");
       if (!isset($usr_grps) || !isNum($usr_grps)) $usr_grps="";
$result = dbquery(
       "SELECT tf.*, tt.*, tu.user_id,user_name,user_color,user_prefix FROM ".$db_prefix."forums tf
       INNER JOIN ".$db_prefix."threads tt USING(forum_id)
       INNER JOIN ".$db_prefix."users tu ON tt.thread_lastuser=tu.user_id
       ".$usr_grps." ORDER BY thread_lastpost DESC LIMIT 0,12");
if (dbrows($result) != 0) {
       $i=0;
       if ($theme_width == "100%") echo "\n";
       while ($data = dbarray($result)) {
              if ($i % 2 == 0) { $row_color = "tbl1"; } else { $row_color = "tbl1"; }
                     $new_posts = dbcount("(thread_id)", "posts", "thread_id='".$data['thread_id']."' and post_datestamp>'".(isset($lastvisited) ? $lastvisited : 0)."'");
                     //$thread_replies = dbcount("(thread_id)", "posts", "thread_id='".$data['thread_id']."'") - 1;
                     $thread_replies = $data['thread_replies'];
                     $forum_id = $data['forum_id'];
                     if ($new_posts > 0) {
               $folder123 = "<img src='".THEME."forum/foldernew.gif' height='11'>";
               } else if ($new_posts > 19) {
               $folder123 = "<img src='".THEME."forum/folderhot.gif' height='11'>";
               } else {
                     if ($data['thread_locked'] == 1) {
               $folder123 = "<img src='".THEME."forum/folderlock.gif' height='11'>";
               } else if ($data['thread_locked'] == 0) {
                     $folder123 = "<img src='".THEME."forum/folder.gif' height='11'>";
                     }
                     }
              //$reply_count = dbcount("(thread_id)", "posts", "thread_id='".$data['thread_id']."'");
              $reply_count = $data['thread_replies']+1;
 
              $data2 = dbarray(dbquery("SELECT post_id FROM ".$db_prefix."posts WHERE thread_id='".$data['thread_id']."' ORDER BY post_id DESC LIMIT 1"));
              $threads_message = $data['thread_subject'];
              $threads_message = str_replace("'", "", $threads_message);
              $rstart = ($reply_count > 20 ? "rowstart=".((ceil($reply_count / 20)-1)*20)."&" : "");
              echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\"><tr><td align=\"left\" width='65%' class='small'>";
              if ($theme_width == "100%") {
                     echo "$folder123 <a href='".FORUM."viewthread.php?".$rstart."forum_id=".$data['forum_id']."&thread_id=".$data['thread_id']."#".$data2['post_id']."'  style='color: #ffffff;'>".trimlink($data['thread_subject'], 16)."</a><br></td>\n";
                     echo "<td align=\"right\" width='35%' style='color: #ffffff;'>[ ".($reply_count - 1)." / ".$data['thread_views']." ]</td>";
              } else {
                     echo "$folder123 <a  href='".FORUM."viewthread.php?".$rstart."forum_id=".$data['forum_id']."&thread_id=".$data['thread_id']."#".$data2['post_id']."' style='color: #ffffff;'>".trimlink($data['thread_subject'], 16)."</a><br></td>\n";
                     echo "<td align=\"right\" width='35%' style='color: #ffffff;'>[ ".($reply_count - 1)." / ".$data['thread_views']." ]</td>";
              }
              echo "</tr></table>";
              $i++;
       }
 
} else {
       echo "<center>".$locale['004']."</center>\n";
}
       echo("</td>
[PHP] pobierz, plaintext 

Tak myślalem zeby dać tam skrypt panelu(sciagnietego ze strony Extreme fusiona) lecz nie zabardzo mi to wychodzi... Wiecie może jak to zrobić. Pokaże wam taki przykładowy skrypt(panelu):

[PHP] pobierz, plaintext 
openside ("Top 5");
$result=dbquery("SELECT user_name, user_location, user_icq, user_id, count(user_id) AS article_count FROM ".$db_prefix."articles INNER JOIN
".$db_prefix."users ON article_name=user_id GROUP BY user_name ORDER BY article_count DESC LIMIT 0,5");
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
if(dbrows($result)!=0){
while($data=dbarray($result)){
echo "<tr><td class='small2' align='left'>&nbsp;&nbsp;<img src='".THEME."images/bullet.gif'> <a href='".BASEDIR."profile.php?lookup=$data[user_id]' class='side'>";
echo "$data[user_name]</a></td><td class='small2' align='right'>[$data[article_count]]</td></tr>";
}
}
echo "</table>";
closeside();
?>
[PHP] pobierz, plaintext 

Z góry dziekuje za pomoc

czemu nikt nigdy nie zna odpowiedzi na moje pytania?