Major Additions - Yet Another Awards System 2.1.4

Yet Another Award System 2.1.4 ? by HacNho
Copyright (C) 2005 by HacNho, All rights reserved.

Hack Version: 2.1.4.070324
Compatible vB version: 3.6.x
Support: https://vborg.vbsupport.ru/showthread.php?t=142487

for vBulletin 3.5.x:
https://vborg.vbsupport.ru/showthread.php?t=94836
For vBulletin 3.0.x, please check the other version:
https://vborg.vbsupport.ru/showthread.php?t=78934

DESCRIPTION:
This is a Medals/Awards system. Admin can give members awards, and award icons will be displayed in member's profile, posts, as well as in a award list.

FEATURES:
In AdminCP
- Can Create/Edit/Delete/Reorder categories/sub-categories in ACP (with category name and description)
- Can Create/Edit/Delete awards in ACP (with Award Name, Description, Icon URL, Image URL)
- Can Move one (or all) award(s) from one category to another
- Can set some awards un-classified (not displayed for public)
- Can re-order awards in awards showcase
+ Issue awards to members, based on username or userid, with Issue Reason
+ Remove awards from members
- [1.2] Options to set number of awards displayed in postbit
- [1.2] Options to turn on/off showing award icon, images, award requests in awards list, awards icons in memberlist
- [2.1.3] Notify awarded user by PM/email
- [2.1.4] Option to turn on/off Award System in ModCP

In ModCP
+ Issue awards to members, based on username or userid, with Issue Reason
+ Remove awards from members

Front page
- Display awards list in with: Award Name, Description, Icon, Image, and Members who get each award.
- Display awards showcase in profile, with Award information, Issue time and reason
- Display award icons in postbit (showthread, showpost, announcement, private)
[1.2] Display limit awards in postbit, with total awards, and a link to awards showcase in member profiles.
[1.2] Award request, link to a form sending to email/PM/new thead or post (based on Dr Erwin Loh's Form hack)
[1.2] Display award on Memberlist page (by trulylowcarb)

CHANGES/MODIFICATION:
- Tables to add: 3 (award, award_user, award_cat)
- Files to add: 4 (/awards.php, /award_request.php, /admincp/award.php, /admincp/award_cat.php)
- Files to edit: 8 (/admincp/index.php, member.php, showthread.php, showpost.php, announcement.php, private.php, memberlist.php, /include/functions_online.php)
- Templates to edit: 5 (MEMBERINFO, postbit, postbit_legacy, memberlist, memberlist_resultsbit )

DIFFICULTY:
Easy
Time: about 5 minutes
Installer is included (1 product XML)


CREDIT:
Idea has been carried on by many people, here are some:
- Lesane for original Award hack for vB2, eventhough I've never use his hack
- AnimeWebby for Awards/ Medals/ Cards Hack [vB3], which I write new code based on his.
- Mac ycl6 for phpBB Medal System for phpBB forum
- Dr Erwin Loh for FORM TO THREAD/ FORUM/ PM/ EMAIL hack
- and all others for supports and ideas

[techenigma]

Yet another question... which template controls the award display in postbit? I want to make some changes there but can't figure out which of your templates is the one to edit. thanks.

[mat.knott]

any update on problem with vbadvanced?

[MikeHolohan]

This is excellent, installed thanks, Mike.

[RCWong]

I upgraded from 2.1.2 to this 2.1.4 and now I get this error?

Fatal error: Call to a member function parse() on a non-object in /home/****/domains/*****/public_html/showthread.php(1044) : eval()'d code on line 15

[mtha]

Originally Posted by marsauae.com

Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'مشرف عام',
`description` = '',
`usertitle` = 'Super Moderator',
`opentag` = '<font color=\"#800000\">',
`closetag` = '</font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`pmdailyquota` = '',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '0',
`forumpermissions` = '1048575',...
WHERE usergroupid=5;

MySQL Error : Unknown column 'pmdailyquota' in 'field list'
Error Number : 1054
Date : Thursday, March 22nd 2007 @ 05:23:34 PM
Script : http://www.marsauae.com/bb/admincp/u....php?do=update
Referrer : http://www.marsauae.com/bb/admincp/u...&usergroupid=5
IP Address :
Username : marsauae
Classname : vB_Database

This error doesnt seem to relate to this hack

Originally Posted by Nzarect

Great mod but I'm having a problem with moderators not being able to view the awards in the modcp. It's there because I can see it, but when they try to access it, they get "you do not have permission to use this page".

I can't find where I can edit their permissions. Only 2 moderators will have permission to issue awards.

Upgrade to version 2.1.4

Originally Posted by techenigma

Excellent Mod... One error I spotted and also a feature request.

I get the following error when attempting to do a mass move in the award manager

Also I wanted to know if you could add a feature in the "Award System Settings" to enable or disable the "Awards SHowcase" in the user profile.


p.s - How can I paginate the images in both the postbit and when they appear in the small "awards showcase" in the user profile? I have about 10 awards showing up there but they just run in one line and I'd like to make it do 5 per line.

Do you have anything special when you try to mass-move? anyway, try with the new version.

should the awards being automatically wrap?

Originally Posted by deb0

I have the plugin installed, but i only have the aDmin-options link. I don't have links to the awards.php or awards manager.

Please help.

You have to add the link. upload the files again might solve the problem

Originally Posted by techenigma

Yet another question... which template controls the award display in postbit? I want to make some changes there but can't figure out which of your templates is the one to edit. thanks.

postbit and postbit_legacy.

[mtha]

Originally Posted by toucan42

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT a.*, au.*, post.userid, post.postid
FROM post AS post
INNER JOIN award_user AS au ON (au.userid=post.userid)
INNER JOIN award AS a ON (a.award_id=au.award_id)
WHERE post.postid IN (0,11332,11334,11336,11337,11338) GROUP BY post.postid

GROUP BY au.issue_id
ORDER BY au.issue_time DESC;

MySQL Error : 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 'GROUP BY au.issue_id
ORDER BY au.issue_time DESC' at line 7
Error Number : 1064
Date : Wednesday, March 21st 2007 @ 11:04:22 PM
Script : http://www.talkwhatever.com/showthread.php?p=11338
Referrer : http://www.talkwhatever.com/index.php
IP Address : 72.92.141.48
Username : admintw42
Classname : vb_database

For me this occurs when I turn ON postbit - assuming it is the double GROUP BY but not sure how to fix that in the product.

please try the new version 2.1.4 . it should work.

[mtha]

Originally Posted by toucan42

On member.php there is a problem also where it shows the small awards showcase:

Awards Showcase
The Ladybug Award: For excellent posts

Congratulations!" border="0" />

Issue with quotes in the "Reason" field?

well, I just remove the description in the link tag. it should be ok with 2.1.4

Originally Posted by danhaga

Great mod but I have one problem... The award description is limited in length and there isnt enough space for me to make a proper description for certain awards.

Is there a way to lengthen this?

ok, in 2.1.4, field type for award description and reason is changed to text, now you can put more stuff in there, but I am not guaranty about the template (if your long custom description would look nice on the pages.

[Bojangles]

Great mod Awesome work! /installed.

[odie3]

Installed and so far so good!

Question: On user posts, rather that showing the newest/oldest awards - could it be possible to just show random awards, per user posts?

Thanks!

Now if I could just get custom ranks per user [not per group like VB works] I'll be set.

[techenigma]

Originally Posted by techenigma

Yet another question... which template controls the award display in postbit? I want to make some changes there but can't figure out which of your templates is the one to edit. thanks.

Originally Posted by mtha

postbit and postbit_legacy.

No sorry, you mis-understood. I'm wondering which of your added templates needs to be edited to change it. Is it the award_showcase template?

Basically what I'm trying to do is change the way the awards are displayed in the post bit i.e remove the awards showcase box around them, have them display directly next to each other instead of spaced, and have them display automatically wrap 5 per line. Which template is it that controls the display? award_showcase?