Member Awards (2.0 Compatible!)

[edi67]

hey jay i saw ur explanation for this error:

Database Error
Unknown column 'awardName' in 'field list'
File: /home/bradriem/public_html/forums/Sources/ManageAwards.php
Line: 322

but i dont understand what i need to look for, can you help?

same error for me too:

Code Select Expand

Database Error : Unknown column 'awardName' in 'field list'
File: /home2/crazyzonews/www/Sources/ManageAwards.php
Linea: 193

some solution please?

[JayBachatero]

Does Joomla have "articles"?  if so, you could create an article that displayed all of the images...

I dont believe it does.

it has the same function, just a different name, so yes you could do it

------------------------------------------------------------------------------

Jay, I have a question

I have some awards that we give out to members monthly - is it possible to give someone the same award more than once?

eg we have a member of the month award, which members can win more than once.  Normally we have a group with a badge for this and it's displayed on their posts, but I would also like to use the member awards to keep a record of this in their profiles.  I tried to award a test award to a member for a second time but even though it let me save it, it doesnt show in their profile twice.

did I do something wrong or does it not work that way?

~thanks

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

hey jay i saw ur explanation for this error:

Database Error
Unknown column 'awardName' in 'field list'
File: /home/bradriem/public_html/forums/Sources/ManageAwards.php
Line: 322

but i dont understand what i need to look for, can you help?

Is this a fresh install?  Seems like that column is missing from the database.

Okay now, I erased everything and started all over again and again and again and again

Check the permissions for the files.  Are you able to install other mods?

I keep getting these errors back n forth in my error log:

Code Select Expand



8: Undefined index: pa_mods
File: /home/decisive/public_html/daspot/Sources/Subs.php
Line: 2828

8: Undefined index: awards
File: /home/decisive/public_html/daspot/Sources/Subs.php
Line: 2830

WAT TO DO!!

You have missing language strings.  Check /Themes/default/languages/Modifications.english.php and see if you have those two language strings.

@edi67 - is this a fresh install?

[edi67]

yes fresh installa, new installation the first time.

what i can try to do ? delete Table in DB and reinstall again ?

everything after mod installation seems work good but when i try to aDD new awards i had that error and nothing appear only error line

[NFM]

I keep getting this error

// Pogo Awards adminIndex text strings. $txt['awards'] = 'Awards'; $txt['pa_view_album'] = 'View member\'s badge album.'; $txt['pa_mods'] = 'Mods'; $txt['whoallow_pogoawards'] = 'Managing Awards.';

[Photoshocker]

Ok in Display.php find

Code Select Expand


mysql_free_result($request);
$posters = array_unique($posters);


Add after

Code Select Expand


// Load the members awards
$awards_request = db_query("
SELECT pab.filename, pam.ID_MEMBER
FROM {$db_prefix}awards_members AS pam
LEFT JOIN {$db_prefix}awards AS pab ON (pab.ID_AWARD = pam.ID_AWARD)
WHERE pam.ID_MEMBER IN (" . implode(', ', $posters) . ")", __FILE__, __LINE__);

$context['awards'] = array();
$context['awards'][$row['ID_MEMBER']] = array();
while ($row = mysql_fetch_assoc($awards_request))
$context['awards'][$row['ID_MEMBER']][] = '<img src="' . dirname($scripturl) . '/' . (empty($modSettings['pa_awardsDir']) ? '' : $modSettings['pa_awardsDir'] . '/') . $row['filename'] . '" alt="' . $row['filename'] . '" />';

mysql_free_result($awards_request);



In Display.template.php find

Code Select Expand


// Show avatars, images, etc.?
if (!empty($settings['show_user_images']) && empty($options['show_no_avatars']) && !empty($message['member']['avatar']['image']))
echo '
<div style="overflow: auto; width: 100%;">', $message['member']['avatar']['image'], '</div><br />';



Add after

Code Select Expand


// Show the fav award
if (isset($context['awards'][$message['member']['id']]))
{
echo '
<div style="overflow: auto; width: 100%;">';
foreach ($context['awards'][$message['member']['id']] as $badge)
echo '
', $badge;
echo '
</div><br />';
}


Hi can you pls tell me how to put award below sigs cause this one doesnt work, thanks..

[gtron]

this may sounds stupid but how do i give someone an award after winning a contest or something

like this: http://www.ampprod.com/forum/index.php?topic=6008.0

[gtron]

^ nvm, i figured it out lol  

[Monniemoo]

Every time I go into my profile, I get this error:

Fatal error: Cannot redeclare awards() (previously declared in /home/troubleb/public_html/dollcon/Sources/Profile.php:2893) in /home/troubleb/public_html/dollcon/Sources/Profile.php on line 3052

I've heard it's because I installed it multiple times, when reading through this topic. My only problem: it's no longer installed. In fact, I completely removed it from my list of packages. And yet, the Awards mod is still there (in the Admin panel), and I still can't access any profiles on the entire site.

Anyone have any idea how to fix this?

[GPGrieco]

When I install it I get this text at the top of every page:

// Pogo Awards adminIndex text strings. $txt['awards'] = 'Awards'; $txt['pa_view_album'] = 'View member\'s badge album.'; $txt['pa_mods'] = 'Mods'; $txt['whoallow_pogoawards'] = 'Managing Awards.';

and all the text gets bigger

[KreedGhost]

The only problem I am having with this mod is the fact that I have changed the file to ManageAwards.englis-utf8.php like I have had to do with alot of mods for them to work, but I still don't have any admin buttons inthe admin area to upload and asign awards to members. Also in the members profile there is not link where is should say "show awards"

[makphisto]

Hi,
I love - LOVE - this mod.  I browsed thru the 28 pages, but I may have missed an answer to this so I apologize if that's the case.
I want a LINK to a members awards to show up in their posts, like below their member name somewhere.  Any idea on how to do that?  I don't need a graphic, or show their favorite award or anything, I just want people to be able to bypass going to the users profile first, THEN clicking Awards, I want to be able to do that directly from the post.  Thanks!

UPDATE: I figured it out.  In the Display.template.php file I placed this code in my show_profile_buttons section:

Code Select Expand


// Awards
echo '
<a href="', $scripturl, '?action=profile;sa=awards;uid=', $message['member']['id'], '">', ($settings['use_image_buttons'] ? '<img src="' . $settings['images_url'] . '/award.gif"  alt="' . $txt[999] . '" title="' . $txt[999] . '" border="0" />' : $txt[999]), '</a>';

Then I put the awards.gif icon in the right spot. Viola.  Thanks.

[NFM]

When I install it I get this text at the top of every page:

// Pogo Awards adminIndex text strings. $txt['awards'] = 'Awards'; $txt['pa_view_album'] = 'View member\'s badge album.'; $txt['pa_mods'] = 'Mods'; $txt['whoallow_pogoawards'] = 'Managing Awards.';

and all the text gets bigger

I fixed that.  It's in the Modifications.English file in the Languages folder.  You'll notice that it will come up after the php> You need to cut it and paste it inside and before the php> that's how I fixed it.

[Herman's Mixen]

I fixed that.  It's in the Modifications.English file in the Languages folder.  You'll notice that it will come up after the php> You need to cut it and paste it inside and before the php> that's how I fixed it.

That's an mismatch in the build of the install.xml file the mod creator did a wrong position add coz xml format is way different than the install.mod file in a mod file it will be <add before> in the xml file it has to be like this for example

Code Select Expand


<Search position="after">serachcode</search>
<add><![CDATA[// code added........]></add>


[bigggnick]

Hey all,

i wanted a reward system for my site. So i found this mod, http://custom.simplemachines.org/mods/index.php?mod=475. I went to install it but got all these errors:
Code:

Awards Database Changes


      Warning: mysql_query() [function.mysql-query]: Access denied for user 'apache'@'localhost' (using password: NO) in /home/nickgcom/domains/nickscomputing.com/public_html/forum/install.php on line 16

      Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/nickgcom/domains/nickscomputing.com/public_html/forum/install.php on line 16
    * Error: Adding {$db_prefix}awards_members table failed.

      Warning: mysql_query() [function.mysql-query]: Access denied for user 'apache'@'localhost' (using password: NO) in /home/nickgcom/domains/nickscomputing.com/public_html/forum/install.php on line 39

      Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/nickgcom/domains/nickscomputing.com/public_html/forum/install.php on line 39
    * Error: Adding {$db_prefix}awards_badges table failed.

      Warning: mysql_query() [function.mysql-query]: Access denied for user 'apache'@'localhost' (using password: NO) in /home/nickgcom/domains/nickscomputing.com/public_html/forum/install.php on line 59

      Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/nickgcom/domains/nickscomputing.com/public_html/forum/install.php on line 59
    * Error: The installer was unable to add some settings for the mod. To enable go to Admin > Pogo Awards > Settings and enter the desires info.
    * The Member Awards mod was successfully installed. Click here to add an award.


Any help?

Thanks

[Monniemoo]

Every time I go into my profile, I get this error:

Fatal error: Cannot redeclare awards() (previously declared in /home/troubleb/public_html/dollcon/Sources/Profile.php:2893) in /home/troubleb/public_html/dollcon/Sources/Profile.php on line 3052

I've heard it's because I installed it multiple times, when reading through this topic. My only problem: it's no longer installed. In fact, I completely removed it from my list of packages. And yet, the Awards mod is still there (in the Admin panel), and I still can't access any profiles on the entire site.

Anyone have any idea how to fix this?

Can someone please help me with this problem? I really can't work on my forum too much more until I'm able to look at profiles again...

[littleone]

Every time I go into my profile, I get this error:

Fatal error: Cannot redeclare awards() (previously declared in /home/troubleb/public_html/dollcon/Sources/Profile.php:2893) in /home/troubleb/public_html/dollcon/Sources/Profile.php on line 3052

I've heard it's because I installed it multiple times, when reading through this topic. My only problem: it's no longer installed. In fact, I completely removed it from my list of packages. And yet, the Awards mod is still there (in the Admin panel), and I still can't access any profiles on the entire site.

Anyone have any idea how to fix this?

Can someone please help me with this problem? I really can't work on my forum too much more until I'm able to look at profiles again...

You need to go into those 2 files and find where the code is duplicated and remove it.  You must have had the mod on ur forum before and it didnt uninstall right, or it was interrupted during install.  In any event its trying to "redeclare" meaning its on there twice.  Find it, remove the duplicate code, and you should be fine.

Hey all,

i wanted a reward system for my site. So i found this mod, http://custom.simplemachines.org/mods/index.php?mod=475. I went to install it but got all these errors:
Code:

Awards Database Changes


      Warning: mysql_query() [function.mysql-query]: Access denied for user 'apache'@'localhost' (using password: NO) in /home/nickgcom/domains/nickscomputing.com/public_html/forum/install.php on line 16

      Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/nickgcom/domains/nickscomputing.com/public_html/forum/install.php on line 16
    * Error: Adding {$db_prefix}awards_members table failed.

      Warning: mysql_query() [function.mysql-query]: Access denied for user 'apache'@'localhost' (using password: NO) in /home/nickgcom/domains/nickscomputing.com/public_html/forum/install.php on line 39

      Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/nickgcom/domains/nickscomputing.com/public_html/forum/install.php on line 39
    * Error: Adding {$db_prefix}awards_badges table failed.

      Warning: mysql_query() [function.mysql-query]: Access denied for user 'apache'@'localhost' (using password: NO) in /home/nickgcom/domains/nickscomputing.com/public_html/forum/install.php on line 59

      Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/nickgcom/domains/nickscomputing.com/public_html/forum/install.php on line 59
    * Error: The installer was unable to add some settings for the mod. To enable go to Admin > Pogo Awards > Settings and enter the desires info.
    * The Member Awards mod was successfully installed. Click here to add an award.


Any help?

Thanks

Im not na expert, but from what I gather as the first error indicates and as the other mention, it couldnt connect to your database.  Possibly your password is wrong in your settings or it just couldnt connect when u were trying to do it.  Uninstall and reinstall and see if that fixes thing for u.  Otherwise you'll need to wait for Jay to respond since he is the expert

[bigggnick]

i got a different award system, it works fine but thanks for the reply anyway

[weissefar]

Sorry if this question has already been asked, but I am trying to grasp the features of this mod. I would like to know, how a normal registered user can see, which award has been given to other users? Is there a global list of this, or do a certain registered user have to walk through the member list looking into each members profil in order to see, whether this person has received an award? If there is no global list to see all awards given, then I would like to suggest that for a future update

Another kind suggestion to a future update is to apply some kind of award indication to the member list, so members easily can see on the member list, if a member has received an award.

[littleone]

You can view what awards a member has by going to their profile.  If you see a reward in a members profile and want to know how many have that same award, you just click on it, and it lists all the members who have that badge.

[Monniemoo]

Every time I go into my profile, I get this error:

Fatal error: Cannot redeclare awards() (previously declared in /home/troubleb/public_html/dollcon/Sources/Profile.php:2893) in /home/troubleb/public_html/dollcon/Sources/Profile.php on line 3052

I've heard it's because I installed it multiple times, when reading through this topic. My only problem: it's no longer installed. In fact, I completely removed it from my list of packages. And yet, the Awards mod is still there (in the Admin panel), and I still can't access any profiles on the entire site.

Anyone have any idea how to fix this?

Can someone please help me with this problem? I really can't work on my forum too much more until I'm able to look at profiles again...

You need to go into those 2 files and find where the code is duplicated and remove it.  You must have had the mod on ur forum before and it didnt uninstall right, or it was interrupted during install.  In any event its trying to "redeclare" meaning its on there twice.  Find it, remove the duplicate code, and you should be fine.

I did what you said, then got another error, which I fixed, but then I got yet another error which I can't figure out...

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/troubleb/public_html/dollcon/Sources/Profile.php on line 2908

Still in my profile. I did uninstall the mod too, and it's still there...and all this is in a piece of the code that is still there that relates to the mod.

What can I do?