Member Awards (2.0 Compatible!)

[SgtMic]

Does not work. Nothing but database errors, forums stop working. I don't recommend dropping the existing tables route.

[Fustrate]

Did you create the tables manually?

[!wooha]

Run this query.

Code Select Expand


ALTER TABLE smf_awards
ADD COLUMN awardName VARCHAR(80) NOT NULL DEFAULT ''


^ this has to be one of the sloppiest mods I've ever seen, no wonder it was abandoned by it's creator!
It's successor ("Frustrate") may be apply named, hopefully he saw fit to do a complete rewrite.

Frankly, I'm surprised it was ever approved at all!

60 pages of correspondence on a mod may be less a measure of it's popularity than a measure of its inadequacy

[Fustrate]

If you knew the history of this mod, you'd know it was put together for a friend of his, and never meant to see the light of day in such a public form. I recently did an entire rewrite of the 2.0 version of this mod, but haven't gotten around to rewriting the 1.1.x version. It'll get here as soon as it gets here.

Oh, and coding conventions change over time. What was thought to be good code two years ago is usually seen as a mess today. Heh, I'd show you an early version of my reputation system mod if I could find it, and you (and I) would say the exact same thing about it.

[!wooha]

lol

no worries!

glad you saw to do a complete rewrite...what a nightmare! (daymare?)

I really wouldnt worry about 1.1x though...let the past take care of itself..

you should probably get a fresh everything for the new version, new name, new thread,etc?

[Fustrate]

nah, I'd rather keep everything in one spot, because I do have to support those using the old versions too (which isn't very often, but it does happen).

Good news was that I got to add a few new features along the way that I had been wanting to put in for a long time... so it wasn't too much of a nightmare

[SgtMic]

Did you create the tables manually?

I created them by installing the mod.
Then I deleted them and imported the "old" ones.
What happens is when you click on a topic in the forum, you get a similar error to what I posted earlier.
Basically errors with tables.
The only way to get the forums to work again is uninstall the mod.

[Fustrate]

I can't quite fix this until I know why it won't create the tables. Do you have a link to where they Treasury creator said something about it?

[SuperTongue]

Erm, I'm not trying to pop in here, but is there any way to have the badges show up under a person's avatar and such in each of their posts along with in their profile as seen here

[Fustrate]

http://www.simplemachines.org/community/index.php?topic=114701.msg1144061#msg1144061

[SgtMic]

I can't quite fix this until I know why it won't create the tables. Do you have a link to where they Treasury creator said something about it?

Go here and talk to Resourcez.

[mummyk]

Hi

We're using 2.0 Beta 3.1 Public, on threads/posts made by members, awards are showing that have been deleted by Admins previously, yet when you look on the member's profile, those awards aren't there?
Anyone have any ideas why? (please!)

I'm a total novice with all of this, so go easy on me please!

[Fustrate]

Can you go into your database and check (db_prefix)awards to see if they still exist there? If they do, delete them from that table, and delete any rows in (db_prefix)awards_members that have that award's id as id_award. Also delete the file from your awards folder.

[mummyk]

OK, thanks, I'll see if I can find that! 

I may be gone some time......

[SgtMic]

So, if I delete the 3 existing tables, install the mod and let it create new tables, it installs fine.
But, it only creates 2 tables, awards and awards_categories.
So after installing, I imported the "old" awards_members table and deleted the members that were in there.
So far seems to work and no errors.

1 question, how can I make the box smaller/ narrower?

[SgtMic]

Take back the no errors part.

Receiving 2 specific errors for every member.


http://thesquadbay.com/forums/index.php?/topic,2900.msg30063.html
Apply Filter: Only show the errors with the same message
8: Undefined index: height
Apply Filter: Only show the errors from this file
File: /home/thesqua1/public_html/forums/Themes/default/Display.template.php (main sub template - eval?)
Line: 317

http://thesquadbay.com/forums/index.php?/topic,2900.msg30063.html
Apply Filter: Only show the errors with the same message
8: Undefined index: width
Apply Filter: Only show the errors from this file
File: /home/thesqua1/public_html/forums/Themes/default/Display.template.php (main sub template - eval?)
Line: 317


Lines 305-323 of the display.template.php

Code Select Expand

// Show their awards?
if (!empty($message['member']['awards']) && $modSettings['awards_in_post'] > 0){
echo '
<li>
<fieldset style="border: 1px solid black; padding: 5px;">
<legend>', $txt['awards'], '</legend>';

// Couldn't limit it in Load.php, so let's do it here.
$awards = 0;
foreach ($message['member']['awards'] as $award){
if($awards < $modSettings['awards_in_post'])
echo '
<a href="', $scripturl, $award['more'], '"><img src="', dirname($scripturl), $award['img'], '" width="', $award['width'], '" height="', $award['height'], '" alt="', $award['description'], '" title="', $award['description'], '" /></a> ';
$awards++;
}

echo '
</fieldset>
</li>';

[aED]

You can check your awards table and see if the fields width and height are named in lowercase letters the last time I got those errors, I checked my db and found out that some fields have names in uppercase.

[Fustrate]

get rid of the hieght and width parts. They don't exist anymore.

[MMcGrad2]

Definately make this 2.0 RC1 PLEASE!

[SgtMic]

My awards table has no height or width fields. It has a total of 7 fields.

Here is what I get when I add/modify in aqdmin.

http://thesquadbay.com/forums/index.php?action=admin;area=awards;sa=assign;ad5c3de8e8=ab62ced010b29ea1f0c184cd3cf0715f
Apply Filter: Only show the errors with the same message
8: Undefined index: to_value
Apply Filter: Only show the errors from this file
File: /home/thesqua1/public_html/forums/Themes/default/ManageAwards.template.php (assign sub template - eval?)
Line: 236