Untitled

<html><head><style>
body
{
    width: 100%;
    height: 100%;
    padding: 0px;
    margin: 0px;
    border: 0px;
    color: #000000;
    font: 11px/20px verdana, arial, sans-serif;
    background: #001930 url('./images/background_wrap.png') no-repeat center;
}
</style>
<body>
<div style="margin: auto; margin-top: 20px; background: #fff; width: 800px; padding: 20px;">
<?php
$host = 'localhost';
$user = 'xx';
$pass = 'xxx';
$name = 'main_world';
$name_trigger = 'main_world_trigger';
$type = 'DELETE';

mysql_connect($host, $user, $pass);
mysql_select_db($name);

$tables = mysql_list_tables($name);
while($row = mysql_fetch_array($tables))
{
    $query[$row[0]]['table_name'] = $row[0];
    $query[$row[0]]['trigger_delete'] = "DROP TRIGGER IF EXISTS `{$row[0]}_delete`;";
    $query[$row[0]]['trigger_update'] = "DROP TRIGGER IF EXISTS `{$row[0]}_update`;";

    // DELETE STRUCTURE TABLE
    $i = 0;
    $query[$row[0]]['create_delete'][$i] = "DROP TABLE IF EXISTS `{$name_trigger}`.`{$row[0]}_delete`;";
    $query[$row[0]]['create_delete'][$i+1] = "CREATE TABLE `{$name_trigger}`.`{$row[0]}_delete` (";
    $i = 2;

    $fields_show = mysql_query("SHOW FIELDS FROM `{$row[0]}`");
    $num_fields = mysql_num_fields(mysql_query("SELECT * FROM `{$row[0]}` LIMIT 1"));
    $nf = 0;
    while($fields = mysql_fetch_array($fields_show))
    {
        $nf++;
        $query[$row[0]]['create_delete'][$i] .= "    {$fields['Field']} {$fields['Type']}";

        if (!empty($fields['Default']))
            $query[$row[0]]['create_delete'][$i] .= " DEFAULT '{$fields['Default']}'";
        if ($fields['Null'] != 'Yes')
            $query[$row[0]]['create_delete'][$i] .= " NOT NULL";
        if (!empty($fields['Extra']))
            $query[$row[0]]['create_delete'][$i] .= " {$fields['Extra']}";

        if($nf <= $num_fields)
            $query[$row[0]]['create_delete'][$i] .= ",";

        $i++;
    }

    $query[$row[0]]['create_delete'][$i] = "    trigger_date TIMESTAMP NOT NULL";
    $i++;
    $query[$row[0]]['create_delete'][$i] = ");";

    // UPDATE STRUCTURE TABLE
    $i++;
    $query[$row[0]]['create_update'][$i] = "DROP TABLE IF EXISTS `{$name_trigger}`.`{$row[0]}_update`;";
    $i++;
    $query[$row[0]]['create_update'][$i] = "CREATE TABLE `{$name_trigger}`.`{$row[0]}_update` (";
    $i++;

    $fields_show = mysql_query("SHOW FIELDS FROM `{$row[0]}`");
    $num_fields = mysql_num_fields(mysql_query("SELECT * FROM `{$row[0]}` LIMIT 1"));
    $nf = 0;
    while($fields = mysql_fetch_array($fields_show))
    {
        $nf++;
        $query[$row[0]]['create_update'][$i] .= "    {$fields['Field']} {$fields['Type']}";

        if (!empty($fields['Default']))
            $query[$row[0]]['create_update'][$i] .= " DEFAULT '{$fields['Default']}'";
        if ($fields['Null'] != 'Yes')
            $query[$row[0]]['create_update'][$i] .= " NOT NULL";
        if (!empty($fields['Extra']))
            $query[$row[0]]['create_update'][$i] .= " {$fields['Extra']}";

        if($nf <= $num_fields)
            $query[$row[0]]['create_update'][$i] .= ",";

        $i++;
    }

    $query[$row[0]]['create_update'][$i] = "    trigger_date TIMESTAMP NOT NULL";
    $i++;
    $query[$row[0]]['create_update'][$i] = ");";

    // ---------------------------------------
    $i = 0;
    $query[$row[0]]['create_trigger_delete'][$i++] = "CREATE TRIGGER `{$row[0]}_delete` BEFORE DELETE ON `{$name}`.`{$row[0]}`";
    $query[$row[0]]['create_trigger_delete'][$i++] = "FOR EACH ROW";
    $query[$row[0]]['create_trigger_delete'][$i++] = "BEGIN";
    $fields_show = mysql_query("SHOW FIELDS FROM `{$row[0]}`");
    $st = 0;
    $i++;
    while($fields = mysql_fetch_array($fields_show))
    {
        if($st == 0)
        {
             $query[$row[0]]['create_trigger_delete'][$i] = "INSERT INTO `{$name_trigger}`.`{$row[0]}_delete`(";
             $st++;
        }

        $query[$row[0]]['create_trigger_delete'][$i] .= " {$fields['Field']},";
    }
    $query[$row[0]]['create_trigger_delete'][$i] .= " trigger_date) VALUES(";

    $fields_show = mysql_query("SHOW FIELDS FROM `{$row[0]}`");
    $st = 0;
    while($fields = mysql_fetch_array($fields_show))
        $query[$row[0]]['create_trigger_delete'][$i] .= " OLD.{$fields['Field']},";

    $query[$row[0]]['create_trigger_delete'][$i] .= " NOW());";
    $i++;
    $query[$row[0]]['create_trigger_delete'][$i] = "END;";


     // ---------------------------------------
    $i = 0;
    $query[$row[0]]['create_trigger_update'][$i++] = "CREATE TRIGGER `{$row[0]}_update` BEFORE UPDATE ON `{$name}`.`{$row[0]}`";
    $query[$row[0]]['create_trigger_update'][$i++] = "FOR EACH ROW";
    $query[$row[0]]['create_trigger_update'][$i++] = "BEGIN";
    $fields_show = mysql_query("SHOW FIELDS FROM `{$row[0]}`");
    $st = 0;
    $i++;
    while($fields = mysql_fetch_array($fields_show))
    {
        if($st == 0)
        {
             $query[$row[0]]['create_trigger_update'][$i] = "INSERT INTO `{$name_trigger}`.`{$row[0]}_update`(";
             $st++;
        }

        $query[$row[0]]['create_trigger_update'][$i] .= " {$fields['Field']},";
    }
    $query[$row[0]]['create_trigger_update'][$i] .= " trigger_date) VALUES(";

    $fields_show = mysql_query("SHOW FIELDS FROM `{$row[0]}`");
    $st = 0;
    while($fields = mysql_fetch_array($fields_show))
        $query[$row[0]]['create_trigger_update'][$i] .= " OLD.{$fields['Field']},";

    $query[$row[0]]['create_trigger_update'][$i] .= " NOW());";
    $i++;
    $query[$row[0]]['create_trigger_update'][$i] = "END;";

}


foreach($query as $array)
{
    echo "##############################<br />";
    echo "# Table {$array['table_name']}<br />";
    echo "##############################<br />";
    echo $array['trigger_delete'].'<br />';
    echo $array['trigger_update'].'<br /><br />';

    foreach($array['create_delete'] as $key => $value)
    {
       echo $value.'<br />';
    }
    echo "<br /><br />";

    foreach($array['create_update'] as $key => $value)
    {
       echo $value.'<br />';
    }
    echo "<br /><br />";

    foreach($array['create_trigger_delete'] as $key => $value)
    {
       echo $value.'<br />';
    }
    echo "<br /><br />";

    foreach($array['create_trigger_update'] as $key => $value)
    {
       echo $value.'<br />';
    }

    echo "<br /><br /><br />";
}