• Resolved Gen0sse


    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!


Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Jeremy O'Connell


    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:


    Replace it with:


    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:


    Replace it with:


    4) Save and upload wpapi.stats.php and that should do it on the next data pull.

    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.