X-Git-Url: http://git.dj3c1t.com/?a=blobdiff_plain;f=app%2Fdata%2Fmodules%2Fsql%2Fsml_data_source_groupes.php;h=45d07b15a736044ed4bb996780845d2b6340e507;hb=ce50b139cfeb948f0a773ccd7bd7d6a800b06692;hp=44dec362116c7ad173610f48d41ea7bbc8d70884;hpb=2802d2dbcb5a1ea3c269d6fb4df9fbfb0f13f93d;p=mw_sourceml

diff --git a/app/data/modules/sql/sml_data_source_groupes.php b/app/data/modules/sql/sml_data_source_groupes.php
index 44dec36..45d07b1 100644
--- a/app/data/modules/sql/sml_data_source_groupes.php
+++ b/app/data/modules/sql/sml_data_source_groupes.php
@@ -96,6 +96,22 @@
       return $sources;
     }
 
+    function source_has_groupe($id_source, $id_groupe){
+      $sgbd = $this->sgbd();
+      $HAS_THIS_GROUP = 0;
+      try{
+        $sql =
+         "SELECT count(*) as n FROM #--sml_sources_authors"
+        ." WHERE id_source=".$this->eq($id_source)
+        ." AND id_author=".$this->eq($id_groupe);
+        $rst = $sgbd->query($sql);
+        if($v_rst = $sgbd->fetch_assoc($rst)) $HAS_THIS_GROUP = $v_rst["n"];
+        $sgbd->free_result($rst);
+      }
+      catch(Exception $e) { $HAS_THIS_GROUP = false; }
+      return $HAS_THIS_GROUP;
+    }
+
     function add_source_groupe($id_source, $id_groupe, $id_groupe_status)
     { $sgbd = $this->sgbd();
       try{
@@ -137,10 +153,13 @@
       return true;
     }
 
-    function del_source_groupe($id)
-    { $sgbd = $this->sgbd();
+    function del_source_groupe($id_source, $id_author){
+      $sgbd = $this->sgbd();
       try{
-        $sql = "DELETE FROM #--sml_sources_authors WHERE id=".$this->eq($id);
+        $sql =
+         "DELETE FROM #--sml_sources_authors"
+        ." WHERE id_source=".$this->eq($id_source)
+        ." AND id_author=".$this->eq($id_author);
         $sgbd->query($sql);
       }
       catch(Exception $e) { return false; }