Clear logs from admin panel

[manfred]

Here is mod to clear logs from admin panel and also log status is displayed. This is done because logs were left even after the hole site was deleted! Try it and send a comment.

Installation: just unzip to your PhpDig folder and open admin panel.

Note that this is only for 1.8.0 version of PhpDig!

-m-

[alivin70]

Hi,
thank you for your code.

Why you do this:

PHP Code:

$query = "SELECT l_id FROM ".PHPDIG_DB_PREFIX."logs";
$id = mysql_query($query,$id_connect);
while (list($key_id) = mysql_fetch_row($id))
       {
           $query_delete = "DELETE FROM ".PHPDIG_DB_PREFIX."logs WHERE l_id=$key_id";
           $id_del = mysql_query($query_delete,$id_connect);
           $del++;
       } 


why not a simpler:

PHP Code:

$query_delete = "DELETE FROM ".PHPDIG_DB_PREFIX."logs";
           $id_del = mysql_query($query_delete,$id_connect);
$del = mysql_affected_rows($id_connect); 


thanks
Alivin70

[manfred]

I'm not very familiar with SQL syntax (yet) and if you compare that to clean_keywords.php there is a match!

Copy&paste is too easy solution - I know but hey it works!

-m-