1:
2:
3:
4:
5:
6:
7:
8:

CREATE TABLE `hphp0_grps`
  (`ID` INT PRIMARY KEY AUTO_INCREMENT,
   `name` VARCHAR(255),
   `password` VARCHAR(255),
   [...]
   `galerie0_canUploadPic` TINYINT(1) DEFAULT 0,
   `galerie0_canDeletePic` TINYINT(1) DEFAULT 0,
   [...]);

1:
2:
3:
4:

CREATE TABLE `create_gal` (`gallery_id` [SMALL]INT, `group_id` [SMALL]INT)
CREATE TABLE `del_gal` LIKE `create_gal`

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:

function getusrright ($str) {
    if (!$_SESSION['logdIn'])
        return false;
    global $sql, $scriptnr;
    $sql->queryDb('SELECT `grpID` FROM `hphp'.$scriptnr.'_users` WHERE `ID` = '.$_SESSION['userID'].';');
    if (!$sql->getErr()) {
        $row = $sql->fetchRow();
        $sql->queryDb('SELECT `'.$str.'` FROM `hphp'.$scriptnr.'_groups` WHERE `ID` = '.$row[0].';');
        if (!$sql->getErr()) {
            $row = $sql->fetchRow();
            return (bool)$row[0];
        }
    }
    return -1;
}

1:
2:
3:
4:
5:
6:
7:
8:

CREATE TABLE `gal_usrright`
	(`grpID` INT,
	 `canCrtGal` TINYINT(1) DEFAULT 0,
	 `canDelGal` TINYINT(1) DEFAULT 0,
	 `canEdiGal` TINYINT(1) DEFAULT 0,
	 `canUplPic` TINYINT(1) DEFAULT 0,
	 `canDelPic` TINYINT(1) DEFAULT 0,
	 `canEdiPic` TINYINT(1) DEFAULT 0);