Редакция 564 | К новейшей редакции | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | 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 | }
|