I have read JPDeni's tutorial but it did not cover my problem. I tried a few configurations but I don't think I have it right. It doesn't find a registered user's record. I am also trying to use my filed ID as a USERID and it is automatically updated. Using JPDeni's list, here's what I need:
View/Search: registered user
Add Records: admin
Modify Records: registered own
Delete Records: admin
My present configuration is:
$auth_no_authentication = 0;
$auth_allow_default = 0;
@auth_default_permissions = (1,1,0,0,0);
$auth_signup = 0;
@auth_signup_permissions = (1,0,0,1,0);
$auth_modify_own = 1,0,0,0;
$auth_view_own = 0;
$auth_user_field = 1;
record layout:
'Name' => [ 0, 'alpha', 40, 255, 1, '', ''],
'ID' => [ 1, 'numer', 4, 255, 1, '', '\d{1}'],
'Formal' => [ 2, 'alpha', 40, 255, 1, '', ''],
'Address1' => [ 3, 'alpha', 30, 255, 1, '', ''],
'Address2' => [ 4, 'alpha', 30, 255, 0, '', ''],
'City' => [ 5, 'alpha', 30, 255, 1, '', ''],
'State' => [ 6, 'alpha', 0, 2, 1, '', ''],
'Zip' => [ 7, 'numer', 5, 255, 1, '', '\d{5}'],
'Email' => [ 8, 'alpha', 40, 255, 0, '', '.+@.+..+'],
'HomePhone' => [ 9, 'alpha', 12, 255, 0, '', ''],
'WorkPhone' => [10, 'alpha', 12, 255, 0, '', ''],
'Fax' => [11, 'alpha', 12, 255, 0, '', ''],
'Birthdate' => [12, 'date', 20, 255, 0, &get_date(), ''],
'YearActive' => [13, 'numer', 4, 255, 0, '', '\d{4}'],
'Occupation' => [14, 'alpha', 60, 255, 0, '', ''],
'Position' => [15, 'alpha', 60, 255, 0, '', ''],
'PreviousPosition' => [16, 'alpha', 60, 255, 0, '', ''],
'Filename' => [17,'alpha', 0, 255, 0, '',
View/Search: registered user
Add Records: admin
Modify Records: registered own
Delete Records: admin
My present configuration is:
$auth_no_authentication = 0;
$auth_allow_default = 0;
@auth_default_permissions = (1,1,0,0,0);
$auth_signup = 0;
@auth_signup_permissions = (1,0,0,1,0);
$auth_modify_own = 1,0,0,0;
$auth_view_own = 0;
$auth_user_field = 1;
record layout:
'Name' => [ 0, 'alpha', 40, 255, 1, '', ''],
'ID' => [ 1, 'numer', 4, 255, 1, '', '\d{1}'],
'Formal' => [ 2, 'alpha', 40, 255, 1, '', ''],
'Address1' => [ 3, 'alpha', 30, 255, 1, '', ''],
'Address2' => [ 4, 'alpha', 30, 255, 0, '', ''],
'City' => [ 5, 'alpha', 30, 255, 1, '', ''],
'State' => [ 6, 'alpha', 0, 2, 1, '', ''],
'Zip' => [ 7, 'numer', 5, 255, 1, '', '\d{5}'],
'Email' => [ 8, 'alpha', 40, 255, 0, '', '.+@.+..+'],
'HomePhone' => [ 9, 'alpha', 12, 255, 0, '', ''],
'WorkPhone' => [10, 'alpha', 12, 255, 0, '', ''],
'Fax' => [11, 'alpha', 12, 255, 0, '', ''],
'Birthdate' => [12, 'date', 20, 255, 0, &get_date(), ''],
'YearActive' => [13, 'numer', 4, 255, 0, '', '\d{4}'],
'Occupation' => [14, 'alpha', 60, 255, 0, '', ''],
'Position' => [15, 'alpha', 60, 255, 0, '', ''],
'PreviousPosition' => [16, 'alpha', 60, 255, 0, '', ''],
'Filename' => [17,'alpha', 0, 255, 0, '',