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)

elricstorm 06-06-2007 05:01 PM

Quote:

Originally Posted by Gooner (Post 1262581)
I cannot say it enough but you are a great coder and great help, And i will do what you have sugested, I have thought of a small feature which might be of goodness...

A key legend, Because the calander descriptions space isnt enough for full instance names (Mutliple) so instances names need to be made smaller [Karazhan - Kara] and such, Maybe a box someware which tells the members which each one means, Key legend.

Mag - Magtheridon
BT - Black Temple
Kara - Karazkan
SSC - Serpent Shrine Caverns
EOTS - Eye of the storm

This list could be modified by the officers, kinda like the Recruitment status system but in the calander.

Good suggestion. I'm working on separate code that will modify the add/edit events sections so that you can choose all of the instances, max counts of classes allowed, etc. and then modifying the small section that appears above the event description and the event signups so that the new table goes there. I'm definitely going to template this with a table appearance as it will be easier to view. It's just going to take some work to finish.

The problem I'm currently facing is that I don't want to modify the customcalendarfield table but instead create a duplicate of it called wowcustomcalendarfield table. I can then add all of the structures for the calendar fields for description, etc. in here and allow people to decide what calendars they apply to. The reason why I want to do this really goes back to uninstalling the product.

If someone uninstalls the product I don't want to leave anything behind that reflects the product. Call it my tidiness routine. In addition, I don't want to mess with calendars that a person doesn't want the events calendar working on. And, adding customcalendarfields is a tricky thing to implement. But, I'm making progress.

Now, hopefully, the armorydata issues are behind me.

Gooner 06-06-2007 07:45 PM

This is allready becomming a much better alternative to PHPRaider for guilds which use VBulletin websites. I allready prefer this raid management system to PHPRaider for the simple fact, Everything is built into one if you know what i mean, Forums, Raid Signup and the website skin is matching all round.... all on one login/database, I realise this is still in its beta stage and im sure you got more big plans for it, But its allready oozing sweet juice. Im only the Webmaster for my guild and our Guild Leader loves the signup system, as do all the members, Very professional and tidy, I can only wait and be excited for the future features. I will most definatly be advertising your work of art everyware i go.

Hyrel 06-06-2007 09:37 PM

Could not agree more Gooner. VB is awesome and being able to have all the needed things for a guild website getting along is marvelous. Now if I can just get it to work heh.

elricstorm 06-06-2007 10:01 PM

Quote:

Originally Posted by Hyrel (Post 1262747)
Could not agree more Gooner. VB is awesome and being able to have all the needed things for a guild website getting along is marvelous. Now if I can just get it to work heh.

Anything else you need help with mate?

Here's a quick list for you to check:
  • Check and make sure you created the custom profile fields for main class, alternate1, and alternate2.
  • Write down the IDs for the three new custom user profile fields.
  • Go into your own usercp and edit -> profile and fill in the fields for your characters.
  • Install the product -> current version 1.2.0 (overwrite if necessary)
  • Check and make sure all vboptions for the product are filled out and that your custom fields are pointing to the right field IDs you created above
  • Go to your calendar and create a new test event and allow user signups.
  • You should see your character names in the drop down fields (if you do then you have your custom fields working right)
  • Click Yes and submit.
  • Everything should look correct now.

Troubleshooting quick list for you to check:
  • Check your phpmyadmin and make sure your wowraid and your armorydata tables exist on your forum database
  • If both are there, browse your armorydata table and check what data is inside there.

Make sure that all of this is done "without" altering the product.

Thanks.

Hyrel 06-06-2007 10:02 PM

At first i thought I had the same error as NightPhoenix, but I guess it isn't. I'm running on a MySQL 5.0 server.

PHP Code:

Database error in vBulletin 3.6.7:

Invalid SQL:

        
SELECT    ea.useridea.responseea.signupnameea.commentea.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., userfield.
        
FROM    forumwowraid ea
            LEFT JOIN forumuserfield 
AS userfield ON userfield.userid ea.userid
            LEFT JOIN forumarmorydata arm ON arm
.userid ea.userid
        WHERE    eventid 
010
            
AND ocdate '1181088000'
        
ORDER BY
            ea
.responseea.signup_date;

MySQL Error  You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near ' userfield.
        FROM    forumwowraid ea
            LEFT JOIN forumuserfield AS userfield ON' 
at line 3
Error Number 
1064
Date         
WednesdayJune 6th 2007 03:58:54 PM
Script       
http://www.rivalnation.com/forums/calendar.php?do=getinfo&e=10&day=2007-6-6&c=1
Referrer     http://www.rivalnation.com/forums/calendar.php
IP Address   76.174.139.167
Username     
CruelAngel
Classname    
vB_Database 


Masked Crusader 06-06-2007 10:28 PM

Been a long time since I have trolled this thread.

I just got around to creating a new guild and have found need for this mod again.

However, I am having ONE issue with it at the moment.

It is the SAME SQL error that everyone else is getting. I believe that everyone is getting this error because the Armory is acting up BADLY.

Of course, it may be something else that I do not know of. Here is the error I am getting:

Code:

Database error in vBulletin 3.6.5:

Invalid SQL:

                        SELECT field11,,
                        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
Date        : Wednesday, June 6th 2007 @ 04:28:10 PM
Script      : http://www.deivictorae.com/calendar.php?do=getinfo&e=3&day=2007-6-7
Referrer    : http://www.deivictorae.com/calendar.php?do=add&c=3&day=2007-6-7
IP Address  : 24.251.140.121
Username    : Protspec
Classname    : vb_database


elricstorm 06-06-2007 10:37 PM

Quote:

Originally Posted by Hyrel (Post 1262758)
...

Yours is an easy fix.

Do you see where you have:

PHP Code:

Database error in vBulletin 3.6.7:

Invalid SQL:

        
SELECT    ea.useridea.responseea.signupnameea.commentea.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., userfield

Notice it says userfield.x and the (x) is missing? That's pointing to $field5, $field9, and $field10, which are the custom userfields. You either haven't created them and pointed them to the right numbers in vboptions.., or you created them and haven't pointed them to the right numbers in vboptions.

Do you understand how to create custom userfield options? And, if so, do you know how to find the IDs of those fields?

Check my attachments for visual examples.

Remember that if you have a bunch of customfields, yours might be field22, field23, field24, etc. That's why you need to plugin the IDs correctly.

elricstorm 06-06-2007 10:45 PM

Quote:

Originally Posted by shanejeffery86 (Post 1262770)
Been a long time since I have trolled this thread.

I just got around to creating a new guild and have found need for this mod again.

However, I am having ONE issue with it at the moment.

It is the SAME SQL error that everyone else is getting. I believe that everyone is getting this error because the Armory is acting up BADLY.

Of course, it may be something else that I do not know of. Here is the error I am getting:

First, upgrade to 1.2.0 which fixes some of the bad behavior the timeout settings caused. See if that works. Post back if you have a similar issue. I also see that you are using 3.6.5 and I've only tested this with 3.6.0 and 3.6.7 so I'm not sure what type of behavior it will exhibit on 3.6.5.

Try the upgrade first and I'll try to work with you on your issue and see if we can figure out what's going on. Only a very few people are having issues though. I have similar friends that are using this code on a 3.6.0, 3.6.4, 3.6.5 and I'm using it on a 3.6.7 main and test site.

The armorydata code really does not affect the sql inserts and queries. The armorydata code is just a retrieval mechanism that stores variables that are then used by the queries. The query structure has been in place for all versions. I've only had to slightly modify it.

Just an fyi..

EDIT: Just noticed - you have an "extra" (comma) right after your field11. I can almost bet you a big juicy hamburger that you accidentally placed a comma in vboptions when entering the field ID number. Check vboptions and make sure you didn't place field11, in the option field. That's a "free" field that you can type anything in.

Masked Crusader 06-06-2007 10:46 PM

No extra comma in there...

No idea where the hell it is coming from.

Need help trying to figure out what is going on.

Hyrel 06-06-2007 10:57 PM

hahah I do I was afraid it might be that though, I thought I'd be all cool and just customize it in the xml for what I had. Guess I messed up instead, lets try not doing that and see what happens.


All times are GMT. The time now is 05:48 PM.

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.01708 seconds
  • Memory Usage 1,800KB
  • 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
  • (1)bbcode_code_printable
  • (2)bbcode_php_printable
  • (4)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