Hello there,
I've solved this via Discord, but I'll post the solution here so everyone can profit
Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. - Znote/ZnoteAAC
github.com
$update_account = mysql_update("UPDATE
znote_accounts
SET
points
='$new_points' WHERE
account_id
='$cid'");
This is the query that adds points to the database and therefor you can buy items / services on the website.
Now if you run an ingame shop, you might want these points to be added as coins.
In order to do that change the query to:
$update_account = mysql_update("UPDATE
accounts
SET
coins
='$new_points' WHERE
id
='$cid'");
Best Wishes
Okke