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.

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.

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.

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

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. :)

• 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.

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,

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".

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.

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.

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.

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.

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.

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.

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:

Yours is an easy fix.

Do you see where you have:

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.

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.

No extra comma in there...

No idea where the hell it is coming from.

Need help trying to figure out what is going on.

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.

Ok the error is gone but I'm back to where I was last night.

http://www.rivalnation.com/forums/ca...o=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.

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

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.

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

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.

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. :)

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:

thanks to Hyrel for providing it. However, it might be returning empty arrays. Still testing with this code further.

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.

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,

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?

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.

yep same thing as Shane

Yup your screens are the same as mine.

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.

Good news!

This works 100%.

I'm doing some tests and will report back in a bit.

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??

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

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.

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