Go Back   vb.org Archive > vBulletin Modifications > vBulletin 3.8 Modifications > vBulletin 3.8 Add-ons

Reply
 
Thread Tools
Yet Another Awards System Details »»
Yet Another Awards System
Version: 3.8.4, by Xanlamin Xanlamin is offline
Developer Last Online: Apr 2015 Show Printable Version Email this Page

Category: Add-On Releases - Version: 3.8.4 Rating:
Released: 11-13-2008 Last Update: 01-15-2010 Installs: 822
DB Changes Uses Plugins Auto-Templates
Re-useable Code Additional Files Translations  
No support by the author.

vBulletin 4 version can be found here: https://vborg.vbsupport.ru/showthrea...highlight=YAAS

DESCRIPTION:
This is a Medals/Awards system. Admin/Mods 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)
+ Issue awards to members, based on username or userid, with Issue Reason
+ Recommend awards for members based on username, with Recommend Reason
+ Remove awards from members
+ Issue Point Values to awards (Recommended that you are running mySQL 5.0 or higher, will not work correctly with lower versions of mySQL)
+ Award automation

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 within a TAB, with Award information, Issue time and reason
- Display award icons in postbit or under sig.

CHANGES/MODIFICATION:

3.8.4:

* Fixed - Issuing Awards to users with ' in usernames.
* Fixed - "Award System Settings" SettingGroup name.
* Fixed - Phrases for Award Request/Recommendation Settings.
* Fixed - All templates should be properly cached.
* Fixed - Inactive awards no longer display in postbit.

* Improved - Version Information in AdminCP.
* Improved - Award Name is added to Post/PM Title Recommendations/Requests.
* Improved - Postbit Display Location descriptions.
* Improved - Cleaner awards layout display.
* Improved - Award Submissions Post/PM layout.


3.8.3 Patch 1:

* Fixed - SQL Group By Syntax when Points are enabled



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

Upload files and import xml.

When upgrading: re-upload ALL files and re-import XML

This MOD is 100% Supported.

Authors of YaAS 3.8:
Xanlamin
CypherSTL

Current Release: v3.8.4 Newest Release

Download Now

File Type: zip YaAS-3.8.4.zip (477.6 KB, 3588 views)

Screenshots

File Type: jpg YaAS-AdminCP-Award_System_Settings.jpg (146.7 KB, 0 views)
File Type: jpg YaAS-AdminCP-Award_Manager.jpg (92.3 KB, 0 views)
File Type: jpg YaAS-Forum-Post_Display.jpg (89.1 KB, 0 views)
File Type: jpg YaAS-Forum-Profile_Display.jpg (105.6 KB, 0 views)

Supporters / CoAuthors

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.
4 благодарности(ей) от:
Erica1977, Panzer Max, Razta, xorex

Comments
  #432  
Old 01-12-2010, 05:09 AM
CypherSTL CypherSTL is offline
 
Join Date: Mar 2006
Location: St. Charles, MO
Posts: 306
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by racingsolution View Post
Well by deleting the function function construct_depth_mark from awards.php it fixes the problem.
Most likely, now if you have multiple category sections, some of the category names will be doubling up.
Reply With Quote
  #433  
Old 01-12-2010, 01:07 PM
robdawg robdawg is offline
 
Join Date: Sep 2005
Location: Orange County, CA
Posts: 66
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Is anyone else having a problem where the dropdown in the vBulletin Options Admin Section has a blank entry for this Awards Manager?
Reply With Quote
  #434  
Old 01-12-2010, 03:12 PM
gunboard gunboard is offline
 
Join Date: Jun 2008
Location: Germany
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi,

how i can delete the ascii 31 (_) between the award icons in postbit ?
Reply With Quote
  #435  
Old 01-13-2010, 06:46 PM
Speysider's Avatar
Speysider Speysider is offline
 
Join Date: Apr 2009
Posts: 1,029
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by robdawg View Post
Is anyone else having a problem where the dropdown in the vBulletin Options Admin Section has a blank entry for this Awards Manager?
I'm having this problem as well.
Reply With Quote
  #436  
Old 01-13-2010, 07:02 PM
Xanlamin's Avatar
Xanlamin Xanlamin is offline
 
Join Date: Mar 2008
Location: St. Charles, MO
Posts: 330
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have you tried to re-import the XML to overwrite to see if this solves this error, so far I have been unable to reproduce this problem.
Reply With Quote
  #437  
Old 01-13-2010, 07:23 PM
DarkArmada DarkArmada is offline
 
Join Date: Nov 2008
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Stupid question, but what do the points actually do? I'm running vbExperience which manages my point system - is there a plugin available to add the points to vbE?
Reply With Quote
  #438  
Old 01-13-2010, 07:47 PM
Xanlamin's Avatar
Xanlamin Xanlamin is offline
 
Join Date: Mar 2008
Location: St. Charles, MO
Posts: 330
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You can assign a point value to the awards, once the user reaches a certain point structure they will receive the corresponding award.
Reply With Quote
  #439  
Old 01-13-2010, 11:35 PM
Cars2007 Cars2007 is offline
 
Join Date: Jun 2007
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Xanlamin View Post
mySQL grouping erros resolved. Download newest zip and reimport the xml.
We are still having the same issue with the latest version of the plugin. Any ideas?

Downloaded YaAS-3.8.3.1.zip from the link above.

Code:
Database error in vBulletin 3.8.4:

Invalid SQL:

						SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints
						FROM award a, award_user au
						WHERE (au.userid = 4981) AND (a.award_id=au.award_id);

MySQL Error   : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number  : 1140
Reply With Quote
  #440  
Old 01-14-2010, 03:48 AM
CypherSTL CypherSTL is offline
 
Join Date: Mar 2006
Location: St. Charles, MO
Posts: 306
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

From looking at the database error, it would seem that it isn't using the new query.

Have you re-imported the XML?

It should be using this query:
Code:
SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints
FROM ' . TABLE_PREFIX . 'award a, ' . TABLE_PREFIX . 'award_user au
WHERE (au.userid = '.$this->profile->userinfo['userid'].') AND (a.award_id=au.award_id) AND (a.award_active = "1")
GROUP BY au.userid
Reply With Quote
  #441  
Old 01-14-2010, 05:27 AM
gunboard gunboard is offline
 
Join Date: Jun 2008
Location: Germany
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Xanlamin View Post
Have you tried to re-import the XML to overwrite to see if this solves this error, so far I have been unable to reproduce this problem.
yes i have tried to reimport the Mod. Does not fix the problem. Sorry for my bad english
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:24 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05159 seconds
  • Memory Usage 2,346KB
  • Queries Executed 27 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_code
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (4)post_thanks_box_bit
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (5)postbit_attachment
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete