database credentials from "config.php"

[shajiuddin]

Hi,

I want to use database credentials from "config.php" on my "logic hooks" file for database connectivity.
Regards

[Angel]

You don't need to create a separate connection to query the database via a logic hook.

Give this example a look:

http://cheleguanaco.blogspot.com/200...k-example.html

[shajiuddin]

Hi Angel,

Yes you are right but see we define these lines in logic hooks file

$hook_version = 1;
$hook_array = Array();
$hook_array['before_save'][] = Array(1, 'assignUser', 'custom/modules/Cases/autoUserAssignment.php', 'UserAssignment', 'updateCase');

We don't need to configure database connection in our "logic_hooks.php" because there's no database activity is involve.

But, In "autoUserAssignment.php" we should have to configure database connection just because of database activity is involve.

Now, what you say about it?
How can we configure database connection from (config.php database credentials) in "autoUserAssignment.php" ?

[care]

 require_once pathtoconfig.php
include_once pathtoconfig_override.php
 
$sql_connection = mysql_connect($sugar_config['dbconfig']['db_host_name'], $sugar_config['dbconfig']['db_user_name'], $sugar_config['dbconfig']['db_password']);
$sql_db = mysql_select_db($sugar_config['dbconfig']['db_name']); 
  

That should work