New Thread on Calendar Event

New Thread on Calendar Event

What it does:
This rather small hack is easy: it starts a new thread in a specific forum for every Event that is posted in the calendar. On our forum it is used for discussion of partys (as it's a party calendar).

Is it complicated?
There is actually very little to change, but in that small part, there are a lot of variables to be edited which are forum specific. That might make it a bit hard for php newlings

Changes:
New files (0):
none

Changed files(1):
calendar.php

New database fields/tables(0):
none

New templates(0):
none

Changed templates(0):
none

New phrases(0):
none

Screenshots:
No visible changes

Instructions:

• Backup all your forum files as well as your database
• Copy the following code into your favorite PHP editing program (Dreamweaver, Wordpad, Notepad...) and edit it to fit your forums.
  
  PHP Code:

  $forumid = 1; // forumid in which to post
$botuserid = 1; //userid of poster
$botusername = "EventBot"; // username of poster

$dateformat = "m-d-y";
$threadtitle = "[".vbdate($dateformat, $dateline_from,false,true,false,true)."] ".$title;
$postmessage = "This is an automatically generated thread for the event [b]".$title."[/b].
More information on this event is available on [url=".$vboptions['bburl']."/calendar.php?".$session[sessionurl]."do=getinfo&e=".$eventid."&day=".vbdate("Y-n-j",TIMENOW,false,true,false,true)."&c=".$calendarid."]this page[/url].";
$iconid = 0;
            
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "thread
(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline, iconid, visible)
VALUES ('" . addslashes($threadtitle) . "', " . TIMENOW . ", $forumid, 1, 0, '$botusername', $botuserid, '$botusername', " . TIMENOW . ", $iconid, 1)
");
$threadid = $DB_site->insert_id();
            
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "post
(threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie, showsignature, ipaddress, iconid, visible)
VALUES ($threadid, 0, '" . addslashes($threadtitle) . "', '$botusername', $botuserid, " . TIMENOW . ", '" . addslashes($postmessage) . "', 1, 0, 0, $iconid, 1)
");
$firstpostid = $DB_site->insert_id();

$DB_site->query("UPDATE " . TABLE_PREFIX . "thread
SET firstpostid = $firstpostid
WHERE threadid = $threadid
");
            
$DB_site->query("
UPDATE " . TABLE_PREFIX . "forum
SET replycount = replycount +  1,
threadcount = threadcount + 1,
lastpost = " . TIMENOW . ",
lastposter = $botusername,
lastthread = '" . addslashes($threadtitle) . "',
lastthreadid = $threadid,
lasticonid = $iconid
WHERE forumid = $forumid
"); 

  The variables to be edited (marked green) are:
  • forumid is the forumid of the forum in which the Bot will be posting the threads to the calendar events
  • botuserid is the userid of the user that will be shown as the author of the thread. I suggest making a special user and naming him something like EventBot
  • botusername is the username of the user that will be shown as the author of the thread. Should be the username to the userid indicated in botuserid. Make sure the username is enclosed in quotation marks ("").
• Open your calendar.php and look for
  PHP Code:

  if ($calendarinfo['neweventemail']) 

• Above that add the code you just edited.

[Luciolle]

Ok sorry I bump this old message but I try to install on vbulletin 3.0.7, I know it's for vb 3.0.3 but it'S supposed to work, but I have always the same error as some people before on this subjet:

Error:

Database error in vBulletin 3.0.7:

Invalid SQL:
UPDATE forum
SET replycount = replycount + 1,
threadcount = threadcount + 1,
lastpost = 1119364576,
lastposter = FrancoisEVENBOT,
lastthread = '[d-m-y] TEST 2435425252523 !!!',
lastthreadid = 119,
lasticonid = 0
WHERE forumid = 63

mysql error: Unknown column 'FrancoisEVENBOT' in 'field list'

mysql error number: 1054

Some body have a solution for that ?
Thanks

(P.S.: I read all messages and I don't find solution or I'm not looking so great ^^)

[Colin F]

Originally Posted by Luciolle

Ok sorry I bump this old message but I try to install on vbulletin 3.0.7, I know it's for vb 3.0.3 but it'S supposed to work, but I have always the same error as some people before on this subjet:

Error:

Database error in vBulletin 3.0.7:

Invalid SQL:
UPDATE forum
SET replycount = replycount + 1,
threadcount = threadcount + 1,
lastpost = 1119364576,
lastposter = FrancoisEVENBOT,
lastthread = '[d-m-y] TEST 2435425252523 !!!',
lastthreadid = 119,
lasticonid = 0
WHERE forumid = 63

mysql error: Unknown column 'FrancoisEVENBOT' in 'field list'

mysql error number: 1054

Some body have a solution for that ?
Thanks

(P.S.: I read all messages and I don't find solution or I'm not looking so great ^^)

See this post: https://vborg.vbsupport.ru/showpost....27&postcount=7

[YLP1]

Originally Posted by Torqued

Ok. Here is what I did to enable a check box. This will add a check box to the Miscellaneous Options when you are creating or editing a calendar event.

When creating a new event:
1: Checking the check box will copy the event as a new thread in $forumid (defined in the code).
2: Leaving the check box unchecked will only create the event on the calendar.

When editing an existing event:
1: Checking the check box will copy the event as a new thread in $forumid (defined in the code).
2: Leaving the check box unchecked will only update the calendar entry.

Now... if you already created a thread and go edit the event later and check the check box, it does not update the previous thread - it creates a new thread.

Also, if you want to convert an existing event to a new thread, you do not really have to "edit" anything. Just click on edit event, check the check box, and save. This will create the new thread in your forum.


In calendar.php, find the following code:

PHP Code:

if ($calendarinfo['neweventemail']) 


And add this code above that. Be sure you edit the $forumid to be the forum you want posts to show up in.

PHP Code:

//hack New Thread on Calendar Event
if ($_POST[makepost] == 1) { 
//add check box functionality
$forumid = 1; // forumid in which to post 
 
// Get forum info 
$foruminfo = fetch_foruminfo($forumid, false); 
$dateformat = "d M, Y"; 
$threadtitle = "[".vbdate($dateformat, $dateline_from,false,true,false,true)."] ".$title; 
 
// Prepare the thread ... 
$post[title] = $threadtitle;
$post[poststarttime] = TIMENOW; 
$post[posthash] = md5($post[poststarttime] . $bbuserinfo['userid'] . $bbuserinfo['salt']); 
$post[message] = $message; 
$post[username] = $bbuserinfo[userid]; 
$post[iconid] = 0; 
$post[emailupdate] = 9999; 
 
// ... and create it 
require_once('./includes/functions_newpost.php'); 
build_new_post('thread', $foruminfo, array(), 0, $post, $errors);
//add check box functionality
} 
//hack New Thread on Calendar Event 


Still in calendar.php, find this code:

PHP Code:

        require_once('./includes/functions_databuild.php'); 


And add this code above it. Be sure you edit the $forumid to be the forum you want posts to show up in.

PHP Code:

//hack New Thread on Calendar Event
if ($_POST[makepost] == 1) { 
//add check box functionality
$forumid = 1; // forumid in which to post 
 
// Get forum info 
$foruminfo = fetch_foruminfo($forumid, false); 
$dateformat = "d M, Y"; 
$threadtitle = "[".vbdate($dateformat, $dateline_from,false,true,false,true)."] ".$title; 
 
// Prepare the thread ... 
$post[title] = $threadtitle;
$post[poststarttime] = TIMENOW; 
$post[posthash] = md5($post[poststarttime] . $bbuserinfo['userid'] . $bbuserinfo['salt']); 
$post[message] = $message; 
$post[username] = $bbuserinfo[userid]; 
$post[iconid] = 0; 
$post[emailupdate] = 9999; 
 
// ... and create it 
require_once('./includes/functions_newpost.php'); 
build_new_post('thread', $foruminfo, array(), 0, $post, $errors);
//add check box functionality
} 
//hack New Thread on Calendar Event 


Adding the check box:

Log into your AdminCP and go to the Style Manager.

Open the calendar_edit template and find this code:

<legend>$vbphrase[miscellaneous_options]</legend>

And add this below that code:

<div><input type="checkbox" name="makepost" value="1">Copy calendar event to new thread</div>

I am so confused... I have three instances of this code: require_once('./includes/functions_databuild.php');

which one do I put the last piece of code above?

[jugo]

can someone port this to vb3.5.

[djsydeburnz]

quick question. lets say that i would prefer to have my title list as 'Event, Date, Location' and I have my 'location' listed as a custom field in my database. I know that in the database, the custom id #4 is for location. I can figure out everything but the location in posting it to the title of the forum.

$post[title] = .$title"|".vbdate($dateformat, $dateline_from,false,true,false,true)."|" ?unknown code;

shoud give me:

Event Title | Event Date | Event Location

[djsydeburnz]

oh, and also wanted to repost an earlier request about listing the information from the roll call feature. in case the rollcall feature is unknown, it is another hack where users can 'mark their attendance' to the event. in the calendar, it lists the members who have marked their attendance, and it would be cool to post this info at the bottom of the thread, just like in the calendar.

thanks in advance.

[tendo]

Does this work for 3.5 at all? Seattle Dnb really needs this. I think it's stupid that vBulletin doesnt have this built in.

Thanks for your time.

[Ashiro]

I'm recieving the error:

Call to a member function on a non-object in /home/ashiro/public_html/degenerates/board2/calendar.php on line 1944

Is there any chance you could help me out? I'd like to get this mod working as it'd be very useful. Thank you.

[Alphawolf83]

Is there a product for vb3.6.x? I did search, but didnt find anything...

[conradk]

Anybody running this mode with 3.7.3? Checking before I start hacking.