View difference between Paste ID: KYh84JCQ and TPyVQSE2

 #!/usr/bin/env ruby
 require 'nokogiri'
 require 'open-uri'
 require 'sequel'
 require 'sqlite3'
 require 'pry'
 require 'uri'
 require 'cgi'
 
 
   DB = Sequel.connect('sqlite:///Users/RyanOConnor/workspace/testing/clubland-2/clublandlv.sqlite')
   genre_table = DB[:genres].select_map(:genre_id)
   subgenre_table = DB[:subgenres]
 
 puts genre_table
 binding.pry
 
 =begin
     clubland = "http://www.clublandlv.com/forumdisplay.php?f=46"
 
       doc = Nokogiri::HTML(open(clubland))
 
       doc.css("#forumbits").each do |grab|
         subgenres = grab.css(".forumtitle a").map(&:text)
         subgenre_links = grab.css(".forumtitle a"){[:href]}
 
          subgenre_links = subgenre_links.map do |links|
           link_id = links.attr("href")
           CGI.parse(URI.parse(link_id).query)['f'].first.to_i
           end
 
               subgenre_table.import([:subgenre, :subgenre_id], subgenres.zip(subgenre_links))
 
        end
 =end
 
 
 I added a Zippyshare link that includes this script as well as the database itself so you can local test.(Just change the path to the DB in the .rb)
-http://www48.zippyshare.com/v/33147561/file.html
+http://www13.zippyshare.com/v/71604817/file.html
 
 Basically there is an unique ID per genre, you can see this listed in the genre_id column in the genres table.
 I want to run the commented script for each genre_id. The commented script grabs the subgenres for each genre.
 
 clubland = "http://www.clublandlv.com/forumdisplay.php?f=46"  You can see the 46 is the unique ID for a specific forum.