gWoWEvents - World of Warcraft Event Signup

[Gryphon]

What is it?
-gWoWEvents is a modification for vBulletin which allows you to add World of Warcraft event sign ups to your forum calendar.

If you use this mod, please Mark as Installed (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=170592), and if you really enjoy this mod, please Nominate for MOTM, and if you really really enjoy this mod, feel free to Support Developer! Thank you!

https://vborg.vbsupport.ru/external/2008/02/14.png Follow me on twitter! (http://www.twitter.com/ghryphen)

Support
valueI use my released mods daily, if I find an issue with them or add features for myself I will release updates. If there are significant bugs or simple feature requests I will do my best to release fixes. Some of my mods rely on fetching data from 3rd party websites, due to the unreliable results, my mods will require users to troubleshoot for themselves if they find the addon is not working for them specifically. I am offering my personal mods that work ok for me for you to use, I am sorry I do not have time to troubleshoot many user specific issues. Thank you for your understanding.

Features
-
Allows your users to enter multiple servers and characters
Links to either US or EU WoW Armorys.
Links icons to wiki.
Choose calendar to use
Limit use by usergroup
Multiple server support
Shows extended character data, skills, talents.
Some features translated for French and German
Character data is fetched by cron so calendar doesn't suffer slowdown
Templated so you can direct links somewhere other than the Armory if you wish.
Unified profilefield compatible with gWoWRoster (https://vborg.vbsupport.ru/showthread.php?t=170605) and gWoWChar (https://vborg.vbsupport.ru/showthread.php?t=141455)


Installation
-
Download the latest version and upload all files.
Install the product.
Create a Multiple-Line Text Box User Profile Field.

/admincp/?loc=profilefield.php%3Fdo%3Dadd
Multiple-Line Text Box
Continue
Title: World of Warcraft Characters
Description: Enter one character per line.<br /><br />Format: US/EU|Realm|Faction|Name<br /><br />Example: US|Mal'Ganis|Alliance|Gryphen
Default Value: Leave Blank
Max length of allowed user input: 1000
Field Length: 50
Text Area Height: 6
Field Editable by User: Yes
Other options are optional.
Save
Look and see what the field name is for World of Warcraft Characters, example field25.

Fill in the gWoWEvents configuration options.
That is all, instruct people to fill in their profile.


Changes
-
v1.0.10a - upload class_gwowarmory.php

Quick fix for Armory import.


v1.0.10 - upload cron.gwowevents.charinfo.php, class_gwowarmory.php, import product with overwrite

Quick fix for 3.1 armory changes.
Secondary skills disabled for now.


v1.0.9 - upload cron.gwowevents.charinfo.php, upload images, import product with overwrite

Death knight images, thanks SlompOchomp
Fix special characters in player names


v1.0.8 - import product with overwrite enabled

Fix spelling error
Fix for signup allowance periods


v1.0.7 - Upload functions_gwowevents.php, images, import product with overwrite enabled

Updated for WotLK


v1.0.5 - Import product with overwrite enabled.

Used phrases for more text
Added option to show who has viewed the event details.


v1.0.4 - Upload all files import product.

Added a 4th, "Yes Late", signup option
Comment minimum setting for Late and Maybe options


v1.0.3 - Import product.

Update for 3.7.0 Gold, thank you Kinneas (https://vborg.vbsupport.ru/member.php?u=123012)


v1.0.2 - Upload all files import product.

Initial Release


Copyright
-gXboxLive, Copyright ? Ghryphen (https://github.com/ghryphen)
Please maintain copyrights in derivative works, thank you.

[Gryphon]

Notes: This mod does not convert or use data from erlicstorms event mod, uses the same Userfield however. Should work ok on earlier version boards.


Options not implemented:

Disable Signup Time

[MrShides]

you and https://vborg.vbsupport.ru/member.php?u=182986 need to hook up.

[Caerydd]

Two Questions

1) Is it compatible with Event Forums?
2) Is it possible to run this on calendar A and Farcaster's Event Attendance on Calendar B ?

Cheers (and glad to see the mod picked up again)

[Gryphon]

1) It does not interact with event forums. I may look into that, I dont use the mod.
2) Possibly, I don't use farcasters, however you can limit this mod to specific calendars.

[sweede]

you and https://vborg.vbsupport.ru/member.php?u=182986 need to hook up.

lol

[Zachariah]

I'll give it a go, I have a bunch of wow players on my site. Right now I just made a bunch of forums for them (http://www.gzhq.net/forums/f47/).
- I never got into the game, but always looking for toys.

Allowed Servers Field: Elune

- Anything else ? (like I have a clue on the game) :D
- I have no clue what a visiting user may use.
- Select "D" yes to all ?

[Gryphon]

Should be good to go :)

[BlizzardHQ]

This is great, thank you for finally releasing this as you know I been bugging you for it :D

One thing I would love to see would a way to list those drafted, those on stand-by and those declined by the raid leader for the upcoming event.

[Zachariah]

This is great, thank you for finally releasing this as you know I been bugging you for it :D

One thing I would love to see would a way to list those drafted, those on stand-by and those declined by the raid leader for the upcoming event.

Ideas:

- Perhaps make the user that is raid leader the Mod of the calendar.
- Option per usergroup "Can Modify Sign-Ups"
- calendar.php?do=manage&e=xxx add a plugin to list current users signed up with options to stand-by / declined per record in a table layout

- then there would need to be code option to allow Mod edit the sign-ups for the event
-- declined (delete ?) and option to send e-mail or PM with message
-- stand-by (list their name in a another <div> bellow the current players) and option to send e-mail or PM with message

[Caerydd]

Thanks for looking into 1, Gryphon :) My guild currently uses threads for signups, so the cross over to a calendar/raid system it would be nice so they can 'discuss' the event while sign ups are listed separately.

I've not upgraded to 3.7 though, and won't be like to until 3.7 goes gold.

however, donations coming yours and Sweede's way at some point, as I really appreciate the work you've both done.

[Gryphon]

This should work fine on 3.6

[sweede]

I've always wondered, why not have the user profile fields created during the installation of the product?

While it doesnt appear to be any easy APIs that you can use to create the fields, it is rather easy to facilitate this using some of the admin hooks.

I have a plugin that i use on my guild site that adds profile fields automaticly though the admincp and even sets the proper option fields for use across vbulletin.

I'll clean it up slightly and post it as its own plugin with instructions on how to get and use the variables.

[Foghorn Deadhor]

I am currently using Elricstorm's mod but found your mod here when I went to go complain about there being no upgrade instructions as promised with the newer version of the product...

Some things I'd like to see, then I'd be all over using your whole WoW package as having integrated mods is hot:

(Please note that I haven't downloaded this yet because a functional calendar is important to my guild)

1) It is important to me to have compatibility with Event Forums. The associated threads being made with calendar events are very useful to us for numerous reasons, so please consider making this happen.

2) I don't see any mention of the stuff that was in the latest version of Elricstorm's which would be nice and helpful, such as formation time, zone, etc.

3) I haven't found a mod that does this, but "<< Previous Event | Next Event >>" buttons would be swell. This may be more of a general calendar thing but if it came with your mod it would be :awesome:

4) An optional place to post WWS report links after the event is done. I know this can just be posted in the body text but a field for it would be dandy, especially if you made an addon that allowed you to list WWS reports by some of the associated calendar info (date, zone).

That's the stuff off the top of my head. I'm looking forward to installing this as soon as I know we won't lose Event Forums compatibility ^_^

[Caerydd]

I think WWS links could be added through extra custom fields you make yourself, most likely :) With Farcaster's original addon, I'm using custom fields to enable highlighting of event details and things - lays out stuff nicer than the raid leader having to cut and paste. I assume this would also work with this addon too.


Shall test this out tomorrow, and verily my fellow officers will be blown away.


Edit: regarding event forums, it might be worth contacting thincom2000 (I think that was how it was spelled) as he was the one I know looking at cleaning up and updating event forums.

[Wayne Luke]

If I could make a suggestion...

In the next version of this event calendar and the Guild Roster, consolidate the image directories so that we don't have multiple copies off all the icons uploaded to different folders. That makes it difficult if you change the images for any reason. Especially if you have multiple styles on the system.

Also it would be nice if you could specify the type of event such as: Raid, Meeting, Roleplay, PvP, etc... Maybe have an option box where the admin can list the different types they want to allow.

[Caerydd]

Seconded WL's suggestions. The option to leave off the character stats for an RP event would make farcaster's original mod redundant.

Also, I have a collection of Blizzard's instance icons for both Outland and Azeroth, I would be happy to upload them if you could find a use for them.

[BlizzardHQ]

Also, I have a collection of Blizzard's instance icons for both Outland and Azeroth, I would be happy to upload them if you could find a use for them.



I would be intrested in these for a DKP mod for vB that I'm working on currently.

[Dsru123]

Well, installed the WoW Characters and Rooster and all working well. I can seem to get the Event mod working. it only shows the style of the default calendar. I added a event and cant seem to reproduce the screenshot format you have here. I created a new RAID CALENDAr, its ID is 2, added to the options *I beleive everything set correctly) but still get the default format and no place to JOIN the event. I am missing something very obvious, but sure as heck cant tell what.

www.jettcommunity.com

[Wayne Luke]

When creating the event, make sure to check "Allow Users to Signup" in the Additional Options field.

[Dsru123]

When creating the event, make sure to check "Allow Users to Signup" in the Additional Options field.

DOH!
I feel so cheap and used!

Thank you, works great.

[Dsru123]

Well, no I see the Event Attendabce option, but underneath it says
"Add characters to your profile to singup for this event. "

I have and the WoW Character and WoW rooster all see me, but not here?

[Foghorn Deadhor]

Is the event server and the server your chars are on the same?

[Dsru123]

Is the event server and the server your chars are on the same?


wow, twice I am a fool............ good catch!

[Gryphon]

A little swamped at work this week, my usual place I slack off and code, I am reading the thread and making notes.

[Collyn]

Ok there is an issue I am running across on my boards. It seems to be a display issue only, if you have multiple events on the same day it spans the sign up across all the events on that day. if however you look at the events individually the sign ups are correct. This only happens if you look at the view for the entire day.

[Wayne Luke]

Been working with this for a while and it suffers from one of the major failings of the previous version by Elricstorm. It doesn't cache the character data so that it can be reused across all events. All the information about race, gender, class, stats, professions and such does not belong in this table. It should be in the gwowroster_charinfo table or a gwowcharinfo table.

Then you can use a charid field to join that table with the event table. This means that every single page load of the different events can pull the information from the local database if it exists and not have to try and access the armory. Normalizing the database like this would lessen the impact on the armory and the local site while providing faster screen draws and access to the information.

I know you meant for the two addons to be completely separate but that doesn't mean data and resource management can't be smart. Aside from this one issue, it is a good upgrade to the other one. It gives me a better base to do what I want. I am currently rewriting the tables, character caching cron and retrieval plugins to manage data easier. I am also going code to handle non-guild members signing up for events and to have their information cached via cron as well. Once done, I can send you all the changes if you would like.

[sweede]

Been working with this for a while and it suffers from one of the major failings of the previous version by Elricstorm. It doesn't cache the character data so that it can be reused across all events. All the information about race, gender, class, stats, professions and such does not belong in this table. It should be in the gwowroster_charinfo table or a gwowcharinfo table.

Then you can use a charid field to join that table with the event table. This means that every single page load of the different events can pull the information from the local database if it exists and not have to try and access the armory. Normalizing the database like this would lessen the impact on the armory and the local site while providing faster screen draws and access to the information.

I know you meant for the two addons to be completely separate but that doesn't mean data and resource management can't be smart. Aside from this one issue, it is a good upgrade to the other one. It gives me a better base to do what I want. I am currently rewriting the tables, character caching cron and retrieval plugins to manage data easier. I am also going code to handle non-guild members signing up for events and to have their information cached via cron as well. Once done, I can send you all the changes if you would like.


When my brain recovers from the shift to 3rd shift working, i planned on making some type of API to access and cache character data for my mod, https://vborg.vbsupport.ru/showthread.php?t=169389

[Gryphon]

Thanks Wayne, I understand what you are saying. I wouldn't mind taking a look. I have a half cocked plan for why it is done this way as I wanted historical data per event so that 6 months after a deadmines event doesn't show level 70 attendees. I wanted to display the stats they were at the time of the event for a later addition to this mod. I realize now this can be done a little differently.

[Wayne Luke]

Well my goal is a little more involved. I am going to use this as a base to recreate most functionality of WoWRoster (not to be confused with your addon of a similar name). My guild wants stuff similar to that including the signature generator. However I want it cached locally so I can update from the Armory in off-peak periods.

[LostPhoenix]

Anyone else having an issue with the cron job failing?

[soothius]

Thanks for the mods gryphon! I managed to get the other two to work fine but am having trouble with this one. It seems it's installed and i can edit the options but when i go to create an event i have no options to use the mod. Currently i just go to calender and create event but am i supposed to do it antoher way? Thanks for any help.

Btw my modest board is located at www.wowdownunder.com .

[Gryphon]

Anyone else having an issue with the cron job failing?

Going to need a bit more information to be able to help. Are there errors?


@soothius, just create an event and make sure to check the box to enable signup.

[LostPhoenix]

Going to need a bit more information to be able to help. Are there errors?




Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE vb_gwowevents SET
`charurl` = 'r=Arygos&n=Censored',
`level` = '70',
`title` = '',
`faction` = 'Horde',
`factionid` = '1',
`gender` = 'Male',
`genderid` = '0',
`race` = 'Undead',
`raceid` = '5',
`class` = 'Priest',
`classid` = '5',
`talentspec` = '20,41,0',
`talent1` = '20',
`talent2` = '41',
`talent3` = '0',
`guild` = '',
`guildurl` = 'r=Arygos&n=&p=1',
`hp` = '6891',
`mp` = '10065',
`str` = '38',
`agi` = '43',
`sta` = '368',
`int` = '515',
`spi` = '521',
`arm` = '1359',
`strbase` = '38',
`agibase` = '43',
`stabase` = '59',
`intbase` = '143',
`spibase` = '163',
`armbase` = '1359',
`prof1` = 'Engineering',
`skill1` = '375',
`prof2` = 'Mining',
`skill2` = '375',
`cooking` = '375',
`firstaid` = '375',
`fishing` = '375',
`riding` = '300',
`armorydata` = '1' WHERE `realmchar` = 'Arygos.Censored';

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Thursday, February 21st 2008 @ 06:27:46 PM
Classname : vb_database


If I run the same SQL call from phpmyadmin it goes fine. I think vBulletin is closing the connection to the database while the cron is running.

[Caerydd]

wewt, I have a test site now ^^

Will be trying this out on that over the weekend.

[jim6763nva]

How long should it take to import armory data after submitting an event? I created an event and it's just sitting there saying Awaiting armory data import....

Jim

[LostPhoenix]

How long should it take to import armory data after submitting an event? I created an event and it's just sitting there saying Awaiting armory data import....

Jim

Jim,

Looks like you have the same issue as me. Login to your admin and check your scheduled tasks. Select gWoWEvents and select run now. If you get an error then we are in the same boat.

[Foghorn Deadhor]

<i>Note: still haven't installed, so take it for what it's worth:</i>

The feature with the by-event stat pulling sounds cool, and having a "history" of stats is a neat idea, but I'm going to say that I personally would probably disable this as it's a feature that doesn't concern me personally and seems bound to have performance issues, especially with Armory's unreliable nature. Perhaps this could be a main-switch option, or perhaps it could be by-event.

I personally would vastly prefer that it pull from the same table as the roster.

Still waiting to hear that it will work with event forums :P

[Gooner]

Great mod, now i hope you do not abandon such a great mod like Elric did :)

[Gooner]

i also am getting error when running cron job...

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE gwowevents SET
`charurl` = 'r=Shadowsong&n=Aloysius',
`level` = '70',
`title` = '',
`faction` = 'Horde',
`factionid` = '1',
`gender` = 'Male',
`genderid` = '0',
`race` = 'Orc',
`raceid` = '2',
`class` = 'Warrior',
`classid` = '1',
`talentspec` = '8,5,48',
`talent1` = '8',
`talent2` = '5',
`talent3` = '48',
`guild` = 'Ordo Templi Draconis',
`guildurl` = 'r=Shadowsong&n=Ordo+Templi+Draconis&p=1',
`hp` = '11394',
`mp` = '100',
`str` = '287',
`agi` = '147',
`sta` = '713',
`int` = '30',
`spi` = '54',
`arm` = '13691',
`strbase` = '162',
`agibase` = '93',
`stabase` = '141',
`intbase` = '30',
`spibase` = '54',
`armbase` = '13691',
`prof1` = 'Blacksmithing',
`skill1` = '250',
`prof2` = 'Mining',
`skill2` = '155',
`cooking` = '',
`firstaid` = '375',
`fishing` = '1',
`riding` = '225',
`armorydata` = '1' WHERE `realmchar` = 'Shadowsong.Aloysius';

MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Sunday, February 24th 2008 @ 08:43:47 AM
Script : http://www.********t/admincp/cronadmin.php?do=runcron&cronid=23
Referrer : http://www.********t/admincp/index.php
IP Address : 77.101.215.207
Username : ********
Classname : vB_Database

[Collyn]

Ok, so I posted a little earlier about how sign ups span across multiple events. My original thought was it did the to ranged events because essentially they were all the same event as the sign up mod saw it.
So as much of a pain in the..... as it is We corrected it by posting indivdual events on each day. The issue however still persists when you have more than one event on the same day. The sign up for one event will span over to the next.

www.shadowwalkersguild.com Wed 2-27 would be a good example of this.

[Kinneas]

i also am getting error when running cron job...
I got this problem because of a timeout limit I think. Try increasing the timeout value for MySQL queries (or ask your host to).

[Tolas]

I have the same issue with the armory imports just going and going and going. I ran the job manually from the admin panel, got no error, it said it completed the job and showed the characters it imported. Back to calendar and still acting like its hung on importing, no info is shown at all.

[Mother_Dee]

I would love to see perhaps icons, say if an event has a trigger word in the title such as "Black Temple", "BT", "Temple", etc.) it would show the BT icon on the calendar. It would also be very cool to be able to set the number of signups or the classes necessary, etcetera, though that becomes massively complicated, I know.

Finally, it would be neat to see it perhaps even tied in with a bit of a revamped "Upcoming Events Module" for vBadvanced to also show the corresponding icon (BT, TK, MH, etc.), perhaps even number of attendees (20/25, etc...) and the like.

This is a far superior mod to the previous, I really enjoy seeing you and Sweede compete for most WoW mods, it makes for a some great Guild Forums. :)

[Gryphon]

I have the same issue with the armory imports just going and going and going. I ran the job manually from the admin panel, got no error, it said it completed the job and showed the characters it imported. Back to calendar and still acting like its hung on importing, no info is shown at all.

Hopefully it eventually went through? This is common when the Armory is unreachable.

I would love to see perhaps icons, say if an event has a trigger word in the title such as "Black Temple", "BT", "Temple", etc.) it would show the BT icon on the calendar. It would also be very cool to be able to set the number of signups or the classes necessary, etcetera, though that becomes massively complicated, I know.

Finally, it would be neat to see it perhaps even tied in with a bit of a revamped "Upcoming Events Module" for vBadvanced to also show the corresponding icon (BT, TK, MH, etc.), perhaps even number of attendees (20/25, etc...) and the like.

This is a far superior mod to the previous, I really enjoy seeing you and Sweede compete for most WoW mods, it makes for a some great Guild Forums. :)

Thanks, some of these suggestions have also been requested by my guild and are on my see-if-I-can-do list.

[Tolas]

Hopefully it eventually went through? This is common when the Armory is unreachable.


Unfortunately no.

I installed the mod yesterday and still I just have the spinning circles on everyone's names saying Awaiting Armory data import... The actual signup works fine, just no info being imported.

Odd thing is that your gWoWRoster plugin and Sweede's WoW BBCode plugin both are pulling data from the armory and I can view the profiles of any of our characters if I go to the Armory directly. I installed all 3 around the same time.

Not sure what else might be wrong?

Edit:

I think I may have figured it out,

I changed from Argent+Dawn in my profile field and in the gwowevent options to Argent Dawn.

It pulled all three characters I had entered on different dates. Previously I used Elric's calendar mod and all my guildmates have entered using Argent+Dawn.

could this be why? if so I will have to have folks change their profiles to get it going I guess. I also noticed I forgot to set the Calendar from 0 to 1 :o (the id of my calendar I am using). I changed it, changed my settings and my own profile back to Argent+Dawn and re-ran the job and got no data for anyone, including my characters (after re-signing up my own)

[Tolas]

heh, I guess I answered my own question. I left it overnight and no armory data. So I will change the setting and have folks remove the + from the server name and hopefully should be working better.

One other question, is there a way the data can be cached? I noticed if I switch from Yes to Tentative or No it starts to re-import.

[Ninok]

I'm also getting the Cron job errors while trying to pull the data from the Armory. I have increased the Timeout value etc, I get the error no matter what I do.

Database error in vBulletin 3.6.5:

Invalid SQL:
UPDATE gwowevents SET
`charurl` = 'r=Blackhand&n=Ninnok',
`level` = '70',
`title` = '',
`faction` = 'Horde',
`factionid` = '1',
`gender` = 'Male',
`genderid` = '0',
`race` = 'Blood Elf',
`raceid` = '10',
`class` = 'Paladin',
`classid` = '2',
`talentspec` = '42,19,0',
`talent1` = '42',
`talent2` = '19',
`talent3` = '0',
`guild` = 'Mithril',
`guildurl` = 'r=Blackhand&n=Mithril&p=1',
`hp` = '7717',
`mp` = '8943',
`str` = '123',
`agi` = '79',
`sta` = '452',
`int` = '418',
`spi` = '125',
`arm` = '14557',
`strbase` = '123',
`agibase` = '79',
`stabase` = '118',
`intbase` = '95',
`spibase` = '88',
`armbase` = '14557',
`prof1` = 'Engineering',
`skill1` = '358',
`prof2` = '',
`skill2` = '',
`cooking` = '6',
`firstaid` = '375',
`fishing` = '',
`riding` = '225',
`armorydata` = '1' WHERE `realmchar` = 'Blackhand.Ninnok';

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Saturday, March 1st 2008 @ 04:45:17 PM

[quedex]

Hi!

First of all thanks for a great mod!
Now to the question, is it possible to make the mod pull Spell dmg, armor, defence info
also/instead of pure stats per class basis?

[Gooner]

are you going to fix this mod??

[Eviserator]

I am getting this as an error when I force the cron to fire:

gWoWEvents Armory Import


Warning: Invalid argument supplied for foreach() in /includes/cron/cron.gwowevents.charinfo.php on line 62


Spinochio
Array
(
[globalSearch] => 1
[lang] => en_us
[requestUrl] => /character-sheet.xml
[characterInfo] => Array
(
[errCode] => noCharacter
[value] =>
)

[prof1] =>
[skill1] =>
)
Array
(
[globalSearch] => 1
[lang] => en_us
[requestUrl] => /character-skills.xml
[characterInfo] => Array
(
[errCode] => noCharacter
[value] =>
[skillTab] => Array
(
[skillCategory] => Array
(
[1] => Array
(
[skill] =>
)

)

)

)

)
--------------------------------------------------------------------------------Warning: Invalid argument supplied for foreach() in /includes/cron/cron.gwowevents.charinfo.php on line 62ScoopjacksonArray
(
[globalSearch] => 1
[lang] => en_us
[requestUrl] => /character-sheet.xml
[characterInfo] => Array
(
[errCode] => noCharacter
[value] =>
)

[prof1] =>
[skill1] =>
)
Array
(
[globalSearch] => 1
[lang] => en_us
[requestUrl] => /character-skills.xml
[characterInfo] => Array
(
[errCode] => noCharacter
[value] =>
[skillTab] => Array
(
[skillCategory] => Array
(
[1] => Array
(
[skill] =>
)

)

)

)

)
--------------------------------------------------------------------------------Warning: Invalid argument supplied for foreach() in /includes/cron/cron.gwowevents.charinfo.php on line 62ElyArray
(
[globalSearch] => 1
[lang] => en_us
[requestUrl] => /character-sheet.xml
[characterInfo] => Array
(
[errCode] => noCharacter
[value] =>
)

[prof1] =>
[skill1] =>
)
Array
(
[globalSearch] => 1
[lang] => en_us
[requestUrl] => /character-skills.xml
[characterInfo] => Array
(
[errCode] => noCharacter
[value] =>
[skillTab] => Array
(
[skillCategory] => Array
(
[1] => Array
(
[skill] =>
)

)

)

)

)

Can you help me understand what the actual error might be?

[Gryphon]

heh, I guess I answered my own question. I left it overnight and no armory data. So I will change the setting and have folks remove the + from the server name and hopefully should be working better.

One other question, is there a way the data can be cached? I noticed if I switch from Yes to Tentative or No it starts to re-import.

Thanks, I was at a loss for why you were not getting updates. I urlencode the profile fields before fetching the armory data, so yes plain text is all that is needed.

I had some reasons for why it does what it does but no longer remember exactly why. Recently ran into this issue myself and will be re-evaluating the way the data is stored per previous suggestions.

I'm also getting the Cron job errors while trying to pull the data from the Armory. I have increased the Timeout value etc, I get the error no matter what I do.

I am afraid that I do not have a solution for this, maybe someone else may have some input.

Hi!

First of all thanks for a great mod!
Now to the question, is it possible to make the mod pull Spell dmg, armor, defence info
also/instead of pure stats per class basis?

Thank you. Yes it is possible, I will add this suggestion to my list.

are you going to fix this mod??

What is broken? Some features are requested, but the primary goal of the mod as it is released works.

I am getting this as an error when I force the cron to fire:

gWoWEvents Armory Import

Please put code tags around such large data pastes in the future. I am not positive, but it appears that the Armory is telling you that there is no such character as Spinochio, Scoopjackson, or Ely. Ensure that the users profile fields are entered properly. I will see if I can recreate this error.

[Sarosh]

i am unable to find the event sign up?? i followed the instructions on the first post, and its not showing, only able to enter char information in profile field. thats all. nothing with event sign up??

[janthes]

After using PHPRaid to manage our sign-ups for so long, I want to try something a little more integrated into the main forums to handle sign-ups so I switched to this.

I got everything up and running in no time, and it seems to do the job well enough but I do have a couple of ideas that I didn't see posted earlier:

1. Is it possible to have a wider selection of what stats are displayed from the Armory data? I would prefer to know how much +healing my healers have versus how much strength they have, ya know?

2. The ability to sort the information presented by name, class, and date without having to go into the admin control panel to do it. It would also be nice to be able to sort by spec, if that is possible. The armory data gives you if a spec is demonology, protection, or holy, right? I don't know personally. :/

3. Maybe a piggyback onto the previous idea, changing the "total sign-up" part at the top to include more information? For example, in the Warlock box you could have it say "Warlocks (2)" and then beneath it list the names of the Warlocks who have signed up and their spec? That would actually take the need of sorting people by spec below out of the equation.

Other than that, the mod seems very well put together.

Thanks for the effort and keep up the good work. :)

[Gryphon]

@Sarosh I do not understand what you mean.

@janthes Thank you for the suggestions. 1) More data is on the list. 2) Named specs are not provided by the Armory, this mod determines them at the time of display by some math done with the talent point distribution. I could probably do this at the time of caching, I will look into it. 3) Nice idea, I will consider this.

[Mother_Dee]

Sarosh, the signup is on the calendar once a new event is added and the user "Allows for Signups."

Is that what you're looking for?

[Mother_Dee]

Same issue as previously posted, recurring events do not create separate signups, so I have to manually post every event even if recurring. That is a bit of a PITA (understatement.) Otherwise it seems to be working well and my users like how it works/looks.

[LostPhoenix]

Here is my hack for those of us who have hosts that don't like the cron. It's not perfect but it does work.

Find the following code in cron.gwowevents.charinfo.php

if ($character['characterInfo'] && $character['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}
else
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}


and change it to:

$dbhost = '';
$dbname = '';
$dbuser = '';
$dbpasswd = '';

if ($character['characterInfo'] && $character['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
//$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
@ $db2 = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
mysql_select_db("$dbname",$db2);
mysql_query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'", $db2);
mysql_close($db2);
} else {
//$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'");
@ $db2 = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
mysql_select_db("$dbname",$db2);
mysql_query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'", $db2);
mysql_close($db2);
}


Obviously you have to add your database info. Until I take the time to learn vbulletin and fix it properly lol.

This will put more stress on your SQL server as it opens and closes a connection each time it updates the user.

[Ninok]

Here is my hack for those of us who have hosts that don't like the cron. It's not perfect but it does work.

Find the following code in cron.gwowevents.charinfo.php

if ($character['characterInfo'] && $character['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}
else
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}


and change it to:

$dbhost = '';
$dbname = '';
$dbuser = '';
$dbpasswd = '';

if ($character['characterInfo'] && $character['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
//$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
@ $db2 = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
mysql_select_db("$dbname",$db2);
mysql_query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'", $db2);
mysql_close($db2);
} else {
//$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'");
@ $db2 = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
mysql_select_db("$dbname",$db2);
mysql_query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'", $db2);
mysql_close($db2);
}


Obviously you have to add your database info. Until I take the time to learn vbulletin and fix it properly lol.

This will put more stress on your SQL server as it opens and closes a connection each time it updates the user.

I still get the same error with this fix, I just can't get it to work. I will add that its random users that it errors out on, I really need to talk to the host.

[LostPhoenix]

I still get the same error with this fix, I just can't get it to work. I will add that its random users that it errors out on, I really need to talk to the host.

If they have incorrect info put into the user friend it will give an error, but should just skip them and move on to the next one... I was able to update 200 users with my fix yesterday and the cron has been working fine since.

Are you getting the same error with my hack? Server has gone away?

[Ninok]

If they have incorrect info put into the user friend it will give an error, but should just skip them and move on to the next one... I was able to update 200 users with my fix yesterday and the cron has been working fine since.

Are you getting the same error with my hack? Server has gone away?

Yea, its the same error, lost connection to mysql server. I find this odd as each user is making 1 call. Is there a way you can set it to update just 1 user? Or break it down to that level for testing?

[Mother_Dee]

PHP Fatal error:

Cannot use string offset as an array in /XXX/XXX/XXX/forum/includes/cron/cron.gwowevents.charinfo.php on line 50

[Mother_Dee]

I've been hung up suddenly with a fatal error and no cron running since the 12th. Before that, character imports were doing fine. See above. Any thoughts?

[Collyn]

I'm getting the same error. *shrugs* I'm not sure what's generating the error since nothing in cron.gwowevents.charinfo.php has changed.

[Eviserator]

I am getting the following error:


gWoWEvents Armory Import
Fatal error: Cannot use string offset as an array in /data/6/0/97/80/423406/user/431220/htdocs/pandemicfear/forums/includes/cron/cron.gwowevents.charinfo.php on line 64


This seems to have started after PHP was upgraded to version 5.2.5.

[Eviserator]

Please put code tags around such large data pastes in the future. I am not positive, but it appears that the Armory is telling you that there is no such character as Spinochio, Scoopjackson, or Ely. Ensure that the users profile fields are entered properly. I will see if I can recreate this error.

Sorry about the code tag, I am new and did not know about them but I corrected my previous message. Anyway, I figure that the issue for this problem listed in my previous email was that the REALM name in the user added field CAN NOT have a plus (+) sign in it:

US|Shattered+Hand|Alliance|Eviserator <======= Faulty Entry

US|Shattered Hand|Alliance|Eviserator <======= Good Entry

[Eviserator]

If you are receiving the following error:

PHP Fatal error:

Cannot use string offset as an array in /XXX/XXX/XXX/forum/includes/cron/cron.gwowevents.charinfo.php on line 50

I have rewritten the CRON process and it is working fine for me now.

Try replacing ALL of the code in your cron.gwowevents.charinfo.php file with the following:


<?php
// ################################################## ######################
//
// gWoWEvents, Copyright ? 2006, Ryan Snook (www.gryphonllc.com )
//
// If you have fixes, improvements or other additions to make to
// gWoWEvents, please contact me at rsnook@gmail.com for collaboration.
// I appreciate your kind consideration.
//
// This work is licensed under the Creative Commons
// Attribution-Noncommercial-No Derivative Works 3.0 United States License.
// To view a copy of this license, visit
// http://creativecommons.org/licenses/by-nc-nd/3.0/us/ or send a letter to
// Creative Commons, 171 Second Street, Suite 300,
// San Francisco, California, 94105, USA.
//
// ########################### SVN info ###################################
// $Id: cron.gwowevents.charinfo.php 830 2008-01-23 20:18:51Z gryphon $
// $Rev: 830 $
// $LastChangedBy: gryphon $
// $Date: 2008-01-23 12:18:51 -0800 (Wed, 23 Jan 2008) $

// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
if (!is_object($vbulletin->db))
{
exit;
}
// ########################## REQUIRE BACK-END ############################
require_once('./includes/functions_gwowevents.php');
// Following line provided by LostPhoenix
$res = $vbulletin->db->query("SELECT * FROM " . TABLE_PREFIX . "gwowevents WHERE `armorydata` != '1' GROUP BY `realmchar` ORDER BY `armorydata` ASC");

while ($char = $vbulletin->db->fetch_array($res))
{
require_once('./includes/class_gwowarmory.php');
$x = new gWoWArmory;
$x->SetLocale($char['locale']);
$x->SetRealmName($char['realm']);
$x->SetCharName($char['character']);

sleep(5);
$character['sheet'] = $x->FetchCharacterSheet();
sleep(5);
$character['skills'] = $x->FetchCharacterSkills();

if ($character['characterInfo']['errCode'] != 'noCharacter')
{
$charinfo_query = "
`charurl` = '" . $character['sheet']['characterInfo']['character']['charUrl'] . "',
`level` = '" . $character['sheet']['characterInfo']['character']['level'] . "',
`title` = '" . $character['sheet']['characterInfo']['character']['prefix'] . "',
`faction` = '" . $character['sheet']['characterInfo']['character']['faction'] . "',
`factionid` = '" . $character['sheet']['characterInfo']['character']['factionId'] . "',
`gender` = '" . $character['sheet']['characterInfo']['character']['gender'] . "',
`genderid` = '" . $character['sheet']['characterInfo']['character']['genderId'] . "',
`race` = '" . $character['sheet']['characterInfo']['character']['race'] . "',
`raceid` = '" . $character['sheet']['characterInfo']['character']['raceId'] . "',
`class` = '" . $character['sheet']['characterInfo']['character']['class'] . "',
`classid` = '" . $character['sheet']['characterInfo']['character']['classId'] . "',
`talentspec` = '" .
$character['sheet']['characterInfo']['characterTab']['talentSpec']['treeOne'] . "," .
$character['sheet']['characterInfo']['characterTab']['talentSpec']['treeTwo'] . "," .
$character['sheet']['characterInfo']['characterTab']['talentSpec']['treeThree'] . "',
`talent1` = '" . $character['sheet']['characterInfo']['characterTab']['talentSpec']['treeOne'] . "',
`talent2` = '" . $character['sheet']['characterInfo']['characterTab']['talentSpec']['treeTwo'] . "',
`talent3` = '" . $character['sheet']['characterInfo']['characterTab']['talentSpec']['treeThree'] .

"',
`guild` = '" . $character['sheet']['characterInfo']['character']['guildName'] . "',
`guildurl` = '" . $character['sheet']['characterInfo']['character']['guildUrl'] . "',
`hp` = '" .

$character['sheet']['characterInfo']['characterTab']['characterBars']['health']['effective'] . "',
`mp` = '" .

$character['sheet']['characterInfo']['characterTab']['characterBars']['secondBar']['effective'] . "',
`str` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['strength']['effective'] . "',
`agi` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['agility']['effective'] . "',
`sta` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['stamina']['effective'] . "',
`int` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['intellect']['effective'] . "',
`spi` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['spirit']['effective'] . "',
`arm` = '" . $character['sheet']['characterInfo']['characterTab']['baseStats']['armor']['effective']

. "',
`strbase` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['strength']['base'] . "',
`agibase` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['agility']['base'] . "',
`stabase` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['stamina']['base'] . "',
`intbase` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['intellect']['base'] . "',
`spibase` = '" . $character['sheet']['characterInfo']['characterTab']['baseStats']['spirit']['base']

. "',
`armbase` = '" . $character['sheet']['characterInfo']['characterTab']['baseStats']['armor']['base']

. "',
`prof1` = '" .

$character['sheet']['characterInfo']['characterTab']['professions']['skill']['0']['name'] . "',
`skill1` = '" .

$character['sheet']['characterInfo']['characterTab']['professions']['skill']['0']['value']['0'] . "',
`prof2` = '" .

$character['sheet']['characterInfo']['characterTab']['professions']['skill']['1']['name'] . "',
`skill2` = '" .

$character['sheet']['characterInfo']['characterTab']['professions']['skill']['1']['value']['0'] . "',
`cooking` = '" .

$character['skills']['characterInfo']['skillTab']['skillCategory']['1']['skill']['0']['value']['0'] . "',
`firstaid` = '" .

$character['skills']['characterInfo']['skillTab']['skillCategory']['1']['skill']['1']['value']['0'] . "',
`fishing` = '" .

$character['skills']['characterInfo']['skillTab']['skillCategory']['1']['skill']['2']['value']['0'] . "',
`riding` = '" .

$character['skills']['characterInfo']['skillTab']['skillCategory']['1']['skill']['3']['value']['0'] . "',
";
$char['realmchar'] = addslashes($char['realm'] . "." . $char['character']);
if ($character['sheet']['characterInfo'] &&

$character['sheet']['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . "

`armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}
else
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE

`realmchar` = '" . $char['realmchar'] . "'");
}
}

if (VB_AREA == 'AdminCP')
{
echo $char['character'] . '<pre>';
print_r($character['skills']);
echo '<pre><hr />';
}
$char_updated .= $char['character'] . ", ";
}
echo $char_updated;
?>

[stevewwm]

Getting this error when trying to add an event to the calendar.


Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT gwe.*,
user.username,
userfield.field0
FROM forumgwowevents gwe
LEFT JOIN forumuserfield AS userfield ON userfield.userid = gwe.userid
LEFT JOIN forumuser AS user ON user.userid = gwe.userid
WHERE eventid = 07
ORDER BY
gwe.response ASC, gwe.date;

MySQL Error : Unknown column 'userfield.field0' in 'field list'
Error Number : 1054
Date : Thursday, March 20th 2008 @ 04:01:35 PM
Script : http://WEBSITENAME.com/forum/calendar.php?do=getinfo&e=7&day=2008-12-20
Referrer : http://WEBSITENAME.com/forum/calendar.php?do=add&type=single&c=1
IP Address :
Username :
Classname : vB_Database

[LostPhoenix]

If found by grouping by character name you put a lot less stress on the armory. The current SQL Call to get the array of characters that needs to be updated will put the same character in multiple times.

By changing:

$res = $vbulletin->db->query("SELECT * FROM " . TABLE_PREFIX . "gwowevents WHERE `armorydata` != '1' ORDER BY `armorydata` ASC");


to:

$res = $vbulletin->db->query("SELECT * FROM " . TABLE_PREFIX . "gwowevents WHERE `armorydata` != '1' GROUP BY `realmchar` ORDER BY `armorydata` ASC");


It will only put each character to be updated once, but it will update the info for all events the character is signed up for.

[Gryphon]

@stevewwm You need to update the field id in the options.

@LostPhoenix, @Eviserator I will look in these changes.

[Kinneas]

If you are receiving the following error:

PHP Fatal error:

Cannot use string offset as an array in /XXX/XXX/XXX/forum/includes/cron/cron.gwowevents.charinfo.php on line 50

I have rewritten the CRON process and it is working fine for me now.

Try replacing ALL of the code in your cron.gwowevents.charinfo.php file with the following:


<?php
// ################################################## ######################
//
// gWoWEvents, Copyright ? 2006, Ryan Snook (www.gryphonllc.com )
//
// If you have fixes, improvements or other additions to make to
// gWoWEvents, please contact me at rsnook@gmail.com for collaboration.
// I appreciate your kind consideration.
//
// This work is licensed under the Creative Commons
// Attribution-Noncommercial-No Derivative Works 3.0 United States License.
// To view a copy of this license, visit
// http://creativecommons.org/licenses/by-nc-nd/3.0/us/ or send a letter to
// Creative Commons, 171 Second Street, Suite 300,
// San Francisco, California, 94105, USA.
//
// ########################### SVN info ###################################
// $Id: cron.gwowevents.charinfo.php 830 2008-01-23 20:18:51Z gryphon $
// $Rev: 830 $
// $LastChangedBy: gryphon $
// $Date: 2008-01-23 12:18:51 -0800 (Wed, 23 Jan 2008) $

// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
if (!is_object($vbulletin->db))
{
exit;
}
// ########################## REQUIRE BACK-END ############################
require_once('./includes/functions_gwowevents.php');
// Following line provided by LostPhoenix
$res = $vbulletin->db->query("SELECT * FROM " . TABLE_PREFIX . "gwowevents WHERE `armorydata` != '1' GROUP BY `realmchar` ORDER BY `armorydata` ASC");

while ($char = $vbulletin->db->fetch_array($res))
{
require_once('./includes/class_gwowarmory.php');
$x = new gWoWArmory;
$x->SetLocale($char['locale']);
$x->SetRealmName($char['realm']);
$x->SetCharName($char['character']);

sleep(5);
$character['sheet'] = $x->FetchCharacterSheet();
sleep(5);
$character['skills'] = $x->FetchCharacterSkills();

if ($character['characterInfo']['errCode'] != 'noCharacter')
{
$charinfo_query = "
`charurl` = '" . $character['sheet']['characterInfo']['character']['charUrl'] . "',
`level` = '" . $character['sheet']['characterInfo']['character']['level'] . "',
`title` = '" . $character['sheet']['characterInfo']['character']['prefix'] . "',
`faction` = '" . $character['sheet']['characterInfo']['character']['faction'] . "',
`factionid` = '" . $character['sheet']['characterInfo']['character']['factionId'] . "',
`gender` = '" . $character['sheet']['characterInfo']['character']['gender'] . "',
`genderid` = '" . $character['sheet']['characterInfo']['character']['genderId'] . "',
`race` = '" . $character['sheet']['characterInfo']['character']['race'] . "',
`raceid` = '" . $character['sheet']['characterInfo']['character']['raceId'] . "',
`class` = '" . $character['sheet']['characterInfo']['character']['class'] . "',
`classid` = '" . $character['sheet']['characterInfo']['character']['classId'] . "',
`talentspec` = '" .
$character['sheet']['characterInfo']['characterTab']['talentSpec']['treeOne'] . "," .
$character['sheet']['characterInfo']['characterTab']['talentSpec']['treeTwo'] . "," .
$character['sheet']['characterInfo']['characterTab']['talentSpec']['treeThree'] . "',
`talent1` = '" . $character['sheet']['characterInfo']['characterTab']['talentSpec']['treeOne'] . "',
`talent2` = '" . $character['sheet']['characterInfo']['characterTab']['talentSpec']['treeTwo'] . "',
`talent3` = '" . $character['sheet']['characterInfo']['characterTab']['talentSpec']['treeThree'] .

"',
`guild` = '" . $character['sheet']['characterInfo']['character']['guildName'] . "',
`guildurl` = '" . $character['sheet']['characterInfo']['character']['guildUrl'] . "',
`hp` = '" .

$character['sheet']['characterInfo']['characterTab']['characterBars']['health']['effective'] . "',
`mp` = '" .

$character['sheet']['characterInfo']['characterTab']['characterBars']['secondBar']['effective'] . "',
`str` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['strength']['effective'] . "',
`agi` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['agility']['effective'] . "',
`sta` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['stamina']['effective'] . "',
`int` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['intellect']['effective'] . "',
`spi` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['spirit']['effective'] . "',
`arm` = '" . $character['sheet']['characterInfo']['characterTab']['baseStats']['armor']['effective']

. "',
`strbase` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['strength']['base'] . "',
`agibase` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['agility']['base'] . "',
`stabase` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['stamina']['base'] . "',
`intbase` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['intellect']['base'] . "',
`spibase` = '" . $character['sheet']['characterInfo']['characterTab']['baseStats']['spirit']['base']

. "',
`armbase` = '" . $character['sheet']['characterInfo']['characterTab']['baseStats']['armor']['base']

. "',
`prof1` = '" .

$character['sheet']['characterInfo']['characterTab']['professions']['skill']['0']['name'] . "',
`skill1` = '" .

$character['sheet']['characterInfo']['characterTab']['professions']['skill']['0']['value']['0'] . "',
`prof2` = '" .

$character['sheet']['characterInfo']['characterTab']['professions']['skill']['1']['name'] . "',
`skill2` = '" .

$character['sheet']['characterInfo']['characterTab']['professions']['skill']['1']['value']['0'] . "',
`cooking` = '" .

$character['skills']['characterInfo']['skillTab']['skillCategory']['1']['skill']['0']['value']['0'] . "',
`firstaid` = '" .

$character['skills']['characterInfo']['skillTab']['skillCategory']['1']['skill']['1']['value']['0'] . "',
`fishing` = '" .

$character['skills']['characterInfo']['skillTab']['skillCategory']['1']['skill']['2']['value']['0'] . "',
`riding` = '" .

$character['skills']['characterInfo']['skillTab']['skillCategory']['1']['skill']['3']['value']['0'] . "',
";
$char['realmchar'] = addslashes($char['realm'] . "." . $char['character']);
if ($character['sheet']['characterInfo'] &&

$character['sheet']['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . "

`armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}
else
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE

`realmchar` = '" . $char['realmchar'] . "'");
}
}

if (VB_AREA == 'AdminCP')
{
echo $char['character'] . '<pre>';
print_r($character['skills']);
echo '<pre><hr />';
}
$char_updated .= $char['character'] . ", ";
}
echo $char_updated;
?>


Can confirm that this also resolved the problem for me. Thanks :)

[3drage]

Getting the following error when attempting to run the chron manually:

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE vbgwowevents SET
`charurl` = 'r=Silvermoon&n=Druidia',
`level` = '60',
`title` = '',
`faction` = 'Horde',
`factionid` = '1',
`gender` = 'Male',
`genderid` = '0',
`race` = 'Tauren',
`raceid` = '6',
`class` = 'Druid',
`classid` = '11',
`talentspec` = '0,34,17',
`talent1` = '0',
`talent2` = '34',
`talent3` = '17',
`guild` = 'The Revenants',
`guildurl` = 'r=Silvermoon&n=The+Revenants&p=1',
`hp` = '4518',
`mp` = '3589',
`str` = '111',
`agi` = '143',
`sta` = '300',
`int` = '175',
`spi` = '166',
`arm` = '2025',
`strbase` = '72',
`agibase` = '56',
`stabase` = '74',
`intbase` = '117',
`spibase` = '115',
`armbase` = '1521',
`prof1` = 'Mining',
`skill1` = '321',
`prof2` = 'Skinning',
`skill2` = '314',
`cooking` = '42',
`firstaid` = '322',
`fishing` = '1',
`riding` = '150',
`armorydata` = '1' WHERE `realmchar` = 'Silvermoon.Druidia';

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Sunday, April 6th 2008 @ 12:38:50 PM
Script : http://www.deathwing-guild.com/admincp/cronadmin.php?do=runcron&cronid=19
Referrer : http://www.deathwing-guild.com/admincp/cronadmin.php?do=modify
IP Address : 24.10.8.51
Username : Necronomicon
Classname : vb_database

[Mother_Dee]

New error: Cannot use string offset as an array ... on line 116. :(

If you are receiving the following error:

PHP Fatal error:

Cannot use string offset as an array in /XXX/XXX/XXX/forum/includes/cron/cron.gwowevents.charinfo.php on line 50

I have rewritten the CRON process and it is working fine for me now.

Try replacing ALL of the code in your cron.gwowevents.charinfo.php file with the following:


<?php
// ################################################## ######################
//
// gWoWEvents, Copyright ? 2006, Ryan Snook (www.gryphonllc.com )
//
// If you have fixes, improvements or other additions to make to
// gWoWEvents, please contact me at rsnook@gmail.com for collaboration.
// I appreciate your kind consideration.
//
// This work is licensed under the Creative Commons
// Attribution-Noncommercial-No Derivative Works 3.0 United States License.
// To view a copy of this license, visit
// http://creativecommons.org/licenses/by-nc-nd/3.0/us/ or send a letter to
// Creative Commons, 171 Second Street, Suite 300,
// San Francisco, California, 94105, USA.
//
// ########################### SVN info ###################################
// $Id: cron.gwowevents.charinfo.php 830 2008-01-23 20:18:51Z gryphon $
// $Rev: 830 $
// $LastChangedBy: gryphon $
// $Date: 2008-01-23 12:18:51 -0800 (Wed, 23 Jan 2008) $

// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
if (!is_object($vbulletin->db))
{
exit;
}
// ########################## REQUIRE BACK-END ############################
require_once('./includes/functions_gwowevents.php');
// Following line provided by LostPhoenix
$res = $vbulletin->db->query("SELECT * FROM " . TABLE_PREFIX . "gwowevents WHERE `armorydata` != '1' GROUP BY `realmchar` ORDER BY `armorydata` ASC");

while ($char = $vbulletin->db->fetch_array($res))
{
require_once('./includes/class_gwowarmory.php');
$x = new gWoWArmory;
$x->SetLocale($char['locale']);
$x->SetRealmName($char['realm']);
$x->SetCharName($char['character']);

sleep(5);
$character['sheet'] = $x->FetchCharacterSheet();
sleep(5);
$character['skills'] = $x->FetchCharacterSkills();

if ($character['characterInfo']['errCode'] != 'noCharacter')
{
$charinfo_query = "
`charurl` = '" . $character['sheet']['characterInfo']['character']['charUrl'] . "',
`level` = '" . $character['sheet']['characterInfo']['character']['level'] . "',
`title` = '" . $character['sheet']['characterInfo']['character']['prefix'] . "',
`faction` = '" . $character['sheet']['characterInfo']['character']['faction'] . "',
`factionid` = '" . $character['sheet']['characterInfo']['character']['factionId'] . "',
`gender` = '" . $character['sheet']['characterInfo']['character']['gender'] . "',
`genderid` = '" . $character['sheet']['characterInfo']['character']['genderId'] . "',
`race` = '" . $character['sheet']['characterInfo']['character']['race'] . "',
`raceid` = '" . $character['sheet']['characterInfo']['character']['raceId'] . "',
`class` = '" . $character['sheet']['characterInfo']['character']['class'] . "',
`classid` = '" . $character['sheet']['characterInfo']['character']['classId'] . "',
`talentspec` = '" .
$character['sheet']['characterInfo']['characterTab']['talentSpec']['treeOne'] . "," .
$character['sheet']['characterInfo']['characterTab']['talentSpec']['treeTwo'] . "," .
$character['sheet']['characterInfo']['characterTab']['talentSpec']['treeThree'] . "',
`talent1` = '" . $character['sheet']['characterInfo']['characterTab']['talentSpec']['treeOne'] . "',
`talent2` = '" . $character['sheet']['characterInfo']['characterTab']['talentSpec']['treeTwo'] . "',
`talent3` = '" . $character['sheet']['characterInfo']['characterTab']['talentSpec']['treeThree'] .

"',
`guild` = '" . $character['sheet']['characterInfo']['character']['guildName'] . "',
`guildurl` = '" . $character['sheet']['characterInfo']['character']['guildUrl'] . "',
`hp` = '" .

$character['sheet']['characterInfo']['characterTab']['characterBars']['health']['effective'] . "',
`mp` = '" .

$character['sheet']['characterInfo']['characterTab']['characterBars']['secondBar']['effective'] . "',
`str` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['strength']['effective'] . "',
`agi` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['agility']['effective'] . "',
`sta` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['stamina']['effective'] . "',
`int` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['intellect']['effective'] . "',
`spi` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['spirit']['effective'] . "',
`arm` = '" . $character['sheet']['characterInfo']['characterTab']['baseStats']['armor']['effective']

. "',
`strbase` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['strength']['base'] . "',
`agibase` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['agility']['base'] . "',
`stabase` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['stamina']['base'] . "',
`intbase` = '" .

$character['sheet']['characterInfo']['characterTab']['baseStats']['intellect']['base'] . "',
`spibase` = '" . $character['sheet']['characterInfo']['characterTab']['baseStats']['spirit']['base']

. "',
`armbase` = '" . $character['sheet']['characterInfo']['characterTab']['baseStats']['armor']['base']

. "',
`prof1` = '" .

$character['sheet']['characterInfo']['characterTab']['professions']['skill']['0']['name'] . "',
`skill1` = '" .

$character['sheet']['characterInfo']['characterTab']['professions']['skill']['0']['value']['0'] . "',
`prof2` = '" .

$character['sheet']['characterInfo']['characterTab']['professions']['skill']['1']['name'] . "',
`skill2` = '" .

$character['sheet']['characterInfo']['characterTab']['professions']['skill']['1']['value']['0'] . "',
`cooking` = '" .

$character['skills']['characterInfo']['skillTab']['skillCategory']['1']['skill']['0']['value']['0'] . "',
`firstaid` = '" .

$character['skills']['characterInfo']['skillTab']['skillCategory']['1']['skill']['1']['value']['0'] . "',
`fishing` = '" .

$character['skills']['characterInfo']['skillTab']['skillCategory']['1']['skill']['2']['value']['0'] . "',
`riding` = '" .

$character['skills']['characterInfo']['skillTab']['skillCategory']['1']['skill']['3']['value']['0'] . "',
";
$char['realmchar'] = addslashes($char['realm'] . "." . $char['character']);
if ($character['sheet']['characterInfo'] &&

$character['sheet']['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . "

`armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}
else
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE

`realmchar` = '" . $char['realmchar'] . "'");
}
}

if (VB_AREA == 'AdminCP')
{
echo $char['character'] . '<pre>';
print_r($character['skills']);
echo '<pre><hr />';
}
$char_updated .= $char['character'] . ", ";
}
echo $char_updated;
?>

[atomhead]

Getting "server has gone away messages", manual update does not work either, and my characters aren't updating in the event page.

[atomhead]

Here is my hack for those of us who have hosts that don't like the cron. It's not perfect but it does work.

Find the following code in cron.gwowevents.charinfo.php

if ($character['characterInfo'] && $character['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}
else
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}


and change it to:

$dbhost = '';
$dbname = '';
$dbuser = '';
$dbpasswd = '';

if ($character['characterInfo'] && $character['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
//$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
@ $db2 = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
mysql_select_db("$dbname",$db2);
mysql_query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'", $db2);
mysql_close($db2);
} else {
//$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'");
@ $db2 = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
mysql_select_db("$dbname",$db2);
mysql_query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'", $db2);
mysql_close($db2);
}


Obviously you have to add your database info. Until I take the time to learn vbulletin and fix it properly lol.

This will put more stress on your SQL server as it opens and closes a connection each time it updates the user.

This fixed my armory updating problem (I also setup that other hack someone posted about grouping characters or something)

[atomhead]

Does this work with the "new thread on event creation" mod? I'm going to test it later when I get time...

[Caerydd]

Does this work with the "new thread on event creation" mod? I'm going to test it later when I get time...

As yet this is supposedly not compatible with Event Forums.

[atomhead]

I posted on the Event Forums thread asking if they could make it work with this mod. Currently after creating a raid vBEF makes the thread but I get amessage "not authorized to signup" even though permissions are set correctly. If anyone can help it would be appreciated. :)

https://vborg.vbsupport.ru/showthread.php?t=123416

[atomhead]

As yet this is supposedly not compatible with Event Forums.

Ok, thanks. I posted my issue hopefully that helps and someone can look into it :)

[Kinneas]

This stopped working for me after upgrading to RC4 due to the CSRF patches.

To fix it, edit the template "gwe_signup_form"

Find:
<form action="calendar.php?do=getinfo&e=$eventinfo[eventid]" method="post">

Below Add:
<input type="hidden" name="securitytoken" value="$bbuserinfo[securitytoken]" />

Should work again :)

[quarum]

Updated my site today from 3.7 RC3 to 3.7.0 "Gold"
When users try to sign up they get this message:

Your submission could not be processed because a security token was missing or mismatched.

If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error.

[Dsru123]

This stopped working for me after upgrading to RC4 due to the CSRF patches.

To fix it, edit the template "gwe_signup_form"

Find:
<form action="calendar.php?do=getinfo&e=$eventinfo[eventid]" method="post">

Below Add:
<input type="hidden" name="securitytoken" value="$bbuserinfo[securitytoken]" />

Should work again :)

works well.
vB 3.7
vBadvanced 3.01
thank you.

[quarum]

Bingo - that did it - thank you very much!

[jim6763nva]

Jim,

Looks like you have the same issue as me. Login to your admin and check your scheduled tasks. Select gWoWEvents and select run now. If you get an error then we are in the same boat.

I just reinstalled this on my site and it was taking a long time to update to I tried your suggestion. The scheduled task seem to work fine, so I'm not sure why the calendar interface takes so long.

Jim

[portent]

After much searching I finally found the config options in the vBulletin options section. I know it sounds stupid but it'd help mentioning that's where it is. ;)

Works well so far, the only thing I'd suggest would be:

a) An easy way to view how many healers/DPS/tanks have signed for a raid. This is much more important than seeing how many of a certain class joined.

b) A way to add the appropriate raid icon to the calendar entry.

My current guild uses PHPRaider for phpBB which offers both, however it's less integrated than gWoWEvents (which I just installed for my old guild)

[christofer]

any update on the "cron/cron.gwowevents.charinfo.php on line 50" issue? I am using vb 3.7 and the current version of gwowevents. My site has not had any updates in the past 2-3 days.

[Largo .//npc]

I'd love to use this on my guild's forums but we don't play WoW, we play SWG.
I've looked at the code but it's way too over my head to be able to convert it. Guess I'll have to go without.
Good mod though!

[Largo .//npc]

I've been looking through the code ect, and I've managed to get it looking more like what my guild need, although it's not really working properly. Would you be able to help us out or is that a no go?

[tuaguild]

i get the following error when doing manual armory import

gWoWEvents Armory Import


Warning: Invalid argument supplied for foreach() in /includes/cron/cron.gwowevents.charinfo.php on line 62
Lycomedesnw
Array
(
[globalSearch] => 1
[lang] => en_us
[errorhtml] =>
[prof1] =>
[skill1] =>
)
Array
(
[globalSearch] => 1
[lang] => en_us
[errorhtml] =>
)
--------------------------------------------------------------------------------Lycomedesnw, Done

[JoeGoff]

I get Failed opening required './includes/class_gwowarmory.php' (include_path='...') in /.../forums/includes/cron/cron.gwowevents.charinfo.php on line 37

The file class_gwowarmory.php is not in the zip file.
Can we get a link to this?
Thanks.

I also noticed that if you set up recurring entries and then signup, it signs you up for every entry, not just the date you signed up on.

Otherwise, I like it.

[Gryphon]

I get Failed opening required './includes/class_gwowarmory.php' (include_path='...') in /.../forums/includes/cron/cron.gwowevents.charinfo.php on line 37

The file class_gwowarmory.php is not in the zip file.
Can we get a link to this?
Thanks.

I also noticed that if you set up recurring entries and then signup, it signs you up for every entry, not just the date you signed up on.

Otherwise, I like it.

Sorry, always forget that. I have updated the zip to include the file.

About recurring, the signups are stored by event id, a recurring event is a singe event entry. This is something I would like to work on, currently it requires a new entry per event.

[Ulkesh]

I'd love to get this sucker working with Recurring events. I've upgraded to this mod from ElricStorm's calendar plugin.

My users set up multiple recurring events (every Monday is Gruul and Magtheridon, every thursday is a badge speed run through Karazahn, etc...), so having a sign-up mod that works with recurring events is crucial to them (thus to me ;)). I've got this installed and will tell them to work with single events for the time being, but will EAGERLY await a version that supports recurring events. :)

Great job on all the WoW plugins, by the way. You rock. :)

[Kinneas]

For some reason my members and I are no longer able to signup as "Maybe", only Yes and No.

I have ensured that this is enabled in ACP options (have even toggled it off and on again), I have also re-uploaded/overwritten all the files and re-imported the product with overwrite enabled.

Any ideas G?

Update: Never mind, figured it out :) - Was a pesky template. I edited the template before to fix the security token thingy and it didn't revert. Did you change "Tentative" to "Maybe" by any chance? :P

[JoeGoff]

Sorry, always forget that. I have updated the zip to include the file.

About recurring, the signups are stored by event id, a recurring event is a singe event entry. This is something I would like to work on, currently it requires a new entry per event.

Thanks, it is working now.

[christofer]

any update on the

gWoWEvents Armory Import

Fatal error: Cannot use string offset as an array in /public_html/xxx/forums/includes/cron/cron.gwowevents.charinfo.php on line 64

issue?

[neo88]

I was wondering if there is a way to get an RSS feed of the events in your Calendar, and put them on a website. So other people can see what new events are going on instead of going to the forums.

I remember reading something about it that there was this hack, i tried searching, but no luck.

THanks

[CoryHawk]

Gryph...

I updated with the attached file and have the field set correctly in the options (We just Field9) and I still get this error

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT gwe.*,
user.username,
userfield.field0
FROM
gwowevents gwe
LEFT JOIN
userfield AS userfield ON userfield.userid = gwe.userid
LEFT JOIN
user AS user ON user.userid = gwe.userid
WHERE
eventid = 092
ORDER BY
gwe.response ASC, gwe.class;

MySQL Error : Unknown column 'userfield.field0' in 'field list'
Error Number : 1054
Request Date : Friday, May 16th 2008 @ 12:17:09 AM
Error Date : Friday, May 16th 2008 @ 12:17:09 AM
Script : http://forums.kaaos.com/calendar.php?do=getinfo&e=92&day=2008-5-15&c=2
Referrer : http://forums.kaaos.com/calendar.php
IP Address : **.**.**.**
Username : Blayloc
Classname : vB_Database
MySQL Version : 4.1.22-standard

[christofer]

For some reason my members and I are no longer able to signup as "Maybe", only Yes and No.

I have ensured that this is enabled in ACP options (have even toggled it off and on again), I have also re-uploaded/overwritten all the files and re-imported the product with overwrite enabled.

Any ideas G?

Update: Never mind, figured it out :) - Was a pesky template. I edited the template before to fix the security token thingy and it didn't revert. Did you change "Tentative" to "Maybe" by any chance? :P

What exactly did you change to get 'maybe' to work?

[Kinneas]

What exactly did you change to get 'maybe' to work?
After updating to the latest version I just reverted the gwe_signup_form template.

[Mother_Dee]

any update on the "cron/cron.gwowevents.charinfo.php on line 50" issue? I am using vb 3.7 and the current version of gwowevents. My site has not had any updates in the past 2-3 days.

Same issue. Previously posted fix by another user gave me an error on another line, reverted file and back to the issue with line 50. Still hoping for a fix. <3

[KrU$ty]

I'm getting an issue where the selected field is not getting picked up. Even though all settings are correct and the information entered into the field is also correct, i get "Add characters to your profile to singup for this event.".

Also notice the spelling mistake in the error message.

Edit: I fixed the error. So its just the spelling mistake i guess.

[Ammadar]

I am very new to vBulleting so maybe I am just blind but I have a question. I followed the installation instructions and I get to Step 4 (Fill in the gWoWEvents configuration options.) Where are these options? in the Admin Console? Edit a php file? I have must be blind but I have been reading the posts for the last two hours and I can't find the configuration options I know I need to change my userfield setting to fix the error below but I can't find the place to fix it.

Any help would be appreciated.

Thanks.

Database error in vBulletin 3.7.1:

Invalid SQL:

SELECT gwe.*,
user.username,
userfield.field0
FROM
gwowevents gwe
LEFT JOIN
userfield AS userfield ON userfield.userid = gwe.userid
LEFT JOIN
user AS user ON user.userid = gwe.userid
WHERE
eventid = 03
ORDER BY
gwe.response ASC, gwe.date;

MySQL Error : Unknown column 'userfield.field0' in 'field list'
Error Number : 1054
Request Date : Wednesday, June 4th 2008 @ 04:01:46 PM
Error Date : Wednesday, June 4th 2008 @ 04:01:47 PM
Script : http://www.wowpara.com/calendar.php?do=getinfo&e=3&day=2008-6-4&c=1
Referrer : http://www.wowpara.com/calendar.php
IP Address : 10.64.2.3
Username : Viane
Classname : vb_database
MySQL Version : 4.1.20

[Ammadar]

<font size="3">Finally Found The Options Ignore My post it was in the third post on the site I must have read it 20 times...

For those that missed it like me it is :
vBulletin Options

at the very bottom you will see the configs.</font>

[ColossusCH]

Hi to all,
i get a problem with names like "Râul, Merlè, ect.)
gwowevent, can't find names like this in Armory.

can somebody help me?

PS, in gwowroster, those names are: Merlé Râul

thank you for help.

[Gryphon]

Hi to all,
i get a problem with names like "R?ul, Merl?, ect.)
gwowevent, can't find names like this in Armory.

can somebody help me?

PS, in gwowroster, those names are: Merlé Râul


thank you for help.

Yes, these characters is still an issue. There is no fix currently I am sorry to say.

[Sanctorum]

I filled out my config in Admin but I still get this error, I even did a fresh install of vBulletin 3.7.1, can someone tell me how to get this working for my guild?:

Database error in vBulletin 3.7.1:

Invalid SQL:

SELECT gwe.*,
user.username,
userfield.field0
FROM
gwowevents gwe
LEFT JOIN
userfield AS userfield ON userfield.userid = gwe.userid
LEFT JOIN
user AS user ON user.userid = gwe.userid
WHERE
eventid = 01
ORDER BY
gwe.response ASC, gwe.date;

MySQL Error : Unknown column 'userfield.field0' in 'field list'
Error Number : 1054
Request Date : Wednesday, June 11th 2008 @ 03:38:22 PM
Error Date : Wednesday, June 11th 2008 @ 03:38:22 PM
Script : http://www.bloodorderguild.us/bogforum/calendar.php?do=getinfo&day=2008-6-11&e=1&c=1
Referrer : http://www.bloodorderguild.us/bogforum/index.php
IP Address : 204.249.195.240
Username : Sanctorum
Classname : vB_Database
MySQL Version : 5.1.24-rc

[Gryphon]

MySQL Error : Unknown column 'userfield.field0' in 'field list'

You need to change your field id from 0.

[Sanctorum]

You need to change your field id from 0.

Oh, silly me... I figured it out after I posted. Thanks :)

Seems the Armory is down, otherwise it's a great mod, thanks for the good work. Marked as Installed.

[twitch]

awesome mod, thanks

[Sanctorum]

It works now, but it doesn't import the data from the Armory:

Aquilae Awaiting Armory data import...

:( Is there a fix for this or am I being stupid again? Yes, it's set to US.

*update*
It appears to update when the player logs off of wow, not sure if this is relevant.

[Tazz_1962]

Hi to all,
i get a problem with names like "R?ul, Merl?, ect.)
gwowevent, can't find names like this in Armory.

can somebody help me?

PS, in gwowroster, those names are: Merlé Râul


thank you for help.

Unfortunately wow armory and your website are not talking the same language. I had this issue with our guild name and with some of our member names. I posted how I fixed it for the guild name earlier. If you have your users with the non traditional lettering have them copy and paste the name as they are shown in gwowroster. Merlé instead of Merl? into there userCP where they list their chars US/EU|server|faction|Merlé the system will work for them and pull their stats.

[ColossusCH]

Hi Gryphon, hi Tazz 1962

Thank you for your reply.
i will try your solution

[Dsru123]

Same issue. Previously posted fix by another user gave me an error on another line, reverted file and back to the issue with line 50. Still hoping for a fix. <3

Same issue. I am trying to figure it out when it statred, I think with Version 3.7.1
PL2........... 6/19/08 is when I updated and anybody after that shows "Awaiting Armory Import".

Going to try and revert and see if its it.

EDIT*****
was a shot, reverted all the way back to 3.7.1 and still same error, back at PL2.

EDIT 2 *****
Host upgraded to PHP 5.2.6 and I believe that is where it puked. Still trying.

[Dsru123]

now getting data from the armory, almost all of it, no more error.

but, the root of the problem is that it is incorrectly accessing the parsed XML data. I commented out the problem lines and its "working" now, but the profession name and skill level information will not be present. I tried fetching the XML data my self so I could see where the problem was and fix the fetch, but any way I try to fetch the XML data it comes back as a HTML page instead of an XML blob, so I'm not sure what other special stuff it is doing to fetch the raw data instead of the pretty html version.

Maybe another mind can fix this part and we will be good to go?

<?php
// ################################################## ######################
//
// gWoWEvents, Copyright ? 2006, Ryan Snook (www.gryphonllc.com )
//
// If you have fixes, improvements or other additions to make to
// gWoWEvents, please contact me at rsnook@gmail.com for collaboration.
// I appreciate your kind consideration.
//
// This work is licensed under the Creative Commons
// Attribution-Noncommercial-No Derivative Works 3.0 United States License.
// To view a copy of this license, visit
// http://creativecommons.org/licenses/by-nc-nd/3.0/us/ or send a letter to
// Creative Commons, 171 Second Street, Suite 300,
// San Francisco, California, 94105, USA.
//
// ########################### SVN info ###################################
// $Id: cron.gwowevents.charinfo.php 830 2008-01-23 20:18:51Z gryphon $
// $Rev: 830 $
// $LastChangedBy: gryphon $
// $Date: 2008-01-23 12:18:51 -0800 (Wed, 23 Jan 2008) $

// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
if (!is_object($vbulletin->db))
{
exit;
}

// ########################## REQUIRE BACK-END ############################
require_once('./includes/functions_gwowevents.php');

$res = $vbulletin->db->query("SELECT * FROM " . TABLE_PREFIX . "gwowevents WHERE `armorydata` != '1' ORDER BY `armorydata` ASC");

while ($char = $vbulletin->db->fetch_array($res))
{
require_once('./includes/class_gwowarmory.php');
$x = new gWoWArmory;
$x->SetLocale($char['locale']);
$x->SetRealmName($char['realm']);
$x->SetCharName($char['character']);

sleep(10);
$character = $x->FetchCharacterSheet();
sleep(10);
$character_skills = $x->FetchCharacterSkills();

if ($character != false)
{
/*
if ($character['characterInfo']['characterTab']['professions']['skill']['0'])
{
$character['prof1'] = $character['characterInfo']['characterTab']['professions']['skill']['0']['name'];
$character['skill1'] = $character['characterInfo']['characterTab']['professions']['skill']['0']['value']['0'];
}
else
{
$character['prof1'] = $character['characterInfo']['characterTab']['professions']['skill']['name'];
$character['skill1'] = $character['characterInfo']['characterTab']['professions']['skill']['value']['0'];
}
*/

/*
$secondaryskill = array();
foreach($character_skills['characterInfo']['skillTab']['skillCategory']['1']['skill'] as $skill)
{
$secondaryskill[$skill['key']] = $skill['value']['0'];
}
*/

$charinfo_query = "
`charurl` = '" . $character['characterInfo']['character']['charUrl'] . "',
`level` = '" . $character['characterInfo']['character']['level'] . "',
`title` = '" . $character['characterInfo']['character']['title'] . "',
`faction` = '" . $character['characterInfo']['character']['faction'] . "',
`factionid` = '" . $character['characterInfo']['character']['factionId'] . "',
`gender` = '" . $character['characterInfo']['character']['gender'] . "',
`genderid` = '" . $character['characterInfo']['character']['genderId'] . "',
`race` = '" . $character['characterInfo']['character']['race'] . "',
`raceid` = '" . $character['characterInfo']['character']['raceId'] . "',
`class` = '" . $character['characterInfo']['character']['class'] . "',
`classid` = '" . $character['characterInfo']['character']['classId'] . "',
`talentspec` = '" . $character['characterInfo']['characterTab']['talentSpec']['treeOne'] . "," . $character['characterInfo']['characterTab']['talentSpec']['treeTwo'] . "," . $character['characterInfo']['characterTab']['talentSpec']['treeThree'] . "',
`talent1` = '" . $character['characterInfo']['characterTab']['talentSpec']['treeOne'] . "',
`talent2` = '" . $character['characterInfo']['characterTab']['talentSpec']['treeTwo'] . "',
`talent3` = '" . $character['characterInfo']['characterTab']['talentSpec']['treeThree'] . "',
`guild` = '" . $character['characterInfo']['character']['guildName'] . "',
`guildurl` = '" . $character['characterInfo']['character']['guildUrl'] . "',
`hp` = '" . $character['characterInfo']['characterTab']['characterBars']['health']['effective'] . "',
`mp` = '" . $character['characterInfo']['characterTab']['characterBars']['secondBar']['effective'] . "',
`str` = '" . $character['characterInfo']['characterTab']['baseStats']['strength']['effective'] . "',
`agi` = '" . $character['characterInfo']['characterTab']['baseStats']['agility']['effective'] . "',
`sta` = '" . $character['characterInfo']['characterTab']['baseStats']['stamina']['effective'] . "',
`int` = '" . $character['characterInfo']['characterTab']['baseStats']['intellect']['effective'] . "',
`spi` = '" . $character['characterInfo']['characterTab']['baseStats']['spirit']['effective'] . "',
`arm` = '" . $character['characterInfo']['characterTab']['baseStats']['armor']['effective'] . "',
`strbase` = '" . $character['characterInfo']['characterTab']['baseStats']['strength']['base'] . "',
`agibase` = '" . $character['characterInfo']['characterTab']['baseStats']['agility']['base'] . "',
`stabase` = '" . $character['characterInfo']['characterTab']['baseStats']['stamina']['base'] . "',
`intbase` = '" . $character['characterInfo']['characterTab']['baseStats']['intellect']['base'] . "',
`spibase` = '" . $character['characterInfo']['characterTab']['baseStats']['spirit']['base'] . "',
`armbase` = '" . $character['characterInfo']['characterTab']['baseStats']['armor']['base'] . "',
`prof1` = '" . $character['prof1'] . "',
`skill1` = '" . $character['skill1'] . "',
"
/* There seems to be something wrong with the $character structure that is supposed to
* fill in all of this info */
. "`prof2` = '" . $character['prof2']. "',"
. "`skill2` = '" . $character['skill2']. "',"
/*
. "`prof2` = '" . $character['characterInfo']['characterTab']['professions']['skill']['1']['name'] . "',"
. "`skill2` = '" . $character['characterInfo']['characterTab']['professions']['skill']['1']['value']['0'] . "',"
*/

."
`cooking` = '" . $secondaryskill['cooking'] . "',
`firstaid` = '" . $secondaryskill['firstaid'] . "',
`fishing` = '" . $secondaryskill['fishing'] . "',
`riding` = '" .$secondaryskill['riding'] . "',
";

$char['realmchar'] = addslashes($char['realm'] . "." . $char['character']);

if ($character['characterInfo'] && $character['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}
else
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}
}

if (VB_AREA == 'AdminCP')
{
echo $char['character'] . '<pre>';
print_r($character);
print_r($character_skills);
echo '<pre><hr />';
}

$char_updated .= $char['character'] . ", ";

}

echo $char_updated;
?>

[LostPhoenix]

Yes, these characters is still an issue. There is no fix currently I am sorry to say.

Gryphon have you tired rawurlencode instead of urlencode to fix the problem with accented characters?

[KURTZ]

ok now i understand how it works ... :D

however, gryphon, i use EU|Crushridge but after 10 mins i haven't imported the char data into my event ... it's normal?

[Sanctorum]

lately since the recent updates, the character data is not being imported into the events.

I did upgrade to php-5.2.6, I'm wondering if it's the same issue as stated above.

*Edit*

Found the problem, it was cURL, it wasn't compiled in when I upgraded PHP.

[Renny]

The icons you get with it. What are they for and how do i use them? like how do i make the icon the url on the calender page Like how this website has:

Furthermore, do you know how you can make a module in vbadvanced like the 2nd image? to show upcoming events like it has done?

[Sedition-Guild]

I uploaded this for our guild website, followed all the instructions, when I went to add a test event to our calender I got the following error:

Warning: require_once(./includes/functions_gwowevents.php) [function.require-once]: failed to open stream: No such file or directory in [path]/calendar.php(1218) : eval()'d code on line 1

Fatal error: require_once() [function.require]: Failed opening required './includes/functions_gwowevents.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /usr/home/wrecl/public_html/forums/calendar.php(1218) : eval()'d code on line 1

Help?
Thanks!

[Kinneas]

I uploaded this for our guild website, followed all the instructions, when I went to add a test event to our calender I got the following error:

Warning: require_once(./includes/functions_gwowevents.php) [function.require-once]: failed to open stream: No such file or directory in [path]/calendar.php(1218) : eval()'d code on line 1

Fatal error: require_once() [function.require]: Failed opening required './includes/functions_gwowevents.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /usr/home/wrecl/public_html/forums/calendar.php(1218) : eval()'d code on line 1

Help?
Thanks!
Did you upload all the files to the correct place? That error indicates it can't find /includes/functions_gwowevents.php

[Gryphon]

@Renny, that is not included in this mod. You can edit the calender event templates and include the following rough example:
<if condition="$eventinfo['calendarid'] == 'CALENDAR_ID'"> IMAGE_CODE </if>

It is tough to know exactly how the user in your screenshots created theirs, maybe a different event manager or a calendar per instance. On my site, I have a WoW calendar and it shows a WoW icon next to events scheduled for it. The CALENDER_ID is the number for the calender, in my case "3" and the IMAGE_CODE is the WoW icon.

This is something you will have to work out on your own however, you will need to be comfortable with customizing various templates.

@Sedition-Guild, Kinneas is correct, thank you.

[Kinneas]

Thanks for the updates Gryph :)

[Kinneas]

Nice update again Gryph. One thing I noticed after upgrading is that the new(?) template, gwe_visitorbit is uncached. I've added it to the cache_templates plugin on my installation.

[Gryphon]

Ok, I'll fix that.

[DWard]

I've installed the addon, and it's working fine apart from the scheduled task. It doesn't seem to run by itself, and there are no sheduled task logs for it. If I run it manually, no problem at all, but takes a little while to load.

[DWard]

any update on the

gWoWEvents Armory Import

Fatal error: Cannot use string offset as an array in /public_html/xxx/forums/includes/cron/cron.gwowevents.charinfo.php on line 64

issue?
I have the same issue, any updates? It worked fine until today, I've changed nothing my end.

[Gryphon]

I've installed the addon, and it's working fine apart from the scheduled task. It doesn't seem to run by itself, and there are no sheduled task logs for it. If I run it manually, no problem at all, but takes a little while to load.

A friend has this problem as well. I think that the vBulletin cron system is just not powerful enough to handle the lengthy process. Personally, I schedule vBulletin's cron.php to run via real cron to ensure it runs completely.

I have the same issue, any updates? It worked fine until today, I've changed nothing my end.

I can not reproduce this. I thought maybe it was php5 so I upgraded from php4 and still had no trouble with receiving updates.

Please try this attachment and let me know if it solves the problem.

[Azel]

Yes, these characters is still an issue. There is no fix currently I am sorry to say.
Any news about this issue? workaround or similar won't work...

[hunteds911]

Ok got it working but now I find that I have double showing of events on the same date.

[hunteds911]

Ok got it working but now I find that I have double showing of events on the same date.

Ok Figured out that issue.. Now does the updating from armory always take so long?

[Killian]

Heya Gryphon,

I'm currently having a problem where if a character does not have a secondary skill trained, the cron job is crapping out on line 68. Any help would be greatly appreciated!

Thanks!!!

[apokphp]

I have same issue as many others about armory not updated (just the spinning circle).

I did get the data once I ran a manual cron...but I made a change in my status on attendance, and all the data that showed, disappeared...I got the infamous spinning circle again.

As a result, it renders the hack unusable IMO.

[Insanity.TM]

Parse error: syntax error, unexpected T_STRING in /homepages/5/d24191187/htdocs/fallenangels/admincp/plugin.php(1985) : eval()'d code on line 2

wtf,....alls addons from gryphon make errors in my board!!! this error comes by installing

[Gryphon]

Parse error: syntax error, unexpected T_STRING in /homepages/5/d24191187/htdocs/fallenangels/admincp/plugin.php(1985) : eval()'d code on line 2

wtf,....alls addons from gryphon make errors in my board!!! this error comes by installing

I can not reproduce this error. It seems to be installing ok for everyone else.

[The DaveyG]

I left this message in the other WoW calendar thread, but now I realize this might be the newer, most robust version...

I run a board for the NHL 09 video game's EASHL mode (basically an MMO for hockey, where a team of up to 50 can get together to play online hockey games). I need something to organize team play times. Would this be possible to easily adapt for this game? Can I have multiple private versions of these calendars that each team can run?

Thanks in advance for anyone's help.

[Gryphon]

I left this message in the other WoW calendar thread, but now I realize this might be the newer, most robust version...

I run a board for the NHL 09 video game's EASHL mode (basically an MMO for hockey, where a team of up to 50 can get together to play online hockey games). I need something to organize team play times. Would this be possible to easily adapt for this game? Can I have multiple private versions of these calendars that each team can run?

Thanks in advance for anyone's help.

This event calendar is pretty much tied into World of Warcraft and the character profiles the developers have available online which get imported into the events.

[The DaveyG]

This event calendar is pretty much tied into World of Warcraft and the character profiles the developers have available online which get imported into the events.

Yeah, I took a look and it is tied in a ton to the game itself. I'll take a look at the code and see if I can modify it to work with the teams I have set up on my site instead of external roster stuff.

[richardrhal]

Parse error: syntax error, unexpected T_STRING in /homepages/5/d24191187/htdocs/fallenangels/admincp/plugin.php(1985) : eval()'d code on line 2

wtf,....alls addons from gryphon make errors in my board!!! this error comes by installing

I have the same error on install the product
Vb 3.6.10 pl3
Product
vBadvanced CMPS
gWoWChar OK
gWoWEvents OK
gWoWRoster OK
WoW Head ItemStats OK

[hunteds911]

I am guessing the long retreive times for Awaiting Armory data import... is still an issue?

[Gryphon]

I am not sure what you mean by long retrieval times? Imports are done every 10 minutes (05, 15, 25, 35, 45, 55). If they take longer than that, the Armory may unreachable.

[hunteds911]

I am not sure what you mean by long retrieval times? Imports are done every 10 minutes (05, 15, 25, 35, 45, 55). If they take longer than that, the Armory may unreachable.

When a person signs up on the calendar for an event it sits there on the sign up list with next to their names with Awaiting Armory data import... . Eventually they show up, but it seems to be a long wait process. I figured if it is automatically going out and acessing the armory ever 10, 15 min and so on then it should cahce it so it doesn't take so long to grab data for on the calendar events. Does the Gwowevent and the Gwowroster character info share the same data that gets pulled/polled every 10, 15, etc. min.?

Just curious if there is a way around the long "Awaiting Armory data import..." on the event calendar really or is it working as intended?

Not complaining just trying to get an idea on how it works and if there is a way to get it to pull data faster if not by caching locally to a data base, maybe bypass the armory for the calendar events or something?

I love the hacks/mods they are awesome. Just curious.

[Gryphon]

It takes a snapshot for a character per event, it does not user prior cache for new events. The reason for a snapshot per event is for historical data not yet implemented, it is working as intended.

[hunteds911]

It takes a snapshot for a character per event, it does not user prior cache for new events. The reason for a snapshot per event is for historical data not yet implemented, it is working as intended.

Ah ok just figured I would ask seeing I don't know alot about this. :) It has been educational. :) BTW again nice addons and thank you for going through and making the time to help me understand how this works. :)

[Mithan]

Will this work with vB Advanced?
Does it come with the template or do I need to create my own?

Thanks!

[Kinneas]

Will this work with vB Advanced?
Does it come with the template or do I need to create my own?

Thanks!
I'm not sure what you mean by "works with" it, but I'm guessing you could write/use a module with it. I currently use an "Upcoming Events" module which also displays these events.

[Kinneas]

Found a small issue. If someone signs up who at the time was untalented, then although it shows up correctly there is a missing image where there would normally be a graphic icon representing their spec. The file it is looking for, which isn't present on my site or in the latest zip, is \images\misc\gwowevents\icons\spec\11-None.gif

[JaimeJr]

just downloaded this, one question how do you setup events and what not? cant seem to figure it out

[Mithan]

I tried installing this today and I get an immediate error:

Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE event ADD gwe_signup BOOL NOT NULL DEFAULT '0';

MySQL Error : Duplicate column name 'gwe_signup'
Error Number : 1060
Request Date : Tuesday, October 21st 2008 @ 09:30:50 AM
Error Date : Tuesday, October 21st 2008 @ 09:30:51 AM
Script : http://www.wowhq.com/forum2/admincp/plugin.php?do=productimport
Referrer : http://www.wowhq.com/forum2/admincp/plugin.php?do=productadd
IP Address : 67.225.32.128
Username : Mithan
Classname : vB_Database
MySQL Version : 4.1.21-log


Any idea?

I even wiped the forum and re-installed this and get the same problem.

Thanks.

[Gryphon]

@Mithan not sure how it happened. But use phpMyAdmin to delete the gwe_signup column from the event table then install the mod.

[Mithan]

@Mithan not sure how it happened. But use phpMyAdmin to delete the gwe_signup column from the event table then install the mod.

I've done that and it still wont work :(

It just refuses to install for some reason.


Do you think it could be do to some setting with mysql?

[asder]

How would i set the Allow users to signup option to be checked by default

[Sarvoth]

When the job is ran to get character day from the army, it only gets 1 person at a time. Is this normal? This is what I see when I run it manually.

[Saint Dean]

Hello,

Just wondering if their is a mod Similiar to this but in gaming clan version. Ie for clan match signups. Etc Ive probably posted in the wrong area but if you could answer this it would be great.

[TazzMann]

just downloaded this, one question how do you setup events and what not? cant seem to figure it out

I am having this same issue.

It said that it installed correctly, but for the life of me I cannot find where in the forum I or any other user can set up an event for signing up.

I am wondering if by chance it did not install correctly.

Thanks,
TazzMann

[Gryphon]

You create new calendar event and check the box to allow signups.

[j?rgk]

hello,

we have one problem.if user have a ^ or ´ in the charaktername (shâdowmoon or rabît ) then we become an error. what can we do, that it work with the ^and ´ in the charakternames?

without the ^´all will work fine, but if someone with the ^´in the names sign nothing work.....

please help!

thank you

[j?rgk]

hello,

nobody an idea,what we can do?

[slick368]

I got this installed without incident, but when I add an event and check to allow for sign-ups, I get a message that sign-up is not available for this event.

I had this installed before and it worked perfect. I don't know of anything that I have done differently, except installed a template mod for the calendar. I reverted those templates back and re-installed the mod with the same result. I have also checked permissions and set them appropriately.

Anybody have an idea what might be wrong. This is an awesome mod and I want to continue using it. I would appreciate any help I can get!

[Gryphon]

I added a feature that prevents people from signing up more than a week in advance to prevent people from just registering for every event on the calendar and then never visit the forum again.

There is no option to configure it...that I can remember, I will see about making it configurable in a future version.

[slick368]

I have set up multiple events to make sure I was not running into the built in limitation for event signup. When I set it up for 5 days from today, I get a message that the signup for the event is no longer available. When I exceed the 7 day window, then I get dual messages... the event is no longer available for signup AND the event is not yet available for signup due to the 7 day limitation.

I have checked and re-checked everything, but nothing seems to give me a different result. And... yes, with each test, I checked the box to allow event signup.

[slick368]

This looks to be a problem in the new version. I reverted everything back to the previous version and it worked without a problem, so I guess until the problems is resolved, I'll just use the pre-WoTLK version. This is too cool a mod not to have even if it's a bit out of date.

[smokejax]

When I attempt to add this I get the following error
90356

Has anyone encountered this?
If I continue, configure all the settings, then create an event. I get a VBDatabase error.

[Sarvoth]

I love this mod, but ended up not using it. If you added a way to draft people on the sign up, then I would use it. As it stands, I use phpraider to do my current sign ups because I can easily draft and people can check it to see if they are going to a raid or not. I would much rather use your mod, so if you ever feel like expanding the functionality of this, that is where I would go next.

[Mithan]

Can anybody who has this successfully working please link to your Forum Hosting Privder?

I want to switch hosts since mine has some stupid blocks in preventing this from working.

Thanks.

[Mithan]

I think I got this thing installed, but when I go post an Event on the Calendar, it doesn't ask me for a gWOWEvent, thus it isn't being used...

Any ideas?

[Mithan]

Also, I can not find a Calander Select option... where is that supposed to be because I do not have it in the gWoWRoster settings area...

Thanks.

[slick368]

Still having problems with ver 1.07 of this mod. Can sign up for events if they are either ranged or recurring, but not single. Could part of the problem be the apparent 4 or 5 typos in the code, as they read singup instead of signup.

I'd like to see this problem worked out. I love this mod and went back to the 1.05 version for a bit because it worked, but it is out of date and my users know it. At this point, I'm ready to uninstall it and go with something else since the author's only responses to several of us (if we were lucky enough to receive one) seem to insist that we are either installing or using the mod incorrectly and that is the cause of the problem when this thing obviously has problems.

Please take a look into this and see if you can get it resolved. I really enjoy this mod and want to keep using it. I have other options here, but none of them are as nice as this one when it works! :confused:

[Gryphon]

I will look into this, just been stretched thin lately on several projects and holidays.

[Bukusami]

slick368

What part of the code / file are those typos as i wish to manually correct them to fix the issue my end, i would really like single events to be working.

[Bukusami]

I just looked and changed the xml file find & replace all singup / signup and single event still says i cannot sign up, only the other events allow signup.

Also Armoury update does not work, it just goes straight to done on a manual update, while i was testing a ranged event and it was fetching armoury info i ran a update task and it imported events, well it said it did but they do not show up on the calender.

[slick368]

Yeah... I was kind of excited when I found the typos because I thought that would fix the problem, but there is something else wrong besides. I hope this gets resolved soon... if you've ever seen this mod in action, you know why I'm holding out as long as I can before moving to something else. If you haven't... it's VERY nice!

If you get the problem figured out, lemme know 'cause I'm anxious to get this thing re-installed and put into use!

[yamahammer]

Thanks for this mod(and the other gWOW mods!).
ive had this mod working in the past, but recently updated to 1.0.7.

After the update, the calendar had the link "Add characters to your profile to singup for this event." and no place to sign up. Im sure the Profile Field ID is correct... have i missed something?

update- got it. had to type in the server name. now have the same failing cron jobs people have already posted. im trying to get it set up in my server cron now.

[Zhin Jio]

phrase gwe_add_characters:
"Add characters to your profile to singup for this event."

typo : signup

[Zhin Jio]

Request:

Configurable fields to query and/or put into the skills listed on the events.

If I had to pick a couple right this second, I'd add spell damage bonus/healing bonus and attack power/ranged attack power. But fully configurable would be nice.

Hmm. Restrict levels for an event?

Require approvals? Sort of a queue for Signed up, which is then either Approved/Standby/Denied. The event creator (or better yet, a particular usergroup) can do the queue moderation.

Finally: require a particular usergroup to create an event? I suppose I can do that with the calendar permissions though.

Just thinking out loud here, I guess. None of this is terribly easy, I suspect.

Thanks for great mod. *checks Installed*

[slick368]

I think I figured out what was going on. In addition to the typos on the signup variables, there were two items that were flip-flopped. Once I traded places with these two buggers... everything seemed to work.

You are looking for DATELINE_TO_USER and DATELINE_FROM_USER... they only appear once in the XML... just flip-flop them and you should be good. At least everything started working for me. Once the change was made, single-event signup started working and I was unable to sign up for events that had already passed.

If you already have 1.07 installed, but not working correctly, simply make the changes to the XML and re-import it (I did it with overwrite enabled). If you're not comfortable with editing the XML file... I've attached mine. Just be aware that this may not have solved ALL problems, but it did resolve mine as far as I can tell thus far.

I'm just stoked 'cause I get to start using this mod again! :D

[Gryphon]

Thank you slick368, an update has been made.

[Jrain157]

Can I make a feature request to add moderation for raids? IE

Mage1 signs up and is placed into the queue with a comment of Yes On Time

Officer1 then has to go into the event and moderate Mage1 as an Active member of the raid.

[Gryphon]

Thanks for the feature suggestion. It certainly is possible, I just don't see myself having time to develop that relatively soon.

[Hawnted]

Request:

Configurable fields to query and/or put into the skills listed on the events.

If I had to pick a couple right this second, I'd add spell damage bonus/healing bonus and attack power/ranged attack power. But fully configurable would be nice.

Hmm. Restrict levels for an event?

Require approvals? Sort of a queue for Signed up, which is then either Approved/Standby/Denied. The event creator (or better yet, a particular usergroup) can do the queue moderation.

Finally: require a particular usergroup to create an event? I suppose I can do that with the calendar permissions though.

Just thinking out loud here, I guess. None of this is terribly easy, I suspect.

Thanks for great mod. *checks Installed*

I would love to see these above, if I had to pick any of them it would be configurable stats shown from armory and Approved/Standby/Denied option.

[ColossusCH]

Hi to all, i really like this mod, but i have a small problem.
i use vbulletin 3.8 and gwowevents 1.0.8.
even when i use in options "Choose when signups should be disabled for an event." "Never". it is not possible to signup on any event on the actual date.
example: Event is on 26. January, signup is only possible till 25. January. on 26 January i get the message: Signup for this event is no longer available.

for me this function is very important for maby-people, to change the status.

further one more question:
somebody know a way to use "Forum Events" or is there any other mod to start a forum thread for each "Raid"

Thank you very much for your Help.

PS, next problem, sorry.
not possible to ad a member with the function "yes, Late"

[Kaelon]

Hey there,

When creating an event (using the latest version, 1.0.8), I get a "Signup for this event is no longer available." if the event lands on the same day that a user tries to sign up. This seems to be regardless of when the signup allowance has been set in the gWoWEvents Configuration. Any thoughts?

[Tolas]

Hey there,

When creating an event (using the latest version, 1.0.8), I get a "Signup for this event is no longer available." if the event lands on the same day that a user tries to sign up. This seems to be regardless of when the signup allowance has been set in the gWoWEvents Configuration. Any thoughts?

Discovered the same problem today.

Event is scheduled for tomorrow night, it disabled signups for the event, even though I have the options set to never disabled signups.

**Edit**

Seems to only affect one event now, the rest appear fine thus far. I will look into how my user created the event and see if maybe something was done differently. I'll post again if I continue to see this happen on more events.

[Tolas]

Seems the problem came back. I removed and re-installed again and same problem. All of our events are locking down signups about a day and a half before the event starts, regardless of any settings.

[Gryphon]

Currently our guild hasn't been utilizing the signup so I have not been able to tweak that feature correctly. I have also been busy with work and other projects.

I will look into this when I have available time.

[y2krazy]

The icons you get with it. What are they for and how do i use them? like how do i make the icon the url on the calender page Like how this website has:

Furthermore, do you know how you can make a module in vbadvanced like the 2nd image? to show upcoming events like it has done?
Anyone come to any solutions for implementing this? Thanks in advance!

Also, after an Armory update on an event in my Calendar, why are my First Aid, Cooking, Fishing and Riding skills all set to 0? :(

~ Sean

[Dragonsys]

Anyone come to any solutions for implementing this? Thanks in advance!

Also, after an Armory update on an event in my Calendar, why are my First Aid, Cooking, Fishing and Riding skills all set to 0? :(

~ Sean

The Armory does not have the secondary Skills info anymore.

[y2krazy]

The Armory does not have the secondary Skills info anymore.
It's not possible to retrieve them from the Skills page? I assume they were being pulled from the Character Sheet if that's the case. Ionno, just a thought? :)

~ Sean

[Dragonsys]

It's not possible to retrieve them from the Skills page? I assume they were being pulled from the Character Sheet if that's the case. Ionno, just a thought? :)

~ Sean

What skills page? the US Armory does not have a skills page anymore, at least not that I can find... I wish it owuld. I would love to add those skills into my Roster.


EDIT: I found them. They are in the Stats. For example - http://www.wowarmory.com/character-statistics.xml?r=Vek%27nilash&n=Dragonsys (under Skills -> Secondary Skills)
Just need to get the data pulled and added my DB...

[SlompOchomp]

I have resized the Death Knight Spec Icons.
Place these .PNGs in your DIR

images\misc\gwowevents\icons\spec

[SlompOchomp]

just started getting this error
gWoWEvents Armory Import


Fatal error: Cannot use string offset as an array in D:\Hosting\4072979\html\includes\cron\cron.gwoweve nts.charinfo.php on line 53
Any resolve to this issue ?

Update: I ended up doing this to resolve my issue and all seems to work.
Here is my hack for those of us who have hosts that don't like the cron. It's not perfect but it does work.

Find the following code in cron.gwowevents.charinfo.php

if ($character['characterInfo'] && $character['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}
else
{
$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'");
}


and change it to:

$dbhost = '';
$dbname = '';
$dbuser = '';
$dbpasswd = '';

if ($character['characterInfo'] && $character['characterInfo']['characterTab']['characterBars']['health']['effective'])
{
//$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'");
@ $db2 = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
mysql_select_db("$dbname",$db2);
mysql_query("UPDATE " . TABLE_PREFIX . "gwowevents SET " . $charinfo_query . " `armorydata` = '1' WHERE `realmchar` = '" . $char['realmchar'] . "'", $db2);
mysql_close($db2);
} else {
//$vbulletin->db->query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'");
@ $db2 = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
mysql_select_db("$dbname",$db2);
mysql_query("UPDATE " . TABLE_PREFIX . "gwowevents SET `armorydata` = '2' WHERE `realmchar` = '" . $char['realmchar'] . "'", $db2);
mysql_close($db2);
}


Obviously you have to add your database info. Until I take the time to learn vbulletin and fix it properly lol.

This will put more stress on your SQL server as it opens and closes a connection each time it updates the user.

[RustyDogma]

When I try to edit the setting for this mod, it won't accept the custom profile field I have set-up from gWowChar. I hit save and it resets the field I enter to 0.

[Gryphon]

Just enter the field number, enter "12" not "field12".

[RustyDogma]

Aye, was just coming back to say I figured it out =P Thanks!

Great add on... the only change I'd love to see is when signing-up a character, have 3 checkboxes of tank, heal, dps (kinda like the new LFG does it in game) so people could check off which role(s) they would be willing to perform for different events.

[Gryphon]

Sounds like a nice idea. I am not sure when I would be able to do such a thing. Sadly, we are using the in-game guild calendar more and this mod isn't getting much use anymore by my guild so less motivation for me to work on it.

[CFodder]

Nice mod, have it installed as will be doing with your other 2 as well :).

Coupla small problems with it, firstly all secondary skills (cooking, first aid, fishing and riding) are showing as zero even though I've been assured by a coupla members they have those skills (I dunno I don't play the game) all the other stats have updated fine from the armoury.

Secondly, and this 'aint a biggy, layout is slight borked for the classes and the warrior at the end is 'scrunched' up with the icon above the name. Am using fluid width boards so it should all set automatically as far as I'm aware??.

[billy126]

Seems the problem came back. I removed and re-installed again and same problem. All of our events are locking down signups about a day and a half before the event starts, regardless of any settings.

in the gWE: Add signups to Event Description plugin, change:

// Allow Post signup
if(TIMENOW <= $eventinfo['dateline_from_user'])
{
$eventinfo['gwe_post_signup'] = true;
}
else
{
$eventinfo['gwe_post_signup'] = false;
}

to:

// Allow Post signup
if(TIMENOW <= $eventinfo['dateline_from_user'])
{
$eventinfo['gwe_post_signup'] = true;
}
else
{
$eventinfo['gwe_post_signup'] = true;
}

That seemed to sort it for me.

[Replicators]

Wish there was something like this for age of conan

EDIT: Could this mod be easily changed to suit other mmo's?

[Pen411]

I'm confused on how to access this calendar, events posted to the calendar do not show up as a wow event.

[Pen411]

Seems to be working (the profile field cannot be private).
However, I do get this error when installed:

Parse error: syntax error, unexpected T_STRING in /public_html/forum/admincp/plugin.php(1995) : eval()'d code on line 2

[we_are_borg]

Gryphon the addon is working but its verry slow when loading it, can this be speeded up sum how.

[RG_LunAnder]

Seems to be working (the profile field cannot be private).
However, I do get this error when installed:

Parse error: syntax error, unexpected T_STRING in /public_html/forum/admincp/plugin.php(1995) : eval()'d code on line 2

there are two missing " in the XML:

@line 100:

<code version="1.0.4">
<installcode>
<![CDATA[
$db->query_write("UPDATE ".TABLE_PREFIX."gwowevents SET `response` = '4' WHERE `response` = '3');
$db->query_write("UPDATE ".TABLE_PREFIX."gwowevents SET `response` = '3' WHERE `response` = '2');
]]>
</installcode>
<uninstallcode />
</code>

should be:

<code version="1.0.4">
<installcode>
<![CDATA[
$db->query_write("UPDATE ".TABLE_PREFIX."gwowevents SET `response` = '4' WHERE `response` = '3' ");
$db->query_write("UPDATE ".TABLE_PREFIX."gwowevents SET `response` = '3' WHERE `response` = '2' ");
]]>
</installcode>
<uninstallcode />
</code>


/lun

[paulomt1]

Ty for the fix

[Aerith_Freak]

I seem to be having an issue where some of my members have character names with special characters such as áéíóú (amongst many others in their names) which causes the script not to be able to pull data from the EU armory.

I've checked what they entered in the profile boxes and the formating is correct.

[lwalsh]

I also am having the issue with special ascii characters. The info will not update on an event for them. So we can not see there stats and etc.

[we_are_borg]

Will there be an update for vb4.0

[legacythe2nd]

Will there be an update for vb4.0I really hope so, i'm using eqdkp at this moment but i'm looking to get more stuff centralized.

[3clipse]

It looks like the latest armory update has broken the character information pull on this mod and gwowroster as well. Is there going to be an update for this and/or the rest of the 3.* vb mods you have published that draw information from the WoW armory, support for 4.* vb or is this an abandoned project as far as the author is concerned, any response would be appreciated.

[Anseur]

Aye, 3.3 armory update seems to of broken it's ability to get data from the armory.

[Gryphon]

Aye, 3.3 armory update seems to of broken it's ability to get data from the armory.

I have a fix for this, I should have it up in the next day.

[we_are_borg]

I have a fix for this, I should have it up in the next day.

Thanks Gryphon.

Are you planning to port the gwow to vb4 lots of people are hoping that you will.

[Anseur]

I have a fix for this, I should have it up in the next day.

Thanks for the hard work!

[Gryphon]

At the moment the cost of upgrading is not worth it to me, I would need a lot of donations to upgrade one of my boards. I have had some offers to use other peoples vB4 install for development, I may take them up on the offer, however that will be when I can dedicate some time for certain on the project.

I have to extend the fix release, the fix may be up tomorrow if not later today, my home server system drive failed.

[we_are_borg]

At the moment the cost of upgrading is not worth it to me, I would need a lot of donations to upgrade one of my boards. I have had some offers to use other peoples vB4 install for development, I may take them up on the offer, however that will be when I can dedicate some time for certain on the project.

I have to extend the fix release, the fix may be up tomorrow if not later today, my home server system drive failed.

Well i have upgraded one board myself but indeed the cost are high atm for upgrading. Well like i said if you need a clean vb4 to make the addons just shout at me. People love your addons and many are depended on it.

[we_are_borg]

Gryphon the addon is giving me an error Internal server error 500, the other addon roster is working fine for me.

[bc641990]

At the moment the cost of upgrading is not worth it to me, I would need a lot of donations to upgrade one of my boards. I have had some offers to use other peoples vB4 install for development, I may take them up on the offer, however that will be when I can dedicate some time for certain on the project.

I have to extend the fix release, the fix may be up tomorrow if not later today, my home server system drive failed.


Maybe you could just help me with this then. I installed the mod with vb4. I got this error when going to the calender.

Warning: fetch_template() calls should be replaced by the vB_Template class in [path]/includes/functions.php on line 3895
Database error
"My Site" database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the "My Site".com home page, then try to open another page.
Click the Back button to try another link.
The "My Site".com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 4.0.0:

Invalid SQL:

SELECT gwe.*,
user.username,
userfield.field0
FROM
gwowevents gwe
LEFT JOIN
userfield AS userfield ON userfield.userid = gwe.userid
LEFT JOIN
user AS user ON user.userid = gwe.userid
WHERE
eventid = 01
ORDER BY
gwe.response ASC, gwe.date;

MySQL Error : Unknown column 'userfield.field0' in 'field list'
Error Number : 1054
Request Date : Saturday, March 6th 2010 @ 12:23:53 PM
Error Date : Saturday, March 6th 2010 @ 12:23:53 PM
Script : http://mysite.com/forums/calendar.php?do=getinfo&e=1&day=2010-3-6&c=1
Referrer : http://mysite.com/forums/calendar.php
IP Address : 11.111.11.111
Username : Me
Classname : vB_Database
MySQL Version : 5.0.89-community

[bc641990]

For the past 10 hours it has just been Awaiting Armory data import... This is for a good 10 people on 3 events. Whats the wait time on this or is there a problem?

Vbulletin 3.8

Edit: Just tried to run the task manager manually and got this error:

Fatal error: Cannot use string offset as an array in /home/xxx/public_html/xxx/forums/includes/cron/cron.gwowevents.charinfo.php on line 54

Edit: Seems there was an improper character and I had to manully go into phpmyadmin and delete the bad tables and fix the usernames. The problem now is the whole special character code. I have a member by the name of:

Os?rus

Is there a way you can get the script to ignore members like this? If not ignore all of them maybe have it so I can just insort their name and tell it to be ignored in the cron script?

I've tried the fixes around here and non seem to work. Getting same error as previously said.

[bc641990]

Discovered the same problem today.

Event is scheduled for tomorrow night, it disabled signups for the event, even though I have the options set to never disabled signups.

**Edit**

Seems to only affect one event now, the rest appear fine thus far. I will look into how my user created the event and see if maybe something was done differently. I'll post again if I continue to see this happen on more events.

We still need a fix on this :|

Bump for help this time?

EDIT: I went though the script and managed to get it so the calendar will never close. If your fine with that, here is the fix:


Go to admincp > Plugin Manager > gWE: Add signups to Event Description
Find:

// Allow Post signup
if(TIMENOW <= $eventinfo['dateline_from_user'])
{
$eventinfo['gwe_post_signup'] = true;
}
else
{
$eventinfo['gwe_post_signup'] = false;
}

Replace:
$eventinfo['gwe_post_signup'] = false;

With:
$eventinfo['gwe_post_signup'] = true;


-------------------


Hope that helps

[medusa1]

Hi , i installed this mod on 3.8.4 but i dont see him showing up in my forum , i dont know what the straight url is.

is it compatible with 3.8.4?

cheers

[medusa1]

found ...

[gimlot79]

nice hack..works :-)

[Dragonsys]

This is great, but would it be possible to merge the Events and Roster tables, and only have 1 armory scheduled task? Running this and your Roster makes for multiple armory requests...

Merging the tables is easy enough. i have not looked at your code much yet, but i think it would be awesome if this could just read the data form the roster char table instead of needing to get the info form the armory.

[Griphus]

I am getting this error when I try to access events I've placed on my calendar:

I've tried both our custom style and our default style... not sure what the problem is.


Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: gwe_visitorbit in [path]/includes/functions.php on line 4055

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: gwe_signup in [path]/includes/functions.php on line 4055

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: gwe_signup_form in [path]/includes/functions.php on line 4055

[Keith.Almli]

At the moment the cost of upgrading is not worth it to me, I would need a lot of donations to upgrade one of my boards. I have had some offers to use other peoples vB4 install for development, I may take them up on the offer, however that will be when I can dedicate some time for certain on the project.

I have to extend the fix release, the fix may be up tomorrow if not later today, my home server system drive failed.

If you end up getting around to this please let us know :) I would be willing to pay anything for this mod :)

[bailradio]

Would also like this to work properly with new armoury :)

[Dragonsys]

I am getting this error when I try to access events I've placed on my calendar:

I've tried both our custom style and our default style... not sure what the problem is.


Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: gwe_visitorbit in [path]/includes/functions.php on line 4055

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: gwe_signup in [path]/includes/functions.php on line 4055

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: gwe_signup_form in [path]/includes/functions.php on line 4055



This does not work with vb4

[bailradio]

any update on this working with new armoury, as you said you had it before? :(