vBshout Automatic Pruning *ALL VERSIONS*

[Distance]

vBshout Automatic Pruning

NOTE: Does not work with Inferno vBshout


What does it do?

This addon will automatically prune (remove all shouts) from the vBshout Shoutbox.

*You can set the time when the product will prune the Shoutbox.


How do I get vBshout?

vBshout 2.0 (https://vborg.vbsupport.ru/showthread.php?t=93097)
vBshout 2.1 (http://www.vbhackers.com/f76/ajax-flatfile-vbshout-2-1-a-4536)


.: Installation :.


1. Upload pruneshout.php to your /includes/cron/ folder
2. Import the product product-shoutbox_prune.xml



.: Upgrading :.

Upgrading from 1.0 / 1.0

1. Upload and overwrite /includes/cron/pruneshout.php
2. Import the product product-shoutbox_prune.xml (Make sure overwrite is turned on)


.: Configuration :.


By default the shoutbox will prune every Sunday night at 11.59pm

If you wish to change this proceed to the following steps.


1. On your admincp find Scheduled Tasks. Expand the group and then click on Scheduled Task Manager
2. Find Shoutbox Pruning and select Edit from the dropdown menu, then click go.
3:

You can change the settings to whatever you want.

Note: * means every. So if you had it as Hour: * then it would run every hour.

Get the idea?

4. Once you have finished click save



.: Version History :.

1.0: Initial Release2.0: Bug fix & after prune message
1.10: Bug fix and after-prune message.
1.20: Fixed table prefix for maximum compatibility

View Release Notes (https://vborg.vbsupport.ru/showthread.php?p=1243347#post1243347)


.: Future Releases :.

Direct link in admincp to prune the shoutboxThanks
Distance


Note: This has been tested with vBshout 2.0 and 2.1. Please backup your forums before installing this mod. I say this so I am not liable for any data loss etc although that situation is EXTREMELY unlikely.

[Distance]

.: v1.0 Release Notes :.

In vBshout 2.1 Only!!

Because vBshout 2.1 is a file based shoutbox when the the Cron script runs to prune the Shoutbox the database will clear the shouts however the file will still have the shouts stored.
Even though the shouts have been cleared the shoutbox will not update until a new shout is made.
I plan to release a version that will also clear the html file soon.

.: v1.10 Release Notes :.

Original bug fixed.
When the shoutbox prunes it will display a message saying the shoutbox has been successfully pruned.

.: v1.20 Release Notes :.

Fixed table prefix for maximum compatibility

[Hornstar]

hey nice work, look forward to the one that will clear the html file as well, will install it later on. thanks.

[Distance]

Yeah its because its a flatfile system.. Annoying eh :)

Please click install :)

[Mrdby]

working anybody?

[Distance]

There is no reason whatsoever why this should not work unless you do not have vBshout installed.

[bitdefuser]

It would be nice if after it prunes it would say, "Weekly Shoutbox Prune Complete" in the shoutbox.
Edit: And would include the next time for cleanup but, that's not really necessary.

[Distance]

I was going to implement something where it adds the message

'The shoutbox will auto prune in x minutes.. etc'

I suppose I could add a message for after the prune aswel

[bitdefuser]

Because vBshout 2.1 is a file based shoutbox when the the Cron script runs to prune the Shoutbox the database will clear the shouts however the file will still have the shouts stored. Even though the shouts have been cleared the shoutbox will not update until a new shout is made. I plan to release a version that will also clear the html file soon.

Problem solved with my suggestion. :p

[Distance]

I have already solved the problem :)

The problem was making sure it was compatible with both versions 2.0 and 2.1. It was surprisingly easier than what I thought considering they are two totally different systems.

Pending final testing and possibly another feature implemented the new v1.10 will be released tomorrow evening.

Distance

[LouiseDM]

installed :)

[Distance]

.: v1.10 Release Notes :.

Original bug fixed.
When the shoutbox prunes it will display a message saying the shoutbox has been successfully pruned.

[D.Ilyin]

Thank's for update!
BTW Distance is it any chance to do the following:
NOT delete, but rename shouts file (i'm talking about 2.1 version) and create new empty file?

[Distance]

You have the concept of the flatfile system wrong.

This is how it works:

The shoutbox reads from the html file
When a new shout is made it is sent to the database
The database updates the html file

This way everytime someone loads up the shoutbox it only has to read a small html file (with only the latest X shouts stored) without having to bring up the whole shout table.

There would be a way but for the amount of people who would use it it isn't worth the hasstle.

Distance

[Mrdby]

3.6.6?

[Distance]

The vB version says 3.6.X.

This means it will work with all versions of vBulletin 3.6

Distance

[vB Nova]

To make it work for the flatfile version just nick the function out of the vbshout.php file and include it into the cron file. Then it's just a case of running the function to rebuild the .html file.

[Distance]

I worked with the creator to make this.. This is the best way to do it ;)

[itsblack]

Is it possible to only prune the messages which are X days old?

[Distance]

Not with this modification, no.

[iCafe]

$vbulletin->db->query("TRUNCATE TABLE `shout`");

it error for any board db use TABLE_PREFIX

fix it to

$vbulletin->db->query("TRUNCATE TABLE `" . TABLE_PREFIX . "shout`");

[TechDawg]

it error for any board db use TABLE_PREFIX

fix it to

Thanks, this fixed my error :)

[Distance]

Thanks, I will update later. :)

[YukonMaster]

Double Post

[YukonMaster]

Database error in vBulletin 3.6.7:

Invalid SQL:
TRUNCATE TABLE `shout`;

MySQL Error : Table 'yukonadm_vbforum.shout' doesn't exist
Error Number : 1146
Date : Saturday, June 16th 2007 @ 01:39:56 AM
Script : http://www.pcitechforums.com/forum/admincp/cronadmin.php?do=runcron&cronid=19
Referrer : http://www.pcitechforums.com/forum/admincp/cronadmin.php?do=modify
IP Address : 70.66.140.217
Username : YukonMaster
Classname : vb_database



What do I do?

[Distance]

Update: v1.20 released

Fixed table prefix for maximum compatibility.

Distance

[YukonMaster]

What do I do?


Heya, Distance, will the update fix this issue?

[Distance]

Yes, it should fix the issue. :)

[unicorn2433]

Will this move the shouts to a forum on the board?