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.

[Videx]

No, this has been superseded by https://vborg.vbsupport.ru/showthread.php?t=123416 which is running good in 3.7.3.

[XrayHead]

Hi All

Anyone know if there is a newer version of this hack or if this works with 3.7?

I'm just upgrading from SMF and this is a standard feature with their software. As it’s a club site we use this ALL the time to link events in the Calendar to threads in the forum!!

Lee

[Videx]

What's wrong with the one I just linked to?

[XrayHead]

OPP's Sorry........ :erm:

Trying to multi task to much I think!!