<?php

require dirname(__FILE__) . '/include/init.php';

define('FIX_FOR_REAL', false);

DB::addConnection(50, 'localhost', 'test', 'test', 'jicom');
DB::setDefaultConnection(50);

function stripslashes2($str)
{
    return strtr($str, array('\\"' => '"', "\\'" => "'"));
}

$ecrits = DB::query('SELECT id, titre FROM ecrits ORDER BY id;');

while ($ecrit = DB::fetchRow($ecrits, DB::FETCH_ASSOC))
{
    if (stripslashes2($ecrit['titre']) != $ecrit['titre'])
    {
        if (FIX_FOR_REAL) DB::uQuery('UPDATE ecrits SET titre="'.DB::esc(stripslashes2($ecrit['titre'])).'" WHERE id="'.(int)$ecrit['id'].'";');
        echo "ECRIT #".$ecrit['id']." -> ".$ecrit['titre']."\n";
    }
}

$ecrits = DB::query('SELECT id, texte FROM ecrits_textes ORDER BY id;');

while ($ecrit = DB::fetchRow($ecrits, DB::FETCH_ASSOC))
{
    if (stripslashes2($ecrit['texte']) != $ecrit['texte'])
    {
        if (FIX_FOR_REAL) DB::uQuery('UPDATE ecrits_textes SET texte="'.DB::esc(stripslashes2($ecrit['texte'])).'" WHERE id="'.(int)$ecrit['id'].'";');
        echo "ECRIT_TEXTE #".$ecrit['id']." -> ".$ecrit['texte']."\n";
    }
}

$forums = DB::query('SELECT id, titre FROM forums ORDER BY id;');

while ($msg = DB::fetchRow($forums, DB::FETCH_ASSOC))
{
    if (stripslashes2($msg['titre']) != $msg['titre'])
    {
        if (FIX_FOR_REAL) DB::uQuery('UPDATE forums SET titre="'.DB::esc(stripslashes2($msg['titre'])).'" WHERE id="'.(int)$msg['id'].'";');
        echo "FORUM #".$msg['id']." -> ".$msg['titre']."\n";
    }
}

$forums = DB::query('SELECT id, texte FROM forums_textes ORDER BY id;');

while ($msg = DB::fetchRow($forums, DB::FETCH_ASSOC))
{
    if (stripslashes2($msg['texte']) != $msg['texte'])
    {
        if (FIX_FOR_REAL) DB::uQuery('UPDATE forums_textes SET texte="'.DB::esc(stripslashes2($msg['texte'])).'" WHERE id="'.(int)$msg['id'].'";');
        echo "FORUM_TEXTE #".$msg['id']." -> ".$msg['texte']."\n";
    }
}
?>