Add-On Releases - vBExperience

vBExperience 3.8 (aka xPerience)

Created by Marius Czyz aka Phalynx.

Winner of the "Mod of the Month"-Award (March 2008) on vBulletin.org.


Description
vBExperience is your feature packaged solution for motivation and satisfying your users. vBExperience is an advanced Level/Promotion and Activity System with Shop, Awards and Activities. It will calculate an activity and experience score for every user based on their activites on the forum. Now your users will see how their level is increasing by participating on your forum.

This mod was developed by me because I was never satisfied with the post count. Communities are not only defined by post count, they need much more parameters: Are the postings the user creates helpful? Are his threads frequently read? Does the user participate on the community by posting pictures, attachments, leaving visitor messages, tagging threads? All this can be answered with this mod.

Comments, suggestions, translations, bugs, etc... are very welcome! Support is only given to people who have clicked Mark as Installed.


Compatibility
This mod will work with vBulletin 3.7.x and 3.8.x. For vBulletin 3.6 you will need vBExperience 3.7



Demo:
http://www.insideearth.net/xperience.php?langid=5

Demo Profile:
http://www.insideearth.net/member.php?u=1&langid=5

Demo Rankings:
http://www.insideearth.net/xperience.php?langid=5

Demo Awards:
http://www.insidesupcom.de/xperience...wards&langid=1

Demo Promotions:
http://www.insidesupcom.de/xperience...=shop&langid=1

Demo Shop:
http://www.insideearth.net/xperience...=shop&langid=5

Demo Stats:
http://www.insideearth.net/xperience...stats&langid=5

Demo Earn Points:
http://www.insideearth.net/xperience...=earn&langid=5

Other Demo Site:
http://www.insidesupcom.de/xperience.php?langid=1


There are mainly four things visible for the users: The users score, his level, his next level up in %/points and his activity in %.


Calculation of the score
Taken into calculation are these things:
Threads
- Created threads
- Thread views of own threads
- Thread replies of own threads
- Thread votes of own threads
- Thread tags
- Replies to own threads
- Sticky threads
- Socialgroup Discussions (Discussions, Posts)

Posts
- Created posts
- Views on attachments

User
- Days since registration
- Average posts per Day (for users who are on forum for at least seven days)
- Referrals
- Received infractions
- Reputation / Use of reputation system
- Visitor messages on profiles
- Members of own social groups
- Albumpictures
- Friends
- Completing Profile

Misc
- Calendar entries


Additionally there is support for 3rd party addons (some are already installed):
- vB Tournaments and Ladders (via CDP Addon)
- Post Ranking System (via CDP Addon)
- Helpful Answers (via CDP Addon)
- AWCoding-Donation System LITE and PRO (via CDP Addon)
- Cyb Paypal Donate (included)
- DownloadsII (included)
- ibProArcade Highscorer Points (via CDP Addon)
- LDM Links and Downloads Manager (included)
- PhotoPlog 2.1 (via CDP Addon)
- PhotoPost vBGallery (via CDP Addon)
- PhotoPost Pro (via CDP Addon)
- Post Thank You / Use of Post Thank You (via CDP Addon)
- QuoteIt! 3.16 (via CDP Addon)
- SAPR: Advanced Post Rating system (via CDP Addon)
- thanks via vS-Hide Hack Resurrection (Expanded Edition) (included)
- v3arcade Highscorer Points (via CDP Addon)
- v3arcade Submissions Points (via CDP Addon)
- vBulletin Blog (included)
- Who Downloaded This Attachment? (included)
- Other Addons can be easily added via CDP - Custom Data Provider plugins.

Additionally you can install these modifications:
- Thread Necromancer: Gives (minus-) points when a user is posting in old threads.
- Scrupulous Poster: Gives points for editing posts. Award users that are editing own posts instead of doing double post.
- Deletion Addicted: Gives points when an user/nod soft-deletes post, thread, visitormessage, groupmessage or picturecomment.
- Arm of Law: Give points for moderators who are using the infraction system
- Discussion Ender: Give points for people who are the last on a discussion
- RadioActivity: Reduce points for every day the user is not online

Also, there are already addons available that are working as Custom Data Provider (CDP). A CDP can extend vBExperience by collecting data and adding it to the vBExperience datastore. All point providers can be used for Awards and Shop.

You have to install these hacks for your own, vBExperience doesn't install nor touches these.


vBAdvanced
There are three vBAdvanced 3.0 XML modules: Most Active Users, Most Experienced Users and Last 20 Activities. Import them via vBAdvanced AdminCP.


Awards
There are six default awards: Most Popular, Activity Award, Posting Award, Community Award, Frequent Poster, Blog Award, Calendar Award. The awards are shown in Rankings and Profile. You can set them also to display in postbit near the username. There is a scheduled job running once a day (02:30h) to calculate them.
Via AdminCP they are completely customizeable and can also be assigned manually.
Awards can be created for every data provider.


Rankings
Showing User, Level, Awards, Activity Points (experience, thread, post, user, misc) - sortable.
Since 3.8.3, there is a also a ranking for Social Groups

Shop
A virtual Shop will motivate your users to earn more points. You can define categories and put virtual items with pictures in it. A currency can be defined seperatly for every item, e.g. 20 points from threads or 100 points from gallery. Users can purchase the items, they appear in their profile. The costs of the item are substracted from their xperience points. Additionally you can set quantity of the items.
The Shop will motivate your users to collect specific points to buy an item. Optionally you can show the last purchased items on postbit.
You can put virtual items in it, like WoW addons: Sell WoW Items in exchange of f.e. thread points. Great for RPG forums.
Non-Virtual Items like bold Usernames or Downloads for Points are already on my todo list.

Earn Points
There is an overview for the user on how points can be collected, with a list of users own points. All data is beeing pulled from the database (settings, phrases)

Statistics
The statistics is showing a Top-X list of the leading users. Usefull for optimizing points of the point provider. Only enabled point providers with results will be displayed.


Promotion system
To motivate users to do more on your forum I created the promotion system. By reaching defined xperience points the user will be moved to another usergroup - where you can set graphics, shadows, highlighting, etc... What is interesting in combination with this: you can give the user more possibilities f.e. larger avatars or bigger PM box. A log of the promotions is available.


Calculation of the activity
The system calculates the activity by taking the average post count/visitormessages/group discussion/Blog entries of the ten most active user and comparing it to own post count. This can be set to count only the last X days, f.e. 21 days.


Settings
You can control how many points are given to every calculation. For example you can give many points for creating new threads but only a few for views of that thread. Setting a value to 0 will disable a setting.
Additionally, you can set ignore users (f.e. for bot users), forums (f.e. offtopic forums) and usergroup id's.


Performance, Big Boards
vBExperience has been tested on smaller and also on some bigger sites. I know from boards with around 120k users running this mod smoothly. More about this topic can be read in the file readme_optimization.txt


Frequently asked questions
Q: How do I change the name Experience to something new?
A: You can change the name via phrases. Just search and replace all phrases that contains vBExperience.

Q: When installing vBExperience, does everyone start from scratch, or will it automatically configure everyone's points based on actions before the install?
A: If you recount, vBExperience will calculate ALL existing data since the beginning of the board.

Known Issues:
- Awards: On "Currently Active Users Viewing This Thread" awards are only shown for the user who is viewing this.
- Awards: If activated in with rich username, they are attached to the username. If the username is linked, the awards are also linked. If a link is underlined, the awards are also underlined. This behaviour is hardcoded in vBulletin and cannot be fixed.
- Settings are showing only a blank page, read here: http://www.vbulletin.com/forum/proje...6979#note74140
- If you completely remove vBExperience, you need also to uninstall the product XML manually from the pluginssystem

Credits for icons
- FAMFAMFAM, http://www.famfamfam.com/lab/icons/silk/
- IconExperience


History
3.8.5 Beta 3, 18th September 2009
- Fixed Promotions
- Fixed Notifications
- Added Activities to Promotions
- All Activities are not obeying limit
- AdminCP/Experience has a recount for Promotions and Achievements
- Fixed listing of Achievements with Firefox
- Several Beta 2 fixes

3.8.5 Beta 2, 02nd September 2009
- Just a short note: Condition in Achievements and Promotions are calculated in POINTS, not in counts of items.
If you choose 10 Day, you must enter the points needed for this.
For example: You have an achievement for 10 days. You have set 2 points for every day since registering. Calculation: 10*2 = 20
You will have to set 20 as the condition.
- New tabbed interface. If you want to change the style, edit the template xperience_navbar_css
- Promotions now showing usergroups and conditions for a promotion to the next group
- You can import old vBExperience Legacy promotions (that were created within level.xml)
- Achievements in Profile
- Achievements below Avatar
- Several Beta 1 fixes

3.8.5 Beta 1, 28th August 2009
- Achievements!
- Promotions!
- Notification on Awards, Promotions and Achievements
- GAP: Empty pointfields will not be displayed anymore
- Activity: Showing percent values with a decimal
- Activities now also for users
- Awards below Avatar
- Default Awards are now also creating new category
- Shop: Fixed issue in not returning cash on sells
- Reworked Edit Shop Items


Todo for Beta 3:
- Download files with vBExperience as a credit system ("LDM Links and Downloads Manager", "DownloadsII")
- Activity eraser
- AdminCP Permissions
- Advanced User Permissions


For more see history.txt

[Julrou]

Hey There !


I updated my forum in vb 3.7 last version 2 days ago, and then i tried to update vbExperience... but it doesn't work, and give me a nice database error. Here it is :

Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE xperience_awards SET awardlimit=0;

MySQL Error   : Unknown column 'awardlimit' in 'field list'
Error Number  : 1054
Request Date  : Monday, May 12th 2008 @ 09:55:56 AM
Error Date    : Monday, May 12th 2008 @ 09:55:57 AM
Script        : http://www.informatiquefacile.eu/forums/admincp/plugin.php?do=productimport
Referrer      : http://www.informatiquefacile.eu/forums/admincp/plugin.php?do=productadd
IP Address    : 82.XXX.XXX.XXX
Username      : Julien
Classname     : vb_database
MySQL Version : 4.1.20-log

Moreover, it gives me database errors when the cron tries to update the data for vbexperience, for example after a post...

I've just uploaded PHP files to my server, and import the xml file "vbexperience_level_2_average".
The product (product_vbexperience3712) is the only source of the problem...


How can i fix this ? Or can i downgrade to vbexprience 3.10 ?


Thanks for your answers

[Julrou]

I've just received a new error (via mail) :

Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE xperience_stats 
		SET
		points_thread=2518.2,
		points_threads=150,
		points_thread_votes=0,
		points_thread_replycount=952,
		points_thread_views=1356.2,
		points_thread_stickies=60,
		points_post=1314,
		points_posts=1314,
		points_post_thanks=0,
		points_post_thanks_use=0,
		points_user=1631.7248726852,
		points_user_infractions=0,
		points_user_activity=100,
		points_user_reputation=1039.5,
		points_user_reputation_use=0,
		points_user_online=420.72487268519,
		points_user_socialgroup=0,
		points_user_friends=39,
		points_user_visitormessages=2,
		points_user_albumpictures=0.5,
		points_user_referrals=130,
		points_post_attachment=0,
		points_post_attachment_views=0,
		points_thread_tags=0,
		points_misc=0,
		points_misc_ldm=0,
		points_misc_dl2=0,
		points_misc_ppg=0,
		points_misc_ppd=0,
		points_misc_vbblog=0,
		points_misc_custom=0,
		promoted=0,
		dateline=1210579260	
		WHERE userid=2;

MySQL Error   : Unknown column 'points_post_thanks_use' in 'field list'
Error Number  : 1054
Request Date  : Monday, May 12th 2008 @ 10:01:49 AM
Error Date    : Monday, May 12th 2008 @ 10:01:50 AM
Script        : http://www.informatiquefacile.eu/forums/cron.php?rand=906638
Referrer      : http://www.informatiquefacile.eu/forums/showthread.php?p=14724
IP Address    : 81.XXX.XXX.XX
Username      : Non inscrit
Classname     : vb_database
MySQL Version :

[Phalynx]

Originally Posted by mikeinjersey

Just when you thought every possible Mod was out there for vBulletin , this comes around... Wow, im blown away right now looking at the description and screenshots for this. Very nice and thought out Mod. Good stuff !

One question, are we able to disable certain ranking parameters ? Like for instance i'd like to disable the Infraction part... as sometimes members start out bad and then get good over time..it would suck if they had to see that stamped on their record forever.

Oops 2 questions.. And is there a Counter that has to be run that calculates all the previous members that have registered years ago ?

thanks much

No support for people who did not clicked Mark as Installed, sorry!

Originally Posted by gamerfu

Can I request an implementation Attack system like iBProBattle?

Currently no time for such extensions.

Originally Posted by EcoForumZ

Users are not able to stay logged into the forum. After loging in it says "Thank you for logging in" then when the page refreshes it shows nobody as being logged in.

That is for 100% not a problem of vBExperience.

Originally Posted by morpheusXIIX

I want to be able to modify my welcome block so that it shows the users activity level and current experience level. So they can see this right when they look to see PMs or New Posts.

Nice idea, will be part of next version.

Originally Posted by Julrou

I updated my forum in vb 3.7 last version 2 days ago, and then i tried to update vbExperience... but it doesn't work, and give me a nice database error.

Did you maybe mixed up content of ZIP/upload and XML? awardlimit is part of newer product XML (not level XML)

Originally Posted by Julrou

I've just received a new error (via mail) :

Which version of vBExperience are you using?

[Phalynx]

Originally Posted by ShadyMDUK

What was the answer as I only see two bars on mine and none of the cool graphics...

Check settings, enable Level Up Bar

Originally Posted by DBs

Thanks for a great mod but I have stumbled across a problem. In the rankings page many users are being listed duplicate times. Is this normal?

You will have to delete stats and do a recount.

[Julrou]

Originally Posted by Phalynx

Did you maybe mixed up content of ZIP/upload and XML? awardlimit is part of newer product XML (not level XML)


Which version of vBExperience are you using?

Thanks for your quick answer !

I just downloaded the zip from here, and re-uploaded the PHP files to my server.
Then, I tried to upload the xml file product, by the admin cp, and it made the database error... Then i've uploaded the level xml ("vbexperience_level_2_average"), and it worked.. but the product still didn't worked, and gave me errors...

I am still using vb experience 3.10, because i cannot update the product with the xml BUT the files on my server are 3.12 ones. :/

Jul.

[Phalynx]

Uninstall both XML, install 3.7.12 XML and after that the Level XML.

[honken]

and i will not losing all my experience points by uninstall and install?

[IrPr]

Originally Posted by honken

and i will not losing all my experience points by uninstall and install?

Points will be re-calculated by cron jobs

Marius, unfortunately due to really high server load caused by this mod i've decided to uninstalling this mod
First disabled cron jobs and restarted webserver to stop cron jobs but still forum was with lag
disabled whole vBexperienve product still same issue
at least i've decided to uninstall vbXperience and problem solved

im lookin for an optimize method for this supermod! for example just calculating points for active users
any chance for supadupa crazy forums?

[subnet_rx]

Originally Posted by subnet_rx

I've created a couple of new rewards based on posts and threads created. Problem is, even though I marked 0 for automatic calculation, the awards aren't being handed out. Is there something you have to do to the cron job or something?

Any suggestions here?

Originally Posted by IrPr

im lookin for an optimize method for this supermod! for example just calculating points for active users
any chance for supadupa crazy forums?

I'm not having lag problems, but I'd like to see this as well. I'd love to see rewards given out based on what has happened over a specific time period like a week or month, instead of just handing it to the top in each category since the beginning of the board.

[germinus]

Is it me or is the only thing that works with this is the activity bar when useing 3.6.9