Changeset 206 for branches/awmn/globals/classes/mysql.php

Timestamp:

10/03/2009 02:39:52 PM (3 years ago)

Author:

Acinonyx

Message:

[awmn] Add support for multiple-table deletes

File:

• branches/awmn/globals/classes/mysql.php (modified) (2 diffs)

branches/awmn/globals/classes/mysql.php

@@ -4 +4 @@
  *
  * Copyright (C) 2005 Nikolaos Nikalexis <winner@cube.gr>
+ * Copyright (C) 2009 Vasilis Tsiligiannis <b_tsiligiannis@silverton.gr>
  * 
  * This program is free software; you can redistribute it and/or modify
@@ -173 +174 @@
         }
 
-        function del($table, $where="", $addlog=TRUE) {
+        function del($table, $using="", $where="", $addlog=TRUE) {
                 $table_start = preg_split("/[\s,]+/", $table);
                 $table_start = $table_start[0];
-                if ($addlog && $this->log) $aff = $this->query_data("SELECT ".$table_start.".id FROM $table".($where==""?"":" WHERE $where"));
-                $query = "DELETE FROM $table".($where==""?"":" WHERE $where");
+                if ($addlog && $this->log) $aff = $this->query_data("SELECT ".$table_start.".id FROM ".($using==""?"$table":"$using").($where==""?"":" WHERE $where"));
+                $query = "DELETE FROM $table".($using==""?"":" USING $using").($where==""?"":" WHERE $where");
                 $res = $this->query_data($query);
                 if ($addlog && isset($aff)) {