Witam postanowi?em zrobi? panel, który b?dzie mia? Avatar oraz kawa?ek ostatniego postu z danego tematu, ale zupe?nie nie wiem, jak si?, za to zabra?, a mianowicie chcia?bym prosi? o pomoc.
Obrazek, na którym jest pokazane, o co dok?adniej chodzi:
Ogólny kod panelu forum:
<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: forum_threads_panel.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at http://www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited withoutL
+--------------------------------------------------------*/
if (!defined("IN_FUSION")) { die("Access Denied"); }
opensidel($locale['global_020']);
$result = dbquery("
SELECT tt.forum_id, tt.thread_id, tt.thread_subject, tt.thread_lastpost FROM ".DB_THREADS." tt
INNER JOIN ".DB_FORUMS." tf ON tt.forum_id=tf.forum_id
WHERE ".groupaccess('tf.forum_access')." AND tt.thread_hidden='0'
ORDER BY thread_lastpost DESC LIMIT 5
");
if (dbrows($result)) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['thread_subject'], 23);
echo"
<div style='float:left; margin:10px 0 0 14px; font-weight:700; font-family:arial; font-size:12px;'>
<a id='nick_forum' href='".FORUM."viewthread.php?thread_id=".$data['thread_id']."' title='".$data['thread_subject']."'>$itemsubject</a>
</div>
<div style='float:right;'>".showdate("forumdate", $data['thread_lastpost'])."</div>
\n";
}
} else {
echo "<div style='text-align:center'>".$locale['global_023']."</div>\n";
}
closesidel();
?>
Kod, który próbuje wstawi?(Avatar):
<img src='".IMAGES."avatars/".$data['user_avatar']."' style='float:left;margin: 2px 5px 2px 2px;' />
Dopisuje do $result = dbquery("SELECT(...):
user_id, user_name, user_avatar
Jednak nic to nie daje. Powinienem chyba(?) stworzy? jakie? zapytanie DO Mysql(?), lecz niestety tego nie potrafi?.
Druga sprawa, to kod na tre?? ostatniego postu z danego tematu. (Nie posiadam ?adnego kodu, wi?c z tym równie? prosz? o pomoc.)
Posiadam: PFv7.02.06
PW od moderatora:
- Przeniesienie tematu - bogdan 12.10.2014 20:32
|
v7.02.06
