Rollie wrote:When you get it up and running, drop a link so I can check out your handywork!
Hybuir wrote:Heya everyone, I've gone ahead and made a 'condensed' version that gives critical information to the user without having to decypher the whole guild list. I've implemented the base code, with a couple of quirks. Any feedback would be greatly appreciated. Working example at http://reapers.ws/guild_at_a_glance/
Code: Select all
<?php
//
// Rostergrab.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
//
$local_directory = "download/"; // this is the directory where your local files
// will be written to and read from. Make sure
// you have WRITE privileges on this directory
$guild_id = 18447; // get this number from the link posted on the
// guilddisplay.php page
//
// 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 );
echo 'Local status file reads : ' . strftime("%m/%d/%y %H:%M:%S",$current_timestamp) . '<br>';
}
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 );
echo 'Remote status file reads : ' . strftime("%m/%d/%y %H:%M:%S",$remote_timestamp) . '<br>';
}
fclose( $infile ); // close the remote status file
if( $remote_timestamp - $current_timestamp > 79200 ) // 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.csv";
$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);
}
?>Code: Select all
<?php
// Author: Skraggy of Aggramar, based on Rollie's sample code
$local_directory = "download/"; // this is the directory where your local files
// will be written to and read from. Make sure
// you have WRITE privileges on this directory
$rankorder = array('High Champion','Chief','Chieftan','Elder','Tribal Guardian','Oathsworn','Tribesman','Brave','Officer Alt','Tribealt','Unknown');
$classorder = array('Druid','Hunter','Mage','Priest','Rogue','Shaman','Warlock','Warrior');
// Read in roster file
$filename = $local_directory . "guildroster.csv";
$infile = fopen ($filename, "r");
if (!$infile)
{
echo "<p>Unable to open local roster file.<br>";
exit;
}
// Read header
$header = fgetcsv($infile, 4096, ",");
// Populate Guild List array
while (($data = fgetcsv($infile, 4096, ",")) !== FALSE) {
if (isset($header)) {
foreach ($header as $key=>$heading) {
$row[$heading]=(isset($data[$key])) ? $data[$key] : '';
}
$guildlist[]=$row;
}
}
fclose($infile);
while (list($key,$class) = each($classorder)) {
printClass($class,$guildlist,$rankorder);
}
// don't forget our credit link =)
echo "<p> Guild data provided by <a href='http://www.warcraftrealms.com/'>WarcraftRealms.com</a>.</p>";
function printClass($classname,$guildarray,$ranks) {
while (list($key,$member) = each($guildarray)) {
if ($member['Class'] == $classname) {
$classlist[] = $member;
}
}
$num = count($classlist);
echo "<h3><a name=\"$classname\">$classname</a>: $num</h3>\n";
echo '<table width="640" bgcolor="#5A1F0C"><tr><th>Name</th><th>Race</th><th>Level</th><th>Guild Rank</th><th>PvP Rank</th><th>Status</th></tr>';
foreach ($ranks as $key=>$rank) {
$ranklist = getRankList($rank,$classlist);
if ($ranklist) {
outputTable($ranklist);
}
}
echo '</table>';
return;
}
function getRankList($rankname,$classarray) {
$return = false;
while (list($key,$member) = each($classarray)) {
if ($member['GuildRank'] == $rankname) {
$return[] = $member;
}
}
return $return;
}
function outputTable($sortedclass) {
while (list($key,$member) = each($sortedclass)) {
list($name,$race,$class,$level,$lastseen,$guildrank,$pvprank) = array_values($member);
//Activity threshold variables in DAYS
$idle = 14;
$inactive = 30;
$interval = ((time() - strtotime($lastseen))/86400);
$status = '<font color="red">Inactive</font>';
if ($interval <= $idle) {
$status = '<font color="#ccffcc">Active</font>';
}
else if ($interval > $idle && $interval < $inactive) {
$status = '<font color="#ffcc99">Idle</font>';
}
// Horde Ranks
$pvpranklist = array('','','','','', 'Scout', 'Grunt', 'Sergeant', 'Senior Sergeant', 'First Sergeant', 'Stone Guard', 'Blood Guard', 'Legionnaire', 'Centurion', 'Champion', 'Lieutenant General', 'General', 'General', 'Warlord', 'High Warlord');
if (!$pvprank) $pvprank = '000004';
$pvptitle = $pvpranklist[intval($pvprank)];
echo '<tr><td>' . $name . '</td><td>' . $race . '</td><td>' . $level . '</td><td>' . $guildrank . '</td><td>' . $pvptitle . '</td><td>' . $status . '</td></tr>';
}
return;
}
?>
If your site is hosted at 1&1 as well as the database, you should have no problem using any code to put information into and access the database.tszeusts wrote:I started to create a table in a MYSQL database hosted by 1&1, but noticed the disclaimer says the database is behind a firewall. Would I be able to use the sample code you have been so generous on providing? I am wondering if I create this database and put the table on my site whether or not it will even work, since 1&1 is hosting for me.
Oh ok I think I am getting it now. Thanks for the reply Skrag- I'm happy to admit I am venturing into web design for the first time if you can't tell. Can you clarify then, in fact, the code is on the page itself? I'll keep reading up, but appreciate any additional help you could provide. From this point forward I plan on using coffecup's free web editor. It seems to provide everything I will need to publish the site I want.If your site is hosted at 1&1 as well as the database, you should have no problem using any code to put information into and access the database.
You would only have a problem if you tried to access the database directly from a web site hosted elsewhere.
None of the code in this thread requires a database however (it's all done in flat files) unless that's functionality you are planning on adding to your own.
Code: Select all
$local_directory = "download/"; // this is the directory where your local files
// will be written to and read from. Make sure
// you have WRITE privileges on this directory 
Now if we can only see your work.. but its in a Member's only sectionrootuser wrote:http://sos.fearthemike.com/roster.php
