Witam, na mojej stronie "www.zaproponuj.org" są takie dwa okna ;) Wyświetlają one najnowsze tematy i posty;) I teraz chciałbym to przerobić tak aby w pierwszym oknie wyświetlały się najnowsze czy tam ostatnio dodane artykuły ;)
<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>";
Kliknij i zaczekaj na załadowanie kodu ...
Jak sie nie|myle za to odpowiada ten kawałek ;P Ewentualnie moge wrzucic tu cały plik od thema ;)
PW od moderatora:
- Przeniesienie tematu - Pieka 01.11 - 12:51
- Brak Stopki! - Pieka 01.11 - 12:53
- Zmiana nazwy tematu - Pieka 01.11 - 12:54
Edytowane przez beafraid dnia 01.11.2009 14:26:34
|
Rozwiń Kod źródłowy PHP
