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)

SocialNetworkBuzz 05-11-2007 04:10 PM

yes it is, but all three sorts have the same result. Instead of a nice table. They all display..

Greyvenney -:- Level (70) Gnome Mage
[05-08-2007 11:46 AM]
Vendforu-:- Level (60) Human Mage
[05-08-2007 03:05 PM]
Bellemi -:- Level (70) Human Paladin
[05-08-2007 02:06 PM]
Discomoose -:- Level (69) Night Elf Priest
[05-09-2007 06:15 AM]
Stabatha -:- Level (70) Gnome Rogue
[05-08-2007 11:42 AM]
doddle -:- Level (70) Gnome Warrior
[05-08-2007 02:57 PM]

SocialNetworkBuzz 05-11-2007 04:17 PM

Quote:

Originally Posted by elricstorm (Post 1245678)
Issue with class counts is fixed. I changed
PHP Code:

$signup['$field6'

to..
PHP Code:

$signup[$field6

..which corrected the problems for the class variables.

Upgrade and overwrite the product using the new one I uploaded version 1.1.1.

Stabatha, which sort is that on? Is that on time sort? I'll fix it if it is. I'll add that to the next revision.

That fixed that issue :)

now, we just gotta get it to display my tables correctly, a way to set class max, rest are put on standby and add onto calendar.php the total signed up for the event. I will be one happy Gnome :)

elricstorm 05-11-2007 05:45 PM

Okay I have no problems with any tables on any of the sorts. Are you sure you followed all of the instructions I outlined? Also, if you did, what other "calendar" mods might you be using or any that utilize calendar functions? It might be that you have a conflicting mod. I have zero problems on any of the sorts.

More importantly, the table you are having trouble with is utilizing the calendar_signup_bit template if that helps you isolate this further. I spoke to several other people who use the calendar and they have no problems with the sorts and the table display. I also checked cross-compatibility with Firefox and IE. I have not tested with "other" browsers besides these two.

As for "class max" - definitely next on my plate. I'm also looking into armory data but that's further down the road. I'm able to utilize armory data but I don't want to have to do a full rewrite at this time. For now, I'd rather maximize functionality and get all the nice features such as alternates, and class max limits.

elricstorm 05-12-2007 01:17 PM

Updated to 1.1.2

See notes in section for what has been revised/updated. If you already have the calendar installed, all you need to do is import and choose "overwrite".

Thanks.

rezenous 05-12-2007 03:17 PM

After reinstalling the problem I had before is fixed but now when I post an event I can't choose to allow signups on that event?

elricstorm 05-12-2007 08:32 PM

Sorry about that - that was my fault. I have a test file a real file. I accidentally uploaded the test file. I just removed it and put the "correct" file up. Download the updated one now and everything is fine.

4yBak 05-18-2007 06:33 PM

thanks a lot for fix :)

elricstorm 05-20-2007 10:40 PM

Welcome - I finally got my test board up and running so I'm working on the alternates system now.

Tork64 05-26-2007 12:52 AM

amazing thanks. I was just going to put down 18 dollars a month for basically the same thing. Thanks for this.

elricstorm 05-26-2007 01:18 PM

Version 1.1.3 released. Read changes to see what has been changed.
Tested and also works on version 3.6.7 for those of you on that version.

Due to changes in how the styles work, if your style is properly formatted, it should work seamless. If it does not for any reason, post a screenshot of how it appears and I will try to make some adjustments for you. Most of the table header code is just pulling directly from your current style's color/formatting. There are no options that need to be changed to allow for your style to work.

Thanks,

elricstorm 05-26-2007 01:31 PM

Quote:

Originally Posted by Tork64 (Post 1254783)
amazing thanks. I was just going to put down 18 dollars a month for basically the same thing. Thanks for this.

Who was trying to charge you this amount? I just want to make sure that no one reuses the code I produce and hacks it in an attempt to sell it to anyone. This is a free source for community use only. Free = Better always :)

And, you are most welcome.

VenomMaster 05-29-2007 04:59 PM

Hi Elric,

due to the fact that my board is used by german speaking users, i needed to localize this hack. Sure, the prases needed two minutes on the fly, but after i changed the templates, the color formatting doesn't work.

I don't know where this fault may be.

I'll attach the changed and exported version of the hack, maybe you can have a look?

Thanks in advance,

Venom

[edit]

It's okay, i found my fault... I didn't deinstall the product before importing it...
Now it works very nice. Thanks for the great hack!

Am i allowed to provide this thingy on vbhacks-germany.com?

Venom

elricstorm 05-29-2007 06:55 PM

Absolutely - you have my permission mate. Just provide a link back here in case of updates or input. As for templates, one thing to remember and I've noticed this as well, even when I do a lot of testing on my boards.. When you make actual template edits, it doesn't take until you deinstall and reinstall the product. That's why I like to make very few template edits. Unfortunately, I really needed to clean up the code in the last version and make the templates more style friendly for vbulletin.

Also, as a good rule of thumb from a coding point of view, if you do make template edits in the future, try to do so from your admincp, rather than from the .xml product file. It's a good coding philosophy to "not" work with xml product files directly. Use the admincp, make your necessary edits on templates, codes, etc. and then export the revised product file. This keeps it error free.

If anyone encounters any similar issues with not being able to see the newer templates after uploading and overwriting, you may have to de-install and reinstall the product in order to see the implemented changes.

And again, you are welcome.

elricstorm 06-01-2007 05:14 PM

I have some good news. I have the alternates system in place now on my own site. I'm letting my guild test with the new system which is 100% fully incorporated with the World of Warcraft official armory site when pulling data. Right now the system only caters to 1 alternate. If tests go well, I'll add one additional alternate to the beginning system. Anyhoo, just a heads up on the news.

elricstorm 06-01-2007 07:35 PM

I have it working fine with 1 main and 2 alternates allowed. Because it's looking error free, there is a good chance I will release the latest version which is up to 1.1.5 this weekend sometime. I skipped a version because I've been working on many revisions and updates. Keep your eyes peeled.

Gooner 06-01-2007 08:37 PM

Thankyou so much for such a great modification, For me this is the best mod on this site, Thanks and keep your great work up. !!!!!!!!!!!

elricstorm 06-01-2007 11:14 PM

Version 1.1.5 has now been released. Please check notes in main thread and version notes before downloading and installing/upgrading. Also make sure that you read the installation notes no matter if you are newly installing or upgrading. EVERYONE needs to read the instructions.

Thanks and enjoy. If you have any questions or concerns, please feel free to post here. Also, don't forget to vote. :)

This addon is now nearing the end of beta. Once the alternates system is fully tested and the class max system is in place, I will move it out of beta.

Noxious 06-02-2007 12:58 PM

hi, the armory updates dont seem to work with EU servers

*Edit* got it to work by altering the if eu function in the product file, either i'm unsure of how to change the local or if its suppost to be automatic its not detecting it.

If anyone else from europe is having this problem if you contact me, i'll email you my modded version of this mod untill the official fix is out

elricstorm 06-02-2007 03:41 PM

I know what I forgot to include. I'll fix it asap. I just forgot to add vboptions for EU or American servers. right now the localization is set for american. I'll have it fixed in about 20 minutes.

elricstorm 06-02-2007 04:18 PM

released version 1.1.6 which fixes the locale issue and allows for both US and European server configurations. Please make sure you check the change log in the top post and also re-read the alternates section so you understand how to configure options. Everything should be self-explanatory. Thanks for bringing this to my attention noxious.. As always, it's the community that drives the effort and helps to polish this addon up.

For those of you upgrading from version 1.1.5 to 1.1.6 you only need to "overwrite" the product when importing. Nothing else needs to be done.

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 :(

elricstorm 06-04-2007 01:40 AM

I was so brain satuated I forgot to include the table prefix for the modified sql statements. I'll fix that and look into the sorts.

elricstorm 06-04-2007 01:58 AM

Version 1.1.8 fixes the sql prefix and re-adds the sorting method for class type. Thanks for the early catch and thanks for the feedback folks.

So, now that we have the alternates system in, the next feature update is going to concentrate on class max limitations for events. So, I have not begun to design the feature and would like some feedback on this. If you had your chance to add 3 modifications to the calendar, what would those modifications be? List them in order from highest priority to lowest priority.

Feedback helps folks. :)

Some tweaks to the system that I plan to make:
  • Adding an alternate checkbox underneath the allow signups to allow for alternates on a per event basis. (I figure this will help for those guilds that dont' want to allow alternates on events)
  • An extra column noting whether or not the character is a main or an alternate.

Gooner 06-04-2007 05:09 AM

Thankyou, you are so fast :) i will report any bugs i find here,

elricstorm 06-04-2007 04:27 PM

So, my thinking is this:

I'm going to work on creating custom calendar fields that will be stored in the calendarcustomfield table. These will be something along the lines of:

Instance Name
Type of Event
Loot Rules
Maximum Participants
Druid Max
Hunter Max
Mage Max
etc.
  • When you create an event, the instance name would have a drop down that shows you all of the instances currently in Wow.
  • The type of event would state whether or not it's group or raid or other.
  • The loot rules would be a "fill in box" that you can put in what you want.
  • Maximum Participants would be a "fill in box" that you can put in ## number.
  • Druid Max, Hunter Max, etc. would be the class maximums that would be a fill in box that you could input ## number.

I have some of these fields already created on my calendar and I can actually add these fields to the addon and then program the code based on the inputs you use. It would be a bit more polished this way.

Any objections?

Gooner 06-04-2007 04:45 PM

sounds great, espcially the Instance name, That would be good.

elricstorm 06-05-2007 11:10 AM

I'm working on polishing up the URL parsing code so that if your browser timeouts when trying to connect to the armory, you don't overwrite your existing armorydata with empty data. This has been an uncommon occurrence but it has happened. While the issue is only temporary because as soon as you reconnect to the armory, the correct data is updated correctly, it's still an annoying thing to see happen. The data is stored in a vbulletin table but the replacement data being directed into that table is the problem. I will keep you posted.

elricstorm 06-05-2007 03:18 PM

Version 1.1.9 has been updated.

This version should fix the small issues present with timed out armory URL parsing and fix any empty data values from hitting the armorydata table which would overwrite existing "good" data.

As always, if you find any issues please report them to me asap.

Thanks,

Hyrel 06-05-2007 09:18 PM

I've installed and reinstalled everything several times now but when I create an event and check the sign up box I get a blank page. If I refresh the page I get a download for the calendar.php which contains this code:

Quote:

<br /><strong>Warning</strong>: file_get_contents() [<a href='function.file-get-contents'>function.file-get-contents</a>]: URL file-access is disabled in the server configuration in <strong>/calendar.php(1208) : eval()'d code</strong> on line <strong>194</strong><br /><br /><strong>Warning</strong>: file_get_contents(http://armory.worldofwarcraft.com/ch...&amp;n=Phetish) [<a href='function.file-get-contents'>function.file-get-contents</a>]: failed to open stream: no suitable wrapper could be found in <strong>/calendar.php(1208) : eval()'d code</strong> on line <strong>194</strong><br /><br /><strong>Warning</strong>: file_get_contents() [<a href='function.file-get-contents'>function.file-get-contents</a>]: URL file-access is disabled in the server configuration in <strong>/calendar.php(1208) : eval()'d code</strong> on line <strong>194</strong><br /><br /><strong>Warning</strong>: file_get_contents(http://armory.worldofwarcraft.com/ch...ak&amp;n=Hyrel) [<a href='function.file-get-contents'>function.file-get-contents</a>]: failed to open stream: no suitable wrapper could be found in <strong>/calendar.php(1208) : eval()'d code</strong> on line <strong>194</strong><br /><br /><strong>Warning</strong>: file_get_contents() [<a href='function.file-get-contents'>function.file-get-contents</a>]: URL file-access is disabled in the server configuration in <strong>/calendar.php(1208) : eval()'d code</strong> on line <strong>194</strong><br /><br /><strong>Warning</strong>: file_get_contents(http://armory.worldofwarcraft.com/ch...mp;n=Nymphidia) [<a href='function.file-get-contents'>function.file-get-contents</a>]: failed to open stream: no suitable wrapper could be found in <strong>/calendar.php(1208) : eval()'d code</strong> on line <strong>194</strong><br />‹

Hyrel 06-05-2007 09:46 PM

ok this fixed the problem:

uninstall, open up the xml file, and edit it like so:
Find: $xml = file_get_contents($url);
replace with:
// $xml = file_get_contents($url);
// Nah, let's cURL it instead
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_URL, $url);
$xml = curl_exec($ch);
curl_close($ch);
// cURL'd

elricstorm 06-05-2007 10:31 PM

The error you were having in your original thread is due to your hosting provider not having your php.ini settings set to allow_url_fopen.

You need to contact your hosting provider and have them set the allow_url_fopen option to on.

http://us.php.net/filesystem

I will not be changing this piece of code to support any curl functions. fopen is pretty straightforward and easy to code and not all hosts have curl installed in their libraries. Also, curl is more beneficial if you have to authenticate and we don't really need to authenticate to this data. But, in case others have an issue with being able to connect, your "workaround" is definitely a good note for others.

Thanks mate.


All times are GMT. The time now is 08:25 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.01445 seconds
  • Memory Usage 1,855KB
  • 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
  • (2)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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