Emptying a table?

[Cybertims]

Is there an easy way to create a link that when clicked will empty a database table??

I use the ChatBox light and want MODS to be able to prune it easily without actually having to have access to the Database.

The table is called chatboxlite_shout

Cheers in advance.

[RS_Jelle]

That's the TRUNCATE command

[SQL]TRUNCATE TABLE `chatboxlite_shout`;[/SQL]

[Cybertims]

Originally Posted by RS_Jelle

That's the TRUNCATE command

[SQL]TRUNCATE TABLE `chatboxlite_shout`;[/SQL]

Cheers for that.....but to be honest it doesnt really help me too much as I have no idea how to use this to create a link that would enable my MODS to empty this said table....thanks though.

[RS_Jelle]

In vBulletin sql code it becomes:

PHP Code:

$result = $db->query_write("TRUNCATE TABLE `" . TABLE_PREFIX . "chatboxlite_shout`"); 


You need to put it on a seperate page (for example yourmod.php?do=empty) and check for the permissions (so normal users can't use it). Those things are explained here

[rogersnm]

If you want it in full do something like:
1) Make a file called chatbox.php
2) Put this as it's contents:

PHP Code:

<?php
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('THIS_SCRIPT', 'chatbox');

// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();

// get special data templates from the datastore
$specialtemplates = array();

// pre-cache templates used by all actions
$globaltemplates = array();

// pre-cache templates used by specific actions
$actiontemplates = array();

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');

// #######################################################################
// ######################## START MAIN SCRIPT ############################
// #######################################################################
if (empty($_REQUEST['do']))
{
    $_REQUEST['do'] = 'empty';
}


if ($_REQUEST['do'] == 'empty')
{
    if (can_moderate())
    {
        $vbulletin->db->query_write("TRUNCATE TABLE chatboxlite_shout");
    }
    else
    {
        print_no_permission();
    }
}
?>

and then only people who can moderate will be able to use it.