one step forward, two steps back.

i want to display special text next to each record in List All if the user looking at the record has permission to modify the record. No text or different text should appear next to records for which this person does not have permission to modify. i have $auth_modify_own = 1 and $auth_view_own = 0. i added the following code right before the closing table tag in db.cgi, sub build_html_record:



i can't get $db_userid part of this to work and i've tried a jillion things. i want to compare the logged in user (i thought this is $db_userid) to the record owner. what am i doing wrong?

Try using this:

|;
print qq! <A HREF="$db_script_url?db=default&uid=$db_uid&modify_form_record=1&modify=$rec{$db_key}">Modify</A> ! if ($per_mod);
print qq|

change the name of the database to match yours.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

wouldn't that link appear with the record even if the current user is not the owner of the record? then when they click the link they would get some kind of error message? or worse, they would get the error message after they entered changes?

It should only appear if that user who is logged in has permission to modify the record.

Did you try it?

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

i was in meetings all day yesterday and didn't get to try it or do anything else on the database. i'll be in meetings today tilll 3 so i'll try it later. thanks.

finally had time to try it. it displays the link even if the current user is not the owner. when you click the link you are able to make changes on the form. then when you click the button to save your changes, you get an error "unable to find record" if you are not the owner. no error and no problem if you are the owner.

finally have it working!!!

in cfg file, i changed field type from alpha to userid for the userid field and i changed field type to lock for a yes/no field named Locked. i also have two variables $instmod and $instdel to indicate whether instant modify and delete are allowed.

then in db.cgi, near beginning of build_html_record i added the first line and the last two lines below:



then right before closing table in same sub i added:



i think i should have been able to do it using the field number for the userid field, but i never could figure it out and since field type alpha didn't seem to do anything i decided to steal it.