|
|
|
|
Joined: Jun 2006
Posts: 697
Addict
|
|
Addict
Joined: Jun 2006
Posts: 697 |
In the old system, users could create polls. In the new system it seems that every forum got set so that users can NOT create new polls. We have 400+ forums so this would take me a long while to fix manually.
What would the SQL script be to change this across the entire system? Users should always be able to create polls.
Thanks!
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
update ubbt_FORUM_PERMISSIONS
set POLLS_IN_TOPICS=1
where GROUP_ID <> 5
If you want them to be able to make polls in replies as well:
update ubbt_FORUM_PERMISSIONS
set POLLS_IN_TOPICS=1
POLLS_IN_REPLIES=1
where GROUP_ID <> 5
Anyone logged in while this query is done, will need to logout and then log back in, in order to get the new permission.
|
|
|
|
|
Joined: Jun 2006
Posts: 697
Addict
|
|
Addict
Joined: Jun 2006
Posts: 697 |
Just in case anybody else needs to do this, I had to add a comma after line 2 in the second query to get it to work. Then it ran fine! I.e. so it read:
update ubbt_FORUM_PERMISSIONS
set POLLS_IN_TOPICS=1,
POLLS_IN_REPLIES=1
where GROUP_ID <> 5
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Whoops, my ummm comma key was broken....yeah that's it 
|
|
|
|
|
Joined: Jun 2006
Posts: 16,535 Likes: 150
|
|
Joined: Jun 2006
Posts: 16,535 Likes: 150 |
Half of my keyboard is
|
|
|
|
0 members (),
227
guests, and
132
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|
|
