Achievements Mod Support (Modzzz)

This is the support forum for the Achievements mod.

Version 2.0.1 released. (See patches/version_2.0.1 folder in zip file)

Adds Achievements for Shoutbox Posts, Store Products and Polls created.

Adds the ability to disable an Achievement.

Modzzz,

I have been getting a lot of Database error

Query:

SELECT `id_profile`, count(`id_profile`) as Cnt FROM `bx_poll_data` WHERE `poll_status` = 'active' AND `poll_approval` = 1 AND `id_profile` NOT IN (SELECT `member_id` FROM `modzzz_achieve_main` WHERE `achieve_id`=35) GROUP BY `id_profile` HAVING `Cnt` >= 20

Mysql error: Table 'iamassyr_dol703new.bx_poll_data' doesn't exist

Found error in the file '/home/iamassyr/public_html/modules/modzzz/achieve/classes/BxAchieveDb.php' at line 411.
Called 'getAll' function with erroneous argument #0.

 You do not have the Polls mod installed. Go to the Admin section for Achievements and disable the Achievements for modules that you do not have installed.

SELECT `id_profile`, count(`id_profile`) as Cnt FROM `bx_poll_data` WHERE `poll_status` = 'active' AND `poll_approval` = 1 AND `id_profile` NOT IN (SELECT `member_id` FROM `modzzz_achieve_main` WHERE `achieve_id`=35) GROUP BY `id_profile` HAVING `Cnt` >= 20

Version 2.0.2 released. (See patches/version_2.0.2 folder in zip file)

Modifies Admin management of Achievements :
 a) Ability to re-enable a disabled Achievement was missing.
 b) Disabled Achievements are now shown as grayed out.

Adds missing Achievement icons.

Hey Modzzz,

I happened to notice that achievements are not automatically being sent to the users. For example, I had 2 members login on Christmas Day but they did not get the Christmas achievement.

I have noticed other achievements are not being sent automatically as well. I am not sure if this has anything to do with these members being 'existing' members or not. Can you please look into this and let me know what you find?

Version 2.0.3 released. (See patches/version_2.0.3 folder in zip file)

Fixes issue where member received the same achievement multiple times.

Excellent,

Thanks!

 Ok that patch appears to have done the trick.

BUT,

It I see that a one of my members who logged in today to check out the the new feature didn't get the "Happy New Years" Achievement

 I as admin didn't get the New Years achievement either, but i have like 6 other achievements that I did receive.

@UnderDog4All , correct me 2..

I have check both your site and database and you and your members did receive the Achievements for Christmas and New Year.

Actually, I manually assigned the New Years achievement. But I didn't assign one to myself as admin. If you login to my site, and go to the profile page of admin, you'll see I have the Achievement block at the top of the left column. There is no achievement displayed there for News Years. NOTE: I purchased Achievements after Christmas so there's no expectation to see any Achievements there for logging in on Christmas in my case.

My response was made to the comment of mydatingcommunity. I was talking about his site, not yours.

Dear Modzzz,

1 of my member got 1000 Member Achievements, because she was number 1000. However, I have deleted some members and she is NOT 1000. Could you please add a rest number for that  achievement?

Thanks

maybe some  bugs

1. achievement name in email isn't right

2. im not able to delete my achievements that i recieved

3. when you view someones profiles and click on one of the achievements a pop-up windows show up with the pic.
when you close it and click on the login button the same window shows up you are not able  to login.

will try it on a new installation and see how it goes

same on new installed 7.0.8

I was able to confirm that you cannot delete an achievement. The page just refreshes.

Example: I created a demo user. I assigned a achievement as the admin to the Demo user.

I logged in as demo and tried to delete the achievement and it didnt work. The page just refreshes and the achievement is still there.

 I have the same issue... added two achievements then tried to delete them... nothing happened.

Also checked the emails sent out... the achievement types mentioned in the messages are not the ones displayed in "My Achievements".

Version 2.0.4 released. (See patches/version_2.0.4 folder in zip file)

Fixes issue where wrong achievement is shown in email when Administrator assigns an achievement to a member.
 
Fixes issue with members deleting achievements.

Fixes issue with login popup box not showing after achievements popup box is clicked.

Install the patch. Test delete... works but I get two warning on My Achievments (Main) page:

Warning: Missing argument 2 for BxDolTwigModule::_browseMy(), called in /public_html/inc/classes/BxDolTwigModule.php on line 905 and defined in/public_html/inc/classes/BxDolTwigModule.php on line 3037

Warning: Cannot modify header information - headers already sent by (output started at /public_html/inc/classes/BxDolTwigModule.php:3037) in /public_html/inc/design.inc.php on line 143

DB error:

Query:  SELECT COUNT(`id`) FROM `modzzz_achieve_achievements` WHERE `active`=1 AND
`category_id`=modules Mysql error: Unknown column 'modules' in 'where clause'

 Found error in the file
'/home/[account name]/public_html/modules/modzzz/achieve/classes/BxAchievePageMain.php'
at line 71.
 

Called 'getOne' function with erroneous argument #0.

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

Also, after deleting the achievement... my site automatically reissued it to me (admin account).  I again deleted it and again reissued it to me.  Apparently I really do deserve the award *LOL*... or something needs to be reset.  The good news is that the name of the achievement award in the email matched the name on the My Achievements page... so that bug appears to be fixed.

It appears that if I assign the Achievement Award to someone, then it's deleted from that account, then it does not get automatically reissued... so the bug is partially fixed ;-)

 Please re-apply the patch.

Query:  SELECT COUNT(`id`) FROM `modzzz_achieve_achievements` WHERE `active`=1 AND
`category_id`=modules Mysql error: Unknown column 'modules' in 'where clause'

 Found error in the file
'/home/[account name]/public_html/modules/modzzz/achieve/classes/BxAchievePageMain.php'
at line 71.
 

Dear Modzzz,

any solution for my issue?

1 of my member got 1000 Member Achievements, because she was number 1000. However, I have deleted some members and she is NOT 1000. Could you please add a rest number for that  achievement?

Thanks

 I believe this is a issue with how Dolphin issues Profile IDs and not the module itself. For example, no matter if you delete member '3', the next new member will automatically use ProfileID '4' instead of re-using '3'.

 Yeah, why is that? I don't like it. I'm kinda anal that way, and want my members to represent the order in which they joined. Like it or not, some people take pride in knowing where that stand among the committed once the site becomes populated with members. Can I get around this?

 I reapplied the patch... no change.  Only happens to page: /m/achieve/browse/my

Query:  SELECT COUNT(`id`) FROM `modzzz_achieve_achievements` WHERE `active`=1 AND
`category_id`=modules Mysql error: Unknown column 'modules' in 'where clause'

 Found error in the file
'/home/[account name]/public_html/modules/modzzz/achieve/classes/BxAchievePageMain.php'
at line 71.
 

I checked your site and the patch was not re-applied (maybe you did not re-download the updated version). I have logged in to your site and updated it. The problem should be resolved now.

Query:  SELECT COUNT(`id`) FROM `modzzz_achieve_achievements` WHERE `active`=1 AND
`category_id`=modules Mysql error: Unknown column 'modules' in 'where clause'

 Found error in the file
'/home/[account name]/public_html/modules/modzzz/achieve/classes/BxAchievePageMain.php'
at line 71.
 

 Confirmed - works now. Thank you very much for fixing it. I know you're very busy and I appreciate your help.

Query:  SELECT COUNT(`id`) FROM `modzzz_achieve_achievements` WHERE `active`=1 AND
`category_id`=modules Mysql error: Unknown column 'modules' in 'where clause'

 Found error in the file
'/home/[account name]/public_html/modules/modzzz/achieve/classes/BxAchievePageMain.php'
at line 71.
 

I installed Achievements version 2.0.4 on a new install of Dolphin 7.0.9 without any problems.

SELECT `id_profile`, count(`id_profile`) as Cnt FROM `bx_events_participants` WHERE `id_profile` NOT IN (SELECT `member_id` FROM `modzzz_achieve_main` WHERE `achieve_id`=12) AND `confirmed` = 1 GROUP BY `id_profile` HAVING `Cnt` >= 100

Mysql error: Table 'xxxxxxxxxxxxxxxxxx.bx_events_participants' doesn't exist

i do not have the events module installed
achieve_id`=12  would be the Popular Member achievement

achievements i have enabled

Very Friendly, Photographer, Movie King, Popular Member, Master of Correspondence, Graduate, Happy Birthday,  Frequent Visitor,Forum Host,Forum Analyst, Active Blogger, Active Commentator, I Scream

after looking in BxAchieveDb.php
none of my enabled achievements use bx_events_main or bx_events_participants

one does

case 'event_fan':
             
                    $sQuery = "SELECT `id_profile`, count(`id_profile`) as Cnt FROM `bx_events_participants` WHERE `id_profile` NOT IN (SELECT `member_id` FROM `" . $this->_sPrefix . "main` WHERE `achieve_id`=$iAchievementId) AND `confirmed` = 1 GROUP BY `id_profile` HAVING `Cnt` >= $iThreshold"; 

i do not have any fan related achievement enabled.

 I cannot see how this could have occurred with manual adjustment of the database entries.

Version 2.0.5 released. (See patches/version_2.0.5 folder in zip file)

Add option for admin to turn off/on resizing of images. Dolphin does not handle resizing of transparent images well so if you are adding new images and you already have them at the correct size, you can deactivate resizing and prevent any distortion.

 After applying this update, I have a database error and NONE of my members can access their profiles.

What info do you need?

DO you want me to post here or forward the email?

JUST FOUND OUT- A person was joining at the same moment I ran the update file

 I have already emailed you.

We are rockin' and rollin' again! I'll try to pay more attention my patching. Thanks again man- You rock!

Just bought and downloaded the zip.

But why is there an extra en.php in the Achieve_files folder? (the language contents are all related to the modzzz points module)

 Thanks for pointing it out. It is not needed, ignore it.

Is there plans to integrate points into achievements so I can reward members?

Thanks!

For next version,

possible to hide those categories which has zero achievement items?

 I will consider this.

 I have adjusted this. Download and replace this file :

    modules\modzzz\achieve\classes\BxAchievePageMain.php

Cool! Replaced and it works! :)

Thanks!

Version 2.0.6 released. (See patches/version_2.0.6 folder in zip file)

Adds the ability to award members points when they gain an achievement.

Think I found a bug.

When I go to http://yoursite.com/m/achieve/administration/achievements, edit an achievement and save it, the default date of 1st January will be saved along with it. (Just checked database table 'achieve_achievements' and the 1st January date is saved.)

Does this mean the achievement like 'Very Friendly' or 'Photographer' won't work because the date is set to 1st Jan?

Not a bug. There is an explanation above the date section that tells you that it is only needed for date specific achievements. If the date is not changed then it is natural that the default will be saved.

 Roger. Thanks for the explanation.

I have no news since the 23.05.12 and some e-mails i sent to you. I know you gotta have a lot of work, but I need to know when you can make the changes that I paid for.

Its urgent, thanks

Regards,

S.C.

Hi,

After installing the achievement module last night, my site went down frequently every 15 minutes. After investigating, there are some achievement has slow queries that is causing too many connections because the query  taking up too much time is as below. I disabled the achievements that has query related issues, and as per the logs, here are the queries:

SET timestamp=1342445573; 

SELECT `ID` FROM `Profiles` WHERE `Status` = 'Active' AND `ID` NOT IN (SELECT `member_id` FROM `modzzz_achieve_main` WHERE `achieve_id`=2 AND YEAR(FROM_UNIXTIME(`created`)) = YEAR(CURDATE())) AND MONTH(`DateLastLogin`) = 1 AND DAY(`DateLastLogin`) = 1 AND YEAR(`DateLastLogin`) = YEAR(CURDATE()); 

# Time: 120716 8:33:41 

# Query_time: 48.740152 Lock_time: 0.001693 Rows_sent: 0 Rows_examined: 198697067 

SET timestamp=1342445621; 

SELECT `Owner`, count(`Owner`) as Cnt FROM `bx_photos_main` WHERE `Status` = 'approved' AND `Owner` NOT IN (SELECT `member_id` FROM `modzzz_achieve_main` WHERE `achieve_id`=4) GROUP BY `Owner` HAVING `Cnt` >= 20; 

# Time: 120716 8:36:29 

# Query_time: 167.698758 Lock_time: 0.000089 Rows_sent: 0 Rows_examined: 685548036 

SET timestamp=1342445789; 

SELECT COUNT(`Owner`) AS Cnt, `Owner` FROM `sys_albums` WHERE `Owner` NOT IN (SELECT `member_id` FROM `modzzz_achieve_main` WHERE `achieve_id`=5) AND `Type`='bx_photos' AND `Status`='active' AND `Caption` != 'Hidden' GROUP BY `Owner` HAVING COUNT(`Owner`) >= 5; 

# Time: 120716 8:37:54 

# Query_time: 172.596160 Lock_time: 0.000041 Rows_sent: 0 Rows_examined: 698829006 

SET timestamp=1342445874; 

SELECT `ID` FROM `Profiles` WHERE `Status` = 'Active' AND `ID` NOT IN (SELECT `member_id` FROM `modzzz_achieve_main` WHERE `achieve_id`=2 AND YEAR(FROM_UNIXTIME(`created`)) = YEAR(CURDATE())) AND MONTH(`DateLastLogin`) = 1 AND DAY(`DateLastLogin`) = 1 AND YEAR(`DateLastLogin`) = YEAR(CURDATE()); 

# Time: 120716 8:39:37 

# Query_time: 187.661077 Lock_time: 0.000024 Rows_sent: 0 Rows_examined: 764173731 

SET timestamp=1342445977; 

SELECT COUNT(`Owner`) AS Cnt, `Owner` FROM `sys_albums` WHERE `Owner` NOT IN (SELECT `member_id` FROM `modzzz_achieve_main` WHERE `achieve_id`=7) AND `Type`='bx_sounds' AND `Status`='active' AND `Caption` != 'Hidden' GROUP BY `Owner` HAVING COUNT(`Owner`) >= 5; 

use okatanan_dol703; 

SET timestamp=1342445573; 

SELECT `ID` FROM `Profiles` WHERE `Status` = 'Active' AND `ID` NOT IN (SELECT `member_id` FROM `modzzz_achieve_main` WHERE `achieve_id`=2 AND YEAR(FROM_UNIXTIME(`created`)) = YEAR(CURDATE())) AND MONTH(`DateLastLogin`) = 1 AND DAY(`DateLastLogin`) = 1 AND YEAR(`DateLastLogin`) = YEAR(CURDATE()); 

# Time: 120716 8:33:41 

# User@Host: okatanan_dol703[okatanan_dol703] @ localhost [] 

# Query_time: 48.740152 Lock_time: 0.001693 Rows_sent: 0 Rows_examined: 198697067 

SET timestamp=1342445621; 

SELECT `Owner`, count(`Owner`) as Cnt FROM `bx_photos_main` WHERE `Status` = 'approved' AND `Owner` NOT IN (SELECT `member_id` FROM `modzzz_achieve_main` WHERE `achieve_id`=4) GROUP BY `Owner` HAVING `Cnt` >= 20; 

# Time: 120716 8:36:29 

# User@Host: okatanan_dol703[okatanan_dol703] @ localhost [] 

# Query_time: 167.698758 Lock_time: 0.000089 Rows_sent: 0 Rows_examined: 685548036 

SET timestamp=1342445789; 

SELECT COUNT(`Owner`) AS Cnt, `Owner` FROM `sys_albums` WHERE `Owner` NOT IN (SELECT `member_id` FROM `modzzz_achieve_main` WHERE `achieve_id`=5) AND `Type`='bx_photos' AND `Status`='active' AND `Caption` != 'Hidden' GROUP BY `Owner` HAVING COUNT(`Owner`) >= 5; 

# Time: 120716 8:37:54 

# User@Host: okatanan_dol703[okatanan_dol703] @ localhost [] 

# Query_time: 172.596160 Lock_time: 0.000041 Rows_sent: 0 Rows_examined: 698829006 

SET timestamp=1342445874; 

SELECT `ID` FROM `Profiles` WHERE `Status` = 'Active' AND `ID` NOT IN (SELECT `member_id` FROM `modzzz_achieve_main` WHERE `achieve_id`=2 AND YEAR(FROM_UNIXTIME(`created`)) = YEAR(CURDATE())) AND MONTH(`DateLastLogin`) = 1 AND DAY(`DateLastLogin`) = 1 AND YEAR(`DateLastLogin`) = YEAR(CURDATE()); 

# Time: 120716 8:39:37 

# User@Host: okatanan_dol703[okatanan_dol703] @ localhost [] 

# Query_time: 187.661077 Lock_time: 0.000024 Rows_sent: 0 Rows_examined: 764173731 

SET timestamp=1342445977; 

SELECT COUNT(`Owner`) AS Cnt, `Owner` FROM `sys_albums` WHERE `Owner` NOT IN (SELECT `member_id` FROM `modzzz_achieve_main` WHERE `achieve_id`=7) AND `Type`='bx_sounds' AND `Status`='active' AND `Caption` != 'Hidden' GROUP BY `Owner` HAVING COUNT(`Owner`) >= 5; 

Looking forward to optimize the above queries in order to enable the related achievements. 

`

Hello Modzzz,

Can you update this for 7.1?