SYSPATH/classes/Kohana/URL.php [ 107 ]
102 }
103
104 // Validate $host, see if it matches trusted hosts
105 if ( ! static::is_trusted_host($host))
106 {
107 throw new Kohana_Exception(
108 'Untrusted host :host. If you trust :host, add it to the trusted hosts in the `url` config file.',
109 array(':host' => $host)
110 );
111 }
112 }
-
APPPATH/views/templates/default.php [ 60 ] » Kohana_URL::base(arguments)
0string(4) "http"1bool FALSE
-
MODPATH/custom/classes/View.php [ 36 ] » include(arguments)
0string(66) "/home/seemynew/public_html/application/views/templates/default.php" -
SYSPATH/classes/Kohana/View.php [ 359 ] » View::capture(arguments)
0string(66) "/home/seemynew/public_html/application/views/templates/default.php"1array(2) ( "content" => object View(2)
{ protected _file => string(58) "/home/seemynew/public_html/application/views/page/home.php" protected _data => array(0) }"debug" => string(0) "" )354 { 355 throw new View_Exception('You must set the file to use within your view before rendering'); 356 } 357 358 // Combine local and global data and capture the output 359 return View::capture($this->_file, $this->_data); 360 } 361 362 } -
SYSPATH/classes/Kohana/View.php [ 236 ] » Kohana_View->render()
231 */ 232 public function __toString() 233 { 234 try 235 { 236 return $this->render(); 237 } 238 catch (Throwable $e) 239 { 240 /** 241 * Display the exception message. -
SYSPATH/classes/Kohana/Response.php [ 160 ] » Kohana_View->__toString()
155 public function body($content = NULL) 156 { 157 if ($content === NULL) 158 return $this->_body; 159 160 $this->_body = (string) $content; 161 return $this; 162 } 163 164 /** 165 * Gets or sets the HTTP protocol. The standard protocol to use -
APPPATH/classes/controller/display.php [ 89 ] » Kohana_Response->body(arguments)
0object View(2)
{ protected _file => string(66) "/home/seemynew/public_html/application/views/templates/default.php" protected _data => array(2) ( "content" => object View(2){ protected _file => string(58) "/home/seemynew/public_html/application/views/page/home.php" protected _data => array(0) }"debug" => string(0) "" ) }84 } 85 } 86 $this->debugVars['defined'] = get_defined_vars(); 87 $this->debugVars['request'] = get_class($this); 88 $this->template->debug = $_GET['debug'] == 10 ? View::factory('system/debug')->bind('vars', $this->debugVars) : ''; 89 $this->response->body($this->template); 90 return parent::after(); 91 } 92 93 } 94 -
SYSPATH/classes/Kohana/Controller.php [ 87 ] » Controller_Display->after()
82 83 // Execute the action itself 84 $this->{$action}(); 85 86 // Execute the "after action" method 87 $this->after(); 88 89 // Return the response 90 return $this->response; 91 } 92 -
{PHP internal call} » Kohana_Controller->execute()
-
SYSPATH/classes/Kohana/Request/Client/Internal.php [ 97 ] » ReflectionMethod->invoke(arguments)
0object Controller_Display_Main(26)
{ public request => object Request(19){ protected _requested_with => NULL protected _method => string(3) "GET" protected _protocol => string(8) "HTTP/1.1" protected _secure => bool TRUE protected _referrer => NULL protected _route => object Route(5)public response => object Response(5){ protected _filters => array(0) protected _uri => string(6) "<args>" protected _regex => array(1) ( "args" => string(2) ".*" ) protected _defaults => array(4) ( "directory" => string(7) "display" "controller" => string(4) "main" "action" => string(5) "index" "args" => string(4) "home" ) protected _route_regex => string(18) "#^(?P<args>.*)$#uD" }protected _routes => array(0) protected _header => object HTTP_Header(0){ }protected _body => NULL protected _directory => string(7) "Display" protected _controller => string(4) "Main" protected _action => string(5) "index" protected _uri => string(0) "" protected _external => bool FALSE protected _params => array(1) ( "args" => string(4) "home" ) protected _get => array(0) protected _post => array(0) protected _cookies => array(0) protected _client => object Request_Client_Internal(9){ protected _cache => NULL protected _follow => bool FALSE protected _follow_headers => array(1) ( 0 => string(13) "authorization" ) protected _strict_redirect => bool TRUE protected _header_callbacks => array(1) ( "Location" => string(34) "Request_Client::on_header_location" ) protected _max_callback_depth => integer 5 protected _callback_depth => integer 1 protected _callback_params => array(0) protected _previous_environment => NULL }}{ protected _status => integer 200 protected _header => object HTTP_Header(0)public log => array(0) public dealer => object Model_Dealer(38){ }protected _body => string(0) "" protected _cookies => array(0) protected _protocol => string(8) "HTTP/1.1" }{ protected _has_one => array(1) ( "dealer2" => array(2) ( "foreign_key" => string(13) "dealer_number" "model" => string(7) "Dealer2" ) ) protected _belongs_to => array(1) ( "Survey" => array(2) ( "foreign_key" => string(9) "survey_id" "model" => string(12) "Model_Survey" ) ) protected _has_many => array(7) ( "photo" => array(4) ( "foreign_key" => string(19) "photo_dealer_number" "through" => NULL "far_key" => string(8) "photo_id" "model" => string(5) "Photo" ) "lead" => array(4) ( "foreign_key" => string(18) "lead_dealer_number" "through" => NULL "far_key" => string(7) "lead_id" "model" => string(4) "Lead" ) "custom" => array(4) ( "foreign_key" => string(20) "custom_dealer_number" "through" => NULL "far_key" => string(9) "custom_id" "model" => string(6) "Custom" ) "visit" => array(4) ( "foreign_key" => string(19) "visit_dealer_number" "through" => NULL "far_key" => string(8) "visit_id" "model" => string(5) "Visit" ) "feedback" => array(4) ( "foreign_key" => string(22) "feedback_dealer_number" "through" => NULL "far_key" => string(11) "feedback_id" "model" => string(8) "Feedback" ) "sales" => array(4) ( "foreign_key" => string(13) "dealer_number" "through" => NULL "far_key" => string(7) "sale_id" "model" => string(5) "Sales" ) "click" => array(4) ( "foreign_key" => string(19) "click_dealer_number" "through" => NULL "far_key" => string(8) "click_id" "model" => string(12) "Clickthrough" ) ) protected _load_with => array(0) protected _validation => NULL protected _object => array(93) ( "dealer_id" => NULL "dealer_name" => NULL "dealer_number" => NULL "type" => NULL "number" => NULL "dealer_pw" => NULL "dealer_page" => NULL "dealer_watermark" => NULL "dealer_website" => NULL "domain" => NULL "dealer_facebook" => NULL "dealer_twitter" => NULL "dealer_youtube" => NULL "dealerrater" => NULL "googlereview" => NULL "googleplus" => NULL "yelp" => NULL "yahoolocal" => NULL "edmunds" => NULL "ksl" => NULL "autotrader" => NULL "blackbook" => NULL "cars_com" => NULL "angieslist" => NULL "citysearch" => NULL "foursquare" => NULL "service_specials" => NULL "specials" => NULL "inventory" => NULL "inventory_new" => NULL "inventory_used" => NULL "android_app" => NULL "apple_app" => NULL "show_sales" => NULL "dealer_logins" => NULL "dealer_redirect" => NULL "dealer_opt" => NULL "dealer_street_address" => NULL "dealer_city" => NULL "dealer_state" => NULL "dealer_zip" => NULL "dealer_phone" => NULL "dealer_keywords" => NULL "dealer_active" => NULL "dealer_email" => NULL "watermark" => NULL "login_sent" => NULL "last_login" => NULL "logo" => NULL "logo2" => NULL "logo_modified" => NULL "logo2_modified" => NULL "password" => NULL "token" => NULL "photoactive" => NULL "contact_name" => NULL "contact_title" => NULL "dealer_aware" => NULL "checksum" => NULL "feedback_enabled" => NULL "leads_enabled" => NULL "emails" => NULL "date_joined" => NULL "security" => NULL "copy" => NULL "archive" => NULL "activate_email_sent" => NULL "activate_email_sent_count" => NULL "calpro_active" => NULL "date_activated" => NULL "date_deactivated" => NULL "date_terminated" => NULL "new" => NULL "allow_photo_email" => NULL "followup_active" => NULL "parent" => NULL "dealer_children" => NULL "scc_card" => NULL "batch_time" => NULL "batch_number" => NULL "share_buttons" => NULL "show_survey" => NULL "survey_id" => NULL "facebook_likes" => NULL "sales_video_status" => NULL "survey_email1" => NULL "survey_email2" => NULL "sales_tab" => NULL "salesman_inactivity_days" => NULL "showRatingOnLandingPg" => NULL "phones_and_hours" => NULL "created_at" => NULL "updated_at" => NULL ) protected _changed => array(0) protected _original_values => array(0) protected _related => array(0) protected _valid => bool FALSE protected _loaded => bool FALSE protected _saved => bool FALSE protected _sorting => NULL protected _foreign_key_suffix => string(3) "_id" protected _object_name => string(6) "dealer" protected _object_plural => string(7) "dealers" protected _table_name => string(7) "dealers" protected _table_columns => array(93) ( "dealer_id" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(9) "dealer_id" "column_default" => NULL "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 1 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(14) "auto_increment" "key" => string(3) "UNI" "privileges" => string(31) "select,insert,update,references" ) "dealer_name" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "dealer_name" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 2 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "dealer_number" => array(12) ( "type" => string(6) "string" "column_name" => string(13) "dealer_number" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 3 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "PRI" "privileges" => string(31) "select,insert,update,references" ) "type" => array(12) ( "type" => string(6) "string" "column_name" => string(4) "type" "column_default" => string(7) "default" "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 4 "character_maximum_length" => string(2) "50" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(19) "default,express,ftp" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "number" => array(12) ( "type" => string(6) "string" "column_name" => string(6) "number" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 5 "character_maximum_length" => string(2) "50" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_pw" => array(12) ( "type" => string(6) "string" "column_name" => string(9) "dealer_pw" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 6 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_page" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "dealer_page" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 7 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_watermark" => array(12) ( "type" => string(6) "string" "column_name" => string(16) "dealer_watermark" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 8 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_website" => array(12) ( "type" => string(6) "string" "column_name" => string(14) "dealer_website" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 9 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "domain" => array(12) ( "type" => string(6) "string" "column_name" => string(6) "domain" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 10 "character_maximum_length" => string(3) "250" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(17) "domain of website" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_facebook" => array(12) ( "type" => string(6) "string" "column_name" => string(15) "dealer_facebook" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 11 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_twitter" => array(12) ( "type" => string(6) "string" "column_name" => string(14) "dealer_twitter" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 12 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_youtube" => array(12) ( "type" => string(6) "string" "column_name" => string(14) "dealer_youtube" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 13 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealerrater" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "dealerrater" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 14 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "googlereview" => array(12) ( "type" => string(6) "string" "column_name" => string(12) "googlereview" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 15 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "googleplus" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "googleplus" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 16 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "yelp" => array(12) ( "type" => string(6) "string" "column_name" => string(4) "yelp" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 17 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "yahoolocal" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "yahoolocal" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 18 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "edmunds" => array(12) ( "type" => string(6) "string" "column_name" => string(7) "edmunds" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 19 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "ksl" => array(12) ( "type" => string(6) "string" "column_name" => string(3) "ksl" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 20 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "autotrader" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "autotrader" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 21 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "blackbook" => array(12) ( "type" => string(6) "string" "column_name" => string(9) "blackbook" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 22 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "cars_com" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "cars_com" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 23 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "angieslist" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "angieslist" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 24 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "citysearch" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "citysearch" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 25 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "foursquare" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "foursquare" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 26 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "service_specials" => array(12) ( "type" => string(6) "string" "column_name" => string(16) "service_specials" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 27 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "specials" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "specials" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 28 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "inventory" => array(12) ( "type" => string(6) "string" "column_name" => string(9) "inventory" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 29 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "inventory_new" => array(12) ( "type" => string(6) "string" "column_name" => string(13) "inventory_new" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 30 "character_maximum_length" => string(3) "200" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "inventory_used" => array(12) ( "type" => string(6) "string" "column_name" => string(14) "inventory_used" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 31 "character_maximum_length" => string(3) "200" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "android_app" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "android_app" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 32 "character_maximum_length" => string(3) "200" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "apple_app" => array(12) ( "type" => string(6) "string" "column_name" => string(9) "apple_app" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 33 "character_maximum_length" => string(3) "200" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "show_sales" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(10) "show_sales" "column_default" => string(1) "1" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 34 "display" => string(2) "10" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_logins" => array(12) ( "type" => string(6) "string" "column_name" => string(13) "dealer_logins" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 35 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_redirect" => array(13) ( "type" => string(3) "int" "min" => string(4) "-128" "max" => string(3) "127" "column_name" => string(15) "dealer_redirect" "column_default" => string(1) "0" "data_type" => string(7) "tinyint" "is_nullable" => bool TRUE "ordinal_position" => integer 36 "display" => string(1) "1" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_opt" => array(13) ( "type" => string(3) "int" "min" => string(4) "-128" "max" => string(3) "127" "column_name" => string(10) "dealer_opt" "column_default" => string(1) "0" "data_type" => string(7) "tinyint" "is_nullable" => bool TRUE "ordinal_position" => integer 37 "display" => string(1) "1" "comment" => string(17) "1=remove checkbox" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_street_address" => array(12) ( "type" => string(6) "string" "column_name" => string(21) "dealer_street_address" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 38 "character_maximum_length" => string(2) "50" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "dealer_city" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "dealer_city" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 39 "character_maximum_length" => string(2) "50" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_state" => array(12) ( "type" => string(6) "string" "column_name" => string(12) "dealer_state" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 40 "character_maximum_length" => string(2) "50" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "dealer_zip" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "dealer_zip" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 41 "character_maximum_length" => string(2) "50" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "dealer_phone" => array(12) ( "type" => string(6) "string" "column_name" => string(12) "dealer_phone" "column_default" => string(1) "0" "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 42 "character_maximum_length" => string(2) "50" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_keywords" => array(12) ( "type" => string(6) "string" "character_maximum_length" => string(5) "65535" "column_name" => string(15) "dealer_keywords" "column_default" => NULL "data_type" => string(4) "text" "is_nullable" => bool TRUE "ordinal_position" => integer 43 "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_active" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(13) "dealer_active" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 44 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_email" => array(12) ( "type" => string(6) "string" "column_name" => string(12) "dealer_email" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 45 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "watermark" => array(12) ( "type" => string(6) "string" "column_name" => string(9) "watermark" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 46 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "login_sent" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "login_sent" "column_default" => string(1) "0" "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 47 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "last_login" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "last_login" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 48 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "logo" => array(12) ( "type" => string(6) "string" "column_name" => string(4) "logo" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 49 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "logo2" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "logo2" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 50 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "logo_modified" => array(12) ( "type" => string(6) "string" "column_name" => string(13) "logo_modified" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 51 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "logo2_modified" => array(12) ( "type" => string(6) "string" "column_name" => string(14) "logo2_modified" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 52 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "password" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "password" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 53 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "token" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "token" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 54 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(17) "md5 dealer_number" "extra" => string(0) "" "key" => string(3) "UNI" "privileges" => string(31) "select,insert,update,references" ) "photoactive" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(11) "photoactive" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 55 "display" => string(2) "11" "comment" => string(17) "Are photos active" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "contact_name" => array(12) ( "type" => string(6) "string" "column_name" => string(12) "contact_name" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 56 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "contact_title" => array(12) ( "type" => string(6) "string" "column_name" => string(13) "contact_title" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 57 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_aware" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(12) "dealer_aware" "column_default" => NULL "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 58 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "checksum" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "checksum" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 59 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "feedback_enabled" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(16) "feedback_enabled" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 60 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "leads_enabled" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(13) "leads_enabled" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 61 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "emails" => array(12) ( "type" => string(6) "string" "binary" => bool TRUE "character_maximum_length" => string(5) "65535" "column_name" => string(6) "emails" "column_default" => NULL "data_type" => string(4) "blob" "is_nullable" => bool TRUE "ordinal_position" => integer 62 "comment" => string(15) "json email list" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "date_joined" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "date_joined" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 63 "character_maximum_length" => string(3) "100" "collation_name" => string(17) "latin1_general_ci" "comment" => string(13) "dates started" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "security" => array(12) ( "type" => string(6) "string" "binary" => bool TRUE "character_maximum_length" => string(5) "65535" "column_name" => string(8) "security" "column_default" => NULL "data_type" => string(4) "blob" "is_nullable" => bool TRUE "ordinal_position" => integer 64 "comment" => string(27) "temp place to stor security" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "copy" => array(12) ( "type" => string(6) "string" "binary" => bool TRUE "character_maximum_length" => string(5) "65535" "column_name" => string(4) "copy" "column_default" => NULL "data_type" => string(4) "blob" "is_nullable" => bool TRUE "ordinal_position" => integer 65 "comment" => string(18) "copy when changing" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "archive" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(7) "archive" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 66 "display" => string(2) "11" "comment" => string(27) "Archived (remove from list)" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "activate_email_sent" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(19) "activate_email_sent" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 67 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "activate_email_sent_count" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(25) "activate_email_sent_count" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 68 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "calpro_active" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(13) "calpro_active" "column_default" => string(1) "1" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 69 "display" => string(2) "11" "comment" => string(12) "Fully active" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "date_activated" => array(12) ( "type" => string(6) "string" "column_name" => string(14) "date_activated" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 70 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "date_deactivated" => array(12) ( "type" => string(6) "string" "column_name" => string(16) "date_deactivated" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 71 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "date_terminated" => array(12) ( "type" => string(6) "string" "column_name" => string(15) "date_terminated" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 72 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "new" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(3) "new" "column_default" => string(1) "1" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 73 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "allow_photo_email" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(17) "allow_photo_email" "column_default" => string(1) "1" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 74 "display" => string(2) "11" "comment" => string(28) "allow customrs to be emailed" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "followup_active" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(15) "followup_active" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 75 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "parent" => array(12) ( "type" => string(6) "string" "column_name" => string(6) "parent" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 76 "character_maximum_length" => string(3) "100" "collation_name" => string(17) "latin1_general_ci" "comment" => string(13) "parent dealer" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "dealer_children" => array(12) ( "type" => string(6) "string" "binary" => bool TRUE "character_maximum_length" => string(5) "65535" "column_name" => string(15) "dealer_children" "column_default" => NULL "data_type" => string(4) "blob" "is_nullable" => bool TRUE "ordinal_position" => integer 77 "comment" => string(17) "array of children" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "scc_card" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(8) "scc_card" "column_default" => string(1) "1" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 78 "display" => string(2) "11" "comment" => string(29) "whether scc card is available" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "batch_time" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "batch_time" "column_default" => string(1) "0" "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 79 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(38) "amount of time before batch is created" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "batch_number" => array(12) ( "type" => string(6) "string" "column_name" => string(12) "batch_number" "column_default" => string(1) "0" "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 80 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(40) "amount of photos before batch is created" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "share_buttons" => array(12) ( "type" => string(6) "string" "column_name" => string(13) "share_buttons" "column_default" => string(28) "[1,2,3,4,5,6,7,8,9,13,14,15]" "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 81 "character_maximum_length" => string(3) "200" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "show_survey" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(11) "show_survey" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 82 "display" => string(1) "2" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "survey_id" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(9) "survey_id" "column_default" => NULL "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 83 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "facebook_likes" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(14) "facebook_likes" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 84 "display" => string(3) "255" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "sales_video_status" => array(13) ( "type" => string(3) "int" "min" => string(4) "-128" "max" => string(3) "127" "column_name" => string(18) "sales_video_status" "column_default" => string(1) "1" "data_type" => string(7) "tinyint" "is_nullable" => bool FALSE "ordinal_position" => integer 85 "display" => string(1) "4" "comment" => string(43) "0 for disable, 1 for enable, 2 for override" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "survey_email1" => array(12) ( "type" => string(6) "string" "column_name" => string(13) "survey_email1" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 86 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "survey_email2" => array(12) ( "type" => string(6) "string" "column_name" => string(13) "survey_email2" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 87 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "sales_tab" => array(13) ( "type" => string(3) "int" "min" => string(4) "-128" "max" => string(3) "127" "column_name" => string(9) "sales_tab" "column_default" => string(1) "1" "data_type" => string(7) "tinyint" "is_nullable" => bool FALSE "ordinal_position" => integer 88 "display" => string(1) "1" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "salesman_inactivity_days" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(24) "salesman_inactivity_days" "column_default" => string(2) "30" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 89 "display" => string(3) "255" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "showRatingOnLandingPg" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(21) "showRatingOnLandingPg" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 90 "display" => string(1) "2" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "phones_and_hours" => array(12) ( "type" => string(6) "string" "column_name" => string(16) "phones_and_hours" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 91 "character_maximum_length" => string(4) "1000" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "created_at" => array(10) ( "type" => string(6) "string" "column_name" => string(10) "created_at" "column_default" => string(19) "current_timestamp()" "data_type" => string(9) "timestamp" "is_nullable" => bool FALSE "ordinal_position" => integer 92 "comment" => string(180) "Row-creation time set by MySQL itself, not application code - added for troubleshooting. Existing rows show the time this column …" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "updated_at" => array(10) ( "type" => string(6) "string" "column_name" => string(10) "updated_at" "column_default" => string(19) "current_timestamp()" "data_type" => string(9) "timestamp" "is_nullable" => bool FALSE "ordinal_position" => integer 93 "comment" => string(105) "Last-modified time set by MySQL itself on every UPDATE, not application code - added for troubleshooting." "extra" => string(29) "on update current_timestamp()" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) ) protected _updated_column => NULL protected _created_column => NULL protected _serialize_columns => array(0) protected _primary_key => string(13) "dealer_number" protected _primary_key_value => NULL protected _table_names_plural => bool TRUE protected _reload_on_wakeup => bool TRUE protected _db => object Database_MySQLi(6)public photo => object Model_Photo(36){ public last_query => string(1895) "SELECT `sales`.`id` AS `id`, `sales`.`ident` AS `ident`, `sales`.`number` AS `number`, `sales`.`firstname` AS `firstname`, `sale …" protected _identifier => string(1) "`" protected _instance => string(7) "default" protected _connection => object mysqli(0)protected _db_group => NULL protected _db_applied => array(0) protected _db_pending => array(0) protected _db_reset => bool TRUE protected _db_builder => NULL protected _with_applied => array(0) protected _cast_data => array(0) protected _errors_filename => string(6) "dealer" protected _behaviors => array(0) protected _private_columns => bool FALSE protected _primary_val => string(11) "dealer_name" protected _guarded => array(1) ( 0 => string(8) "password" ) }{ }protected _config => array(6) ( "type" => string(6) "MySQLi" "connection" => array(4) ( "hostname" => string(9) "localhost" "persistent" => bool FALSE "database" => string(13) "seemynew_data" "ssl" => NULL ) "table_prefix" => string(0) "" "charset" => string(4) "utf8" "caching" => bool FALSE "profiling" => bool TRUE ) protected _connection_id => string(40) "1849a47644000718ddae333bf7bba4b8e52045a0" }{ protected _has_one => array(1) ( "details" => array(2) ( "model" => string(13) "Photo_Details" "foreign_key" => string(8) "photo_id" ) ) protected _belongs_to => array(1) ( "dealer" => array(2) ( "model" => string(6) "Dealer" "foreign_key" => string(19) "photo_dealer_number" ) ) protected _has_many => array(3) ( "vehicle" => array(4) ( "model" => string(13) "Photo_Vehicle" "foreign_key" => string(8) "photo_id" "through" => NULL "far_key" => string(10) "vehicle_id" ) "upload" => array(4) ( "model" => string(6) "Upload" "foreign_key" => string(15) "social_photo_id" "through" => NULL "far_key" => string(9) "upload_id" ) "errors" => array(4) ( "model" => string(5) "Error" "foreign_key" => string(14) "error_photo_id" "through" => NULL "far_key" => string(8) "error_id" ) ) protected _load_with => array(0) protected _validation => NULL protected _object => array(94) ( "photo_id" => NULL "dealer_number" => NULL "name" => NULL "link" => NULL "batch" => NULL "print" => NULL "pin" => NULL "customer_name" => NULL "address" => NULL "city" => NULL "state" => NULL "zip" => NULL "phone" => NULL "model" => NULL "make" => NULL "year" => NULL "style" => NULL "color" => NULL "timestamp" => NULL "active" => NULL "image" => NULL "occupation" => NULL "home_phone" => NULL "work_phone" => NULL "spouse_name" => NULL "spouse_email" => NULL "spouse_occupation" => NULL "photo_name" => NULL "photo_link" => NULL "photo_dealer_id" => NULL "photo_salesperson" => NULL "photo_print" => NULL "photo_batch" => NULL "photo_pin" => NULL "source_format" => NULL "photo_optouts" => NULL "photo_optout" => NULL "photo_customer_name" => NULL "photo_street_address" => NULL "photo_occupation" => NULL "photo_city" => NULL "photo_state" => NULL "photo_phone" => NULL "photo_phone2" => NULL "photo_zip" => NULL "photo_year" => NULL "photo_make" => NULL "photo_model" => NULL "photo_style" => NULL "photo_color" => NULL "photo_dealer_number" => NULL "sales_id" => NULL "sales_number" => NULL "photo_timestamp" => NULL "p_timestamp" => NULL "photo_active" => NULL "photo_atimestamp" => NULL "modified" => NULL "ptoken" => NULL "stoken" => NULL "ctoken" => NULL "vin" => NULL "dop" => NULL "token" => NULL "checksum" => NULL "utimestamp" => NULL "id" => NULL "last_viewed" => NULL "last_shared" => NULL "deal_no" => NULL "email" => NULL "email_date" => NULL "email_count" => NULL "followup" => NULL "s_fix" => NULL "dob" => NULL "dob2" => NULL "complete" => NULL "data" => NULL "scc_exp" => NULL "scc_name" => NULL "confirmed" => NULL "extra" => NULL "laser" => NULL "total_share" => NULL "fb_views" => NULL "dealer_fb_share" => NULL "sales_fb_share" => NULL "cust_fb_share" => NULL "customer_auth" => NULL "hideinhappycustomers" => NULL "happycustomersection" => NULL "created_at" => NULL "updated_at" => NULL ) protected _changed => array(0) protected _original_values => array(0) protected _related => array(0) protected _valid => bool FALSE protected _loaded => bool FALSE protected _saved => bool FALSE protected _sorting => NULL protected _foreign_key_suffix => string(3) "_id" protected _object_name => string(5) "photo" protected _object_plural => string(6) "photos" protected _table_name => string(6) "photos" protected _table_columns => array(94) ( "photo_id" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(8) "photo_id" "column_default" => NULL "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 1 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(14) "auto_increment" "key" => string(3) "PRI" "privileges" => string(31) "select,insert,update,references" ) "dealer_number" => array(12) ( "type" => string(6) "string" "column_name" => string(13) "dealer_number" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 2 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "name" => array(12) ( "type" => string(6) "string" "column_name" => string(4) "name" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 3 "character_maximum_length" => string(3) "200" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "link" => array(12) ( "type" => string(6) "string" "column_name" => string(4) "link" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 4 "character_maximum_length" => string(3) "250" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "batch" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "batch" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 5 "character_maximum_length" => string(2) "60" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "print" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "print" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 6 "character_maximum_length" => string(2) "60" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "pin" => array(12) ( "type" => string(6) "string" "column_name" => string(3) "pin" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 7 "character_maximum_length" => string(2) "60" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "customer_name" => array(12) ( "type" => string(6) "string" "column_name" => string(13) "customer_name" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 8 "character_maximum_length" => string(3) "250" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "address" => array(12) ( "type" => string(6) "string" "column_name" => string(7) "address" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 9 "character_maximum_length" => string(3) "250" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "city" => array(12) ( "type" => string(6) "string" "column_name" => string(4) "city" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 10 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "state" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "state" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 11 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "zip" => array(12) ( "type" => string(6) "string" "column_name" => string(3) "zip" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 12 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "phone" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "phone" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 13 "character_maximum_length" => string(3) "200" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "model" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "model" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 14 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "make" => array(12) ( "type" => string(6) "string" "column_name" => string(4) "make" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 15 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "year" => array(12) ( "type" => string(6) "string" "column_name" => string(4) "year" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 16 "character_maximum_length" => string(2) "50" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "style" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "style" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 17 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "color" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "color" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 18 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "timestamp" => array(12) ( "type" => string(6) "string" "column_name" => string(9) "timestamp" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 19 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "active" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(6) "active" "column_default" => NULL "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 20 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "image" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "image" "column_default" => string(0) "" "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 21 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "occupation" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "occupation" "column_default" => string(0) "" "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 22 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "home_phone" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "home_phone" "column_default" => string(0) "" "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 23 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "work_phone" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "work_phone" "column_default" => string(0) "" "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 24 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "spouse_name" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "spouse_name" "column_default" => string(0) "" "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 25 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "spouse_email" => array(12) ( "type" => string(6) "string" "column_name" => string(12) "spouse_email" "column_default" => string(0) "" "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 26 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "spouse_occupation" => array(12) ( "type" => string(6) "string" "column_name" => string(17) "spouse_occupation" "column_default" => string(0) "" "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 27 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_name" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "photo_name" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 28 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_link" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "photo_link" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 29 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_dealer_id" => array(12) ( "type" => string(6) "string" "column_name" => string(15) "photo_dealer_id" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 30 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_salesperson" => array(12) ( "type" => string(6) "string" "column_name" => string(17) "photo_salesperson" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 31 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_print" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "photo_print" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 32 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_batch" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "photo_batch" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 33 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "photo_pin" => array(12) ( "type" => string(6) "string" "column_name" => string(9) "photo_pin" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 34 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "source_format" => array(12) ( "type" => string(6) "string" "column_name" => string(13) "source_format" "column_default" => string(3) "csv" "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 35 "character_maximum_length" => string(2) "10" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(269) "File format this row was imported from off the FTP host (csv or psv). Defaults to csv for all pre-existing rows, since .psv batc …" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_optouts" => array(12) ( "type" => string(6) "string" "column_name" => string(13) "photo_optouts" "column_default" => string(1) "0" "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 36 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_optout" => array(13) ( "type" => string(3) "int" "min" => string(4) "-128" "max" => string(3) "127" "column_name" => string(12) "photo_optout" "column_default" => string(1) "0" "data_type" => string(7) "tinyint" "is_nullable" => bool FALSE "ordinal_position" => integer 37 "display" => string(1) "1" "comment" => string(21) "1=wm has been removed" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_customer_name" => array(12) ( "type" => string(6) "string" "column_name" => string(19) "photo_customer_name" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 38 "character_maximum_length" => string(3) "100" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_street_address" => array(12) ( "type" => string(6) "string" "column_name" => string(20) "photo_street_address" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 39 "character_maximum_length" => string(3) "200" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "photo_occupation" => array(12) ( "type" => string(6) "string" "column_name" => string(16) "photo_occupation" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 40 "character_maximum_length" => string(3) "250" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_city" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "photo_city" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 41 "character_maximum_length" => string(2) "50" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_state" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "photo_state" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 42 "character_maximum_length" => string(2) "50" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_phone" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "photo_phone" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 43 "character_maximum_length" => string(2) "60" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_phone2" => array(12) ( "type" => string(6) "string" "column_name" => string(12) "photo_phone2" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 44 "character_maximum_length" => string(2) "60" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_zip" => array(12) ( "type" => string(6) "string" "column_name" => string(9) "photo_zip" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 45 "character_maximum_length" => string(2) "50" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_year" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "photo_year" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 46 "character_maximum_length" => string(2) "50" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_make" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "photo_make" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 47 "character_maximum_length" => string(2) "50" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_model" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "photo_model" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 48 "character_maximum_length" => string(2) "50" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_style" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "photo_style" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 49 "character_maximum_length" => string(2) "50" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_color" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "photo_color" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 50 "character_maximum_length" => string(2) "50" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_dealer_number" => array(12) ( "type" => string(6) "string" "column_name" => string(19) "photo_dealer_number" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 51 "character_maximum_length" => string(2) "25" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "sales_id" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(8) "sales_id" "column_default" => NULL "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 52 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "sales_number" => array(12) ( "type" => string(6) "string" "column_name" => string(12) "sales_number" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 53 "character_maximum_length" => string(3) "100" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "photo_timestamp" => array(12) ( "type" => string(6) "string" "column_name" => string(15) "photo_timestamp" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 54 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "p_timestamp" => array(10) ( "type" => string(6) "string" "column_name" => string(11) "p_timestamp" "column_default" => NULL "data_type" => string(9) "timestamp" "is_nullable" => bool TRUE "ordinal_position" => integer 55 "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "photo_active" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(12) "photo_active" "column_default" => string(1) "1" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 56 "display" => string(1) "1" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "photo_atimestamp" => array(12) ( "type" => string(6) "string" "column_name" => string(16) "photo_atimestamp" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 57 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(12) "last altered" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "modified" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "modified" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 58 "character_maximum_length" => string(3) "100" "collation_name" => string(17) "latin1_general_ci" "comment" => string(32) "last time the photo was modified" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "ptoken" => array(12) ( "type" => string(6) "string" "column_name" => string(6) "ptoken" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 59 "character_maximum_length" => string(3) "200" "collation_name" => string(17) "latin1_general_ci" "comment" => string(11) "batch:print" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "stoken" => array(12) ( "type" => string(6) "string" "column_name" => string(6) "stoken" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 60 "character_maximum_length" => string(3) "200" "collation_name" => string(17) "latin1_general_ci" "comment" => string(17) "salesperson token" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "ctoken" => array(12) ( "type" => string(6) "string" "column_name" => string(6) "ctoken" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 61 "character_maximum_length" => string(3) "200" "collation_name" => string(17) "latin1_general_ci" "comment" => string(14) "customer token" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "vin" => array(12) ( "type" => string(6) "string" "column_name" => string(3) "vin" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 62 "character_maximum_length" => string(2) "15" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "dop" => array(12) ( "type" => string(6) "string" "column_name" => string(3) "dop" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 63 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "token" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "token" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 64 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(19) "md5 batch:print:pin" "extra" => string(0) "" "key" => string(3) "UNI" "privileges" => string(31) "select,insert,update,references" ) "checksum" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "checksum" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 65 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(20) "checksum of all data" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "utimestamp" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "utimestamp" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 66 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(16) "lasttime updated" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "id" => array(12) ( "type" => string(6) "string" "column_name" => string(2) "id" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 67 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(11) "batch.print" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "last_viewed" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "last_viewed" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 68 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(16) "Last time viewed" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "last_shared" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "last_shared" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 69 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(16) "last time shared" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "deal_no" => array(12) ( "type" => string(6) "string" "column_name" => string(7) "deal_no" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 70 "character_maximum_length" => string(3) "100" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "email" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "email" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 71 "character_maximum_length" => string(3) "100" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "email_date" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "email_date" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 72 "character_maximum_length" => string(2) "50" "collation_name" => string(17) "latin1_general_ci" "comment" => string(12) "date emailed" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "email_count" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(11) "email_count" "column_default" => NULL "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 73 "display" => string(2) "11" "comment" => string(13) "times emailed" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "followup" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(8) "followup" "column_default" => NULL "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 74 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "s_fix" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(5) "s_fix" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 75 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dob" => array(12) ( "type" => string(6) "string" "column_name" => string(3) "dob" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 76 "character_maximum_length" => string(3) "100" "collation_name" => string(17) "latin1_general_ci" "comment" => string(14) "Buyer birthday" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dob2" => array(12) ( "type" => string(6) "string" "column_name" => string(4) "dob2" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 77 "character_maximum_length" => string(3) "100" "collation_name" => string(17) "latin1_general_ci" "comment" => string(18) "co/spouse birthday" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "complete" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(8) "complete" "column_default" => NULL "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 78 "display" => string(2) "11" "comment" => string(45) "Whether photo and customer data has been tied" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "data" => array(12) ( "type" => string(6) "string" "binary" => bool TRUE "character_maximum_length" => string(5) "65535" "column_name" => string(4) "data" "column_default" => NULL "data_type" => string(4) "blob" "is_nullable" => bool TRUE "ordinal_position" => integer 79 "comment" => string(23) "Update/Email extra data" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "scc_exp" => array(12) ( "type" => string(6) "string" "column_name" => string(7) "scc_exp" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 80 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(24) "Service Club Card Expire" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "scc_name" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "scc_name" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 81 "character_maximum_length" => string(3) "200" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(19) "Short Name for card" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "confirmed" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(9) "confirmed" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 82 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "extra" => array(12) ( "type" => string(6) "string" "character_maximum_length" => string(5) "65535" "column_name" => string(5) "extra" "column_default" => NULL "data_type" => string(4) "text" "is_nullable" => bool TRUE "ordinal_position" => integer 83 "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "laser" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(5) "laser" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 84 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "total_share" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(11) "total_share" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 85 "display" => string(2) "11" "comment" => string(41) "FB sharing count of customer+dealer+sales" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "fb_views" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(8) "fb_views" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 86 "display" => string(2) "11" "comment" => string(33) "Views to this photo from Facebook" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_fb_share" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(15) "dealer_fb_share" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 87 "display" => string(2) "20" "comment" => string(30) "facebook share count by Dealer" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "sales_fb_share" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(14) "sales_fb_share" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 88 "display" => string(2) "20" "comment" => string(29) "facebook share count by Sales" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "cust_fb_share" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(13) "cust_fb_share" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 89 "display" => string(2) "20" "comment" => string(32) "facebook share count by customer" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "customer_auth" => array(12) ( "type" => string(6) "string" "column_name" => string(13) "customer_auth" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 90 "character_maximum_length" => string(2) "10" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "hideinhappycustomers" => array(13) ( "type" => string(3) "int" "min" => string(4) "-128" "max" => string(3) "127" "column_name" => string(20) "hideinhappycustomers" "column_default" => string(1) "0" "data_type" => string(7) "tinyint" "is_nullable" => bool FALSE "ordinal_position" => integer 91 "display" => string(1) "1" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "happycustomersection" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(20) "happycustomersection" "column_default" => string(1) "1" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 92 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "created_at" => array(10) ( "type" => string(6) "string" "column_name" => string(10) "created_at" "column_default" => string(19) "current_timestamp()" "data_type" => string(9) "timestamp" "is_nullable" => bool FALSE "ordinal_position" => integer 93 "comment" => string(207) "Row-creation time set by MySQL itself, not application code - added for troubleshooting. Existing rows show the time this column …" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "updated_at" => array(10) ( "type" => string(6) "string" "column_name" => string(10) "updated_at" "column_default" => string(19) "current_timestamp()" "data_type" => string(9) "timestamp" "is_nullable" => bool FALSE "ordinal_position" => integer 94 "comment" => string(105) "Last-modified time set by MySQL itself on every UPDATE, not application code - added for troubleshooting." "extra" => string(29) "on update current_timestamp()" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) ) protected _updated_column => NULL protected _created_column => NULL protected _serialize_columns => array(0) protected _primary_key => string(8) "photo_id" protected _primary_key_value => NULL protected _table_names_plural => bool TRUE protected _reload_on_wakeup => bool TRUE protected _db => object Database_MySQLi(6)public admin => object Model_Admin(36){ public last_query => string(1895) "SELECT `sales`.`id` AS `id`, `sales`.`ident` AS `ident`, `sales`.`number` AS `number`, `sales`.`firstname` AS `firstname`, `sale …" protected _identifier => string(1) "`" protected _instance => string(7) "default" protected _connection => object mysqli(0)protected _db_group => NULL protected _db_applied => array(0) protected _db_pending => array(0) protected _db_reset => bool TRUE protected _db_builder => NULL protected _with_applied => array(0) protected _cast_data => array(0) protected _errors_filename => string(5) "photo" protected _behaviors => array(0) protected _private_columns => bool FALSE }{ }protected _config => array(6) ( "type" => string(6) "MySQLi" "connection" => array(4) ( "hostname" => string(9) "localhost" "persistent" => bool FALSE "database" => string(13) "seemynew_data" "ssl" => NULL ) "table_prefix" => string(0) "" "charset" => string(4) "utf8" "caching" => bool FALSE "profiling" => bool TRUE ) protected _connection_id => string(40) "1849a47644000718ddae333bf7bba4b8e52045a0" }{ protected _has_one => array(0) protected _belongs_to => array(0) protected _has_many => array(0) protected _load_with => array(0) protected _validation => NULL protected _object => array(11) ( "admin_id" => NULL "admin_un" => NULL "admin_pw" => NULL "name" => NULL "username" => NULL "password" => NULL "last_login" => NULL "last_login_ip" => NULL "token" => NULL "security_leve1" => NULL "email" => NULL ) protected _changed => array(0) protected _original_values => array(0) protected _related => array(0) protected _valid => bool FALSE protected _loaded => bool FALSE protected _saved => bool FALSE protected _sorting => NULL protected _foreign_key_suffix => string(3) "_id" protected _object_name => string(5) "admin" protected _object_plural => string(6) "admins" protected _table_name => string(5) "admin" protected _table_columns => array(11) ( "admin_id" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(8) "admin_id" "column_default" => NULL "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 1 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(14) "auto_increment" "key" => string(3) "PRI" "privileges" => string(31) "select,insert,update,references" ) "admin_un" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "admin_un" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 2 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "admin_pw" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "admin_pw" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 3 "character_maximum_length" => string(3) "255" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "name" => array(12) ( "type" => string(6) "string" "column_name" => string(4) "name" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 4 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "username" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "username" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 5 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "UNI" "privileges" => string(31) "select,insert,update,references" ) "password" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "password" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 6 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "last_login" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "last_login" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 7 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "last_login_ip" => array(12) ( "type" => string(6) "string" "column_name" => string(13) "last_login_ip" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 8 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "token" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "token" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 9 "character_maximum_length" => string(3) "150" "collation_name" => string(17) "latin1_general_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "UNI" "privileges" => string(31) "select,insert,update,references" ) "security_leve1" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(14) "security_leve1" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 10 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "email" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "email" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 11 "character_maximum_length" => string(3) "150" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) ) protected _updated_column => NULL protected _created_column => NULL protected _serialize_columns => array(0) protected _primary_key => string(8) "admin_id" protected _primary_key_value => NULL protected _table_names_plural => bool TRUE protected _reload_on_wakeup => bool TRUE protected _db => object Database_MySQLi(6)public visit => NULL public pageid => NULL public page => string(4) "home" public section => NULL private news => NULL public class => NULL public title => string(22) " | SeeMyNewVehicle.com" public meta => array(2) ( 0 => array(2) ( "name" => string(8) "keywords" "content" => string(19) ",See,My,New,Vehicle" ) 1 => array(2) ( "name" => string(11) "description" "content" => string(67) " See, Save, And Share The Photo Of You In Front Of Your New Vehicle" ) ) public area => NULL public script => NULL public iframe => bool FALSE public templatefile => string(7) "default" public debugVars => array(3) ( "info" => array(3) ( "directory" => string(7) "Display" "controller" => string(4) "Main" "action" => string(5) "index" ) "defined" => array(2) ( "page" => string(4) "home" "var" => string(4) "home" ) "request" => string(23) "Controller_Display_Main" ) public scripts => array(1) ( 0 => string(7) "home.js" ) public styles => array(1) ( 0 => string(8) "home.css" ) public directory => string(7) "Display" public controller => string(4) "Main" public action => string(5) "index" public template => object View(2){ public last_query => string(1895) "SELECT `sales`.`id` AS `id`, `sales`.`ident` AS `ident`, `sales`.`number` AS `number`, `sales`.`firstname` AS `firstname`, `sale …" protected _identifier => string(1) "`" protected _instance => string(7) "default" protected _connection => object mysqli(0)protected _db_group => NULL protected _db_applied => array(0) protected _db_pending => array(0) protected _db_reset => bool TRUE protected _db_builder => NULL protected _with_applied => array(0) protected _cast_data => array(0) protected _errors_filename => string(5) "admin" protected _behaviors => array(0) protected _private_columns => bool FALSE }{ }protected _config => array(6) ( "type" => string(6) "MySQLi" "connection" => array(4) ( "hostname" => string(9) "localhost" "persistent" => bool FALSE "database" => string(13) "seemynew_data" "ssl" => NULL ) "table_prefix" => string(0) "" "charset" => string(4) "utf8" "caching" => bool FALSE "profiling" => bool TRUE ) protected _connection_id => string(40) "1849a47644000718ddae333bf7bba4b8e52045a0" }{ protected _file => string(66) "/home/seemynew/public_html/application/views/templates/default.php" protected _data => array(2) ( "content" => object View(2)public sales => object Model_Sales(37){ protected _file => string(58) "/home/seemynew/public_html/application/views/page/home.php" protected _data => array(0) }"debug" => string(0) "" ) }{ protected _has_one => array(0) protected _belongs_to => array(1) ( "dealer" => array(2) ( "foreign_key" => string(13) "dealer_number" "model" => string(6) "Dealer" ) ) protected _has_many => array(2) ( "photo" => array(4) ( "foreign_key" => string(12) "sales_number" "through" => NULL "far_key" => string(8) "photo_id" "model" => string(5) "Photo" ) "child" => array(4) ( "foreign_key" => string(6) "parent" "through" => NULL "far_key" => string(8) "child_id" "model" => string(5) "Sales" ) ) protected _load_with => array(0) protected _validation => NULL protected _object => array(52) ( "id" => NULL "ident" => NULL "number" => NULL "firstname" => NULL "lastname" => NULL "middlename" => NULL "name" => NULL "title" => NULL "email" => NULL "alternate_email" => NULL "phone" => NULL "phone2" => NULL "address" => NULL "city" => NULL "state" => NULL "zip" => NULL "slug" => NULL "about" => NULL "config" => NULL "username" => NULL "image" => NULL "facebook" => NULL "twitter" => NULL "dealer_number" => NULL "token" => NULL "last_login" => NULL "logins" => NULL "passwordX" => NULL "password" => NULL "timestamp" => NULL "active" => NULL "last_activation_date" => NULL "archive" => NULL "page_active" => NULL "last_active" => NULL "calproid" => NULL "passwordchanged" => integer 0 "email_date" => NULL "email_count" => integer 0 "parent" => NULL "children" => NULL "reminder" => NULL "web_added" => NULL "confirmed" => NULL "created_at" => NULL "updated_at" => NULL "roster_number" => NULL "youtube" => NULL "dealer_override_youtube" => NULL "show_guide" => NULL "total_customers" => NULL "total_customers_extra" => NULL ) protected _changed => array(2) ( "passwordchanged" => string(15) "passwordchanged" "email_count" => string(11) "email_count" ) protected _original_values => array(0) protected _related => array(0) protected _valid => bool FALSE protected _loaded => bool FALSE protected _saved => bool FALSE protected _sorting => NULL protected _foreign_key_suffix => string(3) "_id" protected _object_name => string(5) "sales" protected _object_plural => string(7) "saleses" protected _table_name => string(5) "sales" protected _table_columns => array(52) ( "id" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(2) "id" "column_default" => NULL "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 1 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(14) "auto_increment" "key" => string(3) "PRI" "privileges" => string(31) "select,insert,update,references" ) "ident" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "ident" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 2 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "number" => array(12) ( "type" => string(6) "string" "column_name" => string(6) "number" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 3 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "UNI" "privileges" => string(31) "select,insert,update,references" ) "firstname" => array(12) ( "type" => string(6) "string" "column_name" => string(9) "firstname" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 4 "character_maximum_length" => string(3) "120" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "lastname" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "lastname" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 5 "character_maximum_length" => string(3) "120" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "middlename" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "middlename" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 6 "character_maximum_length" => string(3) "120" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "name" => array(12) ( "type" => string(6) "string" "column_name" => string(4) "name" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 7 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "title" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "title" "column_default" => string(16) "Sales Consultant" "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 8 "character_maximum_length" => string(3) "200" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "email" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "email" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 9 "character_maximum_length" => string(3) "120" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "alternate_email" => array(12) ( "type" => string(6) "string" "column_name" => string(15) "alternate_email" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 10 "character_maximum_length" => string(3) "120" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "phone" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "phone" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 11 "character_maximum_length" => string(3) "120" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "phone2" => array(12) ( "type" => string(6) "string" "column_name" => string(6) "phone2" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 12 "character_maximum_length" => string(3) "120" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "address" => array(12) ( "type" => string(6) "string" "column_name" => string(7) "address" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 13 "character_maximum_length" => string(3) "250" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "city" => array(12) ( "type" => string(6) "string" "column_name" => string(4) "city" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 14 "character_maximum_length" => string(3) "200" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "state" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "state" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 15 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "zip" => array(12) ( "type" => string(6) "string" "column_name" => string(3) "zip" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 16 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "slug" => array(12) ( "type" => string(6) "string" "column_name" => string(4) "slug" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 17 "character_maximum_length" => string(3) "250" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "about" => array(12) ( "type" => string(6) "string" "character_maximum_length" => string(5) "65535" "column_name" => string(5) "about" "column_default" => NULL "data_type" => string(4) "text" "is_nullable" => bool FALSE "ordinal_position" => integer 18 "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "config" => array(12) ( "type" => string(6) "string" "character_maximum_length" => string(5) "65535" "column_name" => string(6) "config" "column_default" => NULL "data_type" => string(4) "text" "is_nullable" => bool FALSE "ordinal_position" => integer 19 "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "username" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "username" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 20 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "image" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "image" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 21 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "facebook" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "facebook" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 22 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "twitter" => array(12) ( "type" => string(6) "string" "column_name" => string(7) "twitter" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 23 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_number" => array(12) ( "type" => string(6) "string" "column_name" => string(13) "dealer_number" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 24 "character_maximum_length" => string(3) "150" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "token" => array(12) ( "type" => string(6) "string" "column_name" => string(5) "token" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 25 "character_maximum_length" => string(3) "200" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(30) "md5 sales array sorted dnumber" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "last_login" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "last_login" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 26 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "logins" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(6) "logins" "column_default" => NULL "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 27 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "passwordX" => array(12) ( "type" => string(6) "string" "column_name" => string(9) "passwordX" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 28 "character_maximum_length" => string(3) "150" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "password" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "password" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 29 "character_maximum_length" => string(3) "150" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "timestamp" => array(12) ( "type" => string(6) "string" "column_name" => string(9) "timestamp" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 30 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "active" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(6) "active" "column_default" => string(1) "1" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 31 "display" => string(1) "1" "comment" => string(12) "1 yes 0 = no" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "last_activation_date" => array(10) ( "type" => string(6) "string" "column_name" => string(20) "last_activation_date" "column_default" => string(19) "current_timestamp()" "data_type" => string(9) "timestamp" "is_nullable" => bool FALSE "ordinal_position" => integer 32 "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "archive" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(7) "archive" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 33 "display" => string(1) "1" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "page_active" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(11) "page_active" "column_default" => NULL "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 34 "display" => string(1) "2" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "last_active" => array(12) ( "type" => string(6) "string" "column_name" => string(11) "last_active" "column_default" => string(1) "0" "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 35 "character_maximum_length" => string(2) "32" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "calproid" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "calproid" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 36 "character_maximum_length" => string(2) "50" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(32) "id assigned by calpro (not used)" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "passwordchanged" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(15) "passwordchanged" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 37 "display" => string(2) "11" "comment" => string(40) "whether password has been changed or not" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "email_date" => array(12) ( "type" => string(6) "string" "column_name" => string(10) "email_date" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 38 "character_maximum_length" => string(3) "150" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "email_count" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(11) "email_count" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 39 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "parent" => array(12) ( "type" => string(6) "string" "column_name" => string(6) "parent" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 40 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(19) "parent sales number" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "children" => array(12) ( "type" => string(6) "string" "binary" => bool TRUE "character_maximum_length" => string(5) "65535" "column_name" => string(8) "children" "column_default" => NULL "data_type" => string(4) "blob" "is_nullable" => bool TRUE "ordinal_position" => integer 41 "comment" => string(17) "array of children" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "reminder" => array(12) ( "type" => string(6) "string" "column_name" => string(8) "reminder" "column_default" => string(1) "0" "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 42 "character_maximum_length" => string(3) "200" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(20) "last weekly reminder" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "web_added" => array(12) ( "type" => string(6) "string" "column_name" => string(9) "web_added" "column_default" => string(1) "0" "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 43 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(23) "Timestamp Added via web" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "confirmed" => array(12) ( "type" => string(6) "string" "column_name" => string(9) "confirmed" "column_default" => string(1) "0" "data_type" => string(7) "varchar" "is_nullable" => bool TRUE "ordinal_position" => integer 44 "character_maximum_length" => string(3) "100" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(25) "Timestamp added to AS/400" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "created_at" => array(10) ( "type" => string(6) "string" "column_name" => string(10) "created_at" "column_default" => string(19) "current_timestamp()" "data_type" => string(9) "timestamp" "is_nullable" => bool FALSE "ordinal_position" => integer 45 "comment" => string(196) "Row-creation time set by MySQL itself. Previously defaulted to the zero-date sentinel and never actually auto-populated - now wi …" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "updated_at" => array(10) ( "type" => string(6) "string" "column_name" => string(10) "updated_at" "column_default" => string(19) "current_timestamp()" "data_type" => string(9) "timestamp" "is_nullable" => bool FALSE "ordinal_position" => integer 46 "comment" => string(147) "Last-modified time set by MySQL itself on every UPDATE. Previously defaulted to the zero-date sentinel with no auto-update - now …" "extra" => string(29) "on update current_timestamp()" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "roster_number" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(13) "roster_number" "column_default" => NULL "data_type" => string(3) "int" "is_nullable" => bool TRUE "ordinal_position" => integer 47 "display" => string(2) "11" "comment" => string(0) "" "extra" => string(0) "" "key" => string(3) "MUL" "privileges" => string(31) "select,insert,update,references" ) "youtube" => array(12) ( "type" => string(6) "string" "column_name" => string(7) "youtube" "column_default" => NULL "data_type" => string(7) "varchar" "is_nullable" => bool FALSE "ordinal_position" => integer 48 "character_maximum_length" => string(3) "255" "collation_name" => string(18) "utf8mb3_unicode_ci" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "dealer_override_youtube" => array(13) ( "type" => string(3) "int" "min" => string(4) "-128" "max" => string(3) "127" "column_name" => string(23) "dealer_override_youtube" "column_default" => string(1) "1" "data_type" => string(7) "tinyint" "is_nullable" => bool FALSE "ordinal_position" => integer 49 "display" => string(1) "4" "comment" => string(0) "" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "show_guide" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(10) "show_guide" "column_default" => string(1) "1" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 50 "display" => string(1) "1" "comment" => string(22) "Show Quick Start Guide" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "total_customers" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(15) "total_customers" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 51 "display" => string(2) "11" "comment" => string(37) "Total customers count of last 1 month" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) "total_customers_extra" => array(13) ( "type" => string(3) "int" "min" => string(11) "-2147483648" "max" => string(10) "2147483647" "column_name" => string(21) "total_customers_extra" "column_default" => string(1) "0" "data_type" => string(3) "int" "is_nullable" => bool FALSE "ordinal_position" => integer 52 "display" => string(2) "11" "comment" => string(38) "Total customers count of last 6 months" "extra" => string(0) "" "key" => string(0) "" "privileges" => string(31) "select,insert,update,references" ) ) protected _updated_column => NULL protected _created_column => NULL protected _serialize_columns => array(0) protected _primary_key => string(6) "number" protected _primary_key_value => NULL protected _table_names_plural => bool TRUE protected _reload_on_wakeup => bool TRUE protected _db => object Database_MySQLi(6)}{ public last_query => string(1895) "SELECT `sales`.`id` AS `id`, `sales`.`ident` AS `ident`, `sales`.`number` AS `number`, `sales`.`firstname` AS `firstname`, `sale …" protected _identifier => string(1) "`" protected _instance => string(7) "default" protected _connection => object mysqli(0)protected _db_group => NULL protected _db_applied => array(1) ( "where" => string(5) "where" ) protected _db_pending => array(1) ( 0 => array(2) ( "name" => string(5) "where" "args" => array(3) ( 0 => string(4) "slug" 1 => string(1) "=" 2 => string(4) "home" ) ) ) protected _db_reset => bool TRUE protected _db_builder => object Database_Query_Builder_Select(19){ }protected _config => array(6) ( "type" => string(6) "MySQLi" "connection" => array(4) ( "hostname" => string(9) "localhost" "persistent" => bool FALSE "database" => string(13) "seemynew_data" "ssl" => NULL ) "table_prefix" => string(0) "" "charset" => string(4) "utf8" "caching" => bool FALSE "profiling" => bool TRUE ) protected _connection_id => string(40) "1849a47644000718ddae333bf7bba4b8e52045a0" }{ protected _type => integer 1 protected _force_execute => bool FALSE protected _lifetime => NULL protected _sql => string(1895) "SELECT `sales`.`id` AS `id`, `sales`.`ident` AS `ident`, `sales`.`number` AS `number`, `sales`.`firstname` AS `firstname`, `sale …" protected _parameters => array(0) protected _as_object => bool FALSE protected _object_params => array(0) protected _where => array(1) ( 0 => array(1) ( "AND" => array(3) ( 0 => string(4) "slug" 1 => string(1) "=" 2 => string(4) "home" ) ) ) protected _order_by => array(0) protected _limit => integer 1 protected _select => array(52) ( 0 => array(2) ( 0 => string(8) "sales.id" 1 => string(2) "id" ) 1 => array(2) ( 0 => string(11) "sales.ident" 1 => string(5) "ident" ) 2 => array(2) ( 0 => string(12) "sales.number" 1 => string(6) "number" ) 3 => array(2) ( 0 => string(15) "sales.firstname" 1 => string(9) "firstname" ) 4 => array(2) ( 0 => string(14) "sales.lastname" 1 => string(8) "lastname" ) 5 => array(2) ( 0 => string(16) "sales.middlename" 1 => string(10) "middlename" ) 6 => array(2) ( 0 => string(10) "sales.name" 1 => string(4) "name" ) 7 => array(2) ( 0 => string(11) "sales.title" 1 => string(5) "title" ) 8 => array(2) ( 0 => string(11) "sales.email" 1 => string(5) "email" ) 9 => array(2) ( 0 => string(21) "sales.alternate_email" 1 => string(15) "alternate_email" ) 10 => array(2) ( 0 => string(11) "sales.phone" 1 => string(5) "phone" ) 11 => array(2) ( 0 => string(12) "sales.phone2" 1 => string(6) "phone2" ) 12 => array(2) ( 0 => string(13) "sales.address" 1 => string(7) "address" ) 13 => array(2) ( 0 => string(10) "sales.city" 1 => string(4) "city" ) 14 => array(2) ( 0 => string(11) "sales.state" 1 => string(5) "state" ) 15 => array(2) ( 0 => string(9) "sales.zip" 1 => string(3) "zip" ) 16 => array(2) ( 0 => string(10) "sales.slug" 1 => string(4) "slug" ) 17 => array(2) ( 0 => string(11) "sales.about" 1 => string(5) "about" ) 18 => array(2) ( 0 => string(12) "sales.config" 1 => string(6) "config" ) 19 => array(2) ( 0 => string(14) "sales.username" 1 => string(8) "username" ) 20 => array(2) ( 0 => string(11) "sales.image" 1 => string(5) "image" ) 21 => array(2) ( 0 => string(14) "sales.facebook" 1 => string(8) "facebook" ) 22 => array(2) ( 0 => string(13) "sales.twitter" 1 => string(7) "twitter" ) 23 => array(2) ( 0 => string(19) "sales.dealer_number" 1 => string(13) "dealer_number" ) 24 => array(2) ( 0 => string(11) "sales.token" 1 => string(5) "token" ) 25 => array(2) ( 0 => string(16) "sales.last_login" 1 => string(10) "last_login" ) 26 => array(2) ( 0 => string(12) "sales.logins" 1 => string(6) "logins" ) 27 => array(2) ( 0 => string(15) "sales.passwordX" 1 => string(9) "passwordX" ) 28 => array(2) ( 0 => string(14) "sales.password" 1 => string(8) "password" ) 29 => array(2) ( 0 => string(15) "sales.timestamp" 1 => string(9) "timestamp" ) 30 => array(2) ( 0 => string(12) "sales.active" 1 => string(6) "active" ) 31 => array(2) ( 0 => string(26) "sales.last_activation_date" 1 => string(20) "last_activation_date" ) 32 => array(2) ( 0 => string(13) "sales.archive" 1 => string(7) "archive" ) 33 => array(2) ( 0 => string(17) "sales.page_active" 1 => string(11) "page_active" ) 34 => array(2) ( 0 => string(17) "sales.last_active" 1 => string(11) "last_active" ) 35 => array(2) ( 0 => string(14) "sales.calproid" 1 => string(8) "calproid" ) 36 => array(2) ( 0 => string(21) "sales.passwordchanged" 1 => string(15) "passwordchanged" ) 37 => array(2) ( 0 => string(16) "sales.email_date" 1 => string(10) "email_date" ) 38 => array(2) ( 0 => string(17) "sales.email_count" 1 => string(11) "email_count" ) 39 => array(2) ( 0 => string(12) "sales.parent" 1 => string(6) "parent" ) 40 => array(2) ( 0 => string(14) "sales.children" 1 => string(8) "children" ) 41 => array(2) ( 0 => string(14) "sales.reminder" 1 => string(8) "reminder" ) 42 => array(2) ( 0 => string(15) "sales.web_added" 1 => string(9) "web_added" ) 43 => array(2) ( 0 => string(15) "sales.confirmed" 1 => string(9) "confirmed" ) 44 => array(2) ( 0 => string(16) "sales.created_at" 1 => string(10) "created_at" ) 45 => array(2) ( 0 => string(16) "sales.updated_at" 1 => string(10) "updated_at" ) 46 => array(2) ( 0 => string(19) "sales.roster_number" 1 => string(13) "roster_number" ) 47 => array(2) ( 0 => string(13) "sales.youtube" 1 => string(7) "youtube" ) 48 => array(2) ( 0 => string(29) "sales.dealer_override_youtube" 1 => string(23) "dealer_override_youtube" ) 49 => array(2) ( 0 => string(16) "sales.show_guide" 1 => string(10) "show_guide" ) 50 => array(2) ( 0 => string(21) "sales.total_customers" 1 => string(15) "total_customers" ) 51 => array(2) ( 0 => string(27) "sales.total_customers_extra" 1 => string(21) "total_customers_extra" ) ) protected _distinct => bool FALSE protected _from => array(1) ( 0 => array(2) ( 0 => string(5) "sales" 1 => string(5) "sales" ) ) protected _join => array(0) protected _group_by => array(0) protected _having => array(0) protected _offset => NULL protected _union => array(0) protected _last_join => NULL }protected _with_applied => array(0) protected _cast_data => array(0) protected _errors_filename => string(5) "sales" protected _behaviors => array(0) protected _private_columns => bool FALSE protected _photos_cache => array(0) }92 93 // Create a new instance of the controller 94 $controller = $class->newInstance($request, $response); 95 96 // Run the controller's execute() method 97 $response = $class->getMethod('execute')->invoke($controller); 98 99 if ( ! $response instanceof Response) 100 { 101 // Controller failed to return a Response. 102 throw new Kohana_Exception('Controller failed to return a Response'); -
SYSPATH/classes/Kohana/Request/Client.php [ 114 ] » Kohana_Request_Client_Internal->execute_request(arguments)
0object Request(19)
{ protected _requested_with => NULL protected _method => string(3) "GET" protected _protocol => string(8) "HTTP/1.1" protected _secure => bool TRUE protected _referrer => NULL protected _route => object Route(5){ protected _filters => array(0) protected _uri => string(6) "<args>" protected _regex => array(1) ( "args" => string(2) ".*" ) protected _defaults => array(4) ( "directory" => string(7) "display" "controller" => string(4) "main" "action" => string(5) "index" "args" => string(4) "home" ) protected _route_regex => string(18) "#^(?P<args>.*)$#uD" }protected _routes => array(0) protected _header => object HTTP_Header(0){ }protected _body => NULL protected _directory => string(7) "Display" protected _controller => string(4) "Main" protected _action => string(5) "index" protected _uri => string(0) "" protected _external => bool FALSE protected _params => array(1) ( "args" => string(4) "home" ) protected _get => array(0) protected _post => array(0) protected _cookies => array(0) protected _client => object Request_Client_Internal(9){ protected _cache => NULL protected _follow => bool FALSE protected _follow_headers => array(1) ( 0 => string(13) "authorization" ) protected _strict_redirect => bool TRUE protected _header_callbacks => array(1) ( "Location" => string(34) "Request_Client::on_header_location" ) protected _max_callback_depth => integer 5 protected _callback_depth => integer 1 protected _callback_params => array(0) protected _previous_environment => NULL }}1object Response(5)
{ protected _status => integer 200 protected _header => object HTTP_Header(0){ }protected _body => string(0) "" protected _cookies => array(0) protected _protocol => string(8) "HTTP/1.1" }109 $orig_response = $response = Response::factory(array('_protocol' => $request->protocol())); 110 111 if (($cache = $this->cache()) instanceof HTTP_Cache) 112 return $cache->execute($this, $request, $response); 113 114 $response = $this->execute_request($request, $response); 115 116 // Execute response callbacks 117 foreach ($this->header_callbacks() as $header => $callback) 118 { 119 if ($response->headers($header)) -
SYSPATH/classes/Kohana/Request.php [ 993 ] » Kohana_Request_Client->execute(arguments)
0object Request(19)
{ protected _requested_with => NULL protected _method => string(3) "GET" protected _protocol => string(8) "HTTP/1.1" protected _secure => bool TRUE protected _referrer => NULL protected _route => object Route(5){ protected _filters => array(0) protected _uri => string(6) "<args>" protected _regex => array(1) ( "args" => string(2) ".*" ) protected _defaults => array(4) ( "directory" => string(7) "display" "controller" => string(4) "main" "action" => string(5) "index" "args" => string(4) "home" ) protected _route_regex => string(18) "#^(?P<args>.*)$#uD" }protected _routes => array(0) protected _header => object HTTP_Header(0){ }protected _body => NULL protected _directory => string(7) "Display" protected _controller => string(4) "Main" protected _action => string(5) "index" protected _uri => string(0) "" protected _external => bool FALSE protected _params => array(1) ( "args" => string(4) "home" ) protected _get => array(0) protected _post => array(0) protected _cookies => array(0) protected _client => object Request_Client_Internal(9){ protected _cache => NULL protected _follow => bool FALSE protected _follow_headers => array(1) ( 0 => string(13) "authorization" ) protected _strict_redirect => bool TRUE protected _header_callbacks => array(1) ( "Location" => string(34) "Request_Client::on_header_location" ) protected _max_callback_depth => integer 5 protected _callback_depth => integer 1 protected _callback_params => array(0) protected _previous_environment => NULL }}988 throw new Request_Exception('Unable to execute :uri without a Kohana_Request_Client', array( 989 ':uri' => $this->_uri, 990 )); 991 } 992 993 return $this->_client->execute($this); 994 } 995 996 /** 997 * Returns whether this request is the initial request Kohana received. 998 * Can be used to test for sub requests. -
DOCROOT/index.php [ 93 ] » Kohana_Request->execute()
88 /** 89 * Execute the main request. A source of the URI can be passed, eg: $_SERVER['PATH_INFO']. 90 * If no source is specified, the URI will be automatically detected. 91 */ 92 echo Request::factory() 93 ->execute() 94 ->send_headers() 95 ->body(); 96