Raised This Month: $51 Target: $400
 12% 

[CS:S/CS:GO] CSS Bank (including MySQL support) v1.6.6


Post New Thread Reply   
 
Thread Tools Display Modes
Miraculix
Senior Member
Join Date: Dec 2009
Location: Germany
Old 06-13-2010 , 13:18   Re: CSS Bank (including MySQL support)
Reply With Quote #81

Thats no Problem.

Also for the "Amount Menu Amounts" you can add more options.
__________________
greeetz Miraculix ;-)
Miraculix is offline
Carn
Member
Join Date: Jun 2008
Old 06-13-2010 , 21:03   Re: CSS Bank (including MySQL support)
Reply With Quote #82

Just moved over to your plugin from the old sm_bank using mysql

thanks for sharing this plugin

Last edited by Carn; 06-13-2010 at 21:22.
Carn is offline
Carn
Member
Join Date: Jun 2008
Old 06-20-2010 , 14:27   Re: CSS Bank (including MySQL support)
Reply With Quote #83

Quote:
L 06/20/2010 - 1393: [cssbank.smx] [GamingDeluxe Bank] Query failure: Lost connection to MySQL server during query
L 06/20/2010 - 13:44:43: [cssbank.smx] [GamingDeluxe Bank] Query failure: 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 'S', 0)' at line 1
L 06/20/2010 - 14:23:28: [cssbank.smx] [GamingDeluxe Bank] Query failure: 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 'S', hide_rank = 0 WHERE steam_id = 'STEAM_0:0:******'' at line 1
L 06/20/2010 - 15:23:52: [cssbank.smx] [GamingDeluxe Bank] Query failure: 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 ''Apho'', 0)' at line 1
L 06/20/2010 - 15:47:06: [cssbank.smx] [GamingDeluxe Bank] Query failure: 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 'STEAM_0:1:******'' at line 1
L 06/20/2010 - 16:52:21: [cssbank.smx] [GamingDeluxe Bank] Query failure: 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 'nl', 0)' at line 1
L 06/20/2010 - 16:54:15: [cssbank.smx] [GamingDeluxe Bank] Query failure: 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 'nl', hide_rank = 0 WHERE steam_id = 'STEAM_0:0:******'' at line 1
L 06/20/2010 - 17:09:10: [cssbank.smx] [GamingDeluxe Bank] Query failure: Lost connection to MySQL server during query
L 06/20/2010 - 176:21: [cssbank.smx] [GamingDeluxe Bank] Query failure: 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 ''|<!$$ /\/\Y B0770/\/\', 0)' at line 1
L 06/20/2010 - 17:40:10: [cssbank.smx] [GamingDeluxe Bank] Query failure: 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 'STEAM_0:1:******'' at line 1
getting constant errors like this, ive edited out steamids btw

metamod 1.80 sourcemod 1.3.0 smbank 1.31 mysql DB

player accounts are randomly being emptied, im not sure if this is still the bug with new player acc's taking cash though..

Last edited by Carn; 06-20-2010 at 14:31.
Carn is offline
Elitist Jerk
Member
Join Date: Jun 2010
Old 06-20-2010 , 15:56   Re: CSS Bank (including MySQL support)
Reply With Quote #84

Thank you so much for this plug-in. It works great on my server.
Is there a maximum number i can enter into the css_bank_maximum ""?
Can i go into the millions? or even further?
Elitist Jerk is offline
Miraculix
Senior Member
Join Date: Dec 2009
Location: Germany
Old 06-20-2010 , 17:18   Re: CSS Bank (including MySQL support)
Reply With Quote #85

New version 1.3.2 available.
Code:
Changelog
1.3.2 (06-20-2010)
    ** Fixed: problem with quotes in player names
@ Carn: I hope it fixes most of your problems.

@ Elitist Jerk: I've not really tested the highest amount. I've set it to 1 million. But I think millions should be no problem. I rather think that billions could cause trouble.
__________________
greeetz Miraculix ;-)

Last edited by Miraculix; 06-20-2010 at 17:21.
Miraculix is offline
Elitist Jerk
Member
Join Date: Jun 2010
Old 06-20-2010 , 18:03   Re: CSS Bank (including MySQL support)
Reply With Quote #86

If you have time to answer this go for it if not thats fine. Maybe some one else can also.

in the DB, css_bank, there is an "amount" column.

What is a query i can run to get the grand total of all amounts for all players to display as one large number. I want to attempt to post on my site a "Bank Total". All combine player amounts.
Elitist Jerk is offline
Miraculix
Senior Member
Join Date: Dec 2009
Location: Germany
Old 06-20-2010 , 18:27   Re: CSS Bank (including MySQL support)
Reply With Quote #87

It should be:
Code:
SELECT SUM(`amount`) FROM `css_bank`
__________________
greeetz Miraculix ;-)
Miraculix is offline
Elitist Jerk
Member
Join Date: Jun 2010
Old 06-20-2010 , 20:34   Re: CSS Bank (including MySQL support)
Reply With Quote #88

Oh why your the best! Thanks again I really appreciate that.
Elitist Jerk is offline
Miraculix
Senior Member
Join Date: Dec 2009
Location: Germany
Old 06-21-2010 , 12:39   Re: CSS Bank (including MySQL support)
Reply With Quote #89

If it works, everything is fine.
__________________
greeetz Miraculix ;-)
Miraculix is offline
bstyle
Member
Join Date: Nov 2009
Old 06-26-2010 , 06:30   Re: CSS Bank (including MySQL support)
Reply With Quote #90

Thank you so much!

Please keep this one simple as possible...
bstyle is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 18:00.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode