[insert_php]
$protocol = (!empty($_SERVER[‘HTTPS’]) && $_SERVER[‘HTTPS’] !== ‘off’ || $_SERVER[‘SERVER_PORT’] == 443) ? “https://” : “http://”;
$domainName = $_SERVER[‘HTTP_HOST’];
session_start();
$hubId = $_COOKIE[‘hubspotutk’];
if (!hubId) {
$hubId = “xyz”;
}
$hubJson = json_decode(file_get_contents(‘https://api.hubapi.com/contacts/v1/contact/utk/’ . $hubId . ‘/profile?hapikey=5f3bb9c9-86e9-4bf5-999c-d6625e63f9fa’));
$showLeads = $hubJson->{‘is-contact’};
$urlArr = explode(‘/’, $_SERVER[‘REQUEST_URI’]);

$vid = $urlArr[count($urlArr) – 2];
$connArr = explode(‘:’, DB_HOST);
$conn = new mysqli($connArr[0], DB_USER, DB_PASSWORD, DB_NAME);
mysqli_set_charset($conn, “utf8”);
$sql =
“SELECT * FROM vendor_data_ab WHERE (is_active = 1 || (website IS NOT NULL AND website != ”)) AND slug = ‘” . $vid . “‘”;

$result = $conn->query($sql);
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
}

$connArr2 = explode(‘:’, DB_HOST2);
$conn2 = new mysqli($connArr2[0], DB_USER2, DB_PASSWORD2, DB_NAME2);
mysqli_set_charset($conn2, “utf8”);
$sql2 =
“SELECT v.*, MAX(vsp.maximum_group_size) as maximum_group_size, MIN(vsp.minimum_group_size) as minimum_group_size FROM vendor v JOIN vendor_survey_ab vs ON v.id = vs.vendor_id JOIN vendor_survey_product_ab vsp ON vs.id = vsp.vendor_survey_ab_id WHERE v.slug = ‘” . $vid . “‘”;

$result2 = $conn2->query($sql2);
if ($result2->num_rows > 0) {
$row2 = $result2->fetch_assoc();
}
$refArray = explode(“/”, $_SERVER[‘HTTP_REFERER’]);

$prodPrimaryFilterStr = “”;
$subProdPrimaryFilterStr = “”;
if ($refArray && strpos(strtolower($refArray[count($refArray) – 1]), “vendor-list”) !== false) {
$str = strtolower($refArray[count($refArray) – 2]);
$prodSrting = $conn2->real_escape_string($str);

$prodNameSql =
“SELECT public_menu_title FROM products WHERE public_slug = ‘” . $prodSrting . “‘
UNION
SELECT public_menu_title FROM sub_products WHERE public_slug = ‘” . $prodSrting . “‘”;

$prodNameResult = $conn2->query($prodNameSql);
if ($prodNameResult->num_rows > 0) {
$prodNameRow = $prodNameResult->fetch_assoc();
$prodName = $prodNameRow[‘public_menu_title’];
}
else{
$prodName = “Previous”;
}

$prodSrting2 = “AND p.public_slug LIKE ‘” . $conn2->real_escape_string($str) . “‘”;

$sql3 =
“SELECT prod_co_desc FROM vendor_survey_ab vs JOIN vendor_survey_product_ab vsp ON vs.id = vsp.vendor_survey_ab_id JOIN products p ON p.id = vsp.product_id AND p.public_slug = ‘” . $prodSrting . “‘ WHERE vs.vendor_id = ” . $row[‘vendor_id’] . “
UNION
SELECT prod_co_desc FROM vendor_survey_ab vs2 JOIN vendor_survey_sub_product_ab vssp ON vs2.id = vssp.vendor_survey_ab_id JOIN sub_products sp ON sp.id = vssp.sub_product_id AND sp.public_slug = ‘” . $prodSrting . “‘ WHERE vs2.vendor_id = ” . $row[‘vendor_id’];

$result3 = $conn2->query($sql3);
if ($result3->num_rows > 0) {
$row3 = $result3->fetch_assoc();
$prodCoDesc = $row3[‘prod_co_desc’];
}
} else {
$prodSrting = “%”;

$topProdSql = “SELECT * FROM (
SELECT product_id, NULL as sub_prod_id
FROM vendor v
JOIN vendor_survey_ab vs
ON v.id = vs.vendor_id
JOIN vendor_survey_product_ab vsp
ON vs.id = vsp.vendor_survey_ab_id
AND vsp.is_primary = 1
WHERE v.id = ” . $row[‘vendor_id’] . “
UNION
SELECT sp.product_id, vssp.sub_product_id as sub_prod_id
FROM vendor v
JOIN vendor_survey_ab vs
ON v.id = vs.vendor_id
JOIN vendor_survey_sub_product_ab vssp
ON vs.id = vssp.vendor_survey_ab_id
AND vssp.is_primary = 1
JOIN sub_products sp
ON sp.id = vssp.sub_product_id
WHERE v.id = ” . $row[‘vendor_id’] . “
) a
ORDER BY product_id, sub_prod_id DESC”;

$topProdResult = $conn2->query($topProdSql);
if ($topProdResult->num_rows > 0) {
while ($tpRow = $topProdResult->fetch_assoc()) {
if ($tpRow[‘sub_prod_id’]) {
$prodIdStr .= (string)$tpRow[‘sub_prod_id’] . “,”;
} else {
$prodIdStr .= (string)$tpRow[‘product_id’] . “,”;
}
}

$prodIdStr = trim($prodIdStr, “,”);

$prodPrimaryFilterStr = “
JOIN vendor_survey_ab vs
ON v.id = vs.vendor_id
JOIN vendor_survey_product_ab vsp
ON vs.id = vsp.vendor_survey_ab_id
AND vsp.product_id = p.id
AND vsp.is_primary = 1″;

$subProdPrimaryFilterStr = “
JOIN vendor_survey_ab vs
ON v.id = vs.vendor_id
JOIN vendor_survey_sub_product_ab vssp
ON vs.id = vssp.vendor_survey_ab_id
AND vssp.sub_product_id = p.id
AND vssp.is_primary = 1″;
} else {
$prodIdStr = “999999”;
}

$prodSrting2 = “AND p.id IN (” . $prodIdStr . “)”;
}

$curProdSql =
“SELECT public_menu_title
FROM products
WHERE public_slug = ‘” . $refArray[count($refArray) – 2] . “‘
UNION
SELECT public_menu_title
FROM sub_products
WHERE public_slug = ‘” . $refArray[count($refArray) – 2] . “‘”;

$curProdResult = $conn2->query($curProdSql);
if ($curProdResult->num_rows > 0) {
$curProd = $curProdResult->fetch_assoc();
}

$rqSql = “SELECT id, q0, q1, q2, q3, q4, q5, q6, q7, q8, q9, q10, q11, CASE WHEN s_type = 4 THEN comment ELSE NULL END as comment, CASE WHEN s_type = 4 THEN broker_name ELSE NULL END as company, s_type
FROM vendor_quality_review
WHERE vendor_id=” . $row[‘vendor_id’];
$rSqlResult = $conn2->query($rqSql);

if ($rSqlResult->num_rows > 0) {
$ratingsQuality = $rSqlResult->fetch_all(MYSQLI_ASSOC);
} else {
$ratingsQuality = array();
}

$finalistSql = “SELECT CONCAT(finalist_meeting_id, finalist_attendee_id) as id, finalist_meeting_question_id, answer
FROM finalist_meeting fm
JOIN finalist_meeting_answer fma
ON fm.id = fma.finalist_meeting_id
WHERE fm.vendor_id = ” . $row[‘vendor_id’] . ” AND
fma.question_type = ‘standard’
AND fma.question_data_type = ‘int’
GROUP BY CONCAT(finalist_meeting_id, finalist_attendee_id), finalist_meeting_question_id, answer
ORDER BY CAST(CONCAT(finalist_meeting_id, finalist_attendee_id) AS UNSIGNED), CAST(finalist_meeting_question_id AS UNSIGNED) ASC”;

$ratingsFinalists = $conn2->query($finalistSql);

$tempKey = 0;
$topKey = 0;
$finalistAnswerArr = [];
if ($ratingsFinalists->num_rows > 0) {
while ($scores = $ratingsFinalists->fetch_assoc()) {
if ($tempKey != $scores[‘id’] && $tempKey != 0) {
for ($fa = 0; $fa < 12; $fa++) { $finalistAnswerArr[$tempKey]['id'] = ""; if ($fa == 11) { if (!$finalistAnswerArr[$scores['id']]["q11"] || $finalistAnswerArr[$scores['id']]["q11"] == "N/A") { $tempCount = 0; $tempCountTotal = 0; for ($n = 0; $n < 11; $n++) { if ($finalistAnswerArr[$tempKey]["q" . $n] != NULL && strtolower($finalistAnswerArr[$tempKey]["q" . $n]) != "na" && strtolower($finalistAnswerArr[$tempKey]["q" . $n]) != "n/a") { $tempCountTotal += $finalistAnswerArr[$tempKey]["q" . $n]; $tempCount++; } } $finalistAnswerArr[$tempKey]["q11"] = round($tempCountTotal / $tempCount); } } else if (!$finalistAnswerArr[$tempKey]["q" . $fa]) { $finalistAnswerArr[$tempKey]["q" . $fa] = NULL; } $finalistAnswerArr[$tempKey]['comment'] = ""; $finalistAnswerArr[$tempKey]['company'] = ""; $finalistAnswerArr[$tempKey]['s_type'] = ""; } } $finalistAnswerArr[$scores['id']]["q" . $scores['finalist_meeting_question_id']] = $scores['answer']; $topKey = $tempKey = $scores['id']; } } $ratingsReviewSql = "SELECT NULL as id, NULL as q0, NULL as q1, NULL as q2, NULL as q3, NULL as q4, NULL as q5, NULL as q6, NULL as q7, NULL as q8, NULL as q9, NULL as q10, ROUND(overall_rating * 2) as q11, NULL as comment, NULL as company, NULL as s_type FROM vendor_review WHERE vendor_id=" . $row['vendor_id']; $ratingsSqlResult = $conn2->query($ratingsReviewSql);

if ($ratingsSqlResult->num_rows > 0) {
$ratingsQuality2 = $ratingsSqlResult->fetch_all(MYSQLI_ASSOC);
} else {
$ratingsQuality2 = array();
}

$ratingsArr = array_merge($ratingsQuality, $finalistAnswerArr, $ratingsQuality2);

$totalScore = 0;
$totalCount = 0;
$reviewCount = 0;
$carouselArr = array();
foreach ($ratingsArr as $rating) {
$ratingTemp = 0;
$numRatings = 0;
if ($rating[‘comment’]) {
$reviewCount++;
}
if ($rating[‘q11’] && $rating[‘q11’] != “N/A”) {
$score = round($rating[‘q11’] / 2, 1);
} else {
if ($rating[‘q0’] != “” && $rating[‘q0’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q0’]) ? $rating[‘q0’] : 0;
$numRatings++;
}
if ($rating[‘q1’] != “” && $rating[‘q1’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q1’]) ? $rating[‘q1’] : 0;
$numRatings++;
}
if ($rating[‘q2’] != “” && $rating[‘q2’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q2’]) ? $rating[‘q2’] : 0;
$numRatings++;
}
if ($rating[‘q3’] != “” && $rating[‘q3’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q3’]) ? $rating[‘q3’] : 0;
$numRatings++;
}
if ($rating[‘q4’] != “” && $rating[‘q4’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q4’]) ? $rating[‘q4’] : 0;
$numRatings++;
}
if ($rating[‘q5’] != “” && $rating[‘q5’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q5’]) ? $rating[‘q5’] : 0;
$numRatings++;
}
if ($rating[‘q6’] != “” && $rating[‘q6’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q6’]) ? $rating[‘q6’] : 0;
$numRatings++;
}
if ($rating[‘q7’] != “” && $rating[‘q7’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q7’]) ? $rating[‘q7’] : 0;
$numRatings++;
}
if ($rating[‘q8’] != “” && $rating[‘q8’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q8’]) ? $rating[‘q8’] : 0;
$numRatings++;
}
if ($rating[‘q9’] != “” && $rating[‘q9’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q9’]) ? $rating[‘q9’] : 0;
$numRatings++;
}
if ($rating[‘q10’] != “” && $rating[‘q10’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q10’]) ? $rating[‘q10’] : 0;
$numRatings++;
}

if ($numRatings) {
$score = round((($ratingTemp / 2) / $numRatings), 1);
} else {
$score = 0;
}
}

if ($rating[‘comment’]) {
$carouselArr[$rating[‘id’]][‘comment’] = $rating[‘comment’];
$carouselArr[$rating[‘id’]][‘company’] = $rating[‘company’];
$carouselArr[$rating[‘id’]][‘score’] = $score;
}

if ($score > 0) {
$totalScore = $totalScore + $score;
$totalCount++;
}
}

if ($totalCount > 0) {
$score = round($totalScore / $totalCount, 1);
} else {
$score = 0;
}

if ($_SERVER[‘HTTP_REFERER’] && $_SERVER[‘HTTP_REFERER’] != $protocol.$domainName.”/”) {
if ($refArray && strtolower($refArray[count($refArray) – 1]) == “vendor-list-t1”) {
$ref = “|**|” . $refArray[count($refArray) – 2];
} else {
$ref = “|*|” . $_SERVER[‘HTTP_REFERER’];
}
} else {
$ref = “|****|” . “https://{$_SERVER[‘HTTP_HOST’]}{$_SERVER[‘REQUEST_URI’]}”;
}

if (!empty($_SERVER[‘HTTP_CLIENT_IP’])) {
//ip from share internet
$ip = $_SERVER[‘HTTP_CLIENT_IP’];
} elseif (!empty($_SERVER[‘HTTP_X_FORWARDED_FOR’])) {
//ip pass from proxy
$ip = $_SERVER[‘HTTP_X_FORWARDED_FOR’];
} else {
$ip = $_SERVER[‘REMOTE_ADDR’];
}

$pplParticipate = false;
$vendorPplSql = “
SELECT v.id
FROM vendor_ppl ppl
JOIN products p
ON p.id = ppl.product_id
AND p.public_slug LIKE ‘” . $prodSrting . “‘
AND ppl.is_active = 1
JOIN vendor v
ON v.id = ppl.vendor_id
JOIN image i
ON i.id = v.logo_id
WHERE ppl.vendor_id = ” . $row[‘vendor_id’] . “
UNION
SELECT v.id
FROM vendor_ppl ppl
JOIN sub_products p
ON p.id = ppl.product_id
AND p.public_slug LIKE ‘” . $prodSrting . “‘
AND ppl.is_active = 1
JOIN vendor v
ON v.id = ppl.vendor_id
JOIN image i
ON i.id = v.logo_id
WHERE ppl.vendor_id = ” . $row[‘vendor_id’];

$vendorPplResults = $conn2->query($vendorPplSql);
if ($vendorPplResults->num_rows > 0) {
$pplParticipate = true;
}

$ppcParticipate = false;
$vendorPpcSql = “
SELECT v.id
FROM vendor_ppc ppc
JOIN products p
ON p.id = ppc.product_id
AND p.public_slug LIKE ‘” . $prodSrting . “‘
AND ppc.is_active = 1
JOIN vendor v
ON v.id = ppc.vendor_id
JOIN image i
ON i.id = v.logo_id
WHERE ppc.vendor_id = ” . $row[‘vendor_id’] . “
UNION
SELECT v.id
FROM vendor_ppc ppc
JOIN sub_products p
ON p.id = ppc.product_id
AND p.public_slug LIKE ‘” . $prodSrting . “‘
AND ppc.is_active = 1
JOIN vendor v
ON v.id = ppc.vendor_id
JOIN image i
ON i.id = v.logo_id
WHERE ppc.vendor_id = ” . $row[‘vendor_id’];

$vendorPpcResults = $conn2->query($vendorPpcSql);
if ($vendorPpcResults->num_rows > 0) {
$ppcParticipate = true;
}

[/insert_php]

[insert_php]
if ($ppcParticipate) {
$clickTarget = ‘href=”‘.$protocol.$domainName.’/t1_external_click?vid=’ . urlencode(base64_encode($row2[‘slug’])) . ‘&uid=’ . urlencode($ip) . ‘&ref=’ . urlencode($ref) . ‘&link_from=1&is_click=1″ target=”_blank”‘;
}
[/insert_php]

[insert_php]
if ($ppcParticipate){
echo ‘‘;
[/insert_php]

[insert_php] echo $row[‘name’]; [/insert_php]

[insert_php]
if ($totalCount > 0) {
echo ‘‘;
}
[/insert_php]

[insert_php]
if ($score >= 0 && $score < .5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= .5 && $score < 1) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 1 && $score < 1.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 1.5 && $score < 2) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 2 && $score < 2.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 2.5 && $score < 3) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 3 && $score < 3.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 3.5 && $score < 4) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 4 && $score < 4.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 4.5 && $score < 5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score == 5) {
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
}
[/insert_php]

• [insert_php]echo $score;[/insert_php]/5 ([insert_php]echo $totalCount;[/insert_php] reviews)

• Founded   [insert_php]echo $row[‘established_date’];[/insert_php]
• Group Sizes  [insert_php] if (empty($row2[‘minimum_group_size’]) && empty($row2[‘maximum_group_size’])) {
  echo “Any Size”;
  } else if (!$row2[‘minimum_group_size’] && $row2[‘maximum_group_size’]) {
  echo “Smaller than ” . $row2[‘maximum_group_size’];
  } else if ($row2[‘minimum_group_size’] && !$row2[‘maximum_group_size’]) {
  echo “Larger than ” . $row2[‘minimum_group_size’];
  } else {
  echo $row2[‘minimum_group_size’] . ” to ” . $row2[‘maximum_group_size’];
  } [/insert_php]
• Customers Served  [insert_php]
  $num = $row2[‘lives_serviced_per_year’];
  if ($num > 1000) {
  $x = round($num);
  $x_number_format = number_format($x);
  $x_array = explode(‘,’, $x_number_format);
  $x_parts = array(‘K’, ‘M’, ‘B’, ‘T’);
  $x_count_parts = count($x_array) – 1;
  $x_display = $x;
  $x_display = $x_array[0] . ((int)$x_array[1][0] !== 0 ? ‘.’ . $x_array[1][0] : ”);
  $x_display .= $x_parts[$x_count_parts – 1];

  $num = $x_display;
  }

  echo ($num) ? $num : ” “;
  [/insert_php]

[insert_php]
if ($score >= 0 && $score < .5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= .5 && $score < 1) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 1 && $score < 1.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 1.5 && $score < 2) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 2 && $score < 2.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 2.5 && $score < 3) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 3 && $score < 3.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 3.5 && $score < 4) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 4 && $score < 4.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 4.5 && $score < 5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score == 5) {
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
}
[/insert_php]

• [insert_php]echo $score;[/insert_php]/5 ([insert_php]echo $totalCount;[/insert_php] reviews)

[insert_php]
if ($ppcParticipate || $pplParticipate) {
if ($showLeads) {
echo ‘Get Pricing Info ‘;
} else {
echo ‘Get Pricing Info ‘;
}
} else {
echo ‘Get Pricing Info ‘;
}
[/insert_php]

[insert_php]
if ((int)$row[‘is_active’] == 0) {
echo ‘

Do you work for ‘ . strip_tags($row[‘name’]) . ‘?
‘;
echo ‘Update this profile

‘;
}
[/insert_php]

[insert_php]
if ((int)$row[‘is_active’] == 0) {
echo ‘

Do you work for ‘ . strip_tags($row[‘name’]) . ‘?
‘;
echo ‘Update this profile

‘;
}
[/insert_php]

Back to [insert_php]echo $prodName;[/insert_php] Page

[insert_php]
if ($showLeads) {
echo ‘Request Info‘;
} else {
echo ‘Request Info‘;
}
[/insert_php]

[insert_php]
echo ‘

You have selected the maximum of 8 products to compare


Add to Compare

‘;
[/insert_php]

[insert_php]
if ($ppcParticipate){
echo ‘ Go To Website ‘;
}
[/insert_php]

• About
• Media
• Offerings
• Reviews
• Materials
• Clients

[insert_php] echo strip_tags($row[‘name’]); [/insert_php] Media

[insert_php]
if (($row[‘snapshot1_id’] && $row[‘snapshot1_id’] != “NULL” && $row[‘snapshot1_visibility’] != 1) || ($row[‘snapshot2_id’] && $row[‘snapshot2_id’] != “NULL” && $row[‘snapshot2_visibility’] != 1) || ($row[‘snapshot3_id’] && $row[‘snapshot3_id’] != “NULL” && $row[‘snapshot3_visibility’] != 1) || ($row[‘media1_link’] && $row[‘media1_link’] != “NULL” && $row[‘media1_visibility’] != 1) || ($row[‘media2_link’] && $row[‘media2_link’] != “NULL” && $row[‘media2_visibility’] != 1) || ($row[‘media3_link’] && $row[‘media3_link’] != “NULL” && $row[‘media3_visibility’] != 1)) {
echo ‘

‘;
if ($row[‘snapshot1_id’] && $row[‘snapshot1_id’] != “NULL” && $row[‘snapshot1_visibility’] != 1) {
echo ‘‘;
} else if ($row[‘media1_link’] && $row[‘media1_link’] != “NULL” && $row[‘media1_visibility’] != 1) {
if ($row[‘media1_type’] == 0) {
echo ‘‘;
} else {
echo ‘‘;
}
}
echo ‘

‘;
if ($row[‘snapshot1_id’] && $row[‘snapshot1_id’] != “NULL” && $row[‘snapshot1_visibility’] != 1) {
echo ‘
• 
  
  

‘;
}
if ($row[‘snapshot2_id’] && $row[‘snapshot2_id’] != “NULL” && $row[‘snapshot2_visibility’] != 1) {
echo ‘

• 
  
  

‘;
}
if ($row[‘snapshot3_id’] && $row[‘snapshot3_id’] != “NULL” && $row[‘snapshot3_visibility’] != 1) {
echo ‘

• 
  
  

‘;
}
if ($row[‘media1_link’] && $row[‘media1_link’] != “NULL” && $row[‘media1_visibility’] != 1) {
if ($row[‘media1_type’] == 0) {
echo ‘

• 
  
  

‘;
} else {
$hash = unserialize(file_get_contents(“https://vimeo.com/api/v2/video/” . $row[‘media1_link’] . “.php”));
if ($hash) {
$img = $hash[0][‘thumbnail_small’];
} else {
$img = “https://d36w3vgtkvgnsp.cloudfront.net/blank_video.jpg”;
}
echo ‘

• 
  
  

‘;
}
}
if ($row[‘media2_link’] && $row[‘media2_link’] != “NULL” && $row[‘media2_visibility’] != 1) {
if ($row[‘media2_type’] == 0) {
echo ‘

• 
  
  

‘;
} else {
$hash = unserialize(file_get_contents(“https://vimeo.com/api/v2/video/” . $row[‘media2_link’] . “.php”));
if ($hash) {
$img = $hash[0][‘thumbnail_small’];
} else {
$img = “https://d36w3vgtkvgnsp.cloudfront.net/blank_video.jpg”;
}
echo ‘

• 
  
  

‘;
}
}
if ($row[‘media3_link’] && $row[‘media3_link’] != “NULL” && $row[‘media3_visibility’] != 1) {
if ($row[‘media3_type’] == 0) {
echo ‘

• 
  
  

‘;
} else {
$hash = unserialize(file_get_contents(“https://vimeo.com/api/v2/video/” . $row[‘media3_link’] . “.php”));
if ($hash) {
$img = $hash[0][‘thumbnail_small’];
} else {
$img = “https://d36w3vgtkvgnsp.cloudfront.net/blank_video.jpg”;
}
echo ‘

• 
  
  

‘;
}
}
echo ‘

‘;
} else {
echo “No Media uploaded for this vendor.”;
}
[/insert_php]

About [insert_php] echo strip_tags($row[‘name’]); [/insert_php]

[insert_php]echo str_replace(“.com”, “”, str_replace(“www.”, “”, str_replace(“http://”, “”, str_replace(“https://”, “”, strip_tags($row[‘summary’])))));[/insert_php]

[insert_php] if ($prodCoDesc) {
echo ‘

‘ . $curProd[‘public_menu_title’] . ‘ Info

‘ . str_replace(“.com”, “”, str_replace(“www.”, “”, str_replace(“http://”, “”, str_replace(“https://”, “”, str_replace(‘$’, ‘$’, strip_tags($prodCoDesc)))))) . ‘

‘;
} [/insert_php]

Value Proposition

[insert_php]echo str_replace(“.com”, “”, str_replace(“www.”, “”, str_replace(“http://”, “”, str_replace(“https://”, “”, strip_tags($row[‘value_proposition’])))));[/insert_php]

Get More Info

[insert_php] echo strip_tags($row[‘name’]); [/insert_php] Offerings

[insert_php]
$prodSql =
“SELECT DISTINCT vp.vendor_id, vp.sub_product_id, vp.is_primary, vp.product_section_id, vp.product_name, vp.product_name2, vp.slug, vp.sub_product_name, vp.sub_product_name2, vp.in_house, vp.stand_alone, vp.top3, ps.name as section_name
FROM vendor_products vp
JOIN product_section ps
ON ps.id = vp.product_section_id
WHERE vp.vendor_id = ” . $row[‘vendor_id’] . “
ORDER BY ps.sort_order, vp.product_name”;

$allProds = $conn->query($prodSql);
if ($allProds->num_rows > 0) {
echo ‘

‘;
$r = 0;
$prevSectionId = 0;
$startSub = true;
$colNum = ceil($allProds->num_rows / 2);
if ($colNum % 2 == 1) $colNum++;
while ($prodRow = $allProds->fetch_assoc()) {
if ($r % $colNum == 0) {
if ($r == 0) {
echo ‘

‘;
} else {
if (!$startSub) {
echo “

“;
$startSub = true;
}
echo ‘

‘;
}
}

if ($prodRow[‘sub_product_name’]) {
if ($startSub) {
echo “

“;
$startSub = false;
}
echo ‘
• ‘ . $prodRow[‘sub_product_name’] . ‘

‘;
} else {
if ($r > 0) {
echo “

“;
}
if ($prevSectionId != $prodRow[‘product_section_id’]) {
echo ‘

• ‘ . $prodRow[‘section_name’] . ‘

‘;
}
echo “

• ” . $prodRow[‘product_name’];
  }

  $r++;
  $prevSectionId = $prodRow[‘product_section_id’];
  }
  echo “

“;
echo ‘

‘;
echo ‘

‘;
} else {
echo ‘

‘;
}
[/insert_php]

[insert_php] echo strip_tags($row[‘name’]); [/insert_php] Reviews

[insert_php]
$topRatingSql =
“SELECT *
FROM vendor_quality_review
WHERE vendor_id = ” . $row[‘vendor_id’] . ” AND s_type=4 AND iteration > 0″;

$topRating = $conn2->query($topRatingSql);

if ($topRating->num_rows > 0) {
$rateRow = $topRating->fetch_assoc();

echo ‘

‘ . $totalCount . ‘ Reviews

‘;
if ($score >= 0 && $score < .5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= .5 && $score < 1) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 1 && $score < 1.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 1.5 && $score < 2) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 2 && $score < 2.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 2.5 && $score < 3) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 3 && $score < 3.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 3.5 && $score < 4) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 4 && $score < 4.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 4.5 && $score < 5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score == 5) {
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
}
echo ‘

‘ . $rateRow[‘broker_name’] . ‘

‘ . date(‘m/d/Y’, strtotime($rateRow[‘created_dt’])) . ‘

‘ . $rateRow[‘comment’] . ‘

‘;
}
[/insert_php]

Register to Read All Reviews

[insert_php] echo strip_tags($row[‘name’]); [/insert_php] Materials

[insert_php]
$materialSql = ‘SELECT id, name, sha1 FROM vendor_material WHERE vendor_id = ‘ . $row[‘vendor_id’];

$materials = $conn2->query($materialSql);
if ($materials->num_rows > 0) {
while ($material = $materials->fetch_assoc()) {
echo ‘

• 

  ‘ . $material[‘name’] . ‘

‘;
}
}
[/insert_php]

You must be a registered user of Shortlister to access this
information . Click below to register and download these materials .

Register to Download Materials

[insert_php] echo strip_tags($row[‘name’]); [/insert_php] Clients

You must be a registered user of Shortlister to access this
information . Click below to register and see this vendor’s clients .

Register to View Clients of This Vendor

[insert_php]if (strpos($_SERVER[‘REQUEST_URI’], “healics”) !== false) {
echo ‘

‘;
}[/insert_php]

[insert_php]
if ($showLeads) {
$rotatorSql = “
SELECT DISTINCT v.*, CONCAT(i.sha1, ‘.’, i.extension) as logo, ppl.bid
FROM vendor_ppl ppl
JOIN products p
ON p.id = ppl.product_id
” . $prodSrting2 . “
AND ppl.is_active = 1
JOIN vendor v
ON v.id = ppl.vendor_id
” . $prodPrimaryFilterStr . “
JOIN image i
ON i.id = v.logo_id
WHERE ppl.vendor_id NOT IN (” . $row[‘vendor_id’] . “)
UNION
SELECT DISTINCT v.*, CONCAT(i.sha1, ‘.’, i.extension) as logo, ppl.bid
FROM vendor_ppl ppl
JOIN sub_products p
ON p.id = ppl.product_id
” . $prodSrting2 . “
AND ppl.is_active = 1
JOIN vendor v
ON v.id = ppl.vendor_id
” . $subProdPrimaryFilterStr . “
JOIN image i
ON i.id = v.logo_id
WHERE ppl.vendor_id NOT IN (” . $row[‘vendor_id’] . “)
ORDER BY bid DESC
LIMIT 3″;

$rotatorResults = $conn2->query($rotatorSql);

if ($rotatorResults->num_rows < 3) { $diff = 3 - $rotatorResults->num_rows;

if ($rotatorResults->num_rows > 0) {
$r1 = mysqli_fetch_all($rotatorResults, MYSQLI_ASSOC);
foreach ($r1 as $tr1) {
$pplArr[] = $tr1[‘id’];
}

$pplStr = explode(‘,’, $pplArr);
$pplStr .= “,” . $row[‘vendor_id’];
}

$rotatorSql = “
SELECT DISTINCT v.*, CONCAT(i.sha1, ‘.’, i.extension) as logo, ppc.bid
FROM vendor_ppc ppc
JOIN products p
ON p.id = ppc.product_id
” . $prodSrting2 . “
AND ppc.is_active = 1
JOIN vendor v
ON v.id = ppc.vendor_id
” . $prodPrimaryFilterStr . “
JOIN image i
ON i.id = v.logo_id
WHERE ppc.vendor_id NOT IN ($pplStr)
UNION
SELECT DISTINCT v.*, CONCAT(i.sha1, ‘.’, i.extension) as logo, ppc.bid
FROM vendor_ppc ppc
JOIN sub_products p
ON p.id = ppc.product_id
” . $prodSrting2 . “
AND ppc.is_active = 1
JOIN vendor v
ON v.id = ppc.vendor_id
” . $subProdPrimaryFilterStr . “
JOIN image i
ON i.id = v.logo_id
WHERE ppc.vendor_id NOT IN ($pplStr)
ORDER BY bid DESC”;

$rotatorResults2 = $conn2->query($rotatorSql);
$r2 = mysqli_fetch_all($rotatorResults2, MYSQLI_ASSOC);

$pplArr = array();
$ppcArr = array();

$i = 0;
foreach ($r2 as $tr2) {
if (!in_array($tr2[‘id’], $ppcArr) && $i < $diff) { $ppcArr[] = $tr2; $diff++; } } $rotator = array_merge($r1, $ppcArr); } else { $rotator = mysqli_fetch_all($rotatorResults, MYSQLI_ASSOC); } } else { $rotatorSql = " SELECT DISTINCT v.*, CONCAT(i.sha1, '.', i.extension) as logo, ppc.bid FROM vendor_ppc ppc JOIN products p ON p.id = ppc.product_id " . $prodSrting2 . " AND ppc.is_active = 1 JOIN vendor v ON v.id = ppc.vendor_id " . $prodPrimaryFilterStr . " JOIN image i ON i.id = v.logo_id WHERE ppc.vendor_id NOT IN (" . $row['vendor_id'] . ") UNION SELECT DISTINCT v.*, CONCAT(i.sha1, '.', i.extension) as logo, ppc.bid FROM vendor_ppc ppc JOIN sub_products p ON p.id = ppc.product_id " . $prodSrting2 . " AND ppc.is_active = 1 JOIN vendor v ON v.id = ppc.vendor_id " . $subProdPrimaryFilterStr . " JOIN image i ON i.id = v.logo_id WHERE ppc.vendor_id NOT IN (" . $row['vendor_id'] . ") ORDER BY bid DESC LIMIT 3"; $rotatorResults = $conn2->query($rotatorSql);
$rotator = mysqli_fetch_all($rotatorResults, MYSQLI_ASSOC);
}

if (count($rotator) > 0) {
echo ‘

Similar Companies

‘;
foreach ($rotator as $rateRow) {
$rqSql = “SELECT id, q0, q1, q2, q3, q4, q5, q6, q7, q8, q9, q10, q11, CASE WHEN s_type = 4 THEN comment ELSE NULL END as comment, CASE WHEN s_type = 4 THEN broker_name ELSE NULL END as company, s_type
FROM vendor_quality_review
WHERE vendor_id=” . $rateRow[‘id’];
$rSqlResult = $conn2->query($rqSql);

if ($rSqlResult->num_rows > 0) {
$ratingsQuality = $rSqlResult->fetch_all(MYSQLI_ASSOC);
} else {
$ratingsQuality = array();
}

$finalistSql = “SELECT CONCAT(finalist_meeting_id, finalist_attendee_id) as id, finalist_meeting_question_id, answer
FROM finalist_meeting fm
JOIN finalist_meeting_answer fma
ON fm.id = fma.finalist_meeting_id
WHERE fm.vendor_id = ” . $rateRow[‘id’] . ” AND
fma.question_type = ‘standard’
AND fma.question_data_type = ‘int’
GROUP BY finalist_meeting_id, finalist_attendee_id, finalist_meeting_question_id”;

$ratingsFinalists = $conn2->query($finalistSql);

$tempKey = 0;
$keyInd = 0;
$finalistAnswerArr = [];
if ($ratingsFinalists->num_rows > 0) {
while ($scores = $ratingsFinalists->fetch_assoc()) {
if ($tempKey != $scores[‘id’] && $tempKey != 0) {
if (count($finalistAnswerArr[$tempKey]) < 12) { for ($fa = count($finalistAnswerArr[$tempKey]); $fa < 12; $fa++) { $finalistAnswerArr[$tempKey]['id'] = ""; if ($fa == 11) { $tempCount = 0; $tempCountTotal = 0; for ($n = 0; $n < 11; $n++) { if ($finalistAnswerArr[$tempKey]["q" . $n] != NULL && strtolower($finalistAnswerArr[$tempKey]["q" . $n]) != "na" && strtolower($finalistAnswerArr[$tempKey]["q" . $n]) != "n/a") { $tempCountTotal += $finalistAnswerArr[$tempKey][$n]; $tempCount++; } } $finalistAnswerArr[$tempKey]["q11"] = round($tempCountTotal / $tempCount); } else { $finalistAnswerArr[$tempKey]["q" . $fa] = NULL; } $finalistAnswerArr[$tempKey]['comment'] = ""; $finalistAnswerArr[$tempKey]['company'] = ""; $finalistAnswerArr[$tempKey]['s_type'] = ""; } } $keyInd = 0; } for ($z = $keyInd; $z <= $scores['finalist_meeting_question_id']; $z++) { $finalistAnswerArr[$scores['id']]["q" . $z] = ($scores['finalist_meeting_question_id'] == $z) ? $scores['answer'] : NULL; } $keyInd = $z; $tempKey = $scores['id']; } } $ratingsReviewSql = "SELECT NULL as id, NULL as q0, NULL as q1, NULL as q2, NULL as q3, NULL as q4, NULL as q5, NULL as q6, NULL as q7, NULL as q8, NULL as q9, NULL as q10, ROUND(overall_rating * 2) as q11, NULL as comment, NULL as company, NULL as s_type FROM vendor_review WHERE vendor_id=" . $rateRow['id']; $ratingsSqlResult = $conn2->query($ratingsReviewSql);

if ($ratingsSqlResult->num_rows > 0) {
$ratingsQuality2 = $ratingsSqlResult->fetch_all(MYSQLI_ASSOC);
} else {
$ratingsQuality2 = array();
}

$ratingsArr = array_merge($ratingsQuality, $finalistAnswerArr, $ratingsQuality2);

$totalScore = 0;
$totalCount = 0;
$reviewCount = 0;
$carouselArr = array();
foreach ($ratingsArr as $rating) {
$ratingTemp = 0;
$numRatings = 0;
if ($rating[‘comment’]) {
$reviewCount++;
}
if ($rating[‘q11’] && $rating[‘q11’] != “N/A”) {
$score = round($rating[‘q11’] / 2, 1);
} else {
if ($rating[‘q0’] != “” && $rating[‘q0’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q0’]) ? $rating[‘q0’] : 0;
$numRatings++;
}
if ($rating[‘q1’] != “” && $rating[‘q1’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q1’]) ? $rating[‘q1’] : 0;
$numRatings++;
}
if ($rating[‘q2’] != “” && $rating[‘q2’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q2’]) ? $rating[‘q2’] : 0;
$numRatings++;
}
if ($rating[‘q3’] != “” && $rating[‘q3’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q3’]) ? $rating[‘q3’] : 0;
$numRatings++;
}
if ($rating[‘q4’] != “” && $rating[‘q4’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q4’]) ? $rating[‘q4’] : 0;
$numRatings++;
}
if ($rating[‘q5’] != “” && $rating[‘q5’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q5’]) ? $rating[‘q5’] : 0;
$numRatings++;
}
if ($rating[‘q6’] != “” && $rating[‘q6’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q6’]) ? $rating[‘q6’] : 0;
$numRatings++;
}
if ($rating[‘q7’] != “” && $rating[‘q7’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q7’]) ? $rating[‘q7’] : 0;
$numRatings++;
}
if ($rating[‘q8’] != “” && $rating[‘q8’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q8’]) ? $rating[‘q8’] : 0;
$numRatings++;
}
if ($rating[‘q9’] != “” && $rating[‘q9’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q9’]) ? $rating[‘q9’] : 0;
$numRatings++;
}
if ($rating[‘q10’] != “” && $rating[‘q10’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q10’]) ? $rating[‘q10’] : 0;
$numRatings++;
}

$score = round((($ratingTemp / 2) / $numRatings), 1);
}

if ($rating[‘comment’]) {
$carouselArr[$rating[‘id’]][‘comment’] = $rating[‘comment’];
$carouselArr[$rating[‘id’]][‘company’] = $rating[‘company’];
$carouselArr[$rating[‘id’]][‘score’] = $score;
}

$totalScore = $totalScore + $score;
$totalCount++;
}

if ($totalCount > 0) {
$score = round($totalScore / $totalCount, 1);
} else {
$score = 0;
}

if ($showLeads) {
$clickTarget = ‘href=”javascript: void(0);” onclick=”sub_click(\” . urlencode(base64_encode($rateRow[‘slug’])) . ‘\’,\” . urlencode($ip) . ‘\’,\” . urlencode($ref) . ‘\’, \’4\’, \” . $rateRow[‘name’] . ‘\’)”‘;
} else {
$clickTarget = ‘href=”‘.$protocol.”.$domainName.’/t1_external_click?vid=’ . urlencode(base64_encode($rateRow[‘slug’])) . ‘&uid=’ . urlencode($ip) . ‘&ref=’ . urlencode($ref) . ‘&link_from=4″ target=”_blank”‘;
}

echo ‘

• 
  

  ‘ . $rateRow[‘name’] . ‘

  ‘;
  if (count($ratingsArr) > 0 && $totalCount > 0) {
  echo ‘

  ‘;
  if ($score >= 0 && $score < .5) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= .5 && $score < 1) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= 1 && $score < 1.5) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= 1.5 && $score < 2) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= 2 && $score < 2.5) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= 2.5 && $score < 3) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= 3 && $score < 3.5) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= 3.5 && $score < 4) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= 4 && $score < 4.5) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= 4.5 && $score < 5) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score == 5) {
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  }
  echo ‘

  • ‘ . $score . ‘/5 (‘ . $totalCount . ‘ reviews)

  ‘;
  }

  $sqlDesc =
  “SELECT prod_co_desc FROM vendor_survey_ab vs JOIN vendor_survey_product_ab vsp ON vs.id = vsp.vendor_survey_ab_id JOIN products p ON p.id = vsp.product_id AND p.public_slug = ‘” . $prodSrting . “‘ WHERE vs.vendor_id = ” . $rateRow[‘id’] . “
  UNION
  SELECT prod_co_desc FROM vendor_survey_ab vs2 JOIN vendor_survey_sub_product_ab vssp ON vssp.id = vssp.vendor_survey_ab_id JOIN sub_products sp ON sp.id = vssp.sub_product_id AND sp.public_slug = ‘” . $prodSrting . “‘ WHERE vs2.vendor_id = ” . $rateRow[‘id’];

  $resultDesc = $conn2->query($sqlDesc);
  $prodCoDesc = “”;
  if ($resultDesc->num_rows > 0) {
  $desc = $resultDesc->fetch_assoc();
  $prodCoDesc = $desc[‘prod_co_desc’];
  }
  $tempDesc = “”;
  if (trim($prodCoDesc) != “”) {
  $tempDesc = $prodCoDesc;
  if (strlen($tempDesc) > 199) {
  $tempDesc = substr($tempDesc, 0, 200) . “…”;
  }
  } else {
  $tempDesc = $rateRow[‘summary’];
  if (strlen($tempDesc) > 199) {
  $tempDesc = substr($tempDesc, 0, 200) . “…”;
  }
  }
  if ($showLeads) {
  $clickTarget = ‘href=”javascript: void(0);” onclick=”sub_click(\” . urlencode(base64_encode($rateRow[‘slug’])) . ‘\’,\” . urlencode($ip) . ‘\’,\” . urlencode($ref) . ‘\’, \’5\’, \” . $rateRow[‘name’] . ‘\’)”‘;
  } else {
  $clickTarget = ‘href=”‘.$protocol.”.$domainName.’/t1_external_click?vid=’ . urlencode(base64_encode($rateRow[‘slug’])) . ‘&uid=’ . urlencode($ip) . ‘&ref=’ . urlencode($ref) . ‘&link_from=5″ target=”_blank”‘;
  }
  echo ‘

  ‘ . strip_tags($tempDesc, ‘$’) . ‘

  Get More Info

‘;
}
echo ‘

‘;
}
[/insert_php]