<!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; }