phpBB3 Dynamically Generated Stat Graphs

[Krupski Roger]

Top 10 Posters of Star Trek Guide

Can I have the code for that? Please? Pretty-please?

-- Roger

[Highway of Life]

Code: Select all

SELECT user_id, username, user_posts
FROM phpbb_users
ORDER BY user_posts
LIMIT 0, 10

[Krupski Roger]

Code: Select all

SELECT user_id, username, user_posts
FROM phpbb_users
ORDER BY user_posts
LIMIT 0, 10

Ha ha. I know how to query the DB. I was looking for the graphing code. It it a Flash object?

[Highway of Life]

Oh! No, it's actually an image generated by PHP. It uses the JPGraph library.
Here is the code for top posters. But you should be able to adapt it to other graphing scripts as well.

[Krupski Roger]

Oh! No, it's actually an image generated by PHP. It uses the JPGraph library.
Here is the code for top posters. But you should be able to adapt it to other graphing scripts as well.

Ah! Thank you!

I guess I'm gonna have to change this a bit....

Code: Select all

/***
* get top 10 users
***/
function top_ten()
{
    global $db;
    $sql = 'SELECT username, user_posts FROM phpbb_users ORDER BY ~user_posts LIMIT 0, 10';
    $result = $db->sql_query($sql);
    $top = '';
    while ($row = $db->sql_fetchrow($result))
    {
        $top .= ($row['username'] . ',' . $row['user_posts']);
    }
    return $top;
}


Thanks for the info & links!

-- Roger

[Obsidian]

Oh! No, it's actually an image generated by PHP. It uses the JPGraph library.
Here is the code for top posters. But you should be able to adapt it to other graphing scripts as well.

Problem is that JPGraph uses a wonky license. Alas, it is sad day for opensource.

[wadie Wadie]

That's cool .

[Highway of Life]

It's been quite a few years since I first started using some of these graphs. I'm sure they've since improved and there should be a few more options to choose from now... could be interesting.