vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Add-On Releases - vBExperience 3.8 (https://vborg.vbsupport.ru/showthread.php?t=199556)

Matt Lathrop 08-13-2009 02:31 PM

Ok after further investigation, both messages and connections are stored but messages also include a lot of hidden messages and things like that, connections are pretty clean and only kept while the user is online. So would it be possible to award x points for every time your user id comes up in the connection log (in the mysql database)? Also in this table it stores the time that the connection was made and the time it was last updated (every time you send a message or interact with chat). SO I guess in a way it does store online time...

Phalynx 08-13-2009 02:33 PM

If the table is readable via vBulletin, it should be no problem to read this. You can use the CDP to get the data and store it as a point provider.

Matt Lathrop 08-13-2009 02:40 PM

Not to sound totally noobish, but CDP?

Phalynx 08-13-2009 02:46 PM

Custom Data Provider, the plugin interface of vBExperience. All plugins are written using this. Take a look at the samples ZIP\extras\Addons and also into the documentation ZIP\extras\Custom Data Provider\readme_custom_data_provider.txt

SEW810 08-13-2009 02:47 PM

Ok Phalynx, you have an MP

Thats your account ;)

Thnx

Matt Lathrop 08-13-2009 02:49 PM

Thanks. I will take a look.

Matt Lathrop 08-13-2009 03:09 PM

Well if I wasn't so brain dead on coding ect. then your instructions would have been very clear... I guess my question would me what all do I ahve to change? flashchat stores the info in a table called flashchat_connections.

Phalynx 08-13-2009 03:30 PM

Currently I don't have the time to code this, sorry.

veenuisthebest 08-13-2009 03:35 PM

Awesome work Phalynx! This is undoubtedly ONE MOST superbly built, documented and supported mod. Updated to 3.8.4 and it works great.

I have a few suggestions please.

1. In xperience.php?go=gap, I have 12 fields showing as 0 as I am not using those mods. Rather than just disabling the text box, why not DON'T SHOW that field at all. It will reduce the clutter on the page. In other words, those 12 rows should not display when You Have = 0.

2. When viewing OTHER PERSON's profile, the Give Away Points should link to xperience.php?go=gap&username=bobby , just like we have from postbit.

Thanks

Phalynx 08-13-2009 03:51 PM

Quote:

Originally Posted by veenuisthebest (Post 1866545)
Awesome work Phalynx! This is undoubtedly ONE MOST superbly built, documented and supported mod. Updated to 3.8.4 and it works great.

I have a few suggestions please.

1. In xperience.php?go=gap, I have 12 fields showing as 0 as I am not using those mods. Rather than just disabling the text box, why not DON'T SHOW that field at all. It will reduce the clutter on the page. In other words, those 12 rows should not display when You Have = 0.

This has been already asked and is on my Todo list

Quote:

Originally Posted by veenuisthebest (Post 1866545)
2. When viewing OTHER PERSON's profile, the Give Away Points should link to xperience.php?go=gap&username=bobby , just like we have from postbit.

Thanks

Nice idea, yes. Will implement this.

SEW810 08-13-2009 04:09 PM

I don't know why xperience_admin.php showes blank page :'(
Even form me, I can't see anything :'(

Well, thanx Phalynx,I'll check it later. Thanx a lot for your time, please if I got some troubles please please could you help me again?.
Thnx

gamerfu 08-13-2009 04:51 PM

Quote:

Originally Posted by SEW810 (Post 1866579)
I don't know why xperience_admin.php showes blank page :'(
Even form me, I can't see anything :'(

Well, thanx Phalynx,I'll check it later. Thanx a lot for your time, please if I got some troubles please please could you help me again?.
Thnx

There was a fix to this...

I think you need PHP 5.2.9 and something else... sorry, the second one escapes me atm.

Phalynx, could you please add the link (solution) to the non-displaying xperience_admin.php in your modification description, please?

Trek 08-13-2009 04:51 PM

This is working good, but one thing I'd like to see is on the awards a minimum requirements field.

For instance, the "Frequent Poster" award is going to people that just sign up and make a single post. This is normal on my forums as it's a gaming guild and people sign up and then submit their application. So their days as a member and post count are considered high.

I'd like it make it so members are only counted if they have been members for 2 weeks or more. Basically, making this a variable.

ConfusedCartman 08-13-2009 06:23 PM

I'm not sure if this bug has been reported, but I've been getting messages from my members saying they can give away more XP than they have if they click the "Give Away" button twice before the page finishes loading. Is this something you're aware of? Anyway, it put one of my members 200xp negative, which shouldn't happen.

Phalynx 08-13-2009 07:10 PM

Quote:

Originally Posted by SEW810 (Post 1866579)
I don't know why xperience_admin.php showes blank page :'(
Even form me, I can't see anything :'(

Well, thanx Phalynx,I'll check it later. Thanx a lot for your time, please if I got some troubles please please could you help me again?.
Thnx

As long as you don't fix it I cannot help you. I didn't have had any access to that part.

Quote:

Originally Posted by Trek (Post 1866600)
This is working good, but one thing I'd like to see is on the awards a minimum requirements field.

For instance, the "Frequent Poster" award is going to people that just sign up and make a single post. This is normal on my forums as it's a gaming guild and people sign up and then submit their application. So their days as a member and post count are considered high.

I'd like it make it so members are only counted if they have been members for 2 weeks or more. Basically, making this a variable.

Ehm, this is already part of the finale 3.8.4 - that award goes only to people who are at least 7 days online. Please upgrade to the final GOLD version.

Quote:

Originally Posted by ConfusedCartman (Post 1866656)
I'm not sure if this bug has been reported, but I've been getting messages from my members saying they can give away more XP than they have if they click the "Give Away" button twice before the page finishes loading. Is this something you're aware of? Anyway, it put one of my members 200xp negative, which shouldn't happen.

This is very strange, will take a deeper look.

Matt Lathrop 08-13-2009 09:00 PM

HTML Code:

$attq = $vbulletin->db->query_read("SELECT
                SUM(counter) as sum_att_views
                FROM " . TABLE_PREFIX . "flashchat_connections
                WHERE userid=".$user['userid']);
               
        if ($vbulletin->db->num_rows($attq) > 0)
        {
                $att = $vbulletin->db->fetch_array($attq);
       
                $xperience['count_misc_cdp'] = $att['sum_att_views'] * $vbulletin->options['xperience_points_cdp'];
                $xperience['count_misc'] += $xperience['count_misc_cdp'];
                $additionalsql .= "points_misc_cdp=".$xperience['count_misc_cdp'].","

Is this the main bulk of code to edit?

stardotstar 08-13-2009 09:19 PM

Quote:

Originally Posted by Phalynx
Originally Posted by stardotstar View Post

Hi, I'm uncertain if this is fixed earlier in the pages, but please point me there if so,,,

I have only a few of the options showing as configuration panels when clicked on in the side bar of the acp.
ie the settings labeled:
Settings:
do not display - I get a blank right side main panel
but the others work fine....
I recall something like this with another mod but I cannot remember if it got fixed or what caused it...
Ring any bells?

BTW thank you for such a huge update - massive and most awesome mod!

That is a known issue, but not with vBExperience, it's PHP:
- Settings are showing only a blank page, read here: http://www.vbulletin.com/forum/proje...6979#note74140

I knew it was something related - thank you for setting me off in the right direction - it was the photoplog I last saw this with.

Great mod, great support, thank you very much.
Will

ConfusedCartman 08-14-2009 12:54 AM

Thanks for responding to my last comment. It seems I'm having one more problem - when calculating average PPD, it calculates it as 0PPD. For some reason, it's unable to read the database that stores the post information - e.g. it's calculating most members with 0% activity. Before I upgraded to this version, I didn't have this problem. I'm using vBulletin 3.7x if that makes a difference.

mikeo9043 08-14-2009 02:26 AM

I installed the latest version on my site, but the when I go to the xperience page, it doesn't show what % each member is at like so:
https://vborg.vbsupport.ru/external/2009/08/67.jpg

Trek 08-14-2009 03:25 AM

Quote:

Originally Posted by Phalynx (Post 1866672)
Ehm, this is already part of the finale 3.8.4 - that award goes only to people who are at least 7 days online. Please upgrade to the final GOLD version.

I'm already running 3.8.4... I'll overwrite the files, but... I dunno.

Trek 08-14-2009 03:31 AM

Just overwrote the files and reran the award recount, same thing. Hope this information helps.

Awards page: http://www.darkhandofvalor.com/xperience.php?go=awards

Member: http://www.darkhandofvalor.com/member.php?u=538

Join Date08-07-2009
  • Total Posts: 1
  • Posts Per Day: 0.16
  • Last Activity: 08-07-2009 03:35 PM
  • Join Date: 08-07-2009
Frequent Poster issued for ValunarGalway on 08-13-2009 10:47 AM.
User likes to post
Fields used: Average Posts per Day

Trek 08-14-2009 03:45 AM

Ok, I ran the recount of experience points and it seemed to of fixed this issue. The other recount that I thought would do it, didn't. Thanks.

SEW810 08-14-2009 03:56 AM

Quote:

Originally Posted by Phalynx (Post 1866672)
As long as you don't fix it I cannot help you. I didn't have had any access to that part.

Sorry dude, I just talked to mauro1947 (web master) about your temporary account, I forget to talk to billnick, the guy that was on line with you and me. He changed your permissions. Really sorry, I feel ashamed :o , he didn't know anything about these movements.

Your mod works just perfect!!! THANK YOU,THANK YOU,THANK YOU,THANK YOU,THANK YOU
THANK YOU,GRACIAS,GRAZIE,OBRIGADO,СПАСИБО,DANKE,MERCI, THANK YOU FOR EVERYTHING !!!!!!!!!!.

Installed, updated, nominated..... your great man ;)
Did I forget to say thank you? lol :D

Phalynx 08-14-2009 06:19 AM

Quote:

Originally Posted by ConfusedCartman (Post 1866859)
Thanks for responding to my last comment. It seems I'm having one more problem - when calculating average PPD, it calculates it as 0PPD. For some reason, it's unable to read the database that stores the post information - e.g. it's calculating most members with 0% activity. Before I upgraded to this version, I didn't have this problem. I'm using vBulletin 3.7x if that makes a difference.

Quote:

Originally Posted by mikeo9043 (Post 1866900)
I installed the latest version on my site, but the when I go to the xperience page, it doesn't show what % each member is at like so:
https://vborg.vbsupport.ru/external/2009/08/67.jpg

Confirmed bug, I will release a patch in few minutes.

Quote:

Originally Posted by Trek (Post 1866939)
Ok, I ran the recount of experience points and it seemed to of fixed this issue. The other recount that I thought would do it, didn't. Thanks.

Nice to hear.

Quote:

Originally Posted by SEW810 (Post 1866944)
Sorry dude, I just talked to mauro1947 (web master) about your temporary account, I forget to talk to billnick, the guy that was on line with you and me. He changed your permissions. Really sorry, I feel ashamed :o , he didn't know anything about these movements.

Your mod works just perfect!!! THANK YOU,THANK YOU,THANK YOU,THANK YOU,THANK YOU
THANK YOU,GRACIAS,GRAZIE,OBRIGADO,СПАСИБО,DANKE,MERCI, THANK YOU FOR EVERYTHING !!!!!!!!!!.

Installed, updated, nominated..... your great man ;)
Did I forget to say thank you? lol :D

Thanks for helping in this. I will release this as a bugfix to 3.8.4

Phalynx 08-14-2009 08:15 AM

This bugfix resolves problems with the activity. There was a bug in reading out average postcount.

Please overwrite the file class_xperience.php

3.8.4.1, 14th August 2009
- Fixed issues with low/high activity
- Improved speed by recounting activity
- Included french translation by mitch84 - thanks!

veenuisthebest 08-14-2009 08:52 AM

Another bug:-

One is able to Give away points to himself.

I had 3605 points, I gave 20 points to myself and it increased. One should not be able to give points to himself, the system can be clearly abused this way.

Also, it would be nice to not to show Give Away Points in postbit dropdown FROM OUR OWN USERNAME.

Phalynx 08-14-2009 09:29 AM

Fixed in next version.

Just a Note:
I'm the next few days on vacation and therefore cannot provide any support. I will return on Monday, 17th August.

Limode 08-14-2009 10:10 AM

@Phalynx ,
Need 10 Hours Recount when upgrade for 136,000 member =.= .

Matt Lathrop 08-14-2009 02:17 PM

Hey I have a question about the CDP. This is what I have so far on my chat mod... currently I have it working so that when I recount the code it changes points_misc_cdp to 1 if they are in the chat room at the time of the recount. The problem is it won't do it constantly... it only updates when I hit recount and when I do that it dose not add on to the current # (which I guess is what recount is supposed to do) Do you have any suggestion on how to solve the issue?

mikeo9043 08-14-2009 02:57 PM

Quote:

Originally Posted by Phalynx (Post 1867018)
This bugfix resolves problems with the activity. There was a bug in reading out average postcount.

Please overwrite the file class_xperience.php


3.8.4.1, 14th August 2009
- Fixed issues with low/high activity
- Improved speed by recounting activity
- Included french translation by mitch84 - thanks!

I updated that file, but no % still shows up on the xperience page.

gamerfu 08-14-2009 03:48 PM

I noticed vBExperience 3.8.4 counts posts in my "SPAM Games" board towards the user's experience. :(

I have this board set to not to count posts towards the user's final post count. :confused:

SEW810 08-14-2009 04:11 PM

Quote:

Originally Posted by Phalynx (Post 1867039)
Fixed in next version.

Just a Note:
I'm the next few days on vacation and therefore cannot provide any support. I will return on Monday, 17th August.

Enjoy your vacations. !!!!!!. See you soon.
Quote:

Originally Posted by Limode (Post 1867054)
@Phalynx ,
Need 10 Hours Recount when upgrade for 136,000 member =.= .

Oh man!!!. Why don't you set
Xperience->General setts->Only active users?... YES

My board has 76000 users and it takes to calculate activity 10~15 mins.
You have double than me, it should takes 30 mins max !!

ConfusedCartman 08-14-2009 04:26 PM

Quote:

Originally Posted by Phalynx (Post 1867018)
This bugfix resolves problems with the activity. There was a bug in reading out average postcount.

Please overwrite the file class_xperience.php


3.8.4.1, 14th August 2009
- Fixed issues with low/high activity
- Improved speed by recounting activity
- Included french translation by mitch84 - thanks!

Thank you! It fixed the problem perfectly. The fantastic support is another reason why this is my favorite vBulletin addon.

Joshkrz 08-14-2009 05:39 PM

Just a question...

Is there anyway to make it so that some shop items can be like so...

Quote:

Reputation Upgrade
+1 REP Power
2000 XP

The Rep Upgrade gives your account an extra Rep power to inflict more damage (or reward) on other users.
And things like custom title item or exclusive display pictures and stuff like that. If so that would be great!

Also could you add "Achivment" type awards, where more than one user can have an award, for lets say... 100 posts or Active for 1 year ect?

Sorry if I'm asking too much but it would be really great, and thanks for the update, I was about to ask about the activity problem.

ConfusedCartman 08-14-2009 06:24 PM

One more quick thing: Activity doesn't seem to behave as expected. A member half my Average Posts Per Day has twice the Activity percentage as I do, and I have toggled off everything except posts and last activity date (he's active daily, like I am). It's not just this one isolated case either - it seems to be very inconsistent across the board. Isn't there a way to just average out the top X number of members' Average Posts Per Day, then just compare each member's average Posts Per Day to that number and draw a percentage from it? If that's what's supposed to be happening, then I don't think it's working. It's not urgent, but if you could make improvements in future releases, that would be great.

Itchy Nips 08-14-2009 07:55 PM

i just realized that the awards images are not appearing for users that have the "user name images" modification.

milsirhc 08-15-2009 11:17 AM

I'm having a major issue:

I've uninstall this product, however now I am getting a SQL error:

Database error in vBulletin 3.8.4:

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

MySQL Error : Unknown column 'xperience_done' in 'field list'

and I am unable to login to my admin CP nor login nor post.

I need help desperately!!

vinss 08-15-2009 11:22 AM

thanks :)

Harley D 08-15-2009 03:38 PM

Quote:

Originally Posted by milsirhc (Post 1867802)
I'm having a major issue:

I've uninstall this product, however now I am getting a SQL error:

Database error in vBulletin 3.8.4:

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

MySQL Error : Unknown column 'xperience_done' in 'field list'

and I am unable to login to my admin CP nor login nor post.

I need help desperately!!

Add this to your CONFIG.PHP
Quote:

define("DISABLE_HOOKS", true);
That should get you back into your ADMINCP.
From there disable anything related to xperience. Then remove the line to reactivate your plug-ins.

You probably un-installed the mod incorrectly or incompletely. A Reinstall may be necessary. Also make sure you have un-installed ALL related mods as well.

Hope this helps.

milsirhc 08-15-2009 10:36 PM

Thanks Harley!

I've manually add a new column xperience_done in my user DB and that allows me to login.

I re-install the mod and uninstall it by first using the kill_xperience.php and then remove the product but the error came back again...

I guess I just leave xperience_done column in there for now...


All times are GMT. The time now is 07:41 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.03387 seconds
  • Memory Usage 1,858KB
  • 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
  • (1)bbcode_html_printable
  • (20)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