pquery($dbQuery,array($notesid)); $folderid = $adb->query_result($result,0,'folderid'); $filename = $adb->query_result($result,0,'filename'); $filestatus = $adb->query_result($result,0,'filestatus'); $fileidQuery = "select attachmentsid from vtiger_seattachmentsrel where crmid = ?"; $fileidRes = $adb->pquery($fileidQuery,array($notesid)); $fileid = $adb->query_result($fileidRes,0,'attachmentsid'); $pathQuery = $adb->pquery("select path from vtiger_attachments where attachmentsid = ?",array($fileid)); $filepath = $adb->query_result($pathQuery,0,'path'); $fileinattachments = $root_directory.$filepath.$fileid.'_'.$filename; if(!file($fileinattachments))$fileinattachments = $root_directory.$filepath.$fileid."_".$filename; $newfileinstorage = $root_directory."/storage/$fileid-".$filename; if($filestatus == 1){ copy($fileinattachments,$newfileinstorage); } echo ""; exit(); ?>