UBB.Developers Forums Community Development Programming MySQL and Server Configuration post edit produces newline characters in table - help

ubbthreads v6.3
MySQL v4.0.12
RedHat 8.0

Problem. I have a custom script that takes the top 5 posts to a selected forum and 'scrolls' them on the screen. This normally works fine however, I just upgraded to ubbthreads6.3 and noticed the script 'broke' after I edited a post. After an hour and a half I finally figured out that somehow the edit is producing newline characters in the value fields.

I figured this would be a quick php fix with something like:


However, that doesn't seem to work (for some bizzare reason that I can't figure out.)

Questions:
<li> Has anyone noticed the newline characters in the mysql value fields after a post is edited? (body)
<li> Is there a fix?
<li> Is this MySQL version specific?

Many thanks to anyone that can help ...oh, also, when a post is edited, the HTML in the post remains except the bold tags turn into UBB Code bold tags. Is there a fix for this?

Thanks,

- Simon

UPDATE: It's not the /n it's the /r that's being created and since I figured that out, the php ereg works now.

Still have the problem with the UBB Code bolds though.

This sounds more like script troubles. I'd make sure you're using all stock scripts and test with posts made under stock scripts.

Also, one question. Do this query for a post you're having trouble with


SELECT B_Markup
FROM w3t_Posts
WHERE B_Number = xxxxxx


Put the post number where I have xxxxx