Changeset 25

Timestamp:

Dec 26, 2018, 11:13:00 PM (6 years ago)

Author:

chronos

Message:

• Modified: Keep Age, Height and Weight values in database as int type.

Location:

trunk

Files:

• Meet.php (modified) (1 diff)
• SQL/Update.php (modified) (1 diff)

trunk/Meet.php

@@ -350 +350 @@
     if ($DbResult->num_rows == 0)
     {
+      if ($this->Age == '') $Age = null; 
+        else $Age = $this->Age;
+      if ($this->Height == '') $Height = null; 
+        else $Height = $this->Height;
+      if ($this->Weight == '') $Weight = null; 
+        else $Weight = $this->Weight;
       $this->Database->insert('MeetItem', array(
         'Message' => $this->Message,
         'Date' => TimeToMysqlDate($this->Date),
         'Gender' => $this->Gender,
-        'Age' => $this->Age,
+        'Age' => $Age,
         'Email' => $this->Email,
         'Phone' => $this->Phone,
         'Name' => $this->Name,
-        'Height' => $this->Height,
-        'Weight' => $this->Weight,
+        'Height' => $Height,
+        'Weight' => $Weight,
         'Location' => $this->Location,
         'Source' => $this->Source,

trunk/SQL/Update.php

@@ -1 +1 @@
 ALTER TABLE `MeetItem` ADD `Link` VARCHAR(255) NOT NULL AFTER `Location`;
 
+ALTER TABLE `MeetItem` CHANGE `Age` `Age` INT NULL DEFAULT NULL;
+UPDATE `MeetItem` SET `Age`=NULL WHERE `Age`=0;
+ALTER TABLE `MeetItem` CHANGE `Height` `Height` INT NULL DEFAULT NULL;
+UPDATE `MeetItem` SET `Height`=NULL WHERE `Height`=0;
+ALTER TABLE `MeetItem` CHANGE `Weight` `Weight` INT NULL DEFAULT NULL;
+UPDATE `MeetItem` SET `Weight`=NULL WHERE `Weight`=0;