PageRenderTime 61ms CodeModel.GetById 20ms RepoModel.GetById 1ms app.codeStats 0ms

/src/site/administrator/components/com_chronocontact/admin.chronocontact.php

https://bitbucket.org/manchas/jrobotz
PHP | 2787 lines | 2643 code | 49 blank | 95 comment | 144 complexity | 52ca23979c2c0b4ebe3cec059832eadb MD5 | raw file
Possible License(s): BSD-3-Clause, LGPL-2.1, GPL-2.0, Apache-2.0

Large files files are truncated, but you can click here to view the full file

    

  1. <?php
    2. 

  2. /*
    3. 

  3. /**
    4. 

  4. * CHRONOFORMS version 3.0 
    5. 

  5. * Copyright (c) 2008 Chrono_Man, ChronoEngine.com. All rights reserved.
    6. 

  6. * Author: Chrono_Man (ChronoEngine.com)
    7. 

  7. * See readme.html.
    8. 

  8. * @license		GNU/GPL
    9. 

  9. * Visit http://www.ChronoEngine.com for regular update and information.
    10. 

  10. **/
    11. 

  11. 

  12. /* ensure that this file is not called from another file */
    13. 

  13. defined('_JEXEC') or die('Restricted access'); 
    14. 

  14. 

  15. //global $mosConfig_lang, $mosConfig_absolute_path, $chronocontact_params;
    16. 

  16. // Loading of the database class and the HTML class
    17. 

  17. require_once( JApplicationHelper::getPath( 'admin_html' ) ); 
    18. 

  18. require_once( JApplicationHelper::getPath( 'class' ) );
    19. 

  19. 

  20. $id 	= JRequest::getVar( 'id', '', 'get', 'int', 0 );
    21. 

  21. //$task 	= JRequest::getVar( 'task', '', 'post', 'string', '' );
    22. 

  22. $cid 	= JRequest::getVar( 'cid', array(), 'post', 'array');
    23. 

  23. if (!is_array( $cid )) {
    24. 

  24. 	$cid = array(0);
    25. 

  25. }
    26. 

  26. $cid_del 	= JRequest::getVar( 'cid_del', array(), 'post', 'array');
    27. 

  27. if (!is_array( $cid_del )) {
    28. 

  28. 	$cid_del = array(0);
    29. 

  29. }
    30. 

  30. ?>
    31. 

  31. <?php echo JHTML::_('behavior.tooltip'); ?>
    32. 

  32. <?php
    33. 

  33. 

  34. // case differentiation
    35. 

  35. switch ($task) {
    36. 

  36. 	case "ajax":
    37. 

  37. 		ajaxfields();
    38. 

  38. 		break;
    39. 

  39. 	case "adminview":
    40. 

  40. 		showadminformChronoContact( '', $cid[0], $option );
    41. 

  41. 		break;
    42. 

  42. 	case "submitadminform":
    43. 

  43. 		submitadminformChronoContact( $option );
    44. 

  44. 		break;
    45. 

  45. 	case "editdata":
    46. 

  46. 		showadminformChronoContact( $cid[0], '', $option );
    47. 

  47. 		break;
    48. 

  48. 	case "transform":
    49. 

  49. 		transformChronoContact( $cid[0], $option );
    50. 

  50. 		break;
    51. 

  51. 	case "savetransform":
    52. 

  52. 		savetransformChronoContact( $option );
    53. 

  53. 		break;
    54. 

  54. 	case "previewajax":
    55. 

  55. 		previewajaxChronoContact( $option );
    56. 

  56. 		break;
    57. 

  57. 	case 'doupgrade':
    58. 

  58. 		doupgrade($option);
    59. 

  59. 		break;
    60. 

  60. 	case 'validatelicense':
    61. 

  61. 		validatelicense($option);
    62. 

  62. 		break;
    63. 

  63. 	case 'validatelicenseframe':
    64. 

  64. 		validatelicenseframe($option);
    65. 

  65. 		break;
    66. 

  66. 	case 'validatelicensedata':
    67. 

  67. 		validatelicensedata();
    68. 

  68. 		break;
    69. 

  69. 	/////////////////////
    70. 

  70. 	case "publish":
    71. 

  71. 		publishChronoContact( $cid, 1, $option );
    72. 

  72. 		break;
    73. 

  73. 	case "unpublish":
    74. 

  74. 		publishChronoContact( $cid, 0, $option );
    75. 

  75. 		break;
    76. 

  76. 	case "add":
    77. 

  77. 		editChronoContact( 0, $option );
    78. 

  78. 		break;
    79. 

  79. 	case "edit":
    80. 

  80. 		editChronoContact( $cid[0], $option );
    81. 

  81. 		break;
    82. 

  82. 	case "applychanges":
    83. 

  83. 		saveChronoContact( $option, $task );
    84. 

  84. 		//editChronoContact( $_POST['id'], $option );
    85. 

  85. 		break;
    86. 

  86. 	case "remove":
    87. 

  87. 		removeChronoContact( $cid, $option );
    88. 

  88. 		break;
    89. 

  89. 	case "save":
    90. 

  90. 		saveChronoContact( $option, $task );
    91. 

  91. 		break;
    92. 

  92. 	case "copy":
    93. 

  93. 		copyChronoContact( $cid[0], $option );
    94. 

  94. 		break;
    95. 

  95. 	case "cancel":
    96. 

  96. 		cancelChronoContact( $option );
    97. 

  97. 		break;
    98. 

  98. 	case "addmenuitem":
    99. 

  99. 		addmenuitem( $option );
    100. 

  100. 		break;
    101. 

  101. 	////////
    102. 

  102. 	case "cancelview":
    103. 

  103. 		showdataChronoContact( 0, $option );
    104. 

  104. 		break;
    105. 

  105. 	case "show":
    106. 

  106. 		$showid = (count($cid) == 0) ? 0 : $cid[0];
    107. 

  107. 		showdataChronoContact( $showid, $option );
    108. 

  108. 		break;
    109. 

  109. 	case "viewdata":
    110. 

  110. 		viewdataChronoContact( $cid[0], $option );
    111. 

  111. 		break;
    112. 

  112. 	case "createtable":	
    113. 

  113. 		maketableChronoContact( $cid[0], $option );
    114. 

  114. 		break;
    115. 

  115. 	case "edittable":
    116. 

  116. 		maketableChronoContact( 0, $option );
    117. 

  117. 		break;
    118. 

  118. 	case "tablemanager":
    119. 

  119. 		tablemanagerChronoContact( $option );
    120. 

  120. 		break;
    121. 

  121. 	case "updatetablelist":
    122. 

  122. 		updatetablelistChronoContact( $option );
    123. 

  123. 		break;
    124. 

  124. 	case "deletetable":
    125. 

  125. 		deletetableChronoContact( $cid[0], $option);
    126. 

  126. 		break;
    127. 

  127. 	case "finalizetable":
    128. 

  128. 		finalizetableChronoContact( $option );
    129. 

  129. 		break;
    130. 

  130. 	case "deleterecord":
    131. 

  131. 		deleterecordChronoContact( $cid, $option );
    132. 

  132. 		break;
    133. 

  133. 	////// backup
    134. 

  134. 	case "backup":
    135. 

  135. 	case "backupall":
    136. 

  136. 		backupChronoContact( $cid[0], $option, $task );
    137. 

  137. 		break;
    138. 

  138. 	case "restore1":
    139. 

  139. 		restore1ChronoContact( 0, $option );
    140. 

  140. 		break;
    141. 

  141. 	case "restore2":
    142. 

  142. 		restore2ChronoContact( 0, $option );
    143. 

  143. 		break;
    144. 

  144. 	case "backexcel":
    145. 

  145. 		BackupExcel( $id, $option );
    146. 

  146. 		break;
    147. 

  147. 	case "backcsv":
    148. 

  148. 		BackupCSV( $id, $option );
    149. 

  149. 		break;
    150. 

  150. 	////// config
    151. 

  151. 	case 'config':
    152. 

  152. 		showConfig( $option );
    153. 

  153. 		break;
    154. 

  154. 	case 'saveconfig':
    155. 

  155. 		saveSettings( $option );
    156. 

  156. 		break;
    157. 

  157. 	case 'cancelconfig':
    158. 

  158. 		cancelSettings( $option );
    159. 

  159. 		break;
    160. 

  160. 	case 'save_conf':
    161. 

  161. 		save_conf( $option );
    162. 

  162. 		break;
    163. 

  163. 	////// wizard
    164. 

  164. 	case 'form_wizard':
    165. 

  165. 		form_wizard( '', $option );
    166. 

  166. 		break;
    167. 

  167. 	case 'wizardedit':
    168. 

  168. 		form_wizard( $cid[0], $option );
    169. 

  169. 		break;
    170. 

  170. 	case 'wizard_elements':
    171. 

  171. 		wizard_elements( $option );
    172. 

  172. 		break;
    173. 

  173. 	case 'save_form_wizard':
    174. 

  174. 		save_form_wizard( $option );
    175. 

  175. 		break;
    176. 

  176. 	case 'editelement':
    177. 

  177. 		editElement( $cid[0], $option );
    178. 

  178. 		break;
    179. 

  179. 	case 'newelement':
    180. 

  180. 		editElement( 0, $option );
    181. 

  181. 		break;
    182. 

  182. 	case 'saveelement':
    183. 

  183. 	case 'applyelement':
    184. 

  184. 		saveElement( $task, $option );
    185. 

  185. 		break;
    186. 

  186. 	case 'cancelelement':
    187. 

  187. 		cancelElement( $option );
    188. 

  188. 		break;
    189. 

  189. 	case 'deleteelement':
    190. 

  190. 		deleteElement( $cid, $option );
    191. 

  191. 		break;
    192. 

  192. 	///// menu tools
    193. 

  193. 	case 'menu_creator':
    194. 

  194. 		menu_creator( $option );
    195. 

  195. 		break;
    196. 

  196. 	case 'menu_remover':
    197. 

  197. 		menu_remover( $option );
    198. 

  198. 		break;
    199. 

  199. 	case 'menu_save':
    200. 

  200. 		menu_save( $option );
    201. 

  201. 		break;
    202. 

  202. 	case 'menu_delete':
    203. 

  203. 		menu_delete( $cid, $option );
    204. 

  204. 		break;
    205. 

  205. 	///////////////
    206. 

  206. 	default: 
    207. 

  207. 		global $mainframe;
    208. 

  208. 		$database =& JFactory::getDBO();
    209. 

  209. 		$switch = 1;
    210. 

  210. 		if(strpos("x".$task,"plugin_")){
    211. 

  211. 			$directory = JPATH_SITE.'/components/com_chronocontact/plugins/';
    212. 

  212. 			$results = array();
    213. 

  213. 			$handler = opendir($directory);
    214. 

  214. 			while ($file = readdir($handler)) {
    215. 

  215. 				if ( $file != '.' && $file != '..' && substr($file, -4) == '.php' && substr($file, 0, 3) == 'cf_')
    216. 

  216. 					$results[] = str_replace(".php","", $file);
    217. 

  217. 			}
    218. 

  218. 			closedir($handler);
    219. 

  219. 			foreach($results as $result){
    220. 

  220. 				if($task == 'plugin_'.$result){
    221. 

  221. 					require_once(JPATH_SITE."/components/com_chronocontact/plugins/".$result.".php");
    222. 

  222. 					${$result} = new $result();
    223. 

  223. 					$switch = 0;
    224. 

  224. 					
    225. 

  225. 					$database->setQuery( "SELECT id FROM #__chrono_contact_plugins WHERE form_id='".$cid[0]."' AND name='".$result."'" );
    226. 

  226. 					$id = $database->loadResult();
    227. 

  227. 					$row =& JTable::getInstance('chronocontactplugins', 'Table');
    228. 

  228. 					$row->load( $id );
    229. 

  229. 					${$result}->show_conf($row, $id, $cid[0], $option);
    230. 

  230. 					break;
    231. 

  231. 				}
    232. 

  232. 			}
    233. 

  233. 		}
    234. 

  234. 		//echo 'xxx'.$cf_joomla_registration->result_TITLE;
    235. 

  235. 		if($switch == 1){
    236. 

  236. 			showChronoContact( $option );
    237. 

  237. 		}
    238. 

  238. 		break;
    239. 

  239. }
    240. 

  240. 

  241. function save_conf( $option ){
    242. 

  242. 	$plugin = JRequest::getVar('name');
    243. 

  243. 	require_once(JPATH_SITE."/components/com_chronocontact/plugins/".$plugin.".php");
    244. 

  244. 	${$plugin} = new $plugin();
    245. 

  245. 	${$plugin}->save_conf($option);
    246. 

  246. }
    247. 

  247. function ajaxfields(){
    248. 

  248. 	global $mainframe;
    249. 

  249. 	$database =& JFactory::getDBO();
    250. 

  250. 	$plugin = JRequest::getVar('plugin');
    251. 

  251. 	$method = JRequest::getVar('method');
    252. 

  252. 	require_once(JPATH_SITE."/components".DS."com_chronocontact".DS."plugins".DS.$plugin.".php");
    253. 

  253. 	${$plugin} = new $plugin();
    254. 

  254. 	${$plugin}->{$method}();
    255. 

  255. }
    256. 

  256. function doupgrade($option){
    257. 

  257. 	global $mainframe;
    258. 

  258. 	$database =& JFactory::getDBO();
    259. 

  259. 	$sql = "ALTER TABLE #__chrono_contact ADD `extravalrules` LONGTEXT NOT NULL AFTER `titlesall`";
    260. 

  260. 	$database->setQuery($sql);
    261. 

  261. 	if (!$database->query()) {
    262. 

  262. 		echo $database->getErrorMsg();
    263. 

  263. 	}
    264. 

  264. 	$sql = "ALTER TABLE #__chrono_contact ADD `stylecode` LONGTEXT NOT NULL AFTER `scriptcode`";
    265. 

  265. 	$database->setQuery($sql);
    266. 

  266. 	if (!$database->query()) {
    267. 

  267. 		echo $database->getErrorMsg();
    268. 

  268. 	}
    269. 

  269. 	$sql = "ALTER TABLE #__chrono_contact ADD `chronocode` LONGTEXT NOT NULL AFTER `autogenerated`";
    270. 

  270. 	$database->setQuery($sql);
    271. 

  271. 	if (!$database->query()) {
    272. 

  272. 		echo $database->getErrorMsg();
    273. 

  273. 	}
    274. 

  274. 	$sql = "ALTER TABLE #__chrono_contact ADD `theme` TEXT NOT NULL AFTER `chronocode`";
    275. 

  275. 	$database->setQuery($sql);
    276. 

  276. 	if (!$database->query()) {
    277. 

  277. 		echo $database->getErrorMsg();
    278. 

  278. 	}
    279. 

  279. 	$sql = "ALTER TABLE #__chrono_contact_emails
    280. 

  280. ADD COLUMN `replytoname` TEXT AFTER `dfromemail`,
    281. 

  281. ADD COLUMN `dreplytoname` TEXT AFTER `replytoname`,
    282. 

  282. ADD COLUMN `replytoemail` TEXT AFTER `dreplytoname`,
    283. 

  283. ADD COLUMN `dreplytoemail` TEXT AFTER `replytoemail`;";
    284. 

  284. 	$database->setQuery($sql);
    285. 

  285. 	if (!$database->query()) {
    286. 

  286. 		echo $database->getErrorMsg();
    287. 

  287. 	}
    288. 

  288. 	$sql = "ALTER TABLE #__chrono_contact_elements
    289. 

  289. ADD COLUMN `title` VARCHAR(255) AFTER `id`,
    290. 

  290. ADD COLUMN `params` LONGTEXT AFTER `code`;";
    291. 

  291. 	$database->setQuery($sql);
    292. 

  292. 	if (!$database->query()) {
    293. 

  293. 		echo $database->getErrorMsg();
    294. 

  294. 	}
    295. 

  295. 	
    296. 

  296. 	// Load Demo form
    297. 

  297. 	$option = 'com_chronocontact';
    298. 

  298. 	$filename = 'basicDemo.cfbak';
    299. 

  299. 	$path = JPATH_SITE.DS.'components'.DS.'com_chronocontact'.DS.'uploads';
    300. 

  300. 	$data = file_get_contents( $path.DS.$filename );					
    301. 

  301. 	$data = str_replace( '&amp;', '&', $data );
    302. 

  302. 	$values = '(';
    303. 

  303. 	$values2 = '(';
    304. 

  304. 	
    305. 

  305. 	preg_match_all('/\<++(.*?)\<endendend>/s', $data, $matches);
    306. 

  306. 	$i = 0;
    307. 

  307. 	foreach ( $matches[0] as $match ) {
    308. 

  308. 		if($i != 0){
    309. 

  309. 			$values .= ',';
    310. 

  310. 			$values2 .= ',';
    311. 

  311. 		}
    312. 

  312. 		preg_match_all('/\<++(.*?)\++>/s', $match, $match2es);
    313. 

  313. 		$fieldvalue = str_replace($match2es[0][0],'',$match);
    314. 

  314. 		$match2es[0][0] = str_replace('<++-++-++','',$match2es[0][0]);
    315. 

  315. 		$match2es[0][0] = str_replace('++-++-++>','',$match2es[0][0]);
    316. 

  316. 		$values .= $match2es[0][0];
    317. 

  317. 		if($i == 0){
    318. 

  318. 			$values2 .= "''";
    319. 

  319. 		}else{
    320. 

  320. 			$match = str_replace('<++-++-++'.$match2es[0][0].'++-++-++>','',$match);
    321. 

  321. 			$match = str_replace('<endendend>','',$match);
    322. 

  322. 			$match = trim($match," \t.");
    323. 

  323. 			$values2 .= "'".addslashes($match)."'";
    324. 

  324. 		}
    325. 

  325. 		$i++;
    326. 

  326. 	}
    327. 

  327. 	$values .= ')';
    328. 

  328. 	$values2 .= ')';
    329. 

  329. 	$database->setQuery( "INSERT INTO #__chrono_contact ".$values." VALUES ".$values2 );
    330. 

  330. 	if (!$database->query()) {
    331. 

  331. 		JError::raiseWarning(100, "Restoring the whole form failed Failed, error : ".$database->getErrorMsg());
    332. 

  332. 		//$mainframe->redirect( "index2.php?option=$option" );
    333. 

  333. 	}else{
    334. 

  334. 		//$mainframe->redirect( 'index2.php?option='.$option , "Restored successfully");
    335. 

  335. 	}
    336. 

  336. 	$lastformid = $database->insertid();
    337. 

  337. 	
    338. 

  338. 	// Restore Emails
    339. 

  339. 	$values = '(`';
    340. 

  340. 	$values2 = '(';
    341. 

  341. 	$emails_data = array();
    342. 

  342. 	$emails_count = explode('<cf_email_separator>', $data);
    343. 

  343. 	$fields_count_1 = explode('{cfbak_start_emails}', $emails_count[0]);
    344. 

  344. 	$fields_count_2 = explode('<endendend2>', $fields_count_1[1]);
    345. 

  345. 	preg_match_all('/\<2++(.*?)\<endendend2>/s', $data, $matches);
    346. 

  346. 	$i = 0;
    347. 

  347. 	$i_v = 0;
    348. 

  348. 	$counter = 0;
    349. 

  349. 	foreach ( $matches[0] as $match ) {
    350. 

  350. 		preg_match_all('/\<2++(.*?)\++>/s', $match, $match2es);
    351. 

  351. 		$fieldvalue = str_replace($match2es[0][0],'',$match);
    352. 

  352. 		$match2es[0][0] = str_replace('<2++-++-++','',$match2es[0][0]);
    353. 

  353. 		$match2es[0][0] = str_replace('++-++-++>','',$match2es[0][0]);
    354. 

  354. 		if($i_v < (count($fields_count_2) - 1)){
    355. 

  355. 			if($i_v != 0){$values .= '`,`';}
    356. 

  356. 			$values .= $match2es[0][0];
    357. 

  357. 		}
    358. 

  358. 		if($i != 0){$values2 .= ',';}
    359. 

  359. 		if($i == 0){
    360. 

  360. 			$values2 .= "''";
    361. 

  361. 		}else if($i == 1){
    362. 

  362. 			$values2 .= "'".$lastformid."'";
    363. 

  363. 		}else{
    364. 

  364. 			$match = str_replace('<2++-++-++'.$match2es[0][0].'++-++-++>','',$match);
    365. 

  365. 			$match = str_replace('<endendend2>','',$match);
    366. 

  366. 			$match = trim($match," \t.");
    367. 

  367. 			$values2 .= "'".addslashes($match)."'";
    368. 

  368. 		}
    369. 

  369. 		$counter++;
    370. 

  370. 		$i++;
    371. 

  371. 		$i_v++;
    372. 

  372. 		
    373. 

  373. 		if($counter == (count($fields_count_2) - 1)){
    374. 

  374. 			$values2 .= ')';
    375. 

  375. 			$emails_data[] = $values2;
    376. 

  376. 			$values2 = '(';
    377. 

  377. 			$counter = 0;
    378. 

  378. 			$i = 0;
    379. 

  379. 		}
    380. 

  380. 	}
    381. 

  381. 	$values .= '`)';
    382. 

  382. 	foreach($emails_data as $email_data){
    383. 

  383. 		$database->setQuery( "INSERT INTO #__chrono_contact_emails ".$values." VALUES ".$email_data );
    384. 

  384. 		if (!$database->query()) {
    385. 

  385. 			JError::raiseWarning(100, "Restoring Emails Setup Failed, error : ".$database->getErrorMsg());
    386. 

  386. 			//$mainframe->redirect( "index2.php?option=$option" );
    387. 

  387. 		}else{
    388. 

  388. 			//$mainframe->redirect( 'index2.php?option='.$option , "Restored successfully");
    389. 

  389. 		}
    390. 

  390. 	}
    391. 

  391. 	//$mainframe->redirect( 'index2.php?option='.$option , "Demo form loaded successfully");
    392. 

  392. 	
    393. 

  393. 	$mainframe->redirect( "index2.php?option=$option", 'Upgrade went successfully' );
    394. 

  394. }
    395. 

  395. function validatelicense($option){
    396. 

  396. 	HTML_ChronoContact::validatelicensepage( $option );
    397. 

  397. }
    398. 

  398. function validatelicenseframe($option){
    399. 

  399. 	//HTML_ChronoContact::validatelicenseframe( $option );
    400. 

  400. }
    401. 

  401. function validatelicensedata(){
    402. 

  402. 	global $mainframe;
    403. 

  403. 	preg_match('/http(s)*:\/\/(.*?)\//i', $mainframe->getSiteURL(), $matches);
    404. 

  404. 	$database =& JFactory::getDBO();
    405. 

  405. 	$query     = "SELECT * FROM `#__components` WHERE `option` = 'com_chronocontact' AND parent='0' AND admin_menu_link='option=com_chronocontact'";
    406. 

  406. 	$database->setQuery( $query );
    407. 

  407. 	$result = $database->loadObject();
    408. 

  408. 	//$configs = JComponentHelper::getParams('com_chronocontact');
    409. 

  409. 	$configs = new JParameter($result->params);
    410. 

  410. 	$postfields = array();
    411. 

  411. 	$postfields['license_key'] = $configs->get('licensecode', '');
    412. 

  412. 	$postfields['domain_name'] = $matches[2];
    413. 

  413. 	$postfields['pid'] = $_POST['pid'];
    414. 

  414. 	$validstatus = false;
    415. 

  415. 	if(function_exists('fsockopen')){	
    416. 

  416. 		$validstatus = validationconnect('http', 'www.chronoengine.com', $port='80', $path='/index2.php?option=com_chronocontact&task=extra&chronoformname=validateLicense', $postfields);
    417. 

  417. 	}
    418. 

  418. 	
    419. 

  419. 	if((!$validstatus)||($validstatus == 'error')||!function_exists('fsockopen')){
    420. 

  420. 		if (!function_exists('curl_init')){
    421. 

  421. 			$validstatus = false;
    422. 

  422. 		}else{
    423. 

  423. 			$fields = ''; 
    424. 

  424. 			$ch = curl_init();
    425. 

  425. 			//$postfields = array();
    426. 

  426. 			foreach( $postfields as $key => $value ) $fields .= "$key=" . urlencode( $value ) . "&";			
    427. 

  427. 			curl_setopt($ch, CURLOPT_URL, 'http://www.chronoengine.com/index2.php?option=com_chronocontact&task=extra&chronoformname=validateLicense');
    428. 

  428. 			curl_setopt($ch, CURLOPT_HEADER, 0);
    429. 

  429. 			curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    430. 

  430. 			curl_setopt($ch, CURLOPT_TIMEOUT, 10);
    431. 

  431. 			curl_setopt($ch, CURLOPT_POSTFIELDS, rtrim( $fields, "& " ));
    432. 

  432. 			if($configs->get('curlproxy', '')){
    433. 

  433. 				curl_setopt($ch, CURLOPT_PROXY, $configs->get('curlproxy'));
    434. 

  434. 			}
    435. 

  435. 			$output = curl_exec($ch);
    436. 

  436. 			curl_close($ch);
    437. 

  437. 			$validstatus = $output;
    438. 

  438. 		}
    439. 

  439. 	}
    440. 

  440. 	//return $validstatus;
    441. 

  441. 	if($validstatus == 'valid'){
    442. 

  442. 		if($configs->get('licensecode', '')){
    443. 

  443. 			//if(!$configs->get('licensevalid', '')){
    444. 

  444. 				$query     = "SELECT * FROM `#__components` WHERE `option` = 'com_chronocontact' AND parent='0' AND admin_menu_link='option=com_chronocontact'";
    445. 

  445. 				$database->setQuery( $query );
    446. 

  446. 				$result = $database->loadObject();
    447. 

  447. 				$newline = "\n";
    448. 

  448. 				if($result){
    449. 

  449. 					$newparams = 'showtipoftheday='.$configs->get('showtipoftheday', 1).$newline.'licensecode='.$configs->get('licensecode', '').$newline.'licensevalid=1';
    450. 

  450. 					$database->setQuery( "UPDATE `#__components` SET params='".$newparams."' WHERE id='".$result->id."'");
    451. 

  451. 					if (!$database->query()) {
    452. 

  452. 						JError::raiseWarning(100, $database->getErrorMsg());
    453. 

  453. 						$mainframe->redirect( "index2.php?option=com_chronocontact" );
    454. 

  454. 					}
    455. 

  455. 				}
    456. 

  456. 			//}
    457. 

  457. 		}
    458. 

  458. 		$mainframe->redirect( "index2.php?option=com_chronocontact", 'Your Install was validated successfully' );
    459. 

  459. 	}else if($validstatus == 'invalid'){
    460. 

  460. 		$query     = "SELECT * FROM `#__components` WHERE `option` = 'com_chronocontact' AND parent='0' AND admin_menu_link='option=com_chronocontact'";
    461. 

  461. 		$database->setQuery( $query );
    462. 

  462. 		$result = $database->loadObject();
    463. 

  463. 		$newline = "\n";
    464. 

  464. 		if($result){
    465. 

  465. 			$newparams = 'showtipoftheday='.$configs->get('showtipoftheday', 1).$newline.'licensecode='.$configs->get('licensecode', '').$newline.'licensevalid=0';
    466. 

  466. 			$database->setQuery( "UPDATE `#__components` SET params='".$newparams."' WHERE id='".$result->id."'");
    467. 

  467. 			if (!$database->query()) {
    468. 

  468. 				JError::raiseWarning(100, $database->getErrorMsg());
    469. 

  469. 				$mainframe->redirect( "index2.php?option=com_chronocontact" );
    470. 

  470. 			}
    471. 

  471. 		}
    472. 

  472. 		$mainframe->redirect( "index2.php?option=com_chronocontact", 'We couldn\'t validate your key because of some wrong data used' );
    473. 

  473. 	}else{
    474. 

  474. 		if(trim(JRequest::getVar('instantcode'))){
    475. 

  475. 			$step1 = base64_decode(trim(JRequest::getVar('instantcode')));
    476. 

  476. 			$step2 = str_replace(substr(md5(str_replace('www.', '', strtolower($matches[2]))), 0, 7), '', $step1);
    477. 

  477. 			$step3 = str_replace(substr(md5(str_replace('www.', '', strtolower($matches[2]))), - strlen(md5(str_replace('www.', '', strtolower($matches[2])))) + 7), '', $step2);
    478. 

  478. 			$step4 = str_replace(substr($configs->get('licensecode', ''), 0, 10), '', $step3);
    479. 

  479. 			$step5 = str_replace(substr($configs->get('licensecode', ''), - strlen($configs->get('licensecode', '')) + 10), '', $step4);
    480. 

  480. 			//echo (int)$step5;return;
    481. 

  481. 			//if((((int)$step5 + (24 * 60 * 60)) > strtotime(date('d-m-Y H:i:s')))||(((int)$step5 - (24 * 60 * 60)) < strtotime(date('d-m-Y H:i:s')))){
    482. 

  482. 			if(((int)$step5 < (strtotime("now") + (24 * 60 * 60)))&&((int)$step5 > (strtotime("now") - (24 * 60 * 60)))){
    483. 

  483. 				$query     = "SELECT * FROM `#__components` WHERE `option` = 'com_chronocontact' AND parent='0' AND admin_menu_link='option=com_chronocontact'";
    484. 

  484. 				$database->setQuery( $query );
    485. 

  485. 				$result = $database->loadObject();
    486. 

  486. 				$newline = "\n";
    487. 

  487. 				if($result){
    488. 

  488. 					$newparams = 'showtipoftheday='.$configs->get('showtipoftheday', 1).$newline.'licensecode='.$configs->get('licensecode', '').$newline.'licensevalid=1';
    489. 

  489. 					$database->setQuery( "UPDATE `#__components` SET params='".$newparams."' WHERE id='".$result->id."'");
    490. 

  490. 					if (!$database->query()) {
    491. 

  491. 						JError::raiseWarning(100, $database->getErrorMsg());
    492. 

  492. 						$mainframe->redirect( "index2.php?option=com_chronocontact" );
    493. 

  493. 					}
    494. 

  494. 				}
    495. 

  495. 				$mainframe->redirect( "index2.php?option=com_chronocontact", 'Your key was validated successfully' );
    496. 

  496. 			}else{
    497. 

  497. 				$mainframe->redirect( "index2.php?option=com_chronocontact", 'Invalid instant code' );
    498. 

  498. 			}
    499. 

  499. 		}else{
    500. 

  500. 			$query     = "SELECT * FROM `#__components` WHERE `option` = 'com_chronocontact' AND parent='0' AND admin_menu_link='option=com_chronocontact'";
    501. 

  501. 			$database->setQuery( $query );
    502. 

  502. 			$result = $database->loadObject();
    503. 

  503. 			$newline = "\n";
    504. 

  504. 			if($result){
    505. 

  505. 				$newparams = 'showtipoftheday='.$configs->get('showtipoftheday', 1).$newline.'licensecode='.$configs->get('licensecode', '').$newline.'licensevalid=0';
    506. 

  506. 				$database->setQuery( "UPDATE `#__components` SET params='".$newparams."' WHERE id='".$result->id."'");
    507. 

  507. 				if (!$database->query()) {
    508. 

  508. 					JError::raiseWarning(100, $database->getErrorMsg());
    509. 

  509. 					$mainframe->redirect( "index2.php?option=com_chronocontact" );
    510. 

  510. 				}
    511. 

  511. 			}
    512. 

  512. 			$mainframe->redirect( "index2.php?option=com_chronocontact", 'We couldn\'t validate your key because your hosting server doesn\'t have neither the CURL library nor the fsockopen functions or they may exist but don\'t function properly, please contact your host admin to fix them or contact us <a href="http://www.chronoengine.com/contactus.html">here</a> Or at this email address : webmaster@chronoengine.com' );
    513. 

  513. 		}
    514. 

  514. 	}
    515. 

  515. }
    516. 

  516. function validationconnect($type, $host, $port='80', $path='/', $data=array()) {
    517. 

  517. 	global $mainframe;
    518. 

  518.     $_err = 'lib sockets::'.__FUNCTION__.'(): ';
    519. 

  519. 	$str = '';
    520. 

  520. 	$d = array();
    521. 

  521.     switch($type) { case 'http': $type = ''; case 'ssl': continue; default: die($_err.'bad $type'); }
    522. 

  522. 	
    523. 

  523.     if(!empty($data)){
    524. 

  524. 		foreach($data as $k => $v){
    525. 

  525. 			$strarr[] = urlencode($k).'='.urlencode($v);
    526. 

  526. 		}
    527. 

  527. 	}
    528. 

  528. 	$str = implode('&', $strarr);
    529. 

  529. 	$result = '';
    530. 

  530. 	//echo $str;
    531. 

  531.     $fp = fsockopen($host, $port, $errno, $errstr, 30);
    532. 

  532.     if(!$fp){
    533. 

  533. 		//$mainframe->redirect( "index2.php?option=com_chronocontact", $_err.$errstr.$errno);
    534. 

  534. 		$result = 'error';
    535. 

  535. 		//die($_err.$errstr.$errno);
    536. 

  536. 	}else{
    537. 

  537.         fputs($fp, "POST $path HTTP/1.1\r\n");
    538. 

  538.         fputs($fp, "Host: $host\r\n");
    539. 

  539.         fputs($fp, "Content-type: application/x-www-form-urlencoded\r\n");
    540. 

  540.         fputs($fp, "Content-length: ".strlen($str)."\r\n");
    541. 

  541.         fputs($fp, "Connection: close\r\n\r\n");
    542. 

  542.         fputs($fp, $str."\r\n\r\n");
    543. 

  543.        
    544. 

  544.         while(!feof($fp)){		
    545. 

  545. 			$d[] = fgets($fp,4096);
    546. 

  546. 		}
    547. 

  547.         fclose($fp);
    548. 

  548. 		$result = $d[count($d) - 1];
    549. 

  549.     } return $result;
    550. 

  550. } 
    551. 

  551. // Publishing of the entries
    552. 

  552. function publishChronoContact( $cid, $publish, $option ) {
    553. 

  553. 	global $mainframe;
    554. 

  554. 	$database =& JFactory::getDBO();
    555. 

  555. 	if (count( $cid ) < 1) {
    556. 

  556. 		$action = $publish ? 'publish' : 'unpublish';
    557. 

  557. 		JError::raiseWarning(100, 'Select a item to '.$action);
    558. 

  558. 		$mainframe->redirect( "index2.php?option=$option" );
    559. 

  559. 	}
    560. 

  560.     $cids = implode( ',', $cid );
    561. 

  561. 	$database->setQuery( "UPDATE #__chrono_contact SET published=".$publish." WHERE id IN ($cids)");
    562. 

  562. 	if (!$database->query()) {
    563. 

  563. 		JError::raiseWarning(100, $database->getErrorMsg());
    564. 

  564. 		$mainframe->redirect( "index2.php?option=$option" );
    565. 

  565. 	}
    566. 

  566.  	if (count( $cid ) == 1) {
    567. 

  567. 		$row =& JTable::getInstance('chronocontact', 'Table'); 
    568. 

  568. 		$row->checkin( $cid[0] );
    569. 

  569. 	}
    570. 

  570. 	$mainframe->redirect( "index2.php?option=$option" );
    571. 

  571. }
    572. 

  572. 

  573. function editChronoContact( $id, $option ) {
    574. 

  574. 	$database =& JFactory::getDBO();
    575. 

  575. 	$row =& JTable::getInstance('chronocontact', 'Table'); 
    576. 

  576. 	$row->load($id);
    577. 

  577. 	HTML_ChronoContact::editChronoContact( $row, $option );
    578. 

  578. }
    579. 

  579. // deletion of entries
    580. 

  580. function removeChronoContact( $cid, $option ) {
    581. 

  581. 	global $mainframe;
    582. 

  582. 	$database =& JFactory::getDBO();
    583. 

  583. 	if (!is_array( $cid ) || count( $cid ) < 1) {
    584. 

  584. 		JError::raiseWarning(100, 'Please select an entry to delete');
    585. 

  585. 		$mainframe->redirect( "index2.php?option=$option" );
    586. 

  586. 	}
    587. 

  587. 	$cids = implode( ',', $cid );
    588. 

  588. 	$database->setQuery( "DELETE FROM #__chrono_contact WHERE id IN ($cids)" );
    589. 

  589. 	if (!$database->query()) {
    590. 

  590. 		JError::raiseWarning(100, $database->getErrorMsg());
    591. 

  591. 		$mainframe->redirect( "index2.php?option=$option" );
    592. 

  592. 	}
    593. 

  593. 	$database->setQuery( "DELETE FROM #__chrono_contact_emails WHERE formid IN ($cids)" );
    594. 

  594. 	if (!$database->query()) {
    595. 

  595. 		JError::raiseWarning(100, $database->getErrorMsg());
    596. 

  596. 		$mainframe->redirect( "index2.php?option=$option" );
    597. 

  597. 	}
    598. 

  598. 	$mainframe->redirect( "index2.php?option=$option" );
    599. 

  599. }
    600. 

  600. function copyChronoContact( $id , $option ) {
    601. 

  601. 	global $mainframe;
    602. 

  602. 	$database =& JFactory::getDBO();
    603. 

  603. 	$row =& JTable::getInstance('chronocontact', 'Table'); 
    604. 

  604. 	$row->load($id);
    605. 

  605. 	$row->id = '';
    606. 

  606. 	if (!$row->store()) {
    607. 

  607. 		JError::raiseWarning(100, $row->getError());
    608. 

  608. 		$mainframe->redirect( "index2.php?option=$option" );
    609. 

  609. 	}
    610. 

  610. 	//copy emails
    611. 

  611. 	$database->setQuery( "SELECT * FROM #__chrono_contact_emails WHERE formid='".$id."'" );
    612. 

  612. 	$emails = $database->loadAssocList();
    613. 

  613. 	//print_r($emails);
    614. 

  614. 	foreach($emails as $email){
    615. 

  615. 		$email['emailid'] = '';
    616. 

  616. 		$email['formid'] = $row->id;
    617. 

  617. 		$row2 =& JTable::getInstance('chronocontactemails', 'Table');
    618. 

  618. 		if (!$row2->bind( $email )) {
    619. 

  619. 			JError::raiseWarning(100, $row2->getError());
    620. 

  620. 			$mainframe->redirect( "index2.php?option=$option" );
    621. 

  621. 		}
    622. 

  622. 		if (!$row2->store()) {
    623. 

  623. 			JError::raiseWarning(100, $row2->getError());
    624. 

  624. 			$mainframe->redirect( "index2.php?option=$option" );
    625. 

  625. 		}
    626. 

  626. 	}
    627. 

  627. 	//copy plugins
    628. 

  628. 	$database->setQuery( "SELECT * FROM #__chrono_contact_plugins WHERE form_id='".$id."'" );
    629. 

  629. 	$plugins = $database->loadAssocList();
    630. 

  630. 	//print_r($emails);
    631. 

  631. 	foreach($plugins as $plugin){
    632. 

  632. 		$plugin['id'] = '';
    633. 

  633. 		$plugin['form_id'] = $row->id;
    634. 

  634. 		$row3 =& JTable::getInstance('chronocontactplugins', 'Table');
    635. 

  635. 		if (!$row3->bind( $plugin )) {
    636. 

  636. 			JError::raiseWarning(100, $row3->getError());
    637. 

  637. 			$mainframe->redirect( "index2.php?option=$option" );
    638. 

  638. 		}
    639. 

  639. 		if (!$row3->store()) {
    640. 

  640. 			JError::raiseWarning(100, $row3->getError());
    641. 

  641. 			$mainframe->redirect( "index2.php?option=$option" );
    642. 

  642. 		}
    643. 

  643. 	}
    644. 

  644. 	$mainframe->redirect( "index2.php?option=".$option );
    645. 

  645. }
    646. 

  646. // save entry
    647. 

  647. function saveChronoContact( $option, $task ) {
    648. 

  648. 	global $mainframe;
    649. 

  649. 	$database =& JFactory::getDBO();
    650. 

  650. 	$row =& JTable::getInstance('chronocontact', 'Table');
    651. 

  651. 	$post = JRequest::get( 'post' , JREQUEST_ALLOWRAW );
    652. 

  652. 	//$post = JRequest::getVar( 'description', '', 'post','string', _J_ALLOWRAW );
    653. 

  653. 	if (!$row->bind( $post )) {
    654. 

  654. 		JError::raiseWarning(100, $row->getError());
    655. 

  655. 		$mainframe->redirect( "index2.php?option=$option" );
    656. 

  656. 	}
    657. 

  657. 	
    658. 

  658. 	$params = JRequest::getVar( 'params', array(), 'post', 'array');
    659. 

  659. 	if (is_array( $params )) {
    660. 

  660. 		$txt = array();
    661. 

  661. 		foreach ( $params as $k=>$v) {
    662. 

  662. 			$txt[] = "$k=$v";
    663. 

  663. 		}
    664. 

  664. 		
    665. 

  665. 		$plugins 	= JRequest::getVar( 'plugins', array(), 'post', 'array');
    666. 

  666. 		$mplugins_order = JRequest::getVar( 'mplugins_order', array(), 'post', 'array');
    667. 

  667. 		$plugins_enable 	= JRequest::getVar( 'plugins_enable', array(), 'post', 'array');
    668. 

  668. 		$pluginslist = array();
    669. 

  669. 		$mplugins_orderlist = array();
    670. 

  670. 		foreach($plugins_enable as $k => $plugin_enable){
    671. 

  671. 			if($plugin_enable == 1){
    672. 

  672. 				$pluginslist[] = $plugins[$k];
    673. 

  673. 				$mplugins_orderlist[] = $mplugins_order[$k];
    674. 

  674. 			}
    675. 

  675. 		}
    676. 

  676. 		if(is_array( $plugins )){
    677. 

  677. 			$txt[] = "plugins=".implode(",", $pluginslist);
    678. 

  678. 		}		
    679. 

  679. 		if(is_array( $mplugins_order )){
    680. 

  680. 			$txt[] = "mplugins_order=".implode(",", $mplugins_orderlist);
    681. 

  681. 		}
    682. 

  682. 		$tablenames 	= JRequest::getVar( 'tablenames', array(), 'post', 'array');
    683. 

  683. 		if(is_array( $tablenames )){
    684. 

  684. 			$txt[] = "tablenames=".implode(",",$tablenames);
    685. 

  685. 		}
    686. 

  686. 		$row->paramsall = implode( "\n", $txt );
    687. 

  687. 	}
    688. 

  688. 	
    689. 

  689. 	$FieldsNamesTypes = generateFieldsNamesTypes($post["html"]);
    690. 

  690. 	$row->fieldsnames = implode(",", $FieldsNamesTypes["names"]);
    691. 

  691. 	$row->fieldstypes = implode(",", $FieldsNamesTypes["types"]);
    692. 

  692. 	
    693. 

  693. 	
    694. 

  694. 	$row->dbclasses = "";
    695. 

  695. 	if (is_array( $params )) {
    696. 

  696. 		foreach($tablenames as $tablename){
    697. 

  697. 			//Create Class
    698. 

  698. 			$tables = array();
    699. 

  699. 			$tables[] = $tablename;
    700. 

  700. 			$result = $database->getTableFields( $tables, false );
    701. 

  701. 			//print_r($result[$row->tablenames]);
    702. 

  702. 			$table_fields = $result[$tablename];
    703. 

  703. 			$row->dbclasses .= "<?php";	
    704. 

  704. 			$row->dbclasses .= "\n";
    705. 

  705. 			$row->dbclasses .= "if (!class_exists('Table".str_replace($mainframe->getCfg('dbprefix'), '', $tablename)."')) {";
    706. 

  706. 			$row->dbclasses .= "\n";
    707. 

  707. 			$row->dbclasses .= "class Table".str_replace($mainframe->getCfg('dbprefix'), '', $tablename)." extends JTable {";	
    708. 

  708. 			$primary = 'id';
    709. 

  709. 			foreach($table_fields as $table_field => $field_data){
    710. 

  710. 				$row->dbclasses .= "\n";
    711. 

  711. 				$row->dbclasses .= "var \$".$table_field." = null;";
    712. 

  712. 				if($field_data->Key == 'PRI')$primary = $table_field;
    713. 

  713. 			}
    714. 

  714. 			$row->dbclasses .= "\n";
    715. 

  715. 			$row->dbclasses .= "function __construct( &\$database ) {";
    716. 

  716. 			$row->dbclasses .= "\n";
    717. 

  717. 			$row->dbclasses .= "parent::__construct( '".$tablename."', '".$primary."', \$database );";
    718. 

  718. 			$row->dbclasses .= "\n";
    719. 

  719. 			$row->dbclasses .= "}";
    720. 

  720. 			$row->dbclasses .= "\n";
    721. 

  721. 			$row->dbclasses .= "}";
    722. 

  722. 			$row->dbclasses .= "\n";
    723. 

  723. 			$row->dbclasses .= "}";
    724. 

  724. 			$row->dbclasses .= "\n";
    725. 

  725. 			$row->dbclasses .= "?>";
    726. 

  726. 			$row->dbclasses .= "\n";
    727. 

  727. 		}
    728. 

  728. 	}
    729. 

  729. 	$row->autogenerated = "";
    730. 

  730. 	
    731. 

  731. 	//$tables = explode("," , $paramsvalues->tablenames);
    732. 

  732. 	foreach($tablenames as $tablename){
    733. 

  733. 		$row->autogenerated = $row->autogenerated.'<?php
    734. 

  734. 		$MyForm =& CFChronoForm::getInstance("'.$post['name'].'");
    735. 

  735. 		if($MyForm->formparams("dbconnection") == "Yes"){
    736. 

  736. 			$user = JFactory::getUser();			
    737. 

  737. 			$row =& JTable::getInstance("'.str_replace($mainframe->getCfg("dbprefix"), "", $tablename).'", "Table");
    738. 

  738. 			srand((double)microtime()*10000);
    739. 

  739. 			$inum	=	"I" . substr(base64_encode(md5(rand())), 0, 16).md5(uniqid(mt_rand(), true));
    740. 

  740. 			JRequest::setVar( "recordtime", JRequest::getVar( "recordtime", date("Y-m-d")." - ".date("H:i:s"), "post", "string", "" ));
    741. 

  741. 			JRequest::setVar( "ipaddress", JRequest::getVar( "ipaddress", $_SERVER["REMOTE_ADDR"], "post", "string", "" ));
    742. 

  742. 			JRequest::setVar( "uid", JRequest::getVar( "uid", $inum, "post", "string", "" ));
    743. 

  743. 			JRequest::setVar( "cf_user_id", JRequest::getVar( "cf_user_id", $user->id, "post", "int", "" ));
    744. 

  744. 			$post = JRequest::get( "post" , JREQUEST_ALLOWRAW );			
    745. 

  745. 			if (!$row->bind( $post )) {
    746. 

  746. 				JError::raiseWarning(100, $row->getError());
    747. 

  747. 			}				
    748. 

  748. 			if (!$row->store()) {
    749. 

  749. 				JError::raiseWarning(100, $row->getError());
    750. 

  750. 			}
    751. 

  751. 			$MyForm->tablerow["'.$tablename.'"] = $row;
    752. 

  752. 		}
    753. 

  753. 		?>
    754. 

  754. 		';
    755. 

  755. 	}
    756. 

  756. 	
    757. 

  757. 	
    758. 

  758. 	if (!$row->store()) {
    759. 

  759. 		JError::raiseWarning(100, $row->getError());
    760. 

  760. 		$mainframe->redirect( "index2.php?option=$option" );
    761. 

  761. 	}
    762. 

  762. 	
    763. 

  763. 	//Emails
    764. 

  764. 	//Delet old emails and save new clean ones
    765. 

  765. 	$database->setQuery( "DELETE FROM #__chrono_contact_emails WHERE formid = '".$row->id."'" );
    766. 

  766. 	if (!$database->query()) {
    767. 

  767. 		JError::raiseWarning(100, $database->getErrorMsg());
    768. 

  768. 		$mainframe->redirect( "index2.php?option=$option" );
    769. 

  769. 	}
    770. 

  770. 	preg_match_all('/start_email{.*?}end_email/i', $post['emails_temp'], $matches);
    771. 

  771. 	$emails = array();
    772. 

  772. 	$template_count2 = 0;
    773. 

  773. 	$emails_ids =  explode(',', str_replace('email_', '', $post['emails_temp_ids']));
    774. 

  774. 	foreach ( $matches[0] as $email ) {
    775. 

  775. 	$template_count = $emails_ids[$template_count2+1];
    776. 

  776. 	//echo $email;return;
    777. 

  777. 		$email = preg_replace('/start_email{/i', '', $email);
    778. 

  778. 		$email = preg_replace('/}end_email/i', '', $email);
    779. 

  779. 		$email_elements = explode('||', $email);
    780. 

  780. 		//$emails[] = trim($email);
    781. 

  781. 		$post2 = array();
    782. 

  782. 		//$post2['emailid'] = ;
    783. 

  783. 		$post2['to'] = str_replace('TO=[', '', str_replace(']', '', $email_elements[0]));
    784. 

  784. 		$post2['dto'] = str_replace('DTO=[', '', str_replace(']', '', $email_elements[1]));
    785. 

  785. 		$post2['subject'] = str_replace('SUBJECT=[', '', str_replace(']', '', $email_elements[2]));
    786. 

  786. 		$post2['dsubject'] = str_replace('DSUBJECT=[', '', str_replace(']', '', $email_elements[3]));
    787. 

  787. 		$post2['cc'] = str_replace('CC=[', '', str_replace(']', '', $email_elements[4]));
    788. 

  788. 		$post2['dcc'] = str_replace('DCC=[', '', str_replace(']', '', $email_elements[5]));
    789. 

  789. 		$post2['bcc'] = str_replace('BCC=[', '', str_replace(']', '', $email_elements[6]));
    790. 

  790. 		$post2['dbcc'] = str_replace('DBCC=[', '', str_replace(']', '', $email_elements[7]));
    791. 

  791. 		$post2['fromname'] = str_replace('FROMNAME=[', '', str_replace(']', '', $email_elements[8]));
    792. 

  792. 		$post2['dfromname'] = str_replace('DFROMNAME=[', '', str_replace(']', '', $email_elements[9]));
    793. 

  793. 		$post2['fromemail'] = str_replace('FROMEMAIL=[', '', str_replace(']', '', $email_elements[10]));
    794. 

  794. 		$post2['dfromemail'] = str_replace('DFROMEMAIL=[', '', str_replace(']', '', $email_elements[11]));
    795. 

  795. 		$post2['replytoname'] = str_replace('REPLYTONAME=[', '', str_replace(']', '', $email_elements[12]));
    796. 

  796. 		$post2['dreplytoname'] = str_replace('DREPLYTONAME=[', '', str_replace(']', '', $email_elements[13]));
    797. 

  797. 		$post2['replytoemail'] = str_replace('REPLYTOEMAIL=[', '', str_replace(']', '', $email_elements[14]));
    798. 

  798. 		$post2['dreplytoemail'] = str_replace('DREPLYTOEMAIL=[', '', str_replace(']', '', $email_elements[15]));
    799. 

  799. 		$post2['formid'] = $row->id;
    800. 

  800. 		
    801. 

  801. 		//$post2['params'] = $post['params_email_'.$template_count];
    802. 

  802. 		$params = explode(",", $post['params_email_'.$template_count]);
    803. 

  803. 		$txt = array();
    804. 

  804. 		$txt[0] = "recordip=".$params[0];
    805. 

  805. 		$txt[1] = "emailtype=".$params[1];
    806. 

  806. 		$txt[2] = "enabled=".$params[2];
    807. 

  807. 		$txt[3] = "editor=".$params[3];
    808. 

  808. 		$txt[4] = "enable_attachments=".$params[4];
    809. 

  809. 		$post2['params'] = implode("\n", $txt);
    810. 

  810. 		$post2['template'] = trim($post['editor_email_'.$template_count]) ? trim($post['editor_email_'.$template_count]) : generateAutoEmailTemplate($post['html']);
    811. 

  811. 		$template_count2++;
    812. 

  812. 		$post2['enabled'] = $params[2];
    813. 

  813. 		
    814. 

  814. 		$row2 =& JTable::getInstance('chronocontactemails', 'Table');
    815. 

  815. 		if (!$row2->bind( $post2 )) {
    816. 

  816. 			JError::raiseWarning(100, $row2->getError());
    817. 

  817. 			$mainframe->redirect( "index2.php?option=$option" );
    818. 

  818. 		}
    819. 

  819. 		if (!$row2->store()) {
    820. 

  820. 			JError::raiseWarning(100, $row2->getError());
    821. 

  821. 			$mainframe->redirect( "index2.php?option=$option" );
    822. 

  822. 		}
    823. 

  823. 	}
    824. 

  824. 	
    825. 

  825. 	//end Emails
    826. 

  826. 	if($task != 'applychanges'){
    827. 

  827. 		$mainframe->redirect( "index2.php?option=".$option );
    828. 

  828. 	}else{
    829. 

  829. 		editChronoContact( $row->id, $option );
    830. 

  830. 	}
    831. 

  831. }
    832. 

  832. // abort the current action
    833. 

  833. function cancelChronoContact( $option ) {
    834. 

  834. 	global $mainframe;
    835. 

  835. 	$database =& JFactory::getDBO();
    836. 

  836. 	//$row =& JTable::getInstance('chronocontact', 'Table');
    837. 

  837. 	//$row->bind( $_POST );
    838. 

  838. 	//$row->checkin();
    839. 

  839. 	$mainframe->redirect( "index2.php?option=$option" );
    840. 

  840. }
    841. 

  841. // list entries
    842. 

  842. function showChronoContact($option) {
    843. 

  843. 	global $mainframe;
    844. 

  844. 	$limit = $mainframe->getUserStateFromRequest($option.'.limit', 'limit', $mainframe->getCfg('list_limit'), 'int'); 
    845. 

  845. 	$limitstart = $mainframe->getUserStateFromRequest($option.'.limitstart', 'limitstart', 0, 'int');
    846. 

  846. 	// count entries
    847. 

  847. 	$database =& JFactory::getDBO();
    848. 

  848. 	$database->setQuery( "SELECT count(*) FROM #__chrono_contact" );
    849. 

  849. 	$total = $database->loadResult();
    850. 

  850. 	echo $database->getErrorMsg();
    851. 

  851. 	jimport('joomla.html.pagination'); 		
    852. 

  852. 	$pageNav = new JPagination($total, $limitstart, $limit); 
    853. 

  853. 	# main database query
    854. 

  854. 	$database->setQuery( "SELECT * FROM #__chrono_contact ORDER BY id LIMIT $pageNav->limitstart,$pageNav->limit" );
    855. 

  855. 	$rows = $database->loadObjectList();
    856. 

  856. 	if ($database->getErrorNum()) {
    857. 

  857. 		JError::raiseWarning(100, $database->stderr());
    858. 

  858. 		$mainframe->redirect( "index2.php?option=$option" );
    859. 

  859. 	}
    860. 

  860. 	HTML_ChronoContact::showChronoContact( $rows, $pageNav, $option );
    861. 

  861. }
    862. 

  862. 

  863. ///////////////////////////////
    864. 

  864. function showdataChronoContact($id, $option) {
    865. 

  865. 	global $mainframe;	
    866. 

  866. 	$database =& JFactory::getDBO();
    867. 

  867. 	
    868. 

  868. 	if(!$id){
    869. 

  869. 		if(is_array(JRequest::getVar('formid', array(0), 'post', 'array'))){
    870. 

  870. 			$id_arr = JRequest::getVar('formid', array(0), 'post', 'array');
    871. 

  871. 			$id = $id_arr[0];
    872. 

  872. 		}else{
    873. 

  873. 			$id = JRequest::getVar('formid', 0, 'post', 'int');
    874. 

  874. 		}
    875. 

  875. 	}
    876. 

  876. 	if(!$id){
    877. 

  877. 		$id = JRequest::getVar('formid', 0, 'get', 'int');
    878. 

  878. 	}
    879. 

  879. 	
    880. 

  880. 	if($id){
    881. 

  881. 		$query = "SELECT * FROM #__chrono_contact WHERE id = '$id'";
    882. 

  882. 		$database->setQuery( $query );
    883. 

  883. 		$rows = $database->loadObjectList();
    884. 

  884. 		$paramsvalues = new JParameter($rows[0]->paramsall);
    885. 

  885. 		$formtables = explode(",", $paramsvalues->get('tablenames'));
    886. 

  886. 	}
    887. 

  887. 	
    888. 

  888. 	$table = JRequest::getVar('table', '');
    889. 

  889. 	
    890. 

  890. 	$result = $database->getTableList();
    891. 

  891. 	if(!in_array($table, $result) || !$table){	
    892. 

  892. 		echo "<form action=\"index2.php\" method=\"post\" name=\"adminForm\">
    893. 

  893. 		Table Doesn't Exist
    894. 

  894. 		<input type=\"hidden\" name=\"task\" value=\"\" />
    895. 

  895. 		<input type=\"hidden\" name=\"option\" value=\"$option\" />
    896. 

  896. 		</form>";
    897. 

  897. 	}else{
    898. 

  898. 		$limit = $mainframe->getUserStateFromRequest($option.'.limit'.$table, 'limit', $mainframe->getCfg('list_limit'), 'int'); 
    899. 

  899. 		$limitstart = $mainframe->getUserStateFromRequest($option.'.limitstart'.$table, 'limitstart', 0, 'int');
    900. 

  900. 		// count entries
    901. 

  901. 		$database->setQuery( "SELECT count(*) FROM ".$table );
    902. 

  902. 		$total = $database->loadResult();
    903. 

  903. 		echo $database->getErrorMsg();
    904. 

  904. 		jimport('joomla.html.pagination'); 		
    905. 

  905. 		$pageNav = new JPagination($total, $limitstart, $limit);
    906. 

  906. 		# main database query
    907. 

  907. 		# get primary key
    908. 

  908. 		$tables = array();
    909. 

  909. 		$tables[] = $table;
    910. 

  910. 		$result = $database->getTableFields( $tables, false );
    911. 

  911. 		$table_fields = $result[$table];
    912. 

  912. 		$primary = '';
    913. 

  913. 		foreach($table_fields as $table_field => $field_data){
    914. 

  914. 			if($field_data->Key == 'PRI')$primary = $table_field;
    915. 

  915. 		}
    916. 

  916. 		$order = "";
    917. 

  917. 		if($primary) $order = " ORDER BY ".$primary;	
    918. 

  918. 		$database->setQuery( "SELECT * FROM ".$table.$order." LIMIT $pageNav->limitstart,$pageNav->limit" );
    919. 

  919. 		$rows = $database->loadObjectList();
    920. 

  920. 		if ($database->getErrorNum()) {
    921. 

  921. 			JError::raiseWarning(100, $database->stderr());
    922. 

  922. 			$mainframe->redirect( "index2.php?option=$option" );
    923. 

  923. 		}
    924. 

  924. 		$formid = $id;
    925. 

  925. 		HTML_ChronoContact::showdataChronoContact( $rows, $pageNav, $option, $formid, $table );
    926. 

  926. 	}
    927. 

  927. }
    928. 

  928. function viewdataChronoContact( $ids, $option ) {
    929. 

  929. 	global $mainframe;	
    930. 

  930. 	$database =& JFactory::getDBO();
    931. 

  931. 	$fids = explode("_",$ids);
    932. 

  932. 	$table = JRequest::getVar('table', '', 'post', 'string', 0);
    933. 

  933. 	# get primary key
    934. 

  934. 	$tables = array();
    935. 

  935. 	$tables[] = $table;
    936. 

  936. 	$result = $database->getTableFields( $tables, false );
    937. 

  937. 	$table_fields = $result[$table];
    938. 

  938. 	$primary = 'cf_id';
    939. 

  939. 	foreach($table_fields as $table_field => $field_data){
    940. 

  940. 		if($field_data->Key == 'PRI')$primary = $table_field;
    941. 

  941. 	}
    942. 

  942. 	$database->setQuery( "SELECT * FROM ".$table." WHERE ".$primary."=".$fids[0] );
    943. 

  943. 	$rows = $database->loadObjectList();
    944. 

  944. 	$row = $rows[0];
    945. 

  945. 	$tablename = $table;
    946. 

  946. 	//echo "SELECT * FROM ".$table." WHERE ".$primary."=".$fids[0];
    947. 

  947. 	HTML_ChronoContact::viewdataChronoContact( $row, $option, $tablename, $fids[1] );
    948. 

  948. }
    949. 

  949. function tablemanagerChronoContact( $option ){
    950. 

  950. 	global $mainframe;
    951. 

  951. 	$database =& JFactory::getDBO();	
    952. 

  952. 	$result = $database->getTableList();
    953. 

  953. 	HTML_ChronoContact::tablemanagerChronoContact($option, $result);
    954. 

  954. }
    955. 

  955. function maketableChronoContact( $id, $option ) {
    956. 

  956. 	global $mainframe;
    957. 

  957. 	$database =& JFactory::getDBO();
    958. 

  958. 	$query     = "SELECT * FROM `#__components` WHERE `option` = 'com_chronocontact' AND parent='0' AND admin_menu_link='option=com_chronocontact'";
    959. 

  959. 	$database->setQuery( $query );
    960. 

  960. 	$result = $database->loadObject();
    961. 

  961. 	//$configs = JComponentHelper::getParams('com_chronocontact');
    962. 

  962. 	$configs = new JParameter($result->params);
    963. 

  963. 	
    964. 

  964. 	$table = JRequest::getVar('table');
    965. 

  965. 	$result = $database->getTableList();
    966. 

  966. 	if ($table) {
    967. 

  967. 		$tables = array();
    968. 

  968. 		$tables[] = $table;
    969. 

  969. 		$result = $database->getTableFields( $tables, false );
    970. 

  970. 		$table_fields = $result[$table];
    971. 

  971. 		
    972. 

  972. 		$row = new StdClass();
    973. 

  973. 		$row->id = 0;
    974. 

  974. 		HTML_ChronoContact::maketableChronoContact( $row, $option, $table, $table_fields );
    975. 

  975. 	} else {
    976. 

  976. 		$row =& JTable::getInstance('chronocontact', 'Table');
    977. 

  977. 		$row->load( $id );
    978. 

  978. 		
    979. 

  979. 		$html_message = "";
    980. 

  980. 		
    981. 

  981. 		$multipagefields = '';
    982. 

  982. 		$multipagefieldsnames = array();
    983. 

  983. 		//check if form is a mother form and load childs fields
    984. 

  984. 		$formparams = new JParameter($row->paramsall);
    985. 

  985. 		$formplugins = explode(",", $formparams->get('plugins'));
    986. 

  986. 		if(in_array('cf_multi_page', $formplugins)){
    987. 

  987. 			$query = "SELECT * FROM #__chrono_contact_plugins WHERE `form_id` = '".$id."' AND name='cf_multi_page'";
    988. 

  988. 			$database->setQuery( $query );
    989. 

  989. 			$multipageconfig = $database->loadObject();
    990. 

  990. 			$multipageparams = new JParameter($multipageconfig->params);
    991. 

  991. 			$multipageforms = array();
    992. 

  992. 			if(trim($multipageparams->get('formsnames'))){
    993. 

  993. 				$multipageforms = explode(',', $multipageparams->get('formsnames'));
    994. 

  994. 				$multipagefieldsnames = array();
    995. 

  995. 				$multipagefields = array();
    996. 

  996. 			}
    997. 

  997. 			foreach($multipageforms as $multipageform){
    998. 

  998. 				$query = "SELECT * FROM #__chrono_contact WHERE `name` = '".$multipageform."'";
    999. 

  999. 				$database->setQuery( $query );
    1000. 

  1000. 				$multipageformdata = $database->loadObject();
    1001. 

  1001. 				$multipagefields[] = $multipageformdata->fieldsnames;
    1002. 

  1002. 			}
    1003. 

  1003. 			$multipagefieldsnames = explode(",", implode(",", $multipagefields));
    1004. 

  1004. 		}
    1005. 

  1005. 		
    1006. 

  1006. 		$defaults = array('cf_id' => (object) array('Type' => 'INT(11)', 'Key' => 'PRI', 'Extra' => 'auto_increment'),
    1007. 

  1007. 		 'uid' => (object) array('Type' => 'VARCHAR(255)', 'Key' => '', 'Extra' => ''),
    1008. 

  1008. 		  'recordtime' => (object) array('Type' => 'VARCHAR(255)', 'Key' => '', 'Extra' => ''),
    1009. 

  1009. 		   'ipaddress' => (object) array('Type' => 'VARCHAR(255)', 'Key' => '', 'Extra' => ''),
    1010. 

  1010. 		    'cf_user_id' => (object) array('Type' => 'VARCHAR(255)', 'Key' => '', 'Extra' => ''));
    1011. 

  1011. 		$names = array();
    1012. 

  1012. 		if(trim($row->fieldsnames)){
    1013. 

  1013. 			$names = explode(",", $row->fieldsnames);
    1014. 

  1014. 		}
    1015. 

  1015. 		$fieldstypes = explode(",", $row->fieldstypes);
    1016. 

  1016. 		foreach($names as $name){
    1017. 

  1017. 			$defaults[$name] = (object) array('Type' => '', 'Key' => '', 'Extra' => '');
    1018. 

  1018. 		}
    1019. 

  1019. 		if(count($multipagefieldsnames)){
    1020. 

  1020. 			foreach($multipagefieldsnames as $multipagefieldsname){
    1021. 

  1021. 				$defaults[$multipagefieldsname] = (object) array('Type' => '', 'Key' => '', 'Extra' => '');
    1022. 

  1022. 			}
    1023. 

  1023. 		}
    1024. 

  1024. 		HTML_ChronoContact::maketableChronoContact( $row, $option, '', $defaults );
    1025. 

  1025. 	}
    1026. 

  1026. }
    1027. 

  1027. function finalizetableChronoContact( $option ) {
    1028. 

  1028. 	global $mainframe;	
    1029. 

  1029. 	$database =& JFactory::getDBO();
    1030. 

  1030. 	$id = JRequest::getVar('formid');
    1031. 

  1031. 	$table = JRequest::getVar('istable_name');
    1032. 

  1032. 	$post = JRequest::get( 'post' , JREQUEST_ALLOWRAW );
    1033. 

  1033. 	$table_sql_arr = array();
    1034. 

  1034. 	$primarykey = '';
    1035. 

  1035. 		
    1036. 

  1036. 	if($id){
    1037. 

  1037. 		$row =& JTable::getInstance('chronocontact', 'Table');
    1038. 

  1038. 		$row->load( $id );		
    1039. 

  1039. 		$paramsvalues = new JParameter($row->paramsall);		
    1040. 

  1040. 		
    1041. 

  1041. 		if(is_array($post['fields'])){
    1042. 

  1042. 			foreach($post['fields'] as $k => $field){
    1043. 

  1043. 				if($field && $post['fields_enable'][$k]){
    1044. 

  1044. 					$sqlpiece = '`'.$field.'` '.$post['fields_types'][$k].' NOT NULL';
    1045. 

  1045. 					if(JRequest::getVar('isautoincrement') == $field){
    1046. 

  1046. 						$sqlpiece .= " auto_increment";
    1047. 

  1047. 					}
    1048. 

  1048. 					if(JRequest::getVar('iskey') == $field){
    1049. 

  1049. 						$primarykey = "PRIMARY KEY  (`".$field."`)";
    1050. 

  1050. 					}
    1051. 

  1051. 					$table_sql_arr[] = $sqlpiece;
    1052. 

  1052. 				}
    1053. 

  1053. 			}
    1054. 

  1054. 		}
    1055. 

  1055. 		if($primarykey){
    1056. 

  1056. 			$table_sql_arr[] = $primarykey;
    1057. 

  1057. 		}
    1058. 

  1058. 		if ( count($post['fields']) > 0){
    1059. 

  1059. 			$table_sql = "CREATE TABLE `".JRequest::getVar('istable_name')."` (";
    1060. 

  1060. 			$table_sql .= implode(", ", $table_sql_arr);
    1061. 

  1061. 			if ($paramsvalues->get('mysql_type', 0) == 2){
    1062. 

  1062. 				$table_sql .= ") TYPE = MYISAM ;";
    1063. 

  1063. 			} else{ 
    1064. 

  1064. 				$table_sql .= ") ENGINE = MYISAM ;";
    1065. 

  1065. 			}
    1066. 

  1066. 		}
    1067. 

  1067. 	}else{
    1068. 

  1068. 		if($table){
    1069. 

  1069. 			$result = $database->getTableList();
    1070. 

  1070. 			$table_sql = '';
    1071. 

  1071. 			if(in_array(JRequest::getVar('tableexists'), $result)){				
    1072. 

  1072. 				//rename table if name was changed
    1073. 

  1073. 				if($table != JRequest::getVar('tableexists')){
    1074. 

  1074. 					$database->setQuery('RENAME TABLE `'.JRequest::getVar('tableexists').'`  TO `'.$table.'`');
    1075. 

  1075. 					if (!$database->query()) {
    1076. 

  1076. 						$mainframe->redirect( 'index2.php?option='.$option, "Error while renaming table :".$database->getErrorMsg() );
    1077. 

  1077. 					}
    1078. 

  1078. 				}
    1079. 

  1079. 				$tables = array();
    1080. 

  1080. 				$tables[] = $table;
    1081. 

  1081. 				$result = $database->getTableFields( $tables, false );
    1082. 

  1082. 				$table_fields = $result[$table];
    1083. 

  1083. 				
    1084. 

  1084. 				if(is_array($post['fields'])){
    1085. 

  1085. 					foreach($post['fields'] as $k => $field){
    1086. 

  1086. 						$found = false;
    1087. 

  1087. 						$sqlpiece = '';
    1088. 

  1088. 						if($field && $post['fields_enable'][$k]){
    1089. 

  1089. 							foreach($table_fields as $fieldname => $fielddata){
    1090. 

  1090. 								if($field == $fieldname){
    1091. 

  1091. 									$found = true;
    1092. 

  1092. 									break;
    1093. 

  1093. 								}
    1094. 

  1094. 							}
    1095. 

  1095. 							if(!$found){
    1096. 

  1096. 								$sqlpiece = 'ADD COLUMN `'.$field.'` '.$post['fields_types'][$k].' NOT NULL';
    1097. 

  1097. 							}
    1098. 

  1098. 							if((JRequest::getVar('isautoincrement') == $field)&&$sqlpiece){
    1099. 

  1099. 								$sqlpiece .= " auto_increment";
    1100. 

  1100. 							}
    1101. 

  1101. 							if((JRequest::getVar('iskey') == $field)&&(JRequest::getVar('isoldkey') != $field)){
    1102. 

  1102. 								$primarykey = "DROP PRIMARY KEY, ADD PRIMARY KEY  (`".$field."`)";
    1103. 

  1103. 							}
    1104. 

  1104. 							if($sqlpiece){
    1105. 

  1105. 								$table_sql_arr[] = $sqlpiece;
    1106. 

  1106. 							}
    1107. 

  1107. 						}
    1108. 

  1108. 						if($field && !$post['fields_enable'][$k] && in_array($field, array_keys($table_fields))){
    1109. 

  1109. 							$table_sql_arr[] = 'DROP `'.$field.'`';
    1110. 

  1110. 						}
    1111. 

  1111. 					}
    1112. 

  1112. 					if($primarykey){
    1113. 

  1113. 						$table_sql_arr[] = $primarykey;
    1114. 

  1114. 					}
    1115. 

  1115. 					if(implode(", ", $table_sql_arr)){
    1116. 

  1116. 						$table_sql = 'ALTER TABLE '.$table.' '.implode(", ", $table_sql_arr).';';
    1117. 

  1117. 					}
    1118. 

  1118. 				}
    1119. 

  1119. 							
    1120. 

  1120. 			}
    1121. 

  1121. 		}
    1122. 

  1122. 	}
    1123. 

  1123. 	
    1124. 

  1124. 	$success_message = ($id) ? "Table has been created successfully" : "Table has been updated successfully";
    1125. 

  1125. 	if($table_sql){
    1126. 

  1126. 		$database->setQuery( $table_sql );
    1127. 

  1127. 		if (!$database->query()) {
    1128. 

  1128. 			$mainframe->redirect( 'index2.php?option='.$option, "Error while creating table :".$database->getErrorMsg() );
    1129. 

  1129. 		}else{	
    1130. 

  1130. 			$mainframe->redirect( 'index2.php?option='.$option, $success_message );
    1131. 

  1131. 		}
    1132. 

  1132. 	}else{
    1133. 

  1133. 		$mainframe->redirect( 'index2.php?option='.$option, "Your changes have been applied" );
    1134. 

  1134. 	}
    1135. 

  1135. 			
    1136. 

  1136. }
    1137. 

  1137. function updatetablelistChronoContact( $option ) {
    1138. 

  1138. 	global $mainframe;	
    1139. 

  1139. 	$database =& JFactory::getDBO();
    1140. 

  1140. 	$post = JRequest::get( 'post' , JREQUEST_ALLOWRAW );
    1141. 

  1141. 	
    1142. 

  1142. 	$table_sql_arr = array();
    1143. 

  1143. 	if(is_array($post['tables'])){
    1144. 

  1144. 		foreach($post['tables'] as $k => $table){
    1145. 

  1145. 			if($table && !$post['tables_enable'][$k]){
    1146. 

  1146. 				$sqlpiece = '`'.$table.'`';
    1147. 

  1147. 				$table_sql_arr[] = $sqlpiece;
    1148. 

  1148. 			}
    1149. 

  1149. 		}
    1150. 

  1150. 	}
    1151. 

  1151. 	
    1152. 

  1152. 	if(count($table_sql_arr)){
    1153. 

  1153. 		$table_sql = 'DROP TABLE IF EXISTS '.implode(", ", $table_sql_arr).';';
    1154. 

  1154. 		$database->setQuery( $table_sql );
    1155. 

  1155. 		if (!$database->query()) {
    1156. 

  1156. 			$mainframe->redirect( 'index2.php?option='.$option, "Error:".$database->getErrorMsg() );
    1157. 

  1157. 		}else{	
    1158. 

  1158. 			$mainframe->redirect( 'index2.php?option='.$option, "Tables list updated successfully" );
    1159. 

  1159. 		}
    1160. 

  1160. 	}else{
    1161. 

  1161. 		$mainframe->redirect( 'index2.php?option='.$option, "No changes have been made" );
    1162. 

  1162. 	}
    1163. 

  1163. 	
    1164. 

  1164. }
    1165. 

  1165. 

  1166. 

  1167. /* backup ****************************************************/
    1168. 

  1168. function backupChronoContact( $id, $option, $task ){
    1169. 

  1169. global $mainframe;	
    1170. 

  1170. 	$database =& JFactory::getDBO();
    1171. 

  1171. 	if($task == 'backup'){
    1172. 

  1172. 		$database->setQuery( "SELECT * FROM #__chrono_contact WHERE id='".$id."'" );
    1173. 

  1173. 		$rows = $database->loadObjectList();
    1174. 

  1174. 	
    1175. 

  1175. 		
    1176. 

  1176. 		$tablename = $mainframe->getCfg('dbprefix')."chrono_contact";
    1177. 

  1177. 		$tables = array( $tablename );
    1178. 

  1178. 		$result = $database->getTableFields( $tables );
    1179. 

  1179. 		$table_fields = array_keys($result[$tablename]);
    1180. 

  1180. 		$string = '';
    1181. 

  1181. 		foreach($table_fields as $table_field){
    1182. 

  1182. 			$string .= '<++-++-++'.$table_field.'++-++-++>';
    1183. 

  1183. 			$string .= $rows[0]->$table_field;
    1184. 

  1184. 			$string .= '<endendend>';		
    1185. 

  1185. 		}
    1186. 

  1186. 		
    1187. 

  1187. 		$database->setQuery( "SELECT * FROM #__chrono_contact_emails WHERE formid='".$id."' ORDER BY emailid" );
    1188. 

  1188. 		$emails = $database->loadObjectList();
    1189. 

  1189. 		$tablename = $mainframe->getCfg('dbprefix')."chrono_contact_emails";
    1190. 

  1190. 		$tables = array( $tablename );
    1191. 

  1191. 		$result = $database->getTableFields( $tables );
    1192. 

  1192. 		$table_fields = array_keys($result[$tablename]);
    1193. 

  1193. 		$string2 = '';
    1194. 

  1194. 		foreach($emails as $email){
    1195. 

  1195. 			foreach($table_fields as $table_field){
    1196. 

  1196. 				$string2 .= '<2++-++-++'.$table_field.'++-++-++>';
    1197. 

  1197. 				$string2 .= $email->$table_field;
    1198. 

  1198. 				$string2 .= '<endendend2>';		
    1199. 

  1199. 			}
    1200. 

  1200. 			$string2 .= '<cf_email_separator>';
    1201. 

  1201. 		}
    1202. 

  1202. 		if (ereg('Opera(/| )([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
    1203. 

  1203. 			$UserBrowser = "Opera";
    1204. 

  1204. 		}
    1205. 

  1205. 		elseif (ereg('MSIE ([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
    1206. 

  1206. 			$UserBrowser = "IE";
    1207. 

  1207. 		} else {
    1208. 

  1208. 			$UserBrowser = '';
    1209. 

  1209. 		}
    1210. 

  1210. 		$mime_type = ($UserBrowser == 'IE' || $UserBrowser == 'Opera') ? 'application/octetstream' : 'application/octet-stream';
    1211. 

  1211. 		@ob_end_clean();
    1212. 

  1212. 		ob_start();
    1213. 

  1213. 	
    1214. 

  1214. 		header('Content-Type: ' . $mime_type);
    1215. 

  1215. 		header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
    1216. 

  1216. 	
    1217. 

  1217. 		if ($UserBrowser == 'IE') {
    1218. 

  1218. 			header('Content-Disposition: inline; filename="' . $rows[0]->name.'.cfbak"');
    1219. 

  1219. 			header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
    1220. 

  1220. 			header('Pragma: public');
    1221. 

  1221. 		}
    1222. 

  1222. 		else {
    1223. 

  1223. 			header('Content-Disposition: attachment; filename="' . $rows[0]->name.'.cfbak"');
    1224. 

  1224. 			header('Pragma: no-cache');
    1225. 

  1225. 		}
    1226. 

  1226. 		print $string.'
    1227. 

  1227. 		{cfbak_start_emails}
    1228. 

  1228. 		'.$string2.'
    1229. 

  1229. 		{cfbak_end_emails}';
    1230. 

  1230. 		exit();
    1231. 

  1231. 	
    1232. 

  1232. 	
    1233. 

  1233. 	}else{	
    1234. 

  1234. 		$doc = new DomDocument('1.0', 'UTF-8');
    1235. 

  1235. 		$root = $doc->createElement('root');
    1236. 

  1236. 		$root = $doc->appendChild($root);
    1237. 

  1237. 		
    1238. 

  1238. 		$database->setQuery( "SELECT * FROM #__chrono_contact" );
    1239. 

  1239. 		$forms = $database->loadObjectList();
    1240. 

  1240. 		$tablename = $mainframe->getCfg('dbprefix')."chrono_contact";
    1241. 

  1241. 		$tables = array( $tablename );
    1242. 

  1242. 		$result = $database->getTableFields( $tables );
    1243. 

  1243. 		$table_fields = array_keys($result[$tablename]);
    1244. 

  1244. 		
    1245. 

  1245. 		foreach($forms as $form){
    1246. 

  1246. 			$occ = $doc->createElement("form_".$form->name);
    1247. 

  1247. 			$occ = $root->appendChild($occ);
    1248. 

  1248. 			
    1249. 

  1249. 			foreach($table_fields as $table_field){
    1250. 

  1250. 				$child = $doc->createElement($table_field);
    1251. 

  1251. 				$child = $occ->appendChild($child);
    1252. 

  1252. 				$value = $doc->createTextNode($form->$table_field);
    1253. 

  1253. 				$value = $child->appendChild($value);
    1254. 

  1254. 			}
    1255. 

  1255. 			//list emails
    1256. 

  1256. 			$database->setQuery( "SELECT * FROM #__chrono_contact_emails WHERE formid='".$form->id."' ORDER BY emailid" );
    1257. 

  1257. 			$emails = $database->loadObjectList();
    1258. 

  1258. 			$tablename_email = $mainframe->getCfg('dbprefix')."chrono_contact_emails";
    1259. 

  1259. 			$tables_email = array( $tablename_email );
    1260. 

  1260. 			$result_email = $database->getTableFields( $tables_email );
    1261. 

  1261. 			$table_fields_email = array_keys($result_email[$tablename_email]);
    1262. 

  1262. 			
    1263. 

  1263. 			$child = $doc->createElement("emails");
    1264. 

  1264. 			$child = $occ->appendChild($child);
    1265. 

  1265. 			foreach($emails as $email){
    1266. 

  1266. 				$occ_email = $doc->createElement("email".$email->emailid);
    1267. 

  1267. 				$occ_email = $child->appendChild($occ_email);
    1268. 

  1268. 				
    1269. 

  1269. 				foreach($table_fields_email as $table_field_email){
    1270. 

  1270. 					$child_email = $doc->createElement($table_field_email);
    1271. 

  1271. 					$child_email = $occ_email->appendChild($child_email);
    1272. 

  1272. 					$value_email = $doc->createTextNode($email->$table_field_email);
    1273. 

  1273. 					$value_email = $child_email->appendChild($value_email);
    1274. 

  1274. 				}
    1275. 

  1275. 			}
    1276. 

  1276. 			//list plugins
    1277. 

  1277. 			$database->setQuery( "SELECT * FROM #__chrono_contact_plugins WHERE id='".$form->id."' ORDER BY id" );
    1278. 

  1278. 			$plugins = $database->loadObjectList();
    1279. 

  1279. 			$tablename_plugin = $mainframe->getCfg('dbprefix')."chrono_contact_plugins";
    1280. 

  1280. 			$tables_plugin = array( $tablename_plugin );
    1281. 

  1281. 			$result_plugin = $database->getTableFields( $tables_plugin );
    1282. 

  1282. 			$table_fields_plugin = array_keys($result_plugin[$tablename_plugin]);
    1283. 

  1283. 			
    1284. 

  1284. 			$child = $doc->createElement("plugins");
    1285. 

  1285. 			$child = $occ->appendChild($child);
    1286. 

  1286. 			foreach($plugins as $plugin){
    1287. 

  1287. 				$occ_plugin = $doc->createElement($plugin->name);
    1288. 

  1288. 				$occ_plugin = $child->appendChild($occ_plugin);
    1289. 

  1289. 				
    1290. 

  1290. 				foreach($table_fields_plugin as $table_field_plugin){
    1291. 

  1291. 					$child_plugin = $doc->createElement($table_field_plugin);
    1292. 

  1292. 					$child_plugin = $occ_plugin->appendChild($child_plugin);
    1293. 

  1293. 					$value_plugin = $doc->createTextNode($plugin->$table_field_plugin);
    1294. 

  1294. 					$value_plugin = $child_plugin->appendChild($value_plugin);
    1295. 

  1295. 				}
    1296. 

  1296. 			}
    1297. 

  1297. 		}
    1298. 

  1298. 		
    1299. 

  1299. 		$xml_string = $doc->saveXML();
    1300. 

  1300. 		
    1301. 

  1301. 		if (ereg('Opera(/| )([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
    1302. 

  1302. 			$UserBrowser = "Opera";
    1303. 

  1303. 		}
    1304. 

  1304. 		elseif (ereg('MSIE ([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
    1305. 

  1305. 			$UserBrowser = "IE";
    1306. 

  1306. 		} else {
    1307. 

  1307. 			$UserBrowser = '';
    1308. 

  1308. 		}
    1309. 

  1309. 		$mime_type = ($UserBrowser == 'IE' || $UserBrowser == 'Opera') ? 'application/octetstream' : 'application/octet-stream';
    1310. 

  1310. 		@ob_end_clean();
    1311. 

  1311. 		ob_start();
    1312. 

  1312. 	
    1313. 

  1313. 		header('Content-Type: ' . $mime_type);
    1314. 

  1314. 		header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
    1315. 

  1315. 	
    1316. 

  1316. 		if ($UserBrowser == 'IE') {
    1317. 

  1317. 			header('Content-Disposition: inline; filename="' . "ALL_".date('d_M_Y_H:i:s').'.cfxbak"');
    1318. 

  1318. 			header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
    1319. 

  1319. 			header('Pragma: public');
    1320. 

  1320. 		}
    1321. 

  1321. 		else {
    1322. 

  1322. 			header('Content-Disposition: attachment; filename="' . "ALL_".date('d_M_Y_H:i:s').'.cfxbak"');
    1323. 

  1323. 			header('Pragma: no-cache');
    1324. 

  1324. 		}
    1325. 

  1325. 		print $xml_string;
    1326. 

  1326. 		exit();
    1327. 

  1327. 	}
    1328. 

  1328. 	
    1329. 

  1329. 	/*if (ereg('Opera(/| )([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
    1330. 

  1330. 		$UserBrowser = "Opera";
    1331. 

  1331. 	}
    1332. 

  1332. 	elseif (ereg('MSIE ([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT'])) {
    1333. 

  1333. 		$UserBrowser = "IE";
    1334. 

  1334. 	} else {
    1335. 

  1335. 		$UserBrowser = '';
    1336. 

  1336. 	}
    1337. 

  1337. 	$mime_type = ($UserBrowser == 'IE' || $UserBrowser == 'Opera') ? 'application/octetstream' : 'application/octet-stream';
    1338. 

  1338. 	@ob_end_clean();
    1339. 

  1339. 	ob_start();
    1340. 

    1341. 

  1341. 	header('Content-Type: ' . $mime_type);
    1342. 

  1342. 	header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
    1343. 

    1344. 

  1344. 	if ($UserBrowser == 'IE') {
    1345. 

  1345. 		header('Content-Disposition: inline; filename="' . $rows[0]->name.'.cfbak"');
    1346. 

  1346. 		header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
    1347. 

  1347. 		header('Pragma: public');
    1348. 

  1348. 	}
    1349. 

  1349. 	else {
    1350. 

  1350. 		header('Content-Disposition: attachment; filename="' . $rows[0]->name.'.cfbak"');
    1351. 

  1351. 		header('Pragma: no-cache');
    1352. 

  1352. 	}
    1353. 

  1353. 	print $string.'
    1354. 

  1354. 	{cfbak_start_emails}
    1355. 

  1355. 	'.$string2.'
    1356. 

  1356. 	{cfbak_end_emails}';
    1357. 

  1357. 	exit();
    1358. 

  1358. 	*/
    1359. 

  1359. }
    1360. 

  1360. function restore1ChronoContact( $id, $option ){
    1361. 

  1361. 	HTML_ChronoContact::restoreChronoContact( $id, $option );
    1362. 

  1362. }
    1363. 

  1363. function restore2ChronoContact( $id, $option ){
    1364. 

  1364. global $mainframe;	
    1365. 

  1365. 	$database =& JFactory::getDBO();
    1366. 

  1366. 	jimport('joomla.utilities.error');
    1367. 

  1367. 	jimport('joomla.filesystem.file');
    1368. 

  1368. 	$id = JRequest::getVar('formid');
    1369. 

  1369. 	//echo $_FILES['file']['type'];
    1370. 

  1370. 	if(is_array(JRequest::getVar( 'file', '', 'files', 'array' ))){
    1371. 

  1371. 		$file = JRequest::getVar( 'file', '', 'files', 'array' );
    1372. 

  1372. 		$filename = $file['name'];
    1373. 

  1373. 		$exten = explode(".",$filename);
    1374. 

  1374. 		if($exten[count($exten)-1] == 'cfbak'){
    1375. 

  1375. 		//if($_FILES['file']['type'] == "application/octet-stream"){
    1376. 

  1376. 			//$filename = $_FILES['file']['name'];
    1377. 

  1377. 			
    1378. 

  1378. 			$path = JPATH_BASE.DS.'cache';
    1379. 

  1379. 			$uploadedfile = JFile::upload($file['tmp_name'], $path.DS.$filename);
    1380. 

  1380. 			//if( is_writable($path) ) {	
    1381. 

  1381. 				if(!$uploadedfile) {
    1382. 

  1382. 					print "<fon…
    1383.

Large files files are truncated, but you can click here to view the full file