View Single Post
  #2  
Old 12-11-2002, 03:29 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

no, it is not possible to delete thread that have not been viewed since x days, because the date of last viewing is not saved into the table...

it would require hacking of showthread.php and changes to the db...
also it would just work with new threads. threads which are not viewed till your next pruning day would become deleted, because the lastview date is too old...

question two: that would be possible, with not to much work:
open thread.php
find
PHP Code:
  doformheader("thread","prunedate");
  
maketableheader("Prune by date");
  
makeinputcode("Delete threads with last post older than x days:<BR>(intensive if deleting a lot of threads)","daysdelete","");
  
makemodchoosercode(-1,-1,'','All forums','In forum',0);

  
doformfooter(); 
change it to
PHP Code:
  doformheader("thread","prunedate");
  
maketableheader("Prune by date");
  
makeinputcode("Delete threads with last post older than x days:<BR>(intensive if deleting a lot of threads)","daysdelete","");
  
makeyesnocode("Delete just unanswered threads?","justempty",0);
  
makemodchoosercode(-1,-1,'','All forums','In forum',0);

  
doformfooter(); 
then find:
PHP Code:
  $datecut=time()-($daysdelete*86400);
  
$threads=$DB_site->query("SELECT threadid FROM thread WHERE $forumcheck thread.lastpost<=$datecut");
  while (
$thread=$DB_site->fetch_array($threads)) {
    
deletethread($thread[threadid],0);
  } 
and change it to:
PHP Code:
  $datecut=time()-($daysdelete*86400);
  
$threads=$DB_site->query("SELECT threadid FROM thread WHERE $forumcheck thread.lastpost<=$datecut".iif($justempty," AND replycount=0",""));
  while (
$thread=$DB_site->fetch_array($threads)) {
    
deletethread($thread[threadid],0);
  } 
that should work
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01566 seconds
  • Memory Usage 1,792KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete