<?

class dbr{ 

    function dbr($type){}
    function abon($type){
         global $kon,$mod;
        $link = $this->connect_to_mysql();
            
        $query = "select kacod,katype from alldata where kamod=$mod and kakontr=$kon and katype=$type";
        if($result1 = mysql_query($query,$link)){
           while($row1 = mysql_fetch_object($result1)){
                 $user=$row1->kacod;
           }
        }
        return $user;
    }
    
    function connect_to_mysql(){
   
    
       $link = mysql_connect(MY_HOST, MY_DB, MY_USER, MY_PASSWD);// устанавливаем соединение с БД
       mysql_select_db(MY_DB,$link);
       mysql_query('SET NAMES utf8');
       mysql_query ("set character_set_client='utf8'"); 
       mysql_query ("set character_set_results='utf8'"); 
       mysql_query ("set collation_connection='utf8_general_ci'");
       if($link) return $link;
       else false;
    }
    
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Обработка данных
    
    function beac($arr_beac,$date){
        global $kon,$mod;
        $user1=$this->user(1);
        $user2=$this->user(2);
        
        foreach ($arr_beac as $param=>$str){
            $query='';
            switch ($param){
                case "street":
                    if(preg_match("/Str_/",$str))$str=str_replace("Str_","(",$str).")";
                    $query = "delete from kastree where kacod=$user1 and date='$date'";
                    if(isset($user1) && $user1!='')mysql_query($query);
                    $query = "insert into street(kacod,date,kastr) values($user1,'$date','$str')";
                    if(isset($user1) && $user1!='')mysql_query($query);
                    break;

            }
        }
    }