How to make an online shop for my players to buy sovereigns and golds?

[zzm88]

I have experience with Django and python. It's not difficult for me to implement an online shop for people to charge money and get tokens on it.

My question is : when I get successful message of people topping up on my website, how can I give them the sovereigns and golds they purchase? (I am just at the beginning of uo emulator, and it seems the players' information is not in a database.)

 

[Juzzver]

You need to set up a local database and just check for changes using your server.

 

[zzm88]

You need to set up a local database and just check for changes using your server.

Do you mean to use the uo server to check the database's change, if there is any it updates character's data?

 

[Juzzver]

Right.

After the successful method, your web server remotely connect the local database of your PC to record the data and values of purchases.

Players request the database when opening the game store to show their current balance. After any purchases, you compare the value of the currency with the database and record the changes. This will work quickly, because your server will interact with the local database.

 

[zzm88]

Right.

After the successful method, your web server remotely connect the local database of your PC to record the data and values of purchases.

Players request the database when opening the game store to show their current balance. After any purchases, you compare the value of the currency with the database and record the changes. This will work quickly, because your server will interact with the local database.

Thank you so much. I drew a schema of your solution.
Now the problem is how to check in the database and update changes in UO server. Is there any mature solution for it? Or do I have to build this checking and updating function from zero?

 

[Juzzver]

For example you can check how it was realized in MyRunUO system (how to include db drivers and connection data, etc) by RunUO: runuo/Config.cs at master · runuo/runuo
or just just use google: "database connect C#" - most of examples will work for your server.

 

[Voxpire]

The PayPal IPN feature is designed especially for cases like this;
If you listen over http on port 80 with a native .NET HttpListener, you can receive IPN messages and parse them to validate purchases directly within the shard's running process.
If the shard is down and PayPal doesn't receive a response, it will continue to retry until it does.
Using a single reward currency and in-game vendors is a LOT less work than managing all the individual items in the store and their associated server-side components.
You can also use an HttpListener to serve a single page from the shard that lists all the items you can buy from the vendors, but that page doesn't have to be a functional store - just a display window

Core/Modules/AutoDonate/AutoDonate.cs at master · Vita-Nex/Core

A library of advanced features that push the limits of Ultima Online! - Vita-Nex/Core

github.com

 

[zzm88]

Thank you so much guys. I will look at it and post updates here if I have made any progress.