|
<?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>";
|