DLE Huge database deleting outdated post problem

[downfreak]

You wanted to delete the news by last posted news or first posted news first?

just coded a quick script to do the task:

<?php
/**
 * Developer: Soft2050
 * IDE Used: JetBrains PhpStorm.
 * Date: 10/9/11
 * Time: 2:07 PM
 */

$dbhost = ''; // Enter your db host here
$dbuser = ''; // Enter db username here
$dbpass = ''; // Enter db password here'
$dbname = ''; // Enter your db name here

$connection = mysql_connect($dbhost, $dbuser, $dbpass) or die(mysqli_error());

mysql_select_db($dbname, $connection);

mysql_query("DELETE FROM `dle_post` LIMIT 1");

mysql_close($connection);

?>

Set that to cron job and it will take care of the rest!

Execute this in ssh:

1 * * * * /filepathhere.php

This will set the cron to run that script every 1 minute
Hope it helps

hey soft2050, how you been mate?
haven't seen you for ages?

by the way from the code that u just coded, is it going to delete the post which was first posted in terms of time when it was posted?

also it it going to delete infos attributed to the post like number of viewings and comments?

cheers mate