Changeset 7424 for temp/trunk

Timestamp:

2006/11/06 09:54:45 (20 years ago)

Author:

kakinaka

Message:

* empty log message *

Location:

temp/trunk/data

Files:

• downloads/module/mdl_epsilon.php (modified) (2 diffs)
• include/module.inc (modified) (previous)
• lib/slib.php (modified) (1 diff)

temp/trunk/data/downloads/module/mdl_epsilon.php

@@ -61 +61 @@
     if(count($objPage->arrErr) == 0) {
         
+        // ÈÆÍѹàÌܤòÄɲÃ
+        sfAlterMemo();
+        
         // ÍøÍÑ¥³¥ó¥Ó¥Ë¤Ë¥Á¥§¥Ã¥¯¤¬Æþ¤Ã¤Æ¤¤¤ë¾ì¹ç¤Ë¤Ï¡¢¥Ï¥¤¥Õ¥ó¶èÀÚ¤ê¤ËÊÔ½¸¤¹¤ë
         $convCnt = count($_POST["convenience"]);
@@ -70 +73 @@
         }
         
-        sfprintr($convenience);
+        // DEL/INS¤ÇÅÐÏ¿¤¹¤ë¡£
+        $delsql = "DELETE FROM dtb_payment";
         
+    
         // javascript¼Â¹Ô
         //$objPage->tpl_onload = "window.close();";

temp/trunk/data/lib/slib.php

@@ -69 +69 @@
                         relname";
             $arrRet = $objQuery->getAll($sql, array($table_name));
+            if(count($arrRet) > 0) {
+                return true;
+            }
+        }else if ($db_type == "mysql") {
+            $sql = "SHOW TABLE STATUS LIKE ?";
+            $arrRet = $objQuery->getAll($sql, array($table_name));
+            if(count($arrRet) > 0) {
+                return true;
+            }
+        }
+    }
+    return false;
+}
+
+// ¥«¥é¥à¤Î¸ºß¥Á¥§¥Ã¥¯
+function sfColumnExists($table_name, $col_name, $dsn = "") {
+    if($dsn == "") {
+        if(defined('DEFAULT_DSN')) {
+            $dsn = DEFAULT_DSN;
+        } else {
+            return;
+        }
+    }
+    
+    $objQuery = new SC_Query($dsn, true, true);
+    // Àµ¾ï¤ËÀܳ¤µ¤ì¤Æ¤¤¤ë¾ì¹ç
+    if(!$objQuery->isError()) {
+        list($db_type) = split(":", $dsn);
+        // postgresql¤Èmysql¤È¤Ç½èÍý¤òʬ¤±¤ë
+        if ($db_type == "pgsql") {
+            $sql = "SELECT
+                        a.attname
+                    FROM
+                        pg_class c, pg_attribute a
+                    WHERE
+                        c.relname=? AND
+                        a.attname=? AND
+                        c.oid=a.attrelid AND
+                        a.attnum > 0
+                    ORDER BY
+                        a.attnum";
+            $arrRet = $objQuery->getAll($sql, array($table_name, $col_name));
             if(count($arrRet) > 0) {
                 return true;