September 07 2010 14:13:17
PHPFusion-mods.net | Your PHP Fusion resource
Navigation
Last Seen Users
LaNceROnline
wanili< 5 mins
Tabibito< 5 mins
Xoft00:22:47
bohdas00:32:19
Djordje00:35:25
Alorsss00:38:00
kyborgasfm00:38:40
pamises1600:57:55
nightgockel00:59:54

Members: 16,220
Newest: kyborgasfm
Blogs
Diemux
» 18-09-2009 - Say ...
Diemux
» 10-07-2009 - Will...
Diemux
» 24-06-2009 - Blog...
elyn
» Elyn + Streamyx (...
Diemux
» 19-05-2009 - Thin...
Diemux
» 15-05-2009 - Week...
Diemux
» 13-05-2009 - Comp...
elyn
» Number 1925
Diemux
» 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...
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 4011
Video Gallery 2868
Professional Down... 2569
Photoalbum Mass U... 2519
Avatar Studio 2348
Extended Profile 1898
Button panel 1865
XHTML mod for mod... 1863
VArcade 2.1 1833
HighSlide Gallery... 1800

Latest Downloads

Bosnian Locale - PHP... 4
Multimedia Studio ve... 25
Post-Report 1
Post Report with pd_... 0
XHTML mod for modern... 1863
Pimped-Fusion v0.08.01 23
Update Package v0.08.01 3
Support Panel-Skype 23
Header Weather Widget 82
Forum Thread List Pa... 34

Latest 100
Downloads v6
Currently popular Downloads
Banner System v2.0.4 1702
Video Gallery 1212
Extreme Theme Editor 916
Fuzed Shoutbox 815
Seoname.php 756
Icon Package 2.0 701
Extended Profile ... 659
News.php 585
EXTboard 552
Tabbed welcome panel 532

Latest Downloads

Google Sitemap Fast 56
ExtBoard 1.2 385
EXTboard 552
v6.01.18 - v6.01.19 33
v6.01.19 FULL 91
Birthday 123
Moneybookers 47
User info 104
Link to us 262
jNews.php 346

Latest 100
Provider
PHPfusion-mods.net is hosted at:

110MB
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 · 3623 Reads · Print
Comments
#1Stic on July 11 2009 22:28:47
Stic
Why need to change tables prefix ? to run multiple php-fusions on site ?
#2snowneo on August 23 2009 17:32:13
snowneo
The main purpose is for security purposes. This way hackers dont know the database prefix and it makes it a little more difficult.
Post Comment
Please Login to Post a Comment.
Ratings
Rating is available to Members only.

Please login or register to vote.
No Ratings have been Posted.
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Our Coders
Smokeman
Rizald 'Elyn' Maxwell
Diemux
Netrix
Donate
Shoutbox
You must login to post a message.

MarcusG
06/09/2010 13:00
@smokeman: my shout was not adressed to a special person. Fusion-Mods and Fusion-Main sites have the same problems with stupid spammers. Wink

Smokeman
06/09/2010 10:02
@MarcusG: I agreed with you but I can't do anything about it. It's Diemux that stands for that part of the site.

MarcusG
06/09/2010 09:21
This SPAM really SUX, especially when there are solutions to fight it. I have NO (ZERO) Spam on my site.

Splash
06/09/2010 04:18
I think someone break Fusion captcha.

Smokeman
04/09/2010 09:32
Spam deleted.

MarcusG
04/09/2010 08:09
Try this to fight the SPAM: KLICK ME HARD Or THIS

doku
04/09/2010 06:56
Spammm Alarm^^ Confused

Smokeman
31/08/2010 14:30
@Info: Cleaned up the shouts for support questions. Thumb Up!

Smokeman
30/08/2010 03:26
It's not my site - im just admin inhere. Smile

gdaze
30/08/2010 02:29
Why not replace the Shoutbox with the Tagwall infusion Smokeman? Then put the Tagwall as a lower center panel. Just a suggestion..
Advertiser
One-click Translation
Translate This Site
Render time: 0.15 seconds 5,388,349 unique visits
Copyright © 2007 - 2010 PHPFusion-mods.net

Valid XHTML 1.0 Transitional



Powered by PHP-Fusion copyright © 2002 - 2010 by Nick Jones.
Released as free software without warranties under GNU Affero GPL v3.
Running on v7.00.0x PHPFusion-mods.net Special Edition