Results 1 to 10 of 10

Thread: User's module controlling

  1. #1
    xfuture is offline Member
    Join Date
    Sep 2006
    Posts
    8

    Default User's module controlling

    I wish to know which DB tables are controlling user's permission ?
    is that acl_actions ?

  2. #2
    bands is offline Sugar Community Member
    Join Date
    Aug 2006
    Posts
    41

    Default Re: User's module controlling

    Hi

    yes ,

    acl_actions,acl_Roles,acl_roles_actions,acl_roles_ users

    Thanks
    BSK

  3. #3
    xfuture is offline Member
    Join Date
    Sep 2006
    Posts
    8

    Default Re: User's module controlling

    Thanks for the reply bands....

    but the ID column are encrypted in some way...
    do you mind telling me how's the encryption done ?

  4. #4
    cywolf's Avatar
    cywolf is offline Sugar Community Member
    Join Date
    Oct 2005
    Location
    Toronto, Canada
    Posts
    223

    Default Re: User's module controlling

    The IDs aren't encrypted, they're just long and alphanumeric.
    Andrew Whitehead
    The Long Reach Corporation
    http://infoathand.com

  5. #5
    xfuture is offline Member
    Join Date
    Sep 2006
    Posts
    8

    Default Re: User's module controlling

    How do we know how they change the actual alphabetic become those number ?
    and account password is using hash ? or encryption ?

    sorry.. a newbie here..

  6. #6
    cywolf's Avatar
    cywolf is offline Sugar Community Member
    Join Date
    Oct 2005
    Location
    Toronto, Canada
    Posts
    223

    Default Re: User's module controlling

    You can look at the method create_guid() in include/utils.php to see how the IDs are generated.

    The user password (user_hash column) is stored as an MD5 hash.
    Andrew Whitehead
    The Long Reach Corporation
    http://infoathand.com

  7. #7
    balajimani is offline Member
    Join Date
    Feb 2009
    Posts
    5

    Default Re: User's module controlling

    Quote Originally Posted by cywolf View Post
    You can look at the method create_guid() in include/utils.php to see how the IDs are generated.

    The user password (user_hash column) is stored as an MD5 hash.
    Hi,

    May i know what kind of encryption used in Encrypting the ID for each table and what basis the ID is
    generated....?

    Thanks and Regards,
    Balaji

  8. #8
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: User's module controlling

    Quote Originally Posted by balajimani View Post
    Hi,

    May i know what kind of encryption used in Encrypting the ID for each table and what basis the ID is
    generated....?

    Thanks and Regards,
    Balaji
    Hi balajiman

    As Andrew Whitehead specified before it is a MD5 encrypting algorithm.
    Take a look at the method create_guid() in the include/utils.php to know more about it or make a google search to understand its concepts.

    Cheers
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  9. #9
    balajimani is offline Member
    Join Date
    Feb 2009
    Posts
    5

    Default Re: User's module controlling

    Quote Originally Posted by andopes View Post
    Hi balajiman

    As Andrew Whitehead specified before it is a MD5 encrypting algorithm.
    Take a look at the method create_guid() in the include/utils.php to know more about it or make a google search to understand its concepts.

    Cheers

    Hi Andrew,

    Thanks for you information. May I know what encryption used in encrypting the IDs and what kind of data encrypted for IDs(either like 1, 2, 3 or combination of someother). Please help in this regards.

    Thanks and Regards,
    Balaji.M

  10. #10
    crmsiva's Avatar
    crmsiva is offline A Sugar Hero
    Join Date
    Jan 2009
    Location
    Chennai, India
    Posts
    1,130

    Default Re: User's module controlling

    The below is the code used for id generation. As told in the previous posts, there is no encrpytion involved in this.

    Code:
    function create_guid()
    {
    	$microTime = microtime();
    	list($a_dec, $a_sec) = explode(" ", $microTime);
    
    	$dec_hex = sprintf("%x", $a_dec* 1000000);
    	$sec_hex = sprintf("%x", $a_sec);
    
    	ensure_length($dec_hex, 5);
    	ensure_length($sec_hex, 6);
    
    	$guid = "";
    	$guid .= $dec_hex;
    	$guid .= create_guid_section(3);
    	$guid .= '-';
    	$guid .= create_guid_section(4);
    	$guid .= '-';
    	$guid .= create_guid_section(4);
    	$guid .= '-';
    	$guid .= create_guid_section(4);
    	$guid .= '-';
    	$guid .= $sec_hex;
    	$guid .= create_guid_section(6);
    
    	return $guid;
    
    }
    
    function create_guid_section($characters)
    {
    	$return = "";
    	for($i=0; $i<$characters; $i++)
    	{
    		$return .= sprintf("%x", mt_rand(0,15));
    	}
    	return $return;
    }
    
    function ensure_length(&$string, $length)
    {
    	$strlen = strlen($string);
    	if($strlen < $length)
    	{
    		$string = str_pad($string,$length,"0");
    	}
    	else if($strlen > $length)
    	{
    		$string = substr($string, 0, $length);
    	}
    }

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •