Advertisement
Guest User

Untitled

a guest
Mar 26th, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. if data = `SwiboFormSubmissionType_Patient`
  2. declare saved_nid int;
  3. set saved_nid = nid;
  4.  
  5. declare saved_sid int;
  6. set saved_sid = sid;
  7.  
  8. declare saved_email mediumtext;
  9. select data from webform_submitted_data where nid = saved_nid and sid = saved_sid and cid = 1 int saved_email;
  10.  
  11. declare saved_firstname mediumtext;
  12. select data from webform_submitted_data where nid = saved_nid and sid = saved_sid and cid = 2 int saved_firstname;
  13.  
  14. declare saved_lastname mediumtext;
  15. select data from webform_submitted_data where nid = saved_nid and sid = saved_sid and cid = 3 int saved_lastname;
  16.  
  17. declare saved_password mediumtext;
  18. select data from webform_submitted_data where nid = saved_nid and sid = saved_sid and cid = 4 int saved_password;
  19.  
  20. insert into kassgma33805com43162_swibo.clinics (email, firstName, lastName, password) select saved_email, saved_firstname, saved_lastname, saved_password;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement