Hello! I have gone in circle the last couple of days so I am seeking assistance - The purpose of my database is that anyone (default user) can search w/out logging on; users cannot create own account - those with permission can add, modify and delete - and
Here is my trouble - the admin can do everything with no problem, default search is no problem - BUT those who need to logon after they have added a record their second and so on records are recorded into the database but they can only modify and delete a single record (their first one, I believe; also, strangely, when they do add their second record the confirmation screen shows up only a few field which are blank - the script can be found at:
http://www.sysadminsrus.com/cgi-local/dbman4/db.cgi
I created a new user with no records: user1 / use1 or you can logon in as company1/password1 which has several records already entered.
Here is my config permissions;
# No Authentication? (1 = "there is no authentication", 0 = "there is authentication")
# If you choose no authentication, then set the permissions of what
# people can do with: @auth_default_permissions below.
$auth_no_authentication = 0;
# The amount of time in seconds that user files are kept in the
# auth directory before the program removes them. 2-6 hours is
# probably a good value.
$auth_time = 21600; # 6 hours (in seconds)
# Enable (1) or disable (0) logging.
$auth_logging = 1;
# Allow a default user? This means you can specify a user via the URL
# and skip the logon process. Use this to allow people to search without
# logging on, but require log in if they want to add/modify/remove etc.
# (1 = "yes", 0 = "no")
$auth_allow_default = 1;
# Default permissions used if there is no authentication, or for a default
# user. (View, Add, Delete, Modify, Admin), 1 = enable, 0 = disable.
@auth_default_permissions = (1,0,0,0,0);
# Allow people to sign up for their own userid/passwords? They will
# recieve default permissions.
$auth_signup = 1;
# Permissions a new signup should get.
@auth_signup_permissions = (1,1,1,1,0);
# Registered users: can modify/delete _only_ own records. For this to make
# sense you should set default off or to 1,0,0,0.
$auth_modify_own = 1;
# Registered users: can view _only_ own records. For this to make sense
# you should turn off default permissions.
$auth_view_own = 0;
# Auth user field. This is the field position in the database used for storing
# the userid who owns the record. Set to -1 if not used.
$auth_user_field = 0;
# URL to send user if they chose log off. Leave blank and the script will return to
# the logon prompt (although this only makes sense if you are using authentication).
$auth_logoff = "http://www.sysadminsrus.com";
here is part of the Database definition:
# Database Definition
# --------------------------------------------------------
# Definition of your database. Format is
# field_name => ['position', 'field_type', 'form-length', 'maxlength', 'not_null', 'default', 'valid_expr']
%db_def = (
'number' => [ 0, 'numer', -1, 255, 0, '', ''],
'userID' => [ 1, 'alpha', -1, 255, 0, '', ''],
'Job ID' => [ 2, 'alpha', 20, 255, 1, '', ''],
'Technical Area' => [ 3, 'alpha', 0, 28, 1, '', ''],
'Job Title' => [ 4, 'alpha', 20, 255, 0, '', ''],
'City Location' => [ 5, 'alpha', 20, 255, 0, '', ''],
'State Location' => [ 6, 'alpha', 0, 20, 0, '', ''],
'Area Code' => [ 7, 'alpha', 20, 255, 0, '', ''],
'Term' => [ 8, 'alpha', 0, 16, 0, '', ''],
'Salary' => [ 9, 'alpha', 0, 14, 0, '', ''],
'Years Experience' => [10, 'alpha', 0, 29, 0, '', ''],
'Authorization' => [11, 'alpha', 0, 28, 0, '', ''],
'Job Requirements' => [12, 'alpha', '40x5', 1000, 1, '', ''],
'Company/Job Description'=> [13, 'alpha', '40x5', 1000, 0, '', ''],
'Email Apply' => [14, 'alpha', 20, 255, 0, '', '.+@.+..+'],
'Phone' => [15, 'alpha', 20, 255, 0, '', ''],
'Fax' => [16, 'alpha', 20, 255, 0, '', ''],
'Company Website' => [17, 'alpha', 20, 255, 0, 'http://', '^http://'],
'Date Posted' => [18, 'date', 20, 255, 0, &get_date(), '']
);
Thanks for looking at this,
Jim
Here is my trouble - the admin can do everything with no problem, default search is no problem - BUT those who need to logon after they have added a record their second and so on records are recorded into the database but they can only modify and delete a single record (their first one, I believe; also, strangely, when they do add their second record the confirmation screen shows up only a few field which are blank - the script can be found at:
http://www.sysadminsrus.com/cgi-local/dbman4/db.cgi
I created a new user with no records: user1 / use1 or you can logon in as company1/password1 which has several records already entered.
Here is my config permissions;
# No Authentication? (1 = "there is no authentication", 0 = "there is authentication")
# If you choose no authentication, then set the permissions of what
# people can do with: @auth_default_permissions below.
$auth_no_authentication = 0;
# The amount of time in seconds that user files are kept in the
# auth directory before the program removes them. 2-6 hours is
# probably a good value.
$auth_time = 21600; # 6 hours (in seconds)
# Enable (1) or disable (0) logging.
$auth_logging = 1;
# Allow a default user? This means you can specify a user via the URL
# and skip the logon process. Use this to allow people to search without
# logging on, but require log in if they want to add/modify/remove etc.
# (1 = "yes", 0 = "no")
$auth_allow_default = 1;
# Default permissions used if there is no authentication, or for a default
# user. (View, Add, Delete, Modify, Admin), 1 = enable, 0 = disable.
@auth_default_permissions = (1,0,0,0,0);
# Allow people to sign up for their own userid/passwords? They will
# recieve default permissions.
$auth_signup = 1;
# Permissions a new signup should get.
@auth_signup_permissions = (1,1,1,1,0);
# Registered users: can modify/delete _only_ own records. For this to make
# sense you should set default off or to 1,0,0,0.
$auth_modify_own = 1;
# Registered users: can view _only_ own records. For this to make sense
# you should turn off default permissions.
$auth_view_own = 0;
# Auth user field. This is the field position in the database used for storing
# the userid who owns the record. Set to -1 if not used.
$auth_user_field = 0;
# URL to send user if they chose log off. Leave blank and the script will return to
# the logon prompt (although this only makes sense if you are using authentication).
$auth_logoff = "http://www.sysadminsrus.com";
here is part of the Database definition:
# Database Definition
# --------------------------------------------------------
# Definition of your database. Format is
# field_name => ['position', 'field_type', 'form-length', 'maxlength', 'not_null', 'default', 'valid_expr']
%db_def = (
'number' => [ 0, 'numer', -1, 255, 0, '', ''],
'userID' => [ 1, 'alpha', -1, 255, 0, '', ''],
'Job ID' => [ 2, 'alpha', 20, 255, 1, '', ''],
'Technical Area' => [ 3, 'alpha', 0, 28, 1, '', ''],
'Job Title' => [ 4, 'alpha', 20, 255, 0, '', ''],
'City Location' => [ 5, 'alpha', 20, 255, 0, '', ''],
'State Location' => [ 6, 'alpha', 0, 20, 0, '', ''],
'Area Code' => [ 7, 'alpha', 20, 255, 0, '', ''],
'Term' => [ 8, 'alpha', 0, 16, 0, '', ''],
'Salary' => [ 9, 'alpha', 0, 14, 0, '', ''],
'Years Experience' => [10, 'alpha', 0, 29, 0, '', ''],
'Authorization' => [11, 'alpha', 0, 28, 0, '', ''],
'Job Requirements' => [12, 'alpha', '40x5', 1000, 1, '', ''],
'Company/Job Description'=> [13, 'alpha', '40x5', 1000, 0, '', ''],
'Email Apply' => [14, 'alpha', 20, 255, 0, '', '.+@.+..+'],
'Phone' => [15, 'alpha', 20, 255, 0, '', ''],
'Fax' => [16, 'alpha', 20, 255, 0, '', ''],
'Company Website' => [17, 'alpha', 20, 255, 0, 'http://', '^http://'],
'Date Posted' => [18, 'date', 20, 255, 0, &get_date(), '']
);
Thanks for looking at this,
Jim