vb.org Archive

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)

Noxious 06-02-2007 11:48 PM

hmm can't seem to download it, keeps coming up with a site unavailable message but i can still download the instructions.txt file which wasn't changed

by any chance is this a corrupt upload?

o and no need to thank me, thank you for making an awesome mod

elricstorm 06-03-2007 02:46 AM

Just checked and I see no issues with the file. I'm able to download it fine and it's the correct file size and I even checked and verified all of the code. You might want to make sure you are viewing a new page and not pulling from an old download link. Clear out your offline files and refresh your browser. Also, I see that 4 people have downloaded the new version so don't see an issue here.

Noxious 06-03-2007 09:09 AM

sorted :D

elricstorm 06-03-2007 11:38 AM

great!

elricstorm 06-03-2007 11:52 AM

Fixed a small coding issue in 1.1.6 which affected class counts not working for 4 alternate class types. All counts are now working properly in 1.1.7. Hopefully this should fix the remainder of the tweaks and revisions for the alternates system now. :)

Nrf_Tivoli 06-03-2007 12:14 PM

I'm getting this error after adding checking Allow Signups to an event.

Code:

Database error in vBulletin 3.6.7:

Invalid SQL:

                SELECT        ea.userid, ea.response, ea.signupname, ea.comment, ea.signup_date,
                        arm.m_name,arm.m_class,arm.m_race,arm.m_level,arm.ai_name,arm.ai_class,arm.ai_race,arm.ai_level,arm.aii_name,arm.aii_class,arm.aii_race,arm.aii_level,
                        userfield.field5, userfield.field9
                FROM        vb_wowraid ea
                        LEFT JOIN userfield AS userfield ON userfield.userid = ea.userid
                        LEFT JOIN armorydata arm ON arm.userid = ea.userid
                WHERE        eventid = 031
                        AND ocdate = '1180828800'
                ORDER BY
                        ea.response, ea.signup_date;

MySQL Error  : Table 'xxxxxxxxx.userfield' doesn't exist
Error Number : 1146
Date        : Sunday, June 3rd 2007 @ 10:19:51 AM
Script      : http://forums.nurfed.com/calendar.php?do=getinfo&e=31&day=2007-6-3
Referrer    : http://forums.nurfed.com/calendar.php?do=manage&e=31
IP Address  : XXXXXXXX
Username    : Tivoli
Classname    : vb_database

I've tried uninstalling the product and reinstalling, same issue. I can add events fine, it only happens after checking signups, and then i can't even select the event without getting this error.

elricstorm 06-03-2007 04:34 PM

The userfield table is a standard table that holds all of the profile information and comes default with all vbulletin packages. The error you are receiving is stating that your "xxxx.userfield" table does not exist. I'm guessing that you changed what the real database name is and masked it by placing in the xxxx yourself? For instance, if I named my default VB database "vbtestdatabase", my custom profile fields would be stored in 'vbtestdatabase.userfield'.

The first thing you should do is make sure that "xxxxxxxxx" is referencing your real forum database, and secondly, if that is true, go into phpmyadmin or a similar utility and check to verify that your userfield table exists in that. If it does not, you need to work on figuring out why you are missing that table. This table is not altered/modified by the product itself. The only thing you are doing with this table is creating the custom fields from your own admincp. Did you do this? Did you follow all of the instructions?

I hope that helps answer your question.

Nrf_Tivoli 06-03-2007 08:07 PM

Actually, i figured it out. Lines 651 to 663, that sql statement is missing TABLE_PREFIX, so it can't find the tables ^^. Should look like this.

Code:

        // SELECT SQL for signups for this event
        $signups = $db->query_read("
                SELECT        ea.userid, ea.response, ea.signupname, ea.comment, ea.signup_date,
                        arm.m_name,arm.m_class,arm.m_race,arm.m_level,arm.ai_name,arm.ai_class,arm.ai_race,arm.ai_level,arm.aii_name,arm.aii_class,arm.aii_race,arm.aii_level,
                        userfield.$field5, userfield.$field9
                FROM        ".TABLE_PREFIX."wowraid ea
                        LEFT JOIN ".TABLE_PREFIX."userfield AS userfield ON userfield.userid = ea.userid
                        LEFT JOIN ".TABLE_PREFIX."armorydata arm ON arm.userid = ea.userid
                WHERE        eventid = 0".$eventinfo['eventid']."
                        AND ocdate = '".$signupdate."'
                ORDER BY
                        ea.response, ".$orderby."
                ");


Gooner 06-03-2007 08:40 PM

it would be cool to add something similar to the "Todays Birthdays" module but instead "Todays Raids" so guild members can see straight away from the CMPS which raids are happening today.

Gooner 06-03-2007 09:16 PM

Is it possible to add an option to sort the signed up list by "Class", its good to know what members of each class can attend the raid. Sorting by class made this mod better, Please re-add it someware :D

in 1.1.2 with the class field, it was possible, but now with armory update its not possible :(


All times are GMT. The time now is 09:32 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.01947 seconds
  • Memory Usage 1,743KB
  • 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
  • (2)bbcode_code_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