SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Filterscripts

Reply
 
Thread Tools Display Modes
Old 25/08/2016, 09:42 PM   #41
rootcause
Big Clucker
 
rootcause's Avatar
 
Join Date: Feb 2015
Location: /
Posts: 114
Reputation: 197
Default Re: Yet Another Banking System

Quote:
Originally Posted by Tass007 View Post
I love you @RootCause. No homo
love you too, friend (no homo ofc)
__________________
All Releases | YouTube
rootcause is offline   Reply With Quote
Old 25/08/2016, 11:52 PM   #42
Kwarde
High-roller
 
Kwarde's Avatar
 
Join Date: Nov 2009
Location: The Netherlands
Posts: 2,528
Reputation: 1642
Default Re: Yet Another Banking System

I came here just to check it out. And it's a lot better than I expected. If the gamemode I'm developing would be in this time instead of the past, I would for sure use it.
Oh and thanks for the new SA:MP GUI. Didn't ever think of changing it but now that I'm seeing it, it's really nice.

By the way, why using MySQL? You'd better use SQLite.
Kwarde is offline   Reply With Quote
Old 26/08/2016, 02:47 AM   #43
qweqwe123465
Little Clucker
 
Join Date: Nov 2015
Posts: 2
Reputation: 0
Default Re: Yet Another Banking System

Quote:
Originally Posted by rootcause View Post
love you too, friend (no homo ofc)
i need you include packs most of include need of you fs been remove
qweqwe123465 is offline   Reply With Quote
Old 26/08/2016, 04:27 AM   #44
Tass007
Gangsta
 
Tass007's Avatar
 
Join Date: May 2011
Location: Somewhere not near you
Posts: 735
Reputation: 31
Default Re: Yet Another Banking System

Quote:
Originally Posted by qweqwe123465 View Post
i need you include packs most of include need of you fs been remove
All links are provided in the original post. But this will help you.
WeaponData include
Mysql include
Streamer include
I-ZCMD include
YSI include
sscanf include
__________________
Copyright © 2016 vR Studios
Currently working with vR Studios
Copying and pasting doesn't allow you to learn the things that reading and understanding will.
Tass007 is offline   Reply With Quote
Old 03/09/2016, 12:19 PM   #45
rootcause
Big Clucker
 
rootcause's Avatar
 
Join Date: Feb 2015
Location: /
Posts: 114
Reputation: 197
Default Re: Yet Another Banking System

Quote:
Originally Posted by Kwarde View Post
I came here just to check it out. And it's a lot better than I expected. If the gamemode I'm developing would be in this time instead of the past, I would for sure use it.
Oh and thanks for the new SA:MP GUI. Didn't ever think of changing it but now that I'm seeing it, it's really nice.

By the way, why using MySQL? You'd better use SQLite.
Thanks!

Well, since it's about banking I went with MySQL because people may add some features to their UCP like transferring money or checking your account history.
__________________
All Releases | YouTube
rootcause is offline   Reply With Quote
Old 03/09/2016, 06:18 PM   #46
zsoolt997
Little Clucker
 
zsoolt997's Avatar
 
Join Date: Aug 2015
Location: Hungary
Posts: 22
Reputation: 3
Default Re: Yet Another Banking System

Code:
format(string, sizeof(string), "BANK: {FFFFFF}Account removed, you got the {2ECC71}%s {FFFFFF19324}left in the account.", formatInt(amount));
Code:
format(string, sizeof(string), "BANK: {FFFFFF}Account removed, you got the {2ECC71}%s {FFFFFF}left in the account.", formatInt(amount));
Random numbers in the color code

Anyway I like your stuffs, so KEEP IT UP!
zsoolt997 is offline   Reply With Quote
Old 06/09/2016, 07:36 AM   #47
rootcause
Big Clucker
 
rootcause's Avatar
 
Join Date: Feb 2015
Location: /
Posts: 114
Reputation: 197
Default Re: Yet Another Banking System

Bug Fixes:

- Fixed an invalid color on account removal message. (Thanks zsoolt997 for reporting it!)
- Fixed an issue with removing bankers & atms. (forgot Iter_Remove, oops)

R40 Version:

Since MySQL plugin got updated to R40, I made a MySQL R40 version too. I didn't had that much time to test out everything but didn't notice any major issues. This version also has robbable ATM toggling, you can uncomment or comment #define ROBBABLE_ATMS to enable/disable robbable ATMs.

As always you can get the new versions from the first post.
__________________
All Releases | YouTube
rootcause is offline   Reply With Quote
Old 06/09/2016, 08:18 AM   #48
markparker12
Big Clucker
 
markparker12's Avatar
 
Join Date: Sep 2015
Posts: 135
Reputation: 25
Default Re: Yet Another Banking System

Oh my God! Your works are always great!
__________________
Free/Paid Game Server Hosting/Web Hosting/SA-Mp HostedTab
Hiring mature, active loyal and skilled players!



My Works
markparker12 is offline   Reply With Quote
Old 23/09/2016, 07:59 AM   #49
Admireal
Big Clucker
 
Join Date: Sep 2016
Posts: 111
Reputation: 5
Default Re: Yet Another Banking System

there is account create problem

Fix it pls rootcause!!!

Quote:
[10:55:27] [DEBUG] mysql_format(1, 0x02AEB8F0, 144, "SELECT null FROM bank_accounts WHERE Owner='%e' && Disabled=0")
[10:55:27] [DEBUG] CHandle::EscapeString(this=0x5607f8, src='[][][AGENT]')
[10:55:27] [DEBUG] CConnection::EscapeString(src='[][][AGENT]', this=0x556e78, connection=0x27d2f1
[10:55:27] [DEBUG] CHandle::EscapeString - return value: true, escaped string: '[][][AGENT]'
[10:55:27] [DEBUG] mysql_format: return value: '70'
[10:55:27] [DEBUG] mysql_query(1, "SELECT null FROM bank_accounts WHERE Owner='[][][AGENT]' && Disabled=0", 1)
[10:55:27] [DEBUG] CHandle::Execute(this=0x5607f8, type=3, query=0x55ffd0)
[10:55:27] [DEBUG] CConnection::Execute(query=0x55ffd0, this=0x556e78, connection=0x27d2f1
[10:55:27] [DEBUG] CQuery::Execute(this=0x55ffd0, connection=0x27d2f1
[10:55:27] [DEBUG] CResultSet::Create(connection=0x27d2f18, query_str='SELECT null FROM bank_accounts WHERE Owner='[][][AGENT]' && Disabled=0')
[10:55:27] [DEBUG] created new resultset '0x5a11f8'
[10:55:27] [DEBUG] fetched MySQL result '0x37ffa80'
[10:55:27] [DEBUG] allocated 0 bytes for PAWN result
[10:55:27] [DEBUG] CHandle::Execute - return value: true
[10:55:27] [DEBUG] mysql_query: return value: '5'
[10:55:27] [DEBUG] cache_get_row_count(0x02AEB8D
[10:55:27] [DEBUG] cache_get_row_count: return value: '1'
[10:55:27] [DEBUG] cache_delete(5)
[10:55:27] [DEBUG] cache_delete: return value: '1'
[10:55:27] [DEBUG] mysql_format(1, 0x02AEBD24, 144, "SELECT null FROM bank_accounts WHERE Owner='%e' && Disabled=0")
[10:55:27] [DEBUG] CHandle::EscapeString(this=0x5607f8, src='[][][AGENT]')
[10:55:27] [DEBUG] CConnection::EscapeString(src='[][][AGENT]', this=0x556e78, connection=0x27d2f1
[10:55:27] [DEBUG] CHandle::EscapeString - return value: true, escaped string: '[][][AGENT]'
[10:55:27] [DEBUG] mysql_format: return value: '70'
[10:55:27] [DEBUG] mysql_query(1, "SELECT null FROM bank_accounts WHERE Owner='[][][AGENT]' && Disabled=0", 1)
[10:55:27] [DEBUG] CHandle::Execute(this=0x5607f8, type=3, query=0x55ffd0)
[10:55:27] [DEBUG] CConnection::Execute(query=0x55ffd0, this=0x556e78, connection=0x27d2f1
[10:55:27] [DEBUG] CQuery::Execute(this=0x55ffd0, connection=0x27d2f1
[10:55:27] [DEBUG] CResultSet::Create(connection=0x27d2f18, query_str='SELECT null FROM bank_accounts WHERE Owner='[][][AGENT]' && Disabled=0')
[10:55:27] [DEBUG] created new resultset '0x5a1658'
[10:55:27] [DEBUG] fetched MySQL result '0x37ffa80'
[10:55:27] [DEBUG] allocated 0 bytes for PAWN result
[10:55:27] [DEBUG] CHandle::Execute - return value: true
[10:55:27] [DEBUG] mysql_query: return value: '5'
[10:55:27] [DEBUG] cache_get_row_count(0x02AEBD0C)
[10:55:27] [DEBUG] cache_get_row_count: return value: '1'
[10:55:27] [DEBUG] cache_delete(5)
[10:55:27] [DEBUG] cache_delete: return value: '1'
[10:55:28] [DEBUG] mysql_format(1, 0x02AEBD24, 144, "SELECT null FROM bank_accounts WHERE Owner='%e' && Disabled=0")
[10:55:28] [DEBUG] CHandle::EscapeString(this=0x5607f8, src='[][][AGENT]')
[10:55:28] [DEBUG] CConnection::EscapeString(src='[][][AGENT]', this=0x556e78, connection=0x27d2f1
[10:55:28] [DEBUG] CHandle::EscapeString - return value: true, escaped string: '[][][AGENT]'
[10:55:28] [DEBUG] mysql_format: return value: '70'
[10:55:28] [DEBUG] mysql_query(1, "SELECT null FROM bank_accounts WHERE Owner='[][][AGENT]' && Disabled=0", 1)
[10:55:28] [DEBUG] CHandle::Execute(this=0x5607f8, type=3, query=0x55ffd0)
[10:55:28] [DEBUG] CConnection::Execute(query=0x55ffd0, this=0x556e78, connection=0x27d2f1
[10:55:28] [DEBUG] CQuery::Execute(this=0x55ffd0, connection=0x27d2f1
[10:55:28] [DEBUG] CResultSet::Create(connection=0x27d2f18, query_str='SELECT null FROM bank_accounts WHERE Owner='[][][AGENT]' && Disabled=0')
[10:55:28] [DEBUG] created new resultset '0x5a1000'
[10:55:28] [DEBUG] fetched MySQL result '0x37ffa80'
[10:55:28] [DEBUG] allocated 0 bytes for PAWN result
[10:55:28] [DEBUG] CHandle::Execute - return value: true
[10:55:28] [DEBUG] mysql_query: return value: '5'
[10:55:28] [DEBUG] cache_get_row_count(0x02AEBD0C)
[10:55:28] [DEBUG] cache_get_row_count: return value: '1'
[10:55:28] [DEBUG] cache_delete(5)
[10:55:28] [DEBUG] cache_delete: return value: '1'
[10:55:28] [DEBUG] mysql_format(1, 0x02AEBD34, 144, "INSERT INTO bank_accounts SET Owner='%e', Password=md5('%e'), CreatedOn=UNIX_TIMESTAMP()")
[10:55:28] [DEBUG] CHandle::EscapeString(this=0x5607f8, src='[][][AGENT]')
[10:55:28] [DEBUG] CConnection::EscapeString(src='[][][AGENT]', this=0x556e78, connection=0x27d2f1
[10:55:28] [DEBUG] CHandle::EscapeString - return value: true, escaped string: '[][][AGENT]'
[10:55:28] [DEBUG] CHandle::EscapeString(this=0x5607f8, src='jhkh')
[10:55:28] [DEBUG] CConnection::EscapeString(src='jhkh', this=0x556e78, connection=0x27d2f1
[10:55:28] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'jhkh'
[10:55:28] [DEBUG] mysql_format: return value: '99'
[10:55:28] [DEBUG] mysql_tquery(1, "INSERT INTO bank_accounts SET Owner='[][][AGENT]', Password=md5('jhkh'), CreatedOn=UNIX_TIMESTAMP()", "OnBankAccountCreated", "is")
[10:55:28] [DEBUG] CCallback::Create(amx=0x2909748, name='OnBankAccountCreated', format='is', params=0x2aebd18, param_offset=5)
[10:55:28] [DEBUG] CCallback::Create - callback index for 'OnBankAccountCreated': 32
[10:55:28] [DEBUG] processing specifier 'i' with parameter index 0
[10:55:28] [DEBUG] retrieved and pushed value '0'
[10:55:28] [DEBUG] processing specifier 's' with parameter index 1
[10:55:28] [DEBUG] retrieved and pushed value 'jhkh'
[10:55:28] [DEBUG] created delayed callback with 2 parameters
[10:55:28] [DEBUG] CHandle::Execute(this=0x5607f8, type=1, query=0x5928f0)
[10:55:28] [DEBUG] CHandle::Execute - return value: true
[10:55:28] [DEBUG] mysql_tquery: return value: '1'
[10:55:28] [DEBUG] CConnection::Execute(query=0x5928f0, this=0x38de020, connection=0x27de4e0)
[10:55:28] [DEBUG] CQuery::Execute(this=0x5928f0, connection=0x27de4e0)
[10:55:28] [ERROR] ČnZ
[10:55:28] [DEBUG] CConnection::GetError(this=0x38de020, connection=0x27de4e0)
[10:55:28] [DEBUG] CCallback::Create(amx=0x2909748, name='OnQueryError', format='dsssd)
[10:55:28] [DEBUG] CCallback::Create - callback index for 'OnQueryError': 76
[10:55:28] [DEBUG] processing specifier 'd'
[10:55:28] [DEBUG] retrieved and pushed value '1364'
[10:55:28] [DEBUG] processing specifier 's'
[10:55:28] [DEBUG] retrieved and pushed value 'Field 'Balance' doesn't have a default value'
[10:55:28] [DEBUG] processing specifier 's'
[10:55:28] [DEBUG] retrieved and pushed value 'OnBankAccountCreated'
[10:55:28] [DEBUG] processing specifier 's'
[10:55:28] [DEBUG] retrieved and pushed value 'INSERT INTO bank_accounts SET Owner='[][][AGENT]', Password=md5('jhkh'), CreatedOn=UNIX_TIMESTAMP()'
[10:55:28] [DEBUG] processing specifier 'd'
[10:55:28] [DEBUG] retrieved and pushed value '1'
[10:55:28] [DEBUG] created delayed callback with 5 parameters
[10:55:28] [DEBUG] CCallback::Execute(amx=0x2909748, index=76, num_params=5)
[10:55:28] [DEBUG] processing internal specifier 'c'
[10:55:28] [DEBUG] pushed value '1' onto AMX stack
[10:55:28] [DEBUG] processing internal specifier 's'
[10:55:28] [DEBUG] pushed value 'INSERT INTO bank_accounts SET Owner='[][][AGENT]', Password=md5('jhkh'), CreatedOn=UNIX_TIMESTAMP()' onto AMX stack
[10:55:28] [DEBUG] processing internal specifier 's'
[10:55:28] [DEBUG] pushed value 'OnBankAccountCreated' onto AMX stack
[10:55:28] [DEBUG] processing internal specifier 's'
[10:55:28] [DEBUG] pushed value 'Field 'Balance' doesn't have a default value' onto AMX stack
[10:55:28] [DEBUG] processing internal specifier 'c'
[10:55:28] [DEBUG] pushed value '1364' onto AMX stack
[10:55:28] [DEBUG] executing AMX callback with index '76'
[10:55:28] [DEBUG] AMX callback executed with error '0'
Admireal is offline   Reply With Quote
Reply

Thread Tools
Display Modes

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Banking system with MYSQL MrViolence101 Scripting Help 2 14/12/2014 11:02 PM
[FilterScript] Banking System V1.0 Zh3r0 Filterscripts 115 10/10/2014 04:17 PM
Could Someone please make a Banking system ! XxJoexX Help Archive 4 09/03/2010 04:37 PM
Banking system cruising Help Archive 1 21/02/2010 02:21 PM


All times are GMT. The time now is 07:11 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.