[tbones]

Originally Posted by tbones

Delete_storylink($linkid) needs the ID of every single story therefore I wonder whether it´s more efficient to use this function directly at Admin: Change the status.

Would it be very difficult to apply it there?

If it´s too difficult you could also change discard at Admin - News Management to delete since discard is this still available through the admin menu at the article itself (I use that in 99% of all cases).

[fingerprn]

Originally Posted by bbrian017

Hi fingerprn thanks for the quick reply on this topic! Do you recall doing any other adjustment to make it work or did you just follow the initial post?

No adjustments needed.

[bbrian017]

Would this have an affect on loading time? Also how do I remove everything from 2007 from the database!

[wnw]

works like a charm..thanks

[fingerprn]

Originally Posted by bbrian017

Would this have an affect on loading time? Also how do I remove everything from 2007 from the database!

1. Unless you have thousands of discarded stories, I doubt it would help that much. There are only two things I've found that can signifcantly speed up loading time: a more powerful server and eAccelerator (do a search for this term in the forum for more info).

2. I'm assuming you mean delete ALL stories from before 2007 and not just discarded ones since the original mod already does this. Here is an UNTESTED solution:

In admin_delete_stories.php, find:

$sql_query = "SELECT * FROM " . table_links . " WHERE link_status = 'discard'";

and replace with:

$sql_query = "SELECT * FROM " . table_links . " WHERE link_date < '2008-01-01 00:00:00'";

Hope this helps.

[autodafe]

Wonderful Hack !!!!

[bbrian017]

Hey thanks fingerprn, I will try that when I get home! But you know what I have been doing but it's a slow process!

I have searched for all queued stories and I discarded the last like 125 pages! and then I deleted all discarded stories and it seems to have worked well!


This mod is pretty cool!

[Andromedan]

Thanks a lot for this!

[longcountdown]

Excellent! 331 discarded stories deleted and the database was optimized! :-D

[tbones]

Originally Posted by tbones

I would like to appreciate the participation of the commenters so I don´t want to delete discarded stories with comments. I´d rather subsitute the title and the content of the story with "This content has been moved" as a polite message.

Could you help me with a hack for that alternative?

I´ve found a general way to preserve but not show stories and use your mod: It´s based on redwine´s work (http://forums.pligg.com/core-develop...submitted.html) and defines a new category 'hidden'.

First you have to change the database tables:

alter table your_table_name_links change link_status link_status enum('discard','queued','published','abuse','duplicated','hidden') NOT NULL default 'discard';

insert into your_table_name_totals (`name`, `total`) values ('hidden', 0);

Then you do what redwine suggested with the files /templates/yourtemplate/admin_templates/admin_links_center.tpl and admin_links.php except you change 'pending' to 'hidden'.

That´s it!