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

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

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

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

Did you also do this?

Quote:

2- From(Plugin Manager)
Find (YAAS - Profile Tab) and disactive it.

The uninstall and then install again would seem, to me anyways, to indicate that there's an error with the uninstall code that isn't removing all the tables from the database, which of course will cause problems when re-installing.

Quote:

Originally Posted by TiKu (Post 2284393)

Did you also do this?

Yes, I did that too.

Quote:

Originally Posted by squidsk (Post 2284468)

Well I don't know what went wrong as the uninstall didn't do it's job but I've tried uploading a back up of all files and the SQL databases and it didn't help. So I'm at a loss as to what happened or how to get this working as it should.

Anyone know how to manually remove these so I can install again?

Code:

Database error in vBulletin 4.1.8:



Invalid SQL:

ALTER TABLE award ADD award_allowrecommend TINYINT( 1 ) DEFAULT 1 NOT NULL,ADD award_pointvalue TINYINT( 3 ) DEFAULT 0 NOT NULL;



MySQL Error   : Duplicate column name 'award_allowrecommend'

Error Number  : 1060

Request Date  : Friday, January 6th 2012 @ 03:28:17 AM

Error Date    : Friday, January 6th 2012 @ 03:28:18 AM

Script        : http://***.***.***/***/plugin.php?do=productimport

Referrer      : http://***.***.***/***/plugin.php?do=productadd

IP Address    : ***.***.***.***

Username      : ***

Classname     : vB_Database

MySQL Version : 5.0.91mm-log

I managed to manually remove everything and install this again.

So back to the original problem

When someone requests awards this happens:

Code:

The following errors occurred with your submission



There's some error when sending your award request. 

Please contact site's administrator for assistant.

Code:

The following errors occurred with your submission



The following users were not found: 1

Then there is the problem with the award tables and tab.

http://www.mattachine.net/images/yaas_problems.png

1. This is how the left side looked before the user 1 got an award (I know it isn't pretty but I haven't been able to get that double border at the bottom changed).
2. This is how the same location looks after they have got one award.
3. This is where that strange tab ends up when the Awards tab link is clicked.
4. This is how the tabs look when there is no reward given. It's just the row of tabs with no box or anything under it. Looks strange. Note that the Awards tab has been clicked in this picture and then an other tab thus creating a border and box with the right design. Not like the un-clicked one in image 7.
5. Here I've clicked the Awards tab after an award has been given out and the strange tab in image 2 have moved up under the normal row of tabs creating a gap. Clicking the other tabs does not make this happen, only the Awards tab.
6. Here the Awards tab has been clicked for a user with awards. The tab background and border is correct but the gap is present.
7. This is how the Awards tab look when a user's profile is first entered.

So what should I do to get this sorted?

I've done the things below and I can't see if it changed anything. Certainly not any of the problems I'm having were fixed with this. I'm running 1.4.8. Can anyone please help me?

Quote:

Originally Posted by sadiq6210 (Post 2189701)

UPDATE FOR: 4.0.8 - 4.1.3
(TAKE BACKUP BEFORE ANY REPLACE)

1- Find the template (memberinfo_block_myawards) and replace it all

Code:

<div id="view-myawards" class="<vb:if condition="$selected_tab == 'myawards'">selected_view_section<vb:else />view_section</vb:if>">

<div>



<div class="blocksubhead subsectionhead userprof_headers userprof_headers_border">

{vb:rawphrase award_showcase} - {vb:raw $block_data[num]} {vb:rawphrase awards} <vb:if condition="$vboptions[aw_points]"> - {vb:raw $block_data[total_points]} {vb:rawphrase points}</vb:if>

</div>



<div class="blockbody">

<table width="100%">

<tr align="center">

        <vb:if condition="$vboptions[aw_showicon]"><th class="blocksubhead" nowrap="nowrap">{vb:rawphrase award_icon}</th></vb:if>

        <vb:if condition="$vboptions[aw_showimage]"><th class="blocksubhead" nowrap="nowrap">{vb:rawphrase award_image}</th></vb:if>

        <th class="blocksubhead" width="100%">{vb:rawphrase award_description}</th>

</tr>

{vb:raw $block_data[myawards]}

</table>

</div>

</div>

</div>

2- From(Plugin Manager)
Find (YAAS - Profile Tab) and disactive it.

3- From (plugin manager)
Find (YAAS in Member Profile - Profile) >> EDIT >> Replace it all

Code:

$blocklist['myawards'] = array(

        'class' => 'MyAwards',

        'title' => $vbphrase['my_awards'],

        'options' => array(

                'pagenumber' => $vbulletin->GPC['pagenumber']

        ),

        'hook_location' => 'profile_tabs_last',

        'wrap' => false

);



require_once('./global.php'); 

global $vbulletin;  

require_once(DIR . '/includes/class_bbcode.php');

$bbcode_parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());



class vB_ProfileBlock_MyAwards extends vB_ProfileBlock

{

    var $template_name = 'memberinfo_block_myawards';



    function confirm_empty_wrap()

    {

        return false;

    }



    function confirm_display()

    {

        return ($this->block_data['myawards'] != '');

    }



    function prepare_output($id = '', $options = array())

    {

        global $show, $vbphrase, $stylevar, $vbcollapse, $bgclass, $vbulletin;

        

        require_once(DIR . '/includes/class_bbcode.php');

        $bbcode_parser =& new vB_BbCodeParser($this->registry, fetch_tag_list());



                

                $result = $this->registry->db->query_read('

            SELECT

                *

            FROM

            ' . TABLE_PREFIX . 'award_user AS award_user

                LEFT JOIN ' . TABLE_PREFIX . 'award AS award USING (award_id)

            WHERE 

                award_user.userid = ' . $this->profile->userinfo['userid'] . '

                AND award.award_active = "1"

            ORDER BY

               '.$vbulletin->options['aw_awardorder'].'

        ');

        

                                if (($vbulletin->options['aw_points']) AND ($this->profile->userinfo['userid']))

                                {

                                        $userpoints = $this->registry->db->query_read('

                                                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

                                        ');

                                

                                        while ($array = $this->registry->db->fetch_array($userpoints))

                                                {

                                                $this->block_data['total_points'] = $array['TotalPoints'];

                                                }  

                                }

                

        $num = $this->block_data['num'] = $this->registry->db->num_rows($result);

        

        $this->block_data['myawards'] = '';

        

        if ($num > 0)

        {

            // Display Awards

            while ($award = $this->registry->db->fetch_array($result))

            {

                exec_switch_bg();

                

                $award['award_desc'] = $bbcode_parser->parse($award['award_desc']);

                $award['issue_reason'] = $bbcode_parser->parse($award['issue_reason']);

                

                $award_issue_date = vbdate($this->registry->options['dateformat'], $award['issue_time'], true);

                $award_issue_time = vbdate($this->registry->options['timeformat'], $award['issue_time']);

                

                //- VB3 -// eval('$this->block_data[\'myawards\'] .= "' . fetch_template('awards_userawards_bit') . '";');

                                //- BEGIN VB4 -//

                                $templater = vB_Template::create('awards_userawards_bit');

                                        $templater->register('award', $award);

                                        $templater->register('award_issue_date', $award_issue_date);

                                        $templater->register('award_issue_time', $award_issue_time);

                                $this->block_data['myawards'] .= $templater->render();

                                //- END VB4 -//

            }

        }

    }

}

Good luck :)

Apparently, the below code which was unnecessary if I put in the other code in my previous post solved the problem.

Quote:

Originally Posted by ffaat (Post 2254525)

I fixed the lack of tab styling in the user profile by the following (the classes needed updating):

Edit YAAS - Profile Tab to be:

PHP Code:


		
			
if ($selected_tab == 'myawards') 
{ 
$template_hook['profile_tabs_last'] .= '<dd class="userprof_module"><a id="myawards-tab" href="'.$vbulletin->input->fetch_relpath().'#myawards" onclick="return tabViewPicker(this);">Awards</a></dd>'; 
} 
else 
{ 
$template_hook['profile_tabs_last'] .= '<dd class="userprof_moduleinactive"><a id="
myawards-tab" href="'.$vbulletin->input->fetch_relpath().'#myawards" onclick="return tabViewPicker(this);">Awards</a></dd>'; 
}

But I also still have a ghost award tab down at the bottom with a link of &tab=myawards#myawards

Could this be a remnant from upgrading from version 3 that didn't get cleaned out?

-Rob A>

So no more additional help needed about the tab situation. :D

I've read through this thread for some info on how the Automation tool works but I can't find what I'm looking for.

So lets say I want usergroup 2 to get award 1 after 365 days.
There is a Task Name box: 1 Year Membership
There's a box where I can enter the award ID: 1
There's a Criteria menu where I can select "Days as Member"
Then there's the Criteria box. Use only numbers, but doesn't say how.
(I know I have to put in usergroup_id:2 there but how? And how do I combine that with the amount of days? Next question how do I make it so that when I add a 2 year award that it replaces the 1 year award and so on?)
Last there's an issued reason box which is quite basic: You've been a member for one year!

mIQe,

It's possible that I missed it some place in the thread, but I think that the Automation function is not able to replace your 1 year with the 2 year. You would have to manually go back and remove all of the 1 year awards once someone hit the 2 year mark.

The Automation part has huge potential, but in it's current form is just missing some key elements to make it worth while using... I would love to use it on my site.

Ok, I can live with doing that manually, but do you know how to input the values in to the Criteria box?

As it can only be numbers I have no idea how to input UsergroupID and DaysAsMember.

Sorry I don't since I do not use the Auto feature.

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 (5)bbcode_code_printable (1)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)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.02945 seconds Memory Usage 1,804KB 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 (5)bbcode_code_printable (1)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)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: