webOffice_alt/ajax.php

<?php
// AJAX handling

// Includes
include('includes/config.inc.php');
include('includes/database.inc.php');
include('includes/functions.inc.php');
include('includes/document.inc.php');
include('includes/label.inc.php');
include('includes/imap.inc.php');
include('includes/mailboxfolder.inc.php');

$db = new Database($CONFIG['dbHost'], $CONFIG['dbUser'], $CONFIG['dbPassword'], $CONFIG['dbDatabase']);

switch($_POST['action']) {
    case 'updateMailaccounts':
        switch($_POST['name']) {
            case 'hostname':
                header("Status: 200 OK");
                $db->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=;")
        echo 'updateMailaccounts';
        break;
    case 'addDefaultMailaccount':
        header("Status: 200 OK");
        $db->insertQuery("INSERT INTO `mailboxes` (`user_id`) VALUES (" . $_POST['user-id'] . ");");
        break;
    case 'removeMailaccount':
        header("Status: 200 OK");
        $db->removeQuery("DELETE FROM `mailboxes` WHERE `id` = " . $_POST['id'] . ";");
        break;
    default:
        header("Status: 400 No Action Defined");
        echo 'error';
        break;
}

pa($_POST); // Debug

?>