OK I figured it out..I think...everything seems to be working ok but the awards are not showing?

On the showthread.php I went edit 1 than 2 than 2. Not sure if that was correct but I don't get any errors on viewing the forum. Any suggestions on how to make them show anybody? I'll post up what I did later to help others when I come home from work in the morning.

<a href="http://flowfusion.biz/forum/awards.php" target="_blank">http://flowfusion.biz/forum/awards.php</a>

Is all I get. I can't get the images to show in the postbit. Or in the members.php.

Any suggestions on why the images are not showing?

aint tried this hack but lookin at your awards m8 it looks a good hack

im gonna grab and install local and will let u know how i get on with it see if i have same prob

cant go no furhter so u got further than me m8

the queries dont work for me

CREATE TABLE " . TABLE_PREFIX . "award (
awardid smallint(5) unsigned NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
description varchar(250) NOT NULL default '',
icon_url varchar(250) NOT NULL default '',
PRIMARY KEY (awardid)
) TYPE=MyISAM
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "award ( awardid smallint(5) unsigned NOT NU

in fact i get same error trying any of the queries and they do have the ; on the end

CREATE TABLE " . TABLE_PREFIX . "useraward (
userid int(10) NOT NULL auto_increment,
PRIMARY KEY (userid)
) TYPE=MyISAM;

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "useraward (
userid int(10) NOT NULL aut

IGNORE - dumbo here forgot to remove the table prefix - not sure why that was in there.

I'm lurking here. Just take your time ok. And double check everything till you get to the "showthread.php" and remember the 1, 2, 2, thing I posted it will come in handy. If I'm right. Geez this is the heart and soul of my forum.

Replace " . TABLE_PREFIX . " with and table prefix you might be using for your copy of vb3 if not using a table prefix remove it from the query and then it will work.

If I get time tonight I will install this hack on my site and then tell you all what I had to change or what not.

Ooh help me, help me?

i cant go no further - the full hack is installed local but im getting this

Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*, useraward.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,
level,
NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid IN (0,41328)
ORDER BY dateline

mysql error: Unknown table 'useraward'

mysql error number: 1051

an di can tell u ive double checked though mysql front and the table is deffo there with no info in it when i query it so im double stuck now as im lost

thi ssi the way i ran the query as i dont use prefixs

CREATE TABLE useraward (
userid int(10) NOT NULL auto_increment,
PRIMARY KEY (userid)
) TYPE=MyISAM;