Photo Hash Field in bx_photos_main

Can someone please tell me how the photo's hash field is generated.  I have a thumbnail field in the property module and I need to inject photo's into the bx_photos_main table and the only part that is missing in that process is the photo hash what is it and how can it be duplicated or made to work with photo injections into the database..........what would be the way to produce that hash without the manual input and process of adding the picture through the module itself?  This has been an issue for me for 2 years I need to solve this....................

 

I am all ears on how to accomplish this task....................

Csampson
Quote · 24 Sep 2011

Anyone?

Csampson
Quote · 24 Sep 2011

The hash is created in dolphin using a md5 hash of the value returned by the microtime() function.

$hash = md5(microtime());

MySql has no microtime equivalant.

But this in a mysql query should work.

MD5(NOW()+MICROSECOND(NOW()))

The hash is just a MD5 hash of something. Can be anything, just needs to be unique.

https://www.deanbassett.com
Quote · 24 Sep 2011

Just for clarification in my mind that is merely an identifier that is called to pull that picture via that identifier.......

I think the light just went on....................I finally get if that is correct.............and the reason they do that is so you can't connect up from another site to those pictures via some photo naming plan........

 

Thanks Deano that is a major step forward......................      

Csampson
Quote · 24 Sep 2011

Basically yes.

I believe i have a more accurate mysql replacement for microtime. Should make sure the value is unique.

MD5(UNIX_TIMESTAMP(NOW())+MICROSECOND(NOW()))



https://www.deanbassett.com
Quote · 24 Sep 2011

 My Question is simple releated to Hash of the Mysql database , its fine that its generating automatically names for the images but I want to add some word before the file name starts I want to clear you more in the below text please read it and help me to find the solution for my issue , Just want to add some word in the starting of the file name thats it.

 

3c7f083e6de39e86a96373f6cc408fbf.jpg   <<<< OLD STYLE OF IMAGES NAME >>>>
 
xyz-3c7f083e6de39e86a96373f6cc408fbf.jpg  <<<< NEW  STYLE OF IMAGES NAME >>>> 

The hash is created in dolphin using a md5 hash of the value returned by the microtime() function.

$hash = md5(microtime());

MySql has no microtime equivalant.

But this in a mysql query should work.

MD5(NOW()+MICROSECOND(NOW()))

The hash is just a MD5 hash of something. Can be anything, just needs to be unique.

 

Quote · 8 Aug 2012
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.