FirstSpot integration with payment systems

[asddsa]

I am thinking about integration of FirstSpot billing with payment system so that users could pay for hotspot services through terminals. XML queries over HTTP are used during transaction.


....................................................SQL queries
[FirstSpot]<>[MySQL or MS SQL] <====> [Transaction server]

................................................................. | XML over HTTP
.................................................................[Payment system]

i.e. transaction server works directly with database.
Is the above scenario right?

[alan]

Please check out chapter 7 -> User Defined Payment section of firstspot_guide.pdf for a guideline.
_________________
~ Patronsoft Limited ~

[asddsa]

In User Defined Payment section the process flow is as follows:

1. Payment system web-interface
2. Enter credit card data
3. Money added to user balance

But in my case the flow will be:

1. User adds money through payment terminal, not web-interface.
Payment must be based on unique ID for each registered user.

2. Transaction registered in payment system database.

3. After information about transaction transferred to our local transaction
server as XML query.

4. Balance of user with particular ID updated in database with SQL code.

[alan]

Sorry, my mistake. In that case, you don't need to use the credit card "User Defined Payment" option.

And yes, you need to update table fsusr directly (refer to chapter 5 of firstspot_guide.pdf for more informaiton). One thing to remind you is that you should update the user attributes when he is offline (check the "reserved1" field, again see firstspot_guide.pdf).
_________________
~ Patronsoft Limited ~