Domain Update Problem - Printable Version

Code:
function update_user_props ( $user_id, $props ) {



    $sql = Database::getInstance();



    list (

           $sub_current, $sub_max,

           $als_current, $als_max,

           $mail_current, $mail_max,

           $ftp_current, $ftp_max,

           $sql_db_current, $sql_db_max,

           $sql_user_current, $sql_user_max,

           $traff_max, $disk_max,

           $domain_php, $domain_cgi, $domain_software_allowed) = explode (";", $props);

           //$domain_ip_id, $domain_php, $domain_cgi) = explode (";", $props);



         //have to check if PHP and/or CGI and/or IP change

         $domain_last_modified =  time();



    $query = <<<SQL_QUERY

        select

            domain_name

        from

            domain

        where

            domain_id  = ?

          and

            domain_php = ?

          and

            domain_cgi = ?

       and

        domain_software_allowed = ?

SQL_QUERY;



    $rs = exec_query($sql, $query, array($user_id, $domain_php, $domain_cgi, $domain_software_allowed));



    if ($rs -> RecordCount() == 0) {

        // mama mia, we have to rebuild the system entry for this domain

        // and also all domain alias and subdomains



        $update_status = Config::get('ITEM_CHANGE_STATUS');



        // check if we have to wait some system update

        check_for_lock_file();

        // ... and go update



        // update the domain

        $query = <<<SQL_QUERY

        update

            domain

        set

            domain_last_modified = ?,

            domain_mailacc_limit = ?,

            domain_ftpacc_limit = ?,

            domain_traffic_limit = ?,

            domain_sqld_limit = ?,

            domain_sqlu_limit = ?,

            domain_status = ?,

            domain_alias_limit = ?,

            domain_subd_limit = ?,

            domain_disk_limit = ?,

            domain_php = ?,

            domain_cgi = ?,

            domain_software_allowed = ?

        where

            domain_id  = ?

SQL_QUERY;



        $rs = exec_query($sql, $query, array($domain_last_modified,

                                         $mail_max,

                                         $ftp_max,

                                         $traff_max,

                                         $sql_db_max,

                                         $sql_user_max,

                                         $update_status,

                                         $als_max,

                                         $sub_max,

                                         $disk_max,

                                         $domain_php,

                                         $domain_cgi,

                                         $domain_software_allowed,

                                         $user_id));