Редакция 564 | Редакция 568 | К новейшей редакции | Весь файл | Учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 564 | Редакция 567 | ||
---|---|---|---|
Строка 619... | Строка 619... | ||
619 | $repID = $this->secure->checkInt($actor); |
619 | $repID = $this->secure->checkInt($actor); |
620 | if ($repID==0) { |
620 | if ($repID==0) { |
621 | $query = "SELECT * FROM ".$this->prefix."section"; |
621 | $query = "SELECT * FROM ".$this->prefix."section"; |
622 | $rq =& $this->db->query($query); |
622 | $rq =& $this->db->query($query); |
623 | while ($rq->fetchInto($element)) { |
623 | while ($rq->fetchInto($element)) { |
624 | $show .= "<input type='checkbox' name='".$name."[]' value='".$element["sect_id"]."'> ".$this->secure->checkStr($element["secname"],1)." "; |
624 | $show .= "<input type='checkbox' name='".$name."[]' value='".$element["sect_id"]."'> ".$this->secure->checkStr($element["secname"],1)." "; |
625 | }
|
625 | }
|
626 | } else { |
626 | } else { |
627 | $query = "SELECT * FROM ".$this->prefix."section s JOIN ".$this->prefix."sect2rep r ON s.sect_id=r.sect_id WHERE r.rep_id='$repID'"; |
627 | $query = "SELECT * FROM ".$this->prefix."section s JOIN ".$this->prefix."sect2rep r ON s.sect_id=r.sect_id WHERE r.rep_id='$repID'"; |
628 | $rq =& $this->db->query($query); |
628 | $rq =& $this->db->query($query); |
629 | while ($rq->fetchInto($element)) { |
629 | while ($rq->fetchInto($element)) { |
630 | $show .= "<input type='checkbox' name='".$name."[]' value='".$element["sect_id"]."' checked> ".$this->secure->checkStr($element["secname"],1)." "; |
630 | $show .= "<input type='checkbox' name='".$name."[]' value='".$element["sect_id"]."' checked> ".$this->secure->checkStr($element["secname"],1)." "; |
631 | }
|
631 | }
|
632 | $query = "SELECT s.* FROM ".$this->prefix."section s WHERE s.sect_id NOT IN (SELECT sect_id FROM ".$this->prefix."sect2rep WHERE rep_id='$repID')"; |
632 | $query = "SELECT s.* FROM ".$this->prefix."section s WHERE s.sect_id NOT IN (SELECT sect_id FROM ".$this->prefix."sect2rep WHERE rep_id='$repID')"; |
633 | $rq =& $this->db->query($query); |
633 | $rq =& $this->db->query($query); |
634 | while ($rq->fetchInto($element)) { |
634 | while ($rq->fetchInto($element)) { |
635 | $show .= "<input type='checkbox' name='".$name."[]' value='".$element["sect_id"]."'> ".$this->secure->checkStr($element["secname"],1)." "; |
635 | $show .= "<input type='checkbox' name='".$name."[]' value='".$element["sect_id"]."'> ".$this->secure->checkStr($element["secname"],1)." "; |
636 | }
|
636 | }
|
637 | }
|
637 | }
|
638 | 638 | ||
639 | break; |
639 | break; |
640 | }
|
640 | }
|