if (!$this->oBD->Execute($consulta_sql)) { return array('error' => 'Error insert File in Data Base'); } } //Comprobamos el Ășltimo id $consulta_sql = "SELECT MAX(v.id_version) as version FROM " . $this->sTablaArchivoVersion . " as v WHERE v.id_archivo='" . $id_archivo_version . "';"; $rs = $this->oBD->Execute($consulta_sql); $aResultado = $rs->GetRows(); $rs->Close(); $version = 1; if ($aResultado[0]['version'] != "" || $aResultado[0]['version'] != NULL) { $version = $aResultado[0]['version'] + 1; } $consulta_sql = "INSERT INTO " . $this->sTablaArchivoVersion . " (id_version,id_archivo, fecha, nombre, size) "; $consulta_sql .= " VALUES({$version},{$id_archivo_version},'{$fecha}','{$filename}','{$size}')"; if (!$this->oBD->Execute($consulta_sql)) { return array('error' => 'Error insert File in Data Base'); } else { //Convert PDF to SWF PdfToSwfConverter::convertPdfToSwf($uploadDirectory . $filename_new . '.' . $ext, $uploadDirectory . $filename_new . '.swf'); return array('success' => true); } } } else { return array('error' => 'Could not save uploaded file.' . 'The upload was cancelled, or server error encountered'); } } } $oFile = new File(); $oFile->setBD($oBD);