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)

demokrit 09-14-2011 11:20 AM

I just installed this and get the following error on all links in the admin CP:
Invalid Action. Go Back.

We have the forum setup at forum.mydomain.com but use www.mydomain.com/forum/ as URL with Apache setup with ProxyPass and ProxyPassReverse. All other functions of the forum is working fine including vBSEO. What may be wrong?

DragonByte Tech 09-14-2011 01:07 PM

Did you upgrade from 2.1.2 or earlier? All URLs in vBA are relative, so I don't believe the URL setup you describe should cause any issues.

If you did upgrade, the upgrade notes has the following instructions:

However, if you experience weird AdminCP navigation menu issues,
please delete the following files from your /includes/xml/ folder:

* bitfield_vbactivity.xml
* bitfield_vbactivity_pro.xml
* cpnav_vbactivity.xml
* cpnav_vbactivity_pro.xml
* hooks_vbactivity.xml
* hooks_vbactivity_pro.xml

Could you please check for the presence of those files?

Fillip

demokrit 09-14-2011 02:52 PM

No, it was a first install. We have never used your addon before (or any of your other addons).

Quote:

* bitfield_vbactivity.xml
* bitfield_vbactivity_pro.xml
* cpnav_vbactivity.xml
* cpnav_vbactivity_pro.xml
* hooks_vbactivity.xml
* hooks_vbactivity_pro.xml

Could you please check for the presence of those files?
None of those files are present in the installation.

DragonByte Tech 09-14-2011 03:03 PM

In that case I don't think there's anything I can do, I have no experience working with the setup you're using :(


Fillip

demokrit 09-14-2011 03:06 PM

It doesn't work even if we access the admin CP by forum.mydomain.com or through www.mydomain.com/forum/. Shouldn't it work for forum.mydomain.com at least? Is there any checks I can do?

DragonByte Tech 09-14-2011 03:12 PM

Have you uploaded the files to their correct folders?

i.e. you didn't accidentally upload the upload folder itself, as opposed to the contents of the upload folder?

It would help if I had the actual domain, I could check for the correct files then :)


Fillip

demokrit 09-15-2011 10:09 AM

Quote:

Have you uploaded the files to their correct folders?
Yes.

Quote:

i.e. you didn't accidentally upload the upload folder itself, as opposed to the contents of the upload folder?
They are uploaded correctly. It installed correctly also as I saw the installing progress in the admin CP. The error appeared after the install was finished and the page was redirected to the addon home page in the CP.

Quote:

It would help if I had the actual domain, I could check for the correct files then
I will send it by PM.

MNNLeafre 10-13-2011 04:29 PM

Are we allowed to edit some things with it?

DragonByte Tech 10-18-2011 04:16 PM

Quote:

Originally Posted by MNNLeafre (Post 2256852)
Are we allowed to edit some things with it?

If you mean edit the code then sure, as long as you do not re-distribute the core product. You can distribute instructions for your edits, but not any vBActivity code :)


Fillip

techanalyst 10-18-2011 04:57 PM

Another modification which my forum users like using, I havent really used the full potential of the modification but for what I have played with I give is an 11/10

RoG Aftermath 10-28-2011 12:50 AM

This may sound like a dumb question but how do users go about requesting and award?

DragonByte Tech 10-28-2011 01:01 AM

As per the first post, that is a Pro-only feature :)


Fillip

RoG Aftermath 10-28-2011 01:23 AM

Quote:

Originally Posted by DragonByte Tech (Post 2262205)
As per the first post, that is a Pro-only feature :)


Fillip


Ok thanks, if i were to upgrade to the pro version would i lose all the achievements and awards and images i have already uploaded? or will they stay there?

DragonByte Tech 10-28-2011 01:31 AM

Upgrading to Pro is seamless and no data loss occurs, as you already have the complete database structure required for the Pro version - Pro is just added code, pretty much :)


Fillip

RoG Aftermath 10-28-2011 02:25 AM

Quote:

Originally Posted by DragonByte Tech (Post 2262211)
Upgrading to Pro is seamless and no data loss occurs, as you already have the complete database structure required for the Pro version - Pro is just added code, pretty much :)


Fillip

Ok thanks for you help its much appreciated. :)

DragonByte Tech 11-19-2011 01:19 AM

vBActivity v3.0.0:
Feature: "Reason" field can be filled out when granting awards.
Feature: Criteria / Points: Profile Completed (when all required profile fields are filled out)
Feature: It is now possible to hide vBActivity features from Guests in the postbit for SEO reasons
Change: Granting an award to a user via the "Manage Users" link now has the award pre-selected
Change: All "List" pages that display usernames now also show a miniature avatar

Majority of this release was focused on improving Activity Contests for the Pro version. More information can be found in the Complete Feature List section of the release post.


Fillip

Baltar 11-20-2011 05:01 PM

I'm installing for the first time. It starts off fine then I'm getting an error message here:

Quote:

Updating

Version Number To: 1.0.2

Altered Table: vb_user
Database Error Database error
The Vinylmation Kingdom Forums database has encountered a problem.
Then it tells me this:

Quote:

Invalid SQL:

UPDATE vb_user AS user
SET dbtech_vbactivity_pointscache = (
SELECT SUM(points) AS numpoints
FROM vb_dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= 1321725343
),
dbtech_vbactivity_pointscache_day = (
SELECT SUM(points) AS numpoints
FROM vb_dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= 1321747200
),
dbtech_vbactivity_pointscache_week = (
SELECT SUM(points) AS numpoints
FROM vb_dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= 1321747200
),
dbtech_vbactivity_pointscache_month = (
SELECT SUM(points) AS numpoints
FROM vb_dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= 1320105600
);

MySQL Error : Column 'dbtech_vbactivity_pointscache' cannot be null
Error Number : 1048
Request Date : Sunday, November 20th 2011 @ 05:55:43 PM
Error Date : Sunday, November 20th 2011 @ 05:55:53 PM
Script : http://www.vinylmationkingdom.com/fo...=productimport
Referrer : ...
IP Address : ...
Username : ...
Classname : vB_Database_MySQLi
MySQL Version : 5.1.30-log
Any advice?

DragonByte Tech 11-20-2011 05:20 PM

Try editing /dbtech/vbactivity/install/110.php and remove the following code:
PHP Code:

self::$db->query_write("
    UPDATE " 
TABLE_PREFIX "user AS user
    SET dbtech_vbactivity_pointscache = (
        SELECT SUM(points) AS numpoints
        FROM " 
TABLE_PREFIX "dbtech_vbactivity_pointslog 
        WHERE userid = user.userid
            AND dateline >= " 
. (TIMENOW 86400) . "
    ),
    dbtech_vbactivity_pointscache_day = (
        SELECT SUM(points) AS numpoints
        FROM " 
TABLE_PREFIX "dbtech_vbactivity_pointslog
        WHERE userid = user.userid
            AND dateline >= 
$today
    ),
    dbtech_vbactivity_pointscache_week = (
        SELECT SUM(points) AS numpoints
        FROM " 
TABLE_PREFIX "dbtech_vbactivity_pointslog
        WHERE userid = user.userid
            AND dateline >= 
$week
    ),
    dbtech_vbactivity_pointscache_month = (
        SELECT SUM(points) AS numpoints
        FROM " 
TABLE_PREFIX "dbtech_vbactivity_pointslog
        WHERE userid = user.userid
            AND dateline >= 
$month
    )
"
); 


Fillip

Baltar 11-20-2011 05:26 PM

removing everything you quoted, correct?

DragonByte Tech 11-20-2011 05:30 PM

Yeah that's what I said :)


Fillip

Baltar 11-20-2011 05:32 PM

Just making sure.. sorry.

DragonByte Tech 11-20-2011 05:40 PM

No problem :)


Fillip

Baltar 11-20-2011 05:43 PM

Thanks for your help. It installed this time.

DragonByte Tech 11-20-2011 05:52 PM

Good stuff :D

Btw, I just added a Hotfix for an issue where if you do not hide vBAA information from guests (via a vBOption), awards and Achievements won't display.

If you re-download the zip and re-upload /dbtech/vbactivity/hooks/postbit_display_complete.php to the similar folder on your forum, you'll get the fix without having to re-upload everything :)


Fillip

Baltar 11-20-2011 05:52 PM

I have it installed and had a question about categories, awards, etc. Is their a readme file for this? Can you give me an example of a category, achievements, awards and such? I just want to see an example of someone who is using this mod! Thanks in advance.

And I'm sending a PM. thanks again.

DragonByte Tech 11-20-2011 06:02 PM

You should have received a .html file called documentation.html in the .zip file you downloaded. If you open that, you'll find the full manual for this mod :)

If you didn't, or have deleted the folder already, you can view the documentation here: http://www.dragonbyte-tech.com/docs/vbactivity/


Fillip

GrimR7529 11-21-2011 03:38 AM

Hi,

I just purchased the pro version for my site: www.cgmatter.com and have the following error come up when I try to use it. I installed the 'Advanced Post Thank...' first and now I am trying to install the vbActivity ...

I upload the files fine without a hickup, but then when I run the script the following happens:

Importing Product, Please Wait...

[:]

Created Table: cgm_dbtech_vbactivity_achievement
Created Table: cgm_dbtech_vbactivity_activitylevel
Created Table: cgm_dbtech_vbactivity_category
Created Table: cgm_dbtech_vbactivity_condition
Created Table: cgm_dbtech_vbactivity_conditionbridge
Created Table: cgm_dbtech_vbactivity_pointslog
Created Table: cgm_dbtech_vbactivity_rewards
Created Table: cgm_dbtech_vbactivity_type
Altered Table: cgm_administrator
Altered Table: cgm_user
Altered Table: cgm_usergroup
Populated Table: cgm_dbtech_vbactivity_activitylevel
Populated Table: cgm_dbtech_vbactivity_type
Updating Version Number To: 1.0.0

Altered Table: cgm_dbtech_vbactivity_achievement
Updating Version Number To: 1.0.2

Altered Table: cgm_dbtech_vbactivity_pointslog
Altered Table: cgm_user

When it gets to the above line it stops and I get the following error:

Database error
The cgmatter database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.cgmatter.com home page, then try to open another page.
Click the Back button to try another link.
The www.cgmatter.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.
Database error in vBulletin 4.1.8:

Invalid SQL:

SELECT SUM(points) AS numpoints
FROM cgm_dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= 1321763533;

MySQL Error : Unknown column 'user.userid' in 'where clause'
Error Number : 1054
Request Date : Sunday, November 20th 2011 @ 10:32:13 PM
Error Date : Sunday, November 20th 2011 @ 10:32:23 PM
Script : http://www.cgmatter.com/admincp/plug...=productimport
Referrer : http://www.cgmatter.com/admincp/plug...?do=productadd
IP Address : XXX.XXX.XXX.XXX <- I changed this...
Username : cgmatteradmin
Classname : vB_Database
MySQL Version : 5.0.92-community

Any help would be greatly appreciated.

DragonByte Tech 11-21-2011 08:30 AM

Please post Pro support questions in our Pro support forums :)


Fillip

DragonByte Tech 11-21-2011 08:36 AM

Zip file updated to address installer problems.

Fillip

flbutterflyz 12-20-2011 02:58 AM

Hi Fillip,

How do I go about putting the points only and not the bars or level in the postbit?

vantastic 01-04-2012 03:59 AM

This sounds like a fantastic mod, but probably a bit heavy for me...

I run random competitions every now and then and need something where I can award an icon to Postbit for each user who gets a place like 1st, 2nd, and 3rd place etc. Could this do what I need?

DragonByte Tech 01-07-2012 01:36 PM

Without knowing the nature of your random competitions I cannot answer that question.

Competitions are Pro-only features, by the way.

Fillip

baghdad4ever 01-16-2012 07:51 AM

hi

how to integrate vbseo like system in the criteria

i want to give achievement according to likes given or recieved

is that possible please?

DragonByte Tech 01-16-2012 10:31 AM

That's not currently possible, sorry :(


Fillip

baghdad4ever 01-17-2012 10:27 AM

1 Attachment(s)
hi sir i had 2 questions

1- i want to put achivement according to points only so i choose

a- Field Points (Total)

b- Type Points

c- Comparison >=

d- Value 500

when criteria saved the type become value and not what i choose points

is that ok?




2- is there any chance when trophy come to here sound like ps3 trophy popup sound?



thanks

DragonByte Tech 01-17-2012 11:39 AM

That's because value is the only correct option for Points (Total). It will work the way you want it to.

Unfortunately it's not feasible to be playing a sound during such events, as they are happening 100% in the background, and possibly also when the user isn't even on the forum.

Fillip

baghdad4ever 01-17-2012 11:45 AM

thank you Fillip for your great help

baghdad4ever 01-18-2012 07:10 AM

hi

when i reply i get this

Code:

SELECT COUNT(quiz_id) AS issue_reply
                FROM pt_issuenote
                WHERE userid = 1 && isfirstnote = '0';

MySQL Error  : Unknown column 'quiz_id' in 'field list'
Error Number  : 1054

and this another user


Code:

Invalid SQL:

                SELECT COUNT(taken_id) AS issue_created
                FROM pt_issue
                WHERE submituserid = 64506;

MySQL Error  : Unknown column 'taken_id' in 'field list'
Error Number  : 1054

how to solve that plz?



EDIT:: sorry it is from unofficial addon integrate the vbulletin project with vbactivity after uninstall it it is solved

DragonByte Tech 01-18-2012 01:20 PM

This is not the support thread for vBQuiz :)


Fillip

baghdad4ever 01-18-2012 01:58 PM

Quote:

Originally Posted by DragonByte Tech (Post 2289370)
This is not the support thread for vBQuiz :)


Fillip


sorry it is from unofficial addon integrate the vbulletin project with vbactivity after uninstall it it is solved:D


All times are GMT. The time now is 05:01 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.02263 seconds
  • Memory Usage 1,841KB
  • 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)bbcode_php_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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