Changeset 206 for branches/awmn/includes/pages/mynodes/mynodes.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/includes/pages/mynodes/mynodes.php (modified) (10 diffs)

branches/awmn/includes/pages/mynodes/mynodes.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
@@ -330 +331 @@
                 $this->tpl['node'] = get('node');
                 if (get('action') == 'delete') {
-                        if ($db->del('nodes', "id = ".intval(get('node')))) { 
+                        if ($db->del('nodes', '', "id = ".intval(get('node')))) { 
                                 $main->message->set_fromlang('info', 'delete_success', makelink());
                         } else {
@@ -419 +420 @@
                         $ret = $ret && $form_node->db_set_multi(array(), "users_nodes", "node_id", $ins_id);
                         if ($_POST['user_id_owner'] != '') {
-                                $ret = $ret && $db->del('users_nodes', "user_id = '".$_POST['user_id_owner']."' AND node_id = '".$ins_id."'");
+                                $ret = $ret && $db->del('users_nodes', '', "user_id = '".$_POST['user_id_owner']."' AND node_id = '".$ins_id."'");
                                 $ret = $ret && $db->add('users_nodes', array("user_id" => $_POST['user_id_owner'], "node_id" => $ins_id, 'owner' => 'Y'));
                         }
@@ -476 +477 @@
                 $ret = TRUE;
                 foreach( (array) $_POST['id'] as $key => $value) {
-                        $ret = $ret && $db->del("links", "id = '".$value."'");
+                        $ret = $ret && $db->del("links", '', "id = '".$value."'");
                 }
                 if ($ret) {
@@ -489 +490 @@
                 $ret = TRUE;
                 foreach( (array) $_POST['id'] as $key => $value) {
-                        $ret = $ret && $db->del("links", "id = '".$value."'");
+                        $ret = $ret && $db->del("links", '', "id = '".$value."'");
                 }
                 if ($ret) {
@@ -502 +503 @@
                 $ret = TRUE;
                 foreach( (array) $_POST['id'] as $key => $value) {
-                        $ret = $ret && $db->del("subnets", "id = '".$value."'");
+                        $ret = $ret && $db->del("subnets", '', "id = '".$value."'");
                 }
                 if ($ret) {
@@ -515 +516 @@
                 $ret = TRUE;
                 foreach( (array) $_POST['id'] as $key => $value) {
-                        $ret = $ret && $db->del("ip_addresses", "id = '".$value."'");
+                        $ret = $ret && $db->del("ip_addresses", '', "id = '".$value."'");
                 }
                 if ($ret) {
@@ -528 +529 @@
                 $ret = TRUE;
                 foreach( (array) $_POST['id'] as $key => $value) {
-                        $ret = $ret && $db->del("nodes_services", "id = '".$value."'");
+                        $ret = $ret && $db->del("nodes_services", '', "id = '".$value."'");
                 }
                 if ($ret) {
@@ -541 +542 @@
                 if (isset($_POST['id'])) {
                         foreach( (array) $_POST['id'] as $key => $value) {
-                                $db->del("photos", "id = '".$value."'");
+                                $db->del("photos", '', "id = '".$value."'");
                                 $uploaddir = $vars['folders']['photos'];
                                 $filename = 'photo-'.$value.".*";
@@ -558 +559 @@
                                 $filename_s = 'photo-'.$ins_id.'-s.jpg';
                                 if (@move_uploaded_file($_FILES[$value]['tmp_name'], ROOT_PATH.$uploaddir.$filename) === FALSE) {
-                                        $db->del("photos", "id = '".$ins_id."'");
+                                        $db->del("photos", '', "id = '".$ins_id."'");
                                         $main->message->set_fromlang("error", "upload_file_failed");
                                         return;