Add-On Releases - kBank - A Money System

kBank v2.5.2 for vBulletin 3.6.x (tested with vBulletin 3.6.8 PL 2), vBulletin 3.7.x (tested with vBulletin 3.7.4 PL 1) and vBulletin 3.8.x (tested with vBulletin 3.8.0)

[WHAT IS IT?]
kBank is a money system for your vBulletin Board with a lot of feature (listed below). With kBank, your members will try to post as much as possible (even spam) to earn points to get cool items or to be the richest man in the world You will love it!

[MAIN FEATURE]
1. Admin function:

1.1 Edit Settings (a lot of settings)
1.2 Donate members: by usergroup or username
1.3 Detail statistic updated daily, full action log (admin log & member log)
1.4 Tool to manage everything (itemtypes, item, transactions log)
1.5 Salary Center (AdminCP > kBank > kBank Salary Center): Provide tool to calculate mod activities
1.6 Easy to manage thread/post/character points

2. Member function:

2.1 Donate money
2.2 View history of transactions
2.3 Buy/Sell/Produce/Use/Gift items
2.4 Monthly Tax
2.5 Intergrated Who Visited In 24h (with Paul M's permission)
2.6 There are many top list based on different factors: Top Posts (all time), Top Posts In 1 Day, Top Posts Each Day, Top Richest, Top Richest (with Items), Top Thanked (times), Top Thanked (amount), Top Sent Thank (times),Top Sent Thank (amount), Top Thanked Post (times), Top Thanked Post (amount), Top Awarded (times), Top Awarded (amount), Top Amount of Tax. List for kBank Admin Only: Top Thanked by Area, Top Awarded by Area, Top Give Award (times), Top Give Award (amount)
2.7 Grant Permission (allow trusted-person to access your points)

3. Other:

3.1 Included 6 itemtypes: Announcement, Custom Post Display, Custom User Info, Profile Images (big avatar/signature picture), None (item with your information), Pack (many-in-1 item)
3.2 Included kBank Award/Thank system. Allow forum staff to award high quality post or take points from spam. Member can easily donate others via good post
3.3 Included kBank Hide with 1 hidden-type: Require thank
3.4 Included Help files (need to install FULL version)

[CHANGE LOG]
Version 2.5.3 (Release Date: 08-04-2009)

1. Secure Transfer Mode (AdminCP)
2. Seperate award/thank function from showpost.php (to work with vbSEO)

Version 2.5.1 (Release Date: 05-04-2009)

1. Included default itemtypes ready to use, buttons for Default Style
2. Minor Improvement

Version 2.5 (Release Date: 04-04-2009)

1. Fix Monthly Tax
2. Fix invalid auction notices
3. customized_userinfo now works in all common places
4. Easy to use customized phpfile (instead of kbank.php)
5. Tools to mass-manage thread/post/character points. Display point policy at the bottom of the page
6. Allow specify decimal place
7. Upgrade AJAX function. Allow to hide thanks from posts. Allow to add thank (display total amount only)
8. Allow searching through member items
9. New itemtype: Custom Post Display

[Add-Ons]

1. Working with vbookie (product-kbank_bookiehack.xml)
2. Raffle System 1.0 (demo: GameOn Forums): Paid work, contact for detail
3. kGame System (Football Betting & Raffle Guessing): Paid work, contact for detail
4. Card Tools (Generate serials, allow using serial to deposit money, like Mobile Card): Paid work, contact for detail
5. Ideas? Contact me to make it come true

[Sir Chase]

Well I recently installed kbank and now I have a "Database error". Error code is

<!--
Database error in vBulletin 3.8.7:

Invalid SQL:

		SELECT 
			userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
			IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid,
			language.phrasegroup_global AS phrasegroup_global,
			language.phrasegroup_adv_portal AS phrasegroup_adv_portal,
			language.phrasegroup_calendar AS phrasegroup_calendar,
			language.phrasegroup_postbit AS phrasegroup_postbit,
			language.phrasegroup_prefix AS phrasegroup_prefix,
			language.options AS lang_options,
			language.languagecode AS lang_code,
			language.charset AS lang_charset,
			language.locale AS lang_locale,
			language.imagesoverride AS lang_imagesoverride,
			language.dateoverride AS lang_dateoverride,
			language.timeoverride AS lang_timeoverride,
			language.registereddateoverride AS lang_registereddateoverride,
			language.calformat1override AS lang_calformat1override,
			language.calformat2override AS lang_calformat2override,
			language.logdateoverride AS lang_logdateoverride,
			language.decimalsep AS lang_decimalsep,
			language.thousandsep AS lang_thousandsep
			
		,kbank_granted.allow_count AS kbank_granted_count
		,kbank_granted.allow_userid AS kbank_granted_userid
		,kbank_granted.allow_username AS kbank_granted_username
		,kbank_granted.allow_usergroupid AS kbank_granted_usergroupid
		,kbank_granted.allow_membergroupids AS kbank_granted_membergroupids
		,kbank_granted.allow_money AS kbank_granted_money
	
		FROM user AS user
		LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
		LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
		
		LEFT JOIN (
			SELECT
				kbank_granted.userid AS userid
				,COUNT(*) AS allow_count
				,GROUP_CONCAT(user.userid SEPARATOR '|') AS allow_userid
				,GROUP_CONCAT(user.username SEPARATOR '|') AS allow_username
				,GROUP_CONCAT(user.usergroupid SEPARATOR '|') AS allow_usergroupid
				,GROUP_CONCAT(user.membergroupids SEPARATOR '|') AS allow_membergroupids
				,GROUP_CONCAT(user.money SEPARATOR '|') AS allow_money
			FROM `kbank_granted_permission` AS kbank_granted
			INNER JOIN `user` AS user ON (user.userid = kbank_granted.allowid)
			WHERE kbank_granted.userid = 5
			GROUP BY kbank_granted.userid
		) AS kbank_granted ON (kbank_granted.userid = user.userid)
	
		WHERE user.userid = 5;

MySQL Error   : Table '--_forum.kbank_granted_permission' doesn't exist
Error Number  : 1146
Request Date  : Thursday, August 2nd 2012 @ 02:27:46 PM
Error Date    : Thursday, August 2nd 2012 @ 02:27:46 PM
Script        : http://runeadventure.com/index.php
Referrer      : 
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 
-->

Any idea on how to fix this would be great.

[TravisWPaquin]

I found a typo → Here

[thock321]

I keep getting database errors?

[natsu287]

Does this still work or no?

[YoricksRequiem]

Seems as if the install script is broken. It does not create any of the tables required.

Edit: I fixed this. Search and replace all instances of Type=MyISAM in the product xml file. It will install fine then.