Changeset 7086

Timestamp:

11/26/08 01:59:51 (6 weeks ago)

Author:

daybreaker

Message:

refs #1131:

• mysql의 timestamp가 요구하는 기본값을 index.xml의 storage 스키마에 기술할 수 없는 관계로 int 필드로 수정
  

Location:

trunk/plugins/GoogleMap

Files:

• index.php (modified) (2 diffs)
• index.xml (modified) (1 diff)

trunk/plugins/GoogleMap/index.php

@@ -167 +167 @@
                         $lat = $response_csv[2];
                         $lng = $response_csv[3];
-                        POD::execute("INSERT INTO {$database['prefix']}GMapLocations VALUES (".getBlogId().", '".POD::escapeString($locative['location'])."', $lng, $lat, NOW())");
+                        POD::execute("INSERT INTO {$database['prefix']}GMapLocations VALUES (".getBlogId().", '".POD::escapeString($locative['location'])."', $lng, $lat, ".time().")");
                         $result = 0;
                         break;
@@ -183 +183 @@
             if ($result == 9) {
                 // Not found. Don't try also later.
-                POD::execute("INSERT INTO {$database['prefix']}GMapLocations VALUES (".getBlogId().", '".POD::escapeString($locative['location'])."', NULL, NULL, NOW())");
+                POD::execute("INSERT INTO {$database['prefix']}GMapLocations VALUES (".getBlogId().", '".POD::escapeString($locative['location'])."', NULL, NULL, ".time().")");
             }
         } else {

trunk/plugins/GoogleMap/index.xml

@@ -71 +71 @@
         <field><name>longitude</name><attribute>double</attribute><isnull>1</isnull></field>
         <field><name>latitude</name><attribute>double</attribute><isnull>1</isnull></field>
-        <field><name>updated</name><attribute>timestamp</attribute><isnull>0</isnull><default>0</default></field>
+        <field><name>updated</name><attribute>int</attribute><length>11</length><isnull>0</isnull><default>0</default></field>
       </fields>
       <key>address</key>