v1.0 Add Meeting Place, Time or Game fields to Calendar

[Cyricx]

Okay, I'm fairly new to coding period, never done any before this :)

So the reason I'm putting this in the beta hack is I may have a line or two added in that isn't needed or there just may be a better way to do one of the modifications, as I basically stumbled and bumbled along til I found something that worked ;)

I've wanted to know how to do this for a long time but could never find where anyone had a "how to", so here is my meager attempt at one. :)

What does this hack do? -
This hack allows you to add a field for Meeting Place or Time or your heart's delight (I used Game) to the calendar. The instructions are written in such a way that you can do just one of the three modifications, or you can do all three. I doubted that very many would do all three so I have listed the modifications seperately in the file. If there are a few that want all three, I'll do up some quick instructions on how to do all 3 modifications at once. :)

Here is an exerpt from the install file -

These are the three modifications I will be detailing. The Instructions are
written in such a way that you can install only one of these, or you may
install all 3.

-1- Adding Time, AMPM, and Timezone fields to your calendar. This is an
integer field, and 2 short text entries.
-2- Adding the "Meeting Place" field to your calendar. This is a long text
(up to 254 characters) entry.
-3- Adding the "Game" field to your calendar. This is a short text entry.
You may use the "Find" feature of your favorite text editor and search for
-1- or -2- or -3- to skip directly to the one you wish to install.
Queries to run: 1 per modification (up to three)
Files to Edit: 1 (/forums/calendar.php)
Templates to Edit: 2 (calendar_enterevent, calendar_daybits)

Each modification has 10 steps to do in the calendar.php. The 9th step is ONLY put in if you have Session's Calendar / Thread Integration Hack located here -

https://vborg.vbsupport.ru/showthread.php?s=&threadid=52968


I'm workin to try to figure out how to do the time in such a way that members will see the time of the event according to their timezone. Once I can figure that out (may be a few months ;) ) or if anyone knows how and would like to point the way (which I'd be most grateful for), I'll create a new version of this hack for that. :) In the meantime, the -3- mod, was my bandaid to tide us over. :)

If these instructions are easy enough for everyone to follow and I don't have any unnessecary code then I'll get this moved to the full releases, but would prefer to double check with those more experienced first. :)

Anyway, let me know what you think, if you have any problems I'll try my best to assist.

A live demo can be scene at http://www.guardiansoffire.com (http://www.guardiansoffire.com/)

Day Info - http://www.guardiansoffire.com/forums/calendar.php?s=&action=getinfo&eventid=498

Thread created by Session's hack - http://www.guardiansoffire.com/forums/showthread.php?s=&threadid=7897

Thanks to Asterix, there are some screenshots in the replies below. :)

[Cyricx]

Here's a screenshot of adding a new event.

[Cyricx]

And here is a screenshot of the thread created by Session's hack with the added code from this hack.

[MrNase]

very cool!

I don't need it now but it shall be ported to vB3 !! :)

[gmarik]

This one is nice.
Only the cp panel design could be lighter ...

[FleaBag]

Cyricx, do you have any kind of moderation active on your Calendar for user submitted events? I can't get the hack to work with 3.2.0, just curious as to whether you're using it. I'd add this hack in a flash if I could offer that service again.

[gmarik]

-Powerful alarms with custom messages, MP3, WAV, MIDI
-Add event
--Once
--Hourly
--Daily
--Weekly
--Monthly
--Annualy
--Regular
--Special

[FleaBag]

You don't want much do you? ;)

[gmarik]

Sure, only these couple o' things. :o)

[corsacrazy]

and maybe an automatic installer file, this hack takes ages to manually do :(

[DaveLogic]

Everything seems to work except that I can only enter numbers into the new fields icluding the Subject box. As soon as I enter any form of text I get the following error

Database error in vBulletin 2.3.2:

Invalid SQL: INSERT INTO calendar_events (userid, event, eventdate, public, subject, allowsmilies, venue, weekday, time, lineup, cost)
VALUES ('1', 'Test', '2003-11-14', 1, 'Test', 1, Test, Test, Test, Test, Test)
mysql error: Unknown column 'Test' in 'field list'

mysql error number: 1054

Date: Friday 14th of November 2003 09:56:36 AM
Script: http://localhost/forums/forums/calendar.php
Referer: http://localhost/forums/calendar.php?action=add&type=public


I've uninstalled/reinstalled the hack twice and also tried with the default settings i.e "Meeting" but still get the same error. I've also checked Mysql and all set to VARCHAR. Tried with TEXT but made no difference....Any ideas???

[DaveLogic]

NB: This is also intergated with the Calendar to Thread Hack which was working fine...

[LeMans350z]

Everything seems to work except that I can only enter numbers into the new fields icluding the Subject box. As soon as I enter any form of text I get the following error

Database error in vBulletin 2.3.2:

Invalid SQL: INSERT INTO calendar_events (userid, event, eventdate, public, subject, allowsmilies, venue, weekday, time, lineup, cost)
VALUES ('1', 'Test', '2003-11-14', 1, 'Test', 1, Test, Test, Test, Test, Test)
mysql error: Unknown column 'Test' in 'field list'

mysql error number: 1054

Date: Friday 14th of November 2003 09:56:36 AM
Script: http://localhost/forums/forums/calendar.php
Referer: http://localhost/forums/calendar.php?action=add&type=public


I've uninstalled/reinstalled the hack twice and also tried with the default settings i.e "Meeting" but still get the same error. I've also checked Mysql and all set to VARCHAR. Tried with TEXT but made no difference....Any ideas???

Ok I had the same error. There is a couple of errors in the install file.
-1-
++++++++++++++++++++++++++
Step 8:
Find:

VALUES ('$bbuserinfo[userid]', '$message', '$date', $public, '$subject', $allowsmilies


AND REPLACE WITH:

VALUES ('$bbuserinfo[userid]', '$message', '$date', $public, '$subject', $allowsmilies, '$eventtime', '$ampm', '$eventzone'

++++++++++++++++++++++++++
Single Quote missing from $eventtime, $ampm, $eventzone

-2-
++++++++++++++++++++++++++
Step 8:
Find:

VALUES ('$bbuserinfo[userid]', '$message', '$date', $public, '$subject', $allowsmilies


AND REPLACE WITH:

VALUES ('$bbuserinfo[userid]', '$message', '$date', $public, '$subject', $allowsmilies, '$meeting'

++++++++++++++++++++++++++
Single Quote missing from $meeting

SO any new fields you created need the single quotes on step 8. I would assume the -3- step requires the same modification however I did not use it so I didn't look. Hope that helps.

[DaveLogic]

Many thanks for your reply...Got it sorted now....thanks