Showing popular contributors in sidebar

Question

Any idea will help. :)

thanks

Answer 1

You can use this PHP to get the top users:

global $qa_db;
$users=qa_db_single_select($qa_db, qa_db_top_users_selectspec(0));

In more detail, you want the something like the following in the qa-theme.php file in your theme:

<?php

    class qa_html_theme extends qa_html_theme_base
    {
        function sidepanel()
        {
            global $qa_db;

            qa_html_theme_base::sidepanel();

            $users=qa_db_single_select($qa_db, qa_db_top_users_selectspec(0));

            foreach ($users as $user)
                $this->output('<P>'.qa_get_one_user_html($user['handle'], false).
                    ' ('.number_format($user['points']).')</P>');
        }
    }

?>

Comments

It works perfectly !! Thanks again ! Have to do some minor adjustments later, but it is really great. I wonder how long You needed to write that down ?

---

In the above code, instead of sidepanel, if we choose sidebar that works perfectly...

---

Thank you for your code-example!
unfortunately I get the following error:

Warning: Invalid argument supplied for foreach() in ...\XAMPP\htdocs\q2a\qa-include\qa-db.php on line 308

Question2Answer query failed:

SELEC

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELEC' at line 1

any ideas?

--> edited 08.12.2010 :

Solution:
For version 1.3 the function qa_db_single_select changed:
-->  delete the $qa_db

instead of:
$users=qa_db_single_select($qa_db, qa_db_top_users_selectspec(0));
use:
$users=qa_db_single_select(qa_db_top_users_selectspec(0));

:)

[ see this post: http://www.question2answer.org/qa/3309/problem-with-function-qa_db_single_select#a3311 ]

Answer 2

I created a widget that shows top 10user on sidebar for q2aV1.4. It is available for download here

If you have any question, pm me. See demo here

Comments

Solution:

1. In qa-top-user.php change string from: qa_lang_html('addon/top_user'),
to: qa_lang_html('misc/top_user'),

2. open \qa-lang\qa-lang-misc.php and add in the end (within the array):
'top_user' => 'Top Users',

3. save and upload to your server.

---

@tenkana: It seems that you updated your plugin. In the plugin available for download there are no avatars. On your site there are avatars showing up.

Would you mind uploading the new version? Thank you.

Answer 3

You can use either:

• Plugin Best Users per Month

or

• Plugin Most Active Users per Week or Month