Auto close discussion after an expiration date.



Read the documentation very carefully.

First before you do anything. Download, install and enable jQuery ext

Now download, extract and copy this extension in your extension Folder

Enable Discussion Expiration. refresh page
You will see a new Heading under "Extension Options" called Discussion Expiration
Click on it and select the Categories you want the Discussion to expire.


Just because you have the ability to choose all the categories doesn't mean you have to. Think long and hard about which categories should have this capability. If you have a category about Events, then this will be perfect for it.
There is a permission you can set that will allow members of a particular role to expire all discussion in any categories. This is for Moderators and admins. Set the permission in Roles & Permissions page

When you create a new Discussion and select the appropriate category, you will see a new date field appear.


Use the included Date Picker to pick an expiration date.


Once the expiration date has passed the Discussion will be automatically closed.
The discussion isn't deleted, hence it can still be searched.

---

Support this extension

Can you please tell me what the 'expiration' actually is? Does the discussion get closed or deleted? Thanks.

I love it man! Thanks for stepping up to the request.

try loggin in as admin.
let me know what happens.
seems to be working on my comp

in Line 84 of default.php I'm using this
if ($Context->Session->User->RoleID != 4 ) { //User is not admin
remove it if u want the old behaviour back.

if ur the admin then the appearing disappearing is disabled. so u can expire all discussions
If ur not the admin then the appearing disappearing act is done.

ok done. the admin can select the role that should not have the category restrictions.

Uploaded version 1.0.2 of Discussion Expiration.

OK I'll do that right now.
have to fix the blog extension to use $Context->Configuration[$PermissionKey] as well

Why let the expiration date follow the discussion title?Just like

Update Discussion Expiration 1.0.3 expired @ June 6,2007

Thanks! Its a great extension and I can't wait to implement it

I don't get the date picker showing - using MAMP on localhost, so maybe its because of that...

Is it possible to get a list of the closed discussions, then have the option to delete them?

Hi, thanks for the reply. I use Safari on OSX with MAMP as a localhost.

The date picker does not display in FF either - I assumed it might be the relative paths or something like that, but in FF, Firebug gives this error:

$(".date-pick") has no properties
[Break on this error] $(".date-pick").datePicker();

JQuery 1.1.6 is what I have - and yes, its enabled. I have JQThickBox too and that works fine, so I don't think its jQuery.

Don't know about a conflict with another extension - but its not just Safari, the date picker does not show in Firefox either.

Edit: I have this issue too with another extension:
Discussion Tags # 20

Maybe its related?

Yes, it was. I shall remove jQuery and try again, then report back..

Edit: No change after removing, then replacing jQuery (and enabling it first)

Bump...

Great! thanks

yes it is.
Any one knows of javascript debugging tools for IE6?

open default.php.
change line 88 to this
$jde(".date-pick").datePicker();


anything else broken or not.

ok Line 110
change it to this
$jde(document).ready(function(){
$jde("select.CategorySelect").change(function(){Toggle();});
Toggle();
});

Okay, I've installed the latest jQuery ext - installed it prior to this install - and still, all I see is this:
===============
Below is a list of open discussions with their respective expiration dates.
There are no "open" discussions pending expiration.
===============

"open" is underlined.

Oh.. okay, I see it now. Only the person who starts a discussion, can set the expiration date. Is there any way for the admins to do this category-wide?

Also, how can I modify the script to delete instead of close?

Thanks btw for the reply..

Thanks again.. okay, I have checked that permission.. but how do I (admin) go about expiring a discussion category-wide?

I mean, as it is, an admin could edit any discussion and apply an expiration date... but is there a way to apply the expiration to an entire category with one click?

Okay, thanks.

Can I modify the script to delete instead of close?

I can add expiring entire categories feature, if you can tell me how are you going to use it. Why do you need this feature?

One useful feature would be to add a default expiring of categories.
For eg. By default expire all new discussions after 30 days of creation if they belong to a specific category
However, what use will that be? an example scenario will be usefull

Did the latest update cause this problem or you never got it working anyway
you can try line 24 in default.php to this
$query = "ALTER TABLE `".$Configuration['DATABASE_TABLE_PREFIX']."Discussion` ADD `DateExpire` date NOT NULL default '0000-00-00';";


I doubt that will fix it cause you already have altered the table, can you check your database and check what default values are being entered for DateField
Btw when does the error actually occur