$tag_tags[] = array('name' => $row2['name'], 'link' => $tagLink, 'href' => '<a href="' . $tagLink . '">' . $row2['name'] . '</a>');
} else {
if ($row2['type'] == 'category') {
$allCategories[] = array('name' => $row2['name'], 'link' => $categoryLink, 'href' => '<a href="' . $categoryLink . '">' . $row2['name'] . '</a>');
$category_tags[] = array('name' => $row2['name'], 'link' => $categoryLink, 'href' => '<a href="' . $categoryLink . '">' . $row2['name'] . '</a>');
}
}
}
$date = $row['language'] == 'de' ? date('d.m.Y', strtotime($row['date'])) : date('m.d.Y', strtotime($row['date']));
if ($row['comments'] == 'Y') {
$query3->execute(array($row['textID']));
$commentCount = $query3->fetchColumn();
} else {
$commentCount = 0;
}
$news[] = array('date' => $date, 'title' => $page_title, 'text' => $page_text, 'href' => $href, 'link' => $link, 'tags' => $tag_tags, 'categories' => $category_tags, 'comments' => $row['comments'], 'commentCount' => $commentCount, 'authorname' => $row['authorname']);
}
$paginationLink = $page_data->seo == 'Y' ? $page_url . '/' . $user_language . '/' . szrp($gsprache->news) . '/' . szrp($page_sprache->older) . '/' : $page_url . '/index.php?site=news&start=';
// https://github.com/easy-wi/developer/issues/62
$langLinks = array();
foreach ($languages as $l) {
$tempLanguage = getlanguagefile('general', $l, 0);
$langLinks[$l] = $page_data->seo == 'Y' ? szrp($tempLanguage->news) : '?s=news';
}
$page_data->langLinks($langLinks);
$page_data->title = $gsprache->news;
$page_data->setCanonicalUrl($s);
$template_file = 'page_news.tpl';
}
}
}
$released = $row['released'] == 1 ? $gsprache->yes : $gsprache->no;
$query2->execute(array($row['authorid'], $resellerLockupID));
while ($row2 = $query2->fetch(PDO::FETCH_ASSOC)) {
$author = (($row2['name'] == '' or $row2['name'] == null) and ($row2['vname'] == '' or $row2['vname'] == null)) ? $row2['cname'] : $row2['vname'] . ' ' . $row2['name'];
}
unset($p_languages);
$query3->execute(array($row['id'], $resellerLockupID));
while ($row3 = $query3->fetch(PDO::FETCH_ASSOC)) {
$p_languages[] = $row3['language'];
}
if (($row['title'] == null or $row['title'] == '') and isset($p_languages[0])) {
$query4->execute(array($row['id'], $p_languages[0], $resellerLockupID));
$page_title = $query4->fetchColumn();
} else {
if ($row['title'] == null or $row['title'] == '') {
$page_title = '';
$p_languages = array();
}
}
if ($row['subpage'] != $row['id']) {
$page_title = ' - ' . $page_title;
}
$link = $seo == 'N' ? $page_url . '/index.php?site=page&id=' . $row['id'] : $page_url . '/' . $row['language'] . '/' . strtolower(szrp($row['title'])) . '/';
$date = $user_language == 'de' ? date('d.m.Y H:m:s', strtotime($row['date'])) : $row['date'];
$table[] = array('id' => $row['id'], 'author' => $author, 'date' => $date, 'released' => $released, 'title' => $page_title, 'link' => $link, 'languages' => $p_languages, 'sort' => $row['sort']);
}
configureDateTables('-1, -2', '1, "asc"');
$template_file = 'admin_page_pages_list.tpl';
}
}
}
$array['iTotalDisplayRecords'] = $array['iTotalRecords'];
}
$orderFields = array(0 => 't.`title`', 1 => 'c.`commentID`', 2 => 'c.`authorname`', 3 => 'c.`date`', 4 => 'c.`moderateAccepted`', 5 => 'c.`markedSpam`');
if (isset($orderFields[$iSortCol]) and is_array($orderFields[$iSortCol])) {
$orderBy = implode(' ' . $sSortDir . ', ', $orderFields[$iSortCol]) . ' ' . $sSortDir;
} else {
if (isset($orderFields[$iSortCol]) and !is_array($orderFields[$iSortCol])) {
$orderBy = $orderFields[$iSortCol] . ' ' . $sSortDir;
} else {
$orderBy = 'c.`commentID` DESC';
}
}
$query = $sql->prepare("SELECT `seo` FROM `page_settings` WHERE `resellerid`=? LIMIT 1");
$query->execute(array($resellerLockupID));
$seoActive = $query->fetchColumn();
if ($sSearch) {
$query = $sql->prepare("SELECT t.`pageid`,t.`language`,t.`title`,c.`commentID`,c.`date`,c.`authorname`,c.`markedSpam`,c.`moderateAccepted` FROM `page_comments` c LEFT JOIN `page_pages_text` t ON c.`pageTextID`=t.`id` WHERE c.`resellerID`=:reseller_id AND (t.`title` LIKE :search OR c.`commentID` LIKE :search OR c.`authorname` LIKE :search OR c.`date` LIKE :search {$statusQuery}) ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}");
$query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID));
} else {
$query = $sql->prepare("SELECT t.`pageid`,t.`language`,t.`title`,c.`commentID`,c.`date`,c.`authorname`,c.`markedSpam`,c.`moderateAccepted` FROM `page_comments` c LEFT JOIN `page_pages_text` t ON c.`pageTextID`=t.`id` WHERE c.`resellerID`=? ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}");
$query->execute(array($resellerLockupID));
}
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
if (!isset($titleLanguages[$row['language']])) {
$titleLanguages[$row['language']] = array('page' => getlanguagefile('page', $row['language'], 0), 'general' => getlanguagefile('general', $row['language'], 0));
}
$moderated = $row['moderateAccepted'] == 'N' ? $gsprache->yes : $gsprache->no;
$spam = $row['markedSpam'] == 'Y' ? $gsprache->yes : $gsprache->no;
$link = $seoActive == 'N' ? $page_url . '/index.php?site=news&id=' . $row['pageid'] : $page_url . '/' . $row['language'] . '/' . szrp($titleLanguages[$row['language']]['general']->news) . '/' . szrp($row['title']) . '/';
$array['aaData'][] = array('<a href="' . $link . '" target="_blank">' . $row['title'] . '</a>', $row['commentID'], $row['authorname'], $row['date'], (string) $moderated, (string) $spam, returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'pc', 'dl', $row['commentID'], $gsprache->del) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_md.tpl', 'pc', 'md', $row['commentID'], $gsprache->mod));
}
$steamAppIDs = '';
if ($row['steamFeeds'] == 'Y') {
$steamAppIDsArray = array();
$query2 = $sql->prepare("SELECT t.`appID`,t.`shorten` FROM `servertypes` AS t WHERE t.`resellerid`=? AND t.`steamgame`='S' AND EXISTS (SELECT 1 FROM `rservermasterg` WHERE `servertypeid`=t.`id`)");
$query2->execute(array($reseller_id));
while ($row2 = $query2->fetch(PDO::FETCH_ASSOC)) {
$steamAppIDsArray[] = workAroundForValveChaos($row2['appID'], $row2['shorten']);
}
$steamAppIDs = count($steamAppIDsArray) > 0 ? ' OR (n.`feedID`=0 AND n.`content` IN (' . implode(',', $steamAppIDsArray) . '))' : '';
}
$query2 = $sql->prepare("(SELECT 'cms' AS `newsType`,p.`id` AS `newsID`,p.`date` AS `newsDate`,t.`id` AS `textID`,t.`title` AS `newsTitle`,t.`text` AS `newsText`,'' AS `twitterText`,'' AS `feedUrl`,'N' AS `twitter`,'' AS `loginName`,'' AS `link` FROM `page_pages` p LEFT JOIN `page_pages_text` t ON p.`id`=t.`pageid` WHERE p.`released`='1' AND p.`type`='news' AND t.`language`=:lang AND p.`resellerid`=0) UNION (SELECT 'feed' AS `newsType`,u.`feedID` AS `newsID`,n.`pubDate` AS `newsDate`,0 AS `textID`,n.`title` AS `newsTitle`,n.`content` AS `newsText`,n.`description` AS `twitterText`,u.`feedUrl`,u.`twitter`,u.`loginName`,n.`link` FROM `feeds_news` n LEFT JOIN `feeds_url` u ON n.`feedID`=u.`feedID` WHERE n.`resellerID`=:resellerID AND n.`active`='Y' AND (u.`active`='Y' {$steamAppIDs})) ORDER BY `newsDate` DESC LIMIT 0,{$newsAmount}");
$query2->execute(array(':lang' => $user_language, ':resellerID' => $row['resellerID']));
while ($row2 = $query2->fetch(PDO::FETCH_ASSOC)) {
if ($row2['newsType'] == 'cms') {
$url = $page_url;
$link = (isset($seo) and $seo == 'Y') ? $page_url . '/' . $user_language . '/' . szrp($gsprache->news) . '/' . szrp($row2['newsTitle']) . '/' : $page_url . '/index.php?site=news&id=' . $row2['newsID'];
$text = nl2br($row2['newsText']);
} else {
$url = $row2['twitter'] == 'N' ? $row2['feedUrl'] : 'https://twitter.com/' . $row2['loginName'];
$link = $row2['link'];
if ($row['displayContent'] == 'Y' and $row['limitDisplay'] == 'Y' and $row2['twitter'] == 'N') {
$text = substr(preg_replace('/<(.*?)>/', '', preg_replace('/<*?[^<>]*?>(.*?)<\\/*?>/', '$1', $row2['newsText'], -1), -1), 0, $row['maxChars']);
} else {
if ($row['displayContent'] == 'Y' and $row['limitDisplay'] == 'N' and $row2['twitter'] == 'N') {
$text = $row2['newsText'];
} else {
if ($row['displayContent'] == 'N' and $row['limitDisplay'] == 'Y' and $row2['twitter'] == 'N') {
$text = substr(preg_replace('/<(.*?)>/', '', preg_replace('/<*?[^<>]*?>(.*?)<\\/*?>/', '$1', $row2['twitterText'], -1), -1), 0, $row['maxChars']);
} else {
$text = $row2['twitterText'];
}
$resellerid = 0;
} else {
if (isset($reseller_id)) {
$resellerid = $reseller_id;
} else {
$resellerid = 0;
}
}
$query = $sql->prepare("SELECT `imprint` FROM `imprints` WHERE language=? AND resellerid=? LIMIT 1");
$query->execute(array($user_language, $resellerid));
$imprint = $query->fetchColumn();
if ($imprint != '') {
$query = $sql->prepare("SELECT `language` FROM `settings` WHERE `resellerid`=? LIMIT 1");
$query->execute(array($resellerid));
$defaultlanguage = $query->fetchColumn();
$query = $sql->prepare("SELECT `imprint` FROM `imprints` WHERE language=? AND resellerid=? LIMIT 1");
$query->execute(array($defaultlanguage, $resellerid));
$imprint = $query->fetchColumn();
}
if (isset($page_data)) {
$page_data->setCanonicalUrl($s);
$page_data->title = $gsprache->imprint;
// https://github.com/easy-wi/developer/issues/62
$langLinks = array();
foreach ($languages as $l) {
$tempLanguage = getlanguagefile('general', $l, 0);
$langLinks[$l] = $page_data->seo == 'Y' ? szrp($tempLanguage->{$s}) : '?s=' . $s;
}
$page_data->langLinks($langLinks);
}
$template_file = "imprint.tpl";
} else {
$older = $page_url . '/index.php?site=' . $s . '&tag=' . strtolower(szrp($row2['name'])) . '&older=2';
}
}
}
if (isset($page_count) and $page_count > 1 and $seo == 'Y') {
$newer = $page_url . '/' . $user_language . '/' . $page_sprache->{$s} . '/' . $search_tag . '/' . ($page_count - 1) . '/';
} else {
if (isset($page_count) and $page_count > 1 and $seo == 'N') {
$newer = $page_url . '/index.php?site=' . $s . '&tag=' . strtolower(szrp($row2['name'])) . '&older=' . ($page_count - 1);
}
}
$query = $sql->prepare("SELECT p.`id`,p.`date`,p.`type`,t.`title`,t.`text` FROM `page_terms_used` u LEFT JOIN `page_pages_text` t ON u.`language_id`=t.`id` AND t.`language`=? LEFT JOIN `page_pages` p ON u.`page_id`=p.`id` AND (p.`type`='page' OR p.`type`='news') WHERE t.`title` IS NOT NULL AND t.`text` IS NOT NULL AND t.`title`!='' AND t.`text`!='' AND u.`term_id`=? AND u.`resellerid`='0' ORDER BY p.`id` DESC LIMIT {$limit}");
$query->execute(array($user_language, $row['id']));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
if ($seo == 'Y') {
$type = '';
if ($row['type'] == 'news') {
$type = szrp($gsprache->news) . '/';
}
$row_link = $page_url . '/' . $user_language . '/' . $type . szrp($row['title']) . '/';
} else {
$row_link = $page_url . '/index.php?site=' . $row['type'] . '&id=' . $row['id'];
}
$table[] = array('title' => $row['title'], 'text' => nl2br($row['text']), 'link' => $row_link, 'date' => $row['date']);
}
$template_file = 'page_tag.tpl';
}
} else {
redirect($page_url);
}
function returnRating($value, $exact = false)
{
global $sql, $newssidebar_textlength, $page_data, $results, $seo;
$query = $sql->prepare("SELECT t.`id`,p.`id` AS `pageID`,p.`type`,t.`shortlink`,t.`title`,t.`text`,t.`language` FROM `page_pages` p LEFT JOIN `page_pages_text` t ON p.`id`=t.`pageid` WHERE p.`released`=1 AND p.`resellerid`=0 AND (LOWER(t.`shortlink`) LIKE :search OR LOWER(t.`title`) LIKE :search OR LOWER(t.`text`) LIKE :search)");
$query->execute(array(':search' => '%' . $value . '%'));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
if (!isset($titleLanguages[$row['language']])) {
$titleLanguages[$row['language']] = array('page' => getlanguagefile('page', $row['language'], 0), 'general' => getlanguagefile('general', $row['language'], 0));
}
$text = strlen($row['text']) <= $newssidebar_textlength ? $row['text'] : substr($row['text'], 0, $newssidebar_textlength) . ' ...';
$title = $row['title'];
if ($row['type'] == 'news' and isset($seo) and $seo == 'Y') {
$type = (string) $titleLanguages[$row['language']]['general']->news;
$link = $page_data->pageurl . '/' . $row['language'] . '/' . szrp($titleLanguages[$row['language']]['general']->news) . '/' . szrp($row['title']) . '/';
} else {
if ($row['type'] == 'news') {
$type = (string) $titleLanguages[$row['language']]['general']->news;
$link = $page_data->pageurl . '?s=news&l=' . $row['language'] . '&id=' . $row['pageID'];
} else {
if ($row['type'] == 'page' and isset($seo) and $seo == 'Y') {
$type = (string) $titleLanguages[$row['language']]['general']->page;
$link = $page_data->pageurl . '/' . $row['language'] . '/' . szrp($row['title']) . '/';
} else {
if ($row['type'] == 'page') {
$type = (string) $titleLanguages[$row['language']]['general']->page;
$link = $page_data->pageurl . '?s=page&l=' . $row['language'] . '&id=' . $row['pageID'];
} else {
if ($row['type'] == 'about' and isset($seo) and $seo == 'Y') {
$type = (string) $titleLanguages[$row['language']]['page']->about;
$title = (string) $titleLanguages[$row['language']]['page']->about;
$link = $page_data->pageurl . '/' . $row['language'] . '/' . szrp($titleLanguages[$row['language']]['page']->about) . '/';
} else {
if ($row['type'] == 'about') {
$type = (string) $titleLanguages[$row['language']]['page']->about;
$title = (string) $titleLanguages[$row['language']]['page']->about;
$link = $page_data->pageurl . '/?s=news&l=' . $row['language'];
}
}
}
}
}
}
if (!isset($link)) {
$link = '#';
}
if ($exact == true) {
$worth = substr_count(strtolower($row['title']), strtolower($value)) * 16;
$worth += substr_count(strtolower($row['text']), strtolower($value)) * 2;
} else {
$worth = substr_count(strtolower($row['title']), strtolower($value)) * 12;
$worth += substr_count(strtolower($row['text']), strtolower($value));
}
$href = '<a href="' . $link . '" title="' . $title . '">' . $title . '</a>';
if (isset($results[$row['id']])) {
$oldWorth = $results[$row['id']]['worth'];
$hits = $results[$row['id']]['hits'];
$hits[] = $value;
$hits = array_unique($hits);
$worth += $oldWorth;
unset($results[$row['id']]);
} else {
$hits = array($value);
}
$results[$row['id']] = array('textID' => $row['id'], 'pageID' => $row['pageID'], 'language' => $row['language'], 'type' => $type, 'worth' => $worth, 'href' => $href, 'title' => $title, 'link' => $link, 'text' => str_replace('%url%', $page_data->pageurl, $text), 'hits' => $hits);
}
return $results;
}
if ($page_category == szrp($page_sprache->sitemap)) {
$s = 'sitemap';
} else {
if ($page_category == szrp($page_sprache->search)) {
$s = 'search';
} else {
if ($page_category == szrp($page_sprache->gallery)) {
$s = 'gallery';
} else {
if ($page_category == szrp($page_sprache->sitemap)) {
$s = 'sitemap';
} else {
if ($page_category == szrp($page_sprache->search)) {
$s = 'search';
} else {
if ($page_category == szrp($page_sprache->register)) {
$s = 'register';
} else {
if (isset($page_data->pages_array['pages']) and in_array($page_category, $page_data->pages_array['pages'])) {
$s = 'page';
} else {
if (isset($what_to_be_included_array[$page_category])) {
$s = $page_category;
} else {
if (isset($customFiles[$page_category])) {
$customModule = true;
$s = $page_category;
}
}
}
}
if (!isset($titleLanguages[$row['language']])) {
$titleLanguages[$row['language']] = array('page' => getlanguagefile('page', $row['language'], 0), 'general' => getlanguagefile('general', $row['language'], 0));
}
$released = $row['released'] == 1 ? $gsprache->yes : $gsprache->no;
$query2->execute(array($row['authorid'], $resellerLockupID));
while ($row2 = $query2->fetch(PDO::FETCH_ASSOC)) {
$author = (($row2['name'] == '' or $row2['name'] == null) and ($row2['vname'] == '' or $row2['vname'] == null)) ? $row2['cname'] : $row2['vname'] . ' ' . $row2['name'];
}
unset($p_languages);
$query3->execute(array($row['id'], $resellerLockupID));
while ($row3 = $query3->fetch(PDO::FETCH_ASSOC)) {
$p_languages[] = $row3['language'];
}
if (($row['title'] == null or $row['title'] == '') and isset($p_languages[0])) {
$query4->execute(array($row['id'], $p_languages[0], $resellerLockupID));
$page_title = $query4->fetchColumn();
} else {
if ($row['title'] == null or $row['title'] == '') {
$page_title = '';
$p_languages = array();
}
}
$link = $seo == 'N' ? $page_url . '/index.php?site=page&id=' . $row['id'] : $page_url . '/' . $row['language'] . '/' . szrp($titleLanguages[$row['language']]['general']->news) . '/' . strtolower(szrp($row['title'])) . '/';
$date = $user_language == 'de' ? date('d.m.Y H:m:s', strtotime($row['date'])) : $row['date'];
$table[] = array('id' => $row['id'], 'author' => $author, 'date' => $date, 'released' => $released, 'title' => $page_title, 'link' => $link, 'languages' => $p_languages);
}
configureDateTables('-1, -2', '1, "asc"');
$template_file = 'admin_page_news_list.tpl';
}
}
}
$connectedUsers[$row['id']] = $username . ' (' . $row['mail'] . ')';
}
$connectedUserCount = count($connectedUsers);
$query = $sql->prepare("SELECT u.`sID`,u.`loginName`,CONCAT(u.`vname`,' ',u.`name`) AS `username` FROM `userdata_social_identities_substitutes` AS s INNER JOIN `userdata_substitutes` AS u ON u.`sID`=s.`userID` WHERE s.`serviceProviderID`=? AND s.`serviceUserID`=? AND u.`active`='Y'");
$query->execute(array($serviceProviderID, $userProfile->identifier));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$connectedSubstitutes[$row['sID']] = strlen(trim($row['username'])) > 0 ? trim($row['username']) . ' (' . $row['loginName'] . ')' : $row['loginName'];
}
$connectedSubstituteCount = count($connectedSubstitutes);
// no user has been found. Check if registration is allowed. If yes display registration form
if ($connectedUserCount == 0 and $connectedSubstituteCount == 0) {
if (isset($registration) and in_array($registration, array('A', 'M', 'D'))) {
$page_sprache = getlanguagefile('page', $user_language, 0);
$_SESSION['serviceProviderData']['userProfile'] = (array) $userProfile;
$_SESSION['serviceProviderData']['serviceProviderID'] = (string) $serviceProviderID;
$redirectURL = $seo == 'Y' ? $pageUrl . '/' . $user_language . '/' . szrp($page_sprache->register) . '/' : $pageUrl . '/index.php?site=register';
redirect($redirectURL);
}
// multiple active users are connected, let the user pick one
} else {
if ($connectedUserCount + $connectedSubstituteCount > 1) {
$sprache->multipleHelper = str_replace('%sp%', $serviceProvider, $sprache->multipleHelper);
$_SESSION['loginUserAllowed'] = $connectedUsers;
$_SESSION['loginSubstitutesAllowed'] = $connectedSubstitutes;
$include = 'login_mutiple.tpl';
// exactly one user connected, login
} else {
if ($connectedUserCount == 1 and $connectedSubstituteCount == 0) {
$query = $sql->prepare("SELECT `id`,`accounttype`,`cname`,`active`,`security`,`resellerid`,`mail`,`salt`,`externalID` FROM `userdata` WHERE `id`=? LIMIT 1");
$query->execute(array(key($connectedUsers)));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
