API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2017
56
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.45 KB | None | 0 0
raw download clone embed print report
  1. /*!*/;
  2. # at 6606619
  3. #170623 11:16:08 server id 1 end_log_pos 6606785 CRC32 0x8dc49ec7 Query thread_id=9968800 exec_time=0 error_code=0
  4. SET TIMESTAMP=1498205768/*!*/;
  5. update
  6. transactions
  7. set
  8. `condition` = "Ended"
  9. where
  10. id = 234975277
  11. /*!*/;
  12. # at 6606785
  13. #170623 11:16:08 server id 1 end_log_pos 6607039 CRC32 0x3b111192 Query thread_id=9968800 exec_time=0 error_code=0
  14. SET TIMESTAMP=1498205768/*!*/;
  15. update
  16. automation
  17. set
  18. `condition` = "approved"
  19. where
  20. id = 202825425
  21. /*!*/;
  22. # at 6607039
  23. # at 6607071
  24. #170623 11:16:08 server id 1 end_log_pos 6607071 CRC32 0x04481cd5 Intvar
  25. SET INSERT_ID=235862063/*!*/;
  26. #170623 11:16:08 server id 1 end_log_pos 6608403 CRC32 0xdedac1b6 Query thread_id=9968800 exec_time=0 error_code=0
  27. SET TIMESTAMP=1498205768/*!*/;
  28. insert into
  29. cards_orders
  30. (
  31. cards_numbers_id,
  32. order_date,
  33. input_date,
  34. ip_address,
  35. x_forwarded,
  36. showing_order_id,
  37. order_id,
  38. account_id,
  39. real_order_sum,
  40. currency_id,
  41. usd_real_order_sum,
  42. order_pin,
  43. bonus_count,
  44. approved_status,
  45. admin_id,
  46. user_xml,
  47. ofc_is_gift,
  48. ofc_statistical,
  49. ofc_gn_inputdate,
  50. ofc_an_inputdate,
  51. ofc_sn_inputdate,
  52. ofc_sa_inputdate,
  53. visibility,
  54. input_side,
  55. is_transfer,
  56. is_auto,
  57. first_check,
  58. parent_ID,
  59.  
  60. batch_id, version_number
  61. ) values (
  62. 987858,
  63. "2017-06-22 00:00:00",
  64. NOW(),
  65. "188.65.135.234",
  66. "",
  67. "day-bonus_05021153_2017-06-23_win",
  68. "day-bonus_05021153_2017-06-23_win",
  69. 3089876,
  70. "0",
  71. 0,
  72. "",
  73. "",
  74. 5,
  75. "W",
  76. 136,
  77. "<?xml version=\"1.0\" encoding=\"windows-1251\"?>
  78. <receipt number=\"day-bonus_05021153_2017-06-23_win\" date=\"2017-06-23\" card=\"05021153\" action=\"create\" status=\"approved\">
  79. <entry name=\"orderDate\" value=\"2017-06-22\"/>
  80. <entry name=\"points\" value=\"5\"/>
  81. </receipt>",
  82. "No",
  83. "No",
  84. NOW(),
  85. NOW(),
  86. NULL,
  87. NULL,
  88. "Yes",
  89. "BackOffice",
  90. "Yes",
  91. "Yes",
  92. 0,
  93. 0,
  94. 294031136, 1
  95. )
  96. /*!*/;
  97. # at 6608403
  98. #170623 11:16:08 server id 1 end_log_pos 6608980 CRC32 0x62ef75ec Query thread_id=9968800 exec_time=0 error_code=0
  99. SET TIMESTAMP=1498205768/*!*/;
  100. update
  101. cards_orders
  102. set
  103. approved_status = "A",
  104. approved_date = NOW(),
  105. approver_id = 136,
  106. rejected_date = "0000-00-00 00:00:00",
  107. ofc_is_gift = "No",
  108. ofc_statistical = "No",
  109. ofc_gn_inputdate = input_date,
  110. ofc_an_inputdate = input_date,
  111. ofc_aa_inputdate = input_date,
  112. ofc_sn_inputdate = NULL,
  113. ofc_sa_inputdate = NULL
  114. where
  115. id = 235862063
  116. /*!*/;
  117. # at 6608980
  118. # at 6609012
  119. #170623 11:16:08 server id 1 end_log_pos 6609012 CRC32 0xa9a27ce6 Intvar
  120. SET INSERT_ID=234975278/*!*/;
  121. #170623 11:16:08 server id 1 end_log_pos 6609469 CRC32 0x640dd5c5 Query thread_id=9968800 exec_time=0 error_code=0
  122. SET TIMESTAMP=1498205768/*!*/;
  123. insert into
  124. transactions
  125. (
  126. sender_account,
  127. receiver_account,
  128. remote_addr,
  129. x_forwarded,
  130. operator_id,
  131. start_date,
  132. points,
  133. `condition`,
  134. cards_orders_id
  135. ) values (
  136. 3089876,
  137. 560291,
  138. "188.65.135.234",
  139. "",
  140. "136",
  141. "2017-06-23 11:16:08",
  142. "5",
  143. "Started",
  144. 235862063
  145. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!