Click on Give Award, (the award you duplicated), and scroll down - there's a Remove Award below that. :)

And I think I may have solved the table-stretching and clutter problem by moving them to their own separate table below the regualr part of the postbit, although, I'm not a coder and I have no idea if this has any repercussions. (I guess I'll see. It's on a test style for now.)

How do I get the awards to show up in the postbit? The installer didn't work.

You have to edit the postbit template - it's in the readme.txt I think.

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT a.*, au.*
FROM award AS a
LEFT JOIN award_user AS au ON (a.award_id=au.award_id)
WHERE (au.userid = 67)
ORDER BY au.issue_time DESC;

MySQL Error : Unknown column 'au.award_id' in 'on clause'
Error Number : 1054
Date : Sunday, September 16th 2007 @ 07:57:48 PM
Script : http://www.teamkalarin.com/member.ph...lastposter&f=9
Referrer : http://www.teamkalarin.com/forum.php
IP Address : 80.57.89.34
Username : Test0001
Classname : vb_database

How do i fix this?

k i've got a weird error.

My awards work but my award showcase section is under my footer...wtf...

here:

http://www.totalgamerzone.com/forums/member.php?u=4

scroll down to the bottom of the page and yu should see an award showcase box...

can someone please help me?

after upgrading from vb 3.6.3 to 3.6.8

i got this error when viewing profiles of members who got an award.

after disabling the yass the error disappears.

Edit:
If someone spots the same error und you use mysquli, just search the plugin YASS - member complete

and change line
$total_awards = mysql_num_rows($alluserawards); in
$total_awards = mysqli_num_rows($alluserawards);

thats just the number of total awards. it wont be displayd anymore in the member profile, but you get rid of the annoying error.

does this work on 3.6.8 ???

If anyone gets an error of;

when trying to give a user an award, like I was, then open your config.php (FORUM ROOT/includes/config.php) file and change the database type ($config['Database']['dbtype'] = ''; ), from mysqli to just mysql. That did the trick for me, so hopefully if others are having the same problem it'll work for them too :).

Is there any way to say give medals automatically? Say if someone posts 100 posts then they get an automatic medal?

thats the wrong way, i can give you the change of the award.php this evening.