How can I get the shoutbox to scroll the other way?

Welcome Guest! To enable all features please Login or Register.

#1 2010-06-14T15:26:43Z

I've done the stored procedure no problem. The problem I'm having is getting the scroll bar to remember where it last was (e.g at the bottom)

I've tried all sorts of changes to div.scrollTop etc but nothing is working?

Any ideas?

Topic Starter

Rank: YAF Forumling

Reputation:

Neutral

53%

Joined: 14/06/2010

Posts: 5

Thanks: 1 times

Was thanked: 1 time(s) in 1 post(s)

Sponsor

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

#2 2010-06-15T15:59:10Z

You can do it in procedures.sql
In sp shoutbox_getmessages:
Replace ORDER BY Date DESC for ORDER BY Date
Save it and launch update.

for YAF

Rank: YAF Developer

Reputation:

Exalted

100%

Medals:

Joined: 21/10/2008

Posts: 1,558

Man Russian Federation

Location: Moscow

Thanks: 51 times

Was thanked: 287 time(s) in 253 post(s)

#3 2010-06-15T18:06:30Z

Hi bbobb!

Thanks for the prompt reply but as I said in my original post I've manage to do the stored procedure no problem.

My issue is with the div box scroll behaviour. Everytime you make a post the scroll bar defaults to the top. Obviously the new messages are now at the bottom :wink: so you don't see them.

I need a way for the scroll bar to be positioned at the bottom after a post.

I've seen many solutions on the net that supposedly not only handle Ajax but also Repeater objects that the Shoutbox use, such as setting the div elements scrollTop property to 0, but none seem to work!

What am I missing about the shoutbox that could be stopping this?

I've have noticed that onload it runs a JS scroll behavior method which I thought might be overriding it but I've remmed that out and it made no difference.

I've had at least 15 people on my board ask for this change as they use it like a chatroom and its scroll the opposite way to how they (and I) expect. :cheesy:

Thanks

Topic Starter

Rank: YAF Forumling

Reputation:

Neutral

53%

Joined: 14/06/2010

Posts: 5

Thanks: 1 times

Was thanked: 1 time(s) in 1 post(s)

#4 2010-06-16T08:04:32Z

I've looked into it and I'm a bit of sceptic too now.
Really, I don't have time now to investigate the complex problem.
If you come up with some solution, please let us know🙂

for YAF

Rank: YAF Developer

Reputation:

Exalted

100%

Medals:

Joined: 21/10/2008

Posts: 1,558

Man Russian Federation

Location: Moscow

Thanks: 51 times

Was thanked: 287 time(s) in 253 post(s)

#5 2010-06-16T23:50:37Z

This seems to work in all newer version browsers.

HTH

ShoutBox Reversed Scroll

1. Reverse the message list.

In Install/mssql/procedures.sql

Modify line 6992 - Removing the DESC

ORDER BY Date

2. Set the ID of the ShoutBox <div>

In Controls/Shoutbox.ascx add the id to the div that wraps the messages approx. line48

<div id="divShoutBox" class="post" style="overflow-y:scroll;
 height: 150px; width: 100%; padding: 0; margin: 0">
       <asp:UpdatePanel ID="shoutBoxChatUpdatePanel" UpdateMode="conditional" runat="server">
	<Triggers>

3. Set the scrollbar to the bottom of box when the Timer fires.

In YAF Project find:

Classes/Utilities/JavaScriptBlocks.cs

Add the endrequest section and function

    public static string DisablePageManagerScrollJs
    {
      get
      {
        return
          @"
	var prm = Sys.WebForms.PageRequestManager.getInstance();

	prm.add_beginRequest(beginRequest);

        prm.add_endRequest(endRequest); //ADDED
    
    function beginRequest() {
		prm._scrollPosition = null;
}
    //ADDED
    function endRequest(){
    
    var div = document.getElementById('divShoutBox'😉;
    
    if(div)
	div.scrollTop = 10000
	}//END ADD
";
      }
    }

OR this can be added as in step 5. So you don't modify the source project.

<script type="text/javascript">

    var prm = Sys.WebForms.PageRequestManager.getInstance();

    prm.add_endRequest(endRequest);

    function endRequest() {
        var div = document.getElementById('divShoutBox'😉;
        if (div)
            div.scrollTop = 10000
    }
</script>

4. Add pause to the Shoutbox , Hover the mouse over the chatbox message area to pause the timer.

In Controls/Shoutbox.ascx add the onmouseover and onmouseout section after the new id you gave the <div>

<div id="divShoutBox" onmouseover="stopTimer()" onmouseout="startTimer()"  
class="post" style="overflow-y:scroll; height: 150px; width: 100%; padding: 0;margin: 0">
<asp:UpdatePanel ID="shoutBoxChatUpdatePanel" UpdateMode="conditional" runat="server">
<Triggers>

5. Add Functions for onmouseover and onmouseout

In the <script section at the top of Shoutbox.ascx add the 2 functions

function startTimer() {
    var timer = $find("<%=shoutBoxRefreshTimer.ClientID%>"😉
    if(timer)
    timer._startTimer();
}
function stopTimer() {
    var timer = $find("<%=shoutBoxRefreshTimer.ClientID%>"😉
    if(timer)
    timer._stopTimer();
}
</script>

6. Set Scrollbar to bottom on pageload.

In Default.aspx add the onload to body tag and <script> section below the other <script block at top.

<script type="text/javascript">
    function setChatScroll(){
    var div = document.getElementById('divShoutBox'😉;
    if (div)
        div.scrollTop = 10000
}
</script>

<body style="margin:0; padding:5px" onload="setChatScroll()">

Rebuild the YAF Project to update the YAF.dll.
Update all files changed on Host and rerun install to update the SP.
Should be good to go.😉

😁 I like it this way 👍

Edited by user 2010-06-21T22:45:35Z | Reason: fix errors added no source function

test

Rank: YAF Leader

Reputation:

Exalted

100%

Medals:

Joined: 15/03/2008

Posts: 311

Thanks: 13 times

Was thanked: 62 time(s) in 56 post(s)

1 user thanked logan for this useful post.

slikvik on 22/06/2010

#6 2010-06-21T09:51:23Z

Haha, thanks.

I've actually got it working exactly the way you have over the weekend and was just to about to proudly post the solution! You beat me to it.

BUT.... there is a small problem with the stored procedure. Simply changing the date order only works until you've reach the set ROWCOUNT!! At that point it just shows the oldest messages, albiet in the right order.

Looking at it now, but if you find anything please let me know.

Ta

Topic Starter

Rank: YAF Forumling

Reputation:

Neutral

53%

Joined: 14/06/2010

Posts: 5

Thanks: 1 times

Was thanked: 1 time(s) in 1 post(s)

#7 2010-06-21T09:59:48Z

OK fixed it. You need to change the query to something like this...

USE [YAFF]
GO
/****** Object:  StoredProcedure [dbo].[yaf_shoutbox_getmessages]    Script Date: 06/21/2010 09:43:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/*****************************************************************************************************
//  Original code by: DLESKTECH at http://www.dlesktech.com/support.aspx
//  Modifications by: KASL Technologies at www.kasltechnologies.com
//  Modifications for integration into YAF/Conventions by Jaben Cargman
*****************************************************************************************************/

ALTER PROCEDURE [dbo].[yaf_shoutbox_getmessages]
(
  @NumberOfMessages int, @StyledNicks bit = 0
)  
AS
BEGIN	
		SET ROWCOUNT @NumberOfMessages
SELECT  t1.Username,
		t1.UserID,
		t1.Message,
		t1.[Date],
				Style = case(@StyledNicks)
	        when 1 then  [dbo].[yaf_get_userstyle](UserID)  
	        else ''	 end	
FROM (SELECT TOP 30 t2.*		
		FROM
		[dbo].[yaf_ShoutboxMessage] t2
		ORDER BY t2.[Date] DESC) t1

ORDER BY t1.[Date]

SET ROWCOUNT 0
		
		END

There might be a better way but it was all I could come up with in 5 minutes.

Regards

Vic

Topic Starter

Rank: YAF Forumling

Reputation:

Neutral

53%

Joined: 14/06/2010

Posts: 5

Thanks: 1 times

Was thanked: 1 time(s) in 1 post(s)

1 user thanked slikvik for this useful post.

logan on 22/06/2010

#8 2010-06-21T22:37:36Z

Thanks Vic works Great😁

test

Rank: YAF Leader

Reputation:

Exalted

100%

Medals:

Joined: 15/03/2008

Posts: 311

Thanks: 13 times

Was thanked: 62 time(s) in 56 post(s)

#9 2010-06-22T10:23:39Z

Just to let you know that I've been playing with alternate scripts too.

One small issue with pausing the timer on mouseover is that people are finding messages appearing a bit more quirky. :wink:

So i tried the following:

            Sys.WebForms.PageRequestManager.getInstance().add_endRequest(EndRequestHandler);
            Sys.WebForms.PageRequestManager.getInstance().add_beginRequest(BeginRequestHandler);
			var scrollPos;
			function BeginRequestHandler(sender, args) {
			    var elem = document.getElementById('shoutScroll'😉;
			    scrollPos = elem.scrollTop;
			    if (scrollPos == elem.scrollHeight) {
			        scrollPos = 10000;
			    }
			    //alert(scrollPos);"+
			}
            function EndRequestHandler(sender, args) {
			    var elem = document.getElementById('shoutScroll'😉;
                 elem.scrollTop = scrollPos;
				 //alert(scrollPos);
				 }

This stores the position before a request and then restores it after. This allows messages to continue to flow and the user can leave the scroll bar where they choose to leave it. It also removes the need for the two mouseover scripts. Unfortunately this has its own quirk too. Say the BeginHandler captures scrollPos at 50 and then you start moving, when EndHandler runs it moves your scrollbar back to 50. Not a big issue but still not perfect.

😕

Topic Starter

Rank: YAF Forumling

Reputation:

Neutral

53%

Joined: 14/06/2010

Posts: 5

Thanks: 1 times

Was thanked: 1 time(s) in 1 post(s)

#10 2017-10-05T20:12:37Z

I modified the stored procedure below and the ShoutBox control (forum\controls\ShoutBox.ascx) to get the order changed.

User Control change
Added this below "</asp😛anel>"

<script>
$("body"😉.on('😉OMSubtreeModified', "#shoutBoxChatArea", function() {
 $("#shoutBoxChatArea"😉.scrollTop($("#shoutBoxChatArea"😉[0].scrollHeight);
}); 
</script>

Stored Procedure change


Alter  PROCEDURE [dbo].[yaf_shoutbox_getmessages]
(
  @BoardId int,
  @NumberOfMessages int, @StyledNicks bit = 0
)  
AS
BEGIN

    --SELECT TOP(@NumberOfMessages)
    --    sh.[ShoutBoxMessageID],
    --    sh.UserName,
    --    sh.UserID,
    --    sh.[Message],
    --    sh.[Date], 
    --    Style= case(@StyledNicks)
    --        when 1 then  usr.UserStyle
    --        else ''    end
                
    --FROM
    --    [dbo].[yaf_ShoutboxMessage] sh
    --    JOIN [dbo].[yaf_User] usr on usr.UserID = sh.UserID
    --WHERE 
    --    sh.BoardId = @BoardId
    --ORDER BY sh.Date DESC

    DECLARE @maxid int
   SET @maxid = (SELECT MAX(ShoutBoxMessageID) FROM [dbo].[yaf_ShoutboxMessage]);

   SELECT TOP(@NumberOfMessages)
        sh.[ShoutBoxMessageID],
        sh.UserName,
        sh.UserID,
        sh.[Message],
        sh.[Date],
        Style= case(@StyledNicks)
            when 1 then  usr.UserStyle
            else ''    end

    FROM
        [dbo].[yaf_ShoutboxMessage] sh
        JOIN [dbo].[yaf_User] usr on usr.UserID = sh.UserID
    WHERE
        sh.BoardId = @BoardId
      AND 
      sh.ShoutBoxMessageID >= (@maxid - @NumberOfMessages + 1)
    ORDER BY sh.ShoutBoxMessageID ASC, sh.Date ASC
END

Edited by user 2017-10-06T01:22:40Z | Reason: Not specified

Rank: YAF Leader

Reputation:

Exalted

100%

Medals:

Joined: 26/04/2011

Posts: 1,073

Man United States

Location: in a van down by the river

Thanks: 243 times

Was thanked: 101 time(s) in 92 post(s)

Users browsing this topic

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Users browsing this topic

Similar Topics

About Us

Project Twitter Updates

Useful Links

Our Contacts