My server is using the Tibia coins Store and when one bought coins, they did not end up in his account, instead the coins became points in the Znote_accounts. Is there a way to switch it around somehow? So that the coins get transferred into the Accounts instead?
-
2026 staff recruitment is open! Check it out and consider applying!
Tibia coins Store help
- Thread starter tommy91
- Start date
Solution
Hello there,
I've solved this via Discord, but I'll post the solution here so everyone can profit
github.com
$update_account = mysql_update("UPDATE
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
Best Wishes
Okke
I've solved this via Discord, but I'll post the solution here so everyone can profit
ZnoteAAC/shop.php at a00dbcfabd4c68eed0568f156c5de05e97c18aa0 · Znote/ZnoteAAC
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
Hello there,
I've solved this via Discord, but I'll post the solution here so everyone can profit
github.com
$update_account = mysql_update("UPDATE
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
Best Wishes
Okke
I've solved this via Discord, but I'll post the solution here so everyone can profit
ZnoteAAC/shop.php at a00dbcfabd4c68eed0568f156c5de05e97c18aa0 · Znote/ZnoteAAC
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