Shoutbox Message User Avatar · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

VICTOR
66.8% (Friendly)
YAF Forumling Topic Starter

14 years ago

Modified Date: 24 Dec 2009

for Version: 1.9.4 - RC1

This is my first sourcecode, feel free to get it.

😁

picture description: for show message owner's Avatar and CurrentUser Avatar

first must edit in your MS-SQL

see in: Databases > your Database > programmability > Stored Procedures > dbo.yaf_shoutbox_getmessage

change from this original query Ln22


SELECT
      Username,
      UserID,
      Message,
      [Date]
      Style = case(@StyledNicks)
            when 1 then [dbo].[yaf_get_userstyle](UserID)
            else'' end
FROM
      [dbo].[yaf_ShoutboxMessage]
ORDER by Date DESC

to this


SELECT
      a.UserID,
      a.Username,
      b.Avatar,
      a.Message,
      [Date] = a.Date,
      Style = case(@StyledNicks)
            when 1 then [dbo].[yaf_get_userstyle](a.UserID)
            else'' end
FROM
      [dbo].[yaf_ShoutboxMessage] a
      left join [dbo].[yaf_User] b on b.UserID = a.UserID
ORDER by a.Date DESC

------------

2.) + 3.) copy Shoutbox.ascx and Shoutbox.ascx.cs

to folder \controls\

from this in folder controls

------------

4.) add CSS Class "ShoutboxFooter1"

to your theme\theme.css


/* ShoutboxFooter1 - Bottom of ShoutBox tables */
.yafnet .shoutboxfooter1 {
	font-size: 10pt;
	font-weight: bold;
	/*height: 28px;*/
	background-color: #666666;
}
.yafnet .shoutboxfooter1 select,
.yafnet .shoutboxfooter1 td {
	font-size: 10px;
}

Edited by user 14 years ago | Reason: Not specified

Thank YAF.Net

this is my forum: www.thewhitechess.com

this is my minor forum: LaughingGazForum

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Sponsor

yeppers
100% (Exalted)
YAF All-the-Time

14 years ago

This is excellent!

Important Information: