To get my feet wet with this whole PHP thing, I wrote a plugin for e107 that queries the WoW Roster database and shows the top players in certain categories.

(Right now, it's still in an unfinished state, but it won't take long to get it distributable. And, it will only work if your roster tables are in the same database as the e107 tables.)

See screenshot attached.

Would anyone else be interested in this? I'm considering adding the following:

1) Professions.
2) Links from each player to their player detail page.

Any suggestions or comments would be appreciated.

that looks nice :-)

I'll be glad to test it when you think it's ready

First suggestion : remove the one database constraint, I think that many ppl are using 2 differents db for e107 & the roster.

I've added 4 lines of php code in the forum_shortcodes.php so ppl can use the roster avatar&sig just by clicking the appropriates radioboxes in the member profil page. If someone is interrested I can post'em here.

kalideda wrote:that looks nice :-)

I'll be glad to test it when you think it's ready

First suggestion : remove the one database constraint, I think that many ppl are using 2 differents db for e107 & the roster.

I've added 4 lines of php code in the forum_shortcodes.php so ppl can use the roster avatar&sig just by clicking the appropriates radioboxes in the member profil page. If someone is interrested I can post'em here.

I'll look into the one database constraint. The problem is that I think connecting to a new database will break e107's database connection... and I have no real way to test with two databases. If we can find someone that has this configured and would be willing to do some testing, it would be a big help.

I'd also love to see your forum_shortcodes that you've added. That would be a big help for people posting in the forums on our site.

Glad to see that there's some interest in my plugin. I'll work on finishing it up (including a configuration screen) and I'll post it here.

I too would definitely use this plugin as well for my e107 site. I'm already using the same DB for both 107 and Roster so the constraint is not a problem here.

I think this would also be a very great WowRoster Addon !!!!
If you think you can easily turn it into an addon (not only e107), that would be very useful =)

Thank you, aniodon.

I too would test it

So I post the e107 tiny mod here, perhaps it'll be usefull for someone
sorry it's not a diff.


I've created 4 e107 "extended variables" (in the e107 admin panel):
user_wowplayer : a textbox (so the e107 username don't have to match the roster/wow one)
user_userostersig : a yes/no radio button
user_userosteravatar : another yes/no radio button
user_guildgrade : a readonly field. that's for another purpose (display the grade, but it need external sync, I use a perl script)

then i've add some lines in this file :
e107/e107_plugins/forum/forum_shortcodes.php

Code: Select all

SC_BEGIN AVATAR
global $post_info, $user, $id;
if ($user = get_user_data($post_info["user_id"])) {
   $userosteravatar = $user["user_userosteravatar"];
   $user_wowplayer = $user["user_wowplayer"];
   $user_guild_grade = $user["user_guildgrade"];
}
if ($post_info['user_id']) {
if ( $userosteravatar == 'oui') {
return "<div class='spacer'><img src='http://myweb.net/wowro/addons/siggen/av.php?name=".$user_wowplayer."' alt='' /></div><br />".$user_guild_grade."<br />";
} else if ($post_info["user_image"]) {
require_once(e_HANDLER."avatar_handler.php");
return "<div class='spacer'><img src='".avatar($post_info['user_image'])."' alt='' /></div><br />".$user_guild_grade."<br />";
} else {
return $user_guild_grade."<br />";
}
} else {
return "<span class='smallblacktext'>".LAN_194."</span>";
}
SC_END

(...)

SC_BEGIN SIGNATURE
global $post_info, $tp, $user;
if ($user = get_user_data($post_info["user_id"])) {
   $userostersig = $user["user_userostersig"];
   $user_wowplayer = $user["user_wowplayer"];
}
if ($post_info['user_id']) {
if ( $userostersig == 'oui') {
return ("<br /><hr style='width:15%; text-align:center' /><img height=76 width=360 src='http://myweb.net/wowro/addons/siggen/sig.php?name=".$user_wowplayer."' alt='' />" ); }
  else {
return ($post_info['user_signature'] ? "<br /><hr style='width:15%; text-align:left' /><span class='smalltext'>".$tp->toHTML($post_info['user_signature'],TRUE)."</span>" : "");
}
}
SC_END


Anyone get that top players addon running on their site? I'd be interested in using it too...cool idea.