I developed a custom "Blogsite" on MT 4.01 and subsequently upgraded to MT 4.1. I need to be able to access/update in real time Custom Fields that are stored in entry_meta via php/mySQL.
Prior to MT 4.1 I used Arvind's Custom Fields plugin and had the option of storing in entry_meta or a database table. Getting to the database table was a no brainer. Now, I do not have that option in MT 4.1 and I have attempted to improvise Arvind's tutorial at
http://blog.movalog.com/a/working-with-php-and-mt-plugindata/
to retrive/store entry_meta with no luck. MT Support suggests I post an inquiry here and on the Community Forum. It has been on the Community Forum for about three weeks with a lot of reads but no responses. It appears the php unserialize does not work either. Is there something special about how this data is serialized on MT via PERL?
Any help you can give will be appreciated. Or, just point me in the right direction.
Thanks in advance for your guidance. Merv
I don't think this is currently possible through PHP. I don't know the details of it myself, but I've seen the question come up multiple times, and the answer's always been, "No."
Thanks for the comment Su.
Actually, with a little off line pointing in the right direction by Mark Carey (Plugin developer extrodinair) I was able to acces the data. Here's a snipit of code that works in PHP:
This code worked perfectly:
// Include path to /mt/php/lib/MTSerialize.php on your server
include("{$SERVER["DOCUMENTROOT"]}/cgi-bin/mt/php/lib/MTSerialize.php");
// Initiate an instance of the MTSerialize object
$mt = new MTSerialize;
// your MySQL query to extract entrymeta from the mtentry table
// Serialized entry_meta to a variable such as $meta
$result = $mt->unserialize($meta);
$variable = $result['customfields']['yourcustomfield_name'];
Merv
Neat. That'll be handy to have around for future reference.