McShelby

You may want to try this:

<?php echo $_SERVER["QUERY_STRING"]; ?>

You said, you’ve installed the run php hack. So which one did you really installed. Is there a link to see the outcome?

You can try my Exec PHP plugin. I wrote it specifically to have a more advanced quote handling than the other known PHP plugins.

You could also try my Exec PHP plugin. I wrote it specifically because of issues when also using quotes in the posts.

I can see it: Line 19 on your main page

This may work. In this case you’d only need a texteditor with regex capabilities.

Okay, this will also not solve your problem and it seems that there is currently no pure SQL way to do this: https://forums.mysql.com/read.php?20,54128,54199

I expect this not to work, because the % wildcard will only work in WHERE statements. But you may modify the statement by using the MySQL regular expression support https://dev.mysql.com/doc/refman/4.1/en/regexp.html

UPDATE wp_posts
SET post_content = "https://www.the-new-domain.com/images/"
WHERE post_content REGEXP ".*https://the.old.domain/img/alpha*/alpha*/alpha*/.*"

I haven’t tested this nor am I sure the regular expression does the job for you. You may have to extend the expected characters between the path separators as well.

Are you sure you are not mixing up post_title and post_name? post_title should always contain the title in the form you typed it in during creation of the post (if no intercepting plugins are active). The title text with dashes should only be generated for the field post_name.

Oh sorry, it was:

UPDATE table
SET field =
REPLACE(
field,
"https://one.two.com/three/xxx/yyy/zzz/",
"https://domain.com/images/");


Are you looking for something like this:


UPDATE table
SET field =
REPLACE("https://one.two.com/three/xxx/yyy/zzz/", "https://domain.com/images/");


This should work with MySQL but I am not sure if this works with other DB systems.

Hint: An ul tag is only allowed to follow up an li tag. If you want to have some caption above the list like “Powered by” you have to write it before the ul tag.

@moshu: Ah, reading all content of a page helps a lot. Wasn’t that my hint for inomaly ?? Thanks

This seems to be a plugin problem. For a simple test just deactivate all plugins and look if the output is still scrambled. It may have also something to do with character encoding. Could you post a link to the site?

vkaryl: The br tag is what I also wrote in my reply but for some reason this comment system interpreted the br as linebreak instead of writing the tag into my reply. I may have had to encapsulate it with a pre tag?

inomaly: You should not use the center tag anymore. Use CSS instead. The rest of the validation problems you have are pretty well explained by the Validator output. Just take some time and _read_ the error messages. You may also consult a XHTML reference like https://en.selfhtml.org/ Sorrowly the english translation isn’t finished at all, but there are translations in german, spanish, japanese and french – if this helps…