* @version $Id: decode_entities.php,v 1.6 2008/01/23 09:06:25 andig2 Exp $
* @meta ACCESS:PERM_ADMIN
*/
// move out of contrib for includes
chdir('..');
require_once './core/functions.php';
require_once './engines/engines.php';
?>
Decode HTML Entities
Warning- be sure to backup your data before submitting the cleanup request!";
$SQL = 'SELECT * FROM '.TBL_DATA;
$result = runSQL($SQL);
$count = 0;
foreach ($result as $video)
{
$SQL = '';
$keys = array();
foreach ($video as $key => $value)
{
if ($key == 'id') continue;
$new = html_clean_utf8($value);
if ($new != $value)
{
$keys[] = $key;
if ($SQL) $SQL .= ', ';
$SQL .= "$key = '".escapeSQL($new)."'";
}
}
if ($SQL)
{
$count++;
echo (($submit) ? 'Converting: ' : 'Conversion needed: ').$video['title']."
\n";
// actually perform the conversion?
if ($submit)
{
$SQL = "UPDATE ".TBL_DATA." SET $SQL WHERE id = ".$video['id'];
runSQL($SQL);
}
else
{
foreach($keys as $key)
{
echo $key.': '.htmlentities($video[$key])."
\n";
}
echo "
\n";
}
}
}
$action = ($submit) ? 'Converted' : 'Analyzed';
echo "$action $count of ".count($result)." movies.
\n";
if (empty($submit))
{
?>