Forum Replies Created

Viewing 15 replies - 1 through 15 (of 19 total)
  • Thread Starter jpf

    (@jpf)

    correction, it does seem to be obeying the setting for “# Emails to process” but not Read state.

    Thread Starter jpf

    (@jpf)

    You are a godsend. I updated to your newest verson released last 24 and voila! .. cha-ching to your account .. thanks.

    Thread Starter jpf

    (@jpf)

    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

    Thread Starter jpf

    (@jpf)

    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

    Thread Starter jpf

    (@jpf)

    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

    Thread Starter jpf

    (@jpf)

    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. “

    Thread Starter jpf

    (@jpf)

    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 “[email protected]” ..

    Thanks,

    jpf

    Thread Starter jpf

    (@jpf)

    I noticed that perhaps my needs are related to https://www.ads-software.com/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.

    Thread Starter jpf

    (@jpf)

    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.

    Thread Starter jpf

    (@jpf)

    Thanks. Much appreciated that you would reach out to the rss author.

    Thread Starter jpf

    (@jpf)

    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("<A HREF=https://WPSITE.COM.ORG/PATH-TO-AUCTION/PAGE-FOR-AUCTION?ult_auc_id=",ibt.ID,">",ibt.Item,"</A>") 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("<A HREF=https://WPSITE.COM.ORG/PATH-TO-AUCTION/PAGE-FOR-AUCTION?ult_auc_id=",ID,">",Item,"</A>") 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("<A HREF=https://WPSITE.COM.ORG/PATH-TO-AUCTION/PAGE-FOR-AUCTION?ult_auc_id=",p.ID,">",p.post_title,"</A>") as Item ,b.name as Bidder,b.date as Date,concat("$",b.bid) as Bid FROM <code>YOUR-WP-DB_wdm_bidders</code> 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("<A HREF=https://WPSITE.COM.ORG/PATH-TO-AUCTION/PAGE-FOR-AUCTION?ult_auc_id=",ID,">",Item,"</A>") 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

    There is an HTTP header flag which will automatically make the page refersh on it’s own .. https://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

    Thread Starter jpf

    (@jpf)

    Oh nevermind on the Shortcode coding .. this works Fantastic!!!
    https://www.ads-software.com/plugins/elisqlreports/

    Thread Starter jpf

    (@jpf)

    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.

    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)