Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.6 > vBulletin 3.6 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Vanguard Guild Roster Integration Hack Details »»
Vanguard Guild Roster Integration Hack
Version: 1.0.2, by Gandiel Gandiel is offline
Developer Last Online: Sep 2009 Show Printable Version Email this Page

Category: Miscellaneous Hacks - Version: 3.6.4 Rating:
Released: 03-13-2007 Last Update: 03-14-2007 Installs: 13
DB Changes Uses Plugins Template Edits
Additional Files  
No support by the author.

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

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.

Supporters / CoAuthors

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 03-14-2007, 06:32 PM
Gandiel Gandiel is offline
 
Join Date: Jan 2007
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Reserved
Reply With Quote
  #3  
Old 03-21-2007, 12:57 PM
Sarcoth Sarcoth is offline
 
Join Date: Mar 2006
Location: Huntsville
Posts: 521
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #4  
Old 03-21-2007, 01:26 PM
TrIn@dOr TrIn@dOr is offline
 
Join Date: Nov 2006
Location: South Bend, IN
Posts: 169
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Would be nice making this for any kind of roster.
Reply With Quote
  #5  
Old 03-21-2007, 04:00 PM
Gandiel Gandiel is offline
 
Join Date: Jan 2007
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Sarcoth View Post
Very nicely done. Installed.
Thanks!

Quote:
Originally Posted by Sarcoth View Post
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.
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.

Quote:
Originally Posted by Sarcoth View Post
2) Add a class counter at the bottom.
Same...


Quote:
Originally Posted by TrIn@dOr View Post
Would be nice making this for any kind of roster.
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......
Reply With Quote
  #6  
Old 03-21-2007, 06:55 PM
Sarcoth Sarcoth is offline
 
Join Date: Mar 2006
Location: Huntsville
Posts: 521
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #7  
Old 03-22-2007, 01:37 AM
Sarcoth Sarcoth is offline
 
Join Date: Mar 2006
Location: Huntsville
Posts: 521
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #8  
Old 03-25-2007, 05:50 PM
Atakan KOC's Avatar
Atakan KOC Atakan KOC is offline
 
Join Date: Feb 2006
Location: Istanbul
Posts: 710
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks....
Reply With Quote
  #9  
Old 03-29-2007, 12:40 PM
Kavious Kavious is offline
 
Join Date: Mar 2007
Posts: 5
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Vanguard Roster Update

Could not open file for reading

Any Ideas?
Reply With Quote
  #10  
Old 03-29-2007, 12:50 PM
Gandiel Gandiel is offline
 
Join Date: Jan 2007
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:29 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04336 seconds
  • Memory Usage 2,306KB
  • Queries Executed 24 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete