$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)) {