public function run()
{
if (version_compare(VERSION, '3.0', '>=') && $this->Database->tableExists('tl_files') && $this->Database->fieldExists('image', 'tl_link_data')) {
$objData = $this->Database->prepare("SELECT id,image FROM tl_link_data WHERE 1")->execute();
if ($objData->numRows) {
while ($objData->next()) {
$objImage = $this->Database->prepare("SELECT id FROM tl_files WHERE path = ?")->execute($objData->image);
if ($objImage->id > 0) {
$this->log("UPDATE tl_link_data SET image = " . $objImage->id . " WHERE id = " . $objData->id . " ", 'SQL Update 2.x to 3.x', TL_GENERAL);
$this->Database->prepare("UPDATE tl_link_data SET image = ? WHERE id = ? ")->execute($objImage->id, $objData->id);
}
}
}
}
if (version_compare(VERSION, '3.2', '>=') && $this->Database->tableExists('tl_link_data')) {
$arrFields = $this->Database->listFields('tl_link_data');
foreach ($arrFields as $arrField) {
if ($arrField['name'] == 'image' && $arrField['type'] != 'binary') {
Database\Updater::convertSingleField('tl_link_data', 'image');
}
}
}
/* remove protocol */
$this->Database->prepare("UPDATE `tl_link_data` SET `url` = CONCAT(`url_protocol`, `url`), url_protocol = ''")->execute();
if (version_compare(VERSION, '3.2', '>=')) {
$strFile = 'system/modules/delirius_linkliste/config/database.sql';
if (\Files::getInstance()->is_writeable($strFile)) {
\Files::getInstance()->delete($strFile);
}
}
}
public function run()
{
Database\Updater::convertSingleField('tl_galerie_pictures', 'fullscreenSingleSRC');
Database\Updater::convertSingleField('tl_galerie_pictures', 'singleSRC');
Database\Updater::convertSingleField('tl_galerie_pictures', 'thumbSRC');
Database\Updater::convertSingleField('tl_galerie', 'themesSRC');
Database\Updater::convertSingleField('tl_galerie', 'dummy');
Database\Updater::convertMultiField('tl_content', 'imagesFolder');
Database\Updater::convertMultiField('tl_content', 'imagesFolder');
}
public function run()
{
if (version_compare(VERSION, '3.2', '>=') && $this->Database->tableExists('tl_slogan_data')) {
$arrFields = $this->Database->listFields('tl_slogan_data');
foreach ($arrFields as $arrField) {
if ($arrField['name'] == 'image' && $arrField['type'] != 'binary') {
Database\Updater::convertSingleField('tl_slogan_data', 'image');
}
}
}
if (version_compare(VERSION, '3.2', '>=')) {
$strFile = 'system/modules/delirius_slogan/config/database.sql';
if (\Files::getInstance()->is_writeable($strFile)) {
\Files::getInstance()->delete($strFile);
}
}
}
