Scoutnet vzw

man crontab

#!/bin/bash
DESTINATION="$HOME/emailaliases"
SOURCE="$HOME/public_html/private/list.txt"
rsync $SOURCE $DESTINATION

<?php
require_once ('../include/include.php');
$dsn = "mysql://$user:$pass@$host/$dbName";
$db = DB::connect($dsn);
if (DB::isError($db)){die ($db->getMessage());}
$list=array("Kapoenen leiding","Welpen leiding","Akabe leiding","Jonggiver leiding","Giver leiding","Jin Leiding","Stam");
$emailaliases = "#-------------- \r\n";
$emailaliases .= "#Groepsadressen \r\n";
$emailaliases .= "#-------------- \r\n";
$emailaliases .= "xxx  sn0904_0 \r\n";
$emailaliases .= "xxx sn0904_0 \r\n";
$emailaliases .= "xxx  sn0904_1 \r\n";
$emailaliases .= "xxx  sn0904_2 \r\n";
$emailaliases .= "xxx  sn0904_3 \r\n";
$emailaliases .= "xxx  sn0904_4 \r\n";
$emailaliases .= "xxx  sn0904_5 \r\n";
$emailaliases .= "xxx  sn0904_6 \r\n";
$emailaliases .= "xxx  sn0904_7 \r\n";
$emailaliases .= "xxx  sn0904_8 \r\n";
$emailaliases .= "xxx sn0904_9 \r\n";
$take['8'] = "#Alle leiding\r\n";
foreach ($list as $key => $tak){
   $sql = "SELECT * FROM `leiding` LEFT JOIN `ledenlijst` ON `ledenlijst_Lidnummer` = `leiding_Lidnummer` LEFT JOIN `taknamen` ON `ledenlijst_Functiecode` =`taknamen_Code` WHERE `taknamen_Naam` = '".$tak."'";
   $result = $db->query($sql);
   if (DB::isError($result)){die ($result->getMessage());}
   $emailaliases .= ("#---------------------------- \r\n");
   $emailaliases .= ("#".$tak." \r\n");
   $emailaliases .= ("#---------------------------- \r\n");
   $take[$key] = "#".$tak."\r\n#------------------- \r\n";
   $take[8] .= "#".$tak."\r\n#------------------- \r\n";
   while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)){
      if($row['leiding_Email_2'] != ""){
         $take[$key] .= $row['leiding_Email_2']." \r\n";
         $take[8] .= $row['leiding_Email_2']." \r\n";
         $emailaliases .= ($row['leiding_Email'].' '.$row['leiding_Email_2']." \r\n");

      }
   }
}
$emailaliases .= "#Onbestaande adressen gaan naar: \r\n";
$emailaliases .= "@scoutslommel.scoutnet.be sn0904@scoutsnet.be \r\n";
$handle = fopen ("email/emailaliases", "w");
fwrite($handle, $emailaliases);
$handle = fopen ("email/sn0904_1", "w");
fwrite($handle, $take[0]);
$handle = fopen ("email/sn0904_2", "w");
fwrite($handle, $take[1]);
$handle = fopen ("email/sn0904_3", "w");
fwrite($handle, $take[2]);
$handle = fopen ("email/sn0904_4", "w");
fwrite($handle, $take[3]);
$handle = fopen ("email/sn0904_5", "w");
fwrite($handle, $take[4]);
$handle = fopen ("email/sn0904_6", "w");
fwrite($handle, $take[5]);
$handle = fopen ("email/sn0904_7", "w");
fwrite($handle, $take[6]);
$handle = fopen ("email/sn0904_8", "w");
fwrite($handle, $take[8]);
//echo $emailaliases;
//echo ('<pre>');
//print_r($take);
?>