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)

Gryphon 02-14-2008 10:00 PM

gWoWEvents - World of Warcraft Event Signup
 
1 Attachment(s)
What is it?
[hr]-[/hr]gWoWEvents is a modification for vBulletin which allows you to add World of Warcraft event sign ups to your forum calendar.

If you use this mod, please Mark as Installed, and if you really enjoy this mod, please Nominate for MOTM, and if you really really enjoy this mod, feel free to Support Developer! Thank you!


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

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

Installation
[hr]-[/hr]
  1. Download the latest version and upload all files.
  2. Install the product.
  3. Create a Multiple-Line Text Box User Profile Field.
    • /admincp/?loc=profilefield.php%3Fdo%3Dadd
    • Multiple-Line Text Box
    • Continue
    • Title: World of Warcraft Characters
    • Description:
      Code:

      Enter one character per line.<br /><br />Format: US/EU|Realm|Faction|Name<br /><br />Example: US|Mal'Ganis|Alliance|Gryphen
    • Default Value: Leave Blank
    • Max length of allowed user input: 1000
    • Field Length: 50
    • Text Area Height: 6
    • Field Editable by User: Yes
    • Other options are optional.
    • Save
    • Look and see what the field name is for World of Warcraft Characters, example field25.
  4. Fill in the gWoWEvents configuration options.
  5. That is all, instruct people to fill in their profile.

Changes
[hr]-[/hr]
v1.0.10a - upload class_gwowarmory.php
  • Quick fix for Armory import.

v1.0.10 - upload cron.gwowevents.charinfo.php, class_gwowarmory.php, import product with overwrite
  • Quick fix for 3.1 armory changes.
  • Secondary skills disabled for now.

v1.0.9 - upload cron.gwowevents.charinfo.php, upload images, import product with overwrite
  • Death knight images, thanks SlompOchomp
  • Fix special characters in player names

v1.0.8 - import product with overwrite enabled
  • Fix spelling error
  • Fix for signup allowance periods

v1.0.7 - Upload functions_gwowevents.php, images, import product with overwrite enabled
  • Updated for WotLK

v1.0.5 - Import product with overwrite enabled.
  • Used phrases for more text
  • Added option to show who has viewed the event details.

v1.0.4 - Upload all files import product.
  • Added a 4th, "Yes Late", signup option
  • Comment minimum setting for Late and Maybe options

v1.0.3 - Import product.
  • Update for 3.7.0 Gold, thank you Kinneas

v1.0.2 - Upload all files import product.
  • Initial Release

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

Gryphon 02-15-2008 07:27 PM

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


Options not implemented:
  • Disable Signup Time

MrShides 02-15-2008 07:59 PM

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

Caerydd 02-15-2008 08:20 PM

Two Questions

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

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

Gryphon 02-15-2008 08:22 PM

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

sweede 02-15-2008 08:32 PM

Quote:

Originally Posted by MrShides (Post 1443964)

lol

Zachariah 02-15-2008 09:02 PM

I'll give it a go, I have a bunch of wow players on my site. Right now I just made a bunch of forums for them.
- I never got into the game, but always looking for toys.

Allowed Servers Field: Elune

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

Gryphon 02-16-2008 03:09 AM

Should be good to go :)

BlizzardHQ 02-16-2008 12:47 PM

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

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

Zachariah 02-16-2008 01:56 PM

Quote:

Originally Posted by BlizzardHQ (Post 1444412)
This is great, thank you for finally releasing this as you know I been bugging you for it :D

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

Ideas:

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

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

Caerydd 02-16-2008 02:18 PM

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

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

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

Gryphon 02-16-2008 06:25 PM

This should work fine on 3.6

sweede 02-16-2008 07:40 PM

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

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

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

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

Foghorn Deadhor 02-16-2008 09:02 PM

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

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

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

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

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

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

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

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

Caerydd 02-16-2008 10:08 PM

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


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


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

Wayne Luke 02-17-2008 12:16 AM

If I could make a suggestion...

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

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

Caerydd 02-17-2008 09:05 AM

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

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

BlizzardHQ 02-17-2008 10:22 AM

Quote:

Originally Posted by Caerydd (Post 1445024)


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

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

Dsru123 02-17-2008 04:30 PM

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

www.jettcommunity.com

Wayne Luke 02-17-2008 05:30 PM

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

Dsru123 02-17-2008 05:47 PM

Quote:

Originally Posted by Wayne Luke (Post 1445340)
When creating the event, make sure to check "Allow Users to Signup" in the Additional Options field.

DOH!
I feel so cheap and used!

Thank you, works great.

Dsru123 02-17-2008 06:01 PM

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

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

Foghorn Deadhor 02-17-2008 09:03 PM

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

Dsru123 02-17-2008 09:55 PM

Quote:

Originally Posted by Foghorn Deadhor (Post 1445481)
Is the event server and the server your chars are on the same?


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

Gryphon 02-18-2008 04:27 PM

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

Collyn 02-20-2008 06:51 AM

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

Wayne Luke 02-21-2008 12:33 PM

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

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

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

sweede 02-21-2008 12:51 PM

Quote:

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

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

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


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

Gryphon 02-21-2008 01:34 PM

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

Wayne Luke 02-21-2008 02:50 PM

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

LostPhoenix 02-21-2008 10:04 PM

Anyone else having an issue with the cron job failing?

soothius 02-21-2008 10:16 PM

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

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

Gryphon 02-21-2008 10:28 PM

Quote:

Originally Posted by LostPhoenix (Post 1448385)
Anyone else having an issue with the cron job failing?

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


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

LostPhoenix 02-21-2008 11:31 PM

Quote:

Originally Posted by Gryphon (Post 1448397)
Going to need a bit more information to be able to help. Are there errors?

Code:

Database error in vBulletin 3.6.8:

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

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

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

Caerydd 02-22-2008 05:27 AM

wewt, I have a test site now ^^

Will be trying this out on that over the weekend.

jim6763nva 02-22-2008 01:49 PM

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

Jim

LostPhoenix 02-22-2008 10:18 PM

Quote:

Originally Posted by jim6763nva (Post 1448691)
How long should it take to import armory data after submitting an event? I created an event and it's just sitting there saying Awaiting armory data import....

Jim

Jim,

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

Foghorn Deadhor 02-22-2008 10:23 PM

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

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

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

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

Gooner 02-24-2008 11:28 AM

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

Gooner 02-24-2008 11:45 AM

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

Quote:

Database error in vBulletin 3.6.8:

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

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


All times are GMT. The time now is 07:15 AM.

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.02046 seconds
  • Memory Usage 1,869KB
  • 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
  • (2)bbcode_code_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)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