object(Zend_Db_Statement_Mysqli_Exception)#73 (6) { ["message:protected"]=> string(248) "Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '') ORDER BY `Spe' at line 1" ["string:private"]=> string(0) "" ["code:protected"]=> int(0) ["file:protected"]=> string(69) "/home/ucl/public_html/app/zend-framework/Zend/Db/Statement/Mysqli.php" ["line:protected"]=> int(85) ["trace:private"]=> array(11) { [0]=> array(6) { ["file"]=> string(62) "/home/ucl/public_html/app/zend-framework/Zend/Db/Statement.php" ["line"]=> int(109) ["function"]=> string(8) "_prepare" ["class"]=> string(24) "Zend_Db_Statement_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(134) "SELECT `Spec`.* FROM `Spec` WHERE (PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '') ORDER BY `SpecID` ASC" } } [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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(134) "SELECT `Spec`.* FROM `Spec` WHERE (PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '') ORDER BY `SpecID` ASC" } } [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(134) "SELECT `Spec`.* FROM `Spec` WHERE (PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '') ORDER BY `SpecID` ASC" } } [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)#62 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(4) "Spec" ["cols"]=> array(27) { [0]=> string(6) "SpecID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(4) "Type" [6]=> string(10) "SpecNumber" [7]=> string(14) "SpecMoveInDate" [8]=> string(11) "SpecIsModel" [9]=> string(9) "SpecPrice" [10]=> string(12) "ExcludesLand" [11]=> string(8) "SpecSqft" [12]=> string(11) "SpecStories" [13]=> string(13) "SpecUnitLevel" [14]=> string(12) "SpecLocation" [15]=> string(9) "SpecBaths" [16]=> string(13) "SpecHalfBaths" [17]=> string(12) "SpecBedrooms" [18]=> string(17) "MasterBedLocation" [19]=> string(10) "SpecGarage" [20]=> string(5) "Entry" [21]=> string(15) "SpecLivingAreas" [22]=> string(15) "SpecDiningAreas" [23]=> string(12) "SpecBasement" [24]=> string(21) "SpecMarketingHeadline" [25]=> string(15) "SpecDescription" [26]=> string(15) "SpecVirtualTour" } ["primary"]=> array(5) { [1]=> string(6) "SpecID" [2]=> string(6) "PlanID" [3]=> string(13) "SubdivisionID" [4]=> string(9) "BuilderID" [5]=> string(13) "CorporationID" } ["metadata"]=> array(27) { ["SpecID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "SpecID" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["PlanID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "PlanID" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(4) ["IDENTITY"]=> bool(false) } ["CorporationID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "CorporationID" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(5) ["IDENTITY"]=> bool(false) } ["Type"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(4) "Type" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(34) "enum('SingleFamily','MultiFamily')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecNumber" ["COLUMN_POSITION"]=> int(7) ["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) } ["SpecMoveInDate"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(14) "SpecMoveInDate" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(4) "date" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecIsModel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecIsModel" ["COLUMN_POSITION"]=> int(9) ["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) } ["SpecPrice"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecPrice" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ExcludesLand"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "ExcludesLand" ["COLUMN_POSITION"]=> int(11) ["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) } ["SpecSqft"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(8) "SpecSqft" ["COLUMN_POSITION"]=> int(12) ["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) } ["SpecStories"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecStories" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecUnitLevel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecUnitLevel" ["COLUMN_POSITION"]=> int(14) ["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) } ["SpecLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecLocation" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(31) "enum('Corner','Interior','End')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecBaths" ["COLUMN_POSITION"]=> int(16) ["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) } ["SpecHalfBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecHalfBaths" ["COLUMN_POSITION"]=> int(17) ["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) } ["SpecBedrooms"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBedrooms" ["COLUMN_POSITION"]=> int(18) ["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) } ["MasterBedLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(17) "MasterBedLocation" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(21) "enum('*','Down','Up')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecGarage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecGarage" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["Entry"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(5) "Entry" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(27) "enum('Front','Side','Rear')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecLivingAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecLivingAreas" ["COLUMN_POSITION"]=> int(22) ["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) } ["SpecDiningAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDiningAreas" ["COLUMN_POSITION"]=> int(23) ["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) } ["SpecBasement"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBasement" ["COLUMN_POSITION"]=> int(24) ["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) } ["SpecMarketingHeadline"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(21) "SpecMarketingHeadline" ["COLUMN_POSITION"]=> int(25) ["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) } ["SpecDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDescription" ["COLUMN_POSITION"]=> int(26) ["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) } ["SpecVirtualTour"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecVirtualTour" ["COLUMN_POSITION"]=> int(27) ["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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(4) "Spec" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Spec"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(4) "Spec" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(78) "(PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(1) { [0]=> array(2) { [0]=> string(6) "SpecID" [1]=> string(3) "ASC" } } ["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)#62 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(4) "Spec" ["cols"]=> array(27) { [0]=> string(6) "SpecID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(4) "Type" [6]=> string(10) "SpecNumber" [7]=> string(14) "SpecMoveInDate" [8]=> string(11) "SpecIsModel" [9]=> string(9) "SpecPrice" [10]=> string(12) "ExcludesLand" [11]=> string(8) "SpecSqft" [12]=> string(11) "SpecStories" [13]=> string(13) "SpecUnitLevel" [14]=> string(12) "SpecLocation" [15]=> string(9) "SpecBaths" [16]=> string(13) "SpecHalfBaths" [17]=> string(12) "SpecBedrooms" [18]=> string(17) "MasterBedLocation" [19]=> string(10) "SpecGarage" [20]=> string(5) "Entry" [21]=> string(15) "SpecLivingAreas" [22]=> string(15) "SpecDiningAreas" [23]=> string(12) "SpecBasement" [24]=> string(21) "SpecMarketingHeadline" [25]=> string(15) "SpecDescription" [26]=> string(15) "SpecVirtualTour" } ["primary"]=> array(5) { [1]=> string(6) "SpecID" [2]=> string(6) "PlanID" [3]=> string(13) "SubdivisionID" [4]=> string(9) "BuilderID" [5]=> string(13) "CorporationID" } ["metadata"]=> array(27) { ["SpecID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "SpecID" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["PlanID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "PlanID" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(4) ["IDENTITY"]=> bool(false) } ["CorporationID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "CorporationID" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(5) ["IDENTITY"]=> bool(false) } ["Type"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(4) "Type" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(34) "enum('SingleFamily','MultiFamily')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecNumber" ["COLUMN_POSITION"]=> int(7) ["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) } ["SpecMoveInDate"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(14) "SpecMoveInDate" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(4) "date" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecIsModel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecIsModel" ["COLUMN_POSITION"]=> int(9) ["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) } ["SpecPrice"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecPrice" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ExcludesLand"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "ExcludesLand" ["COLUMN_POSITION"]=> int(11) ["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) } ["SpecSqft"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(8) "SpecSqft" ["COLUMN_POSITION"]=> int(12) ["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) } ["SpecStories"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecStories" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecUnitLevel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecUnitLevel" ["COLUMN_POSITION"]=> int(14) ["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) } ["SpecLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecLocation" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(31) "enum('Corner','Interior','End')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecBaths" ["COLUMN_POSITION"]=> int(16) ["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) } ["SpecHalfBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecHalfBaths" ["COLUMN_POSITION"]=> int(17) ["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) } ["SpecBedrooms"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBedrooms" ["COLUMN_POSITION"]=> int(18) ["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) } ["MasterBedLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(17) "MasterBedLocation" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(21) "enum('*','Down','Up')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecGarage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecGarage" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["Entry"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(5) "Entry" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(27) "enum('Front','Side','Rear')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecLivingAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecLivingAreas" ["COLUMN_POSITION"]=> int(22) ["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) } ["SpecDiningAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDiningAreas" ["COLUMN_POSITION"]=> int(23) ["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) } ["SpecBasement"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBasement" ["COLUMN_POSITION"]=> int(24) ["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) } ["SpecMarketingHeadline"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(21) "SpecMarketingHeadline" ["COLUMN_POSITION"]=> int(25) ["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) } ["SpecDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDescription" ["COLUMN_POSITION"]=> int(26) ["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) } ["SpecVirtualTour"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecVirtualTour" ["COLUMN_POSITION"]=> int(27) ["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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(4) "Spec" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Spec"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(4) "Spec" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(78) "(PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(1) { [0]=> array(2) { [0]=> string(6) "SpecID" [1]=> string(3) "ASC" } } ["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(493) ["function"]=> string(8) "fetchAll" ["class"]=> string(22) "Zend_Db_Table_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Table_Select)#62 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(4) "Spec" ["cols"]=> array(27) { [0]=> string(6) "SpecID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(4) "Type" [6]=> string(10) "SpecNumber" [7]=> string(14) "SpecMoveInDate" [8]=> string(11) "SpecIsModel" [9]=> string(9) "SpecPrice" [10]=> string(12) "ExcludesLand" [11]=> string(8) "SpecSqft" [12]=> string(11) "SpecStories" [13]=> string(13) "SpecUnitLevel" [14]=> string(12) "SpecLocation" [15]=> string(9) "SpecBaths" [16]=> string(13) "SpecHalfBaths" [17]=> string(12) "SpecBedrooms" [18]=> string(17) "MasterBedLocation" [19]=> string(10) "SpecGarage" [20]=> string(5) "Entry" [21]=> string(15) "SpecLivingAreas" [22]=> string(15) "SpecDiningAreas" [23]=> string(12) "SpecBasement" [24]=> string(21) "SpecMarketingHeadline" [25]=> string(15) "SpecDescription" [26]=> string(15) "SpecVirtualTour" } ["primary"]=> array(5) { [1]=> string(6) "SpecID" [2]=> string(6) "PlanID" [3]=> string(13) "SubdivisionID" [4]=> string(9) "BuilderID" [5]=> string(13) "CorporationID" } ["metadata"]=> array(27) { ["SpecID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "SpecID" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["PlanID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "PlanID" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(4) ["IDENTITY"]=> bool(false) } ["CorporationID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "CorporationID" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(5) ["IDENTITY"]=> bool(false) } ["Type"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(4) "Type" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(34) "enum('SingleFamily','MultiFamily')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecNumber" ["COLUMN_POSITION"]=> int(7) ["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) } ["SpecMoveInDate"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(14) "SpecMoveInDate" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(4) "date" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecIsModel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecIsModel" ["COLUMN_POSITION"]=> int(9) ["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) } ["SpecPrice"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecPrice" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ExcludesLand"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "ExcludesLand" ["COLUMN_POSITION"]=> int(11) ["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) } ["SpecSqft"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(8) "SpecSqft" ["COLUMN_POSITION"]=> int(12) ["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) } ["SpecStories"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecStories" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecUnitLevel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecUnitLevel" ["COLUMN_POSITION"]=> int(14) ["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) } ["SpecLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecLocation" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(31) "enum('Corner','Interior','End')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecBaths" ["COLUMN_POSITION"]=> int(16) ["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) } ["SpecHalfBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecHalfBaths" ["COLUMN_POSITION"]=> int(17) ["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) } ["SpecBedrooms"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBedrooms" ["COLUMN_POSITION"]=> int(18) ["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) } ["MasterBedLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(17) "MasterBedLocation" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(21) "enum('*','Down','Up')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecGarage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecGarage" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["Entry"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(5) "Entry" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(27) "enum('Front','Side','Rear')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecLivingAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecLivingAreas" ["COLUMN_POSITION"]=> int(22) ["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) } ["SpecDiningAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDiningAreas" ["COLUMN_POSITION"]=> int(23) ["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) } ["SpecBasement"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBasement" ["COLUMN_POSITION"]=> int(24) ["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) } ["SpecMarketingHeadline"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(21) "SpecMarketingHeadline" ["COLUMN_POSITION"]=> int(25) ["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) } ["SpecDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDescription" ["COLUMN_POSITION"]=> int(26) ["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) } ["SpecVirtualTour"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecVirtualTour" ["COLUMN_POSITION"]=> int(27) ["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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(4) "Spec" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Spec"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(4) "Spec" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(78) "(PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(1) { [0]=> array(2) { [0]=> string(6) "SpecID" [1]=> string(3) "ASC" } } ["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(411) ["function"]=> string(18) "_setFloorPlansSpec" ["class"]=> string(18) "PropertyController" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> array(9) { ["MarketName"]=> string(6) "Boston" ["CommunityURL"]=> string(18) "south-natick-hills" ["Subdivision"]=> NULL ["CityStateZip"]=> string(3) ", " ["Latitude"]=> NULL ["Longitude"]=> NULL ["Zip"]=> NULL ["Address"]=> string(7) ", , , " ["Builder"]=> NULL } [1]=> object(Zend_Db_Table_Rowset)#74 (10) { ["_data:protected"]=> array(0) { } ["_table:protected"]=> object(Ucl_Db_Plan)#72 (13) { ["_name:protected"]=> string(4) "Plan" ["_primary:protected"]=> array(4) { [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" } ["_db: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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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) } ["_schema:protected"]=> NULL ["_cols:protected"]=> array(26) { [0]=> string(6) "PlanID" [1]=> string(13) "SubdivisionID" [2]=> string(9) "BuilderID" [3]=> string(13) "CorporationID" [4]=> string(4) "Type" [5]=> string(8) "PlanType" [6]=> string(10) "PlanNumber" [7]=> string(8) "PlanName" [8]=> string(16) "PlanNotAvailable" [9]=> string(12) "PlanTypeName" [10]=> string(9) "BasePrice" [11]=> string(12) "ExcludesLand" [12]=> string(8) "BaseSqft" [13]=> string(7) "Stories" [14]=> string(5) "Baths" [15]=> string(9) "HalfBaths" [16]=> string(8) "Bedrooms" [17]=> string(17) "MasterBedLocation" [18]=> string(6) "Garage" [19]=> string(5) "Entry" [20]=> string(11) "LivingAreas" [21]=> string(11) "DiningAreas" [22]=> string(8) "Basement" [23]=> string(17) "MarketingHeadline" [24]=> string(11) "Description" [25]=> string(20) "EnvisionDesignCenter" } ["_identity:protected"]=> int(1) ["_sequence:protected"]=> bool(true) ["_metadata:protected"]=> array(26) { ["PlanID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(6) "PlanID" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["CorporationID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(13) "CorporationID" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(4) ["IDENTITY"]=> bool(false) } ["Type"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(4) "Type" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(34) "enum('SingleFamily','MultiFamily')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PlanType"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(8) "PlanType" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(92) "enum(' Single Family','Condominium','Townhome','Townhouse',' Carriage House',' Garden Home')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PlanNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(10) "PlanNumber" ["COLUMN_POSITION"]=> int(7) ["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) } ["PlanName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(8) "PlanName" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PlanNotAvailable"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(16) "PlanNotAvailable" ["COLUMN_POSITION"]=> int(9) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PlanTypeName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(12) "PlanTypeName" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(89) "enum('Single Family','Condominium','Townhome','Townhouse','Carriage House','Garden Home')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BasePrice"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(9) "BasePrice" ["COLUMN_POSITION"]=> int(11) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ExcludesLand"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(12) "ExcludesLand" ["COLUMN_POSITION"]=> int(12) ["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) } ["BaseSqft"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(8) "BaseSqft" ["COLUMN_POSITION"]=> int(13) ["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) } ["Stories"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(7) "Stories" ["COLUMN_POSITION"]=> int(14) ["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) } ["Baths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(5) "Baths" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["HalfBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(9) "HalfBaths" ["COLUMN_POSITION"]=> int(16) ["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) } ["Bedrooms"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(8) "Bedrooms" ["COLUMN_POSITION"]=> int(17) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["MasterBedLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(17) "MasterBedLocation" ["COLUMN_POSITION"]=> int(18) ["DATA_TYPE"]=> string(21) "enum('*','Down','Up')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["Garage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(6) "Garage" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["Entry"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(5) "Entry" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(27) "enum('Front','Side','Rear')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LivingAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(11) "LivingAreas" ["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) } ["DiningAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(11) "DiningAreas" ["COLUMN_POSITION"]=> int(22) ["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) } ["Basement"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(8) "Basement" ["COLUMN_POSITION"]=> int(23) ["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) } ["MarketingHeadline"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(17) "MarketingHeadline" ["COLUMN_POSITION"]=> int(24) ["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) } ["Description"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(11) "Description" ["COLUMN_POSITION"]=> int(25) ["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) } ["EnvisionDesignCenter"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(20) "EnvisionDesignCenter" ["COLUMN_POSITION"]=> int(26) ["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) } } ["_metadataCache:protected"]=> NULL ["_rowClass:protected"]=> string(17) "Zend_Db_Table_Row" ["_rowsetClass:protected"]=> string(20) "Zend_Db_Table_Rowset" ["_referenceMap:protected"]=> array(0) { } ["_dependentTables:protected"]=> array(0) { } } ["_connected:protected"]=> bool(true) ["_tableClass:protected"]=> string(11) "Ucl_Db_Plan" ["_rowClass:protected"]=> string(17) "Zend_Db_Table_Row" ["_pointer:protected"]=> int(0) ["_count:protected"]=> int(0) ["_rows:protected"]=> array(0) { } ["_stored:protected"]=> bool(true) ["_readOnly:protected"]=> bool(false) } } } [7]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Action.php" ["line"]=> int(502) ["function"]=> string(16) "floorplansAction" ["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(16) "floorplansAction" } } [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(30) "/south-natick-hills/floorplans" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(30) "/south-natick-hills/floorplans" ["_params:protected"]=> array(5) { ["subdivision-name"]=> string(18) "south-natick-hills" ["controller"]=> string(8) "property" ["action"]=> string(10) "floorplans" ["floorplan"]=> int(0) ["error_handler"]=> object(ArrayObject)#48 (3) { ["exception"]=> object(Zend_Db_Statement_Mysqli_Exception)#73 (6) { ["message:protected"]=> string(248) "Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '') ORDER BY `Spe' at line 1" ["string:private"]=> string(0) "" ["code:protected"]=> int(0) ["file:protected"]=> string(69) "/home/ucl/public_html/app/zend-framework/Zend/Db/Statement/Mysqli.php" ["line:protected"]=> int(85) ["trace:private"]=> array(11) { [0]=> array(6) { ["file"]=> string(62) "/home/ucl/public_html/app/zend-framework/Zend/Db/Statement.php" ["line"]=> int(109) ["function"]=> string(8) "_prepare" ["class"]=> string(24) "Zend_Db_Statement_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(134) "SELECT `Spec`.* FROM `Spec` WHERE (PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '') ORDER BY `SpecID` ASC" } } [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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(134) "SELECT `Spec`.* FROM `Spec` WHERE (PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '') ORDER BY `SpecID` ASC" } } [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(134) "SELECT `Spec`.* FROM `Spec` WHERE (PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '') ORDER BY `SpecID` ASC" } } [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)#62 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(4) "Spec" ["cols"]=> array(27) { [0]=> string(6) "SpecID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(4) "Type" [6]=> string(10) "SpecNumber" [7]=> string(14) "SpecMoveInDate" [8]=> string(11) "SpecIsModel" [9]=> string(9) "SpecPrice" [10]=> string(12) "ExcludesLand" [11]=> string(8) "SpecSqft" [12]=> string(11) "SpecStories" [13]=> string(13) "SpecUnitLevel" [14]=> string(12) "SpecLocation" [15]=> string(9) "SpecBaths" [16]=> string(13) "SpecHalfBaths" [17]=> string(12) "SpecBedrooms" [18]=> string(17) "MasterBedLocation" [19]=> string(10) "SpecGarage" [20]=> string(5) "Entry" [21]=> string(15) "SpecLivingAreas" [22]=> string(15) "SpecDiningAreas" [23]=> string(12) "SpecBasement" [24]=> string(21) "SpecMarketingHeadline" [25]=> string(15) "SpecDescription" [26]=> string(15) "SpecVirtualTour" } ["primary"]=> array(5) { [1]=> string(6) "SpecID" [2]=> string(6) "PlanID" [3]=> string(13) "SubdivisionID" [4]=> string(9) "BuilderID" [5]=> string(13) "CorporationID" } ["metadata"]=> array(27) { ["SpecID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "SpecID" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["PlanID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "PlanID" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(4) ["IDENTITY"]=> bool(false) } ["CorporationID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "CorporationID" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(5) ["IDENTITY"]=> bool(false) } ["Type"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(4) "Type" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(34) "enum('SingleFamily','MultiFamily')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecNumber" ["COLUMN_POSITION"]=> int(7) ["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) } ["SpecMoveInDate"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(14) "SpecMoveInDate" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(4) "date" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecIsModel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecIsModel" ["COLUMN_POSITION"]=> int(9) ["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) } ["SpecPrice"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecPrice" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ExcludesLand"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "ExcludesLand" ["COLUMN_POSITION"]=> int(11) ["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) } ["SpecSqft"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(8) "SpecSqft" ["COLUMN_POSITION"]=> int(12) ["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) } ["SpecStories"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecStories" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecUnitLevel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecUnitLevel" ["COLUMN_POSITION"]=> int(14) ["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) } ["SpecLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecLocation" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(31) "enum('Corner','Interior','End')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecBaths" ["COLUMN_POSITION"]=> int(16) ["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) } ["SpecHalfBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecHalfBaths" ["COLUMN_POSITION"]=> int(17) ["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) } ["SpecBedrooms"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBedrooms" ["COLUMN_POSITION"]=> int(18) ["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) } ["MasterBedLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(17) "MasterBedLocation" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(21) "enum('*','Down','Up')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecGarage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecGarage" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["Entry"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(5) "Entry" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(27) "enum('Front','Side','Rear')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecLivingAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecLivingAreas" ["COLUMN_POSITION"]=> int(22) ["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) } ["SpecDiningAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDiningAreas" ["COLUMN_POSITION"]=> int(23) ["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) } ["SpecBasement"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBasement" ["COLUMN_POSITION"]=> int(24) ["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) } ["SpecMarketingHeadline"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(21) "SpecMarketingHeadline" ["COLUMN_POSITION"]=> int(25) ["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) } ["SpecDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDescription" ["COLUMN_POSITION"]=> int(26) ["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) } ["SpecVirtualTour"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecVirtualTour" ["COLUMN_POSITION"]=> int(27) ["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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(4) "Spec" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Spec"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(4) "Spec" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(78) "(PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(1) { [0]=> array(2) { [0]=> string(6) "SpecID" [1]=> string(3) "ASC" } } ["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)#62 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(4) "Spec" ["cols"]=> array(27) { [0]=> string(6) "SpecID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(4) "Type" [6]=> string(10) "SpecNumber" [7]=> string(14) "SpecMoveInDate" [8]=> string(11) "SpecIsModel" [9]=> string(9) "SpecPrice" [10]=> string(12) "ExcludesLand" [11]=> string(8) "SpecSqft" [12]=> string(11) "SpecStories" [13]=> string(13) "SpecUnitLevel" [14]=> string(12) "SpecLocation" [15]=> string(9) "SpecBaths" [16]=> string(13) "SpecHalfBaths" [17]=> string(12) "SpecBedrooms" [18]=> string(17) "MasterBedLocation" [19]=> string(10) "SpecGarage" [20]=> string(5) "Entry" [21]=> string(15) "SpecLivingAreas" [22]=> string(15) "SpecDiningAreas" [23]=> string(12) "SpecBasement" [24]=> string(21) "SpecMarketingHeadline" [25]=> string(15) "SpecDescription" [26]=> string(15) "SpecVirtualTour" } ["primary"]=> array(5) { [1]=> string(6) "SpecID" [2]=> string(6) "PlanID" [3]=> string(13) "SubdivisionID" [4]=> string(9) "BuilderID" [5]=> string(13) "CorporationID" } ["metadata"]=> array(27) { ["SpecID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "SpecID" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["PlanID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "PlanID" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(4) ["IDENTITY"]=> bool(false) } ["CorporationID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "CorporationID" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(5) ["IDENTITY"]=> bool(false) } ["Type"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(4) "Type" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(34) "enum('SingleFamily','MultiFamily')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecNumber" ["COLUMN_POSITION"]=> int(7) ["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) } ["SpecMoveInDate"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(14) "SpecMoveInDate" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(4) "date" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecIsModel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecIsModel" ["COLUMN_POSITION"]=> int(9) ["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) } ["SpecPrice"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecPrice" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ExcludesLand"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "ExcludesLand" ["COLUMN_POSITION"]=> int(11) ["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) } ["SpecSqft"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(8) "SpecSqft" ["COLUMN_POSITION"]=> int(12) ["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) } ["SpecStories"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecStories" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecUnitLevel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecUnitLevel" ["COLUMN_POSITION"]=> int(14) ["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) } ["SpecLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecLocation" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(31) "enum('Corner','Interior','End')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecBaths" ["COLUMN_POSITION"]=> int(16) ["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) } ["SpecHalfBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecHalfBaths" ["COLUMN_POSITION"]=> int(17) ["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) } ["SpecBedrooms"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBedrooms" ["COLUMN_POSITION"]=> int(18) ["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) } ["MasterBedLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(17) "MasterBedLocation" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(21) "enum('*','Down','Up')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecGarage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecGarage" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["Entry"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(5) "Entry" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(27) "enum('Front','Side','Rear')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecLivingAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecLivingAreas" ["COLUMN_POSITION"]=> int(22) ["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) } ["SpecDiningAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDiningAreas" ["COLUMN_POSITION"]=> int(23) ["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) } ["SpecBasement"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBasement" ["COLUMN_POSITION"]=> int(24) ["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) } ["SpecMarketingHeadline"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(21) "SpecMarketingHeadline" ["COLUMN_POSITION"]=> int(25) ["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) } ["SpecDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDescription" ["COLUMN_POSITION"]=> int(26) ["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) } ["SpecVirtualTour"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecVirtualTour" ["COLUMN_POSITION"]=> int(27) ["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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(4) "Spec" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Spec"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(4) "Spec" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(78) "(PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(1) { [0]=> array(2) { [0]=> string(6) "SpecID" [1]=> string(3) "ASC" } } ["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(493) ["function"]=> string(8) "fetchAll" ["class"]=> string(22) "Zend_Db_Table_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Table_Select)#62 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(4) "Spec" ["cols"]=> array(27) { [0]=> string(6) "SpecID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(4) "Type" [6]=> string(10) "SpecNumber" [7]=> string(14) "SpecMoveInDate" [8]=> string(11) "SpecIsModel" [9]=> string(9) "SpecPrice" [10]=> string(12) "ExcludesLand" [11]=> string(8) "SpecSqft" [12]=> string(11) "SpecStories" [13]=> string(13) "SpecUnitLevel" [14]=> string(12) "SpecLocation" [15]=> string(9) "SpecBaths" [16]=> string(13) "SpecHalfBaths" [17]=> string(12) "SpecBedrooms" [18]=> string(17) "MasterBedLocation" [19]=> string(10) "SpecGarage" [20]=> string(5) "Entry" [21]=> string(15) "SpecLivingAreas" [22]=> string(15) "SpecDiningAreas" [23]=> string(12) "SpecBasement" [24]=> string(21) "SpecMarketingHeadline" [25]=> string(15) "SpecDescription" [26]=> string(15) "SpecVirtualTour" } ["primary"]=> array(5) { [1]=> string(6) "SpecID" [2]=> string(6) "PlanID" [3]=> string(13) "SubdivisionID" [4]=> string(9) "BuilderID" [5]=> string(13) "CorporationID" } ["metadata"]=> array(27) { ["SpecID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "SpecID" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["PlanID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "PlanID" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(4) ["IDENTITY"]=> bool(false) } ["CorporationID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "CorporationID" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(5) ["IDENTITY"]=> bool(false) } ["Type"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(4) "Type" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(34) "enum('SingleFamily','MultiFamily')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecNumber" ["COLUMN_POSITION"]=> int(7) ["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) } ["SpecMoveInDate"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(14) "SpecMoveInDate" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(4) "date" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecIsModel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecIsModel" ["COLUMN_POSITION"]=> int(9) ["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) } ["SpecPrice"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecPrice" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ExcludesLand"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "ExcludesLand" ["COLUMN_POSITION"]=> int(11) ["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) } ["SpecSqft"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(8) "SpecSqft" ["COLUMN_POSITION"]=> int(12) ["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) } ["SpecStories"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecStories" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecUnitLevel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecUnitLevel" ["COLUMN_POSITION"]=> int(14) ["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) } ["SpecLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecLocation" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(31) "enum('Corner','Interior','End')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecBaths" ["COLUMN_POSITION"]=> int(16) ["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) } ["SpecHalfBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecHalfBaths" ["COLUMN_POSITION"]=> int(17) ["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) } ["SpecBedrooms"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBedrooms" ["COLUMN_POSITION"]=> int(18) ["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) } ["MasterBedLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(17) "MasterBedLocation" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(21) "enum('*','Down','Up')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecGarage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecGarage" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["Entry"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(5) "Entry" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(27) "enum('Front','Side','Rear')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecLivingAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecLivingAreas" ["COLUMN_POSITION"]=> int(22) ["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) } ["SpecDiningAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDiningAreas" ["COLUMN_POSITION"]=> int(23) ["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) } ["SpecBasement"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBasement" ["COLUMN_POSITION"]=> int(24) ["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) } ["SpecMarketingHeadline"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(21) "SpecMarketingHeadline" ["COLUMN_POSITION"]=> int(25) ["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) } ["SpecDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDescription" ["COLUMN_POSITION"]=> int(26) ["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) } ["SpecVirtualTour"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecVirtualTour" ["COLUMN_POSITION"]=> int(27) ["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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(4) "Spec" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Spec"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(4) "Spec" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(78) "(PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(1) { [0]=> array(2) { [0]=> string(6) "SpecID" [1]=> string(3) "ASC" } } ["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(411) ["function"]=> string(18) "_setFloorPlansSpec" ["class"]=> string(18) "PropertyController" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> array(9) { ["MarketName"]=> string(6) "Boston" ["CommunityURL"]=> string(18) "south-natick-hills" ["Subdivision"]=> NULL ["CityStateZip"]=> string(3) ", " ["Latitude"]=> NULL ["Longitude"]=> NULL ["Zip"]=> NULL ["Address"]=> string(7) ", , , " ["Builder"]=> NULL } [1]=> object(Zend_Db_Table_Rowset)#74 (10) { ["_data:protected"]=> array(0) { } ["_table:protected"]=> object(Ucl_Db_Plan)#72 (13) { ["_name:protected"]=> string(4) "Plan" ["_primary:protected"]=> array(4) { [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" } ["_db: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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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) } ["_schema:protected"]=> NULL ["_cols:protected"]=> array(26) { [0]=> string(6) "PlanID" [1]=> string(13) "SubdivisionID" [2]=> string(9) "BuilderID" [3]=> string(13) "CorporationID" [4]=> string(4) "Type" [5]=> string(8) "PlanType" [6]=> string(10) "PlanNumber" [7]=> string(8) "PlanName" [8]=> string(16) "PlanNotAvailable" [9]=> string(12) "PlanTypeName" [10]=> string(9) "BasePrice" [11]=> string(12) "ExcludesLand" [12]=> string(8) "BaseSqft" [13]=> string(7) "Stories" [14]=> string(5) "Baths" [15]=> string(9) "HalfBaths" [16]=> string(8) "Bedrooms" [17]=> string(17) "MasterBedLocation" [18]=> string(6) "Garage" [19]=> string(5) "Entry" [20]=> string(11) "LivingAreas" [21]=> string(11) "DiningAreas" [22]=> string(8) "Basement" [23]=> string(17) "MarketingHeadline" [24]=> string(11) "Description" [25]=> string(20) "EnvisionDesignCenter" } ["_identity:protected"]=> int(1) ["_sequence:protected"]=> bool(true) ["_metadata:protected"]=> array(26) { ["PlanID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(6) "PlanID" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["CorporationID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(13) "CorporationID" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(4) ["IDENTITY"]=> bool(false) } ["Type"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(4) "Type" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(34) "enum('SingleFamily','MultiFamily')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PlanType"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(8) "PlanType" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(92) "enum(' Single Family','Condominium','Townhome','Townhouse',' Carriage House',' Garden Home')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PlanNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(10) "PlanNumber" ["COLUMN_POSITION"]=> int(7) ["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) } ["PlanName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(8) "PlanName" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PlanNotAvailable"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(16) "PlanNotAvailable" ["COLUMN_POSITION"]=> int(9) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PlanTypeName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(12) "PlanTypeName" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(89) "enum('Single Family','Condominium','Townhome','Townhouse','Carriage House','Garden Home')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BasePrice"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(9) "BasePrice" ["COLUMN_POSITION"]=> int(11) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ExcludesLand"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(12) "ExcludesLand" ["COLUMN_POSITION"]=> int(12) ["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) } ["BaseSqft"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(8) "BaseSqft" ["COLUMN_POSITION"]=> int(13) ["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) } ["Stories"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(7) "Stories" ["COLUMN_POSITION"]=> int(14) ["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) } ["Baths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(5) "Baths" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["HalfBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(9) "HalfBaths" ["COLUMN_POSITION"]=> int(16) ["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) } ["Bedrooms"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(8) "Bedrooms" ["COLUMN_POSITION"]=> int(17) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["MasterBedLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(17) "MasterBedLocation" ["COLUMN_POSITION"]=> int(18) ["DATA_TYPE"]=> string(21) "enum('*','Down','Up')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["Garage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(6) "Garage" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["Entry"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(5) "Entry" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(27) "enum('Front','Side','Rear')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LivingAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(11) "LivingAreas" ["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) } ["DiningAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(11) "DiningAreas" ["COLUMN_POSITION"]=> int(22) ["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) } ["Basement"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(8) "Basement" ["COLUMN_POSITION"]=> int(23) ["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) } ["MarketingHeadline"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(17) "MarketingHeadline" ["COLUMN_POSITION"]=> int(24) ["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) } ["Description"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(11) "Description" ["COLUMN_POSITION"]=> int(25) ["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) } ["EnvisionDesignCenter"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(20) "EnvisionDesignCenter" ["COLUMN_POSITION"]=> int(26) ["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) } } ["_metadataCache:protected"]=> NULL ["_rowClass:protected"]=> string(17) "Zend_Db_Table_Row" ["_rowsetClass:protected"]=> string(20) "Zend_Db_Table_Rowset" ["_referenceMap:protected"]=> array(0) { } ["_dependentTables:protected"]=> array(0) { } } ["_connected:protected"]=> bool(true) ["_tableClass:protected"]=> string(11) "Ucl_Db_Plan" ["_rowClass:protected"]=> string(17) "Zend_Db_Table_Row" ["_pointer:protected"]=> int(0) ["_count:protected"]=> int(0) ["_rows:protected"]=> array(0) { } ["_stored:protected"]=> bool(true) ["_readOnly:protected"]=> bool(false) } } } [7]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Action.php" ["line"]=> int(502) ["function"]=> string(16) "floorplansAction" ["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(16) "floorplansAction" } } [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(30) "/south-natick-hills/floorplans" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(30) "/south-natick-hills/floorplans" ["_params:protected"]=> array(5) { ["subdivision-name"]=> string(18) "south-natick-hills" ["controller"]=> string(8) "property" ["action"]=> string(10) "floorplans" ["floorplan"]=> int(0) ["error_handler"]=> object(ArrayObject)#48 (3) { ["exception"]=> *RECURSION* ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#67 (14) { ["_paramSources:protected"]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri:protected"]=> string(30) "/south-natick-hills/floorplans" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(30) "/south-natick-hills/floorplans" ["_params:protected"]=> array(4) { ["subdivision-name"]=> string(18) "south-natick-hills" ["controller"]=> string(8) "property" ["action"]=> string(10) "floorplans" ["floorplan"]=> int(0) } ["_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(10) "floorplans" ["_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(143) ["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)#67 (14) { ["_paramSources:protected"]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri:protected"]=> string(30) "/south-natick-hills/floorplans" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(30) "/south-natick-hills/floorplans" ["_params:protected"]=> array(4) { ["subdivision-name"]=> string(18) "south-natick-hills" ["controller"]=> string(8) "property" ["action"]=> string(10) "floorplans" ["floorplan"]=> int(0) } ["_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(10) "floorplans" ["_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_Mysqli_Exception)#73 (6) { ["message:protected"]=> string(248) "Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '') ORDER BY `Spe' at line 1" ["string:private"]=> string(0) "" ["code:protected"]=> int(0) ["file:protected"]=> string(69) "/home/ucl/public_html/app/zend-framework/Zend/Db/Statement/Mysqli.php" ["line:protected"]=> int(85) ["trace:private"]=> array(11) { [0]=> array(6) { ["file"]=> string(62) "/home/ucl/public_html/app/zend-framework/Zend/Db/Statement.php" ["line"]=> int(109) ["function"]=> string(8) "_prepare" ["class"]=> string(24) "Zend_Db_Statement_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(134) "SELECT `Spec`.* FROM `Spec` WHERE (PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '') ORDER BY `SpecID` ASC" } } [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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(134) "SELECT `Spec`.* FROM `Spec` WHERE (PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '') ORDER BY `SpecID` ASC" } } [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(134) "SELECT `Spec`.* FROM `Spec` WHERE (PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '') ORDER BY `SpecID` ASC" } } [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)#62 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(4) "Spec" ["cols"]=> array(27) { [0]=> string(6) "SpecID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(4) "Type" [6]=> string(10) "SpecNumber" [7]=> string(14) "SpecMoveInDate" [8]=> string(11) "SpecIsModel" [9]=> string(9) "SpecPrice" [10]=> string(12) "ExcludesLand" [11]=> string(8) "SpecSqft" [12]=> string(11) "SpecStories" [13]=> string(13) "SpecUnitLevel" [14]=> string(12) "SpecLocation" [15]=> string(9) "SpecBaths" [16]=> string(13) "SpecHalfBaths" [17]=> string(12) "SpecBedrooms" [18]=> string(17) "MasterBedLocation" [19]=> string(10) "SpecGarage" [20]=> string(5) "Entry" [21]=> string(15) "SpecLivingAreas" [22]=> string(15) "SpecDiningAreas" [23]=> string(12) "SpecBasement" [24]=> string(21) "SpecMarketingHeadline" [25]=> string(15) "SpecDescription" [26]=> string(15) "SpecVirtualTour" } ["primary"]=> array(5) { [1]=> string(6) "SpecID" [2]=> string(6) "PlanID" [3]=> string(13) "SubdivisionID" [4]=> string(9) "BuilderID" [5]=> string(13) "CorporationID" } ["metadata"]=> array(27) { ["SpecID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "SpecID" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["PlanID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "PlanID" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(4) ["IDENTITY"]=> bool(false) } ["CorporationID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "CorporationID" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(5) ["IDENTITY"]=> bool(false) } ["Type"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(4) "Type" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(34) "enum('SingleFamily','MultiFamily')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecNumber" ["COLUMN_POSITION"]=> int(7) ["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) } ["SpecMoveInDate"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(14) "SpecMoveInDate" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(4) "date" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecIsModel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecIsModel" ["COLUMN_POSITION"]=> int(9) ["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) } ["SpecPrice"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecPrice" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ExcludesLand"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "ExcludesLand" ["COLUMN_POSITION"]=> int(11) ["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) } ["SpecSqft"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(8) "SpecSqft" ["COLUMN_POSITION"]=> int(12) ["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) } ["SpecStories"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecStories" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecUnitLevel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecUnitLevel" ["COLUMN_POSITION"]=> int(14) ["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) } ["SpecLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecLocation" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(31) "enum('Corner','Interior','End')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecBaths" ["COLUMN_POSITION"]=> int(16) ["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) } ["SpecHalfBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecHalfBaths" ["COLUMN_POSITION"]=> int(17) ["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) } ["SpecBedrooms"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBedrooms" ["COLUMN_POSITION"]=> int(18) ["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) } ["MasterBedLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(17) "MasterBedLocation" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(21) "enum('*','Down','Up')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecGarage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecGarage" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["Entry"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(5) "Entry" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(27) "enum('Front','Side','Rear')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecLivingAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecLivingAreas" ["COLUMN_POSITION"]=> int(22) ["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) } ["SpecDiningAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDiningAreas" ["COLUMN_POSITION"]=> int(23) ["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) } ["SpecBasement"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBasement" ["COLUMN_POSITION"]=> int(24) ["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) } ["SpecMarketingHeadline"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(21) "SpecMarketingHeadline" ["COLUMN_POSITION"]=> int(25) ["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) } ["SpecDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDescription" ["COLUMN_POSITION"]=> int(26) ["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) } ["SpecVirtualTour"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecVirtualTour" ["COLUMN_POSITION"]=> int(27) ["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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(4) "Spec" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Spec"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(4) "Spec" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(78) "(PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(1) { [0]=> array(2) { [0]=> string(6) "SpecID" [1]=> string(3) "ASC" } } ["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)#62 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(4) "Spec" ["cols"]=> array(27) { [0]=> string(6) "SpecID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(4) "Type" [6]=> string(10) "SpecNumber" [7]=> string(14) "SpecMoveInDate" [8]=> string(11) "SpecIsModel" [9]=> string(9) "SpecPrice" [10]=> string(12) "ExcludesLand" [11]=> string(8) "SpecSqft" [12]=> string(11) "SpecStories" [13]=> string(13) "SpecUnitLevel" [14]=> string(12) "SpecLocation" [15]=> string(9) "SpecBaths" [16]=> string(13) "SpecHalfBaths" [17]=> string(12) "SpecBedrooms" [18]=> string(17) "MasterBedLocation" [19]=> string(10) "SpecGarage" [20]=> string(5) "Entry" [21]=> string(15) "SpecLivingAreas" [22]=> string(15) "SpecDiningAreas" [23]=> string(12) "SpecBasement" [24]=> string(21) "SpecMarketingHeadline" [25]=> string(15) "SpecDescription" [26]=> string(15) "SpecVirtualTour" } ["primary"]=> array(5) { [1]=> string(6) "SpecID" [2]=> string(6) "PlanID" [3]=> string(13) "SubdivisionID" [4]=> string(9) "BuilderID" [5]=> string(13) "CorporationID" } ["metadata"]=> array(27) { ["SpecID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "SpecID" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["PlanID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "PlanID" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(4) ["IDENTITY"]=> bool(false) } ["CorporationID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "CorporationID" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(5) ["IDENTITY"]=> bool(false) } ["Type"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(4) "Type" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(34) "enum('SingleFamily','MultiFamily')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecNumber" ["COLUMN_POSITION"]=> int(7) ["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) } ["SpecMoveInDate"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(14) "SpecMoveInDate" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(4) "date" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecIsModel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecIsModel" ["COLUMN_POSITION"]=> int(9) ["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) } ["SpecPrice"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecPrice" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ExcludesLand"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "ExcludesLand" ["COLUMN_POSITION"]=> int(11) ["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) } ["SpecSqft"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(8) "SpecSqft" ["COLUMN_POSITION"]=> int(12) ["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) } ["SpecStories"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecStories" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecUnitLevel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecUnitLevel" ["COLUMN_POSITION"]=> int(14) ["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) } ["SpecLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecLocation" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(31) "enum('Corner','Interior','End')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecBaths" ["COLUMN_POSITION"]=> int(16) ["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) } ["SpecHalfBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecHalfBaths" ["COLUMN_POSITION"]=> int(17) ["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) } ["SpecBedrooms"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBedrooms" ["COLUMN_POSITION"]=> int(18) ["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) } ["MasterBedLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(17) "MasterBedLocation" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(21) "enum('*','Down','Up')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecGarage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecGarage" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["Entry"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(5) "Entry" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(27) "enum('Front','Side','Rear')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecLivingAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecLivingAreas" ["COLUMN_POSITION"]=> int(22) ["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) } ["SpecDiningAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDiningAreas" ["COLUMN_POSITION"]=> int(23) ["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) } ["SpecBasement"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBasement" ["COLUMN_POSITION"]=> int(24) ["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) } ["SpecMarketingHeadline"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(21) "SpecMarketingHeadline" ["COLUMN_POSITION"]=> int(25) ["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) } ["SpecDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDescription" ["COLUMN_POSITION"]=> int(26) ["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) } ["SpecVirtualTour"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecVirtualTour" ["COLUMN_POSITION"]=> int(27) ["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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(4) "Spec" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Spec"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(4) "Spec" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(78) "(PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(1) { [0]=> array(2) { [0]=> string(6) "SpecID" [1]=> string(3) "ASC" } } ["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(493) ["function"]=> string(8) "fetchAll" ["class"]=> string(22) "Zend_Db_Table_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Table_Select)#62 (5) { ["_info:protected"]=> array(10) { ["schema"]=> NULL ["name"]=> string(4) "Spec" ["cols"]=> array(27) { [0]=> string(6) "SpecID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(4) "Type" [6]=> string(10) "SpecNumber" [7]=> string(14) "SpecMoveInDate" [8]=> string(11) "SpecIsModel" [9]=> string(9) "SpecPrice" [10]=> string(12) "ExcludesLand" [11]=> string(8) "SpecSqft" [12]=> string(11) "SpecStories" [13]=> string(13) "SpecUnitLevel" [14]=> string(12) "SpecLocation" [15]=> string(9) "SpecBaths" [16]=> string(13) "SpecHalfBaths" [17]=> string(12) "SpecBedrooms" [18]=> string(17) "MasterBedLocation" [19]=> string(10) "SpecGarage" [20]=> string(5) "Entry" [21]=> string(15) "SpecLivingAreas" [22]=> string(15) "SpecDiningAreas" [23]=> string(12) "SpecBasement" [24]=> string(21) "SpecMarketingHeadline" [25]=> string(15) "SpecDescription" [26]=> string(15) "SpecVirtualTour" } ["primary"]=> array(5) { [1]=> string(6) "SpecID" [2]=> string(6) "PlanID" [3]=> string(13) "SubdivisionID" [4]=> string(9) "BuilderID" [5]=> string(13) "CorporationID" } ["metadata"]=> array(27) { ["SpecID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "SpecID" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["PlanID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(6) "PlanID" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(4) ["IDENTITY"]=> bool(false) } ["CorporationID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "CorporationID" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(5) ["IDENTITY"]=> bool(false) } ["Type"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(4) "Type" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(34) "enum('SingleFamily','MultiFamily')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecNumber" ["COLUMN_POSITION"]=> int(7) ["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) } ["SpecMoveInDate"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(14) "SpecMoveInDate" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(4) "date" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecIsModel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecIsModel" ["COLUMN_POSITION"]=> int(9) ["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) } ["SpecPrice"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecPrice" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ExcludesLand"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "ExcludesLand" ["COLUMN_POSITION"]=> int(11) ["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) } ["SpecSqft"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(8) "SpecSqft" ["COLUMN_POSITION"]=> int(12) ["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) } ["SpecStories"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(11) "SpecStories" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecUnitLevel"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecUnitLevel" ["COLUMN_POSITION"]=> int(14) ["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) } ["SpecLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecLocation" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(31) "enum('Corner','Interior','End')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(9) "SpecBaths" ["COLUMN_POSITION"]=> int(16) ["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) } ["SpecHalfBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(13) "SpecHalfBaths" ["COLUMN_POSITION"]=> int(17) ["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) } ["SpecBedrooms"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBedrooms" ["COLUMN_POSITION"]=> int(18) ["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) } ["MasterBedLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(17) "MasterBedLocation" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(21) "enum('*','Down','Up')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecGarage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(10) "SpecGarage" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["Entry"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(5) "Entry" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(27) "enum('Front','Side','Rear')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["SpecLivingAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecLivingAreas" ["COLUMN_POSITION"]=> int(22) ["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) } ["SpecDiningAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDiningAreas" ["COLUMN_POSITION"]=> int(23) ["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) } ["SpecBasement"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(12) "SpecBasement" ["COLUMN_POSITION"]=> int(24) ["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) } ["SpecMarketingHeadline"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(21) "SpecMarketingHeadline" ["COLUMN_POSITION"]=> int(25) ["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) } ["SpecDescription"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecDescription" ["COLUMN_POSITION"]=> int(26) ["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) } ["SpecVirtualTour"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Spec" ["COLUMN_NAME"]=> string(15) "SpecVirtualTour" ["COLUMN_POSITION"]=> int(27) ["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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(4) "Spec" [1]=> string(1) "*" [2]=> NULL } } ["from"]=> array(1) { ["Spec"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(4) "Spec" ["joinCondition"]=> NULL } } ["where"]=> array(1) { [0]=> string(78) "(PlanID IN () AND SubdivisionID = '' AND BuilderID ='' AND CorporationID = '')" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(1) { [0]=> array(2) { [0]=> string(6) "SpecID" [1]=> string(3) "ASC" } } ["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(411) ["function"]=> string(18) "_setFloorPlansSpec" ["class"]=> string(18) "PropertyController" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> array(9) { ["MarketName"]=> string(6) "Boston" ["CommunityURL"]=> string(18) "south-natick-hills" ["Subdivision"]=> NULL ["CityStateZip"]=> string(3) ", " ["Latitude"]=> NULL ["Longitude"]=> NULL ["Zip"]=> NULL ["Address"]=> string(7) ", , , " ["Builder"]=> NULL } [1]=> object(Zend_Db_Table_Rowset)#74 (10) { ["_data:protected"]=> array(0) { } ["_table:protected"]=> object(Ucl_Db_Plan)#72 (13) { ["_name:protected"]=> string(4) "Plan" ["_primary:protected"]=> array(4) { [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" } ["_db: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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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)#61 (12) { ["_stmt:protected"]=> NULL ["_keys:protected"]=> array(10) { [0]=> string(16) "FloorPlanImageID" [1]=> string(6) "PlanID" [2]=> string(13) "SubdivisionID" [3]=> string(9) "BuilderID" [4]=> string(13) "CorporationID" [5]=> string(16) "SequencePosition" [6]=> string(5) "Title" [7]=> string(7) "Caption" [8]=> string(13) "ReferenceType" [9]=> string(14) "FloorPlanImage" } ["_values:protected"]=> array(10) { [0]=> int(0) [1]=> int(0) [2]=> int(0) [3]=> int(0) [4]=> int(0) [5]=> int(0) [6]=> NULL [7]=> NULL [8]=> NULL [9]=> NULL } ["_meta:protected"]=> object(mysqli_result)#57 (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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_sqlParam:protected"]=> array(1) { [0]=> string(105) "SELECT .* FROM WHERE (PlanID = AND SubdivisionID = AND BuilderID = AND CorporationID = ) ORDER BY ASC" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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) } ["_schema:protected"]=> NULL ["_cols:protected"]=> array(26) { [0]=> string(6) "PlanID" [1]=> string(13) "SubdivisionID" [2]=> string(9) "BuilderID" [3]=> string(13) "CorporationID" [4]=> string(4) "Type" [5]=> string(8) "PlanType" [6]=> string(10) "PlanNumber" [7]=> string(8) "PlanName" [8]=> string(16) "PlanNotAvailable" [9]=> string(12) "PlanTypeName" [10]=> string(9) "BasePrice" [11]=> string(12) "ExcludesLand" [12]=> string(8) "BaseSqft" [13]=> string(7) "Stories" [14]=> string(5) "Baths" [15]=> string(9) "HalfBaths" [16]=> string(8) "Bedrooms" [17]=> string(17) "MasterBedLocation" [18]=> string(6) "Garage" [19]=> string(5) "Entry" [20]=> string(11) "LivingAreas" [21]=> string(11) "DiningAreas" [22]=> string(8) "Basement" [23]=> string(17) "MarketingHeadline" [24]=> string(11) "Description" [25]=> string(20) "EnvisionDesignCenter" } ["_identity:protected"]=> int(1) ["_sequence:protected"]=> bool(true) ["_metadata:protected"]=> array(26) { ["PlanID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(6) "PlanID" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(false) } ["SubdivisionID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(13) "SubdivisionID" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(2) ["IDENTITY"]=> bool(false) } ["BuilderID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(9) "BuilderID" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(3) ["IDENTITY"]=> bool(false) } ["CorporationID"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(13) "CorporationID" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(4) ["IDENTITY"]=> bool(false) } ["Type"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(4) "Type" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(34) "enum('SingleFamily','MultiFamily')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PlanType"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(8) "PlanType" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(92) "enum(' Single Family','Condominium','Townhome','Townhouse',' Carriage House',' Garden Home')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PlanNumber"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(10) "PlanNumber" ["COLUMN_POSITION"]=> int(7) ["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) } ["PlanName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(8) "PlanName" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(4) "char" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "50" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PlanNotAvailable"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(16) "PlanNotAvailable" ["COLUMN_POSITION"]=> int(9) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["PlanTypeName"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(12) "PlanTypeName" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(89) "enum('Single Family','Condominium','Townhome','Townhouse','Carriage House','Garden Home')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["BasePrice"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(9) "BasePrice" ["COLUMN_POSITION"]=> int(11) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["ExcludesLand"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(12) "ExcludesLand" ["COLUMN_POSITION"]=> int(12) ["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) } ["BaseSqft"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(8) "BaseSqft" ["COLUMN_POSITION"]=> int(13) ["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) } ["Stories"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(7) "Stories" ["COLUMN_POSITION"]=> int(14) ["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) } ["Baths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(5) "Baths" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["HalfBaths"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(9) "HalfBaths" ["COLUMN_POSITION"]=> int(16) ["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) } ["Bedrooms"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(8) "Bedrooms" ["COLUMN_POSITION"]=> int(17) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["MasterBedLocation"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(17) "MasterBedLocation" ["COLUMN_POSITION"]=> int(18) ["DATA_TYPE"]=> string(21) "enum('*','Down','Up')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["Garage"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(6) "Garage" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(7) "decimal" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> string(1) "0" ["PRECISION"]=> string(2) "10" ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["Entry"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(5) "Entry" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(27) "enum('Front','Side','Rear')" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["LivingAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(11) "LivingAreas" ["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) } ["DiningAreas"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(11) "DiningAreas" ["COLUMN_POSITION"]=> int(22) ["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) } ["Basement"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(8) "Basement" ["COLUMN_POSITION"]=> int(23) ["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) } ["MarketingHeadline"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(17) "MarketingHeadline" ["COLUMN_POSITION"]=> int(24) ["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) } ["Description"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(11) "Description" ["COLUMN_POSITION"]=> int(25) ["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) } ["EnvisionDesignCenter"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(4) "Plan" ["COLUMN_NAME"]=> string(20) "EnvisionDesignCenter" ["COLUMN_POSITION"]=> int(26) ["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) } } ["_metadataCache:protected"]=> NULL ["_rowClass:protected"]=> string(17) "Zend_Db_Table_Row" ["_rowsetClass:protected"]=> string(20) "Zend_Db_Table_Rowset" ["_referenceMap:protected"]=> array(0) { } ["_dependentTables:protected"]=> array(0) { } } ["_connected:protected"]=> bool(true) ["_tableClass:protected"]=> string(11) "Ucl_Db_Plan" ["_rowClass:protected"]=> string(17) "Zend_Db_Table_Row" ["_pointer:protected"]=> int(0) ["_count:protected"]=> int(0) ["_rows:protected"]=> array(0) { } ["_stored:protected"]=> bool(true) ["_readOnly:protected"]=> bool(false) } } } [7]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Action.php" ["line"]=> int(502) ["function"]=> string(16) "floorplansAction" ["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(16) "floorplansAction" } } [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(30) "/south-natick-hills/floorplans" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(30) "/south-natick-hills/floorplans" ["_params:protected"]=> array(5) { ["subdivision-name"]=> string(18) "south-natick-hills" ["controller"]=> string(8) "property" ["action"]=> string(10) "floorplans" ["floorplan"]=> int(0) ["error_handler"]=> object(ArrayObject)#48 (3) { ["exception"]=> *RECURSION* ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#67 (14) { ["_paramSources:protected"]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri:protected"]=> string(30) "/south-natick-hills/floorplans" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(30) "/south-natick-hills/floorplans" ["_params:protected"]=> array(4) { ["subdivision-name"]=> string(18) "south-natick-hills" ["controller"]=> string(8) "property" ["action"]=> string(10) "floorplans" ["floorplan"]=> int(0) } ["_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(10) "floorplans" ["_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(143) ["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(143) ["function"]=> string(8) "dispatch" ["class"]=> string(21) "Zend_Controller_Front" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } }