Major Additions - vBCredits - Ultimate Points System

vBCredits is the ultimate points system for your vBulletin!
Click here for the vB3.6 compatible version

Yes, this also works for vB3.8!

Thank you to everyone who voted us MOTM

Features:

• Earning Credits
  • Twenty-Four Actions Eligible for Awards
    • Induction
      • Registration, Promotion, Subscription, etc
    • Referral
    • Paycheck
      • Definable Time Period
    • Activity
      • Definable Qualification
    • Birthday
    • Grant Reputation
      • Can Integrate with Rep Power
    • Receive Reputation
      • Can Multiply Reputation Points
    • Infraction
      • Can Multiply Infraction Points
    • New Thread
    • Rate Thread
      • Can Multiply Rating
    • Posting
    • Own Thread Posting
    • Post Size
      • Multiply Against Chars or Words
      • Can Strip BB Code Prior
      • Definable Maximum
    • Your Thread Viewed
      • Can Disable Guest Views
    • Your Thread Rated
    • Your Thread Replied
    • Your Profile Viewed
    • Poll Creation
    • Poll Vote
    • Upload Attachment
    • Sending PM
    • Calendar Event
    • Profile Picture
    • Profile Fields
      • Can Multiply Number of Fields
      • Can Set Minimum Fields
  • Decimal Settings for Credits and Percentages
  • Protocol for Negative Balances
  • Award Recalculation when Action Changes
  • Award Negation Multiplier
    • When Action Revoked Such As Post Deletion
  • Forum Overrides
    • Twelve Eligible Actions by Usergroup
    • ACP Tool to Configure Multiple at Once
    • Earning in Forums Can be Turned Off
• Displaying Credits
  • Everybody, Private, Nobody
    • Usergroup Permission to See All Private Amounts
  • Displays by Global, Usergroup, Forum
  • Lock Usergroups from Entire System
  • AJAX Navbar Amount Refresh
  • Display / Order by Savings, Checking, or Both
  • Richest User Listing
    • Can Exclude Usergroups From Listing
  • Display Credits in Memberlist
• Extensive Referral System
  • Validate by Time, Posts, and Reputation
  • Referee Credit Incentive
  • Number of Referrals per Referral Point
  • Maximum Referral Points
  • Referral Points Multiplied Against Additive Referral Bonus
  • ARB Increases ALL Other Action Award Amounts
• Post Award System
  • AJAX Through Thread or Profile
  • Can Spend From Central Board Account
    • Filled from Taxes, Fees, etc
  • Daily, User, Thread Limits
  • Can Disallow Negative Awards
  • Disable by Usergroup, Forum
  • Moderate by Usergroup, Forum
  • Can Publicly Display Awards in Thread
• Transaction Log
  • Displays All Donations, Awards, Payments, Winnings, etc
  • Can be Split into Pages
  • Usergroup Permission to View All Users' Logs
  • Specify Transaction Alerts via PM
  • Comments and Reasons Allow BB Code
• Donations
  • Support for Comments and Anonymous
  • Time Based User Limits
  • Donation Fee
  • Fee Handling Protocol
  • Moderate / Cancel Donations
• Drawings
  • Unlimited Concurrent Drawings
  • Raffle / Lottery Types
  • Static / Raising Jackpots
  • Per Drawing Ticket Cost
  • Maximum Active Tickets
  • Minimum / Maximum Tickets Sold for Drawings
  • Recurring Drawings
  • Usergroup Discounts
  • Configurable Title and Date
  • Exclude Usergroups
  • Optional Winner PHP
  • Allow Lottery Number Picking
  • Tax on Winnings
  • Archive Time Limit for Completed Drawings
  • Retry Period for Ineligible Drawings
• Savings Accounts
  • Validate Access by Time, Posts, and Reputation
  • Minimum Balance for Interest
  • Bank Transfer Fee
  • Pending Deposits
  • Early Withdrawal Fee
  • Interest Intervals
  • Maximum Savings per Usergroup
  • Configurable Usergroup Interest Rates
  • Moderate Deposits
• Loans
  • Moderate Loans
  • Maximum Total Loans and Amounts
  • Minimum Loan Amount
  • Minimum Payment by Due Date
  • Late Payment Fee
  • Automatic Recurring Payments
  • Accountability Rating for Loan Repayment
  • Good and Bad Rating Thresholds
  • Lock Spending Ability if Below Bad Rating
  • Transfer Usergroups when Threshold Passed
    • Reward or Punish Users with New Rates and Abilities
• Administrative Utilities
  • Mass Usergroup Updater
    • Select Template Usergroup to Copy Settings
    • Select Multiple Target Usergroups
    • Configure All Usergroup Settings and Awards
  • Mass Credit Updater
    • Retroactively Award Users Based on Settings
    • Can be Used to Award Static Amounts to All Users
    • Can be Used to Reset Entire Usergroups
    • Pick and Choose Usergroups and Awards to Calculate
  • Modify User Accounts by Criteria
    • First Search for Users Using Familiar Options
    • Can Search by Savings and Checking Amounts
    • Can Alter Resulting Users' Amounts Directly
    • Can Apply Easy-to-Use Custom Defined Formula
      • Use Simple Math, Numbers, and Variables
        • Days Registered
        • Post Count
        • Reputation
        • Infraction Points
        • Checking and Savings Amounts
• Overall Quality
  • Everything is Easily Disabled / Unlimited
  • Will Not Alter Environment for vB or Other Hacks
  • Fully Phrased
  • Complete Admin Help*
  • WOL Locations
  • Includes Hooks
  • Unique Plugin Optimization
  • Uses Bitfields and Datastore
  • Maintains Sessions
  • Includes TMS Support
  • No File Edits

and much more!

Just follow the directions carefully in the zip based on whether you are clean installing or upgrading


Fully integrated with vBulletin and easily integrated with third party scripts:
Many hacks allow you to specify a points system by entering the table and column for the points data. Use TABLE: user COLUMN: credits when integrating vBCredits with such hacks (note: you may need to include your table prefix with some hacks)! If you are unsure about integration - ask me!

Why is this version not the gold version yet?
vBCredits 1.4rc1 went through a long bugtesting process at the official site, and rc2 is largely bug free in its entirety. However, *it is missing most of the admin help and post/thread deletion actions are temporarily removed while I figure out how to fix them.

Footnotes:
Thank you for using vBCredits, I would be happy to hear your feedback and correct anything that comes up. For more tailored support, please indicate you have installed this hack, and if you like it you can nominate this for MOTM. Use of this free hack requires that you retain the copyright line at the bottom of the forum (PM me otherwise). If you do not agree with this, please do not use vBCredits - thank you for your understanding and support!

[yeshoward]

Hi
we have a ads board and we want members need to "spend" X points per classified ads they post there, possible for your module? so posting is actually deducting points instead of earning

[imported_silkroad]

Yes, it certainly possible (anything is possible!)

If you want to see this in action, visit this link and try to post a "New Thread" as a registered user.

[imported_silkroad]

Hi Dark,

Any idea why this vbcredits query appears so many times in the mysql-slow.log (low query log)? This vbcredits query dominates our slow queries log (slow query time is a big 10 sec). Not sure why.

Stats from the last hour or so:

Count: 10456 Time=0.00s (40s) Lock=0.00s (1s) Rows=0.0 (31),
SELECT award.*, award.fromuserid AS userid, user.* FROM credits_transactions AS award LEFT JOIN post AS post ON (award.postid = post.postid) LEFT JOIN user AS user ON (award.fromuserid = user.userid) LEFT JOIN thread AS thread ON (post.threadid = thread.threadid) WHERE award.action = 'S' AND award.completed = N AND thread.threadid = N ORDER BY award.postid ASC, award.timestamp DESC

Thanks.

[imported_silkroad]

Hi (again) Dark,

Nevermind, sorry. I see the issue. We have this set:

--log-queries-not-using-indexes

Command Line Format --log-queries-not-using-indexes Config File Format log-queries-not-using-indexes Option Sets Variable Yes, log_queries_not_using_indexes Variable Name log_queries_not_using_indexes Variable Scope Global Dynamic Variable Yes Deprecated 5.1.29, by slow-query-log Value Set Type boolean


If you are using this option with the slow query log enabled, queries that are expected to retrieve all rows are logged. See Section 5.2.4, “The Slow Query Log”. This option does not necessarily mean that no index is used. For example, a query that uses a full index scan uses an index but would be logged because the index would not limit the number of rows.

[sebil]

hello..

i just installed this one ye.. and got this error.. with 3.7

1||1246996131||92.25.91.29||do=options&dogroup=cre dits_global_settings||http://www.malludreams.com/forum/adm...v||Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/530.5 (KHTML, like Gecko) Chrome/2.0.172.33 Safari/530.5Access Denied, you have been logged.

and with 3.6:-
iam getting this errror..

A conflict was detected in the bitfields. You cannot continue with the installation of this product until this has been fixed. The conflicts found were:
Bitfield Collision: credits_cantearn = prefixrequired

please helpp

[lafsunlmtd]

I've got a very large forum that runs on a cluster of multiple servers.. How does vbCredits run in a multiple server environment with over 425,000 members? Will we run into any problems using this system, or should everything work out alright?

[Darkwaltz4]

Originally Posted by yeshoward

Hi
we have a ads board and we want members need to "spend" X points per classified ads they post there, possible for your module? so posting is actually deducting points instead of earning

you can set negative awards even per forum with the forum overrides system, but to make it require a positive number of credits to complete the action, youll need this addon:
http://www.vbcredits.com/forum/showthread.php?t=945

Originally Posted by imported_silkroad

Hi (again) Dark,

Nevermind, sorry. I see the issue. We have this set:

--log-queries-not-using-indexes

Command Line Format --log-queries-not-using-indexes Config File Format log-queries-not-using-indexes Option Sets Variable Yes, log_queries_not_using_indexes Variable Name log_queries_not_using_indexes Variable Scope Global Dynamic Variable Yes Deprecated 5.1.29, by slow-query-log Value Set Type boolean


If you are using this option with the slow query log enabled, queries that are expected to retrieve all rows are logged. See Section 5.2.4, ?The Slow Query Log?. This option does not necessarily mean that no index is used. For example, a query that uses a full index scan uses an index but would be logged because the index would not limit the number of rows.

admittedly, i need to learn optimal table indexing

Originally Posted by sebil

hello..

i just installed this one ye.. and got this error.. with 3.7

and with 3.6:-
iam getting this errror..

please helpp

vbcredits isnt compatible with vbfirewall
to install on vb3.6, install the vb3.6 version of vbcredits instead

Originally Posted by lafsunlmtd

I've got a very large forum that runs on a cluster of multiple servers.. How does vbCredits run in a multiple server environment with over 425,000 members? Will we run into any problems using this system, or should everything work out alright?

well, ive had several big board users with vbcredits tell me it works alright, in fact you can ask imported_silkroad about his experiences with it and im pretty sure hes got even more members

[lafsunlmtd]

hmmm.... it won't install on my master/slave server environ as is. it keeps trying to write to my slaves. I will try some other stuff and let you know if anything works.

[Saviour]

Not sure if this has been covered before...too many posts to search.

Anyway...

When purchasing raffle tickets, I noticed that you will receive an error if you hit the Enter key instead of clicking on Purchase. It causes a database error with the below message:

Database error in vBulletin 3.8.3:

Invalid SQL:
SELECT * FROM vb_credits_lottery WHERE lotteryid =;

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 1
Error Number : 1064
Request Date : Wednesday, July 8th 2009 @ 02:43:33 PM
Error Date : Wednesday, July 8th 2009 @ 02:43:34 PM
Script : http://xxxxxxxx.com/forums/credits.php?do=lottery
Referrer : http://xxxxxxxx.com/forums/credits.php?do=manage
IP Address : [removed]
Username : xxxxxx
Classname : vB_Database
MySQL Version : 5.0.67-log

Is this a bug? Is there a fix?

[bluecamosis]

Hi, I have a question about this hack. I've successfully installed it on my forums and it's working perfectly fine. But I have a query.

Is there a way to calculate the total amount of credits for a particular user group? I have 4 different "teams" in my forum, and I'm thinking of displaying the total amount of credits each group has accumulated, but I'm not sure how to do that. Help will be greatly appreciated thanks! =)