function collect_groups()
 {
     $sql = "SELECT * FROM {$this->groupstable} WHERE group_single_user = 0";
     $result = cpg_db_query($sql, $this->link_id);
     $udb_groups = array(102 => 'Administrators', 2 => 'Registered', 3 => 'Guests');
     while ($row = mysql_fetch_assoc($result)) {
         $udb_groups[$row[$this->field['grouptbl_group_id']] + 100] = utf_ucfirst(utf_strtolower($row[$this->field['grouptbl_group_name']]));
     }
     return $udb_groups;
 }

 function collect_groups()
 {
     $sql = "SELECT * FROM {$this->groupstable}";
     $result = cpg_db_query($sql, $this->link_id);
     $udb_groups = array(1 => 'Guests');
     while ($row = mysql_fetch_assoc($result)) {
         $udb_groups[$row[$this->field['grouptbl_group_id']] + 100] = utf_ucfirst(utf_strtolower($row[$this->field['grouptbl_group_name']]));
     }
     return $udb_groups;
 }

 function collect_groups()
 {
     $sql = "SELECT * FROM {$this->groupstable}";
     $result = $this->query($sql);
     // XMB has no guest group in groups table, so adding one here
     $udb_groups = array(3 => 'Guests');
     while ($row = cpg_db_fetch_assoc($result)) {
         $udb_groups[$row['id'] + 100] = utf_ucfirst(utf_strtolower($row[$this->field['grouptbl_group_name']]));
     }
     $result->free();
     return $udb_groups;
 }

 function collect_groups()
 {
     // Use this version to exclude true post based groups
     //$sql ="SELECT * FROM {$this->groupstable} WHERE minposts=-1";
     // Use this version to include all SMF groups
     $sql = "SELECT * FROM {$this->groupstable}";
     $result = cpg_db_query($sql, $this->link_id);
     $udb_groups = array(1 => 'Guests', 2 => 'Registered');
     while ($row = mysql_fetch_assoc($result)) {
         $udb_groups[$row[$this->field['grouptbl_group_id']] + 100] = utf_ucfirst(utf_strtolower($row[$this->field['grouptbl_group_name']]));
     }
     return $udb_groups;
 }

 function synchronize_groups()
 {
     global $CONFIG;
     if ($this->use_post_based_groups) {
         if ($this->group_overrride) {
             $udb_groups = $this->collect_groups();
         } else {
             $sql = "SELECT * FROM {$this->groupstable} WHERE {$this->field['grouptbl_group_name']} <> ''";
             $result = cpg_db_query($sql, $this->link_id);
             $udb_groups = array();
             while ($row = mysql_fetch_assoc($result)) {
                 $udb_groups[$row[$this->field['grouptbl_group_id']] + 100] = utf_ucfirst(utf_strtolower($row[$this->field['grouptbl_group_name']]));
             }
         }
     } else {
         $udb_groups = array(1 => 'Administrators', 2 => 'Registered', 3 => 'Guests');
     }
     $result = cpg_db_query("SELECT group_id, group_name FROM {$CONFIG['TABLE_USERGROUPS']} WHERE 1");
     while ($row = mysql_fetch_array($result)) {
         $cpg_groups[$row['group_id']] = $row['group_name'];
     }
     mysql_free_result($result);
     /* Must be removed to allow new groups to be created in an unbridged install.
        // Scan Coppermine groups that need to be deleted
        foreach($cpg_groups as $c_group_id => $c_group_name) {
            if ((!isset($udb_groups[$c_group_id]))) {
                cpg_db_query("DELETE FROM {$CONFIG['TABLE_USERGROUPS']} WHERE group_id = '" . $c_group_id . "' LIMIT 1");
                unset($cpg_groups[$c_group_id]);
            }
        }
        */
     // Scan udb groups that need to be created inside Coppermine table
     foreach ($udb_groups as $i_group_id => $i_group_name) {
         if (!isset($cpg_groups[$i_group_id])) {
             // add admin info
             $admin_access = in_array($i_group_id - 100, $this->admingroups) ? '1' : '0';
             cpg_db_query("INSERT INTO {$CONFIG['TABLE_USERGROUPS']} (group_id, group_name, has_admin_access) VALUES ('{$i_group_id}', '" . addslashes($i_group_name) . "', '{$admin_access}')");
             $cpg_groups[$i_group_id] = $i_group_name;
         }
     }
     // Update Group names
     foreach ($udb_groups as $i_group_id => $i_group_name) {
         if ($cpg_groups[$i_group_id] != $i_group_name) {
             cpg_db_query("UPDATE {$CONFIG['TABLE_USERGROUPS']} SET group_name = '" . addslashes($i_group_name) . "' WHERE group_id = '{$i_group_id}' LIMIT 1");
         }
     }
     // fix admin grp
     if (!$this->use_post_based_groups) {
         cpg_db_query("UPDATE {$CONFIG['TABLE_USERGROUPS']} SET has_admin_access = '1' WHERE group_id = '1' LIMIT 1");
     }
 }

 function collect_groups()
 {
     $sql = "SELECT * FROM {$this->groupstable}";
     $result = $this->query($sql);
     $udb_groups = array(1 => 'Administrators', 2 => 'Registered', 3 => 'Guests');
     while ($row = cpg_db_fetch_assoc($result)) {
         $udb_groups[$row[$this->field['grouptbl_group_id']] + 100] = utf_ucfirst(utf_strtolower($row[$this->field['grouptbl_group_name']]));
     }
     $result->free();
     return $udb_groups;
 }