vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - [DBTech] vBActivity & Awards v3 (vB4) (https://vborg.vbsupport.ru/showthread.php?t=236973)

DragonByte Tech 12-10-2012 01:44 PM

The next step is to alter the "Rewards" table that holds every achievement and Award earned by your users. Do you have an exceptionally large userbase? If so, that may be the cause.

You can try running the following query:
Code:

DELETE FROM dbtech_vbactivity_rewards WHERE feature = 'achievement'
That should help lessen the load on your system while you retry the upgrade :)

Afterwards, run the Maintenance function under DBTech - vBActivity and recalculate achievements.


Fillip

GamerPerfection 12-31-2012 09:14 AM

Can you set a starting date for calculation of points? I'm looking for a points mod where I can use it for competitions but starting all point calculation at 0 on a particular date?

DragonByte Tech 12-31-2012 01:00 PM

Yeah, there's a date selector for the Maintenance action that re-calculates points.

Fillip

joshskeety 01-21-2013 01:19 AM

What would cause the "All Achievements" in the encyclopedia to not display the correct number of people who have earned that achievement? I have a forum where dozens of members have earned an achievement and it's only saying a few members have earned it.

https://vborg.vbsupport.ru/external/2013/01/27.png

It's also not updating the Achievements as they're earned on the Recent Changes page.

joshskeety 01-21-2013 10:13 PM

Any ideas? It just seems to be giving stuff to our main Administrators unless we run the recalculate tool. Even then, it's not updating the stuff on the vBactivity page.

DragonByte Tech 01-22-2013 09:42 AM

Can you check the user table and see if the missing users have the dbtech_vbactivity_excluded_tmp column set to 1?

That is the only possibility.

Fillip

joshskeety 01-22-2013 06:00 PM

Yep, they do. I made it 0 in the database but the numbers on the "All Achievements" page still are low. Dates Registered seems to work but not things like Post Count and Threads Made.

EDIT: Now they've all reset back to 1. What am I missing here?

joshskeety 01-23-2013 08:06 AM

Let me try to clear up the confusion too. The achievements work, they're given to everyone as expected. The problem is that on the "All Achievements" page the numbers of users who earned the achievements for Posts/Threads are wrong. Days Registered worked fine.

I believe this is where the issue is happening in allachievements.php

Code:

                        // Check if we've earned this reward or not
                        if ($rewardscache['achievement']["$achievementid"])
                        {
                                // Store time earned
                                $conditions[] = '<span class="smallfont">' . construct_phrase($vbphrase['dbtech_vbactivity_achievement_earned_x'], vbdate($vbulletin->options['timeformat'], $rewardscache['achievement']["$achievementid"]) . ' ' . vbdate($vbulletin->options['dateformat'], $rewardscache['achievement']["$achievementid"])) . '</span>';
                        }
                       
                        if (!empty($friends["$achievementid"]))
                        {
                                if ($others["$achievementid"])
                                {
                                        // We have franz with this achievement
                                        $conditions[] = '<span class="smallfont">' . construct_phrase($vbphrase['dbtech_vbactivity_x_friends_y_others_have_this_achievement'], implode(', ', $friends["$achievementid"]), vb_number_format($others["$achievementid"])) . '</span>';
                                }
                                else
                                {
                                        // We have franz with this achievement
                                        $conditions[] = '<span class="smallfont">' . construct_phrase($vbphrase['dbtech_vbactivity_x_friends_have_this_achievement'], implode(', ', $friends["$achievementid"])) . '</span>';
                                }
                        }
                        else
                        {
                                if ($others["$achievementid"])
                                {
                                        $conditions[] = '<span class="smallfont">' . construct_phrase($vbphrase['dbtech_vbactivity_x_people_have_this_achievement'], vb_number_format($others["$achievementid"])) . '</span>';
                                }
                        }

It's telling me "Others" have earned the achievement, not friends. But the number is so low so it has to be my friends.

DragonByte Tech 01-25-2013 06:27 PM

I'll look into it for a bugfix update :)


Fillip

GONUMBER6 01-31-2013 08:56 PM

Hi, I was just wondering if there was a way to decrease the amount of space this is taking up in my database? I can only imagine how long it will take to back up if my forum keeps growning at the rate it is going....

Specifically reffering to the points log. :)


All times are GMT. The time now is 02:16 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02026 seconds
  • Memory Usage 1,753KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete