$jobPending = $gsprache->del; } else { $jobPending = $gsprache->mod; } } $json = @json_decode($row2['extraData']); $row['status'] = (is_object($json) and isset($json->newActive) and $json->newActive == 'N') ? 2 : 0; } if ($query2->rowCount() == 0) { $query3->execute(array($row['id'], $resellerLockupID)); } } if ($row['active'] == 'N') { $statusMessage = $gsprache->status_inactive; } else { if ($row['uptime'] == 1) { $statusMessage = $gsprache->status_stop; } else { if ($row['uptime'] < 1) { $statusMessage = $gsprache->status_crashed; } else { if ($row['password'] == 'Y' and $row['queryPassword'] == 'N') { $statusMessage = $gsprache->status_password; } } } } $password = ($row['initialpassword'] != null and $row['initialpassword'] != '') ? '?password='******'initialpassword'] : ''; $server = ($row['usedns'] == 'Y' and $row['dns'] != null or $row['dns'] != '') ? '<a href="ts3server://' . $row['dns'] . $password . '">' . $row['ip'] . ':' . $row['port'] . '</a> ( ' . $row['dns'] . ' )' : '<a href="ts3server://' . $row['ip'] . ':' . $row['port'] . $password . '">' . $row['ip'] . ':' . $row['port'] . '</a>'; $array['aaData'][] = array($server, $row['id'], returnButton($template_to_use, 'ajax_admin_show_status.tpl', '', '', $row['status'], (string) $statusMessage), $row['localserverid'], returnButton($template_to_use, 'ajax_admin_user_switch.tpl', $row['cname'], $row['full_name'], $row['userid'], ''), (int) $row['usedslots'] . '/' . (int) $row['slots'], (string) $jobPending, returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'vo', 'dl', $row['id'], $gsprache->del) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_md.tpl', 'vo', 'md', $row['id'], $gsprache->mod)); }
} $query = $sql->prepare("SELECT COUNT(`newsID`) AS `amount` FROM `feeds_news` WHERE `resellerID`=?"); $query->execute(array($resellerLockupID)); $array['iTotalRecords'] = $query->fetchColumn(); if ($sSearch) { $query = $sql->prepare("SELECT COUNT(`newsID`) AS `amount` FROM `feeds_news` WHERE `resellerID`=:reseller_id AND (`newsID` LIKE :search OR `pubDate` LIKE :search OR ((LENGTH(`title`)<2 AND `link` LIKE :search) OR (LENGTH(`title`)>1 AND `title` LIKE :search)))"); $query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); $array['iTotalDisplayRecords'] = $query->fetchColumn(); } else { $array['iTotalDisplayRecords'] = $array['iTotalRecords']; } $orderFields = array(0 => 'n.`title`', 1 => 'n.`newsID`', 2 => 'n.`pubDate`'); 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 = 'n.`newsID` ASC'; } } if ($sSearch) { $query = $sql->prepare("SELECT n.`newsID`,n.`title`,n.`link`,n.`pubDate`,n.`active` FROM `feeds_news` n LEFT JOIN `feeds_url` u ON n.`feedID`=u.`feedID` WHERE n.`resellerID`=:reseller_id AND (n.`newsID` LIKE :search OR n.`pubDate` LIKE :search OR ((LENGTH(n.`title`)<2 AND n.`link` LIKE :search) OR (LENGTH(n.`title`)>1 AND n.`title` LIKE :search))) ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); } else { $query = $sql->prepare("SELECT n.`newsID`,n.`title`,n.`link`,n.`pubDate`,n.`active` FROM `feeds_news` n LEFT JOIN `feeds_url` u ON n.`feedID`=u.`feedID` WHERE n.`resellerID`=? ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array($resellerLockupID)); } while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $array['aaData'][] = array(strlen($row['title']) < 2 ? $row['link'] : $row['title'], $row['newsID'], $row['pubDate'], returnButton($template_to_use, 'ajax_admin_feed_active.tpl', $row['active'], '', $row['newsID'], ''), returnButton($template_to_use, 'ajax_admin_feed_del.tpl', '', '', $row['newsID'], '') . returnButton($template_to_use, 'ajax_admin_feed_hidden.tpl', '', '', $row['newsID'], '')); }
} } $json = @json_decode($row2['extraData']); $row['active'] = (is_object($json) and isset($json->newActive)) ? $json->newActive : 'N'; } if ($query2->rowCount() == 0) { $query3->execute(array($row['id'], $row['resellerid'])); } } $statusMessage = $row['active'] == 'N' ? $gsprache->status_inactive : $gsprache->status_ok; if ($row['accounttype'] == 'a') { $accounttype = $sprache->accounttype_admin; } else { if ($row['accounttype'] == 'r') { $accounttype = $sprache->accounttype_reseller; } else { $accounttype = $sprache->accounttype_user; } } $actionString = ''; if ($pa['userPassword'] and ($row['accounttype'] == 'a' and $pa['user'] or $row['accounttype'] != 'a')) { $actionString .= ' ' . returnButton($template_to_use, 'ajax_admin_buttons_pw.tpl', 'us', 'pw', $row['id'], $gsprache->password); } if ($row['id'] != $admin_id and ($row['accounttype'] == 'a' and $pa['user'] or $row['accounttype'] != 'a' and ($pa['user_users'] or $pa['user']))) { $actionString .= ' ' . returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'us', 'dl', $row['id'], $gsprache->del); } if ($row['accounttype'] == 'a' and $pa['user'] or $row['accounttype'] != 'a' and ($pa['user_users'] or $pa['user'])) { $actionString .= ' ' . returnButton($template_to_use, 'ajax_admin_buttons_md.tpl', 'us', 'md', $row['id'], $gsprache->mod); } $array['aaData'][] = array(returnButton($template_to_use, 'ajax_admin_user_switch.tpl', $row['cname'], '', $row['id'], ''), $row['id'], $row['full_name'], returnButton($template_to_use, 'ajax_admin_show_status.tpl', '', '', $row['active'] == 'N' ? 3 : 4, (string) $statusMessage), (string) $accounttype, (string) $jobPending, $actionString); }
$failLogins = (int) $query->fetchColumn(); $query = $sql->prepare("SELECT COUNT(1) AS `amount` FROM `badips`"); $query->execute(array($resellerLockupID)); $array['iTotalRecords'] = $query->fetchColumn(); if ($sSearch) { $query = $sql->prepare("SELECT COUNT(1) AS `amount` FROM `badips` WHERE `badip` LIKE :search OR `id` LIKE :search OR `bantime` LIKE :search OR `failcount` LIKE :search OR `reason` LIKE :search"); $query->execute(array(':search' => '%' . $sSearch . '%')); $array['iTotalDisplayRecords'] = $query->fetchColumn(); } else { $array['iTotalDisplayRecords'] = $array['iTotalRecords']; } $orderFields = array(0 => '`badip`', 1 => '`id`', 2 => '`bantime`', 3 => '`failcount`', 4 => '`reason`'); 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 = '`logdate` DESC'; } } if ($sSearch) { $query = $sql->prepare("SELECT * FROM `badips` WHERE `badip` LIKE :search OR `id` LIKE :search OR `bantime` LIKE :search OR `failcount` LIKE :search OR `reason` LIKE :search ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array(':search' => '%' . $sSearch . '%')); } else { $query = $sql->prepare("SELECT * FROM `badips` ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(); } while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $array['aaData'][] = array($row['badip'], $row['id'], $row['bantime'], $row['failcount'] . '/' . $failLogins, $row['reason'], returnButton($template_to_use, 'ajax_admin_job_checkbox.tpl', '', '', $row['id'], '')); }
$jobPending = $gsprache->mod; } } $json = @json_decode($row2['extraData']); $row['status'] = (is_object($json) and isset($json->newActive) and $json->newActive == 'N') ? 2 : 0; } if ($query2->rowCount() == 0) { $query3->execute(array($row['id'], $resellerLockupID)); } } if ($row['active'] == 'N') { $statusMessage = $gsprache->status_inactive; } else { if ($row['stopped'] == 'Y') { $statusMessage = $gsprache->status_stop; } else { if ($row['queryName'] == 'OFFLINE' and $row['notified'] >= $rSA['down_checks'] and $row['stopped'] == 'N') { $statusMessage = $gsprache->status_crashed; } else { if ($row['war'] == 'Y' and $row['queryPassword'] == 'N') { $statusMessage = $gsprache->status_password; } else { if ($row['brandname'] == 'Y' and $rSA['brandname'] != null and $rSA['brandname'] != '' and strpos(strtolower($row['queryName']), strtolower($rSA['brandname'])) === false) { $statusMessage = $gsprache->status_server_tag; } } } } } $array['aaData'][] = array(returnButton($template_to_use, 'ajax_admin_gameserver_icon.tpl', $row['shorten'], '', '', '') . ' ' . $row['address'], $row['id'], returnButton($template_to_use, 'ajax_admin_show_status.tpl', '', '', $row['status'], (string) $statusMessage), returnButton($template_to_use, 'ajax_admin_user_switch.tpl', $row['cname'], $row['full_name'], $row['userid'], ''), (string) $jobPending, returnButton($template_to_use, 'ajax_admin_buttons_rs.tpl', 'gs', 'rs', $row['id'], $gsprache->start) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_st.tpl', 'gs', 'st', $row['id'], $gsprache->stop), returnButton($template_to_use, 'ajax_admin_buttons_ri.tpl', 'gs', 'ri', $row['id'], $gsprache->reinstall) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'gs', 'dl', $row['id'], $gsprache->del) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_md.tpl', 'gs', 'md', $row['id'], $gsprache->mod)); }
$orderBy = implode(' ' . $sSortDir . ', ', $orderFields[$iSortCol]) . ' ' . $sSortDir; } else { if (isset($orderFields[$iSortCol]) and !is_array($orderFields[$iSortCol])) { $orderBy = $orderFields[$iSortCol] . ' ' . $sSortDir; } else { $orderBy = 'm.`id` DESC'; } } if ($sSearch) { $query = $sql->prepare("SELECT m.*,COUNT(s.`id`) AS `installedserver`,SUM(s.`slots`) AS `installedslots`,SUM(s.`usedslots`) AS `uslots` FROM `voice_masterserver` AS m LEFT JOIN `voice_server` s ON m.`id`=s.`masterserver` WHERE (m.`resellerid`=:reseller_id OR m.`managedForID`=:reseller_id) AND (m.`ssh2ip` LIKE :search OR m.`id` LIKE :search OR m.`description` LIKE :search) GROUP BY m.`id` ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); } else { $query = $sql->prepare("SELECT m.*,COUNT(s.`id`) AS `installedserver`,SUM(s.`slots`) AS `installedslots`,SUM(s.`usedslots`) AS `uslots` FROM `voice_masterserver` AS m LEFT JOIN `voice_server` s ON m.`id`=s.`masterserver` WHERE (m.`resellerid`=? OR m.`managedForID`=?) GROUP BY m.`id` ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array($resellerLockupID, $resellerLockupID)); } while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $status = 4; $statusMessage = $gsprache->status_ok; if ($row['local_version'] != $row['latest_version']) { $status = 2; $statusMessage = $sprache->old_version . ' ' . $row['local_version']; } if ($row['active'] == 'N') { $status = 3; $statusMessage = $gsprache->status_inactive; } $installedslots = $row['installedslots'] == null ? 0 : $row['installedslots']; $aaDataArray = array($row['ssh2ip'], $row['id'], returnButton($template_to_use, 'ajax_admin_show_status.tpl', '', '', $status, (string) $statusMessage), $row['description'], $row['installedserver'] . '/' . $row['maxserver'], $installedslots . '/' . $row['maxslots']); $aaDataArray[] = ($row['managedServer'] == 'N' or $reseller_id == 0) ? returnButton($template_to_use, 'ajax_admin_buttons_ri.tpl', 'vm', 'ri', $row['id'], $sprache->import) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'vm', 'dl', $row['id'], $gsprache->del) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_md.tpl', 'vm', 'md', $row['id'], $gsprache->mod) : ''; $array['aaData'][] = $aaDataArray; }
$query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); $array['iTotalDisplayRecords'] = $query->fetchColumn(); } else { $array['iTotalDisplayRecords'] = $array['iTotalRecords']; } $orderFields = array(0 => '`ip`', 1 => 'm.`webMasterID`', 2 => 'm.`active`', 3 => 'm.`description`', 4 => '`vhostsInstalled`', 5 => '`hddUsed`'); 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 = 'm.`webMasterID` DESC'; } } if ($sSearch) { $query = $sql->prepare("SELECT m.`webMasterID`,m.`ip`,m.`active`,m.`description`,m.`maxVhost`,m.`maxHDD`,COUNT(v.`webVhostID`) AS `vhostsInstalled`,SUM(v.`hdd`) AS `hddUsed` FROM `webMaster` AS m LEFT JOIN `webVhost` v ON m.`webMasterID`=v.`webMasterID` WHERE m.`resellerID`=:reseller_id AND (m.`ip` LIKE :search OR m.`webMasterID` LIKE :search OR m.`description` LIKE :search) GROUP BY m.`webMasterID` ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); } else { $query = $sql->prepare("SELECT m.`webMasterID`,m.`ip`,m.`active`,m.`description`,m.`maxVhost`,m.`maxHDD`,COUNT(v.`webVhostID`) AS `vhostsInstalled`,SUM(v.`hdd`) AS `hddUsed` FROM `webMaster` AS m LEFT JOIN `webVhost` v ON m.`webMasterID`=v.`webMasterID` WHERE m.`resellerID`=? GROUP BY m.`webMasterID` ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array($resellerLockupID)); } while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $status = 4; $statusMessage = $gsprache->status_ok; if ($row['active'] == 'N') { $status = 3; $statusMessage = $gsprache->status_inactive; } $array['aaData'][] = array($row['ip'], $row['webMasterID'], returnButton($template_to_use, 'ajax_admin_show_status.tpl', '', '', $status, (string) $statusMessage), $row['description'], (int) $row['vhostsInstalled'] . '/' . (int) $row['maxVhost'], (int) $row['hddUsed'] . '/' . (int) $row['maxHDD'], returnButton($template_to_use, 'ajax_admin_buttons_ri.tpl', 'wm', 'ri', $row['webMasterID'], $gsprache->reinstall) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'wm', 'dl', $row['webMasterID'], $gsprache->del) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_md.tpl', 'wm', 'md', $row['webMasterID'], $gsprache->mod)); }
$query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); $array['iTotalDisplayRecords'] = $query->fetchColumn(); } else { $array['iTotalDisplayRecords'] = $array['iTotalRecords']; } $orderFields = array(0 => 's.`ip`', 1 => 's.`id`', 2 => 's.`interface`', 3 => array('`installed_databases`', 's.`max_databases`')); 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 = 's.`id` ASC'; } } if ($sSearch) { $query = $sql->prepare("SELECT s.`id`,s.`active`,s.`ip`,s.`interface`,s.`max_databases`,(SELECT COUNT(1) AS `amount` FROM `mysql_external_dbs` AS d WHERE d.`sid`=s.`id`) AS `installed_databases` FROM `mysql_external_servers` AS s WHERE s.`resellerid`=:reseller_id AND (s.`id` LIKE :search OR s.`ip` LIKE :search OR s.`interface` LIKE :search {$statusQuery}) ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); } else { $query = $sql->prepare("SELECT s.`id`,s.`active`,s.`ip`,s.`interface`,s.`max_databases`,(SELECT COUNT(1) AS `amount` FROM `mysql_external_dbs` AS d WHERE d.`sid`=s.`id`) AS `installed_databases` FROM `mysql_external_servers` AS s WHERE s.`resellerid`=? ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array($resellerLockupID)); } while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $status = 4; $statusMessage = $gsprache->status_ok; if ($row['active'] == 'N') { $status = 3; $statusMessage = $gsprache->status_inactive; } $array['aaData'][] = array($row['ip'], $row['id'], returnButton($template_to_use, 'ajax_admin_show_status.tpl', '', '', $status, (string) $statusMessage), '<a href="' . $row['interface'] . '" target="_blank">' . $row['interface'] . '</a>', (int) $row['installed_databases'] . '/' . (int) $row['max_databases'], returnButton($template_to_use, 'ajax_admin_buttons_ri.tpl', 'my', 'ri', $row['id'], $gsprache->reinstall) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'my', 'dl', $row['id'], $gsprache->del) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_md.tpl', 'my', 'md', $row['id'], $gsprache->mod)); }
$query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); $array['iTotalDisplayRecords'] = $query->fetchColumn(); } else { $array['iTotalDisplayRecords'] = $array['iTotalRecords']; } $orderFields = array(0 => '`ssh2ip`', 1 => 'm.`id`', 2 => 'm.`active`', 3 => '`description`', 4 => '`defaultdns`', 5 => '`installed_dns`'); 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 = 'm.`id` DESC'; } } if ($sSearch) { $query = $sql->prepare("SELECT m.*,COUNT(d.`dnsID`) AS `installed_dns` FROM `voice_tsdns` AS m LEFT JOIN `voice_dns` d ON d.`tsdnsID`=m.`id` WHERE m.`resellerid`=:reseller_id AND (m.`ssh2ip` LIKE :search OR m.`id` LIKE :search OR m.`description` LIKE :search OR `defaultdns` LIKE :search) GROUP BY m.`id` ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); } else { $query = $sql->prepare("SELECT m.*,COUNT(d.`dnsID`) AS `installed_dns` FROM `voice_tsdns` AS m LEFT JOIN `voice_dns` d ON d.`tsdnsID`=m.`id` WHERE m.`resellerid`=? GROUP BY m.`id` ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array($resellerLockupID)); } while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $status = 4; $statusMessage = $gsprache->status_ok; if ($row['active'] == 'N') { $status = 3; $statusMessage = $gsprache->status_inactive; } $array['aaData'][] = array($row['ssh2ip'], $row['id'], returnButton($template_to_use, 'ajax_admin_show_status.tpl', '', '', $status, (string) $statusMessage), $row['description'], $row['defaultdns'], $row['installed_dns'] . '/' . $row['max_dns'], returnButton($template_to_use, 'ajax_admin_buttons_ri.tpl', 'vd', 'ip', $row['id'], $sprache->import) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'vd', 'dl', $row['id'], $gsprache->del) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_md.tpl', 'vd', 'md', $row['id'], $gsprache->mod)); }
$query2 = $sql->prepare("SELECT `action`,`extraData` FROM `jobs` WHERE `affectedID`=? AND `resellerID`=? AND `type`='my' AND (`status` IS NULL OR `status`=1) ORDER BY `jobID` DESC LIMIT 1"); $query3 = $sql->prepare("UPDATE `mysql_external_dbs` SET `jobPending`='N' WHERE `id`=? AND `resellerid`=? LIMIT 1"); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $jobPending = $gsprache->no; $status = 4; $statusMessage = $gsprache->status_ok; if ($row['jobPending'] == 'Y') { $query2->execute(array($row['id'], $resellerLockupID)); while ($row2 = $query2->fetch(PDO::FETCH_ASSOC)) { if ($row2['action'] == 'ad') { $jobPending = $gsprache->add; } else { if ($row2['action'] == 'dl') { $jobPending = $gsprache->del; } else { $jobPending = $gsprache->mod; } } $json = @json_decode($row2['extraData']); $row['status'] = (is_object($json) and isset($json->newActive) and $json->newActive == 'N') ? 2 : 0; } if ($query2->rowCount() == 0) { $query3->execute(array($row['id'], $resellerLockupID)); } } if ($row['active'] == 'N') { $status = 3; $statusMessage = $gsprache->status_inactive; } $array['aaData'][] = array($row['dbname'], $row['id'], returnButton($template_to_use, 'ajax_admin_show_status.tpl', '', '', $status, (string) $statusMessage), $row['description'], returnButton($template_to_use, 'ajax_admin_user_switch.tpl', $row['cname'], $row['full_name'], $row['uid'], ''), (string) $jobPending, returnButton($template_to_use, 'ajax_admin_buttons_ri.tpl', 'md', 'ri', $row['id'], $gsprache->reinstall) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'md', 'dl', $row['id'], $gsprache->del) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_md.tpl', 'md', 'md', $row['id'], $gsprache->mod)); }
if (strpos(strtolower($value), strtolower($sSearch)) !== false) { $translationTypeKeys[] = $key; } } $translationInQuery .= count($translationTypeKeys) > 0 ? ' OR m.`type` IN (\'' . implode("','", $translationTypeKeys) . '\')' : ''; $query = $sql->prepare("SELECT COUNT(`id`) AS `amount` FROM `modules` AS m WHERE `id` LIKE :search {$translationInQuery}"); $query->execute(array(':search' => '%' . $sSearch . '%')); $array['iTotalDisplayRecords'] = $query->fetchColumn(); } else { $array['iTotalDisplayRecords'] = $array['iTotalRecords']; } $orderFields = array(0 => '`name`', 1 => 'm.`id`', 2 => 'm.`active`', 3 => 'm.`type`'); 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 = 'm.`id` ASC'; } } if ($sSearch) { $query = $sql->prepare("SELECT m.*,(SELECT `text` FROM `translations` WHERE `type`='mo' AND `transID`=m.`id` AND `lang`=:lang LIMIT 1) AS `name` FROM `modules` AS m WHERE m.`id` LIKE :search {$translationInQuery} ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array(':lang' => $user_language, ':search' => '%' . $sSearch . '%')); } else { $query = $sql->prepare("SELECT m.*,(SELECT `text` FROM `translations` WHERE `type`='mo' AND `transID`=m.`id` AND `lang`=? LIMIT 1) AS `name` FROM `modules` AS m ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array($user_language)); } while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $array['aaData'][] = array($row['name'], $row['id'], returnButton($template_to_use, 'ajax_admin_show_status.tpl', '', '', $row['active'] == 'N' ? 2 : 4, ''), (string) $types[$row['type']], returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'mo', 'dl', $row['id'], $gsprache->del) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_md.tpl', 'mo', 'md', $row['id'], $gsprache->mod)); }
$query2 = $sql->prepare("SELECT `action`,`extraData` FROM `jobs` WHERE `affectedID`=? AND `resellerID`=? AND `type`='wv' AND (`status` IS NULL OR `status`=1) ORDER BY `jobID` DESC LIMIT 1"); $query3 = $sql->prepare("UPDATE `webVhost` SET `jobPending`='N' WHERE `webVhostID`=? AND `resellerID`=? LIMIT 1"); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $jobPending = $gsprache->no; $status = 4; $statusMessage = $gsprache->status_ok; if ($row['jobPending'] == 'Y') { $query2->execute(array($row['id'], $resellerLockupID)); while ($row2 = $query2->fetch(PDO::FETCH_ASSOC)) { if ($row2['action'] == 'ad') { $jobPending = $gsprache->add; } else { if ($row2['action'] == 'dl') { $jobPending = $gsprache->del; } else { $jobPending = $gsprache->mod; } } $json = @json_decode($row2['extraData']); $row['status'] = (is_object($json) and isset($json->newActive) and $json->newActive == 'N') ? 2 : 0; } if ($query2->rowCount() == 0) { $query3->execute(array($row['id'], $resellerLockupID)); } } if ($row['active'] == 'N') { $status = 3; $statusMessage = $gsprache->status_inactive; } $array['aaData'][] = array(strlen($row['description']) == 0 ? 'web-' . $row['webVhostID'] : $row['description'], $row['webVhostID'], returnButton($template_to_use, 'ajax_admin_show_status.tpl', '', '', $status, (string) $statusMessage), returnButton($template_to_use, 'ajax_admin_user_switch.tpl', $row['cname'], $row['full_name'], $row['userID'], ''), (int) $row['hddUsage'] . '/' . (int) $row['hdd'], (string) $jobPending, returnButton($template_to_use, 'ajax_admin_buttons_ri.tpl', 'wv', 'ri', $row['webVhostID'], $gsprache->reinstall) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'wv', 'dl', $row['webVhostID'], $gsprache->del) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_md.tpl', 'wv', 'md', $row['webVhostID'], $gsprache->mod)); }
} $query = $sql->prepare("SELECT COUNT(`feedID`) AS `amount` FROM `feeds_url` WHERE `resellerID`=?"); $query->execute(array($resellerLockupID)); $array['iTotalRecords'] = $query->fetchColumn(); if ($sSearch) { $query = $sql->prepare("SELECT COUNT(`feedID`) AS `amount` FROM `feeds_url` WHERE `resellerID`=:reseller_id AND (`feedID` LIKE :search OR `feedUrl` LIKE :search)"); $query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); $array['iTotalDisplayRecords'] = $query->fetchColumn(); } else { $array['iTotalDisplayRecords'] = $array['iTotalRecords']; } $orderFields = array(0 => '`feedUrl`', 1 => '`feedID`', 2 => '`active`'); 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 = '`feedID` DESC'; } } if ($sSearch) { $query = $sql->prepare("SELECT `feedID`,`feedUrl` FROM `feeds_url` WHERE `resellerID`=:reseller_id AND (`feedID` LIKE :search OR `feedUrl` LIKE :search) ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); } else { $query = $sql->prepare("SELECT `feedID`,`feedUrl` FROM `feeds_url` WHERE `resellerID`=? ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array($resellerLockupID)); } while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $array['aaData'][] = array($row['feedUrl'], $row['feedID'], returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'fe', 'dl', $row['feedID'], $gsprache->del) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_md.tpl', 'fe', 'md', $row['feedID'], $gsprache->mod)); }
$query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $addonShortenIDs[] = $row['addon_id']; } $addonInQuery = count($addonShortenIDs) > 0 ? ' OR `id` IN (' . implode(',', $addonShortenIDs) . ')' : ''; $query = $sql->prepare("SELECT COUNT(`id`) AS `amount` FROM `addons` WHERE `resellerid`=:reseller_id AND (`id` LIKE :search OR `type` LIKE :search OR `menudescription` LIKE :search {$addonInQuery})"); $query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); $array['iTotalDisplayRecords'] = $query->fetchColumn(); } else { $array['iTotalDisplayRecords'] = $array['iTotalRecords']; } $orderFields = array(0 => 'a.`menudescription`', 1 => 'a.`id`', 2 => 'a.`type`', 3 => '`list`'); 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 = 'a.`id` ASC'; } } if ($sSearch) { $query = $sql->prepare("SELECT a.`id`,a.`menudescription`,a.`type`,(SELECT GROUP_CONCAT(DISTINCT s.`shorten` ORDER BY s.`shorten` ASC SEPARATOR ', ') AS `list` FROM `addons_allowed` AS al INNER JOIN `servertypes` AS s ON al.`servertype_id`=s.`id` WHERE al.`addon_id`=a.`id`) AS `list` FROM `addons` AS a WHERE a.`resellerid`=:reseller_id AND (`id` LIKE :search OR `type` LIKE :search OR `menudescription` LIKE :search {$addonInQuery}) ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); } else { $query = $sql->prepare("SELECT a.`id`,a.`menudescription`,a.`type`,(SELECT GROUP_CONCAT(DISTINCT s.`shorten` ORDER BY s.`shorten` ASC SEPARATOR ', ') AS `list` FROM `addons_allowed` AS al INNER JOIN `servertypes` AS s ON al.`servertype_id`=s.`id` WHERE al.`addon_id`=a.`id`) AS `list` FROM `addons` AS a WHERE a.`resellerid`=? ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array($resellerLockupID)); } while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $array['aaData'][] = array($row['menudescription'], $row['id'], $row['type'] == 'map' ? (string) $sprache->map : (string) $sprache->tool, $row['list'], returnButton($template_to_use, 'ajax_admin_buttons_ex.tpl', 'ad', 'ex', $row['id'], $gsprache->export) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'ad', 'dl', $row['id'], $gsprache->del) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_md.tpl', 'ad', 'md', $row['id'], $gsprache->mod)); }
} $query = $sql->prepare("SELECT COUNT(`id`) AS `amount` FROM `servertypes` WHERE `resellerid`=?"); $query->execute(array($resellerLockupID)); $array['iTotalRecords'] = $query->fetchColumn(); if ($sSearch) { $query = $sql->prepare("SELECT COUNT(`id`) AS `amount` FROM `servertypes` WHERE `resellerid`=:reseller_id AND (`id` LIKE :search OR `shorten` LIKE :search OR `description` LIKE :search)"); $query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); $array['iTotalDisplayRecords'] = $query->fetchColumn(); } else { $array['iTotalDisplayRecords'] = $array['iTotalRecords']; } $orderFields = array(0 => '`description`', 1 => '`id`', 2 => '`shorten`'); 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 = '`id` ASC'; } } if ($sSearch) { $query = $sql->prepare("SELECT `id`,`shorten`,`description` FROM `servertypes` WHERE `resellerid`=:reseller_id AND (`id` LIKE :search OR `shorten` LIKE :search OR `description` LIKE :search) ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); } else { $query = $sql->prepare("SELECT `id`,`shorten`,`description` FROM `servertypes` WHERE `resellerid`=? ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array($resellerLockupID)); } while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $array['aaData'][] = array($row['description'], $row['id'], $row['shorten'], returnButton($template_to_use, 'ajax_admin_buttons_ex.tpl', 'im', 'ex', $row['id'], $gsprache->export) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'im', 'dl', $row['id'], $gsprache->del) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_md.tpl', 'im', 'md', $row['id'], $gsprache->mod)); }
if ($checkReturn === false) { $description = 'The login data does not work'; } else { if (strlen($checkReturn) > 0) { $games = array(); foreach (preg_split('/\\;/', $checkReturn, -1, PREG_SPLIT_NO_EMPTY) as $status) { $ex = explode('=', $status); if (isset($ex[1])) { $games[$ex[0]] = $ex[1]; } } foreach ($games as $shorten => $v) { // Check if the shorten exists and the update is done $query3->execute(array($shorten, $resellerLockupID, $rootServer->sship)); while ($row3 = $query3->fetch(PDO::FETCH_ASSOC)) { // If the update is no longer running, update db entry if ($v == 0) { $statusList[$shorten] = true; $query4->execute(array($row3['id'])); unset($sshcheck[array_search($shorten, $sshcheck)]); } } } } } foreach ($sshcheck as $shorten) { $statusList[$shorten] = false; } } $array['aaData'][] = array($row['ip'], $row['id'], $description, returnButton($template_to_use, 'ajax_admin_master_list.tpl', $statusList, '', '', ''), returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'ma', 'dl', $row['id'], $gsprache->del) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_add.tpl', 'ma', 'ad', $row['id'], $gsprache->add)); }
} $orderFields = array(0 => 'r.`ip`', 1 => 'r.`id`', 2 => 'r.`active`', 3 => 'r.`description`', 4 => '`gameserver_amount`', 5 => '`gameserver_ram`'); 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 = 'r.`id` ASC'; } } if ($sSearch) { if ($reseller_id == 0) { $query = $sql->prepare("SELECT r.`id`,r.`ip`,r.`active`,r.`description`,r.`maxserver`,r.`ram`,r.`os`,(SELECT COUNT(1) AS `amount` FROM `gsswitch` g WHERE g.`rootID`=r.`id`) AS `gameserver_amount`,(SELECT SUM(`maxram`) AS `amount` FROM `gsswitch` g WHERE g.`rootID`=r.`id`) AS `gameserver_ram` FROM `rserverdata` r WHERE r.`id` LIKE :search OR r.`ip` LIKE :search OR r.`description` LIKE :search ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array(':search' => '%' . $sSearch . '%')); } else { $query = $sql->prepare("SELECT r.`id`,r.`ip`,r.`active`,r.`description`,r.`maxserver`,r.`ram`,r.`os`,(SELECT COUNT(1) AS `amount` FROM `gsswitch` g WHERE g.`rootID`=r.`id`) AS `gameserver_amount`,(SELECT SUM(`maxram`) AS `amount` FROM `gsswitch` g WHERE g.`rootID`=r.`id`) AS `gameserver_ram` FROM `rserverdata` r WHERE (r.`resellerid`=:reseller_id OR EXISTS (SELECT 1 FROM `userdata` WHERE `resellerid`=:reseller_id AND `id`=r.`resellerid`)) AND (r.`id` LIKE :search OR r.`ip` LIKE :search OR r.`description` LIKE :search) ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array(':search' => '%' . $sSearch . '%', ':reseller_id' => $resellerLockupID)); } } else { if ($reseller_id == 0) { $query = $sql->prepare("SELECT r.`id`,r.`ip`,r.`active`,r.`description`,r.`maxserver`,r.`ram`,r.`os`,(SELECT COUNT(1) AS `amount` FROM `gsswitch` g WHERE g.`rootID`=r.`id`) AS `gameserver_amount`,(SELECT SUM(`maxram`) AS `amount` FROM `gsswitch` g WHERE g.`rootID`=r.`id`) AS `gameserver_ram` FROM `rserverdata` r ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(); } else { $query = $sql->prepare("SELECT r.`id`,r.`ip`,r.`active`,r.`description`,r.`maxserver`,r.`ram`,r.`os`,(SELECT COUNT(1) AS `amount` FROM `gsswitch` g WHERE g.`rootID`=r.`id`) AS `gameserver_amount`,(SELECT SUM(`maxram`) AS `amount` FROM `gsswitch` g WHERE g.`rootID`=r.`id`) AS `gameserver_ram` FROM `rserverdata` r WHERE r.`resellerid`=:reseller_id OR EXISTS (SELECT 1 FROM `userdata` WHERE `resellerid`=:reseller_id AND `id`=r.`resellerid`) ORDER BY {$orderBy} LIMIT {$iDisplayStart},{$iDisplayLength}"); $query->execute(array(':reseller_id' => $resellerLockupID)); } } while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $array['aaData'][] = array($row['ip'], $row['id'], $row['active'] == 'Y' ? (string) $gsprache->yes : (string) $gsprache->no, $row['description'], (int) $row['gameserver_amount'] . '/' . (int) $row['maxserver'], (int) $row['gameserver_ram'] . '/' . (int) $row['ram'], returnButton($template_to_use, 'ajax_admin_buttons_ri.tpl', 'ro', 'ri', $row['id'], $gsprache->reinstall) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'ro', 'dl', $row['id'], $gsprache->del) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_md.tpl', 'ro', 'md', $row['id'], $gsprache->mod)); }
$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)); }
$query2 = $sql->prepare("SELECT `action`,`extraData` FROM `jobs` WHERE `affectedID`=? AND `resellerID`=? AND `type`='ds' AND (`status` IS NULL OR `status`=1) ORDER BY `jobID` DESC LIMIT 1"); $query3 = $sql->prepare("UPDATE `voice_dns` SET `jobPending`='N' WHERE `dnsID`=? AND `resellerID`=? LIMIT 1"); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $jobPending = $gsprache->no; $status = 4; $statusMessage = $gsprache->status_ok; if ($row['jobPending'] == 'Y') { $query2->execute(array($row['id'], $resellerLockupID)); while ($row2 = $query2->fetch(PDO::FETCH_ASSOC)) { if ($row2['action'] == 'ad') { $jobPending = $gsprache->add; } else { if ($row2['action'] == 'dl') { $jobPending = $gsprache->del; } else { $jobPending = $gsprache->mod; } } $json = @json_decode($row2['extraData']); $row['status'] = (is_object($json) and isset($json->newActive) and $json->newActive == 'N') ? 2 : 0; } if ($query2->rowCount() == 0) { $query3->execute(array($row['id'], $resellerLockupID)); } } if ($row['active'] == 'N') { $status = 3; $statusMessage = $gsprache->status_inactive; } $array['aaData'][] = array('<a href="ts3server://' . $row['dns'] . '">' . $row['server'] . '</a>', $row['dnsID'], returnButton($template_to_use, 'ajax_admin_show_status.tpl', '', '', $status, (string) $statusMessage), returnButton($template_to_use, 'ajax_admin_user_switch.tpl', $row['cname'], $row['full_name'], $row['userID'], ''), (string) $jobPending, returnButton($template_to_use, 'ajax_admin_buttons_dl.tpl', 'vr', 'dl', $row['dnsID'], $gsprache->del) . ' ' . returnButton($template_to_use, 'ajax_admin_buttons_md.tpl', 'vr', 'md', $row['dnsID'], $gsprache->mod)); }