protected function deleteUpload($uid) { $additionalQuerys = $this->deleteQuerysCreateAdditional($uid); TableMng::getDb()->autocommit(false); TableMng::queryMultiple("DELETE FROM SystemUsers WHERE ID = {$uid};\n\t\t\t{$additionalQuerys}\n\t\t\t"); TableMng::getDb()->autocommit(true); }
/** * Removes a Message from the Database by the ID given * * It also removes the links to this Message in the Tables * MessageReceivers and MessageManagers. * * @param int $id the ID of the message to remove */ protected function messageDeleteFromDb($id) { try { TableMng::getDb()->autocommit(false); $query = sprintf('DELETE FROM MessageMessages WHERE `ID` = %s; DELETE FROM MessageReceivers WHERE `messageId` = %s; DELETE FROM MessageManagers WHERE `messageId` = %s;', $id, $id, $id); TableMng::queryMultiple($query); TableMng::getDb()->autocommit(true); } catch (Exception $e) { $this->_interface->dieError('Konnte die Nachricht nicht löschen!'); } }
/** * Changes a Group based on the given data */ protected function groupsChange() { $query = ''; $changeCounter = 0; if (isset($_POST['data'])) { foreach ($_POST['data'] as &$data) { TableMng::sqlEscape($data); } $query = $this->groupsChangeQuery($_POST['data']); } else { die(json_encode(array('value' => 'error', 'message' => 'No data given!'))); } try { TableMng::getDb()->autocommit(false); TableMng::queryMultiple($query); TableMng::getDb()->autocommit(true); } catch (Exception $e) { die(json_encode(array('value' => 'error', 'message' => 'Konnte die Query nicht ausführen!'))); } die(json_encode(array('value' => 'success', 'message' => 'Die Gruppen wurden erfolgreich geändert!'))); }
/** * Deletes the Message with the Id $messageId * Also deletes all entries in the tables MessageReceivers and * MessageManagers that are linked to this Message * @param id $messageId the message to delete * @throws Exception if somethings gone wrong */ public static function deleteMessage($messageId) { $db = TableMng::getDb(); $db->autocommit(false); $query = sprintf('DELETE FROM MessageMessages WHERE `ID` = %s; DELETE FROM MessageReceivers WHERE `messageId` = %s; DELETE FROM MessageManagers WHERE `messageId` = %s;', $messageId, $messageId, $messageId); TableMng::queryMultiple($query); $db->autocommit(true); }
/** * Pushes the given data to the Database * * @param Array $data An Array with the changed TimeModification-Strings */ protected function changeDataToDb($data) { try { TableMng::queryMultiple("UPDATE SystemGlobalSettings\n\t\t\t\t\tSET value = '{$data['displayMealsStartdate']}'\n\t\t\t\t\tWHERE name = 'displayMealsStartdate';\n\t\t\t\tUPDATE SystemGlobalSettings\n\t\t\t\t\tSET value = '{$data['displayMealsEnddate']}'\n\t\t\t\t\tWHERE name = 'displayMealsEnddate';\n\t\t\t\tUPDATE SystemGlobalSettings\n\t\t\t\t\tSET value = '{$data['orderEnddate']}'\n\t\t\t\t\tWHERE name = 'orderEnddate';\n\t\t\t\tUPDATE SystemGlobalSettings\n\t\t\t\t\tSET value = '{$data['ordercancelEnddate']}'\n\t\t\t\t\tWHERE name = 'ordercancelEnddate';"); } catch (Exception $e) { $this->_interface->dieError('Konnte die Daten nicht verändern!' . $e->getMessage()); } }
/** * Adds a new group to the DatabaseTable * * Requirement: the Parent has childs * * @param String $name The name of the new Group * @param String $parentName The name of the parent-Group * @todo if multiple parents with this name exist, problem! */ protected static function groupAddToNodeWithChildren($name, $parentName) { TableMng::getDb()->autocommit(false); TableMng::queryMultiple("SELECT @myRight := rgt FROM SystemGroups\n\t\t\tWHERE name = '{$parentName}';\n\t\t\tUPDATE SystemGroups SET rgt = rgt + 2 WHERE rgt >= @myRight;\n\t\t\tUPDATE SystemGroups SET lft = lft + 2 WHERE lft >= @myRight;\n\t\t\tINSERT INTO SystemGroups(name, lft, rgt) VALUES('{$name}',\n\t\t\t\t\t\t\t@myRight, @myRight + 1);\n\t\t\t"); TableMng::getDb()->autocommit(true); }