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)

RollaJedi 08-19-2010 01:56 PM

:D sorry if i'm seeming to pressing. Thats good enough for me. :)

Phalynx 08-19-2010 02:18 PM

vBExperience 4.0.2 Release Candidate has been published. Please provide your feedback to this release, thanks!

Changelog:
Speedy Achievements! Improved the overall speed of the achievements engine by switching from user based to achievement based calculation.

- Added: Achievements can replace each other. If you have an achievement for 500 points, you can replace the achievement for 250 points.
- Added: Multiple conditions on one achievement
- Added: Achievement can be taken away if condition is not met anymore (optionally)
- Improved: Faster recount on achievements. Achievements are now calculated once in an hour for all users, this process is seperated from the points calculation (which speeds this up, too).
- Improved: Increased limitation of achievements
- Improved: Take away specific issued achievements from users, no need to take away all
- Fixed: Achievements duplicated for a single user

### For the achievements improvements you need to clear the issued achievements and recount them! ###

- Added: Place the bars freely in postbit
- Added: GAP in memberinfo dropdown
- Fixed: XHTML Warnings
- Fixed: SQL Error with empty points
- Fixed: Calculation not working with v3arcade Submissions
- Fixed: Ignoring hook "postbit_messagearea_start"
- Fixed: In memberprofile tabs of other modifications are empty

- New plugin for PhotoPlog
- vBGallery Images and vBGallery Comments are bundlet into one plugin

Magz 08-19-2010 02:33 PM

eeek

just got this when importing product

Fatal error: Call to undefined function DoIndex() in /home/*******/public_html/includes/adminfunctions_plugin.php(920) : eval()'d code on line 33

Phalynx 08-19-2010 02:47 PM

You should FIRST upload files to the server.

RollaJedi 08-19-2010 02:58 PM

phalynx,
i upgraded to the newest vbexperience. All my achievement icons are 16x16 again. Your file called 'functions_xperience.php' must be different now because i can't find the place inside the file where i changed the 16x16 size to 34x34 size.

Previously you had told me:

Edit functions_xperience.php,

search for:
$awards .= '<img style="vertical-align: middle;" border="0" width="16" height="16" src="'.$vbulletin->options['bburl'].'/xperience/icons/'.$awardurl.'" alt="'.$awardtitle.'" title="'.$awardtitle.'" />';


replace with:
$awards .= '<img style="vertical-align: middle;" border="0" width="32" height="32" src="'.$vbulletin->options['bburl'].'/xperience/icons/'.$awardurl.'" alt="'.$awardtitle.'" title="'.$awardtitle.'" />';


this is no longer valid. can you help me on this again? :)

Magz 08-19-2010 03:34 PM

Quote:

Originally Posted by Phalynx (Post 2086365)
You should FIRST upload files to the server.

As per all other upgrades, I did.

I've just re uploaded all files ( to make sure i didn't miss any ), and still get that when importing.

RollaJedi 08-19-2010 03:43 PM

ok, i figured it out actually. I found that you now have a template with that information inside it.
However, there is now a break between each achievement. I want them together with no breaks. Is there some place to edit so i can get rid of the break? Thanks!

Phalynx 08-19-2010 04:26 PM

Quote:

Originally Posted by Magz (Post 2086389)
As per all other upgrades, I did.

I've just re uploaded all files ( to make sure i didn't miss any ), and still get that when importing.

I'm pretty sure the file \includes\install_xperience.php is outdated.

Quote:

Originally Posted by RollaJedi (Post 2086399)
ok, i figured it out actually. I found that you now have a template with that information inside it.
However, there is now a break between each achievement. I want them together with no breaks. Is there some place to edit so i can get rid of the break? Thanks!

I will take a look if this can be cutted.

RollaJedi 08-19-2010 04:34 PM

cool, thanks! it just doesnt look right with the icons i have and the new break between them. :)

Magz 08-19-2010 04:49 PM

Sorted, 3rd attempt re-uploading resolved the issue, ftp must of been having a funny five minutes

Veer 08-19-2010 06:47 PM

Quote:

Originally Posted by RollaJedi (Post 2086399)
ok, i figured it out actually. I found that you now have a template with that information inside it.
However, there is now a break between each achievement. I want them together with no breaks. Is there some place to edit so i can get rid of the break? Thanks!

What templates need to be edited for this?

Veer 08-19-2010 06:48 PM

Quote:

Originally Posted by Phalynx (Post 2086340)
vBExperience 4.0.2 Release Candidate has been published. Please provide your feedback to this release, thanks!

Thanks for the update Phalynx.
I will post feedback shortly :)

Phalynx 08-19-2010 06:57 PM

Edit the template xperience_xpicon_small

Veer 08-19-2010 07:17 PM

Quote:

Originally Posted by Phalynx (Post 2086493)
Edit the template xperience_xpicon_small

Okay found it, Thanks.

Veer 08-19-2010 07:20 PM

Got Database error when recounting achievements:

Code:

Database error in vBulletin 4.0.6:

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 's a Crowd";s:5:"small";s:14:"friends_32.png";s:3:"big";s:14:"friends_48.png";}}'' at line 3
Error Number  : 1064
Request Date  : Thursday, August 19th 2010 @ 04:15:42 PM
Error Date    : Thursday, August 19th 2010 @ 04:15:43 PM
Script        : http://www.domain.com/admincp/xperience_admin.php?do=xperience_admin_recount_ach
Referrer      : http://www.domain.com/admincp/xperience_admin.php?do=xperience_admin_recount_ach
Classname    : vB_Database
MySQL Version : 5.0.91-community


Phalynx 08-19-2010 07:22 PM

Remove the ' from Three's a Crowd - I will catch this for the next build.

Veer 08-19-2010 07:44 PM

Quote:

Originally Posted by Phalynx (Post 2086503)
Remove the ' from Three's a Crowd - I will catch this for the next build.

Hmm right, fixed.

pedroenf 08-19-2010 10:12 PM

Quote:

Originally Posted by Phalynx (Post 2086503)
Remove the ' from Three's a Crowd - I will catch this for the next build.

Remove it from where????

Veer 08-19-2010 10:14 PM

Quote:

Originally Posted by pedroenf (Post 2086573)
Remove it from where????

From the Achievement title.
If title contains ' then you will get error when you recount all Achievements.

pedroenf 08-19-2010 10:33 PM

But i do not have no ' in any tittle. My forum is portuguese and we use á and ã and ç. But none of this show in mysql errors.

WhiskeyOSS 08-20-2010 12:51 AM

When we click on ranking we get this error ?

Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT
COUNT(*) AS users
FROM xperience_stats AS x
INNER JOIN user AS u
ON u.userid=x.userid
WHERE 1=1 AND u.userid NOT IN(Bullie44, Whitey);

MySQL Error : Unknown column 'Bullie44' in 'where clause'
Error Number : 1054
Request Date : Thursday, August 19th 2010 @ 06:48:44 PM
Error Date : Thursday, August 19th 2010 @ 06:48:44 PM
Script : http://www.teamsrgaming.com/forums/x...php?go=ranking
Referrer : http://www.teamsrgaming.com/forums/xperience.php
IP Address : 76.11.220.172
Username : WhiskeySR
Classname : vB_Database
MySQL Version : 5.0.91-log

Veer 08-20-2010 01:23 AM

Phalynx, Promotion system still need to be updated, promotion / demotion both not working plus getting database error when remove all promotions.

Any idea when it will be updated?

Phalynx 08-20-2010 06:58 AM

Quote:

Originally Posted by pedroenf (Post 2086583)
But i do not have no ' in any tittle. My forum is portuguese and we use ? and ? and ?. But none of this show in mysql errors.

The ' is reserved for use in SQL statements. It's just missing an addslash command to avoid this. Fixed in final 4.0.2

Quote:

Originally Posted by WhiskeyOSS (Post 2086625)
When we click on ranking we get this error ?

Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT
COUNT(*) AS users
FROM xperience_stats AS x
INNER JOIN user AS u
ON u.userid=x.userid
WHERE 1=1 AND u.userid NOT IN(Bullie44, Whitey);

MySQL Error : Unknown column 'Bullie44' in 'where clause'
Error Number : 1054
Request Date : Thursday, August 19th 2010 @ 06:48:44 PM
Error Date : Thursday, August 19th 2010 @ 06:48:44 PM
Script : http://www.teamsrgaming.com/forums/x...php?go=ranking
Referrer : http://www.teamsrgaming.com/forums/xperience.php
IP Address : 76.11.220.172
Username : WhiskeySR
Classname : vB_Database
MySQL Version : 5.0.91-log

Don't enter the username for the users beeing ignored. You will have to enter the UserID!


Quote:

Originally Posted by Veer (Post 2086638)
Phalynx, Promotion system still need to be updated, promotion / demotion both not working plus getting database error when remove all promotions.

Any idea when it will be updated?

Fixed in final.
Also, promotions are working - what are you missing here? Demotions need a workaroung by doing it with an extra thing.

Phalynx 08-20-2010 07:36 AM

This has been fixed for final 4.0.2:
- Improved: Speed improvements on Insight
- Improved: Speed improvements on Activities
- Fixed: Error while clearing all promotions
- Fixed: Achievements/Awards now without space between
- Fixed: Uncached template 'xperience_gap_memberaction'

I'm also waiting for a confirmation about the member profile tabs. Does it happen again?

Please take also a look if you have templates that need to be reverted.

KURTZ 08-20-2010 08:56 AM

Code:

Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT
                a.awardid AS id,
                a.awardtitle AS title,
                a.awardurl AS small,
                a.awardbigurl AS big
                FROM xperience_award_issues AS i
                INNER JOIN xperience_awards AS a ON a.awardid=i.awardid
                WHERE i.userid=2
                ORDER BY i.dateline
                LIMIT 0,;

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 '' at line 10

got this.

Phalynx 08-20-2010 09:20 AM

Quote:

Originally Posted by KURTZ (Post 2086763)
Code:

Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT
                a.awardid AS id,
                a.awardtitle AS title,
                a.awardurl AS small,
                a.awardbigurl AS big
                FROM xperience_award_issues AS i
                INNER JOIN xperience_awards AS a ON a.awardid=i.awardid
                WHERE i.userid=2
                ORDER BY i.dateline
                LIMIT 0,;

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 '' at line 10

got this.

Please check if the setting "Limit Awards" is empty. If yes, put a 1 to it.

Phalynx 08-20-2010 09:57 AM

I've updated Inside SupCom to the newest build. You can now see the new replace achievement feature in action:
http://www.insidesupcom.de/member.php?1-Phalynx

KURTZ 08-20-2010 11:53 AM

Quote:

Originally Posted by Phalynx (Post 2086769)
Please check if the setting "Limit Awards" is empty. If yes, put a 1 to it.

thanks, seems to be fixed ... :)

MiNeM 08-20-2010 12:03 PM

Hi Guys,

I keep getting the following error when i run Update Experience points

it goes to User 130 everytime and the give me this DB error

Code:

Database error in vBulletin 4.0.6:

Invalid SQL:
UPDATE xperience_stats
                SET
                points_xperience=-4744,points_threads=0,points_thread_votes=0,points_thread_replycount=0,points_thread_views=6,points_thread_stickies=0,points_posts=0,points_post_avg=0,points_post_attachment=0,points_misc_events=0,points_threads_sg=0,points_posts_sg=0,points_post_attachment_views=0,points_user_profile=0,points_post_den=56,points_user_law=0,points_user_infractions=0,points_user_reputation=0,points_user_reputation_use=0,points_user_online=160,points_user_referrals=0,points_misc_custom=0,points_user_socialgroup=0,points_thread_tags=0,points_thread_rate=0,points_user_friends=0,points_user_visitormessages=0,points_user_albumpictures=0,points_misc_ldm=0,points_misc_dl2=0,points_misc_vbblog=0,points_misc_vbcms=0,points_misc_ppd=0,points_misc=0,points_thread=6,points_post=0,points_user=160,points_xperience=-4744,points_shop=0,points_post_scp=-12,points_post_thanks_used=-3,points_post_thanks_got_post=-1,points_post_thanks_got_total=-1,points_misc_ibparcadechamps=-5,points_user_activity=0,points_user_activity30=0,points_user_activity7=0,points_level=1,promoted=0,
        dateline=1282309080       
        WHERE userid=130;

MySQL Error  : Unknown column 'points_post_scp' in 'field list'
Error Number  : 1054
Request Date  : Friday, August 20th 2010 @ 02:56:37 PM
Error Date    : Friday, August 20th 2010 @ 02:58:25 PM
Script        : http://www.xbox-360.co.za/forum/admi...min_recount_xp
Referrer      : http://www.xbox-360.co.za/forum/admi...php?do=recount
IP Address    : 198.54.202.174
Username      : MiNeM
Classname    : vB_Database
MySQL Version : 5.0.91-community

Thanks in advance...

Phalynx 08-20-2010 12:08 PM

Please click "Mark as Installed" to get further support!

Uninstall the old vBExperience 3.8 plugin "vBExperience Scrupulous Poster".

RollaJedi 08-20-2010 12:30 PM

thank you P for the break fix on the next vbe! :)

MiNeM 08-20-2010 12:34 PM

Oops sorry "Installed"

MiNeM 08-20-2010 12:35 PM

Ok unistalled "vBExperience Scrupulous Poster"

But i am still getting error ?

Code:

Database error in vBulletin 4.0.6:

Invalid SQL:
UPDATE xperience_stats
                SET
                points_xperience=-4744,points_threads=0,points_thread_votes=0,points_thread_replycount=0,points_thread_views=6,points_thread_stickies=0,points_posts=0,points_post_avg=0,points_post_attachment=0,points_misc_events=0,points_threads_sg=0,points_posts_sg=0,points_post_attachment_views=0,points_user_profile=0,points_post_den=56,points_user_law=0,points_user_infractions=0,points_user_reputation=0,points_user_reputation_use=0,points_user_online=160,points_user_referrals=0,points_misc_custom=0,points_user_socialgroup=0,points_thread_tags=0,points_thread_rate=0,points_user_friends=0,points_user_visitormessages=0,points_user_albumpictures=0,points_misc_ldm=0,points_misc_dl2=0,points_misc_vbblog=0,points_misc_vbcms=0,points_misc_ppd=0,points_misc=0,points_thread=6,points_post=0,points_user=160,points_xperience=-4744,points_shop=0,points_post_scp=-12,points_post_thanks_used=-3,points_post_thanks_got_post=-1,points_post_thanks_got_total=-1,points_misc_ibparcadechamps=-5,points_user_activity=0,points_user_activity30=0,points_user_activity7=0,points_level=1,promoted=0,
        dateline=1282311240       
        WHERE userid=130;

MySQL Error  : Unknown column 'points_post_scp' in 'field list'
Error Number  : 1054
Request Date  : Friday, August 20th 2010 @ 03:32:54 PM
Error Date    : Friday, August 20th 2010 @ 03:34:07 PM
Script        : http://www.xbox-360.co.za/forum/admincp/xperience_admin.php?do=xperience_admin_recount_xp
Referrer      : http://www.xbox-360.co.za/forum/admincp/xperience_admin.php?do=recount
IP Address    : 198.54.202.174
Username      : MiNeM
Classname    : vB_Database
MySQL Version : 5.0.91-community


Phalynx 08-20-2010 12:39 PM

vBExperience 4.0.2 RC has arrived!

Upgrade Instruction:
1. Copy ALL (I mean ALL - That is a common error!) files from upload_via_ftp/ to the server.
2. ReImport product_vbexperience402.xml, allow overwrite
3. If you modified any of the vBExperience templates, revert them

Changelog:
- Added: Achievements can replace each other. If you have an achievement for 500 points, you can replace the achievement for 250 points. The shipped achievements are already configured to replace each other.
- Added: Multiple conditions on one achievement
- Added: Achievement can be taken away if condition is not met anymore (optionally)
- Added: Place the bars freely in postbit ($xperience_postbit / $xperience_achievements_postbit / $xperience_awards_postbit)
- Added: GAP in memberinfo dropdown

- Improved: Faster recount on achievements. Achievements are now calculated once in an hour for all users, this process is seperated from the points calculation (which speeds this up, too).
- Improved: Increased limitation of achievements
- Improved: Take away specific issued achievements from users, no need to take away all
- Improved: Speed improvements on Insight
- Improved: Speed improvements on Activities

- Fixed: Achievements duplicated for a single user
- Fixed: Error while clearing all promotions
- Fixed: Achievements/Awards now without space between
- Fixed: Uncached template 'xperience_gap_memberaction'
- Fixed: XHTML Warnings
- Fixed: SQL Error with empty points
- Fixed: Calculation not working with v3arcade Submissions
- Fixed: Ignoring hook "postbit_messagearea_start"
- Fixed: In memberprofile tabs of other modifications are empty

- New plugin for PhotoPlog
- vBGallery Images and vBGallery Comments are bundled into one plugin

Phalynx 08-20-2010 12:41 PM

Quote:

Originally Posted by MiNeM (Post 2086835)
Ok unistalled "vBExperience Scrupulous Poster"

But i am still getting error ?

Please check if it has been really uninstalled. The column "points_post_scp" comes from that plugin.

MiNeM 08-20-2010 12:43 PM

I checked i only have these installed

vBExperience 4.0.2 Calculate activity of your users
vBExperience Advanced Forum Points 4.0.0 Different Points for different Forums
vBExperience Level 4.0 vBExperience Level

Phalynx 08-20-2010 12:45 PM

1 Attachment(s)
Quote:

Originally Posted by MiNeM (Post 2086840)
I checked i only have these installed

vBExperience 4.0.2 Calculate activity of your users
vBExperience Advanced Forum Points 4.0.0 Different Points for different Forums
vBExperience Level 4.0 vBExperience Level

Ok, so you must do a clean install and afterward do an uninstall:
- Install the attached file - I just removed the dependency to vBExperience 3.8
- Uninstall it

Does the error appear again?

MiNeM 08-20-2010 12:56 PM

damn ok i installed it and then uninstalled it clean

and i still get that error..

also updated now to vBExperience402_RC_20100820 still same issue

Phalynx 08-20-2010 01:01 PM

Please list all installed plugins (not products!) on your system. You can PM me this also.

This is an old entry of old plugin, that is not related to vBExperience 4.

RollaJedi 08-20-2010 03:49 PM

just wondering if you ever got any further on that ibproarcade addon for tournament wins :)


All times are GMT. The time now is 11:19 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.03683 seconds
  • Memory Usage 1,856KB
  • 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
  • (16)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