관리-도구

편집 파일: addprefix.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(); ?>