[Miraculix]

Update to v1.6.6

Changelog:

1.6.6 (2014-05-03)
    ** Fixed: Second pistolround(s) not working, with mp_halftime associated with mp_timelimit instead of mp_maxrounds.
    ** Fixed: Bug in check for old data. Whereby defaults like css_bank_default_bankmoney won't work.

[8guawong]

How do you backup the db??

[Miraculix]

On default settings:
Save the clientprefs-sqlite.sq3 file from the addons/sourcemod/data/sqlite folder.

[rautamiekka]

Originally Posted by Miraculix Update to v1.6.6 Changelog: 1.6.6 (2014-05-03) ** Fixed: Second pistolround(s) not working, with mp_halftime associated with mp_timelimit instead of mp_maxrounds. ** Fixed: Bug in check for old data. Whereby defaults like css_bank_default_bankmoney won't work.

Excellent, excellent ! Glad to see the plugin isn't totally dead, and you fixed 2 rather annoying bugs, as that text implies. Good work.

[rautamiekka]

I looked shit up for you, Miraculix:

SQLite supports SIGNED BIGINT as the largest integer, which means -9223372036854775808 <-> 9223372036854775807, that is -2**63 <-> 2**63-1. This is the limit regardless of database engine ...

However, MySQL supports, in addition to the SIGNED BIGINT, UNSIGNED BIGINT, which is 0 <-> 18446744073709551615, meaning 2**64-1. In either case, SIGNED or UNSIGNED, reaching that number by normal gaming means doesn't happen fast, but it's far better than the 2+ billion limit imposed by 32-bit integer. Not to mention spending all that money ...

There's still hope, though, although it's 32-bit: http://stackoverflow.com/questions/9...-integers-in-c

I'm sure you're better C++ coder than I am, so you should be able to figure this out. That link is for C++ on Linux, but it shouldn't be any different.

[rautamiekka]

I see that Bank strips the 'STEAM_#:' from the Steam ID. Is that done for compatibility so that don't have to store IDs which have changed for different games ? Meaning, Steam ID is the same for CS:GO from the other games, but the first number is 1 instead of 0.

[raiden_it]

I have a problem. After one player has rich the limit 2147483647 his account has zeroing.
I have v1.6.5 (2014-04-21) plugin version.
Can you help me?

[helpme_please]

i think i find bug cheat.
some player can cheat money
sometime can spam money $50000 all round. i don't know maybe they deposit money and suicide!
or deposit money to bank and disconnect. join again to get $10000 if mp_startmoney $10000

[red4911]

L 05/14/2015 - 16:43:12: SourceMod error session started L 05/14/2015 - 16:43:12: Info (map "de_dust2") (file "errors_20150514.log") L 05/14/2015 - 16:43:12: [cssbank.smx] [Bank] Query failure: Lost connection to MySQL server during query L 05/14/2015 - 16:43:12: [cssbank.smx] [Bank] Query: UPDATE css_bank SET amount = 0, auto_deposit = 6000, auto_withdraw = 10000, plugin_message = 1, player_name = 'AgaSiQz', hide_rank = 0, last_accountuse = 1431610992 WHERE id = 1951; L 05/14/2015 - 16:54:11: Error log file session closed. L 05/14/2015 - 18:03:43: SourceMod error session started L 05/14/2015 - 18:03:43: Info (map "de_dust2") (file "errors_20150514.log") L 05/14/2015 - 18:03:43: [cssbank.smx] [Bank] Query failed! Lost connection to MySQL server during query L 05/14/2015 - 18:03:43: [SM] Native "SQL_FetchRow" reported: Invalid query Handle 0 (error: 4) L 05/14/2015 - 18:03:43: [SM] Displaying call stack trace for plugin "cssbank.smx": L 05/14/2015 - 18:03:43: [SM] [0] Line 142, cssbank/database.sp::T_NewClientConnected() L 05/14/2015 - 186:25: Error log file session closed. L 05/14/2015 - 186:42: SourceMod error session started L 05/14/2015 - 186:42: Info (map "de_dust2") (file "errors_20150514.log") L 05/14/2015 - 186:42: [cssbank.smx] [Bank] Query failed! Lost connection to MySQL server during query L 05/14/2015 - 186:42: [SM] Native "SQL_FetchRow" reported: Invalid query Handle 0 (error: 4) L 05/14/2015 - 186:42: [SM] Displaying call stack trace for plugin "cssbank.smx": L 05/14/2015 - 186:42: [SM] [0] Line 142, cssbank/database.sp::T_NewClientConnected() L 05/14/2015 - 19:14:20: Error log file session closed.

[pr3d4t0r]

I would like to use this with mysql, I configure the databases.cfg, the connection is up, tables are created, but the balances are reset after the mapchange and log files was flooded by these type of errors, like this:

L 03/15/2016 - 21:59:49: [cssbank.smx] [OUR BANK] Query failure: Field 'amount' doesn't have a default value
L 03/15/2016 - 21:59:49: [cssbank.smx] [OUR BANK] Query: INSERT INTO css_bank(steam_id, plugin_message, player_name, hide_rank) VALUES('0:109467077', 1, 'Tranduil', 0);

I see the problem is that the field doesn't have the default value, but how can I fix it to work? I need for mysql, because of I running more servers, and would like to use a shared bank.

Thanks!