vb.org Archive - Date and Time Variables

OK .. having a bit of a problem here figuring out what Date and Time variables are availlable. Would appreciate any help! :)

Firstly, what I'm looking to do, is be able to use an if/else statement to do/show something dependant on if the 'forum time' falls into a certain range (BETWEEN $feature_open AND $feature_close). Is there a variable that is accessable for your forum's time? By forum time, I mean server time + $vboptions[hourdiff] (which is the variable I found for server to forum offset).

Or would I be better off adding the following in global.php if it's a variable I'll be using alot?

PHP Code:


		
			
$forumtime = date() + $vboptions[hourdiff];

I'm very new to this and still learning the basics of PHP, but am I correct in assuming date() is the php function to get the unix time on your forum's server?

I'm guessing since I'll be using it for both comparisons and display, that it would be best to keep it in unix time (seconds since 1970), and then later just format it for display purposes? Is this the IF statement I should use?

PHP Code:


		
			
if($forumtime > $feature_open && $forum_time < $feature_close)

{ do; whatever; I; need; to; do; here; if; true; }

else

{ do; whatever; I; need; to; do; here; if; false; }

I'm guessing once I learn how to access info from the database, I could also do the following SQL command? Obviously I'm not entirely sure how to do this yet, as the following could just be a pile of garbage ... lol:

Code:

$features = 

however_connect_to_table_then_add_SQL_

 SELECT needed_data1, needed_data2

 FROM feature_data_and_date_range_table

 WHERE (getdate() BETWEEN feature_open AND feature_close)

     AND feature_id = $feature_to_get_if_in_range;

Do vB variables have 'scope' (learning new terms .. lol) within SQL statements in vB PHP pages?

Also, when wanting to enter the date range to my database to store the range something will be availlable, should I use the following if I used the coresponding form variable on the submit page?

$feature_open = mktime(open_hour,0,0,open_month,open_day,open_year );

and

$feature_close = mktime(close_hour,0,0,close_month,close_day,close_ year);

I'm still not sure how to plug it all into the appropriate database fields, but I'm sure some searching in these and/or other MySQL forums will help, or simply looking at similar code already in vB. Otherwise I 'll start a new topic not to mix it up with this one.

THANKS TO ANY AND ALL WHO EVEN TRY TO READ THE ABOVE MESS !!! LOL :)

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01012 seconds Memory Usage 1,721KB 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 (1)bbcode_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: