The Arcive of Official vBulletin Modifications Site.

Upcoming Events · **Released**: 12-27-2009

Upcoming Events

Released 28/12/2009
By Vikas - http://www.ngcoders.com

Installation

Goto Admincp->vBullietin CMS->Widgets->Create New Widget
Choose PHP Direct Execution as Widget's Type
Place a Title. eg Upcoming Events. Keep it short as this is what will appear as title on your pages.
Click Save
Click Configure on the right of the new created widget.
Remove the default code that appears. Be sure to not leave behind even a single letter.
Copy and Paste the code that you can find below.
Leave the template name as is (vbcms_widget_execphp_page)
Click Save
Goto Admincp->vBullietin CMS->Layout Manager
Click Go on the Default Layout
Add the Widget to your Layout
Click Save
That's all !!

PHP Code

PHP Code:


			


ob_start();





//  %d

$show_count = 5;



$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || (  dateline_from > '%d' AND dateline_to < '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);



$event_get = vB::$db->query_read($query);



$output_bits = '';

while($event = vB::$db->fetch_array($event_get)) {



     if($event['dateline_to'] == 0 )

     {

         $format = sprintf("On %s",date('jS M Y',$event['dateline_from']));

     } else {

         $format = sprintf("From %s to %s",date('jS M Y',$event['dateline_from']),date('jS M Y',$event['dateline_to']));

     }

     

     $output_bits .= sprintf('

        <div class = "cms_widget_post_bit"><h4 class="cms_widget_post_header"><a href="calendar.php?do=getinfo&e=%d">%s</a></h4>

            <p class="cms_widget_post_content">%s</p>

        </div>

        ',$event['eventid'],$event['title'],$format);



}

$output = $output_bits;



ob_end_clean();

NashChristian · #**182** 10-05-2010, 05:37 PM

Quote:

Originally Posted by khuhner

I hear you on the Calendar. It's really pitiful. I voted for your Jira. I also entered in a Jira a long time ago, would everyone vote for that one as well?

http://tracker.vbulletin.com/browse/VBIV-7072

Voted! I cross-referenced the two requests as well.

theoutlawed · #**183** 10-08-2010, 02:41 AM

Quote:

Originally Posted by Stadler

Nice widget, but it won't show 'All Day'-events.

To fix this find:

Code:

$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || (  dateline_from > '%d' AND dateline_to < '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);

and replace it with:

Code:

$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%1\$d' || (  dateline_from > '%1\$d' AND dateline_to < '%1\$d' ) || (dateline_to = 0 AND DATE(FROM_UNIXTIME(dateline_from)) = DATE(FROM_UNIXTIME(%1\$d)))) ORDER BY dateline_from ASC LIMIT %2\$d",TIMENOW,$show_count);

HTH,
Christian Stadler

Thank you this fixed my issues. Been combing through this thread post by post and this is what fixed it for me.

Mark4865 · #**184** 10-11-2010, 02:00 PM

Hello,

Stupid question but I run 3 different event calendars, so if I create 3 different upcoming event widgets with 3 diffrent titles, how do I make each widget only check the right calendar for events??

khuhner · #**185** 10-11-2010, 02:24 PM

Quote:

Originally Posted by Mark4865

Hello,

Stupid question but I run 3 different event calendars, so if I create 3 different upcoming event widgets with 3 diffrent titles, how do I make each widget only check the right calendar for events??

Actually not a stupid question. There's a lot of requests about enhancing the Calendar, as it currently provides very little in the way of configuration, features, etc.

You'll need to submit an enhancement request to get any changes to the calendar (or other products). I'd suggest doing that on vb.com, not here. There are at least two outstanding extensive calendar enhancement request in the Tracker. I submitted this one:

http://tracker.vbulletin.com/browse/VBIV-7072

and here's the other:

http://tracker.vbulletin.com/browse/VBIV-7656

I'd recommend adding your requirement to either/both (via comments) and be sure to 'vote' for each. The more peoiple vote the more likely it'll get assigned to a developer!

Kurt

Mark4865 · #**186** 10-11-2010, 03:26 PM

thanks for quick response Kurt, does this current widget in this post allow me to run 3 calendars with 3 different titled widgets and if so how do I get the correct one to know which calendar to take events off.??

khuhner · #**187** 10-11-2010, 10:03 PM

Quote:

Originally Posted by Mark4865

thanks for quick response Kurt, does this current widget in this post allow me to run 3 calendars with 3 different titled widgets and if so how do I get the correct one to know which calendar to take events off.??

Well, if you read the detail of the Jira items, there isnt anything in there for support for multiple calendars. I would like that too, and I would strongly recommend you add your comments and suggestions directly to the Jira on vb.com rather than posting here.

Here are the two items:

http://tracker.vbulletin.com/browse/VBIV-7072
http://tracker.vbulletin.com/browse/VBIV-7656

Kurt

Eduardo Leon · #**188** 10-11-2010, 10:12 PM

this work like a widget ..

this is right ?

well i try to use this in my forum ... !

mse2k · #**189** 10-22-2010, 03:50 PM

This is my code. It shows all upcomming events and the events on the actually day. But it shows not only 2 how in $show_count, it shows all. Can you help me. THX

Quote:

ob_start();

// %d
$show_count = 2;

$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event

WHERE visible = 1
AND (dateline_from >= '%d' || dateline_to >= '%d' )

ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);

$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get)) {

if($event['dateline_to'] == 0 )
{
$format = sprintf("Am %s", vbdate(VB::$vbulletin->options['dateformat'],$event['dateline_from']));
} else {
$format = sprintf("Vom %s <br>bis %s", vbdate(VB::$vbulletin->options['dateformat'],$event['dateline_from']), vbdate(VB::$vbulletin->options['dateformat'],$event['dateline_to']));
}

$output_bits .= sprintf('
<div class = "cms_widget_post_bit"><h4 class="cms_widget_post_header"><a href="calendar.php?do=getinfo&e=%d">%s</a></h4>
<p class="cms_widget_post_content">%s</p>
</div>
',$event['eventid'],$event['title'],$format);

}
$output = $output_bits;

ob_end_clean();

miata.shark · #**190** 11-30-2010, 01:06 AM

How can I manage repeated events?
i.e. I want to display "each tuesday" for a repeated meeting

I set an if about recurring and then I should pick the recuroption............ but how can I treat something like "1|4"?

khuhner · #**191** 12-01-2010, 12:46 PM

Quote:

Originally Posted by miata.shark

How can I manage repeated events?
i.e. I want to display "each tuesday" for a repeated meeting

I set an if about recurring and then I should pick the recuroption............ but how can I treat something like "1|4"?

Unfortunately the mod doesnt do that. There has been several items added to the bug Tracker on vb.com that are related to your problem. I strongly encourage everyone to vote for BOTH items as many sites require more sophisticated Calendar support.

http://tracker.vbulletin.com/browse/VBIV-7072
http://tracker.vbulletin.com/browse/VBIV-7656

Kurt

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04838 seconds Memory Usage 2,353KB Queries Executed 26 (?)
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 (1)bbcode_php (6)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (2)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (1)postbit_attachment (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 fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment 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:

2 благодарности(ей) от:
level8, Toorak Times

The Arcive of Official vBulletin Modifications Site.

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