I realize this is probably all old news, but here's my use of your efforts:
http://horderlies.com/index.php?id=members
The WCR link is in the middle section, i was moving the tables around to decide where I liked which parts where.. thats where it ended up, but it is there (the credit)

Ok, i am encountering a problem.
The "Guild at a glance" code works, the "Guild Activity" code works (as in they both reflect the correct # of guild members).
However, the Member List isn't working properly with updating new members or member levels..
http://horderlies.com/index.php?id=members

Hey Thanks a bunch!
My next goal is to try to get the report to color code each table row (or the text within, rather) based on the Class.
my php is no where near that advanced but I am sure I can figure it out from similar situations on other forums.

Ah, if it weren't for gaming, i'd just be a useless tool.
but for now, i'm a wrench being used as a hammer. _________________Please, Don't squeeze the Shaman!

I need help, I have tried and tried to get your script to work, here is ther errors I am getting:

File Last Updated at : 12/31/69 17:00:00

Warning: fopen(): URL file-access is disabled in the server configuration in /home/content/S/O/L/SOLGuild/html/roster.php on line 44

Warning: fopen(http://www.warcraftrealms.com/exports/status.txt): failed to open stream: no suitable wrapper could be found in /home/content/S/O/L/SOLGuild/html/roster.php on line 44
Unable to open status file.

How do I fix this, what did I do wrong?

[quote="Hybuir"]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/

I figure since I used Rollie's code as a base, I'd post here what I ended up with.

First, I split it out into two files, rostergrab.php which checks for new status file, and roster.php which is the main roster, and I just cron rostergrab.php. I don't really need my page hitting warcraftrealms everytime someone hits the page, so I wanted it separate.

So for rostergrab.php, I have this (which is just Rollie's code with the display part ripped out):

Code:

<?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

Items to note if you want to use this is you'll have to change the rankorder value to list the ranks your guild has, and the order you want them displayed per class. Also, if you're alliance, you'll need to change the pvpranklist to the alliance ranks.

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.

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.

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._________________

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.

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.

Don't know if there's even a demand for this anymore but... I was bored, what can I say? I expanded my 'Guild at a Glance' code to include 70's.

Step 1. Make an php file (index.php) to include this code. Make sure you update your '$guild_id' '$guild_name' '$server_id' and '$server_name' variables to reflect the correct information.
Full Code at: http://juniordimas.com/fold/index.php.txt

Step 2. Make a txt file called 'guildroster.txt' and just have it completely empty

Step 3. Make a txt file called 'status.txt' and have it just have 6 Zeros (000000)

Thanks for your work. The CSV file and corresponding code is very useful. The only question I've got and I didn't see it asked, yet (though I may have missed it) is has anyone addressed a purge of the data so that only current guild members are shown in the roster?