Contact Bank: WordPress Form Builder for Contact Forms - Version 2.0.18

Version Description

  • Bugs Fixed
  • Compatibility to 3.9
Download this release

Release Info

Developer contact-banker
Plugin Icon 128x128 Contact Bank: WordPress Form Builder for Contact Forms
Version 2.0.18
Comparing to
See all releases

Code changes from version 2.0.17 to 2.0.18

Files changed (9) hide show
  1. contact-bank.php +2 -5
  2. lib/contact_view-class.php +13 -34
  3. lib/install-script.php +13 -40
  4. readme.txt +8 -3
  5. views/contact_bank_layout_settings.php +1 -4
  6. views/contact_email_settings.php +5 -10
  7. views/contact_frontend_data.php +1 -4
  8. views/contact_view.php +5 -11
  9. views/dashboard.php +3 -13
contact-bank.php CHANGED
@@ -4,7 +4,7 @@ Plugin Name: Contact Bank Standard Edition
4
  Plugin URI: http://tech-banker.com
5
  Description: Build Complex, Powerful Contact Forms in Just Seconds. No Programming Knowledge Required! Yeah, It's Really That Easy.
6
  Author: Tech Banker
7
- Version: 2.0.17
8
  Author URI: http://tech-banker.com
9
  */
10
  ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
@@ -402,10 +402,7 @@ function add_contact_mce_popup(){
402
  global $wpdb;
403
  $forms = $wpdb->get_results
404
  (
405
- $wpdb->prepare
406
- (
407
- "SELECT * FROM " .contact_bank_contact_form(),""
408
- )
409
  );
410
  for($flag = 0;$flag<count($forms);$flag++)
411
  {
4
  Plugin URI: http://tech-banker.com
5
  Description: Build Complex, Powerful Contact Forms in Just Seconds. No Programming Knowledge Required! Yeah, It's Really That Easy.
6
  Author: Tech Banker
7
+ Version: 2.0.18
8
  Author URI: http://tech-banker.com
9
  */
10
  ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
402
  global $wpdb;
403
  $forms = $wpdb->get_results
404
  (
405
+ "SELECT * FROM " .contact_bank_contact_form()
 
 
 
406
  );
407
  for($flag = 0;$flag<count($forms);$flag++)
408
  {
lib/contact_view-class.php CHANGED
@@ -177,61 +177,40 @@ else
177
  global $wpdb;
178
  $wpdb->query
179
  (
180
- $wpdb->prepare
181
- (
182
- "TRUNCATE Table ".contact_bank_dynamic_settings_form(),""
183
- )
184
- );
185
  $wpdb->query
186
  (
187
- $wpdb->prepare
188
- (
189
- "TRUNCATE Table ".contact_bank_email_template_admin(),""
190
- )
191
  );
192
  $wpdb->query
193
  (
194
- $wpdb->prepare
195
- (
196
- "TRUNCATE Table ".contact_bank_form_settings_Table(),""
197
- )
198
  );
199
  $wpdb->query
200
  (
201
- $wpdb->prepare
202
- (
203
- "TRUNCATE Table ".frontend_controls_data_Table(),""
204
- )
205
  );
206
  $wpdb->query
207
  (
208
- $wpdb->prepare
209
- (
210
- "TRUNCATE Table ".contact_bank_frontend_forms_Table(),""
211
- )
212
  );
213
  $wpdb->query
214
  (
215
- $wpdb->prepare
216
- (
217
- "TRUNCATE Table ".contact_bank_layout_settings_Table(),""
218
- )
219
  );
220
 
221
  $wpdb->query
222
  (
223
- $wpdb->prepare
224
- (
225
- "TRUNCATE Table ".create_control_Table(),""
226
- )
227
  );
228
  $wpdb->query
229
  (
230
- $wpdb->prepare
231
- (
232
- "TRUNCATE Table ".contact_bank_contact_form(),""
233
- )
234
- );
235
  die();
236
  }
237
  else if($_REQUEST["param"] == "submit_form_messages_settings")
177
  global $wpdb;
178
  $wpdb->query
179
  (
180
+ "TRUNCATE Table ".contact_bank_dynamic_settings_form()
181
+ );
 
 
 
182
  $wpdb->query
183
  (
184
+ "TRUNCATE Table ".contact_bank_email_template_admin()
 
 
 
185
  );
186
  $wpdb->query
187
  (
188
+ "TRUNCATE Table ".contact_bank_form_settings_Table()
 
 
 
189
  );
190
  $wpdb->query
191
  (
192
+ "TRUNCATE Table ".frontend_controls_data_Table()
193
+
 
 
194
  );
195
  $wpdb->query
196
  (
197
+ "TRUNCATE Table ".contact_bank_frontend_forms_Table()
198
+
 
 
199
  );
200
  $wpdb->query
201
  (
202
+ "TRUNCATE Table ".contact_bank_layout_settings_Table()
203
+
 
 
204
  );
205
 
206
  $wpdb->query
207
  (
208
+ "TRUNCATE Table ".create_control_Table()
 
 
 
209
  );
210
  $wpdb->query
211
  (
212
+ "TRUNCATE Table ".contact_bank_contact_form()
213
+ );
 
 
 
214
  die();
215
  }
216
  else if($_REQUEST["param"] == "submit_form_messages_settings")
lib/install-script.php CHANGED
@@ -17,10 +17,7 @@ if($version == "" || $version == "1.0")
17
  {
18
  $contact_forms = $wpdb->get_results
19
  (
20
- $wpdb->prepare
21
- (
22
- "SELECT * FROM ".contact_bank_contact_form(),""
23
- )
24
  );
25
  $sql = "DROP TABLE " . contact_bank_contact_form();
26
  $wpdb->query($sql);
@@ -111,10 +108,9 @@ if($version == "" || $version == "1.0")
111
  {
112
  $contact_forms_controls = $wpdb->get_results
113
  (
114
- $wpdb->prepare
115
- (
116
- "SELECT * FROM ".create_control_Table()." where field_id not in (9,12,13,14,15)",""
117
- )
118
  );
119
 
120
  $sql = "DROP TABLE " . create_control_Table();
@@ -150,11 +146,7 @@ if($version == "" || $version == "1.0")
150
  {
151
  $contact_forms_dynamic_settings = $wpdb->get_results
152
  (
153
- $wpdb->prepare
154
- (
155
- "SELECT * FROM ". contact_bank_dynamic_settings_form(). " JOIN " . create_control_Table(). " ON " . contact_bank_dynamic_settings_form().".dynamicId = ". create_control_Table(). ".column_dynamicId",
156
- ""
157
- )
158
  );
159
  $contact_forms_email_dynamic_settings = $wpdb->get_results
160
  (
@@ -261,10 +253,7 @@ if($version == "" || $version == "1.0")
261
  {
262
  $contact_forms_emails = $wpdb->get_results
263
  (
264
- $wpdb->prepare
265
- (
266
- "SELECT * FROM ".contact_bank_email_template_admin(),""
267
- )
268
  );
269
 
270
  $sql = "DROP TABLE " . contact_bank_email_template_admin();
@@ -281,8 +270,8 @@ if($version == "" || $version == "1.0")
281
  $wpdb->prepare
282
  (
283
  "INSERT INTO " . contact_bank_email_template_admin() . "(email_id, email_to, email_from,
284
- body_content, subject, send_to, form_id, from_name, reply_to, cc, bcc, name) VALUES(%d, %s,
285
- %s, %s, %s, %d, %d, %s, %s, %s, %s, %s)",
286
  $contact_forms_emails[$flag]->email_id,
287
  $contact_forms_emails[$flag]->email_to,
288
  $contact_forms_emails[$flag]->email_from,
@@ -309,10 +298,7 @@ if($version == "" || $version == "1.0")
309
  {
310
  $contact_front_end_forms = $wpdb->get_results
311
  (
312
- $wpdb->prepare
313
- (
314
- "SELECT * FROM ".contact_bank_frontend_forms_Table(),""
315
- )
316
  );
317
 
318
  $sql = "DROP TABLE " . contact_bank_frontend_forms_Table();
@@ -342,11 +328,7 @@ if($version == "" || $version == "1.0")
342
  {
343
  $contact_front_end_forms_data = $wpdb->get_results
344
  (
345
- $wpdb->prepare
346
- (
347
- "SELECT * FROM ".frontend_controls_data_Table() . " JOIN " . create_control_Table(). " ON " . frontend_controls_data_Table().".dynamic_control_id = ". create_control_Table(). ".column_dynamicId",
348
- ""
349
- )
350
  );
351
 
352
  $sql = "DROP TABLE " . frontend_controls_data_Table();
@@ -432,10 +414,7 @@ if($version == "" || $version == "1.0")
432
 
433
  $contact_forms_for_settings = $wpdb->get_results
434
  (
435
- $wpdb->prepare
436
- (
437
- "SELECT * FROM ".contact_bank_contact_form(),""
438
- )
439
  );
440
  for($flag = 0; $flag < count($contact_forms_for_settings); $flag++)
441
  {
@@ -536,10 +515,7 @@ else if($version == "2.0")
536
  {
537
  $contact_forms_settings_table = $wpdb->get_results
538
  (
539
- $wpdb->prepare
540
- (
541
- "SELECT * FROM ".contact_bank_form_settings_Table(),""
542
- )
543
  );
544
 
545
  $sql = "DROP TABLE " . contact_bank_form_settings_Table();
@@ -548,10 +524,7 @@ else if($version == "2.0")
548
 
549
  $contact_forms_count = $wpdb->get_results
550
  (
551
- $wpdb->prepare
552
- (
553
- "SELECT * FROM ".contact_bank_contact_form(),""
554
- )
555
  );
556
 
557
 
17
  {
18
  $contact_forms = $wpdb->get_results
19
  (
20
+ "SELECT * FROM ".contact_bank_contact_form()
 
 
 
21
  );
22
  $sql = "DROP TABLE " . contact_bank_contact_form();
23
  $wpdb->query($sql);
108
  {
109
  $contact_forms_controls = $wpdb->get_results
110
  (
111
+
112
+ "SELECT * FROM ".create_control_Table()." where field_id not in (9,12,13,14,15)"
113
+
 
114
  );
115
 
116
  $sql = "DROP TABLE " . create_control_Table();
146
  {
147
  $contact_forms_dynamic_settings = $wpdb->get_results
148
  (
149
+ "SELECT * FROM ". contact_bank_dynamic_settings_form(). " JOIN " . create_control_Table(). " ON " . contact_bank_dynamic_settings_form().".dynamicId = ". create_control_Table(). ".column_dynamicId"
 
 
 
 
150
  );
151
  $contact_forms_email_dynamic_settings = $wpdb->get_results
152
  (
253
  {
254
  $contact_forms_emails = $wpdb->get_results
255
  (
256
+ "SELECT * FROM ".contact_bank_email_template_admin()
 
 
 
257
  );
258
 
259
  $sql = "DROP TABLE " . contact_bank_email_template_admin();
270
  $wpdb->prepare
271
  (
272
  "INSERT INTO " . contact_bank_email_template_admin() . "(email_id, email_to, email_from,
273
+ body_content, subject, send_to, form_id, from_name, reply_to, cc, bcc, name) VALUES(%d, %s,
274
+ %s, %s, %s, %d, %d, %s, %s, %s, %s, %s)",
275
  $contact_forms_emails[$flag]->email_id,
276
  $contact_forms_emails[$flag]->email_to,
277
  $contact_forms_emails[$flag]->email_from,
298
  {
299
  $contact_front_end_forms = $wpdb->get_results
300
  (
301
+ "SELECT * FROM ".contact_bank_frontend_forms_Table()
 
 
 
302
  );
303
 
304
  $sql = "DROP TABLE " . contact_bank_frontend_forms_Table();
328
  {
329
  $contact_front_end_forms_data = $wpdb->get_results
330
  (
331
+ "SELECT * FROM ".frontend_controls_data_Table() . " JOIN " . create_control_Table(). " ON " . frontend_controls_data_Table().".dynamic_control_id = ". create_control_Table(). ".column_dynamicId"
 
 
 
 
332
  );
333
 
334
  $sql = "DROP TABLE " . frontend_controls_data_Table();
414
 
415
  $contact_forms_for_settings = $wpdb->get_results
416
  (
417
+ "SELECT * FROM ".contact_bank_contact_form()
 
 
 
418
  );
419
  for($flag = 0; $flag < count($contact_forms_for_settings); $flag++)
420
  {
515
  {
516
  $contact_forms_settings_table = $wpdb->get_results
517
  (
518
+ "SELECT * FROM ".contact_bank_form_settings_Table()
 
 
 
519
  );
520
 
521
  $sql = "DROP TABLE " . contact_bank_form_settings_Table();
524
 
525
  $contact_forms_count = $wpdb->get_results
526
  (
527
+ "SELECT * FROM ".contact_bank_contact_form()
 
 
 
528
  );
529
 
530
 
readme.txt CHANGED
@@ -2,8 +2,8 @@
2
  Contributors: contact-banker, Gallery-Bank
3
  Tags: admin, advanced form, AJAX, best contact form plugin, buddypress, category, comment, comments, contact, contact bank, contact form, contact form 7, contact form builder, contact form plugin, contact forms, contact me, contact us, contacts, content, easy contact form, easy contact plugin, email, Facebook, feed, feedback, feedback form, form, form builder, forms, gallery, google, image, images, javascript, jquery, link, links, login, media, page, pages, plugin, Post, posts, request, rss, seo, shortcode, sidebar, stats, text, web form, widget, wordpress
4
  Requires at least: 3.3
5
- Tested up to: 3.8.3
6
- Stable tag: 2.0.17
7
  License: GPLv2 or later
8
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
9
 
@@ -26,7 +26,7 @@ It provides a powerful engine for uploading and managing dynamic forms with more
26
 
27
  ***The Contact Bank WordPress Plugin is now proudly maintained by <a href="http://www.tech-banker.com">Tech Banker Pte Ltd.</a> since March 2014.***
28
 
29
- ***April 15, 2014: We're happy to announce that Contact Bank reached 23,900+ plugin downloads in only 6 months. We frequently receive positive feedback from people using our Contact Bank Plugin for WordPress. Thanks so much for your support!***
30
 
31
  <a href="http://tech-banker.com/forum/contact-bank-support/" target="_blank">Support Desk - feel free to ask your Queries</a>
32
 
@@ -137,6 +137,11 @@ Visit [here](http://tech-banker.com/contact-bank) to upgrade to Pro Version now.
137
 
138
  == Changelog ==
139
 
 
 
 
 
 
140
  = 2.0.17 =
141
 
142
  * Compatibility to 3.8.3
2
  Contributors: contact-banker, Gallery-Bank
3
  Tags: admin, advanced form, AJAX, best contact form plugin, buddypress, category, comment, comments, contact, contact bank, contact form, contact form 7, contact form builder, contact form plugin, contact forms, contact me, contact us, contacts, content, easy contact form, easy contact plugin, email, Facebook, feed, feedback, feedback form, form, form builder, forms, gallery, google, image, images, javascript, jquery, link, links, login, media, page, pages, plugin, Post, posts, request, rss, seo, shortcode, sidebar, stats, text, web form, widget, wordpress
4
  Requires at least: 3.3
5
+ Tested up to: 3.9
6
+ Stable tag: 2.0.18
7
  License: GPLv2 or later
8
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
9
 
26
 
27
  ***The Contact Bank WordPress Plugin is now proudly maintained by <a href="http://www.tech-banker.com">Tech Banker Pte Ltd.</a> since March 2014.***
28
 
29
+ ***April 17, 2014: We're happy to announce that Contact Bank reached 24,800+ plugin downloads in only 6 months. We frequently receive positive feedback from people using our Contact Bank Plugin for WordPress. Thanks so much for your support!***
30
 
31
  <a href="http://tech-banker.com/forum/contact-bank-support/" target="_blank">Support Desk - feel free to ask your Queries</a>
32
 
137
 
138
  == Changelog ==
139
 
140
+ = 2.0.18 =
141
+
142
+ * Bugs Fixed
143
+ * Compatibility to 3.9
144
+
145
  = 2.0.17 =
146
 
147
  * Compatibility to 3.8.3
views/contact_bank_layout_settings.php CHANGED
@@ -25,10 +25,7 @@
25
  global $wpdb;
26
  $forms = $wpdb->get_results
27
  (
28
- $wpdb->prepare
29
- (
30
- "SELECT form_id,form_name FROM " .contact_bank_contact_form(),""
31
- )
32
  );
33
  ?>
34
  <select class=" layout-span12" id="ux_ddl_select_form" name="ux_ddl_select_form" onchange="select_form_layout();" style="margin-top: 5px;">
25
  global $wpdb;
26
  $forms = $wpdb->get_results
27
  (
28
+ "SELECT form_id,form_name FROM " .contact_bank_contact_form()
 
 
 
29
  );
30
  ?>
31
  <select class=" layout-span12" id="ux_ddl_select_form" name="ux_ddl_select_form" onchange="select_form_layout();" style="margin-top: 5px;">
views/contact_email_settings.php CHANGED
@@ -14,18 +14,13 @@
14
  <?php
15
  global $wpdb;
16
  $forms = $wpdb->get_results
17
- (
18
- $wpdb->prepare
19
- (
20
- "SELECT form_id,form_name FROM " .contact_bank_contact_form(),""
21
- )
22
- );
23
  $email_count = $wpdb->get_var
24
  (
25
- $wpdb->prepare
26
- (
27
- "SELECT count(email_id) FROM ".contact_bank_email_template_admin(),""
28
- )
29
  );
30
 
31
  ?>
14
  <?php
15
  global $wpdb;
16
  $forms = $wpdb->get_results
17
+ (
18
+ "SELECT form_id,form_name FROM " .contact_bank_contact_form()
19
+
20
+ );
 
 
21
  $email_count = $wpdb->get_var
22
  (
23
+ "SELECT count(email_id) FROM ".contact_bank_email_template_admin()
 
 
 
24
  );
25
 
26
  ?>
views/contact_frontend_data.php CHANGED
@@ -23,10 +23,7 @@
23
  global $wpdb;
24
  $form_data = $wpdb->get_results
25
  (
26
- $wpdb->prepare
27
- (
28
- "SELECT * FROM " .contact_bank_contact_form(),""
29
- )
30
  );
31
  ?>
32
  <select class=" layout-span12" id="select_form" name="select_form" onchange="select_form_id();">
23
  global $wpdb;
24
  $form_data = $wpdb->get_results
25
  (
26
+ "SELECT * FROM " .contact_bank_contact_form()
 
 
 
27
  );
28
  ?>
29
  <select class=" layout-span12" id="select_form" name="select_form" onchange="select_form_id();">
views/contact_view.php CHANGED
@@ -17,9 +17,9 @@
17
  (
18
  $wpdb->prepare
19
  (
20
- "INSERT INTO ".contact_bank_contact_form()."(form_id,form_name) VALUES(%d,%s)",
21
- $form_id,
22
- "Untitled Form (Draft)"
23
  )
24
  );
25
  $wpdb->query
@@ -143,10 +143,7 @@
143
  }
144
  $wpdb->query
145
  (
146
- $wpdb->prepare
147
- (
148
- "INSERT INTO " . contact_bank_layout_settings_Table() . "(form_id,form_settings_key,form_settings_value) VALUES ".implode(',', $sql),""
149
- )
150
  );
151
  $email_name = "Admin Notification";
152
  $send_to = get_option('admin_email');
@@ -350,10 +347,7 @@
350
  <?php
351
  $publish_pages = $wpdb->get_results
352
  (
353
- $wpdb->prepare
354
- (
355
- "SELECT ID,post_name FROM " . $wpdb->posts . " WHERE (post_type = \"page\" OR post_type=\"post\") AND post_status = \"publish\"",""
356
- )
357
  );
358
  ?>
359
  <select class="layout-span7" id="ux_ddl_page_url" name="ux_ddl_page_url">
17
  (
18
  $wpdb->prepare
19
  (
20
+ "INSERT INTO ".contact_bank_contact_form()."(form_id,form_name) VALUES(%d,%s)",
21
+ $form_id,
22
+ "Untitled Form (Draft)"
23
  )
24
  );
25
  $wpdb->query
143
  }
144
  $wpdb->query
145
  (
146
+ "INSERT INTO " . contact_bank_layout_settings_Table() . "(form_id,form_settings_key,form_settings_value) VALUES ".implode(',', $sql)
 
 
 
147
  );
148
  $email_name = "Admin Notification";
149
  $send_to = get_option('admin_email');
347
  <?php
348
  $publish_pages = $wpdb->get_results
349
  (
350
+ "SELECT ID,post_name FROM " . $wpdb->posts . " WHERE (post_type = \"page\" OR post_type=\"post\") AND post_status = \"publish\""
 
 
 
351
  );
352
  ?>
353
  <select class="layout-span7" id="ux_ddl_page_url" name="ux_ddl_page_url">
views/dashboard.php CHANGED
@@ -2,11 +2,7 @@
2
  global $wpdb;
3
  $last_form_id = $wpdb->get_var
4
  (
5
- $wpdb->prepare
6
- (
7
- "SELECT form_id FROM " .contact_bank_contact_form(). " order by form_id desc limit 1",
8
- ""
9
- )
10
  );
11
  $popup = get_option("contact-bank-info-popup");
12
  if($popup == "")
@@ -61,10 +57,7 @@ if($popup == "")
61
  <?php
62
  $form_count = $wpdb->get_var
63
  (
64
- $wpdb->prepare
65
- (
66
- "SELECT count(form_id) FROM ".contact_bank_contact_form(),""
67
- )
68
  );
69
  if($form_count < 1)
70
  {
@@ -106,10 +99,7 @@ if($popup == "")
106
  global $wpdb;
107
  $form_data = $wpdb->get_results
108
  (
109
- $wpdb->prepare
110
- (
111
- "SELECT * FROM " . contact_bank_contact_form(), ""
112
- )
113
  );
114
  for ($flag = 0; $flag < count($form_data); $flag++)
115
  {
2
  global $wpdb;
3
  $last_form_id = $wpdb->get_var
4
  (
5
+ "SELECT form_id FROM " .contact_bank_contact_form(). " order by form_id desc limit 1"
 
 
 
 
6
  );
7
  $popup = get_option("contact-bank-info-popup");
8
  if($popup == "")
57
  <?php
58
  $form_count = $wpdb->get_var
59
  (
60
+ "SELECT count(form_id) FROM ".contact_bank_contact_form()
 
 
 
61
  );
62
  if($form_count < 1)
63
  {
99
  global $wpdb;
100
  $form_data = $wpdb->get_results
101
  (
102
+ "SELECT * FROM " . contact_bank_contact_form()
 
 
 
103
  );
104
  for ($flag = 0; $flag < count($form_data); $flag++)
105
  {