Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.6 > vBulletin 3.6 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Yet Another Awards System 2.1.4 Details »»
Yet Another Awards System 2.1.4
Version: 2.1.4, by mtha mtha is offline
Developer Last Online: May 2016 Show Printable Version Email this Page

Category: Major Additions - Version: 3.6.5 Rating:
Released: 03-18-2007 Last Update: 03-24-2007 Installs: 748
DB Changes Uses Plugins Template Edits
Re-useable Code Additional Files Translations Is in Beta Stage  
No support by the author.

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #152  
Old 07-07-2007, 09:57 PM
Silvio's Avatar
Silvio Silvio is offline
 
Join Date: Nov 2005
Location: Italy
Posts: 140
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ty mta for this great mod i'm using it from last version and is really gorgeous.

now i've upgraded to 3.6.x version and i enabled a setting i did not used on last version so i cant say if is the same issue.

issue : phrases not working (after install they doesnt exists and nor create them) at least from cp options
Enter the userID of the User you would like to appear as sender of the Congratulation PM and/or Email.
Leave it "0" to use userid of the one who issue award
To edit the PM Content, click here, to edit the Subject click here.



i guess the problem is here
Code:
To edit the PM Content, click <a href="phrase.php?do=edit&amp;e[3000][award_pm]">here</a>, to edit the Subject click <a href="phrase.php?do=edit&amp;e[4000][award_pm]">here</a>.]]></phrase>
how is possible to fix that?

pls accept apologises for my terrible english

take care
ciao
Reply With Quote
  #153  
Old 07-10-2007, 06:42 AM
es-league.com es-league.com is offline
 
Join Date: May 2006
Posts: 27
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Think I have an error that I hope someone can help with...

I have noticed that only some of the award winning members
have medals displayed in their posts ?

Although the medals are clearly given in the admin cp
and showing as awarded on a particular date,
they even show up in each players user cp but not always
in the posts and threads...

seems a bit random , any ideas ?
Reply With Quote
  #154  
Old 07-12-2007, 10:53 AM
Taios Taios is offline
 
Join Date: Apr 2007
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Question:
How do i get the medals to be as big as the medals in this forum?
http://www.global-army.com/forum/sho...=9253#post9253

I mean like. When the user posts, they are much bigger. Atm, my forum only shows a minute of the actual thing.

EDIT : figured it out. Just need to do some edits now i guess to change the position fo where its shown
Reply With Quote
  #155  
Old 07-13-2007, 08:34 PM
katie hunter's Avatar
katie hunter katie hunter is offline
 
Join Date: May 2007
Posts: 533
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi I have a small question in the award how can i edit this part ? Name / Description

I want to stretch it more a little or add more words to it other then Name / Description

http://forum.nihonomaru.com/awards.php

Thanks
Reply With Quote
  #156  
Old 07-16-2007, 06:12 PM
Simetrical Simetrical is offline
 
Join Date: Nov 2006
Location: New York City
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This is a nice mod. Unfortunately, it crashed my site when this query was run repeatedly during a period of high load (23 times over, running between 78 and 208 seconds, as of just before I started killing them):
Code:
mysql> EXPLAIN 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 1=1 
    -> 
    -> 
    ->                         GROUP BY au.issue_id
    ->                         ORDER BY au.issue_time DESC;
+----+-------------+-------+--------+---------------+---------+---------+-------------------------+-------+---------------------------------+
| id | select_type | table | type   | possible_keys | key     | key_len | ref                     | rows  | Extra                           |
+----+-------------+-------+--------+---------------+---------+---------+-------------------------+-------+---------------------------------+
|  1 | SIMPLE      | au    | ALL    | NULL          | NULL    | NULL    | NULL                    |   117 | Using temporary; Using filesort | 
|  1 | SIMPLE      | a     | eq_ref | PRIMARY       | PRIMARY | 2       | totalwar_vb.au.award_id |     1 | Using where                     | 
|  1 | SIMPLE      | post  | ref    | userid        | userid  | 4       | totalwar_vb.au.userid   | 25005 | Using where                     | 
+----+-------------+-------+--------+---------------+---------+---------+-------------------------+-------+---------------------------------+
3 rows in set (0.00 sec)
While I'm no MySQL expert, it seems that this attempts to copy the entirety of the post table to a temporary table, in my case about 1.5 million rows. I've tracked the query down to the showthread_query hook:
PHP Code:
        // Obtain list of awards for current user
        
$alluserawards =  $db->query_read("
            SELECT a.*, au.*, post.userid, post.postid 
            FROM " 
TABLE_PREFIX "post AS post
            INNER JOIN " 
TABLE_PREFIX "award_user AS au ON (au.userid=post.userid)
            INNER JOIN " 
TABLE_PREFIX "award AS a ON (a.award_id=au.award_id)
            WHERE 1=1 
"
iif((!empty($ids)), "AND post.postid IN (0" $ids ")") ."
"
iif((!empty($cache_postids)), "AND post.postid IN (" $cache_postids ")") ."
            GROUP BY au.issue_id
            
$awardsdisplayorder
        "
);

        while( 
$ua $db->fetch_array($alluserawards))
        {
            
$userawardscache[$ua['userid']][$ua['issue_id']] = $ua;
        }
        
$db->free_result($alluserawards); 
Apparently this fails to account for the possibility that $ids and $cache_postids are both empty. I have no idea why it would or would not be reasonable to account for that, because I don't know what either of those variables is, but at any rate, if they both are empty things are not very good. I've wrapped the whole thing in a conditional checking whether both are empty, just not setting anything if they both are. I'd appreciate any response.
Reply With Quote
  #157  
Old 07-16-2007, 09:41 PM
letsjoy's Avatar
letsjoy letsjoy is offline
 
Join Date: Jun 2006
Location: Dhump State
Posts: 197
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks alot
Reply With Quote
  #158  
Old 07-18-2007, 08:48 PM
kartik786 kartik786 is offline
 
Join Date: Aug 2005
Location: India
Posts: 175
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks a lot.. im going to give it a try soon
Reply With Quote
  #159  
Old 07-19-2007, 09:56 AM
malluroses malluroses is offline
 
Join Date: Jul 2007
Posts: 58
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks a lot yaar
Reply With Quote
  #160  
Old 07-19-2007, 09:43 PM
The Librarian's Avatar
The Librarian The Librarian is offline
 
Join Date: Dec 2006
Posts: 79
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I've got this mod working but I've got two items I need help fixing:

1) I need to re-arrange the order members are listed on the Awards page. They seem to be listed by MemberID # (order of registration) but I want them in Alphabetical order.

and

2) I got a database error when I tried to give an award to a member with an apostrophe in her name. I'm working on a fix but if someone has information on that it would be appreciated.

Oh, and btw, I corrected the English on the PM message. It should be "Congratulations" (with an "s") and "upon receiving" instead of "as you are receiving".

Thanks!
Reply With Quote
  #161  
Old 07-20-2007, 07:59 PM
The Librarian's Avatar
The Librarian The Librarian is offline
 
Join Date: Dec 2006
Posts: 79
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

More about #2 above:
Quote:
Originally Posted by The Librarian View Post
2) I got a database error when I tried to give an award to a member with an apostrophe in her name. I'm working on a fix but if someone has information on that it would be appreciated.
Here's the deal... when I try to award another user (5peaches) I get "you have successfully given MA'AM the award"- so it's giving 5peaches award to MA'AM... and then if I try to give MA'AM an award I get this error message:
Quote:
Invalid SQL:

SELECT userid, username
FROM vb_user
WHERE username = 'MA'AM';

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 'AM'' at line 3
Error Number : 1064
Date : Thursday, July 19th 2007 @ 08:43:42 PM
Script : http://www.website.com/forum/admincp...do=dogiveaward
Referrer : http://www.website.com/forum/admincp...ers&award_id=9
I'm sure it's because of the appostrophe... does anybody have a fix for this, please?!
Reply With Quote
Reply


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 01:06 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.05440 seconds
  • Memory Usage 2,333KB
  • Queries Executed 25 (?)
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
  • (1)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (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
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete