Win a copy of Terraform in Action this week in the Cloud forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Rob Spoor
  • Bear Bibeault
Saloon Keepers:
  • Jesse Silverman
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Al Hobbs
  • salvin francis

Sorting the user list

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Is there a way to have the user list sorted by the number of posts instead of the reference number?

Thanks.
[originally posted on jforum.net by bcc]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Currently, no.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Also, there seems to be a weird problem with pagination of the user list with PostgreSQL.
I got 99 users right now, when I click the member listing link, i see all of them, and when I click the next link, I see 32-61. Next, 62-91. Next, 92-99.

So it seems to work fine on the following pages, but not on the first one.

With the post pagination, everything seems to be fine.
[originally posted on jforum.net by bcc]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
BTW, thanks for the project. I like phpbb, but always hated having to install php in addition to an app server.
[originally posted on jforum.net by bcc]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I think I found it.

It uses UserModel.selectAll instead of UserModel.selectAllByLimit for the first page of the user list.

BTW, that's a beautiful way to do db abstraction you got there!
[originally posted on jforum.net by bcc]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
This seems to do the trick.


[originally posted on jforum.net by bcc]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Now that I think about it, it might be easier to just change the postgresql.sql.
But the order of the parameters in PostgresqlUserDAO.selectAll(int,int) still needs to be put in the right order when it calls the super's method.
[originally posted on jforum.net by bcc]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I just changed the order of offset and limit in the postgresql.sql and removed all PostgreSQL's DAO classes, except for PostgresqlDataAccessDriver and PostgresqlScheduledSearchIndexerDAO.

I left them empty.

Everything seems to work fine.


[originally posted on jforum.net by bcc]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Interesting approach.

So, just changing the order of the parameters and removing all dao classes does the trick? Nice.

You think you can post the DIFF for postgresql.sql here?

Thanks a lot.
Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

[originally posted on jforum.net by bcc]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
But you also need to delete the PostgreSQL DAO's classes. Someone reversed the parameters in them, so it won't work if you simply chage postgresql.sql.

PostgresqlDataAccessDriver and PostgresqlScheduledSearchIndexerDAO are references by other classes, so I kept them but removed all methods. It would make sense to remove them completely and update the classes that reference them.

Also, with the new layout (this board), the preview doesn't work for some reason. While I was posting the previous message (the diff), clicking the preview button took me to the home page.


[originally posted on jforum.net by bcc]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ok, thank.. I updated the cvs with your fixes.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic