The Arcive of Official vBulletin Modifications Site.

New Thread on Calendar Event · **Released**: 07-10-2004

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.

scratche · #52 05-04-2005, 03:12 PM

hi there i wanted to know if ne one could help.. im using the roll call feature for my calendar... and i want it too post that in my forum aswell for each thread can anyone assist me in doin this

Benj · #53 05-05-2005, 09:06 AM

does this hack add calendar custom fields to the post as well ?

Torqued · #54 05-11-2005, 12:10 AM

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:

Code:

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

And add this below that code:

Code:

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

scratche · #55 05-15-2005, 02:48 AM

Quote:

Originally Posted by scratche

hi there i wanted to know if ne one could help.. im using the roll call feature for my calendar... and i want it too post that in my forum aswell for each thread can anyone assist me in doin this

can anyone help me with this i can seem to get the roll call options to post aswell into the thread that this hack creates... any suggestions?

Cyricx · #56 05-16-2005, 12:06 PM

That's awesome Torqued!! I can totally use that code to do exactly what I need with this

Thank you so much!!!

scratche · #57 05-16-2005, 05:20 PM

how can i have the information from this hack
https://vborg.vbsupport.ru/showthrea...ight=roll+call
post with the message in the thread????

Torqued · #58 05-16-2005, 07:06 PM

Quote:

Originally Posted by Cyricx

That's awesome Torqued!! I can totally use that code to do exactly what I need with this

Thank you so much!!!

I'm sort of using it as a blog. You can see the results here: http://www.torqued.org/news

I'm glad someone else found it useful.

lionslair · #59 05-21-2005, 05:50 AM

Quote:

Originally Posted by KirbyDE

Instead of $botuserid and $botusername use $bbuserinfo[userid] and $bbuserinfo[username].

And I wonder why this hack re-invents the wheel instead of just using build_new_post()?

PHP Code:


			
$forumid = 1; // forumid in which to post 



// Get forum info

$foruminfo = fetch_foruminfo($forumid, false);



// Prepare the thread ...

$post[title] = "[".date($dateformat, $dateline_from)."] ".$title; 

$post[poststarttime] = TIMENOW;

$post[posthash] = md5($post[poststarttime] . $bbuserinfo['userid'] . $bbuserinfo['salt']);

$post[message] = "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=".date("Y-n-j")."&c=".$calendarid."]this page[/url]."; 

$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);

If you want to be fully flexible, one could make the text as a phrase, forum ID and date format string as a setting

I have public and private events and if the event is public I want it to be posted into the public forum. If it is a private event I want it to be posted into the proivate forum. Is this able to be done?

SamirDarji · #60 05-26-2005, 03:17 AM

Quote:

Originally Posted by lionslair

I have public and private events and if the event is public I want it to be posted into the public forum. If it is a private event I want it to be posted into the proivate forum. Is this able to be done?

It is possible to be done, but will add to the complexity of this hack as the destination forum has to vary with the source calendar. So some code will have to be put in that checks what calendar the event is being posted to, to determine the destination forum for the thread. I'm no coder, but it's a bit of work from the current implementation.

HeloHi · #61 05-26-2005, 11:56 PM

Quote:

Originally Posted by Viks

hi guys, Colin,
I am getting the follwing error message when i add a new calender event.
Once I go back to my forum i see the thread and the event but the error message occurs each time a new event is added.

Error message==
===============

Database error in vBulletin 3.0.3:

Invalid SQL:
UPDATE forum
SET replycount = replycount + 1,
threadcount = threadcount + 1,
lastpost = 1104462847,
lastposter = ,
lastthread = '[12-30-04] new event',
lastthreadid = 62,
lasticonid = 0
WHERE forumid = 18

mysql error: You have an error in your SQL syntax near '
lastthread = '[12-30-04] new event',
lastthreadid = 62,
lasticonid = 0
WHER' at line 6

mysql error number: 1064

Date: Thursday 30th of December 2004 10:14:08 PM
Script: http://www.myforums.com/forums/calendar.php
Referer: http://www.myforums.com/forums/calen...ype=single&c=1
Username: A
IP Address: 64.1.2.3

============================================

please help.

thanks

vik

I am getting this error too. Anyone else run into this problem and figured out what is wrong with it?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05374 seconds Memory Usage 2,382KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (7)bbcode_php (5)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!