/branch/vtigercrm-530-540-patch-original/install/CreateTables.inc.php
PHP | 1310 lines | 1052 code | 176 blank | 82 comment | 12 complexity | c0d7c1707642fb4dfb30c5e6308d531e MD5 | raw file
Possible License(s): LGPL-2.1, MPL-2.0-no-copyleft-exception, GPL-2.0, LGPL-3.0
Large files files are truncated, but you can click here to view the full file
- <?php
- /*+**********************************************************************************
- * The contents of this file are subject to the vtiger CRM Public License Version 1.0
- * ("License"); You may not use this file except in compliance with the License
- * The Original Code is: vtiger CRM Open Source
- * The Initial Developer of the Original Code is vtiger.
- * Portions created by vtiger are Copyright (C) vtiger.
- * All Rights Reserved.
- ************************************************************************************/
- $new_tables = 0;
- require_once('config.php');
- require_once('include/logging.php');
- require_once('modules/Leads/Leads.php');
- require_once('modules/Contacts/Contacts.php');
- require_once('modules/Accounts/Accounts.php');
- require_once('modules/Potentials/Potentials.php');
- require_once('modules/Calendar/Activity.php');
- require_once('modules/Documents/Documents.php');
- require_once('modules/Emails/Emails.php');
- require_once('modules/Users/Users.php');
- require_once('modules/Users/LoginHistory.php');
- require_once('data/Tracker.php');
- require_once('include/utils/utils.php');
- require_once('modules/Users/DefaultDataPopulator.php');
- require_once('modules/Users/CreateUserPrivilegeFile.php');
- // load the config_override.php file to provide default user settings
- if (is_file("config_override.php")) {
- require_once("config_override.php");
- }
- $adb = PearDatabase::getInstance();
- $log =& LoggerManager::getLogger('INSTALL');
- function create_default_users_access() {
- global $log, $adb;
- global $admin_email;
- global $admin_password;
- $role1_id = $adb->getUniqueID("vtiger_role");
- $role2_id = $adb->getUniqueID("vtiger_role");
- $role3_id = $adb->getUniqueID("vtiger_role");
- $role4_id = $adb->getUniqueID("vtiger_role");
- $role5_id = $adb->getUniqueID("vtiger_role");
- $profile1_id = $adb->getUniqueID("vtiger_profile");
- $profile2_id = $adb->getUniqueID("vtiger_profile");
- $profile3_id = $adb->getUniqueID("vtiger_profile");
- $profile4_id = $adb->getUniqueID("vtiger_profile");
- $adb->query("insert into vtiger_role values('H".$role1_id."','Organisation','H".$role1_id."',0)");
- $adb->query("insert into vtiger_role values('H".$role2_id."','CEO','H".$role1_id."::H".$role2_id."',1)");
- $adb->query("insert into vtiger_role values('H".$role3_id."','Vice President','H".$role1_id."::H".$role2_id."::H".$role3_id."',2)");
- $adb->query("insert into vtiger_role values('H".$role4_id."','Sales Manager','H".$role1_id."::H".$role2_id."::H".$role3_id."::H".$role4_id."',3)");
- $adb->query("insert into vtiger_role values('H".$role5_id."','Sales Man','H".$role1_id."::H".$role2_id."::H".$role3_id."::H".$role4_id."::H".$role5_id."',4)");
- //Insert into vtiger_role2profile
- $adb->query("insert into vtiger_role2profile values ('H".$role2_id."',".$profile1_id.")");
- $adb->query("insert into vtiger_role2profile values ('H".$role3_id."',".$profile2_id.")");
- $adb->query("insert into vtiger_role2profile values ('H".$role4_id."',".$profile2_id.")");
- $adb->query("insert into vtiger_role2profile values ('H".$role5_id."',".$profile2_id.")");
- //New Security Start
- //Inserting into vtiger_profile vtiger_table
- $adb->query("insert into vtiger_profile values ('".$profile1_id."','Administrator','Admin Profile')");
- $adb->query("insert into vtiger_profile values ('".$profile2_id."','Sales Profile','Profile Related to Sales')");
- $adb->query("insert into vtiger_profile values ('".$profile3_id."','Support Profile','Profile Related to Support')");
- $adb->query("insert into vtiger_profile values ('".$profile4_id."','Guest Profile','Guest Profile for Test Users')");
- //Inserting into vtiger_profile2gloabal permissions
- $adb->query("insert into vtiger_profile2globalpermissions values ('".$profile1_id."',1,0)");
- $adb->query("insert into vtiger_profile2globalpermissions values ('".$profile1_id."',2,0)");
- $adb->query("insert into vtiger_profile2globalpermissions values ('".$profile2_id."',1,1)");
- $adb->query("insert into vtiger_profile2globalpermissions values ('".$profile2_id."',2,1)");
- $adb->query("insert into vtiger_profile2globalpermissions values ('".$profile3_id."',1,1)");
- $adb->query("insert into vtiger_profile2globalpermissions values ('".$profile3_id."',2,1)");
- $adb->query("insert into vtiger_profile2globalpermissions values ('".$profile4_id."',1,1)");
- $adb->query("insert into vtiger_profile2globalpermissions values ('".$profile4_id."',2,1)");
- //Inserting into vtiger_profile2tab
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",1,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",2,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",3,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",4,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",6,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",7,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",8,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",9,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",10,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",13,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",14,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",15,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",16,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",18,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",19,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",20,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",21,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",22,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",23,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",24,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",25,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",26,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",27,0)");
- //Inserting into vtiger_profile2tab
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",1,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",2,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",3,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",4,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",6,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",7,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",8,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",9,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",10,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",13,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",14,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",15,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",16,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",18,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",19,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",20,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",21,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",22,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",23,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",24,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",25,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",26,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",27,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",1,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",2,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",3,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",4,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",6,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",7,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",8,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",9,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",10,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",13,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",14,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",15,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",16,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",18,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",19,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",20,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",21,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",22,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",23,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",24,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",25,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",26,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",27,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",1,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",2,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",3,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",4,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",6,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",7,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",8,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",9,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",10,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",13,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",14,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",15,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",16,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",18,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",19,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",20,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",21,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",22,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",23,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",24,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",25,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",26,0)");
- $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",27,0)");
- //Inserting into vtiger_profile2standardpermissions Adminsitrator
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",2,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",2,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",2,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",2,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",2,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",4,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",4,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",4,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",4,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",4,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",6,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",6,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",6,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",6,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",6,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",7,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",7,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",7,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",7,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",7,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",8,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",8,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",8,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",8,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",8,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",9,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",9,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",9,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",9,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",9,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",13,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",13,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",13,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",13,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",13,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",14,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",14,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",14,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",14,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",14,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",15,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",15,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",15,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",15,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",15,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",16,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",16,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",16,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",16,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",16,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",18,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",18,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",18,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",18,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",18,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",19,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",19,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",19,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",19,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",19,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",20,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",20,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",20,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",20,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",20,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",21,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",21,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",21,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",21,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",21,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",22,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",22,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",22,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",22,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",22,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",23,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",23,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",23,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",23,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",23,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",26,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",26,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",26,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",26,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",26,4,0)");
- //Insert into Profile 2 std permissions for Sales User
- //Help Desk Create/Delete not allowed. Read-Only
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",2,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",2,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",2,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",2,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",2,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",4,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",4,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",4,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",4,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",4,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",6,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",6,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",6,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",6,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",6,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",7,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",7,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",7,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",7,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",7,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",8,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",8,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",8,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",8,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",8,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",9,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",9,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",9,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",9,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",9,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",13,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",13,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",13,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",13,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",13,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",14,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",14,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",14,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",14,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",14,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",15,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",15,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",15,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",15,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",15,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",16,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",16,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",16,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",16,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",16,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",18,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",18,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",18,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",18,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",18,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",19,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",19,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",19,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",19,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",19,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",20,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",20,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",20,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",20,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",20,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",21,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",21,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",21,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",21,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",21,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",22,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",22,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",22,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",22,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",22,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",23,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",23,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",23,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",23,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",23,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",26,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",26,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",26,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",26,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",26,4,0)");
- //Inserting into vtiger_profile2std for Support Profile
- // Potential is read-only
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",2,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",2,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",2,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",2,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",2,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",4,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",4,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",4,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",4,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",4,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",6,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",6,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",6,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",6,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",6,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",7,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",7,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",7,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",7,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",7,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",8,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",8,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",8,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",8,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",8,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",9,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",9,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",9,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",9,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",9,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",13,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",13,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",13,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",13,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",13,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",14,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",14,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",14,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",14,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",14,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",15,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",15,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",15,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",15,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",15,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",16,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",16,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",16,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",16,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",16,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",18,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",18,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",18,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",18,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",18,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",19,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",19,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",19,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",19,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",19,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",20,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",20,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",20,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",20,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",20,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",21,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",21,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",21,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",21,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",21,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",22,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",22,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",22,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",22,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",22,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",23,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",23,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",23,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",23,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",23,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",26,0,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",26,1,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",26,2,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",26,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",26,4,0)");
- //Inserting into vtiger_profile2stdper for Profile Guest Profile
- //All Read-Only
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",2,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",2,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",2,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",2,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",2,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",4,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",4,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",4,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",4,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",4,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",6,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",6,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",6,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",6,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",6,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",7,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",7,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",7,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",7,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",7,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",8,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",8,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",8,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",8,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",8,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",9,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",9,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",9,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",9,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",9,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",13,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",13,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",13,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",13,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",13,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",14,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",14,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",14,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",14,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",14,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",15,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",15,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",15,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",15,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",15,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",16,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",16,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",16,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",16,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",16,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",18,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",18,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",18,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",18,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",18,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",19,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",19,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",19,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",19,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",19,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",20,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",20,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",20,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",20,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",20,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",21,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",21,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",21,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",21,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",21,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",22,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",22,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",22,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",22,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",22,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",23,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",23,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",23,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",23,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",23,4,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",26,0,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",26,1,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",26,2,1)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",26,3,0)");
- $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",26,4,0)");
- //Inserting into vtiger_profile 2 utility Admin
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",2,5,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",2,6,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",4,5,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",4,6,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",6,5,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",6,6,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",7,5,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",7,6,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",8,6,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",7,8,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",6,8,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",4,8,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",13,5,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",13,6,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",13,8,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",14,5,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",14,6,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",7,9,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",18,5,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",18,6,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",7,10,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",6,10,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",4,10,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",2,10,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",13,10,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",14,10,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",18,10,0)");
- //Inserting into vtiger_profile2utility Sales Profile
- //Import Export Not Allowed.
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",2,5,1)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",2,6,1)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",4,5,1)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",4,6,1)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",6,5,1)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",6,6,1)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",7,5,1)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",7,6,1)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",8,6,1)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",7,8,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",6,8,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",4,8,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",13,5,1)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",13,6,1)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",13,8,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",14,5,1)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",14,6,1)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",7,9,0)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",18,5,1)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",18,6,1)");
- $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",7,10,0)");
- …
Large files files are truncated, but you can click here to view the full file