The Arcive of Official vBulletin Modifications Site.

kBank 2.1 - Money System · **Released**: 07-13-2008

kBank v2.1 for vBulletin 3.6.x (tested with vBulletin 3.6.8 Patch Level 2) and vBulletin 3.7.x (tested with vBulletin 3.7.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

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 5 itemtypes: Announcement, 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.1 (Release Date: 18-08-2008)

1. Item: Add Never Expires option, group similar items in kShop
2. Itemtype: Add edit time limitation (member can edit username/usertitle once or twice,etc... Confirmation required) for Customized Userinfo itemtype. Add new itemtype with "open" information
3. Admin Tool: Admin can select exactly which element is shown in post and profile. Add 1-time register points. Add option to count thanks as posts (still work well when update posts count). Add Salary Center
4. Add product uninstall codes
5. Create addon to work with vbookie

Version 2.0.1 (Release Date: 27-07-2008)

1. Fix mysql queries (cause database error)
2. Fix thank issue (delay update of thank times/amount)
3. Improve kBank Hide (working with extremely long hide content)

Cause of file size limitation, you can download FULL version (with help) here: http://www.mediafire.com/?sharekey=2...77ec469acb75af

[KNOWN ISSUES]

After installing if you can not see kBank Salary Center under kBank menu, please download file "cpnav_kbank.xml" (attached) and upload overwrite into ./includes/xml
Please download customize_userinfo.kbank.php (attached below) and upload overwrite into ./kbank/itemtypes to fix HTML username/usertitle issue
Fatal error when Update award/thank: https://vborg.vbsupport.ru/showpost.php?p=1637542

Marco van Herwaarden · #62 07-30-2008, 07:52 AM

Quote:

Originally Posted by parseforum

Hello

After install this hack and upload files and edit Templates when I`m going to my forum give this error and I can`t Restore my backup

Please help me

Seems you have not uploaded all the files for this modification. Check if you have uploaded all files and to the correct directory.

Marco van Herwaarden · #63 07-30-2008, 07:53 AM

Quote:

Originally Posted by RedeemedWarrior

i used a Testvb

and it trashed it also

database is ruined

thankfully it wasn't my live board

How do you think the coder, or anyone else, can help troubleshooting your issues without more information then you posted.

At least post what/how it ruined your database. If you get database errors, post the full error.

parseforum · #64 07-30-2008, 07:57 AM

Quote:

Originally Posted by Marco van Herwaarden

Seems you have not uploaded all the files for this modification. Check if you have uploaded all files and to the correct directory.

I uploaded all files again but I have that error

Marco van Herwaarden · #65 07-30-2008, 08:37 AM

I doubt that, a the error message indicates missing files.

RedeemedWarrior · #66 07-30-2008, 09:00 AM

Quote:

Originally Posted by Marco van Herwaarden

How do you think the coder, or anyone else, can help troubleshooting your issues without more information then you posted.

At least post what/how it ruined your database. If you get database errors, post the full error.

simply default Vb Database Error

I reverted shortly after to a fresh install, so more info i can't supply

As how it ruined, nothing was usable after the install, the Admincp was a useless, couldn't even access disable plugins

it began after I set my usergroup (admin) to KBank admin it froze up as soon as settings saved

i'll try again on my Testvb re install, i have a few idea's as to what may have triggered it

Edit : After following all install script/instructions nothing is functional

I'm uninstalling and moving on

had alot of promise

mrpaint · #67 07-30-2008, 10:51 AM

@parseforum: Have you uploaded all files/folders inside folder "upload"? If you only download kBank 2.0 Upgrade 2.0.1.zip, you have to download kBank 2.0.1 Installation.zip and re-upload to your forum root! kBank 2.0 Upgrade 2.0.1.zip is used for upgrading only!

@RedeemedWarrior: God bless you! But what is your error messages? If full error is not display, just view page source and you will see MySQL error messages (it has been hidden, just a trick)

PS: You have to set userid instead of usergroupid for kBank Admin. For more information about installing kBank, visit this page (english, no registration require): http://hskl.net/f/kbank.php?do=help&page=install

parseforum · #68 07-30-2008, 11:36 AM

Quote:

@parseforum: Have you uploaded all files/folders inside folder "upload"? If you only download kBank 2.0 Upgrade 2.0.1.zip, you have to download kBank 2.0.1 Installation.zip and re-upload to your forum root! kBank 2.0 Upgrade 2.0.1.zip is used for upgrading only!

I uploaded all files but I have the problem

mrpaint · #69 07-30-2008, 12:01 PM

Quote:

Originally Posted by parseforum

I uploaded all files but I have the problem

Can you screenshot your files/folder tree in you server?

parseforum · #70 07-30-2008, 12:57 PM

I deleted the files and upload them again now I have this error:

Code:

Database error in vBulletin 3.7.2:

Invalid SQL:

		SELECT 
			userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
			
		,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_چوب AS kbank_granted_چوب
	
		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 (
			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.چوب SEPARATOR '|') AS allow_چوب
			FROM `kbank_granted_permission` AS kbank_granted
			INNER JOIN `user` 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   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '�وب AS kbank_granted_چوب
	
		FROM user AS user
		LEFT JOIN userfield AS us' at line 10
Error Number  : 1064
Request Date  : Wednesday, July 30th 2008 @ 09:52:41 AM
Error Date    : Wednesday, July 30th 2008 @ 09:52:41 AM
Script        : http://67.205.67.58/~parsefc/forum/login.php?do=login
Referrer      : http://67.205.67.58/~parsefc/forum/admincp/
IP Address    : 85.185.30.103
Username      : Arash
Classname     : vB_Database
MySQL Version : 5.0.51a-community

mrpaint · #71 07-30-2008, 01:19 PM

Quote:

Originally Posted by parseforum

I deleted the files and upload them again now I have this error:

Code:

Database error in vBulletin 3.7.2:

Invalid SQL:

        SELECT 
            userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
            IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
            
        ,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_چوب AS kbank_granted_چوب
    
        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 (
            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.چوب SEPARATOR '|') AS allow_چوب
            FROM `kbank_granted_permission` AS kbank_granted
            INNER JOIN `user` 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   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '�وب AS kbank_granted_چوب
    
        FROM user AS user
        LEFT JOIN userfield AS us' at line 10
Error Number  : 1064
Request Date  : Wednesday, July 30th 2008 @ 09:52:41 AM
Error Date    : Wednesday, July 30th 2008 @ 09:52:41 AM
Script        : http://67.205.67.58/~parsefc/forum/login.php?do=login
Referrer      : http://67.205.67.58/~parsefc/forum/admincp/
IP Address    : 85.185.30.103
Username      : Arash
Classname     : vB_Database
MySQL Version : 5.0.51a-community

You have specified wrong field name for money row (please use "money", default value, if you don't really understand this setting)

As I tested, you can't edit setting because you can't login. You should create new file named "hook_fetch_userinfo_query.php", content:

PHP Code:


			
<?php
?>

Replace it with the old one inside ./kbank (don't forget to backup)
Go to AdminCP and edit settings
Restore the original "hook_fetch_userinfo_query.php"

Everything should be okie! Gud luck

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05101 seconds Memory Usage 2,333KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (1)bbcode_php (7)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!