SQL: SELECT * FROM `domainx`.`modx_web_groups`, `domainx`.`modx_web_user_attributes` WHERE `domainx`.`modx_web_user_attributes`.`internalKey` = '2' AND `domainx`.`modx_web_groups`.`internalKey` = '2'
WHERE `domainx`.`modx_web_user_attributes`.`internalKey` = ’2’ AND `domainx`.`modx_web_groups`.`internalKey` = ’2’I think it would need to be :
WHERE `domainx`.`modx_web_user_attributes`.`internalKey` = '2' AND `domainx`.`modx_web_groups`.`webuser` = '2'
<?php
if($use_udperms==1) {
$groupsarray = array();
if($_GET['a']=='88') { // only do this bit if the user is being edited
$sql = "SELECT * FROM $dbase.`".$table_prefix."web_groups` where webuser=".$_GET['id']."";
$rs = mysql_query($sql);
$limit = mysql_num_rows($rs);
for ($i = 0; $i < $limit; $i++) {
$currentgroup=mysql_fetch_assoc($rs);
$groupsarray[$i] = $currentgroup['webgroup'];
}
}
// retain selected user groups between post
if(is_array($_POST['user_groups'])) {
foreach($_POST['user_groups'] as $n => $v) $groupsarray[] = $v;
}
?>
<div class="sectionHeader"><?php echo $_lang['web_access_permissions']; ?></div><div class="sectionBody">
<?php
echo $_lang['access_permissions_user_message']."<p />";
$sql = "SELECT name, id FROM $dbase.`".$table_prefix."webgroup_names` ORDER BY name";
$rs = mysql_query($sql);
$limit = mysql_num_rows($rs);
for($i=0; $i<$limit; $i++) {
$row=mysql_fetch_assoc($rs);
echo "<input type='checkbox' name='user_groups[]' value='".$row['id']."'".(in_array($row['id'], $groupsarray) ? " checked='checked'" : "")." />".$row['name']."<br />";
}
?>
</div>