* 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++;
}
}
$template_file = $i . ' ' . $gsprache->jobs . ' deleted';
} else {
configureDateTables('-1', '0, "desc"', 'ajax.php?w=datatable&d=joblog');
$template_file = 'admin_jobs_list.tpl';
}
}
$dns = $row['dns'];
$tsdnsRootID = $row['tsdnsID'];
$deleteDNS = $row['ip'] . ' ' . $row['port'] . ' ' . $row['dns'];
}
$serverFound = $query->rowCount();
if ($ui->st('action', 'post') == 'dl' and count($errors) == 0 and $serverFound > 0) {
$query = $sql->prepare("SELECT *,AES_DECRYPT(`ssh2port`,:aeskey) AS `decryptedssh2port`,AES_DECRYPT(`ssh2user`,:aeskey) AS `decryptedssh2user`,AES_DECRYPT(`ssh2password`,:aeskey) AS `decryptedssh2password` FROM `voice_tsdns` WHERE `active`='Y' AND `id`=:id AND `resellerid`=:reseller_id LIMIT 1");
$query->execute(array(':aeskey' => $aeskey, ':id' => $tsdnsRootID, ':reseller_id' => $resellerLockupID));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$dnsReturn = tsdns('dl', $row['ssh2ip'], $row['decryptedssh2port'], $row['decryptedssh2user'], $row['publickey'], $row['keyname'], $row['decryptedssh2password'], 0, $row['serverdir'], $row['bitversion'], array($ip), array($port), array($dns), $resellerLockupID);
}
$query = $sql->prepare("DELETE FROM `voice_dns` WHERE `dnsID`=? AND `resellerid`=? LIMIT 1");
$query->execute(array($id, $resellerLockupID));
if ($query->rowCount() > 0) {
$loguseraction = '%del% %tsdns% %dns% ' . $deleteDNS;
$insertlog->execute();
$template_file = $spracheResponse->table_del;
} else {
$template_file = $spracheResponse->error_table;
}
}
// Nothing submitted yet or csfr error, display the delete form
if (!$ui->st('action', 'post') or count($errors) != 0) {
// Check if we could find an entry and if not display 404 page
$template_file = $serverFound > 0 ? 'admin_voice_dns_dl.tpl' : 'admin_404.tpl';
}
} else {
configureDateTables('-1', '1, "asc"', 'ajax.php?w=datatable&d=tsdns');
$template_file = 'admin_voice_dns_list.tpl';
}
}
$query = $sql->prepare("DELETE FROM `gserver_file_templates` WHERE `templateID`=? AND `userID`=? AND `resellerID`=? LIMIT 1");
$query->execute(array($id, $user_id, $resellerLockupID));
}
if ($query->rowCount() > 0) {
$loguseraction = '%del% %template% ' . $name;
$insertlog->execute();
$template_file = $spracheResponse->table_del;
} else {
$template_file = $spracheResponse->error_table;
}
} else {
$template_file = 'admin_404.tpl';
}
}
} else {
$table = array();
if (isset($adminInclude)) {
$query = $sql->prepare("SELECT `templateID`,`name`,`servertype` FROM `gserver_file_templates` WHERE `userID` IS NULL AND `resellerID`=?");
$query->execute(array($resellerLockupID));
} else {
$query = $sql->prepare("SELECT `templateID`,`name`,`servertype` FROM `gserver_file_templates` WHERE `userID`=? AND `resellerID`=?");
$query->execute(array($user_id, $resellerLockupID));
}
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$table[] = array('id' => $row['templateID'], 'name' => $row['name'], 'servertype' => $row['servertype']);
}
configureDateTables('-1, -2');
$template_file = 'global_gserver_file_template_list.tpl';
}
}
}
*
* Easy-WI is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with Easy-WI. If not, see <http://www.gnu.org/licenses/>.
*
* Diese Datei ist Teil von Easy-WI.
*
* 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/>.
*/
if (!isset($admin_id) or $main != 1 or isset($admin_id) and !$pa['log']) {
header('Location: admin.php');
die('No Access');
}
$sprache = getlanguagefile('logs', $user_language, $reseller_id);
configureDateTables('', '0, "desc"', 'ajax.php?w=datatable&d=adminuserlog');
$template_file = 'admin_logs.tpl';
$query = $sql->prepare("DELETE FROM `userdata_social_providers` WHERE `serviceProviderID`=? AND `resellerID`=? LIMIT 1");
$query->execute(array($id, $resellerLockupID));
// Check if a row was affected meaning an entry could be deleted. If yes add log entry and display success message
if ($query->rowCount() > 0) {
$query = $sql->prepare("DELETE FROM `userdata_social_identities` WHERE `serviceProviderID`=? AND `resellerID`=? LIMIT 1");
$query->execute(array($id, $resellerLockupID));
$template_file = $spracheResponse->table_del;
$loguseraction = '%del% Social Provider ' . $name;
$insertlog->execute();
// Nothing was deleted, display an error
} else {
$template_file = $spracheResponse->error_table;
}
// GET Request did not add up. Display 404 error.
} else {
$template_file = 'admin_404.tpl';
}
}
// List the available entries
} else {
$table = array();
$query = $sql->prepare("SELECT `serviceProviderID`,`active`,`filename` FROM `userdata_social_providers` WHERE `resellerID`=?");
$query->execute(array($resellerLockupID));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$table[] = array('id' => $row['serviceProviderID'], 'active' => $row['active'], 'name' => $row['filename']);
}
configureDateTables('-1');
$template_file = 'admin_social_provider_list.tpl';
}
}
}
} else {
if ($ui->st('action', 'post') == 'dl' and isset($name)) {
$query = $sql->prepare("DELETE FROM `custom_columns_settings` WHERE `customID`=? LIMIT 1");
$query->execute(array($id));
if ($query->rowCount() > 0) {
$query = $sql->prepare("DELETE FROM `custom_columns` WHERE `customID`=?");
$query->execute(array($id));
$query = $sql->prepare("DELETE FROM `translations` WHERE `type`='cc' AND `transID`=?");
$query->execute(array($id));
$loguseraction = "%del% Custom Column {$name}";
$insertlog->execute();
$template_file = $spracheResponse->table_del;
} else {
$template_file = $spracheResponse->error_table;
}
} else {
$template_file = 'admin_404.tpl';
}
}
} else {
$table = array();
$query = $sql->prepare("SELECT * FROM `custom_columns_settings`");
$query->execute();
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$table[] = array('id' => $row['customID'], 'active' => $row['active'], 'name' => $row['name'], 'type' => $row['type'] == 'I' ? $sprache->int : $sprache->var);
}
configureDateTables('-1', '1, "desc"');
$template_file = 'admin_settings_columns_list.tpl';
}
}
}
$email = $row['email'];
$homepage = $row['homepage'];
$ip = $row['ip'];
$dns = $row['dns'];
$markedSpam = $row['markedSpam'];
$spamReason = $row['spamReason'];
$moderateAccepted = $row['moderateAccepted'];
}
if (isset($comment)) {
$template_file = 'admin_page_comments_md.tpl';
} else {
$template_file = 'admin_404.tpl';
}
} else {
if ($ui->st('d', 'get') == 'dl' and $ui->id('id', 19, 'get')) {
$query = $sql->prepare("DELETE FROM `page_comments` WHERE `commentID`=? AND `resellerID`=? LIMIT 1");
$query->execute(array($ui->id('id', 19, 'get'), $reseller_id));
if ($query->rowCount() > 0) {
$loguseraction = '%del% %comment% ' . $ui->id('id', 19, 'get');
$insertlog->execute();
$template_file = $spracheResponse->table_del;
} else {
$template_file = $spracheResponse->error_table;
}
} else {
configureDateTables('-1', '1, "desc"', 'ajax.php?w=datatable&d=pagecomments');
$template_file = 'admin_page_comments_list.tpl';
}
}
}
}
$query = $sql->prepare("SELECT `description` FROM `servertypes` WHERE `id`=? AND `resellerid`=? LIMIT 1");
$query->execute(array($id, $resellerLockupID));
$description = $query->fetchColumn();
$template_file = $description != '' ? 'admin_images_dl.tpl' : 'admin_404.tpl';
} else {
if ($ui->st('action', 'post') == 'dl') {
$query = $sql->prepare("SELECT `shorten` FROM `servertypes` WHERE id=? AND resellerid=? LIMIT 1");
$query->execute(array($id, $resellerLockupID));
$shorten = $query->fetchColumn();
$query = $sql->prepare("DELETE FROM `servertypes` WHERE `id`=? AND `resellerid`=? LIMIT 1");
$query->execute(array($id, $resellerLockupID));
if ($query->rowCount() > 0) {
$loguseraction = '%del% %template% ' . $shorten;
$insertlog->execute();
$template_file = $spracheResponse->table_del;
} else {
$template_file = $spracheResponse->error_table;
}
$query = $sql->prepare("DELETE FROM `rservermasterg` WHERE `servertypeid`=? AND `resellerid`=? LIMIT 1");
$query->execute(array($id, $resellerLockupID));
} else {
$template_file = 'admin_404.tpl';
}
}
} else {
configureDateTables('-1', '0, "asc"', 'ajax.php?w=datatable&d=gameimages');
$template_file = 'admin_images_list.tpl';
}
}
}
}
$queryip = $row['ssh2ip'];
$ssh2port = $row['decryptedssh2port'];
$ssh2user = $row['decryptedssh2user'];
$ssh2password = $row['decryptedssh2password'];
$serverdir = $row['serverdir'];
$keyname = $row['keyname'];
$bitversion = $row['bitversion'];
}
}
tsdns('dl', $queryip, $ssh2port, $ssh2user, $publickey, $keyname, $ssh2password, $mnotified, $serverdir, $bitversion, array($ip), array($port), array($dns), $resellerLockupID);
}
} else {
if ($ui->w('safeDelete', 1, 'post') == 'S' and (!isset($errorcode) or strpos($errorcode, 'error id=0') === false)) {
$template_file = isset($errorcode) ? 'Error: ' . $errorcode : 'Error: Could not connect to TS3 masterserver';
} else {
$template_file = $spracheResponse->error_table;
}
}
}
// Nothing submitted yet or csfr error, display the delete form
if (!$ui->st('action', 'post') or count($errors) != 0) {
// Check if we could find an entry and if not display 404 page
$template_file = $serverFound > 0 ? 'admin_voiceserver_dl.tpl' : 'admin_404.tpl';
}
// List the available entries
} else {
configureDateTables('-1, -2, -3', '1, "asc"', 'ajax.php?w=datatable&d=voiceserver');
$template_file = 'admin_voiceserver_list.tpl';
}
}
}
if ($ui->st('action', 'post') == 'ri') {
$mailData = array('userId' => $row['uid'], 'name' => strlen($description) > 0 ? $description : $row['dbname'], 'mailConnectInfo' => array('ip' => $row['user_connect_ip'], 'port' => $row['port']));
$remotesql->AddDB($mailData, $row['dbname'], $row['decryptedpassword'], $row['ips'], $row['max_queries_per_hour'], $row['max_connections_per_hour'], $row['max_updates_per_hour'], $row['max_userconnections_per_hour']);
$loguseraction = '%ri% MYSQL DB ' . $row['dbname'] . ' (' . $row['ip'] . ')';
$template_file = $spracheResponse->reinstall_success;
} else {
$query2 = $sql->prepare("DELETE FROM `mysql_external_dbs` WHERE `id`=? AND `resellerid`=? LIMIT 1");
$query2->execute(array($id, $resellerLockupID));
customColumns('D', $id, 'del');
$loguseraction = '%del% MySQL DB ' . $row['dbname'] . ' (' . $row['ip'] . ')';
$template_file = $spracheResponse->table_del;
}
$insertlog->execute();
} else {
$template_file = $remotesql->error;
}
}
}
// Nothing submitted yet or csfr error, display the delete form
if (!$ui->st('action', 'post') or count($errors) != 0 and $serverFound > 0) {
$template_file = $ui->st('d', 'get') == 'ri' ? 'admin_mysql_db_ri.tpl' : 'admin_mysql_db_dl.tpl';
}
// Check if we could find an entry and if not display 404 page
if (!isset($template_file)) {
$template_file = 'admin_404.tpl';
}
} else {
configureDateTables('-1', '1, "asc"', 'ajax.php?w=datatable&d=mysqldb');
$template_file = 'admin_mysql_db_list.tpl';
}
}
$pages[] = $start == $selectpage ? '<a href="admin.php?w=ad&d=md&o=' . $o . '&a=' . $amount . '&p=' . $selectpage . '" class="bold">' . $i . '</a>' : '<a href="admin.php?w=ad&d=md&o=' . $o . '&a=' . $amount . '&p=' . $selectpage . '">' . $i . '</a>';
$i++;
}
$pages = implode(', ', $pages);
$query = $sql->prepare("SELECT `id`,`menudescription`,`active`,`type` FROM `addons` WHERE `resellerid`=? ORDER BY {$orderby} LIMIT {$start},{$amount}");
$query2 = $sql->prepare("SELECT GROUP_CONCAT(DISTINCT s.`shorten` ORDER BY s.`shorten` ASC SEPARATOR ', ') AS `list`, COUNT(s.`id`) AS `amount` FROM `addons_allowed` AS a INNER JOIN `servertypes` AS s ON a.`servertype_id`=s.`id` WHERE a.`addon_id`=? AND s.`resellerid`=?");
$query->execute(array($reseller_id));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$gamesList = '(0)';
if ($row['active'] == 'Y') {
$imgName = '16_ok';
$imgAlt = 'Active';
} else {
$imgName = '16_bad';
$imgAlt = 'Inactive';
}
$query2->execute(array($row['id'], $reseller_id));
while ($row2 = $query2->fetch(PDO::FETCH_ASSOC)) {
$gamesList = '(' . $row2['amount'] . ') ' . $row2['list'];
}
if (strlen($gamesList) > 40) {
$gamesList = substr($gamesList, 0, 40) . '...';
}
$table[] = array('id' => $row['id'], 'active' => $row['active'], 'img' => $imgName, 'alt' => $imgAlt, 'gametype' => $gamesList, 'description' => $row['menudescription'], 'type' => $row['type'] == 'map' ? $sprache->map : $sprache->tool);
}
configureDateTables('-1', '1, "asc"', 'ajax.php?w=datatable&d=gameserveraddons');
$template_file = 'admin_addons_list.tpl';
}
}
}
}
$dns = strlen($row['description']) == 0 ? 'web-' . $id : $row['description'];
}
// Nothing submitted yet, display the delete form
if (!$ui->st('action', 'post')) {
// Check if we could find an entry and if not display 404 page
$template_file = $query->rowCount() > 0 ? 'admin_web_vhost_ri.tpl' : 'admin_404.tpl';
// User submitted remove the entry
} else {
if ($ui->st('action', 'post') == 'ri') {
$vhostObject = new HttpdManagement($webMasterID, $resellerLockupID);
if ($vhostObject != false and $vhostObject->ssh2Connect() and $vhostObject->sftpConnect()) {
$vhostObject->vhostReinstall($id);
$vhostObject->restartHttpdServer();
$template_file = $spracheResponse->table_del;
$loguseraction = '%ri% %webvhost% ' . $dns;
$insertlog->execute();
} else {
$template_file = $spracheResponse->error_table;
}
// GET Request did not add up. Display 404 error.
} else {
$template_file = 'admin_404.tpl';
}
}
// List the available entries
} else {
configureDateTables('-1', '1, "asc"', 'ajax.php?w=datatable&d=webvhost');
$template_file = 'admin_web_vhost_list.tpl';
}
}
}
}
if ($row['state'] == 'A') {
$status = $sprache->status_author;
} else {
if ($row['state'] == 'C') {
$status = $sprache->status_confirmed;
} else {
if ($row['state'] == 'D') {
$status = $sprache->status_done;
} else {
if ($row['state'] == 'N') {
$status = $sprache->status_new;
} else {
if ($row['state'] == 'P') {
$status = $sprache->status_process;
} else {
$status = $sprache->status_reopen;
}
}
}
}
}
$table[] = array('id' => $row['id'], 'priority' => $priority, 'userPriority' => $userPriority, 'writedate' => $row['writedate'], 'supporter' => trim($row['supportername']) != '' ? trim($row['supportername']) : $row['supporter'], 'user_id' => $row['userid'], 'user' => trim($row['username']) != '' ? trim($row['username']) : $row['cname'], 'subject' => $topic, 'status' => $status, 'rawState' => $row['state']);
}
configureDateTables('-1', '1, "DESC"');
$template_file = "admin_tickets_list.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';
}
}
}
$appServer->removeApp($removeTemplates);
}
$query2->execute(array($serverID));
while ($row = $query2->fetch(PDO::FETCH_ASSOC)) {
$started[] = $row['serverip'] . ':' . $row['port'];
$appServer->addApp(array(), true);
}
}
if (count($started) > 0) {
$template_file = $gsSprache->reinstall . ': ' . implode('<br>', $started);
$appServer->execute();
if (isset($dbConnect['debug']) and $dbConnect['debug'] == 1) {
$template_file .= '<br><pre>' . implode("\r\n", $appServer->debug()) . '</pre>';
}
} else {
$template_file = 'admin_404.tpl';
}
} else {
$template_file = 'admin_404.tpl';
}
}
} else {
$template_file = 'admin_404.tpl';
}
} else {
configureDateTables('-1', '1, "asc"', 'ajax.php?w=datatable&d=appserver');
$template_file = 'admin_roots_list.tpl';
}
}
}
}
$logsubuser = 0;
} else {
$logsubuser = isset($_SESSION['oldid']) ? $_SESSION['oldid'] : 0;
$logreseller = 0;
}
$lookUpID = ($reseller_id != 0 and $admin_id != $reseller_id) ? $admin_id : $reseller_id;
if ($ui->st('d', 'get') == 'ud') {
$newsInclude = true;
include EASYWIDIR . '/stuff/methods/feeds_function.php';
} else {
if ($ui->st('d', 'get') == 'md') {
$ids = (array) $ui->active('ids', 'post');
$query = $sql->prepare("DELETE FROM `feeds_news` WHERE `newsID`=? AND `resellerID`=? LIMIT 1");
$query2 = $sql->prepare("UPDATE `feeds_news` SET `active`=? WHERE `newsID`=? AND `resellerID`=?");
foreach ($ids as $id => $values) {
if (isset($values->dl) and $values->dl == 'Y') {
$query->execute(array($id, $lookUpID));
} else {
if (isset($values->active) and $values->active == 'Y') {
$query2->execute(array('Y', $id, $lookUpID));
} else {
$query2->execute(array('N', $id, $lookUpID));
}
}
}
$template_file = $spracheResponse->table_add;
} else {
configureDateTables('-2', '2, "desc"', 'ajax.php?w=datatable&d=feedsnewsentries');
$template_file = 'admin_feeds_entries_list.tpl';
}
}
if (is_array($newHash)) {
$query = $reseller_id == 0 ? $sql->prepare("UPDATE `userdata` SET `updateTime`=NOW(),`security`=?,`salt`=? WHERE id=? AND (`resellerid`=? OR `id`=`resellerid`) LIMIT 1") : $sql->prepare("UPDATE `userdata` SET `updateTime`=NOW(),`security`=?,`salt`=? WHERE id=? AND `resellerid`=? LIMIT 1");
$query->execute(array($newHash['hash'], $newHash['salt'], $id, $resellerLockupID));
} else {
$query = $reseller_id == 0 ? $sql->prepare("UPDATE `userdata` SET `updateTime`=NOW(),`security`=? WHERE id=? AND (`resellerid`=? OR `id`=`resellerid`) LIMIT 1") : $sql->prepare("UPDATE `userdata` SET `updateTime`=NOW(),`security`=? WHERE id=? AND `resellerid`=? LIMIT 1");
$query->execute(array($newHash, $id, $resellerLockupID));
}
// Check if a row was affected meaning an entry could be deleted. If yes add log entry and display success message
if ($query->rowCount() > 0) {
$template_file = $spracheResponse->table_add;
$loguseraction = '%psw% %user% ' . $cname;
$insertlog->execute();
// Nothing was deleted, display an error
} else {
$template_file = $spracheResponse->error_table;
}
}
}
}
// GET Request did not add up. Display 404 error.
} else {
$template_file = 'admin_404.tpl';
}
// List the available entries
} else {
configureDateTables('-1, -2', '1, "asc"', 'ajax.php?w=datatable&d=user');
$template_file = 'admin_user_list.tpl';
}
}
}
}
$query->execute(array($id));
if ($query->fetchColumn() == 1) {
$template_file = $sprache->error_core;
} else {
$query = $sql->prepare("SELECT `file` FROM `modules` WHERE `id`=? LIMIT 1");
$query->execute(array($id));
$moduleFile = $query->fetchColumn();
if ($query->rowCount() > 0) {
if ($ui->st('action', 'post') == 'dl') {
$query = $sql->prepare("DELETE FROM `modules` WHERE `id`=? LIMIT 1");
$query->execute(array($id));
if ($query->rowCount() > 0) {
$template_file = $spracheResponse->table_del;
$loguseraction = '%del% %modules% ' . $moduleFile;
$insertlog->execute();
} else {
$template_file = $spracheResponse->error_table;
}
} else {
$template_file = 'admin_modules_dl.tpl';
}
} else {
$template_file = 'admin_404.tpl';
}
}
} else {
configureDateTables('-1', '1, "asc"', 'ajax.php?w=datatable&d=custommodule');
$template_file = 'admin_modules_list.tpl';
}
}
}
*
* Easy-WI is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with Easy-WI. If not, see <http://www.gnu.org/licenses/>.
*
* Diese Datei ist Teil von Easy-WI.
*
* 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/>.
*/
if (!isset($admin_id) or $main != 1 or isset($admin_id) and !$pa['log']) {
header('Location: admin.php');
die('No acces');
}
$sprache = getlanguagefile('logs', $user_language, $reseller_id);
configureDateTables('', '0, "desc"', 'ajax.php?w=datatable&d=maillog');
$template_file = 'admin_logs_mail.tpl';
$query->execute(array($feedUrl, $id, $lookUpID));
}
if ($query->fetchColumn() > 0) {
$template_file = 'Error: Feed already exists';
} else {
$active = $ui->active('active', 'post');
$query = $sql->prepare("UPDATE `feeds_url` SET `active`=?,`twitter`=?,`feedUrl`=?,`loginName`=? WHERE `feedID`=? AND `resellerID`=? LIMIT 1");
$query->execute(array($active, $twitter, $feedUrl, $loginName, $id, $lookUpID));
$loguseraction = "%mod% Feed {$feedUrl}";
$insertlog->execute();
$template_file = $spracheResponse->table_add;
}
} else {
$query = $sql->prepare("SELECT `active`,`twitter`,`feedUrl`,`loginName` FROM `feeds_url` WHERE `feedID`=? AND `resellerID`=? LIMIT 1");
$query->execute(array($id, $lookUpID));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$active = $row['active'];
$twitter = $row['twitter'];
$feedUrl = $row['feedUrl'];
$loginName = $row['loginName'];
}
$template_file = 'admin_feeds_md.tpl';
}
} else {
configureDateTables('-1', '1, "desc"', 'ajax.php?w=datatable&d=feeds');
$template_file = 'admin_feeds_list.tpl';
}
}
}
}
}
$query = $sql->prepare("SELECT `webVhostID` FROM `webVhost` WHERE `webMasterID`=? AND `resellerID`=?");
$query->execute(array($id, $resellerLockupID));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$table[$row['webVhostID']] = 'web-' . $row['webVhostID'];
}
$template_file = 'admin_web_master_ri.tpl';
} else {
if ($ui->st('action', 'post') == 'ri') {
$insertCount = 0;
$reinstalledVhosts = array();
$ids = (array) $ui->id('dnsID', 10, 'post');
$query = $sql->prepare("SELECT `userID` FROM `webVhost` WHERE `webVhostID`=? AND `resellerID`=?");
$query2 = $sql->prepare("INSERT INTO `jobs` (`api`,`type`,`invoicedByID`,`affectedID`,`hostID`,`userID`,`name`,`status`,`date`,`action`,`extraData`,`resellerid`) VALUES ('S','wv',?,?,?,?,?,NULL,NOW(),'ri','',?)");
foreach ($ids as $v) {
$query->execute(array($v, $resellerLockupID));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$reinstalledVhosts[] = 'web-' . $v;
$query2->execute(array($admin_id, $v, $id, $row['userID'], 'web-' . $v, $resellerLockupID));
$insertCount += $query2->rowCount();
}
}
$template_file = $insertCount > 0 ? $spracheResponse->reinstall_success . ': ' . implode(', ', $reinstalledVhosts) : 'admin_404.tpl';
}
}
// List the available entries
} else {
configureDateTables('-1', '1, "asc"', 'ajax.php?w=datatable&d=webmasterserver');
$template_file = 'admin_web_master_list.tpl';
}
}
}
$template_file = $return ? $spracheResponse->ts_query_success . $return : $spracheResponse->error_table;
if ($ui->w('banType', 1, 'post') == 'U') {
$connection->clientKick($volocalserverid, $ui->id('clientUID', 19, 'post'));
}
} else {
$error = $sprache->banErrorData;
$template_file = 'userpanel_voiceserver_ban_ad.tpl';
}
} else {
if (!$ui->st('action', 'post') and $ui->st('e', 'get') == 'ad') {
$userList = $connection->getClientList($volocalserverid);
$template_file = 'userpanel_voiceserver_ban_ad.tpl';
} else {
$banList = $connection->banList($volocalserverid);
$template_file = 'userpanel_voiceserver_ban_list.tpl';
configureDateTables('-1', '0, "asc"');
}
}
}
}
} else {
$template_file = 'userpanel_404.tpl';
}
} else {
$table = array();
$o = $ui->st('o', 'get');
if ($ui->st('o', 'get') == 'aa') {
$orderby = 'v.`ip` ASC, v.`port` ASC';
} else {
if ($ui->st('o', 'get') == 'da') {
$orderby = 'v.`ip` DESC, v.`port` DESC';
if ($query->rowCount() > 0) {
$appServer = new AppServer($rootID);
$appServer->getAppServerDetails($id);
if ($ui->st('d', 'get') == 'rs') {
$appServer->startApp();
$template_file = $sprache->serverrestart;
$loguseraction = '%start% %gserver% ' . $gsip . ':' . $port;
} else {
if ($ui->st('d', 'get') == 'st') {
$appServer->stopApp();
$template_file = $sprache->serverstop;
$loguseraction = '%stop% %gserver% ' . $gsip . ':' . $port;
}
}
$return = $appServer->execute();
if (isset($dbConnect['debug']) and $dbConnect['debug'] == 1) {
$template_file .= '<br><pre>' . implode("\r\n", $appServer->debug()) . '</pre>';
}
$insertlog->execute();
} else {
$template_file = 'admin_404.tpl';
}
// List the available entries
} else {
configureDateTables('-1, -2', '0, "asc"', 'ajax.php?w=datatable&d=gameserver');
$template_file = 'admin_gserver_list.tpl';
}
}
}
}
}
