vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)
-   -   New Thread on Calendar Event (https://vborg.vbsupport.ru/showthread.php?t=67074)

Luciolle 06-21-2005 01:40 PM

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 06-21-2005 02:47 PM

Quote:

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 07-18-2005 06:04 PM

Quote:

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

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 07-27-2005 02:41 PM

can someone port this to vb3.5.

djsydeburnz 09-24-2005 04:11 AM

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 09-24-2005 04:30 AM

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 02-02-2006 04:40 PM

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 02-20-2006 05:10 PM

I'm recieving the error:

Quote:

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 12-12-2007 07:18 AM

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

conradk 10-21-2008 01:52 AM

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


All times are GMT. The time now is 11:02 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02290 seconds
  • Memory Usage 1,776KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (4)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete