This question has been answered by donshakespeare. See the first response.
<?php
// connect to DB.
$db=new mysqli('localhost','dbuser','superpassword','databasename');
// get the data
$query = "select * from modx_site_content";
$result = $db->query($query);
echo $result->num_rows . " records to check\n";
$count=0;
// iterate through it, replace and smash back into DB.
while ( $entry = $result->fetch_assoc())
{
$content=str_replace('http://home_url.home/','https://public_url.com/',$entry['content']);
if($content != $entry['content'])
{
$content=addslashes($content);
$query="update modx_site_content set content='{$content}' where id={$entry['id']}";
$db->query($query) or die("$query\nfailed\n");
$count++;
}
}
echo "$count updated\n";
echo "Don't forget to clear the cache now\n";
I know it's there just escaping me (or I've gone mad, one of the two).It's usually both, as the average MODX Dev's life will testify.
tinymce.init({
...
//find this bit of code in your TinymceWrapperCommonCode chunk (if using TinymceWrapper), or wherever your code is
relative_urls: false,
remove_script_host: false, // change to true
document_base_url: MODx.config.site_url,
...
});
I know it's there just escaping me (or I've gone mad, one of the two).It's usually both, as the average MODX Dev's life will testify.
Looking for this maybe?
https://forums.modx.com/thread/101460/need-help-using-tinymce-in-a-staging-enviroment-multiple-domain