object(Zend_Db_Statement_Exception)#51 (6) { ["message:protected"]=> string(35) "Invalid bind-variable position ':\'" ["string:private"]=> string(0) "" ["code:protected"]=> int(0) ["file:protected"]=> string(62) "/home/ucl/public_html/app/zend-framework/Zend/Db/Statement.php" ["line:protected"]=> int(143) ["trace:private"]=> array(11) { [0]=> array(6) { ["file"]=> string(62) "/home/ucl/public_html/app/zend-framework/Zend/Db/Statement.php" ["line"]=> int(108) ["function"]=> string(16) "_parseParameters" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(209) "SELECT `Subdivision`.* FROM `Subdivision` WHERE (SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } } [1]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Db/Adapter/Mysqli.php" ["line"]=> int(330) ["function"]=> string(11) "__construct" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } [1]=> string(209) "SELECT `Subdivision`.* FROM `Subdivision` WHERE (SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } } [2]=> array(6) { ["file"]=> string(69) "/home/ucl/public_html/app/zend-framework/Zend/Db/Adapter/Abstract.php" ["line"]=> int(405) ["function"]=> string(7) "prepare" ["class"]=> string(22) "Zend_Db_Adapter_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(209) "SELECT `Subdivision`.* FROM `Subdivision` WHERE (SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } } [3]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Db/Table/Abstract.php" ["line"]=> int(1185) ["function"]=> string(5) "query" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Table_Select)#52 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(11) "Subdivision" ["cols"]=> array(22) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(6) "Status" [4]=> string(17) "ShareWithRealtors" [5]=> string(8) "PriceLow" [6]=> string(9) "PriceHigh" [7]=> string(7) "SqftLow" [8]=> string(8) "SqftHigh" [9]=> string(13) "SubdivisionID" [10]=> string(15) "SubdivisionName" [11]=> string(13) "SubParentName" [12]=> string(13) "SubLeadsEmail" [13]=> string(15) "LeadsPerMessage" [14]=> string(14) "BuildOnYourLot" [15]=> string(17) "DrivingDirections" [16]=> string(14) "SubDescription" [17]=> string(10) "SubWebsite" [18]=> string(20) "EnvisionDesignCenter" [19]=> string(9) "LotsTotal" [20]=> string(13) "LotsAvailable" [21]=> string(9) "BuilderID" } ["primary"]=> array(3) { [1]=> string(17) "SubdivisionNumber" [2]=> string(13) "BuilderNumber" [3]=> string(22) "CorporateBuilderNumber" } ["metadata"]=> array(22) { ["SubdivisionNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "SubdivisionNumber" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["BuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "BuilderNumber" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["CorporateBuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(22) "CorporateBuilderNumber" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["Status"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(6) "Status" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(53) "enum('Active','Closeout','ComingSoon','GrandOpening')" ["DEFAULT"]=> string(6) "Active" ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ShareWithRealtors"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "ShareWithRealtors" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "PriceLow" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "PriceHigh" ["COLUMN_POSITION"]=> int(7) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(7) "SqftLow" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "SqftHigh" ["COLUMN_POSITION"]=> int(9) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "SubdivisionName" ["COLUMN_POSITION"]=> int(11) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "60" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubParentName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubParentName" ["COLUMN_POSITION"]=> int(12) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubLeadsEmail"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubLeadsEmail" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "100" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LeadsPerMessage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "LeadsPerMessage" ["COLUMN_POSITION"]=> int(14) ["DATA_TYPE"]=> string(15) "enum('1','All')" ["DEFAULT"]=> string(3) "All" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuildOnYourLot"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "BuildOnYourLot" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["DrivingDirections"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "DrivingDirections" ["COLUMN_POSITION"]=> int(16) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "SubDescription" ["COLUMN_POSITION"]=> int(17) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubWebsite"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(10) "SubWebsite" ["COLUMN_POSITION"]=> int(18) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["EnvisionDesignCenter"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(20) "EnvisionDesignCenter" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsTotal"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "LotsTotal" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsAvailable"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "LotsAvailable" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(22) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } } ["rowClass"]=> string(17) "Zend_Db_Table_Row" ["rowsetClass"]=> string(20) "Zend_Db_Table_Rowset" ["referenceMap"]=> array(0) { } ["dependentTables"]=> array(0) { } ["sequence"]=> bool(true) } ["_integrityCheck:protected"]=> bool(true) ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(1) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Subdivision"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(11) "Subdivision" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(161) "(SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(0) { } ["limitcount"]=> NULL ["limitoffset"]=> NULL ["forupdate"]=> bool(false) } ["_tableCols:protected"]=> array(0) { } } } } [4]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Db/Table/Abstract.php" ["line"]=> int(1040) ["function"]=> string(6) "_fetch" ["class"]=> string(22) "Zend_Db_Table_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Table_Select)#52 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(11) "Subdivision" ["cols"]=> array(22) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(6) "Status" [4]=> string(17) "ShareWithRealtors" [5]=> string(8) "PriceLow" [6]=> string(9) "PriceHigh" [7]=> string(7) "SqftLow" [8]=> string(8) "SqftHigh" [9]=> string(13) "SubdivisionID" [10]=> string(15) "SubdivisionName" [11]=> string(13) "SubParentName" [12]=> string(13) "SubLeadsEmail" [13]=> string(15) "LeadsPerMessage" [14]=> string(14) "BuildOnYourLot" [15]=> string(17) "DrivingDirections" [16]=> string(14) "SubDescription" [17]=> string(10) "SubWebsite" [18]=> string(20) "EnvisionDesignCenter" [19]=> string(9) "LotsTotal" [20]=> string(13) "LotsAvailable" [21]=> string(9) "BuilderID" } ["primary"]=> array(3) { [1]=> string(17) "SubdivisionNumber" [2]=> string(13) "BuilderNumber" [3]=> string(22) "CorporateBuilderNumber" } ["metadata"]=> array(22) { ["SubdivisionNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "SubdivisionNumber" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["BuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "BuilderNumber" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["CorporateBuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(22) "CorporateBuilderNumber" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["Status"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(6) "Status" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(53) "enum('Active','Closeout','ComingSoon','GrandOpening')" ["DEFAULT"]=> string(6) "Active" ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ShareWithRealtors"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "ShareWithRealtors" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "PriceLow" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "PriceHigh" ["COLUMN_POSITION"]=> int(7) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(7) "SqftLow" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "SqftHigh" ["COLUMN_POSITION"]=> int(9) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "SubdivisionName" ["COLUMN_POSITION"]=> int(11) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "60" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubParentName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubParentName" ["COLUMN_POSITION"]=> int(12) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubLeadsEmail"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubLeadsEmail" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "100" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LeadsPerMessage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "LeadsPerMessage" ["COLUMN_POSITION"]=> int(14) ["DATA_TYPE"]=> string(15) "enum('1','All')" ["DEFAULT"]=> string(3) "All" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuildOnYourLot"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "BuildOnYourLot" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["DrivingDirections"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "DrivingDirections" ["COLUMN_POSITION"]=> int(16) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "SubDescription" ["COLUMN_POSITION"]=> int(17) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubWebsite"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(10) "SubWebsite" ["COLUMN_POSITION"]=> int(18) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["EnvisionDesignCenter"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(20) "EnvisionDesignCenter" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsTotal"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "LotsTotal" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsAvailable"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "LotsAvailable" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(22) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } } ["rowClass"]=> string(17) "Zend_Db_Table_Row" ["rowsetClass"]=> string(20) "Zend_Db_Table_Rowset" ["referenceMap"]=> array(0) { } ["dependentTables"]=> array(0) { } ["sequence"]=> bool(true) } ["_integrityCheck:protected"]=> bool(true) ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(1) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Subdivision"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(11) "Subdivision" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(161) "(SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(0) { } ["limitcount"]=> NULL ["limitoffset"]=> NULL ["forupdate"]=> bool(false) } ["_tableCols:protected"]=> array(0) { } } } } [5]=> array(6) { ["file"]=> string(72) "/home/ucl/public_html/app/application/controllers/PropertyController.php" ["line"]=> int(551) ["function"]=> string(8) "fetchAll" ["class"]=> string(22) "Zend_Db_Table_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Table_Select)#52 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(11) "Subdivision" ["cols"]=> array(22) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(6) "Status" [4]=> string(17) "ShareWithRealtors" [5]=> string(8) "PriceLow" [6]=> string(9) "PriceHigh" [7]=> string(7) "SqftLow" [8]=> string(8) "SqftHigh" [9]=> string(13) "SubdivisionID" [10]=> string(15) "SubdivisionName" [11]=> string(13) "SubParentName" [12]=> string(13) "SubLeadsEmail" [13]=> string(15) "LeadsPerMessage" [14]=> string(14) "BuildOnYourLot" [15]=> string(17) "DrivingDirections" [16]=> string(14) "SubDescription" [17]=> string(10) "SubWebsite" [18]=> string(20) "EnvisionDesignCenter" [19]=> string(9) "LotsTotal" [20]=> string(13) "LotsAvailable" [21]=> string(9) "BuilderID" } ["primary"]=> array(3) { [1]=> string(17) "SubdivisionNumber" [2]=> string(13) "BuilderNumber" [3]=> string(22) "CorporateBuilderNumber" } ["metadata"]=> array(22) { ["SubdivisionNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "SubdivisionNumber" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["BuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "BuilderNumber" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["CorporateBuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(22) "CorporateBuilderNumber" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["Status"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(6) "Status" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(53) "enum('Active','Closeout','ComingSoon','GrandOpening')" ["DEFAULT"]=> string(6) "Active" ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ShareWithRealtors"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "ShareWithRealtors" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "PriceLow" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "PriceHigh" ["COLUMN_POSITION"]=> int(7) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(7) "SqftLow" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "SqftHigh" ["COLUMN_POSITION"]=> int(9) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "SubdivisionName" ["COLUMN_POSITION"]=> int(11) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "60" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubParentName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubParentName" ["COLUMN_POSITION"]=> int(12) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubLeadsEmail"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubLeadsEmail" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "100" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LeadsPerMessage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "LeadsPerMessage" ["COLUMN_POSITION"]=> int(14) ["DATA_TYPE"]=> string(15) "enum('1','All')" ["DEFAULT"]=> string(3) "All" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuildOnYourLot"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "BuildOnYourLot" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["DrivingDirections"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "DrivingDirections" ["COLUMN_POSITION"]=> int(16) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "SubDescription" ["COLUMN_POSITION"]=> int(17) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubWebsite"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(10) "SubWebsite" ["COLUMN_POSITION"]=> int(18) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["EnvisionDesignCenter"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(20) "EnvisionDesignCenter" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsTotal"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "LotsTotal" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsAvailable"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "LotsAvailable" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(22) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } } ["rowClass"]=> string(17) "Zend_Db_Table_Row" ["rowsetClass"]=> string(20) "Zend_Db_Table_Rowset" ["referenceMap"]=> array(0) { } ["dependentTables"]=> array(0) { } ["sequence"]=> bool(true) } ["_integrityCheck:protected"]=> bool(true) ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(1) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Subdivision"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(11) "Subdivision" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(161) "(SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(0) { } ["limitcount"]=> NULL ["limitoffset"]=> NULL ["forupdate"]=> bool(false) } ["_tableCols:protected"]=> array(0) { } } } } [6]=> array(6) { ["file"]=> string(72) "/home/ucl/public_html/app/application/controllers/PropertyController.php" ["line"]=> int(45) ["function"]=> string(13) "getCommonData" ["class"]=> string(18) "PropertyController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [7]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Action.php" ["line"]=> int(502) ["function"]=> string(13) "detailsAction" ["class"]=> string(18) "PropertyController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [8]=> array(6) { ["file"]=> string(80) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(293) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(13) "detailsAction" } } [9]=> array(6) { ["file"]=> string(66) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Front.php" ["line"]=> int(914) ["function"]=> string(8) "dispatch" ["class"]=> string(35) "Zend_Controller_Dispatcher_Standard" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Controller_Request_Http)#20 (14) { ["_paramSources:protected"]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri:protected"]=> string(38) "/deer-run-%3A-deer-run-estates/details" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(38) "/deer-run-%3A-deer-run-estates/details" ["_params:protected"]=> array(4) { ["subdivision-name"]=> string(27) "deer-run-:-deer-run-estates" ["controller"]=> string(8) "property" ["action"]=> string(7) "details" ["error_handler"]=> object(ArrayObject)#53 (3) { ["exception"]=> object(Zend_Db_Statement_Exception)#51 (6) { ["message:protected"]=> string(35) "Invalid bind-variable position ':\'" ["string:private"]=> string(0) "" ["code:protected"]=> int(0) ["file:protected"]=> string(62) "/home/ucl/public_html/app/zend-framework/Zend/Db/Statement.php" ["line:protected"]=> int(143) ["trace:private"]=> array(11) { [0]=> array(6) { ["file"]=> string(62) "/home/ucl/public_html/app/zend-framework/Zend/Db/Statement.php" ["line"]=> int(108) ["function"]=> string(16) "_parseParameters" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(209) "SELECT `Subdivision`.* FROM `Subdivision` WHERE (SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } } [1]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Db/Adapter/Mysqli.php" ["line"]=> int(330) ["function"]=> string(11) "__construct" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } [1]=> string(209) "SELECT `Subdivision`.* FROM `Subdivision` WHERE (SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } } [2]=> array(6) { ["file"]=> string(69) "/home/ucl/public_html/app/zend-framework/Zend/Db/Adapter/Abstract.php" ["line"]=> int(405) ["function"]=> string(7) "prepare" ["class"]=> string(22) "Zend_Db_Adapter_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(209) "SELECT `Subdivision`.* FROM `Subdivision` WHERE (SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } } [3]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Db/Table/Abstract.php" ["line"]=> int(1185) ["function"]=> string(5) "query" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Table_Select)#52 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(11) "Subdivision" ["cols"]=> array(22) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(6) "Status" [4]=> string(17) "ShareWithRealtors" [5]=> string(8) "PriceLow" [6]=> string(9) "PriceHigh" [7]=> string(7) "SqftLow" [8]=> string(8) "SqftHigh" [9]=> string(13) "SubdivisionID" [10]=> string(15) "SubdivisionName" [11]=> string(13) "SubParentName" [12]=> string(13) "SubLeadsEmail" [13]=> string(15) "LeadsPerMessage" [14]=> string(14) "BuildOnYourLot" [15]=> string(17) "DrivingDirections" [16]=> string(14) "SubDescription" [17]=> string(10) "SubWebsite" [18]=> string(20) "EnvisionDesignCenter" [19]=> string(9) "LotsTotal" [20]=> string(13) "LotsAvailable" [21]=> string(9) "BuilderID" } ["primary"]=> array(3) { [1]=> string(17) "SubdivisionNumber" [2]=> string(13) "BuilderNumber" [3]=> string(22) "CorporateBuilderNumber" } ["metadata"]=> array(22) { ["SubdivisionNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "SubdivisionNumber" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["BuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "BuilderNumber" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["CorporateBuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(22) "CorporateBuilderNumber" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["Status"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(6) "Status" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(53) "enum('Active','Closeout','ComingSoon','GrandOpening')" ["DEFAULT"]=> string(6) "Active" ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ShareWithRealtors"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "ShareWithRealtors" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "PriceLow" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "PriceHigh" ["COLUMN_POSITION"]=> int(7) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(7) "SqftLow" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "SqftHigh" ["COLUMN_POSITION"]=> int(9) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "SubdivisionName" ["COLUMN_POSITION"]=> int(11) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "60" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubParentName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubParentName" ["COLUMN_POSITION"]=> int(12) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubLeadsEmail"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubLeadsEmail" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "100" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LeadsPerMessage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "LeadsPerMessage" ["COLUMN_POSITION"]=> int(14) ["DATA_TYPE"]=> string(15) "enum('1','All')" ["DEFAULT"]=> string(3) "All" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuildOnYourLot"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "BuildOnYourLot" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["DrivingDirections"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "DrivingDirections" ["COLUMN_POSITION"]=> int(16) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "SubDescription" ["COLUMN_POSITION"]=> int(17) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubWebsite"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(10) "SubWebsite" ["COLUMN_POSITION"]=> int(18) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["EnvisionDesignCenter"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(20) "EnvisionDesignCenter" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsTotal"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "LotsTotal" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsAvailable"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "LotsAvailable" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(22) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } } ["rowClass"]=> string(17) "Zend_Db_Table_Row" ["rowsetClass"]=> string(20) "Zend_Db_Table_Rowset" ["referenceMap"]=> array(0) { } ["dependentTables"]=> array(0) { } ["sequence"]=> bool(true) } ["_integrityCheck:protected"]=> bool(true) ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(1) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Subdivision"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(11) "Subdivision" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(161) "(SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(0) { } ["limitcount"]=> NULL ["limitoffset"]=> NULL ["forupdate"]=> bool(false) } ["_tableCols:protected"]=> array(0) { } } } } [4]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Db/Table/Abstract.php" ["line"]=> int(1040) ["function"]=> string(6) "_fetch" ["class"]=> string(22) "Zend_Db_Table_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Table_Select)#52 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(11) "Subdivision" ["cols"]=> array(22) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(6) "Status" [4]=> string(17) "ShareWithRealtors" [5]=> string(8) "PriceLow" [6]=> string(9) "PriceHigh" [7]=> string(7) "SqftLow" [8]=> string(8) "SqftHigh" [9]=> string(13) "SubdivisionID" [10]=> string(15) "SubdivisionName" [11]=> string(13) "SubParentName" [12]=> string(13) "SubLeadsEmail" [13]=> string(15) "LeadsPerMessage" [14]=> string(14) "BuildOnYourLot" [15]=> string(17) "DrivingDirections" [16]=> string(14) "SubDescription" [17]=> string(10) "SubWebsite" [18]=> string(20) "EnvisionDesignCenter" [19]=> string(9) "LotsTotal" [20]=> string(13) "LotsAvailable" [21]=> string(9) "BuilderID" } ["primary"]=> array(3) { [1]=> string(17) "SubdivisionNumber" [2]=> string(13) "BuilderNumber" [3]=> string(22) "CorporateBuilderNumber" } ["metadata"]=> array(22) { ["SubdivisionNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "SubdivisionNumber" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["BuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "BuilderNumber" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["CorporateBuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(22) "CorporateBuilderNumber" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["Status"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(6) "Status" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(53) "enum('Active','Closeout','ComingSoon','GrandOpening')" ["DEFAULT"]=> string(6) "Active" ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ShareWithRealtors"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "ShareWithRealtors" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "PriceLow" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "PriceHigh" ["COLUMN_POSITION"]=> int(7) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(7) "SqftLow" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "SqftHigh" ["COLUMN_POSITION"]=> int(9) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "SubdivisionName" ["COLUMN_POSITION"]=> int(11) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "60" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubParentName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubParentName" ["COLUMN_POSITION"]=> int(12) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubLeadsEmail"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubLeadsEmail" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "100" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LeadsPerMessage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "LeadsPerMessage" ["COLUMN_POSITION"]=> int(14) ["DATA_TYPE"]=> string(15) "enum('1','All')" ["DEFAULT"]=> string(3) "All" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuildOnYourLot"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "BuildOnYourLot" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["DrivingDirections"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "DrivingDirections" ["COLUMN_POSITION"]=> int(16) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "SubDescription" ["COLUMN_POSITION"]=> int(17) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubWebsite"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(10) "SubWebsite" ["COLUMN_POSITION"]=> int(18) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["EnvisionDesignCenter"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(20) "EnvisionDesignCenter" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsTotal"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "LotsTotal" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsAvailable"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "LotsAvailable" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(22) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } } ["rowClass"]=> string(17) "Zend_Db_Table_Row" ["rowsetClass"]=> string(20) "Zend_Db_Table_Rowset" ["referenceMap"]=> array(0) { } ["dependentTables"]=> array(0) { } ["sequence"]=> bool(true) } ["_integrityCheck:protected"]=> bool(true) ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(1) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Subdivision"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(11) "Subdivision" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(161) "(SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(0) { } ["limitcount"]=> NULL ["limitoffset"]=> NULL ["forupdate"]=> bool(false) } ["_tableCols:protected"]=> array(0) { } } } } [5]=> array(6) { ["file"]=> string(72) "/home/ucl/public_html/app/application/controllers/PropertyController.php" ["line"]=> int(551) ["function"]=> string(8) "fetchAll" ["class"]=> string(22) "Zend_Db_Table_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Table_Select)#52 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(11) "Subdivision" ["cols"]=> array(22) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(6) "Status" [4]=> string(17) "ShareWithRealtors" [5]=> string(8) "PriceLow" [6]=> string(9) "PriceHigh" [7]=> string(7) "SqftLow" [8]=> string(8) "SqftHigh" [9]=> string(13) "SubdivisionID" [10]=> string(15) "SubdivisionName" [11]=> string(13) "SubParentName" [12]=> string(13) "SubLeadsEmail" [13]=> string(15) "LeadsPerMessage" [14]=> string(14) "BuildOnYourLot" [15]=> string(17) "DrivingDirections" [16]=> string(14) "SubDescription" [17]=> string(10) "SubWebsite" [18]=> string(20) "EnvisionDesignCenter" [19]=> string(9) "LotsTotal" [20]=> string(13) "LotsAvailable" [21]=> string(9) "BuilderID" } ["primary"]=> array(3) { [1]=> string(17) "SubdivisionNumber" [2]=> string(13) "BuilderNumber" [3]=> string(22) "CorporateBuilderNumber" } ["metadata"]=> array(22) { ["SubdivisionNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "SubdivisionNumber" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["BuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "BuilderNumber" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["CorporateBuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(22) "CorporateBuilderNumber" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["Status"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(6) "Status" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(53) "enum('Active','Closeout','ComingSoon','GrandOpening')" ["DEFAULT"]=> string(6) "Active" ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ShareWithRealtors"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "ShareWithRealtors" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "PriceLow" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "PriceHigh" ["COLUMN_POSITION"]=> int(7) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(7) "SqftLow" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "SqftHigh" ["COLUMN_POSITION"]=> int(9) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "SubdivisionName" ["COLUMN_POSITION"]=> int(11) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "60" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubParentName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubParentName" ["COLUMN_POSITION"]=> int(12) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubLeadsEmail"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubLeadsEmail" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "100" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LeadsPerMessage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "LeadsPerMessage" ["COLUMN_POSITION"]=> int(14) ["DATA_TYPE"]=> string(15) "enum('1','All')" ["DEFAULT"]=> string(3) "All" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuildOnYourLot"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "BuildOnYourLot" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["DrivingDirections"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "DrivingDirections" ["COLUMN_POSITION"]=> int(16) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "SubDescription" ["COLUMN_POSITION"]=> int(17) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubWebsite"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(10) "SubWebsite" ["COLUMN_POSITION"]=> int(18) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["EnvisionDesignCenter"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(20) "EnvisionDesignCenter" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsTotal"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "LotsTotal" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsAvailable"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "LotsAvailable" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(22) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } } ["rowClass"]=> string(17) "Zend_Db_Table_Row" ["rowsetClass"]=> string(20) "Zend_Db_Table_Rowset" ["referenceMap"]=> array(0) { } ["dependentTables"]=> array(0) { } ["sequence"]=> bool(true) } ["_integrityCheck:protected"]=> bool(true) ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(1) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Subdivision"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(11) "Subdivision" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(161) "(SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(0) { } ["limitcount"]=> NULL ["limitoffset"]=> NULL ["forupdate"]=> bool(false) } ["_tableCols:protected"]=> array(0) { } } } } [6]=> array(6) { ["file"]=> string(72) "/home/ucl/public_html/app/application/controllers/PropertyController.php" ["line"]=> int(45) ["function"]=> string(13) "getCommonData" ["class"]=> string(18) "PropertyController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [7]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Action.php" ["line"]=> int(502) ["function"]=> string(13) "detailsAction" ["class"]=> string(18) "PropertyController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [8]=> array(6) { ["file"]=> string(80) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(293) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(13) "detailsAction" } } [9]=> array(6) { ["file"]=> string(66) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Front.php" ["line"]=> int(914) ["function"]=> string(8) "dispatch" ["class"]=> string(35) "Zend_Controller_Dispatcher_Standard" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Controller_Request_Http)#20 (14) { ["_paramSources:protected"]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri:protected"]=> string(38) "/deer-run-%3A-deer-run-estates/details" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(38) "/deer-run-%3A-deer-run-estates/details" ["_params:protected"]=> array(4) { ["subdivision-name"]=> string(27) "deer-run-:-deer-run-estates" ["controller"]=> string(8) "property" ["action"]=> string(7) "details" ["error_handler"]=> object(ArrayObject)#53 (3) { ["exception"]=> *RECURSION* ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#44 (14) { ["_paramSources:protected"]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri:protected"]=> string(38) "/deer-run-%3A-deer-run-estates/details" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(38) "/deer-run-%3A-deer-run-estates/details" ["_params:protected"]=> array(3) { ["subdivision-name"]=> string(27) "deer-run-:-deer-run-estates" ["controller"]=> string(8) "property" ["action"]=> string(7) "details" } ["_aliases:protected"]=> array(0) { } ["_dispatched:protected"]=> bool(true) ["_module:protected"]=> string(7) "default" ["_moduleKey:protected"]=> string(6) "module" ["_controller:protected"]=> string(8) "property" ["_controllerKey:protected"]=> string(10) "controller" ["_action:protected"]=> string(7) "details" ["_actionKey:protected"]=> string(6) "action" } } } ["_aliases:protected"]=> array(0) { } ["_dispatched:protected"]=> bool(true) ["_module:protected"]=> string(7) "default" ["_moduleKey:protected"]=> string(6) "module" ["_controller:protected"]=> string(5) "error" ["_controllerKey:protected"]=> string(10) "controller" ["_action:protected"]=> string(5) "error" ["_actionKey:protected"]=> string(6) "action" } [1]=> object(Zend_Controller_Response_Http)#21 (8) { ["_body:protected"]=> array(0) { } ["_exceptions:protected"]=> array(1) { [0]=> *RECURSION* } ["_headers:protected"]=> array(0) { } ["_headersRaw:protected"]=> array(0) { } ["_httpResponseCode:protected"]=> int(200) ["_isRedirect:protected"]=> bool(false) ["_renderExceptions:protected"]=> bool(false) ["headersSentThrowsException"]=> bool(true) } } } [10]=> array(6) { ["file"]=> string(31) "/home/ucl/public_html/index.php" ["line"]=> int(139) ["function"]=> string(8) "dispatch" ["class"]=> string(21) "Zend_Controller_Front" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } } ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#44 (14) { ["_paramSources:protected"]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri:protected"]=> string(38) "/deer-run-%3A-deer-run-estates/details" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(38) "/deer-run-%3A-deer-run-estates/details" ["_params:protected"]=> array(3) { ["subdivision-name"]=> string(27) "deer-run-:-deer-run-estates" ["controller"]=> string(8) "property" ["action"]=> string(7) "details" } ["_aliases:protected"]=> array(0) { } ["_dispatched:protected"]=> bool(true) ["_module:protected"]=> string(7) "default" ["_moduleKey:protected"]=> string(6) "module" ["_controller:protected"]=> string(8) "property" ["_controllerKey:protected"]=> string(10) "controller" ["_action:protected"]=> string(7) "details" ["_actionKey:protected"]=> string(6) "action" } } } ["_aliases:protected"]=> array(0) { } ["_dispatched:protected"]=> bool(true) ["_module:protected"]=> string(7) "default" ["_moduleKey:protected"]=> string(6) "module" ["_controller:protected"]=> string(5) "error" ["_controllerKey:protected"]=> string(10) "controller" ["_action:protected"]=> string(5) "error" ["_actionKey:protected"]=> string(6) "action" } [1]=> object(Zend_Controller_Response_Http)#21 (8) { ["_body:protected"]=> array(0) { } ["_exceptions:protected"]=> array(1) { [0]=> object(Zend_Db_Statement_Exception)#51 (6) { ["message:protected"]=> string(35) "Invalid bind-variable position ':\'" ["string:private"]=> string(0) "" ["code:protected"]=> int(0) ["file:protected"]=> string(62) "/home/ucl/public_html/app/zend-framework/Zend/Db/Statement.php" ["line:protected"]=> int(143) ["trace:private"]=> array(11) { [0]=> array(6) { ["file"]=> string(62) "/home/ucl/public_html/app/zend-framework/Zend/Db/Statement.php" ["line"]=> int(108) ["function"]=> string(16) "_parseParameters" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(209) "SELECT `Subdivision`.* FROM `Subdivision` WHERE (SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } } [1]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Db/Adapter/Mysqli.php" ["line"]=> int(330) ["function"]=> string(11) "__construct" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } [1]=> string(209) "SELECT `Subdivision`.* FROM `Subdivision` WHERE (SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } } [2]=> array(6) { ["file"]=> string(69) "/home/ucl/public_html/app/zend-framework/Zend/Db/Adapter/Abstract.php" ["line"]=> int(405) ["function"]=> string(7) "prepare" ["class"]=> string(22) "Zend_Db_Adapter_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(209) "SELECT `Subdivision`.* FROM `Subdivision` WHERE (SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } } [3]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Db/Table/Abstract.php" ["line"]=> int(1185) ["function"]=> string(5) "query" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Table_Select)#52 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(11) "Subdivision" ["cols"]=> array(22) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(6) "Status" [4]=> string(17) "ShareWithRealtors" [5]=> string(8) "PriceLow" [6]=> string(9) "PriceHigh" [7]=> string(7) "SqftLow" [8]=> string(8) "SqftHigh" [9]=> string(13) "SubdivisionID" [10]=> string(15) "SubdivisionName" [11]=> string(13) "SubParentName" [12]=> string(13) "SubLeadsEmail" [13]=> string(15) "LeadsPerMessage" [14]=> string(14) "BuildOnYourLot" [15]=> string(17) "DrivingDirections" [16]=> string(14) "SubDescription" [17]=> string(10) "SubWebsite" [18]=> string(20) "EnvisionDesignCenter" [19]=> string(9) "LotsTotal" [20]=> string(13) "LotsAvailable" [21]=> string(9) "BuilderID" } ["primary"]=> array(3) { [1]=> string(17) "SubdivisionNumber" [2]=> string(13) "BuilderNumber" [3]=> string(22) "CorporateBuilderNumber" } ["metadata"]=> array(22) { ["SubdivisionNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "SubdivisionNumber" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["BuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "BuilderNumber" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["CorporateBuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(22) "CorporateBuilderNumber" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["Status"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(6) "Status" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(53) "enum('Active','Closeout','ComingSoon','GrandOpening')" ["DEFAULT"]=> string(6) "Active" ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ShareWithRealtors"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "ShareWithRealtors" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "PriceLow" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "PriceHigh" ["COLUMN_POSITION"]=> int(7) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(7) "SqftLow" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "SqftHigh" ["COLUMN_POSITION"]=> int(9) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "SubdivisionName" ["COLUMN_POSITION"]=> int(11) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "60" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubParentName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubParentName" ["COLUMN_POSITION"]=> int(12) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubLeadsEmail"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubLeadsEmail" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "100" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LeadsPerMessage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "LeadsPerMessage" ["COLUMN_POSITION"]=> int(14) ["DATA_TYPE"]=> string(15) "enum('1','All')" ["DEFAULT"]=> string(3) "All" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuildOnYourLot"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "BuildOnYourLot" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["DrivingDirections"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "DrivingDirections" ["COLUMN_POSITION"]=> int(16) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "SubDescription" ["COLUMN_POSITION"]=> int(17) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubWebsite"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(10) "SubWebsite" ["COLUMN_POSITION"]=> int(18) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["EnvisionDesignCenter"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(20) "EnvisionDesignCenter" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsTotal"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "LotsTotal" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsAvailable"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "LotsAvailable" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(22) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } } ["rowClass"]=> string(17) "Zend_Db_Table_Row" ["rowsetClass"]=> string(20) "Zend_Db_Table_Rowset" ["referenceMap"]=> array(0) { } ["dependentTables"]=> array(0) { } ["sequence"]=> bool(true) } ["_integrityCheck:protected"]=> bool(true) ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(1) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Subdivision"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(11) "Subdivision" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(161) "(SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(0) { } ["limitcount"]=> NULL ["limitoffset"]=> NULL ["forupdate"]=> bool(false) } ["_tableCols:protected"]=> array(0) { } } } } [4]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Db/Table/Abstract.php" ["line"]=> int(1040) ["function"]=> string(6) "_fetch" ["class"]=> string(22) "Zend_Db_Table_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Table_Select)#52 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(11) "Subdivision" ["cols"]=> array(22) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(6) "Status" [4]=> string(17) "ShareWithRealtors" [5]=> string(8) "PriceLow" [6]=> string(9) "PriceHigh" [7]=> string(7) "SqftLow" [8]=> string(8) "SqftHigh" [9]=> string(13) "SubdivisionID" [10]=> string(15) "SubdivisionName" [11]=> string(13) "SubParentName" [12]=> string(13) "SubLeadsEmail" [13]=> string(15) "LeadsPerMessage" [14]=> string(14) "BuildOnYourLot" [15]=> string(17) "DrivingDirections" [16]=> string(14) "SubDescription" [17]=> string(10) "SubWebsite" [18]=> string(20) "EnvisionDesignCenter" [19]=> string(9) "LotsTotal" [20]=> string(13) "LotsAvailable" [21]=> string(9) "BuilderID" } ["primary"]=> array(3) { [1]=> string(17) "SubdivisionNumber" [2]=> string(13) "BuilderNumber" [3]=> string(22) "CorporateBuilderNumber" } ["metadata"]=> array(22) { ["SubdivisionNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "SubdivisionNumber" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["BuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "BuilderNumber" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["CorporateBuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(22) "CorporateBuilderNumber" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["Status"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(6) "Status" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(53) "enum('Active','Closeout','ComingSoon','GrandOpening')" ["DEFAULT"]=> string(6) "Active" ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ShareWithRealtors"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "ShareWithRealtors" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "PriceLow" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "PriceHigh" ["COLUMN_POSITION"]=> int(7) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(7) "SqftLow" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "SqftHigh" ["COLUMN_POSITION"]=> int(9) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "SubdivisionName" ["COLUMN_POSITION"]=> int(11) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "60" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubParentName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubParentName" ["COLUMN_POSITION"]=> int(12) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubLeadsEmail"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubLeadsEmail" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "100" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LeadsPerMessage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "LeadsPerMessage" ["COLUMN_POSITION"]=> int(14) ["DATA_TYPE"]=> string(15) "enum('1','All')" ["DEFAULT"]=> string(3) "All" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuildOnYourLot"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "BuildOnYourLot" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["DrivingDirections"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "DrivingDirections" ["COLUMN_POSITION"]=> int(16) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "SubDescription" ["COLUMN_POSITION"]=> int(17) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubWebsite"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(10) "SubWebsite" ["COLUMN_POSITION"]=> int(18) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["EnvisionDesignCenter"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(20) "EnvisionDesignCenter" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsTotal"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "LotsTotal" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsAvailable"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "LotsAvailable" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(22) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } } ["rowClass"]=> string(17) "Zend_Db_Table_Row" ["rowsetClass"]=> string(20) "Zend_Db_Table_Rowset" ["referenceMap"]=> array(0) { } ["dependentTables"]=> array(0) { } ["sequence"]=> bool(true) } ["_integrityCheck:protected"]=> bool(true) ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(1) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Subdivision"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(11) "Subdivision" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(161) "(SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(0) { } ["limitcount"]=> NULL ["limitoffset"]=> NULL ["forupdate"]=> bool(false) } ["_tableCols:protected"]=> array(0) { } } } } [5]=> array(6) { ["file"]=> string(72) "/home/ucl/public_html/app/application/controllers/PropertyController.php" ["line"]=> int(551) ["function"]=> string(8) "fetchAll" ["class"]=> string(22) "Zend_Db_Table_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Table_Select)#52 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(11) "Subdivision" ["cols"]=> array(22) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(6) "Status" [4]=> string(17) "ShareWithRealtors" [5]=> string(8) "PriceLow" [6]=> string(9) "PriceHigh" [7]=> string(7) "SqftLow" [8]=> string(8) "SqftHigh" [9]=> string(13) "SubdivisionID" [10]=> string(15) "SubdivisionName" [11]=> string(13) "SubParentName" [12]=> string(13) "SubLeadsEmail" [13]=> string(15) "LeadsPerMessage" [14]=> string(14) "BuildOnYourLot" [15]=> string(17) "DrivingDirections" [16]=> string(14) "SubDescription" [17]=> string(10) "SubWebsite" [18]=> string(20) "EnvisionDesignCenter" [19]=> string(9) "LotsTotal" [20]=> string(13) "LotsAvailable" [21]=> string(9) "BuilderID" } ["primary"]=> array(3) { [1]=> string(17) "SubdivisionNumber" [2]=> string(13) "BuilderNumber" [3]=> string(22) "CorporateBuilderNumber" } ["metadata"]=> array(22) { ["SubdivisionNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "SubdivisionNumber" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["BuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "BuilderNumber" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["CorporateBuilderNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(22) "CorporateBuilderNumber" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["Status"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(6) "Status" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(53) "enum('Active','Closeout','ComingSoon','GrandOpening')" ["DEFAULT"]=> string(6) "Active" ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ShareWithRealtors"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "ShareWithRealtors" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "PriceLow" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PriceHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "PriceHigh" ["COLUMN_POSITION"]=> int(7) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftLow"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(7) "SqftLow" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SqftHigh"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(8) "SqftHigh" ["COLUMN_POSITION"]=> int(9) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubdivisionName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "SubdivisionName" ["COLUMN_POSITION"]=> int(11) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> string(0) "" ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "60" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubParentName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubParentName" ["COLUMN_POSITION"]=> int(12) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubLeadsEmail"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "SubLeadsEmail" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "100" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LeadsPerMessage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(15) "LeadsPerMessage" ["COLUMN_POSITION"]=> int(14) ["DATA_TYPE"]=> string(15) "enum('1','All')" ["DEFAULT"]=> string(3) "All" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuildOnYourLot"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "BuildOnYourLot" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["DrivingDirections"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(17) "DrivingDirections" ["COLUMN_POSITION"]=> int(16) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(14) "SubDescription" ["COLUMN_POSITION"]=> int(17) ["DATA_TYPE"]=> string(4) "text" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SubWebsite"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(10) "SubWebsite" ["COLUMN_POSITION"]=> int(18) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["EnvisionDesignCenter"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(20) "EnvisionDesignCenter" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsTotal"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "LotsTotal" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LotsAvailable"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(13) "LotsAvailable" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(11) "Subdivision" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(22) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(3) "255" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } } ["rowClass"]=> string(17) "Zend_Db_Table_Row" ["rowsetClass"]=> string(20) "Zend_Db_Table_Rowset" ["referenceMap"]=> array(0) { } ["dependentTables"]=> array(0) { } ["sequence"]=> bool(true) } ["_integrityCheck:protected"]=> bool(true) ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#45 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(6) { [0]=> string(2) "id" [1]=> string(5) "state" [2]=> string(11) "postal_code" [3]=> string(9) "market_id" [4]=> string(11) "market_name" [5]=> string(9) "subdomain" } ["_values:protected"]=> array(6) { [0]=> int(19895) [1]=> string(2) "TX" [2]=> string(5) "76670" [3]=> int(275) [4]=> string(6) "Dallas" [5]=> string(6) "dallas" } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(43) "SELECT .* FROM WHERE (LOWER(subdomain) = )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(1) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Subdivision"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(11) "Subdivision" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(161) "(SubdivisionName RLIKE '^d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?:\'?( |-)*\'?d\'?e\'?e\'?r\'?( |-)*\'?r\'?u\'?n\'?( |-)*\'?e\'?s\'?t\'?a\'?t\'?e\'?s\'?$')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(0) { } ["limitcount"]=> NULL ["limitoffset"]=> NULL ["forupdate"]=> bool(false) } ["_tableCols:protected"]=> array(0) { } } } } [6]=> array(6) { ["file"]=> string(72) "/home/ucl/public_html/app/application/controllers/PropertyController.php" ["line"]=> int(45) ["function"]=> string(13) "getCommonData" ["class"]=> string(18) "PropertyController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [7]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Action.php" ["line"]=> int(502) ["function"]=> string(13) "detailsAction" ["class"]=> string(18) "PropertyController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [8]=> array(6) { ["file"]=> string(80) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(293) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(13) "detailsAction" } } [9]=> array(6) { ["file"]=> string(66) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Front.php" ["line"]=> int(914) ["function"]=> string(8) "dispatch" ["class"]=> string(35) "Zend_Controller_Dispatcher_Standard" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Controller_Request_Http)#20 (14) { ["_paramSources:protected"]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri:protected"]=> string(38) "/deer-run-%3A-deer-run-estates/details" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(38) "/deer-run-%3A-deer-run-estates/details" ["_params:protected"]=> array(4) { ["subdivision-name"]=> string(27) "deer-run-:-deer-run-estates" ["controller"]=> string(8) "property" ["action"]=> string(7) "details" ["error_handler"]=> object(ArrayObject)#53 (3) { ["exception"]=> *RECURSION* ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#44 (14) { ["_paramSources:protected"]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri:protected"]=> string(38) "/deer-run-%3A-deer-run-estates/details" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(38) "/deer-run-%3A-deer-run-estates/details" ["_params:protected"]=> array(3) { ["subdivision-name"]=> string(27) "deer-run-:-deer-run-estates" ["controller"]=> string(8) "property" ["action"]=> string(7) "details" } ["_aliases:protected"]=> array(0) { } ["_dispatched:protected"]=> bool(true) ["_module:protected"]=> string(7) "default" ["_moduleKey:protected"]=> string(6) "module" ["_controller:protected"]=> string(8) "property" ["_controllerKey:protected"]=> string(10) "controller" ["_action:protected"]=> string(7) "details" ["_actionKey:protected"]=> string(6) "action" } } } ["_aliases:protected"]=> array(0) { } ["_dispatched:protected"]=> bool(true) ["_module:protected"]=> string(7) "default" ["_moduleKey:protected"]=> string(6) "module" ["_controller:protected"]=> string(5) "error" ["_controllerKey:protected"]=> string(10) "controller" ["_action:protected"]=> string(5) "error" ["_actionKey:protected"]=> string(6) "action" } [1]=> object(Zend_Controller_Response_Http)#21 (8) { ["_body:protected"]=> array(0) { } ["_exceptions:protected"]=> array(1) { [0]=> *RECURSION* } ["_headers:protected"]=> array(0) { } ["_headersRaw:protected"]=> array(0) { } ["_httpResponseCode:protected"]=> int(200) ["_isRedirect:protected"]=> bool(false) ["_renderExceptions:protected"]=> bool(false) ["headersSentThrowsException"]=> bool(true) } } } [10]=> array(6) { ["file"]=> string(31) "/home/ucl/public_html/index.php" ["line"]=> int(139) ["function"]=> string(8) "dispatch" ["class"]=> string(21) "Zend_Controller_Front" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } } } ["_headers:protected"]=> array(0) { } ["_headersRaw:protected"]=> array(0) { } ["_httpResponseCode:protected"]=> int(200) ["_isRedirect:protected"]=> bool(false) ["_renderExceptions:protected"]=> bool(false) ["headersSentThrowsException"]=> bool(true) } } } [10]=> array(6) { ["file"]=> string(31) "/home/ucl/public_html/index.php" ["line"]=> int(139) ["function"]=> string(8) "dispatch" ["class"]=> string(21) "Zend_Controller_Front" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } }