updateQuery("UPDATE `mailboxes` SET `server`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";"); break; case 'port': header("Status: 200 OK"); $db->updateQuery("UPDATE `mailboxes` SET `port`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";"); break; case 'protocol': header("Status: 200 OK"); $db->updateQuery("UPDATE `mailboxes` SET `protocol`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";"); break; case 'use-ssl': header("Status: 200 OK"); $db->updateQuery("UPDATE `mailboxes` SET `use_ssl`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";"); break; case 'no-valid-cert': header("Status: 200 OK"); $db->updateQuery("UPDATE `mailboxes` SET `valid_ssl`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";"); break; case 'username': header("Status: 200 OK"); $db->updateQuery("UPDATE `mailboxes` SET `username`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";"); break; case 'password': header("Status: 200 OK"); $db->updateQuery("UPDATE `mailboxes` SET `password`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";"); break; default: header("Status: 400 Wrong Field"); echo 'error'; break; } //$db->updateQuery("UPDATE `mailboxes` SET x=y WHERE id=;") break; case 'updateMailfolder': switch($_POST['name']) { case 'mailaccount': header("Status: 200 OK"); $db->updateQuery("UPDATE `mailbox-folders` SET `mailbox_id`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";"); break; case 'mailfolder': header("Status: 200 OK"); $db->updateQuery("UPDATE `mailbox-folders` SET `folder_name`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";"); break; default: header("Status: 400 Wrong Field"); echo 'error'; break; } break; case 'addDefaultMailaccount': header("Status: 200 OK"); $db->insertQuery("INSERT INTO `mailboxes` (`user_id`) VALUES (" . $_POST['user-id'] . ");"); break; case 'addDefaultMailfolder': header("Status: 200 OK"); $db->insertQuery("INSERT INTO `mailbox-folders` (`label_id`) VALUES (" . $_POST['label-id'] . ");"); break; case 'removeMailaccount': header("Status: 200 OK"); $db->removeQuery("DELETE FROM `mailboxes` WHERE `id` = " . $_POST['id'] . ";"); break; case 'manageMailboxFolder': header("Status: 200 OK"); $boxHtml = 'Account: '; $boxHtml .= getEditableLink('mailaccount', 'select', $_GET['mfId'], 'Click to change', getMailboxNameFromMailaccountId($_GET['mbId'])); $boxHtml .= '
Folder: '; $boxHtml .= getEditableLink('mailfolder', 'text', $_GET['mfId'], 'Click to change', getMailboxFolderNameFromId($_GET['mfId'])); // TODO: make this select-box echo $boxHtml; break; case 'getMailAccountsByUid': header("Status: 200 OK"); $mailboxes = getMailboxesByUserId($_REQUEST['uId'], false); $mbArray = array(); foreach($mailboxes as $mailbox) { $mbArray[$mailbox->getId()] = $mailbox->getUsername(); } $jsonOut = json_encode($mbArray); echo $jsonOut; break; default: header("Status: 400 No Action Defined"); echo 'error'; break; } //pa($_POST); // Debug ?>