|'.$filename.'|'.$filetype.'|'.$filesize.'|'.$bin_data.'|'; $this->setError($Language->getText('tracker_artifactfile','required_fields')); return false; } if (session_loggedin()) { $userid=user_getid(); } else { $userid=100; } // If $filetype is "text/plain", $bin_data convert UTF-8 encoding. if (strcasecmp($filetype,"text/plain") === 0 && function_exists('mb_convert_encoding') && function_exists('mb_detect_encoding')) { $bin_data = mb_convert_encoding($bin_data,'UTF-8',mb_detect_encoding($bin_data, "auto")); $filesize = strlen($bin_data); } db_begin(); $res=db_query("INSERT INTO artifact_file (artifact_id,description,bin_data,filename,filesize,filetype,adddate,submitted_by) VALUES ('".$this->Artifact->getID()."','$description','". base64_encode($bin_data) ."','$filename', '$filesize','$filetype','". time() ."','$userid')"); $id=db_insertid($res,'artifact_file','id'); if (!$res || !$id) { db_rollback(); $this->setError('ArtifactFile: '.db_error()); return false; } else { /* // // skip this unless we need it later - save a db query // // // Now set up our internal data structures // if (!$this->fetchData($id)) { db_rollback(); return false; } */ db_commit(); $this->Artifact->addHistory('File Added',$id.': '.$filename); $this->clearError(); return $id; } } /** * delete - delete this artifact file from the db. * * @return boolean success. */ function delete() { if (!$this->Artifact->ArtifactType->userIsTechnician()) { $this->setPermissionDeniedError(); return false; } $res=db_query("DELETE FROM artifact_file WHERE id='". $this->getID() ."'"); if (!$res || db_affected_rows($res) < 1) { $this->setError('ArtifactFile: Unable to Delete'); return false; } else { $this->Artifact->addHistory('File Deleted',$this->getID().': '.$this->getName()); return true; } } /** * fetchData - re-fetch the data for this ArtifactFile from the database. * * @param int The file_id. * @return boolean success. */ function fetchData($id) { $res=db_query("SELECT * FROM artifact_file_user_vw WHERE id='$id'"); if (!$res || db_numrows($res) < 1) { $this->setError('ArtifactFile: Invalid ArtifactFile ID'); return false; } $this->data_array =& db_fetch_array($res); db_free_result($res); return true; } /** * getArtifact - get the Artifact Object this ArtifactFile is associated with. * * @return object Artifact. */ function &getArtifact() { return $this->Artifact; } /** * getID - get this ArtifactFile's ID. * * @return int The id #. */ function getID() { return $this->data_array['id']; } /** * getName - get the filename. * * @return string filename. */ function getName() { return $this->data_array['filename']; } /** * getType - get the type. * * @return string type. */ function getType() { return $this->data_array['filetype']; } /** * getData - get the binary data from the db. * * @return binary. */ function &getData() { return base64_decode($this->data_array['bin_data']); } /** * getSize - get the size. * * @return int size. */ function getSize() { return $this->data_array['filesize']; } /** * getDescription - get the description. * * @return string description. */ function getDescription() { return $this->data_array['description']; } /** * getDate - get the date file was added. * * @return int unix time. */ function getDate() { return $this->data_array['adddate']; } /** * getSubmittedBy - get the user_id of the submitter. * * @return int user_id. */ function getSubmittedBy() { return $this->data_array['submitted_by']; } /** * getSubmittedRealName - get the real name of the submitter. * * @return string name. */ function getSubmittedRealName() { return $this->data_array['realname']; } /** * getSubmittedUnixName - get the unix name of the submitter. * * @return string unixname. */ function getSubmittedUnixName() { return $this->data_array['user_name']; } } // Local Variables: // mode: php // c-file-style: "bsd" // End: ?>