diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-05 13:34:23 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-05 13:34:23 +0000 |
| commit | c5ea123ae7dc5b6c1de2af850d152e98aa809f6b (patch) | |
| tree | 9a9f721ef2bd6307233118b015d46dc8208fcaca /phpBB/index.php | |
| parent | b238891d8c118353d19c511a68a9e23adb0519dd (diff) | |
| download | forums-c5ea123ae7dc5b6c1de2af850d152e98aa809f6b.tar forums-c5ea123ae7dc5b6c1de2af850d152e98aa809f6b.tar.gz forums-c5ea123ae7dc5b6c1de2af850d152e98aa809f6b.tar.bz2 forums-c5ea123ae7dc5b6c1de2af850d152e98aa809f6b.tar.xz forums-c5ea123ae7dc5b6c1de2af850d152e98aa809f6b.zip | |
Basic new post folder colour change
git-svn-id: file:///svn/phpbb/trunk@430 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/index.php')
| -rw-r--r-- | phpBB/index.php | 34 |
1 files changed, 25 insertions, 9 deletions
diff --git a/phpBB/index.php b/phpBB/index.php index 9743a67b0c..e2db35a677 100644 --- a/phpBB/index.php +++ b/phpBB/index.php @@ -94,12 +94,11 @@ if($total_categories) { case 'postgresql': $limit_forums = ($viewcat != -1) ? "AND f.cat_id = $viewcat " : ""; - $sql = "SELECT f.*, t.topic_id, t.topic_replies, t.topic_last_post_id, u.username, u.user_id, p.post_time, af.auth_view, af.auth_read, af.auth_post, af.auth_reply, af.auth_edit, af.auth_delete, af.auth_votecreate, af.auth_vote - FROM ".FORUMS_TABLE." f, ".TOPICS_TABLE." t, ".POSTS_TABLE." p, ".USERS_TABLE." u, ".AUTH_FORUMS_TABLE." af + $sql = "SELECT f.*, t.topic_id, t.topic_replies, t.topic_last_post_id, u.username, u.user_id, p.post_time + FROM ".FORUMS_TABLE." f, ".TOPICS_TABLE." t, ".POSTS_TABLE." p, ".USERS_TABLE." u WHERE f.forum_last_post_id = p.post_id AND p.post_id = t.topic_last_post_id AND p.poster_id = u.user_id - AND af.forum_id = f.forum_id $limit_forums UNION ( SELECT f.*, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL @@ -116,12 +115,11 @@ if($total_categories) case 'oracle': $limit_forums = ($viewcat != -1) ? "AND f.cat_id = $viewcat " : ""; - $sql = "SELECT f.*, t.topic_id, t.topic_replies, t.topic_last_post_id, u.username, u.user_id, p.post_time, af.auth_view, af.auth_read, af.auth_post, af.auth_reply, af.auth_edit, af.auth_delete, af.auth_votecreate, af.auth_vote - FROM ".FORUMS_TABLE." f, ".POSTS_TABLE." p, ".TOPICS_TABLE." t, ".USERS_TABLE." u, ".AUTH_FORUMS_TABLE." af + $sql = "SELECT f.*, t.topic_id, t.topic_replies, t.topic_last_post_id, u.username, u.user_id, p.post_time + FROM ".FORUMS_TABLE." f, ".POSTS_TABLE." p, ".TOPICS_TABLE." t, ".USERS_TABLE." u WHERE f.forum_last_post_id = p.post_id(+) AND p.post_id = t.topic_last_post_id(+) AND p.poster_id = u.user_id(+) - AND af.forum_id = f.forum_id(+) $limit_forums ORDER BY f.cat_id, f.forum_order"; break; @@ -129,6 +127,15 @@ if($total_categories) default: // This works on: MySQL, MSSQL and ODBC (Access) $limit_forums = ($viewcat != -1) ? "WHERE f.cat_id = $viewcat " : ""; +/* + $sql = "SELECT f.*, t.topic_id, t.topic_replies, t.topic_last_post_id, u.username, u.user_id, p.post_time + FROM ((( ".FORUMS_TABLE." f + LEFT JOIN ".POSTS_TABLE." p ON f.forum_last_post_id = p.post_id ) + LEFT JOIN ".TOPICS_TABLE." t ON p.post_id = t.topic_last_post_id ) + LEFT JOIN ".USERS_TABLE." u ON p.poster_id = u.user_id ) + $limit_forums + ORDER BY f.cat_id, f.forum_order"; +*/ $sql = "SELECT f.*, t.topic_id, t.topic_replies, t.topic_last_post_id, u.username, u.user_id, p.post_time, af.auth_view, af.auth_read, af.auth_post, af.auth_reply, af.auth_edit, af.auth_delete, af.auth_votecreate, af.auth_vote FROM ((( ".FORUMS_TABLE." f LEFT JOIN ".POSTS_TABLE." p ON f.forum_last_post_id = p.post_id ) @@ -139,6 +146,7 @@ if($total_categories) ORDER BY f.cat_id, f.forum_order"; break; } + if(!$q_forums = $db->sql_query($sql)) { if(DEBUG) @@ -199,10 +207,18 @@ if($total_categories) for($j = 0; $j < $total_forums; $j++) { if( ( ($forum_rows[$j]['cat_id'] == $category_rows[$i]['cat_id'] && $viewcat == -1) || - ($category_rows[$i]['cat_id'] == $viewcat) ) && - $is_auth_ary[$forum_rows[$j]['forum_id']]['auth_view']) + ($category_rows[$i]['cat_id'] == $viewcat) ) && $is_auth_ary[$forum_rows[$j]['forum_id']]['auth_view']) { - $folder_image = "<img src=\"".$images['folder']."\">"; + + if($userdata['session_start'] == $userdata['session_time']) + { + $folder_image = ($forum_rows[$j]['post_time'] > $userdata['session_last_visit']) ? "<img src=\"".$images['new_folder']."\">" : "<img src=\"".$images['folder']."\">"; + } + else + { + $folder_image = ($forum_rows[$j]['post_time'] > $userdata['session_time'] - 300) ? "<img src=\"".$images['new_folder']."\">" : "<img src=\"".$images['folder']."\">"; + } + $posts = $forum_rows[$j]['forum_posts']; $topics = $forum_rows[$j]['forum_topics']; if($forum_rows[$j]['username'] != "" && $forum_rows[$j]['post_time'] > 0) |