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!

[imported_silkroad]

Hi Dark!

Maybe this is better, just add this to credits_daily.php ?

$twoyearsago = time() - 63072000;
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits = 0 WHERE lastactivity < $twoyearsago");

and also, this:

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits_canearn = 0 WHERE lastactivity < $twoyearsago");

So, the first query zeros out all the old credits of users inactive for more than two years, the second query turns off all credit earnings for the same group.

However, I need to turn credits_canearn back on when a user become active again, something like:

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits_canearn = 1 WHERE lastactivity > $twoyearsago");

Thoughts?

[imported_silkroad]

Update; I ended up with a simple vB cron file that does this once a day:

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits = 0 WHERE lastactivity < (UNIX_TIMESTAMP() - (60 * 60 * 24 * 365 * 2))");

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits_canearn = 0 WHERE lastactivity < (UNIX_TIMESTAMP() - (60 * 60 * 24 * 365 * 2))");

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits_canearn = 1 WHERE lastactivity > (UNIX_TIMESTAMP() - (60 * 60 * 24 * 365 *2))

[Darkwaltz4]

to simplify, you could add just this one query to the bottom of credits_daily

PHP Code:

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits_canearn = (lastactivity > " . (TIMENOW - 63072000) . "), credits = credits * credits_canearn"); 


[imported_silkroad]

Great idea, thanks!

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits_canearn = (lastactivity > " . (TIMENOW - 63072000) . "), credits = credits * credits_canearn")

;

But I don't understand it, ROTFL

[Darkwaltz4]

well its a combination of a couple sql tricks. the first sets the canearn flag to 1 or 0 (true or false, but it gets typecasted to int because thats the column type) based on the activity date.

the second multiplies your credits against that flag... if you can earn credits, then its 1 * your credits = your credits stay the same. if you cant earn credits, then its 0 = your credits are now 0.

[imported_silkroad]

Oh, so the () around the lastactivity condition makes it boolean?

Wow! I would call you Master, and me Grasshopper, but I don't want to end up in the closet of a hotel room in Bangkok with ropes "everywhere"

[Darkwaltz4]

in response to the... first part

the > makes it boolean, but the column (credits_canearn) is int, so boolean true becomes int 1 and boolean false becomes int 0. the parens are just for clarification

[imported_silkroad]

Originally Posted by Darkwaltz4

in response to the... first part

the > makes it boolean, but the column (credits_canearn) is int, so boolean true becomes int 1 and boolean false becomes int 0. the parens are just for clarification

Clever. Thanks!

[animcentral]

is this support point per forum?
i need a points system that support Point Per forum to set point per forums

[Darkwaltz4]

yep, it has forum overrides