Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions

Reply
 
Thread Tools Display Modes
  #11  
Old 02-18-2003, 12:57 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hmm try this.
open admin/functions.php
find:
PHP Code:
// ##################### Save birthdays into template ###################
function getbirthdays() {
  global 
$timeoffset$DB_site;

  
$btoday date("Y-m-d",time()+(-12-$timeoffset)*3600) . '|||';
  
$btoday .= date("Y-m-d",time()+(12-$timeoffset)*3600) . '|||';

  
$todayneggmt date("m-d",time()+(-12-$timeoffset)*3600);
  
$todayposgmt date("m-d",time()+(12-$timeoffset)*3600);

  
$bdays $DB_site->query("SELECT username,userid,birthday
                            FROM user
                            WHERE birthday LIKE '%-
$todayneggmt'
                              OR birthday LIKE '%-
$todayposgmt'"); 
and change to:
PHP Code:
// ##################### Save birthdays into template ###################
function getbirthdays() {
  global 
$timeoffset$DB_site;

  
$btoday date("Y-m-d",time()+(-12-$timeoffset)*3600) . '|||';
  
$btoday .= date("Y-m-d",time()+(12-$timeoffset)*3600) . '|||';

  
$todayneggmt date("Y-m-d",time()+(-12-$timeoffset)*3600);
  
$todayposgmt date("Y-m-d",time()+(12-$timeoffset)*3600);

  
$bdays $DB_site->query("SELECT username,userid,birthday
                            FROM user
                            WHERE birthday = '
$todayneggmt'
                              OR birthday = '
$todayposgmt'"); 
Reply With Quote
  #12  
Old 02-18-2003, 01:55 PM
pifemaster pifemaster is offline
 
Join Date: Feb 2003
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Xenon,

I made the change, when I went to my calendar the date still shows up under "each year". When I went to my profile & attempted to change my date to "February 18, 2003" it gave me the following error message:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT username,userid,birthday
FROM user
WHERE birthday = 2003-02-17'
OR birthday = 2003-02-18'
mysql error: You have an error in your SQL syntax near ''
OR birthday = 2003-02-18'' at line 3

mysql error number: 1064

Any ideas.

Thank you,
Robert Pfeifer
Reply With Quote
  #13  
Old 02-18-2003, 02:09 PM
pifemaster pifemaster is offline
 
Join Date: Feb 2003
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Xenon,

I reinstalled the "original" backup I made of "admin/functions.php" and the error goes away. But date shows up on home page of forum & on calendar for every year.

Thank you,
Robert Pfeifer
Reply With Quote
  #14  
Old 02-18-2003, 06:41 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

you've made an mistake and deletete the single ' in front of the $today...
Reply With Quote
  #15  
Old 02-18-2003, 07:08 PM
pifemaster pifemaster is offline
 
Join Date: Feb 2003
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Xenon,

You were very correct. I did screw up & miss the '

I uploaded the new file & now the birthdate does not show up on the home page at all (even if the year is current) & still shows up on the calendar for each year.

Thank you,
Robert Pfeifer
Reply With Quote
  #16  
Old 02-18-2003, 07:11 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hmm weird...

don't have any further ideas..
Reply With Quote
Reply

Thread Tools
Display Modes

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 10:11 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.03782 seconds
  • Memory Usage 2,219KB
  • 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
  • (2)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete