PDA

View Full Version : I have a problem


Slynderdale
06-02-2002, 09:44 AM
I made a mood hack but for some reason it shows up blank in postbit


$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,at tachment.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,allowrat e
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

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
06-02-2002, 09:47 AM
it says Mood: and a blank image, see attachment below

Admin
06-02-2002, 01:49 PM
What's the path of that image? Perhaps you forgot {imagesfolder}?

Slynderdale
06-02-2002, 02:04 PM
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
06-02-2002, 02:19 PM
i fixed it, thanks though for trying to help :)

Admin
06-02-2002, 02:20 PM
You edited the wrong query, you need to edit the $posts=$DB_site->query_first(" query at the bottom.

Slynderdale
06-02-2002, 02:21 PM
im done with my mood hack now:)

Slynderdale
06-02-2002, 02:46 PM
Originally posted by FireFly
You edited the wrong query, you need to edit the $posts=$DB_site->query_first(" 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
06-02-2002, 02:47 PM
heres how the post looks :)

Slynderdale
06-02-2002, 02:48 PM
heres what the post reply, post thread and edit post looks like

Slynderdale
06-02-2002, 02:49 PM
heres the quick reply box

Slynderdale
06-02-2002, 02:49 PM
heres the admin options that let you add,upload and delete moods

Velocd
06-15-2002, 02:36 AM
..were you planning on releasing this?

psx-dude
06-19-2002, 08:53 PM
I would like to see this released, please release this.

bonnmac
06-25-2002, 09:22 PM
Yes please release this. It looks fantastic :)

Boofo
07-27-2002, 10:33 PM
Good luck on getting Slynderdale to release anything he says he's going to or one that works right and doesn't have to be completely re-written. He's baiting you guys. :)

DrkFusion
07-27-2002, 11:47 PM
Originally posted by Boofo
Good luck on getting Slynderdale to release anything he says he's going to or one that works right and doesn't have to be completely re-written. He's baiting you guys. :)

LMAO

Drk