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.

[Kavious]

Yeah I can get it to it tried it a few times, and also tried reloading the entire product a couple of times to make sure it was not something I did.

[Gandiel]

Did you put in your guildID at the end of this line in vgroster_import.php?

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

Replacing 123456789 with your guild's ID?

[Kavious]

yes I did

[Gandiel]

Kavious,

Email me your $file ="http://vgplayers.station.sony.com/includes/guilds/guildsRosterCSV.vm?guildId=123456789"; line so I can test it, please.

Gandiel

[Kavious]

Sent it via PM since it wont give me your email.

[TrIn@dOr]

Originally Posted by Gandiel

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

This is the kind of roster that we use, http://aaotracker.com/clanprofile.php?clanid=1295



What do u think?

[Gandiel]

I have no idea how somebody could interface to that. It looks like the game America's Army has it's own memberslist (like you show above).

I didn't see anywhere on their site the "raw" feed that you could use for your own purposes.

[Gandiel]

Kavious,

I've been doing some research on your problem...

What version of PHP do you have? Do you know if safe mode is on?

http://us.php.net/fopen -- This is the function that opens the VGPlayers CSV file.

If PHP has decided that filename specifies a registered protocol, and that protocol is registered as a network URL, PHP will check to make sure that allow_url_fopen is enabled. If it is switched off, PHP will emit a warning and the fopen call will fail.

And here is the allow_url_fopen:

allow_url_fopen boolean

This option enables the URL-aware fopen wrappers that enable accessing URL object like files. Default wrappers are provided for the access of remote files using the ftp or http protocol, some extensions like zlib may register additional wrappers.

Note: This setting can only be set in php.ini due to security reasons.

Note: This option was introduced immediately after the release of version 4.0.3. For versions up to and including 4.0.3 you can only disable this feature at compile time by using the configuration switch --disable-url-fopen-wrapper.

So it looks like you may be unable to run the scheduled task because safe mode for PHP is turned on.



Something you can try....

1. Download the CSV from VGPlayers manually. From your guild's page on VGPlayers, right-click the CSV List link and choose Save-As. The file will be something like "guildsRosterCSV.vm"
2. Rename that file to "guildsRosterCSV.csv" and upload it to your webserver.
3. Change line #27 in "vgroster_import.php" to the location of where you uploaded the CSV file in Step 2. Don't use a URL... use something similar to this:
   

   $file = "/forum_root/vgroster/guildsRosterCSV.csv";

4. Try the Scheduled Task and see if it works locally rather than trying to grab the CSV from a URL.

[TrIn@dOr]

Originally Posted by Gandiel

I have no idea how somebody could interface to that. It looks like the game America's Army has it's own memberslist (like you show above).

I didn't see anywhere on their site the "raw" feed that you could use for your own purposes.

But is imposible to parse that?

[Gandiel]

Trin,

Yes. You'd need a raw feed.

(unless someone else has any ideas...)

Maybe try posting in the "Modifications not Available" forum. https://vborg.vbsupport.ru/forumdisplay.php?f=112


Gandiel