In the arcade main page, Cost and Jackpot decimal places

[gooberface]

Is there anyway to change the amount of decimal places showing in the "cost" and "jackpot" parts in the arcade on each game? I have my store and points showing 2 decimal places, but the arcade is displaying 5 or 6. Is there anyway to adjust that? Thanks guys.

[MrZeropage]

run the following queries:

ALTER games_list MODIFY jackpot decimal(30,2) NOT NULL DEFAULT '0.00'
ALTER games_list MODIFY jackpot_type decimal(30,2) NOT NULL DEFAULT '0.00'
ALTER games_list MODIFY cost decimal(30,2) NOT NULL DEFAULT '0.00'
ALTER tournaments MODIFY cost decimal(30,2) NOT NULL DEFAULT '0.00'

this should help (untested)

[gooberface]

Am I to search for those in the templates or what? I can't find anything with those in them.

[MrZeropage]

execute those queries ...

[Nachtfalke]

Nice one! But shouldn't it be ALTER tournaments MODIFY cost decimal(30,2) NOT NULL DEFAULT '-1.00' ?

[MrZeropage]

no, cost-default is 0 not -1
this is not jackpot :)

[gooberface]

I don't understand what "execute those queries" or "run these queries" means. Where should I go in my control panel to find this option? And thanks for breaking it down so basically for me. I'm not very experienced with programming and code and all this.

[MrZeropage]

in the AdminCP in the leftsidew menu at the very bottom there has to be an option "run/execute SQL query" ...

[Stifmeister2]

in the AdminCP in the leftsidew menu at the very bottom there has to be an option "run/execute SQL query" ...
Yes and he has to set the permision to execute SQL queries in config.php. ;)