<?php

require_once ("inc/stdLib.php");

$sql1="select id,phone from customer where phone <> ''";

//$sql2="select trans_id as id,shiptophone as phone from shipto where phone <> ''";

$sql3="select id,phone from vendor where phone <> ''";

$sql4="select id,homephone as phone from employee where homephone <> ''";

$sql5="select cp_id as id,cp_phone1 as phone from contacts where cp_phone1 <> ''";

$sql6="select cp_id as id,cp_phone2 as phone from contacts where cp_phone2 <> ''";

$sql7="select cp_id as id,cp_mobile1 as phone from contacts where cp_mobile1 <> ''";

$sql8="select cp_id as id,cp_mobile2 as phone from contacts where cp_mobile2 <> ''";

$sql9="select cp_id as id,cp_fax as phone from contacts where cp_fax <> ''";

$sql10="select cp_id as id,cp_homephone as phone from contacts where cp_homephone <> ''";

$rs=$_SESSION['db']->getAll($sql1,DB_FETCHMODE_ASSOC);

foreach($rs as $eintrag) {

mkTelNummer($eintrag["id"],"C",array($eintrag["phone"]));

}

$rs=$_SESSION['db']->getAll($sql3,DB_FETCHMODE_ASSOC);

foreach($rs as $eintrag) {

mkTelNummer($eintrag["id"],"V",array($eintrag["phone"]));

}

$rs=$_SESSION['db']->getAll($sql4,DB_FETCHMODE_ASSOC);

foreach($rs as $eintrag) {

mkTelNummer($eintrag["id"],"E",array($eintrag["phone"]));

}

$rs1=$_SESSION['db']->getAll($sql5,DB_FETCHMODE_ASSOC);

$rs2=$_SESSION['db']->getAll($sql6,DB_FETCHMODE_ASSOC);

$rs3=$_SESSION['db']->getAll($sql7,DB_FETCHMODE_ASSOC);

$rs4=$_SESSION['db']->getAll($sql8,DB_FETCHMODE_ASSOC);

$rs5=$_SESSION['db']->getAll($sql9,DB_FETCHMODE_ASSOC);

$rs6=$_SESSION['db']->getAll($sql10,DB_FETCHMODE_ASSOC);

$rs=array_merge($rs1,$rs2);

foreach($rs as $eintrag) {

mkTelNummer($eintrag["id"],"P",array($eintrag["phone"]),false);

}

?>