Forum


Notice to all users

We are migrating towards a new forum system located at community.teamspeak.com, as such this forum will become read-only on January 29, 2020

Results 1 to 8 of 8
  1. #1
    Join Date
    December 2009
    Location
    USA
    Posts
    84

    Copy permissions to new group?

    is there any way to copy the permissions from one group to a new group, so i dont have to spend all afternoon entering them? I want a few new groups with just a couple tweaks.

    thanks,

    mark

  2. #2
    Join Date
    December 2009
    Location
    Deutschland
    Posts
    35
    Edit by mod
    This a old topic and copy group option was added for long time now.


    The only way I know is editing the ts3server.sqlitedb SQLite database, so you must have access to the TS3-Folder to do this.

    You can use any tool supporting SQLite, but hereīs a little tutorial using SQLiteman(freeware):

    1. BackUp your ts3server.sqlitedb, you can find it in your ts3-directory and copy it somewhere else(so youīve got it three times: one used by the TS3, one BackUp and one to work with)
    2. Start SQLiteman and open your copied ts3server.sqlitedb
    === To create a new group (this can be done in TS3 as well) ===
    3. Doubleclick on groups_server which you can find under tables in the Tree-View on the windowīs left side
    4. You can see your groups and their IDs in the lower right part of the window, dont mind Group 1-5(1&2 are for ServerQuery logins and 3-5 are templates, I suppose)
    5. Add a new row(=> group) using the Add a row button above the Groups
    6. Fill the row (server_id should be 1, assuming you havenīt got a license yet, and type also 1; group_id is the highest existing group_id +1 and name ... your own decision)
    7. Save the changes by clicking the "save the current transaction..."-button above the grid
    === To copy permissions from a Group to another ===
    8. Now you must use some (easy) SQL
    9. Select all permissions you want to copy
    e.G: You want to copy all permissions of the normal-group, which has the id 7(you can find it in the groups_server-table)
    So write "SELECT * FROM perm_server_group WHERE id1=7" in the SQL-Window in the upper right part of the window and click the green arrow above it("Run SQL")
    Now you have all Permissions you want to copy in the lower right list
    10. Click the "Export Data"-Button above the list (donīt worry, itīs not grayed out)
    11. Save the file anywhere using the "SQL inserts"-Format (without headers)
    12. Open the file using any Text-Editor and replace all original id1 in the insert statements with the id of your new group(you can use a find&replace function, but watch out it replaces nothing exept the id1s)
    13. Save the file and import it to SQLitemans SQL window(the thing in the upper right corner) using the Open button(if it asks you if you "all you changes... ", say yes)
    14 You should see some/many SQL statements
    15 Click the first line and the "Run multiple SQL-statements"-button (the one with two green arrows)
    16 It should import some things
    17 Close SQLite
    18 Stop the TS3-Server
    19 Replace the ts3server.sqlitedb with your edited one
    20 Start the TS3-Server and be happy

    You can do steps 3-7 in TS3 as well (but you must copy the ts3server.sqlitedb AFTER doing this)
    Last edited by florian_fr40; October 26th, 2011 at 08:35 AM.

  3. #3
    Join Date
    December 2009
    Location
    USA
    Posts
    84
    Thanks for this. Easier than entering all the info by hand to multiple groups, which is what i was faced with.

    But, why in the world would they leave this feature missing? Would be a LOT easier to just 'clone' a user id/group/whatever.

  4. #4
    Join Date
    December 2009
    Location
    fl
    Posts
    7
    Adding a GUI feature for this would be very very helpful.

  5. #5
    Join Date
    March 2006
    Location
    Germany
    Posts
    39
    I don't think there is a need for this. You can simply put users in more than one group. One primary group (which would be the "normal" user group) and one secondary group which is almost empty except the permission you want to add / substract (set negate flag).

  6. #6
    Join Date
    December 2009
    Location
    Netherlands / Helmond
    Posts
    18
    it won't work (for me :P)
    i want to copy Server groups from 1 virtual server to another.
    If i replaced al ID1 i get a error

    nsert into <any_table> ("server_id", "id1", "id2", "perm_id", "perm_value", "perm_negated", "perm_skip") values ('1', '20', '0', 'b_virtualserver_token_use', '1', '0', '0');
    -- Error: near "<": syntax error Unable to execute statement.

    Greets

  7. #7
    Join Date
    September 2010
    Location
    netherlands
    Posts
    2
    can be done a lot easier?

    create new group

    login to serverquery

    use sid=1 (or whatever number you want to use)
    servergrouppermlist sgid=[old group id]

    in the reply select everything after:
    error id=0 msg=ok (** ms)
    just before:
    error id=0 msg=ok (** ms)
    Total: ** ms

    copy

    then type:
    servergroupaddperm sgid=[new group id] then just paste everything you copied after this and run it

    vp

  8. #8
    Join Date
    May 2010
    Posts
    6,310
    @vanputten

    This a old topic and copy group option was added for long time now.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [Not Supported] [Mini-Tutorial] How to copy permissions from group x to group y
    By Soljia in forum Server Support
    Replies: 6
    Last Post: July 4th, 2016, 08:16 AM
  2. [Rejected] Right-click copy server group (channel group listed too)
    By Morthawt in forum Suggestions and Feedback
    Replies: 3
    Last Post: July 10th, 2012, 07:44 AM
  3. Copy all permissions
    By Bgdu67 in forum Permission System
    Replies: 3
    Last Post: November 29th, 2010, 03:00 PM
  4. Copy Permissions to another Virtualserver
    By Nightwing in forum Permission System
    Replies: 4
    Last Post: January 16th, 2010, 02:47 AM
  5. Copy/Past group
    By Dutchie in forum Permission System
    Replies: 3
    Last Post: December 29th, 2009, 02:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •