cptdondo

🙂 started down that road. It’s a pain… Neither plugin is simple….

So I hit on a simpler sol,ution – add one line to the ecg plugin:

function ecg_cat_join($query) {
global $table_prefix;
/****** new line ******/
if (strstr($query,’JOIN’)) { return $query ;}
$newquery = $query . ‘ LEFT JOIN ‘ . $table_prefix .
‘post2cat ON (‘ . $table_prefix . ‘posts.ID = ‘ .
$table_prefix . ‘post2cat.post_id) ‘;
return $newquery;
}

You also have to load the ecg plugin after the private categories plugin….

But it still seems to me that there should be a standard wp-join function to make sure the plugins create a valid SQL query…..

–Yan

OK, I get this:

WordPress database error: [Not unique table/alias: ‘wp_post2cat’]
SELECT COUNT(ID) FROM wp_posts /*index*/ LEFT JOIN wp_post2cat ON wp_posts.ID = wp_post2cat.post_id LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) WHERE 1=1 AND post_date_gmt <= ‘2005-08-15 15:50:59’ AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’) AND (category_id != 0 AND category_id != 1 AND category_id != 2 AND category_id != 4 AND category_id != 5

Apparently it doesn’t like something… Googling for this error reveals only one similar post for a different plugin, which alas doesn’t even activate on my system…..

I don’t know enough of WP’s innards to figure out what it is complaining about – the SQL query seems fine…

Yes, the post has to have some specific magic incantations to make it work… Only the two test posts have the correct href tags. 🙂

As for the next/prev buttons, that’s version 2. Seriously, if someone could provide some guidance as to how to parse the text of the post for specific text in a plugin I would be happy to attempt it. In fact, that’s high on my list as soon as I get this working.

AFAICT, the plugin would have to parse the text of the post for the img … tags and build the links. Not hard, but I am completely new to wordpress/php/javascript, so some hints would be good.

–Yan

Cool, thanks. I hope to have a hacked up version of the mailer up soon…. In the meantime, if anyone is interested in an image viewer/mailer, email me and I will send a tarball…. It’s definitely alpha code right now, but it works. Eventually, I hope to create a plugin….

Well, if anyone is interested, I’ve now written a script that pushes images to a server. The web server must accept the PUT method.

The script also previews, scales, rotates and creates thumbnails…

Post or email me if you want a copy. The script only runs under linux….

It’s not a mistake, it’s a feature. At least for me. 🙂

I’ll try to reverse-engineer (or translate) the Russian stuff. I have UTF-8 editors, so I’ll play with it. Thanks.