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

I need to update a user's accessList with a mysql update query.

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

Hi Markr,

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.
Dave Edis - Senior Developer
interactivetools.com
Attachments:

usersignup_001.php 5K

Re: [Dave] Can I update a user's accessList with a mysql update query?

By markr - November 21, 2010

This is perfect...will work nicely. Thanks.

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?