vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Yet Another Awards System 3.5 v2.1.2 (https://vborg.vbsupport.ru/showthread.php?t=94836)

Soliloquy 07-29-2007 04:51 AM

I've been running this successfully for several months now, and one of the awards I give out is a Link Award for members who have linked to the forum from their homepage. I've also set up a page full of banners and graphics for them to use, and tried linking to it from the award description. The link works, but it broke the display of the small version of the awards in the profile and the memberlist. (I'm guessing the script uses the award description as the alt tag or something.) Anyone know how to fix the broken areas so I can have the link?

amcd 08-04-2007 09:37 AM

in the showthread_query hook, we have
Code:

$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 $postids
"
. iif((!empty($cache_postids)), "post.postid IN (" . $cache_postids . ")") ."
            GROUP BY au.issue_id
            $awardsdisplayorder
        "
);



what is the purpose of that 'group by'?

RichieScott1 08-24-2007 11:23 AM

How do I delete an award from a user?

mgurain 09-24-2007 04:29 PM

Quote:

Originally Posted by mgurain (Post 1282508)
Hi mtha,
Last update 12. May 2006, will it work on vb3.6.7 ?

mtha, did you stop supporting this hack ?

Design Master 11-06-2007 04:56 PM

I got this errore when get in awards.php

note that i didn't Edit templates Yet.

Quote:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT award.*, award_cat.award_cat_title
FROM award AS award
LEFT JOIN award_cat AS award_cat USING (award_cat_id)

ORDER BY award_cat.award_cat_displayorder,award.award_displ ayorder;

MySQL Error : Unknown column 'DatabaseName.award.award_cat_id' in 'on clause'
Error Number : 1054
Date : Tuesday, November 6th 2007 @ 12:50:21 PM

habasabi 11-13-2007 03:08 PM

I have a question.. I installed this a while ago, and all was working fine, until now.. Some of our members have changed their usernames, and now they can't request an award... when you click on submit, it says that their Old username is not found.. even though they're submitting for someone else, and their username is inputted correctly...

is this a glitch? has anyone else had this problem? Anyone know how to fix it? Thanks in advance

ryancooper 02-06-2008 03:20 PM

Is there a way to add a custom link URL to each award?

Hoffi 02-07-2008 12:57 PM

Did someone installed this on 3.7 and created a tab for the Awards?

Biker_GA 02-09-2008 04:20 PM

I'd love to see this ported to 3.7. We used this often on our board before upgrading. Unfortunately, the author seems to be MIA. :(

hrk 02-14-2008 08:35 AM

YES, Please mod for 3.7 BETA 4 please...:)


All times are GMT. The time now is 04:39 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01325 seconds
  • Memory Usage 1,741KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete