The Joomla! Forum™

Hello all, I would like to insert automatic some text into content table of DB of Joomla. Could you please tell me is this code is good? Do i should modify other things? Thanks, $created_by = 65; $datum=date("Y-m-d"); $publishdate = $datum; $publishdate_readable =  $datum; @mysql_query(" INSERT...

Thanks so much  It's well done with this command. This will sync your jos_core_acl_groups_aro_map with jos_users UPDATE jos_core_acl_groups_aro_map AS a JOIN jos_core_acl_aro AS b ON a.aro_id = b.aro_id JOIN jos_users AS c ON b.value = c.id SET a.group_id = c.gid

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).

Hello all, I have 2 sites (Joomla) on the same host: alo.ynghia.com (A) and video.ynghia.com (B). I would like to: - When users register into site A, he will be added automatically into site B - And when users register into site B, he will be added automatically into site A Which file i should modif...

not yet successful. Anyone can help me?

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 ...

This is the content of jos_core_acl_groups_aro_map





Note: I have removed the CB component


Thanks for your help!

I have used this command: UPDATE jos_users SET gid=18, usertype='Registered' WHERE id > 63; When i check in the PhpMyAdmin window: http://img260.imageshack.us/img260/9347/user1du0.jpg But when i use User Manage of Joomla, nothing change: http://img260.imageshack.us/img260/699/user2po9.jpg thanks for...

Hello all,

I would like to change the permission of all users on my site from author to registered, which table and field I should modify?

I'm using CB component.

Thanks,