Advertisement
Guest User

Untitled

a guest
Apr 21st, 2014
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.99 KB | None | 0 0
  1. $response = array();
  2.  
  3. $send_status = 0;
  4.  
  5. $seller_id = 1275;
  6.  
  7. $re1 = mysql_query("INSERT INTO pos_msg_que(send_status, sid, uid, alert_type, alert_data, send_time) VALUES ('$send_status','$seller_id','$uid','1','mysql_real_escape_string($email_start_message)','$start_time');");
  8.  
  9. if (!$re1 == 'false') {
  10. $response['start_email_alert'] = '1';
  11. } else {
  12. $response['start_email_alert'] = '0';
  13. }
  14.  
  15. $re2 = mysql_query("INSERT INTO pos_msg_que(send_status, sid, uid, alert_type, alert_data, send_time) VALUES ('$send_status','$seller_id','$uid','2','mysql_real_escape_string($sms_start_message)','$start_time');");
  16.  
  17. if (!$re2 == 'false') {
  18. $response['start_sms_alert'] = '1';
  19. } else {
  20. $response['start_sms_alert'] = '0';
  21. }
  22.  
  23. $re3 = mysql_query("INSERT INTO pos_msg_que(send_status, sid, uid, alert_type, alert_data, send_time) VALUES ('$send_status','$seller_id','$uid','3','mysql_real_escape_string($email_end_message)','$end_time');");
  24.  
  25. if (!$re3 == 'false') {
  26. $response['end_email_alert'] = '1';
  27. } else {
  28. $response['end_email_alert'] = '0';
  29. }
  30.  
  31. $re4 = mysql_query("INSERT INTO pos_msg_que(send_status, sid, uid, alert_type, alert_data, send_time) VALUES ('$send_status','$seller_id', '$uid','4','mysql_real_escape_string($sms_end_message)','$end_time');");
  32.  
  33. if (!$re4 == 'false') {
  34. $response['end_sms_alert'] = '1';
  35. } else {
  36. $response['end_sms_alert'] = '0';
  37. }
  38. echo json_encode($response);
  39.  
  40. +-----------------+------------+------+-----+-------------------+-----------------------------+
  41. | Field | Type | Null | Key | Default | Extra |
  42. +-----------------+------------+------+-----+-------------------+-----------------------------+
  43. | id | int(8) | NO | PRI | NULL | auto_increment |
  44. | send_status | int(11) | NO | | NULL | |
  45. | sid | int(8) | NO | | NULL | |
  46. | uid | int(8) | NO | | NULL | |
  47. | alert_type | tinyint(2) | NO | | NULL | |
  48. | alert_data | blob | NO | | NULL | |
  49. | send_time | datetime | NO | | NULL | |
  50. | advance_time | int(3) | NO | | NULL | |
  51. | last_attempt_at | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
  52. +-----------------+------------+------+-----+-------------------+-----------------------------+
  53.  
  54. function cleanStr($str){
  55. $str = trim($str);
  56. if($str == "") return;
  57.  
  58. $str = stripslashes($str);//STRIP slashes
  59. if (function_exists(mysqli_real_escape_string)){
  60. $str = mysqli_real_escape_string($str);
  61. }else{
  62. $str = mysql_real_escape_string($str);
  63. }
  64. //CONVERT TO HTML
  65. $str = htmlspecialchars($str);
  66. //LAST CLEAN UP
  67. $str = preg_replace("#'#","",$str);
  68. return $str;
  69. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement