Anybody doing anything interesting?

[Rollie]

There have been loads of people who have downloaded either the realm stats or the guild stats. Anyone out there doing anything interesting with the data? I'd be interested to see some of the things people are doing with the exports!

[Sonfann]

http://freresdarmes.mediom.com/?page=membres

it's in french but you can understand most of the data

but I have fluctuation in the data sometimes I have ~45 members other times I get ~95

I try to upload stats often to provide you with good info

any hints on what happens to the ~50 lost members

[edwalter]

Our guild (http://knightsofthestorm.com) plays on 2 servers (a PvE and a PvP).

Here are our lists:

http://ewal.net/llane.aspx
http://ewal.net/sargeras.aspx

The data comes from two sources: Warcraft Realms & Allakhazam. Several guild members use Allakhazam's WowReader plugin which provides a detailed character profile. Those characters have tradeskill data in our list and the character names are linked to their detailed profiles. The character list and other stats come from Warcraft Realms. The Race and Level are taken from whichever feed has more current data.

For both data feeds, these pages use the same "occasionally download to a local file and always read off the local file" approach as your example PHP code did.

[Guest]

i actually work an a php5 class for my guild. Actual i use a test guildid, we are a german guild so we have to wait.

Here you can see my alpha Version.

FYI
I import your Data in a mysql-DB so i can handle well with it. Actually i check the timestamp from your site, but i think its better to check this timestamp every hour (:
There are no formatet fonts, so spend not so much time on the fonts *g*


http://members.4s.cyrom.de

[Kitaka]

the last one comes from me

[Shade]

http://www.freepgs.com/warng/rostertest.php

what it looks like now.

http://www.freepgs.com/warng/rostertemplate.htm

what it will look like.

i'll post link to overall site when it's completed.

[suran]

Well got my hands on Dan from EU-Khaz'Goroth little census page and decided it would be a nice guild tool as well. so i converted it into this.

www.kaladim.se/census/census.php

more work is needed, i know. like a nice little roster and a lvl / class bar.

[Turiel]

Well, something cool (imho ) I've done is that on my PHPBB forums, I've crossreferenced the guild database to link player data with PHPBB user data.

So on the left hand side, where PHPBB normally displays username, location,etc, I also display level class race and guild. So it looks kinda like the official forums

[Rollie]

How did you make the phpbb username to character association? I'd be interested in seeing this =)

[Turiel]

Code: Select all

function get_user_guildname($g_username)
{
 if (!$g_username)
  return "Error #1";

 $g_query = "select guildid from ss_players where CharName='$g_username'";
 $g_result = mysql_query($g_query);
 if (mysql_num_rows($g_result) > 0)
 {
  $g_row = mysql_fetch_row($g_result);

  $g_guildid = $g_row[0];

  mysql_free_result($g_result);

  $g_query = "select name from ss_guild where gid='$g_guildid'";

  $g_result = mysql_query($g_query);

  if (mysql_num_rows($g_result) > 0)
  {
   $g_row = mysql_fetch_row($g_result);

   $g_name = $g_row[0];
  }
  else
   $g_name = "None";
 }
 else
  $g_name = "None";

 return $g_name;
}

function get_user_wowinfo($w_username)
{
 if (!$w_username)
  return 'Error #1';

 $wowinfo = "";

 $w_query = "select Level,Race,Class from ss_players where CharName='$w_username
'";
 $w_result = mysql_query($w_query);

 if (mysql_num_rows($w_result) > 0)
 {
  $w_row = mysql_fetch_row($w_result);

  $wowinfo = "Level ".$w_row[0]." ".$w_row[1]." ".$w_row[2];
 }

 return $wowinfo;
}

Then, in viewtopic.php search for "$poster from =" and add below:

Code: Select all

        $poster_guild = ( $postrow[$i]['user_id'] != ANONYMOUS ) ? $lang['Guild'].": ".get_user_guildname($postrow[$i]['username']) : '';

        $poster_wowinfo = ( $postrow[$i]['user_id'] != ANONYMOUS ) ? get_user_wowinfo($postrow[$i]['username']) : '';

Search for "'POSTER_JOINED' => $poster_joined," in the same file and add below:

Code: Select all

                'POSTER_GUILD' => $poster_guild,
                'POSTER_WOWINFO' => $poster_wowinfo,

Then in your tempates viewtopic_body.tpl add the follow at the appropriate part:

Code: Select all

{postrow.WOWINFO}
Guild: {postrow.GUILD}

And here's the database structure - imported from the warcraft realms CSV files:
CREATE TABLE ss_players (
player_id int(11) NOT NULL auto_increment,
CharName varchar(30) NOT NULL default '',
Race varchar(30) NOT NULL default '',
Class varchar(20) NOT NULL default '',
Level smallint(6) NOT NULL default '0',
LastSeen varchar(10) NOT NULL default '',
GuildRank varchar(30) NOT NULL default '',
guildid int(11) NOT NULL default '0',
PRIMARY KEY (player_id)
) TYPE=MyISAM

CREATE TABLE ss_guild (
gid int(11) NOT NULL default '0',
name varchar(100) NOT NULL default '',
master varchar(50) NOT NULL default '',
faction varchar(30) NOT NULL default '',
PRIMARY KEY (gid)
) TYPE=MyISAM;

[Rollie]

Ah, okay, so you made everyone pick usernames that matched their character name then?

[Turiel]

Yeah, if their board username doesn't match their charname then nothing will show up. Also, the player has to be in a guild or else there won't be any data for him (since we get all our data from the guild CSV files available here).