View Single Post
  #616  
Old 07-18-2007, 01:45 PM
webgod webgod is offline
 
Join Date: Sep 2002
Posts: 42
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by burntire View Post
Place a zero in front of the time 09.99 and it will work.

Something in the code needs changed, but I can't figure it out.

it's the database.

in the XMLfile all database fields in the userfield table are set to mediumtext as the data type... And as the name implies, it's a text field.

Text fields and numerical fields are sorted in a slightly different manner.

The Quarter Mile ET is Field55 in the userfield table. If you have access to the database, change the field type from mediumtext to type: Decimal Length/Set: 5,3 (this will allow a range of 00.000 to 99.999 to be entered)

obviously back up the table first, before doing any operation on it.

you should do this for all numerical entry fields ... they should should NOT be text data types, especially when doing any type of sorting or calculations. as in Site Averages!

Also, because you are converting the data type at the Database level, and not restricting the user to enter only numerical data on the front end... (I haven't tested it.. but) the user will likely get a database error when entering data in the 14 field that is not between 00.000 & 99.999.

The way around this is in the AdminCP under User Profile Fields->"" Manager -> Find and click edit for the 1/4 Mile ET field. in the Regular Expression Box enter ^\d+(?:\.\d{0,3})?$ in the description box append this: (numbers ONLY, up to three decimal places)

and you're all set for 1/4 mile ET, you will have to repeat similar steps for all other numerical fields



if there is any interest and with the permission of the author, I could rewrite the XML file to incorporate the data tyoe changes and the RegEx changes, along with any other need "enhancements"
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01372 seconds
  • Memory Usage 1,765KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete