[Phpcompta-dev] r269 - trunk/coprop/include

[phpcompta-dev]

Author: danydb
Date: 2012-01-08 00:09:44 +0100 (Sun, 08 Jan 2012)
New Revision: 269

Modified:
   trunk/coprop/include/class_copro_key.php
Log:
Key : bug sql


Modified: trunk/coprop/include/class_copro_key.php
===================================================================
--- trunk/coprop/include/class_copro_key.php    2012-01-07 23:01:25 UTC (rev 
268)
+++ trunk/coprop/include/class_copro_key.php    2012-01-07 23:09:44 UTC (rev 
269)
@@ -32,15 +32,15 @@
     {
         global $cn;
         extract ($p_array);
-        if (strlen(trim ($cr_name))==0) 
+        if (strlen(trim ($cr_name))==0)
             throw new Exception("Le nom est vide");
         if ($b_dupl )
         {
-            $dupl=$cn->count_sql("select * from copro.clef_repartition where 
cr_name=$1",$cr_name);
+            $dupl=$cn->count_sql("select * from coprop.clef_repartition where 
cr_name=$1",array($cr_name));
             if ( $dupl >0 )
                 throw new Exception("Une clef avec ce nom existe déja");
         }
-        
+
     }
 
        function insert($p_array)
@@ -52,7 +52,7 @@
                     $this->verify($p_array);
                        $cn->start();
                        $this->cr_id = $cn->get_value("insert into 
coprop.clef_repartition(cr_note,cr_name,cr_tantieme)
-                               values($1,$2) returning cr_id", array( 
strip_tags($cr_note), strip_tags($cr_name),$cr_tantieme));
+                               values($1,$2,$3) returning cr_id", array( 
strip_tags($cr_note), strip_tags($cr_name),$cr_tantieme));
                        for ($i = 0; $i < count($f_id); $i++)
                        {
                                if (${"part" . $f_id[$i]} == '')
@@ -76,7 +76,7 @@
                {
                     $this->verify($p_array,false);
                        $cn->start();
-                       $cn->exec_sql("update coprop.clef_repartition set 
+                       $cn->exec_sql("update coprop.clef_repartition set
                                cr_note=$1,cr_name=$2,cr_tantieme=$3
                                where cr_id=$4",
                                        array( strip_tags($cr_note), 
strip_tags($cr_name),$cr_tantieme,$this->cr_id));