View Full Version : Add-On Releases - World of Warcraft Event Calendar
elricstorm
04-18-2007, 10:00 PM
What does this Mod do?
.
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
.
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?
.
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 instructionsReview the "instructions" contained in the zip file before installing this product.
Creating a Calendar Entry
.
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
.
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
.
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
.
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:
.
Farcaster:
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
Gryphon:
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!
Wayne Luke
04-19-2007, 06:57 PM
Thanks.. will look into installing this later. Just a quick question, this replaces Farcaster's event attendance mod correct?
elricstorm
04-19-2007, 06:59 PM
Edit: screenshots were no longer valid.
elricstorm
04-19-2007, 07:02 PM
Yes Wayne - that is correct. This calendar and farcaster's will not work side by side but this calendar really only applies to those who play world of warcraft and maybe Farcaster can figure out a way to incorporate some of the features into his calendar. Anyhoo, just a point of thought. :)
Gryphon
04-19-2007, 10:48 PM
Nice, problem with field id however. I am up to field115, field8 and the like have been passed up a while ago.
You will need cp options for people to file in their id's, it is unlikely they will have the same id's available.
colicab-d
04-20-2007, 12:17 AM
Yeh i tried but got a few Db erros with this. Will wait for a more complete release but am v.interested in the mod in general
ssslippy
04-20-2007, 01:44 AM
ok installed but can not figure out where to have users signup? I did modify the fields to match mine.
Also your mod seems to use phrases that dont exist?
Masked Crusader
04-20-2007, 02:57 AM
*Marked as installed*
Going to try out the install now. Will get back with you ASAP with any problems.
Masked Crusader
04-20-2007, 04:02 AM
Alright, installed just fine. Created all of the fields to match up with yours.
However, the table does not create when the event is created. Also, there is no rsvp options like you show in your picture.
What am I missing here?
Masked Crusader
04-20-2007, 04:13 AM
Also, does Farcaster's Event Attendance have to be installed for this to work, or does this do the job itself?
Because, from what it looks like, the product was either created incorrectly, or Farcaster's addon is required to make this work.
D33mon
04-20-2007, 06:32 AM
Im having the same problem. Installed it, but no RSVP option apears. All the extra fields are their and I can check the "users can sign up" when creating event.. but other then that. No effect.
Masked Crusader
04-20-2007, 07:06 AM
Good to hear that I am not the only person not getting this working.
Was feeling like a moron for a bit! lol :)
elricstorm
04-20-2007, 10:51 AM
Sorry about that everyone. I forgot to include one important set of instructions. I added that to the top. It was late in the day for me and my brain was a little over-saturated. I added the template step above. Make sure you perform the calendar_showeventsbit step above.
elricstorm
04-20-2007, 10:53 AM
Nice, problem with field id however. I am up to field115, field8 and the like have been passed up a while ago.
You will need cp options for people to file in their id's, it is unlikely they will have the same id's available.
That's next on my list of things to do. In the meantime you can do one of two different things to get around this:
1. edit your profile fields and swap four of them out and you can order the display in whatever way you want.
OR
2. uninstall the addon and edit the .xml file directly and search for field5, field6, field7, field8 and change those field numbers to match the new fields you create. Then, reinstall.
Thanks for the suggestion. It's definitely next on my list. :)
elricstorm
04-20-2007, 10:54 AM
Also, does Farcaster's Event Attendance have to be installed for this to work, or does this do the job itself?
Because, from what it looks like, the product was either created incorrectly, or Farcaster's addon is required to make this work.
Farcaster's addon is not compatible with this addon. I corrected the instructions to include the template modifications which I forgot to include. You cannot use both.
elricstorm
04-20-2007, 11:16 AM
Added a section above that also includes the vb options area where you can decide which calendars to include/exclude and how you want the calendar to sort, and by which field.
Masked Crusader
04-20-2007, 05:33 PM
Thanks Elric for being on top of the ball.
I am sure that a TON of people appreciate the hard work you put into this addon. God knows I appreciate it :).
Masked Crusader
04-20-2007, 06:47 PM
Alright, got another quick question for you.
I need to change the class colors. They are way too light for my skin style. I looked through the XML file to find that the style css is commented out.
Where can I change the colors for the classses?
elricstorm
04-20-2007, 07:28 PM
Line 80 - 88 of the XML product file:
.style1 {color: #FF3300}
.style2 {color: #33FF33}
.style3 {color: #33FFFF}
.style4 {color: #FF66CC}
.style5 {color: #FFFFFF}
.style6 {color: #FFFF66}
.style7 {color: #FF3333}
.style8 {color: #CC66CC}
.style9 {color: #CC9966}
Style 1 = Druid
Style 2 = Hunter
Style 3 = mage
Style 4 = Paladin
Style 5 = Priest
Style 6 = Rogue
Style 7 = Shaman
Style 8 = Warlock
Style 9 = Warrior
This is another item I will most likely add to my list of revisions so that people can color-code or not color-code the signups. Thanks for the input once again.
Masked Crusader
04-20-2007, 10:50 PM
Thanks Elric.
Hey, if want any assistance developing this mod more, I am sure that I am can contribute some of my time to helping you out if you would like.
My contact info is as follows: E-mail/MSN (shanejeffery86@hotmail.com) and AIM (ShowNoLove00). I am experienced with CSS, XHTML, pHp, SQL scripting, and Javascript.
Let me know bud.
elricstorm
04-20-2007, 11:03 PM
Thanks Shane - I'm always interested in help. I'll give you a holler sometime this weekend or early next week. A few things that I definitely want to add in are "alternates" and the option coding for all of these customizable toggles.
Masked Crusader
04-21-2007, 12:32 AM
Look forward to hearing from you.
If I am not on either of the IM programs, just shoot me an e-mail and I will get back with ASAP.
elricstorm
04-21-2007, 12:57 PM
Will do.
Also, as a reminder, if anyone has "any" suggestions you want to see in this that may make it better, please suggest them and let me know.
gmrstudios
04-27-2007, 06:58 PM
I would love to see a feature that pulls character information from the armory instead of from profile fields. Not sure if its practical but including information about the person who signed up dynamically would remove alot of the headaches associated with people keeping their profile up to date.
Hi,
This is an awsome mod! Exactly what I wanted really. I had used Farcasters Event mod in the past, and this had one of the features I requested (using a custom field value instead of username).
How about integrating this with vB Event Forums (https://vborg.vbsupport.ru/showthread.php?t=123416) ? I think that would make it just about perfect :D
Thanks again for the mod.
elricstorm
05-01-2007, 05:27 PM
I would love to see a feature that pulls character information from the armory instead of from profile fields. Not sure if its practical but including information about the person who signed up dynamically would remove alot of the headaches associated with people keeping their profile up to date.
The armory is still in beta and there are a lot of kinks to be worked out. One of the big issues with using the armory is how slow it is. Also, Blizzard would have to release all of the XML element tags because almost all of the information is fairly hidden.
elricstorm
05-03-2007, 04:25 PM
Updated version to 1.1.0. Please see changes in red in the main mod section description.
Edit: Added a screenshot to show the new added options.
Gryphon
05-03-2007, 05:24 PM
FYI: The armory is much faster when fetching the contents than it is when viewing it in the browser. I am currently working on a project (http://www.alliedtribalforces.com/gwowroster.php) which does such a thing. elricstorm feel free to PM me if you want more info.
elricstorm
05-03-2007, 05:46 PM
Thanks mate.
Hi,
This is an awsome mod! Exactly what I wanted really. I had used Farcasters Event mod in the past, and this had one of the features I requested (using a custom field value instead of username).
How about integrating this with vB Event Forums (https://vborg.vbsupport.ru/showthread.php?t=123416) ? I think that would make it just about perfect :D
Thanks again for the mod.
Any thoughts/updates as to the above? :)
elricstorm
05-07-2007, 01:36 AM
Not too sure about that yet Juum. Thanks to Blackjacks help, I am now working on implementing code features that will incorporate the armory into the my calendar mod. I'll look into the other code and think about it though.
CathyAnne
05-07-2007, 03:11 PM
I love this addon, it's made things much easier for me. Thank you so much for making it. I do have one question.
When people RSVP, it's currently placed in alphabetical order. Is it possible to have the RSVP listed by date? This would help me immensely. Is this a change I could make or it would it be something that would require a bit of work?
Thanks again for this great addition to my forum.
elricstorm
05-08-2007, 11:04 AM
In the vboptions area for the calendar there is a sort feature. You can sort by class, date, or by name there.
SocialNetworkBuzz
05-08-2007, 05:36 PM
This installed easy,
but mine doesn't look yours when they sign up (see screenie attached). Also it is not counting the number per class to sign up.
Thanks for such a great mod!
rezenous
05-09-2007, 06:32 PM
I'm having the same problem as Stabatha, tried reinstalling, changing fields etc but no luck
SocialNetworkBuzz
05-09-2007, 10:50 PM
Also 2 things I'd love to see in the future... on the cal page under the event x/25 confirmed x/x on stand by
the other to set the first set amount per class as signed up the rest on standby. GEM and Guild Cal both do this. This will prevent 10 mages from signing up from Kara and 8 +++++ing they got put on standby *grin* when only 2 of them get to go. If the event allowed 3 mages and 2 signed up yet it would show mages 2/3 etc...
again great hack! hope we can work the bugs out to make it flawless... Now we just need a DKP system like this and guilds can be fully powered by vB!
4yBak
05-11-2007, 11:40 AM
Thanks for hack - it's very interesting :)
Have one small problem - this hack don't calculate Total Signed Up for each class (see an attachment for more information).
As you can see - we have 2 members, but we don't have digit 1 in column Priest and Shaman. How to fix this issue?
elricstorm
05-11-2007, 12:52 PM
sorry bout that - known issue - I'll fix it shortly.
SocialNetworkBuzz
05-11-2007, 03:27 PM
What about the template design not forming a table like in my screenie in post #34.. I clicked install... show some love :P
elricstorm
05-11-2007, 03:43 PM
Issue with class counts is fixed. I changed
$signup['$field6']
to..
$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.
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
Issue with class counts is fixed. I changed
$signup['$field6']
to..
$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
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.
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.
// 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:
<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/character-sheet.xml?r=Aerie+Peak&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/character-sheet.xml?r=Aerie+Peak&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/character-sheet.xml?r=Aerie+Peak&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.
Hyrel
06-06-2007, 04:21 AM
My armory data isn't showing up though, so I may have missed something else up along the way hehe. The fields are just blank for level, class, race.
Gooner
06-06-2007, 05:10 AM
Well, ive got a wierd issue going on in my callander, Alot of people have signed but there are 3 signs with absolutely nothing, and the guild leaders armory information isnt showing at all, I have triple cheked the name and its exactly how its spelled in the armory, all case sensitive and everything.. The blank signups are confusing me also, If this is because of members signing without using a character name, Is it possible to make it a requirement to have a character name, and if they dont have one, dont allow them to signup, Here is a screenshot of the wierdness.
Click picture for full size.
http://www.eu-otd.com/wierd.jpg
[PS] You may noticed i removed the Maybe button from the signup option, This is due to our guild not allowing maybes.
NightPhoenix
06-06-2007, 05:54 AM
I installed the update over the previous install, and now I keep getting the following error:
Warning: file_get_contents(http://armory.worldofwarcraft.com/character-sheet.xml?r=Shu'Halo&n=Nitefire) [function.file-get-contents]: failed to open stream: HTTP request failed! in /calendar.php(1208) : eval()'d code on line 194
Apparently, an armory issue, but I never received it with the previous version of the event calendar.
NightPhoenix
06-06-2007, 06:01 AM
Follow up on the above post, I just received a more in depth error message:
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.field6
FROM wowraid ea
LEFT JOIN userfield AS userfield ON userfield.userid = ea.userid
LEFT JOIN armorydata arm ON arm.userid = ea.userid
WHERE eventid = 024
AND ocdate = '1181001600'
ORDER BY
ea.response, ea.signup_date;
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Wednesday, June 6th 2007 @ 02:53:47 AM
Script : http://www.shuhalo.com/home/calendar.php?do=getinfo&e=24&day=2007-6-5&c=1
Referrer : http://www.shuhalo.com/home/calendar.php
IP Address : 68.41.165.188
Username : NightFire
Classname : vb_database
Right now I have roughly 200 of these errors reported in my email with the only variables being Event ID and Ocdate (of course, the IPs and user names are different too :) )
elricstorm
06-06-2007, 10:51 AM
Well, ive got a wierd issue going on in my callander, Alot of people have signed but there are 3 signs with absolutely nothing, and the guild leaders armory information isnt showing at all, I have triple cheked the name and its exactly how its spelled in the armory, all case sensitive and everything.. The blank signups are confusing me also, If this is because of members signing without using a character name, Is it possible to make it a requirement to have a character name, and if they dont have one, dont allow them to signup, Here is a screenshot of the wierdness.
[PS] You may noticed i removed the Maybe button from the signup option, This is due to our guild not allowing maybes.
The first two blank rows on that screenshot are because two people in your guild did not fill in their "main character" name. The one for Taursos is due to an armorydata sync issue which I fixed in 1.1.9. I noticed you are on 1.1.8. In 1.1.9 I fixed the issues with the problem you are having. The basic concept is this:
When people go to the event, they call their own main character name, alternate1 name, and alternate2 name data from the armory and store it in the armorydata table. The previous issue was that sometimes certain people would have "connection" problem and would hit the armory and not finish the data polling. They would then update their own armorydata information into the new table I created with "blank" data.
This issue has been fixed in 1.1.9.
Now they use an fsocketopen for timeout and there's also a check to make sure that they aren't passing empty data back to your own database armorydata table. If they are trying to pass empty data, it simply does not allow any updates to occur, saving the data already there in the table. I hope that makes sense.
To temporarily fix the issue, you can do one of two things.
Download and install 1.1.9 and insert their data manually into the armorydata table.
Download and install 1.1.9 and tell them to visit the event again, which will forceably fix the issue automatically.
In addition
You need to make sure that the main character profile field you created is "required" at time of registration and on update/edits. If you do not do this, you will encounter similar things. What's really happening here is that people on your site are not updating the required field. The only real issue you are experiencing is the empty data problem on Taursos. You can update his information manually this one time after updating to 1.1.9 or have him revisit the event.
The design reasoning was to be able to bypass a manual update or another button update push to populate the armorydata table I created. I might, in future versions provide an admin udpate which would do that so you can manually push and sync your armorydata information if you encounter such a problem.
I hope that helps answer the question. If anyone on 1.1.9 after making sure you have no empty database in the armorydata encounters this problem, I'd like to know. Please remember that the person whose data is blank needs to revisit the event to repopulate the data or you can manually do it for them by editing their information directly in the armorydata table. After you do this, it shouldn't reoccur.
With anything new (armorydata) expect some bugs. But, I'll make sure they all get fixed. :)
elricstorm
06-06-2007, 10:57 AM
Follow up on the above post, I just received a more in depth error message:
Right now I have roughly 200 of these errors reported in my email with the only variables being Event ID and Ocdate (of course, the IPs and user names are different too :) )
What version of PHP are you running?
What version of mysql are you running?
Do me a favor also? Execute the query directly in your phpmyadmin. Just copy and paste the query you posted above and execute it in your phpmyadmin. Let me know if you receive the same error.
I think I know what might be happening in your case and should be able to fix it. Please respond. Thanks mate. :)
EDIT:
http://www.vbulletin.com/forum/showthread.php?t=161266
Click on this link and you will find a quick fix if you've set this to something other than what the default is supposed to be. This is most likely the reason for this issue. Thanks.
elricstorm
06-06-2007, 11:09 AM
My armory data isn't showing up though, so I may have missed something else up along the way hehe. The fields are just blank for level, class, race.
You need to make sure you created the custom user profile fields I outlined in the document.
Create one field for Main Character Name
Create one field for Alternate Name 1
Create one field for Alternate Name 2
Write down the IDs of these fields on a piece of paper (ex. field4, field5, field6 -whatever their names are)
Go into vboptions and to Elricstorm's World of Warcraft and do the following:
Fill out the appropriate information for Server, locale, and at the very bottom input your field names for the profile fields you created.
I would suggest re-reading the instructions and following them step by step.
And, lastly, people on your boards need to update their main character information in their profiles or you need to do it for them.
Thanks,
elricstorm
06-06-2007, 11:24 AM
For those of you always hating to remind people to fill out the custom profile fields you created, I suggest using this:
https://vborg.vbsupport.ru/showthread.php?t=124354
I use it on my forums and it works like a charm. Gooner something like this will help you out a lot. I have a guild that has 180 members in it. I hate policing every member so something like this works out great.
The other thing you should do is make that main character field mandatory by changing it to "required at time of registration and on updates".
Gooner
06-06-2007, 04:03 PM
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.
elricstorm
06-06-2007, 04:53 PM
Thanks for being patient with all of this folks.
I just added version 1.2.0 which removes the fsocketopen checks as it was really behaving badly and not providing the type of connectivity testing I wanted performed. Instead of timing out if the armory was not responsive, it turns out that the armory url was responsive but sometimes not returning results for up to 10 minutes! So, fsocketopen would not close the socket. I tried using a cURL method and also a socket_timeout method but both still had unexpected results. Therefore, I removed that bit of code altogether.
I kept the bit of code that checks to make sure that $cclass is not returning empty and if not, it continues on with the process. If it comes up empty it should not overwrite data into the armorydata table. I also adjusted a couple of other minor code tweaks but overall, it should perform better.
So, for all those that I replied to earlier, you can still read my suggestions on optimizing your site, etc. but I would upgrade to 1.2.0 and have it fix the problems you encountered with 1.1.9.
thanks everyone.
elricstorm
06-06-2007, 05:01 PM
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
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.
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., 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.response, ea.signup_date;
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 ' userfield.
FROM forumwowraid ea
LEFT JOIN forumuserfield AS userfield ON' at line 3
Error Number : 1064
Date : Wednesday, June 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:
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
...
Yours is an easy fix.
Do you see where you have:
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., 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
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.
Hyrel
06-06-2007, 11:04 PM
Ok the error is gone but I'm back to where I was last night.
http://www.rivalnation.com/forums/calendar.php?do=getinfo&e=10
It works but the armory data isn't posting. It shows 1 player in the total signup but not in the classes and level, class, and race are blank.
Noxious
06-07-2007, 12:07 AM
i can't get my event pages to load at all now since i updated to 1.2.0, didn't see them have any problems with 1.1.9
elricstorm
06-07-2007, 12:09 AM
Hyrel did you check your armorydata table to see what was in there? If it's propogated, see what's posted in that table. In addition post a screenshot of custom user profile fields so I can see their IDs. In addition, show me a screenshot of your vboptions for this addon in complete detail.
Thanks.
Noxious
06-07-2007, 12:16 AM
i think i'm having problems getting my pages to load as i also can't seem to get the european wow armory to load either, so at a guess with the timeout being taken out its timing your site out when the armory is also down on your respective wow site
elricstorm
06-07-2007, 12:17 AM
Shane, do a complete uninstall and then do a reinstall of the product. Set your vboptions after reinstalling, particularly the field ids and the server information. Create a test event but "don't check allow signups". View the event and make sure their are no sql errors. If not, then edit the event and "allow signups". Let me know what happens. Thanks.
elricstorm
06-07-2007, 12:22 AM
i think i'm having problems getting my pages to load as i also can't seem to get the european wow armory to load either, so at a guess with the timeout being taken out its timing your site out when the armory is also down on your respective wow site
Yes you are absolutely correct here. I did a couple of tests on both armory sites for EU and US.
I'm looking into a timeout redirect code that actually works now. I think in your case, you don't have anything wrong and it's just that the european armory site was down for a short while.
Please be patient as I work on a new timeout code that works. My problem is that the timeouts for url checking show up as true even when the armory site is not responding for either european or US. I don't believe that they are really ever down but that they are just bogged down with hits and that they eventually do work. So, timeout settings are very difficult to program for that site. I'll find another solution that works. I'm testing out several options.
I knew the armory would pose some problems but I know I'll get around it. :)
elricstorm
06-07-2007, 12:54 AM
It looks like I found the answer I needed and I had to actually add it directly to the parser function itself.
I'll post the new product in a moment but this appears to do the trick:
function parse_wowarmory($url)
{
ini_set('user_agent', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)');
$ch = curl_init();
$timeout = 5;
curl_setopt ($ch, CURLOPT_URL, $url);
curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt ($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
$xml = curl_exec($ch);
require_once(DIR . '/includes/class_xml.php');
$xmlobj = new vB_XML_Parser($xml);
return $xmlobj->parse();
curl_close($ch);
}
thanks to Hyrel for providing it. However, it might be returning empty arrays. Still testing with this code further.
elricstorm
06-07-2007, 01:02 AM
Product updated to 1.2.1 with cURL changes in effect. I believe this is the best route since fsockopen behaves indifferently with the armory. Let me know if your site performs any better with the code.
The default setting is 10 seconds for timeout. You can edit the default timeout and set it to whatever you would like in your vboptions. The setting is there. And, yes, this time it does work. If you test with the timeout settings, let me know what you feel is a good round timeout number response for both US and EU armory sites. I'm guessing that the safe bet is to set it to 15 seconds but I'll do that just for my own site. Some of you might want your events to load up faster so you could just set it back down to 5 seconds.
I looked at the armory tonight and did a couple of search character tests and it looks like both armory sites are having severe trouble with style sheets and xsl data. So, this might be why the armory is unresponsive.
The timeout is only meant as a workaround for when the armory is down. I'll provide three quick scenarios on how this code will work now:
Scenario One: Armory responding fine with no issues
-- Your calendar will move fast
-- Events will show up quickly
-- Character data will be populated into the armorydata table for main, alternate1, alternate2
-- Alternate1, and 2 are optional so it will bypass these completely if they are blank
Scenario Two: Armory not responding (after) you've populated your database with previous events
-- Your calendar will delay to "x" seconds based on the timer you set
-- Events will show up after "x" seconds based on the timer you set
-- Character data will not be populated into the armorydata table overwriting "good" data
-- Character data will be shown on your events based on what already existed in your armorydata
Scenario Three: Armoy not responding and a "new" member who never signed up before signs up
-- Your calendar will show drop downs for the fields the new member added in their profile
-- Because the armory is non-responsive and the character never had data in the armordata table, fields will show up blank besides character name.
Scenario three is the one scenario I would like to work on. So, I need some input on what you want to see in your table for data that is not there. This would only be for character data that was never populated ever, and it would only show until the next time the character visited when the armory was back up.
Keep in mind, once your databases are fully populated with some type of information, you won't see any issues like this. The worst you would see is "outdated' information because the character info wouldn't have been updated. Again, any input on this would be nice.
Thanks everyone.
elricstorm
06-07-2007, 02:12 AM
Okay version 1.1.8 is the current "good" version although it does not have timeout features. However, it tests out fine and does return proper array data. Version 1.1.9 has the first of the timeout features with fsockopen but with unexpected results. Version 1.2.1 has the new cURL features but it's untested and may not produce the right results.
Therefore I put the previous_versions.zip file up and recommend that anyone starting off "new" or for those of you having issues with getting this going - try version 1.1.8 first and if that works, then you can upgrade. Personally, I believe that 1.2.1 needs a bit more testing but I wanted to get it out there just in case it works well.
Thanks,
Masked Crusader
06-07-2007, 03:27 AM
Alright got it working.
HOWEVER still somethings that are not working.
NOTE: I have the newest version of the mod.
If a person signs up, it does not show the number of people signed up for that class.
Also, the class, level, and race fields are not populating...the server is correct as is the zone of the server.
Any ideas?
Hyrel
06-07-2007, 03:30 AM
My theory is that the armory is timing out. I'm going to continue to mess with that and see what happens. In the meantime here's the screenshots.
Hyrel
06-07-2007, 03:31 AM
yep same thing as Shane
Masked Crusader
06-07-2007, 04:16 AM
Yup your screens are the same as mine.
elricstorm
06-07-2007, 10:34 AM
Use version 1.2.0 from the previous_versions zip I included. cURL returns an empty array. I confirmed that with some extensive testing. I see nothing wrong with the cURL code but the armory does not like it. Version 1.2.0 does work but there aren't any time out features included with it. However it includes the empty data checking feature. So, if the armory is slow, the event checking will be slow too but I'll find a way around it.
The reason why all of your class/level/race information is coming up blank is because the cURL returns:
Array() in version 1.2.1
In 1.2.0 it returns
Array
(
data..
data..
data..
)
I've included a zip for testing which shows the difference between the normal file_get_contents and also CURL. If you access these directly on your site you will see what I'm talking about.
elricstorm
06-07-2007, 11:14 AM
Good news!
This works 100%.
function parse_wowarmory($url)
{
ini_set('user_agent', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)');
$ch = curl_init();
$timeout = 30;
$xml = file_get_contents($url);
curl_setopt($ch, CURLOPT_URL, $xml);
curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt ($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
require_once(DIR . '/includes/class_xml.php');
$xmlobj = new vB_XML_Parser($xml);
return $xmlobj->parse();
curl_exec($ch);
curl_close($ch);
}
I'm doing some tests and will report back in a bit.
Masked Crusader
06-07-2007, 02:56 PM
Elricstorm,
I appreciate you staying on top of this bud. I thought I was going to be waiting a month for a response :). I am used to it with other mod designers around here.
Anyways, I am looking forward to a new release.
Gooner
06-07-2007, 03:59 PM
Elricstorm,
I appreciate you staying on top of this bud. I thought I was going to be waiting a month for a response :). I am used to it with other mod designers around here.
Anyways, I am looking forward to a new release.
Elric is Win.
(A New Idea)
I just thought of an idea when i find out sometimes my events page wont load because of armory being down, What if every character gets checked and stored into the database, So then the calander only needs to access the armory once for the first update, And manual updates of character info can be made through the guild members pressing an update button, I think this will solve the problem of not being able to pull then information from the armory when the wow site is down.
Click event -> Check Armory -> pull info from armory into DB or file.
then maybe after that it could go...
Click event -> check armory -> no reply from armory so check DB or file.
or in another instance..
Click event -> check armory ->Different data found to that in DB -> overwrite old data with new data found, If armory dont load then load last best data from DB.
Something like that??
Masked Crusader
06-07-2007, 04:18 PM
Elric is Win.
(A New Idea)
I just thought of an idea when i find out sometimes my events page wont load because of armory being down, What if every character gets checked and stored into the database, So then the calander only needs to access the armory once for the first update, And manual updates of character info can be made through the guild members pressing an update button, I think this will solve the problem of not being able to pull then information from the armory when the wow site is down.
Click event -> Check Armory -> pull info from armory into DB or file.
then maybe after that it could go...
Click event -> check armory -> no reply from armory so check DB or file.
or in another instance..
Click event -> check armory ->Different data found to that in DB -> overwrite old data with new data found, If armory dont load then load last best data from DB.
Something like that??
FANTASTIC IDEA! I am going to elaborate on it though.
Put an update button right next to the character name field on the right hand side in the User CP ---> Edit Profile.
That should be easy enough imo.
Maybe I am wrong though :)
elricstorm
06-07-2007, 05:43 PM
thanks to Blacksnake I may have a better piece of code for the new version to be released tonight. We'll see how this new bit of code works first. I'll have it updated this evening.
Gooner
06-07-2007, 06:00 PM
sweet, this maybe the virsion i update to, ill be updating every other virsion, because your so fast, otherwise ill be updating every day :P
Gooner
06-07-2007, 09:04 PM
I just realised, The only real big issue i have with this system is that every update i install all the raid signup information gets lost, which means another 40 people needs to re-sign, and because our guild raids almost every night, This can be quite a big issue...
Is there any way around installing updates without losing the sign information?
If not i guess i can just copy/paste the sign information to the forums.
Noxious
06-07-2007, 09:52 PM
yeah dont uninstall the previous version and just allow overwrite when you import the product file.
elricstorm
06-07-2007, 10:16 PM
Correct. Don't uninstall and reinstall the product. Doing that causes all of the tables to be removed and that's why you are losing your information. Just import the product and choose "overwrite" yes. You only have to uninstall and reinstall if you were upgrading from any version that came before the alternates system was implemented.
elricstorm
06-08-2007, 02:06 AM
1.2.2 will come tomorrow as I left my flash memory key at work with my code on it. :) - lol
Gooner
06-08-2007, 04:21 AM
sweet, look forward to 1.2.2 and thanks for the help :D
elricstorm
06-08-2007, 12:31 PM
1.2.2 and 1.2.3 are combined - I'll be adding the product update this afternoon. Also, it's moving "a lot" faster now with the way I've worked on the design. There will be a functions.php file to add to your /includes folder now and I'm building a .chm documentation file so that it answers all questions regarding the system. Everything should be in place by 5 pm today.
Zoom zoom zoom!
Quickness
06-08-2007, 03:41 PM
Looking forward to the new release since 1.2.1 works, but doesn't pull any info from the Armory.
Noxious
06-08-2007, 04:35 PM
Looking forward to the new release since 1.2.1 works, but doesn't pull any info from the Armory.
yeah, elricstorm's explained about that a problem with the curl timeout string within the code. If you need to get it sorted, download the previous versions zip from this mod and install version 1.2.0. just overwrite the data and don't uninstall so you keep your info
elricstorm
06-08-2007, 05:01 PM
Version 1.2.3 released
Please download and read the .chm instructions or the .txt instructions. CHM is nicer to look at and read. You have to do one PHP file upload now as well. They are both contained in the instructions.zip file.
Version 1.2.2 and 1.2.3 Combined changes
Created a wowcalendar_functions.php file that houses the wow parser. This was done to keep from encountering declaration errors that surfaced when viewing multiple events on a particular event day.
Created a new wow parser code that includes better checking and curl features for armory data retrieval.
Created a new .chm file to house all of the installation instructions, creation events, troubleshooting issues, and version notes.
Special thanks to Blackjack for his advice on the wowparser for the armory. I redesigned it based on his design coupled with the new curl features. It works pretty solidly now.
Noxious
06-08-2007, 05:09 PM
great dude, thanks, downloaded and installed
Quickness
06-08-2007, 05:09 PM
Installed it.. seems to work great. Thank you for the time you put into this.
Gooner
06-08-2007, 05:14 PM
Thanks for your hard work, Keep it up :D your doing a superb job., looking forward to 1.2.4
NightPhoenix
06-08-2007, 08:10 PM
Working very nicely so far... if I get any errors I'll post em... great work :)
elricstorm
06-08-2007, 08:18 PM
Thanks everyone. I really appreciate the kind words. I also appreciate the fact that you have been influential and supportive of the project by providing positive and negative feedback, and reporting any errors that surface. Community efforts drive projects and that means a lot to me.
Hyrel
06-08-2007, 09:46 PM
*scratches head* Ok, I know I'm missing something stupid and that's why it's not filling in the tables. The fields are set correctly, checked that first. The php file is in the forum includes. Does it matter that my file system is forums instead of forum?
And installed the new xml file. No errors ^_^ but no armory data too.
Anyone who does coding should be nominated for sainthood /bow to the code master. This stuff gives me headaches ^_^
Hyrel
06-08-2007, 09:50 PM
Love the new instructions btw, they look sexy.
Ulkesh
06-08-2007, 10:09 PM
Installed and set up 1.2.1 and everything was working beautifully. Had events created, users signing up for 'em, and life was good. :cool::up:
Upgraded to 1.2.3, and now getting "Unknown function: curl_init()" error. :( working on the issue with the host. I (and my users) love the add-on. I'm just hoping I can revert to the old version without erasing all my event data, until I can figure something out with my host, again. :erm:
Weird. cURL library wasn't included on the server. Time to recompile! :D
elricstorm
06-09-2007, 02:40 AM
Installed and set up 1.2.1 and everything was working beautifully. Had events created, users signing up for 'em, and life was good. :cool::up:
Upgraded to 1.2.3, and now getting "Unknown function: curl_init()" error. :( working on the issue with the host. I (and my users) love the add-on. I'm just hoping I can revert to the old version without erasing all my event data, until I can figure something out with my host, again. :erm:
Weird. cURL library wasn't included on the server. Time to recompile! :D
Yeah, that was the only reason why I waited with adding cURL to the code because I knew there would be some instances where the library was not loaded on the server. However, most hosting providers are now formally loading them since it is a much better library to work with where authentication is concerned. :)
elricstorm
06-09-2007, 02:42 AM
Love the new instructions btw, they look sexy.
Thanks - btw, did you get yours working. So far everyone says it's working great. I just want to make sure I didn't miss something in my instructions. :)
Hyrel
06-09-2007, 02:46 AM
Not yet =/ getting a friend to look through my code and see if they can find where I went astray.
elricstorm
06-09-2007, 02:53 AM
*scratches head* Ok, I know I'm missing something stupid and that's why it's not filling in the tables. The fields are set correctly, checked that first. The php file is in the forum includes. Does it matter that my file system is forums instead of forum?
And installed the new xml file. No errors ^_^ but no armory data too.
Anyone who does coding should be nominated for sainthood /bow to the code master. This stuff gives me headaches ^_^
What is your field name for main character?
What is your field name for alternate 1?
What is your field name for alternate 2?
What is your locale? US or EU?
What is your server name?
Did you modify the code?
elricstorm
06-09-2007, 02:45 PM
Version 1.2.3 is now the new stable version. When I come out with version 1.2.4 - the new version will be the beta version and 1.2.3 will be the stable version.
Zaeolos
06-09-2007, 05:06 PM
My only problem is when I create recurring events, the only one that shows up on the calendar is the first event of that sequence. Is this a vBulletin thing or is my board messed up.
Gooner
06-09-2007, 06:09 PM
I get this error with 1.2.3:
Fatal error: Call to undefined function: curl_init() in /home/gooner07/public_html/includes/wowcalendar_functions.php on line 10
Any reason why?
i did everything exactly by instructions, This was a clean install since my site got totally wiped today because of a critical hard disk error.
Hyrel
06-09-2007, 06:33 PM
I have some hidden issue on my board *grumbles* SO seeing how the guild is not using it yet and I hate looking for bugs, I'm going to purge the database and delete the files off the server and start over. I have a feeling it's an addon or mod I was trying out and thought I removed all traces of but missed some, missing things up. I was messing around with some memberlist mods and I have a feeling they are the ill messing things up -.-
Thanks again for all your help. For 2 years I've tried to find something that does what your doing. Phpraid was awesome except the lack of VB integration. And since guild members worldwide seem to suffer from the same laziness when it comes to using the guild website, different signups meant a good portion of the members wouldn't use it. Some because they are lazy; some because they are really clueless when it comes to the internet. So thank you again for making this available and for helping all us code noobs get it working ^_^
Zaeolos
06-09-2007, 06:33 PM
I get this error with 1.2.3:
Fatal error: Call to undefined function: curl_init() in /home/gooner07/public_html/includes/wowcalendar_functions.php on line 10
Any reason why?
i did everything exactly by instructions, This was a clean install since my site got totally wiped today because of a critical hard disk error.
I was getting that error at first. I did a phpinfo() and found that Curl had not been compiled into the php. Once I recompiled, everything was fine.
Gooner
06-09-2007, 06:35 PM
it seems my hosting company are still setting up the server, which earlyer today had a new HDD installed, i was told i needed to wait :P
Noxious
06-09-2007, 06:50 PM
well so far mine works great without a single problem :D
Hyrel
06-09-2007, 08:29 PM
ok... now I'm truly perplexed.
Clean install of VB on a clean DB. After the installation I setup the VB settings and installed the mod. Followed the instructions to the T. Since it is a clean install field5, field9, and field10 are used for character name, alternate 1 and alternate 2. I wasn't sure if fields 6, 7, and 8 needed to be empty so I made dummy fields and deleted them to get me to field 9 and 10. Same problem as before. No errors are coming up. Everything works except it isn't getting the armory data. So the class total data is empty and the class, level, and race fields are empty. Going to do some diging see if I can find anything.
Hyrel
06-09-2007, 08:35 PM
Here's a screenshot of the database tables...not sure if that helps any. the output is the same as the past screenshots.
elricstorm
06-10-2007, 03:52 AM
My only problem is when I create recurring events, the only one that shows up on the calendar is the first event of that sequence. Is this a vBulletin thing or is my board messed up.
No problems with recurring events on two test boards. Not sure exactly what you mean but most likely a vbulletin thing.
elricstorm
06-10-2007, 03:53 AM
it seems my hosting company are still setting up the server, which earlyer today had a new HDD installed, i was told i needed to wait :P
I'll add that to the next set of instructions. Yep, your hosting provider needs to install cURL library for your PHP compile. It's a very simple standard library that all hosting providers should include by default now anyways due to authetication.
elricstorm
06-10-2007, 04:02 AM
Here's a screenshot of the database tables...not sure if that helps any. the output is the same as the past screenshots.
Try placing an data insert in the armorydata table for your ID and see how the display works. You do not need to create more custom fields to get this to work with yours.
If you want, PM me and provide me a testuser account that has some admin privs to it and I'll look over your board and tell you what's going on. I won't be able to look over anything until tomorrow afternoon (sunday) but it's your call mate. :)
Take care.
Gooner
06-10-2007, 12:27 PM
Well, i thought it was, but my hosting company says that the cURL libarary is definatly 100% installed and compiled with PHP but i still recieve this error when trying to view an event ive made...
Fatal error: Call to undefined function: curl_init() in /home/gooner07/public_html/includes/wowcalendar_functions.php on line 10
Any ideas.?
elricstorm
06-10-2007, 01:21 PM
Well, i thought it was, but my hosting company says that the cURL libarary is definatly 100% installed and compiled with PHP but i still recieve this error when trying to view an event ive made...
Fatal error: Call to undefined function: curl_init() in /home/gooner07/public_html/includes/wowcalendar_functions.php on line 10
Any ideas.?
Check your phpinfo and find out yourself if it's there. Look to see what you have.
You should see something like:
CURL support enabled
CURL Information libcurl/7.13.1 OpenSSL/0.9.7f zlib/1.2.2.2 libidn/0.5.15
Gooner
06-10-2007, 01:43 PM
There is nothing on my PHPinfo script which says anything about CURL, i think its a simple case of Sh*t hosting, Can anyone advise me a good hosting company, A european one would be good, Im sick of my current host, My site has been crippled for several days and they wont fix it... Ive told them if they dont fix it i will move host... they are...
http://www.webhosting.uk.com/
Avoid them, The technical support is very poor, and my website has been down for 4 days....
Any advise on decent European host?
elricstorm
06-10-2007, 01:57 PM
There is nothing on my PHPinfo script which says anything about CURL, i think its a simple case of Sh*t hosting, Can anyone advise me a good hosting company, A european one would be good, Im sick of my current host, My site has been crippled for several days and they wont fix it... Ive told them if they dont fix it i will move host... they are...
http://www.webhosting.uk.com/
Avoid them, The technical support is very poor, and my website has been down for 4 days....
Any advise on decent European host?
Hrm, haven't looked deeply into hosting but you want to try to stay away from virtual hosting accounts if at all possible because you usually don't have any way to edit things yourself.
I would look for a hosting company that either provides "dedicated virtual hosting" with SSH capability and root access. If you can find that you should be fine. I use IPOWER which provides that capability and I'm able to load and install anything on my dedicated virtual server.
The error you had listed above is definitely an issue with curl not being installed/configured as a library. Let me know how it works out mate. In the interim, I'll see what I can do about providing a "non-curl" php file shortly. I moved the parser to a functions file so that I could eventually provide non-curl and curl support for people.
elricstorm
06-10-2007, 01:59 PM
Gooner try this file and write your other file as OLD_
Let me know how it works.
elricstorm
06-10-2007, 02:00 PM
Hyrel, check your PMs mate and read my notes. I looked over your site and I'm 100% positive it's mysql related. Read notes, run tests per my notes, and let me know what you find out.
Gooner
06-10-2007, 02:13 PM
Thanks mate, ive requested a few things from my host, so im waiting to see what they do, if not, im moving host, the only problem though is i dont know how to move my website domain to a new hosting site. anyone know?
elricstorm
06-10-2007, 04:07 PM
Thanks mate, ive requested a few things from my host, so im waiting to see what they do, if not, im moving host, the only problem though is i dont know how to move my website domain to a new hosting site. anyone know?
Download your site.
When you go to your new hosting provider you point your domain to the new DNS and 24 hours later or less it's in effect. (new hosting provider can help you with that)
Upload your site.
I would do it similarly to that because your old hosting provider probably doesn't do file transfers.
elricstorm
06-11-2007, 01:54 AM
Hyrel, read your PMs mate. I found your issue and posted why it was happening. If you fix the two settings I gave you, it will work 100%. Thanks mate.
VenomMaster
06-11-2007, 06:30 AM
Hey elric,
first let me say that this hack is absolutely incredible! I'll consider to donate for this... :D
But i have a little issue with your Mod. Maybe it's only my fault, but if you have special chars in the charname (like ? or ?), it seems not to load the informations from the database or from the armory.
How can you override this?
See an example here:
http://cm.digitalrose.de/forum/calendar.php?do=getinfo&day=2007-6-9&c=1
and meant is this character:
http://armory.wow-europe.com/#character-sheet.xml?r=Nefarian&n=Jah%C3%AAira
Greets,
Venom
elricstorm
06-11-2007, 10:46 AM
Hey elric,
first let me say that this hack is absolutely incredible! I'll consider to donate for this... :D
But i have a little issue with your Mod. Maybe it's only my fault, but if you have special chars in the charname (like ? or ?), it seems not to load the informations from the database or from the armory.
How can you override this?
See an example here:
http://cm.digitalrose.de/forum/calendar.php?do=getinfo&day=2007-6-9&c=1
and meant is this character:
http://armory.wow-europe.com/#character-sheet.xml?r=Nefarian&n=Jah%C3%AAira
Greets,
Venom
The simple answer is I will have to use urlencode on the name before it's passed to the URL. Otherwise the URL can't decode the special characters. I'll do a couple of tests on this. As long as there are no other special characters like apostrophes etc. in a wow name - this should not be an issue and should be a rather simple fix.
VenomMaster
06-11-2007, 01:52 PM
Sounds nice. I#m looking forward for it^^ If you need anything, just call :D
elricstorm
06-11-2007, 02:44 PM
Sounds nice. I#m looking forward for it^^ If you need anything, just call :D
Download this product file, import it and overwrite your old one and tell me if it does the trick. If it does, I'll publish.
Thanks.
VenomMaster
06-11-2007, 06:05 PM
Wow... that was really fast.
I tried it, but in my case i had to add an utf8_en(de)code. The URI has to be right, since it changes "Jah?ira" to the preferred "Jah%C3%AAira".
But it doesn't seem to save or fetch any data from the armory. If i call the generated URI in my browser, it works, and if i put in another charname, without accents, it works too.
quite spooky...
[edit]
WoW, i finally got it. It's enough to urlencode & utf8_encode the name in the url, anything else can be left as it is.
I also added the german translations for the fetched data. I'll attach it below.
Again thank you very much for this really great hack.
-Venom
elricstorm
06-11-2007, 07:22 PM
Wow... that was really fast.
I tried it, but in my case i had to add an utf8_en(de)code. The URI has to be right, since it changes "Jah?ira" to the preferred "Jah%C3%AAira".
But it doesn't seem to save or fetch any data from the armory. If i call the generated URI in my browser, it works, and if i put in another charname, without accents, it works too.
quite spooky...
[edit]
WoW, i finally got it. It's enough to urlencode & utf8_encode the name in the url, anything else can be left as it is.
I also added the german translations for the fetched data. I'll attach it below.
Again thank you very much for this really great hack.
-Venom
Can you reattach the product file with your changes? I'd like to see what you changed. I was actually quite curious about the encoding/decoding and how that would pan out. I figured it would at least get you started in the right area. I can probably add a dropdown for the different encoding types in vboptions and then leave the most common as default. That way the URL would encode correctly based off what you saved.
I believe what you are saying is just to leave the urlencode() in the URL parse and not add the decode() parameters.
VenomMaster
06-11-2007, 08:32 PM
Hey elric,
quite right... I removed all en/decode options ad just added one urlencode(utf8_encode()) at the place where the name is passed.
For getting this to work i had to add three Columns in the "armordata"-table.
Since i was very enthusiastic, i changed something more than that:
Now you have a picture instead of therace and class for every signed up member.
The Race picture is selected by the race and the gender.
Completely dynamic change between EU and US-Servers - If you play on EU, all races and classes show up in german, otherwise i left it english...
However, i thik you'll find your way. Here it is! (only the plugin, 'cause it doens't export the template changes...)
elricstorm
06-11-2007, 11:16 PM
Wrong plugin. But, I know what you did and what encoding you used. I'm not sure why you had to create three more columns though.
I actually have pictures on my site as well. I do the same with my roster file. However, I just haven't put the code in because I don't like adding things that others can't turn off. So, I'm leaving styles for later on. :)
Hyrel
06-12-2007, 03:19 AM
Aye got your PMs and sent the memo to my hosting company. They said sure it's easy to fix, here compile your own php5 on your server. So a friend set about doing that last night..never did get it work. he was trying to do some kind of walk around for it to make the curl work instead. I'm not sure what's going on now, because the data you imputed is now showing up correctly. Not sure what's going on now.
Gooner
06-12-2007, 05:05 AM
Finally got my new site up with a new host, Forums installed and your mod was the first plugin on, :), i was just wondering when you plan to add the raid instance information thingy that is in your screenshot :), looks cool.
VenomMaster
06-12-2007, 05:29 AM
I'm not sure why you had to create three more columns though.
I added them to read the genderid from the xml, to use the male/female-pics. Anyways, if there's a possible way to change the things in a way others can choose, (i'm shure there is one), i have to say that i don't kow it :D
However, it works great for me.
-Venom
Hyrel
06-12-2007, 06:10 AM
ok new thing, if anyone signs up as a YES it is posting the default data, but not if they say no or maybe.
elricstorm
06-12-2007, 10:58 AM
Finally got my new site up with a new host, Forums installed and your mod was the first plugin on, :), i was just wondering when you plan to add the raid instance information thingy that is in your screenshot :), looks cool.
I have two scenarios to accomplishing this. I can either add "additional columns" to the calendar custom field table or I can create a completely new table and attempt to create a sql class that works with the new table. The latter seems a bit harder so far but that's the one I'm trying to work with because I don't like working with vbulletin tables. I might have a third option but I have to wait and see.
I will have something up within a week or two to test with.
elricstorm
06-12-2007, 11:03 AM
ok new thing, if anyone signs up as a YES it is posting the default data, but not if they say no or maybe.
Hyrel, if you go into your admincp -> maintenance -> view php info...
You will see that you still have:
allow_url_fopen Off Off
allow_url_include Off Off
Set these to on and you shouldn't have any issues. Also, please make sure you didn't modify the code. Step by step here is what I would do initially:
Change the php.ini files with the changes to the allow_url etc.
Uninstall the product completely
Reinstall the product completely
Re-edit your test event and allow folks to signup.
Test signups.
Make sure the product you use has "0" modifications to it - not saying it doesn't but just want to make sure that's what you use. If you do that, I can safely say it will work 100% with your site.
Also, remember that after you recompile, you need to reboot your server to get the new php.ini changes to take effect.
elricstorm
06-12-2007, 03:52 PM
I added them to read the genderid from the xml, to use the male/female-pics. Anyways, if there's a possible way to change the things in a way others can choose, (i'm shure there is one), i have to say that i don't kow it :D
However, it works great for me.
-Venom
You would use conditionals in the column template to choose between..
<if condition="$show_images == 1">
<img src="imagepath/image.jpg">
<else />
<if condition="$show_images == 2">
<img src="imagepath/image.jpg"> $field#
<else />
$field#
</if>
</if>
$show_images would be a equal to a vboptions setting for (0 = off) (1 = image only) (2 = image + class/race etc name).
$field# would be equal to the field for race, class, etc. for the column.
I will add something similar to this in one of the upcoming releases. So, no need to go through the extra work. It's better to simply say, hey Elric can you add a feature for "x" rather than customize something that I would otherwise do.
Thanks,
Hyrel
06-12-2007, 05:14 PM
Ok, back to tyring to get the php5 installed ^_^ I'll try doing it myself this time and see what happens. Thanks for not giving up on this noob! :)
elricstorm
06-13-2007, 03:26 PM
I will have version 1.2.4 released by this weekend. It will include two new columns for gender and talents. It will provide support for EU special naming characters. It will have full phrasenames in place for all English names so that EU users can phrase easier. It will provide image support for icons. Overall, it's looking pretty solid so far. I think you'll like it once it's updated. I'm still working on the customcalendar fields but that wont' be released for another version or 2.
Gooner
06-13-2007, 04:16 PM
Sounds great, Cant wait, Like the though of having icons :D
Hyrel
06-14-2007, 09:06 AM
oooh can't wait~ Finally got it working! It's just very very very slow, like it's having to upload form the armory each time, is that right?
elricstorm
06-14-2007, 10:34 AM
No, it shouldn't be slow. If you have a slow hosting site that could be part of the problem. It only queries the site and updates the information for the individual looking at the event. If it does get slow or goes down, the curl features and the conditionals should bypass the site altogether. My site is fairly fast but then I have a pretty good hosting plan too. Remember, that speed will affect each user on an individual basis also. So, for instance, if my ISP provider went down or was having problems reaching the armory, I would be the only one having issues and would use the conditionals to bypass the site. Whereas, others would have no problems whatsoever.
I'm not sure how it would run on a privately built or pre-made server. I've always found those types of servers to be slower. That's why I won't privately host my own site.
And, glad you finally got it working!
elricstorm
06-14-2007, 11:45 PM
Version 1.2.4 Changes
Added encode features for utf8 to handle European characters such as umlauts in names.
Added a new column for talents. The most points spent in a given talent determines the primary name of the spec you are trained in. Furthermore, if you hover over the talent entry you can see the full talent numbers trained.
Added a new column for gender.
Added the ability to include images.
Class icon images and gender/race/class specific images are displayed on columns.
When images mode is on, gender:race becomes a combined column. If you hover over the gender:race icon, you will see the full alternate name for the person.
When images mode is off, gender and race become split columns instead.
Added 3 new functions to handle the new imaging and talent codes implemented.
Enjoy.
Edit: I almost forgot. I corrected phrase names as well so that now all english words are phrased. This should help out the european community a bit.
Gooner
06-15-2007, 05:10 AM
Great work, Only 1 problem is that every person race has undead male image, even trolls, orcs taurens, all have same undead male image :)
And my Talent space is blank, nothing shows in it. maybe this is because im viewing signups on an old raid which happened yesterday?
Gooner
06-15-2007, 06:31 AM
False Alarm, I made a blank event and tested it, And it works PERFECT, Its just the current events which were made before the updated virsion got installed doesnt update, Your update is perfect, And i cant wait to see what you add in 1.2.5, I hope there is no end to what you can add. :D
elricstorm
06-15-2007, 10:42 AM
Yeah if you just overwrite, there won't be information tied to image icons and talents until the person visits the event. That's why there's a dirty way and a clean way. I actually installed via the dirty way because my members visit so often, I knew they would update their information automatically in a quick timeframe. I wrote that down in the main section on updating to 1.2.4 - hopefully people read it. And, again, thanks.
And, just to reiterate, the OLD events will update - but only when your members visit "any" of the events on your calendar. When they do, their information is updated in the armorydata table and then all events they signed up on, even old ones, will update with the right information.
Zarith
06-15-2007, 07:27 PM
My talents column doesn't work it says cloth... but if i hover the tooltip shows the breakdown.
elricstorm
06-15-2007, 08:44 PM
My talents column doesn't work it says cloth... but if i hover the tooltip shows the breakdown.
What class -> what talent tree ->
Provide the character name -> the server name -> and the locale (EU or US) and I can throw up a test script and look right at the array naming variables.
The problem may just be with the armory. All of the trees are set properly via the armory array, but I did notice that instead of subtlety for rogues, they listed that tree as "lockpicking" - lol. All of the talent trees so far are checking out. Let me know which one that one is.
I can place in a substitution naming for the ones that blizzard list incorrectly. It's not a problem with the mod though. That's a problem with array naming conventions that blizzard decided to use with the armory.
Noxious
06-15-2007, 09:30 PM
1.2.4 works perfect for me, fantastic
Zarith
06-15-2007, 10:26 PM
What class -> what talent tree ->
Provide the character name -> the server name -> and the locale (EU or US) and I can throw up a test script and look right at the array naming variables.
The problem may just be with the armory. All of the trees are set properly via the armory array, but I did notice that instead of subtlety for rogues, they listed that tree as "lockpicking" - lol. All of the talent trees so far are checking out. Let me know which one that one is.
I can place in a substitution naming for the ones that blizzard list incorrectly. It's not a problem with the mod though. That's a problem with array naming conventions that blizzard decided to use with the armory.
Dukkon, US, Muradin
I'm a Elemental Shaman.
When i hover over the cloth, it shows the proper talent points 41/0/# But it says Cloth instead of Elemental.
elricstorm
06-15-2007, 10:48 PM
I'll take a peek at that - I have no problems with our elemental shamans and their talent listings. I'll let you know what I find out.
elricstorm
06-15-2007, 10:57 PM
Aha, I figured it out. You have no "professions" whatsoever. So, your array number was (1) different. That's good to know. As I mentioned before, it's good to test things out to find out any differences. I'll add some variable checking in 1.2.5 that fixes that problem, amongst some other very tiny tweaks. Thanks for the heads up mate. :)
As an explanation:
The normal arrays for most people (because everyone that I know of has at least one profession) would show:
[3][0][key][talent1]
[3][1][key][talent2]
[3][2][key][talent3]
but your array points to armor skill values instead
[3][0][key][cloth]
[3][1][key][leather]
[3][2][key][mail]
I'll just provide some checking against non talent listings and that will fix the issue. Expect a fix before the end of this weekend.
Thanks.
elricstorm
06-15-2007, 11:22 PM
My talents column doesn't work it says cloth... but if i hover the tooltip shows the breakdown.
Zarith try this test version please and let me know how it works.
Zarith
06-15-2007, 11:49 PM
Zarith try this test version please and let me know how it works.
Still doing the same thing, still shows cloth.
Zarith
06-15-2007, 11:51 PM
Still doing the same thing, still shows cloth.
I had a thought, I know the idea is to take the info from armory, but if you got the values from the 3 trees, you could build in the greatest # = which spec, with the exception of hybrid. Just throwing that out there.
elricstorm
06-16-2007, 01:42 AM
I had a thought, I know the idea is to take the info from armory, but if you got the values from the 3 trees, you could build in the greatest # = which spec, with the exception of hybrid. Just throwing that out there.
Nah, not necessary. I actually had a typo in the file I sent to you last time. Here try this one and it should work fine. I tested with your name and it worked for me. Let me know please.
Hyrel
06-16-2007, 01:43 AM
could you look at this code and see if anything jumps out at you as being wrong?
I changed the fields to match my own and they seem to work right, but the total count won't update nor are the colors right.
elricstorm
06-16-2007, 01:50 AM
could you look at this code and see if anything jumps out at you as being wrong?
I changed the fields to match my own and they seem to work right, but the total count won't update nor are the colors right.
Hyrel what version is that you are using?
Edit: Ewww you are using a heavily modified european version of 1.1.2.
Erm, you changed quite a bit in that old version. Honestly, I would work with the latest version and just fix your backend php problems. No sense working around those kinds of issues. I would suggest not hacking the file directly and if you see something you need to include, if the option makes sense, I can add it. I've done that for european hacks quite a bit. I've really made the code versatile enough and the options available enough so that it works with everything.
Zarith
06-16-2007, 03:17 AM
Nah, not necessary. I actually had a typo in the file I sent to you last time. Here try this one and it should work fine. I tested with your name and it worked for me. Let me know please.
Says Elementalcombat instead of Elemental. But close! :)
elricstorm
06-16-2007, 04:23 AM
That's correct then. That's normal.
Hyrel
06-16-2007, 09:10 AM
It was the only one I could find that didn't use the armory data hehe.
We've had nothing but problems with the stupid back end. 2 installs of php5 and in both of them the php.ini vanished. So then tried just doing a customized version of the php.ini (wish my stupid host had mentioned that in the first place) and it doesn't seem to be fixing the problem either.
It was working with 1.2.3 but the load time was 2+ minutes on the page. Upgraded to 1.2.4 and starting getting an error about the calendar.php. Installed went back to 1.2.3 and it has the same thing now. O.o
Ok, so since the armory parsing seem to be the problem thought I would try to go around it by just pulling the info from customer userfields. I have our Memberlist setup so it already has the race, level, and class info so it seemed simple enough to pull the information from there instead. Also, in this guild you can only have 1 alt and only one of your characters can raid anyways so thought I'd just cut the alts out all together. If they want to raid with 2 characters they can make a new account for that one ^_^
I would just leave it having the one alt, but I haven't found a way to limit what custom fields show up on the members list and stupid me designed the site with a set width and I haven't the room for the alt data as well as the main.
I've had this hosting company for 5 years and have always loved them...right now I want to torture them with brandy bunch reruns for hours.
Hyrel
06-16-2007, 11:51 AM
I completely reinstalled php5 and changed the settings in the php.ini and I'm stilling getting this error.
Fatal error: Cannot use string offset as an array in /home/.dandelion/hyrel/rivalnation.com/forums/calendar.php(1208) : eval()'d code on line 237
elricstorm
06-16-2007, 12:06 PM
I completely reinstalled php5 and changed the settings in the php.ini and I'm stilling getting this error.
Fatal error: Cannot use string offset as an array in /home/.dandelion/hyrel/rivalnation.com/forums/calendar.php(1208) : eval()'d code on line 237
Easy fix.
Either your server information or your "own" characters/alternates are listed incorrectly in either your admincp or your usercp.
You will receive that error because it essentially can't find the character name. Make sure that the character name is listed properly. If you want, you can provide me the server -> character -> locale and I can run the same test.
Essentially that error is on a "per user" basis. When my members have encountered it, I would check their profiles and sure enough they had either a character or alternate spelled incorrectly.
In your case, line 237 is pointing exactly to your "second alternate".
So, I bet your second alternate is spelled incorrectly in your "usercp". Or, your profile field is not listed correctly for that second alternate. One of the two.
Gooner
06-16-2007, 12:38 PM
is it possible to make the the Class, Tallent and Race colums a fixed width? it looks a bit messy when each row is out of line of the rest, Not a problem of course, just visually disturbing :) it would be nice to have all the images in one straight line., for race and class.
elricstorm
06-16-2007, 12:40 PM
patch_ver_125 was released which fixes the column displays (which are fixed width but percentages don't always align properly when you returning multiple rows of data so it's just a minor tweak here and there. It should be fine now. It also fixes the talents not displaying properly for people who do not have any professions.
Just overwrite the product file for 124 with this one.
Gooner
06-16-2007, 12:41 PM
thanks, great work :)
Just noticed, is it possible to get, Warlock, Shaman, and Warrior, to the right of the image like the rest of them?
The class name is just slighty below the image.
:P
elricstorm
06-16-2007, 12:45 PM
is it possible to make the the Class, Tallent and Race colums a fixed width? it looks a bit messy when each row is out of line of the rest, Not a problem of course, just visually disturbing :) it would be nice to have all the images in one straight line., for race and class.
Update to patch_ver_125.
Also, it's not that the columns aren't a fixed width - they actually are. They are fixed with a percentage width. The problem is because each row is separately being returned, if the data is slightly larger than the rest, it will automatically "slightly stretch" that column to fit it. So, it was just a matter of me tweaking for certain talents. In this case the "elementalcombat" was probably the largest talent and I adjusted the column by 2% which fixed that. I also readjusted the name and comment columns. It should be fine now.
Gooner
06-16-2007, 12:49 PM
i did update mate :) but the images of warrior, warlock and shaman are still slightly below the image, and a rogue has talent as lockpicking.. his tree is 26.3.32
screenshot
http://www.eu-otd.com/images/eventpic1.jpg
elricstorm
06-16-2007, 12:50 PM
thanks, great work :)
Just noticed, is it possible to get, Warlock, Shaman, and Warrior, to the right of the image like the rest of them?
The class name is just slighty below the image.
:P
I don't have that problem on my site. It might be the type of style you are running on your site, especially if your site is "narrow". I tell you what though, here's what I'm going to add in version 1.2.6:
Ability to adjust table width and column widths in vboptions.
This way, when a site is slightly different, you can always tweak your site to fix these types of issues. I'll put together that in 1.2.6 which will be released sometime soon.
Thanks for the feedback and yes, I personally want the ability to immediately change styles etc. on any site right away. This should take care of that.
Gooner
06-16-2007, 12:52 PM
thanks :) this is like testing programes to work on windows and linux :P in this case to work on fluid and fixed width sites. :) great work by the way
that ability will help alot and give much much more flexibility
[edit] any idea on the lockpicking bug?
elricstorm
06-16-2007, 12:54 PM
i did update mate :) but the images of warrior, warlock and shaman are still slightly below the image, and a rogue has talent as lockpicking.. his tree is 26.3.32
screenshot
Yep, that actually is correct. Blizzard named "subtlety" to "lockpicking" on their arrays. I'll fix that and elementalcombat, feralcombat, etc. in 1.2.6 also. As for your screenshot, I can almost guarantee you that you have a "narrow" site. That's most likely the reason why you are having that. I have a wider site and I don't have those issues.
So, the 1.2.6 version with the ability to adjust widths on the fly will fix that for a lot of people. As always, with anything new, there's always a few minor setbacks.
elricstorm
06-16-2007, 01:30 PM
Here's a test version of 1.2.6 with the ability to adjust table and column widths through vboptions. It's not formally released because it hasn't been tested but any of you are more than welcome to let me know how it works. Note, this does not have the talent name fixes in it though.
Gooner
06-16-2007, 01:36 PM
ill tst it right now and report back in a short while
Gooner
06-16-2007, 01:44 PM
the customizable row/column width is working great, it has fixed the problem i had with my images, Great addition. :)
Gooner
06-16-2007, 01:54 PM
a few features ideas that i have thought of over the last few days, you might fancy.
Option to remove the "Maybe" option on signup.
Option to hide/show images.
The reason for the maybe option is because our guild leader doesnt allow people to be a maybe, It doesnt help out leaders when they need to know who will be there, They are eather raiding or not, and if they are going to be late they can leave that in coment, I have to remove the maybe code from your scrip everytime i download it :)
and the images option, I personally like the images but i thought some guilds may not. Just some ideas if you get bored :P
elricstorm
06-16-2007, 01:58 PM
a few features ideas that i have thought of over the last few days, you might fancy.
Option to remove the "Maybe" option on signup.
Option to hide/show images.
The reason for the maybe option is because our guild leader doesnt allow people to be a maybe, It doesnt help out leaders when they need to know who will be there, They are eather raiding or not, and if they are going to be late they can leave that in coment, I have to remove the maybe code from your scrip everytime i download it :)
and the images option, I personally like the images but i thought some guilds may not. Just some ideas if you get bored :P
I'll look into the maybe option but the hide/show images option is already in there. You just overlooked it. :)
Oh by the way, do me another favor since you are running the new test. Here, upload these two files and let me know if that fixes both talent issues. Feralcombat should show Feral and lockpicking should show subtlety.
EDIT: Keep in mind it won't fix the talents right away - you may have to input the name as a test to see. Column data only updates when the "person signed up" revisits the page.
Gooner
06-16-2007, 02:10 PM
Just tested those files and they are "Working as intended" :D, btw the rogue talent changed instantly from lockpicking to subletly, without any other name modification. :) looks like the calander caught it by itself and changed it.
elricstorm
06-16-2007, 02:16 PM
Just tested those files and they are "Working as intended" :D, btw the rogue talent changed instantly from lockpicking to subletly, without any other name modification. :) looks like the calander caught it by itself and changed it.
Okay, great - well I'll work on a few things later on this weekend and then probably release 1.2.6. I need to add checking for "secondary skills" also. I just found a tiny naming bug on a level 11 that didn't have professions or secondary skills. Of course, this won't affect most players because almost everyone has at least one secondary skill. However, I like it clean. :)
Thanks for the testing.
Gooner
06-16-2007, 02:37 PM
my pleasure, anything i can do to help the progression of this fantastic mod
Hyrel
06-16-2007, 04:18 PM
OMG, all this work for that! /cry I put a shortened form of my alts name. What if there is no Alt 2 though? We're only allowed 1 alt in the guild.
Gooner
06-16-2007, 04:28 PM
they dont need to fill the alt names in, nobody on my guild uses the alt names :)
Hyrel
06-16-2007, 04:43 PM
Oh you just have to have the field for it...cool.
It is working, we're getting there. Still takes about a minute to load and that seems to be something to do with the custom php. The titles above the fields aren't lining up right though.
http://www.rivalnation.com/forums/calendar.php?do=getinfo&e=5
And it have class before race and on the bottom they are the other way around.
Gooner
06-16-2007, 05:01 PM
you are better to install a non hacked virsion of the system. it should work find then
elricstorm
06-16-2007, 06:00 PM
As I mentioned in the .chm help file, the alternate names should be set as "optional". That's why they should not be a required field. Remember, some people have alternates and some people do not. Also, the ability to turn the alternates system off and on is right in the options. I tried to make the calendar "very admin friendly" and it's only going to get better in this regard.
Gooner is correct. Use a non-hacked version of the product file. Also, the product contains "phrase names" for everything. All you have to do is go to your phrases in your admincp and change the phrases to support whatever language you want. It's really that simple. :)
Hyrel
06-16-2007, 06:01 PM
This isn't a hacked one, it's the new 1.2.6. hacking only comes after it's fixed, no fun messing up something that already has an issue ^_^
Only thing I want to change really will be the image it's using for the tables backgrounds..maybe add the class images at the top too.
Hyrel
06-16-2007, 06:05 PM
I actually had the alts turned off or set to 0 anyways. But it had a hissy fit when I didn't have an alt in the alt 2 slot, so i just put a partial name in there to see if that would make it happy. didn't even think about it not being able to look the name up on the armory. But then if alts were turned off why was it trying to look it up anyways?
elricstorm
06-16-2007, 06:57 PM
Version 1.2.6 Changes
Added new vboptions for adjusting table width
Added new vboptions for adjusting "all column" widths
Changed the talent naming to "direct" naming so now this information is not pulled from the armory but from a function instead
.chm file will not be updated this release (will change it next release)
Version now released.
Enjoy.
Changed files are the functions and product files so make sure you re-upload the new functions file (everyone).
elricstorm
06-16-2007, 07:00 PM
I actually had the alts turned off or set to 0 anyways. But it had a hissy fit when I didn't have an alt in the alt 2 slot, so i just put a partial name in there to see if that would make it happy. didn't even think about it not being able to look the name up on the armory. But then if alts were turned off why was it trying to look it up anyways?
Turning the "alts" system off excludes the ability for people to signup on alternates. It does not change the function from checking those fields though.
matt2cacnio
06-17-2007, 02:15 AM
very good addon. Good job ;). Worked like a charm
Gooner
06-17-2007, 04:29 PM
some of my members seem to be having problem with my callender, any idea?
The calendar is buggy atm, lots of members are complaining about it timing out and throwing them out
elricstorm
06-17-2007, 04:58 PM
upgrade to 1.2.6 for starters with the new functions
Make sure you upload the latest functions file as well as overwrite the product file when upgrading to 1.2.6.
Gooner
06-17-2007, 05:03 PM
i have, im the one who tested it for you
Gooner
06-17-2007, 05:07 PM
i changed the armoury timeout from 15 to 5, to see if that makes a difference. other than that i dont know.
Hyrel
06-17-2007, 06:57 PM
elricstorm , would it be possible for me to get a copy of the code that doesn't use the armory? The load time from having to use the custom php is just too slow. The guild will want to go back to the eqdkp planner if I leave it the way it is.
Making them keep their profiles up-to-date isn't really an issue. We have enough competition on raids that if they want to go they will make that a priority.
I know I'm asking alot, but thought I'd see if you could before I try hacking it ^_^ My sainty is at stake here ;)
What I would like to have is the ability to custom set the background of the table head since what it pulls from VB isn't really a good option unless it can be resized. have a large class icon for the totals count table. All of which I'm pretty sure I could do.
Then the sign ups have name, level, class with the image, spec, race (no image), and comments but all the data minus the comments comes from customer user fields. Also would be kind of cool if the totals and the sign ups could be separate boxes.
I'll gladly donate for your work. I've spent more time trying to get this working then the whole rest of the website.
elricstorm
06-17-2007, 07:56 PM
i have, im the one who tested it for you
Gooner, you still need to upgrade. I changed the product code and the functions (even from the one you tested) :), upgrade to the newest. :)
Also, no issues on our calendar here. I just double checked with my primary and test sites. Let me know how the new code works and which armory you are using - is it EU or US?
elricstorm
06-17-2007, 08:05 PM
elricstorm , would it be possible for me to get a copy of the code that doesn't use the armory? The load time from having to use the custom php is just too slow. The guild will want to go back to the eqdkp planner if I leave it the way it is.
I'll see what I can do with the next version mate - I might try to condense code with the new and see if I can create an armory and a non-armory version. Although trying to keep tabs on two separate product files might be a bit difficult. I'll see what I can do. What I may do instead is have a toggle so you can turn "off" armory checking once you've updated information.
I'll have to think about it. :)
elricstorm
06-18-2007, 11:25 AM
Here you go hyrel. Here's a very old version 1.1.3 you can use that does not have the armorydata or alternates in it.
Enjoy.
Nrf_Tivoli
06-18-2007, 03:13 PM
If characters haven't been updated via the armory yet and a character above them in the list has been profiled it will display the info from the character above them.
06-15-2007 05:13 PM Tivs 70 Priest Priest Shadow Male Undead Undead
06-18-2007 01:01 AM Kjen 70 Priest Priest Shadow Male Undead Undead
06-18-2007 07:12 AM Wd 70 Priest Priest Shadow Male Undead Undead
06-18-2007 07:13 AM Onyxx 70 Priest Priest Shadow Male Undead Undead
06-18-2007 07:29 AM ryse 70 Priest Priest Shadow Male Undead Undead
06-18-2007 08:31 AM Kensie 70 Priest Priest Shadow Male Undead Undead sure why not
Otherwise if they are before the player it appears correct like this.
06-18-2007 06:29 AM Nulil
06-18-2007 07:00 AM Croissant
06-18-2007 07:12 AM Wd
06-18-2007 07:28 AM Onyxx
06-18-2007 07:29 AM ryse
06-18-2007 07:55 AM Cyla
06-18-2007 08:30 AM Kensie
06-18-2007 11:13 AM Kjen
06-18-2007 02:39 PM Tivs 70 Priest Priest Shadow Male Undead Undead
06-18-2007 02:58 PM Madelyn 70 Priest Priest Holy Female Undead Undead
06-18-2007 04:02 PM wanis 70 Warlock Warlock Affliction Male Undead Undead
elricstorm
06-18-2007, 04:20 PM
If characters haven't been updated via the armory yet and a character above them in the list has been profiled it will display the info from the character above them.
06-15-2007 05:13 PM Tivs 70 Priest Priest Shadow Male Undead Undead
06-18-2007 01:01 AM Kjen 70 Priest Priest Shadow Male Undead Undead
06-18-2007 07:12 AM Wd 70 Priest Priest Shadow Male Undead Undead
06-18-2007 07:13 AM Onyxx 70 Priest Priest Shadow Male Undead Undead
06-18-2007 07:29 AM ryse 70 Priest Priest Shadow Male Undead Undead
06-18-2007 08:31 AM Kensie 70 Priest Priest Shadow Male Undead Undead sure why not
Otherwise if they are before the player it appears correct like this.
06-18-2007 06:29 AM Nulil
06-18-2007 07:00 AM Croissant
06-18-2007 07:12 AM Wd
06-18-2007 07:28 AM Onyxx
06-18-2007 07:29 AM ryse
06-18-2007 07:55 AM Cyla
06-18-2007 08:30 AM Kensie
06-18-2007 11:13 AM Kjen
06-18-2007 02:39 PM Tivs 70 Priest Priest Shadow Male Undead Undead
06-18-2007 02:58 PM Madelyn 70 Priest Priest Holy Female Undead Undead
06-18-2007 04:02 PM wanis 70 Warlock Warlock Affliction Male Undead Undead
If a person signs up for an event and then they go back and change their main character name or alternate name, it will pull the information from the previous person because there isn't any information updated for them yet. As an example:
I have Drabin, Tyllarik, and Luttiano as my Main, Alternate1, Alternate2.
I signup for 4 events with Drabin.
I go into my usercp and swap my main character out to Angello.
If I visit the calendar, Drabin is signed up but there isn't any information for him because he is no longer listed in the armorydata table.
The only way to update the information is to signup with Angello, in which case Drabin is completely removed and replaced with the correct main signup name.
This is not a bug but rather an underdeveloped result of the newness of the armorydata features. The only way it occurs is if someone is signed up to an event that never had armorydata pulled. In the interim, the easiest solution is to make sure you uninstall the product and reinstall the product when upgrading to any version that introduced the armory data and alternates system (i.e. version 1.1.3 upgrading to 1.2.6 you would have to do this) and re-edit the events and force new signups if you have a lot of events already signed up to. The second easiest solution is to tell your members to visit "any event" - even events they haven't signed up to and it will forceably update the information.
As a new feature, I'm working on a way to manually update all currently signed up names via an admin button for certain groups. This would ensure that you could forceably fix any db issues right away, without having to wait for members to come visit.
This issue should not occur for "most people". It usually occurs for people who upgraded from a very old version to a very new version.
Hyrel
06-19-2007, 09:35 PM
*hugs* thank you thank you!
Gooner
06-20-2007, 03:59 PM
:p any idea when 1.2.7 will be released, im allready looking forward to it :)
elricstorm
06-20-2007, 04:51 PM
:p any idea when 1.2.7 will be released, im allready looking forward to it :)
Well, that's a very good question mate. Here's what I'm currently doing.
I completely overwrote and remodeled abe1's form-hack 4.0 product and created a 100% fully customizable world of warcraft recruitment form for my guild. I'm finalizing the product and fixing a few of the customizations before I release it to the general public. It's really nice and has 2 to 3 sections of vboptions with which to customize the form with. You can even include or exclude different sections, include new questions/answers for your form, etc right in vboptions.
The second reason why I'm finishing up this product is because I'm going to be using part of the features from this product to add to calendar event creation. So, it's important I finish this second product and then continue working on the next release.
I am, however, still working on minor adjustments for 1.2.7. The actual event creation bit probably won't come out until 1.3.0.
ETA: This weekend sometime for the recruitment form product
ETA: Next weekend sometime for adjustments to the calendar
I hope that helps.
Gooner
06-20-2007, 08:57 PM
Nicw!, Cant wait, That form hack modification sounds nice, ill definatly be replacing mine with yours :)
Gooner
06-22-2007, 06:41 PM
Today, for no reason as all, i have made no changes to the database, ive not even been home, i get home and i find in my emails, about 70 of these like errors:
Database error in vBulletin 3.6.7:
Invalid SQL:
REPLACE INTO armorydata
(userid,m_name,m_class,m_race,m_level,ai_name,ai_c lass,ai_race,ai_level,aii_name,aii_class,aii_race, aii_level,
m_gender,m_talentone,m_talenttwo,m_talentthree,m_t alentonename,m_talenttwoname,m_talentthreename,
ai_gender,ai_talentone,ai_talenttwo,ai_talentthree ,ai_talentonename,ai_talenttwoname,ai_talentthreen ame,
aii_gender,aii_talentone,aii_talenttwo,aii_talentt hree,aii_talentonename,aii_talenttwoname,aii_talen tthreename)
VALUES (71,
'Maaikie','Mage','Undead','70','','','','',
'','','','','Female','10','48','3',
'Arcane','Fire','Frost','','','','',
'','','','','','','',
'','','');
MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Friday, June 22nd 2007 @ 03:02:35 PM
Script : http://www.eu-otd.com/calendar.php?do=getinfo&e=12&day=2007-6-24&c=1
Referrer : http://www.eu-otd.com/calendar.php
IP Address : 84.27.196.102
Username : Maaikie
Classname : vB_Database
i have different ones for different usernames.....
Database error in vBulletin 3.6.7:
Invalid SQL:
REPLACE INTO armorydata
(userid,m_name,m_class,m_race,m_level,ai_name,ai_c lass,ai_race,ai_level,aii_name,aii_class,aii_race, aii_level,
m_gender,m_talentone,m_talenttwo,m_talentthree,m_t alentonename,m_talenttwoname,m_talentthreename,
ai_gender,ai_talentone,ai_talenttwo,ai_talentthree ,ai_talentonename,ai_talenttwoname,ai_talentthreen ame,
aii_gender,aii_talentone,aii_talenttwo,aii_talentt hree,aii_talentonename,aii_talenttwoname,aii_talen tthreename)
VALUES (1,
'Goonerr','Warrior','Orc','70','','','','',
'','','','','Male','46','15','0',
'Arms','Fury','Protection','','','','',
'','','','','','','',
'','','');
MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Friday, June 22nd 2007 @ 08:39:51 PM
Script : http://www.eu-otd.com/calendar.php?do=getinfo&e=14&day=2007-6-26&c=1
Referrer : http://www.eu-otd.com/calendar.php
IP Address : 82.32.101.43
Username : Gooner
Classname : vB_Database
Do you know whats worng? i havnt touched anything since yesterday, and it was working fine yesterday.
Hyrel
06-23-2007, 12:56 AM
Maybe Blizzard made some change to the armory?
elricstorm
06-23-2007, 03:21 AM
It's trying to update Goonerr correctly but there is an issue with the alternate(s) listed for Goonerr. Check your alternate data information and make sure whatever names are listed there are correct. No changes to the armory for US and no issues here since releasing 1.2.6. Check your alternates (that's the empty data it's trying to pass). I'm not saying yours is incorrect but that's where I would start first.
Secondly, keep in mind that I don't control the armory so therefore I can't efficiently run "down" tests against it. All I can do is safely assume everything is working as intended when the armory does go down. I really wish they would bring the armory down for about 2 or 3 days so that I could make some touchup adjustments.
thanks for the headsup though.
elricstorm
06-23-2007, 06:08 AM
Added World of Warcraft Recruitment Form addon this morning. Check it out if you want:
https://vborg.vbsupport.ru/showthread.php?p=1274436
Hyrel
06-23-2007, 06:20 AM
Elric is evil! Just when I get one addon working he adds another to frustrate me =p
Ok, I have it just shy of being exactly the way I want it. I've added the column and header for the member's spec. All that is missing is adding the commands to actually make it pull the data from userfield22 and input it in the table.
I tried changing calendar_getday_event which seemed like it was part of the process but I either missed something or that is only part. This seemed a good point in which to ask for help before I mess something up ^_^
Yukino_AE
06-25-2007, 12:04 AM
ok, i add this mod, all seems to be going well, when i go to add an event and enable sign up and save it it just goes to a white screen. when i check the calandar page again the event is there. but if anyone goes to click the even to signup it takes them to a white screen. lol what am i doing wrong. help. :P
elricstorm
06-25-2007, 01:54 AM
ok, i add this mod, all seems to be going well, when i go to add an event and enable sign up and save it it just goes to a white screen. when i check the calandar page again the event is there. but if anyone goes to click the even to signup it takes them to a white screen. lol what am i doing wrong. help. :P
Did you follow all of the steps outlined in the help file?
What version of php are you running on your site?
Do you have the curl library installed?
Do you have fopen for URLs turned on?
Are you running any calendar modifications other than this one?
Let's start with that for starters.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.