The secure CMS.

Welcome to Geeklog, Anonymous Saturday, December 21 2024 @ 10:05 am EST

Geeklog Forums

Changing the rights of ALL staticpages in one time.

 New Topic  Post Reply
 12/03/03 01:36am (Read 3,367 times)  
Status: offline

xspace

Forum User
Regular Poster
Registered: 03/04/03
Posts: 100
confused
Is there anyway to change the rights of all staticpages all at once, w/o doing it one by one ... i wan to give the staticpage E rights to GROUP.

THx!!!
Die young, stay Pretty
 Quote
 12/03/03 10:00am  
Status: offline

Turias

Forum User
Full Member
Registered: 10/20/03
Posts: 807
There is no way to do this through Geeklog. You would probably have to write a php script to do this. Maybe phpMyAdmin or something similar has this functionality, but I'm not sure...
 Quote
 12/03/03 10:14am  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
An SQL request like

UPDATE gl_staticpage SET perm_group = 3;

should do the trick.

bye, Dirk
 Quote
 12/03/03 10:16pm  
Status: offline

xspace

Forum User
Regular Poster
Registered: 03/04/03
Posts: 100
Quote by Dirk: An SQL request like

UPDATE gl_staticpage SET perm_group = 3;

should do the trick.

bye, Dirk


Kewl Dirk ... will try it out .. I knew that some sort of SQL would help, as I seen it before in some threads. But I dun know which is which ... Smile

Thx!
Die young, stay Pretty
 Quote
 12/03/03 10:39pm  
Status: offline

xspace

Forum User
Regular Poster
Registered: 03/04/03
Posts: 100
It worked ...

Typing these, so that someone can search it in a simpler manner ... Laughing Out Loud
changing permissions
SQL permissions
Update permissions
Die young, stay Pretty
 Quote
 New Topic  Post Reply
All times are EST. The time is now 10:05 am.
  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content