32 lines
994 B
PHP
32 lines
994 B
PHP
<?php
|
|
require_once dirname(__FILE__).'/accesscheck.php';
|
|
|
|
# convert the database to add the prefix
|
|
# dangerous, should not be used, particularly not if the prefix already exists
|
|
|
|
if (!$GLOBALS["table_prefix"]) {
|
|
print "No prefix defined, nothing to do";
|
|
return;
|
|
}
|
|
|
|
include "structure.php";
|
|
|
|
while (list($table,$value) = each ($DBstruct)) {
|
|
if ($table != $tables[$table]) {
|
|
Sql_Verbose_Query("drop table if exists $tables[$table]",0);
|
|
Sql_Verbose_Query("alter table $table rename $tables[$table]",0);
|
|
}
|
|
}
|
|
|
|
$req = Sql_Verbose_Query("select tablename from ".$tables["attribute"]);
|
|
while ($row = Sql_Fetch_Row($req)) {
|
|
set_time_limit(500);
|
|
if (Sql_Table_Exists("listattr_".$row[0]) && $table_prefix)
|
|
Sql_Verbose_Query("alter table listattr_$row[0] rename $table_prefix"."listattr_".$row[0]);
|
|
if (Sql_Table_Exists($table_prefix."listattr_".$row[0]))
|
|
Sql_Query("alter table $table_prefix"."listattr_".$row[0]." add column listorder integer default 0",0);
|
|
}
|
|
flush();
|
|
|
|
?>
|