Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
v1.0 Add Meeting Place, Time or Game fields to Calendar Details »
v1.0 Add Meeting Place, Time or Game fields to Calendar
Mod Version: 1.00, by Cyricx (Member) Cyricx is offline
Developer Last Online: Dec 2011 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 2.2.x Rating: (0 vote - 0 average) Installs: 1
Released: 04 Oct 2003 Last Update: Never Downloads: 1
Not Supported Is in Beta Stage  

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 -

http://www.vbulletin.org/forum/showt...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

Day Info - http://www.guardiansoffire.com/forum...fo&eventid=498

Thread created by Session's hack - http://www.guardiansoffire.com/forum...&threadid=7897

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

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Comments
  #2  
Old 04 Oct 2003, 04:09
Cyricx Cyricx is offline
 
Join Date: Sep 2002
Here's a screenshot of adding a new event.
Attached Images
File Type: jpg calendar2.jpg (80.7 KB, 144 views)
__________________
Cyricx (Chris)
Reply With Quote
  #3  
Old 04 Oct 2003, 04:11
Cyricx Cyricx is offline
 
Join Date: Sep 2002
And here is a screenshot of the thread created by Session's hack with the added code from this hack.
Attached Images
File Type: jpg calendar1.jpg (65.6 KB, 103 views)
__________________
Cyricx (Chris)
Reply With Quote
  #4  
Old 04 Oct 2003, 22:06
MrNase's Avatar
MrNase MrNase is offline
 
Join Date: May 2003
Real name: Dominik
very cool!

I don't need it now but it shall be ported to vB3 !!
Reply With Quote
  #5  
Old 07 Oct 2003, 11:41
gmarik's Avatar
gmarik gmarik is offline
 
Join Date: May 2002
Real name: Marco
This one is nice.
Only the cp panel design could be lighter ...
Reply With Quote
  #6  
Old 31 Oct 2003, 11:56
FleaBag's Avatar
FleaBag FleaBag is offline
 
Join Date: Dec 2001
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.
__________________
AndroidETC.com :: Android, and other stuff.
Reply With Quote
  #7  
Old 31 Oct 2003, 18:16
gmarik's Avatar
gmarik gmarik is offline
 
Join Date: May 2002
Real name: Marco
Wishlist

-Powerful alarms with custom messages, MP3, WAV, MIDI
-Add event
--Once
--Hourly
--Daily
--Weekly
--Monthly
--Annualy
--Regular
--Special
Reply With Quote
  #8  
Old 01 Nov 2003, 19:33
FleaBag's Avatar
FleaBag FleaBag is offline
 
Join Date: Dec 2001
You don't want much do you?
__________________
AndroidETC.com :: Android, and other stuff.
Reply With Quote
  #9  
Old 02 Nov 2003, 07:55
gmarik's Avatar
gmarik gmarik is offline
 
Join Date: May 2002
Real name: Marco
Sure, only these couple o' things. )
Reply With Quote
  #10  
Old 02 Nov 2003, 10:01
corsacrazy's Avatar
corsacrazy corsacrazy is offline
 
Join Date: May 2002
Real name: wayne
and maybe an automatic installer file, this hack takes ages to manually do
Reply With Quote
  #11  
Old 14 Nov 2003, 10:17
DaveLogic DaveLogic is offline
 
Join Date: Jun 2003
Real name: David
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...dd&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???
Reply With Quote
  #12  
Old 14 Nov 2003, 10:19
DaveLogic DaveLogic is offline
 
Join Date: Jun 2003
Real name: David
NB: This is also intergated with the Calendar to Thread Hack which was working fine...
Reply With Quote
  #13  
Old 16 Nov 2003, 02:27
LeMans350z LeMans350z is offline
 
Join Date: Dec 2002
Originally Posted by 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...dd&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.
__________________
LeMans350z
Reply With Quote
  #14  
Old 17 Nov 2003, 08:42
DaveLogic DaveLogic is offline
 
Join Date: Jun 2003
Real name: David
Smile

Many thanks for your reply...Got it sorted now....thanks
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 16:58.

Layout Options | Width: Wide Color: