vb.org Archive - Major Additions - Yet Another Awards System 2.1.4

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Major Additions - Yet Another Awards System 2.1.4 (https://vborg.vbsupport.ru/showthread.php?t=142487)

Can anybody help me with this? Perhaps post the entire text that should be in the YAAS - Showthread_postbit_create plugin?

Quote:

Originally Posted by Danisty (Post 1221910)

Can anybody help me with this? Perhaps post the entire text that should be in the YAAS - Showthread_postbit_create plugin?

Code:

$post['userawards'] = '';

  $post['showuserawards'] = false;

  if ($vbulletin->options['aw_postbit'])

  {

      if (is_array($userawardscache[$post[userid]]))

      {

        $aw_i = 0;

        $post['num_awards'] = count($userawardscache[$post[userid]]);

        foreach($userawardscache[$post['userid']] AS $award_id => $award)

        {

          $aw_i++;

          if ($aw_i <= $vbulletin->options['aw_display_limit'])

          {

            eval('$post[userawards] .= "' . fetch_template('awards_bit') . '";');

          }

        }

        $post['showuserawards'] = true;

      }

    }

Hi !
I have a problem with this:

IF on POSTBIT is enabled:

Quote:

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 1=1
AND post.postid IN (0,1684)

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

MySQL Error : Colonna sconosciuta 'a.award_id' in 'on clause'
Error Number : 1054
Date : Sunday, April 8th 2007 @ 10:45:07 PM
Script : http://forum.uebb.it/showthread.php?t=371
Referrer :
IP Address : 66.249.72.209
Username : Non registrato
Classname : vb_database

If MEMBERLIST is enabled:

Quote:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT a.*, au.*
FROM user AS user
INNER JOIN award_user AS au ON (au.userid=user.userid)
INNER JOIN award AS a ON (a.award_id=au.award_id)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid=user.userid)
LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid=reputationlevel.reputati onlevelid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

WHERE 1=1
AND user.usergroupid IN (-1,37,38,72,71,9,6,70,52,79,74,51,16,19,64,82,29,69 ,30,56,77,42,28,68,7,15,14,73,84,12,65,80,81,59,60 ,5,26,49,83,50,2,31,78)
GROUP BY au.issue_id;

MySQL Error : Colonna sconosciuta 'a.award_id' in 'on clause'
Error Number : 1054
Date : Sunday, April 8th 2007 @ 11:38:03 PM
Script : http://forum.uebb.it/memberlist.php
Referrer :
IP Address : 62.123.244.184
Username : King™
Classname : vb_database

and...a big problem...if all disabled, in ALL MEMBER PROFILE:

Quote:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT a.*, au.*
FROM award AS a
LEFT JOIN award_user AS au ON (a.award_id=au.award_id)
WHERE (au.userid = 1874)
ORDER BY au.issue_time DESC;

MySQL Error : Colonna sconosciuta 'a.award_id' in 'on clause'
Error Number : 1054
Date : Sunday, April 8th 2007 @ 10:43:57 PM
Script : http://www.uebb.it/forum/member.php?u=1874
Referrer :
IP Address : 74.6.68.235
Username : Non registrato
Classname : vb_database

Now i have disabled the product for full board function...
Pls...i need fast help to repair..:(

Quote:

Originally Posted by sinisterpain (Post 1221915)

Code:

$post['userawards'] = '';

  $post['showuserawards'] = false;

  if ($vbulletin->options['aw_postbit'])

  {

      if (is_array($userawardscache[$post[userid]]))

      {

        $aw_i = 0;

        $post['num_awards'] = count($userawardscache[$post[userid]]);

        foreach($userawardscache[$post['userid']] AS $award_id => $award)

        {

          $aw_i++;

          if ($aw_i <= $vbulletin->options['aw_display_limit'])

          {

            eval('$post[userawards] .= "' . fetch_template('awards_bit') . '";');

          }

        }

        $post['showuserawards'] = true;

      }

    }

I'm still getting the following error:

Quote:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /member.php(825) : eval()'d code on line 60

alright, I feel stupid right now... to install this hack I download the zip file on teh first page and do what?... yes im serious, haha. This is my first hack install and im curious/nervous. Looks like a great program.

Im running: VBulletin 3.6.4

Can anyone tell me if it is possible to give an award to a usergroup rather that a single user... for example I have bronze supporter, silver supporter and gold supporter usergroups.

I created awards for each of these usergroups and wanted to assign an award to each usergroup, any ideas?

Mike.

Quote:

Originally Posted by polo708 (Post 1223983)

First you need to "unzip" the file that you downloaded. Then, if you look inside the "Docs" folder you'll see installation instructions. Follow them step by step.

very nice product

I want to change Yes/No/Maybe options in poll to another words where I can found this words

If I can't get some kind of feedback here I'm just going to uninstall this.

Am I right to say that for this mod, I allow members to vote, and then I see the results of the voters and award the winner?

If so, may I know, how do I view the results of the votes? I can't seem to find the results, and who voted..

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (7)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01547 seconds Memory Usage 1,755KB 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 (2)bbcode_code_printable (7)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
Messages: