Static Security - passing a value around

johnberman · Post by **johnberman** » Fri Apr 14, 2017 8:22 pm

Hi

I have three tables

meteor_events (has Event_ID and other fields)
Contributor (has name, email, password, contributor_ID etc)
Comments (has Event_ID which is the link to meteor_events, contributor_ID and other fields)

All 3 have a common link that is contributor ID

I dont allow registration as I add contributors

using Static levels a user can login and add comments which is great

I assume somehow I can get the contributor ID passed to the contributor ID field automatically in comments so it can be seen who added comments

Im sure its a setting somewhere ?

Regards
John Berman

mobhar · Post by **mobhar** » Sat Apr 15, 2017 6:45 pm

$this->contributor_ID->DbValue

arbei · Post by **arbei** » Wed Apr 19, 2017 11:02 am

If the contributor table is the User Table, you can use CurrentUserInfo("contributor_ID") to get the id of the logged in user.

Add this function as the Default Value of the Add page of the Comments table then generate the files and try again.

Read help file topic: "Server Events and Client Scripts" -> "Some Global Functions" for more information.