Miscellaneous Hacks - Vanguard Guild Roster Integration Hack

Vanguard - Saga of Heroes
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:
   

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

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

MAKE SURE YOU CLICK INSTALL
You will get an email when a new version is released.

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.

[Xaices]

Gandiel,

Need some help please. I get this when I run a scheduled task.

Database error in vBulletin 3.6.8:
Invalid SQL:
INSERT INTO vbvgroster_roster VALUES ('','','');
MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Tuesday, December 18th 2007 @ 07:55:53 PM
Script : http://www.blackwatchguild.com/forum...cron&cronid=19
Referrer : http://www.blackwatchguild.com/forums/admincp/index.php
IP Address :
Username :
Classname : vB_Database

http://vgplayers.station.sony.com/in...d=481036338348

Thanks for you help in this matter.

[Xaices]

Ok Gandiel is no longer supporting this. Can any one assist?

That error is due to a problem with the MySQL coding/syntax. The vbvgroster_roster has a total of 12 values in each row. That SQL query is only trying to write to 3 of them. Unless you define what specific columns you are filling in, you must have the exact number of columns that the table has in the VALUES portion of the query. This will need to be fixed in the script, and I would suggest contacting the developer of the script, or browsing support forums for the product.

I can't code so any assistance on this would be most appreciated.

[Gandiel]

Xaices and anyone else,

Seeing Xaices last post with that quote in it gave me some insight to the problem. I've provided a fix (for now) to the problem. You'll need to UNINSTALL the product first, then REINSTALL the new product-vgroster.xml file attached to this post and overwrite the vgroster_import.php in includes/cron/

The reason I say this is a temporary fix is because there's a problem with Vanguard's CSV output. They only want to display 11 headings:

name, id, prefixTitle,advtClass,advtLevel,craftingClass,craftingLevel,diplomacyClass,diplomacyLevel,dateJoined,guildRank

But in reality they're outputting 12 fields:

Xaices,81604385483,Founder,Dread Knight (20),50,Crafter (1050),1,Diplomat,4,,2007-12-10,Initiate

Notice the double commas between "4" and "2007-12-10"


If Vanguard ever fixes that, the cron job will break again.

I stopped supporting this months ago. I haven't even played Vanguard since April 2007. I just had some spare time this morning to take a deeper look into the problem.

GL to you all.


Gandiel

[Xaices]

Thank you Gandiel!