#!/usr/bin/perl -w
use strict;
use CGI;
use DBI;
use Template;
use CGI::Ajax;
use CGI::Session;
use CGI::Cookie;
use CGI::Session::Driver::mysql;
use CGI::Carp qw(fatalsToBrowser);
my ($src, $lib, $files);
#print "Content-type:text/html\n\n";
my $cgi = CGI->new();
my $ip = $cgi->remote_host();
my $sid = $cgi->cookie("CGISESSID") || undef;
my $os = $^O;
if($os =~ /MSWin32/){
    $src = 'D:/mixedapache/cgies/templatetoolkit/src';
    $lib = 'D:/mixedapache/cgies/templatetoolkit/lib';
    $files = 'D:/mixedapache/cgies/templatetoolkit/';  
}else{
    $src = '/mnt/win_d/mixedapache/cgies/templatetoolkit/src';
    $lib = '/mnt/win_d/mixedapache/cgies/templatetoolkit/lib';
    $files = '/mnt/win_d/mixedapache/cgies/templatetoolkit/';
}
my $dbh = DBI->connect('dbi:mysql:phones', 'name', 'password', {RaiseError =>1});
my $session = CGI::Session->new('driver:mysql',
                                $sid,
                                { TableNAme  => 'sessions',
                                  IdColNAme  => 'id',
                                  DataColName=> 'a_session',
                                  Handle     => $dbh,
               }) or die CGI::Session->errstr;
my $cookie = $cgi->new(-name => $session->name, -value => $session->id);
print $session->header();
my $config = {
  INCLUDE_PATH => [
                   $src,
                   $lib,
                   $files,
                   ]
};
my $tt    = Template->new($config);
my $url ='/cgi-bin/ajax.pl';
my $ajaxbit = CGI::Ajax->new(
    'external'      => $url,
    'login'         => \&login,
    'skip_header'   => 1,
);
$ajaxbit->skip_header(1);
print $ajaxbit->build_html($cgi, \&mainpage);
sub mainpage{
    my $output = '';
        my $vars = {
        };
        my $input = 'perltemp';
        $tt->process($input, $vars, \$output)
            || die $tt->error( );
    return $output;
}