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: [markr] Can I update a user's accessList with a mysql update query?

By Dave - November 21, 2010

Hi markr,

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