<?php
/* Exports the baramundi computers to a csv file
   Requires the mssql php module, install with: sudo apt-get install php5-sybase
   
   Change /etc/freetds/freetds.conf tds version  to 8.0 -->
   [global]
   tds version = 8.0
   
   Author: Christian Moeller (moeller@sploing.org)
 */

/* Baramundi MS-SQL Database settings */
$bara_db_host         = 'baramundiserver.firma.de\SQLEXPRESS';
$bara_db_user         = 'db-user';
$bara_db_pass         = 'db-pass';
$bara_db_database     = 'master';

$bara_sql_query_file  = 'bara_query_computer.sql';
$csv_filename         = 'bara_computer.csv';
$csv_seperator        = ';';

echo "\n~~~Baramundi Hardware to CSV~~\n";

$mssql_connection = mssql_connect ($bara_db_host, $bara_db_user, $bara_db_pass) or die ('Database connection failed: '.mssql_get_last_message() );
if ($mssql_connection){
  echo "Database connected\n";
  mssql_select_db($bara_db_database,$mssql_connection)	or die ('Could not select the Database '.$bara_db_database);
  runquery();
}

function runquery(){
  global $bara_sql_query_file, $mssql_connection, $csv_filename, $csv_seperator;
  $query = utf8_encode(file_get_contents("./".$bara_sql_query_file, false));
  #echo "\n\n\n".$query."\n\n\n";
  if (!$query){
    exit("Error! Could not read SQL file ".$bara_sql_query_file);
  } else {
    echo "Querying...\n";
    $result = mssql_query($query,$mssql_connection);
    if (!$result) {
      exit("Error! SQL Query failed, received no data");
    } else {
      /* create file */
      $csvfile = fopen("./".$csv_filename, "w");
      
      if (!$csvfile) {
        exit("Error! Could not create file ".$csv_filename);
      } else {
        echo "Creating file...\n";
        /* col names */
        for ($i = 0; $i < mssql_num_fields($result); ++$i) {
          fwrite($csvfile, "\"".str_replace('"','',mssql_field_name($result, $i))."\"".$csv_seperator);
        }
        fwrite($csvfile, "\n");
        /* rows */
        while($row = mssql_fetch_assoc($result))
        {
          for ($i = 0; $i < mssql_num_fields($result); ++$i) {
            fwrite($csvfile, "\"".str_replace('"','',$row[mssql_field_name($result, $i)])."\"".$csv_seperator);
          }
          fwrite($csvfile, "\n");
        }
        fclose($csvfile);
        echo "Finished, created ".$csv_filename."\n";
      }
    } 
  }
}

?>