Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Details »»

Version: , by eiko (Guest)
Developer Last Online: Jan 1970 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 05-02-2001 Last Update: Never Installs: 0
 
No support by the author.

Today's Posts in place of latest...

1) By calendar date (ie Today)
2) Sorted by Category
3) Post time (not alpha on the subject
4) Shows total post count for today

Does not jump to the actual post in a thread, but rather the top of the thread.

This is a standard feature of the UBB, miss it dearly, members dogging me for it.

Someone? Purdy please?

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 05-04-2001, 07:44 PM
eiko
Guest
 
Posts: n/a
Default

Anyone? Please?
Reply With Quote
  #3  
Old 05-04-2001, 08:08 PM
Overgrow's Avatar
Overgrow Overgrow is offline
 
Join Date: Nov 2001
Posts: 320
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PHP Code:
$startToday strtotime(date("m/d/y",time()));
$endToday = ($startToday 86400);

$query "SELECT COUNT(threadid) as count,title,**ETC**";
$query .= " FROM THREAD";
$query .= " WHERE lastpost > '$startToday' AND lastpost < '$endToday'";
$query .= " ORDER BY forumid,lastpost DESC"
Is that enough to get you started?
Reply With Quote
  #4  
Old 05-04-2001, 08:20 PM
eiko
Guest
 
Posts: n/a
Default

thanks...

I'll have to spend more time getting into php... been so long with perl... trying to do too much too soon I guess.
Reply With Quote
  #5  
Old 05-04-2001, 08:43 PM
Overgrow's Avatar
Overgrow Overgrow is offline
 
Join Date: Nov 2001
Posts: 320
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I started with PERL and went to PHP after a year or so (same reason, UBB to VB). It's SO MUCH NICER when programming for the web. Get into it, you won't regret it. I'll break this down a bit for you..

$startToday?=?strtotime(date("m/d/y",time()));

strtotime is a built in PHP function, if you ever wonder if something is built in and what it does, go to

www.php.net/strtotime

or whatever the function name is, and you will get the info.


date is also a built in php function, as well as time...

Bascially I'm pulling the current timestamp with time(), formatting it with date, and then translating that BACK into a timestamp with strtotime. The key there is that when I do the first conversion, I don't use the hour:minutes so eventually it returns the timestamp of TODAY at 12:01 AM.

After that, I add 86400 seconds to it to make the endToday timestamp = tomorrow.

Then I build the SQL query.. After you finish writing the query, do something like

PHP Code:
$results mysql_query($query,$db_connection);

while ( 
$row mysql_fetch_array $results ) ) {

print 
"<a href=\"showthread.php?threadid=$row[threadid]\">$row[title]</a>";


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 12:47 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04085 seconds
  • Memory Usage 2,240KB
  • Queries Executed 20 (?)
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
  • (2)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (4)postbit
  • (2)postbit_onlinestatus
  • (5)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
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • postbit_imicons
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete