I have a problem

I made a mood hack but for some reason it shows up blank in postbit

PHP Code:

        $post=$DB_site->query_first("
        SELECT
        post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,".iif($forum[allowicons],'icon.title as icontitle,icon.iconpath,','')."
        mood.title as moodtitle,mood.moodpath,attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
        ".iif($avatarenabled,",avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline","")."
        FROM post
        ".iif($forum[allowicons],'LEFT JOIN icon ON icon.iconid=post.iconid','')."
        LEFT JOIN mood ON mood.moodid=post.moodid
        LEFT JOIN user ON user.userid=post.userid,ratetotal,ratenum,allowrate
        LEFT JOIN userfield ON userfield.userid=user.userid
        ".iif ($avatarenabled,"LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                               LEFT JOIN customavatar ON customavatar.userid=user.userid","")."
        LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
        WHERE post.postid = '$postid'
        "); 

thats what i have in showthread and heres what i have in functions

PHP Code:

        if ($post[moodid]!=0) {
          $post[currentmood]="<b>Mood:</b> $post[moodtitle] <img src=\"$post[moodpath]\" border=\"0\" alt=\"$post[moodtitle]\">";
        } else {
          $post[currentmood]="<b>Mood:</b> No Mood";
        } 

[Slynderdale]

it says Mood: and a blank image, see attachment below

[Admin]

What's the path of that image? Perhaps you forgot {imagesfolder}?

[Slynderdale]

the images and stuff are fine, some reason the post bit isnt getting the varibles, there blank it should be like
Mood: mood image
and the image is blank too

[Slynderdale]

i fixed it, thanks though for trying to help

[Admin]

You edited the wrong query, you need to edit the [minicode]$posts=$DB_site->query_first("[/minicode] query at the bottom.

[Slynderdale]

im done with my mood hack now

[Slynderdale]

Originally posted by FireFly
You edited the wrong query, you need to edit the [minicode]$posts=$DB_site->query_first("[/minicode] query at the bottom.

yea, i noticed that when i looked at the code closer lol, thanks for the help though, ill really apricate it

[Slynderdale]

heres how the post looks

[Slynderdale]

heres what the post reply, post thread and edit post looks like