Exclusive eBooks, Software Solutions, Quality Guaranteed
 
Web NukeBiz
Welcome to NukeBiz · Members
Amazon
show cart or checkout0 items
Cart Value: 0.00

Forums » DragonflyCMS Projects » Storez » [fixed] Direct Deposit details are numeric fields
[fixed] Direct Deposit details are numeric fields
A comprehensive shopping cart solution.
Topic initiation via Bugger.

Post new topic    Reply to topic    Printer Friendly Page     Forum Index »  eCommerce » Storez

View previous topic :: View next topic  
Author Message
layingback
Nice Poster
Nice Poster

Offline Offline
Joined: Feb 26, 2007
Posts: 77

PostPosted: Fri Mar 18, 2011 3:22 pm
Post subject: [fixed] Direct Deposit details are numeric fields

Stores 9.3.6

I'm trying to enable 'Direct Deposit" payment option on an existing store in order to provide a Bank Transfer (B.A.C.S.) payment option in the online store. (Currently it's done via email.)

Essentially it works, but the Sort-Code/Routing number is held as BigInt on DB, so 3-part Sort Codes of the form 99-99-99 get truncated to the first 2 digits only.

Similarly Bank Number which is just branch name in UK is stored as BigInt.

And finally A/c No. is also stored as BigInt when I guess it needs to be stored in text as it must be 8 digits long, so leading zeros can't be dropped.

Can I just change the storage formats in MySQL to text?

Where are the results of the edits processed, please? To check validation. I've been unable to track the right module down for "submit value=Update" from Storez&mode=CartPaymentEdit&payment_id=6

TIA!


layingback's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.2.8/5.1.73/5.4.21/9.4.0
Back to top
View user's profile Visit poster's website
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Sat Mar 19, 2011 5:22 am
Post subject: Re: Direct Deposit details are numeric fields

No doubt the info is in the relevant file under modules/Storez/payments/

_________________
DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
Display posts from previous:   
Post new topic    Reply to topic    Printer Friendly Page    Forum Index »  eCommerce » Storez
Page 1 of 1
All times are GMT + 9.5 Hours



Jump to:  


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum