Terrence LP

Hello,

Great Plugin – Needs a Filter feature! Like Filter By (what ever we have in the columns)

But to answer the ‘USE DB’ what I was able to do was set up MySQL permissions so my WP User also has access to the other or External DB.

From there I just call the DB like so –

SELECT article.id, SUM(article_text.word_count) as total_words
FROM master_media.article

As long as that is specified it all works great!

I’m even using SUM, JOINS, GROUP BY and ORDER BY’s all in the same query and works great .

• This reply was modified 7 years ago by Terrence LP.

Rock on! Great Plugin great features.

And yes I’d pay for advance features and continued development. Great Job!

Terrence LP
Webmaster – Georgia Highlands College

I’m not aware of being able to do that as the Email Before Download is pretty limited. My solution is pretty specific in that I’m only in need of one ID. With conditions coming from the form, you will need a more custom approach or a different plugin altogether.

Try Exec-PHP plugin and via PHP and jQuery you can do it all in one page. Visually it can look the same but if any database update are needed, they will also have to be added.

These three plugins are OK, but a real Download/Forms/Email plugin needs to be created from the ground up.

if you need to verify the Download category ID as well – (wp prefix may be optional.)

<?php
global $wpdb;
$myrows = $wpdb->get_results(
“SELECT wp_download_monitor_files.*, wp_download_monitor_relationships.*
FROM wp_download_monitor_files, wp_download_monitor_relationships
WHERE wp_download_monitor_files.id = wp_download_monitor_relationships.download_id
ORDER BY wp_download_monitor_files.id DESC
LIMIT 1″
);
?>
[email-download download_id=”<?php echo $myrows[0]->download_id; ?>” contact_form_id=”3288″]

Here is what I did – hit the DB ~!

<?php
global $wpdb;
$myrows = $wpdb->get_results( “SELECT id FROM wp_download_monitor_files ORDER BY id DESC LIMIT 1” );
?>

[email-download download_id=”<?php echo $myrows[0]->id; ?>” contact_form_id=”3288″]

I just love the support this plugin gets… NOT!

I’m finishing up my TAX HACK and will post when Done.

I see the future of eShop moving to ShopWord, since this plugin get’s no real support. I’ve been using Ubercart to get ideas and some of this eShop is getting entirely rewritten thanks to Obama and my lack of a JOB.

FTW!