vb.org Archive - Add-On Releases - gWoWEvents - World of Warcraft Event Signup

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Add-On Releases - gWoWEvents - World of Warcraft Event Signup (https://vborg.vbsupport.ru/showthread.php?t=170592)

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

Code:

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.

Quote:

Originally Posted by Kinneas (Post 1501421)

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

To fix it, edit the template "gwe_signup_form"

Find:

Code:

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

Below Add:

Code:

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

Should work again :)

works well.
vB 3.7
vBadvanced 3.01
thank you.

Bingo - that did it - thank you very much!

Quote:

Originally Posted by LostPhoenix (Post 1449011)

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

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)

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.

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!

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?

i get the following error when doing manual armory import

Code:

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

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.

Quote:

Originally Posted by JoeGoff (Post 1517607)

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.

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

[s]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?[/s]

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

Quote:

Originally Posted by Gryphon (Post 1517632)

Thanks, it is working now.

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

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

Code:

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

Quote:

Originally Posted by Kinneas (Post 1518207)

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

Quote:

Originally Posted by christofer (Post 1525968)

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

After updating to the latest version I just reverted the gwe_signup_form template.

Quote:

Originally Posted by christofer (Post 1509376)

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

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.

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?...y=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

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

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.

Quote:

Originally Posted by ColossusCH (Post 1542733)

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.

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/bogfor...8-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

Quote:

Originally Posted by Sanctorum (Post 1546966)

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

You need to change your field id from 0.

Quote:

Originally Posted by Gryphon (Post 1546975)

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.

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.

Quote:

Originally Posted by ColossusCH (Post 1542733)

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.

Hi Gryphon, hi Tazz 1962

Thank you for your reply.
i will try your solution

Quote:

Originally Posted by Mother_Dee (Post 1531430)

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.

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?

Code:

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

?>

Quote:

Originally Posted by Gryphon (Post 1545416)

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?

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?

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.

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?

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!

Quote:

Originally Posted by Sedition-Guild (Post 1584395)

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

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01509 seconds Memory Usage 1,911KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_code_printable (14)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: