Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 11-13-2005, 02:48 PM
cd1986 cd1986 is offline
 
Join Date: Sep 2005
Location: UK
Posts: 79
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Move thread x days after FIRST post made

I have a downline builder section in my forum, and would like to automate the process of threads being moved from there to the "trash can" forum after 7 days. Is this possible? I know that you can move a thread x days after the last post was made, but i don't want to do that - id like it to be moved 7 days after the first post was made, irrespective of how many replies there have been since.

PHP Code:
 <?php 
error_reporting
(E_ALL & ~E_NOTICE);
if (
$DB_site == NULL)
{
exit;
}
global 
$DB_site;
 
$movedate strtotime("now -7 days");
$fromforuma="46";
$toforuma="47";
 
$DB_site->query("
UPDATE " 
TABLE_PREFIX "thread 
SET forumid = 
$toforuma 
WHERE lastpost <= 
$movedate
AND forumid = 
$fromforuma
"
);
 
log_cron_action('Auto Move Threads'$nextitem);
?>
That's the code used in a move 7 days after last post was made cron (taken from a mod from trafix), but can i modify this easily to use the firstpost as a starting point? I assume you must have to change "lastpost" to do this, but the closest i can find is "firstpostid" which i don't think is correct...
Reply With Quote
  #2  
Old 11-13-2005, 07:02 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PHP Code:
WHERE dateline <= $movedate 
You will have to update your script for vB3.5 also.
Reply With Quote
  #3  
Old 11-13-2005, 07:23 PM
cd1986 cd1986 is offline
 
Join Date: Sep 2005
Location: UK
Posts: 79
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MarcoH64
PHP Code:
WHERE dateline <= $movedate 
You will have to update your script for vB3.5 also.
Thanks, i will do that now.
Reply With Quote
  #4  
Old 03-11-2006, 04:18 PM
Sculli's Avatar
Sculli Sculli is offline
 
Join Date: Nov 2005
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Is there anyone who could kindly provide the updated version for 3.5 as well as point out a way to exclude stickies from being moved? Thank you so much in advance.
Reply With Quote
  #5  
Old 03-18-2006, 03:14 AM
Sculli's Avatar
Sculli Sculli is offline
 
Join Date: Nov 2005
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Somebody saaaave me ...
Reply With Quote
  #6  
Old 04-05-2006, 06:38 AM
Sculli's Avatar
Sculli Sculli is offline
 
Join Date: Nov 2005
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Anyone? Please.
Reply With Quote
  #7  
Old 04-30-2006, 06:57 PM
Sculli's Avatar
Sculli Sculli is offline
 
Join Date: Nov 2005
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

bump
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 06:31 PM.


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.05138 seconds
  • Memory Usage 2,220KB
  • 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
  • (3)bbcode_php
  • (1)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