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

Page 6 of 23

Show 40 post(s) from this thread on one page

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)

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:

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

}

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?

All times are GMT. The time now is 12:30 PM.

Page 6 of 23

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01390 seconds Memory Usage 1,798KB 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 (5)bbcode_code_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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: