Leaderboard on Forumhome?

[vaskies]

I tried using the code directly from the league module, but had no luck because the tables being queried don't exist.

$league = $DB->query("SELECT l.mid, l.gid, AVG(l.position) AS position, SUM(l.points) as points,
m.name
FROM ibf_games_league AS l
LEFT JOIN ibf_members AS m ON (l.mid=m.id)
".$extquery."
GROUP by mid
ORDER BY points DESC");
while ($row = $DB->fetch_row($league) ) {
extract($row);
$rank++;
$name = $row['name'];
if ($ibforums->member['id'] == $mid) {
$name = "<b>".$name."</b>";
}


Where and how are these "ibf" database tables defined? Needless to say I've extensively searched and unfortunately haven't come up with anything yet...

[stangger5]

What all are you tring to do ??

Have a look at my forum home..
Links in my sig..

[vaskies]

To use your site as a reference, I've been trying to get this:
http://www.next-level-arcade.com/ibproarcade/league.html
and limit it to the top 10, to be used on forumhome.

The current problem I face is I can't find where these "ibf_games_league" and "ibf_members" tables are defined, because they are not actually created in the vbulletin database.

Edit: I'm using vbulletin 4.0 gold patch level 1, btw.