Beispiel #1
0
/**
 * Update data source
 */
function sumo_update_datasource_data($data = array())
{
    if (!empty($data)) {
        global $SUMO;
        $query = "UPDATE " . SUMO_TABLE_DATASOURCES . " \n\t\t\t\tSET\n\t\t\t  \tname='" . $data['name'] . "', \n\t\t\t  \ttype='" . $data['type'] . "', \n\t\t\t  \thost='" . $data['host'] . "',\n\t\t\t  \tport=" . $data['port'] . ",\n\t\t\t  \tusername='******'username'] . "',\n\t\t\t  \tpassword='******'password'] . "',\n\t\t\t  \tdb_name='" . $data['db_name'] . "',\n\t\t\t  \tdb_table='" . $data['db_table'] . "',\n\t\t\t  \tdb_field_user='******'db_field_user'] . "',\n\t\t\t  \tdb_field_password='******'db_field_password'] . "',\n\t\t\t  \tenctype='" . $data['enctype'] . "',\n\t\t\t  \tldap_base='" . $data['ldap_base'] . "'\n\t\t\t  WHERE id=" . $data['id'] . " AND id<>1";
        $SUMO['DB']->Execute($query);
        // if data source updated
        if (sumo_verify_datasource_exist('id', $data['id'])) {
            sumo_write_log('I09006X', array($data['id'], $data['name'], $SUMO['user']['user']), 3, 3, 'system', FALSE);
            return TRUE;
        } else {
            return FALSE;
        }
    } else {
        return FALSE;
    }
}
 * @version    0.4.2
 * @link       http://sumoam.sourceforge.net SUMO Access Manager
 * @author     Alberto Basso <*****@*****.**>
 * @copyright  Copyright &copy; 2003-2009, Alberto Basso
 * @package    SUMO
 * @category   Console
 */
// Patch for MySQLUsers
if (strtolower($_POST['host'] == 'localhost')) {
    $_POST['host'] = '127.0.0.1';
}
$data = array(array('dsname', $_POST['name'], 1), array('type', $_POST['type'], 1), array('hostname', $_POST['host']), array('port', $_POST['port']), array('username', $_POST['username']), array('password', $_POST['password']), array('db_name', $_POST['db_name']), array('db_table', $_POST['db_table']), array('enctype', $_POST['enctype']), array('username', $_POST['db_field_user']), array('password', $_POST['db_field_password']), array('enctype', $_POST['enctype']), array('ldap_base', $_POST['ldap_base']));
$validate = sumo_validate_data_network($data, TRUE);
if ($validate[0]) {
    // verify if datasource already exist
    if (sumo_verify_datasource_exist('name', $_POST['name'])) {
        $validate = array(FALSE, sumo_get_message('I09002C', $_POST['name']));
    }
    $ds = sumo_get_available_datasources(true);
    // MySQL / MySQLUsers / Postgres / Oracle / Joomla
    if (in_array($_POST['type'], $ds) && (!$_POST['db_name'] || !$_POST['db_table'] || !$_POST['db_field_user'] || !$_POST['db_field_password'])) {
        $validate = array(FALSE, sumo_get_message('I09004C', $_POST['db_name']));
    }
    // LDAP/LDAPS
    if (($_POST['type'] == 'LDAP' || $_POST['type'] == 'LDAPS' || $_POST['type'] == 'ADAM') && !$_POST['ldap_base']) {
        $validate = array(FALSE, sumo_get_message('I09005C'));
    }
}
if (!$validate[0]) {
    $tpl['MESSAGE:H'] = sumo_get_message('DataSourceNotAdded', $_POST['name']) . ":<br>" . $validate[1];
} else {