'.$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!"; ?>