[Linuxvm-dev] Applicable database feilds

[Matthew J. D. <mda...@se...>]

Vince,

I have added th following database feilds:

email_user_name
email_password
email_server_address

You can pull the info from the database with this code


  my $dsn = "DBI:mysql:database=voicemail";
  my $user = "voicemail";
  my $password = "commail";
  my $dbh = DBI->connect($dsn, $user, $password);
  my $sql = qq{SELECT <*XXXX*> FROM VM_Users where extension = $extension};
  my $sth = $dbh->prepare($sql);
  $sth->execute();
  my $current_greeting = ($sth->fetchrow_array())[0];
  $sth->finish();
  $dbh->disconnect ();

Tomorrow at 11:30ish looks good.  I'll call if something comes up.  (Things
always come up - just how long will it take is the question)

-Matt