thorsten /
phpMyFAQ
| @@ 566-591 (lines=26) @@ | ||
| 563 | * |
|
| 564 | * @return array |
|
| 565 | */ |
|
| 566 | public function getGroupData($groupId) |
|
| 567 | { |
|
| 568 | if ($groupId <= 0 || !is_numeric($groupId)) { |
|
| 569 | return false; |
|
| 570 | } |
|
| 571 | ||
| 572 | $select = sprintf(" |
|
| 573 | SELECT |
|
| 574 | group_id, |
|
| 575 | name, |
|
| 576 | description, |
|
| 577 | auto_join |
|
| 578 | FROM |
|
| 579 | %sfaqgroup |
|
| 580 | WHERE |
|
| 581 | group_id = %d", |
|
| 582 | PMF_Db::getTablePrefix(), |
|
| 583 | $groupId |
|
| 584 | ); |
|
| 585 | ||
| 586 | $res = $this->config->getDb()->query($select); |
|
| 587 | if ($this->config->getDb()->numRows($res) != 1) { |
|
| 588 | return []; |
|
| 589 | } |
|
| 590 | return $this->config->getDb()->fetchArray($res); |
|
| 591 | } |
|
| 592 | ||
| 593 | /** |
|
| 594 | * Returns an array that contains the IDs of all groups in which |
|
| @@ 926-949 (lines=24) @@ | ||
| 923 | * @param integer $groupId Group ID |
|
| 924 | * @return string |
|
| 925 | */ |
|
| 926 | public function getGroupName($groupId) |
|
| 927 | { |
|
| 928 | if ($groupId <= 0 || !is_numeric($groupId)) { |
|
| 929 | return false; |
|
| 930 | } |
|
| 931 | ||
| 932 | $select = sprintf(" |
|
| 933 | SELECT |
|
| 934 | name |
|
| 935 | FROM |
|
| 936 | %sfaqgroup |
|
| 937 | WHERE |
|
| 938 | group_id = %d", |
|
| 939 | PMF_Db::getTablePrefix(), |
|
| 940 | $groupId |
|
| 941 | ); |
|
| 942 | ||
| 943 | $res = $this->config->getDb()->query($select); |
|
| 944 | if ($this->config->getDb()->numRows($res) != 1) { |
|
| 945 | return []; |
|
| 946 | } |
|
| 947 | $row = $this->config->getDb()->fetchArray($res); |
|
| 948 | return $row['name']; |
|
| 949 | } |
|
| 950 | ||
| 951 | /** |
|
| 952 | * Removes all users from the group $groupId. |
|
