* Version 3 der Lizenz oder (nach Ihrer Wahl) jeder spaeteren
* veroeffentlichten Version, weiterverbreiten und/oder modifizieren.
*
* Easy-WI wird in der Hoffnung, dass es nuetzlich sein wird, aber
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!isset($admin_id) or $main != 1 or isset($admin_id) and !isanyadmin($admin_id) and !rsellerpermisions($admin_id) or !isset($pa)) {
header('Location: login.php');
die('No Access');
}
$sprache = getlanguagefile('search', $user_language, $reseller_id);
$results = array();
$gs = false;
$vs = false;
$vo = false;
$ad = false;
$im = false;
$ro = false;
$us = false;
$q = array();
$i = 0;
function theName($a, $b)
{
$name = ($a == ' ' or $a == '' or $a == null) ? $b : $a . ' (' . $b . ')';
return $name;
}
* der GNU General Public License, wie von der Free Software Foundation,
* Version 3 der Lizenz oder (nach Ihrer Wahl) jeder spaeteren
* veroeffentlichten Version, weiterverbreiten und/oder modifizieren.
*
* Easy-WI wird in der Hoffnung, dass es nuetzlich sein wird, aber
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!defined('AJAXINCLUDED')) {
die('Do not access directly!');
}
$sprache = getlanguagefile('web', $user_language, $resellerLockupID);
$maxVhost = 0;
$maxHDD = 0;
$webVhosts = 0;
$leftHDD = 0;
$totalHDD = 0;
$totalVhosts = 0;
$maxHDD = 1000;
$quotaActive = 'N';
$ownVhost = 'N';
$usageType = 'F';
$dns = array();
$phpConfigurationMaster = array();
$phpConfigurationVhost = new stdClass();
$query = $sql->prepare("SELECT m.`vhostTemplate`,m.`maxVhost`,m.`maxHDD`,m.`quotaActive`,m.`defaultdns`,m.`usageType`,m.`phpConfiguration`,(SELECT COUNT(v.`webVhostID`) AS `a` FROM `webVhost` AS v WHERE v.`webMasterID`=m.`webMasterID`) AS `totalVhosts`,(SELECT SUM(v.`hdd`) AS `a` FROM `webVhost` AS v WHERE v.`webMasterID`=m.`webMasterID`) AS `totalHDD` FROM `webMaster` AS m WHERE m.`webMasterID`=? AND m.`resellerID`=? LIMIT 1");
$query->execute(array($ui->id('id', 10, 'get'), $resellerLockupID));
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!isset($user_id) or $main != 1 or isset($user_id) and !$pa['voiceserver']) {
header('Location: userpanel.php');
die('No Access');
}
include EASYWIDIR . '/stuff/keyphrasefile.php';
include EASYWIDIR . '/stuff/methods/class_ts3.php';
include EASYWIDIR . '/stuff/methods/functions_ssh_exec.php';
include EASYWIDIR . '/stuff/methods/functions_ts3.php';
$sprache = getlanguagefile('voice', $user_language, $reseller_id);
$loguserid = $user_id;
$logusername = getusername($user_id);
$logusertype = 'user';
$logreseller = 0;
if (isset($admin_id)) {
$logsubuser = $admin_id;
} else {
if (isset($subuser_id)) {
$logsubuser = $subuser_id;
} else {
$logsubuser = 0;
}
}
if ($ui->st('d', 'get') == 'bu' and $ui->id('id', 10, 'get') and (!isset($_SESSION['sID']) or in_array($ui->id('id', 10, 'get'), $substituteAccess['vo']))) {
$id = $ui->id('id', 10, 'get');
$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));
}
$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';
}
}
}
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!isset($main) or $main != 1 or (!isset($user_id) or isset($user_id) and !$pa['restart'])) {
header('Location: userpanel.php');
die('No acces');
}
include EASYWIDIR . '/stuff/keyphrasefile.php';
include EASYWIDIR . '/stuff/methods/class_ftp.php';
include EASYWIDIR . '/stuff/methods/functions_gs.php';
include EASYWIDIR . '/stuff/methods/class_app.php';
if (isset($resellerLockupID)) {
$reseller_id = $resellerLockupID;
}
$sprache = getlanguagefile('gserver', $user_language, $reseller_id);
$loguserid = $user_id;
$logusername = getusername($user_id);
$logusertype = 'user';
$logreseller = 0;
if (isset($admin_id)) {
$logsubuser = $admin_id;
} else {
if (isset($subuser_id)) {
$logsubuser = $subuser_id;
} else {
$logsubuser = 0;
}
}
if ($ui->w('action', 4, 'post') and !token(true)) {
$template_file = $spracheResponse->token;
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!isset($admin_id) or $main != 1 or isset($admin_id) and !$pa['gimages']) {
header('Location: admin.php');
die('No acces');
}
include EASYWIDIR . '/third_party/gameq/GameQ.php';
include EASYWIDIR . '/stuff/keyphrasefile.php';
$sprache = getlanguagefile('images', $user_language, $resellerLockupID);
$rsprache = getlanguagefile('roots', $user_language, $resellerLockupID);
$gssprache = getlanguagefile('gserver', $user_language, $resellerLockupID);
$loguserid = $admin_id;
$logusername = getusername($admin_id);
$logusertype = 'admin';
if ($reseller_id == 0) {
$logreseller = 0;
$logsubuser = 0;
} else {
$logsubuser = isset($_SESSION['oldid']) ? $_SESSION['oldid'] : 0;
$logreseller = 0;
}
if ($ui->w('action', 4, 'post') and !token(true)) {
$token = token();
unset($header, $text);
$errors = array($spracheResponse->token);
$template_file = $ui->st('d', 'get') == 'ad' ? 'admin_images_add.tpl' : 'admin_images_md.tpl';
* Version 3 der Lizenz oder (nach Ihrer Wahl) jeder spaeteren
* veroeffentlichten Version, weiterverbreiten und/oder modifizieren.
*
* Easy-WI wird in der Hoffnung, dass es nuetzlich sein wird, aber
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
$pages = array();
if (!isurl($pageurl) or !isdomain($pageurl) and !isurl($pageurl)) {
$pageurl = $page_url;
}
$page_sprache = getlanguagefile('page', $user_language, 0);
$page_data = new PageSettings($user_language, $pageurl, $seo);
if (isset($page_active) and $page_active == 'Y') {
$easywiModules = array('gs' => true, 'ip' => true, 'ea' => true, 'my' => true, 'ro' => true, 'ti' => true, 'le' => true, 'vo' => true);
$customModules = array('gs' => array(), 'mo' => array(), 'my' => array(), 'ro' => array(), 'ti' => array(), 'us' => array(), 'vo' => array(), 'pa' => array());
$customFiles = array();
$what_to_be_included_array = array('news' => 'page_news.php', 'contact' => 'page_contact.php', 'page' => 'page_page.php', 'home' => 'page_page.php', 'about' => 'page_page.php', 'gallery' => 'page_page.php', 'sitemap' => 'page_page.php', 'search' => 'page_page.php', 'tag' => 'page_tag.php', 'categories' => 'page_tag.php', 'downloads' => 'page_download.php', 'protectioncheck' => 'protectioncheck.php', 'register' => 'page_register.php');
$query = $sql->prepare("SELECT * FROM `modules` WHERE `type` IN ('P','C')");
$query2 = $sql->prepare("SELECT `text` FROM `translations` WHERE `type`='mo' AND `transID`=? AND `lang`=? LIMIT 1");
$query->execute();
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
if ($row['active'] == 'Y' and $row['type'] == 'P' and is_file(EASYWIDIR . '/stuff/custom_modules/' . $row['file'])) {
$query2->execute(array($row['id'], $user_language));
$name = $query2->fetchColumn();
if (strlen($name) == 0) {
$query2->execute(array($row['id'], $rSA['language']));
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;
}
* Version 3 der Lizenz oder (nach Ihrer Wahl) jeder spaeteren
* veroeffentlichten Version, weiterverbreiten und/oder modifizieren.
*
* Easy-WI wird in der Hoffnung, dass es nuetzlich sein wird, aber
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!isset($admin_id) or $main != 1 or isset($admin_id) and !$pa['settings']) {
header('Location: login.php');
die;
}
$sprache = getlanguagefile('settings', $user_language, $reseller_id);
$loguserid = $admin_id;
$logusername = getusername($admin_id);
$logusertype = 'admin';
if ($reseller_id == 0) {
$logreseller = 0;
$logsubuser = 0;
} else {
$logsubuser = isset($_SESSION['oldid']) ? $_SESSION['oldid'] : 0;
$logreseller = 0;
}
if ($reseller_id != 0 and $admin_id != $reseller_id) {
$reseller_id = $admin_id;
}
if ($ui->w('action', 4, 'post') and !token(true)) {
$template_file = $spracheResponse->token;
if (count($error) > 0) {
$token = md5(passwordgenerate(32));
$_SESSION['token'] = $token;
$comments = str_replace('<br />', '', $comments);
} else {
$comments = $name . ' (' . $email . '):<br />' . $comments;
$query = $sql->prepare("SELECT `email_setting_value` FROM `settings_email` WHERE `reseller_id`=? AND `email_setting_name`='email' LIMIT 1");
$query->execute(array($reseller_id));
if (sendmail('contact', $name, $comments, $query->fetchColumn())) {
unset($error);
$success = true;
} else {
$error[] = 'Sending the mail failed';
$token = md5(passwordgenerate(32));
$_SESSION['token'] = $token;
}
}
} else {
$token = md5(passwordgenerate(32));
$_SESSION['token'] = $token;
}
$page_data->title = $page_sprache->contact;
$page_data->setCanonicalUrl($s);
// https://github.com/easy-wi/developer/issues/62
$langLinks = array();
foreach ($languages as $l) {
$tempLanguage = getlanguagefile('page', $l, 0);
$langLinks[$l] = $page_data->seo == 'Y' ? szrp($tempLanguage->{$s}) : '?s=' . $s;
}
$page_data->langLinks($langLinks);
$template_file = 'contact.tpl';
* Version 3 der Lizenz oder (nach Ihrer Wahl) jeder spaeteren
* veroeffentlichten Version, weiterverbreiten und/oder modifizieren.
*
* Easy-WI wird in der Hoffnung, dass es nuetzlich sein wird, aber
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!isset($admin_id) or $main != 1 or isset($admin_id) and !$pa['traffic']) {
header('Location: admin.php');
die('No Access');
}
$sprache = getlanguagefile('traffic', $user_language, $reseller_id);
if ($d == 'se' and $reseller_id == 0) {
include EASYWIDIR . '/stuff/keyphrasefile.php';
if ($ui->w('action', 4, 'post') and !token(true)) {
$template_file = $spracheResponse->token;
} else {
if (isset($ui->post['type']) and $ui->w('action', 4, 'post') == 'md') {
$error = 0;
if (!isset($ui->post['type']) or !small_letters_check($ui->post['type'], '30')) {
$error = 1;
}
if (!isset($ui->post['statip']) or !isip($ui->post['statip'], 'all') and !isurl($ui->post['statip'])) {
$error = 1;
}
if (!isset($ui->post['dbname']) or !gamestring($ui->post['dbname'])) {
$error = 1;
* Easy-WI wird in der Hoffnung, dass es nuetzlich sein wird, aber
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!isset($admin_id) or $main != 1 or isset($admin_id) and !$pa['eac']) {
header('Location: admin.php');
die('No acces');
}
include EASYWIDIR . '/stuff/keyphrasefile.php';
$sprache = getlanguagefile('roots', $user_language, $reseller_id);
$gssprache = getlanguagefile('gserver', $user_language, $reseller_id);
$mysprache = getlanguagefile('mysql', $user_language, $reseller_id);
$loguserid = $admin_id;
$logusername = getusername($admin_id);
$logusertype = 'admin';
if ($reseller_id == 0) {
$logreseller = 0;
$logsubuser = 0;
} else {
if (isset($_SESSION['oldid'])) {
$logsubuser = $_SESSION['oldid'];
} else {
$logsubuser = 0;
}
$logreseller = 0;
}
if ($ui->w('action', 4, 'post') and !token(true)) {
* der GNU General Public License, wie von der Free Software Foundation,
* Version 3 der Lizenz oder (nach Ihrer Wahl) jeder spaeteren
* veroeffentlichten Version, weiterverbreiten und/oder modifizieren.
*
* Easy-WI wird in der Hoffnung, dass es nuetzlich sein wird, aber
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!defined('AJAXINCLUDED')) {
die('Do not access directly!');
}
$sprache = getlanguagefile('modules', $user_language, $resellerLockupID);
$types = array('A' => $sprache->type_admin, 'P' => $sprache->type_cms, 'U' => $sprache->type_user, 'C' => $sprache->type_core);
$query = $sql->prepare("SELECT COUNT(`id`) AS `amount` FROM `modules`");
$query->execute();
$array['iTotalRecords'] = $query->fetchColumn();
if ($sSearch) {
$translationIDs = array();
$query = $sql->prepare("SELECT `transID` FROM `translations` WHERE `type`='mo' AND `lang`=:lang AND `text` LIKE :search");
$query->execute(array(':lang' => $user_language, ':search' => '%' . $sSearch . '%'));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$translationIDs[] = $row['transID'];
}
$translationInQuery = count($translationIDs) > 0 ? ' OR m.`id` IN (' . implode(',', $translationIDs) . ')' : '';
$translationTypeKeys = array();
foreach ($types as $key => $value) {
if (strpos(strtolower($value), strtolower($sSearch)) !== false) {
* Version 3 der Lizenz oder (nach Ihrer Wahl) jeder spaeteren
* veroeffentlichten Version, weiterverbreiten und/oder modifizieren.
*
* Easy-WI wird in der Hoffnung, dass es nuetzlich sein wird, aber
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!isset($admin_id) or $main != 1 or isset($admin_id) and !$pa['jobs']) {
header('Location: admin.php');
die('No acces');
}
$sprache = getlanguagefile('api', $user_language, $reseller_id);
if ($ui->w('action', 4, 'post') and !token(true)) {
$template_file = $spracheResponse->token;
} else {
if ($ui->w('action', 4, 'post') == 'dl' and !$ui->id('id', 19, 'get')) {
$i = 0;
if ($ui->id('id', 19, 'post')) {
foreach ($ui->id('id', 19, 'post') as $id) {
if ($reseller_id == 0) {
$delete = $sql->prepare("DELETE FROM `jobs` WHERE `jobID`=? LIMIT 1");
$delete->execute(array($id));
} else {
$delete = $sql->prepare("DELETE FROM `jobs` WHERE `jobID`=? AND `resellerID`=? LIMIT 1");
$delete->execute(array($id, $reseller_id));
}
$i++;
}
$langObject = getlanguagefile('user', $user_language, 0);
if (isset($registration) and in_array($registration, array('A', 'M', 'D'))) {
$activationToken = (isset($page_name) and isset($page_count) and $page_name == 'activate' and wpreg_check($page_count, 100)) ? $page_count : $ui->pregw('activate', 100, 'get');
if ($activationToken) {
// Check if a user to the activation ID exists
$query = $sql->prepare("SELECT `id` FROM `userdata` WHERE `token`=? LIMIT 1");
$query->execute(array($activationToken));
$userID = $query->fetchColumn();
if (isid($userID, 10)) {
$query = $sql->prepare("UPDATE `userdata` SET `active`='Y',`token`=null,`updateTime`=NOW() WHERE `id`=? LIMIT 1");
$query->execute(array($userID));
$_SESSION['userid'] = $userID;
$_SESSION['resellerid'] = 0;
$template_file = $page_sprache->registerActivated;
$langObjectTemp = getlanguagefile('redirect', $user_language, 0);
$text = $langObjectTemp->refresh;
$langObjectTemp = null;
if (isset($page_data->canurl)) {
$header = '<meta http-equiv="refresh" content="3; URL=' . $page_data->canurl . '">';
} else {
$header = '<meta http-equiv="refresh" content="3; URL=/">';
}
} else {
$template_file = $page_sprache->registerErrorActivatedFailed;
}
} else {
$error = array();
$alert = array();
$tous = array();
$selectlanguages = getlanguages($template_to_use);
* Version 3 der Lizenz oder (nach Ihrer Wahl) jeder spaeteren
* veroeffentlichten Version, weiterverbreiten und/oder modifizieren.
*
* Easy-WI wird in der Hoffnung, dass es nuetzlich sein wird, aber
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!isset($admin_id) or $main != 1 or isset($admin_id) and !isanyadmin($admin_id) and !rsellerpermisions($admin_id)) {
header('Location: login.php');
die('No acces');
}
$sprache_bad = getlanguagefile('home', $user_language, $reseller_id);
$statsArray = array('gameMasterInstalled' => 0, 'gameMasterActive' => 0, 'gameMasterSlotsAvailable' => 0, 'gameMasterCrashed' => 0, 'gameserverInstalled' => 0, 'gameserverActive' => 0, 'gameserverSlotsInstalled' => 0, 'gameserverSlotsActive' => 0, 'gameserverSlotsUsed' => 0, 'gameserverNoPassword' => 0, 'gameserverNoTag' => 0, 'gameserverNotRunning' => 0, 'mysqlMasterInstalled' => 0, 'mysqlMasterActive' => 0, 'mysqlMasterDBAvailable' => 0, 'mysqlMasterCrashed' => 0, 'mysqlDBInstalled' => 0, 'mysqlDBActive' => 0, 'mysqlDBSpaceUsed' => 0, 'ticketsCompleted' => 0, 'ticketsInProcess' => 0, 'ticketsNew' => 0, 'userAmount' => 0, 'userAmountActive' => 0, 'virtualMasterInstalled' => 0, 'virtualMasterActive' => 0, 'virtualMasterVserverAvailable' => 0, 'virtualInstalled' => 0, 'virtualActive' => 0, 'voiceMasterInstalled' => 0, 'voiceMasterActive' => 0, 'voiceMasterSlotsAvailable' => 0, 'voiceMasterCrashed' => 0, 'voiceserverInstalled' => 0, 'voiceserverActive' => 0, 'voiceserverSlotsInstalled' => 0, 'voiceserverSlotsActive' => 0, 'voiceserverSlotsUsed' => 0, 'voiceserverTrafficAllowed' => 0, 'voiceserverTrafficUsed' => 0, 'voiceserverCrashed' => 0, 'webMasterInstalled' => 0, 'webMasterActive' => 0, 'webMasterCrashed' => 0, 'webMasterSpaceAvailable' => 0, 'webMasterVhostAvailable' => 0, 'webspaceInstalled' => 0, 'webspaceActive' => 0, 'webspaceSpaceGiven' => 0, 'webspaceSpaceGivenActive' => 0, 'webspaceSpaceUsed' => 0);
$query = $sql->prepare("SELECT * FROM `easywi_statistics_current` WHERE `userID`=? LIMIT 1");
$query->execute(array($resellerLockupID));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$statsArray = $row;
}
$statsArray['ticketsTotal'] = $statsArray['ticketsInProcess'] + $statsArray['ticketsNew'];
$statsArray['warningTotal'] = $statsArray['gameserverNoPassword'] + $statsArray['gameserverNoTag'] + $statsArray['gameserverNotRunning'] + $statsArray['voiceserverCrashed'];
if ($ui->smallletters('w', 2, 'get') == 'da' or !$ui->smallletters('w', 2, 'get') and !$ui->smallletters('d', 2, 'get')) {
$statsArray['ticketsPercent'] = $statsArray['ticketsCompleted'] + $statsArray['ticketsInProcess'] + $statsArray['ticketsNew'] > 0 ? round(($statsArray['ticketsInProcess'] + $statsArray['ticketsNew']) / (($statsArray['ticketsCompleted'] + $statsArray['ticketsInProcess'] + $statsArray['ticketsNew']) / 100), 2) : 0;
$statsArray['ticketsNewPercent'] = $statsArray['ticketsInProcess'] + $statsArray['ticketsNew'] > 0 ? round($statsArray['ticketsNew'] / (($statsArray['ticketsInProcess'] + $statsArray['ticketsNew']) / 100), 2) : 0;
$statsArray['gameMasterActivePercent'] = $statsArray['gameMasterInstalled'] > 0 ? round($statsArray['gameMasterActive'] / ($statsArray['gameMasterInstalled'] / 100), 2) : 0;
$statsArray['gameMasterCrashedPercent'] = $statsArray['gameMasterActive'] > 0 ? round($statsArray['gameMasterCrashed'] / ($statsArray['gameMasterActive'] / 100), 2) : 0;
$statsArray['gameMasterServerPercent'] = $statsArray['gameMasterServerAvailable'] > 0 ? round($statsArray['gameserverActive'] / ($statsArray['gameMasterServerAvailable'] / 100), 2) : 0;
$statsArray['gameMasterSlotsPercent'] = $statsArray['gameMasterSlotsAvailable'] > 0 ? round($statsArray['gameserverSlotsInstalled'] / ($statsArray['gameMasterSlotsAvailable'] / 100), 2) : 0;
* Version 3 der Lizenz oder (nach Ihrer Wahl) jeder spaeteren
* veroeffentlichten Version, weiterverbreiten und/oder modifizieren.
*
* Easy-WI wird in der Hoffnung, dass es nuetzlich sein wird, aber
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!isset($admin_id) or $main != 1 or isset($admin_id) and (!isset($reseller_id) or $reseller_id != 0) or !$pa['settings']) {
header('Location: admin.php');
die('No acces');
}
$sprache = getlanguagefile('system_check', $user_language, $reseller_id);
$systemCheckOk = array();
$systemCheckError = array();
if (version_compare(PHP_VERSION, '5.3.0') >= 0) {
$systemCheckOk['php'] = $sprache->system_ok_php_version . PHP_VERSION;
} else {
$systemCheckError['php'] = $sprache->error_system_php_version . PHP_VERSION;
}
if (extension_loaded('openssl')) {
$systemCheckOk['openssl'] = $sprache->system_ok_openssl;
} else {
$systemCheckError['openssl'] = $sprache->error_system_openssl;
}
if (extension_loaded('json')) {
$systemCheckOk['json'] = $sprache->system_ok_json;
} else {
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!isset($admin_id) or !isset($reseller_id)) {
header('Location: login.php');
die;
}
$adminInclude = true;
$pa = User_Permissions($admin_id);
if (!isanyadmin($admin_id) and count($pa) == 0) {
redirect('login.php');
}
$ewVersions['files'] = '5.10';
$vcsprache = getlanguagefile('versioncheck', $user_language, $reseller_id);
$query = $sql->prepare("SELECT `version` FROM `easywi_version` ORDER BY `id` DESC LIMIT 1");
$query->execute();
$ewVersions['cVersion'] = $query->fetchColumn();
$query = $sql->prepare("SELECT `version`,`releasenotesDE`,`releasenotesEN` FROM `settings` WHERE `resellerid`=0 LIMIT 1");
$query->execute();
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$ewVersions['version'] = $row['version'];
$ewVersions['releasenotesDE'] = $row['releasenotesDE'];
$ewVersions['releasenotesEN'] = $row['releasenotesEN'];
}
if ($reseller_id == 0 and $ui->st('w', 'get') != 'vc' and ($ewVersions['cVersion'] < $ewVersions['version'] or $ewVersions['files'] < $ewVersions['version'])) {
$toooldversion = $vcsprache->newversion . $ewVersions['version'];
}
$query = $sql->prepare("SELECT `cname`,`name`,`vname`,`lastlogin` FROM `userdata` WHERE `id`=? LIMIT 1");
$query->execute(array($admin_id));
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!isset($user_id) or $main != 1 or isset($user_id) and !$pa['webvhost']) {
header('Location: userpanel.php');
die;
}
include EASYWIDIR . '/stuff/keyphrasefile.php';
include EASYWIDIR . '/stuff/methods/class_httpd.php';
$sprache = getlanguagefile('web', $user_language, $reseller_id);
$gsSprache = getlanguagefile('gserver', $user_language, $reseller_id);
$dedicatedLanguage = getlanguagefile('reseller', $user_language, $reseller_id);
$loguserid = $user_id;
$logusername = getusername($user_id);
$logusertype = 'user';
$logreseller = 0;
if (isset($admin_id)) {
$logsubuser = $admin_id;
} else {
if (isset($subuser_id)) {
$logsubuser = $subuser_id;
} else {
$logsubuser = 0;
}
}
if ($ui->id('id', 10, 'get') and in_array($ui->st('d', 'get'), array('if', 'pw', 'ri', 'md', 'dm'))) {
$query = $sql->prepare("SELECT v.`webMasterID`,v.`description`,v.`phpConfiguration`,v.`phpConfiguration`,m.`vhostTemplate`,m.`usageType`,m.`defaultdns`,m.`connect_ip_only`,m.`ftpIP`,m.`ip`,m.`phpConfiguration` AS `phpMasterConfiguration` FROM `webVhost` AS v INNER JOIN `webMaster` AS m ON m.`webMasterID`=v.`webMasterID` WHERE v.`webVhostID`=? AND v.`userID`=? AND v.`resellerID`=? AND v.`active`='Y'");
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!isset($admin_id) or !isset($reseller_id) or isset($reseller_id) and $reseller_id != 0 or isset($admin_id) and isset($pa) and !$pa['root']) {
header('Location: login.php');
die;
}
$loguserid = $admin_id;
$logusername = getusername($admin_id);
$logusertype = 'admin';
$logreseller = 0;
$logsubuser = 0;
$sprache = getlanguagefile('modules', $user_language, $reseller_id);
unset($name);
# array with easy-wi core modules to prevent legacy issues and users from removing
$coreModules = array(1 => array('id' => 1, 'active' => 'Y', 'name' => $gsprache->gameserver, 'sub' => 'gs', 'type' => $sprache->type_core), 2 => array('id' => 2, 'active' => 'Y', 'name' => 'Easy Anti Cheat', 'sub' => 'ea', 'type' => $sprache->type_core), 3 => array('id' => 3, 'active' => 'Y', 'name' => 'MySQL', 'sub' => 'my', 'type' => $sprache->type_core), 4 => array('id' => 4, 'active' => 'Y', 'name' => $gsprache->voiceserver, 'sub' => 'vo', 'type' => $sprache->type_core), 5 => array('id' => 5, 'active' => 'Y', 'name' => $gsprache->lendserver, 'sub' => 'le', 'type' => $sprache->type_core), 6 => array('id' => 6, 'active' => 'Y', 'name' => $gsprache->support, 'sub' => 'ti', 'type' => $sprache->type_core), 7 => array('id' => 7, 'active' => 'Y', 'name' => 'Rootserver', 'sub' => 'ro', 'type' => $sprache->type_core), 8 => array('id' => 8, 'active' => 'Y', 'name' => $gsprache->imprint, 'sub' => 'ip', 'type' => $sprache->type_core), 9 => array('id' => 9, 'active' => 'Y', 'name' => 'CMS', 'sub' => 'pn', 'type' => $sprache->type_core), 10 => array('id' => 10, 'active' => 'Y', 'name' => $gsprache->webspace, 'sub' => 'ws', 'type' => $sprache->type_core));
$query = $sql->prepare("SELECT `id` FROM `modules` WHERE `type`='C' AND `get`=? LIMIT 1");
$query2 = $sql->prepare("INSERT INTO `modules` (`file`,`get`,`sub`,`type`,`active`) VALUES ('',?,?,'C',?) ON DUPLICATE KEY UPDATE `active`=VALUES(`active`)");
$query3 = $sql->prepare("INSERT INTO `translations` (`type`,`transID`,`lang`,`text`,`resellerID`) VALUES ('mo',?,?,?,?) ON DUPLICATE KEY UPDATE `text`=VALUES(`text`)");
foreach ($coreModules as $module) {
$query->execute(array($module['sub']));
$coreModuleID = (int) $query->fetchColumn();
if ($coreModuleID == 0) {
$query2->execute(array($module['sub'], $module['sub'], 'Y'));
$instertedID = $sql->lastInsertId();
$query3->execute(array($instertedID, $user_language, $module['name'], 0));
} else {
$query3->execute(array($coreModuleID, $user_language, $module['name'], 0));
include EASYWIDIR . '/stuff/methods/class_masterserver.php';
include EASYWIDIR . '/stuff/methods/functions_ts3.php';
include EASYWIDIR . '/stuff/methods/class_ts3.php';
include EASYWIDIR . '/stuff/methods/queries_updates.php';
include EASYWIDIR . '/stuff/keyphrasefile.php';
if (!isset($ip) or $ui->escaped('SERVER_ADDR', 'server') == $ip or in_array($ip, ipstoarray($rSA['cronjob_ips']))) {
echo "Reboot and Updater started\r\n";
if (version_compare(PHP_VERSION, '5.3.0') >= 0) {
$currentTime = new DateTime(date('Y-m-d H:i:s'));
} else {
$currentDay = date('j');
$currentDays = date('t');
$currentHour = date('G');
}
$now = date('Y-m-d', strtotime('now'));
$sprache = getlanguagefile('gserver', 'uk', 0);
echo "Fetch version for Teamspeak 3 Server\r\n";
$query = $sql->prepare("UPDATE `voice_masterserver` SET `latest_version`=? WHERE `bitversion`=?");
$ts3MasterVersion32 = getTS3Version('server', 'linux', 32);
if (isset($ts3MasterVersion32['version']) and preg_match('/^([\\d]{1,2}.)*[\\d]{1,2}$/', $ts3MasterVersion32['version'])) {
$query->execute(array($ts3MasterVersion32['version'], '32'));
}
$ts3MasterVersion64 = getTS3Version('server', 'linux', 64);
if (isset($ts3MasterVersion64['version']) and preg_match('/^([\\d]{1,2}.)*[\\d]{1,2}$/', $ts3MasterVersion64['version'])) {
$query->execute(array($ts3MasterVersion64['version'], '64'));
}
echo "Current versions for Teamspeak 3 Server are {$ts3MasterVersion32['version']} (32bit) and {$ts3MasterVersion64['version']} (64bit)\r\n";
echo "Fetch version for Minecraft and Bukkit Server\r\n";
$query = $sql->prepare("SELECT t.`shorten` FROM `servertypes` t LEFT JOIN `rservermasterg` r ON t.`id`=r.`servertypeid` WHERE r.`id` IS NOT NULL AND t.`gameq`='minecraft' GROUP BY t.`shorten` ORDER BY t.`shorten`");
$query2 = $sql->prepare("UPDATE `servertypes` SET `steamVersion`=?,`downloadPath`=? WHERE `shorten`=?");
$query->execute();
*/
if (!isset($admin_id) or $main != 1 or isset($admin_id) and !$pa['root']) {
header('Location: admin.php');
die('No Access');
}
$loguserid = $admin_id;
$logusername = getusername($admin_id);
$logusertype = 'admin';
if ($reseller_id == 0) {
$logreseller = 0;
$logsubuser = 0;
} else {
$logsubuser = isset($_SESSION['oldid']) ? $_SESSION['oldid'] : 0;
$logreseller = 0;
}
$sprache = getlanguagefile('login', $user_language, $reseller_id);
// Define the ID variable which will be used at the form and SQLs
$id = $ui->id('id', 10, 'get');
$active = $ui->active('active', 'post');
$name = $ui->w('name', 255, 'post');
$keyID = $ui->escaped('keyID', 'post');
$providerToken = $ui->escaped('providerToken', 'post');
// At this point all variables are defined that can come from the user
// CSFR protection with hidden tokens. If token(true) returns false, we likely have an attack
if ($ui->w('action', 4, 'post') and !token(true)) {
unset($header, $text);
$errors = array($spracheResponse->token);
$template_file = $ui->st('d', 'get') == 'ad' ? 'admin_social_provider_add.tpl' : 'admin_social_provider_md.tpl';
// Add and modify entries. Same validation can be used.
} else {
if ($ui->st('d', 'get') == 'ad' or $ui->st('d', 'get') == 'md') {
function serverAmount($resellerid)
{
global $sql, $user_language;
$query = $sql->prepare("SELECT `licence` FROM `settings` WHERE `resellerid`=0 LIMIT 1");
$query->execute();
$json = @json_decode($query->fetchColumn());
$query = $sql->prepare("SELECT COUNT(g.`id`) AS `amount` FROM `gsswitch` g LEFT JOIN `userdata` u ON g.`userid`=u.`id` LEFT JOIN `userdata` r ON g.`resellerid`= r.`id` WHERE g.`active`='Y' AND u.`active`='Y' AND (r.`active`='Y' OR r.`active` IS NULL)");
$query->execute();
$gsCount = (int) $query->fetchColumn();
$query = $sql->prepare("SELECT COUNT(v.`id`) AS `amount` FROM `virtualcontainer` v LEFT JOIN `userdata` u ON v.`userid`=u.`id` LEFT JOIN `userdata` r ON v.`resellerid`= r.`id` WHERE v.`active`='Y' AND u.`active`='Y' AND (r.`active`='Y' OR r.`active` IS NULL)");
$query->execute();
$vCount = (int) $query->fetchColumn();
$query = $sql->prepare("SELECT COUNT(v.`id`) AS `amount` FROM `voice_server` v LEFT JOIN `voice_masterserver` m ON v.`masterserver`=m.`id` LEFT JOIN `userdata` u ON v.`userid`=u.`id` LEFT JOIN `userdata` r ON v.`resellerid`= r.`id` WHERE v.`active`='Y' AND m.`active`='Y' AND u.`active`='Y' AND (r.`active`='Y' OR r.`active` IS NULL)");
$query->execute();
$voCount = (int) $query->fetchColumn();
$query = $sql->prepare("SELECT `dedicatedID` FROM `rootsDedicated` d LEFT JOIN `userdata` u ON d.`userID`=u.`id` LEFT JOIN `userdata` r ON d.`resellerID`= r.`id` WHERE r.`active`!='N' AND u.`active`!='N' AND d.`active`!='N'");
$query->execute();
$dCount = (int) $query->fetchColumn();
$count = $gsCount + $vCount + $voCount + $dCount;
$sprache = getlanguagefile('licence', $user_language, $resellerid);
$s = $sprache->unlimited;
$mG = $s;
$mVs = $s;
$mVo = $s;
$mD = $s;
$lG = 10;
$lVs = 10;
$lVo = 10;
$lD = 10;
$left = $s;
if ($resellerid != 0) {
$query = $sql->prepare("SELECT `maxgserver`,`maxvserver`,`maxvoserver`,`maxdedis` FROM `resellerdata` WHERE `resellerid`=? LIMIT 1");
$query->execute(array($resellerid));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$mG = $row['maxgserver'];
$mVs = $row['maxvserver'];
$mVo = $row['maxvoserver'];
$mD = $row['maxdedis'];
}
$query = $sql->prepare("SELECT COUNT(g.`id`) AS `amount` FROM `gsswitch` g LEFT JOIN `userdata` u ON g.`userid`=u.`id` WHERE g.`resellerid`=? AND g.`active`='Y' AND u.`active`='Y'");
$query->execute(array($resellerid));
$gsCount = (int) $query->fetchColumn();
$query = $sql->prepare("SELECT COUNT(v.`id`) AS `amount` FROM `virtualcontainer` v LEFT JOIN `userdata` u ON v.`userid`=u.`id` WHERE (v.`userid`=:resellerid OR v.`resellerid`=:resellerid) AND v.`active`='Y' AND u.`active`='Y'");
$query->execute(array(':resellerid' => $resellerid));
$vCount = (int) $query->fetchColumn();
$query = $sql->prepare("SELECT COUNT(v.`id`) AS `amount` FROM `voice_server` v LEFT JOIN `voice_masterserver` m ON v.`masterserver`=m.`id` LEFT JOIN `userdata` u ON v.`userid`=u.`id` LEFT JOIN `userdata` r ON v.`resellerid`= r.`id` WHERE v.`resellerid`=? AND v.`active`='Y' AND m.`active`='Y' AND u.`active`='Y'");
$query->execute(array($resellerid));
$voCount = (int) $query->fetchColumn();
$query = $sql->prepare("SELECT COUNT(`dedicatedID`) AS `amount` FROM `rootsDedicated` d LEFT JOIN `userdata` u ON d.`userid`=u.`id` WHERE (d.`userID`=:resellerid OR d.`resellerID`=:resellerid) AND d.`active`!='N'");
$query->execute(array(':resellerid' => $resellerid));
$dCount = (int) $query->fetchColumn();
}
return array('left' => $left, 'count' => $count, 'gsCount' => $gsCount, 'vCount' => $vCount, 'voCount' => $voCount, 'dCount' => $dCount, 'mG' => $mG, 'mVs' => $mVs, 'mVo' => $mVo, 'mD' => $mD, 'lG' => $lG, 'lVs' => $lVs, 'lVo' => $lVo, 'lD' => $lD, 'p' => $json->p, 'b' => $json->b, 't' => $json->t, 'u' => $json->u, 'c' => $json->c, 'v' => $json->v);
}
*
* Easy-WI ist Freie Software: Sie koennen es unter den Bedingungen
* der GNU General Public License, wie von der Free Software Foundation,
* Version 3 der Lizenz oder (nach Ihrer Wahl) jeder spaeteren
* veroeffentlichten Version, weiterverbreiten und/oder modifizieren.
*
* Easy-WI wird in der Hoffnung, dass es nuetzlich sein wird, aber
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
include EASYWIDIR . '/stuff/keyphrasefile.php';
$sprache = getlanguagefile('feeds', $user_language, $reseller_id);
$loguserid = $admin_id;
$logusername = getusername($admin_id);
$logusertype = 'admin';
if ($reseller_id == 0) {
$logreseller = 0;
$logsubuser = 0;
} else {
if (isset($_SESSION['oldid'])) {
$logsubuser = $_SESSION['oldid'];
} else {
$logsubuser = 0;
}
$logreseller = 0;
}
if ($reseller_id != 0 and $admin_id != $reseller_id) {
* Version 3 der Lizenz oder (nach Ihrer Wahl) jeder spaeteren
* veroeffentlichten Version, weiterverbreiten und/oder modifizieren.
*
* Easy-WI wird in der Hoffnung, dass es nuetzlich sein wird, aber
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!isset($admin_id) or $main != 1 or isset($admin_id) and !$pa['root'] or $reseller_id != 0) {
header('Location: admin.php');
die;
}
$sprache = getlanguagefile('subnets', $user_language, $resellerLockupID);
$loguserid = $admin_id;
$logusername = getusername($admin_id);
$logusertype = 'admin';
$logreseller = 0;
$logsubuser = 0;
// Define the ID variable which will be used at the form and SQLs
$id = $ui->id('id', 10, 'get');
// CSFR protection with hidden tokens. If token(true) returns false, we likely have an attack
if ($ui->w('action', 4, 'post') and !token(true)) {
unset($header, $text);
$errors = array($spracheResponse->token);
$template_file = $ui->st('d', 'get') == 'ad' ? 'admin_root_subnets_add.tpl' : 'admin_root_subnets_md.tpl';
// Add and modify entries. Same validation can be used.
} else {
if ($ui->st('d', 'get') == 'ad' or $ui->st('d', 'get') == 'md') {
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!isset($admin_id) or !isset($reseller_id) or $main != 1 or isset($admin_id) and !$pa['settings'] or $reseller_id != 0) {
redirect('admin.php');
}
$loguserid = $admin_id;
$logusername = getusername($admin_id);
$logusertype = 'admin';
$logreseller = 0;
$logsubuser = 0;
$sprache = getlanguagefile('columns', $user_language, $reseller_id);
if ($ui->w('action', 4, 'post') and !token(true)) {
$template_file = $spracheResponse->token;
} else {
if (in_array($ui->st('d', 'get'), array('ad', 'md'))) {
$id = $ui->id('id', 10, 'get');
if (in_array($ui->st('action', 'post'), array('ad', 'md'))) {
$error = array();
if (!$ui->active('active', 'post')) {
$error[] = 'Active';
}
if (!$ui->id('length', 10, 'post')) {
$error[] = 'Length';
}
if (!$ui->w('item', 1, 'post')) {
$error[] = 'Item';
* Version 3 der Lizenz oder (nach Ihrer Wahl) jeder spaeteren
* veroeffentlichten Version, weiterverbreiten und/oder modifizieren.
*
* Easy-WI wird in der Hoffnung, dass es nuetzlich sein wird, aber
* OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
* Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
* Siehe die GNU General Public License fuer weitere Details.
*
* Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
* Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
*/
if (!isset($admin_id) or $main != 1 or isset($admin_id) and !$pa['tickets']) {
header('Location: admin.php');
die;
}
$sprache = getlanguagefile('tickets', $user_language, $reseller_id);
$loguserid = $admin_id;
$logusername = getusername($admin_id);
$logusertype = 'admin';
if ($reseller_id == 0) {
$logreseller = 0;
$logsubuser = 0;
} else {
$logsubuser = isset($_SESSION['oldid']) ? $_SESSION['oldid'] : 0;
$logreseller = 0;
}
if ($ui->w('action', 4, 'post') and !token(true)) {
$template_file = $spracheResponse->token;
} else {
if ($ui->st('d', 'get') == 'at') {
if (!$ui->smallletters('action', 2, 'post')) {
die;
}
$query = $sql->prepare("SELECT `faillogins` FROM `settings` WHERE `resellerid`=0 LIMIT 1");
$query->execute();
$allowedfails = $query->fetchColumn();
$query = $sql->prepare("SELECT `id` FROM `badips` WHERE `badip`=? AND `reason`='password' AND `failcount`>=? LIMIT 1");
$query->execute(array($loguserip, $allowedfails));
if ($query->rowCount() > 0) {
die('Your IP is banned');
}
}
if ($ui->st('r', 'get')) {
$redirectID = $ui->id('id', 30, 'get') ? '&id=' . $ui->id('id', 30, 'get') : '';
$actionParam = ($redirectID != '' and $ui->smallletters('d', 10, 'get') == 'md') ? '&d=' . $ui->smallletters('d', 10, 'get') : '';
$header = '<meta http-equiv="refresh" content="3; URL=' . $ui->escaped('SCRIPT_NAME', 'server') . '?w=' . $ui->st('r', 'get') . $redirectID . $actionParam . '">';
$rsprache = getlanguagefile('redirect', $user_language, 0);
$text = $rsprache->refresh;
}
if ($ui->smallletters('site', 50, 'get')) {
$s = $ui->smallletters('site', 50, 'get');
}
$w = $ui->st('w', 'get') ? $ui->st('w', 'get') : 'ho';
$d = $ui->st('d', 'get') ? $ui->st('d', 'get') : 'md';
$start = $ui->id('p', 19, 'get') ? $ui->id('p', 19, 'get') : 0;
if ($ui->smallletters('t', '1', 'get')) {
$list_type = $ui->smallletters('t', '1', 'get');
if ($list_type == "m") {
$where = "WHERE `type`='map'";
} else {
if ($list_type == "t") {
$where = "WHERE `type`='tool'";
include EASYWIDIR . '/stuff/methods/vorlage.php';
include EASYWIDIR . '/stuff/methods/functions.php';
include EASYWIDIR . '/stuff/methods/class_validator.php';
include EASYWIDIR . '/stuff/methods/class_rootserver.php';
include EASYWIDIR . '/stuff/methods/class_ftp.php';
include EASYWIDIR . '/stuff/methods/class_app.php';
include EASYWIDIR . '/stuff/methods/class_httpd.php';
include EASYWIDIR . '/stuff/settings.php';
include EASYWIDIR . '/stuff/methods/functions_gs.php';
include EASYWIDIR . '/stuff/methods/functions_ssh_exec.php';
include EASYWIDIR . '/stuff/methods/class_ts3.php';
include EASYWIDIR . '/stuff/methods/functions_ts3.php';
include EASYWIDIR . '/stuff/methods/class_mysql.php';
include EASYWIDIR . '/stuff/keyphrasefile.php';
if (!isset($ip) or $ui->escaped('SERVER_ADDR', 'server') == $ip or in_array($ip, ipstoarray($rSA['cronjob_ips']))) {
$gsprache = getlanguagefile('general', 'uk', 0);
class runGraph
{
private $jobsDone = 0, $startTime = 0, $newLine = "\r\n", $jobCount = 0, $spinnerCount = 0, $spinners = array('-', '/', '-', '\\', '|', '/', '-', '\\', '|', '/'), $spinner = '-', $oneJobPercent = 1;
function __construct($jobCount, $newLine)
{
$this->startTime = strtotime('now');
$this->jobCount = $jobCount;
$this->oneJobPercent = $jobCount > 0 ? 100 / $jobCount : 100;
$this->newLine = $newLine;
$this->startTime = strtotime('now');
}
public function updateCount($jobCount)
{
$this->jobCount = $jobCount;
$this->oneJobPercent = $jobCount > 0 ? 100 / $jobCount : 100;
