Download: (inv) Awards

[Gunnar94]

Is this a fresh install or an upgrade, if you are installing try below:

Try running this query in your ACP.

CREATE TABLE inv_awards_awarded ( `row_id` int(255) NOT NULL auto_increment, `award_id` int(255) NOT NULL, `user_id` int(255) NOT NULL, `is_active` tinyint(1) NOT NULL default '1', `notes` text NOT NULL, `date` varchar(45) NOT NULL, `awarded_by` INT(255) NOT NULL, `approved` TINYINT(1) NOT NULL DEFAULT 1, PRIMARY KEY (`row_id`) )

Be sure to include your database table prefix.

IF UPGRADING:

Please tell me the error you are getting.

[PersonalMode]

Hi topthrillkid,

I update 2.2.0 to 2.2.2, and I have this error during the upgrade :

Error: ALTER TABLE ibf_`groups` ADD `g_can_receive_awards` TINYINT(1) NOT NULL DEFAULT '1'

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 '`groups` ADD `g_can_receive_awards` TINYINT(1) NOT NULL DEFAULT '1'' at line 1

Error: ALTER TABLE ibf_`inv_awards` ADD `public_perms` TEXT NOT NULL

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 '`inv_awards` ADD `public_perms` TEXT NOT NULL' at line 1

Error: ALTER TABLE ibf_`inv_awards_awarded` ADD `awarded_by` INT( 255 ) NOT NULL AFTER `user_id`

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 '`inv_awards_awarded` ADD `awarded_by` INT( 255 ) NOT NULL AFTER `user_id`' at line 1

Error: ALTER TABLE ibf_`inv_awards_awarded` ADD `approved` TINYINT(1) NOT NULL DEFAULT 1

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 '`inv_awards_awarded` ADD `approved` TINYINT(1) NOT NULL DEFAULT 1' at line 1

[Azoun]

Any idea when the issue with friendly url's will be solved?

[Viper V2]

I got the awards app nicely. my only question is how do I get it from showing the resized awards in the topic profile view? The do not show option in the ACP is not working for me. thanks

[Andrej]

This has probably been asked but is it planned to have auto awards? Things like were it automatically gives awards to x post count / join date / etc.

[Sinistra]

Broken images in admin CP? How do I fix this and also Renaming the main category or the option to delete?

[Heosforo]

Reading so many member errors I thought it would be difficult, but it works perfect thanks a lot.
Any chance to hide the tab menu?

[Gunnar94]

This has probably been asked but is it planned to have auto awards? Things like were it automatically gives awards to x post count / join date / etc.

Yes, just trying to figure out the best way to make that all happen for now.

Broken images in admin CP? How do I fix this and also Renaming the main category or the option to delete?

Install the latest version.

[Viper V2]

I have noticed that if you have a deleted member in your thread then it throws the User's Awards off for everyone within that thread or page in the topic views for the awards.

[Gunnar94]

What do you mean by it throws them off, what exactly happens?

[groverr]

or you can set that showed the signature

[PersonalMode]

Hi topthrillkid,

I update 2.2.0 to 2.2.2, and I have this error during the upgrade :

Error: ALTER TABLE ibf_`groups` ADD `g_can_receive_awards` TINYINT(1) NOT NULL DEFAULT '1'

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 '`groups` ADD `g_can_receive_awards` TINYINT(1) NOT NULL DEFAULT '1'' at line 1

Error: ALTER TABLE ibf_`inv_awards` ADD `public_perms` TEXT NOT NULL

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 '`inv_awards` ADD `public_perms` TEXT NOT NULL' at line 1

Error: ALTER TABLE ibf_`inv_awards_awarded` ADD `awarded_by` INT( 255 ) NOT NULL AFTER `user_id`

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 '`inv_awards_awarded` ADD `awarded_by` INT( 255 ) NOT NULL AFTER `user_id`' at line 1

Error: ALTER TABLE ibf_`inv_awards_awarded` ADD `approved` TINYINT(1) NOT NULL DEFAULT 1

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 '`inv_awards_awarded` ADD `approved` TINYINT(1) NOT NULL DEFAULT 1' at line 1

Can you help me ??

[Viper V2]

What do you mean by it throws them off, what exactly happens?

For example in a thread that has a deleted member within it, the deleted member will show it has User's Award in it's topic profile and then go below that deleted member and there is a member who's awards are not right in the topic view until it just stops having the user awards in the topic view towards the bottom of the page.

[Viper V2]

I downloaded the most recent upgrade or Beta and I beleive there are 2 settings in the system setting part that appear to be the same thing:

Listings Page Settings
Enable Awards System YesNo
Enable/Disable all public areas for this awards applications. (Listings page and profile tab)

• Revert
• Edit
• Delete
  

Listings Page Settings
Enable Awards System YesNo
Enable/Disable all public areas for this awards applications. (Listings page and profile tab)

[Gunnar94]

Can you help me ??

Upgrade to version 2.2.3 BETA 1, skip 2.2.2

For example in a thread that has a deleted member within it, the deleted member will show it has User's Award in it's topic profile and then go below that deleted member and there is a member who's awards are not right in the topic view until it just stops having the user awards in the topic view towards the bottom of the page.

If you could give me a screenshot or link, I think I understand, but just want to be sure.

I downloaded the most recent upgrade or Beta and I beleive there are 2 settings in the system setting part that appear to be the same thing:

Listings Page Settings

Enable Awards System YesNo

Enable/Disable all public areas for this awards applications. (Listings page and profile tab)

• Revert
• Edit
• Delete
  

Listings Page Settings

Enable Awards System YesNo

Enable/Disable all public areas for this awards applications. (Listings page and profile tab)

Not sure, why it's doing that, I had the same result. You can just delete one.

[Viper V2]

Upgrade to version 2.2.3 BETA 1, skip 2.2.2

If you could give me a screenshot or link, I think I understand, but just want to be sure.

Not sure, why it's doing that, I had the same result. You can just delete one.

Just for instance in a thread that has a post from a deleted member it will then mess up the chain on user awards in the topic view for the members who have posted below that deleted member.

[whoisdo]

Are you still planning on having a gamerscore/points value added to this?

[Azoun]

Any idea when the issue with friendly url's will be solved?

Any idea?

[Viper V2]

Here is a screen shot showing how a deleted member shows the user awards in the topic view. It should not show any for a deleted member.

[Gunnar94]

Any idea?

It is already, in version 2.2.3 BETA 1.

Here is a screen shot showing how a deleted member shows the user awards in the topic view. It should not show any for a deleted member.

Ok, thank you, I will look into it.

[groverr]

and showed how to do this in your signature

[Viper V2]

you got an eta of when the fix for the deleting members and messed up awards in the profile will be? thanks

[Gunnar94]

Not yet, sorry. I have been without power for a few days now, a big storm rolled through. I will hopefully be able to make an estimate on Wednesday as we still do not have power, I am working off of a generator.

[Viper V2]

Hello, not to bug you, but any fix yet on the deleted member topic view bug?

[Gunnar94]

(inv) Awards 2.2.3 BETA 2 uploaded to the IPS Marketplace and at Invision Envy.

Fix for deleted members in topic is included, BV Gaming! ;)