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

March 11 2010 22:36:22

Navigation

Last Seen Users

Kevin2009	< 5 mins
mafiotabg	< 5 mins
Nemo_O	00:06:43
MasteR_SVK	00:14:10
afoster	00:20:28
Silentneeb	00:21:51
klopdd	00:22:40
DJ-SKY	00:23:43
Lukass445	00:24:31
ST66	00:32:54

Members: 13,490

Newest: weaser

Blogs

» 18-09-2009 - Say ...

» 10-07-2009 - Will...

» 24-06-2009 - Blog...

» Elyn + Streamyx (...

» 19-05-2009 - Thin...

» 15-05-2009 - Week...

» 13-05-2009 - Comp...

» Number 1925

» Number One

Things to Do

Latest Articles

Protect your Fusion ...

Change your database...

Handling MySQL Datab...

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...

Upgrading to PHP-Fus...

View all articles

Downloads v7

Currently popular Downloads
FusionBoard 4	3160
Video Gallery	2271
Professional Down...	2231
Photoalbum Mass U...	2053
Avatar Studio	1995
Extended Profile	1687
VArcade 2.1	1582
HighSlide Gallery...	1559
XHTML mod for mod...	1443
Button panel	1439

Latest Downloads

User Info [Remade]	272
BBcode: AVI	6
Pimped PHP-Fusion	4
XHTML mod for modern...	1443
Banner Rotater	865
Who's Where Panel	733
VU Tab Panel	382
Viewlog Script	186
Usergroup Management	658
Unauthenicated User	185

Latest 100

Downloads v6

Currently popular Downloads
Banner System v2.0.4	1412
Video Gallery	1064
Extreme Theme Editor	815
Fuzed Shoutbox	705
Seoname.php	664
Icon Package 2.0	651
Extended Profile ...	610
EXTboard	542
News.php	541
Tabbed welcome panel	489

Latest Downloads

Google Sitemap Fast	4
ExtBoard 1.2	366
EXTboard	542
v6.01.18 - v6.01.19	20
v6.01.19 FULL	54
Birthday	88
Moneybookers	32
User info	74
Link to us	245
jNews.php	312

Latest 100

Provider

PHPfusion-mods.net is hosted at:

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 22:45:52 · 2 Comments · 2754 Reads ·

Comments

#1	Stic on July 11 2009 22:28:47
	Why need to change tables prefix ? to run multiple php-fusions on site ?
#2	snowneo on August 23 2009 17: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.