The Joomla! Forum™

please review my previous post. There is no the field userid in the table jos_core_acl_aro (I made in bold in your code). Change to the appropriate field (as I said before). The query shouldn't work and I don't have Joomla! db structure here, but if you change it, it will work. I just figure the id...

gacon wrote:not yet successful. Anyone can help me?

Have you tried my query ? Please post the one you tried if it didn't work.

Something like this should work: UPDATE users, acl_map, aro SET users.type='Registered', users.gid=18, acl_map.gid=18 WHERE users.type='Author' AND[b] users.id=aro.userid[/b] AND aro.acl=acl_map.aro (from m) You have tried? There is no the field userid in the table jos_core_acl_aro (I made in bold ...

I think the simplest way to do it is to use the template trick. Suppose that you use SEF or some rewrites in .htaccess so that myfile.php executes index.php. Then edit your templates/xxxxxx/index.php: change mosMainBody() by this: if ($_SERVER['REQUEST_URI'] == '/myfile.php') include('myfile.php') e...

Something like this should work:



(from http://forum.joomla.org/index.php/topic,213582.0.html)