Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > ibProArcade Archive
Reload this Page In the arcade main page, Cost and Jackpot decimal places
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
In the arcade main page, Cost and Jackpot decimal places Details »»
In the arcade main page, Cost and Jackpot decimal places
MOD Information
The Developer
 
Version: , by gooberface gooberface is offline
Developer Last Online: Aug 2012 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 08-22-2006 Last Update: Never Installs: 0
 
No support by the author.

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.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 08-22-2006, 06:28 PM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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)
Reply With Quote
  #3  
Old 08-22-2006, 06:59 PM
gooberface gooberface is offline
 
Join Date: Aug 2006
Posts: 44
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Am I to search for those in the templates or what? I can't find anything with those in them.
Reply With Quote
  #4  
Old 08-22-2006, 07:09 PM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
execute those queries ...
Reply With Quote
  #5  
Old 08-23-2006, 02:33 AM
Nachtfalke Nachtfalke is offline
 
Join Date: Apr 2006
Location: Germany
Posts: 60
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Nice one! But shouldn't it be ALTER tournaments MODIFY cost decimal(30,2) NOT NULL DEFAULT '-1.00' ?
Reply With Quote
  #6  
Old 08-23-2006, 05:14 AM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
no, cost-default is 0 not -1
this is not jackpot
Reply With Quote
  #7  
Old 08-25-2006, 01:30 PM
gooberface gooberface is offline
 
Join Date: Aug 2006
Posts: 44
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #8  
Old 08-25-2006, 01:45 PM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
in the AdminCP in the leftsidew menu at the very bottom there has to be an option "run/execute SQL query" ...
Reply With Quote
  #9  
Old 08-25-2006, 06:22 PM
Stifmeister2 Stifmeister2 is offline
 
Join Date: Feb 2006
Location: Finland
Posts: 755
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 12:45 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06277 seconds
  • Memory Usage 2,271KB
  • Queries Executed 24 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (8)postbit
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete