Calendar / Thread Integration Hack

Ok, this is my first VBulletin hack so please be calm on me As this is a beta BACKUP the files to be edited (as always)

I always wanted to link the calendar events to a thread aswell. So that if you make a public event, it also generates a thread from the same info. Now i always thought this was going to be hard, but actually it is really simple.

There are 5 steps to do in total in just 2 files. It concerns the calendar.php and the newthread.php

I tested this on vb 2.30 & works smoothly now at my site www.livesets.com

what does it do exactly:

• When people push the New Thread button in a particular forum (can be specified as you like) you will be redirected to the Add Public Event screen
• After filling in the required info it generates a public event just like it would do normally
• next to that it will generate a thread in the forum where you pushed the New Thread button with topic title [date] title ( f.e. "[2003-05-14] Awakenings, Amsterdam NL" ) adn the same content as the Public Event
• after that it updates all counters (forum,thread,user)
• redirects to the new thread

NOTICE: on several places you will have to manually insert the forumid you want to use for this, in the example attached here the forumid used was 2

Please give some feedback I'm really happy i got this to work Some members already requested something like this, this is to make them happy :classic:

Greets,
Session.

[SRozhon]

excellant! Great Job!!!

[FleaBag]

08-21-03 at 11:01 PM bloodkat said this in Post #20
So, I am super new to this, and I am probably missing something obvious... but I installed this hack, and the only people that can use it so far are the admins (for whom it works flawlessly ). I am confused, because I do not see any permissions settings in the hack, and I have not set any custom permissions on the calendar or the forum in question, but everyone besides the admins that attempt to add a new event, enters in their new thread info, and when they hit submit, they get a vBulletin message that says:

You do not have access to do this.

I have been poking around, but I can not seem to find the problem here. Anyone have any thoughts?? Would REALLY appreciate the help.

Isn't this because as default, only admins can add public events? I'm assuming you need to use one of the hacks to enable any members to use this hack.

Session, you stated earlier you had worked out how to get a Reply button, is it possible you could share this with us?

Thank you!

[Session]

I will post an update soon, i'm close to having it 100% perfect with country / city / eventname selection.. see www.livesets.com

only thing i need to do is make it editable in the same way ( i need to extract the different fields again when i want to edit )

Give it a week or 2

[Cyricx]

Bloodkat, get ahold of me on MSN IM and we will poke around

I'm betting its in your calendar access or in the forums permission settings

Session, awesome man, look forward to the update, this is most definately one of the most useful hacks on my site. And being I use 80 some hacks lol, that's saying alot

[DaveLogic]

I haven't installed this hack yet but I have managed to create several extra fields, i.e Event, Venue, Date, Price etc and they all work perfectly....Is it at all possible to have the calendar entries linking to threads, i.e when you click on a calendar link it takes you to the thread not the calendar entry?? This way it will allow for images to be posted within calendar events..

[Cyricx]

Okay, I've figured out how to add a new field and everything, and got it integrated enough with this hack that it doesn't break anything hehehe. However I need to find or figure out a way to get it to add to the thread.

It's a "meeting place" field
So at the beginning of your hack code I have this -

$DB_site->query("INSERT INTO calendar_events (userid, event, eventdate, public, subject, allowsmilies, location)
VALUES ('$bbuserinfo[userid]', '$message', '$date', $public, '$subject', $allowsmilies, '$location')");
$eventid = $DB_site->insert_id();
$DB_site->query("INSERT INTO thread

Now what I'm wondering is how I can get the $location to add into the $subject field of the new thread maybe like a

Meeting Place: $location
< br >
$message

or something like that. Is there a $message="meetingplace $location, < br > $message

kinda code I can do? or any other ideas? =/

I want to add several fields but I just need an example of how to do it once and I can easily duplicate the code

Any ideas?

EDIT - Nm, after a lot of digging finally figured it out, and learned a bit more about php too

here is what I did for those wondering the same..

took this part of sessions code

$DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,allowsmilie,showsignature,ipad dress,iconid,visible)
VALUES (NULL,'$threadid','$subject','$bbuserinfo[username]','$bbuserinfo[userid]','".time()."','0','$message','1','0','0','0','1') ");
$postid=$DB_site->insert_id();

and altered the $message to Meeting Place: $location < br > < br > $message

like so

$DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,allowsmilie,showsignature,ipad dress,iconid,visible)
VALUES (NULL,'$threadid','$subject','$bbuserinfo[username]','$bbuserinfo[userid]','".time()."','0','Meeting Place : $location < br >< br > $message','1','0','0','0','1')");

Removing the spaces before and after the "br" of course

Hope this helps anyone wondering the same.

[dkny]

Anyway I can add an attachment to the event?

[fmoise99]

Great hack! May use this in the future!

[fmoise99]

Originally Posted by dkny

Anyway I can add an attachment to the event?

That would be nice. Even multiple attachments!

[DaveLogic]

Originally Posted by fmoise99

That would be nice. Even multiple attachments!

If this hack could have even one attachment it will immediately become THE mother of all hacks IMO...