PHPFusion-mods.net | Your PHP Fusion resource - Articles: Change your database prefix.

May 17 2012 11:49:17

Navigation

Last Seen Users

J_K_NIELSEN	00:25:52
volt123	00:54:06
darans	00:54:23
Acert	01:28:15
michi	01:51:45
LukeWarm	01:55:47
Dave92	02:33:51
KasteR	02:37:41
colber	02:55:19
rubberdark	04:02:20

Members: 25,040

Newest: Dave92

Downloads v7

Currently popular Downloads
FusionBoard 4	6351
Video Gallery	4524
Video Infusion	4019
Photoalbum Mass U...	3499
Professional Down...	3403
Avatar Studio	3338
XHTML mod for mod...	3186
Button panel	2703
60 Animated smileys	2610
VArcade 2.1	2532

Latest Downloads

Code Snippets v1.10	8
Video Infusion Pro	84
Who Is Where	16
Facebook Login/Register	62
Yolks Smiley Pack	56
SWTOR Recruiting Panel	25
NeoBlog Theme	28
Code Snippets	9
FAQ Panel	15
Download Plus Panel	32

Latest 100

Downloads v6

Currently popular Downloads
Banner System v2.0.4	2269
Video Gallery	1560
Extreme Theme Editor	1257
Fuzed Shoutbox	1066
Seoname.php	1016
Icon Package 2.0	879
Extended Profile ...	782
News.php	699
Tabbed welcome panel	646
EXTboard	583

Latest Downloads

Banner System v2.0.4	2269
Last comments	102
Language switcher panel	319
Admin Submission Panel	130
Admin private messag...	253
Google Sitemap Fast	144
ExtBoard 1.2	430
EXTboard	583
v6.01.18 - v6.01.19	74
v6.01.19 FULL	240

Latest 100

Latest Articles

Patch Re-captcha PHP...

A tour through the n...

Protect your Fusion ...

Change your database...

Admin Control Panel ...

How to Secure Your I...

Show Content by Defa...

v7 | Add social book...

v7 | Custom MySQL er...

How To: A PM after r...

v7 | SEO friendly UR...

Comments Advanced Vi...

Auto-redirect to the...

A tour through PHP-F...

View all articles

Change your database prefix.

The following file will allow you to alter the table prefix used in your site.
Once this script has run you do need to alter the config.php to reflect the change.

Upload the file to your fusion site base directory
Go To it
Fill the form
Submit
Assume no Error - Open config.php
Assume no Error - Alter prefix to suit new prefix.
Assume no Error - remove this file from server. File written by Ausimods

<?php 
 /**
 * @name prefix_changer.php
 * @access ALL
 * @author AusiMods @ < ausimods.com >
 * @copyright GPL
 * @package php-fusion
 * @subpackage External table prefix changer
 */
 switch (isset($_POST['op']) && $_POST['op'] == 'go' ? $_POST['op'] : NULL) {
 case 'go':
 $new_prefix = isset($_POST['prefix']) ? $_POST['prefix'] : "fusion_";
 if(file_exists('config.php')) {
 require_once "config.php";
 }
 else {
 die('Incorrect file location');
 }
 if (!mysql_connect($db_host, $db_user, $db_pass)) {
 die('Could not connect to mysql');
 }
 $sql = "SHOW TABLES FROM $db_name";
 $result = mysql_query($sql);
 if (!$result){
 echo "Cant Find the tables<br />\n";
 print(mysql_error());
 exit;
 }
 while ($row = mysql_fetch_row($result)){
 $rename = ereg_replace(DB_PREFIX, $new_prefix, $row[0]);
 $change = @mysql_query("RENAME TABLE `{$db_name}`.`{$row[0]}`  TO `{$db_name}`.`{$rename}` ;");
 if($change) {
 echo "SUCCESS ON: {$row[0]} to {$rename}<br />\n";
 }
 else{
 echo "FAILURE ON: {$row[0]} to {$rename}<br />\n";
 }
 }
 mysql_free_result($result);
 echo 'Pretty sure the task is complete.<br /> Open config.php and alter the current prefix to your
 new one to re enable your site.';
 break;
 default:
 echo '<form method="post" action="">';
 echo '<input type="hidden" name="op" id="op" value="go" />';
 echo 'Change table prefix to <input type="text" name="prefix" id="prefix" value="" />.';
 echo '<input type="submit" name="submit" id="submit" value="submit" />';
 echo '</form>';
 break;
 }
 ?>

| Posted by Diemux on December 27 2008 · 2 Comments · 8379 Reads ·

Comments

#1	Stic on July 11 2009 08:28:47
	Why need to change tables prefix ? to run multiple php-fusions on site ?
#2	snowneo on August 23 2009 03:32:13
	The main purpose is for security purposes. This way hackers dont know the database prefix and it makes it a little more difficult.