Query("SELECT intMediaID from MediaLibrary where intMediaTypeID = " . $prmMediaTypeID . " and bitPublish = 1 and strImageFile <> '' and strMediaTitle <> '' order by dtmPubDate desc limit 1"); } if ($prmMediaTypeID > 0) { $prmOverrideHeader = $prmMediaTypeID; } else { $prmOverrideHeader = 0; } $prmMetaTags = IsSet($prmMetaTags) ? stripslashes($prmMetaTags) : ''; $prmMetaDescription = IsSet($prmMetaDescription) ? stripslashes($prmMetaDescription) : ''; $prmLeftAlign = 647; $prmPageRecord = 7; $prmTotal = 0; $prmPageNum = IsSet($prmPageNum) ? $prmPageNum : 0; $prmPage = IsSet($prmPage) ? $prmPage : 0; $dbComments = new cDB(); include '_incPageSetup.php'; if ($prmMediaTypeID > 0) { if ($prmMediaTypeID == 297) { $dbMedia->Query("SELECT intMediaID from MediaLibrary where intMediaID = 5191"); } else { $dbMedia->Query("SELECT intMediaID from MediaLibrary where intMediaTypeID = " . $prmMediaTypeID . " and bitPublish = 1 and strImageFile <> '' and strMediaTitle <> '' order by dtmPubDate desc limit 1"); } if (!$dbMedia->RowCount) { $dbMedia->Query('SELECT intMediaID from MediaLibrary where intMediaTypeID = ' . $prmMediaTypeID . ' or intMediaTypeID2 = ' . $prmMediaTypeID . ' or intMediaTypeID3 = ' . $prmMediaTypeID . " and bitPublish = 1 and strImageFile <> '' and strMediaTitle <> '' order by dtmPubDate desc limit 1"); } if ($dbMedia->RowCount) { if ($dbMedia->ReadRow()) { $prmMID = $dbMedia->RowData['intMediaID']; $varLandingPage = 1; } else { $varLandingPage = 0; } } } $dbComments->Query('select * from Comments where intMediaID = ' . $prmMID . ' order by dtmDateTime desc'); $varCommentCount = $dbComments->RowCount; if ($prmPreview == 1){ $strExtension = ''; } else { $strExtension = 'MediaLibrary.bitPublish = 1 AND'; } $dbMedia->Query('SELECT DATE_FORMAT(MediaLibrary.dtmPubDate, "%W, %M %e, %Y") AS PubDate, MediaLibrary.*, Authors.strFirstName, Authors.strLastName, Authors.txtFullBio FROM MediaLibrary LEFT JOIN Authors ON MediaLibrary.intAuthorID = Authors.intAuthorID WHERE MediaLibrary.intMediaID = ' . $prmMID . ' AND ' . $strExtension . ' MediaLibrary.dtmPubDate <= CURDATE()'); if ($dbMedia->RowCount) { if ($dbMedia->ReadRow()) { $prmMediaTitle = $dbMedia->RowData['strMediaTitle']; $prmMediaTypeID = $dbMedia->RowData['intMediaTypeID']; $prmMediaText = $dbMedia->RowData['txtMediaText']; $prmMediaText = str_replace('http://www.frozzi.com/cbridge/userfiles/accountfiles/', '/media/image/', $prmMediaText); $prmMediaText = str_replace('

', '', $prmMediaText); $prmMediaText = str_replace('

', '', $prmMediaText); $prmMediaText = str_replace('

', '

', $prmMediaText); $prmMediaText = str_replace('

', '

', $prmMediaText); //if ($prmMID < $prmLeftAlign) { $prmMediaText = str_replace('img style="float: right"', 'float: left"', $prmMediaText); $prmMediaText = str_replace('style="float: right', 'style="float: left', $prmMediaText); $prmMediaText = str_replace('RowData['strImageLabel']; $prmFormID = $dbMedia->RowData['intFormID']; if ($prmFormID > 0) { $prmFormName = Lookup("Forms", "intFormID", "strName", $prmFormID); } $prmColumnFormat = $dbMedia->RowData['intColumnFormat']; $prmMediaFile = $dbMedia->RowData['strMediaFile']; $prmASINs = $dbMedia->RowData['txtASINs']; $prmImageFile = $dbMedia->RowData['strImageFile']; $prmLargeImage = $dbMedia->RowData['strLargeImage']; $prmHTML = $dbMedia->RowData['bitHTML']; $prmSKU = $dbMedia->RowData['strSKU']; $prmPrice = $dbMedia->RowData['mnyPrice']; $prmIntlPrice = $dbMedia->RowData['mnyIntlPrice']; $prmEcommerce = $dbMedia->RowData['bitEcommerce']; $prmShortDesc = $dbMedia->RowData['txtShortDesc']; $prmPubDate = $dbMedia->RowData['dtmPubDate']; $prmFirstName = $dbMedia->RowData['strFirstName']; $prmLastName = $dbMedia->RowData['strLastName']; $prmAuthorBio = $dbMedia->RowData['txtFullBio']; $prmMediaCrumb = $dbMedia->RowData['strCrumbText']; $prmLayoutID = $dbMedia->RowData['intLayoutID']; $prmCurrentMetaKeywords = $dbMedia->RowData['txtMetaTags']; $prmCurrentMetaDescription = $dbMedia->RowData['txtMetaDescription']; $prmCurrentFriendlyURL = $dbMedia->RowData['strFriendlyURL']; $prmCurrentTitleTag = $dbMedia->RowData['strTitleTag']; $prmVideoLink = $dbMedia->RowData['strVideoLink']; $prmThumbnail = $dbMedia->RowData['strThumbnail']; $prmDek = strip_tags($dbMedia->RowData['txtDek'], '
'); $prmTagList = $dbMedia->RowData['txtTags']; $prmDisplayDate = strToUpper(date('F',strtotime($prmPubDate))) . ' ' . strToUpper(date('j',strtotime($prmPubDate))) . ', ' . strToUpper(date('Y',strtotime($prmPubDate))); if (strlen($prmTagList) > 0) { $prmCurrentTag = $prmTagList; $prmCurrentTag = str_replace(',,', ',', $prmCurrentTag); $prmCurrentTag = str_replace(', ', ',', $prmCurrentTag); $prmCurrentTag = str_replace(' ,', ',', $prmCurrentTag); $prmCurrentTag = trim(strtoupper($prmCurrentTag)); $strTagList = ''; $strKeywords = explode(',', $prmCurrentTag); $intArrayCount = count($strKeywords); if ($intArrayCount > 0) { asort($strKeywords); for ($i=0; $i<=$intArrayCount - 1; $i++) { if (strlen($strTagList) > 2 and strlen($strKeywords[$i]) > 1) { $strCommaValue = ', '; } else { $strCommaValue = ''; } $strTagList = $strTagList . $strCommaValue . '' . $strKeywords[$i] . ''; } } } } } $prmDisplayCrumb = 1; $prmDisplayPrint = 1; $prmPrintLink = $appRootURL . '/printmedia.php/prmMediaID/' . $prmMID; $prmPageTitle = strip_tags( $prmMediaTitle ); $strSQL="SELECT * from Codes where intCodeID = " . $prmMediaTypeID; $db->query(stripslashes($strSQL)); if ($db->ReadRow()) { if (strlen($db->RowData["strImage"]) > 0) { $prmBannerImage = '/images/codes/' . $db->RowData["strImage"]; } else { $prmBannerImage = '/images/imgBannerHome.jpg'; } if (strlen($db->RowData["strImageTagline"]) > 0) { $prmTagline = '/images/codes/' . $db->RowData["strImageTagline"]; } else { $prmTagline = '/images/imgMissionStatement.jpg'; } if (strlen($db->RowData["strImageLeftNavOn"]) > 0) { $prmHeaderButton = '/images/codes/' . $db->RowData["strImageLeftNavOn"]; if ($prmOverrideHeader > 0) { $prmHeaderButton = '/images/codes/' . Lookup("Codes", "intCodeID", "strImageLeftNavOn", $prmOverrideHeader); } } else { $prmHeaderButton = ''; } $prmMetaTags = $db->RowData['txtMetaTags']; $prmMetaDescription = $db->RowData['txtMetaDescription']; } else { $prmBannerImage = '/images/imgBannerHome.jpg'; $prmTagline = '/images/imgMissionStatement.jpg'; $prmHeaderButton = ''; $prmMetaTags = ''; $prmMetaDescription = ''; } if (strlen($prmCurrentMetaKeywords) > 0) { $prmMetaKeywords = $prmCurrentMetaKeywords; } if (strlen($prmCurrentMetaDescription) > 0) { $prmMetaDescription = $prmCurrentMetaDescription; } if (strlen($prmDOSDMetaKeywords) > 0) { $prmMetaKeywords = $prmDOSDMetaKeywords; } if (strlen($prmDOSDMetaDescription) > 0) { $prmMetaDescription = $prmDOSDMetaDescription; } include '_incHTMLHeaders.php'; include '_incPageHead.php'; if ($prmColumnFormat == 0) { include '_incLeftNavigation.php'; } if ($prmMID == 4929) { //Mourning Roundup include 'mappopup.php'; }else{ if ($prmColumnFormat == 0) { include '_incCenterContent.php'; } else { include '_incCenterOneColumn.php'; } include '_incRightContent.php'; } include '_incHTMLFooters.php'; ?>