, Guest!
Already a Member? Login or Register.

Menu



Showcase


Due to the volume of spam happening on our forums, posting is now restricted to verified members only.  If you're not verified, drop us a note with your username.

Home > FlexCMS Support Forum > User Help > Code Snippets > Search/Replace Old URLs

FlexCMS Support Forum


Search/Replace Old URLs
Started April 25, 2005 @ 11:21pm by DCSun
Post Message 
DCSun
Administrator



Posts: 625
 
Search/Replace Old URLsApril 25, 2005 @ 11:21pm
The script below can be pasted into a new php-enabled page, update the first two lines to match your site, then run, and that will replace any of the old urls in the pages, blocks, and forum messages. As always, you should backup the database before running this just in case.


Code

$StringToFind = 'yourdomain.com/flex';
$ReplacementString = 'yourdomain.com';


// pages
$query = "select * from `".$Settings['DBPrefix']."core-Pages` where PageLink!='".$Arguments2."'";
$result = mysql_query($query) or die (mysql_error());
while ($row = mysql_fetch_array($result)) {
if (strpos($row['PageContents'],$StringToFind) !== false) {

$row['PageContents'] = str_replace($StringToFind,$ReplacementString,$row['PageContents']);

$PageReplacements++;

$query2 = "update `".$Settings['DBPrefix']."core-Pages` set PageContents='".addslashes($row['PageContents'])."' where RecordNumber='".$row['RecordNumber']."' limit 1";
$result2 = mysql_query($query2) or die (mysql_error());

}
}

// blocks
$query = "select * from `".$Settings['DBPrefix']."core-Blocks`";
$result = mysql_query($query) or die (mysql_error());
while ($row = mysql_fetch_array($result)) {
if (strpos($row['BlockContents'],$StringToFind) !== false) {

$row['BlockContents'] = str_replace($StringToFind,$ReplacementString,$row['BlockContents']);

$BlockReplacements++;

$query2 = "update `".$Settings['DBPrefix']."core-Blocks` set BlockContents='".addslashes($row['BlockContents'])."' where RecordNumber='".$row['RecordNumber']."' limit 1";
$result2 = mysql_query($query2) or die (mysql_error());

}
}

// forum messages
$query = "select * from `".$Settings['DBPrefix']."mb-Messages`";
$result = mysql_query($query) or die (mysql_error());
while ($row = mysql_fetch_array($result)) {
if (strpos($row['Message'],$StringToFind) !== false) {

$row['Message'] = str_replace($StringToFind,$ReplacementString,$row['Message']);

$ForumReplacements++;

$query2 = "update `".$Settings['DBPrefix']."mb-Messages` set Message='".addslashes($row['Message'])."' where RecordNumber='".$row['RecordNumber']."' limit 1";
$result2 = mysql_query($query2) or die (mysql_error());

}
}


print '<br><b>Search and Replace Complete.<br><br>Replacements:<br></b>Pages: '.$PageReplacements.'<br>Blocks: '.$BlockReplacements.'<br>Forum Posts: '.$ForumReplacements;



FlexCMS v3.2 Has Been Released!
 

Post Message 




Try & Buy FeedForAll - Easy to use RSS Feed Creator - great for iTunes users!

MEMBERS




All Contents, Code, Scripts and Technologies Copyright 2003-2009 FlexCMS.
All Rights Reserved. Software License Agreement

Processing Time: 0.07111 seconds.
 
Management Login

Powered By FlexCMS
Powered By FlexCMS