Can I update a user's accessList with a mysql update query?
4 posts by 2 authors in: Forums > CMS Builder
Last Post: November 21, 2010 (RSS)
By markr - November 19, 2010
Can you help me with the query to do this for one specific section only?
Also, can I import users into the db with author access for a specific section enabled?
Re: [markr] Can I update a user's accessList with a mysql update query?
By Dave - November 20, 2010
I've attached a sample form that creates user accounts. Have a look at the code and comments for an example. It has some example PHP/MySQL code for setting the access levels.
Hope that helps! Let me know any questions.
interactivetools.com
Re: [Dave] Can I update a user's accessList with a mysql update query?
By markr - November 21, 2010
Btw, if you don't mind explaining, I'm curious, why does phpMyAdmin list all my cms_ tables normally but cms_accesslist is listed under cms, like a sub table or something?
Re: [markr] Can I update a user's accessList with a mysql update query?
By Dave - November 21, 2010
I don't use phpMyAdmin much, but I did a quick search and it sounds like it's because we happened to use double underscores in that table name. See:
http://board.flashkit.com/board/showthread.php?t=790497
So it's a phpMyAdmin "feature" :)
Hope that helps!
interactivetools.com