Where is the new user saved ?

[dskanth]

Hello, iam new to sugar crm, and iam pretty curious to know where is the user profile saved ?
My actual requirement is that: i have to write a trigger to save the user details in another external table, when the user profile is edited in Sugar.
I dont see where the user profile is saved to the database (in which file).

Can you please tell, which file needs to be modified, and where can i write custom query ?
Also, can i use triggers for insert / update in the user table of Sugar ?

Please guide me. Its very urgent.

[andopes]

The main user information are saved into users table.
Some user preferences, like date format, time zone, are saved into user_preferences table.
You may create a logic_hook before_save into Users module to save the uses info into another table/database.

Cheers

[dskanth]

Hi Andopes, thanks a lot for your reply !
Can you please tell me in which file do i need to write the code (logic hook) for saving the user info in the external database table, and any code snippet of the logic hook for this?
I would be grateful to you.

[andopes]

Have a look on editLogicHook project.

Cheers

[dskanth]

Hai Andopes, i have installed the EditLogichooks module, but could not see it in the Admin > Studio.
How can i proceed, am i missing something ?

[andopes]

Use the RTFM method.

Cheers

[dskanth]

Hai, i dont understand what is RTFM method.
I have found out the Logic Hooks and now i have written this code inside my new logichook, for Users module.

<?php
class Users_logichook_class
{
function Users_logichook_method(&$bean, $event, $arguments=null)
{
if ($event != 'before_save') return;
// Insert your custom logic between these comments

$conn=mysql_connect("localhost","root","root");
mysql_select_db("scheduler");
$sql="insert into patients values (null,'a','a','a','a',22,'a','a','a','','',null)";
$res=mysql_query($sql);
$row=mysql_fetch_row($res);
echo 'First name: '.$row[1];
mysql_close($conn);

// Insert your custom logic between these comments
}
}
?>

Iam running Sugar CRM in my localhost, and now when i update a user in Sugar, i need to edit / insert the user details in a table (custom) of another database in my localhost.
But when i edited the user and saved in the Sugar, the values are not getting inserted in the external table. Whats wrong ?
What can i do to get this working ?
Please suggest me the logic for logic hooks.
Thank you.

[nagarajkonaguthi@gmail.com]

Use the RTFM method.

Cheers

Hi Andopes,

Please guide me in installing editlogichook module and writing the logic hook to connect to the external databae and displaying the the data from it in sugarcrm custom module.

And what is RTFM method.

Thanks in advance

--Nagaraj S Koanguthi