Project

General

Profile

Bug #44752 » set-pids.php

Fixed support for upload-tt_content elements - Simon Schick, 2013-03-04 17:27

 
<?php
//nur hier anpassen
$database = 'typo3';
$user = 'root';
$password = '';

mysql_connect('localhost', $user, $password);
mysql_select_db($database);

echo "<pre>";

//tt_content+image (text+image, image) OR tt_content+media (upload)
$resultFileReference = mysql_query("SELECT uid, uid_foreign FROM sys_file_reference WHERE tablenames='tt_content' AND (fieldname='image' OR fieldname='media')");
while ($rowFileReference = mysql_fetch_assoc($resultFileReference)) {
$resultContent = mysql_query("SELECT uid, pid FROM tt_content WHERE uid=".$rowFileReference['uid_foreign']);
$rowContent = mysql_fetch_assoc($resultContent);
mysql_query("UPDATE sys_file_reference SET pid=".$rowContent['pid']." WHERE uid=".$rowFileReference['uid']);
echo 'fileReference with uid: '.$rowFileReference['uid'].' is on page '.$rowContent['pid'].'/successful'.chr(10);
}

//pages+media
$resultFileReference = mysql_query("SELECT uid, uid_foreign FROM sys_file_reference WHERE tablenames='pages' AND fieldname='media'");
while ($rowFileReference = mysql_fetch_assoc($resultFileReference)) {
mysql_query("UPDATE sys_file_reference SET pid=".$rowFileReference['uid_foreign']." WHERE uid=".$rowFileReference['uid']);
echo 'fileReference with uid: '.$rowFileReference['uid'].' is on page '.$rowFileReference['uid_foreign'].'/successful'.chr(10);
}

//pages_language_overlay+media
$resultFileReference = mysql_query("SELECT uid, uid_foreign FROM sys_file_reference WHERE tablenames='pages_language_overlay' AND fieldname='media'");
while ($rowFileReference = mysql_fetch_assoc($resultFileReference)) {
$resultOverlay = mysql_query("SELECT uid, pid FROM pages_language_overlay WHERE uid=".$rowFileReference['uid_foreign']);
$rowOverlay = mysql_fetch_assoc($resultOverlay);
mysql_query("UPDATE sys_file_reference SET pid=".$rowOverlay['pid']." WHERE uid=".$rowFileReference['uid']);
echo 'fileReference with uid: '.$rowFileReference['uid'].' is on page '.$rowOverlay['pid'].'/successful'.chr(10);
}

mysql_free_result($resultFileReference);

echo "</pre>";
(5-5/5)