$query->execute(array($resellerID, $localID, $localID, $name, $resellerID)); updateJobs($localID, $resellerID); } else { $success['false'][] = 'No user can be found to delete'; } } else { $success['false'][] = 'No data for this method'; } } else { if (array_value_exists('action', 'ls', $data) and isset($data['identify_by']) and isset($data[$data['identify_by']]) and !in_array($data[$data['identify_by']], $bad)) { $userArray = array('userdetails' => array(), 'gserver' => array(), 'voice' => array(), 'mysql' => array(), 'tsdns' => array(), 'webspace' => array()); $from = array('localid' => 'id', 'username' => 'cname', 'external_id' => 'externalID', 'email' => 'mail', 'mysql' => array()); $email = isset($data['email']) ? $data['email'] : ''; $identifyBy = $data['identify_by']; $username = isset($data['username']) ? $data['username'] : ''; $externalID = (isset($data['external_id']) and isExternalID($data['external_id']) != '') ? $data['external_id'] : ''; $localID = isset($data['localid']) ? $data['localid'] : ''; $showUserDataOnly = (isset($data['show_user_data_only']) and $data['show_user_data_only'] == "1") ? 1 : 0; if (dataExist('identify_by', $data)) { $query = $sql->prepare("SELECT `id`,`active`,`cname`,`name`,`vname`,`mail`,`phone`,`handy`,`city`,`cityn`,`street`,`streetn`,`externalID`,`jobPending` FROM `userdata` WHERE `" . $from[$data['identify_by']] . "`=? AND `resellerid`=? AND `accounttype`='u' LIMIT 1"); $query->execute(array($data[$data['identify_by']], $resellerID)); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $userArray['userdetails'] = $row; $userArray['userdetails']['show_user_data_only'] = $showUserDataOnly; } if ($query->rowCount() > 0) { $list = true; if ($showUserDataOnly == 0) { $tempArray = array(); $query = $sql->prepare("SELECT `id`,`active`,`queryUpdatetime`,`queryPassword`,`queryMap`,`queryMaxplayers`,`queryNumplayers`,`queryName`,`port5`,`serverid`,`pallowed`,`eacallowed`,`protected`,`brandname`,`tvenable`,`war`,`psince`,`serverip`,`port`,`port2`,`port3`,`port4`,`minram`,`maxram`,`slots`,`taskset`,`cores`,`lendserver`,`externalID`,`jobPending` FROM `gsswitch` WHERE `userid`=? AND `resellerid`=? ORDER BY `serverip`,`port`"); $query2 = $sql->prepare("SELECT t.`shorten` FROM `serverlist` s INNER JOIN `servertypes` t ON s.`servertype`=t.`id` WHERE s.`switchID`=? AND s.`resellerid`=?");
$query = $sql->prepare("UPDATE `jobs` SET `status`='2' WHERE `type`='vo' AND (`status` IS NULL OR `status`='1') AND `affectedID`=? and `resellerID`=?"); $query->execute(array($localID, $resellerID)); $query = $sql->prepare("INSERT INTO `jobs` (`api`,`type`,`hostID`,`invoicedByID`,`affectedID`,`userID`,`name`,`status`,`date`,`action`,`resellerid`) VALUES ('A','vo',?,?,?,?,?,NULL,NOW(),'dl',?)"); $query->execute(array($hostID, $resellerID, $localID, $userID, $name, $resellerID)); } else { $success['false'][] = 'No server can be found to delete'; } } else { $success['false'][] = 'No data for this method'; } } else { if (!isset($success['false']) and array_value_exists('action', 'ls', $data) and isset($data['identify_server_by']) and dataExist('identify_server_by', $data)) { $from = array('server_local_id' => 'id', 'server_external_id' => 'externalID'); $identifyServerBy = $data['identify_server_by']; $localServerID = isid($data['server_local_id'], 10); $externalServerID = isExternalID($data['server_external_id']); $list = true; $query = $sql->prepare("SELECT * FROM `voice_server` WHERE `" . $from[$data['identify_server_by']] . "`=? AND `resellerid`=? LIMIT 1"); $query->execute(array($data[$data['identify_server_by']], $resellerID)); if ($apiType == 'xml') { header("Content-type: text/xml; charset=UTF-8"); $responsexml = new DOMDocument('1.0', 'utf-8'); $element = $responsexml->createElement('voice'); while ($row = $query->fetch(PDO::FETCH_ASSOC)) { foreach ($row as $k => $v) { $server = $responsexml->createElement($k, $v); $element->appendChild($server); } } $responsexml->appendChild($element); $responsexml->formatOutput = true;