vb.org Archive
Page 4 of 6 « First 23 4 56
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Auto Delete Move Threads After X Day (https://vborg.vbsupport.ru/showthread.php?t=113324)

TheProphet 07-18-2006 06:54 PM
Is this removing sticky threads aswell ?

Simplicity 08-03-2006 07:37 AM
How would I go about setting this hack up so that it moves a thread which has replies but not been active for 14 days?

Simplicity 08-19-2006 11:21 AM
Just to clarify, this moves a thread which has had no reply posts at all or moves a thread which has had replies but not for x days?

louis_chypher 08-19-2006 11:29 PM
Quote:
Originally Posted by Simplicity
Just to clarify, this moves a thread which has had no reply posts at all or moves a thread which has had replies but not for x days?
The query is
Code:
SELECT * from `" . TABLE_PREFIX . "thread`
                                                Where  forumid  =" . $forumid_from . " AND `postuserid` NOT IN (".$vbulletin->options['Admin'].") AND `dateline` <= '" . (TIMENOW - ( 45 * 86400)) . "'");
Which is a selection of threads that have not had any activity for, in the case of this query, 45 days. Those selected threads are the threads that are moved.

louis_chypher 08-19-2006 11:40 PM
I changed the move code, starting at line 11 to:

Code:
//comma delimited
$from=$vbulletin->options['forumids'];

// do not edit below
if ($vbulletin->options['automovemode'])
{

        //if $from is empty then do not continue
        if (!(empty($from)))
        {
                $array_from=split(",",$from);
               
                //comma delimited
                $to=$vbulletin->options['forumarchive']; //retrive the forum archive ID's                                                                 
                $array_to=split(",",$to); //split the forum archive id on the ","
                $i=0;
                $arraycount=count($array_to); //get the count of the array
                $default_to=$array_to[$i];        //place the first array item into storage
                                                                        //the first array item is the default forum id to use in case
                                                                        //any forum id place hodler are blank
               
                //do not do if $default_to is empty
                if (!(empty($default_to)))
                {
               
                        echo $to . " in if statement</ br>";
       
                        foreach($array_from as $forumid_from)
                        {
       
                                echo "retreiving forum info for forum: " . $forumid_from;
       
                                //select a single forum ID to move
                                $check=$vbulletin->db->query_read("
                                        SELECT * from `" . TABLE_PREFIX . "thread`
                                                Where  forumid  =" . $forumid_from . " AND `postuserid` NOT IN (".$vbulletin->options['Admin'].") AND `dateline` <= '" . (TIMENOW - ( 45 * 86400)) . "'");                         
       

                                while ($check2 = $vbulletin->db->fetch_array($check))
                                {                               
                                        require_once('./includes/functions_databuild.php');               
                                        $threadman=&datamanager_init('Thread', $vbulletin, ERRTYPE_ARRAY, 'threadpost');
                                        $threadman->set_existing($check2);
                                        $threadman->set('forumid', $array_to[$i]);
                                        $threadman->set('sticky', 1);
                                        $threadman->save();
                                        build_forum_counters($check2['forumid']);
                                        if ($array_to[$i] == "")
                                                {build_forum_counters($default_to);}
                                        else
                                                {build_forum_counters($array_to[$i]);}
                                        echo "Auto Move Threads:<i>".$check2[title]."</a></i><br>";
                                        log_cron_action('Auto Move Threads', $nextitem);
                                }

                                //if only one archive place desired then do not increment forum_to index       
                                if ($arraycount > 1)
                                {$i +=1;}       
                        }
                }       
        }
}
What I get with the code change is I can move multiple target forums to their own spicific destination forums.

Such as in the options for Effected Forums if I entered 1,2,3,4
and in Archive Forums I put 20,21,,21

Then forums 1 and 3 gets moved to forum 20 and forums 3 and 4 gets moved to forums 21

If I entered Effected Forums if I entered 1,2,3,4
and in Archive Forums I put 20 then all forums get moved into 20

enojoy!

HaMaDa4eVeR 08-27-2006 07:01 AM
Quote:
Is this removing sticky threads aswell ?
I think that
Quote:
How would I go about setting this hack up so that it moves a thread which has replies but not been active for 14 days?
[IMG]https://vborg.vbsupport.ru/attachment.php?
attachmentid=47281&stc=1&thumb=1&d=[/IMG]
it only move/delete in X days and the thread that have 0 post ,

HaMaDa4eVeR 08-27-2006 07:03 AM
Quote:
Just to clarify, this moves a thread which has had no reply posts at all or moves a thread which has had replies but not for x days?
it move thereads has zero reply in X days ago

HaMaDa4eVeR 08-27-2006 07:05 AM
Good Jop, louis_chypher

Dj. Gargamel 10-10-2006 07:35 PM
when I am trying to use this mod manually though cp - cron (hard deletion settings) I am getting this error
Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT * FROM `vbulthread` Where forumid IN(96 , 97) AND `replycount` = '0' AND `postuserid` NOT IN () AND `dateline` <= '1160512459';

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `dateline` <= '1160512459'' at line 1
Error Number : 1064
Date : Tuesday, October 10th 2006 @ 10:34:19 PM
Script : http://www.americasarmy.pl/forum/adm...cron&cronid=25
Referrer : http://www.americasarmy.pl/forum/adm....php?do=modify
IP Address : xx.xx.xx.xx
Username : Dj. Gargamel
Classname : vb_database

using soft deletion is working correctly

RidinHighSpeeds 10-13-2006 12:47 AM
It didn't say in the readme file, but should I create a new scheduled task for this hack??


All times are GMT. The time now is 07:12 AM.
Page 4 of 6 « First 23 4 56
Show 40 post(s) from this thread on one page

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.01390 seconds
  • Memory Usage 1,757KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete