require 'mysql'
require 'socket'
require 'open-uri'
require 'uri'

#con = Mysql.new('localhost','root','purple4','stdw_market')
#rs = con.query("select * from tbl_commod")
#rs.each_hash { |h| puts h['CommodName'] }
#con.close

#class SqlBot
#  def initialize(address, port, username, password)
#    puts "Addy : #{address}"
#    puts "Port : #{port}"
#    puts "User : #{username}"
#    puts "Pass : #{password}"
#    @client = TCPSocket.new(address, port)
#    @client.puts "connect #{username} #{password}"
#  end
#
#  def msg(message)
##    @client.puts "#{message}"
#  end
#end

#bot = SqlBot.new('localhost','4201','test','blah')
#bot.msg("this is my test")