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?