public function parseInTextLinking($curSiteInhalt) { if (!checkIsUserLogedIn()) { // @[art:seite][id:1] $pattern = '/@\\[art:([^\\]]+)\\]\\[id:(\\d+)\\]/'; $count = preg_match_all($pattern, $curSiteInhalt, $matches, PREG_SET_ORDER); foreach ($matches as $match) { $patternR = '/@\\[art:' . $match[1] . '\\]\\[id:' . $match[2] . '\\]/'; $replacement = $this->buildNewInTextLink($match); $curSiteInhalt = preg_replace($patternR, $replacement, $curSiteInhalt); } } return $curSiteInhalt; //.'<pre>'.print_r($matches, 1).'</pre>'.$code; }
<?php session_start(); header('Content-Type: text/html; charset=utf-8'); /********************************************************************* * * * * * Erstellungsjahr: 2014 * * * * * *********************************************************************/ // Prüfen ob User angemeldet ist // ***************************************************************************** require_once '../../../inc/check.inc.php'; if (!checkIsUserLogedIn()) { exit; } // Benötigte Files einbinden // ***************************************************************************** require_once '../../../inc/db_connect.inc.php'; require_once '../../../inc/functionsAll.inc.php'; require_once '../../inc/klassen/empfehlungsManager.inc.php'; if (isset($_POST['_art']) && !empty($_POST['_art'])) { switch ($_POST['_art']) { // Zeigt das Empfehlungs Manager Admin Window an // ************************************************************************* case 'showEmpfehlungsmanagerAdminWindow': $curEmpfehlungClassObj = new cmsEmpfehlungsManagerAdmin(); echo $curEmpfehlungClassObj->showEmpfehlungsmanagerAdminWindow(); break; // Zeigt den Inhalt vom Empfehlungs Manager Admin Window an (Reload)
private function buildEigenElementText($textNum, $text, $siteElementArr, $curArrOrigLang) { $noOutlineClass = ''; if (isset($this->areElementsInherit) && $this->areElementsInherit == true) { $noOutlineClass = ' vCmsShowNoOutlineImportant'; } if (isset($text) && $text == '[vcms-empty-lang]') { $text = $curArrOrigLang['elemText' . $textNum]; } $return = '<div class="vFrontOwnElemTextHolder' . $noOutlineClass . '" data-id="' . $siteElementArr['selemID'] . '" data-num="' . $textNum . '">'; if (checkIsUserLogedIn() && checkIndividualUserRechtChange() && $this->areElementsInherit == false) { $return .= '<div class="vSiteElemTextOwnBearLeiste"> <div class="vSiteElemTextOwnBearLeisteUe">Textfeld</div> <div class="vSiteElemTextOwnBearLeisteChange" title="Bearbeiten" data-id="' . $siteElementArr['selemID'] . '" data-num="' . $textNum . '"></div> <div class="vSiteElemTextOwnBearLeisteSave" title="Speichern" data-id="' . $siteElementArr['selemID'] . '" data-num="' . $textNum . '"></div> <div class="vSiteElemTextOwnBearLeisteCancel" title="Abbrechen"></div> </div>'; } $return .= '<div class="vFrontOwnElemTextInner">' . $text . '</div>'; $return .= '</div>'; return $return; }
private function parseTextByHaswh($text) { if (checkIsUserLogedIn()) { return $text; } preg_match_all("/(#\\w+)/", $text, $texts); $langId = $this->getCurentLangIdFromUrlName($_GET['_lang']); if (!empty($texts[0])) { foreach ($texts[0] as $key => $value) { $hash = $value; $query = mysql_query("SELECT * FROM time_hash WHERE name ='{$hash}'"); $row = mysql_fetch_array($query); $idHash = $row['id_hash']; $currentDate = date('Y-m-d H:i:s'); $currenTime = date('H:i a'); $query = mysql_query("SELECT * FROM `times` WHERE id_th='{$idHash}' AND from_date<='{$currentDate}' AND to_date >='{$currentDate}' AND option_time=2 LIMIT 1"); if (mysql_num_rows($query)) { $row = mysql_fetch_array($query); $idTime = $row['id_t']; $query = mysql_query("SELECT * FROM `time_hash_texts` WHERE id_time_ht='{$idTime}' AND id_lang='{$langId}' LIMIT 1"); $row = mysql_fetch_array($query); $replaceText = $row['title']; $text = str_replace($value, $replaceText, $text); } else { if (date('G') > 21 && date('G') < 24) { $query = mysql_query("SELECT * FROM `times` WHERE id_th='{$idHash}' AND DATE_FORMAT(time_only,'%H:%i%p')<='{$currenTime}' AND DATE_FORMAT(time_to,'%H:%i%p') <'{$currenTime}' AND option_time=1 order BY time_only desc LIMIT 1"); } elseif (date('G') >= 0 && date('G') <= 6) { // $query = mysql_query("SELECT * FROM `times` WHERE id_th='$idHash' AND DATE_FORMAT(time_to,'%H:%i%p') >='0:00' AND DATE_FORMAT(time_to,'%H:%i%p') <='6:00' AND option_time=1 order BY time_only desc LIMIT 1"); $query = mysql_query("SELECT * FROM `times` WHERE id_t='60' "); if ($_GET['test'] == 1) { while ($row7 = mysql_fetch_assoc($query)) { print_r($row7); } echo "SELECT * FROM `times` WHERE id_th='{$idHash}' AND DATE_FORMAT(time_to,'%H:%i%p') >='0:00' AND DATE_FORMAT(time_to,'%H:%i%p') <='6:00' AND option_time=1 order BY time_only desc LIMIT 1"; die; } } else { $query = mysql_query("SELECT * FROM `times` WHERE id_th='{$idHash}' AND DATE_FORMAT(time_only,'%H:%i%p')<='{$currenTime}' AND DATE_FORMAT(time_to,'%H:%i%p') >='{$currenTime}' AND option_time=1 LIMIT 1"); } $row = mysql_fetch_array($query); $idTime = $row['id_t']; if ($_GET['test'] == 1) { print_r($row); echo $idTime; } $query = mysql_query("SELECT * FROM `time_hash_texts` WHERE id_time_ht='{$idTime}' AND id_lang='{$langId}' LIMIT 1"); $row = mysql_fetch_array($query); $replaceText = $row['title']; $text = str_replace($value, $replaceText, $text); } } } return $text; }
public function getCmsSiteDataArray() { global $hpCms; $return = array(); $idlang = $curLangId = $this->getCurentLangIdFromUrlName($_GET['_lang']); if (isset($_GET['page_name']) && !empty($_GET['page_name'])) { $query = mysql_query('SELECT seitID FROM vseitelang WHERE seitlaTextUrl = "' . $this->dbDecode($_GET['page_name']) . '" AND langID="' . $idlang . '" LIMIT 1'); if (mysql_num_rows($query) > 0) { $row = mysql_fetch_array($query); $idSite = $row['seitID']; $sqlDataText = 'SELECT * FROM vseiten WHERE seitID = ' . $idSite . ' LIMIT 1'; } else { $sqlDataText = 'SELECT * FROM vseiten WHERE seitTextUrl = "' . $this->dbDecode($_GET['page_name']) . '" LIMIT 1'; } } else { $sqlDataText = 'SELECT * FROM vseiten WHERE seitID = ' . $this->dbDecode($hpCms['hp_SeitStart']) . ' LIMIT 1'; } $sqlDataErg = $this->dbAbfragen($sqlDataText); $hans = 0; $curSiteIdWeiter = ''; $idlang = $curLangId = $this->getCurentLangIdFromUrlName($_GET['_lang']); while ($rowData = mysql_fetch_array($sqlDataErg, MYSQL_ASSOC)) { if ($this->checkIfActiveSiteLang($rowData['seitID'], $idlang)) { // Für Seite Online oder Offline // *********************************************************************** if (!checkIsUserLogedIn() && !isset($_GET['isCmsSeoImportTitle']) && !isset($_GET['isCmsSeoImportDesc'])) { if (isset($rowData['seitID']) && !empty($rowData['seitID'])) { if ($this->checkIsThisSiteOnlineByCheckAndDateTimeMM($rowData['seitID']) == false) { if (isset($_GET['_lang']) && !empty($_GET['_lang'])) { header('Location: /' . $_GET['_lang'] . ''); exit; } header('Location: /'); exit; } } } // *********************************************************************** $_SESSION['VCMS_CUR_CMS_SITE_SESSION'] = $rowData['seitID']; $return['cms_siteID'] = $rowData['seitID']; $return['cms_siteArt'] = $rowData['seitArt']; $return['cms_siteCreateDate'] = $rowData['seitCreateDate']; $return['cms_siteOnline'] = $rowData['seitOnline']; $return['cms_siteName'] = $rowData['seitName']; $return['cms_siteTextUrl'] = $rowData['seitTextUrl']; $return['cms_siteParent'] = $rowData['seitParent']; $return['cms_sitePosition'] = $rowData['seitPosition']; $return['cms_siteNartID'] = $rowData['nartID']; $return['cms_siteLayID'] = $rowData['layID']; $return['cms_siteMetaTitle'] = $rowData['seitMetaTitle']; $return['cms_siteMetaKeywords'] = $rowData['seitMetaKeywords']; $return['cms_siteMetaDesc'] = $rowData['seitMetaDesc']; $return['cms_siteBackImages'] = $rowData['seitBackImages']; $return['cms_siteListImage'] = $rowData['seitListImage']; $return['cms_siteSlideImages'] = $rowData['seitSlideImages']; $return['cms_siteCanonical'] = $rowData['seitCanonical']; $return['cms_siteNoIndex'] = $rowData['seitNoIndex']; // Shop Modul Produkte Ausgaben // ******************************************************* if ($this->checkIsShopModulActiv()) { $return['cms_shopProducts'] = array(); $return['cms_shopProducts'] = $this->buildShopModulPrSiteArray($rowData['seitProdukte']); } // ******************************************************* // Seitenfelder Ausgaben // ******************************************************* $return['cms_ownFields'] = array(); $return['cms_ownFields'] = $this->buildTheCurSeitenfelderInArray($rowData); // ******************************************************* $curSiteIdWeiter = $rowData['seitID']; $hans++; } } if ($hans == 0) { if (isset($_GET['_lang']) && !empty($_GET['_lang'])) { header('Location: /' . $_GET['_lang'] . ''); exit; } header('Location: /'); exit; } else { if ($hans == 1) { if (isset($_GET['page_name']) && !empty($_GET['page_name']) && $return['cms_siteID'] == $hpCms['hp_SeitStart']) { if (isset($_GET['_lang']) && !empty($_GET['_lang'])) { header('Location: /' . $_GET['_lang'] . ''); exit; } header('Location: /'); exit; } } } if (isset($curSiteIdWeiter) && !empty($curSiteIdWeiter)) { if (isset($_POST['VCMS_POST_LANG']) && !empty($_POST['VCMS_POST_LANG'])) { $curLangId = $this->getCurentLangIdFromUrlName($_POST['VCMS_POST_LANG']); $sqlDataLText = 'SELECT * FROM vseitelang WHERE langID = ' . $this->dbDecode($curLangId) . ' AND seitID = ' . $this->dbDecode($curSiteIdWeiter) . ' LIMIT 1'; $sqlDataLErg = $this->dbAbfragen($sqlDataLText); while ($rowDataL = mysql_fetch_array($sqlDataLErg, MYSQL_ASSOC)) { $return['cms_langArr'] = array(); $return['cms_langArr']['cms_siteName'] = $rowDataL['seitlaName']; $return['cms_langArr']['cms_siteMetaTitle'] = $rowDataL['seitlaMetaTitle']; $return['cms_langArr']['cms_siteMetaKeywords'] = $rowDataL['seitlaMetaKeywords']; $return['cms_langArr']['cms_siteMetaDesc'] = $rowDataL['seitlaMetaDesc']; $return['cms_langArr']['cms_siteCanonical'] = $rowDataL['seitlaCanonical']; $return['cms_langArr']['cms_siteNoIndex'] = $rowDataL['seitlaNoIndex']; } } } return $return; }
public function getAllBlogCommentsFromSite($siteID) { $return = ''; $sqlText = 'SELECT * FROM vkommentare WHERE seitID = "' . $this->dbDecode($siteID) . '" AND komAktiv = 2 ORDER BY komDate DESC'; $sqlErg = $this->dbAbfragen($sqlText); while ($row = mysql_fetch_array($sqlErg, MYSQL_ASSOC)) { $curZwArr = explode(' ', $row['komDate']); $curDateZwArr = explode('-', $curZwArr[0]); $curTimeZwArr = explode(':', $curZwArr[1]); $curDate = $curDateZwArr[2] . '.' . $curDateZwArr[1] . '.' . $curDateZwArr[0]; $curTime = $curTimeZwArr[0] . ':' . $curTimeZwArr[1]; $return .= '<div class="blogSysCommentElement"> <div class="blogSysCommentElementHead"> <div class="blogSysCommentElementHeadName">' . $row['komName'] . ' schrieb am ' . $curDate . ' um ' . $curTime . ' Uhr</div>'; if (checkIsUserLogedIn()) { $return .= '<div class="blogSysCommentElementHeadDel" title="Kommentar Löschen" data-id="' . $row['komID'] . '"></div>'; } $return .= '<div class="clearer"></div> </div> <div class="blogSysCommentElementText">' . nl2br($row['komText']) . '</div> </div>'; } return $return; }