vb.org Archive

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

maidos 02-29-2008 01:55 PM

thanks for the update but is it possible to move the bars below the post count

maidos 02-29-2008 02:06 PM

how goes the promotion for points and level for vbexperience level 70

Paradigm 02-29-2008 02:07 PM

I installed the update (allowing it to overwrite the files) and when I went to update the counters I get this Database error:

Database error in vBulletin 3.7.0 Beta 5:

Code:

Invalid SQL:
UPDATE vbxperience_stats
                SET
                points_thread=0,
                points_threads=0,
                points_thread_votes=0,
                points_thread_replycount=0,
                points_thread_views=0,
                points_thread_stickies=0,
                points_post=0,
                points_posts=0,
                points_post_thanks=,
                points_user=1373,
                points_user_infractions=0,
                points_user_reputation=100,
                points_user_online=1273.69496528,
                points_user_socialgroup=0,
                points_user_visitormessages=0,
                points_user_albumpictures=0,
                points_post_attachment=0,
                points_thread_tags=0,
                points_misc=0,
                points_misc_ldm=0,
                points_misc_dl2=0,
                points_misc_ppg=0,
                points_user_referrals=0,
                points_misc_ppd=0,
                dateline=1204301100       
                WHERE userid=1;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
                points_user=1373,
                points_user_infractions=0,
                points_user_reputation=10' at line 11
Error Number  : 1064
Date          : Saturday, March 1st 2008 @ 01:05:41 AM
Script        : http://www.bigonline.org/admincp/misc.php?do=xperience_recount_xp
Referrer      : http://www.bigonline.org/admincp/misc.php?do=chooser
Username      : Paradigm
Classname    : vB_Database
MySQL Version : 4.1.22-standard-log


Phalynx 02-29-2008 02:19 PM

Quote:

Originally Posted by maidos (Post 1453671)
thanks for the update but is it possible to move the bars below the post count

Edit the template postbit/postbit_legacy and move $template_hook[postbit_userinfo_left] where you will have it.


Quote:

Originally Posted by maidos (Post 1453680)
how goes the promotion for points and level for vbexperience level 70

You decide, take a look at the Excel Sheet. You have to enter there the usergroupid's.

Quote:

Originally Posted by Paradigm (Post 1453681)
I installed the update (allowing it to overwrite the files) and when I went to update the counters I get this Database error:

Fixed. Please download ZIP and overwrite class_xperience.php. Please let me also know if the PayPal addition works.

Paradigm 02-29-2008 02:22 PM

On my way to do that now. Thanks for the fast fix!!

Paradigm 02-29-2008 02:27 PM

That fixed the Database error. Testing the paypal function now.

maidos 02-29-2008 02:27 PM

its the wrong code $template_hook[postbit_userinfo_left]

when i delete it teh nav bars is still there

maidos 02-29-2008 02:38 PM

also i dont know how to edit the exel something :S
i tried editing with the usegroup 6,7,2,5,1,20,13,11,17,12,9,14,19,18,22
but nothing happends every member are still on level 1

Paradigm 02-29-2008 02:47 PM

Ok, from what I can tell it has not worked. I set the points per donation unit (which is in USD) to 20. I made a $15 donation, confirmed it and then updated the counters. I then went to the xperience tab in my profile to see if I had received 300 points but I didn't. Also under the xperience tab in the profiles shouldn't there be a section that says Points for donations just like it says points for posts and threads?

Mephisteus 02-29-2008 03:44 PM

Here's a bug, when you put a value for points to 0 (such as days) it messes up the query causing an error when updating counters.

UPDATE vB_xperience_stats
SET
points_thread=252,
points_threads=80,
points_thread_votes=0,
points_thread_replycount=61.2,
points_thread_views=56.4,
points_thread_stickies=50,
points_post=434,
points_posts=406,
points_post_thanks=0,
points_user=16,
points_user_infractions=0,
points_user_reputation=10,
points_user_online=,
points_user_socialgroup=0,
points_user_visitormessages=3,
points_user_albumpictures=3,
points_post_attachment=28.5,
points_thread_tags=5,
points_misc=0,
points_misc_ldm=0,
points_misc_dl2=0,
points_misc_ppg=0,
points_user_referrals=0,
points_misc_ppd=0,
dateline=1204305480
WHERE userid=1;

steven1091 02-29-2008 05:31 PM

Nope, i have installed it all properly, and the template hook is not there, my skin does support 3.7 yes as all templates were reverted.

koxito 02-29-2008 05:52 PM

Well, i prefered to the % display only if i hoover it with the mouse... couse the way it is recomended early in this thread just make a lot of space in the postbit and looks terrible! :P

Man, i know the points are showing in the postbit and in the memberinfo, but it shows only the level experience, not the total poings.

Lets says, to get level 32 i need 5450 points... when i get the level it displays this, but if i continue gaining points, just display the same 5450 points until i level up to level 33 .. .and than it shows 5650 pints.... ¿ is there a way it can display the exact points i got ?...

Lumis Out.
Waiting for bug correcting before update.

Phalynx 02-29-2008 07:46 PM

You asked the bars below the post count:
Quote:

Originally Posted by maidos (Post 1453671)
thanks for the update but is it possible to move the bars below the post count

Then why are you now telling me nav bars:
Quote:

Originally Posted by maidos (Post 1453700)
its the wrong code $template_hook[postbit_userinfo_left]
when i delete it teh nav bars is still there

I can help you only if you specify correctly what you want.

Quote:

Originally Posted by Mephisteus (Post 1453744)
Here's a bug, when you put a value for points to 0 (such as days) it messes up the query causing an error when updating counters.

Did you noticed my posting where I corrected this already and updated the ZIP?

It was reportet here and fixed here.

Quote:

Originally Posted by koxito (Post 1453838)
Waiting for bug correcting before update.

I cannot confirm that bug, maybe I'm blind or you are expecting something that is not here. On my boards it is showing the correct value of the xperience of the users, not the levels.

KURTZ 02-29-2008 07:55 PM

interesting hack!

just installed ;)

Phalynx 02-29-2008 08:03 PM

Quote:

Originally Posted by Paradigm (Post 1453709)
Ok, from what I can tell it has not worked. I set the points per donation unit (which is in USD) to 20. I made a $15 donation, confirmed it and then updated the counters. I then went to the xperience tab in my profile to see if I had received 300 points but I didn't. Also under the xperience tab in the profiles shouldn't there be a section that says Points for donations just like it says points for posts and threads?

It works on my board:
http://www.insidesupcom.de/member.php?u=1

In profile it displays misc points only if they are higher than 0.

Did you run the counters via maintenance tools?

Paradigm 02-29-2008 08:12 PM

Yes, I have run the counters serveral times now. No luck. I dont see the points for Misc. But even if I could see it it didn't update my points for donating.

I have also fully removed and readded the mod.

Phalynx 02-29-2008 08:18 PM

Please run this query and tell me what you get:
Code:

SELECT
SUM(amount) as sum_amount
FROM cybppdonate
WHERE confirmed = '1' AND userid=307
GROUP BY userid


KURTZ 02-29-2008 08:31 PM

i've just installed this on my two boards (Beta 5) without any trouble ...

Paradigm 02-29-2008 08:39 PM

I sent you a PM.

Paradigm 02-29-2008 08:58 PM

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'bigonlin_vb.cybppdonate' doesn't exist

KURTZ 02-29-2008 09:00 PM

i checked my board now and i saw that there is a "weird" issue on the bars (i use the normal postbit) ...

the width of the bars isn't fixed ... it chages by the username of the member ... check the attachment ... :) it's possibile to fix this?

Phalynx 02-29-2008 09:04 PM

Quote:

Originally Posted by Paradigm (Post 1453976)
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'bigonlin_vb.cybppdonate' doesn't exist

Hmm, seems you don't have the version of the hack installed that I have. It should work with this hack:
https://vborg.vbsupport.ru/showthread.php?t=122997 - version 4.4

If you have this hack installed I need at least a list of your tables in your database.

Quote:

Originally Posted by KURTZ (Post 1453977)
i checked my board now and i saw that there is a "weird" issue on the bars (i use the normal postbit) ...

the width of the bars isn't fixed ... it chages by the username of the member ... check the attachment ... :) it's possibile to fix this?

Check the settings, you can set the size of the bars to a fixed size.

KURTZ 02-29-2008 09:07 PM

I know Phalynx, but if i change the percentage of the width the trouble remains the same with smaller bars ...

Paradigm 02-29-2008 09:10 PM

This is what I have installed. It says 4.4. Is there a query I can run to give you the list of tables?

Phalynx 02-29-2008 09:16 PM

Quote:

Originally Posted by KURTZ (Post 1453985)
I know Phalynx, but if i change the percentage of the width the trouble remains the same with smaller bars ...

Don't use %, just enter f.e. 200

Phalynx 02-29-2008 09:17 PM

Quote:

Originally Posted by Paradigm (Post 1453987)
This is what I have installed. It says 4.4. Is there a query I can run to give you the list of tables?

Here:
Code:

SHOW TABLES

Paradigm 02-29-2008 09:19 PM

I sent the results to you in a PM.

Paradigm 02-29-2008 09:23 PM

I ran that first query again only I substituted vbcybppdonate for cybppdonate.


The results are:

Code:

sum_amount
35


Phalynx 02-29-2008 09:27 PM

Ok, I think I know why it did not work for you. I've attached the file includes\class_xperience.php - please copy to your server, run recounter and check if it worked.

-- Removed file, it's now included in ZIP

Paradigm 02-29-2008 09:30 PM

I tip my hat to you sir. It worked!

Why wasn't it working for us? What is differnet from our board to yours?

Phalynx 02-29-2008 09:33 PM

It's simple, I checked for the table for the PayPal Hack without the table prefix. Stupid :/

Phalynx 02-29-2008 09:51 PM

I've updated the ZIP with the new file. Also I fixed an error with the display of "Post Thanks" points.

3.7.7, 1st March 2008
- Fixed not counting points for some xperience providers due to missing check for table prefix
- Fixed a bug where points for "Post Thanks" were not displayed in profile

hubba 02-29-2008 09:57 PM

>of the width the trouble remains the same with smaller

Same with me, even if I set it to 100px. But only in IE, in Opera it is OK.

koxito 02-29-2008 09:59 PM

Just Updated. Works Perfect, all the options are there! :) congratulations man... yeah you were right i dont know why it hasnt been showing on my forum.. but it works great now!

YOUR ROCKS!

May be for the next update you may consider, make it a category in the ADMIN CP, like vbimagehosting or blogs... couse this is now a major adition!

GREAT JOB.. keep in touch!... :P

Next sugestion: you should include in the % bar.. the resting points until level up... example if you have 1200 points and the next level is 1250, should display Next level: 70% / 50 points.

it would be cool!

Edit: bars work for me.

Great job! :)

Lumis Out.

Phalynx 02-29-2008 09:59 PM

Quote:

Originally Posted by hubba (Post 1454023)
>of the width the trouble remains the same with smaller

Same with me, even if I set it to 100px. But only in IE, in Opera it is OK.

I have no clue how to fix that. I must be something with the used style as in default style there is all perfect sized.
Can you please confirm that with a fresh created and unmodified style?


Quote:

Originally Posted by koxito (Post 1454025)
Next asking: you shoult include in the % bar.. the resting points until level up... example if you have 1200 points and the next level is 1250, should display Next level: 70% / 50 points.

Noted as a todo for next version.

maidos 02-29-2008 10:07 PM

u told me that $template_hook[postbit_userinfo_left] can be moved to differnet place in order to make the nav bars relocate.

but it didnt work

and as for the levels i tried editing with usergroup but its rewally confusing.... every member seemto have level 1 and 99 % on level bar

Phalynx 02-29-2008 10:12 PM

Quote:

Originally Posted by maidos (Post 1454030)
u told me that $template_hook[postbit_userinfo_left] can be moved to differnet place in order to make the nav bars relocate.
but it didnt work

No, $template_hook[postbit_userinfo_left] is for the postbit (showing a thread). Navbar is $template_hook['navbar_buttons_right']

I told you postbit_userinfo_left because you asked for relocating it under the postcount.

Quote:

Originally Posted by maidos (Post 1454030)
and as for the levels i tried editing with usergroup but its rewally confusing.... every member seemto have level 1 and 99 % on level bar

Which level product did you import?

ogameclub 02-29-2008 10:30 PM

Quote:

This product is not compatible with version 3.6.8 of vBulletin. (Compatible starting with 3.7.0 Beta / Incompatible with 3.7.99 and greater)
Oh nooo

hubba 02-29-2008 10:44 PM

>I have no clue how to fix that

Yes it is VERY strange.

>Can you please confirm that with a fresh created

Yes, with a complete untouched postit... thats the same.

maidos 03-01-2008 08:46 AM

yes thats the thing i tried moving that postbit_userinfo_left under post count... doesnt work... can you help out?
level product70


All times are GMT. The time now is 09:32 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.03078 seconds
  • Memory Usage 1,840KB
  • 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
  • (4)bbcode_code_printable
  • (17)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