Table parameters
Contents Table layout parameters Search layout parameters Behavior Permissions General view items (applicable to all modes) Table modifications logging Table automatic maintenance "Password reminder" utility Templates substitution (location: w:/atomicsoft/misc/shot_maker/distrib/helpdesk.sql/template.en)
Parameter	Value/Comments
Table layout parameters
Table display label
Table browsing mode
Sort records by (browsing categories)	-_add_datetime [Descending] _login _email _pwd first_name last_name company country phone fax _subscribed _update_datetime user_group
View records per page
Visible fields *	_login _email first_name last_name country phone _pwd company fax _subscribed _add_datetime _update_datetime user_group
Linked columns	_login first_name last_name _email _pwd company country phone fax _subscribed _add_datetime _update_datetime user_group
Detailed entry view mode
Visible fields *	_login _email first_name last_name company country phone fax user_group _update_datetime _pwd _subscribed _add_datetime
"Add record" mode
Visible fields *	_email _pwd first_name last_name company country phone fax _subscribed user_group _login _add_datetime _update_datetime
"Record update" mode
Visible fields *	_email _pwd first_name last_name company country phone fax _subscribed user_group _login _add_datetime _update_datetime
Search layout parameters
Sort records by default	_login _email _pwd first_name last_name company country phone fax _subscribed _add_datetime _update_datetime user_group
View records per page
Search fields *	_email first_name last_name company country phone _subscribed _login fax _pwd _add_datetime _update_datetime user_group
Behavior
"Add record" mode
Run this code before applying actual changes	require "on_event.pl"; &OnRecordAdded();
"Record update" mode
Run this code before applying actual changes	require "on_event.pl"; &OnRecordUpdated();
"Record delete" mode
Run this code before applying actual changes	require "on_event.pl"; &OnRecordDeleted();
"Log in" mode
Run this code after logging in
After logging in redirect user to this URL
Moderation request alert
Send e-mail alert to admin	Don't send alerts After first moderation request After each moderation request
Moderation decline note
Send "On decline" message when modification is declined by admin
"On decline" message "from" address
"On decline" message subject
"On decline" message body template	--use default-- (decline.txt) add_form.htm add_mod.htm add_ok.htm admin.htm adm_arr.htm adm_exp.htm adm_fld.htm adm_imex.htm adm_main.htm adm_mass.htm adm_sys.htm adm_tbl.htm adm_tbl2.htm adm_uni.htm advs_frm.htm alert.eml assign.eml autoresp.eml case.htm caseclose.eml caserusr.htm cases.htm cases_ur.htm case_add.htm case_del.htm case_row.htm case_upd.htm case_usr.htm chatcont.htm chatfram.htm chatinp.htm chatmsg.htm chat_inf.htm decline.txt del_mod.htm del_ok.htm easydata.htm emergen.eml ent_view.htm errors.htm faqmaint.htm faq_res.htm faq_srch.htm hd_main.htm inquiry.htm inq_chat.htm inq_post.htm login.htm message.htm mod_alrt.txt msg_usr.htm new_musr.htm prn_1msg.htm prn_case.htm prn_fax.htm prn_main.htm prn_msg.htm prof_exp.eml pwd_msg.txt readnote.eml redirect.htm refuse.eml remember.htm remind1.eml remind2.eml reply.htm reply_ok.htm srch_box.htm srch_ln.txt srch_res.htm st_detal.htm subcat.htm tbl_view.htm tmpl_edt.htm tmpl_eml.htm tmpl_lst.htm tmpl_vie.htm upd_form.htm upd_mod.htm upd_ok.htm usr_main.htm usr_strt.htm usr_upd.htm welcome.eml
Permissions
Anonymous user permissions
Add
Moderate additions
Logged in users
Update own
Moderate own updates
Delete own
Moderate own deletions
General view items (applicable to all modes)
Sub-menu entries	add update delete
Table modifications logging
Log all modifications to file "TABLENAME.modif.log"
Table automatic maintenance
Maintenance interval (in seconds)
Data file backing up
Number of backup files (five is maximum)
Backup file #1 update period (hours)
Rename backup file #1 to #2 after this number of updates of backup file #1
Rename backup file #2 to #3 after this number of updates of backup file #2
Rename backup file #3 to #4 after this number of updates of backup file #3
Rename backup file #4 to #5 after this number of updates of backup file #4
"Password reminder" utility
Reminding message "from" address
Reminding message subject
Password remember message body template	--use default-- (pwd_msg.txt) add_form.htm add_mod.htm add_ok.htm admin.htm adm_arr.htm adm_exp.htm adm_fld.htm adm_imex.htm adm_main.htm adm_mass.htm adm_sys.htm adm_tbl.htm adm_tbl2.htm adm_uni.htm advs_frm.htm alert.eml assign.eml autoresp.eml case.htm caseclose.eml caserusr.htm cases.htm cases_ur.htm case_add.htm case_del.htm case_row.htm case_upd.htm case_usr.htm chatcont.htm chatfram.htm chatinp.htm chatmsg.htm chat_inf.htm decline.txt del_mod.htm del_ok.htm easydata.htm emergen.eml ent_view.htm errors.htm faqmaint.htm faq_res.htm faq_srch.htm hd_main.htm inquiry.htm inq_chat.htm inq_post.htm login.htm message.htm mod_alrt.txt msg_usr.htm new_musr.htm prn_1msg.htm prn_case.htm prn_fax.htm prn_main.htm prn_msg.htm prof_exp.eml pwd_msg.txt readnote.eml redirect.htm refuse.eml remember.htm remind1.eml remind2.eml reply.htm reply_ok.htm srch_box.htm srch_ln.txt srch_res.htm st_detal.htm subcat.htm tbl_view.htm tmpl_edt.htm tmpl_eml.htm tmpl_lst.htm tmpl_vie.htm upd_form.htm upd_mod.htm upd_ok.htm usr_main.htm usr_strt.htm usr_upd.htm welcome.eml
Templates substitution (location: w:/atomicsoft/misc/shot_maker/distrib/helpdesk.sql/template.en)
Sub-template to display login form	--use default-- (login.htm) add_form.htm add_mod.htm add_ok.htm admin.htm adm_arr.htm adm_exp.htm adm_fld.htm adm_imex.htm adm_main.htm adm_mass.htm adm_sys.htm adm_tbl.htm adm_tbl2.htm adm_uni.htm advs_frm.htm alert.eml assign.eml autoresp.eml case.htm caseclose.eml caserusr.htm cases.htm cases_ur.htm case_add.htm case_del.htm case_row.htm case_upd.htm case_usr.htm chatcont.htm chatfram.htm chatinp.htm chatmsg.htm chat_inf.htm decline.txt del_mod.htm del_ok.htm easydata.htm emergen.eml ent_view.htm errors.htm faqmaint.htm faq_res.htm faq_srch.htm hd_main.htm inquiry.htm inq_chat.htm inq_post.htm login.htm message.htm mod_alrt.txt msg_usr.htm new_musr.htm prn_1msg.htm prn_case.htm prn_fax.htm prn_main.htm prn_msg.htm prof_exp.eml pwd_msg.txt readnote.eml redirect.htm refuse.eml remember.htm remind1.eml remind2.eml reply.htm reply_ok.htm srch_box.htm srch_ln.txt srch_res.htm st_detal.htm subcat.htm tbl_view.htm tmpl_edt.htm tmpl_eml.htm tmpl_lst.htm tmpl_vie.htm upd_form.htm upd_mod.htm upd_ok.htm usr_main.htm usr_strt.htm usr_upd.htm welcome.eml
Sub-template to display "password mailing" form	--use default-- (remember.htm) add_form.htm add_mod.htm add_ok.htm admin.htm adm_arr.htm adm_exp.htm adm_fld.htm adm_imex.htm adm_main.htm adm_mass.htm adm_sys.htm adm_tbl.htm adm_tbl2.htm adm_uni.htm advs_frm.htm alert.eml assign.eml autoresp.eml case.htm caseclose.eml caserusr.htm cases.htm cases_ur.htm case_add.htm case_del.htm case_row.htm case_upd.htm case_usr.htm chatcont.htm chatfram.htm chatinp.htm chatmsg.htm chat_inf.htm decline.txt del_mod.htm del_ok.htm easydata.htm emergen.eml ent_view.htm errors.htm faqmaint.htm faq_res.htm faq_srch.htm hd_main.htm inquiry.htm inq_chat.htm inq_post.htm login.htm message.htm mod_alrt.txt msg_usr.htm new_musr.htm prn_1msg.htm prn_case.htm prn_fax.htm prn_main.htm prn_msg.htm prof_exp.eml pwd_msg.txt readnote.eml redirect.htm refuse.eml remember.htm remind1.eml remind2.eml reply.htm reply_ok.htm srch_box.htm srch_ln.txt srch_res.htm st_detal.htm subcat.htm tbl_view.htm tmpl_edt.htm tmpl_eml.htm tmpl_lst.htm tmpl_vie.htm upd_form.htm upd_mod.htm upd_ok.htm usr_main.htm usr_strt.htm usr_upd.htm welcome.eml
Error block sub-template	--use default-- (errors.htm) add_form.htm add_mod.htm add_ok.htm admin.htm adm_arr.htm adm_exp.htm adm_fld.htm adm_imex.htm adm_main.htm adm_mass.htm adm_sys.htm adm_tbl.htm adm_tbl2.htm adm_uni.htm advs_frm.htm alert.eml assign.eml autoresp.eml case.htm caseclose.eml caserusr.htm cases.htm cases_ur.htm case_add.htm case_del.htm case_row.htm case_upd.htm case_usr.htm chatcont.htm chatfram.htm chatinp.htm chatmsg.htm chat_inf.htm decline.txt del_mod.htm del_ok.htm easydata.htm emergen.eml ent_view.htm errors.htm faqmaint.htm faq_res.htm faq_srch.htm hd_main.htm inquiry.htm inq_chat.htm inq_post.htm login.htm message.htm mod_alrt.txt msg_usr.htm new_musr.htm prn_1msg.htm prn_case.htm prn_fax.htm prn_main.htm prn_msg.htm prof_exp.eml pwd_msg.txt readnote.eml redirect.htm refuse.eml remember.htm remind1.eml remind2.eml reply.htm reply_ok.htm srch_box.htm srch_ln.txt srch_res.htm st_detal.htm subcat.htm tbl_view.htm tmpl_edt.htm tmpl_eml.htm tmpl_lst.htm tmpl_vie.htm upd_form.htm upd_mod.htm upd_ok.htm usr_main.htm usr_strt.htm usr_upd.htm welcome.eml
"New record page" sub-template	--use default-- (add_form.htm) add_form.htm add_mod.htm add_ok.htm admin.htm adm_arr.htm adm_exp.htm adm_fld.htm adm_imex.htm adm_main.htm adm_mass.htm adm_sys.htm adm_tbl.htm adm_tbl2.htm adm_uni.htm advs_frm.htm alert.eml assign.eml autoresp.eml case.htm caseclose.eml caserusr.htm cases.htm cases_ur.htm case_add.htm case_del.htm case_row.htm case_upd.htm case_usr.htm chatcont.htm chatfram.htm chatinp.htm chatmsg.htm chat_inf.htm decline.txt del_mod.htm del_ok.htm easydata.htm emergen.eml ent_view.htm errors.htm faqmaint.htm faq_res.htm faq_srch.htm hd_main.htm inquiry.htm inq_chat.htm inq_post.htm login.htm message.htm mod_alrt.txt msg_usr.htm new_musr.htm prn_1msg.htm prn_case.htm prn_fax.htm prn_main.htm prn_msg.htm prof_exp.eml pwd_msg.txt readnote.eml redirect.htm refuse.eml remember.htm remind1.eml remind2.eml reply.htm reply_ok.htm srch_box.htm srch_ln.txt srch_res.htm st_detal.htm subcat.htm tbl_view.htm tmpl_edt.htm tmpl_eml.htm tmpl_lst.htm tmpl_vie.htm upd_form.htm upd_mod.htm upd_ok.htm usr_main.htm usr_strt.htm usr_upd.htm welcome.eml
"Addition successful" message template	--use default-- (add_ok.htm) add_form.htm add_mod.htm add_ok.htm admin.htm adm_arr.htm adm_exp.htm adm_fld.htm adm_imex.htm adm_main.htm adm_mass.htm adm_sys.htm adm_tbl.htm adm_tbl2.htm adm_uni.htm advs_frm.htm alert.eml assign.eml autoresp.eml case.htm caseclose.eml caserusr.htm cases.htm cases_ur.htm case_add.htm case_del.htm case_row.htm case_upd.htm case_usr.htm chatcont.htm chatfram.htm chatinp.htm chatmsg.htm chat_inf.htm decline.txt del_mod.htm del_ok.htm easydata.htm emergen.eml ent_view.htm errors.htm faqmaint.htm faq_res.htm faq_srch.htm hd_main.htm inquiry.htm inq_chat.htm inq_post.htm login.htm message.htm mod_alrt.txt msg_usr.htm new_musr.htm prn_1msg.htm prn_case.htm prn_fax.htm prn_main.htm prn_msg.htm prof_exp.eml pwd_msg.txt readnote.eml redirect.htm refuse.eml remember.htm remind1.eml remind2.eml reply.htm reply_ok.htm srch_box.htm srch_ln.txt srch_res.htm st_detal.htm subcat.htm tbl_view.htm tmpl_edt.htm tmpl_eml.htm tmpl_lst.htm tmpl_vie.htm upd_form.htm upd_mod.htm upd_ok.htm usr_main.htm usr_strt.htm usr_upd.htm welcome.eml
"Addition was queued for moderation" message template	--use default-- (add_mod.htm) add_form.htm add_mod.htm add_ok.htm admin.htm adm_arr.htm adm_exp.htm adm_fld.htm adm_imex.htm adm_main.htm adm_mass.htm adm_sys.htm adm_tbl.htm adm_tbl2.htm adm_uni.htm advs_frm.htm alert.eml assign.eml autoresp.eml case.htm caseclose.eml caserusr.htm cases.htm cases_ur.htm case_add.htm case_del.htm case_row.htm case_upd.htm case_usr.htm chatcont.htm chatfram.htm chatinp.htm chatmsg.htm chat_inf.htm decline.txt del_mod.htm del_ok.htm easydata.htm emergen.eml ent_view.htm errors.htm faqmaint.htm faq_res.htm faq_srch.htm hd_main.htm inquiry.htm inq_chat.htm inq_post.htm login.htm message.htm mod_alrt.txt msg_usr.htm new_musr.htm prn_1msg.htm prn_case.htm prn_fax.htm prn_main.htm prn_msg.htm prof_exp.eml pwd_msg.txt readnote.eml redirect.htm refuse.eml remember.htm remind1.eml remind2.eml reply.htm reply_ok.htm srch_box.htm srch_ln.txt srch_res.htm st_detal.htm subcat.htm tbl_view.htm tmpl_edt.htm tmpl_eml.htm tmpl_lst.htm tmpl_vie.htm upd_form.htm upd_mod.htm upd_ok.htm usr_main.htm usr_strt.htm usr_upd.htm welcome.eml
"Update record page" sub-template	--use default-- (upd_form.htm) add_form.htm add_mod.htm add_ok.htm admin.htm adm_arr.htm adm_exp.htm adm_fld.htm adm_imex.htm adm_main.htm adm_mass.htm adm_sys.htm adm_tbl.htm adm_tbl2.htm adm_uni.htm advs_frm.htm alert.eml assign.eml autoresp.eml case.htm caseclose.eml caserusr.htm cases.htm cases_ur.htm case_add.htm case_del.htm case_row.htm case_upd.htm case_usr.htm chatcont.htm chatfram.htm chatinp.htm chatmsg.htm chat_inf.htm decline.txt del_mod.htm del_ok.htm easydata.htm emergen.eml ent_view.htm errors.htm faqmaint.htm faq_res.htm faq_srch.htm hd_main.htm inquiry.htm inq_chat.htm inq_post.htm login.htm message.htm mod_alrt.txt msg_usr.htm new_musr.htm prn_1msg.htm prn_case.htm prn_fax.htm prn_main.htm prn_msg.htm prof_exp.eml pwd_msg.txt readnote.eml redirect.htm refuse.eml remember.htm remind1.eml remind2.eml reply.htm reply_ok.htm srch_box.htm srch_ln.txt srch_res.htm st_detal.htm subcat.htm tbl_view.htm tmpl_edt.htm tmpl_eml.htm tmpl_lst.htm tmpl_vie.htm upd_form.htm upd_mod.htm upd_ok.htm usr_main.htm usr_strt.htm usr_upd.htm welcome.eml
"Update successful" message template	--use default-- (upd_ok.htm) add_form.htm add_mod.htm add_ok.htm admin.htm adm_arr.htm adm_exp.htm adm_fld.htm adm_imex.htm adm_main.htm adm_mass.htm adm_sys.htm adm_tbl.htm adm_tbl2.htm adm_uni.htm advs_frm.htm alert.eml assign.eml autoresp.eml case.htm caseclose.eml caserusr.htm cases.htm cases_ur.htm case_add.htm case_del.htm case_row.htm case_upd.htm case_usr.htm chatcont.htm chatfram.htm chatinp.htm chatmsg.htm chat_inf.htm decline.txt del_mod.htm del_ok.htm easydata.htm emergen.eml ent_view.htm errors.htm faqmaint.htm faq_res.htm faq_srch.htm hd_main.htm inquiry.htm inq_chat.htm inq_post.htm login.htm message.htm mod_alrt.txt msg_usr.htm new_musr.htm prn_1msg.htm prn_case.htm prn_fax.htm prn_main.htm prn_msg.htm prof_exp.eml pwd_msg.txt readnote.eml redirect.htm refuse.eml remember.htm remind1.eml remind2.eml reply.htm reply_ok.htm srch_box.htm srch_ln.txt srch_res.htm st_detal.htm subcat.htm tbl_view.htm tmpl_edt.htm tmpl_eml.htm tmpl_lst.htm tmpl_vie.htm upd_form.htm upd_mod.htm upd_ok.htm usr_main.htm usr_strt.htm usr_upd.htm welcome.eml
"Update was queued for moderation" message template	--use default-- (upd_mod.htm) add_form.htm add_mod.htm add_ok.htm admin.htm adm_arr.htm adm_exp.htm adm_fld.htm adm_imex.htm adm_main.htm adm_mass.htm adm_sys.htm adm_tbl.htm adm_tbl2.htm adm_uni.htm advs_frm.htm alert.eml assign.eml autoresp.eml case.htm caseclose.eml caserusr.htm cases.htm cases_ur.htm case_add.htm case_del.htm case_row.htm case_upd.htm case_usr.htm chatcont.htm chatfram.htm chatinp.htm chatmsg.htm chat_inf.htm decline.txt del_mod.htm del_ok.htm easydata.htm emergen.eml ent_view.htm errors.htm faqmaint.htm faq_res.htm faq_srch.htm hd_main.htm inquiry.htm inq_chat.htm inq_post.htm login.htm message.htm mod_alrt.txt msg_usr.htm new_musr.htm prn_1msg.htm prn_case.htm prn_fax.htm prn_main.htm prn_msg.htm prof_exp.eml pwd_msg.txt readnote.eml redirect.htm refuse.eml remember.htm remind1.eml remind2.eml reply.htm reply_ok.htm srch_box.htm srch_ln.txt srch_res.htm st_detal.htm subcat.htm tbl_view.htm tmpl_edt.htm tmpl_eml.htm tmpl_lst.htm tmpl_vie.htm upd_form.htm upd_mod.htm upd_ok.htm usr_main.htm usr_strt.htm usr_upd.htm welcome.eml
"Deletion successful" message template	--use default-- (del_ok.htm) add_form.htm add_mod.htm add_ok.htm admin.htm adm_arr.htm adm_exp.htm adm_fld.htm adm_imex.htm adm_main.htm adm_mass.htm adm_sys.htm adm_tbl.htm adm_tbl2.htm adm_uni.htm advs_frm.htm alert.eml assign.eml autoresp.eml case.htm caseclose.eml caserusr.htm cases.htm cases_ur.htm case_add.htm case_del.htm case_row.htm case_upd.htm case_usr.htm chatcont.htm chatfram.htm chatinp.htm chatmsg.htm chat_inf.htm decline.txt del_mod.htm del_ok.htm easydata.htm emergen.eml ent_view.htm errors.htm faqmaint.htm faq_res.htm faq_srch.htm hd_main.htm inquiry.htm inq_chat.htm inq_post.htm login.htm message.htm mod_alrt.txt msg_usr.htm new_musr.htm prn_1msg.htm prn_case.htm prn_fax.htm prn_main.htm prn_msg.htm prof_exp.eml pwd_msg.txt readnote.eml redirect.htm refuse.eml remember.htm remind1.eml remind2.eml reply.htm reply_ok.htm srch_box.htm srch_ln.txt srch_res.htm st_detal.htm subcat.htm tbl_view.htm tmpl_edt.htm tmpl_eml.htm tmpl_lst.htm tmpl_vie.htm upd_form.htm upd_mod.htm upd_ok.htm usr_main.htm usr_strt.htm usr_upd.htm welcome.eml
"Deletion was queued for moderation" message template	--use default-- (del_mod.htm) add_form.htm add_mod.htm add_ok.htm admin.htm adm_arr.htm adm_exp.htm adm_fld.htm adm_imex.htm adm_main.htm adm_mass.htm adm_sys.htm adm_tbl.htm adm_tbl2.htm adm_uni.htm advs_frm.htm alert.eml assign.eml autoresp.eml case.htm caseclose.eml caserusr.htm cases.htm cases_ur.htm case_add.htm case_del.htm case_row.htm case_upd.htm case_usr.htm chatcont.htm chatfram.htm chatinp.htm chatmsg.htm chat_inf.htm decline.txt del_mod.htm del_ok.htm easydata.htm emergen.eml ent_view.htm errors.htm faqmaint.htm faq_res.htm faq_srch.htm hd_main.htm inquiry.htm inq_chat.htm inq_post.htm login.htm message.htm mod_alrt.txt msg_usr.htm new_musr.htm prn_1msg.htm prn_case.htm prn_fax.htm prn_main.htm prn_msg.htm prof_exp.eml pwd_msg.txt readnote.eml redirect.htm refuse.eml remember.htm remind1.eml remind2.eml reply.htm reply_ok.htm srch_box.htm srch_ln.txt srch_res.htm st_detal.htm subcat.htm tbl_view.htm tmpl_edt.htm tmpl_eml.htm tmpl_lst.htm tmpl_vie.htm upd_form.htm upd_mod.htm upd_ok.htm usr_main.htm usr_strt.htm usr_upd.htm welcome.eml
* - required fields