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 07-24-2003, 03:30 AM
inthezone inthezone is offline
 
Join Date: Feb 2003
Posts: 31
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Using vbdate

How would I use vbdate to format the date/time of a 'lastpost' number from the DB table called 'thread'?
Reply With Quote
  #2  
Old 07-24-2003, 09:58 AM
NTLDR's Avatar
NTLDR NTLDR is offline
Coder
 
Join Date: Apr 2002
Location: Bristol, UK
Posts: 3,644
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PHP Code:
$date vbdate($dateformat$thread['dateline']);
$time vbdate($timeformat$thread['dateline']); 
Replacing $thread with the variable that holds in information from the DB.
Reply With Quote
  #3  
Old 07-24-2003, 03:55 PM
inthezone inthezone is offline
 
Join Date: Feb 2003
Posts: 31
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I've done this:

PHP Code:
$query = @mysql_query("SELECT * FROM thread");
while (
$rowmysql_fetch_array($query)) 
{

$lastpost vbdate($dateformat,$row['lastpost']);
.
.
.
echo 
"$lastpost<br>";



But the dates don't appear...
Reply With Quote
  #4  
Old 07-24-2003, 04:01 PM
NTLDR's Avatar
NTLDR NTLDR is offline
Coder
 
Join Date: Apr 2002
Location: Bristol, UK
Posts: 3,644
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Firstly, if you including vB's global.php then there is no need to use mysql_query, use the builtin MySQL functions that coem with vB

PHP Code:
$threads $DB_site->query("SELECT * FROM thread"); 
while(
$thread =$DB_site->fetch_array($threads)) { 

    
$lastpost vbdate($dateformat$thread['lastpost']); 

    echo 
"$lastpost<br />"


If this code is in a function then make sure you have:

PHP Code:
global $DB_site$timeformat$dateformat
Also note that if the page is outputing templates then the echo isn't likly to output anything to the browser.
Reply With Quote
  #5  
Old 07-24-2003, 04:09 PM
inthezone inthezone is offline
 
Join Date: Feb 2003
Posts: 31
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Today at 01:01 PM NTLDR said this in Post #4
Firstly, if you including vB's global.php then there is no need to use mysql_query, use the builtin MySQL functions that coem with vB

PHP Code:
$threads $DB_site->query("SELECT * FROM thread"); 
while(
$thread =$DB_site->fetch_array($threads)) { 

    
$lastpost vbdate($dateformat$thread['lastpost']); 

    echo 
"$lastpost<br />"


If this code is in a function then make sure you have:

PHP Code:
global $DB_site$timeformat$dateformat
Also note that if the page is outputing templates then the echo isn't likly to output anything to the browser.

I am using global.php on this page for user identification purposes, but the above code doesn't print out the dates. Does the page automatically recognize vbdate() when you require global.php?
Reply With Quote
  #6  
Old 07-24-2003, 04:18 PM
NTLDR's Avatar
NTLDR NTLDR is offline
Coder
 
Join Date: Apr 2002
Location: Bristol, UK
Posts: 3,644
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes, if you haven't included global.php you will see and error saying something saying call to undefined function vbdate() on line x in file x.php.

Are you using echo/print and HTML within the PHP file or are you using templates for the page?
Reply With Quote
  #7  
Old 07-24-2003, 04:27 PM
inthezone inthezone is offline
 
Join Date: Feb 2003
Posts: 31
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Today at 01:18 PM NTLDR said this in Post #6
Yes, if you haven't included global.php you will see and error saying something saying call to undefined function vbdate() on line x in file x.php.

Are you using echo/print and HTML within the PHP file or are you using templates for the page?

I'm using HTML/PHP rather than the vB templates for the page. The site is separate from the forum content-wise (aside from displaying recent threads), but is integrated with the vB user database via global.php, and most of the pages are structured like this:

PHP Code:
chdir('./vB/');
require(
'global.php');
require (
'header.php');

if (
$bbuserinfo['userid']>0)
{
// Page content
}

if (
$bbuserinfo['userid']==0)
{
echo 
"You must be registered to view this page. Please login or register";
}

require (
'footer.php'); 
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 09:46 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.04012 seconds
  • Memory Usage 2,236KB
  • Queries Executed 13 (?)
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
  • (7)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)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_postinfo_query
  • fetch_postinfo
  • 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