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;
}
