adminlog

[ZiG]

im having trouble resetting my adminlog, starting it over. It has like, 2 years of logs in it and I want to reset it, start it over without having to go through phpmyadmin. Any way of doing this? I thought I knew a simple way before but I cant seem to find it again

[filburt1]

Originally Posted by ZiG

im having trouble resetting my adminlog, starting it over. It has like, 2 years of logs in it and I want to reset it, start it over without having to go through phpmyadmin. Any way of doing this? I thought I knew a simple way before but I cant seem to find it again

[sql]
DELETE FROM adminlog;
[/sql]

[ZiG]

Originally Posted by ZiG

without having to go through phpmyadmin

[Alcar Lazuli]

If you are using vB3, you can use the Query section.

However, if you have vB2, you'll either have to use PHPMyAdmin, or use the prune feature found in vB2.

[Dean C]

Just make a file with this content and run it ZiG.

PHP Code:

<?php
error_reporting(7);
require("./global.php");

$query = $DB_site->query("DELETE FROM adminlog");

if($query)
{
echo 'Query ran successfully';
}
else
{
echo 'This query could not be run';
}

?>