Miscellaneous Hacks - CES Lv vB Event Forums Addon - Query Blaster

CES Lv vB Event Forums - Query Blaster
Version: 1.1.3

Requires:

• CES Pre-Process Hooks 1.2.0+ (needs showthread_preprocess and forumdisplay_preprocess)
• Lv vB Event Forums 3.3.1+
• Farcaster's Event Attendance & vb Event Forums Integration 1.1.0+

*** NEWS ***
7/28/2007 - v1.1.3 released
7/27/2007 - v1.1.2 released
7/24/2007 - v1.1.0, v1.1.1 released
4/2/2007 - v1.0.0 released

Known Issues:
- none

What It Does:
This modifies the Lv vB Event Forums addon by replacing a number of plugins and effectively removing LOTS of extra queries (you probably noticed). Also adds the ability to add attachments to events.

Products to Install: 1
Plugins Included: 20
Files to Upload: 0
Files to Edit: 1
New Templates: 5
Template Edits: 0

Mod Features:
- adds an option to the Forum Manager
- event attachments
- much fewer queries in forumdisplay and especially showthread

You will need to edit all your Event Forums in the Forum Manager and set "Is this an event forum?" to yes. This just makes some of the plugin code simpler and I think removed 1 query elsewhere. You still need to specify forum-calendar relationships in settings.

*** Changelog ***
As of Version 1.1.3

• fixed upcoming events on forumdisplay
• fixed edit options for first post
• fixed thread titles in forumdisplay
• fixed thread not created on event creation
• removed unused templates

As of Version 1.1.2

• fixed empty first post (event details)

As of Version 1.1.1

• fixed missing plugin since 1.0.0 that fetches event info

As of Version 1.1.0

• event forums use own showthread template
• separate postbit for event details
• map forums to calendars in the forum manager
• fixed redirect bug on attachment edit
• fixed bug where comments bar was disconnected

[thincom2000]

Okay the new version uses separate templates for everything so that template edits for Lv vB Event Forums are unnecessary in SHOWTHREAD. In addition, it fixes a few bugs like a broken Comments table, inability to utilize the attachments feature, etc. I'm also positive that this version works since I'm currently running it.

[TheMilkCarton]

XML Error: mismatched tag at Line 2390

I get that when uploading the new XML file.

Edit: There was a missing </phrasetype> a few lines above it.

Now I get

Warning: Invalid argument supplied for foreach() in /showthread.php(997) : eval()'d code on line 15

when going to an event

Oh geez. So I realized you changed the Yes/No to "Event forum?" question to what ID to map it too, but that didn't solve the problem. The Event info still doesn't show up, and it's now even more screwed up than before.

Not only does the event not show, the comments don't show, and now the event date has changed positions and isn't where I had it before.

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

You know what, it's fine. Don't bother trying to fix this. It's honestly not worth the effort anymore. I've decided that I'm just getting rid of the event forum entirely and keeping the Event Attendance.

It's not worth the amount of frustration I'm going through trying to figure out why on earth your hack permanently damaged my installs of vB Event forums and Event Attendance + the integration.

Just PLEASE tell me what it overwrote in the templates, plugins, or DB that could be hiding the replies to the event.

This update just caused considerably more problems than the previous version, and I'd recommend you take the file down until things can get sorted out.

[thincom2000]

I don't know how to answer your "overwrite" question. This mod doesn't overwrite anything. It disables the existing plugins on install, and re-enables them on uninstall. As for the templates, the mod now uses its own templates (so I apologize that your time changed positions). And the only DB change was adding the calendar map to the forum table.

As for the rest of your issues, I'm at a loss. Except for the missing </phrasetype>, everything in the new product file is exactly as it is on my installation.

EDIT: Fixed the product file. I checked the showthread_preprocess plugin again and it fetches data for the event based on an array containing field names. As far as I can tell, this array has been accidentally left out of the product file since 1.0.0. While I understand you plan to drop Event Forums, I certainly hope this fixes the issue, since surely you are not the only user experiencing empty event stuff. Unfortunately this still doesn't explain why the Comments were missing, so hopefully another able member could help me work that out.

[TheMilkCarton]

Sorry, tried 1.1.1, not any better. Well, I guess it's *somewhat* better, it doesn't give me showthread.php error. Event info and comments still don't show, and I'm still confused as to how your plugin takes the event date say, Fri, 5-4-07, and relocates it to where the body of the event info should be.

Are you doing this testing on the latest versions of Farcaster's mods? He had updated the hacks since you released this plugin, and before the two updates today.

OK, I really give up for real this time. I can't handle the frustration anymore.

[thincom2000]

The plugin uses a template called postbit_event. I will look into Farcaster's update, although at first glance it just looks like he fixed some phrases.

If you can link me to one of your messed up event forums, I would like to at least look at it. For example the actual HTML output is what I'm interested in.

[TheMilkCarton]

Well, I uninstalled everything.

Then I installed vB Event forums > Event Attendance > then the Integration Add-On.

The replies still don't show. Your product had to have done some kind of irreversible damage to the database. Upon uninstalling everything a 2nd time, I went into phpMyAdmin to make CERTAIN that all the RSVP and Event Forums tables were dropped.

As for the HTML, it went something like this

<!--  Post Area -->
<div id="post_2353" ...></div>
<div id="last_shown" ...></div>
<!-- /Post Area -->

I made that up off the top of my head, but it was only showing the bar with the thread controls (View First Unread, Thread Tools, yadda yadda).. Then the rest was just a bunch of blank DIVs, that still had the Post IDs.

Here's the real code:

<div id="posts"><!-- post #4879 -->

	
	<div id="edit4879" style="padding:0px 0px 4px 0px">
	<!-- this is not the last post shown on the page -->	





	</div>
	

<!-- / post #4879 --><!-- post #4880 -->

	
	<div id="edit4880" style="padding:0px 0px 4px 0px">
		





	</div>
	

<!-- / post #4880 --><div id="lastpost"></div></div>

This was after the 3rd CLEAN INSTALL, can you please just tell me what settings your product changed? I looked at the install code in the XML but it didn't give me much to go on.
---------------------------------------------------------------

UGHHHHHHHHHHHHHHHHHHHHHHHHH.. It was your Pre-Processes that was doing it.

Great. Just great. I'm 100% positive I made the file edits correctly, too.

Well good. Pre-Processes is uninstalled, and I'm not going to attempt using this hack again.

[thincom2000]

Okay thanks. It must be a typo or something in the Pre-Processes instructions. Thanks for putting up with this as long as you did.

[thincom2000]

Thanks to vBulletin 3.6.8 being released, I finally ran into the empty postbit problem again when I upgraded. Apparently my fix for this had been a file edit and never made it into the instructions. I have changed this to plugin code and included it in the new product file, so as far as I can tell, there should no longed be the previously reported issue.

[TheMilkCarton]

Originally Posted by thincom2000

Apparently my fix for this had been a file edit and never made it into the instructions. I have changed this to plugin code and included it in the new product file, so as far as I can tell, there should no longed be the previously reported issue.

I'm glad to hear this...

So maybe it was NOT your Pre-processes that was doing it. Hopefully it was just a coincidence.

I'm willing to give this another shot, since you appeared to fix it with the default vB files and had no problem fixing it with a plugin.

Were the only file edits you made the showthread_ and forumdisplay_ preprocesses?

Well, anyway, I'm going to try this again... At least this time going into it, I'll know there's a chance it's going to screw up my Event stuff. The last time when it happened so unexpectedly, I was completely LIVID.

I just realllllyy can't justify using the Event Forums mod when it makes forumdisplay use ****80+ queries****, so lets hope this works this time.

[thincom2000]

Yes the only necessary file edits are the showthread_ and forumdisplay_preprocess instructions.