aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorGraham Eames <grahamje@users.sourceforge.net>2006-10-05 19:58:37 +0000
committerGraham Eames <grahamje@users.sourceforge.net>2006-10-05 19:58:37 +0000
commitdb202159e23598482f4ead669264b39874de6a4f (patch)
treeb07a4fe90502b0ecc9aa87fa18c1daa3ada02fad
parent9c83c919a20792183e5468218fa08c3dc0d6eade (diff)
downloadforums-db202159e23598482f4ead669264b39874de6a4f.tar
forums-db202159e23598482f4ead669264b39874de6a4f.tar.gz
forums-db202159e23598482f4ead669264b39874de6a4f.tar.bz2
forums-db202159e23598482f4ead669264b39874de6a4f.tar.xz
forums-db202159e23598482f4ead669264b39874de6a4f.zip
Add coluring to search-posts results
git-svn-id: file:///svn/phpbb/trunk@6443 89ea8834-ac86-4346-8a33-228a782c2dd0
-rw-r--r--phpBB/search.php3
-rw-r--r--phpBB/styles/subSilver/template/search_results.html2
2 files changed, 3 insertions, 2 deletions
diff --git a/phpBB/search.php b/phpBB/search.php
index 933072e4de..f177a001fb 100644
--- a/phpBB/search.php
+++ b/phpBB/search.php
@@ -495,7 +495,7 @@ if ($keywords || $author || $author_id || $search_id || $submit)
}
$db->sql_freeresult($result);
- $sql = 'SELECT p.*, f.forum_id, f.forum_name, t.*, u.username, u.user_sig, u.user_sig_bbcode_uid
+ $sql = 'SELECT p.*, f.forum_id, f.forum_name, t.*, u.username, u.user_sig, u.user_sig_bbcode_uid, u.user_colour
FROM ' . POSTS_TABLE . ' p
LEFT JOIN ' . TOPICS_TABLE . ' t ON (p.topic_id = t.topic_id)
LEFT JOIN ' . FORUMS_TABLE . ' f ON (p.forum_id = f.forum_id)
@@ -823,6 +823,7 @@ if ($keywords || $author || $author_id || $search_id || $submit)
$tpl_ary = array(
'POSTER_NAME' => ($row['poster_id'] == ANONYMOUS) ? ((!empty($row['post_username'])) ? $row['post_username'] : $user->lang['GUEST']) : $row['username'],
+ 'POSTER_COLOUR' => ($row['user_colour']) ? '#' . $row['user_colour'] : '',
'U_PROFILE' => ($row['poster_id'] != ANONYMOUS) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=viewprofile&amp;u=' . $row['poster_id']) : '',
'POST_SUBJECT' => $row['post_subject'],
'POST_DATE' => (!empty($row['post_time'])) ? $user->format_date($row['post_time']) : '',
diff --git a/phpBB/styles/subSilver/template/search_results.html b/phpBB/styles/subSilver/template/search_results.html
index 16efdcbfcd..0579b3131d 100644
--- a/phpBB/styles/subSilver/template/search_results.html
+++ b/phpBB/styles/subSilver/template/search_results.html
@@ -87,7 +87,7 @@
<td colspan="2" height="25"><p class="topictitle"><a name="{searchresults.POST_ID}"></a>&nbsp;<!-- IF searchresults.FORUM_TITLE -->{L_FORUM}: <a href="{searchresults.U_VIEW_FORUM}">{searchresults.FORUM_TITLE}</a><!-- ELSE -->{L_GLOBAL}<!-- ENDIF --> &nbsp; {L_TOPIC}: <a href="{searchresults.U_VIEW_TOPIC}">{searchresults.TOPIC_TITLE}</a></p></td>
</tr>
<tr class="row1">
- <td width="150" align="center" valign="middle"><b class="postauthor">{searchresults.POSTER_NAME}</b></td>
+ <td width="150" align="center" valign="middle"><b class="postauthor"<!-- IF searchresults.POSTER_COLOUR --> style="color: {searchresults.POSTER_COLOUR}"<!-- ENDIF -->>{searchresults.POSTER_NAME}</b></td>
<td height="25">
<table width="100%" cellspacing="0" cellpadding="0" border="0">
<tr>