close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Security Asssit User (Groups/Levels)

Thread began 5/31/2012 10:22 pm by SuperSoaker | Last modified 6/06/2012 4:28 pm by Jason Byrnes | 981 views | 13 replies |

SuperSoaker

Security Asssit User (Groups/Levels)

Adding UserGroup to existing users_update page: I added a static dropdown value = to:<?php $row_WADAusers['UserGroupID'] ?> and added <?php echo $row_WADAusers['UserGroupID']; ?> to update record (users) it does not update the record. I followed same as the userCountry drop down.

I'm also adding UsersGroups, usergroup to the results page, but when i use the tables from the usergroups table whcih has 3 groups it multiplies the entries each user 3 times as each level and if i use the user, groupid it only provides a number not the text value.

as always thanks for your help

Sign in to reply to this post

Jason ByrnesWebAssist

in the update record behavior, you should be binding the User Group column to the user Group form element, not to the user group column of the recordset.

Sign in to reply to this post

SuperSoaker

Sorry i'm still not doing something right

to refresh what I'm trying to do:

Added a user group to the user-insert.php, now i want to update the user group from update page and have a column in the results page
Will attach three files

Thanks making big strides and some very little ones.

thanks again, let me know if you need more info

Attached Files
users_insert.zip
Sign in to reply to this post

Jason ByrnesWebAssist

On the update page, dont add the usergroups.UserGroup column to the WADAUsers recordset, but you do need to add the users.UserGroupID column.

create a new recordset that queries the usergroups table to return the UserGroup and UserGroupID columns.

Use that recordset to populate the user group select list, same as you did on the insert page.

In the Dynamic Select list options, in the Select Value Equal to section, click the lightning bolt icon and select the WADAUsers.UserGroupID recordset column.

In the update record behavior, bind the UserGroupID column to the user group select list.

Sign in to reply to this post

SuperSoaker

Almost got it

Thanks Jason, that worked perfect the last part I'm working on is the results page I need to add the Users.UsersGroup "name" to the results, I can get the numbers to show by using user.usergroupid, but I need the name to show

Thanks,

you guys have been great

Attached Files
users_results.zip
Sign in to reply to this post

Jason ByrnesWebAssist

you need to convert the WADAUsers query to a joined query:

SELECT UserID, UserEmail, UserFirstName, UserLastName, users.UserGroupID, usergroups.UserGroup 
FROM users
INNER JOIN usergroups
ON usergroups.UserGroupID = users.UserGroupID
Sign in to reply to this post

SuperSoaker

Changes copied and applied

Thanks Jason, I did not see where the software let me make those selections? Just ran into another problem, on the user_update page I have the user group region hidden from all except admin, but when the update is made by anyone that's not an admin it's nulls out the groupid? Do i let the drop down show but make a rule that prevents others from changing or do we need to make a change drop down?

thanks

Sign in to reply to this post

Jason ByrnesWebAssist

you need to edit the wadausers recordset to change the query.


using the security assist show region behavior, set the select list to show for admins, for other user levels, replace it with a hidden form element that captures the original user level from the users table.

Sign in to reply to this post

SuperSoaker

Really Trying Here

I tried updating as you requested with no luck, please see attached.

thanks

Attached Files
users_update2.zip
Sign in to reply to this post

Jason ByrnesWebAssist

please provide more details.

what specifically are you having "no luck" with?

what specifically is not working?

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...