bacula@yourdir:~$ bconsole
*sql
SELECT sum(JobBytes)/1073741824 FROM Job WHERE StartTime > '2008-02-07' AND Type = 'B'

bacula@yourdir:~$ bconsole
*sql
SELECT sum(JobFiles) FROM Job WHERE Type = 'B'

";
   dump_sql();
   print "

\n";
        foreach ($attribs as $arr) {
                print "$arr = " . $formul[$arr] . "\n";
        }

        print "orgtype = " . $org_type_lst[$formul['orgtype_id']] . "\n";
        print "orgindustry = " . $org_industry_lst[$formul['orgindustry_id']] . "\n";
        print "bacula_version = " . $version_lst[$formul['bacula_version']] . "\n";
        print "country = " . $country_lst[$formul['country_id']] . "\n";
        print "ostype = " . $os_lst[$formul['ostype_id']] . "\n";
        print "catalog = " . $catalog_lst[$formul['catalog_id']] . "\n";

        print "
\n";
}

function get_file_from_id()
{
    global $dat_dir;
    $id = $_REQUEST['id'];

    if (!ereg('^[a-zA-Z0-9\.]+$',$id)) {
         return(0) ;
    }

    $filename="$dat_dir/profile.$id";

    if (!file_exists($filename)) {
         echo "Can't verify your id";
         return (0);
    }       

    return $filename;
}

function send_email($id, $name, $email)
{
        // Your email address
//        $from = 'kern@sibbald.com';
        $from = 'eric@eb.homelinux.org';

        // The subject
        $subject = "[BACULA] New testimonial";

        // The message
        $message = "Hello, 
You can modify your new testimonial at http://www.bacula.org/en/?page=testimonial&action=Modify&id=$id

Best regards.
";

        mail($email, $subject, $message, "From: Bacula WebMaster <$from>");

        $message = "Hello, 
You can review this testimonial at http://www.bacula.org/en/?page=testimonial&action=Modify&id=$id

Best regards.
";

        
        mail('testimonial@baculasystems.com', $subject, $message, "From: $name <$email>");

        echo "The email has been sent for approval.
";
}

function save_formul($form)
{
        $fp = fopen($form['filename'], 'w'); 
        fwrite($fp, serialize($form));
        fclose($fp);
}

function get_formul()
{
        global $upload_dir;
        global $dat_dir;
        $formul = array();
        $attribs = array('contact_name','email_address', 'org_name');
        foreach ($attribs as $arr) {
                if (!$_REQUEST[$arr]) {
                        echo "Can't get $arr
";
                        return '';
                }
                $formul[$arr] = preg_replace('/[^a-zA-Z0-9!\.?\:\/,;_()@\n -]/', " ", $_REQUEST[$arr]);
        }

        $attribs = array('title','website','hardware_comments','comments')		;
        foreach ($attribs as $arr) {
                $formul[$arr] = preg_replace('/[^a-zA-Z0-9!\.?\:\/,;_()@\n -]/', " ", $_REQUEST[$arr]);
        }
        /* Disallow http:// links into comments field */
        $m = array();
        preg_match('/http:\/\//', $_REQUEST['comments'], $m);
        if (sizeof($m) > 2) {
           return '';
        }
        $m = array();
        preg_match('/http:\/\//', $_REQUEST['hardware_comments'], $m);
        if (sizeof($m) > 2) {
           return '';
        }
        /* Disallow when number of dir too big or > number of fd */
        if (intval($_REQUEST['number_dir']) > 100 || 
            intval($_REQUEST['number_dir']) > intval($_REQUEST['number_fd'])) {
           return '';
        }
        $attribs = array('publish_contact','publish_email', 'publish_orgname', 'orgtype_id', 
                         'orgindustry_id','org_size', 'publish_orgsize','publish_website', 'bacula_version',
                         'country_id','ostype_id', 'redundant_setup','number_fd','number_sd','support',
                         'month_gb','number_files','catalog_id','number_dir');
        foreach ($attribs as $arr) {
                $tmp = $_REQUEST[$arr];
                $tmp = preg_replace("/[,\.]/", "", $tmp);
                if (preg_match("/^[0-9]+$/", $tmp)) {
                        $formul[$arr] = $_REQUEST[$arr];
                }
        }

        $attribs = array('orgtype_id', 'orgindustry_id', 'org_size', 'country_id','bacula_version',
                         'catalog_id', 'ostype_id','number_fd','number_sd', 'number_dir', 'month_gb','number_files');
        foreach ($attribs as $arr) {
                if (!$formul[$arr]) {
                        echo "Can't get $arr
";
                        return '';
                }
        }

        if ($_FILES['org_logo']) {
                $token = uniqid(md5(rand()), true);
                $image = "/upload/$token";

                if (preg_match("/(jpg|jpeg)$/i", $_FILES['org_logo']['name'])) {
                        $image = "$image.jpg";
                } elseif (preg_match("/png$/i", $_FILES['org_logo']['name'])) {
                        $image = "$image.png";
                } elseif (preg_match("/gif$/i", $_FILES['org_logo']['name'])) {
                        $image = "$image.gif";
                } else {
                        $image = '';
                }
                if ($image) {
                        $ret=move_uploaded_file($_FILES['org_logo']['tmp_name'], "$upload_dir/$image");
                        $formul['org_logo'] = $image;
                }
        }
        $formul['date'] = time();
        $formul['visible'] = false;

        return $formul;
}

function form_set_value($formul,$val)
{
 echo "document.getElementById('$val').value = '" . $formul[$val] . "';\n";
}

function form_set_selection($formul,$val)
{
 echo "document.getElementById('${val}_" . $formul[$val] . "').selected =true;\n";
}

function form_set_text($formul,$val)
{
 $temp = $formul[$val];
 $temp = str_replace(array("\n", "\r"), array("\\n",""), $temp);
 echo "document.getElementById('$val').value='" . $temp . "';\n";
}

// passwd file must exist in dat directory
function is_admin()
{
   global $dat_dir;
   $id = $_REQUEST['p'];

   if (!$id) {
       return(false);
   }

   if (!ereg('^[a-zA-Z]+$',$id)) {
       return(false) ;
   }
   
   if (file_exists("$dat_dir/$id")) {
       return true;
   } else {
       return false;
   }
}

function admin_link()
{
   global $password;
   if (is_admin()) {
      $pass = $_REQUEST['p'];
      $waiting = $_REQUEST['waiting'];    
      $password = "&p=$pass";
      print "Admin: ";
      if ($waiting) {
         print " View all
";
      } else {
         print " View all | ";
         print " View Waiting
";
      }
	   print "
";
   }
}

function load_formul($filename)
{
   if (!file_exists($filename)) {
           return array();
   }

   if (!filesize($filename) || filesize($filename) > 10*1024*1024) {
       return undef;
   }
   $fp = fopen($filename, 'r');
   $contents = fread ($fp, filesize ($filename));
   fclose ($fp);

   $formul = unserialize($contents);
   if (!is_array($formul)) {
       return undef;
   }

   return $formul;
}

function print_formul_file($filename, $admin) {
    global $password;
    $form = load_formul($filename);
    if (!$form) {
       return 0;
    }
    
    if (!$admin) {
       if (!$form['visible']) {
          return 0;
       }
    } 
    $waiting = $_REQUEST['waiting'];
    if ($admin && $waiting && $form['visible']) {
       return 0;
    }

    $ret = print_formul($form);
    if ($admin) {
       if ($form['visible']) {
          print " Hide  | \n";
       } else {
          print " Accept  | \n";
       }
       print " Modify  | \n";
       print " Export 

\n";
   }
   return $ret;
}

function dump_sql()
{
   global $dat_dir, $country_lst, $org_type_lst, $org_industry_lst, $os_lst,$catalog_lst, $version_lst;
   if (!is_admin()) {
     return;
   }
?>
   CREATE TABLE dict (lang text, id int, name text, primary key (lang, id));
   CREATE TABLE testimonials (
    contact_name        text,
    email_address       text,
    org_name            text,
    title               text  DEFAULT '',
    website             text  DEFAULT '',
    filename            text  DEFAULT '',
    month_gb            int   DEFAULT 0,
    number_files        bigint DEFAULT 0,
    number_dir          int   DEFAULT 0,
    number_fd           int   DEFAULT 0,
    number_sd           int   DEFAULT 0,
    org_size            int   DEFAULT 0,

    country_id          int,
    ostype_id           int,
    bacula_version      int,
    contry_id           int,
    orgindustry_id      int,
    orgtype_id          int,
    catalog_id          int,

    id                  text,
    publish_contact     int    DEFAULT 0,
    publish_email       int    DEFAULT 0,
    publish_website     int    DEFAULT 0,
    publish_orgname     int    DEFAULT 0,
    publish_orgsize     int    DEFAULT 0,
    redundant_setup     int    DEFAULT 0,
    support             int    DEFAULT 0,
    comments            text   DEFAULT '',
    hardware_comments   text   DEFAULT '', 
    visible             int    DEFAULT 0,
    org_logo            text   DEFAULT '',
    date                int    DEFAULT 0,
    lastmodifed         int    DEFAULT 0
   );

   CREATE VIEW reference AS SELECT contact_name,email_address,org_name,title,website,hardware_comments,comments,
          publish_contact,publish_email,publish_orgname,org_size,publish_orgsize,publish_website,
          redundant_setup,number_fd,number_sd,support,month_gb,number_files,number_dir,date,visible,filename,t.id,
          orgtype.name AS orgtype, 
          orgindustry.name AS orgindustry,
          version.name AS bacula_version,
          country.name AS country,
          ostype.name AS ostype,
          catalog.name AS catalog
   FROM testimonials AS t, dict AS  orgtype, dict AS orgindustry, dict AS version, dict AS country, dict AS ostype,
        dict AS catalog

   WHERE t.orgtype_id = orgtype.id            AND orgtype.lang     = 'en'
     AND t.orgindustry_id = orgindustry.id    AND orgindustry.lang = 'en'
     AND t.bacula_version = version.id AND version.lang = 'en'
     AND t.country_id = country.id            AND country.lang = 'en'
     AND t.ostype_id  = ostype.id             AND ostype.lang = 'en'
     AND t.catalog_id = catalog.id            AND catalog.lang = 'en';


   INSERT INTO dict (lang, id, name) VALUES ('en', 0, 'no');
   INSERT INTO dict (lang, id, name) VALUES ('en', 1, 'yes');

   

   

   

    1) { ?>
         1) { ?>
        

   
 Date: 
 
   
 Location: 
 
   
 Organization Type: 
 
   
 Industry/Function: 
 

   
        
 Organisation Size: 
 
   

   
        
 Website: 

   

   
 Number of fd: 
 
   

   
 GB/Month: 
 
   

   
 Comments: