<?php

// DB server hostname, localhost by default
$host = 'localhost'; 
// DB user name (same as for Joomla)
$user = '';
// DB password (same as for Joomla)
$pass = '';
// DB name (same as for Joomla)
$db   = '';
// JoomSEF table, jos_redirection is the default value
$table = 'jos_redirection';

$conn = mysql_connect($host, $user, $pass);

mysql_select_db($db);
$res = mysql_query("SELECT `id`, `newurl` FROM `$table`");

while (($row = mysql_fetch_row($res))) {
    
    $url = $row[1];
    $url = strtr($url, '?', '&');
    
    $parts = split('&', $url);
    
    $newurl = $parts[0];
    array_shift($parts);
    
    if (count($parts) > 0) {
        $newurl .= '?';
     
        foreach ($parts as $i => $val) {
            if (substr($val, 0, 7) == 'option=') {
                $newurl .= $parts[$i];
                unset($parts[$i]);
                if (count($parts) > 0) $newurl .= '&';
                break;
            }
        }
        
        sort($parts);
        $newurl .= join('&', $parts);
    }    
    
    if ($newurl != $row[1]) {
        print("fixing ".$row[1]." \r\n-> $newurl \r\n\r\n");
        mysql_query("UPDATE `$table` SET `newurl` = '$newurl' WHERE `id` = ".$row[0]);
    }
    
}
?>