def name_repair(var) 
      
   car_names1 = ["HONDA",      
...

#insert new record if it dosent already exist
             if !dbh.select_one('SELECT Salenm FROM Auctions Where Salenm LIKE "%' + c.attributes["href"][/....$/] + '%"')
                dbh.do("INSERT INTO Auctions (Salenm, Date, Location) VALUES (?, ?, 1)", 
...

require 'rubygems'
require 'hpricot'
require 'open-uri'
...

doc.css('file').each do |file|
  file.css('segment').each do |seg|
    nzb << [file.css('group').first.content, seg.content.strip]
...

require 'net/http'
require 'rexml/document'
require 'download.rb'
...