thorsten /
phpMyFAQ
| @@ 119-144 (lines=26) @@ | ||
| 116 | * @param integer $user_id User ID |
|
| 117 | * @return array |
|
| 118 | */ |
|
| 119 | public function getUserRights($user_id) |
|
| 120 | { |
|
| 121 | // get user rights |
|
| 122 | $select = sprintf(" |
|
| 123 | SELECT |
|
| 124 | fr.right_id AS right_id |
|
| 125 | FROM |
|
| 126 | %sfaqright fr, |
|
| 127 | %sfaquser_right fur, |
|
| 128 | %sfaquser fu |
|
| 129 | WHERE |
|
| 130 | fr.right_id = fur.right_id AND |
|
| 131 | fu.user_id = %d AND |
|
| 132 | fu.user_id = fur.user_id", |
|
| 133 | PMF_Db::getTablePrefix(), |
|
| 134 | PMF_Db::getTablePrefix(), |
|
| 135 | PMF_Db::getTablePrefix(), |
|
| 136 | $user_id); |
|
| 137 | ||
| 138 | $res = $this->config->getDb()->query($select); |
|
| 139 | $result = []; |
|
| 140 | while ($row = $this->config->getDb()->fetchArray($res)) { |
|
| 141 | $result[] = $row['right_id']; |
|
| 142 | } |
|
| 143 | return $result; |
|
| 144 | } |
|
| 145 | ||
| 146 | /** |
|
| 147 | * Gives the user a new user-right. |
|
| @@ 456-472 (lines=17) @@ | ||
| 453 | * |
|
| 454 | * @return array |
|
| 455 | */ |
|
| 456 | public function getAllRights() |
|
| 457 | { |
|
| 458 | $select = sprintf(" |
|
| 459 | SELECT |
|
| 460 | right_id |
|
| 461 | FROM |
|
| 462 | %sfaqright", |
|
| 463 | PMF_Db::getTablePrefix()); |
|
| 464 | ||
| 465 | $res = $this->config->getDb()->query($select); |
|
| 466 | $result = []; |
|
| 467 | while ($row = $this->config->getDb()->fetchArray($res)) { |
|
| 468 | $result[] = $row['right_id']; |
|
| 469 | } |
|
| 470 | ||
| 471 | return $result; |
|
| 472 | } |
|
| 473 | ||
| 474 | /** |
|
| 475 | * Returns an array that contains all rights stored in the |
|
| @@ 638-655 (lines=18) @@ | ||
| 635 | * |
|
| 636 | * @return array |
|
| 637 | */ |
|
| 638 | public function getAllGroups() |
|
| 639 | { |
|
| 640 | $select = sprintf(" |
|
| 641 | SELECT |
|
| 642 | group_id |
|
| 643 | FROM |
|
| 644 | %sfaqgroup", |
|
| 645 | PMF_Db::getTablePrefix() |
|
| 646 | ); |
|
| 647 | ||
| 648 | $res = $this->config->getDb()->query($select); |
|
| 649 | $result = []; |
|
| 650 | while ($row = $this->config->getDb()->fetchArray($res)) { |
|
| 651 | $result[] = $row['group_id']; |
|
| 652 | } |
|
| 653 | ||
| 654 | return $result; |
|
| 655 | } |
|
| 656 | ||
| 657 | /** |
|
| 658 | * Get all groups in <option> tags |
|
