In my Insert Attachment All add-on located here:
I have a query that is searching the xf_attachment.content_type field for 'post'. This has worked perfectly for many forums. But today I ran across a situation where it's not working. Normally I always saw 'post' in this field, example:
But on the forum I'm troubleshooting I see this:
Notice the content_type has a hex value.
Can someone explain why this is, the two values tranlated are:
Has the XenForo Media Gallery changed the values to hex?
My main question is how do I set up a query to search for '706f7374' ?
This is my query:
// get posts $posts = $db->fetchAll(" SELECT DISTINCT(xf_post.post_id), xf_post.message FROM xf_post INNER JOIN xf_attachment ON xf_attachment.content_id = xf_post.post_id INNER JOIN xf_attachment_data ON xf_attachment_data.data_id = xf_attachment.data_id WHERE xf_attachment.content_type = ? AND xf_attachment_data.width > ? AND xf_post.message NOT LIKE CONCAT('%[ATTACH=full]', xf_attachment.attachment_id , '[/ATTACH]%') ORDER BY xf_post.post_id ASC LIMIT ? ", array('post', 0, $limit));