Title: jpf's Replies | WordPress.org --- # jpf [ ](https://wordpress.org/support/users/jpf/) * [Profile](https://wordpress.org/support/users/jpf/) * [Topics Started](https://wordpress.org/support/users/jpf/topics/) * [Replies Created](https://wordpress.org/support/users/jpf/replies/) * [Reviews Written](https://wordpress.org/support/users/jpf/reviews/) * [Topics Replied To](https://wordpress.org/support/users/jpf/replied-to/) * [Engagements](https://wordpress.org/support/users/jpf/engagements/) * [Favorites](https://wordpress.org/support/users/jpf/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 19 total) 1 [2](https://wordpress.org/support/users/jpf/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/jpf/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Postie] URGENT: Update ignoring MAIL READ/UNREAD state](https://wordpress.org/support/topic/urgent-update-ignoring-mail-readunread-state/) * Thread Starter [jpf](https://wordpress.org/support/users/jpf/) * (@jpf) * [10 years, 6 months ago](https://wordpress.org/support/topic/urgent-update-ignoring-mail-readunread-state/#post-6690645) * correction, it does seem to be obeying the setting for “# Emails to process” but not Read state. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Postie] problems with Constant Contact emails in recent versions](https://wordpress.org/support/topic/problems-with-constant-contact-emails-in-recent-versions/) * Thread Starter [jpf](https://wordpress.org/support/users/jpf/) * (@jpf) * [10 years, 7 months ago](https://wordpress.org/support/topic/problems-with-constant-contact-emails-in-recent-versions/#post-6602755) * You are a godsend. I updated to your newest verson released last 24 and voila!.. cha-ching to your account .. thanks. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Postie] problems with Constant Contact emails in recent versions](https://wordpress.org/support/topic/problems-with-constant-contact-emails-in-recent-versions/) * Thread Starter [jpf](https://wordpress.org/support/users/jpf/) * (@jpf) * [10 years, 7 months ago](https://wordpress.org/support/topic/problems-with-constant-contact-emails-in-recent-versions/#post-6602626) * I have a couple screenshots of my parsed test .. I’d rather not post them public, drop me a mail via my email. Thanks, * jpf * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Postie] problems with Constant Contact emails in recent versions](https://wordpress.org/support/topic/problems-with-constant-contact-emails-in-recent-versions/) * Thread Starter [jpf](https://wordpress.org/support/users/jpf/) * (@jpf) * [10 years, 7 months ago](https://wordpress.org/support/topic/problems-with-constant-contact-emails-in-recent-versions/#post-6602619) * A test is scheduled inbound to you in 3 minutes. My current-rev postie is on the same distribution so we can compare notes. The inbound mail to you will be coming direct from my personal email address. s**********1@**********1.org * Thanks, jpf * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Postie] Postie PHP Error after installing new plugins](https://wordpress.org/support/topic/postie-php-error-after-installing-new-plugins/) * Thread Starter [jpf](https://wordpress.org/support/users/jpf/) * (@jpf) * [10 years, 10 months ago](https://wordpress.org/support/topic/postie-php-error-after-installing-new-plugins/#post-6049849) * Simply `[Fri Jul 17 11:33:18 2015] [error] [client xx.xx.27.1] Postie: Checking for mail manually, referer:` or `[Fri Jul 17 11:37:03 2015] [error] [client xx. xx.27.1] Postie: Checking for mail manually with debug output, referer:` And nothing after that either in logs nor on screen .. just dies. * Postie Test-Config works just fine and properly. deactivation of Category RSS plugin causes Postie to work fine and properly. * thanks * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Postie] :end text not recognized if is within tags?](https://wordpress.org/support/topic/end-text-not-recognized-if-is-within-tags/) * Thread Starter [jpf](https://wordpress.org/support/users/jpf/) * (@jpf) * [10 years, 10 months ago](https://wordpress.org/support/topic/end-text-not-recognized-if-is-within-tags/#post-6338066) * thanks, Perhaps you can stick in the REGEX-REPLACE option with a big warning * **“for advanced users only .. that this may break your page, use with caution.“** * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Postie] :end text not recognized if is within tags?](https://wordpress.org/support/topic/end-text-not-recognized-if-is-within-tags/) * Thread Starter [jpf](https://wordpress.org/support/users/jpf/) * (@jpf) * [10 years, 10 months ago](https://wordpress.org/support/topic/end-text-not-recognized-if-is-within-tags/#post-6338061) * OK .. I’m so sorry .. Nevermind on the “bug” where it ignored text during the parse when within HTML markup .. I must have had too little sleep last night or something .. * HOWEVER, the ability to REGEX within “:end” string might be nice. REGEX-REPLACE would be even nicer, that would be the cherry on top! The user could REGEX a footer block from Constant Contact (or some other source, Mailchimp(?) ), and then simply REPLACE with “” and not break any HTML tables. * I will look into Postie Addon for this purpose now. Perhaps users could develop a “library” of delete this footer-type. The biggest problem with the footer is the SafeUnsubscribe button, the Forward this Email link, and the This mail was sent to “secret@postiesite.com” .. * Thanks, * jpf * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Postie] :end text not recognized if is within tags?](https://wordpress.org/support/topic/end-text-not-recognized-if-is-within-tags/) * Thread Starter [jpf](https://wordpress.org/support/users/jpf/) * (@jpf) * [10 years, 10 months ago](https://wordpress.org/support/topic/end-text-not-recognized-if-is-within-tags/#post-6338054) * I noticed that perhaps my needs are related to [https://wordpress.org/support/topic/signature-patterns-filtering?replies=7](https://wordpress.org/support/topic/signature-patterns-filtering?replies=7) * But in my case, it seems to be ignoring the text is it’s Linked Text within HTML Markup. I understand that I may break closing tables, but I can’t see how bad that problem is until I get this working. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Postie] Postie PHP Error after installing new plugins](https://wordpress.org/support/topic/postie-php-error-after-installing-new-plugins/) * Thread Starter [jpf](https://wordpress.org/support/users/jpf/) * (@jpf) * [10 years, 10 months ago](https://wordpress.org/support/topic/postie-php-error-after-installing-new-plugins/#post-6049847) * Wayne — * I wanted to update you on the Cat Specific RSS Menu plugin. Apparently the author may have in fact made a change .. but it’s for the worse I’m afraid. At this point, if that plugin is activated, and I click to run Postie (either regular or debug) it just freezes with NO ERROR. This is a problem I would assume. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Postie] Postie PHP Error after installing new plugins](https://wordpress.org/support/topic/postie-php-error-after-installing-new-plugins/) * Thread Starter [jpf](https://wordpress.org/support/users/jpf/) * (@jpf) * [11 years ago](https://wordpress.org/support/topic/postie-php-error-after-installing-new-plugins/#post-6049675) * Thanks. Much appreciated that you would reach out to the rss author. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Ultimate Wordpress Auction Plugin] Useful Ultimate Auction SQL Queries???](https://wordpress.org/support/topic/useful-ultimate-auction-sql-queries/) * Thread Starter [jpf](https://wordpress.org/support/users/jpf/) * (@jpf) * [12 years, 2 months ago](https://wordpress.org/support/topic/useful-ultimate-auction-sql-queries/#post-4706863) * I noticed a few errors in the ABOVE SQL (specifically, HIGHEST BIDDER LIST and RECENT BID LIST) .. I’ve also improved on them a bit for use with the ABOVE recommended plugin. See updated list of SQL below….. * ``` #list incremental values SELECT p.ID,p.post_title,m.meta_key,m.meta_value from YOUR-WP-DB_posts p, YOUR-WP-DB_postmeta m where p.ID = m.post_id and m.meta_key = "wdm_incremental_val" #list opening bid SELECT p.ID,p.post_title,m.meta_key,m.meta_value from YOUR-WP-DB_posts p, YOUR-WP-DB_postmeta m where p.ID = m.post_id and m.meta_key = "wdm_opening_bid" #list RESERVES SELECT p.ID,p.post_title,m.meta_key,m.meta_value from YOUR-WP-DB_posts p, YOUR-WP-DB_postmeta m where p.ID = m.post_id and m.meta_key = "wdm_lowest_bid" #list HIGHEST BIDS + USERS select CONCAT("",ibt.Item,"") as Item,b.name as Name, ibt.bid as Bid from (select p.ID as ID, p.post_title as Item, max(b.bid) as Bid from YOUR-WP-DB_posts p, YOUR-WP-DB_wdm_bidders b where p.ID = b.auction_id group by p.ID )as ibt, YOUR-WP-DB_wdm_bidders b where b.auction_id = ibt.ID and b.bid = ibt.bid order by b.bid desc #3 MOST ACTIVE auctions by bid_count select CONCAT("",Item,"") as Item, NumBids from (select p.ID as ID,p.post_title as Item,count(b.bid) as NumBids from YOUR-WP-DB_posts p, YOUR-WP-DB_wdm_bidders b where p.ID = b.auction_id group by p.ID order by NumBids desc) as bid_count LIMIT 3 #list 10 RECENT BIDS select CONCAT("",p.post_title,"") as Item ,b.name as Bidder,b.date as Date,concat("$",b.bid) as Bid FROM YOUR-WP-DB_wdm_bidders as b, YOUR-WP-DB_posts p where b.auction_id = p.ID order by b.date desc limit 5 #list END DATES DESCENDING SELECT p.ID,p.post_title,m.meta_key,m.meta_value from YOUR-WP-DB_posts p, YOUR-WP-DB_postmeta m where p.ID = m.post_id and m.meta_key = "wdm_listing_ends" order by m.meta_value desc limit 200 #BULK update listing END DATE for all LIVE auctions update YOUR-WP-DB_postmeta set meta_value = "2014-03-14 23:59:59" where meta_key = "wdm_listing_ends" and meta_value > NOW() #ENDING within 24 hours SELECT p.ID,p.post_title,m.meta_key,m.meta_value from YOUR-WP-DB_posts p, YOUR-WP-DB_postmeta m where p.ID = m.post_id and m.meta_key = "wdm_listing_ends" and m.meta_value < DATE_ADD(NOW(), INTERVAL 24 HOUR) and m.meta_value > NOW() order by m.meta_value desc limit 200 #currently LIVE Auctions CREATED in last 24hrs SELECT p.ID,p.post_title,p.post_date from YOUR-WP-DB_posts p,YOUR-WP-DB_postmeta m where p.ID = m.post_id and p.post_date > DATE_SUB(NOW(), INTERVAL 24 HOUR) and m.meta_key = "wdm_listing_ends" and m.meta_value > NOW() order by p.post_date desc limit 200 #currently LIVE Auctions MODIFIED in last 24hrs SELECT p.ID,p.post_title,p.post_modified from YOUR-WP-DB_posts p,YOUR-WP-DB_postmeta m where p.ID = m.post_id and p.post_modified > DATE_SUB(NOW(), INTERVAL 240 HOUR) and m.meta_key = "wdm_listing_ends" and m.meta_value > NOW() order by p.post_modified desc limit 200 #AUCTIONS WITH NO BIDS select Item, CONCAT("$",OpeningBid) as OpeningBid from (select CONCAT("",Item,"") as Item,m.meta_value*1 as OpeningBid from (select p.ID as ID ,p.post_title as Item, count(b.bid) as NumBids from YOUR-WP-DB_posts p INNER JOIN YOUR-WP-DB_postmeta m on p.ID = m.post_id LEFT OUTER JOIN YOUR-WP-DB_wdm_bidders b on p.ID = b.auction_id where m.meta_key = "wdm_listing_ends" and m.meta_value > NOW() group by p.ID,m.post_id) as no_bids ,YOUR-WP-DB_postmeta m where m.post_id = no_bids.ID and no_bids.NumBids = 0 and m.meta_key = "wdm_opening_bid" order by OpeningBid desc) as no_bid_price LIMIT 5 #Current Winning Bids Total Value select CONCAT("$",round(sum(Bid))) as CurrentBidValue, "$6500" as Target from (select ID, Item, User, Bid from (select p.ID as ID, p.post_title as Item,b.name as User ,max(b.bid) as Bid from YOUR-WP-DB_posts p, YOUR-WP-DB_wdm_bidders b where p.ID = b.auction_id group by p.ID order by p.ID asc, b.bid desc) as max_bid order by Bid desc) as bid_list ``` * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Ultimate Wordpress Auction Plugin] Auto Refresh](https://wordpress.org/support/topic/auto-refresh-2/) * [jpf](https://wordpress.org/support/users/jpf/) * (@jpf) * [12 years, 2 months ago](https://wordpress.org/support/topic/auto-refresh-2/#post-4707336) * There is an HTTP header flag which will automatically make the page refersh on it’s own .. [http://www.i18nguy.com/markup/metatags.html](http://www.i18nguy.com/markup/metatags.html).. that would have to be added somehow into your wordpress install and ONLY on the auction pages .. not sure if it’s even possible. Perhaps there’s an HTTP-META plugin for WP, that would be nice if you found one. * There are certainly HTML5/JS options that would allow persistent connections between machine and server that would allow changes to be reflected immediately across machines (think google docs), but it’s probably not high on a to do list as it’s quite complicated to put in place. * 1) Rest assured, it’s not YOUR site. 2) I’m not familiar with the PRO features but I would doubt it. 3) I would guess not at all implemented, but in theory it is possible with arduous efforts. * jpf * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Ultimate Wordpress Auction Plugin] Useful Ultimate Auction SQL Queries???](https://wordpress.org/support/topic/useful-ultimate-auction-sql-queries/) * Thread Starter [jpf](https://wordpress.org/support/users/jpf/) * (@jpf) * [12 years, 2 months ago](https://wordpress.org/support/topic/useful-ultimate-auction-sql-queries/#post-4706707) * Oh nevermind on the Shortcode coding .. this works Fantastic!!! [https://wordpress.org/plugins/elisqlreports/](https://wordpress.org/plugins/elisqlreports/) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Ultimate Wordpress Auction Plugin] Useful Ultimate Auction SQL Queries???](https://wordpress.org/support/topic/useful-ultimate-auction-sql-queries/) * Thread Starter [jpf](https://wordpress.org/support/users/jpf/) * (@jpf) * [12 years, 2 months ago](https://wordpress.org/support/topic/useful-ultimate-auction-sql-queries/#post-4706704) * BTW, I forgot to mention, I would love for someone to work with me to create shortcodes for most of these? I’m not very WP shortcode saavy..but I’m sure someone here else may be. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Ultimate Wordpress Auction Plugin] Auction page not loading](https://wordpress.org/support/topic/auction-page-not-loading/) * [jpf](https://wordpress.org/support/users/jpf/) * (@jpf) * [12 years, 2 months ago](https://wordpress.org/support/topic/auction-page-not-loading/#post-4705036) * Off-topic .. sorry can’t help with this one .. but where’d you get that Donation Progress (plugin?) on your right side of page. * I’ll be curious to learn the problem with your non-loading pages. Viewing 15 replies - 1 through 15 (of 19 total) 1 [2](https://wordpress.org/support/users/jpf/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/jpf/replies/page/2/?output_format=md)