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!)

P.S. the award showcase under the user public profile shows OK.

pps I also have the arcade installed, but it was working previously with awards!

OK - sorted it - was missing the awards_bit template.

Don't know how, as this was working previously!

*clicks install* Good hack.

I've found a problem into the install of this hack:

In member.php when i'm looking at someones profile the awards of this person are not show.

I fix this by replacing 'award' to 'awards_bit' into de globaltemplates array and fetch_template('awards') with fetch_template('awards_bit') into the loop, all in member.php.

Hope this helps someone ;-)

PD: I click install great work dude :p

0k i installed this hack on a 3.0.1 i get a database error when i finish the install
so i make the back up and deleted the new queris from my db, the forum back to normal, but when i make modification to the templates i cant see the changes, so anyone have an idea what can fix this?

i installed with HTL my forum had the arcade nd vbadvance hacks

I'm now considering installing this onto my 3.0.1 forum. I guess it works O.K. as long as I don't have the arcade hack installed. Is everyone satisified with it? no issues?

As far as I know the latest arcade hack will work with the awards hack as it seems they have changed their variables. But in other news I should be releasing a new fully working version with the latest arcade hack in the next couple of days.

Great work AnimeWebby! I'll hold off until your next release..

Thanks,

Art

Thanks for Porting this :)

[high]* bitbender clicks install and heads off to test site....[/high]

I have encountered a problem that I don't see in this thread yet...

Anyway, I can successfully add an award to the database. However, when I go to give a user an award, it doesn't save the information. It says "User [username] saved" or whatever when you are editing their profile... but it actually doesn't do anything to that table. In addition, there are NO errors that are encountered.

If I go to the table itself (useraward) and enter data manually, it will show that a user has an award when you view their profile...

Does anyone have any ideas as to why this is happening?

Thank you for your time and energy!

Sincerely,
Andrew

Also, it appears that the awards aren't appearing on the showthread page; however, they are showing in announcements and showpost... LOL.

I've done the modifications for showthread and functions_showthread over and over again... and I just don't understand. I made sure that awards_bit is added as a template as well.

If it helps, the arcade hack has been installed on my board... but I thought I read somewhere that it doesn't matter as the new Arcade version changed their variables...

Any thoughts?

Once again, thank you for your time and energy...

Sincerely,
Andrew Tatum

UPDATE:

When I gave myself the award via phpMyAdmin and uploaded the files... it actually showed the award for me (FinHeavenAJ). However, for any other member that doesn't have an award... they show up as a guest.

See the attachment to see exactly what I'm talking about. Once again, the awards are showing on the announcements and showpost pages... but just don't want to cooperate when it comes down to the showthread. :disappointed:

mtha, your version in post 134 works perfect for me ;) I just take some of your code some of original and it works fine now (i hope... :))

Ok something in this script does not work with 3.1. Soon as I add it it shows all new members as guest. Does anyone see what it is? showthread.php

// [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 22 ]
$posts = $DB_site->query("
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*, useraward.*,
" . iif($forum['allowicons'], 'icon.title as icontitle, icon.iconpath,') . "
" . iif($vboptions['avatarenabled'], 'avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,') . "
" . iif($vboptions['reputationenable'], 'level,') . "
" . iif(!$deljoin, '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
" . iif(!can_moderate(), $datastore['hidprofilecache']) . "
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = post.userid)
LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward ON(useraward.userid = user.userid)
" . iif($forum['allowicons'], "LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON(icon.iconid = post.iconid)") . "
" . iif($vboptions['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid)") .
iif($vboptions['reputationenable'], " LEFT JOIN " . TABLE_PREFIX . "reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)") . "
" . iif(!$deljoin, "LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')") . "
LEFT JOIN " . TABLE_PREFIX . "editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN " . TABLE_PREFIX . "post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE $postids
ORDER BY dateline $postorder

It's that part that is messed up that I just posted.

It seems that we're in the same boat :(

Ok this hack does not work in 3.1 unless you do this.

You need to use the 3.0 showthread.php, and the 3.0 includes/adminfunctions_showthread.php

It won't work on the 3.1 php files. I don't know why but that's the deal.

I have the shoutbox, who was online, awards, arcade, and store hack on my board.

And this is the only way I see getting this file to work.

Hello, I tried installing this hack and it all seemed as if it was going to work. I'm using vB 3.0.0 and when i got to step 6 of the HTL i got the message saying "Theres been a slight problem with the database", does anyone know of a way to fix this? If I changed the file edits back would it get rid of the slight error, or is my forum doomed?

well i think everthing is working fo me, the only problem is when i try to access the admincp/award.php it tells me that "Could not find phrase 'no_awards_defined'." and I know that I made it...am I doing somehting wrong?

Can someone please confirm this works with 3.0.1 or not. Thx.

As far as I know, it does not work on 3.0.1 :(

... I mean, at least it didn't for me...

Ok it seems like I'm the only one helping this thread.

Ok One it does work in 3.1 but you need to use the 3.0 showthread and the 3.o functions_include.php

I did not use the HTL I used the files to edit. But yes it can work in 3.1 bit DO NOT USE DREAMWEAVER TO EDIT FILES.

BUT NOW I NEED SOME HELP CAN SOMEONE TELL ME HOW TO USE THE HTL INSTALLER?

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)

i did not find that line in showthread.php :S
please help

also what path should be given in medals files
if i want to place medals in foll. dir
/images/icons/awards/medal1.gif

also getting this error when going to award manager without any awards
Could not find phrase 'no_awards_defined'.
i RECHECKED i have added the above phrase but still getting that error.
thats all errors i have

please help.
Thnx.
Sandy...

YOU MUST USE THE SHOWTHREAD.PHP FROM 3.0 NOT 3.1

:) well well well, I didnt have this one in used, but I did try to install it, and it seems to work on 3.0.1 (with some of my small modifications)

check out this post:
https://vborg.vbsupport.ru/showpost....&postcount=134

and ... I do not have 3.1 yet (i dont think its available yet even :D ), so cant tell about 3.1

I forgot what I changed, and dont have time to read it again tho.

i am using 3.0 not 3.0.1 :)
i managed to fix it. i did some wrong edits. :S

anywyz, thats fixed now. i have added awards in admincp and also alloted same to some users. but those aint visible now.

Sandy...

Uuhm; it DID work at my forum (2.2.7).
When I did a upgrade to 2.3.4 it was still working; but not anymore! Just from the one to the other day it stopped working.

When I select "enable awards for" "yes" and I save then the next time I take a look it stands again to "no".

Removing and re-adding al the awards didn't work.
Help me please.

Am I the only one experiencing problems of when you edit the user, the award doesn't "save?"

Meaning, if I award someone an away through the admincp, it doesn't save to the database...

Any ideas?

Sweet hack!

/me hits install