PageRenderTime 34ms CodeModel.GetById 4ms RepoModel.GetById 0ms app.codeStats 1ms

/branch/vtigercrm-530-540-patch-original/install/CreateTables.inc.php

https://code.google.com/p/vtiger-ru-fork/
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

  1. <?php
  2. /*+**********************************************************************************
  3. * The contents of this file are subject to the vtiger CRM Public License Version 1.0
  4. * ("License"); You may not use this file except in compliance with the License
  5. * The Original Code is: vtiger CRM Open Source
  6. * The Initial Developer of the Original Code is vtiger.
  7. * Portions created by vtiger are Copyright (C) vtiger.
  8. * All Rights Reserved.
  9. ************************************************************************************/
  10. $new_tables = 0;
  11. require_once('config.php');
  12. require_once('include/logging.php');
  13. require_once('modules/Leads/Leads.php');
  14. require_once('modules/Contacts/Contacts.php');
  15. require_once('modules/Accounts/Accounts.php');
  16. require_once('modules/Potentials/Potentials.php');
  17. require_once('modules/Calendar/Activity.php');
  18. require_once('modules/Documents/Documents.php');
  19. require_once('modules/Emails/Emails.php');
  20. require_once('modules/Users/Users.php');
  21. require_once('modules/Users/LoginHistory.php');
  22. require_once('data/Tracker.php');
  23. require_once('include/utils/utils.php');
  24. require_once('modules/Users/DefaultDataPopulator.php');
  25. require_once('modules/Users/CreateUserPrivilegeFile.php');
  26. // load the config_override.php file to provide default user settings
  27. if (is_file("config_override.php")) {
  28. require_once("config_override.php");
  29. }
  30. $adb = PearDatabase::getInstance();
  31. $log =& LoggerManager::getLogger('INSTALL');
  32. function create_default_users_access() {
  33. global $log, $adb;
  34. global $admin_email;
  35. global $admin_password;
  36. $role1_id = $adb->getUniqueID("vtiger_role");
  37. $role2_id = $adb->getUniqueID("vtiger_role");
  38. $role3_id = $adb->getUniqueID("vtiger_role");
  39. $role4_id = $adb->getUniqueID("vtiger_role");
  40. $role5_id = $adb->getUniqueID("vtiger_role");
  41. $profile1_id = $adb->getUniqueID("vtiger_profile");
  42. $profile2_id = $adb->getUniqueID("vtiger_profile");
  43. $profile3_id = $adb->getUniqueID("vtiger_profile");
  44. $profile4_id = $adb->getUniqueID("vtiger_profile");
  45. $adb->query("insert into vtiger_role values('H".$role1_id."','Organisation','H".$role1_id."',0)");
  46. $adb->query("insert into vtiger_role values('H".$role2_id."','CEO','H".$role1_id."::H".$role2_id."',1)");
  47. $adb->query("insert into vtiger_role values('H".$role3_id."','Vice President','H".$role1_id."::H".$role2_id."::H".$role3_id."',2)");
  48. $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)");
  49. $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)");
  50. //Insert into vtiger_role2profile
  51. $adb->query("insert into vtiger_role2profile values ('H".$role2_id."',".$profile1_id.")");
  52. $adb->query("insert into vtiger_role2profile values ('H".$role3_id."',".$profile2_id.")");
  53. $adb->query("insert into vtiger_role2profile values ('H".$role4_id."',".$profile2_id.")");
  54. $adb->query("insert into vtiger_role2profile values ('H".$role5_id."',".$profile2_id.")");
  55. //New Security Start
  56. //Inserting into vtiger_profile vtiger_table
  57. $adb->query("insert into vtiger_profile values ('".$profile1_id."','Administrator','Admin Profile')");
  58. $adb->query("insert into vtiger_profile values ('".$profile2_id."','Sales Profile','Profile Related to Sales')");
  59. $adb->query("insert into vtiger_profile values ('".$profile3_id."','Support Profile','Profile Related to Support')");
  60. $adb->query("insert into vtiger_profile values ('".$profile4_id."','Guest Profile','Guest Profile for Test Users')");
  61. //Inserting into vtiger_profile2gloabal permissions
  62. $adb->query("insert into vtiger_profile2globalpermissions values ('".$profile1_id."',1,0)");
  63. $adb->query("insert into vtiger_profile2globalpermissions values ('".$profile1_id."',2,0)");
  64. $adb->query("insert into vtiger_profile2globalpermissions values ('".$profile2_id."',1,1)");
  65. $adb->query("insert into vtiger_profile2globalpermissions values ('".$profile2_id."',2,1)");
  66. $adb->query("insert into vtiger_profile2globalpermissions values ('".$profile3_id."',1,1)");
  67. $adb->query("insert into vtiger_profile2globalpermissions values ('".$profile3_id."',2,1)");
  68. $adb->query("insert into vtiger_profile2globalpermissions values ('".$profile4_id."',1,1)");
  69. $adb->query("insert into vtiger_profile2globalpermissions values ('".$profile4_id."',2,1)");
  70. //Inserting into vtiger_profile2tab
  71. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",1,0)");
  72. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",2,0)");
  73. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",3,0)");
  74. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",4,0)");
  75. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",6,0)");
  76. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",7,0)");
  77. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",8,0)");
  78. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",9,0)");
  79. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",10,0)");
  80. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",13,0)");
  81. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",14,0)");
  82. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",15,0)");
  83. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",16,0)");
  84. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",18,0)");
  85. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",19,0)");
  86. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",20,0)");
  87. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",21,0)");
  88. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",22,0)");
  89. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",23,0)");
  90. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",24,0)");
  91. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",25,0)");
  92. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",26,0)");
  93. $adb->query("insert into vtiger_profile2tab values (".$profile1_id.",27,0)");
  94. //Inserting into vtiger_profile2tab
  95. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",1,0)");
  96. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",2,0)");
  97. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",3,0)");
  98. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",4,0)");
  99. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",6,0)");
  100. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",7,0)");
  101. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",8,0)");
  102. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",9,0)");
  103. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",10,0)");
  104. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",13,0)");
  105. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",14,0)");
  106. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",15,0)");
  107. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",16,0)");
  108. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",18,0)");
  109. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",19,0)");
  110. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",20,0)");
  111. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",21,0)");
  112. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",22,0)");
  113. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",23,0)");
  114. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",24,0)");
  115. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",25,0)");
  116. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",26,0)");
  117. $adb->query("insert into vtiger_profile2tab values (".$profile2_id.",27,0)");
  118. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",1,0)");
  119. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",2,0)");
  120. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",3,0)");
  121. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",4,0)");
  122. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",6,0)");
  123. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",7,0)");
  124. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",8,0)");
  125. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",9,0)");
  126. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",10,0)");
  127. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",13,0)");
  128. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",14,0)");
  129. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",15,0)");
  130. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",16,0)");
  131. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",18,0)");
  132. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",19,0)");
  133. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",20,0)");
  134. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",21,0)");
  135. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",22,0)");
  136. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",23,0)");
  137. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",24,0)");
  138. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",25,0)");
  139. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",26,0)");
  140. $adb->query("insert into vtiger_profile2tab values (".$profile3_id.",27,0)");
  141. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",1,0)");
  142. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",2,0)");
  143. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",3,0)");
  144. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",4,0)");
  145. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",6,0)");
  146. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",7,0)");
  147. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",8,0)");
  148. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",9,0)");
  149. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",10,0)");
  150. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",13,0)");
  151. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",14,0)");
  152. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",15,0)");
  153. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",16,0)");
  154. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",18,0)");
  155. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",19,0)");
  156. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",20,0)");
  157. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",21,0)");
  158. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",22,0)");
  159. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",23,0)");
  160. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",24,0)");
  161. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",25,0)");
  162. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",26,0)");
  163. $adb->query("insert into vtiger_profile2tab values (".$profile4_id.",27,0)");
  164. //Inserting into vtiger_profile2standardpermissions Adminsitrator
  165. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",2,0,0)");
  166. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",2,1,0)");
  167. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",2,2,0)");
  168. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",2,3,0)");
  169. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",2,4,0)");
  170. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",4,0,0)");
  171. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",4,1,0)");
  172. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",4,2,0)");
  173. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",4,3,0)");
  174. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",4,4,0)");
  175. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",6,0,0)");
  176. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",6,1,0)");
  177. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",6,2,0)");
  178. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",6,3,0)");
  179. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",6,4,0)");
  180. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",7,0,0)");
  181. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",7,1,0)");
  182. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",7,2,0)");
  183. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",7,3,0)");
  184. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",7,4,0)");
  185. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",8,0,0)");
  186. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",8,1,0)");
  187. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",8,2,0)");
  188. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",8,3,0)");
  189. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",8,4,0)");
  190. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",9,0,0)");
  191. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",9,1,0)");
  192. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",9,2,0)");
  193. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",9,3,0)");
  194. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",9,4,0)");
  195. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",13,0,0)");
  196. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",13,1,0)");
  197. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",13,2,0)");
  198. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",13,3,0)");
  199. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",13,4,0)");
  200. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",14,0,0)");
  201. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",14,1,0)");
  202. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",14,2,0)");
  203. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",14,3,0)");
  204. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",14,4,0)");
  205. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",15,0,0)");
  206. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",15,1,0)");
  207. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",15,2,0)");
  208. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",15,3,0)");
  209. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",15,4,0)");
  210. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",16,0,0)");
  211. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",16,1,0)");
  212. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",16,2,0)");
  213. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",16,3,0)");
  214. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",16,4,0)");
  215. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",18,0,0)");
  216. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",18,1,0)");
  217. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",18,2,0)");
  218. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",18,3,0)");
  219. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",18,4,0)");
  220. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",19,0,0)");
  221. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",19,1,0)");
  222. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",19,2,0)");
  223. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",19,3,0)");
  224. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",19,4,0)");
  225. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",20,0,0)");
  226. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",20,1,0)");
  227. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",20,2,0)");
  228. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",20,3,0)");
  229. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",20,4,0)");
  230. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",21,0,0)");
  231. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",21,1,0)");
  232. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",21,2,0)");
  233. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",21,3,0)");
  234. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",21,4,0)");
  235. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",22,0,0)");
  236. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",22,1,0)");
  237. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",22,2,0)");
  238. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",22,3,0)");
  239. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",22,4,0)");
  240. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",23,0,0)");
  241. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",23,1,0)");
  242. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",23,2,0)");
  243. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",23,3,0)");
  244. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",23,4,0)");
  245. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",26,0,0)");
  246. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",26,1,0)");
  247. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",26,2,0)");
  248. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",26,3,0)");
  249. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile1_id.",26,4,0)");
  250. //Insert into Profile 2 std permissions for Sales User
  251. //Help Desk Create/Delete not allowed. Read-Only
  252. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",2,0,0)");
  253. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",2,1,0)");
  254. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",2,2,0)");
  255. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",2,3,0)");
  256. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",2,4,0)");
  257. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",4,0,0)");
  258. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",4,1,0)");
  259. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",4,2,0)");
  260. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",4,3,0)");
  261. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",4,4,0)");
  262. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",6,0,0)");
  263. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",6,1,0)");
  264. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",6,2,0)");
  265. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",6,3,0)");
  266. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",6,4,0)");
  267. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",7,0,0)");
  268. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",7,1,0)");
  269. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",7,2,0)");
  270. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",7,3,0)");
  271. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",7,4,0)");
  272. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",8,0,0)");
  273. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",8,1,0)");
  274. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",8,2,0)");
  275. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",8,3,0)");
  276. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",8,4,0)");
  277. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",9,0,0)");
  278. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",9,1,0)");
  279. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",9,2,0)");
  280. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",9,3,0)");
  281. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",9,4,0)");
  282. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",13,0,1)");
  283. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",13,1,1)");
  284. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",13,2,1)");
  285. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",13,3,0)");
  286. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",13,4,0)");
  287. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",14,0,0)");
  288. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",14,1,0)");
  289. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",14,2,0)");
  290. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",14,3,0)");
  291. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",14,4,0)");
  292. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",15,0,0)");
  293. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",15,1,0)");
  294. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",15,2,0)");
  295. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",15,3,0)");
  296. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",15,4,0)");
  297. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",16,0,0)");
  298. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",16,1,0)");
  299. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",16,2,0)");
  300. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",16,3,0)");
  301. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",16,4,0)");
  302. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",18,0,0)");
  303. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",18,1,0)");
  304. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",18,2,0)");
  305. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",18,3,0)");
  306. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",18,4,0)");
  307. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",19,0,0)");
  308. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",19,1,0)");
  309. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",19,2,0)");
  310. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",19,3,0)");
  311. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",19,4,0)");
  312. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",20,0,0)");
  313. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",20,1,0)");
  314. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",20,2,0)");
  315. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",20,3,0)");
  316. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",20,4,0)");
  317. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",21,0,0)");
  318. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",21,1,0)");
  319. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",21,2,0)");
  320. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",21,3,0)");
  321. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",21,4,0)");
  322. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",22,0,0)");
  323. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",22,1,0)");
  324. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",22,2,0)");
  325. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",22,3,0)");
  326. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",22,4,0)");
  327. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",23,0,0)");
  328. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",23,1,0)");
  329. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",23,2,0)");
  330. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",23,3,0)");
  331. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",23,4,0)");
  332. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",26,0,0)");
  333. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",26,1,0)");
  334. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",26,2,0)");
  335. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",26,3,0)");
  336. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile2_id.",26,4,0)");
  337. //Inserting into vtiger_profile2std for Support Profile
  338. // Potential is read-only
  339. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",2,0,1)");
  340. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",2,1,1)");
  341. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",2,2,1)");
  342. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",2,3,0)");
  343. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",2,4,0)");
  344. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",4,0,0)");
  345. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",4,1,0)");
  346. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",4,2,0)");
  347. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",4,3,0)");
  348. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",4,4,0)");
  349. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",6,0,0)");
  350. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",6,1,0)");
  351. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",6,2,0)");
  352. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",6,3,0)");
  353. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",6,4,0)");
  354. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",7,0,0)");
  355. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",7,1,0)");
  356. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",7,2,0)");
  357. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",7,3,0)");
  358. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",7,4,0)");
  359. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",8,0,0)");
  360. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",8,1,0)");
  361. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",8,2,0)");
  362. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",8,3,0)");
  363. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",8,4,0)");
  364. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",9,0,0)");
  365. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",9,1,0)");
  366. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",9,2,0)");
  367. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",9,3,0)");
  368. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",9,4,0)");
  369. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",13,0,0)");
  370. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",13,1,0)");
  371. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",13,2,0)");
  372. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",13,3,0)");
  373. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",13,4,0)");
  374. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",14,0,0)");
  375. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",14,1,0)");
  376. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",14,2,0)");
  377. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",14,3,0)");
  378. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",14,4,0)");
  379. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",15,0,0)");
  380. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",15,1,0)");
  381. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",15,2,0)");
  382. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",15,3,0)");
  383. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",15,4,0)");
  384. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",16,0,0)");
  385. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",16,1,0)");
  386. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",16,2,0)");
  387. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",16,3,0)");
  388. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",16,4,0)");
  389. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",18,0,0)");
  390. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",18,1,0)");
  391. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",18,2,0)");
  392. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",18,3,0)");
  393. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",18,4,0)");
  394. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",19,0,0)");
  395. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",19,1,0)");
  396. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",19,2,0)");
  397. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",19,3,0)");
  398. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",19,4,0)");
  399. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",20,0,0)");
  400. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",20,1,0)");
  401. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",20,2,0)");
  402. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",20,3,0)");
  403. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",20,4,0)");
  404. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",21,0,0)");
  405. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",21,1,0)");
  406. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",21,2,0)");
  407. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",21,3,0)");
  408. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",21,4,0)");
  409. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",22,0,0)");
  410. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",22,1,0)");
  411. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",22,2,0)");
  412. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",22,3,0)");
  413. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",22,4,0)");
  414. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",23,0,0)");
  415. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",23,1,0)");
  416. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",23,2,0)");
  417. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",23,3,0)");
  418. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",23,4,0)");
  419. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",26,0,0)");
  420. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",26,1,0)");
  421. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",26,2,0)");
  422. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",26,3,0)");
  423. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile3_id.",26,4,0)");
  424. //Inserting into vtiger_profile2stdper for Profile Guest Profile
  425. //All Read-Only
  426. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",2,0,1)");
  427. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",2,1,1)");
  428. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",2,2,1)");
  429. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",2,3,0)");
  430. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",2,4,0)");
  431. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",4,0,1)");
  432. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",4,1,1)");
  433. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",4,2,1)");
  434. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",4,3,0)");
  435. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",4,4,0)");
  436. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",6,0,1)");
  437. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",6,1,1)");
  438. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",6,2,1)");
  439. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",6,3,0)");
  440. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",6,4,0)");
  441. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",7,0,1)");
  442. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",7,1,1)");
  443. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",7,2,1)");
  444. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",7,3,0)");
  445. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",7,4,0)");
  446. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",8,0,1)");
  447. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",8,1,1)");
  448. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",8,2,1)");
  449. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",8,3,0)");
  450. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",8,4,0)");
  451. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",9,0,1)");
  452. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",9,1,1)");
  453. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",9,2,1)");
  454. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",9,3,0)");
  455. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",9,4,0)");
  456. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",13,0,1)");
  457. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",13,1,1)");
  458. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",13,2,1)");
  459. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",13,3,0)");
  460. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",13,4,0)");
  461. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",14,0,1)");
  462. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",14,1,1)");
  463. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",14,2,1)");
  464. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",14,3,0)");
  465. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",14,4,0)");
  466. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",15,0,1)");
  467. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",15,1,1)");
  468. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",15,2,1)");
  469. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",15,3,0)");
  470. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",15,4,0)");
  471. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",16,0,1)");
  472. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",16,1,1)");
  473. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",16,2,1)");
  474. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",16,3,0)");
  475. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",16,4,0)");
  476. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",18,0,1)");
  477. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",18,1,1)");
  478. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",18,2,1)");
  479. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",18,3,0)");
  480. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",18,4,0)");
  481. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",19,0,1)");
  482. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",19,1,1)");
  483. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",19,2,1)");
  484. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",19,3,0)");
  485. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",19,4,0)");
  486. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",20,0,1)");
  487. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",20,1,1)");
  488. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",20,2,1)");
  489. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",20,3,0)");
  490. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",20,4,0)");
  491. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",21,0,1)");
  492. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",21,1,1)");
  493. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",21,2,1)");
  494. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",21,3,0)");
  495. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",21,4,0)");
  496. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",22,0,1)");
  497. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",22,1,1)");
  498. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",22,2,1)");
  499. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",22,3,0)");
  500. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",22,4,0)");
  501. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",23,0,1)");
  502. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",23,1,1)");
  503. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",23,2,1)");
  504. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",23,3,0)");
  505. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",23,4,0)");
  506. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",26,0,1)");
  507. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",26,1,1)");
  508. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",26,2,1)");
  509. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",26,3,0)");
  510. $adb->query("insert into vtiger_profile2standardpermissions values (".$profile4_id.",26,4,0)");
  511. //Inserting into vtiger_profile 2 utility Admin
  512. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",2,5,0)");
  513. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",2,6,0)");
  514. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",4,5,0)");
  515. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",4,6,0)");
  516. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",6,5,0)");
  517. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",6,6,0)");
  518. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",7,5,0)");
  519. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",7,6,0)");
  520. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",8,6,0)");
  521. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",7,8,0)");
  522. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",6,8,0)");
  523. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",4,8,0)");
  524. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",13,5,0)");
  525. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",13,6,0)");
  526. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",13,8,0)");
  527. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",14,5,0)");
  528. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",14,6,0)");
  529. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",7,9,0)");
  530. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",18,5,0)");
  531. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",18,6,0)");
  532. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",7,10,0)");
  533. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",6,10,0)");
  534. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",4,10,0)");
  535. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",2,10,0)");
  536. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",13,10,0)");
  537. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",14,10,0)");
  538. $adb->query("insert into vtiger_profile2utility values (".$profile1_id.",18,10,0)");
  539. //Inserting into vtiger_profile2utility Sales Profile
  540. //Import Export Not Allowed.
  541. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",2,5,1)");
  542. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",2,6,1)");
  543. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",4,5,1)");
  544. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",4,6,1)");
  545. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",6,5,1)");
  546. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",6,6,1)");
  547. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",7,5,1)");
  548. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",7,6,1)");
  549. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",8,6,1)");
  550. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",7,8,0)");
  551. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",6,8,0)");
  552. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",4,8,0)");
  553. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",13,5,1)");
  554. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",13,6,1)");
  555. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",13,8,0)");
  556. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",14,5,1)");
  557. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",14,6,1)");
  558. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",7,9,0)");
  559. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",18,5,1)");
  560. $adb->query("insert into vtiger_profile2utility values (".$profile2_id.",18,6,1)");
  561. $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