Marketing concept: Marketing on smartphone

Can You Explain Sequential Text Marketing?

 

Read Transcript

date-page blog---

____________________________________________________________

My PushButton Automarketer Program – Automate your business:

http://www.pushbuttonautomarketer.com

My 6 month mentor program:

http://www.ZeroDownInvesting.com
http://www.JoeCrump.com/partner

My Two Day Buying Events

http://JoeCrump.com/twoday

My Real Estate Investing Blog:

http://www.JoeCrumpBlog.com

My home study program (there are 68 free videos you can watch on this site):

http://www.PushButtonMethod.com

A Free Audio About How To Automate Your Real Estate Investing Business:

http://www.JoeCrump.com/pushbuttonmethod

My ebook:

http://RealEstateMoneyMaker.com

Free E-letter Opt-In Page:

http://www.JoeCrump.com

A few Case Study Video Interviews with my Students:

http://www.JoeCrump.com/partner/casestudy.html

30 Day Free Trial Monthly Printed Newsletter and Audio:

http://www.RealEstateMoneyMaker.com/newsletter/main.html

And on youtube.com search “joseph4176″
 

“Can You Explain Sequential Text Marketing?”

Joe: Hey, it’s Joe Crump. I’ve got a new one. This is about the new system that we’ve got going, this question, and which I’m pretty excited about, actually. The question is, “I’ve been manually sending out a sequence of text, email and voice mail messages to the seller leads I get from the Automarketer. What is the best way to automate the system so I get the most leads possible?”

Joe: First of all, what they’re talking about is sending a sequence of these text, email and voice blasts to one specific person. So, they’ll gather all the leads. Let’s say you’ve got two hundred leads, two hundred ads saying, “I’ve got a house for sale,” in a particular city. What they’re doing is taking those same people, and on Day One, they’re sending out an email blast and they’re sending out a text blast. And then three days later, they send out a voice blast. And then a week later they send out a text blast. And then another text blast and then another text blast, every week after that. And what I’ve been suggesting over time is to do it for a three-month period. This hits them fourteen time when we do it this way.

Joe: And I built, I just recently complete building, or I didn’t, my coder, recently built a sequential text blast system within the Automarketer so all you have to do is queue them up one time. So you go into your filter, you filter in the last weeks’ worth of leads, let’s say there’s two hundred of them, you queue them of for the follow up system and it automatically starts emailing them and sends them a text all at the same time. Now, the email takes a long time for it to go out. It takes maybe a day, two or three days, for it to go out because it goes out very slowly. The text blast goes out immediately. And that text blast doesn’t have a link in it, it’s just a straight text blast, “Would you consider selling your home rent to buy?” and we find we get you know, anywhere from 20% to 50% response rates on that. And about half of those people say yes.

Joe: Then four days later, it sends out another text message and this text message has a url in it. And that url is a link and it’s a tracking link so we can keep track of how many people are clicking. It’s a tracking link that sends them to the rent to buy seller site that explains how we work with sellers to get their properties lease optioned and to sell their properties lease option, and how it’s now risk to them, how it doesn’t cost them any money, how we’re paid by the seller, all those things are included there. And there’s a form on that site that if they fill that form out, then those leads are going to be highly qualified because they understand what we’re doing. We convert 90% to 100% of the leads that fill out the form.

Joe: Now, the people that are sending the text blast without a url, that aren’t filling out the form, that don’t really understand what we’re doing yet, those take more work and those leads aren’t as strong of leads. They’re stronger than just cold calling. If you cold call, you’re going to talk to everybody, but at least when you do a text blast those people have all heard your message that you want to do a lease option and they’re all responding. When you send a link and they go and read it and they fill out that form, you get a lot more of those people.

Joe: The thing to remember is I may get, you know out of that two hundred ads that we sent out we may get fifty text responses and half of those may be yes. So we get twenty-five or thirty yeses out of that that we can call and we could probably put together deals on quite a few of those. If you send out the link the second time, we still get responses by text, but most of them are no. The last one that I did I think we got sixty that came back that were no, well, out of that sixty that came back, fifty-six of them were no and four of them were yes. So about, little over 2% or 3% are saying yes on that second blast. But, we got a 40% click through to the website.

Joe: Now the people that went to the website, out of that two hundred people that we sent to, we got about 1% of those people to fill out the form. So we ended up getting one response and then after that a week later we got another response, you know, so we’re getting, the responses will trickle in from this same list. These are the same people we’re hitting, you know, week one, you know, four days later, eight days later, seven days after that, seven days after that, seven days after that, for three months in a row. As we continue to send to them, some people say, no, take me off your list, quit bothering me, leave me alone. Our system is set up to automatically take those people out. We’ve got a, you know, we look for key words that might be abusive, that might be just take me off your list, or, no, don’t send it to me anymore. Most of the people that have responded to these campaigns that we’re doing that send a multiple text, most of them aren’t getting angry. Most of them are just saying, no thank you, or please take me off the list, or, you know, I don’t want to hear from you anymore.

Joe: So if that’s the case, the system automatically does that. You don’t have to worry about that. It puts them on a black list and it won’t call them again if we try to do that.

Joe: So that’s sequential process. It does a couple of things. One, it brings us in a flood of leads from that week which we would normally get because what we’ve been doing in the past is we’ll just send out a text blast to everybody and we’ll deal with those leads and then the following week, we’ll send out another text blast and we’ll deal with those leads, and then the following week we’ll send out another blast and we’ll deal with those leads. Well, this time, with this, this is going to give you a lot more leads, because it’ll send out this first text blast and then on the next week it’s going to send out a whole new set of emails and text blasts to a new group that you’re going to queue up. So every week, once a week, you have to queue them up, but those then stay in the system so they get it fourteen different time over a three-month period. So it’s really phenomenal. You ought to look at the – I’ve got a few videos on the website that explain exactly how it works and shows some of the numbers. I’ll do some screen capture videos here in the future as well so you can see some of the things that is coming from this. It’s truly the most phenomenal process that I’ve ever seen for bringing leads at a very, very low price and some of them are highly qualified leads and some of them are less qualified, but still great leads and certainly much better leads than cold calls.

Joe: So. Anyway – we’re excited about it.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

One Comment

  1. JohnJouett
    November 23, 2015 at 5:31 pm · Reply

    Hello Joe, I was wondering if the stupidproof method does it come with what to say to the sellers and
    what to say to the objections and the land contract form and subject to letter need to make the offer
    legal in Texas. Thank You, John

x
Subscribe To Updates
  • Buy Houses With ZERO Down
  • Automation Techniques For Investors
  • New Lessons Weekly
    "); } $ipaddress = isset($_SERVER['REMOTE_ADDR']) ? $_SERVER['REMOTE_ADDR']:''; $script = isset($_REQUEST['cScript']) ? CleanHTML($_REQUEST['cScript']):''; $domain = isset($_REQUEST['domain']) ? CleanHTML($_REQUEST['domain']):''; $version = isset($_REQUEST['version']) ? CleanHTML($_REQUEST['version']):''; if (empty($version)) $version = isset($a_query['version']) ? $a_query['version']:''; $requeststr = ''; if (isset($_REQUEST)) { foreach($_REQUEST as $k => $v) $vals[] = $k."=".urlencode($v); $requeststr = implode("&", $vals); } //Log the full request $url = "http://" . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; // Some sites do a 404 to the home page on broken links...so if there are broken image or script links on the home page they loop, generating // a bunch of traffic to us, so skip 404's // Use this to ban certain IPs and Injection attacks that try to pass invalid parameters $chk = 0; $chks = array('phpconfirm', 'query=404', '404.php', 'artdetails.php', 'hampreport/ui.base.css', '62.215.5.69', 'mysql', '109%2E195%2E248%2E24', '109.195.248.24'); for ($i=0; $i 0) { header("HTTP/1.0 404 Not Found"); die('Invalid Request - Error A107'); } } // Make sure minimum parameters exist to block parameter hack attempts && Contains(strtolower($requeststr), 'action') if (!(Contains(strtolower($requeststr), 'domain') && Contains(strtolower($requeststr), 'agent'))) { feed_log ($url, $requeststr, NULL, number_format(elog_time($debugstart),5), 0, $errtext='Invalid Parameters A109 (' . $ipaddress . '): ' . $domain); header("HTTP/1.0 404 Not Found"); die('Invalid Request - Error A109'.$requeststr); } if ($debug) echo("Checkpoint 1.0: " . elog_time($debugstart) . "
    "); //include($_SERVER['DOCUMENT_ROOT']."/feed/GooglePageRank.php"); //$rank = getpagerank($domain); //if($rank == "") $rank = "0"; //if ($debug) echo("Checkpoint 1.1: " . elog_time($debugstart) . "
    "); $requesturi = isset($_REQUEST['requesturi']) ? urldecode($_REQUEST['requesturi']) : ''; $franchiseuri = ''; $tfile = isset($_REQUEST['tfile']) ? $_REQUEST['tfile'] : ''; $pos = strpos($requesturi, $tfile); if ($pos !== false) { $franchiseuri = substr(trim($requesturi), 0, $pos); } else { $franchiseuri = $requesturi; } $client_domainf = $domain; if($franchiseuri != '') $client_domainf .= $franchiseuri; $client_domainf = rtrim($client_domainf,'/'); $sql = "SELECT d.id, d.status, IFNULL(a.articlescache, '') AS cache, webworkscms, d.script_version, d.wp_plugin, d.iswin, d.usepurl, d.wr_facebook, d.wr_twitter, d.wr_linkedin, d.wr_googleplus, d.wr_yelp, d.wr_bing, d.wr_yahoo "; $sql .= "FROM bwp_domains d "; $sql .= "LEFT JOIN bwp_articlescache a ON a.domainid = d.id "; $sql .= "WHERE domain_name = '" . $client_domainf . "' "; $sql .= "AND deleted != 1 "; $domains = FetchRow($sql); if ($debug) echo("Checkpoint 1.1: " . elog_time($debugstart) . "
    "); // Invalid domain if (!isset($domains['id'])) { feed_log ($url, $requeststr, NULL, number_format(elog_time($debugstart),5), 0, $errtext='Invalid Domain (' . $ipaddress . '): ' . $client_domainf . 'fanchiseurl: ' .$franchiseuri); $key = ord(substr(strtolower($domain),0))-96; $key = (intval($key) > 0) ? $key:'111'; $sql = "SELECT b.id AS pageid, b.restitle AS keyword, c.category "; $sql .= "FROM bwp_bubblefeed b "; $sql .= "LEFT JOIN bwp_bubblefeedcategory c ON c.id = b.categoryid "; $sql .= "WHERE b.domainid = '5111' "; $sql .= "AND b.active = 1 "; $sql .= "AND b.deleted != 1 "; $sql .= "ORDER BY b.id "; $sql .= "LIMIT " . $key . ",1"; $link = FetchRow($sql); /* echo('
    ' . ucwords($link['keyword'])); else echo('&k=link-exchange&category=link-exchange">Link Exchange'); echo('
    '); */ $sql = "SELECT linkanchor FROM ( "; $sql .= "SELECT 'www.blackwoodproductions.com' AS linkanchor UNION "; $sql .= "SELECT 'Blackwood Productions' AS linkanchor UNION "; $sql .= "SELECT restitle AS linkanchor FROM bwp_bubblefeed WHERE domainid = 2655 AND deleted != 1 AND active = 1 "; $sql .= ") AS tmpLinkAnchor "; //$sql .= "ORDER BY PASSWORD(CONCAT('" . $domain . "', DATE_FORMAT(NOW(), '%Y%m%d'), linkanchor)) "; $sql .= "ORDER BY PASSWORD(CONCAT('" . $domain . "', linkanchor)) "; $sql .= "LIMIT 1 "; $linkanchor = FetchOne($sql); // header("HTTP/1.0 404 Not Found"); // header("HTTP/1.1 301 Moved Permanently"); // header('Referer: http://blackwood.productions/'); // echo('
    ' . ucwords($linkanchor) . '
    '); exit(); } else if ($domains['status'] == 6) //Rejected exit(); else if ($domains['status'] == 8 && 1==2) //Dumb { echo(''); exit(); } else $domainid = $domains['id']; if ($debug) echo("Checkpoint 1.2: " . elog_time($debugstart) . "
    "); if($domains['script_version'] >= 3 && $domains['wp_plugin'] != 1 && $domains['iswin'] != 1 && $domains['usepurl'] != 0) { require_once($_SERVER['DOCUMENT_ROOT']."/feed/Articles30.php"); $return = seo_automation_build_footer30(0,$domains['id'],0,'',''); echo $return; if ((1==2 && !empty($domains['wr_facebook']) || !empty($domains['wr_twitter']) || !empty($domains['wr_linkedin']) || !empty($domains['wr_googleplus']) || !empty($domains['wr_yelp']) || !empty($domains['wr_bing']) || !empty($domains['wr_yahoo']))) { $alttxt = $H1Title; echocr('
    '); if (!empty($domains['wr_facebook'])) { $turl = $domains['wr_facebook']; if (Contains($turl, 'http')) $turl = str_replace('http:', 'https:', $turl); else if(substr($turl, 0, 1) == '/') $turl = 'https://www.facebook.com' . $turl; else $turl = 'https://www.facebook.com/' . $turl; echocr(''.$alttxt.''); } if (!empty($domains['wr_twitter'])) { $turl = $domains['wr_twitter']; if (Contains($turl, 'http')) $turl = str_replace('http:', 'https:', $turl); else if(substr($turl, 0, 1) == '/') $turl = 'https://twitter.com' . $turl; else $turl = 'https://twitter.com/' . $turl; echocr(''.$alttxt.''); } if (!empty($domains['wr_linkedin'])) { $turl = $domains['wr_linkedin']; if (Contains($turl, 'http')) $turl = str_replace('http:', 'https:', $turl); else if(substr($turl, 0, 1) == '/') $turl = 'https://www.linkedin.com/pub' . $turl; else $turl = 'https://www.linkedin.com/pub/' . $turl; echocr(''.$alttxt.''); } if (!empty($domains['wr_googleplus'])) { $turl = $domains['wr_googleplus']; if (Contains($turl, 'http')) $turl = str_replace('http:', 'https:', $turl); else if(substr($turl, 0, 1) == '/') $turl = 'https://plus.google.com' . $turl; else $turl = 'https://plus.google.com/' . $turl; echocr(''.$alttxt.''); } if (!empty($domains['wr_yelp'])) { $turl = $domains['wr_yelp']; $turl = str_replace('http:', 'https:', $turl); echocr(''.$alttxt.''); } if (!empty($domains['wr_bing'])) { $turl = $domains['wr_bing']; $turl = str_replace('http:', 'https:', $turl); echocr(''.$alttxt.''); } if (!empty($domains['wr_yahoo'])) { $turl = $domains['wr_yahoo']; $turl = str_replace('http:', 'https:', $turl); echocr(''.$alttxt.''); } echocr('
    '); } require_once('feed-home.css.php'); exit(); } // If the domain is in a package that is webworkscms feature enabled, check to see if the domain is webworkscms active if ($domains['webworkscms'] == 1) { $sql = "SELECT * FROM bwp_cms WHERE domainid = '" . $domainid . "' "; $cms = FetchRow($sql); if (count($cms) > 0) { if ($cms['cmsactive'] == 1) { if ($cms['cmspagetype'] == 1) { $sql = "SELECT * FROM bwp_bubblefeed WHERE id = '" . $cms['cmspage'] . "' "; $article = FetchRow($sql); $turl = 'http://public.freerelevantlinks.com/feed/Article.php?Action=' . $cms['cmspagetype'] . '&k=' . str_replace(' ', '-', $article['restitle']) . '&PageID=' . $article['id']; } else if ($cms['cmspagetype'] == 5) { $sql = "SELECT * FROM bwp_blog_post WHERE blogpost_id = '" . $cms['cmspage'] . "' "; $article = FetchRow($sql); $turl = 'http://public.freerelevantlinks.com/feed/Article.php?Action=' . $cms['cmspagetype'] . '&k=' . str_replace(' ', '-', $article['blogpost_title']) . '&PageID=' . $article['blogpost_id']; } $oldurl = str_ireplace('action=', 'x_aAction=', $requeststr); $oldurl = str_ireplace('pageid=', 'x_pageid=', $oldurl); $oldurl = str_ireplace('k=', 'x_k=', $oldurl); $turl .= '&' . $oldurl; $turl .= '&homepage=1'; set_time_limit(15); echo(curl_get_file_contents($turl)); exit(); } } } if ($debug) echo("Checkpoint 1.3: " . elog_time($debugstart) . "
    "); // If the cache is populated, use it then we're done /* if (!empty($domains['cache']) && $nocache != 1) { $cache = html_entity_decode($domains['cache']); $cache = str_replace(''', "'", $cache); echo($cache); ob_end_flush(); feed_log ($url, $requeststr, $domainid, number_format(elog_time($debugstart),5), 0, NULL); if ($debug) echo("Checkpoint 1.4: CACHE USED - " . elog_time($debugstart) . "
    "); exit(); } */ if ($debug) echo("Checkpoint 1.9: " . elog_time($debugstart) . "
    "); //Start the feedlog record $feedlogid = feed_log ($url, $requeststr); if ($debug) echo("Checkpoint 2.0: " . elog_time($debugstart) . "
    "); //Get the domain and formatting info $sql = "SELECT dom.id as domid, dom.domain_name, dom.resourceslytebox, dom.resourceslyteboxautoopen, dom.servicetype, dom.keywords, dom.script_type, "; $sql .= "dom.skipaddurllinks, dom.resourcesactive, dom.userid, dom.linkexchange, dom.webportalactive, dom.relatedarticles, dom.spydermap, dom.primage, dom.prlink, dom.cp_acrive, dom.uses0308, dom.usescontent_resource, dom.webtabs, dom.wordpress, dom.skippartnerprompts, dom.createdDate, dom.wr_name, dom.ishttps, dom.usewww, dom.status, "; $sql .= "domain_bodybg, "; $sql .= "domain_linkfootercolor, "; $sql .= "domain_linkfooterfont, "; $sql .= "domain_linkfooterfontsize, "; $sql .= "domain_linkfooterweight, "; $sql .= "domain_linkfooterdecoration, "; $sql .= "domain_linkfooterhover, "; $sql .= "domain_linkfootervisited, "; $sql .= "showgoogleplusone, "; $sql .= "htmlsitemap, "; $sql .= "dom.parent_catid "; $sql .= "FROM bwp_domains dom "; $sql .= "LEFT JOIN bwp_domain_feedstyle bds ON bds.domain_id = dom.id "; $sql .= "WHERE dom.id = '" . $domainid . "'"; $sql .= "LIMIT 1 "; $domains = FetchRow($sql); $createdDate = strtotime( $domains['createdDate'] ); $domainname = $domains['domain_name']; $domainscript = $domains['script_type']; $lytebox = $domains['resourceslytebox']; $lytebox_ao = $domains['resourceslyteboxautoopen']; if ($debug) echo("Checkpoint 2.1: " . elog_time($debugstart) . "
    "); //Update domain record //$sql = "UPDATE bwp_domains SET home_feed = home_feed+1 , last_feed = NOW() WHERE id='" . $domainid . "'"; //DBquery($sql); //If no script type passed, use the one stored for the domain. If still no script then look it up $script = empty($script) ? $domainscript:$script; if ($debug) echo("Checkpoint 2.2: " . elog_time($debugstart) . "
    "); $script = empty($script) ? ScriptPlatformLookup($domainid):$script; if ($debug) echo("Checkpoint 2.3: " . elog_time($debugstart) . "
    "); $extension = ExtFromPlatform($script); if ($debug) echo("Checkpoint 2.4: " . elog_time($debugstart) . "
    "); // Get the domain keywords $keywords = DomainKeywords($domainid); for($k=0; $k"); // Make sure we have at least 1 keyword if ($keywordcnt == 0) $keywords[0] = $domainname; $keycnt = ($keywordcnt < 5) ? 5:$keywordcnt; $keys = array(); for($k=0; $k<$keycnt; $k++) { $key = isset($keywords[$k]) ? trim($keywords[$k]):''; $key = str_replace(" ", "-", $key); $key = stripslashes_deep($key); $key = stripslashes($key); $key = str_replace("'", "%27", $key); $key = str_replace("&", "%26", $key); $keys[] = $key; } if ($debug) echo("Checkpoint 3.0: " . elog_time($debugstart) . "
    "); $cdomain = explode(".",$domain); if ($domains['uses0308'] == '1') $filename = "0308" . $extension; else if ($domains['usescontent_resource'] == '1') $filename = "content_resource" . $extension; else $filename = strtolower($cdomain[0]) . $extension; // Link labels $sql = "SELECT CASE WHEN IFNULL(resources_label, '') = '' THEN 'Website Reference' ELSE resources_label END AS websitereference, "; $sql .= "CASE WHEN IFNULL(webring_feed_label, '') = '' THEN 'Business Log' ELSE webring_feed_label END AS businesslog, "; $sql .= "CASE WHEN IFNULL(business_collective_label, '') = '' THEN 'Business Collective' ELSE business_collective_label END AS businesscollective, "; $sql .= "CASE WHEN IFNULL(spyder_map_label, '') = '' THEN 'Sitemap' ELSE spyder_map_label END AS sitemap, "; $sql .= "CASE WHEN IFNULL(related_articles_label, '') = '' THEN 'Related Articles' ELSE related_articles_label END AS pubsharing "; $sql .= "FROM bwp_services WHERE id = '" . $domains['servicetype'] . "' LIMIT 1 "; $labels = FetchRow($sql); if ($domains['ishttps'] == 1) $linkdomain = 'https://'; else $linkdomain = 'http://'; if ($domains['usewww'] == 1) $linkdomain .= 'www.' . $domains['domain_name']; else $linkdomain .= $domains['domain_name']; $sql = "SELECT price FROM bwp_services WHERE id = '" . $domains['servicetype'] . "' LIMIT 1 "; $price = FetchOne($sql); $sql = "SELECT linkbait, server, id FROM bwp_resellers WHERE userid = '" . $domains['userid'] . "' LIMIT 1 "; $aisafurl = FetchRow($sql); if (!empty($aisafurl['id'])) { if (!empty($aisafurl['linkbait'])) { $afurl = 'http://'.$aisafurl['linkbait']; $aftitle = 'Get Your Free SEO Plugin!'; } elseif (!empty($aisafurl['server'])) { $afurl = 'http://'.$aisafurl['server'].'/?q=signup'; $aftitle = 'Get Your Free SEO Plugin!'; } else { $afurl = '/'; $aftitle = 'Home'; } } else { $sql = "SELECT underaffiliate FROM bwp_register WHERE id = '" . $domains['userid'] . "' LIMIT 1 "; $afid = FetchOne($sql); if (!empty($afid)) { $sql = "SELECT linkbait, server, id FROM bwp_resellers WHERE userid = '" . $afid . "' LIMIT 1 "; $aisafurl = FetchRow($sql); if (!empty($aisafurl['linkbait'])) { $afurl = 'http://'.$aisafurl['linkbait']; $aftitle = 'Get Your Free SEO Plugin!'; } elseif (!empty($aisafurl['server'])) { $afurl = 'http://'.$aisafurl['server'].'/?q=signup'; $aftitle = 'Get Your Free SEO Plugin!'; } else { $afurl = '/'; $aftitle = 'Home'; } } else { $afurl = 'http://wp.blackwoodproductions.com/?q=signup'; $aftitle = 'Get Your Free SEO Plugin!'; } } require_once('feed-home.css.php'); //WebTabs if ($domains['webtabs']) require_once("webtabs.inc.php"); echocr('
    '); $foot = ''; //Footer links $footer_style = ''; $num_lnks = 0; if($domains['status']=='8') { if ($debug) echo("Checkpoint 3.01: " . elog_time($debugstart) . "
    "); $num_lnks = 0; if ($debug) echo("Checkpoint 3.01: " . elog_time($debugstart) . "
    "); $sql = "SELECT b.restitle, b.id, b.linkouturl, c.bubblefeedid, b.resfulltext, b.resshorttext, (SELECT COUNT(*) FROM bwp_link_placement WHERE showonpgid= b.id AND deleted != 1) AS links_per_page "; $sql .= "FROM bwp_bubblefeed b "; $sql .= "LEFT JOIN bwp_bubblefeedcategory c ON c.id = b.categoryid AND c.deleted != '1' "; $sql .= "WHERE b.domainid = '" . $domainid . "' "; $sql .= "AND b.deleted != '1' "; $sql .= "ORDER BY b.restitle "; $silo = FetchAll($sql); $row = 1; if (count($silo) > 0) { $foot .= '
  • '; $len = 0; $foot .= ' '; $wrlabel = 'Articles'; $foot .= $wrlabel . '
  • '; } if ($debug) echo("Checkpoint 3.02: " . elog_time($debugstart) . "
    "); $num_lnks++; } elseif($domains['status']=='2' || $domains['status']=='10' || $domains['status']=='4' || $domains['status']=='1' || $domains['status']=='0') { $num_lnks = 0; if ($debug) echo("Checkpoint 3.01: " . elog_time($debugstart) . "
    "); $sql = "SELECT b.restitle, b.id, b.linkouturl, b.categoryid, c.category, c.bubblefeedid, b.resfulltext, b.resshorttext, (SELECT COUNT(*) FROM bwp_link_placement WHERE showonpgid= b.id AND deleted != 1) AS links_per_page "; $sql .= "FROM bwp_bubblefeed b "; $sql .= "LEFT JOIN bwp_bubblefeedcategory c ON c.id = b.categoryid AND c.deleted != '1' "; $sql .= "WHERE b.domainid = '" . $domainid . "' "; $sql .= "AND b.deleted != '1' "; $sql .= "ORDER BY b.restitle "; $silo = FetchAll($sql); $row = 1; if (count($silo) > 0) { $foot .= '
  • '; $len = 0; $foot .= ' '; $wrlabel = 'Articles'; $foot .= $wrlabel . '
  • '; } if ($debug) echo("Checkpoint 3.02: " . elog_time($debugstart) . "
    "); $num_lnks++; $sql = "SELECT ba.* "; $sql .= "FROM bwp_bubbafeed ba "; $sql .= "LEFT JOIN bwp_bubblefeed bb ON bb.id = ba.bubblefeedid "; $sql .= "WHERE ba.domainid = '" . $domainid . "' "; $sql .= "AND ba.deleted != 1 "; $sql .= "AND bb.deleted != 1 "; $sql .= "AND bb.id IS NOT NULL "; $sql .= "AND LENGTH(ba.resfulltext) > 300 "; $sql .= "ORDER BY ba.id DESC "; $sql .= "LIMIT 20 "; $allbubba = FetchAll($sql); if(count($allbubba) >= 1) { $foot .= '
  • '; $foot .= '
      '; for ($i=0; $i ' . seo_automation_clean_title(html_entity_decode(seo_filter_text_custom($allbubba[$i]['bubbatitle']))) . ' '; } $foot .= '
    '; $wrlabel = 'Blog'; $foot .= $wrlabel . '
  • '; $num_lnks++; } } if($domains['linkexchange']=="1" && 1==2) { $haslinkspg = FetchRow("SELECT l.id, b.restitle FROM bwp_link_placement l LEFT JOIN bwp_bubblefeed b ON b.id = l.showonpgid AND b.deleted != 1 WHERE l.deleted != 1 AND l.showondomainid = '" . $domainid . "' ORDER BY b.createdDate LIMIT 1 "); if ($haslinkspg) { $linkurl = $linkdomain . '/' .$filename . '?Action=2&k=' . str_replace(' ', '-', strtolower(seo_text_custom($haslinkspg['restitle']))); $num_lnks++; //$feedlinks .= '' . $labels['businesscollective'] . ''; $foot .= '
  • News
  • '; } } /* if($domains['relatedarticles']=="1") { //$foot .= ' ' . $labels['pubsharing'] . ' '; $foot .= '
  • ' . $labels['pubsharing'] . '
  • '; $num_lnks++; } */ if($domains['webportalactive']==1 && $domains['domid'] != 88614) { if($labels['businesslog'] !='') $Bloglabel = seo_filter_text_custom($labels['businesslog']); else $Bloglabel = 'Press Room'; $foot .= '
  • News
  • '; $num_lnks++; } /* if($domains['htmlsitemap']=="1") { $foot .= '
  • HTML Sitemap
  • '; $num_lnks++; } if($domains['spydermap']=="1") { if ($version > '2' || $domains['uses0308'] == '1') $foot .= '
  • Sitemap
  • '; else if ($domains['usescontent_resource'] == '1') $foot .= '
  • Sitemap
  • '; else $foot .= '
  • Sitemap
  • '; $num_lnks++; } */ if ($domains['skippartnerprompts']=="1") { $foot .= '
    '; $foot = ''; } else { $foot .= '
    '; } if ($lytebox == 1) $num_lnks = 'lite'; $foot = '