Code:
$sqlVehicleInsert = "INSERT INTO
".$this->db_prefix."vehicles.vehicles(
vin_crc
,vin
,stock_crc
,stock
,flag_active
,flag_sold
,flag_new
,flag_certified
,flag_special
,flag_oneowner
,flag_home
,time_create
,time_update
,time_instock
,time_sold
,time_inactive
,source_id
,dealer_id
,location_id
,switchboard_id
,year
,make_refid
,model_refid
,modelnumber_refid
,miles
,doors
,passengers
,wheelbase
,evox_vif
,body_refid
,trim_refid
,style_refid
,style_brief_refid
,class_refid
,color_ext_refid
,color_ext_generic_refid
,color_ext_code_refid
,color_ext_hex
,color_int_refid
,color_int_generic_refid
,color_int_code_refid
,color_int_hex
,upholstery_refid
,engine_cylinders_refid
,mpg_city
,mpg_highway)VALUES(CRC32(?),?,CRC32(?),?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
$parmsVehicleInsert = array(
$this->vehicle_data->vin
,$this->vehicle_data->vin
,$this->vehicle_data->stock
,$this->vehicle_data->stock
,$this->vehicle_data->time_create
,$this->vehicle_data->time_update
,$this->vehicle_data->time_instock
,$this->vehicle_data->time_sold
,$this->vehicle_data->time_inactive
,$this->vehicle_data->source_id
,$this->vehicle_data->dealer_id
,$this->vehicle_data->location_id
,$this->vehicle_data->switchboard_id
,$this->vehicle_data->year
,$this->vehicle_data->make_refid
,$this->vehicle_data->model_refid
,$this->vehicle_data->modelnumber_refid
,$this->vehicle_data->miles
,$this->vehicle_data->doors
,$this->vehicle_data->passengers
,$this->vehicle_data->wheelbase
,$this->vehicle_data->evox_vif
,$this->vehicle_data->body_refid
,$this->vehicle_data->trim_refid
,$this->vehicle_data->style_refid
,$this->vehicle_data->style_brief_refid
,$this->vehicle_data->class_refid
,$this->vehicle_data->color_ext_refid
,$this->vehicle_data->color_ext_generic_refid
,$this->vehicle_data->color_ext_code_refid
,$this->vehicle_data->color_ext_hex
,$this->vehicle_data->color_int_refid
,$this->vehicle_data->color_int_generic_refid
,$this->vehicle_data->color_int_code_refid
,'xxxxxx' //,$this->vehicle_data->color_int_hex
,$this->vehicle_data->upholstery_refid
,$this->vehicle_data->engine_cylinders_refid
,$this->vehicle_data->mpg_city
,$this->vehicle_data->mpg_highway
);
$this->db->query($sqlVehicleInsert,$parmsVehicleInsert);
