php/mysql parsing smilies for forum script

[liam_d]

Hi all im trying to do a thing to parse my smilies correctly and this is my post parsing thing;

PHP Code:

// post body bbcode stuff
function main_bbcode()
{
    global $site_config;
    
    // Strip the old tags!
    $_POST['body1'] = htmlspecialchars($_POST['body1']);
    
    // Smilies
    $grab_smilies = mysql_query("SELECT * FROM `smilies` ORDER BY `id`");
    while ($echo_smilies = mysql_fetch_array($grab_smilies))
    {
        $_POST['body1'] = str_replace($echo_smilies['code'],"<img src='{$site_config['site_url']}{$echo_smilies['image']}' />",$_POST['body1']);
    }
    
    // Bold code
    $_POST['body1'] = str_replace("[b]","<strong>",$_POST['body1']);
    $_POST['body1'] = str_replace("[/b]","</strong>",$_POST['body1']);
        
    // Underline code
    $_POST['body1'] = str_replace("[u]","<u>",$_POST['body1']);
    $_POST['body1'] = str_replace("[/u]","</u>",$_POST['body1']);
        
    // Italic code
    $_POST['body1'] = str_replace("[i]","<em>",$_POST['body1']);
    $_POST['body1'] = str_replace("[/i]","</em>",$_POST['body1']);
        
    // New line code
    $_POST['body1'] = str_replace("\n","<br />",$_POST['body1']);
    
    // Urls
    $_POST['body1'] = preg_replace("`(?<=^|[\n ]|\.)http://([\w]*[\w\.\?\/&=\;-]+)`","[url=http://\\1]http://\\1[/url]",$_POST['body1']);
    $_POST['body1'] = preg_replace("`(?<=^|[\n ]|\.)www\.([\w\.\?\/&=\;-]+)`","[url=http://www.\\1]www.\\1[/url]",$_POST['body1']);
    
    $_POST['body1'] = preg_replace("`\[url\]([\w]*[:\/\/]*[\w\.\?\/&=\;, -@]+)\[/url\]`sUi","<a href='\\1' rel='nofollow'>\\1</a>",$_POST['body1']);
    $_POST['body1'] = preg_replace("`\[url\=([\w]*[:\/\/]*[\w\.\?\/&=\;, -@]+)\](.*)\[/url\]`sUi","<a href='\\1' rel='nofollow'>\\2</a>",$_POST['body1']);

    // addlsashes dont want no errors or sql injection
    $_POST['body1'] = addslashes($_POST['body1']);
}


Say one of smilie codes is [<] well <] doesnt get entered in the database is there a way for it to pick up all things its replacing coze i think its deleting it or something?

[Jeanco]

Please explain your problem more thoroughly.. I'm not sure what the problem is.

[Peter]

your best bet will be to echo the query and try running it in phpmyadmin makes life a bit easier seeing the code that needs to be executed and the error phpmyadmin gives (if any).

[liam_d]

Solved with help from xeo on devshed and my smart thinking after a nights sleep