Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
vBCredits - Ultimate Points System Details »
vBCredits - Ultimate Points System
Mod Version: 1.4rc2, by Darkwaltz4 (Coder) Darkwaltz4 is offline
Developer Last Online: Feb 2013 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.7.x Rating: (69 votes - 4.83 average) Installs: 935
Released: 07 Mar 2008 Last Update: 11 Mar 2008 Downloads: 8161
Not Supported DB Changes Uses Plugins Template Edits Additional Files Translations  

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!

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Major Additions vBCredits - Ultimate Points System Darkwaltz4 vBulletin 3.6 Add-ons 1868 18 Feb 2013 23:07

  #901  
Old 23 Jun 2009, 13:55
imported_silkroad imported_silkroad is offline
 
Join Date: Dec 2003
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?

Last edited by imported_silkroad; 23 Jun 2009 at 14:06.
Reply With Quote
  #902  
Old 24 Jun 2009, 12:33
imported_silkroad imported_silkroad is offline
 
Join Date: Dec 2003
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))
Reply With Quote
  #903  
Old 24 Jun 2009, 16:11
Darkwaltz4's Avatar
Darkwaltz4 Darkwaltz4 is offline
 
Join Date: Oct 2002
Location: Chicago
Real name: John
to simplify, you could add just this one query to the bottom of credits_daily


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
I probably want my scripts to work on your site more than you do!
www.DragonByte-tech.com
Reply With Quote
  #904  
Old 24 Jun 2009, 17:03
imported_silkroad imported_silkroad is offline
 
Join Date: Dec 2003
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
Reply With Quote
  #905  
Old 24 Jun 2009, 17:12
Darkwaltz4's Avatar
Darkwaltz4 Darkwaltz4 is offline
 
Join Date: Oct 2002
Location: Chicago
Real name: John
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.
__________________
I probably want my scripts to work on your site more than you do!
www.DragonByte-tech.com
Reply With Quote
  #906  
Old 24 Jun 2009, 17:34
imported_silkroad imported_silkroad is offline
 
Join Date: Dec 2003
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"
Reply With Quote
  #907  
Old 24 Jun 2009, 17:53
Darkwaltz4's Avatar
Darkwaltz4 Darkwaltz4 is offline
 
Join Date: Oct 2002
Location: Chicago
Real name: John
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
__________________
I probably want my scripts to work on your site more than you do!
www.DragonByte-tech.com
Reply With Quote
  #908  
Old 25 Jun 2009, 18:22
imported_silkroad imported_silkroad is offline
 
Join Date: Dec 2003
Originally Posted by Darkwaltz4 View Post
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!
Reply With Quote
  #909  
Old 25 Jun 2009, 18:46
animcentral's Avatar
animcentral animcentral is offline
 
Join Date: May 2009
Real name: http://animup.net
is this support point per forum?
i need a points system that support Point Per forum to set point per forums
Reply With Quote
  #910  
Old 26 Jun 2009, 02:56
Darkwaltz4's Avatar
Darkwaltz4 Darkwaltz4 is offline
 
Join Date: Oct 2002
Location: Chicago
Real name: John
yep, it has forum overrides
__________________
I probably want my scripts to work on your site more than you do!
www.DragonByte-tech.com
Reply With Quote
  #911  
Old 07 Jul 2009, 13:10
yeshoward yeshoward is offline
 
Join Date: Mar 2007
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
Reply With Quote
  #912  
Old 07 Jul 2009, 13:51
imported_silkroad imported_silkroad is offline
 
Join Date: Dec 2003
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.
Reply With Quote
  #913  
Old 07 Jul 2009, 13:56
imported_silkroad imported_silkroad is offline
 
Join Date: Dec 2003
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.
Reply With Quote
  #914  
Old 07 Jul 2009, 14:10
imported_silkroad imported_silkroad is offline
 
Join Date: Dec 2003
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.
Reply With Quote
  #915  
Old 07 Jul 2009, 19:53
sebil's Avatar
sebil sebil is offline
 
Join Date: Feb 2008
hello..

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

1||1246996131||92.25.91.29||do=options&dogroup=credits_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
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 13:14.

Layout Options | Width: Wide Color: