Added new "DATE" datatype which uses the native mysql date format instead o...

tbrehm

2010-04-09 57540eebc0e035f023afef66b3bbc00f315951bf

Added new "DATE" datatype which uses the native mysql date format instead of tstamps in tform library. The old tstamp datatype as been renamed to "DATETSTAMP".

 interface/lib/classes/listform.inc.php

@@ -281,7 +281,17 @@
                        $record[$key] = htmlentities(stripslashes($record[$key]),ENT_QUOTES,$conf["html_content_encoding"]);
                         break;

                    case 'DATE':
                    case 'DATETSTAMP':
                        if ($record[$key] > 0) {
                            // is value int?
                            if (ereg("^[0-9]+[.]?[0-9]*$", $record[$key], $p)) {
                                $record[$key] = date($this->lng('conf_format_dateshort'), $record[$key]);
                            } else {
                                $record[$key] = date($this->lng('conf_format_dateshort'), strtotime($record[$key]));
                            }
                        }
                        break;
                    case 'DATE':
                        if ($record[$key] > 0) {
                            // is value int?
                            if (ereg("^[0-9]+[.]?[0-9]*$", $record[$key], $p)) {
@@ -340,11 +350,17 @@
                        }
                        break;
                    
                    case 'DATE':
                    case 'DATETSTAMP':
                        if($record[$key] > 0) {
                            $record[$key] = date('Y-m-d',strtotime($record[$key]));
                        }
                        break;
					
                    case 'DATE':
                        if($record[$key] != '' && $record[$key] != '0000-00-00') {
                            $record[$key] = $record[$key];
                        }
                        break;

                    case 'DATETIME':
                        if($record[$key] > 0) {

 interface/lib/classes/tform.inc.php

@@ -176,9 +176,16 @@
                                        $new_record[$key] = $record[$key];
                                break;

                                case 'DATE':
                                case 'DATETSTAMP':
                                        if($record[$key] > 0) {
                                                $new_record[$key] = date($this->dateformat,$record[$key]);
                                        }
                                break;
								
                                case 'DATE':
                                        if($record[$key] != '' && $record[$key] != '0000-00-00') {
                                                $tmp = explode('-',$record[$key]);
                                                $new_record[$key] = date($this->dateformat,mktime(0, 0, 0, $tmp[1]  , $tmp[2], $tmp[0]));
                                        }
                                break;

@@ -596,7 +603,7 @@
                                                $new_record[$key] = implode($field['separator'],$record[$key]);
                                        }
                                break;
                                case 'DATE':
                                case 'DATETSTAMP':
                                        if($record[$key] > 0) {
                                                list($tag,$monat,$jahr) = explode('.',$record[$key]);
                                                $new_record[$key] = mktime(0,0,0,$monat,$tag,$jahr);
@@ -604,6 +611,16 @@
                                            $new_record[$key] = 0;
                                        }
                                break;
                                case 'DATE':
                                        if($record[$key] != '' && $record[$key] != '0000-00-00') {
                                                list($tag,$monat,$jahr) = explode('.',$record[$key]);
                                                $new_record[$key] = $jahr.'-'.$monat.'-'.$tag;
                                                //$tmp = strptime($record[$key],$this->dateformat);
                                                //$new_record[$key] = ($tmp['tm_year']+1900).'-'.($tmp['tm_mon']+1).'-'.$tmp['tm_mday'];
                                        } else {
                                            $new_record[$key] = '0000-00-00';
                                        }
                                break;
                                case 'INTEGER':
                                        $new_record[$key] = (isset($record[$key]))?$record[$key]:0;
                                        //if($new_record[$key] != $record[$key]) $new_record[$key] = $field['default'];

 interface/lib/lang/de.lng

@@ -31,4 +31,5 @@
$wb['top_menu_dns'] = 'DNS';
$wb['top_menu_tools'] = 'Tools';
$wb['top_menu_help'] = 'Support';
$wb['top_menu_billing'] = 'Billing';
?>

 interface/lib/lang/en.lng

@@ -31,5 +31,6 @@
$wb['top_menu_dns'] = 'DNS';
$wb['top_menu_tools'] = 'Tools';
$wb['top_menu_help'] = 'Help';
$wb['top_menu_billing'] = 'Billing';
$wb['toolsarea_head_txt'] = 'Tools';
?>