[HOWTO] Using the CLI to manage ispcp via command line (scripts)

[sci2tech]

Maybe this will help
Needed query.

PHP Code:

    $query = "
        INSERT INTO `admin` (
            `admin_name`, `admin_pass`, `admin_type`, `domain_created`,
            `created_by`, `fname`, `lname`,
            `firm`, `zip`, `city`, `state`,
            `country`, `email`, `phone`,
            `fax`, `street1`, `street2`,
            `customer_id`, `gender`
        )
        VALUES (
            ?, ?, 'user', unix_timestamp(),
            ?, ?, ?,
            ?, ?, ?, ?,
            ?, ?, ?,
            ?, ?, ?,
            ?, ?
        )
    "; 


Needed fields: admin_name, admin_pass, admin_type, created_by, email.

PHP Code:

$query = "
        INSERT INTO `domain` (
            `domain_name`, `domain_admin_id`,
            `domain_created_id`, `domain_created`,
            `domain_mailacc_limit`, `domain_ftpacc_limit`,
            `domain_traffic_limit`, `domain_sqld_limit`,
            `domain_sqlu_limit`, `domain_status`,
            `domain_subd_limit`, `domain_alias_limit`,
            `domain_ip_id`, `domain_disk_limit`,
            `domain_disk_usage`, `domain_php`, `domain_cgi`,
            `allowbackup`, `domain_dns`
        )
        VALUES (
            ?, ?,
            ?, unix_timestamp(),
            ?, ?,
            ?, ?,
            ?, ?,
            ?, ?,
            ?, ?, '0',
            ?, ?,
            ?, ?
        )
    "; 


domain_admin_id must be taken from previous query field admin_id.

PHP Code:

check_for_lock_file();
send_request(); 


This are minimum operations to add a domain.