Accessing A Remote Database

[ezhangin]

I'm new to miva, but would it be possible to access a remote MySQL database sometime during card authorization process? It actually doesn't matter where in the process it is, I'm just actually looking to know if its possible to modify that part of Miva.

[ezhangin]

I would like to know if my above question would require source code access, (I want to instantly update another, separate database, once fulfillment happens) or if I could just write a module.

[wcw]

What are you trying to put in the other database? It is likely you will need a fulfillment module.

[ezhangin]

I am trying to put a counter of sorts in the other database but it doesn't really matter, as long as I can perform an INSERT to the remote MySQL database.

Will I need the Limited Source Kit for this, or can a module be written without it? Even so, how would one trigger something based off of fulfillment?

[ezhangin]

If it helps, I would be collecting some data from the order processed such as item bought or number of items purchased. It's more of a proof of concept but I wish to know if it is feasible.

[wcw]

A fulfillment module runs after the payment is made and before the invoice screen displays. The email modules are fulfillment modules. You would have to be able to access the remote database.

[ezhangin]

Thanks for being helpful.