vb.org Archive

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)

Collyn 02-27-2008 10:34 AM

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 02-27-2008 12:47 PM

Quote:

Originally Posted by Gooner (Post 1449850)
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 02-27-2008 08:08 PM

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 02-29-2008 03:25 PM

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 02-29-2008 11:09 PM

Quote:

Originally Posted by Tolas (Post 1452444)
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.

Quote:

Originally Posted by Mother_Dee (Post 1453730)
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 03-01-2008 02:10 AM

Quote:

Originally Posted by Gryphon (Post 1454073)
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 03-01-2008 11:43 AM

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 03-01-2008 09:50 PM

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.

Code:

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 03-03-2008 10:57 AM

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 03-03-2008 02:44 PM

are you going to fix this mod??

Eviserator 03-04-2008 05:25 PM

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

Code:

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 03-05-2008 04:12 PM

Quote:

Originally Posted by Tolas (Post 1454343)
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.

Quote:

Originally Posted by Ninok (Post 1454754)
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.

Quote:

Originally Posted by quedex (Post 1455824)
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.

Quote:

Originally Posted by Gooner (Post 1455973)
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.

Quote:

Originally Posted by Eviserator (Post 1456891)
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 03-06-2008 02:52 AM

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 03-07-2008 01:30 AM

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 03-07-2008 08:36 PM

@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 03-08-2008 02:45 PM

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 03-09-2008 09:42 PM

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 03-10-2008 06:37 AM

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

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

$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 03-10-2008 06:44 PM

Quote:

Originally Posted by LostPhoenix (Post 1461267)
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
Code:

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

$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 03-10-2008 09:44 PM

Quote:

Originally Posted by Ninok (Post 1461687)
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 03-11-2008 05:24 PM

Quote:

Originally Posted by LostPhoenix (Post 1461820)
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 03-12-2008 07:50 PM

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 03-14-2008 06:41 PM

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 03-14-2008 08:39 PM

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 03-16-2008 04:19 PM

I am getting the following error:

Code:

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 03-17-2008 06:12 PM

Quote:

Originally Posted by Gryphon (Post 1457740)
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 03-20-2008 12:12 AM

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:

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');
                // 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 03-20-2008 08:03 PM

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

Code:

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 03-24-2008 05:07 PM

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

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

        $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 03-24-2008 05:50 PM

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

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

Kinneas 04-01-2008 04:26 PM

Quote:

Originally Posted by Eviserator (Post 1469231)
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:

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');
                // 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 04-06-2008 06:41 PM

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

Code:

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 04-07-2008 12:37 PM

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

Quote:

Originally Posted by Eviserator (Post 1469231)
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:

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');
                // 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 04-10-2008 02:39 PM

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

atomhead 04-10-2008 03:27 PM

Quote:

Originally Posted by LostPhoenix (Post 1461267)
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
Code:

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

$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 04-11-2008 04:45 PM

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

Caerydd 04-14-2008 10:54 AM

Quote:

Originally Posted by atomhead (Post 1488387)
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 04-14-2008 04:23 PM

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 04-14-2008 04:24 PM

Quote:

Originally Posted by Caerydd (Post 1490316)
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 04-28-2008 12:21 PM

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


All times are GMT. The time now is 03:23 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03528 seconds
  • Memory Usage 2,071KB
  • 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
  • (18)bbcode_code_printable
  • (18)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete