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!

[50calray]

Originally Posted by Darkwaltz4

Couple ways to do it:

You can use the mass credit updater again (select all groups DONT select any awards, base 0, let it process)

I just did this and my website freaked out on me?

I get some type of warning and the forum skin turned white minus the banner.

Warning: Division by zero in [path]/includes/functions_credits.php on line 28

http://www.semiautorifles.com/forums...911-a-967.html

[50calray]

edited: my IT guy rebooted it.

[Darkwaltz4]

Originally Posted by kawe

why my credits not align left ?
how to fix it
im already revert all template
and setup follow the instruction

look at the other lines in the navbar area - do they have classes on them that need to also be applied to the new line you added for vbcredits? your style's css might not be expecting to style that line, so the default is making it center.

Originally Posted by imported_silkroad

FWIW, Added new field winnumber to MySQL table credits_lottery to record winning number after each lottery. Code mod below:

# diff credits_daily.php credits_daily.php.back2
183c183
<                       $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "credits_lottery SET active = 0, winner = '" . $vbulletin->db->escape_string(serialize($winners)) . "', winnumber = $winnumber WHERE lotteryid = " . $lottery['lotteryid']);
---
>                       $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "credits_lottery SET active = 0, winner = '" . $vbulletin->db->escape_string(serialize($winners)) . "' WHERE lotteryid = " . $lottery['lotteryid']);

If it works (hope so!), will mod template to show winning number in last lottery, which is missing now.

that looks like it should work, and easy to pull out when listing finished drawings

Originally Posted by 50calray

Warning: Division by zero in [path]/includes/functions_credits.php on line 28

You put 0 for the number of referrals per referral point. it needs to be 1 or higher - it is NOT the same as the referral award (it has to do with the additive referral bonus). once you fix that the error will go away and your style will fix itself.

[imported_silkroad]

Originally Posted by Darkwaltz4

that looks like it should work, and easy to pull out when listing finished drawings

Thanks!

I'll check the database when the current drawing happens the end of this week. If it works, I'll finish add to the lottery output.

Cheers.

[ArnyVee]

Originally Posted by imported_silkroad

FWIW, Added new field winnumber to MySQL table credits_lottery to record winning number after each lottery. Code mod below:

# diff credits_daily.php credits_daily.php.back2
183c183
<                       $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "credits_lottery SET active = 0, winner = '" . $vbulletin->db->escape_string(serialize($winners)) . "', winnumber = $winnumber WHERE lotteryid = " . $lottery['lotteryid']);
---
>                       $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "credits_lottery SET active = 0, winner = '" . $vbulletin->db->escape_string(serialize($winners)) . "' WHERE lotteryid = " . $lottery['lotteryid']);

If it works (hope so!), will mod template to show winning number in last lottery, which is missing now.

Originally Posted by Darkwaltz4

that looks like it should work, and easy to pull out when listing finished drawings

Wow, if this works, please share!

[imported_silkroad]

Hi Dark!

We need to stop giving credits to users without activity for the past two years. Where would we add some PHP code like this:

//     60 * 60 * 24 * 365 * 2 = 63072000
$twoyearsago = time() - 63072000;

if ($userinfo[lastactivity] < $twoyearsago )
{
    exit;
}

Or the same code in the template somewhere?

<if condition="$userinfo[lastactivity] < (TIMENOW - 63072000)">
     User has not logged in for 30 days exit or something
</if>

Where should we do it?

Thanks!!

[imported_silkroad]

Originally Posted by ArnyVee

Wow, if this works, please share!

OK, if we get it working, will let you know. Right now, we have a bug in the lottery code, but it was from another change we made, so we should know if this is working next weekend.

If it works, just follow the instructions in post 890 above.

Cheers.

[Darkwaltz4]

Originally Posted by imported_silkroad

Hi Dark!

We need to stop giving credits to users without activity for the past two years. Where would we add some PHP code like this:

//     60 * 60 * 24 * 365 * 2 = 63072000
$twoyearsago = time() - 63072000;
 
if ($userinfo[lastactivity] < $twoyearsago )
{
    exit;
}

Or the same code in the template somewhere?

<if condition="$userinfo[lastactivity] < (TIMENOW - 63072000)">
     User has not logged in for 30 days exit or something
</if>

Where should we do it?

Thanks!!

the easy way is to move those users into a usergroup that doesnt earn credits for anything

or you can add that check to the includes/functions_credits.php award_credits function, and then the includes/cron/credits_daily.php file to change this query

PHP Code:

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits = credits + CASE$pcsql ELSE 0 END WHERE credits_canearn = 1"); 


to include the date range

[imported_silkroad]

Originally Posted by Darkwaltz4

the easy way is to move those users into a usergroup that doesnt earn credits for anything

or you can add that check to the includes/functions_credits.php award_credits function, and then the includes/cron/credits_daily.php file to change this query

PHP Code:

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits = credits + CASE$pcsql ELSE 0 END WHERE credits_canearn = 1"); 


to include the date range

Thanks Dark!

I don't think we will move the users to another usergroup, because if they become active again, which they often do, then we have to move them back. That that would not work for us.

So, I think I'll add the check to credits_daily.php as you suggested. I might add a new vB Option in the AdminCP for this instead of hardcoding our two year rule.

Thanks again.

[imported_silkroad]

Hi Dark,

I looked at that line in credits_daily.php. Perhaps my post was not clear, or I am missing something, or simply am making a mistake.

I want users who have been inactive for two years to receive no credit for anything (especially credit for having their old posts viewed, since we get a lot of traffic).

Does this one line in credits_daily.php "do it all", in other words, it is the one line that adds user credits for post views, posts, etc.?

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits = credits + CASE$pcsql ELSE 0 END WHERE credits_canearn = 1")

How about the query_write above that one?

  $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET credits = credits + CASE$cdtsql ELSE 0 END, credits_numrefs = credits_numrefs + CASE$refsql ELSE 0 END WHERE credits_canearn = 1 AND usergroupid IN (" . implode(', ', $goodug) . ")")

;

Thanks!