| commit | author | age | ||
| 381520 | 1 | <?php |
| M | 2 | |
| 3 | /* | |
| 4 | Copyright (c) 2008, Till Brehm, projektfarm Gmbh | |
| 5 | All rights reserved. | |
| 6 | ||
| 7 | Redistribution and use in source and binary forms, with or without modification, | |
| 8 | are permitted provided that the following conditions are met: | |
| 9 | ||
| 10 | * Redistributions of source code must retain the above copyright notice, | |
| 11 | this list of conditions and the following disclaimer. | |
| 12 | * Redistributions in binary form must reproduce the above copyright notice, | |
| 13 | this list of conditions and the following disclaimer in the documentation | |
| 14 | and/or other materials provided with the distribution. | |
| 15 | * Neither the name of ISPConfig nor the names of its contributors | |
| 16 | may be used to endorse or promote products derived from this software without | |
| 17 | specific prior written permission. | |
| 18 | ||
| 19 | THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND | |
| 20 | ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED | |
| 21 | WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. | |
| 22 | IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, | |
| 23 | INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, | |
| 24 | BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, | |
| 25 | DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY | |
| 26 | OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING | |
| 27 | NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, | |
| 28 | EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. | |
| 29 | */ | |
| 30 | ||
| 31 | /****************************************** | |
| 32 | * Begin Form configuration | |
| 33 | ******************************************/ | |
| 34 | ||
| 35 | $list_def_file = "list/database_user.list.php"; | |
| 36 | $tform_def_file = "form/database_user.tform.php"; | |
| 37 | ||
| 38 | /****************************************** | |
| 39 | * End Form configuration | |
| 40 | ******************************************/ | |
| 41 | ||
| b1a6a5 | 42 | require_once '../../lib/config.inc.php'; |
| MC | 43 | require_once '../../lib/app.inc.php'; |
| 381520 | 44 | |
| M | 45 | //* Check permissions for module |
| 46 | $app->auth->check_module_permissions('sites'); | |
| 47 | ||
| 48 | $app->uses("tform_actions"); | |
| 49 | ||
| 50 | class page_action extends tform_actions { | |
| 51 | function onBeforeDelete() { | |
| 52 | global $app; $conf; | |
| b1a6a5 | 53 | if($app->tform->checkPerm($this->id, 'd') == false) $app->error($app->lng('error_no_delete_permission')); |
| MC | 54 | |
| 55 | $old_record = $app->tform->getDataRecord($this->id); | |
| 56 | ||
| 57 | /* we cannot use datalogDelete here, as we need to set server_id to 0 */ | |
| c7654c | 58 | $app->db->query("DELETE FROM `web_database_user` WHERE `database_user_id` = ?", $this->id); |
| b1a6a5 | 59 | $new_rec = array(); |
| MC | 60 | $old_record['server_id'] = 0; |
| 61 | $app->db->datalogSave('web_database_user', 'DELETE', 'database_user_id', $this->id, $old_record, $new_rec); | |
| 381520 | 62 | } |
| b1a6a5 | 63 | |
| MC | 64 | function onAfterDelete() { // this has to be done on AFTER delete, because we need the db user still in the database when the server plugin processes the datalog |
| 65 | global $app; $conf; | |
| 66 | ||
| 67 | //* Update all records that belog to this user | |
| cc7a82 | 68 | $records = $app->db->queryAllRecords("SELECT database_id FROM web_database WHERE database_user_id = ?", $this->id); |
| b1a6a5 | 69 | foreach($records as $rec) { |
| 3a11d2 | 70 | $app->db->datalogUpdate('web_database', array('database_user_id' => null), 'database_id', $rec['database_id']); |
| b1a6a5 | 71 | |
| MC | 72 | } |
| cc7a82 | 73 | $records = $app->db->queryAllRecords("SELECT database_id FROM web_database WHERE database_ro_user_id = ?", $this->id); |
| b1a6a5 | 74 | foreach($records as $rec) { |
| 3a11d2 | 75 | $app->db->datalogUpdate('web_database', array('database_ro_user_id' => null), 'database_id', $rec['database_id']); |
| b1a6a5 | 76 | } |
| MC | 77 | } |
| 78 | ||
| 381520 | 79 | } |
| M | 80 | |
| 81 | $page = new page_action; | |
| 82 | $page->onDelete(); | |
| 83 | ||
| b1a6a5 | 84 | ?> |
