Incoming Examples¶

This is an initial collection of code examples.

Dealing with files¶

See if a file already exists in the storage¶

Code snippet from t3api62:TYPO3\CMS\Install\Updates\TceformsUpdateWizard:

$fileSha1 = sha1_file($sourcePath);

$existingFileRecord = $this->database->exec_SELECTgetSingleRow(
   'uid',
   'sys_file',
   'sha1=' . $this->database->fullQuoteStr($fileSha1, 'sys_file') . ' AND storage=' . $storageUid
);
if (is_array($existingFileRecord)) {
   $fileUid = $existingFileRecord['uid'];
} else {
   $fileUid = NULL;
}

Dealing with file references¶

Create a file reference¶

Code snippet from t3api62:TYPO3\CMS\Install\Updates\TceformsUpdateWizard::performUpdate:

if ($fileUid > 0) {
   $fields = array(
      // TODO add sorting/sorting_foreign
      'fieldname' => $fieldname,
      'table_local' => 'sys_file',
      // the sys_file_reference record should always placed on the same page
      // as the record to link to, see issue #46497
      'pid' => ($table === 'pages' ? $row['uid'] : $row['pid']),
      'uid_foreign' => $row['uid'],
      'uid_local' => $fileUid,
      'tablenames' => $table,
      'crdate' => time(),
      'tstamp' => time(),
      'sorting' => ($i + 256),
      'sorting_foreign' => $i,
   );
   if (isset($titleTextField)) {
      $fields['title'] = trim($titleTextContents[$i]);
   }
   if (isset($alternativeTextField)) {
      $fields['alternative'] = trim($alternativeTextContents[$i]);
   }
   if (isset($captionField)) {
      $fields['description'] = trim($captionContents[$i]);
   }
   if (isset($linkField)) {
      $fields['link'] = trim($linkContents[$i]);
   }
   $this->database->exec_INSERTquery('sys_file_reference', $fields);
   $queries[] = str_replace(LF, ' ', $this->database->debug_lastBuiltQuery);
   ++$i;
}