setTableNames( array( // intra tables "int_login_log" => $prefix . "int_login_log", "int_menu" => $prefix . "int_menu", "int_module" => $prefix . "int_module", "int_action" => $prefix . "int_module_action", "int_lang" => $prefix . "int_lang", "int_translation" => $prefix . "int_lang_translation", "int_user" => $prefix . "int_user", "int_group" => $prefix . "int_user_group", "int_priv" => $prefix . "int_priv", "int_menu_name" => $prefix . "int_menu_name", "int_module_name" => $prefix . "int_module_name", "int_action_name" => $prefix . "int_module_action_name", "int_group_name" => $prefix . "int_user_group_name", "int_te_table" => $prefix . "int_te_table", "int_te_table_name" => $prefix . "int_te_table_name", "int_te_field" => $prefix . "int_te_table_field", "int_te_field_name" => $prefix . "int_te_table_field_name", "int_te_field_changeable" => $prefix . "int_te_table_field_changeable", "int_te_field_user_vars" => $prefix . "int_te_table_field_user_vars", "int_te_field_visible" => $prefix . "int_te_table_field_visible", "int_te_table_user_vars" => $prefix . "int_te_table_user_vars", // web tables "web_lang" => $prefix . "web_lang", "web_translation" => $prefix . "web_lang_translation", "web_translation_data" => $prefix . "web_lang_translation_data", "web_banner" => $prefix . "web_banner", "web_banner_slot" => $prefix . "web_banner_slot", "web_banner_slot_text" => $prefix . "web_banner_slot_text", "web_banner_text" => $prefix . "web_banner_text", "web_menu_banner" => $prefix . "web_menu_banner", "web_menu_banner_slot" => $prefix . "web_menu_banner_slot", "web_menu" => $prefix . "web_menu", "web_menu_with_help" => $prefix . "web_menu_with_help", "web_menu_multilang" => $prefix . "web_menu_multilang", "web_menu_multilang_data" => $prefix . "web_menu_multilang_data", "web_menu_mode" => $prefix . "web_menu_mode", "web_module" => $prefix . "web_module", "web_action" => $prefix . "web_module_action", "web_menu_mode_name" => $prefix . "web_menu_mode_name", "web_module_name" => $prefix . "web_module_name", "web_action_name" => $prefix . "web_module_action_name", "web_article_file" => $prefix . "web_article_file", "web_article_item" => $prefix . "web_article_item", "web_article_group" => $prefix . "web_article_group", "web_article_group_name" => $prefix . "web_article_group_name", "web_file" => $prefix . "web_file", "web_file_text" => $prefix . "web_file_text", "web_file_type" => $prefix . "web_file_type", "web_file_type_group" => $prefix . "web_file_type_group", "web_file_type_group_text" => $prefix . "web_file_type_group_text", // dynamic database (ddb) tables "ddb_company" => $prefix . "ddb_company", "ddb_data_checkbox" => $prefix . "ddb_data_checkbox", "ddb_data_checkbox_textfield_combo" => $prefix . "ddb_data_checkbox_textfield_combo", "ddb_data_listbox" => $prefix . "ddb_data_listbox", "ddb_data_textarea" => $prefix . "ddb_data_textarea", "ddb_data_textfield" => $prefix . "ddb_data_textfield", "ddb_database" => $prefix . "ddb_database", "ddb_database_name" => $prefix . "ddb_database_name", "ddb_field" => $prefix . "ddb_field", "ddb_field_format" => $prefix . "ddb_field_format", "ddb_field_format_info" => $prefix . "ddb_field_format_info", "ddb_field_group" => $prefix . "ddb_field_group", "ddb_field_group_name" => $prefix . "ddb_field_group_name", "ddb_field_listbox_item" => $prefix . "ddb_field_listbox_item", "ddb_field_listbox_item_name" => $prefix . "ddb_field_listbox_item_name", "ddb_field_name" => $prefix . "ddb_field_name", "ddb_field_type" => $prefix . "ddb_field_type", "ddb_field_type_name" => $prefix . "ddb_field_type_name", "ddb_object" => $prefix . "ddb_object", "ddb_object_name" => $prefix . "ddb_object_name", "ddb_table" => $prefix . "ddb_table", "ddb_table_name" => $prefix . "ddb_table_name", // product tables "prd_campaign" => $prefix . "prd_campaign", "prd_campaign_text" => $prefix . "prd_campaign_text", "prd_campaign_node" => $prefix . "prd_campaign_node", "prd_field" => $prefix . "prd_field", "prd_field_text" => $prefix . "prd_field_text", "prd_field_data" => $prefix . "prd_field_data", "prd_group" => $prefix . "prd_group", "prd_group_text" => $prefix . "prd_group_text", "prd_group_node" => $prefix . "prd_group_node", "prd_product" => $prefix . "prd_product", "prd_product_text" => $prefix . "prd_product_text", "prd_product_image" => $prefix . "prd_product_image", "prd_type" => $prefix . "prd_type", "prd_type_text" => $prefix . "prd_type_text", // area tables "area_region" => $prefix . "area_region", "area_region_name" => $prefix . "area_region_name", "area_county" => $prefix . "area_county", "area_settlement" => $prefix . "area_settlement", // poll tables "poll_question" => $prefix . "poll_question", "poll_question_text" => $prefix . "poll_question_text", "poll_answer" => $prefix . "poll_answer", "poll_answer_text" => $prefix . "poll_answer_text", "poll_result" => $prefix . "poll_result", // newsletter tables "newsletter_item" => $prefix . "newsletter_item", "newsletter_text" => $prefix . "newsletter_text", "newsletter_user" => $prefix . "newsletter_user", "newsletter_check" => $prefix . "newsletter_check", // sql tables "sql_view" => $prefix . "sql_view", "sql_view_text" => $prefix . "sql_view_text", "sql_view_from" => $prefix . "sql_view_from", "sql_view_select" => $prefix . "sql_view_select", "sql_view_select_text" => $prefix . "sql_view_select_text", "sql_view_select_user_conf" => $prefix . "sql_view_select_user_conf", "sql_view_user_conf" => $prefix . "sql_view_user_conf", // contact tables "web_contact_department" => $prefix . "web_contact_department", "web_contact_department_text" => $prefix . "web_contact_department_text", "web_contact_department_visible" => $prefix . "web_contact_department_visible", "web_contact_worker" => $prefix . "web_contact_worker", "web_contact_worker_text" => $prefix . "web_contact_worker_text", "web_contact_worker_visible" => $prefix . "web_contact_worker_visible", "web_contact_worker_visible" => $prefix . "web_contact_worker_visible", // web2 tables "web2_project" => $prefix . "web2_project", "web2_template" => $prefix . "web2_template", "web2_theme" => $prefix . "web2_theme", "web2_var" => $prefix . "web2_var", "web2_var_data" => $prefix . "web2_var_data", // forum tables "forum_topics" => $prefix . "forum_topics", // Form tables "form" => $prefix . "form", "form_text" => $prefix . "form_text", "form_field" => $prefix . "form_field", "form_field_text" => $prefix . "form_field_text", "form_values" => $prefix . "form_values", "users" => $prefix . "users" ) ); // system tables $n->setFieldNames( "users", array( "id" => "id", "username" => "username", "passwd" => "passwd", "first_name" => "first_name", "last_name" => "last_name", "company" => "company", "licence" => "licence", "address" => "address", "phone" => "phone", "mobile" => "mobile", "email" => "email", "lang_id" => "lang_id", "is_active" => "is_active" ) ); // system tables $n->setFieldNames( "int_login_log", array( "id" => "id", "username" => "username", "login_type" => "login_type", "timestamp" => "timestamp", "remote_addr" => "remote_addr", "remote_host" => "remote_host", "forwarded_addr" => "forwarded_addr", "forwarded_host" => "forwarded_host" ) ); $n->setFieldNames( "int_menu", array( "id" => "id", "parent_id" => "parent_id", "redirect_id" => "redirect_id", "action_id" => "module_action_id", "order_id" => "order_id", "is_visible" => "is_visible" ) ); $n->setFieldNames( "int_menu_name", array( "lang_id" => "lang_id", "menu_id" => "menu_id", "name" => "name" ) ); $n->setFieldNames( "int_module", array( "id" => "id", "include" => "include", "class" => "class", "parameters" => "parameters", "is_active" => "is_active" ) ); $n->setFieldNames( "int_action", array( "id" => "id", "module_id" => "module_id", "alias" => "alias", "function" => "function", "parameters" => "parameters", "is_active" => "is_active" ) ); $n->setFieldNames( "int_lang", array( "id" => "id", "name" => "name", "charset" => "charset" ) ); $n->setFieldNames( "int_translation", array( "lang_id" => "lang_id", "name" => "name", "value" => "value" ) ); $n->setFieldNames( "int_user", array( "id" => "id", "group_id" => "user_group_id", "lang_id" => "lang_id", "username" => "username", "password" => "password", "first_name" => "first_name", "last_name" => "last_name", "nick_name" => "nick_name", "email" => "email", "modify_lang" => "modify_lang" ) ); $n->setFieldNames( "int_group", array( "id" => "id" ) ); $n->setFieldNames( "int_priv", array( "group_id" => "user_group_id", "action_id" => "module_action_id", "item_id" => "module_item_id", "priv" => "priv" ) ); $n->setFieldNames( "int_module_name", array( "module_id" => "module_id", "lang_id" => "lang_id", "name" => "name" ) ); $n->setFieldNames( "int_action_name", array( "action_id" => "module_action_id", "lang_id" => "lang_id", "name" => "name" ) ); $n->setFieldNames( "int_group_name", array( "group_id" => "user_group_id", "lang_id" => "lang_id", "name" => "name" ) ); // table editor tables $n->setFieldNames( "int_te_table", array( "id" => "id", "table_name" => "table_name", "main_field" => "main_field", "order_field" => "order_field" ) ); $n->setFieldNames( "int_te_table_name", array( "table_id" => "table_id", "lang_id" => "lang_id", "name" => "name" ) ); $n->setFieldNames( "int_te_field", array( "id" => "id", "table_id" => "table_id", "fk_table_id" => "fk_table_id", "type" => "type", "size" => "size", "field_name" => "field_name", "is_unique" => "is_unique", "is_required" => "is_required" ) ); $n->setFieldNames( "int_te_field_name", array( "field_id" => "field_id", "lang_id" => "lang_id", "name" => "name" ) ); $n->setFieldNames( "int_te_field_changeable", array( "field_id" => "field_id", "order_id" => "order_id" ) ); $n->setFieldNames( "int_te_field_user_vars", array( "field_id" => "field_id", "user_id" => "user_id", "filter" => "filter" ) ); $n->setFieldNames( "int_te_field_visible", array( "field_id" => "field_id", "order_id" => "order_id" ) ); $n->setFieldNames( "int_te_table_user_vars", array( "table_id" => "table_id", "user_id" => "user_id", "sort_field_id" => "sort_field_id", "sort_type" => "sort_type", "items_per_page" => "items_per_page" ) ); // dynamic database (ddb) tables $n->setFieldNames( "ddb_company", array( "id" => "id", "modify_user_id" => "modify_user_id", "modify_time" => "modify_time", "is_checked" => "is_checked", "name" => "name", "owner_person" => "owner_person", "contact_person" => "contact_person", "trademark" => "trademark", "settlement_id" => "settlement_id", "index" => "index", "address" => "address", "phone1" => "phone1", "phone2" => "phone2", "phone3" => "phone3", "fax" => "fax", "email" => "email", "url" => "url" ) ); $n->setFieldNames( "ddb_data_checkbox", array( "object_id" => "object_id", "field_id" => "field_id", "value" => "value" ) ); $n->setFieldNames( "ddb_data_checkbox_textfield_combo", array( "object_id" => "object_id", "field_id" => "field_id", "lang_id" => "lang_id", "checkbox" => "checkbox", "textfield" => "textfield" ) ); $n->setFieldNames( "ddb_data_listbox", array( "object_id" => "object_id", "field_id" => "field_id", "item_id" => "item_id" ) ); $n->setFieldNames( "ddb_data_textarea", array( "object_id" => "object_id", "field_id" => "field_id", "lang_id" => "lang_id", "value" => "value" ) ); $n->setFieldNames( "ddb_data_textfield", array( "object_id" => "object_id", "field_id" => "field_id", "lang_id" => "lang_id", "value" => "value" ) ); $n->setFieldNames( "ddb_database", array( "id" => "id", "is_visible" => "is_visible" ) ); $n->setFieldNames( "ddb_database_name", array( "database_id" => "database_id", "lang_id" => "lang_id", "name" => "name" ) ); $n->setFieldNames( "ddb_field", array( "id" => "id", "group_id" => "group_id", "type_id" => "type_id", "format_id" => "format_id", "is_required" => "is_required", "is_visible" => "is_visible", "order_id" => "order_id" ) ); $n->setFieldNames( "ddb_field_format", array( "id" => "id", "regexp" => "regexp" ) ); $n->setFieldNames( "ddb_field_format_info", array( "format_id" => "format_id", "lang_id" => "lang_id", "name" => "name", "description" => "description" ) ); $n->setFieldNames( "ddb_field_group", array( "id" => "id", "table_id" => "table_id", "order_id" => "order_id" ) ); $n->setFieldNames( "ddb_field_group_name", array( "group_id" => "group_id", "lang_id" => "lang_id", "name" => "name" ) ); $n->setFieldNames( "ddb_field_listbox_item", array( "id" => "id", "field_id" => "field_id" ) ); $n->setFieldNames( "ddb_field_listbox_item_name", array( "item_id" => "item_id", "lang_id" => "lang_id", "name" => "name" ) ); $n->setFieldNames( "ddb_field_name", array( "field_id" => "field_id", "lang_id" => "lang_id", "name" => "name", "description" => "description" ) ); $n->setFieldNames( "ddb_field_type", array( "id" => "id", "alias" => "alias" ) ); $n->setFieldNames( "ddb_field_type_name", array( "type_id" => "type_id", "lang_id" => "lang_id", "name" => "name" ) ); $n->setFieldNames( "ddb_object", array( "id" => "id", "modify_user_id" => "modify_user_id", "modify_time" => "modify_time", "is_checked" => "is_checked", "begin_date" => "begin_date", "end_date" => "end_date", "table_id" => "table_id", "company_id" => "company_id", "contact_person" => "contact_person", "trademark" => "trademark", "settlement_id" => "settlement_id", "index" => "index", "address" => "address", "phone1" => "phone1", "phone2" => "phone2", "phone3" => "phone3", "fax" => "fax", "email" => "email", "url" => "url" ) ); $n->setFieldNames( "ddb_object_name", array( "object_id" => "object_id", "lang_id" => "lang_id", "name" => "name" ) ); $n->setFieldNames( "ddb_table", array( "id" => "id", "database_id" => "database_id", "is_visible" => "is_visible" ) ); $n->setFieldNames( "ddb_table_name", array( "table_id" => "table_id", "lang_id" => "lang_id", "name" => "name" ) ); // web tables $n->setFieldNames( "web_lang", array( "id" => "id", "name" => "name", "charset" => "charset" ) ); $n->setFieldNames( "web_translation", array( "id" => "id", "name" => "name" ) ); $n->setFieldNames( "web_translation_data", array( "translation_id" => "translation_id", "lang_id" => "lang_id", "value" => "value" ) ); $n->setFieldNames( "web_banner", array( "id" => "id", "file" => "file", "url" => "url", "impressions" => "impressions", "clicks" => "clicks", "lang_id" => "lang_id" ) ); $n->setFieldNames( "web_banner_slot", array( "id" => "id" ) ); $n->setFieldNames( "web_banner_slot_text", array( "slot_id" => "slot_id", "lang_id" => "lang_id", "title" => "title" ) ); $n->setFieldNames( "web_banner_text", array( "banner_id" => "banner_id", "lang_id" => "lang_id", "title" => "title" ) ); $n->setFieldNames( "web_menu_banner", array( "menu_id" => "menu_id", "slot_id" => "slot_id", "banner_id" => "banner_id" ) ); $n->setFieldNames( "web_menu_banner_slot", array( "menu_id" => "menu_id", "slot_id" => "slot_id", "count" => "count" ) ); $n->setFieldNames( "web_menu", array( "id" => "id", "alias" => "alias", "parent_id" => "parent_id", "lang_id" => "lang_id", "redirect_id" => "redirect_id", "action_id" => "web_module_action_id", "order_id" => "order_id", "is_visible" => "is_visible", "mode_id" => "web_menu_mode_id", "name" => "name", "body" => "body", "is_private" => "is_private" ) ); $n->setFieldNames( "web_menu_with_help", array( "id" => "id", "alias" => "alias", "parent_id" => "parent_id", "lang_id" => "lang_id", "redirect_id" => "redirect_id", "action_id" => "web_module_action_id", "order_id" => "order_id", "is_visible" => "is_visible", "mode_id" => "web_menu_mode_id", "name" => "name", "body" => "body", "help" => "help" ) ); $n->setFieldNames( "web_menu_mode", array( "id" => "id" ) ); $n->setFieldNames( "web_module", array( "id" => "id", "include" => "include", "class" => "class", "parameters" => "parameters", "is_active" => "is_active" ) ); $n->setFieldNames( "web_action", array( "id" => "id", "module_id" => "web_module_id", "alias" => "alias", "function" => "function", "parameters" => "parameters", "is_active" => "is_active" ) ); $n->setFieldNames( "web_menu_mode_name", array( "mode_id" => "web_menu_mode_id", "lang_id" => "lang_id", "name" => "name" ) ); $n->setFieldNames( "web_module_name", array( "module_id" => "web_module_id", "lang_id" => "lang_id", "name" => "name" ) ); $n->setFieldNames( "web_action_name", array( "action_id" => "web_module_action_id", "lang_id" => "lang_id", "name" => "name" ) ); $n->setFieldNames( "web_menu_multilang", array( "id" => "id", "parent_id" => "parent_id", "redirect_id" => "redirect_id", "action_id" => "web_module_action_id", "mode_id" => "web_menu_mode_id", "order_id" => "order_id", "is_visible" => "is_visible", "alias" => "alias" ) ); $n->setFieldNames( "web_menu_multilang_data", array( "menu_id" => "menu_multilang_id", "lang_id" => "lang_id", "name" => "name", "body" => "body" ) ); $n->setFieldNames( "web_article_file", array( "article_id" => "article_id", "file_id" => "file_id", "order_id" => "order_id" ) ); $n->setFieldNames( "web_article_item", array( "id" => "id", "group_id" => "group_id", "lang_id" => "lang_id", "name" => "name", "date" => "date", "intro" => "intro", "body" => "body" ) ); $n->setFieldNames( "web_article_group", array( "id" => "id" ) ); $n->setFieldNames( "web_article_group_name", array( "group_id" => "group_id", "lang_id" => "lang_id", "name" => "name" ) ); $n->setFieldNames( "web_file", array( "id" => "id", "type_id" => "type_id", "name" => "name", "size" => "size", "time" => "time", "date" => "date", "type_id2" => "type_id2", "lang_id" => "lang_id" ) ); $n->setFieldNames( "web_file_text", array( "file_id" => "file_id", "lang_id" => "lang_id", "title" => "title", "description" => "description" ) ); $n->setFieldNames( "web_file_type", array( "id" => "id", "group_id" => "group_id", "mime" => "mime", "extension" => "extension" ) ); $n->setFieldNames( "web_file_type_group", array( "id" => "id", "mime" => "mime" ) ); $n->setFieldNames( "web_file_type_group_text", array( "group_id" => "group_id", "lang_id" => "lang_id", "title" => "title" ) ); // area tables $n->setFieldNames( "area_region", array( "id" => "id", ) ); $n->setFieldNames( "area_region_name", array( "region_id" => "region_id", "lang_id" => "lang_id", "name" => "name" ) ); $n->setFieldNames( "area_county", array( "id" => "id", "region_id" => "region_id", "name" => "name" ) ); $n->setFieldNames( "area_settlement", array( "id" => "id", "county_id" => "county_id", "name" => "name" ) ); // product tables $n->setFieldNames( "prd_type", array( "id" => "id", "is_deleted" => "is_deleted" ) ); $n->setFieldNames( "prd_type_text", array( "type_id" => "type_id", "lang_id" => "lang_id", "title" => "title" ) ); $n->setFieldNames( "prd_group", array( "id" => "id", "parent_id" => "parent_id", "code" => "code", "image_filename" => "image_filename", "is_visible" => "is_visible" ) ); $n->setFieldNames( "prd_group_text", array( "group_id" => "group_id", "lang_id" => "lang_id", "title" => "title", "description" => "description" ) ); $n->setFieldNames( "prd_group_node", array( "product_id" => "product_id", "group_id" => "group_id" ) ); $n->setFieldNames( "prd_product", array( "id" => "id", "type_id" => "type_id", "code" => "code", "price" => "price", "in_pack" => "in_pack", "quantity" => "quantity", "create_time" => "create_time", "modify_time" => "modify_time", "delete_time" => "delete_time", "is_visible" => "is_visible" ) ); $n->setFieldNames( "prd_product_text", array( "product_id" => "product_id", "lang_id" => "lang_id", "title" => "title", "description" => "description" ) ); $n->setFieldNames( "prd_product_image", array( "id" => "id", "product_id" => "product_id", "file_name" => "file_name", "order_id" => "order_id" ) ); $n->setFieldNames( "prd_campaign", array( "id" => "id" ) ); $n->setFieldNames( "prd_campaign_text", array( "campaign_id" => "campaign_id", "lang_id" => "lang_id", "title" => "title" ) ); $n->setFieldNames( "prd_campaign_node", array( "product_id" => "product_id", "campaign_id" => "campaign_id" ) ); $n->setFieldNames( "prd_field", array( "id" => "id", "type_id" => "type_id", "is_multilang" => "is_multilang" ) ); $n->setFieldNames( "prd_field_text", array( "field_id" => "field_id", "lang_id" => "lang_id", "title" => "title" ) ); $n->setFieldNames( "prd_field_data", array( "field_id" => "field_id", "product_id" => "product_id", "lang_id" => "lang_id", "value" => "value" ) ); // Poll tables $n->setFieldNames( "poll_question", array( "id" => "id", "begin_date" => "begin_date", "end_date" => "end_date", "is_private" => "is_private" ) ); $n->setFieldNames( "poll_question_text", array( "question_id" => "question_id", "lang_id" => "lang_id", "title" => "title" ) ); $n->setFieldNames( "poll_answer", array( "id" => "id", "question_id" => "question_id", "hits" => "hits" ) ); $n->setFieldNames( "poll_answer_text", array( "answer_id" => "answer_id", "lang_id" => "lang_id", "title" => "title" ) ); // newsletter tables $n->setFieldNames( "newsletter_text", array( "newsletter_id" => "newsletter_id", "lang_id" => "lang_id", "title" => "title", "sisu" => "sisu" ) ); $n->setFieldNames( "newsletter_user", array( "id" => "id", "type" => "type", "epost" => "epost", "lang_id" => "lang_id" ) ); $n->setFieldNames( "newsletter_check", array( "newsletter_id" => "newsletter_id", "user_id" => "user_id" ) ); $n->setFieldNames( "newsletter_item", array( "id" => "id", "lisatud" => "lisatud" ) ); // sql tables $n->setFieldNames( "sql_view", array( "id" => "id", "handle" => "handle", "sql" => "sql" ) ); $n->setFieldNames( "sql_view_text", array( "view_id" => "view_id", "lang_id" => "lang_id", "title" => "title" ) ); $n->setFieldNames( "sql_view_from", array( "id" => "id", "view_id" => "view_id", "table_name" => "table_name", "handle" => "handle" ) ); $n->setFieldNames( "sql_view_select", array( "id" => "id", "view_id" => "view_id", "handle" => "handle", "statement" => "statement", "is_visible" => "is_visible", "html_attributes" => "html_attributes", "order_id" => "order_id" ) ); $n->setFieldNames( "sql_view_select_text", array( "select_id" => "select_id", "lang_id" => "lang_id", "title" => "title" ) ); $n->setFieldNames( "sql_view_select_user_conf", array( "select_id" => "select_id", "user_id" => "user_id", "filter" => "filter", "sort_order_id" => "sort_order_id", "sort_type" => "sort_type" ) ); $n->setFieldNames( "sql_view_user_conf", array( "view_id" => "view_id", "user_id" => "user_id", "sheet" => "sheet" ) ); // Contact tables $n->setFieldNames( "web_contact_department", array( "id" => "id", "nimetus" => "nimetus", "aadress" => "aadress", "telefon" => "telefon", "fax" => "fax", "pilt" => "pilt", "epost" => "epost", "www" => "www", "kommentaar" => "kommentaar" ) ); $n->setFieldNames( "web_contact_department_visible", array( "id" => "id", "nimetus" => "nimetus", "aadress" => "aadress", "telefon" => "telefon", "fax" => "fax", "pilt" => "pilt", "epost" => "epost", "www" => "www", "kommentaar" => "kommentaar" ) ); $n->setFieldNames( "web_contact_department_text", array( "department_id" => "department_id", "nimetus" => "nimetus", "kommentaar" => "kommentaar", "lang_id" => "lang_id" ) ); $n->setFieldNames( "web_contact_worker", array( "id" => "id", "department_id" => "department_id", "nimi" => "nimi", "ametinimetus" => "ametinimetus", "telefon" => "telefon", "sisetelefon" => "sisetelefon", "mobiil" => "mobiil", "lyhimobiil" => "lyhimobiil", "fax" => "fax", "pilt" => "pilt", "epost" => "epost", "kommentaar" => "kommentaar" ) ); $n->setFieldNames( "web_contact_worker_visible", array( "id" => "id", "department_id" => "department_id", "nimi" => "nimi", "telefon" => "telefon", "sisetelefon" => "sisetelefon", "mobiil" => "mobiil", "lyhimobiil" => "lyhimobiil", "fax" => "fax", "pilt" => "pilt", "epost" => "epost", "ametinimetus" => "ametinimetus", "kommentaar" => "kommentaar" ) ); $n->setFieldNames( "web_contact_worker_text", array( "worker_id" => "worker_id", "ametinimetus" => "ametinimetus", "kommentaar" => "kommentaar", "lang_id" => "lang_id" ) ); // web2 tables $n->setFieldNames( "web2_project", array( "id" => "id", "handle" => "handle", "theme_id" => "theme_id" ) ); $n->setFieldNames( "web2_template", array( "id" => "id", "handle" => "handle", "class" => "class", "include" => "include" ) ); $n->setFieldNames( "web2_theme", array( "id" => "id", "template_id" => "template_id", "handle" => "handle" ) ); $n->setFieldNames( "web2_var", array( "id" => "id", "template_id" => "template_id", "handle" => "handle" ) ); $n->setFieldNames( "web2_var_data", array( "var_id" => "var_id", "theme_id" => "theme_id", "value" => "value" ) ); $n->setFieldNames( "forum_topics", array( "id" => "id", "name" => "name", "email" => "email", "user" => "user", "email" => "email", "added" => "added" ) ); $n->setFieldNames( "form", array( "id" => "id", "is_active" => "is_active" ) ); $n->setFieldNames( "form_text", array( "form_id" => "form_id", "name" => "name", "description" => "description", "email" => "email", "lang_id" => "lang_id" ) ); $n->setFieldNames( "form_field", array( "id" => "id", "form_id" => "form_id", "type" => "type", "required" => "required" ) ); $n->setFieldNames( "form_field_text", array( "field_id" => "field_id", "name" => "name", "size" => "size", "lang_id" => "lang_id" ) ); $n->setFieldNames( "form_values", array( "form_id" => "form_id", "field_id" => "field_id", "answer_id" => "answer_id", "value" => "value", "lang_id" => "lang_id" ) ); return $n; } function setLibPath($paths) { $recurse_paths = $paths; foreach ($paths AS $path) { getSubDirs($path, $recurse_paths); } ini_set("include_path", ini_get("include_path") . ":" . implode(":", $recurse_paths)); } function getSubDirs($path, &$subs) { if (!is_readable($path) || !is_dir($path)) { trigger_error("{$path} is not readable directory", E_USER_ERROR); return; } $dir = dir($path); while ($entry = $dir->read()) { $entry_path = $path . $entry; if ($entry != "." && $entry != ".." && is_dir($entry_path)) { $subs[] = $entry_path . "/"; getSubDirs($entry_path . "/", $subs); } } $dir->close(); } ?>