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

[mrpaint]

Originally Posted by algert

Sorry if I'd be annoying, lol.. anyway, I've found another I'd called it a bug to me.. if I award someone the award info will be extra large, I mean can it be shown like the thanks in one line, like this screenshot:-


Thanks in advance, once again.

Award can be display just like thank by editing the phrase (please search phrase in AdminCP). It's not a bug, I just want to display awards different from thanks

[algert]

Originally Posted by mrpaint

Award can be display just like thank by editing the phrase (please search phrase in AdminCP). It's not a bug, I just want to display awards different from thanks

Oh my apologies for naming it a bug, can you tell me which phrase to edit for awards, and the code for it to be replaced, sorry.. once again.. :S

Edited:- I think I will try to manage it out, I have fixed the award words. Sorry to bother anyway.

[mrpaint]

Edit phrase: kbank_award_the_message_with_username
You can use something like

{4} awarded {1} For <b>{2}</b> {5}: {3}

{1} is the username of the poster
{2} is the amount
{3} is the reason
{4} is the username of the staff
{5} is money name

[jeremycards]

HELP! i just installed this addon. Everything was uploaded then i imported. i started checking out the options and when i clicked save changes, my forum gave a great database error and it started flooding my email with errors!! i dont know what to do, i tryed deleting the files from the database but it gets worse errors, help please! This is what the mails say and they wont stop coming

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_holiday AS phrasegroup_holiday,
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_Oro AS kbank_granted_Oro

FROM endsekuser AS user
LEFT JOIN endsekuserfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN endsekusertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN endseklanguage AS language ON (language.languageid = IF(user.languageid = 0, 2, 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.Oro SEPARATOR '|') AS allow_Oro
FROM `endsekkbank_granted_permission` AS kbank_granted
INNER JOIN `endsekuser` AS user ON (user.userid = kbank_granted.allowid)
WHERE kbank_granted.userid = 1
GROUP BY kbank_granted.userid
) AS kbank_granted ON (kbank_granted.userid = user.userid)

WHERE user.userid = 1;

MySQL Error : Unknown column 'user.Oro' in 'field list'
Error Number : 1054
Request Date : Sunday, May 10th 2009 @ 05:25:23 AM
Error Date : Sunday, May 10th 2009 @ 05:25:23 AM
Script : http://forum.endingsekai.com/index.php
Referrer :
IP Address : 190.17.181.228
Username :
Classname : vB_Database
MySQL Version :

[mrpaint]

Hi there,

Don't worry too much. With that error message, I can see that you changed the kBank field to "Oro". I think you made mistake in this step. I think you want to change the name to "Oro" (means "gold" in Spanish, right?) instead of the field.

Now you can fix by 3 steps:

1. Turn off all hooks
2. Go to kBank Settings page, change "Oro" back to "money" in "Money field" and change value of "Name of points" to "Oro"
3. Turn hooks back on

If you don't know how to turn off hooks, take a look at this page: http://www.vbulletin.com/forum/showthread.php?t=196688 (I have just Googled it )

Good luck to you

[jeremycards]

i see, i tough it might have been that the problem (oro is gold in spanish actually =P) i'll give it a try and tell you, thanks for your help

[Xile1508]

Does this allow members to buy items, ( A member can use his/her points to be granted access to download a specific file. )

Eg. A Graphics Design Site, Using this could allow there members to spend their points to download a certain Brush Pack etc.

[jeremycards]

worked like a charm, thanks a lot!

edit: Oh by the way, is there a way to make this available only in one subforum?

edit 2: scratch that, i already found out. But now i have a problem. People can buy stuff from the shop even without having the necesary money for it :S what could be happening?

[Abderian]

Is there something obvious I am missing? When my users buy custom avatars they do not show up... Their profiles are set to view avatars and the gallery works, and their avatar shows in the admin cp but not in posts.

[mrpaint]

Originally Posted by Xile1508

Does this allow members to buy items, ( A member can use his/her points to be granted access to download a specific file. )

Eg. A Graphics Design Site, Using this could allow there members to spend their points to download a certain Brush Pack etc.

You will need a Downloading Plugin and kBank will be used as a Money Gateway (with some modification) to require point when downloading. I'm thinking about require money when downloading attachments, too. Maybe it will be available in the future
With kBank, now, you can purchase items with special function like changing username, usertitle, display background in posts, etc

Originally Posted by jeremycards

worked like a charm, thanks a lot!

edit: Oh by the way, is there a way to make this available only in one subforum?

You can specify points policy for each forum (Forum Manager)