vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)
-   -   In the arcade main page, Cost and Jackpot decimal places (https://vborg.vbsupport.ru/showthread.php?t=124646)

gooberface 08-22-2006 03:39 PM

In the arcade main page, Cost and Jackpot decimal places
 
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 08-22-2006 06:28 PM

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 08-22-2006 06:59 PM

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

MrZeropage 08-22-2006 07:09 PM

execute those queries ...

Nachtfalke 08-23-2006 02:33 AM

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

MrZeropage 08-23-2006 05:14 AM

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

gooberface 08-25-2006 01:30 PM

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 08-25-2006 01:45 PM

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

Stifmeister2 08-25-2006 06:22 PM

Quote:

Originally Posted by MrZeropage
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. ;)


All times are GMT. The time now is 06:59 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01009 seconds
  • Memory Usage 1,719KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete