vb.org Archive - Major Additions - [DBTech] vBActivity & Awards v3 (vB4)

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)

Thanks for responding! I'll let them know and hopefully get them to go pro :D

installed pro version but not seeing it show up anywhere in the admin cp except for under the options. please advise.

Install Lite New Update but when i click the activity
showing database error

Code:

Database error in vBulletin 4.2.0:

 

Invalid SQL:

 

        SELECT

                pointslog.*,

                user.*

                , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb                        

                

        FROM dbtech_vbactivity_pointslog AS pointslog

        LEFT JOIN user AS user ON (user.userid = pointslog.userid)

        

        LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)

        LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)

        

        WHERE 

                user.dbtech_vbactivity_excluded_tmp = '0'

        ORDER BY dateline DESC                        

        LIMIT 0, 20;

 

MySQL Error   : Incorrect key file for table '/tmp/#sql_1683_1.MYI'; try to repair it

Error Number  : 126

Request Date  : Monday, February 3rd 2014 @ 06:36:06 PM

Error Date    : Monday, February 3rd 2014 @ 06:36:37 PM

Script        : http://www.**********.com/vbactivity.php?do=activity

Referrer      : http://www.********.com/usercp.php

IP Address    : 12******65

Username      : b*****n

Classname     : v*******e

MySQL Version :

Me again!

OK, so we're having an issue and I want to check if it is something which is working correctly, or if we're having a bug.

In the settings for vbactivity -> activity stat settings -> Activity Target

I manually change this to 5 since that is our weekly goal (making 20 our monthly) for members to keep track of whether or not they are close to hitting our posting requirements simply by looking at their postbits.

Downside? At least once a day it is auto changing itself.

"This setting controls the target number of points your members will be attempting to achieve.
vBActivity will automatically suggest a recommended target based on the past week of activity, but you can manually override it via this setting."

I read this and understood that by changing the number it would override this feature - any idea why it keeps resetting it and ignoring my number? How can I disable this?

Quote:

Originally Posted by tanzeelniazi (Post 2478820)

Install Lite New Update but when i click the activity
showing database error

Code:

Database error in vBulletin 4.2.0:

 

Invalid SQL:

 

        SELECT

                pointslog.*,

                user.*

                , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb                        

                

        FROM dbtech_vbactivity_pointslog AS pointslog

        LEFT JOIN user AS user ON (user.userid = pointslog.userid)

        

        LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)

        LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)

        

        WHERE 

                user.dbtech_vbactivity_excluded_tmp = '0'

        ORDER BY dateline DESC                        

        LIMIT 0, 20;

 

MySQL Error   : Incorrect key file for table '/tmp/#sql_1683_1.MYI'; try to repair it

Error Number  : 126

Request Date  : Monday, February 3rd 2014 @ 06:36:06 PM

Error Date    : Monday, February 3rd 2014 @ 06:36:37 PM

Script        : http://www.**********.com/vbactivity.php?do=activity

Referrer      : http://www.********.com/usercp.php

IP Address    : 12******65

Username      : b*****n

Classname     : v*******e

MySQL Version :

Repair the table via phpMyAdmin :)

Quote:

Originally Posted by xxdestinyxx (Post 2479570)

You need to up the "Activity Target: Minimum Points" instead, to make the calculation function that resets that number set a better target for your forum.

You should decide on the target number by investigating the average points per day/week/month of your forum and how it gains, then find a good middle ground.

Fillip

Ok, we're not using it for that purpose though. As long as I know it's not a bug I'll reset it every morning to the one we want. :)

Thanks for letting me know!

many time i repair tabel but crash when i open url http://www.xyz.com/vbactivity.php?do=activity not working and then i rec email database error

Im new to this addon, could someone message me how to use it, i have it all installed but category criteria and achievements and awards is all blank. I tried to figure it out and got confused.

vBActivity & Awards v3.1.5

New Features Added

Translations

Achievement titles / descriptions
Category titles / descriptions
Award titles / descriptions

Fillip

X vBulletin 3.8.12 by vBS Debug 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 (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01857 seconds Memory Usage 1,752KB 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 (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)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
Messages: