$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "search SET ipaddress = '' WHERE ipaddress <> ''");