<?php


/***********************************************************************************/


/* Name:    renametables.php                                                       */


/* Author:  Gaylen Fraley aka Raven                                                */


/* Support: http://ravenphpscripts.com                                             */


/* Date:    2005-08-08                                                             */


/* Purpose: Renames all tables from current $user_prefix to $prefixNew.            */


/* Usage:   Place this script in your nuke root folder. To see what the change will*/


/*          look like, set $testRun to TRUE; Once you're satisfied that the changes*/


/*          are correct, set $testRun to FALSE; and re-execute the script.         */


/* License: Free                                                                   */


/* Warranty:None.  Proceed at your own risk.                                       */


/***********************************************************************************/


$prefixNew    = "nuke1";


$testRun      = FALSE;





/***********************************************************************************/


/* DO NOT CHANGE ANYTHING PAST THIS LINE UNLESS YOU REALLY KNOW WHAT YOU'RE DOING! */


/***********************************************************************************/


require('config.php');


$prefixOld    = $user_prefix;


$prefixOldLen = strlen($prefixOld);


$prefixNewLen = strlen($prefixNew);


mysql_connect($dbhost, $dbuname, $dbpass);


$result = mysql_list_tables($dbname);


$num_rows = mysql_num_rows($result);


for ($i = 0; $i < $num_rows; $i++) {


   if (!(substr(mysql_tablename($result, $i),0,$prefixOldLen)==$prefixOld)) continue;


   $sql = 'RENAME TABLE '.mysql_tablename($result, $i).' TO '.$prefixNew.substr(mysql_tablename($result, $i), $prefixOldLen).';';


   if (!$testRun) {


      @mysql_query($sql);


      if (mysql_error()) echo('MySQL said: '.mysql_error())."<br />";


      else echo 'Table '.mysql_tablename($result, $i).' Renamed To '.$prefixNew.substr(mysql_tablename($result, $i), $prefixOldLen)."<br />";


   }


   else echo $sql."<br />";


}


mysql_free_result($result);


?>