vb.org Archive
Page 35 of 38 « First 253334 35 3637 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Add-On Releases - World of Warcraft Event Calendar (https://vborg.vbsupport.ru/showthread.php?t=145287)

wolfman 10-30-2007 12:56 AM
Quote:
Originally Posted by Caerydd (Post 1330906)
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/

Synth 10-30-2007 06:14 PM
Quote:
Originally Posted by Stabatha (Post 1356762)
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
                    (varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
                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         : Tuesday, October 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 

Jrain157 11-07-2007 10:05 PM
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?

SocialNetworkBuzz 11-09-2007 11:42 AM
Quote:
Originally Posted by Stabatha (Post 1356762)
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

Lord Doys 11-15-2007 11:45 AM
Quote:
Originally Posted by Disi (Post 1352799)
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.

atomhead 11-20-2007 02:42 AM
Quote:
Originally Posted by Lord Doys (Post 1382943)
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 =\

LostPhoenix 11-22-2007 09:58 PM
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?

Collyn 12-09-2007 06:37 AM
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 ;)

cgootgeld 12-11-2007 06:17 AM
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?

ranmasao12 12-14-2007 03:13 PM
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!:confused:


All times are GMT. The time now is 09:14 PM.
Page 35 of 38 « First 253334 35 3637 Last »
Show 40 post(s) from this thread on one page

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.01433 seconds
  • Memory Usage 1,918KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete