Adding Tibia Coins to an account

[dartedd450]

10.98 server, how do I add/modify the amount of Tibia couns on an account?

 

[Forrest]

10.98 server, how do I add/modify the amount of Tibia couns on an account?

You have to add this to the database.

ALTER TABLE `accounts` ADD `coins` INT UNSIGNED NOT NULL DEFAULT 0,

This is just to store the coins if the server you are using does not have support for the shop then you need to use one which does. I don't know if TFS currently has support for the ingame store.

 

[dartedd450]

Yes my server supports Tibiacoins. Able to open the shop and browse it properly, just unsure on how to manually add them

You have to add this to the database.

ALTER TABLE `accounts` ADD `coins` INT UNSIGNED NOT NULL DEFAULT 0,

This is just to store the coins if the server you are using does not have support for the shop then you need to use one which does. I don't know if TFS currently has support for the ingame store.

Error
SQL query:


ALTER TABLE `accounts` ADD `coins` INT UNSIGNED NOT NULL DEFAULT 0,



MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1