function register($firstname, $lastname, $email, $password, $userId = 0, $send_welcome = true)
{
global $db;
$userId = (int) $userId;
$email = strtolower($email);
$res = pg_query($db, "SELECT * FROM users WHERE email = '" . pg_escape_string($email) . "'") or die("Database Error");
if (pg_num_rows($res) > 0) {
return false;
}
$apikey = generateRandomString(32);
$activationKey = $send_welcome ? generateRandomString(40) : "";
$res = pg_query($db, "INSERT INTO users(firstname, lastname, email, password, apikey, users_id, activationkey) VALUES('" . pg_escape_string($firstname) . "', '" . pg_escape_string($lastname) . "', '" . pg_escape_string($email) . "', '" . md5($password) . "', '" . $apikey . "', " . $userId . ", '" . pg_escape_string($activationKey) . "'); SELECT currval(pg_get_serial_sequence('users','id')) as last_insert_id;") or die("Database Error");
if ($d = pg_fetch_assoc($res)) {
$userId = $d['last_insert_id'];
$layers_my_group = array();
$layers_ssl_maps = array();
$layers_style_maps = array();
$layers_outdoor_maps = array();
$layers_satellite_maps = array();
$layers_style_maps[] = $layers_my_group[] = addLayers($userId, 'CartoDB Light', 'https://cartodb-basemaps-{s}.global.ssl.fastly.net/light_all/{z}/{x}/{y}.png', '', '', 'Map tiles by <a href="http://cartodb.com/attributions#basemaps" target="_blank">CartoDB</a>, under <a href="https://creativecommons.org/licenses/by/3.0/" target="_blank">CC BY 3.0</a>. Data by <a href="http://www.openstreetmap.org/" target="_blank">OpenStreetMap</a>, under ODbL.');
$layers_outdoor_maps[] = $layers_my_group[] = addLayers($userId, 'Loniva Hiking', 'http://tile.waymarkedtrails.org/hiking/{z}/{x}/{y}.png', '', '', '<a href="https://openpistemap.org" target="_blank">OpenStreetMap</a>');
$layers_style_maps[] = $layers_my_group[] = addLayers($userId, 'MapQuest Sat', 'https://otile1.mqcdn.com/tiles/1.0.0/sat/{z}/{x}/{y}.png', '', '', '<a href="https://openstreetmap.org" target="_blank">OpenStreetMap</a>');
$layers_style_maps[] = $layers_my_group[] = addLayers($userId, 'Stamen.Watercolor', 'http://{s}.tile.stamen.com/watercolor/{z}/{x}/{y}.jpg', '', '', 'Map tiles by <a href="http://stamen.com" target="_blank">Stamen Design</a>, under <a href="http://creativecommons.org/licenses/by/3.0" target="_blank">CC BY 3.0</a>. Data by <a href="http://openstreetmap.org" target="_blank">OpenStreetMap</a>, under <a href="http://creativecommons.org/licenses/by-sa/3.0" target="_blank">CC BY SA</a>.');
$layers_outdoor_maps[] = $layers_my_group[] = addLayers($userId, 'OpenCycleMap', 'http://{s}.tile.thunderforest.com/cycle/{z}/{x}/{y}.png', '', '', '<a href="http://thunderforest.com/" target="_blank">Thunderforest</a>');
$layers_ssl_maps[] = $layers_my_group[] = addLayers($userId, 'OpenStreetMap', 'https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png', '', '', '<a href="https://openstreetmap.org" target="_blank">OpenStreetMap</a>');
$layers_satellite_maps[] = $layers_my_group[] = addLayers($userId, 'Esri World Imagery', 'http://server.arcgisonline.com/ArcGIS/rest/services/World_Imagery/MapServer/tile/{z}/{y}/{x}', '', '', 'Attribution: <a href="http://www.esri.com/" target="_blank">ESRI</a>');
$layers_satellite_maps[] = $layers_my_group[] = addLayers($userId, 'Google Maps', 'http://mt1.google.com/vt/lyrs=y&x={x}&y={y}&z={z}', '', '', '<a href="http://www.google.com/intl/en-GB_US/help/terms_maps.html" target="_blank">Google - Terms of Use</a>');
$layers_my_group[] = addLayers($userId, 'MapBox', 'https://{s}.tiles.mapbox.com/v3/{id}/{z}/{x}/{y}.png', 'examples.map-i875mjb7', '', '<a href="https://mapbox.com" target="_blank">MapBox</a>');
$layers_outdoor_maps[] = $layers_my_group[] = addLayers($userId, 'Loniva Biking', 'http://tile.waymarkedtrails.org/cycling/{z}/{x}/{y}.png', '', '', '<a href="http://cycling.waymarkedtrails.org/" target="_blank">OpenStreetMap</a>');
$layers_style_maps[] = $layers_my_group[] = addLayers($userId, 'Stamen.Toner', 'http://a.tile.stamen.com/toner/{z}/{x}/{y}.png', '', '', 'Map tiles by <a href="http://stamen.com" target="_blank">Stamen Design</a>, under <a href="http://creativecommons.org/licenses/by/3.0" target="_blank">CC BY 3.0</a>. Data by <a href="http://openstreetmap.org" target="_blank">OpenStreetMap</a>, under <a href="http://www.openstreetmap.org/copyright" target="_blank">ODbL</a>.');
$layers_style_maps[] = $layers_my_group[] = addLayers($userId, 'CartoDB Dark', 'https://cartodb-basemaps-{s}.global.ssl.fastly.net/dark_all/{z}/{x}/{y}.png', '', '', 'Map tiles by <a href="http://cartodb.com/attributions#basemaps" target="_blank">CartoDB</a>, under <a href="https://creativecommons.org/licenses/by/3.0/" target="_blank">CC BY 3.0</a>. Data by <a href="http://www.openstreetmap.org/" target="_blank">OpenStreetMap</a>, under ODbL.');
$layers_ssl_maps[] = $layers_my_group[] = addLayers($userId, 'MapQuest', 'https://otile3-s.mqcdn.com/tiles/1.0.0/map/{z}/{x}/{y}.png', '', '', '<a href="https://openstreetmap.org" target="_blank">OpenStreetMap. </a> Tiles Courtesy of <a href="http://www.mapquest.com/" target="_blank">MapQuest</a>');
$layers_my_group[] = addLayers($userId, 'MapFig Greenwaters', 'https://{s}.tile.thunderforest.com/mapfig-2a6/{z}/{x}/{y}.png', '', '', '© <a href="http://mapfig.org" target="_blank">MapFig </a> Greenwaters by <a href="http://thunderforest.com" target="_blank">Thunderforest,</a> Data by <a href="http://www.openstreetmap.org/copyright" target="_blank">OpenStreetMap</a>.');
$layers_ssl_maps[] = $layers_my_group[] = addLayers($userId, 'MapFig Darkwaters', 'https://{s}.tile.thunderforest.com/mapfig-darkwaters/{z}/{x}/{y}.png', '', '', '© <a href="http://mapfig.org" target="_blank">MapFig </a> Darkwaters by <a href="http://thunderforest.com" target="_blank">Thunderforest,</a> Data by <a href="http://www.openstreetmap.org/copyright" target="_blank">OpenStreetMap</a>.');
$layers_ssl_maps[] = $layers_my_group[] = addLayers($userId, 'MapFig Bluewaters', 'https://{s}.tile.thunderforest.com/mapfig-bluewaters/{z}/{x}/{y}.png', '', '', '© <a href="http://mapfig.org" target="_blank">MapFig </a> Bluewaters by <a href="http://thunderforest.com" target="_blank">Thunderforest,</a> Data by <a href="http://www.openstreetmap.org/copyright" target="_blank">OpenStreetMap</a>.');
$g1 = addGroup($userId, 'My Group');
addGroupHasLayers($userId, $g1, $layers_my_group);
$g1 = addGroup($userId, 'SSL Maps');
addGroupHasLayers($userId, $g1, $layers_ssl_maps);
$g1 = addGroup($userId, 'Style Maps');
addGroupHasLayers($userId, $g1, $layers_style_maps);
$g1 = addGroup($userId, 'Outdoor Maps');
addGroupHasLayers($userId, $g1, $layers_outdoor_maps);
$g1 = addGroup($userId, 'Satellite Maps');
addGroupHasLayers($userId, $g1, $layers_satellite_maps);
if ($send_welcome) {
sendWelcomeEmail($userId, $password);
}
return $userId;
} else {
return false;
}
}
public function json_CreateGroup()
{
$data = json_decode(file_get_contents('php://input'), true);
$data['username'] = user_decrypt($data['username']);
$check = $this->checkInput($data, array('username', 'groupname'));
if ($check == '') {
$gid = addGroup($data['username'], $data['groupname']);
if ($gid > 0) {
$return['error'] = 0;
$return['value'] = $gid;
} else {
$return['error'] = -2;
$return['value'] = 'Group with same name';
$return['data'] = $gid;
}
} else {
$return['error'] = -1;
$return['value'] = $check;
}
$jsonstring = json_encode($return);
echo $jsonstring;
}
function XMLRPCaddResourceGroup($name, $managingGroup, $type)
{
global $user;
if (!in_array("groupAdmin", $user['privileges'])) {
return array('status' => 'error', 'errorcode' => 16, 'errormsg' => 'access denied for managing groups');
}
$validate = array('managingGroup' => $managingGroup);
$rc = validateAPIgroupInput($validate, 0);
if ($rc['status'] == 'error') {
return $rc;
}
if ($typeid = getResourceTypeID($type)) {
if (checkForGroupName($name, 'resource', '', $typeid)) {
return array('status' => 'error', 'errorcode' => 76, 'errormsg' => 'resource group already exists');
}
if (get_magic_quotes_gpc()) {
$name = stripslashes($name);
}
if (!preg_match('/^[-a-zA-Z0-9_\\. ]{3,30}$/', $name)) {
return array('status' => 'error', 'errorcode' => 87, 'errormsg' => 'Name must be between 3 and 30 characters and can only contain letters, numbers, spaces, and these characters: - . _');
}
$name = mysql_real_escape_string($name);
$data = array('type' => 'resource', 'ownergroup' => $rc['managingGroupID'], 'resourcetypeid' => $typeid, 'name' => $name);
if (!addGroup($data)) {
return array('status' => 'error', 'errorcode' => 26, 'errormsg' => 'failure while adding group to database');
}
} else {
return array('status' => 'error', 'errorcode' => 68, 'errormsg' => 'invalid resource type');
}
return array('status' => 'success');
}
function addRack()
{
$taglist = genericAssertion('taglist', 'array0');
// The new rack(s) should be placed on the bottom of the list, sort-wise
$rowInfo = getRowInfo($_REQUEST['row_id']);
$sort_order = $rowInfo['count'] + 1;
if (isset($_REQUEST['got_data'])) {
###############################################################################################
# Add zabbix group
$result = addGroup($_REQUEST["name"]);
if (isset($result["error"])) {
showError("Adding zabbix group is failed. Error message：" . $result["error"]);
return;
}
# END
###############################################################################################
assertStringArg('name');
assertUIntArg('height1');
assertStringArg('asset_no', TRUE);
$rack_id = commitAddObject($_REQUEST['name'], NULL, 1560, $_REQUEST['asset_no'], $taglist);
// Set the height and sort order
commitUpdateAttrValue($rack_id, 27, $_REQUEST['height1']);
commitUpdateAttrValue($rack_id, 29, $sort_order);
// Link it to the row
commitLinkEntities('row', $_REQUEST['row_id'], 'rack', $rack_id);
showSuccess('added rack ' . mkA($_REQUEST['name'], 'rack', $rack_id));
################################################################################################
# insert information of airconditioner
$type = isset($_REQUEST['type']) ? $_REQUEST['type'] : 'rack';
if ($type == 'airconditioner') {
usePreparedInsertBlade('rack_airconditioner', array('row_id' => $_REQUEST['row_id'], 'rack_id' => $rack_id));
}
# insert position information
$pos_x = isset($_REQUEST['pos_x']) ? $_REQUEST['pos_x'] : null;
$pos_y = isset($_REQUEST['pos_y']) ? $_REQUEST['pos_y'] : null;
$pos_z = isset($_REQUEST['pos_z']) ? $_REQUEST['pos_z'] : null;
# if x,y,z are existing, insert into DB
if (isset($pos_x) && isset($pos_y) && isset($pos_z)) {
usePreparedInsertBlade('rack_position', array('row_id' => $_REQUEST['row_id'], 'rack_id' => $rack_id, 'pos_x' => $pos_x, 'pos_y' => $pos_y, 'pos_z' => $pos_z));
}
################################################################################################
} elseif (isset($_REQUEST['got_mdata'])) {
assertUIntArg('height2');
assertStringArg('names', TRUE);
// copy-and-paste from renderAddMultipleObjectsForm()
$names1 = explode("\n", $_REQUEST['names']);
$names2 = array();
foreach ($names1 as $line) {
$parts = explode('\\r', $line);
reset($parts);
if (!strlen($parts[0])) {
continue;
} else {
$names2[] = rtrim($parts[0]);
}
}
foreach ($names2 as $cname) {
################################################################################################
# add zabbix group
$result = addGroup($cname);
if (isset($result["error"])) {
showError("Adding zabbix group is failed. Error message：" . $result["error"]);
return;
}
# END
################################################################################################
$rack_id = commitAddObject($cname, NULL, 1560, NULL, $taglist);
// Set the height and sort order
commitUpdateAttrValue($rack_id, 27, $_REQUEST['height2']);
commitUpdateAttrValue($rack_id, 29, $sort_order);
$sort_order++;
// Link it to the row
commitLinkEntities('row', $_REQUEST['row_id'], 'rack', $rack_id);
showSuccess('added rack ' . mkA($cname, 'rack', $rack_id));
}
} else {
showFuncMessage(__FUNCTION__, 'ERR2');
}
}
<h3>Dodaj grupę</h3>
<?php
if ($_SESSION['isAdmin']) {
if (isset($_POST['addgroup'])) {
$group = clearVariable($_POST['group']);
$changeStatus;
if (empty($group)) {
// zwrócenie błędu jeżeli któreś pole jest puste
$changeStatus = "<p>Musisz wpisać nazwę grupy.</p>";
} else {
include('php/addgroup.php');
$changeStatus = addGroup($group);
}
echo $changeStatus;
}
?>
<form action="?category=admin/groups" method="post"><p>Nazwa grupy: <input type="text" maxlength="30" size="16" name="group" /> <input type="submit" name="addgroup" value="Dodaj" /></p></form>
<hr />
<hr />
<h3>Istniejące grupy</h3>
<?php
if ($action == 'delete') {
if (!empty($_GET['id'])) {
$id = clearVariable($_GET['id']);
$deleteStatus;
include('php/deletegroup.php');
}
### Variables Variables Variables
$base_name = plugin_basename('likedome/admin/group.php');
$base_page = 'admin.php?page=' . $base_name;
$category = trim($_REQUEST['category']);
define('LIKEDOME_PLUGINS_ROOT', dirname(dirname(__FILE__)));
require_once LIKEDOME_PLUGINS_ROOT . '/config.php';
require_once LIKEDOME_PLUGINS_ROOT . '/includes/classes.php';
require_once LIKEDOME_PLUGINS_ROOT . '/includes/templatespart.php';
### Determines Which Category It Is
switch ($category) {
// Add
case 'add':
$name = trim($_POST['groupname']);
$matchId = intval($_POST['matchId']);
$succe = addGroup($name, 0, $matchId);
if ($succe != 1) {
echo "添加队伍提交失败";
return;
}
echo "添加队伍提交成功";
break;
// Del
// Del
case 'del':
$groupid = intval($_POST['groupid']);
$matchid = intval($_POST['matchid']);
$succe = delGroup($groupid);
if ($succe != 1) {
echo "删除队伍:" . $groupid . "失败";
return;
/**
\brief Gruppe hinzufügen
Fügt eine neue Gruppe hinzu
*/
function Group_add()
{
if (!$this->userdata['rights']['groupedit']) {
#no permission
$this->_header("", "no permission");
}
$page = param_num("page", 1);
$data = $_SESSION['steps'];
#information message, step 2
if ($data['addgroup']) {
$id = param_num("id");
if ($id) {
$return = getGroup($id);
if (!$return) {
$this->_header();
}
}
#save step
unset($data['addgroup']);
$_SESSION['steps'] = $data;
$this->forms['information']['action'] = "groupdetails";
$this->forms['information']['url'] = $this->backtracking->backlink();
$this->forms['information']['title'] = "Gruppe hinzufügen";
$this->forms['information']['message'] = "Gruppe " . $return['name'] . " hinzugefügt";
$this->forms['information']['style'] = "green";
$this->show('message_information', "Gruppe hinzufügen");
}
#formular send
if ($_REQUEST['send']) {
$items['name'] = param_str("name", true);
$items['descr'] = param_str("descr", true);
$errors = false;
#check if empty
if (!$items['name']) {
$errors[] = "Name darf nicht leer sein!";
$this->forms['addgroup']['fields']['name']['bgrd'] = '_error';
}
if (!$items['descr']) {
$errors[] = "Beschreibung darf nicht leer sein!";
$this->forms['addgroup']['fields']['descr']['bgrd'] = '_error';
}
#optional parameters
$items['usertitle'] = param_str("usertitle", true);
# for ($i=0;$i<count($rights);$i++) {
# if ($_POST[$rights[$i]['rid']."_".$rights[$i]['name']]) $rights[$i]['isset'] = 1;
# else $rights[$i]['isset'] = 0;
# }
if (!$errors && getGroupByName($items['name'])) {
$errors[] = "Gruppe existiert bereits!";
$this->forms['addgroup']['fields']['name']['bgrd'] = '_error';
}
if (!$errors) {
#save step
$data['addgroup'] = 1;
$_SESSION['steps'] = $data;
$gid = addGroup($items['name'], $items['descr'], $items['usertitle']);
if ($gid) {
addToLogfile("Gruppe " . $items['name'] . " hinzugefügt", "Admin", $this->userdata['uid']);
$this->_header("admin.php?action=addgroup&id=" . $gid . "&send");
}
} else {
$this->forms['addgroup']['fields']['descr']['value'] = $items['descr'];
$this->forms['addgroup']['fields']['name']['value'] = $items['name'];
$this->forms['addgroup']['fields']['usertitle']['value'] = $items['usertitle'];
$this->template->assign("errors", $errors);
}
}
$this->forms['addgroup']['name'] = $return['name'];
$this->forms['addgroup']['url'] = "admin.php";
$this->forms['addgroup']['action'] = 'addgroup';
$this->show('group_add_form', "Gruppe hinzufügen");
}
function submitAddGroup()
{
global $submitErr;
$data = processGroupInput(1);
if ($submitErr) {
editOrAddGroup(1);
return;
}
if (!addGroup($data)) {
abort(10);
}
viewGroups();
}
<?php
require_once dirname(__FILE__) . "/../../../include/master.inc.php";
$error = "";
$success = "";
if (!isLogin()) {
redirect(BASEURL . "app/login.php");
}
if (isset($_POST['save'])) {
if (strlen($_POST['name']) < 2) {
$error = "Group Name Too Short.";
} else {
if (!addGroup($_SESSION['user']['id'], $_POST['name'])) {
$error = "Something went wrong. Please refresh and try again!";
} else {
$success = "Successfully Added!";
}
}
} else {
$error = "Invalid Request";
}
$_SESSION['response']['group-add']['error'] = $error;
$_SESSION['response']['group-add']['success'] = $success;
redirect(BASEURL . "app/group-add.php");
$de = createDBdate($today['year'], $today['mon'], $today['mday'], 14, 30, 0); print 'e-' . insertEvent($user, 'unsw', 'Lunch 2', $ds, $de, 1); $ds = createDBdate($today['year'], $today['mon'], 6, 12, 0, 0); $de = createDBdate($today['year'], $today['mon'], 6, 14, 0, 0); print 'e-' . insertEvent($user, 'unsw', 'Summer', $ds, $de, 1); print "\n"; displayAllEvents($user, 'unsw'); print "-----------------------\n"; deleteEvent(1, $user); updateWeight(2, 99); //for event 2 //Groups test $kkk = addGroup($user, 'KKK'); addGroup($user, 'NRA'); addGroup($user, 'Friday night booklovers club'); addGroup($user, 'Religious nuts society'); $user2 = '*****@*****.**'; $user3 = '*****@*****.**'; insertUser($user2, 'password', null); insertUser($user3, 'password', null); addMemberToGroup($kkk, $user2); acceptGroup($kkk, $user2); newCalendar($user2, 'google'); $ds = createDBdate($today['year'], $today['mon'], 6, 14, 0, 0); $de = createDBdate($today['year'], $today['mon'], 6, 16, 0, 0); insertEvent($user2, 'google', 'Autumn', $ds, $de, 1); addMemberToGroup($kkk, $user3); // acceptGroup(1,$user3); rejectGroup($kkk, $user3); newCalendar($user2, 'outlook'); $ds = createDBdate($today['year'], $today['mon'], 6, 16, 0, 0);
protected function post_id_name_handler()
{
addGroup($this->id, $this->name);
header('Location: ' . filter_input(INPUT_SERVER, 'PHP_SELF'));
return false;
}
function XMLRPCaddUserGroup($name, $affiliation, $owner, $managingGroup, $initialMaxTime, $totalMaxTime, $maxExtendTime)
{
global $user;
if (!in_array('groupAdmin', $user['privileges'])) {
return array('status' => 'error', 'errorcode' => 16, 'errormsg' => 'access denied for managing user groups');
}
$validate = array('name' => $name, 'affiliation' => $affiliation, 'owner' => $owner, 'managingGroup' => $managingGroup, 'initialMaxTime' => $initialMaxTime, 'totalMaxTime' => $totalMaxTime, 'maxExtendTime' => $maxExtendTime);
$rc = validateAPIgroupInput($validate, 0);
if ($rc['status'] == 'error') {
return $rc;
}
$data = array('type' => 'user', 'owner' => $owner, 'name' => $name, 'affiliationid' => $rc['affiliationid'], 'editgroupid' => $rc['managingGroupID'], 'initialmax' => $initialMaxTime, 'totalmax' => $totalMaxTime, 'maxextend' => $maxExtendTime, 'overlap' => 0);
if (!addGroup($data)) {
return array('status' => 'error', 'errorcode' => 26, 'errormsg' => 'failure while adding group to database');
}
return array('status' => 'success');
}
$characters = readCharacters($conn);
$records = readRecords($conn);
$professions = readProfessions($conn);
$gameBuilds = readGameBuilds($conn);
$instances = readInstances($conn);
$paths = readPaths($conn);
$categories = readCategories($conn);
$instanceTypes = readInstanceTypes($conn);
$message = "Login successful";
} else {
if ($type == "readRulesets") {
$rulesets = readRulesets($conn);
$message = "Rules read.";
} else {
if ($type == "addGroup") {
$message = addGroup($conn);
$groups = readGroups($conn);
} else {
if ($type == "editGroup") {
$message = editGroup($conn);
$groups = readGroups($conn);
$players = readPlayers($conn);
$records = readRecords($conn);
} else {
if ($type == "deleteGroup") {
$message = deleteGroup($conn);
$groups = readGroups($conn);
} else {
if ($type == "addPlayer") {
$message = addPlayer($conn);
$players = readPlayers($conn);
showYearEditor($_REQUEST['year']);
break;
case "showusereditor":
showUserEditor($_REQUEST['userid'], $_REQUEST['add']);
break;
case "deleteuser":
deleteUser($_REQUEST['user']);
break;
case "addyear":
addYear($_REQUEST['year']);
break;
case "deleteyear":
deleteYear($_REQUEST['year']);
break;
case "addgroup":
addGroup($_REQUEST['group']);
break;
case "deletegroup":
print deleteGroup($_REQUEST['group']);
break;
case "deleteblockeduser":
deleteBlockedUser($_REQUEST['user']);
break;
case "addblockeduser":
addBlockedUser($_REQUEST['user']);
break;
case "removependingpayment":
removePendingPayment($_REQUEST);
break;
case "getpendingpayments":
getPendingPayments($_REQUEST);
echo getNotice();
exit;
break;
case 'readallnotices':
$db = JFactory::getDBO();
$query = 'UPDATE #__acctexp_eventlog' . ' SET `notify` = \'0\'' . ' WHERE `notify` = \'1\'';
$db->setQuery($query);
$db->query();
aecCentral($option);
break;
case 'toggleajax':
toggleProperty(aecGetParam('type'), aecGetParam('id'), aecGetParam('property'));
exit;
break;
case 'addgroupajax':
addGroup(aecGetParam('type'), aecGetParam('id'), aecGetParam('group'));
exit;
break;
case 'removegroupajax':
removeGroup(aecGetParam('type'), aecGetParam('id'), aecGetParam('group'));
exit;
break;
case 'recallinstall':
include_once JPATH_SITE . '/administrator/components/com_acctexp/install.acctexp.php';
com_install();
break;
case 'initsettings':
$aecConfig = new aecConfig();
$aecConfig->initParams();
echo 'SPLINES RETICULATED.';
break;
addDepartment($_POST["dep_name"]);
//delete category
} else {
if ($_POST["procedure"] == "DELETE_DEPARTMENT") {
deleteDepartment($_POST["dep_id"]);
//edit category
} else {
if ($_POST["procedure"] == "EDIT_DEPARTMENT") {
editDepartment($_POST["dep_id"], $_POST["dep_newName"]);
}
}
}
//################ Job Group Functions ##############
//add group
if ($_POST["procedure"] == "ADD_GROUP") {
addGroup($_POST["grp_name"], $_POST["dep_id"]);
//delete group
} else {
if ($_POST["procedure"] == "DELETE_GROUP") {
deleteGroup($_POST["grp_id"]);
//edit group
} else {
if ($_POST["procedure"] == "EDIT_GROUP") {
editGroup($_POST["grp_id"], $_POST["grp_newName"]);
}
}
}
$pageTitle = "Manage Jobs";
$javascript = "manageJobs.js";
require 'includes/adminHeader.php';
?>
stExec($stH, array($group['id']));
$deleted = $stH->rowCount();
if (!$deleted) {
$msg = "Database Error: {$ax['grp_not_deleted']}";
break;
}
$msg = $ax['grp_deleted'];
} while (false);
return $msg;
}
//Control logic
if ($privs >= 4) {
//manager or admin
$msg = '';
if (isset($_POST['addExe'])) {
$msg = addGroup($group);
} elseif (isset($_POST['updExe'])) {
$msg = updateGroup($group);
} elseif (isset($_GET['delExe'])) {
$msg = deleteGroup($group);
}
echo "<p class='error'>{$msg}</p>\n\t\t<div class='scrollBoxAd'>\n\t\t<div class='centerBox'>\n";
if (!$mode or isset($_POST["back"])) {
showGroups();
//no add / no edit
} else {
editGroup($group);
//add or edit
}
echo "</div>\n</div>\n";
} else {
function groups_admin_main($var)
{
$op = pnVarCleanFromInput('op');
extract($var);
if (!pnSecAuthAction(0, 'Groups::', '::', ACCESS_EDIT)) {
include 'header.php';
echo _GROUPSNOAUTH;
include 'footer.php';
} else {
switch ($op) {
case "secviewgroups":
viewGroups();
break;
case "secviewgroup":
viewGroup();
break;
case "secnewgroup":
newGroup();
break;
case "secaddgroup":
addGroup();
break;
case "secdeletegroup":
deleteGroup();
break;
case "secselectuserforgroup":
selectUserForGroup();
break;
case "secaddusertogroup":
addUserToGroup();
break;
case "secdeleteuserfromgroup":
deleteUserFromGroup();
break;
case "secmodifygroup":
modifyGroup();
break;
case "secrenamegroup":
renameGroup();
break;
default:
viewGroups();
break;
}
}
}
if (!isset($USER->userid)) {
header('Location: index.php');
exit;
}
$errors = array();
$groupname = optional_param("groupname", "", PARAM_TEXT);
$desc = optional_param("desc", "", PARAM_HTML);
$website = optional_param("website", "", PARAM_TEXT);
$members = optional_param("members", "", PARAM_TEXT);
$isopenjoining = optional_param("isopenjoining", "N", PARAM_ALPHA);
if (isset($_POST["creategroup"])) {
if ($groupname == "") {
array_push($errors, $LNG->GROUP_FORM_NAME_ERROR);
}
if (empty($errors)) {
$group = addGroup($groupname);
if ($group instanceof Error) {
array_push($errors, $group->message);
} else {
//group is a new user Ha!
$gu = new User($group->groupid);
$gu = $gu->load();
$gu->updateDescription($desc);
$gu->updateWebsite($website);
$group->updateIsOpenJoining($isopenjoining);
if ($_FILES['photo']['error'] == 0) {
$photofilename = uploadImageToFit('photo', $errors, $group->groupid);
if ($photofilename == "") {
$photofilename = $CFG->DEFAULT_GROUP_PHOTO;
}
$gu->updatePhoto($photofilename);
} else {
echo json_encode(['error' => 'No phone number supplied!', 'code' => 400]);
}
}
break;
/**
* Attempt to create a new group
*/
/**
* Attempt to create a new group
*/
case 'addGroup':
requireAuth();
if (isset($_GET['name']) && strlen($_GET['name']) > 0 && strlen($_GET['name']) < 256) {
$name = $_GET['name'];
echo json_encode(addGroup($name, true));
} else {
echo json_encode(['error' => 'Incorrect name length', 'code' => 400]);
}
break;
/**
* Delete the group
*/
/**
* Delete the group
*/
case 'deleteGroup':
requireAuth();
// We need the exact ID: this means no 003106 (only 316...)
if (isset($_GET['gid']) && is_numeric($_GET['gid'])) {
$gid = $_GET['gid'];
break;
case "getgroupsbyglobal":
$query = optional_param('q', "", PARAM_TEXT);
$response = getGroupsByGlobal($start, $max, $o, $s, $style, $query);
break;
case "getmygroups":
$userid = optional_param('userid', '', PARAM_ALPHANUMEXT);
$response = getMyGroups($userid);
break;
case "getmyadmingroups":
$userid = optional_param('userid', '', PARAM_ALPHANUMEXT);
$response = getMyAdminGroups($userid);
break;
case "addgroup":
$groupname = required_param('groupname', PARAM_TEXT);
$response = addGroup($groupname);
break;
case "deletegroup":
$groupid = required_param('groupid', PARAM_ALPHANUMEXT);
$response = deleteGroup($groupid);
break;
case "addgroupmember":
$groupid = required_param('groupid', PARAM_ALPHANUMEXT);
$userid = required_param('userid', PARAM_ALPHANUMEXT);
$response = addGroupMember($groupid, $userid);
break;
case "makegroupadmin":
$groupid = required_param('groupid', PARAM_ALPHANUMEXT);
$userid = required_param('userid', PARAM_ALPHANUMEXT);
$response = makeGroupAdmin($groupid, $userid);
break;
function showOneEntry($r, $only_phone = false)
{
global $db, $table, $table_grp_adr, $table_groups, $print, $is_fix_group, $mail_as_image, $page_ext_qry;
$view = "";
$view .= add("<b>" . $r['firstname'] . (!empty($r['middlename']) ? " " . $r['middlename'] : "") . " " . $r['lastname'] . "</b>");
$view .= add($r['nickname']);
$b64 = explode(";", $r['photo']);
if (count($b64) >= 3 && !$only_phone) {
$b64 = $b64[2];
$b64 = explode(":", $b64);
if (count($b64) >= 2) {
$b64 = str_replace(" ", "", $b64[1]);
$view .= $r['photo'] != "" ? '<img alt="Embedded Image" width=75 src="data:image/jpg;base64,' . $b64 . '"/><br>' : "";
}
}
if (!$only_phone) {
$view .= ($r['title'] != "" ? "<i>" : "") . add($r['title']) . ($r['title'] != "" ? "</i>" : "");
$view .= add($r['company']);
// $view .= addGroup($r, array('address'));
$view .= add(str_replace("\n", "<br />", trim($r["address"])));
$view .= addGroup($r, array('home', 'mobile', 'work', 'fax'));
}
$view .= addPhone($r['home'], ucfmsg('H:'));
$view .= addPhone($r['mobile'], ucfmsg('M:'));
$view .= addPhone($r['work'], ucfmsg('W:'));
$view .= addPhone($r['fax'], ucfmsg('F:'));
if (!$only_phone) {
$view .= addGroup($r, array('email', 'email2', 'email3', 'homepage'));
if ($mail_as_image) {
// B64IMG: Thanks to NelloD
$view .= $r['email'] != "" ? "<img src=\"b64img.php?text=" . base64_encode($r['email']) . "\"><br/>" : "";
$view .= $r['email2'] != "" ? "<img src=\"b64img.php?text=" . base64_encode($r['email2']) . "\"><br/>" : "";
$view .= $r['email3'] != "" ? "<img src=\"b64img.php?text=" . base64_encode($r['email3']) . "\"><br/>" : "";
} else {
$view .= addEmail($r['email']);
$view .= addEmail($r['email2']);
$view .= addEmail($r['email3']);
}
$view .= addHomepage($r['homepage']);
$view .= addGroup($r, array('bday', 'bmonth', 'byear'));
$view .= addBirthday($r['bday'], $r['bmonth'], $r['byear'], ucfmsg('BIRTHDAY'));
$view .= addBirthday($r['aday'], $r['amonth'], $r['ayear'], ucfmsg('ANNIVERSARY'));
$view .= addGroup($r, array('address2', 'phone2'));
$view .= add(str_replace("\n", "<br />", trim($r['address2'])));
$view .= addGroup($r, array('phone2'));
}
$view .= add($r['phone2'], ucfmsg('P:'));
if (!$only_phone) {
// Detect URLs (http://*, www.*) and show as link.
//
// $text = "Hello, http://www.google.com";
// $new = preg_replace("/(http:\/\/[^\s]+)/", "<a href=\"$1\">$1</a>", $test);
//
$view .= $r['notes'] != "" ? "<br />" . str_replace("\n", "<br />", trim($r['notes'])) . "<br /><br />" : "";
}
echo $view . "\n";
if (!isset($print) and !$is_fix_group) {
$sql = "SELECT DISTINCT {$table_groups}.group_id, group_name\n\t FROM {$table_grp_adr}, {$table_groups}, {$table}\n\t WHERE {$table}.id = {$table_grp_adr}.id\n\t AND {$table}.id = " . $r['id'] . "\n\t AND {$table_grp_adr}.group_id = {$table_groups}.group_id";
$result = mysql_query($sql, $db);
$first = true;
while ($result && ($g = mysql_fetch_array($result))) {
if ($first) {
echo "<br /><i>" . ucfmsg('MEMBER_OF') . ": ";
} else {
echo ", ";
}
echo "<a href='./index{$page_ext_qry}group=" . urlencode($g['group_name']) . "'>" . $g['group_name'] . "</a>";
$first = false;
}
if ($first != true) {
echo "</i>";
}
/*
echo "<br/><br/>";
echo ucfmsg('MODIFIED') . ": ".$r['modified'];
echo "<i>(".ucfmsg('CREATED') . ": ".$r['created'].")</i><br/>";
*/
}
}
if (strtolower($view) == strtolower($user)) {
$name = "Your";
$afterStr = "<a class='button' href='groups.php'>Join more groups</a>";
} else {
$name = "{$view}'s";
$afterStr = "";
}
echo "<h2 class='title'>{$name} Groups</h2><div class='display'>";
showGroups($view);
echo $afterStr;
die("</div></div></body></html>");
}
//add or remove groups
if (isset($_GET['add'])) {
$add = sanitizeString($_GET['add']);
addGroup($user, $add);
} elseif (isset($_GET['remove'])) {
$remove = sanitizeString($_GET['remove']);
removeGroup($user, $remove);
}
// display groups
$result = queryMysql("SELECT course, coursename FROM courses ORDER BY course");
$num = $result->num_rows;
echo "<h2 class='title'>Groups</h2><div class='display'><ul>";
for ($i = 0; $i < $num; $i++) {
$row = $result->fetch_array(MYSQLI_ASSOC);
echo "<li><a href='group.php?view=" . $row['course'] . "'>" . $row['course'] . " " . $row['coursename'] . "</a>";
// check if the user is in a group
$result1 = queryMysql("SELECT * FROM groups WHERE user='******' AND course='" . $row['course'] . "'");
if ($result1->num_rows) {
echo "<span class='action'><a class='button small' href='groups.php?remove=" . $row['course'] . "'>drop</a>";
}
redirect_header('privmanager.php', 2, _AM_WEBLOG_DBUPDATED);
}
function deleteGroup($post)
{
if (isset($post['gid'])) {
$group_handler =& xoops_getmodulehandler('priv');
foreach ($post['gid'] as $gid) {
$criteria =& new Criteria('priv_gid', $gid);
$group =& $group_handler->getObjects($criteria);
if (is_object($group[0])) {
$group_handler->delete($group[0]);
}
}
}
redirect_header('privmanager.php', 2, _AM_WEBLOG_DBUPDATED);
}
switch ($action) {
case "comments":
synchronizeComments();
break;
case "add":
addGroup($_POST);
break;
case "delete":
deleteGroup($_POST);
break;
default:
privmanager();
break;
}
function tournament()
{
global $wpdb, $user_identity, $user_ID;
header('Content-Type: text/html; charset=' . getCharset() . '');
if (intval($_REQUEST['matchid']) > 0 && intval($_REQUEST['opt']) > 0) {
echo "参数错误!";
exit;
}
$matchid = intval($_REQUEST['matchid']);
if (!empty($user_identity)) {
$username = htmlspecialchars(addslashes($user_identity));
} else {
if (!empty($_COOKIE['comment_author_' . COOKIEHASH])) {
$username = htmlspecialchars(addslashes($_COOKIE['comment_author_' . COOKIEHASH]));
} else {
echo "需要登陆";
exit;
}
}
switch ($_REQUEST['opt']) {
case 'apply':
if (!getUserVerify($user_ID)) {
echo "需要选手认证才可以报名";
exit;
}
$apply = $wpdb->query("SELECT verify1 FROM pre_common_member_verify WHERE uid = {$user_ID}");
if (count(getUserList($user_ID, $matchid, -1, -1, 1)) > 0) {
echo "你已经报过名了";
exit;
}
updateUser($user_ID, $matchid, -1, -1, 1);
if (count(getUserList($user_ID, $matchid, -1, -1, 1)) > 0) {
echo "报名成功!";
exit;
}
echo "报名时发生错误";
exit;
case 'cancelapply':
updateUser($user_ID, $matchid, -1, -1, 0);
echo "报名已取消";
exit;
case 'follow':
updateUser($user_ID, $matchid, -1, 1);
if (count(getUserList($user_ID, $matchid, -1, 1)) > 0) {
echo "关注成功!";
exit;
}
echo "关注时发生错误";
exit;
case 'cancelfollow':
updateUser($user_ID, $matchid, -1, 0);
echo "关注已取消";
exit;
case 'cancelgroup':
$groupid = intval($_REQUEST['groupid']);
$memberid = intval($_REQUEST['memberid']);
$users = getUserList($memberid);
if (empty($users)) {
echo "找不到此用户ID, " . $memberid;
exit;
}
$groups = getGroupList(-1, $groupid);
if (empty($groups)) {
echo "找不到此队伍ID, " . $groupid;
exit;
}
$matchs = getMatchList($groups[0]->match_id);
if (empty($matchs)) {
echo "找不到此队伍的比赛ID, error code : " . $groups[0]->match_id;
exit;
}
if ($matchs[0]->stage != 1) {
echo "比赛不处于报名阶段,无法退出 . error code : " . $groups[0]->match_id;
exit;
}
if ($groups[0]->captain_id == $user_ID || $memberid == $user_ID) {
// 队员离开
updateUser($memberid, $matchid, 0, -1, -1, 0, -1, 0);
echo "已退出队伍";
exit;
}
echo "权限不足.";
exit;
case 'applygroup':
$users = getUserList($user_ID, $matchid);
if (!empty($users)) {
$groupid = $_REQUEST['groupid'];
if (intval($users[0]->apply_group)) {
echo "您已经申请了其他的队伍!";
exit;
}
$groups = getGroupList($matchid, $groupid);
if (empty($groups)) {
echo "比赛" . $matchid . "中找不到这个队伍!" . $groupid;
exit;
}
$groupusers = getUserList(-1, -1, $groupid);
if ($groups[0]->maxpeople - 1 < count($groupusers)) {
echo "这个队伍中的人数已经满了!" . $groupid;
exit;
}
updateUser($user_ID, $matchid, $groupid, -1, -1, 1);
echo "申请成功!";
exit;
}
echo "你尚未参加此项比赛!";
exit;
case 'passapplygroup':
$memberid = intval($_REQUEST['memberid']);
$users = getUserList($memberid, $matchid);
if (!empty($users)) {
$groupid = intval($_REQUEST['groupid']);
if ($users[0]->group_id == $groupid) {
updateUser($memberid, $matchid, $groupid, -1, -1, 1, -1, 1);
echo "通过申请!";
exit;
}
echo "申请失败!" . $users[0]->group_id . ":" . $groupid;
exit;
}
echo "此用户尚未参加此项比赛!";
exit;
case 'creategroup':
$users = getUserList($user_ID, $matchid);
if (!intval($users[0]->apply_match)) {
echo "你尚未参加此项比赛!";
exit;
}
if (intval($users[0]->apply_group)) {
echo "您已经申请了其他的队伍!";
exit;
}
$groupname = trim($_REQUEST['groupname']);
$success = addGroup($groupname, $user_ID, $matchid);
if (intval($success)) {
$groups = getGroupList($matchid, -1, $user_ID);
updateUser($user_ID, $matchid, $groups[0]->id, -1, -1, 1, -1, 1);
echo "申请成功!";
exit;
}
echo "申请发生错误error code : " . $success;
exit;
case 'ranksubmit':
$matchId = intval($_POST['matchId']);
$matchTypeId = intval($_POST['matchTypeId']);
$scheduleId = intval($_POST['scheduleId']);
$applyId = intval(addUserRankApply($user_ID, $matchId, $scheduleId));
if (!$applyId) {
echo "申请发生错误, Code:" . $applyId;
exit;
}
$submit = getUserRankApplyList(-1, $user_ID, $matchId, $scheduleId);
$rankTypeList = getRankTypeList(-1, $matchTypeId);
foreach ($rankTypeList as $rankType) {
$value = intval($_POST['rank-' . $rankType->id]);
if ($value && $submit[0]->id) {
$result = addUserRank($user_ID, $matchTypeId, $rankType->id, $value, 0, $submit[0]->id);
if (!$result) {
echo "录入信息失败,Code:" . $rankType->id;
exit;
}
} else {
echo "录入信息失败,Error Code:" . $value . " AND " . $submit[0]->id;
exit;
}
}
echo "提交选手成绩完成";
exit;
default:
echo "无法解析此函数";
exit;
}
}
<?php
include "../Actions/Authentification.php";
include "../Actions/CategoriesActions.php";
include "../Actions/TagsActions.php";
include "../Actions/TachesActions.php";
include "../Actions/GroupeActions.php";
switch ($_GET['fun']) {
case 'encoursTache':
encoursTaches();
break;
case 'terTache':
terminerTache();
break;
case 'addGroupes':
addGroup();
break;
case 'auth':
auth();
break;
case 'inscription':
inscription();
break;
case 'addCategorie':
addCategorie();
break;
case 'ModCategorie':
modCategorie();
break;
case 'deleteCategorie':
deleteCategorie();
}
} else {
if ($_GET['action'] == addGroupType && $_SESSION['access'] >= 50) {
//if the user is adding the contact, then add it
if (isset($_POST['addGroupType'])) {
$groupType = new ContactType();
addGroupType($groupType);
} else {
addGroupTypeForm();
}
} else {
if ($_GET['action'] == addGroup && $_SESSION['access'] >= 50) {
$group = new Contact();
//if the user is adding the contact, then add it
if (isset($_POST['addGroup'])) {
addGroup($group);
} else {
addGroupForm();
}
} else {
if ($_GET['action'] == addContactType && $_SESSION['access'] >= 50) {
//if the user is adding the contact, then add it
if (isset($_POST['addContactType'])) {
$contactType = new PersonType();
addContactType($contactType);
} else {
addContactTypeForm();
}
} else {
if ($_GET['action'] == addContact && $_SESSION['access'] >= 50 || $_GET['action'] == addPerson && $_SESSION['access'] >= 50) {
$contact = new Person();
if ($i < count($adgr) - 1) {
$info["owner"] .= ",";
}
}
$j = 0;
$info["memberUid"] = array();
for ($i = 0; $i < $infoUsers['count']; $i++) {
if (!empty($_POST[$infoUsers[$i]['cn'][0]])) {
$info["memberUid"][$j] = $infoUsers[$i]['cn'][0];
$j++;
}
}
for ($i = 0; $i < count($adgr); $i++) {
if (!in_array($adgr[$i], $info["memberUid"])) {
$info["memberUid"][$j] = $adgr[$i];
$j++;
}
}
// LDAP ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
// On ajoute les données au dossier
$ds = connectionLDAP();
include '../ldap/addGroup.php';
addGroup($ds, $info);
echo 'Le groupe a été correctement ajouté.';
kill($ds);
// LDAP ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
} else {
// VUE ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
echo 'Données non conformes.';
// VUE ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
}
