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 - vBExperience 4 (https://vborg.vbsupport.ru/showthread.php?t=245023)

Subieforums 10-26-2012 09:16 PM

Hello this mod is awesome!

However, I noticed that not everything is showing up. The achievements and awards are not showing up on my own personal post bit. Not sure if something got mixed up or? They show up on my profile page, but not on my threads...

I have a bunch of achievements listed on my profile page, but they do not show up on my own postbit, they appear to be working for others, but for some reason not me. When I first installed the mod it worked, but now it doesnt. kind of weird.

Any help would be greatly appreciated!

osix 11-05-2012 01:15 AM

This is a great mod will it be updated to support 4.2.X

trackpads 11-10-2012 07:40 PM

I am getting these incredibly long queries in the slow query log for mysql. These are related to discussion ender, which I have already removed but are still showing up.

What should I do?

Thanks

-Jason

Code:


# Time: 121110 15:03:40
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 116.362738  Lock_time: 0.000086 Rows_sent: 1  Rows_examined: 3393026
SET timestamp=1352577820;
SELECT
                        P.userid, COUNT(userid) AS times
                        FROM vb_thread AS T
                        INNER JOIN vb_post AS P ON T.lastpostid=P.postid
                        WHERE P.userid=32258
                        AND T.dateline > 315532800 AND T.dateline < 1352577704
                        AND P.dateline > 315532800 AND P.dateline < 1352577704
                        GROUP BY P.userid
                        ORDER BY P.dateline DESC, P.userid;


# Time: 121110 15:05:19
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 89.153733  Lock_time: 0.000073 Rows_sent: 1  Rows_examined: 3393026
SET timestamp=1352577919;
SELECT
                        P.userid, COUNT(userid) AS times
                        FROM vb_thread AS T
                        INNER JOIN vb_post AS P ON T.lastpostid=P.postid
                        WHERE P.userid=32262
                        AND T.dateline > 315532800 AND T.dateline < 1352577830
                        AND P.dateline > 315532800 AND P.dateline < 1352577830
                        GROUP BY P.userid
                        ORDER BY P.dateline DESC, P.userid;


trackpads 11-10-2012 07:53 PM

Double

trackpads 11-10-2012 07:57 PM

Ok, I had deleted the award not set to Zero so I re imported the default awards and set to zero. However, now instead of scanning a bazillion rows it only scans 5-6 but still takes for ever.

Can I just remove this from the code so it doesnt do anything at all?

Code:

# Time: 121110 15:52:28
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 2.705497  Lock_time: 0.000074 Rows_sent: 1  Rows_examined: 1
SET timestamp=1352580748;
SELECT
                        P.userid, COUNT(userid) AS times
                        FROM vb_thread AS T
                        INNER JOIN vb_post AS P ON T.lastpostid=P.postid
                        WHERE P.userid=32317
                        AND T.dateline > 315532800 AND T.dateline < 1352580745
                        AND P.dateline > 315532800 AND P.dateline < 1352580745
                        GROUP BY P.userid
                        ORDER BY P.dateline DESC, P.userid;
# Time: 121110 15:52:37
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 1.297763  Lock_time: 0.000075 Rows_sent: 1  Rows_examined: 5
SET timestamp=1352580757;
SELECT
                        P.userid, COUNT(userid) AS times
                        FROM vb_thread AS T
                        INNER JOIN vb_post AS P ON T.lastpostid=P.postid
                        WHERE P.userid=32320
                        AND T.dateline > 315532800 AND T.dateline < 1352580755
                        AND P.dateline > 315532800 AND P.dateline < 1352580755
                        GROUP BY P.userid
                        ORDER BY P.dateline DESC, P.userid;


trackpads 11-10-2012 08:02 PM

Disabled the mod for now. Thanks, I really like it just got to get past the query.

MrSeth 11-13-2012 11:39 PM

Does this work for v4.2?

Aramist 11-20-2012 08:57 AM

Hi

I have just updated the mod and started getting this error on my mail box:

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT
                dbtech_thanks_likes,
                dbtech_thanks_liked,
                dbtech_thanks_thanks,
                dbtech_thanks_thanked
                FROM vb_user
                WHERE userid = 1;

MySQL Error  : Unknown column 'dbtech_thanks_likes' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, November 20th 2012 @ 09:02:45 AM
Error Date    : Tuesday, November 20th 2012 @ 09:02:46 AM
Script        : http://www.mysite.com/forum/cron.php?rand=1353409358


Any clue?

trackpads 11-24-2012 03:15 PM

Quote:

Originally Posted by Aramist (Post 2382825)
Hi

I have just updated the mod and started getting this error on my mail box:

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT
                dbtech_thanks_likes,
                dbtech_thanks_liked,
                dbtech_thanks_thanks,
                dbtech_thanks_thanked
                FROM vb_user
                WHERE userid = 1;

MySQL Error  : Unknown column 'dbtech_thanks_likes' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, November 20th 2012 @ 09:02:45 AM
Error Date    : Tuesday, November 20th 2012 @ 09:02:46 AM
Script        : http://www.mysite.com/forum/cron.php?rand=1353409358


Any clue?


did you check the overwrite box when importing the product?

This is your clue: MySQL Error : Unknown column 'dbtech_thanks_likes' in 'field list'

That means it didnt install correctly, your missing a database column in that table.

Hope this helps,

-Jason

trackpads 11-30-2012 12:32 AM

Quote:

Originally Posted by trackpads (Post 2380061)
Ok, I had deleted the award not set to Zero so I re imported the default awards and set to zero. However, now instead of scanning a bazillion rows it only scans 5-6 but still takes for ever.

Can I just remove this from the code so it doesnt do anything at all?

Code:

# Time: 121110 15:52:28
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 2.705497  Lock_time: 0.000074 Rows_sent: 1  Rows_examined: 1
SET timestamp=1352580748;
SELECT
                        P.userid, COUNT(userid) AS times
                        FROM vb_thread AS T
                        INNER JOIN vb_post AS P ON T.lastpostid=P.postid
                        WHERE P.userid=32317
                        AND T.dateline > 315532800 AND T.dateline < 1352580745
                        AND P.dateline > 315532800 AND P.dateline < 1352580745
                        GROUP BY P.userid
                        ORDER BY P.dateline DESC, P.userid;
# Time: 121110 15:52:37
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 1.297763  Lock_time: 0.000075 Rows_sent: 1  Rows_examined: 5
SET timestamp=1352580757;
SELECT
                        P.userid, COUNT(userid) AS times
                        FROM vb_thread AS T
                        INNER JOIN vb_post AS P ON T.lastpostid=P.postid
                        WHERE P.userid=32320
                        AND T.dateline > 315532800 AND T.dateline < 1352580755
                        AND P.dateline > 315532800 AND P.dateline < 1352580755
                        GROUP BY P.userid
                        ORDER BY P.dateline DESC, P.userid;



Anyone?

GamerPerfection 12-08-2012 09:42 AM

I've just installed this and am looking to use it as part of my competition ideas. Now what I found really good is that you can state a date for the start of the point calculations. However, I put todays date 12/08/2012 MM/DD/YYYY and the did a recount of points. It does work, however, things like points for reputation, friends, referrals etc are not being calculated from that date, it is calculating since they joined, where as points for other activity such as threads, posts, blogs etc are at 0 so they are calculating from that date.

So why are not all the stats calculating from the date I set? By the way i'm using the BETA version.

Gamelobby 12-09-2012 10:09 PM

Quote:

Originally Posted by MrSeth (Post 2380912)
Does this work for v4.2?

I'm guessing that since the latest is version is 4.1.1 it is NOT ready for 4.2.
I would just wait for a new release probably titled 4.2.

Although the demo site is 4.2. :)

GamerPerfection 12-10-2012 04:52 AM

That's a bit optimistic. The last update was way back in March and he hasn't posted in this thread since May and by the looks of it his support forum is inactive. I don't think there will be any new updates.

M.C. 12-14-2012 07:59 AM

but it work OK in 4.2.

sadly that such great addons are missing support :(

Point Market he suggest for this has same support issue :(

I belive that because of new Internet Brands policy to all developers! SAD SAD SAD!!!

rhoula 12-15-2012 11:22 PM

I have tried everything possible to get this to work but I can't please if someone can help me I will be very very grateful.

I will even send you a postcard from Oklahoma City to thank you for your help :)

Or maybe put your banner ad on my website for a couple weeks to thank you.

If you can help me please write to info[at] checkthisup.com

Thank you in advance

Binoy 12-19-2012 08:57 AM

We are facing a problem with vbexpeirence for the last few days. It is not working now. Whenever we try to giveaway points it shows message
"Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/includes/class_core.php on line 415
Database error"
.
could you please help me on fixing this Appreciate your help

avec une femme 12-27-2012 10:14 PM

Is this working for 4.2? Is there any ongoing support for this modification. I feel reluctant to install it if it's just going to end up with bugs with any upgrades.

gsmlover4u 01-09-2013 07:15 AM

after uninstall facing database error when submit new thread
how to solve this issue

Quote:

Database error in vBulletin 4.2.0:

Invalid SQL:
UPDATE user SET xperience_done=0 WHERE userid='1';

MySQL Error : Unknown column 'xperience_done' in 'field list'
Error Number : 1054
Request Date : Wednesday, January 9th 2013 @ 08:39:43 AM
Error Date : Wednesday, January 9th 2013 @ 08:39:43 AM
Script : http://www.******.com/newthread.php?do=postthread&f=376
Referrer : http://www.******.com/newthread.php?do=newthread&f=376
IP Address : **.**.***.****
Username : **********
Classname : vB_Database
MySQL Version : 5.5.25-MariaDB-mariadb1

joehuang 01-10-2013 02:17 AM

why is the official supporting site (http://www.vbaddict.net) is down?

is this project still running and supported?

smirkley 01-10-2013 02:20 AM

As 90+% of linked suporting sites being down here,..

Seems like the mod is still supported though.

Give patience to the coder.

Vintum 01-11-2013 03:29 AM

Are mods like this only meant to be fun and promote forum activity?

It looks great and all, but I'm wondering if it has any extra potential for the webmaster to profit from this.

Phalynx 01-11-2013 09:23 AM

Server crashed, the RAID1 has lost both disk. Recreating the whole site from backups.

But to be honest, I don't have much time for doing support, also the further development is on ice.

M.C. 01-14-2013 06:37 PM

Welcome back!!! Sorry about your crash.

Somehow my Registered users (ID=2) can't access experience (other users OK)... why this happend?

Quote:

you do not have permission to access this page. This could be due to one of several reasons
In "Ignore Groups" settings I have 19,20 which are different groups.

Is there any other settings for usergroups access to Experience?

UPDATE: Figure out that "Can View Member Info" in Usergroup settings has to be YES - why this connected to experience?!

Phalynx 01-16-2013 10:49 AM

This is historical, vBExperience has grown since than. Yes, a change would be good.

But anyway - someone interested in taking over this modification?

joehuang 01-17-2013 08:05 AM

Most things are working properly, however I found out that the recent Activity does not show any activity except one activity one week ago.

I have recounted the activity in admincp, but the result is the same.

Anyone knows why the recent activity is not updating?

Thanks.

joehuang 01-18-2013 03:36 PM

What is activity bar about?

A lot of users have 0% activity but actually they have been active posting/replying...

I tried "recount", nothing changes...

Anyone shed some light?

Thanks.

Teascu Dorin 01-18-2013 08:17 PM

1 Attachment(s)
Here is the Romanian trnaslation for version 4.1.1:
Attachment 143351
Enjoy!

M.C. 01-19-2013 10:08 AM

How to turn "Demote" option?

Kevin Ban 01-21-2013 05:46 AM

Can this work with vb 4.2?

joehuang 01-21-2013 07:51 AM

Kevin,

Yes, I installed with 4.2 and it works, no problem so far.

Kevin Ban 01-22-2013 10:50 AM

Extra>Levels

How to i uninstall "vbexperience_level_2_average" and replace it with "vbexperience_level_5_very_large"?

Anyway what's the difference between them. If i have 10,000 members, can i use "vbexperience_level_8_level200"? what will happen?

mofeu 01-22-2013 10:53 AM

For Levels you need to install something else on vBExperience4?

Kevin Ban 02-02-2013 08:06 AM

example if I want to replace the 7 days registered award with my own custom image, the default size is 16x16 how do i increase the size to 24x16. And the default image is png, can i use gif?

mokujin 02-06-2013 07:26 AM

Here is the way how to add another extenstions (example for GIF images), the default is allowed PNG only.

Open admincp/xperience_admin.php
Find:
PHP Code:

            $files16 GetFiles("_16.png");
            foreach (
$files16 as $file)
            {
                
$selected iif($achievements['imagesmall'] == $file"selected ");
          
$imagesmall .= '<option '.$selected.'value="'.$file.'" >'.$file.'</option>';
            } 

Add above:
PHP Code:

            $files16 GetFiles("_16.gif");
            foreach (
$files16 as $file)
            {
                
$selected iif($achievements['imagesmall'] == $file"selected ");
          
$imagesmall .= '<option '.$selected.'value="'.$file.'" >'.$file.'</option>';
            } 

###############################################
Find:
PHP Code:

             $files32 GetFiles("_32.png");
            foreach (
$files32 as $file)
            {
                
$selected iif($achievements['imagebig'] == $file"selected ");
          
$imagebig .= '<option '.$selected.'value="'.$file.'" >'.$file.'</option>';
            } 

Add above:
PHP Code:

             $files32 GetFiles("_32.gif");
            foreach (
$files32 as $file)
            {
                
$selected iif($achievements['imagebig'] == $file"selected ");
          
$imagebig .= '<option '.$selected.'value="'.$file.'" >'.$file.'</option>';
            } 


Zantox 02-07-2013 08:23 PM

My Achievements don't show up. They appear on profile but not on postbit. I have it set too, and some others do, but my specific user does not. Help

Jubei 02-16-2013 08:09 PM

Is there a way to send an auto-email to members when they unlock an achievement/award?

sheyworth 02-20-2013 04:32 AM

When I try to upload the plugins, suchas the one to make it work with vbookie, I get a message that they are not plugin, but they appear to be products. Advice?

Should I just upload them as product?

Ok So I installed it as a product. I then set my vbookie cash as custom. Now whenever I place a bet, settle a bet etc I get the follwing error
Quote:

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT
SUM(bet_amount_won) AS sumbets
FROM vbookie_bets_placed
WHERE bet_settled='Y' AND userid=4749
AND dateline > 315532800
GROUP BY userid;

MySQL Error : Unknown column 'dateline' in 'where clause'
Error Number : 1054
Request Date : Wednesday, February 20th 2013 @ 06:12:51 AM
Error Date : Wednesday, February 20th 2013 @ 06:12:52 AM
Script : http://www.centerstagesports.com/forums/vbookie.php
Referrer : http://www.centerstagesports.com/for...p?30963-Test-2
IP Address : xxxxx
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.5.27
What do I need to fix?

TLCrestron 02-20-2013 05:43 PM

We are running vBulletin v4.2, and I'm no longer able to see the Experience choice in the "Community" drop down. Nor can I enable the tab, etc.

What can I do to resolve that?

sheyworth 02-20-2013 08:34 PM

Quote:

Originally Posted by TLCrestron (Post 2405462)
We are running vBulletin v4.2, and I'm no longer able to see the Experience choice in the "Community" drop down. Nor can I enable the tab, etc.

What can I do to resolve that?

Good luck getting support. I contacted the developer and he basically said he no longer supports it, then disabled his PM here.

snowlion 02-21-2013 12:00 AM

Quote:

Originally Posted by Phalynx (Post 2397251)
This is historical, vBExperience has grown since than. Yes, a change would be good.

But anyway - someone interested in taking over this modification?

He'd left his message about this mod here. So anyone interested in taking over this modification?


All times are GMT. The time now is 10:55 AM.

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.03058 seconds
  • Memory Usage 1,870KB
  • 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
  • (5)bbcode_code_printable
  • (4)bbcode_php_printable
  • (8)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
  • (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