collapse

* Simple Portal Archived Forum

This is an Archive Forum.

The content in this forum may be out-of-date or have been superseded by newer information, and links in forum pages to other sites may not work.
This forum contains archives for future reference.

Visit our thread at Simple Machines Forum for current support.

SMF 2.1 users: EhPortal is a ported version of Simple Portal specifically designed for the SMF 2.1 branch.
Please visit web-develop.ca to download EhPortal and for its support.

* User Info

 
 
Welcome, Guest. Please login or register.

* Who's Online

  • Dot Guests: 443
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.

* Shoutbox

Refresh History
  • Shoutbox is not for support!
  • {OCS}MasterSeal: Yup, Still adore SP
    April 21, 2019, 07:08:06 PM
  • {OCS}MasterSeal: STILL love SP :)
    November 24, 2018, 05:05:50 AM
  • ♦ Ninja ZX-10RR ♦: <3 aegersz
    September 13, 2018, 03:36:09 PM
  • aegersz: I STILL <3 LOVE SimplePortal
    September 13, 2018, 07:11:39 AM
  • aegersz: o LOVE you guys - Simple Portal rocks !
    May 09, 2018, 05:18:59 AM
  • Chen Zhen: our apologies for the site being down.. please read server issues topic
    March 22, 2018, 05:32:38 AM
  • {OCS}MasterSeal: LOL PLEASE forget I just posted that. I found the answer in my own dang post back in 2015. lol sorry!
    July 04, 2017, 10:47:55 PM
  • {OCS}MasterSeal: I know this SB isnt' for support, but I just have a general question. Who would I contact to find out where SP stores its block info? Is it DB driven or files? I searched the site but came up with nothing. probably my fault any insight is appreciated.
    July 04, 2017, 10:43:36 PM
  • ♦ Ninja ZX-10RR ♦: Excuse me but what does Simpleportal have to deal with that?
    February 05, 2017, 08:21:14 PM
  • WhiteEagle: of course IMHO that site appears to be dead :(
    February 04, 2017, 01:08:05 PM
  • WhiteEagle: If I can get that, then I'll use it for that site...
    February 04, 2017, 01:07:35 PM
  • WhiteEagle: decided to not use SMF for any projects, unless I can get a copy of the premium version of the fanfiction archive plugin
    February 04, 2017, 01:06:54 PM
  • expertdecisions: cloudflare
    January 28, 2017, 08:01:47 AM
  • aegersz: SM release 2.0.13 !
    January 12, 2017, 06:00:13 AM
  • raffo: Tks Emanuele, even if I didn't understand the fix :D
    November 07, 2016, 02:01:20 AM
  • emanuele: [link]
    November 01, 2016, 12:43:50 PM
  • emanuele: raffo: the English support board is a good place. ;)
    November 01, 2016, 12:43:38 PM
  • raffo: Where can I find the fix for the shoutbox?
    November 01, 2016, 05:06:09 AM
  • {OCS}MasterSeal: To the SP team, I make a point to come here and thank you as much as possible for your work.  so again, THANK YOU!
    October 28, 2016, 10:38:05 AM
  • emanuele: That's indeed funny, the limit is present only in the patch and not the full install.
    October 22, 2016, 06:14:58 PM

* Recent Posts

Adding Forums Button to Nav bar by jirapon
[August 01, 2019, 09:07:12 AM]


Re: Board Icons by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 04:03:41 PM]


MOVED: Czech translation???? by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 03:04:51 PM]


Board Icons by jirapon
[July 30, 2019, 07:28:44 AM]


Re: Thankyou Simpleportal, by ♦ Ninja ZX-10RR ♦
[July 29, 2019, 09:41:29 AM]

Blocks speak! Do you have an interest in getting more blocks - or even making your own? The Blocks Board is for you!

Author Topic: Post order in Recent Posts block  (Read 9830 times)

0 Members and 1 Guest are viewing this topic.

Offline BuddahBoy

  • Semi Newbie
  • *
  • Posts: 6
  • Gender: Male
  • Headbangers Welcome
  • SMF Version: 2.0.10
  • SP Version: 2.3.6
Post order in Recent Posts block
« on: July 20, 2015, 11:42:44 AM »
Greetings - didn't find an answer to this so thought to ask here. 

The "Recent Posts" block lists in descending order and I'd like the list to be ascending and also to not be affected by replies - can you please give me some direction? 

Thank you,
Ron
Time has no meaning to nature

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6782
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
Re: Post order in Recent Posts block
« Reply #1 on: July 20, 2015, 06:33:51 PM »
Try the following change:

SSI.php

Code: (Find) [Select]
ORDER BY t.id_last_msg DESC
Code: (Replace) [Select]
ORDER BY t.id_topic
And slowly, you come to realize... It's all as it should be...

Offline Burke Knight

  • Sr. Member
  • ****
  • Posts: 394
  • Gender: Male
  • I tell it how I see it. Don't like it? Hit Alt+F4
    • BurkeKnight Enterprises
  • SMF Version: None
  • SP Version: None
  • Elkarte Version: None
Re: Post order in Recent Posts block
« Reply #2 on: July 21, 2015, 07:03:10 AM »
Greetings - didn't find an answer to this so thought to ask here. 

and also to not be affected by replies - can you please give me some direction? 

Sounds like you should select Recent Topics instead of Recent Posts.

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6782
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
Re: Post order in Recent Posts block
« Reply #3 on: July 21, 2015, 08:08:42 AM »
We have a single "recent" block which handles both posts and topics. However, the topic bit is more like recently updated topics and not recently created topics, as many people expect. The change above should change that along with the desired sort direction.
And slowly, you come to realize... It's all as it should be...

Offline BuddahBoy

  • Semi Newbie
  • *
  • Posts: 6
  • Gender: Male
  • Headbangers Welcome
  • SMF Version: 2.0.10
  • SP Version: 2.3.6
Re: Post order in Recent Posts block
« Reply #4 on: July 21, 2015, 10:48:01 AM »
Thank you [SiNaN] - I did edit that file as you suggested but nothing changed in the listing.  I attach a screenshot showing the box contents - same per and post fix. 

Appreciate the assistance
Ron
Time has no meaning to nature

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6782
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
Re: Post order in Recent Posts block
« Reply #5 on: July 21, 2015, 12:52:07 PM »
You seem to be listing "posts" with that block indeed. If you want to list "posts" there, what do you mean by "also to not be affected by replies"? Can you try changing the "display" option of that block to "topics" by editing the block and see if that gives you want you want to achieve?
And slowly, you come to realize... It's all as it should be...

Offline BuddahBoy

  • Semi Newbie
  • *
  • Posts: 6
  • Gender: Male
  • Headbangers Welcome
  • SMF Version: 2.0.10
  • SP Version: 2.3.6
Re: Post order in Recent Posts block
« Reply #6 on: July 21, 2015, 01:45:51 PM »
Thank you - tried that previous to the edit of the php file - did that again and it seems to work fine. 

Appreciate it mucho
Ron
Time has no meaning to nature

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6782
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
Re: Post order in Recent Posts block
« Reply #7 on: July 21, 2015, 02:14:09 PM »
Glad to hear that it worked fine. You're welcome! ;)
And slowly, you come to realize... It's all as it should be...