Major Additions - Yet Another Awards System

*** CREATE A BACKUP OF YOUR FORUM AND DATABASE BEFORE INSTALLING ***

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
+ Writes granting/removing awards to the log

In ModCP
- Issue awards to members, based on username or userid, with Issue Reason
- Remove awards from members
+ Writes granting/removing award to the log

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)

New Features/Additions since 3.8
- Points System
- Separate Award Request/Recommendation Forms
- CSS Customizable

Current Release Version 4.0.9

• Added - Handling of user merges
• Added - Handling of user deletes
• Added - Manage awards on per user basis
• Added - Extra info to the logs for mass removal and editing of issued awards
• Added - Ability to collapse categories on awards.php
• Added - Checksum file for checking for suspect file versions
• Added - Various missing phrases
• Fixed - Memberlist not showing awards when option is active
• Fixed - Navtab not being selected (vb version < 4.2)
• Fixed - Category title not being displayed on awards.php
• Fixed - Logging not working in modcp
• Fixed - A few other minor bugs

[TiKu]

Did you also do this?

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

[squidsk]

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.

[mIQe]

Originally Posted by TiKu

Did you also do this?

Yes, I did that too.

Originally Posted by squidsk

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.

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.

[mIQe]

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

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:

The following errors occurred with your submission

There's some error when sending your award request. 
Please contact site's administrator for assistant.

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.



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?

[mIQe]

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?

Originally Posted by sadiq6210

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

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

<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

$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

[mIQe]

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

Originally Posted by ffaat

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.

[mIQe]

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!

[Mobo]

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.

[mIQe]

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.

[Mobo]

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