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

Reply
 
Thread Tools
gWoWEvents - World of Warcraft Event Signup Details »»
gWoWEvents - World of Warcraft Event Signup
Version: 1.0.10, by Gryphon Gryphon is offline
Developer Last Online: Sep 2023 Show Printable Version Email this Page

Category: Add-On Releases - Version: 3.8.2 Rating:
Released: 02-14-2008 Last Update: 01-31-2010 Installs: 139
Supported DB Changes Uses Plugins Auto-Templates
Re-useable Code Additional Files  

What is it?
[hr]-[/hr]gWoWEvents is a modification for vBulletin which allows you to add World of Warcraft event sign ups to your forum calendar.

If you use this mod, please Mark as Installed, and if you really enjoy this mod, please Nominate for MOTM, and if you really really enjoy this mod, feel free to Support Developer! Thank you!


Support
[hr]value[/hr]I use my released mods daily, if I find an issue with them or add features for myself I will release updates. If there are significant bugs or simple feature requests I will do my best to release fixes. Some of my mods rely on fetching data from 3rd party websites, due to the unreliable results, my mods will require users to troubleshoot for themselves if they find the addon is not working for them specifically. I am offering my personal mods that work ok for me for you to use, I am sorry I do not have time to troubleshoot many user specific issues. Thank you for your understanding.

Features
[hr]-[/hr]
  • Allows your users to enter multiple servers and characters
  • Links to either US or EU WoW Armorys.
  • Links icons to wiki.
  • Choose calendar to use
  • Limit use by usergroup
  • Multiple server support
  • Shows extended character data, skills, talents.
  • Some features translated for French and German
  • Character data is fetched by cron so calendar doesn't suffer slowdown
  • Templated so you can direct links somewhere other than the Armory if you wish.
  • Unified profilefield compatible with gWoWRoster and gWoWChar

Installation
[hr]-[/hr]
  1. Download the latest version and upload all files.
  2. Install the product.
  3. Create a Multiple-Line Text Box User Profile Field.
    • /admincp/?loc=profilefield.php%3Fdo%3Dadd
    • Multiple-Line Text Box
    • Continue
    • Title: World of Warcraft Characters
    • Description:
      Code:
      Enter one character per line.<br /><br />Format: US/EU|Realm|Faction|Name<br /><br />Example: US|Mal'Ganis|Alliance|Gryphen
    • Default Value: Leave Blank
    • Max length of allowed user input: 1000
    • Field Length: 50
    • Text Area Height: 6
    • Field Editable by User: Yes
    • Other options are optional.
    • Save
    • Look and see what the field name is for World of Warcraft Characters, example field25.
  4. Fill in the gWoWEvents configuration options.
  5. That is all, instruct people to fill in their profile.

Changes
[hr]-[/hr]
v1.0.10a - upload class_gwowarmory.php
  • Quick fix for Armory import.

v1.0.10 - upload cron.gwowevents.charinfo.php, class_gwowarmory.php, import product with overwrite
  • Quick fix for 3.1 armory changes.
  • Secondary skills disabled for now.

v1.0.9 - upload cron.gwowevents.charinfo.php, upload images, import product with overwrite
  • Death knight images, thanks SlompOchomp
  • Fix special characters in player names

v1.0.8 - import product with overwrite enabled
  • Fix spelling error
  • Fix for signup allowance periods

v1.0.7 - Upload functions_gwowevents.php, images, import product with overwrite enabled
  • Updated for WotLK

v1.0.5 - Import product with overwrite enabled.
  • Used phrases for more text
  • Added option to show who has viewed the event details.

v1.0.4 - Upload all files import product.
  • Added a 4th, "Yes Late", signup option
  • Comment minimum setting for Late and Maybe options

v1.0.3 - Import product.
  • Update for 3.7.0 Gold, thank you Kinneas

v1.0.2 - Upload all files import product.
  • Initial Release

Copyright
[hr]-[/hr]gXboxLive, Copyright ? Ghryphen (https://github.com/ghryphen)
Please maintain copyrights in derivative works, thank you.

Download Now

File Type: zip gWoWEvents_v1.0.10a.zip (145.6 KB, 137 views)

Screenshots

File Type: jpg 2008-08-06_120748.jpg (157.4 KB, 0 views)

Show Your Support

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

Comments
  #52  
Old 03-04-2008, 05:25 PM
Eviserator Eviserator is offline
 
Join Date: Feb 2008
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am getting this as an error when I force the cron to fire:

gWoWEvents Armory Import


Warning: Invalid argument supplied for foreach() in /includes/cron/cron.gwowevents.charinfo.php on line 62

Code:
Spinochio
Array
(
    [globalSearch] => 1
    [lang] => en_us
    [requestUrl] => /character-sheet.xml
    [characterInfo] => Array
        (
            [errCode] => noCharacter
            [value] => 
        )

    [prof1] => 
    [skill1] => 
)
Array
(
    [globalSearch] => 1
    [lang] => en_us
    [requestUrl] => /character-skills.xml
    [characterInfo] => Array
        (
            [errCode] => noCharacter
            [value] => 
            [skillTab] => Array
                (
                    [skillCategory] => Array
                        (
                            [1] => Array
                                (
                                    [skill] => 
                                )

                        )

                )

        )

)
--------------------------------------------------------------------------------Warning: Invalid argument supplied for foreach() in /includes/cron/cron.gwowevents.charinfo.php on line 62ScoopjacksonArray
(
    [globalSearch] => 1
    [lang] => en_us
    [requestUrl] => /character-sheet.xml
    [characterInfo] => Array
        (
            [errCode] => noCharacter
            [value] => 
        )

    [prof1] => 
    [skill1] => 
)
Array
(
    [globalSearch] => 1
    [lang] => en_us
    [requestUrl] => /character-skills.xml
    [characterInfo] => Array
        (
            [errCode] => noCharacter
            [value] => 
            [skillTab] => Array
                (
                    [skillCategory] => Array
                        (
                            [1] => Array
                                (
                                    [skill] => 
                                )

                        )

                )

        )

)
--------------------------------------------------------------------------------Warning: Invalid argument supplied for foreach() in /includes/cron/cron.gwowevents.charinfo.php on line 62ElyArray
(
    [globalSearch] => 1
    [lang] => en_us
    [requestUrl] => /character-sheet.xml
    [characterInfo] => Array
        (
            [errCode] => noCharacter
            [value] => 
        )

    [prof1] => 
    [skill1] => 
)
Array
(
    [globalSearch] => 1
    [lang] => en_us
    [requestUrl] => /character-skills.xml
    [characterInfo] => Array
        (
            [errCode] => noCharacter
            [value] => 
            [skillTab] => Array
                (
                    [skillCategory] => Array
                        (
                            [1] => Array
                                (
                                    [skill] => 
                                )

                        )

                )

        )

)
Can you help me understand what the actual error might be?
Reply With Quote
  #53  
Old 03-05-2008, 04:12 PM
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Location: Seattle, WA
Posts: 617
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Tolas View Post
heh, I guess I answered my own question. I left it overnight and no armory data. So I will change the setting and have folks remove the + from the server name and hopefully should be working better.

One other question, is there a way the data can be cached? I noticed if I switch from Yes to Tentative or No it starts to re-import.
Thanks, I was at a loss for why you were not getting updates. I urlencode the profile fields before fetching the armory data, so yes plain text is all that is needed.

I had some reasons for why it does what it does but no longer remember exactly why. Recently ran into this issue myself and will be re-evaluating the way the data is stored per previous suggestions.

Quote:
Originally Posted by Ninok View Post
I'm also getting the Cron job errors while trying to pull the data from the Armory. I have increased the Timeout value etc, I get the error no matter what I do.
I am afraid that I do not have a solution for this, maybe someone else may have some input.

Quote:
Originally Posted by quedex View Post
Hi!

First of all thanks for a great mod!
Now to the question, is it possible to make the mod pull Spell dmg, armor, defence info
also/instead of pure stats per class basis?
Thank you. Yes it is possible, I will add this suggestion to my list.

Quote:
Originally Posted by Gooner View Post
are you going to fix this mod??
What is broken? Some features are requested, but the primary goal of the mod as it is released works.

Quote:
Originally Posted by Eviserator View Post
I am getting this as an error when I force the cron to fire:

gWoWEvents Armory Import
Please put code tags around such large data pastes in the future. I am not positive, but it appears that the Armory is telling you that there is no such character as Spinochio, Scoopjackson, or Ely. Ensure that the users profile fields are entered properly. I will see if I can recreate this error.
Reply With Quote
  #54  
Old 03-06-2008, 02:52 AM
Sarosh Sarosh is offline
 
Join Date: Oct 2006
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i am unable to find the event sign up?? i followed the instructions on the first post, and its not showing, only able to enter char information in profile field. thats all. nothing with event sign up??
Reply With Quote
  #55  
Old 03-07-2008, 01:30 AM
janthes janthes is offline
 
Join Date: Mar 2008
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

After using PHPRaid to manage our sign-ups for so long, I want to try something a little more integrated into the main forums to handle sign-ups so I switched to this.

I got everything up and running in no time, and it seems to do the job well enough but I do have a couple of ideas that I didn't see posted earlier:

1. Is it possible to have a wider selection of what stats are displayed from the Armory data? I would prefer to know how much +healing my healers have versus how much strength they have, ya know?

2. The ability to sort the information presented by name, class, and date without having to go into the admin control panel to do it. It would also be nice to be able to sort by spec, if that is possible. The armory data gives you if a spec is demonology, protection, or holy, right? I don't know personally. :/

3. Maybe a piggyback onto the previous idea, changing the "total sign-up" part at the top to include more information? For example, in the Warlock box you could have it say "Warlocks (2)" and then beneath it list the names of the Warlocks who have signed up and their spec? That would actually take the need of sorting people by spec below out of the equation.

Other than that, the mod seems very well put together.

Thanks for the effort and keep up the good work.
Reply With Quote
  #56  
Old 03-07-2008, 08:36 PM
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Location: Seattle, WA
Posts: 617
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

@Sarosh I do not understand what you mean.

@janthes Thank you for the suggestions. 1) More data is on the list. 2) Named specs are not provided by the Armory, this mod determines them at the time of display by some math done with the talent point distribution. I could probably do this at the time of caching, I will look into it. 3) Nice idea, I will consider this.
Reply With Quote
  #57  
Old 03-08-2008, 02:45 PM
Mother_Dee Mother_Dee is offline
 
Join Date: Jul 2007
Location: Wisconsin
Posts: 66
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sarosh, the signup is on the calendar once a new event is added and the user "Allows for Signups."

Is that what you're looking for?
Reply With Quote
  #58  
Old 03-09-2008, 09:42 PM
Mother_Dee Mother_Dee is offline
 
Join Date: Jul 2007
Location: Wisconsin
Posts: 66
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Same issue as previously posted, recurring events do not create separate signups, so I have to manually post every event even if recurring. That is a bit of a PITA (understatement.) Otherwise it seems to be working well and my users like how it works/looks.
Reply With Quote
  #59  
Old 03-10-2008, 06:37 AM
LostPhoenix LostPhoenix is offline
 
Join Date: Oct 2007
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Here is my hack for those of us who have hosts that don't like the cron. It's not perfect but it does work.

Find the following code in cron.gwowevents.charinfo.php
Code:
if ($character['characterInfo'] && $character['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
	$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}
else
{
	$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}
and change it to:
Code:
$dbhost = '';
$dbname = '';
$dbuser = '';
$dbpasswd = '';

if ($character['characterInfo'] && $character['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
	//$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
	@ $db2 = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
	mysql_select_db("$dbname",$db2);
	mysql_query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'", $db2);
	mysql_close($db2);
} else {
	//$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'");
	@ $db2 = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
	mysql_select_db("$dbname",$db2);
	mysql_query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'", $db2);
	mysql_close($db2);
}
Obviously you have to add your database info. Until I take the time to learn vbulletin and fix it properly lol.

This will put more stress on your SQL server as it opens and closes a connection each time it updates the user.
Reply With Quote
  #60  
Old 03-10-2008, 06:44 PM
Ninok Ninok is offline
 
Join Date: Mar 2006
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by LostPhoenix View Post
Here is my hack for those of us who have hosts that don't like the cron. It's not perfect but it does work.

Find the following code in cron.gwowevents.charinfo.php
Code:
if ($character['characterInfo'] && $character['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
	$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}
else
{
	$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}
and change it to:
Code:
$dbhost = '';
$dbname = '';
$dbuser = '';
$dbpasswd = '';

if ($character['characterInfo'] && $character['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
	//$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
	@ $db2 = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
	mysql_select_db("$dbname",$db2);
	mysql_query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'", $db2);
	mysql_close($db2);
} else {
	//$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'");
	@ $db2 = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
	mysql_select_db("$dbname",$db2);
	mysql_query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'", $db2);
	mysql_close($db2);
}
Obviously you have to add your database info. Until I take the time to learn vbulletin and fix it properly lol.

This will put more stress on your SQL server as it opens and closes a connection each time it updates the user.
I still get the same error with this fix, I just can't get it to work. I will add that its random users that it errors out on, I really need to talk to the host.
Reply With Quote
  #61  
Old 03-10-2008, 09:44 PM
LostPhoenix LostPhoenix is offline
 
Join Date: Oct 2007
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Ninok View Post
I still get the same error with this fix, I just can't get it to work. I will add that its random users that it errors out on, I really need to talk to the host.
If they have incorrect info put into the user friend it will give an error, but should just skip them and move on to the next one... I was able to update 200 users with my fix yesterday and the cron has been working fine since.

Are you getting the same error with my hack? Server has gone away?
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 11:51 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05070 seconds
  • Memory Usage 2,367KB
  • Queries Executed 28 (?)
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
  • (6)bbcode_code
  • (7)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (2)postbit_attachment
  • (11)postbit_onlinestatus
  • (11)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_postinfo_query
  • fetch_postinfo
  • 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_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete