Method for deleting trackback error

[peppolone]

I think we can remove all the contents of the table _trackbacks once they were sent, but for now I wrote a script to remove only those with status error (similar to http://forums.pligg.com/pligg-mods/1...d-stories.html)

STEP 1:

Open admin_links_center.tpl and add the following:

<img src="{$my_pligg_base}/templates/{$the_template}/images/template_edit.png" align="absmiddle"/> <a href="admin_links.php" onclick="javascript:window.open('admin_delete_trackback.php', 'resultwindow', 'width=300, height=200')">Remove Trackback error</a><br/>

STEP 2:

Create a file called "admin_delete_trackback.php" in the root and add the following:

<?php
include_once('Smarty.class.php');
$main_smarty = new Smarty;

include('config.php');
include(mnminclude.'html1.php');
include(mnminclude.'link.php');
include(mnminclude.'user.php');
include(mnminclude.'smartyvariables.php');
			
// require user to log in
force_authentication();

// restrict access to god only
$amIgod = 0;
$amIgod = $amIgod + checklevel('god');
$main_smarty->assign('amIgod', $amIgod);

$canIhaveAccess = 0;
$canIhaveAccess = $canIhaveAccess + checklevel('god');
$canIhaveAccess = $canIhaveAccess + checklevel('admin');

if($canIhaveAccess == 0){	
	$main_smarty->assign('tpl_center', $the_template . '/admin_templates/admin_access_denied');
	$main_smarty->display($the_template . '/pligg.tpl');		
	die();
}
function delete_trackback_error($trackback) {
    $query="SELECT * FROM " . table_trackbacks . " WHERE trackback_id = '$trackback'";
    if (! $result=mysql_query($query)) {die (mysql_error());}
    else {$sql_array = mysql_fetch_object($result); }
    $query="DELETE FROM " . table_trackbacks . " WHERE trackback_id = '$trackback'";
    if (! $result=mysql_query($query)) {die (mysql_error());}
	}
$sql_query = "SELECT * FROM " . table_trackbacks . " WHERE trackback_status = 'error'";
$result_trackback_errors = mysql_query($sql_query);
$num_rows = mysql_num_rows($result_trackback_errors);
		while($trackback_error = mysql_fetch_object($result_trackback_errors))
		{
			delete_trackback_error($trackback_error->trackback_id);
		}
echo $num_rows. " Deleted Trackbacks";
?>

Now my table go from 7,8MB to 4,8MB