Starting Escrow Script ??

[umbika]

Hi,

I would like to write a script for establishing an escrow system but I have no idea for how should be structure of database table. In this system, users can send money to "escrow system" through any kind of payment gateways (a user database table and payment gateway scripts are already available). There are 3 parties in transactions, a buyer, a seller and an escrow account. And system should work as folowings:
- Buyer send payment to escrow account. And when payment confirmed by escrow mods/admins emails should be sent to buyer and seller
- Seller send the item to buyer. When he/she sends the item, emails should be sent to buyer and escrow account.
- If buyer gives confirmation when he/she receives the item without any problem, money from the escrow account should be transferred to seller. If buyer does not give a confirmation in a certain period or gives negative comments system should work to backwards ..Confirmation info should be em -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --