Utility: Advanced Bank with nearly unlimited maximum balance

[Dolphin86]

just encase, if those loan systems added so player can make a loan, then he/she deleted their char or even account and remake a new char / account and make more loan over and over again, i really don't recommended loan system because you may get 1b zeny within 1 hour probably?

[tonelli]

in banker_2_3 Line 554  ( mes "覧覧覧覧覧覧覧覧覧・; ) gives me an "unexpected new line at string" error.. and im not 100% what its supposed to say to fix it

 

fixed. 覧 means inspect so i just replaced it with ( mes "Would you like to view more logs?"; )

Edited November 1, 2014 by tonelli

[nasagnilac]

in banker_2_3 Line 554  ( mes "覧覧覧覧覧覧覧覧覧・; ) gives me an "unexpected new line at string" error.. and im not 100% what its supposed to say to fix it

 

fixed. 覧 means inspect so i just replaced it with ( mes "Would you like to view more logs?"; )

replace this one.

mes "覧覧覧覧覧覧覧覧覧・"; )

Better fix this I found a lot of bug in this script. You can transfer to an account that's not exist. This is a good script but I have no time to modified it.

[Dori]

Hi,

I have used your advanced banker script before and it worked fine. But not any more.

With the latest rathena revision your banker script has an exploit.

When I first talked to the banker, he was saying that i already have an account. (When I didn't even create an account with him)

He also doesn't tell you the amount of zeny I have in the bank. He just says "you have a balance of Zeny in your account".

And now here's the exploit, you can withdraw any amount of zeny you want.

I hope you have a fix for this >.

[mrlongshen]

Hi,

I have used your advanced banker script before and it worked fine. But not any more.

With the latest rathena revision your banker script has an exploit.

When I first talked to the banker, he was saying that i already have an account. (When I didn't even create an account with him)

He also doesn't tell you the amount of zeny I have in the bank. He just says "you have a balance of Zeny in your account".

And now here's the exploit, you can withdraw any amount of zeny you want.

I hope you have a fix for this >.

 

Have you tried to reloadscript ?

[juanfu]

sql_query SELECT is not returning 0 in IF statement

 

example in the script

 

 if (query_sql("SELECT `balance`, `password` FROM `bank` WHERE `account_id`=" + getcharid(3), .@balance$, .@password$)) {

 

i change it to 

 

 if (query_sql("SELECT `balance`, `password` FROM `bank` WHERE `account_id`=" + getcharid(3), .@balance$, .@password$)>0) {

 

maybe query_sql is returning -1 or something like that so , you must update some "if" in the scripts

 

 

(i speak spanish, sorry for bad english)

[teknical]

Hi,

I have used your advanced banker script before and it worked fine. But not any more.

With the latest rathena revision your banker script has an exploit.

When I first talked to the banker, he was saying that i already have an account. (When I didn't even create an account with him)

He also doesn't tell you the amount of zeny I have in the bank. He just says "you have a balance of Zeny in your account".

And now here's the exploit, you can withdraw any amount of zeny you want.

I hope you have a fix for this >.

I'm getting the same exact problem.  i can withdraw with an account that has 0 zeny. 

[Brave]

There's a bug it doesn't put sql in bank table

[rakuzas]

When using this script on 2013 rathena version it works fine.. But when I updated into latest rathena.. I got Callfunction beautifynumber not found.. Then When we talk to this npc, he said we dont have account.. But we have account in previous server before updated.. Then we stuck.. Its too bad this bank cannot be used anymore.. Or anyone have idea how to fix that beutifynumber callfunction not found? Thanks..

[Sora7]

is this working on latest versions?

if not, is there any similar scripts like this for latest versions?

ty

[hardelite]

The script works on new versions of rAthena.
But for that we must make some changes.

(line 554) Change it:

mes "覧覧覧覧覧覧覧覧覧・;

for this:

mes "Would you like to view more logs?";

Add this table to your database:

Spoiler

CREATE TABLE `bank` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`account_id` INT(10) UNSIGNED NOT NULL,
	`balance` BIGINT(20) UNSIGNED NOT NULL,
	`password` VARCHAR(32) NULL DEFAULT NULL,
	`created_at` TIMESTAMP NULL DEFAULT NULL,
	`updated_at` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`),
	UNIQUE INDEX `account_id` (`account_id`)
);

And:

CREATE TABLE `banklog` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`from_account` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`to_account` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`from_character` INT(10) UNSIGNED NULL DEFAULT '0',
	`to_character` INT(10) UNSIGNED NULL DEFAULT '0',
	`amount` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`type` VARCHAR(255) NOT NULL DEFAULT '0',
	`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`)

 

PS: These tables are from another script. But it worked well for me.

(I don't remember the author)

Edited December 27, 2019 by hardelite