AHhh, yes, thanks for the help. I got it working, arcade hack also. Someone needs to update the first post with the changes for gold if it hasnt been done already.

But was does "request award" mean or supposed to do on the awards page?

does anyone know why I get that error message? yes I have done everything and read all the directions. I even went over instructions 3 times but still something gives error. I can see the forum home, but everytime i try to view each thread or something else, I get that error. Also the admin panel seems to work fine, but the rest is just messed up. :(

Use these instructions, instead of the ones in the first post

https://vborg.vbsupport.ru/showpost....&postcount=134

ANyone have an idea why I get this error message in my email every so often?

IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
,avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline
,level,
NOT ISNULL(deletionlog.primaryid) AS isdeleted,
post_parsed.pagetext_html, post_parsed.hasimages

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=announcement.userid)
LEFT JOIN useraward AS useraward ON(useraward.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 type = 'post')
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid = 856

mysql error: Unknown table 'announcement' in on clause

mysql error number: 1109

Date: Thursday 15th of April 2004 12:11:04 PM
Script: http://giftedsouls.com/gs/showpost.p...56&postcount=2
Referer:

My 7th attept has failed. I really wnat this, i think i'm gonna pay for someone to install it for me. But as a last resort, i;ve attatched my mof#dified files, could someone have a look to whether i've doen anything wrong? I used HTL, but i got Parse errors and database errors all over the place.

The /nw in teh attacthment, is the backup files.

last I checcked, the first post wasnt updated for gold...atleast it wasnt when I downloaded it.

When you get to the file and template edits use the mods from this post
https://vborg.vbsupport.ru/showpost....&postcount=134

Right, i'll have another go if i get time. I think my problems were in member.php, announcement.php and showpost.php. I think thats all.

AnimeWebby - Any update on the new install / instructions? Anyone running this on vb3.01?

I'm currently upgrading/revamping [on a non-livesite location] and after two nights of caffiene and much hunting through this thread, I have this working on 3.0.1. The awards appear in the postbits and profiles where they should and I had no issues adding, editing and deleting awards, nor adding/removing them from users.

The only issues I seem to be having is it's saying it can't find some of the phrases [only through the admincp], like "deleted_award_successfully" AND when I went to go ahead and add them manually [I did this HTL style], it said the phrases already did exist.

Not too big a deal because the functionality seems to be working fine, though it does grate against my weird OCD-perfectionist-ness.

<edit>God, I'm so rude. I forgot to say: An otherwise excellent hack, this will be extremely useful to me. *clicks install*</edit>

I've followed the alternative instructions in this thread and I don't get any awards displaying under 3.01 (I had them working on 3 RC4). I can setup the awards in AdminCP and I have made the correct changes to the templates.

I have fixed broken user profiles again and tried removing and re-adding awards.

No error message, just no awards. :(

If anyone could shed any light, I'd be most grateful (I know I've not given a lot to go on here!)