<!DOCTYPE html>
<?php
require "config.php";
require "functions/admincheck.php";
require "functions/cmum.php";
if (isset($_POST["value"]) && $_POST["value"] == "baddgrp") {
$status = addgroup($_POST["name"], $_POST["comment"]);
if ($status == "0") {
$notice = "toastr.success('Group successfully created');";
} elseif ($status == "1") {
$notice = "toastr.error('You must enter a group name'); \$('#modalNewGroup').modal({ show: true });";
} elseif ($status == "2") {
$notice = "toastr.error('Group already exists'); \$('#modalNewGroup').modal({ show: true });";
}
}
if (isset($_GET["action"]) && stripslashes($_GET["action"]) == "edit" && isset($_GET["gid"]) && $_GET["gid"] != "") {
$mysqli = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
if (mysqli_connect_errno()) {
errorpage("MYSQL DATABASE ERROR", mysqli_connect_error(), $charset, CMUM_TITLE, $_SERVER["REQUEST_URI"], CMUM_VERSION, CMUM_BUILD, CMUM_MOD);
exit;
}
$sql = $mysqli->query("SELECT id,name,comment FROM groups WHERE id='" . $mysqli->real_escape_string($_GET["gid"]) . "'");
$eg_res = $sql->fetch_array();
$eg_id = $eg_res["id"];
$eg_name = $eg_res["name"];
$eg_comment = $eg_res["comment"];
mysqli_close($mysqli);
$notice = "\$('#modalEditGroup').modal({ show: true });";
}
if (isset($_POST["value"]) && $_POST["value"] == "beditgrp") {
$status = editgroup($_POST["gid"], $_POST["name"], $_POST["comment"]);
}
if ($action == 'addGRP') {
$errgroup = addgroup($account, implode("-", $grplist), $strategy, $grptime, $grppre, $goto, $callerannounce, $alertinfo, $ringing, $description);
if ($errgroup != false) {
exec($wScript1);
needreload();
}
}
if ($action == 'delGRP') {
delextensions('ext-group', ltrim($extdisplay, 'GRP-'));
exec($wScript1);
needreload();
}
if ($action == 'edtGRP') {
delextensions('ext-group', $account);
addgroup($account, implode("-", $grplist), $strategy, $grptime, $grppre, $goto, $callerannounce, $alertinfo, $ringing, $description);
exec($wScript1);
needreload();
}
?>
</div>
<div class="rnav" style="width:190px;">
<li><a id="<?php
echo $extdisplay == '' ? 'current' : '';
?>
" href="config.php?mode=pbx&display=<?php
echo urlencode($dispnum);
?>
" onFocus="this.blur()"><?php
echo _("Add Ring Group");
function impusrcsv($csv, $creategrp, $createprof, $cmumcsvver)
{
if (file_exists("config.php")) {
require "config.php";
} else {
require "../config.php";
}
$csv = preg_split("/\r\n|[\r\n]/", $csv);
$mysqli = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
$i = 0;
$x = 0;
$y = 0;
$e = 0;
$p = 0;
$g = 0;
$impusers = "";
$impexists = "";
$impprofiles = "";
$impgroups = "";
foreach ($csv as $i => $value) {
$csvuser = explode(";", $csv[$i]);
if ($csvuser[0] == "" || $csvuser[1] == "") {
$y++;
} else {
$sql = $mysqli->query("SELECT id FROM users WHERE user='******'");
$urowcheck = $sql->num_rows;
if ($urowcheck == 0) {
$improf = explode(" ", $csvuser[4]);
foreach ($improf as $profvalue) {
if (isset($createprof) && $createprof == "1" && isset($profvalue) && $profvalue != "") {
$pcsql = $mysqli->query("SELECT id FROM profiles WHERE cspvalue='" . $profvalue . "'");
$prowcheck = $pcsql->num_rows;
if ($prowcheck == 0) {
addprofile($profvalue, $profvalue, "Auto created profile by user import");
$impprofiles = $impprofiles . $profvalue . "<br>";
$p++;
}
}
$psql = $mysqli->query("SELECT id FROM profiles WHERE cspvalue='" . $profvalue . "'");
$pdata = $psql->fetch_array();
if ($pdata["id"] != "") {
$usrprof[] = $pdata["id"];
}
}
if (!isset($usrprof)) {
$usrprof = "N;";
} else {
$usrprof = serialize($usrprof);
}
$csvchk = "0";
do {
if (empty($csvuser[$csvchk])) {
$csvuser[$csvchk] = "";
}
$csvchk++;
} while ($csvchk < "23");
if ($cmumcsvver == "3") {
if (isset($_POST["creategrp"]) && $_POST["creategrp"] == "1" && !empty($csvuser[16]) && $csvuser[16] != "") {
$gsql = $mysqli->query("SELECT id FROM groups WHERE name='" . $csvuser[16] . "'");
$growcheck = $gsql->num_rows;
if ($growcheck == 0) {
addgroup($csvuser[16], "Auto created group by user import");
$impgroups = $impgroups . $csvuser[16] . "<br>";
$g++;
}
}
if (!empty($csvuser[14]) && $csvuser[14] != "") {
$ustrdate = date("Y-m-d", strtotime($csvuser[14]));
} else {
$ustrdate = "";
}
if (!empty($csvuser[15]) && $csvuser[15] != "") {
$uexpdate = date("Y-m-d", strtotime($csvuser[15]));
} else {
$uexpdate = "";
}
} elseif ($cmumcsvver == "2") {
if (isset($_POST["creategrp"]) && $_POST["creategrp"] == "1" && !empty($csvuser[12]) && $csvuser[12] != "") {
$gsql = $mysqli->query("SELECT id FROM groups WHERE name='" . $csvuser[12] . "'");
$growcheck = $gsql->num_rows;
if ($growcheck == 0) {
addgroup($csvuser[12], "Auto created group by user import");
$impgroups = $impgroups . $csvuser[12] . "<br>";
$g++;
}
}
if (!empty($csvuser[15]) && $csvuser[15] != "") {
$ustrdate = date("Y-m-d", strtotime($csvuser[15]));
} else {
$ustrdate = "";
}
if (!empty($csvuser[16]) && $csvuser[16] != "") {
$uexpdate = date("Y-m-d", strtotime($csvuser[16]));
} else {
$uexpdate = "";
}
}
if ($cmumcsvver == "3") {
$mysqli->query("INSERT INTO users (user,password,displayname,ipmask,profiles,maxconn,admin,enabled,mapexclude,debug,comment,email,customvalues,ecmrate,startdate,expiredate,usrgroup,boxtype,macaddress,serialnumber,added,addedby,changed,changedby) VALUES ('" . stripslashes(trim($csvuser[0])) . "','" . stripslashes(trim($csvuser[1])) . "','" . stripslashes(trim($csvuser[2])) . "','" . stripslashes(trim($csvuser[3])) . "','" . $usrprof . "','" . stripslashes(trim($csvuser[5])) . "','" . trim($csvuser[6]) . "','" . trim($csvuser[7]) . "','" . trim($csvuser[8]) . "','" . trim($csvuser[9]) . "','" . stripslashes(trim($csvuser[10])) . "','" . stripslashes(trim($csvuser[11])) . "','" . $mysqli->real_escape_string(trim($csvuser[12])) . "','" . stripslashes(trim($csvuser[13])) . "','" . $ustrdate . "','" . $uexpdate . "','" . trim(grptoid($csvuser[16])) . "','" . stripslashes(trim($csvuser[17])) . "','" . stripslashes(trim($csvuser[18])) . "','" . stripslashes(trim($csvuser[19])) . "','" . $csvuser[20] . "','" . admintoid($csvuser[21]) . "','" . $csvuser[22] . "','" . admintoid($csvuser[23]) . "')");
unset($usrprof);
$sql = "";
$psql = "";
$gsql = "";
$impusers = $impusers . $csvuser[0] . "<br>";
$x++;
} elseif ($cmumcsvver == "2") {
$mysqli->query("INSERT INTO users (user,password,displayname,ipmask,profiles,maxconn,admin,enabled,mapexclude,debug,comment,email,customvalues,ecmrate,startdate,expiredate,usrgroup,boxtype,macaddress,serialnumber,added,addedby,changed,changedby) VALUES ('" . stripslashes(trim($csvuser[0])) . "','" . stripslashes(trim($csvuser[1])) . "','" . stripslashes(trim($csvuser[2])) . "','" . stripslashes(trim($csvuser[3])) . "','" . $usrprof . "','" . stripslashes(trim($csvuser[5])) . "','" . truefalse(trim($csvuser[6])) . "','" . truefalse(trim($csvuser[7])) . "','" . truefalse(trim($csvuser[8])) . "','" . truefalse(trim($csvuser[9])) . "','" . stripslashes(trim($csvuser[10])) . "','" . stripslashes(trim($csvuser[11])) . "','" . $mysqli->real_escape_string(trim($csvuser[13])) . "','" . stripslashes(trim($csvuser[14])) . "','" . $ustrdate . "','" . $uexpdate . "','" . trim(grptoid($csvuser[12])) . "','','','','" . $csvuser[17] . "','" . admintoid($csvuser[18]) . "','" . $csvuser[19] . "','" . admintoid($csvuser[20]) . "')");
unset($usrprof);
$sql = "";
$psql = "";
$gsql = "";
$impusers = $impusers . $csvuser[0] . "<br>";
$x++;
}
} else {
$impexists = $impexists . $csvuser[0] . "<br>";
$e++;
}
}
}
mysqli_close($mysqli);
$status["usrimp"] = $x;
$status["usrexi"] = $e;
$status["profimp"] = $p;
$status["grpimp"] = $g;
$status["implist"] = $impusers;
$status["exilist"] = $impexists;
$status["proflist"] = $impprofiles;
$status["grplist"] = $impgroups;
return $status;
}
