<?php

class FTP_Accounts
{
    public static function checkLoginSyntax($login)
    {
        if (!preg_match('/^[a-z0-9._-]+@[a-z0-9._-]+$/', $login))
            return false;

        return true;
    }

    public function add($login, $password, $path='', $quota='')
    {
        if (!FTP_Accounts::checkLoginSyntax($login))
            return false;

        $exist = DB::aQuery('SELECT COUNT(*) FROM ftp_accounts WHERE login="'.DB::esc($login).'";');
        if (!empty($exist[0][0]))
            return false;

        if (strpos($path, '..') === true)
            $path = '';

        $path = ALTERNZ_BASE_PATH.Users::get('login').'/'.$path;

        if (empty($quota))
            $quota = 10;

        DB::uQuery('INSERT INTO ftp_accounts (uid, login, password, path, quota_size) VALUES
            ("'.Users::get('uid').'", "'.DB::esc($login).'", "'.DB::esc($password).'", "'.DB::esc($path).'", "'.(int)$quota.'");');

        return true;
    }

    public function getList()
    {
        $list = DB::aQuery('SELECT * FROM ftp_accounts WHERE uid="'.Users::get('uid').'";');

        foreach ($list as $key=>$row)
        {
            $list[$key]['path'] = str_replace(ALTERNZ_BASE_PATH.Users::get('login'), '', $row['path']);
        }

        return $list;
    }

    public function delete($login)
    {
        if (!FTP_Accounts::checkLoginSyntax($login))
            return false;

        DB::uQuery('DELETE FROM ftp_accounts WHERE uid="'.Users::get('uid').'" AND login="'.DB::esc($login).'";');
        return true;
    }

    public function edit($login, $new_password, $new_path, $new_quota)
    {
        if (!FTP_Accounts::checkLoginSyntax($login))
            return false;

        if (strpos($new_path, '..') === true)
            $new_path = '';

        $new_path = ALTERNZ_BASE_PATH.Users::get('login').'/'.$new_path;

        DB::uQuery('UPDATE ftp_accounts SET password="'.DB::esc($new_password).'", path="'.DB::esc($new_path).'", quota_size="'.(int)$new_quota.'"
            WHERE uid="'.Users::get('uid').'" AND login="'.DB::esc($login).'";');

        return true;
    }

    public function getByLogin($login)
    {
        $item = DB::aQuery('SELECT * FROM ftp_accounts WHERE uid="'.Users::get('uid').'" AND login="'.DB::esc($login).'";');

        if (empty($item[0]))
            return false;

        $item = $item[0];
        $item['path'] = str_replace(ALTERNZ_BASE_PATH.Users::get('login'), '', $item['path']);
        return $item;
    }
}

?>