';

echo 'CONVERT PAGELAYOUT' . LF;
echo '=================================================================' . LF.LF;

$pagelayout = _dbQuery("SELECT * FROM ".DB_PREPEND."phpwcms_pagelayout WHERE pagelayout_var NOT LIKE '%:{%'");

$c = 0;

foreach($pagelayout as $var) {
	$sql  = "UPDATE ".DB_PREPEND."phpwcms_pagelayout SET ";
	$sql .=	"pagelayout_var='".aporeplace(base64_decode($var['pagelayout_var']))."' ";
	$sql .= "WHERE pagelayout_id = ".$var['pagelayout_id'];
	$upgrade = _dbQuery($sql, 'UPDATE');

	echo html_specialchars($var['pagelayout_name']).': ';
	echo $upgrade['AFFECTED_ROWS'] ? $upgrade['AFFECTED_ROWS'] : html_specialchars($sql);
	echo LF;

	$c++;
}

if(!$c) echo 'No pagelayout for conversation found!';


echo '