delete many news at ones

[babsy]

HI

i have a client, who has been filling his page with news for the last 3 years, and now the page is getting slow, so i told him to start deleting old news? But it there a fast way of deleting old news (the news are on multiple pages, diff. news)?? anyone knows a fast way!

idea for next WB make the possibility to delete multible news and multible news post at the same time, maybe it would be good to just select the ones you want to delete and then pres (delete) instead of having to put one by one in the (trash)

[crnogorac081]

you can connect to DB using phpmyadmin and manualy delete all entries from news table..

[doc]

Hi,

one comment in addition to the post from crnogorac081.

You could use SQL statements from phpMyAdmin to select (or delete) all news entries older than a certain date.

Simply use something like below in phpMyAdmin to select all news entries older than yyyyyy:
SELECT * FROM `xxx_mod_news_posts` WHERE `posted_when` < 'yyyyyyyyy'

Just replace xxx_ with the prefix of your database if any and yyyyyyy with the timestamp of the first post you want keep. Use PHP date function or this online service to convert Unix timestamp into human readable format. Of course you could also write two lines of code (e.g. in a code section to get the work done).

Doc

[babsy]

thank you i will try that tomorrow!

[babsy]

This works fine.. i can delete without a problem (just have to delete the actual php page also.. through FTP

[DarkViper]

it works as long you have no comments saved for your news.. Then you must delete the corresponding comments also.
You can do it if you execute following 2 SQL-Queries after each other.:

Code:

replace xxxx with your TABLE_PREFIX
>>first execute
DELETE `t1`, `t2` FROM `xxxx_mod_news_posts` AS `t1`
INNER JOIN `xxxx_mod_news_comments` AS `t2`
WHERE `t1`.`post_id` = `t2`.`post_id` AND `t1`.`posted_when` < UNIX_TIMESTAMP( '2005-03-27 03:00:00' )

>>second execute
DELETE FROM `xxxx_mod_news_posts`
WHERE `posted_when` < UNIX_TIMESTAMP( '2005-03-27 03:00:00' )

First query will delete all posts with all attached comments
Second query will delete all other posts without comments.
The order of executing queries is very important!

The SQL-function UNIX_TIMESTAMP makes it easy to insert the timestamp. The format is:  ( 'yyyy-mm-dd hh:mm:ss' )