[Nican]

Bank mod: SQL

Original Author:
mateo10
Edit because
Request to add MySQL support

Description
Users can deposit/withdraw money money from a bank account at any time

Commands

• say !deposit (amount) - Deposit money into your bank
• say !withdraw (amount) - Get money from your bank
• say !bankstatus - Shows how much money you have in your bank
• say !bank - Shows a friendly menu
• sm_bankadd / sm_bankset (search person) (amount)

Cvars

• sm_bank_allow (default: 1) - Enable/Disable this plugin
• sm_bank_max (default: 50000) - The maximun amount of money is allowed in the bank
• sm_bank_fee (default: 250) - How much users must pay for each deposit
• sm_bank_transfer (default: 1) - Allow users to share money between them selfs
• sm_bank_interest (default: 5.0) - % of interest players will get per round
• sm_bank_pistol (default: 0) -Set to 1 to block withdraw during pistol round

Special thanks to:

• sessus - For the German translation.

Change log

• August 26, 2007
  • Initial release
• August 27, 2007
  • Fixed fee error
  • Fixed money setting if player reached limit
• August 29, 2007
  • Fixed small error
• September 04, 2007
  • Added menu
  • Added bank money transferring
  • Added money with commas
• September 06, 2007
  • Fixed money error... Displayed wrong number when depositing
• October 25, 2007
  • Fixed error that people could not transfer money
  • Set maxmoney to 0 for unlimited money
  • Add commands sm_setmoney / sm_addmoney to players
• October 27, 2007
  • Fixed transfer error of max clients not registering
• November 4, 2007
  • Fixed possible change of client disconnecting while transferring money
  • Fixed some memory leaks
  • Fixed error of clients getting more money then they could on interest
• November 24, 2007
  • Added cvar to block usage of withdraw during pistol round
• March 22, 2007
  • Made menu show money values relative to how much money the player has.

[tkaway69]

Very nice. Will you be adding the ability to transfer funds between players?

[kipplitz]

ok, help a new guy out. To use this, you need the database manager. I assume you need to have an install of mysql as well? Can you do this on a hosted server? Any light on this mucho appreciated!

Thanks,

KippLitz

[Nican]

I am trying to make the database manager support SQLite too... but SQLite is just not complete enough to use database manager...

When I make database manager support SQLite I will PM you


EDIT:

Woohoo! I found what I needed, now I need to make it compatiable

[Nican]

There... I added SQLite support to Database manager

[Rainbow 6]

does not want to compile

[Nican]

Do you have the database manager?
http://forums.alliedmods.net/showthread.php?t=60036

[Rainbow 6]

yes i do but what good is it if i can not even get the plugin downloaded so i can get it to my game server

[Nican]

Here is the deal, this plugin runs over the database manager, WITH IT NEEDS TO BE DOWNLOADED

http://forums.alliedmods.net/showthread.php?t=60036

Install a_mysql.sp and I will add a compiled version to this post

[bobbobagan]

Are bank balances saved?