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

July 31 2010 23:54:57

Navigation

Last Seen Users

Deus	< 5 mins
davidbusch	< 5 mins
Assensvej	00:54:52
hooz	01:02:13
Narco	01:03:37
KissXme	01:14:05
schweinebob	01:32:36
bigcarrot	01:45:25
foc_in_gaura	02:03:09
vannix	02:19:32

Members: 15,625

Newest: KissXme

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

A tour through the n...

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

View all articles

Downloads v7

Currently popular Downloads
FusionBoard 4	3859
Video Gallery	2749
Professional Down...	2497
Photoalbum Mass U...	2427
Avatar Studio	2287
Extended Profile	1863
XHTML mod for mod...	1808
Button panel	1789
VArcade 2.1	1778
HighSlide Gallery...	1762

Latest Downloads

XHTML mod for modern...	1808
Pimped-Fusion v0.08.01	4
Update Package v0.08.01	0
Support Panel-Skype	7
Header Weather Widget	59
Forum Thread List Pa...	23
Meta Keywords/Descri...	73
Security System	127
User Field: US State...	24
Forum sub categories...	135

Latest 100

Downloads v6

Currently popular Downloads
Banner System v2.0.4	1648
Video Gallery	1183
Extreme Theme Editor	887
Fuzed Shoutbox	789
Seoname.php	736
Icon Package 2.0	687
Extended Profile ...	648
News.php	578
EXTboard	549
Tabbed welcome panel	518

Latest Downloads

Google Sitemap Fast	46
ExtBoard 1.2	381
EXTboard	549
v6.01.18 - v6.01.19	27
v6.01.19 FULL	81
Birthday	111
Moneybookers	43
User info	100
Link to us	259
jNews.php	339

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