<% require "cgi" ERuby.import('cgi.txt') $cgi = CGI_Simple.new require "mysql" $db = Mysql.new('MYSQL-HOST', 'MYSQL-USERNAME', 'MYSQL-PASSWORD', 'MYSQL-DATABASE') class BreadcrumbItem def initialize(title, url) @title = title @url = url end def show puts "#{@title} > " end def show_last puts @title end end class BreadcrumbTrail def initialize @items = [] end def add(title, url) item = BreadcrumbItem.new(title, url) @items.push(item) end def show last = @items.pop for i in 0...@items.length @items[i].show end last.show_last end end class User attr_reader :ok, :info def initialize(username, password) #print "logging in: "+username+", password: "+password+"
\n" @ok = 0 result = $db.query("SELECT * FROM forum_users WHERE username='#{$db.quote(username)}' AND password='#{$db.quote(password)}'") if result.num_rows == 1 @ok = 1; @info = result.fetch_hash end end end # # do we have a *new* valid login? # test_user = User.new($cgi.getparam('login_username'), $cgi.getparam('login_password')) if test_user.ok == 1 #print "ok!
" $cgi.setcookie('ruby_username', $cgi.param('login_username')) $cgi.setcookie('ruby_password', $cgi.param('login_password')) end if $logout == 1 $logout = 0 #print "fail!
" $cgi.setcookie('ruby_username', '') $cgi.setcookie('ruby_password', '') end $navigation = BreadcrumbTrail.new $user = User.new($cgi.getcookie('ruby_username'), $cgi.getcookie('ruby_password')) $navigation.add("Home", "./") %>