Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 05-09-2004, 07:08 PM
LancerForums's Avatar
LancerForums LancerForums is offline
 
Join Date: Nov 2001
Location: CA
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Query to Get the Latest Events from a Specific Calendar

Hi,

Does anyone know what the query would be to select a list of events from a particular calendar?

Thanks,

Mark
Reply With Quote
  #2  
Old 05-18-2004, 08:17 PM
mcahill mcahill is offline
 
Join Date: Apr 2002
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Not pretty code, not optimized code. But it does pull events from only the public folder for use on my homepage. No warranty expressed or implied...use at own risk...your mileage may vary.


PHP Code:
<?
            
            
            $fudgedate = strtotime("yesterday");
              //$eventdate = mktime($yesterday);
            
            

              $events = mysql_query("SELECT * FROM event where dateline_from = '$fudgedate' or dateline_from > '$fudgedate' and recurring !=3 and calendarid = 1 order by dateline_from asc limit 8") or die("oops3");
            
            $eventrow = mysql_fetch_array($events);
                    
            while ( $rowevents = mysql_fetch_array($events) ) { 
            
                    
            echo "<a href='http://sitename.com/forum/calendar.php?do=getinfo&e=" . $rowevents['eventid'] ."'>";
            echo $rowevents['title'];
            echo "</a> ";
            if ($rowevents['recurring'] == 0 and $rowevents['dateline_to'] == 0) {
            $fixdate = ($rowevents['dateline_from'] + 86400);
            } 
            else {
            $fixdate = $rowevents['dateline_from'] ;
            }
            echo date("D M j",$fixdate);
            echo "<br>";
            
                
    }

        
          ?>
It has a bit of trouble with some of the ranged date events, but it's good enough for what I use it for. If you improve it, post it back up here...

Cheers,

Mark
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:00 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.06743 seconds
  • Memory Usage 2,170KB
  • Queries Executed 11 (?)
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
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete