} else {
$query = $sql->prepare("INSERT INTO `userdata` (`cname`,`security`,`mail`,`accounttype`,`resellerid`) VALUES (?,?,?,'u',?)");
$query->execute(array($ui->username("{$virtualserver_id}-username", 50, 'post'), $newHash, $ui->ismail("{$virtualserver_id}-email", 'post'), $reseller_id));
}
$query = $sql->prepare("SELECT `id` FROM `userdata` WHERE `cname`=? AND `mail`=? AND `resellerid`=? ORDER BY `id` DESC LIMIT 1");
$query->execute(array($ui->username("{$virtualserver_id}-username", 50, 'post'), $ui->ismail("{$virtualserver_id}-email", 'post'), $reseller_id));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$customerID = $row['id'];
$cnamenew = $ui->username("{$virtualserver_id}-username", 50, 'post');
sendmail('emailuseradd', $customerID, $cnamenew, $initialpassword);
}
}
} else {
$userlist = '';
$cldbid = rand(1, 100) . '.' . rand(1, 100);
$adminList = $connection->AdminList($virtualserver_id);
if (is_array($adminList)) {
foreach ($adminList as $cldbid => $client_unique_identifier) {
$userlist .= $cldbid . ':' . $client_unique_identifier . '|';
}
}
$cnamenew = $prefix . $cldbid;
$query = $sql->prepare("INSERT INTO `userdata` (`cname`,`security`,`mail`,`accounttype`,`resellerid`) VALUES (?,?,?,'u',?)");
$query->execute(array($cnamenew, $userlist, '*****@*****.**', $reseller_id));
$query = $sql->prepare("SELECT `id` FROM `userdata` WHERE `cname`=? AND `mail`='*****@*****.**' ORDER BY `id` DESC LIMIT 1");
$query->execute(array($cnamenew));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$customerID = $row['id'];
$cnamenew = $prefix . $customerID;
}
$query = $sql->prepare("UPDATE `userdata` SET `cname`=? WHERE `id`=? AND `resellerid`=? LIMIT 1");
