Title: Order
Last modified: August 30, 2016

---

# Order

 *  Resolved [Gen0sse](https://wordpress.org/support/users/gen0sse/)
 * (@gen0sse)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/order-14/)
 * Hi Jeremy,
 * now that your Plugin is working I’ve noticed that the list of the last posts 
   of my phpBB is in the wrong order (the latest entry should be on the top of the
   list).
 * Moreover the names of the contributors are displayed in lower case letters. Since
   I don’t know very much of programming in PHP I just wanted to know if you could
   offer there a solution to me.
 * Cheers, Jeremy!
 * [https://wordpress.org/plugins/cleverwise-phpbb-statistics/](https://wordpress.org/plugins/cleverwise-phpbb-statistics/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [Me](https://wordpress.org/support/users/cyberws/)
 * (@cyberws)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/order-14/#post-6692786)
 * The plugin is working as it was designed:
 * 1) The order of the posts are the last five however they are displayed in oldest
   to newest. You do raise an interesting point though as reversing the array order
   would flip the order.
 * 2) phpBB has two username columns which are standard and clean. Clean is free
   from any odd characters and all lower case. At present that is used.
 * I will consider adding your requests to the main branch still for now:
 * 1) Open **wpapi.stats.php** in a text editor.
 * 2) Find the line:
 * `$wpdata['last_post']=$forum_posts;`
 * Replace it with:
 * `$wpdata['last_post']=array_reverse($forum_posts);`
 * 3) Find the line:
 * `$sqla="select username_clean from $table where user_id='$poster_id'";`
 * Replace it with:
 * `$sqla="select username from $table where user_id='$poster_id'";`
 * Then find this line:
 * `$poster_id=$rowa['username_clean'];`
 * Replace it with:
 * `$poster_id=$rowa['username'];`
 * 4) Save and upload **wpapi.stats.php** and that should do it on the next data
   pull.
 *  Thread Starter [Gen0sse](https://wordpress.org/support/users/gen0sse/)
 * (@gen0sse)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/order-14/#post-6692807)
 * Brilliant work, Jeremy! That did the trick again. 🙂
 * Thank you very much for your efforts!

Viewing 2 replies - 1 through 2 (of 2 total)

 The topic ‘Order’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/cleverwise-phpbb-statistics.svg)
 * [Cleverwise phpBB Statistics](https://wordpress.org/plugins/cleverwise-phpbb-statistics/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/cleverwise-phpbb-statistics/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/cleverwise-phpbb-statistics/)
 * [Active Topics](https://wordpress.org/support/plugin/cleverwise-phpbb-statistics/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/cleverwise-phpbb-statistics/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/cleverwise-phpbb-statistics/reviews/)

## Tags

 * [list order](https://wordpress.org/support/topic-tag/list-order/)

 * 2 replies
 * 2 participants
 * Last reply from: [Gen0sse](https://wordpress.org/support/users/gen0sse/)
 * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/order-14/#post-6692807)
 * Status: resolved