Code: Select all
<?php
//
// Rostertest.php
//
// Sample guild export downloader and display
// You may use this script as you wish. This is only some sample code
// provided to help get a jumpstart!
//
// Created: 1/27/2005
//
// Author: Cooper Sellers aka Rollie - Bloodscalp
// A Tinkering Called: Guild at a Glance
// Tinkerer: Junior Dimas aka Hybuir - Boulderfist <Reapers> cdimas@gmail.com
// Note: this code is originally written for a Horde guild. To change it to
// an alliance guild, trade off Shaman variables with the Paladin name.
$local_directory = ""; // this is the directory where your local files
// will be written to and read from. Make sure
// you have WRITE priveledges on this directory
$guild_id = 146466; // get this number from the link posted on the
// guilddisplay.php page
$guild_name = "Reapers"; // Variables to link back to your guilds full info
$server_id = "52"; // on WarcraftRealms.com
$server_name = "Boulderfist";
$PHP_SELF = $_SERVER["PHP_SELF"]; //To show Source Code
$endr = "<a href=$PHP_SELF?source>Get the Source Code</a>";
if (isset($_GET["source"])) { // source display
echo $endr;
highlight_file(__FILE__);
die();
}
//
// Remember to check the status file so that you are not pulling data
// more than once per day
//
$localstatusfile = $local_directory . "status.txt";
$infile = fopen ($localstatusfile, "r");
$current_timestamp = 0;
if (!$infile)
{
echo "<p>No status file available, assuming this is the first run<br>";
}
else
{
// read our status file time
$buffer = fgets($infile, 4096);
$current_timestamp = trim( $buffer );
}
fclose( $infile ); // close our local status file
$filename = "http://www.warcraftrealms.com/exports/status.txt";
$infile = fopen ($filename, "r"); // open remote status file
if (!$infile)
{
echo "<p>Unable to open status file.<br>";
exit;
}
$remote_timestamp = 0;
if(!feof ($infile)) // only 1 read should be needed for the status file
{
$buffer = fgets($infile, 4096);
$remote_timestamp = trim( $buffer );
}
fclose( $infile ); // close the remote status file
if( $remote_timestamp - $current_timestamp > 86400 ) // 1 day = 60*60*24
{
//
// We can do a full get
//
// write our new status file
$outfilename = $local_directory . "status.txt";
$outfile = fopen($outfilename, "w");
if( !$outfile )
{
echo "<p>Unable to open save file => " . $outfilename . "<br>";
exit;
}
fputs($outfile, $buffer);
fclose($outfile);
//
// Now get our guild roster file
//
$filename = 'http://www.warcraftrealms.com/exports/guildexport.php?guildid=' . $guild_id;
$infile = fopen ($filename, "r");
if (!$infile)
{
echo "<p>Unable to open remote file.<br>\n";
exit;
}
$outfilename = $local_directory . "guildroster.txt";
$outfile = fopen($outfilename, "w");
if( !$outfile )
{
echo "<p>Unable to open save file => " . $outfilename . "<br>\n";
exit;
}
while (!feof ($infile))
{
$buffer = fgets($infile, 4096);
fputs($outfile, $buffer);
}
fclose($outfile);
fclose($infile);
}
//
// Now let's just output our roster as it's given
//
$filename = $local_directory . "guildroster.txt";
$infile = fopen ($filename, "r");
if (!$infile)
{
echo "<p>Unable to open local roster file.<br>";
exit;
}
//Do one read to get the header
$buffer = fgets($infile, 4096);
//Initiallize all counts
$total_count=0;
$druid_count=0;
$druid_mount=0;
$hunter_count=0;
$hunter_mount=0;
$mage_count=0;
$mage_mount=0;
$priest_count=0;
$priest_mount=0;
$rogue_count=0;
$rogue_mount=0;
$shaman_count=0;
$shaman_mount=0;
$warlock_count=0;
$warlock_mount=0;
$warrior_count=0;
$warrior_mount=0;
$level_count=0;
// read the entries
while (!feof ($infile))
{
$buffer = fgets($infile, 4096);
list( $name, $race, $class, $level, $last_seen, $rank ) = explode(",",$buffer);
$total_count = $total_count + 1;
$level_count = $level_count + $level;
if ($class == "Druid")
{
$druid_count = $druid_count + 1;
if ($level>="40") { $druid_mount = $druid_mount + 1; }
}
else if ($class == "Hunter")
{
$hunter_count = $hunter_count + 1;
if ($level>="40") { $hunter_mount = $hunter_mount + 1; }
}
else if ($class == "Mage")
{
$mage_count = $mage_count + 1;
if ($level>="40") { $mage_mount = $mage_mount + 1; }
}
else if ($class == "Priest")
{
$priest_count = $priest_count + 1;
if ($level>="40") { $priest_mount = $priest_mount + 1; }
}
else if ($class == "Rogue")
{
$rogue_count = $rogue_count + 1;
if ($level>="40") { $rogue_mount = $rogue_mount + 1; }
}
else if ($class == "Warlock")
{
$warlock_count = $warlock_count + 1;
if ($level>="40") { $warlock_mount = $warlock_mount + 1; }
}
else if ($class == "Warrior")
{
$warrior_count = $warrior_count + 1;
if ($level>="40") { $warrior_mount = $warrior_mount + 1; }
}
else if ($class == "Shaman") // Can be changed for Paladins
{
$shaman_count = $shaman_count + 1;
if ($level>="40") { $shaman_mount = $shaman_mount + 1; }
}
}
// Start of finding out the percentages of the classess
$druid_per = round(($druid_count/$total_count) * 100,1);
$hunter_per = round(($hunter_count/$total_count) * 100,1);
$mage_per = round(($mage_count/$total_count) * 100,1);
$priest_per = round(($priest_count/$total_count) * 100,1);
$rogue_per = round(($rogue_count/$total_count) * 100,1);
$shaman_per = round(($shaman_count/$total_count) * 100,1);
$warlock_per = round(($warlock_count/$total_count) * 100,1);
$warrior_per = round(($warrior_count/$total_count) * 100,1);
// Find out the percentages of players with mount capabilities
$druid_mount_per = round(($druid_mount/$druid_count)*100);
$hunter_mount_per = round(($hunter_mount/$hunter_count)*100);
$mage_mount_per = round(($mage_mount/$mage_count)*100);
$priest_mount_per = round(($priest_mount/$priest_count)*100);
$rogue_mount_per = round(($rogue_mount/$rogue_count)*100);
$shaman_mount_per = round(($shaman_mount/$shaman_count)*100);
$warlock_mount_per = round(($warlock_mount/$warlock_count)*100);
$warrior_mount_per = round(($warrior_mount/$warrior_count)*100);
$total_mount = $druid_mount + $hunter_mount + $mage_mount + $priest_mount + $rogue_mount + $shaman_mount + $warlock_mount + $warrior_mount;
$total_mount_per = round(($total_mount/$total_count)*100);
// The reason why there are so many echo's is because I just copied and pasted the code for the table from DreamWeaver
// I know that it isn't the best code, but it makes the people that are anal about tag placement very happy.
echo '<table bordercolor="#000000" border="1px">';
echo ' <tr>';
echo ' <td colspan="4"> <div align="center">Guild at a Glance - <a href=http://www.warcraftrealms.com/census.php?guildid=' . $guild_id . ' target=_guild>'. $guild_name . '</a> - <a href=http://www.warcraftrealms.com/census.php?serverid=' . $server_id . ' target=_server>' . $server_name .'</a> </div></td>';
echo ' </tr><tr>';
echo ' <td> <div align="center">Class</div></td>';
echo ' <td> <div align="center">Count</div></td>';
echo ' <td bordercolor="#000000"> <div align="center">Percent</div></td>';
echo ' <td> <div align="center">Mount Count</div></td>';
echo ' </tr><tr>';
echo ' <td>Druid</td>';
echo ' <td> <div align="center">' . $druid_count . ' </div></td>';
echo ' <td> <div align="center">' . $druid_per . ' </div></td>';
echo ' <td> <div align="center">' . $druid_mount . ' (' . $druid_mount_per . '%)</div></td>';
echo ' </tr><tr>';
echo ' <td>Hunter</td>';
echo ' <td> <div align="center">' . $hunter_count . ' </div></td>';
echo ' <td> <div align="center">' . $hunter_per . ' </div></td>';
echo ' <td> <div align="center">' . $hunter_mount . ' (' . $hunter_mount_per . '%)</div></td>';
echo ' </tr><tr>';
echo ' <td>Mage</td>';
echo ' <td> <div align="center">' . $mage_count .'</div></td>';
echo ' <td> <div align="center">' . $mage_per .'</div></td>';
echo ' <td> <div align="center">' . $mage_mount . ' (' . $mage_mount_per . '%)</div></td>';
echo ' </tr><tr>';
echo ' <td>Priest</td>';
echo ' <td> <div align="center">' . $priest_count .'</div></td>';
echo ' <td> <div align="center">' . $priest_per .'</div></td>';
echo ' <td> <div align="center">' . $priest_mount . ' (' . $priest_mount_per . '%)</div></td>';
echo ' </tr><tr>';
echo ' <td>Rogue</td>';
echo ' <td> <div align="center">' . $rogue_count . '</div></td>';
echo ' <td> <div align="center">' . $rogue_per . '</div></td>';
echo ' <td> <div align="center">' . $rogue_mount . ' (' . $rogue_mount_per . '%)</div></td>';
echo ' </tr><tr>';
echo ' <td>Shaman</td>';
echo ' <td> <div align="center">' . $shaman_count . '</div></td>';
echo ' <td> <div align="center">' . $shaman_per . '</div></td>';
echo ' <td> <div align="center">' . $shaman_mount . ' (' . $shaman_mount_per . '%)</div></td>';
echo ' </tr><tr>';
echo ' <td>Warlock</td>';
echo ' <td> <div align="center">' . $warlock_count . ' </div></td>';
echo ' <td> <div align="center">' . $warlock_per . '</div></td>';
echo ' <td> <div align="center">' . $warlock_mount . ' (' . $warlock_mount_per . '%)</div></td>';
echo ' </tr><tr>';
echo ' <td>Warrior</td>';
echo ' <td> <div align="center">' . $warrior_count . ' </div></td>';
echo ' <td> <div align="center">' . $warrior_per . ' </div></td>';
echo ' <td> <div align="center">' . $warrior_mount . ' (' . $warrior_mount_per . '%)</div></td>';
echo ' </tr><tr>';
echo ' <td><div align="right"><strong>Total</strong></div></td>';
echo ' <td><div align="center"><strong> ' . $total_count . ' </strong></div></td>';
echo ' <td><div align="center"> </div></td>';
echo ' <td><div align="center"><strong> ' . $total_mount . ' (' . $total_mount_per . '%)</strong></div></td>';
echo ' </tr> <tr valign="bottom">';
echo ' <td colspan="4"> <div align="center"><font size="1">Updated ' . strftime("%m/%d/%y %H:%M:%S",$remote_timestamp) . '. Guild data provided by <a href=http://www.warcraftrealms.com target=_new>WarcraftRealms.com</a>.</font></div></td>';
echo ' </tr>';
echo '</table>';
echo $endr;
?>Code: Select all
<?php
//
// Rostertest.php
//
// Sample guild export downloader and display
// You may use this script as you wish. This is only some sample code
// provided to help get a jumpstart!
//
// Created: 1/27/2005
//
// Author: Cooper Sellers aka Rollie - Bloodscalp
//
//
// Now let's just output our roster as it's given
//
$filename = $local_directory . "guildroster.txt";
$infile = fopen ($filename, "r");
if (!$infile)
{
echo "<p>Unable to open local roster file.<br>";
exit;
}
// do one read to get the header
$buffer = fgets($infile, 4096);
// read the entries
echo '<table style="margin-left: 180px; margin-right: auto; margin-top: 230px; text-align: left; width: 80%; height: 60px;" border="1" cellpadding="0" cellspacing="0"><tbody><tr><td style="font-weight: bold; font-family: Verdana;"><small>Name</small></td><td style="font-weight: bold; font-family: Verdana;"><small>Rasse</small></td><td style="font-weight: bold; font-family: Verdana;"><small>Klasse</small></td><td style="font-weight: bold; font-family: Verdana;"><small>Level</small></td><td style="font-weight: bold; font-family: Verdana;"><small>Zuletzt gesehen</small></td><td style="font-weight: bold; font-family: Verdana;"><small>Rang</small></td></tr><tr>';
while (!feof ($infile))
{
$buffer = fgets($infile, 4096);
list( $name, $race, $class, $level, $last_seen, $rank ) = explode(",",$buffer);
$member_count++;
echo '<tr><td style="font-family: Verdana;"><small>' . $name . '</small></td><td style="font-family: Verdana;"><small>' . $race . '</small></td><td style="font-family: Verdana;"><small>' . $class . '</small></td><td style="font-family: Verdana;"><small>' . $level . '</small></td><td style="font-family: Verdana;"><small>' . $last_seen . '</small></td><td style="font-family: Verdana;"><small>' . $rank . '</small></td></tr>';
}
echo '</table>';
echo '<table class="content"><tr><td class="topcontent"><center>Statistics</center><tr><td class="content">';
echo "Total Members: ";
echo "$member_count";
echo '</center>';
echo "Guild data provided by <a href='http://www.warcraftrealms.com/'>WarcraftRealms.com</a>.";
echo '</td></tr></table>';
?>
[/url]
Code: Select all
// read the entries
echo '<table style="margin-left: 180px; margin-right: auto; margin-top: 230px; text-align: left; width: 80%; height: 60px;" border="1" cellpadding="0" cellspacing="0"><tbody><tr><td style="font-weight: bold; font-family: Verdana;"><small>Name</small></td><td style="font-weight: bold; font-family: Verdana;"><small>Race</small></td><td style="font-weight: bold; font-family: Verdana;"><small>class</small></td><td style="font-weight: bold; font-family: Verdana;"><small>Level</small></td><td style="font-weight: bold; font-family: Verdana;"><small>Last seen</small></td><td style="font-weight: bold; font-family: Verdana;"><small>Rank</small></td></tr><tr>';ThanksKeitaran wrote:Looks realy nice Hybuir thanks a lot i'll add it to my site
Code: Select all
<?php
//
// Rostertest.php
//
// Sample guild export downloader and display
// You may use this script as you wish. This is only some sample code
// provided to help get a jumpstart!
//
// Created: 1/27/2005
//
// Author: Cooper Sellers aka Rollie - Bloodscalp
// A Tinkering Called: True Guild Colors :-D
// Tinkerer: Junior Dimas aka Hybuir - Boulderfist <Reapers> cdimas@gmail.com
$local_directory = ""; // this is the directory where your local files
// will be written to and read from. Make sure
// you have WRITE priveledges on this directory
$guild_id = 146466; // get this number from the link posted on the
// guilddisplay.php page
$guild_name = "Reapers"; // Variables to link back to your guilds full info
$server_id = "52"; // on WarcraftRealms.com
$server_name = "Boulderfist";
$PHP_SELF = $_SERVER["PHP_SELF"]; //To show Source Code
$endr = "<a href=$PHP_SELF?source>Get the Source Code</a>";
if (isset($_GET["source"])) { // source display
echo $endr;
highlight_file(__FILE__);
die();
}
//
// Remember to check the status file so that you are not pulling data
// more than once per day
//
$localstatusfile = $local_directory . "status.txt";
$infile = fopen ($localstatusfile, "r");
$current_timestamp = 0;
if (!$infile)
{
echo "<p>No status file available, assuming this is the first run<br>";
}
else
{
// read our status file time
$buffer = fgets($infile, 4096);
$current_timestamp = trim( $buffer );
}
fclose( $infile ); // close our local status file
$filename = "http://www.warcraftrealms.com/exports/status.txt";
$infile = fopen ($filename, "r"); // open remote status file
if (!$infile)
{
echo "<p>Unable to open status file.<br>";
exit;
}
$remote_timestamp = 0;
if(!feof ($infile)) // only 1 read should be needed for the status file
{
$buffer = fgets($infile, 4096);
$remote_timestamp = trim( $buffer );
}
fclose( $infile ); // close the remote status file
if( $remote_timestamp - $current_timestamp > 86400 ) // 1 day = 60*60*24
{
//
// We can do a full get
//
// write our new status file
$outfilename = $local_directory . "status.txt";
$outfile = fopen($outfilename, "w");
if( !$outfile )
{
echo "<p>Unable to open save file => " . $outfilename . "<br>";
exit;
}
fputs($outfile, $buffer);
fclose($outfile);
//
// Now get our guild roster file
//
$filename = 'http://www.warcraftrealms.com/exports/guildexport.php?guildid=' . $guild_id;
$infile = fopen ($filename, "r");
if (!$infile)
{
echo "<p>Unable to open remote file.<br>\n";
exit;
}
$outfilename = $local_directory . "guildroster.txt";
$outfile = fopen($outfilename, "w");
if( !$outfile )
{
echo "<p>Unable to open save file => " . $outfilename . "<br>\n";
exit;
}
while (!feof ($infile))
{
$buffer = fgets($infile, 4096);
fputs($outfile, $buffer);
}
fclose($outfile);
fclose($infile);
}
//
// Now let's just output our roster as it's given
//
$filename = $local_directory . "guildroster.txt";
$infile = fopen ($filename, "r");
if (!$infile)
{
echo "<p>Unable to open local roster file.<br>";
exit;
}
//Do one read to get the header
$buffer = fgets($infile, 4096);
//Activity threshold variables in DAYS
$idle = 14; //before $idle days you are active
$inactive = 30; //after $idle days and before $inacive day you are idle
//after $inacive days you are... uhm... inacive
$seconds_in_a_day = 24*60*60; //self explanitory.
//Initiallize all counts
$total_count=0;
$inactive_count=0;
$inactive_01_19=0;
$inactive_20_39=0;
$inactive_40_59=0;
$inactive_60=0;
$idle_count=0;
$idle_01_19=0;
$idle_20_39=0;
$idle_40_59=0;
$idle_60=0;
$active_count=0;
$active_01_19=0;
$active_20_39=0;
$active_40_59=0;
$active_60=0;
// read the entries
while (!feof ($infile))
{
$buffer = fgets($infile, 4096);
list( $name, $race, $class, $level, $last_seen, $rank ) = explode(",",$buffer);
$interval = ((time() - strtotime($last_seen))/86400); //takes the interval in seconds and converts into days
$total_count = $total_count + 1;
if ($interval <= $idle) {
$active_count = $active_count + 1;
if ( $level < 20 ) {
$active_01_19 = $active_01_19 + 1;
}
else if ( $level <= 39 ) {
$active_20_39 = $active_20_39 + 1;
}
else if ( $level <=59 ) {
$active_40_59 = $active_40_59 + 1;
}
else if ( $level == 60 ) {
$active_60 = $active_60 + 1;
}
}
else if ( $interval > $idle && $interval < $inactive) {
$idle_count = $idle_count + 1;
if ( $level < 20 ) {
$idle_01_19 = $idle_01_19 + 1;
}
else if ( $level <= 39 ) {
$idle_20_39 = $idle_20_39 + 1;
}
else if ( $level <=59 ) {
$idle_40_59 = $idle_40_59 + 1;
}
else if ( $level == 60 ) {
$idle_60 = $idle_60 + 1;
}
}
else if ( $interval > $inactive ) {
$inactive_count = $inactive_count + 1;
if ( $level < 20 ) {
$inactive_01_19 = $inactive_01_19 + 1;
}
else if ( $level <= 39 ) {
$inactive_20_39 = $inactive_20_39 + 1;
}
else if ( $level <=59 ) {
$inactive_40_59 = $inactive_40_59 + 1;
}
else if ( $level == 60 ) {
$inactive_60 = $inactive_60 + 1;
}
}
}
echo ' <table bordercolor="#000000" border="1px">';
echo ' <tr>';
echo ' <td colspan="7"><div align="center">Guild True Colors - <a href=http://www.warcraftrealms.com/census.php?guildid=' . $guild_id . ' target=_guild>'. $guild_name . '</a> - <a href=http://www.warcraftrealms.com/census.php?serverid=' . $server_id . ' target=_server>' . $server_name .'</a> </div></td>';
echo ' </tr>';
echo ' <tr><td><div align="center"><b>Activity</b></div></td><td><div align="center"><b>1-19</b></div></td><td><div align="center"><b>20-39</b></div></td><td><div align="center"><b>40-59</b></div></td><td><div align="center"><b>60</b></div></td><td><div align="center"><b>Percent</b></div></td><td><div align="center"><b>#</b></div></td></tr>';
echo ' <tr>';
echo ' <td style="BACKGROUND-COLOR: red">Inactive</td>';
echo ' <td style="BACKGROUND-COLOR: red"><div align="center">' . $inactive_01_19 . '</div></td>';
echo ' <td style="BACKGROUND-COLOR: red"><div align="center">' . $inactive_20_39 . '</div></td>';
echo ' <td style="BACKGROUND-COLOR: red"><div align="center">' . $inactive_40_59 . '</div></td>';
echo ' <td style="BACKGROUND-COLOR: red"><div align="center">' . $inactive_60 . '</div></td>';
echo ' <td style="BACKGROUND-COLOR: red"><div align="center">' . round(($inactive_count/$total_count)*100) . '%</div></td>';
echo ' <td style="BACKGROUND-COLOR: red"><div align="center">' . $inactive_count . '</div></td>';
echo ' </tr>';
echo ' <tr>';
echo ' <td style="BACKGROUND-COLOR: #ffcc99">Idle</td>';
echo ' <td style="BACKGROUND-COLOR: #ffcc99"><div align="center">' . $idle_01_19 . '</div></td>';
echo ' <td style="BACKGROUND-COLOR: #ffcc99"><div align="center">' . $idle_20_39 . '</div></td>';
echo ' <td style="BACKGROUND-COLOR: #ffcc99"><div align="center">' . $idle_40_59 . '</div></td>';
echo ' <td style="BACKGROUND-COLOR: #ffcc99"><div align="center">' . $idle_60 . '</div></td>';
echo ' <td style="BACKGROUND-COLOR: #ffcc99"><div align="center">' . round(($idle_count/$total_count)*100) . '%</div></td>';
echo ' <td style="BACKGROUND-COLOR: #ffcc99"><div align="center">' . $idle_count . '</div></td>';
echo ' </tr>';
echo ' <tr>';
echo ' <td style="BACKGROUND-COLOR: #ccffcc">Active</td>';
echo ' <td style="BACKGROUND-COLOR: #ccffcc"><div align="center">' . $active_01_19 . '</div></td>';
echo ' <td style="BACKGROUND-COLOR: #ccffcc"><div align="center">' . $active_20_39 . '</div></td>';
echo ' <td style="BACKGROUND-COLOR: #ccffcc"><div align="center">' . $active_40_59 . '</div></td>';
echo ' <td style="BACKGROUND-COLOR: #ccffcc"><div align="center">' . $active_60 . '</div></td>';
echo ' <td style="BACKGROUND-COLOR: #ccffcc"><div align="center">' . round(($active_count/$total_count)*100) . '%</div></td>';
echo ' <td style="BACKGROUND-COLOR: #ccffcc"><div align="center">' . $active_count . '</div></td>';
echo ' </tr>';
echo ' <tr>';
echo ' <td colspan="5"> </td><td><b><div align="right">Total</b></div></td><td><b>' . $total_count . '</b></td>';
echo ' </tr>';
echo ' <tr>';
echo ' <td colspan="7"> <div align="center"><font size="1">Updated ' . strftime("%m/%d/%y %H:%M:%S",$remote_timestamp) . '. Guild data provided by <a href=http://www.warcraftrealms.com target=_new>WarcraftRealms.com</a>.</font></div></td>';
echo ' </tr>';
echo ' </table>';
echo ' <small>* Active is defined as last login within ' . $idle . ' days.</small><br>';
echo ' <small>* Idle is defined as last login between ' . $idle . ' and ' . $inactive .' days.</small><br>';
echo ' <small>* Inactive is defined as last login after ' . $inactive . ' days.</small><br>';
echo $endr;
?> 
