'.$usr_mpdl.''.$br;
$sql2 = "SELECT url,hits FROM ".$usr_mpdl." "
. "WHERE type='mp' AND (url LIKE '%?%' OR url LIKE '%\#%' OR url LIKE '%&%' OR url LIKE '% %')";
$res2 = mysql_query($sql2);
if ($res2) {
while ($row2 = mysql_fetch_array($res2)) {
$orig_mp = $row2['url'];
$fixed_mp = pureURL($orig_mp);
$hits = $row2['hits'];
$fix_sql = "UPDATE $usr_mpdl SET hits = hits+".$hits.") "
. "WHERE url='".$fixed_mp."'";
$fix_res = mysql_query($fix_sql);
if (!$fix_res) {
$new_sql = "INSERT INTO ".$usr_mpdl." (type,url,hits) VALUES ('mp','$fixed_mp','$hits')";
$new_res = mysql_query($new_sql);
echo 'added: ';
}
$del_sql = "DELETE FROM ".$usr_mpdl." WHERE url = '".$orig_mp."' AND type='mp'";
mysql_query($del_sql);
echo $orig_mp.' >>> '.$fixed_mp.$br;
}
}
}
echo "
All your MP-listings have been fixed!";
?>