PageRenderTime 60ms CodeModel.GetById 24ms RepoModel.GetById 0ms app.codeStats 1ms

/editor/view-thank.php

https://bitbucket.org/3tierlogic/3tl.tabbuilder
PHP | 290 lines | 231 code | 46 blank | 13 comment | 12 complexity | 43f9a650044c0d03cef2dba6892ae9e4 MD5 | raw file
    

  1. <?php
    2. 

  2. 

  3. 	// includes
    4. 

  4. 	require_once('config.php');
    5. 

  5. 	require_once('functions.php');
    6. 

  6. 

  7. 	session_start();
    8. 

  8. 

  9. 	$appId = $_SESSION['appId'];
    10. 

  10. 	$secret = $_SESSION['appSecret'];
    11. 

  11. 	$page_id = $_SESSION['page_id'];
    12. 

  12. 

  13. 	if ( ! isset( $appId ) || ! isset( $secret ) || ! isset( $page_id ) ) exit();
    14. 

  14. 

  15. 	// get tab to show
    16. 

  16. 	$query = "SELECT id FROM pages WHERE fan_page_id = '".$page_id."' AND app_id = '".$appId."'
    17. 

  17. 							AND published = '1' LIMIT 1 ";
    18. 

  18. 	$query = mysql_query( $query ) or exit( mysql_error() );
    19. 

  19. 

  20. 	// if tab is published - show it
    21. 

  21. 	if ( mysql_num_rows( $query ) > 0 ) {
    22. 

  22. 		$tabId = mysql_result( $query, 0 );
    23. 

  23. 		$tab = ars_getPageInfo( $tabId );
    24. 

  24. 	}
    25. 

  25. 

  26. 	// when user enters a contest, but has no more entries, he is redirected to "thank you" page
    27. 

  27. 	// in order not to create an empty record in DB, we clear 'campaign_id' field
    28. 

  28. 	// so if it is empty, we don't need to save any data
    29. 

  29. 	if ( $_REQUEST['campaign_id'] != '' ) {
    30. 

  30. 

  31. 		// DECLARE VARIABLES
    32. 

  32. 		$firstName = '';
    33. 

  33. 		$lastName = '';
    34. 

  34. 		$city = '';
    35. 

  35. 		$state = '';
    36. 

  36. 		$email = '';
    37. 

  37. 		$address = '';
    38. 

  38. 		$zipCode = '';
    39. 

  39. 		$cellPhone = '';
    40. 

  40. 		$homePhone = '';
    41. 

  41. 		$cellularCarrier = '';
    42. 

  42. 		$gender = '';
    43. 

  43. 		$country = '';
    44. 

  44. 		$birthYear = '';
    45. 

  45. 		$birthMonth = '';
    46. 

  46. 		$birthDay = '';
    47. 

  47. 		$birthDate = '';
    48. 

  48. 		$optInSms = 'no';
    49. 

  49. 		$optInEmail = 'no';
    50. 

  50. 		$openText1 = $openText2 = $openText3 = $openText4 = $openText5 = '';
    51. 

  51. 		$openText6 = $openText7 = $openText8 = $openText9 = $openText10 = '';
    52. 

  52. 		$openTextarea1 = $openTextarea2 = $openTextarea3 = $openTextarea4 = $openTextarea5 = '';
    53. 

  53. 		$openTextarea6 = $openTextarea7 = $openTextarea8 = $openTextarea9 = $openTextarea10 = '';
    54. 

  54. 		$openSelect1 = $openSelect2 = $openSelect3 = $openSelect4 = $openSelect5 = '';
    55. 

  55. 		$openSelect6 = $openSelect7 = $openSelect8 = $openSelect9 = $openSelect10 = '';
    56. 

  56. 		$openCheckbox1 = $openCheckbox2 = $openCheckbox3 = $openCheckbox4 = $openCheckbox5 = '';
    57. 

  57. 		$openCheckbox6 = $openCheckbox7 = $openCheckbox8 = $openCheckbox9 = $openCheckbox10 = '';
    58. 

  58. 		$openRadio1 = $openRadio2 = $openRadio3 = $openRadio4 = $openRadio5 = '';
    59. 

  59. 		$openRadio6 = $openRadio7 = $openRadio8 = $openRadio9 = $openRadio10 = '';
    60. 

  60. 

  61. 

  62. 		// GET SENT VALUES
    63. 

  63. 		foreach ( $_POST as $key => $value ) {
    64. 

  64. 			$value = escapeStr( $value );
    65. 

  65. 

  66. 			switch ( $key ) {
    67. 

  67. 				case 'First_Name': $firstName = $value; break;
    68. 

  68. 				case 'Last_Name': $lastName = $value; break;
    69. 

  69. 				case 'City': $city = $value; break;
    70. 

  70. 				case 'State': $state = $value; break;
    71. 

  71. 				case 'Email': $email = $value; break;
    72. 

  72. 				case 'Address': $address = $value; break;
    73. 

  73. 				case 'Zip_Code': $zipCode = $value; break;
    74. 

  74. 				case 'Cell_Phone': $cellPhone = $value; break;
    75. 

  75. 				case 'Home_Phone': $homePhone = $value; break;
    76. 

  76. 				case 'Cellular_Carrier': $cellularCarrier = $value; break;
    77. 

  77. 				case 'Gender': $gender = $value; break;
    78. 

  78. 				case 'Country': $country = $value; break;
    79. 

  79. 				case 'Birthday_Year': $birthYear = $value; break;
    80. 

  80. 				case 'Birthday_Month': $birthMonth = $value; break;
    81. 

  81. 				case 'Birthday_Day': $birthDay = $value; break;
    82. 

  82. 

  83. 				case 'SMS_opt_in': $optInSms = 'yes'; break;
    84. 

  84. 				case 'Email_opt_in': $optInEmail = 'yes'; break;
    85. 

  85. 

  86. 				case 'Text_Open_Field_1': $openText1 = $value; break;
    87. 

  87. 				case 'Text_Open_Field_2': $openText2 = $value; break;
    88. 

  88. 				case 'Text_Open_Field_3': $openText3 = $value; break;
    89. 

  89. 				case 'Text_Open_Field_4': $openText4 = $value; break;
    90. 

  90. 				case 'Text_Open_Field_5': $openText5 = $value; break;
    91. 

  91. 				case 'Text_Open_Field_6': $openText6 = $value; break;
    92. 

  92. 				case 'Text_Open_Field_7': $openText7 = $value; break;
    93. 

  93. 				case 'Text_Open_Field_8': $openText8 = $value; break;
    94. 

  94. 				case 'Text_Open_Field_9': $openText9 = $value; break;
    95. 

  95. 				case 'Text_Open_Field_10': $openText10 = $value; break;
    96. 

  96. 

  97. 				case 'Textarea_Open_Field_1': $openTextarea1 = $value; break;
    98. 

  98. 				case 'Textarea_Open_Field_2': $openTextarea2 = $value; break;
    99. 

  99. 				case 'Textarea_Open_Field_3': $openTextarea3 = $value; break;
    100. 

  100. 				case 'Textarea_Open_Field_4': $openTextarea4 = $value; break;
    101. 

  101. 				case 'Textarea_Open_Field_5': $openTextarea5 = $value; break;
    102. 

  102. 				case 'Textarea_Open_Field_6': $openTextarea6 = $value; break;
    103. 

  103. 				case 'Textarea_Open_Field_7': $openTextarea7 = $value; break;
    104. 

  104. 				case 'Textarea_Open_Field_8': $openTextarea8 = $value; break;
    105. 

  105. 				case 'Textarea_Open_Field_9': $openTextarea9 = $value; break;
    106. 

  106. 				case 'Textarea_Open_Field_10': $openTextarea10 = $value; break;
    107. 

  107. 

  108. 				case 'Select_Open_Field_1': $openSelect1 = $value; break;
    109. 

  109. 				case 'Select_Open_Field_2': $openSelect2 = $value; break;
    110. 

  110. 				case 'Select_Open_Field_3': $openSelect3 = $value; break;
    111. 

  111. 				case 'Select_Open_Field_4': $openSelect4 = $value; break;
    112. 

  112. 				case 'Select_Open_Field_5': $openSelect5 = $value; break;
    113. 

  113. 				case 'Select_Open_Field_6': $openSelect6 = $value; break;
    114. 

  114. 				case 'Select_Open_Field_7': $openSelect7 = $value; break;
    115. 

  115. 				case 'Select_Open_Field_8': $openSelect8 = $value; break;
    116. 

  116. 				case 'Select_Open_Field_9': $openSelect9 = $value; break;
    117. 

  117. 				case 'Select_Open_Field_10': $openSelect10 = $value; break;
    118. 

  118. 

  119. 				case 'Checkbox_Open_Field_1': $openCheckbox1 = $value; break;
    120. 

  120. 				case 'Checkbox_Open_Field_2': $openCheckbox2 = $value; break;
    121. 

  121. 				case 'Checkbox_Open_Field_3': $openCheckbox3 = $value; break;
    122. 

  122. 				case 'Checkbox_Open_Field_4': $openCheckbox4 = $value; break;
    123. 

  123. 				case 'Checkbox_Open_Field_5': $openCheckbox5 = $value; break;
    124. 

  124. 				case 'Checkbox_Open_Field_6': $openCheckbox6 = $value; break;
    125. 

  125. 				case 'Checkbox_Open_Field_7': $openCheckbox7 = $value; break;
    126. 

  126. 				case 'Checkbox_Open_Field_8': $openCheckbox8 = $value; break;
    127. 

  127. 				case 'Checkbox_Open_Field_9': $openCheckbox9 = $value; break;
    128. 

  128. 				case 'Checkbox_Open_Field_10': $openCheckbox10 = $value; break;
    129. 

  129. 

  130. 				case 'Radio_Open_Field_1': $openRadio1 = $value; break;
    131. 

  131. 				case 'Radio_Open_Field_2': $openRadio2 = $value; break;
    132. 

  132. 				case 'Radio_Open_Field_3': $openRadio3 = $value; break;
    133. 

  133. 				case 'Radio_Open_Field_4': $openRadio4 = $value; break;
    134. 

  134. 				case 'Radio_Open_Field_5': $openRadio5 = $value; break;
    135. 

  135. 				case 'Radio_Open_Field_6': $openRadio6 = $value; break;
    136. 

  136. 				case 'Radio_Open_Field_7': $openRadio7 = $value; break;
    137. 

  137. 				case 'Radio_Open_Field_8': $openRadio8 = $value; break;
    138. 

  138. 				case 'Radio_Open_Field_9': $openRadio9 = $value; break;
    139. 

  139. 				case 'Radio_Open_Field_10': $openRadio10 = $value; break;
    140. 

  140. 			} // switch
    141. 

  141. 		} // foreach
    142. 

  142. 

  143. 		if ( ! empty( $birthYear ) && ! empty( $birthMonth ) && ! empty( $birthDay ) )
    144. 

  144. 			$birthDate = $birthYear . '-' . $birthMonth . '-' . $birthDay;
    145. 

  145. 

  146. 

  147. 		// STORE FORM DATA
    148. 

  148. 		mysql_query("INSERT INTO sp_campaign_result VALUES ( 0,
    149. 

  149. 									'".$_REQUEST['campaign_id']."',
    150. 

  150. 									'".$_REQUEST['user_fb_id']."',
    151. 

  151. 									'".$_SERVER['REMOTE_ADDR']."',
    152. 

  152. 									'',
    153. 

  153. 									'".$firstName."',
    154. 

  154. 									'".$lastName."',
    155. 

  155. 									'".$gender."',
    156. 

  156. 									'".$birthYear."',
    157. 

  157. 									'".$birthMonth."',
    158. 

  158. 									'".$birthDay."',
    159. 

  159. 									'".$birthDate."',
    160. 

  160. 									'".$cellPhone."',
    161. 

  161. 									'".$homePhone."',
    162. 

  162. 									'".$cellularCarrier."',
    163. 

  163. 									'".$email."',
    164. 

  164. 									'".$address."',
    165. 

  165. 									'".$city."',
    166. 

  166. 									'".$state."',
    167. 

  167. 									'".$country."',
    168. 

  168. 									'".$zipCode."',
    169. 

  169. 									'".$optInSms."',
    170. 

  170. 									'".$optInEmail."',
    171. 

  171. 

  172. 									'".$openText1."', '".$openText2."', '".$openText3."', '".$openText4."', '".$openText5."',
    173. 

  173. 									'".$openText6."', '".$openText7."', '".$openText8."', '".$openText9."', '".$openText10."',
    174. 

  174. 

  175. 									'".$openTextarea1."', '".$openTextarea2."', '".$openTextarea3."', '".$openTextarea4."',
    176. 

  176. 									'".$openTextarea5."', '".$openTextarea6."', '".$openTextarea7."', '".$openTextarea8."',
    177. 

  177. 									'".$openTextarea9."', '".$openTextarea10."',
    178. 

  178. 

  179. 									'".$openSelect1."', '".$openSelect2."', '".$openSelect3."', '".$openSelect4."', '".$openSelect5."',
    180. 

  180. 									'".$openSelect6."', '".$openSelect7."', '".$openSelect8."', '".$openSelect9."', '".$openSelect10."',
    181. 

  181. 

  182. 									'".$openCheckbox1."', '".$openCheckbox2."', '".$openCheckbox3."', '".$openCheckbox4."',
    183. 

  183. 									'".$openCheckbox5."', '".$openCheckbox6."', '".$openCheckbox7."', '".$openCheckbox8."',
    184. 

  184. 									'".$openCheckbox9."', '".$openCheckbox10."',
    185. 

  185. 

  186. 									'".$openRadio1."', '".$openRadio2."', '".$openRadio3."', '".$openRadio4."', '".$openRadio5."',
    187. 

  187. 									'".$openRadio6."', '".$openRadio7."', '".$openRadio8."', '".$openRadio9."', '".$openRadio10."',
    188. 

  188. 

  189. 									'', '', '', '', '', '', '', '', '', '',
    190. 

  190. 									NOW()
    191. 

  191. 									);") or exit( mysql_error() );
    192. 

    193. 

  193. 

  194. 		// STORE UGC DATA
    195. 

  195. 		if ( $_REQUEST['save-ugc'] == '1' ) {
    196. 

  196. 

  197. 			// get the last record form sp_campaign_result
    198. 

  198. 			$query = "SELECT * FROM sp_campaign_result ORDER BY cpresult_sid DESC LIMIT 1";
    199. 

  199. 			$query = mysql_query( $query ) or exit( mysql_error() );
    200. 

  200. 			$lastRecord = mysql_fetch_assoc( $query );
    201. 

  201. 

  202. 			list( $photoWidth, $photoHeight ) = getimagesize( $_REQUEST['ugc_photo_path'] );
    203. 

  203. 

  204. 			mysql_query("INSERT INTO sp_campaign_ugc VALUES ( 0,
    205. 

  205. 										'".$_REQUEST['ugc_photo_name']."',
    206. 

  206. 										'".$_REQUEST['ugc_original_photo_name']."',
    207. 

  207. 										'".$_REQUEST['campaign_id']."',
    208. 

  208. 										NOW(), '', '',
    209. 

  209. 										'".$_REQUEST['user_fb_id']."',
    210. 

  210. 										'".$lastRecord['cpresult_sid']."',
    211. 

  211. 										'".escapeStr( $_REQUEST['UGC_Title'] )."',
    212. 

  212. 										'".escapeStr( $_REQUEST['UGC_Description'] )."',
    213. 

  213. 										'',
    214. 

  214. 										'photo',
    215. 

  215. 										'en',
    216. 

  216. 										'', '',
    217. 

  217. 										'".$photoWidth."',
    218. 

  218. 										'".$photoHeight."'
    219. 

  219. 										);") or exit( mysql_error() );
    220. 

    221. 

  221. 			// save uploaded ugc photo
    222. 

  222. 			mysql_query("UPDATE pages SET saved = '1'
    223. 

  223. 										WHERE type = 'ugc' AND name = '".$_REQUEST['ugc_photo_name']."'
    224. 

  224. 										") or exit( mysql_error() );
    225. 

  225. 		} // store ugc data
    226. 

  226. 

  227. 	} // no need to save any data
    228. 

  228. 

  229. ?><!doctype html>
    230. 

  230. <html lang="en-US" xmlns:fb="https://www.facebook.com/2008/fbml">
    231. 

  231. <head>
    232. 

  232. <meta charset="UTF-8" />
    233. 

  233. <title><?php echo $tab['name']; ?></title>
    234. 

  234. <link rel="stylesheet" href="css/style.css?v=1.01" />
    235. 

  235. <script src="js/jquery.1.7.js"></script>
    236. 

  236. <script src="js/jquery.countdown.min.js"></script>
    237. 

  237. <script src="js/fb.js"></script>
    238. 

  238. <script src="js/both.js"></script>
    239. 

  239. <script src="https://widgets.twimg.com/j/2/widget.js"></script>
    240. 

  240. <script src="https://apis.google.com/js/plusone.js"></script>
    241. 

  241. <script src="https://maps.google.com/maps/api/js?sensor=false"></script>
    242. 

  242. <style>* { margin: 0; padding: 0; }</style>
    243. 

  243. <script>
    244. 

  244. $(window).load( function() {
    245. 

  245. 

  246. 	// DISPLAY WIDGETS
    247. 

  247. 	displayWidgetsOnload( $('.pageBody') );
    248. 

  248. 

  249. });
    250. 

  250. </script>
    251. 

  251. </head>
    252. 

  252. 

  253. 

  254. 

  255. <body class="fb-view">
    256. 

  256. 

  257. 	<!-- include Javascript SDK -->
    258. 

  258. 	<div id="fb-root"></div>
    259. 

  259. 	<script>jsSDK();</script>
    260. 

  260. 

  261. 	<div id="includes">
    262. 

  262. 		<div class="appId"><?php echo $appId; ?></div>
    263. 

  263. 		<div class="pageId"><?php echo $page_id; ?></div>
    264. 

  264. 		<div class="signedRequest"><?php echo $signed_request; ?></div>
    265. 

  265. 		<div class="appLink"><?php echo $_SESSION['appLink']; ?></div>
    266. 

  266. 	</div><!-- / .includes -->
    267. 

  267. 

  268. 	<?php echo $tab['content_contest_thank']; ?>
    269. 

  269. 	
    270. 

  270. 	<script>
    271. 

  271. 

  272. 		window.fbAsyncInit = function() {
    273. 

  273. 			FB.init({
    274. 

  274. 				appId  : $appId,
    275. 

  275. 				status : true,
    276. 

  276. 				cookie : true,
    277. 

  277. 				xfbml  : true
    278. 

  278. 			});
    279. 

  279. 		};
    280. 

  280. 

  281. 		(function() {
    282. 

  282. 			var e = document.createElement('script');
    283. 

  283. 			e.src = document.location.protocol + '//connect.facebook.net/en_US/all.js#xfbml=1&appId=<?php echo $appId; ?>';
    284. 

  284. 			e.async = true;
    285. 

  285. 			document.getElementById('fb-root').appendChild(e);
    286. 

  286. 		}());
    287. 

  287. 

  288. 	</script>
    289. 

  289. </body>
    290. 

  290. </html>
    291.