vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   vBulletin CMS Widgets - Upcoming Events (https://vborg.vbsupport.ru/showthread.php?t=231365)

gruftiradio 12-31-2009 07:35 PM

Can the Widget show the Time of Event, not the date?

S1OPP 01-01-2010 12:34 PM

Installed and working great.

Q: Is there a simple way to get it to include upcoming birthdays?

NiCForce 01-01-2010 10:00 PM

I think that some coders already know the answer, but do not show us how?
a friend of mine has been added to my code (or the entire code) =




PHP Code:

ob_start(); 

$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'] == 
     { 
$datefrom date('j',$event['dateline_from']); 
$datefrom $datefrom+1;
         
$format sprintf("On ".$datefrom."th %s",date('M Y',$event['dateline_from'])); 
     } else { 
$datefrom date('j',$event['dateline_from']); 
$datefrom $datefrom 1;
$dateto date('j',$event['dateline_to']); 
$dateto $dateto 1;
         
$format sprintf("From ".$datefrom."th %s to ".$dateto."th %s",date('M Y',$event['dateline_from']),date('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(); 

Set your GMT time, standard for me + 1 (change it) and it should work.
if a coder could take the data from the + or - GMT time and replacing the code in my (+ 1)then it should work. but what I was thinking. is that the data is taken from a wrong place.

ragtek 01-03-2010 02:28 PM

You should use the eventcache instead of selecting the events from the database!

Also you don't take care of the showupcoming Option and the calendarpermissions....
Also you should use the vbulletin dateformat instead of hardcoding;)

ngcoders 01-05-2010 01:27 AM

@ragtek - If all this was documented somewhere so that i could have referenced , Sadly there is none. Also i wrote it for personal use and it server my purpose.

ragtek 01-05-2010 06:58 AM

Quote:

Originally Posted by ngcoders (Post 1947454)
@ragtek - If all this was documented somewhere so that i could have referenced , Sadly there is none. Also i wrote it for personal use and it server my purpose.

Yea, i know what you mean.
If i code something for me, i also don't code it "the vB way" (for example i don't creat options,.don't use the permissionsystem,etc..) but if i want to release it here, i have to make it userfriendly.

But because youre users can change the time zone, you should take care of this;)


For timeformating you can use the vbdate function: http://members.vbulletin.com/api/vBu...functionvbdate

hope that helps:)

ngcoders 01-05-2010 05:36 PM

Thanks ill keep that in mind , When more vb4 details are available will update accordingly.

oechertigger 01-06-2010 04:50 PM

Great App! THX

but is there a possibility to change the language of the Datetime Format??
Diplayed is: From 8th Jan 2010 to 8th Jan 2010

I want to have: Am 08.01.2010 von 08:00Uhr bis 20:00Uhr

or: Am 08. Jan. 2010 von 08:00 bis 20:00 Uhr

I use a german board, so i like to have the german dateformat!

I hope someone can help...?


Just found the answer by myself:

Quote:

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("Am %s",date('d. M. Y H:i',$event['dateline_from']));
} else {
$format = sprintf("Am %s bis %s",date('d. M. Y H:i',$event['dateline_from']),date('d. M. Y H:i',$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();

Bitti 01-06-2010 05:40 PM

Quote:

Great App! THX

but is there a possibility to change the language of the Datetime Format??
Diplayed is: From 8th Jan 2010 to 8th Jan 2010

I want to have: Am 08.01.2010 von 08:00Uhr bis 20:00Uhr

or: Am 08. Jan. 2010 von 08:00 bis 20:00 Uhr

I use a german board, so i like to have the german dateformat!

I hope someone can help...?
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'] == )
{
$format sprintf("Am %s"vbdate(VB::$vbulletin->options['dateformat'],$event['dateline_from']));
} else {
$format sprintf("Vom %s 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(); 


nealohara 01-06-2010 06:17 PM

Nice. Is there a way of refining this a little?

Let's say we've got a room booked on Thursday the 7th January between 20:00 and 21:00 and we add it to the default calendar. Currently what we get is

Event
7th Jan 2010 to 7th Jan 2010


ideally I'd like it to display as follows:

Event
7th Jan 2010 between 20:00 and 21:00


The dates and times are all stored as variables but I don't want to screw it up :)

Any ideas?


All times are GMT. The time now is 04:50 PM.

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.01277 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_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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