Roster Master
By: Rex "SaintPeter" Schrader
rostermaster@bellumaeternus.com

About
Roster Master provides a method to integrate your EverQuest II Guild Roster into your personal site.  It works by "Web-Scraping" Sony's site, parsing the data, and storing it in a local database. 
 
General Features
Single and Double Column display sorting
- Sort by clicking on a column header, or select two columns from a drop-down (IE: Class, then Level)
- Reversable Sorting for both sort modes

SQL or Flatfile (.csv) backend cache
- Fast display since you don't have to hit Sony's site every time.
- User Configurable cache refresh time
 
Update Logging for all fields
- Have a record of changes in all fields, every user add, and every user deletion.
 
Error Messages
- Explanatory error messages for common failures.
- Clean exits
 
Easy to Setup and Install
- FTP, Set Permissions and go!

PHP based SQL install
- No .sql file to import, just run the installer.
 
Fully Documented, Clean Code
- All functions completely commented
- Detailed install and modification documents

Forum Software/phpNuke Required Features:
Support for popular Forums for login/admin authentication
- phpBB 2.x.x
- Invision Power Board 2.x.x

SQL Table Prefix Configuration
- Run multiple instances of Roster Master out of one database
 
Username to Character Name Mapping
- Allow your users to "Claim" their characters.
- Manage and assign your user's character claims
 
Character "Type"
- Users may specify if their character is Primary, Secondary, or Utility

Files
Stand Alone

Roster Master v1.0.4 (9/12/05)

phpNuke

Roster Master For phpNuke v1.2.2 (9/21/05)  

CPG Nuke/Dragonfly
(Port maintained by DarkGrue)
Roster Master for Dragonfly 2.0.0 (9/17/05)

PostNuke
(Port maintained by Topiatic)
PostNuke 1.0b (Link to Release Post) (6/4/05)
 
 
Notes
This the Release version of Roster Master.  It has been fairly extensivly tested.
Please post any errors here, or e-mail me at rostermaster@bellumaeternus.com
 
Future Features
In the other thread there were some requests for additional features.  I am planning on adding the following features -
Username Mapping (IE: Website username next to owned characters)  Done!
- Class/Level Breakout Graph (similar to this)
- Possibly phpNuke integration Done!
- Features that you reasonably request
 
Demo Sites
Stand Alone Demo Site
phpNuke Demo Module

Getting Assistance
Best Resource: >> Everquest II Official Forums Thread <<
I check this thread on a regular basis.  Questions asked here will be answered VERY quickly.

I can also be contacted at: rostermaster@bellumaeternus.com

I am happy to offer you any assistance I can in getting my code to work for you.  Here are some 'Best Practices' you can follow that will help me help you best.

 
Before you ask:
Read this Article - How to ask questions "The Smart Way"

Did you read the included documentation?

Have you read through this thread to see if your problem is mentioned?
 
When Asking:
Make sure to include (at very least)
- The Version and version number of Roster Master you are using (Stand Alone v0.8.1/phpNuke 1.0.0)
- What configuration options you are using.  IE: $config['use_database']
  (For your security, don't post the complete rm_config.php file, since it might contain your SQL connection information)
- What exact error message(s) you are getting?  Copy and paste 'em into the message
- What you've already tried.

Fair Warning:
Failure to follow these Best Practices may result in snarky, rude, or no response.  I have spent a lot of my personal time creating an application that I don't use.  I expect you to respect my contribution by taking a moment of your time to write a clear and complete problem description. 

Webpage Copyright 2005 Rex "SaintPeter" Schrader
Roster Master Copyright 2005 Rex "SaintPeter Schrader - Released under GPL
Hosting Provided by: Bellum Aeternus