I got a huge local database (s3db) of diablo 2 items, that daily gets filled with new items and stock.
That database contains the item name, stats, image, stock and realm (diablo 2 server).
What I wish to get to done is a way with that image files will get created and synchronized of current item stock.
Those images that I wish to separate into different categories (to not have the image get too large), I wish to post on the [login to view URL] forum.
Once a user pays with the forum gold (virtual currency) of [login to view URL] to my profile account, and added the realm, core, unique item code (that we will need to identify the item), quantity, game and password the item should get dropped into his game.
To track the transaction, my profile needs to be logged in. Either could do that by keeping a browser tab open, or performing such connection in background.
To drop the item an action can be performed via the web interface of my database (preferable that action should be performed directly within the database)
In case that there is any issue, such as the game doesnt exist, password wrong or what ever, the user should get pmd about the issue and I need to get notified about it.
To repeat such transaction with a new game name and password the user should get notified For example:
There is an error. Your Game does not exist. Please reply here:
REPEAT order XZ7R5WQ9A realm/core/unique item code/quantity/game/password
This is a general idea and features might had been missed to write here. Important is to get the whole process be done, with any possible error handlings.
Please let me know if you have more detailed questions about it.