#!/usr/bin/perl

use strict;
use DBI;
use CGI;

my $cgi = new CGI;
print $cgi->header();
my %var = $cgi->Vars;
my $serverid;

exit unless(defined($var{hostname}));

my $shorthost = "";
use YAML qw( LoadFile );
my $config_settings = LoadFile("/var/www/conf/backup_master_config.yaml") || die "Failed to load config: $!\n";
my $dbh = DBI->connect("DBI:mysql:database=".$config_settings->{backup_db}.";host=localhost",$config_settings->{backup_user}, $config_settings->{backup_pass}) or die("couldnt connect to db $!"); 

my $stmt = "SELECT serverid FROM server WHERE hostname= ?";
if ($dbh->selectrow_array($stmt, undef, $var{hostname})) {
  if($var{hostname} =~ m/^(\w+)([\w\.]+)/) {
    $shorthost = $1;
  }
} else {
  print "Invalid Client Submission\n";
  exit 1;
}

if($var{beta}){
  $serverid = getserverid_beta($var{hostname});
}else{
  $serverid = getserverid($var{hostname});
}
if($serverid == 0){
#  insertserver($var{hostname}, $shorthost);
  $serverid = getserverid($var{hostname});
}
#print "shost: $shorthost\n";
#print "serverid: $serverid\n";


my $localip = getip($serverid);
print $localip;
#unless($localip == 0){
#  print "serverip: $localip\n";
#}else{
#  insertip($serverid, $var{ip});
#}

#### subs below this line ####


sub insertserver {
  my $name = shift;
  my $sname = shift;
  my $query = "INSERT INTO server ( hostname, host ) VALUES (?, ?)";
  my $sth = $dbh->prepare($query);
  $sth->execute($name, $sname) or warn $sth->errstr;
  print "$name $sname inserted\n";
}

sub getip {
  my $serverid = shift;
  my $query = "SELECT INET_NTOA(backnetip) as backnetip FROM newbacknetip WHERE serverid = ?";
  my $sth = $dbh->prepare($query);
  $sth->bind_param(1,$serverid, { TYPE => &DBI::SQL_INTEGER });
  $sth->execute or warn $sth->errstr;
  if(my $ref = $sth->fetchrow_hashref()){
    $sth->finish;
    return $ref->{backnetip};
  }else{
    return 0;
  }
}
sub insertip {
  my $id = shift;
  my $ip = shift;
  my $query = "INSERT INTO newbacknetip ( serverid, backnetip ) values (?, INET_ATON(?))";
  my $sth = $dbh->prepare($query);
  $sth->bind_param(1,$id, { TYPE => &DBI::SQL_INTEGER });
  $sth->bind_param(2,$ip, { TYPE => &DBI::SQL_VARCHAR });
  $sth->execute or warn $sth->errstr;
  print "$ip inserted\n";
}

sub getserverid {
  my $name = shift;
  my $query = "SELECT serverid,hostname,host FROM server WHERE hostname = ?";
  my $sth = $dbh->prepare($query);
  $sth->execute($name) or warn $sth->errstr;
  if(my $ref = $sth->fetchrow_hashref()){
    $sth->finish;
    return $ref->{serverid};
  }else{
    return 0;
  }
}
sub getserverid_beta {
  my $name = shift;
  my $query = "SELECT serverid,hostname,host FROM server WHERE hostname like ?";
  my $sth = $dbh->prepare($query);
  $sth->execute("$name\%.beta\%") or warn $sth->errstr;
  if(my $ref = $sth->fetchrow_hashref()){
    $sth->finish;
    return $ref->{serverid};
  }else{
    return 0;
  }
}
