} 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");