Редакция 670 | Редакция 672 | К новейшей редакции | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 670 | Редакция 671 | ||
---|---|---|---|
Строка 703... | Строка 703... | ||
703 | $show .= $this->secure->checkStr($dist["type"],1)." "; |
703 | $show .= $this->secure->checkStr($dist["type"],1)." "; |
704 | if ($base["sign_id"]!=0) { |
704 | if ($base["sign_id"]!=0) { |
705 | $query = "SELECT * FROM ".$this->prefix."signs WHERE sign_id='".$base["sign_id"]."'"; |
705 | $query = "SELECT * FROM ".$this->prefix."signs WHERE sign_id='".$base["sign_id"]."'"; |
706 | $rq =& $this->db->query($query); |
706 | $rq =& $this->db->query($query); |
707 | $rq->fetchInto($sign); |
707 | $rq->fetchInto($sign); |
708 | $show .= "[".$this->secure->checkStr($sign["sign"],1)."] "; |
708 | $show .= "[".$this->secure->checkStr($sign["sname"],1)."] "; |
709 | }
|
709 | }
|
710 | $show .= $this->secure->checkStr($base["proto"],1).$this->secure->checkStr($base["rhost"],1).$this->secure->checkStr($base["rfolder"],1)." "; |
710 | $show .= $this->secure->checkStr($base["proto"],1).$this->secure->checkStr($base["rhost"],1).$this->secure->checkStr($base["rfolder"],1)." "; |
711 | $show .= $this->secure->checkStr($base["scheme"],1); |
711 | $show .= $this->secure->checkStr($base["scheme"],1)." "; |
712 | 712 | ||
713 | // Формируем sections
|
713 | // Формируем sections
|
714 | $query = "SELECT * FROM ".$this->prefix."section s "; |
714 | $query = "SELECT * FROM ".$this->prefix."section s "; |
715 | $query .= "JOIN ".$this->prefix."sect2rep r ON s.sect_id=r.sect_id "; |
715 | $query .= "JOIN ".$this->prefix."sect2rep r ON s.sect_id=r.sect_id "; |
716 | $query .= "WHERE r.rep_id='".$base["rep_id"]."' AND ("; |
716 | $query .= "WHERE r.rep_id='".$base["rep_id"]."' AND ("; |
Строка 750... | Строка 750... | ||
750 | $show .= $this->secure->checkStr($dist["type"],1)." "; |
750 | $show .= $this->secure->checkStr($dist["type"],1)." "; |
751 | if ($updates["sign_id"]!=0) { |
751 | if ($updates["sign_id"]!=0) { |
752 | $query = "SELECT * FROM ".$this->prefix."signs WHERE sign_id='".$base["sign_id"]."'"; |
752 | $query = "SELECT * FROM ".$this->prefix."signs WHERE sign_id='".$base["sign_id"]."'"; |
753 | $rqs =& $this->db->query($query); |
753 | $rqs =& $this->db->query($query); |
754 | $rqs->fetchInto($sign); |
754 | $rqs->fetchInto($sign); |
755 | $show .= "[".$this->secure->checkStr($sign["sign"],1)."] "; |
755 | $show .= "[".$this->secure->checkStr($sign["sname"],1)."] "; |
756 | }
|
756 | }
|
757 | $show .= $this->secure->checkStr($updates["proto"],1).$this->secure->checkStr($updates["rhost"],1).$this->secure->checkStr($updates["rfolder"],1)." "; |
757 | $show .= $this->secure->checkStr($updates["proto"],1).$this->secure->checkStr($updates["rhost"],1).$this->secure->checkStr($updates["rfolder"],1)." "; |
758 | $show .= $this->secure->checkStr($updates["scheme"],1); |
758 | $show .= $this->secure->checkStr($updates["scheme"],1)." "; |
759 | // Формируем sections
|
759 | // Формируем sections
|
760 | $query = "SELECT * FROM ".$this->prefix."section s "; |
760 | $query = "SELECT * FROM ".$this->prefix."section s "; |
761 | $query .= "JOIN ".$this->prefix."sect2rep r ON s.sect_id=r.sect_id "; |
761 | $query .= "JOIN ".$this->prefix."sect2rep r ON s.sect_id=r.sect_id "; |
762 | $query .= "WHERE r.rep_id='".$updates["rep_id"]."'"; |
762 | $query .= "WHERE r.rep_id='".$updates["rep_id"]."'"; |
763 | $rq =& $this->db->query($query); |
763 | $rq =& $this->db->query($query); |