Vanguard Guild Roster Integration Hack
 

WHAT IS THIS?
This plugin integrates your guild's data obtained from vgplayers.station.sony.com with vBulletin

FEATURES:

• Automatically updates your guild's data once per hour. No more manually downloading the XML or CSV files.
• Allows you to specify the text for the headers of guild roster display
• Allows you to turn off certain columns is you so desire
• Ability to sort on most data... i.e. Name, Class, Level, Crafting Level, etc.

INSTALLATION:

Easy! Takes only a few minutes:

1. Edit line 27 of vgroster_import.php to include your guild's ID on vgplayers.station.sony.com
2. The line should look like this:
   
   Code:

   ---

   $file ="http://vgplayers.station.sony.com/includes/guilds/guildsRosterCSV.vm?guildId=123456789";

   ---

3. Upload vgroster.php to the root of your forums. Upload vgroster_import.php to /includes/cron/
4. Import the xml into products. (AdminCP -> Plugin System -> Manage Products -> Add/Import Product)
5. Edit the options. (AdminCP -> vBulletin Options -> Vanguard Roster Settings)
   • Enter in the information specific to your guild... and the text you'd like displayed for the headers.
   • Also gives you the ability to turn off certain columns if you'd like.
6. Run the Scheduled Task once to populate the database with your guilds information. The task will run once per hour afterwards.
   (AdminCP -> Scheduled Task Manager -> Vanguard Roster Update -> Run Now)
7. View your roster at http://www.yourwebsite.org/yourforums/vgroster.php

You're done!



NOTE TO USER:
I am VERY new to vBulletin and .php coding. This is my first hack. I'll do my best to support it the best I can. I know if Sigil changes their format of the .csv file, we'll all need to do a little more work on it. Hope you enjoy this!

Please be gentle with your comments. :D

UPDATES:
Version 1.0.2: Initial Release (March 14, 2007)






This hack is created for your use free of charge. No payment is requested. However, if you would like to donate money for the work I put in to this hack, a donation would show your appreciation.

Reserved

Very nicely done. Installed. I've been working on something similiar myself but this far surpasses my plans. You figured out a way to do a few things I was stuck on. I'm going to play with it a little bit to get it the way I want.

My plans at the moment:
1) Get the vgroster and memberlist connected. I'd like to have a column for usernames and then only display users on the roster if they have an account on the forum. They must also be in one of the following usergroups (5,6,9,10) to appear on the roster. Having a roster identical to VGPlayers means I could have just gone to VGPlayers instead; no offense.
2) Add a class counter at the bottom.

I already have these things working on my Showroster Hack, but I haven't been able to get the sorting to work. Plus, it is still tied to showgroups which I haven't gotten around to maniplulating yet. I just need to figure a way to merge this with mine. I really like what you put together. Thanks!

Feel free to take a look at what I have for any idea's. My Guild Roster.

Would be nice making this for any kind of roster.

Thanks!

No offense taken. I'd like to incorporate a lot of your ideas into mine as well. I just wanted to get this initial release out there so people could start using it.

Same...


This might be more difficult than what you think. Each gaming site (Everquest, World of Warcraft, Vanguard, etc... ) has their own format to their CSV/XML files. This hack wouldn't be too terribly difficult to recode to use those others... just the hack itself can't be generic enough to allow any game's feed.

At least I don't think so......

The best way I can think of accomplishing #1 is having users enter a CharID in their profile. That means adding an additional profile field. Once they enter a correct ID, you can have their userfield.field# match up with the vgroster_roster.CharID. Only members of certain usergroups AND with a good CharID would then appear on the roster. I am just having trouble getting my code to work. Going to continue looking into it later.

Gandiel, I hope you don't mind me posting this here. I apologize if you do.

I just threw the instructions for the class statistics counter together that works with your hack. I've been using it for my showroster hack already. I only had to make a few changes. One change was having to put a space after each class name. It should be easy to change later if one of us get the roster working with the forum usernames.

Instructions are attached.

Thanks....

This is the message I get when trying to run the update:

Vanguard Roster Update

Could not open file for reading

Any Ideas?

The VGPlayers website might have been down. Their website usually goes down when they do their daily restarts.

Check the VGPlayers website manually. If you can't get to it, then that's why you can't update. If you CAN get to it, post back here and we'll see if we can't work it out.