PDA

View Full Version : Bank Addon for Lesane store hack


Blue2000
06-07-2002, 10:00 PM
This was requested on my site. and also lots of times here.

The problem was that they was a bank hack out but not one that works with the store hack.

So i have reconfiged the root, mem and jessie ( https://vborg.vbsupport.ru/showthread.php?s=&threadid=38118 ) bank hack to work with Lesane's Store hack (https://vborg.vbsupport.ru/showthread.php?s=&threadid=36991&highlight=bank )

I hope that they dont mind but i think it will be used more now anyway due the the fact that in lesanes store they is a way to make money.

Big thanks out goes to the above people for making the 2 hacks

I cant help but keep adding things to this hack Lesane great job you did with it ;)

Another good point is becourse of the fact that once you put money in the bank it then cant be robed from other members of your board (well if you have rob addon installed)


information on how to install and DB changes r in the zip below.

BRING ON THE CASIO :P

Keyser S?ze
06-08-2002, 07:06 PM
what about adding a small fee to use the bank? i mean, if everyone puts their money into the bank til neded then the rob hack is useless

would be even better if the fee was a % of how much u had in there

Blue2000
06-08-2002, 07:16 PM
if you want that its do

in Bank.php find

$userbankmoney=floor($userbankmoney*(pow(1.03,$pre senttime)));

under that put

$userbankmoneytaken=floor($userbankmoney-(pow(1.01,$presenttime)));

then find

$DB_site->query("UPDATE user SET
bank=$userbankmoney,savemt='".time()."' WHERE userid='$bbuserinfo[userid]'");
}


and replace with

$DB_site->query("UPDATE user SET
bank=$userbankmoney,$userbankmoneytaken,savemt='".time()."' WHERE userid='$bbuserinfo[userid]'");
}




note that -(pow(1.01,$presenttime)) is your % if you want atm its set at 1 % per day

eg of 10%

(1.1,$presenttime

ZiRu$
06-08-2002, 07:22 PM
thanks so much man.....

Blue2000
06-08-2002, 07:23 PM
Originally posted by IceMalee
what about adding a small fee to use the bank? i mean, if everyone puts their money into the bank til neded then the rob hack is useless


would be even better if the fee was a % of how much u had in there

you know thinking about it its pointless you may aswell just set the first % - the 2nd one you want...

So i have a better idea

i will work on it now and see what happens

inetd
06-08-2002, 07:33 PM
Please post description of this add-on! :D

ceo_tfw
06-08-2002, 08:29 PM
how do you change the value so you can have more money in bank

it does not go any higher than 65535

Blue2000
06-08-2002, 08:34 PM
ok due to how safe it is now once using it

i thought of this idea to add a cost of using the bank but not by a % per day not by a cost of using things.

Ok in the real world you have to pay to take money out of an whole in the wall

So i have made this addon take $10 off you for taking money out.

also the bank is providing a service for the members. members want to use it, then they should be a cost for it.

so the hack also makes you now pay $100 for invresting money into the bank :P

:)

Blue2000
06-08-2002, 08:57 PM
Originally posted by ceo_tfw
how do you change the value so you can have more money in bank

it does not go any higher than 65535

ill look into this

Blue2000
06-08-2002, 09:05 PM
Originally posted by Blue2000


ill look into this


run this


ALTER TABLE user CHANGE bank bank INT(234) UNSIGNED DEFAULT '0' NOT NULL

bandersen
06-09-2002, 11:46 AM
Great!
I have installed.

Can you tell me what code to enter where to get the navigation string showing, like here you have:

vBulletin.org Forum > Code Hacks > Full Releases > Bank Addon for Lesane store hack

Lesane
06-09-2002, 11:53 AM
Great addon Blue2000, well done. I'm going to install this one later, thanks.

bandersen
06-09-2002, 11:57 AM
Here's some feedback:
"top 10 richest people" do not include money in the bank. Hence, I show up broke even I am not....
Is there a way to include money in the bank in the count?

"the bank option" on the Store does not show any Sold# when I put money in the bank... it just stays zero.

Blue2000
06-09-2002, 12:41 PM
i just found another bug

it wouldnt allow you to take out more than 10000

find in bank.php


if ($bank>$usermoney || $bank>10000)

replace with

if ($bank>$usermoney)

Blue2000
06-09-2002, 12:45 PM
Originally posted by bandersen
Here's some feedback:
"top 10 richest people" do not include money in the bank. Hence, I show up broke even I am not....
Is there a way to include money in the bank in the count?

"the bank option" on the Store does not show any Sold# when I put money in the bank... it just stays zero.

yeah i was going to play with that later.

oh and about the bank option that was just a way of putting a link in the shop when you press the link your not buying anything so its not wrong to only display 0.

Blue2000
06-09-2002, 01:08 PM
Originally posted by bandersen
Here's some feedback:
"top 10 richest people" do not include money in the bank. Hence, I show up broke even I am not....
Is there a way to include money in the bank in the count?



here you go fella

find



if ($action=="top10") {

$topresult = $DB_site->query("SELECT * FROM user ORDER BY storep+bank DESC LIMIT 25");
while ($top = mysql_fetch_array($topresult)) {
if (($counter++ % 2) != 0) {
$backcolor="{firstaltcolor}";
$bgclass="alt1";
} else {
$backcolor = "{secondaltcolor}";
$bgclass="alt2";
}
eval("\$top10rich .= \"".gettemplate("store_top10_bit")."\";");
}
eval("dooutput(\"".gettemplate("store_top10_main")."\");");

}



replace with


if ($action=="top10") {

$topresult = $DB_site->query("SELECT * FROM user ORDER BY storep+bank DESC LIMIT 25");
while ($top = mysql_fetch_array($topresult)) {
if (($counter++ % 2) != 0) {
$backcolor="{firstaltcolor}";
$bgclass="alt1";
} else {
$backcolor = "{secondaltcolor}";
$bgclass="alt2";
}
$allmoney = $top[bank]+$top[storep];
eval("\$top10rich .= \"".gettemplate("store_top10_bit")."\";");
}
eval("dooutput(\"".gettemplate("store_top10_main")."\");");

}


text file updated

ceo_tfw
06-09-2002, 01:23 PM
Originally posted by Blue2000



run this


ALTER TABLE user CHANGE bank bank INT(234) UNSIGNED DEFAULT '0' NOT NULL


thanks for that, it works well now,, cool job

Blue2000
06-09-2002, 01:30 PM
Originally posted by bandersen
Great!
I have installed.

Can you tell me what code to enter where to get the navigation string showing, like here you have:

vBulletin.org Forum > Code Hacks > Full Releases > Bank Addon for Lesane store hack

in

bankbit template

find

$bankform

and ABOVE add


<br>
<img src="{imagesfolder}/off.gif" border="0" align="middle" alt="$bbtitle : Powered by vBulletin version $templateversion"></a>
<normalfont><b><a href="index.php?s=$session[sessionhash]">$bbtitle</a> &gt; BANK</b></normalfont>


:)

ceo_tfw
06-09-2002, 03:07 PM
is there a way to show the amount of interest you have earned whilst moneys been in the bank

Blue2000
06-09-2002, 03:33 PM
not at this time

Dean C
06-09-2002, 05:55 PM
this is a great addon.. ill have a go at installing it later.... are all the updates that you have done in the original zip file???

Blue2000
06-09-2002, 06:56 PM
Originally posted by Mist
this is a great addon.. ill have a go at installing it later.... are all the updates that you have done in the original zip file???

yes they should be :)

BigJohnson
06-10-2002, 07:54 AM
Does your money grow with interest?

ZiRu$
06-10-2002, 02:17 PM
yah...does it grow with interest?

BigJohnson
06-10-2002, 05:23 PM
OK When you go to the store is says how much is needed for this item if you want to buy it and it tells you how much money you need also to buy it. KNow in order to have the bank you need 100 bucks. Now no where in the main page of the store does it say you need 100 bucks till you actually click the bank button then it says you need 100 bucks. Please tell me how to add something pon like this thanks.

BigJohnson
06-10-2002, 05:46 PM
I am creating new template for this hack because the ones now are a little reaky looking. When i am done i will create a new template look and release them here in this thread. They should be done tongiht. I am trying to figure out why this php code is not working for the avatar

$avatarimage

It works on the forum home but not in the bank. but $avatarimage directs to ITEM.gif in your images dir for some odd reason. I will change this also unless someone wants to post it now. I am going to look at it now and post back.

bandersen
06-10-2002, 10:01 PM
I replaced the code but I still show up broke....in 10 richest. No change. Any clue...

ps. looking forward to that new template release...

Originally posted by Blue2000


here you go fella

find



if ($action=="top10") {

$topresult = $DB_site->query("SELECT * FROM user ORDER BY storep+bank DESC LIMIT 25");
while ($top = mysql_fetch_array($topresult)) {
if (($counter++ % 2) != 0) {
$backcolor="#13486D";
$bgclass="alt1";
} else {
$backcolor = "#1C5780";
$bgclass="alt2";
}
eval("\$top10rich .= \"".gettemplate("store_top10_bit")."\";");
}
eval("dooutput(\"".gettemplate("store_top10_main")."\");");

}



replace with


if ($action=="top10") {

$topresult = $DB_site->query("SELECT * FROM user ORDER BY storep+bank DESC LIMIT 25");
while ($top = mysql_fetch_array($topresult)) {
if (($counter++ % 2) != 0) {
$backcolor="#13486D";
$bgclass="alt1";
} else {
$backcolor = "#1C5780";
$bgclass="alt2";
}
$allmoney = $top[bank]+$top[storep];
eval("\$top10rich .= \"".gettemplate("store_top10_bit")."\";");
}
eval("dooutput(\"".gettemplate("store_top10_main")."\");");

}


text file updated

Blue2000
06-11-2002, 01:36 AM
Originally posted by BigJohnson
Does your money grow with interest?

you get interest per day like it says in my first post

and it gives you an eg to set the interest to what you want

Blue2000
06-11-2002, 01:46 AM
Originally posted by BigJohnson
OK When you go to the store is says how much is needed for this item if you want to buy it and it tells you how much money you need also to buy it. KNow in order to have the bank you need 100 bucks. Now no where in the main page of the store does it say you need 100 bucks till you actually click the bank button then it says you need 100 bucks. Please tell me how to add something pon like this thanks.


Ok first off

this link was just made for a easyer way to add the bank to the store so you didnt need antoher button in your header.

It cant you show how many its sold becoz ITS NOT SELLING U ANYTHING

als o if that was added then it would also be a lie coz you dont get changed to transfer and stuff link this

They is however 3 ways arond this problem

1. One i can probley edited the DB so them numbers would only show as NA

2. set the bank link not to display in your forum and then add a button yourself. (personaly i liked the link in the store so thats why i added that bit)

3. U can leave it the way it is and in your admin cp edit the option for bank and add in the Description the costs for things

* Blue2000 likes option 3 coz its easyest :P

Blue2000
06-11-2002, 01:52 AM
Originally posted by BigJohnson
I am creating new template for this hack because the ones now are a little reaky looking. When i am done i will create a new template look and release them here in this thread. They should be done tongiht.




ok they r not that bad looking but i agree they do need a little tooking in ;)

one of my admins is making a new set now.

But if you ask me the more sets of templates the better fella. so bring them on :)



I am trying to figure out why this php code is not working for the avatar

$avatarimage

It works on the forum home but not in the bank. but $avatarimage directs to ITEM.gif in your images dir for some odd reason. I will change this also unless someone wants to post it now. I am going to look at it now and post back.


i dont have this problem at all

and your the first to report such a thing.

does anyone else have thing problem?

Blue2000
06-11-2002, 02:04 AM
Originally posted by bandersen
I replaced the code but I still show up broke....in 10 richest. No change. Any clue...


]
try redownloading the zip[i updated it] and install it from there.

see what happens

coz this is working on my site and 3 others i have seen.

BigJohnson
06-11-2002, 08:32 AM
Originally posted by Blue2000

i dont have this problem at all

and your the first to report such a thing.

does anyone else have thing problem?

Well yes because the other bank thing that we needed to install look at the screen shot someone posted.

https://vborg.vbsupport.ru/attachment.php?s=&postid=246545

See the X

It is only on that screen though that it does it. All the other screens are fine with the avatar showing but this one. Its only in the showroom template it doesnt work. That i find wierd. No one else is having this prob of not seeing the avatar?

bandersen
06-11-2002, 11:41 AM
Sorry... text file in zip in first post looks the same as the old one.. without the "if 10 richest action.....". Can you attach it here?


Originally posted by Blue2000

]
try redownloading the zip[i updated it] and install it from there.

see what happens

coz this is working on my site and 3 others i have seen.

bandersen
06-11-2002, 11:55 AM
Originally posted by BigJohnson


Well yes because the other bank thing that we needed to install look at the screen shot someone posted.

https://vborg.vbsupport.ru/attachment.php?s=&postid=246545

See the X

It is only on that screen though that it does it. All the other screens are fine with the avatar showing but this one. Its only in the showroom template it doesnt work. That i find wierd. No one else is having this prob of not seeing the avatar?

BigJ.: I have avatars in every template.... "$avatarimage" works fine. My avatars are still in the ... /images/avatar directory.

Blue2000
06-11-2002, 04:54 PM
its hard to try and debug somthing that doesnt happen to you.

bandersen
06-11-2002, 05:14 PM
Originally posted by Blue2000
its hard to try and debug somthing that doesnt happen to you.

Hi Blue2000 - I was just replying to the post above :)
Could you please attach the new zip/new txt file here because the text file in post one looks like the old one... Then I can see if I get the top 10 richest to work (ref.post above). Thanks,.

BigJohnson
06-12-2002, 08:08 AM
well if you looks at th avatar images thingy lines in the PHP when u have no avatar it directs u to /board dir/item.gif So that is why. I just debugged it and fixed the prob also here are my templates i created for this addon if anyone wants to use them.

Here is a image of what it looks like. The actual TXT file is in the post below. Enjoy. Tell me what you guy think of it? It was pretty simple. I just didint like the other one but everyone has there own opinions.

BigJohnson
06-12-2002, 08:13 AM
Sorry i lied. hehe. Here is another pic. The txt is below. ;)

BigJohnson
06-12-2002, 08:14 AM
Here is the actual instructions on the templates. Enjoy.

bandersen
06-12-2002, 08:18 AM
Thant template is very very nice :) cool bank image!

BigJohnson
06-12-2002, 08:28 AM
thanks. I always usually change the images to everything i do becuase it is more fun. The most fun i had changing the images to was for the store hack. Heres an example.

What do you think about this one. hehe. I dont no if i should realease them for the store though ebcause il ie them very much hehe. That is just a taste of what i did.

bandersen
06-12-2002, 08:33 AM
:) cool! I have left the images out of the store until I find time to be creative!

Blue2000
06-12-2002, 02:21 PM
Originally posted by bandersen


Hi Blue2000 - I was just replying to the post above :)
Could you please attach the new zip/new txt file here because the text file in post one looks like the old one... Then I can see if I get the top 10 richest to work (ref.post above). Thanks,.

sorry mate

i thought you had taken the code from my post.

so when i said redownload it i meant i had updated the file with what i posted in the thread.

sorry for the misunderstanding

Blue2000
06-12-2002, 02:21 PM
Originally posted by BigJohnson
Here is the actual instructions on the templates. Enjoy.

very nice fella

nice work

bandersen
06-12-2002, 02:58 PM
ps. Blue2000 see post #33.... perhaps you just hit reply on the wrong post.
I checked the zip in post 1 again... the new text file hasnt been updated or something....so if you could attach it here?



Originally posted by Blue2000


sorry mate

i thought you had taken the code from my post.

so when i said redownload it i meant i had updated the file with what i posted in the thread.

sorry for the misunderstanding

Blue2000
06-12-2002, 04:58 PM
hmmmm

ok here it is again :)

Blue2000
06-12-2002, 05:18 PM
Originally posted by bandersen
Thant template is very very nice :) cool bank image!

yeah it is a cool bank image

you going to share that fella? :)

Blue2000
06-12-2002, 05:26 PM
BigJohnson dude two of the templates r the same

you have killed the main load screen where you have your pic

bandersen
06-12-2002, 05:27 PM
Gee... I can t get the top 10 richest to display the total sum of money in store + in bank. (my money is called points tho). I did upload the new bank.php and I did do the change in store.php.
The bank is correct, and top10 show points in the store only.

Blue2000
06-14-2002, 11:57 AM
oh god

sorry mate i forgot the template edit aswell

in template store_top10_bit

find


<td align="center" bgcolor="$backcolor">
<smallfont>$top[storep]</smallfont>
</td></tr>


replace with


<td align="center" bgcolor="$backcolor">
<smallfont>$allmoney</smallfont>
</td></tr>


zip updated

bandersen
06-14-2002, 12:07 PM
Guess what... now it's working :p Thanks

bandersen
06-14-2002, 05:23 PM
BigJ., I was planning to adopt those templates you made. Could you upload the correct main load screen.....(bankbit_load?) thanks a lot.

Originally posted by Blue2000
BigJohnson dude two of the templates r the same

you have killed the main load screen where you have your pic


EDIT: I just installed them and they turned out OK..... as far as I can see....

BigJohnson
06-14-2002, 08:18 PM
OK here is the updated templates. I dont think any thing was wrong with the other one though. You had to prob not do it right or something. Is anyone seeing anything wrong with it. WQell any way i changed it to make sure here it is.

BigJohnson
06-14-2002, 08:20 PM
Ok here is the bank images for thoughs who want it. Enjoy. I am working on another one as well i will post it here. Also tell me what you think about the templates i posted. Thanks.

bandersen
06-14-2002, 09:00 PM
I just used the templates in your first attachment and they seemed ok....
Your images are very cool...the bank image... did you notice the mix of modern windows and Greek pillars... and the size of the two :) I have weakness for historical buildings :)

Blue2000
06-15-2002, 02:25 AM
they is diffo somthing wrong fella

do a seach for 100.gif in your templates you will not find it.

the fist page brings up the load and not he showroom

BigJohnson
06-15-2002, 04:01 AM
Heres another little something that i found wierd about this hack. When you have to pay 100 bucks to put money in the bank. Say you put all you money in the bank then it says you have -100 dollars. To me this seems inpossible. Can you please change it so that it will say you can add this much to the bank because you need to have 100 left over or something. Thanks so much. I willbe keeping in touch to see the replies thanks.

bandersen
06-15-2002, 09:38 AM
I see the load / showroom thing now..

BigJohnson
06-15-2002, 10:03 PM
bump

[hhhh]
06-16-2002, 12:10 PM
]Database error in vBulletin 2.2.6:

Invalid SQL:
SELECT savemt FROM user WHERE userid='1'
mysql error: Unknown column 'savemt' in 'field list'

mysql error number: 1054

Date: Saturday 15th of June 2002 03:33:02 AM
Script: http://www.vnof.info/forums/forums/bank.php
Referer: http://www.vnof.info/forums/store.php?action=main

What This Error ??? Help Me!

ZiRu$
06-16-2002, 06:19 PM
I done the query.....Put in the templates....

What's this error.....I get it when i click on the bank


There seems to have been a slight problem with the Blazing Mic database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

bandersen
06-16-2002, 07:11 PM
I get that too every now and then. It comes with an email saying too many connections are open (I am on a Hosted server). It goes away after a while :)

[hhhh]
06-17-2002, 01:20 PM
]
Database error in vBulletin 2.2.6:

Invalid SQL:
SELECT savemt FROM user WHERE userid='1'
mysql error: Unknown column 'savemt' in 'field list'

mysql error number: 1054

Date: Saturday 15th of June 2002 03:33:02 AM
Script: http://www.vnof.info/forums/bank.php
Referer: http://www.vnof.info/forums/store.php?action=main

plezz help me.....

ZiRu$
06-17-2002, 08:49 PM
Originally posted by bandersen
I get that too every now and then. It comes with an email saying too many connections are open (I am on a Hosted server). It goes away after a while :)

no....its on my test board......I'm only one on there

Blue2000
06-18-2002, 02:37 PM
Originally posted by BigJohnson
Heres another little something that i found wierd about this hack. When you have to pay 100 bucks to put money in the bank. Say you put all you money in the bank then it says you have -100 dollars. To me this seems inpossible. Can you please change it so that it will say you can add this much to the bank because you need to have 100 left over or something. Thanks so much. I willbe keeping in touch to see the replies thanks.

the message is there saying it will cost that amount..

Am sure your members can do the maths first.

Blue2000
06-18-2002, 02:38 PM
Originally posted by BigJohnson
bump

dont bump me on any of the things i post again dude.. i will reply when i have time!

Blue2000
06-18-2002, 02:39 PM
Originally posted by [hhhh]

What This Error ??? Help Me!

you havent not ran the db part of the install

remember i said you have to install the other hack first the link is there in my first post

Blue2000
06-18-2002, 02:41 PM
Originally posted by Hot Dogg
I done the query.....Put in the templates....

What's this error.....I get it when i click on the bank


There seems to have been a slight problem with the Blazing Mic database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.



give me a clue then, whats your e-mail say?

BigJohnson
06-18-2002, 07:42 PM
Sorry for bumping u hehe. Well still no one answered my question hehe. Say i have 1000 dollars and i put 1000 in the bank that means i have -100 dollars it says and that makes no sense also when i have 1000 bucks i put 100 in the bank it says in my post bit that i have 800 bucks then but i really have 900 because it takes 100 dollars off. The postbit is using the store hack variable is there a bank variable to replace it?

[hhhh]
06-21-2002, 06:25 AM
]Originally posted by Blue2000


you havent not ran the db part of the install

remember i said you have to install the other hack first the link is there in my first post
i have run this script db.

INSERT INTO store VALUES (null, 'bank', '<a href="/forums/bank.php"><b>The Bank</a></font>', '0', 0, 'images/100.gif', 'With this action you can use our bank to store your money so it can not be robed, also gain money for keeping it in there...', 'Y', 0);

but it not working ?? help me!

Blue2000
06-21-2002, 10:41 AM
what error message did you get?

Herman
06-23-2002, 02:39 AM
i hav a problem mine wont show up, i need the template, i think bankbit i can't find it anywhree

globalwin
06-24-2002, 08:27 PM
yeh, I get the above error too :(

[hhhh]
06-25-2002, 04:14 AM
plz..............................!

Lesane
06-25-2002, 07:16 AM
If you get an error with this:

INSERT INTO store VALUES (null, 'bank', '<a href="/forums/bank.php"><b>The Bank</a></font>', '0', 0, 'images/100.gif', 'With this action you can use our bank to store your money so it can not be robed, also gain money for keeping it in there...', 'Y', 0);

Then you probably don't have the latest version of the Store Hack installed.

Use this query:

INSERT INTO store VALUES (null, 'bank', '<a href=/forums/bank.php><b>The Bank</a></font>', '0', 0, 'images/100.gif', 'With this action you can use our bank to store your money so it can not be robed, also gain money for keeping it in there...', 'Y');

BigJohnson
06-25-2002, 09:16 AM
Can someone please answer my question aboce thanks.

Roxie
06-25-2002, 07:46 PM
It wouldn't let me run that query. and I get an error with the other.

Originally posted by Lesane
If you get an error with this:

INSERT INTO store VALUES (null, 'bank', '<a href="/forums/bank.php"><b>The Bank</a></font>', '0', 0, 'images/100.gif', 'With this action you can use our bank to store your money so it can not be robed, also gain money for keeping it in there...', 'Y', 0);

Then you probably don't have the latest version of the Store Hack installed.

Use this query:

INSERT INTO store VALUES (null, 'bank', '<a href=/forums/bank.php><b>The Bank</a></font>', '0', 0, 'images/100.gif', 'With this action you can use our bank to store your money so it can not be robed, also gain money for keeping it in there...', 'Y');

Roxie
06-25-2002, 07:57 PM
Big Johnson, your question was answered a page back.

Lesane
06-26-2002, 09:59 AM
Roxie, any errors?

Keta
06-27-2002, 08:47 AM
ok am i missing templates? because i see a blank page when i try to go to the bank here are the ones i got...am i missing some?

bankbit_change [edit] [remove]
bankbit_load [edit] [remove]
bankbit_save [edit] [remove]
bankbit_showroom [edit] [remove]

Kmaster
07-03-2002, 01:20 AM
I found new error.

Invalid SQL: UPDATE user SET
bank=690,,savemt='1025662706' WHERE userid='12'
mysql error: You have an error in your SQL syntax near 'savemt='1025662706' WHERE userid='12'' at line 2

Blue2000 please help. thx.

BigJohnson
07-03-2002, 12:54 PM
No my question was never answered about your Money able to be going down to -100

Night Owl
07-20-2002, 05:35 AM
I am also getting the database error:

Database error in vBulletin 2.2.6:

Invalid SQL:
SELECT savemt FROM user WHERE userid='36'
mysql error: Unknown column 'savemt' in 'field list'

mysql error number: 1054

Date: Saturday 20th of July 2002 02:24:02 AM
Script: http://www.sybermoms.com/forums/forums/bank.php
Referer: https://216.118.116.130:2087/scripts/command

Note: The URL on the script is also messed up.

I installed the store hack about a week ago, so I'm sure I have the most up to date one. And I know I ran the sql query. So, what's up?

Thanks!

Night Owl
07-20-2002, 06:06 AM
Just call me stupid.

But I get it now. You have to install the ORIGINAL bank hack written by root, mem and jessie (as noted in Blue's first post). THEN you install blue's hack.

Whew. I think I just wore out the last brain cell...:lol :lol :lol

Roxie
07-24-2002, 10:40 PM
yes, night owl. It took me a minute to realize that. LOL, but now I can't figure out how to install that one *smacks forehead* If anyone can help I am birdie718 on AIM.

Roxie
07-24-2002, 11:08 PM
My users money is not showing when they try to put it in the bank. Please help. :D My AIM name is birdie718

Roxie
07-27-2002, 05:48 AM
I'm still needing help with this. I have money, but when I go into the bank it says I have none to put away.

Roxie
08-02-2002, 06:19 PM
Can anyone help me please? It's still not working for me and I have tried everything I could think of.

DarkDraco07
08-13-2002, 07:38 AM
i just started to install this until i came across a problem....

how am i supposed to edit templates when there are no templates???????????

DarkDraco07
08-13-2002, 11:56 AM
WHERE ARE THE TEMPLATES!!!!!!!!!!!

DestyNova
08-13-2002, 05:00 PM
Never mind.. I fix it, it works now =P

If anyone still need help on this hack, I ll more than happy to help but pls undy that I have limited experience with PHP.

DarkDraco07
08-13-2002, 05:57 PM
HELP ME, SEND ME THE TEMPLATES!!!!
i downloaded the file but templates were not included!!!!

DestyNova
08-13-2002, 06:14 PM
Originally posted by DarkDraco07
HELP ME, SEND ME THE TEMPLATES!!!!
i downloaded the file but templates were not included!!!!

go and download from this [vB v2.2.5] vBulletin bank hack (https://vborg.vbsupport.ru/attachment.php?s=&postid=246521) first before use BLue's hack. It contains the bank hack and templates.

After that then replace the bank.php by follow Blue's instruction and use BigJohnson's template to replace some of templates.

But do old bank hack first that I give you the link first.

DarkDraco07
08-13-2002, 08:28 PM
thanks alot, this will solve lots of probs

DarkDraco07
08-14-2002, 09:25 PM
how do you change the interest?

Roxie
08-15-2002, 06:32 AM
On the first page I believe it tells how to change the interest.

draven
08-24-2002, 09:43 AM
I got the hack installed and it works fine. Top 10 also working fine.
But in the store statistics it still won't show the richest person (dosn't count the money in the bank).
I managed to get that part working so it shows the overall richest person, but it just dosn't show the overall money (dosn't count the money in the bank).
Sure it's pretty simple. Anyone?

N9ne
08-24-2002, 01:08 PM
Ok there's many pages in the bank hack and this hack's threads so i'll just ask this simple question:

I'm running PHP4.2.2, vB2.2.6 with the store hack with lottery addon, will the bank hack + this addon work for me...without any bugs?

ZiRu$
08-24-2002, 09:52 PM
It don't work for me.......i added the templates in a previous post...installed the bank and store hack...and then i installed the other bank and ran the install......it didn't create the new templates even though it said it did

Somone should just attach ALL THE TEMPLATES

ZiRu$
08-24-2002, 10:47 PM
I got it working....thought I'd help y'all out

here's the missing templates

Keta
09-01-2002, 08:05 PM
Originally posted by draven
I got the hack installed and it works fine. Top 10 also working fine.
But in the store statistics it still won't show the richest person (dosn't count the money in the bank).
I managed to get that part working so it shows the overall richest person, but it just dosn't show the overall money (dosn't count the money in the bank).
Sure it's pretty simple. Anyone?

ok i am having the exact same problem i made the edit to strore.php and added in the template information ($allmoney) and its still now showing the bank money :( someone help me

azork
09-16-2002, 10:19 AM
is there a way to deposit some money in other members'bank? Because i've installed the steal addon and when i reward some members, they are robbed...

Cold Steel
09-16-2002, 05:59 PM
Everything is working fine for me.

Thanks, great integration hack!

One little thing... instead of my top TEN members, now there's a long list. Can that be changed?

azork
09-18-2002, 11:00 PM
Blue 2000, I have found a major bug in the hack!

You can easily receive an illimitate amount of gold:

Basically, just open up 2 internet explorers, took both of them to the bank, and with 1 of them, withdrew a certain amount of money (say... 100 gold). Then on both screens, enter "100" as the amount you want to deposit, and hit the deposit botton on both screens at the exact same time and WALLA dupage...

I think if you put a time limit on how fast you can deposit gold (like, u can only deposit gold once every 45 seconds) this dupe bug will be fixed.

but im not sure....

Night Owl
10-13-2002, 05:27 PM
I think my members have found a bug!

Apparently, if you do not use the bank, you earn interest like mad!

If you use it, you do not earn interest.

What can be done to fix this?

bouncer18
10-14-2002, 05:46 AM
Here is an error i have found

if ya got 500 bucks
you deposit it all

it says you have -100 bucks..
but in the bank it shows ya have 400 (since it takes 100 away to deposit)

Got a quick fix?

bouncer18
10-14-2002, 06:25 AM
actually..
what does happen is
if they deposit all there cash
they go -100

and then they cant post w/ the theft hack..

:o\

LOD-squa
12-17-2002, 10:55 PM
do we have to have that other store installed to get this?

azork
01-17-2003, 12:28 PM
i've a limitation money in the bank: i can't deposit more than 65k in it. how can i change that?

FWF
02-17-2003, 08:38 AM
this is a cool ad on :)

Vivi Ornitier
02-27-2003, 04:07 AM
how do we withdraw? I knwo there's a withdraw link but it doesn't work, the money still stays in the bank

auz1111
03-09-2003, 02:40 AM
when i try to visit the bank from the store it tries to access this url: www.forumname.net/board folder/bank.php

It need it to go to www.forumname.net/bank.php

please help

thanks for the great hack!

Darnell 0216
03-09-2003, 05:10 PM
You're supposed to edit that part when installing. Go back into store.php and change #### Bank link #####
if($action == "bank") {
header("Location: www.forumname.net/board folder/bank.php");
to #### Bank link #####
if($action == "bank") {
header("Location: www.forumname.net/bank.php");

N9ne
03-09-2003, 05:13 PM
Why not have:


#### Bank link #####
if($action == "bank") {
header("Location: $bburl/bank.php");

Darnell 0216
03-09-2003, 05:15 PM
Originally posted by azork
i've a limitation money in the bank: i can't deposit more than 65k in it. how can i change that? Originally posted by Blue2000


run this

ALTER TABLE user CHANGE bank bank INT(234) UNSIGNED DEFAULT '0' NOT NULL

auz1111
03-09-2003, 05:30 PM
Originally posted by Darnell 0216
[B]You're supposed to edit that part when installing.

thanks!

bharvey42
03-10-2003, 07:56 PM
has the depoist error been fixed? The one where you go into negative money for deposits?

bharvey42
03-10-2003, 07:57 PM
instead of paying a flat rate for deposits would it be possible to charge a % of the depoist? that seems more logical if you only have say $40 to deposit.

Darnell 0216
03-14-2003, 07:14 AM
10-13-02 at 01:27 PM Night Owl said this in Post #106 (https://vborg.vbsupport.ru/showthread.php?postid=309392#post309392)
I think my members have found a bug!

Apparently, if you do not use the bank, you earn interest like mad!

If you use it, you do not earn interest.

What can be done to fix this?
I noticed this as well. Best I can figure is the clock that times the deposits is user dependent and resets with each bank action. To work properly it would need to be rewritten to be global and run no matter what. If someone could break that down that would be great.

hamed
03-23-2003, 04:07 PM
how can I change the interest rate? I want them to earn 0.1% a day :knockedout:

Kevorkian
03-23-2003, 04:57 PM
in my bank the interest don't work -_-''

Darnell 0216
03-23-2003, 05:52 PM
Today at 01:07 PM hamed said this in Post #121 (https://vborg.vbsupport.ru/showthread.php?postid=371993#post371993)
how can I change the interest rate? I want them to earn 0.1% a day :knockedout:
find
$userbankmoney=floor($userbankmoney*(pow(1.1,$pres enttime))); and change 1.1 to the percentage you want for interest. In your case 0.1% would be 1.001.

Darnell 0216
03-23-2003, 05:54 PM
Today at 01:57 PM Kevorkian said this in Post #122 (https://vborg.vbsupport.ru/showthread.php?postid=372036#post372036)
in my bank the interest don't work -_-''
Are you sure you're not just experiencing the previously mentioned fluke? If you constantly use the bank, you won't earn interest because the interest clock is tied directly into each bank action. You would have to leave the bank alone for 24 hours for you to recieve an interest payment.

hamed
03-23-2003, 06:46 PM
Today at 07:52 PM Darnell 0216 said this in Post #123 (https://vborg.vbsupport.ru/showthread.php?postid=372098#post372098)

find
$userbankmoney=floor($userbankmoney*(pow(1.1,$pres enttime))); and change 1.1 to the percentage you want for interest. In your case 0.1% would be 1.001.


Thank you. This is great.

Koutaru
05-04-2003, 08:50 PM
Is there a way to get monthly interest instead of daily?

Darnell 0216
05-17-2003, 06:49 PM
05-04-03 at 05:50 PM Koutaru said this in Post #126 (https://vborg.vbsupport.ru/showthread.php?postid=391426#post391426)
Is there a way to get monthly interest instead of daily? Because of the way the hack is designed, that would be pointless. Currently the bank runs on a timer based on your visiting and using the bank. A full 24 hours must pass without a deposit or withdrawal being made. Unless you have members that are willing to sit with money on hand for 30-31 days, their everyday actions would keep updating the interest timer.

I hoped someone would find a way to redo the interest timer to work independently of the bank actions. But no one has done so yet.

Koutaru
05-18-2003, 03:54 AM
Hmm -- I understand now, thanks Darnell. I guess I can live with the daily ;)

Bulleh
06-01-2003, 11:22 AM
ok im a reall n00b here, but ive installed bank hack www.gamers-source.com But how do i deposit money in to the bank? lol i musta done something wrong but i cant see what

Holidazed
06-04-2003, 07:27 PM
Blue2000, I know it is a pain in the butt, but is there a way you can make a modification so that this hack works with Zajako's RPG Hack? I do not have the store hack installed on my system. Actually, it is a bit too complicated for me.

It might require a couple of changes (like DB field name changed to have maybe an "RPG" in front of it), bank.php changed to rpgbank.php. This is so people could have this hack running on Lesane's Store as well as Zajako's RPG.

For money, Zajako uses a variable called "$rpgmoney". If you could do this, I would greatly appreciate it.

Thank you.

Madacc
06-24-2003, 02:12 AM
For some reason this bank will only work with my default style.. and none of the others.. how can I fix this!?

reismarktq2
07-05-2003, 02:43 PM
Question: I want to make it so that members are limited to one withdrawal every 12 hours. Any idea how I would code this?

Sin City
07-10-2003, 07:30 AM
whenever i click the "Bank" option in the store i get this error:

404 - File Not Found!
http://hostultra.com/board%20folder/bank.php could not be found!
Called by referring page:
http://hostultra.com/~lox/forums/store.php?action=main

i have the updated bank.php file uploaded to my root directory so i really have no idea what is wrong.... anyone have a clue?

Sin City
07-10-2003, 10:29 PM
bump :)

Dras
08-04-2003, 03:42 AM
I get:

Database error in vBulletin 2.3.0:

Invalid SQL:
SELECT savemt FROM user WHERE userid='1'
mysql error: Unknown column 'savemt' in 'field list'

mysql error number: 1054

I changed around the coding so it's :
forums/store.php?action=bank

But still no luck =/

Darnell 0216
08-14-2003, 04:49 AM
08-04-03 at 12:42 AM Dras said this in Post #135 (https://vborg.vbsupport.ru/showthread.php?postid=423019#post423019)
I get:

Database error in vBulletin 2.3.0:

Invalid SQL:
SELECT savemt FROM user WHERE userid='1'
mysql error: Unknown column 'savemt' in 'field list'

mysql error number: 1054


I changed around the coding so it's :
forums/store.php?action=bank

But still no luck =/
Unknown Colum means you didn't run the necessary SQL queries. Run them and then try again.

Dras
08-15-2003, 03:53 AM
WHERE? I don't see anyhting to run PHP admin except for the thing to add a link in the store!

Roxie
09-08-2003, 03:24 AM
Anyone know how to set the bank back to 0?

Hogwarts
09-08-2003, 11:30 PM
I insatlled the Store hack, and edited up to be for a Harry Potter Board (Hogwarts) .. now I am trying to add this becasue it would be cool, Diagon Alley (the store) and Gringotts (a wizards bank aka .. ovisuly the Bank hack). Now I download this installation instructions and it says you have to have the other too hacks insatlled, I am one step down, but I don't have the bank hack installed.

I went to the link in the txt file and downloaded the bank hack files (2 of them, 1 bank.php and 1 insatll_bank.php put the insatll hack in the admin folder ran it .. blank page. Went to their supot thread, this has happend to others, but the last post was like over a year ago, so I figured I would post this in here.

How do I install that .. I am sure others have experianced this.

Any information would be very helpfull.

Thank You

- Hogwarts

Red Blaze
09-19-2003, 04:44 PM
I also get this error in bank.php

Database error in vBulletin 2.3.2:

Invalid SQL:
SELECT savemt FROM user WHERE userid='1'
mysql error: Unknown column 'savemt' in 'field list'

mysql error number: 1054

Date: Friday 19th of September 2003 07:59:45 PM
Script: http://members.lycos.co.uk/thesonicjoint/thesonicjoint/bank.php
Referer:

I DID run the query, in fact... the only query it tells me, and I still get a database error.

EDIT: I also get this in bank.php

bank.php)???(???(?mBIN??'?
Warning: Cannot modify header information - headers already sent by (output started at /data/members/free/tripod/uk/t/h/e/thesonicjoint/htdocs/bank.php:1) in /data/members/free/tripod/uk/t/h/e/thesonicjoint/htdocs/admin/functions.php on line 1881



In the store, I get this on the very top.


store.phpũ????????mBIN????
Warning: Cannot modify header information - headers already sent by (output started at /data/members/free/tripod/uk/t/h/e/thesonicjoint/htdocs/store.php:1) in /data/members/free/tripod/uk/t/h/e/thesonicjoint/htdocs/admin/functions.php on line 1881

SharronH
10-05-2003, 03:33 AM
Sorry i lied. hehe. Here is another pic. The txt is below. ;)


Does anyone know how to intregrate this pic into the bank. I've spent 2 hours trying and I gave up. TIA

deathemperor
10-08-2003, 03:14 AM
well, all people who may want to use Store hack and add on the bank hack due to the store hack has no bank, then do this:
in the 1st post of this thread, read carefully, then you should realize that you have to install the bank hack 1st, the link to download was already there.
How to install ? put the install_bank.php in your admin folder, then run it, it should have no error.
After that, just do things blue2000 told you, and everything should work fine. Sometimes you all need to read and look up carefullly to find errors yourself, it's not too hard that asking here is the best solution.
good luck

Limpkinw
11-12-2003, 09:05 PM
Is there a way to track transactions, especially transfers, peopel are funneling funds with dup accounts and i cant track it. also can i allow only a certian percentage of funds to be deposited..

xxxsaint
11-19-2003, 02:05 PM
And for those of us who realized that you had to install the BANK HACK FIRST before using this , what we've been trying to tell you is that when we go to forums/admin/install_bank.php all we get is a blank page and can't get it installed , and there is zero support for the same problem in the original bank hack thread. NOW , for those of you that actually take time to read what people are saying instead of telling them that they need to read the instructions more carefully , is there anybody that has found a solution to this problem?

xxxsaint
11-27-2003, 03:52 PM
come on guys , surely someone knows the answer to this

Roxie
12-02-2003, 06:28 PM
Sorry. I didn't have this problem. Worked for me.

PixelFx
12-11-2003, 10:00 PM
any idea if this works with store 2.1? and this bank hack? on vb2.3.3?

thanks :) also anyone know if you do intergrated rpg hack 68c if there are any conflicks with points?

xxxsaint
12-12-2003, 12:28 AM
Lots of luck , I've been trying to get help on this thread for ages , and all I got was NADA.

mariannet
01-04-2004, 10:43 PM
Is there a way to track transactions, especially transfers, peopel are funneling funds with dup accounts and i cant track it. also can i allow only a certian percentage of funds to be deposited..

I'm too having problems with dup accounts just to transfer funds without me knowing... please, some help here?

Marzas
04-18-2004, 10:52 AM
how about adding a loan feature to this hack, my members would LOVE that.
And have a set date for when they pay back the bank with intrest, if not, it wont allow them in the store and changes their usertitle?:p