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
World of Warcraft Event Calendar Details »»
World of Warcraft Event Calendar
Version: 1.2.7, by elricstorm elricstorm is offline
Developer Last Online: Nov 2010 Show Printable Version Email this Page

Category: Add-On Releases - Version: 3.6.x Rating:
Released: 04-18-2007 Last Update: 07-06-2007 Installs: 97
Uses Plugins Template Edits
Is in Beta Stage  
No support by the author.

What does this Mod do?
[hr].[/hr]

This is a calendar mod that supports events created for World of Warcraft that allows signups for mains and alternates. Data for mains and alternates are pulled from the world of warcraft armory automatically and listed/displayed in a table format based on the style of your current site.

Current Version
[hr].[/hr]

Current beta version = 1.2.7 (recommended)
Current stable version = 1.2.6

Whether you are upgrading or installing from new, you ALL need to download the instructions and read them. There is a section for New Installs and a section for Upgrading. Inside there is also a NEW .CHM file (help file) that will also make it easier to read. I kept the instructions file in there as well but it's renamed to wowcalendar.txt instead. Review wowcalendar.chm if you are able to. It works better.

What is required?
[hr].[/hr]

You will essentially need to perform:
  • One product XML import
  • Two PHP file uploads
  • One Profile addition for User Profiles
  • One Template Modification
  • Uploading image files to the specified path listed in the instructions
Review the "instructions" contained in the zip file before installing this product.

Creating a Calendar Entry
[hr].[/hr]

When you create a calendar entry, single, recurring, etc. - make sure you enable users to signup (located at the bottom of the new calendar event form) (see the screenshot listed in this post). By default, it should place an automatic signup checkmark in that box. Once you submit, users will be able to signup.

Alternates
[hr].[/hr]

If you have alternates on, alternates can be used to signup with (only if people have added additional characters to their user profile. At this time, the calendar only reads the top 3 lines in the profile box so any more characters listed will not be usable in the calendar.

(i.e. if you have 7 characters listed, only the first 3 will be usable.

Armory Data
[hr].[/hr]

Armory Data is pulled as soon as a "registered" user checks the calendar event. This data is then replaced into the armorydata table for use later on with the signups. Remember to set your server and your locale as well. If your server has two words (ex. Scarlet Crusade) you would input Scarlet+Crusade in the server box. If you play on a US server you would put US in the locale box. If you play on a European Server you would input EU in the locale box. Make sure you set all appropriate options.

Options for your Calendar System
[hr].[/hr]

Go into your vb options and you will find two separate sections for setting options - one is for settings and one is for styles. You can change any options in here. Future revisions will include more substitutions/changes in this area.

SPECIAL THANKS TO:
[hr].[/hr]
[name]Farcaster[/name]:
For his initial MOD and ideas which got me started and into customizing the entire calendar. Farcaster's Event Attendance can be found at: https://vborg.vbsupport.ru/showthread.php?t=129088

[name]Gryphon[/name]:
For helping with the original wow parser code and for giving me some tips/advice for working to implement it with the calendar system. In addition, Gryphon, formerly Blackjack, worked with me deeply to allow both this calendar and his current gWoWCharacter mod to be cross-compatible. He also helped with localization. Many thanks!

Show Your Support

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

Comments
  #342  
Old 10-30-2007, 12:56 AM
wolfman wolfman is offline
 
Join Date: Aug 2002
Posts: 77
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Caerydd View Post
Is there a mac friendly version of the instructions? My usual 'open everything in TextWrangler' didn't work with it >>

Is an old fashion .txt so bad *puppy dog eyes*

*emails self a copy of the file, and opens on PC* Good thing I'm at home >>

I did find a mac application that can read .chm files http://chmox.sourceforge.net/
Reply With Quote
  #343  
Old 10-30-2007, 06:14 PM
Synth Synth is offline
 
Join Date: Oct 2005
Posts: 160
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Stabatha View Post
Hi there,

I am receiving this error when trying to create a new raid... I have tried uninstalling and reinstalling the product 6 times too!

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT field5,,
FROM userfield
WHERE userid = 1;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
FROM userfield
WHERE userid = 1' at line 1
Error Number : 1064
I'm having this same issue as well when I use 1.2.6 and click on the created event. When I try to install 1.2.7 i get:

PHP Code:
Database error in vBulletin 3.6.2:

Invalid SQL:

                
INSERT INTO setting
                    
(varnamegrouptitlevaluedefaultvaluedatatypeoptioncodedisplayorderadvancedvolatilevalidationcodeblacklistproduct)
                
VALUES
                    
(
                    
'wow_font_style',
                    
'wow_calendar_style',
                    
'Verdana',
                    
'Verdana',
                    
'free',
                    
'',
                    
11,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_fontsize_style',
                    
'wow_calendar_style',
                    
'8pt',
                    
'8pt',
                    
'free',
                    
'',
                    
21,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_druid_color',
                    
'wow_calendar_style',
                    
'#FF3300',
                    
'#FF3300',
                    
'free',
                    
'',
                    
71,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_hunter_color',
                    
'wow_calendar_style',
                    
'#33FF33',
                    
'#33FF33',
                    
'free',
                    
'',
                    
82,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_mage_color',
                    
'wow_calendar_style',
                    
'#33FFFF',
                    
'#33FFFF',
                    
'free',
                    
'',
                    
83,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_paladin_color',
                    
'wow_calendar_style',
                    
'#FF66CC',
                    
'#FF66CC',
                    
'free',
                    
'',
                    
84,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_priest_color',
                    
'wow_calendar_style',
                    
'#FFFFFF',
                    
'#FFFFFF',
                    
'free',
                    
'',
                    
85,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_rogue_color',
                    
'wow_calendar_style',
                    
'#FFFF66',
                    
'#FFFF66',
                    
'free',
                    
'',
                    
86,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_shaman_color',
                    
'wow_calendar_style',
                    
'#FF3333',
                    
'#3366FF',
                    
'free',
                    
'',
                    
87,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_warlock_color',
                    
'wow_calendar_style',
                    
'#CC9966',
                    
'#CC66CC',
                    
'free',
                    
'',
                    
88,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_warrior_color',
                    
'wow_calendar_style',
                    
'#CC66CC',
                    
'#CC9966',
                    
'free',
                    
'',
                    
89,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_table_width',
                    
'wow_calendar_style',
                    
'100%',
                    
'100%',
                    
'free',
                    
'',
                    
90,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_time_width',
                    
'wow_calendar_style',
                    
'18%',
                    
'18%',
                    
'free',
                    
'',
                    
91,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_name_width',
                    
'wow_calendar_style',
                    
'12%',
                    
'12%',
                    
'free',
                    
'',
                    
92,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_level_width',
                    
'wow_calendar_style',
                    
'7%',
                    
'7%',
                    
'free',
                    
'',
                    
93,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_class_width',
                    
'wow_calendar_style',
                    
'8%',
                    
'8%',
                    
'free',
                    
'',
                    
94,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_talents_width',
                    
'wow_calendar_style',
                    
'10%',
                    
'10%',
                    
'free',
                    
'',
                    
95,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_gender_width',
                    
'wow_calendar_style',
                    
'5%',
                    
'5%',
                    
'free',
                    
'',
                    
96,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_race_width',
                    
'wow_calendar_style',
                    
'8%',
                    
'8%',
                    
'free',
                    
'',
                    
97,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_genrace_width',
                    
'wow_calendar_style',
                    
'9%',
                    
'9%',
                    
'free',
                    
'',
                    
98,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
),
    (
                    
'wow_comments_width',
                    
'wow_calendar_style',
                    
'28%',
                    
'28%',
                    
'free',
                    
'',
                    
99,
                    
0,
                    
1,
                    
'',
                    
0,
                    
'wow_calendar'
    
);

MySQL Error  Duplicate entry 'wow_font_style' for key 1
Error Number 
1062
Date         
TuesdayOctober 30th 2007 03:17:31 PM
Script       
: [url]http://hop-guild.com/forum/admincp/plugin.php?do=productimport[/url]
Referrer     : [url]http://hop-guild.com/forum/admincp/plugin.php?do=productadd[/url]
IP Address   74.142.45.149
Username     
Onixx
Classname    
vb_database 
Reply With Quote
  #344  
Old 11-07-2007, 10:05 PM
Jrain157 Jrain157 is offline
 
Join Date: Aug 2005
Posts: 27
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Got it to work on www.tamalesguild.com, but the load time for the signups takes FOREVER. Are there any settings that can be changed to improve performance?
Reply With Quote
  #345  
Old 11-09-2007, 11:42 AM
SocialNetworkBuzz SocialNetworkBuzz is offline
 
Join Date: May 2007
Posts: 109
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Stabatha View Post
Hi there,

I am receiving this error when trying to create a new raid... I have tried uninstalling and reinstalling the product 6 times too!

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT field5,,
FROM userfield
WHERE userid = 1;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
FROM userfield
WHERE userid = 1' at line 1
Error Number : 1064
Still getting this error. Has anyone gotten this to work with vb 3.6.8?

Still getting this error
Reply With Quote
  #346  
Old 11-15-2007, 11:45 AM
Lord Doys Lord Doys is offline
 
Join Date: May 2003
Posts: 27
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Disi View Post
The other thing is, you schould cache the armory side and just update it once a day. its sometime so slow that i could me a cap of cofee . A secound advantage is that if you cache it you got a working version if armory is down
Was thinking about this as well, members are complaining alot that the calendar is SOOO slow. (while it is actually the armory that is the bugger.)

So i agree with Disi.
Cache the characters like once per day (maybe even week..variable?) with a cron job.

And when people sign up, pull data straight from cache.
Reply With Quote
  #347  
Old 11-20-2007, 02:42 AM
atomhead atomhead is offline
 
Join Date: Nov 2007
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Lord Doys View Post
Was thinking about this as well, members are complaining alot that the calendar is SOOO slow. (while it is actually the armory that is the bugger.)

So i agree with Disi.
Cache the characters like once per day (maybe even week..variable?) with a cron job.

And when people sign up, pull data straight from cache.
Yeah I'd have to agree, currently way too slow pulling data into the list. Had just one character and it took like 30 seconds. Looking for other alternatives until that's fixed =\
Reply With Quote
  #348  
Old 11-22-2007, 09:58 PM
LostPhoenix LostPhoenix is offline
 
Join Date: Oct 2007
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I was toying around with this mod and found that if you have two events for the same day (and view by day instead of event) you will get signed up for both events. Anyone else ran into this problem?

I did some more testing, and it seem the problem comes when reading from the database on the calendar date pages (not specific event). I checked the database, and each signup is only in for the correct event. Does this mean the strings aren't clearing?
Reply With Quote
  #349  
Old 12-09-2007, 06:37 AM
Collyn Collyn is offline
 
Join Date: Dec 2004
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm not experiencing those errors on mine. It seems to be working fine with multiple sign ups on the same day. Other than the slowness that everyone else seems to be experiencing.

Risking duplicate entries if this happens I apologize we are 24+ pages deep now.
In our guild I have the issue where I have people with multiple raiding 70's more than 3 the issue with selectable names was fixed by adding the following.

in calendar_signup_form
find:
PHP Code:
<if condition="$alternates">
                    <if 
condition="!$mycharacter[1]==''"><option value="$mycharacter[1]<if condition="$mysignupname == $mycharacter[1]">selected</if>>$mycharacter[1]</option></if>
                    <if 
condition="!$mycharacter[2]==''"><option value="$mycharacter[2]<if condition="$mysignupname == $mycharacter[2]">selected</if>>$mycharacter[2]</option></if> 
Understand that your 1st character is 0, second is 1, 3rd is 2, and so on. Max characters that you can have on a server is 10. So after the above code add.

PHP Code:
                    <if condition="!$mycharacter[3]==''"><option value="$mycharacter[3]<if condition="$mysignupname == $mycharacter[3]">selected</if>>$mycharacter[3]</option></if>
                    <if 
condition="!$mycharacter[4]==''"><option value="$mycharacter[4]<if condition="$mysignupname == $mycharacter[4]">selected</if>>$mycharacter[4]</option></if>
                    <if 
condition="!$mycharacter[5]==''"><option value="$mycharacter[5]<if condition="$mysignupname == $mycharacter[5]">selected</if>>$mycharacter[5]</option></if>
                    <if 
condition="!$mycharacter[6]==''"><option value="$mycharacter[6]<if condition="$mysignupname == $mycharacter[6]">selected</if>>$mycharacter[6]</option></if>
                    <if 
condition="!$mycharacter[7]==''"><option value="$mycharacter[7]<if condition="$mysignupname == $mycharacter[7]">selected</if>>$mycharacter[7]</option></if>
                    <if 
condition="!$mycharacter[8]==''"><option value="$mycharacter[8]<if condition="$mysignupname == $mycharacter[8]">selected</if>>$mycharacter[8]</option></if>
                    <if 
condition="!$mycharacter[9]==''"><option value="$mycharacter[9]<if condition="$mysignupname == $mycharacter[9]">selected</if>>$mycharacter[9]</option></if> 
this will extend the drop down and allow more selectable charaters for those guildies that have no life
Reply With Quote
  #350  
Old 12-11-2007, 06:17 AM
cgootgeld cgootgeld is offline
 
Join Date: Aug 2007
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I too am having load time issues with the calendar. I've made sure that the Database is optimized and working properly but still experience long page load times. I thought this was an armory issue but the strange thing is that when I'm logged in as a Admin the calendar loads instantaneous, only when I'm logged in as a registered/member user do I have these problems. Could this be related to user permissions with the calendar and since we have over 100 members and only 1 admin be the cause of this?
Reply With Quote
  #351  
Old 12-14-2007, 03:13 PM
ranmasao12 ranmasao12 is offline
 
Join Date: Sep 2007
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

has anyone figured out how to address the speed issues when your linked into the armory. I figure the armory is slow so the calendar is slow. i would still like to link the character info but I dont want the system to hit the armory page on every load. If we could schedule a job to cache the info into the database then pull from there that would be great!
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 01:43 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.06899 seconds
  • Memory Usage 2,467KB
  • Queries Executed 27 (?)
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
  • (3)bbcode_php
  • (5)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
  • (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
  • (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_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete