API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 18th, 2016
295
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 75.77 KB | None | 0 0
raw download clone embed print report
  1. mysql> SELECT * FROM CCBillPostbackLog WHERE eventType <> 'Cancellation' AND requestContent NOT LIKE '%X-eid%'\G;
  2. *************************** 1. row ***************************
  3. logId: 188
  4. eventType: NewSaleFailure
  5. dateTime: 2016-03-17 01:49:57
  6. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 557","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Rodriguez ","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:49:56","transactionId":"0116076306000004172"}
  7. processed: 1
  8. *************************** 2. row ***************************
  9. logId: 190
  10. eventType: NewSaleFailure
  11. dateTime: 2016-03-17 01:51:38
  12. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 557","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Rodriguez ","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:51:38","transactionId":"0116076306000004173"}
  13. processed: 1
  14. *************************** 3. row ***************************
  15. logId: 192
  16. eventType: NewSaleFailure
  17. dateTime: 2016-03-17 01:52:51
  18. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 552","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Ayala","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:52:51","transactionId":"0116076306000004175"}
  19. processed: 1
  20. *************************** 4. row ***************************
  21. logId: 194
  22. eventType: NewSaleSuccess
  23. dateTime: 2016-03-17 01:54:10
  24. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleSuccess","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 552","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.macka@gmail.com","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","initialPeriod":"30","ipAddress":"73.220.212.81","lastName":"Ayala","nextRenewalDate":"2016-04-15","paymentAccount":"0428da47bda69f95a29f4ddc8d66d174","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionId":"0116076306000004177","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:54:10","transactionId":"0116076306000004177"}
  25. processed: 1
  26. *************************** 5. row ***************************
  27. logId: 197
  28. eventType: NewSaleFailure
  29. dateTime: 2016-03-17 02:20:26
  30. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 557","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Rodriguez ","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:49:56","transactionId":"0116076306000004172"}
  31. processed: 1
  32. *************************** 6. row ***************************
  33. logId: 198
  34. eventType: NewSaleFailure
  35. dateTime: 2016-03-17 02:20:26
  36. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 557","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Rodriguez ","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:51:38","transactionId":"0116076306000004173"}
  37. processed: 1
  38. *************************** 7. row ***************************
  39. logId: 199
  40. eventType: NewSaleSuccess
  41. dateTime: 2016-03-17 02:20:26
  42. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleSuccess","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 552","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.macka@gmail.com","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","initialPeriod":"30","ipAddress":"73.220.212.81","lastName":"Ayala","nextRenewalDate":"2016-04-15","paymentAccount":"0428da47bda69f95a29f4ddc8d66d174","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionId":"0116076306000004177","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:54:10","transactionId":"0116076306000004177"}
  43. processed: 1
  44. *************************** 8. row ***************************
  45. logId: 200
  46. eventType: NewSaleFailure
  47. dateTime: 2016-03-17 02:20:26
  48. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 552","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Ayala","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:52:51","transactionId":"0116076306000004175"}
  49. processed: 1
  50. *************************** 9. row ***************************
  51. logId: 204
  52. eventType: NewSaleFailure
  53. dateTime: 2016-03-17 02:46:15
  54. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 557","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Rodriguez ","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:49:56","transactionId":"0116076306000004172"}
  55. processed: 1
  56. *************************** 10. row ***************************
  57. logId: 205
  58. eventType: NewSaleFailure
  59. dateTime: 2016-03-17 02:46:15
  60. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 557","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Rodriguez ","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:51:38","transactionId":"0116076306000004173"}
  61. processed: 1
  62. *************************** 11. row ***************************
  63. logId: 206
  64. eventType: NewSaleSuccess
  65. dateTime: 2016-03-17 02:46:15
  66. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleSuccess","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 552","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.macka@gmail.com","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","initialPeriod":"30","ipAddress":"73.220.212.81","lastName":"Ayala","nextRenewalDate":"2016-04-15","paymentAccount":"0428da47bda69f95a29f4ddc8d66d174","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionId":"0116076306000004177","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:54:10","transactionId":"0116076306000004177"}
  67. processed: 1
  68. *************************** 12. row ***************************
  69. logId: 207
  70. eventType: NewSaleFailure
  71. dateTime: 2016-03-17 02:46:15
  72. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 552","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Ayala","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:52:51","transactionId":"0116076306000004175"}
  73. processed: 1
  74. *************************** 13. row ***************************
  75. logId: 273
  76. eventType: NewSaleFailure
  77. dateTime: 2016-03-17 11:09:03
  78. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"4738 Penny Lane","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","cardType":"MASTERCARD","city":"Oklahoma","country":"US","email":"terryjohnsonbusiness@yahoo.com","failureCode":"BE-102","failureReason":"Pickup Card","firstName":"Brade ","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"209.54.37.12","initialPeriod":"30","lastName":"Constantine","paymentType":"CREDIT","postalCode":"73127","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781?email=terryjohnsonbusniness@yahoo.com","pid":"2990036","eid":"b79ebbb8004cca75b59f3f1a86087267","username":"terryjoh890","state":"OK","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-17 04:09:03","transactionId":"0116077401000010511"}
  79. processed: 1
  80. *************************** 14. row ***************************
  81. logId: 275
  82. eventType: NewSaleFailure
  83. dateTime: 2016-03-17 11:36:27
  84. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"Avenue 123","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","cardType":"MASTERCARD","city":"New York","country":"RO","email":"doru@dginternational.com","failureCode":"BE-123","firstName":"Doru","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"193.231.83.66","initialPeriod":"30","lastName":"Test","paymentType":"CREDIT","postalCode":"333555","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/sandbox-api.ccbill.com\/wap-frontflex-sandbox\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"B","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-17 04:36:26"}
  85. processed: 1
  86. *************************** 15. row ***************************
  87. logId: 279
  88. eventType: NewSaleFailure
  89. dateTime: 2016-03-17 12:03:15
  90. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"Avenue 123","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","cardType":"MASTERCARD","city":"New York","country":"RO","email":"doru@dginternational.com","failureCode":"BE-123","firstName":"Doru","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"193.231.83.66","initialPeriod":"30","lastName":"Test","paymentType":"CREDIT","postalCode":"333555","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/sandbox-api.ccbill.com\/wap-frontflex-sandbox\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"B","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-17 04:36:26"}
  91. processed: 1
  92. *************************** 16. row ***************************
  93. logId: 281
  94. eventType: NewSaleFailure
  95. dateTime: 2016-03-17 12:11:28
  96. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"Avenue 123","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","cardType":"MASTERCARD","city":"New York","country":"RO","email":"doru@dginternational.com","failureCode":"BE-123","firstName":"Doru","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"193.231.83.66","initialPeriod":"30","lastName":"Test","paymentType":"CREDIT","postalCode":"333555","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/sandbox-api.ccbill.com\/wap-frontflex\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781?email=125asdasd@sfg.ro","pid":"24771","eid":"ecfc8410bc4471732928d08aff320d73","username":"BlueKryp0123","state":"B","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-17 05:11:28"}
  97. processed: 1
  98. *************************** 17. row ***************************
  99. logId: 285
  100. eventType: NewSaleFailure
  101. dateTime: 2016-03-17 12:16:52
  102. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"Avenue 123","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","cardType":"MASTERCARD","city":"New York","country":"RO","email":"doru@dginternational.com","failureCode":"BE-123","firstName":"Doru","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"193.231.83.66","initialPeriod":"30","lastName":"Test","paymentType":"CREDIT","postalCode":"333555","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/sandbox-api.ccbill.com\/wap-frontflex\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781?email=125asdasd@sfg.ro","pid":"24772","eid":"4dbfdb3c7f63d0f0ca203fdad7cdeef1","username":"BlueKryp0123","state":"B","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-17 05:16:52"}
  103. processed: 1
  104. *************************** 18. row ***************************
  105. logId: 289
  106. eventType: NewSaleFailure
  107. dateTime: 2016-03-17 12:30:02
  108. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"Avenue 123","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","cardType":"MASTERCARD","city":"New York","country":"RO","email":"doru@dginternational.com","failureCode":"BE-123","firstName":"Doru","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"193.231.83.66","initialPeriod":"30","lastName":"Test","paymentType":"CREDIT","postalCode":"333555","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/sandbox-api.ccbill.com\/wap-frontflex-sandbox\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"B","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-17 04:36:26"}
  109. processed: 1
  110. *************************** 19. row ***************************
  111. logId: 349
  112. eventType: NewSaleFailure
  113. dateTime: 2016-03-17 22:05:22
  114. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"1141 ave I so","billedCurrency":"CAD","billedCurrencyCode":"124","billedInitialPrice":"42.15","billedRecurringPrice":"42.15","cardType":"MASTERCARD","city":"Saskatoon","country":"CA","email":"bigbabyblue69@gmail.com","failureCode":"BE-103","failureReason":"Do not honor","firstName":"Walter ","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"174.2.90.246","initialPeriod":"30","lastName":"Horbay","paymentType":"CREDIT","postalCode":"S7M1Z7","priceDescription":"&#36;42.15(CAD) for 30 days then &#36;42.15(CAD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781?email=bigbabyblue69@gmail.com","pid":"2992406","eid":"d8863f63a3b6006c33081205fa6f4311","username":"bigbabyb00","state":"SK","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-17 15:05:22","transactionId":"0116077401000037890"}
  115. processed: 1
  116. *************************** 20. row ***************************
  117. logId: 466
  118. eventType: NewSaleFailure
  119. dateTime: 2016-03-18 09:13:13
  120. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"3417 arbor dr","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Fenton","country":"US","email":"benningdavid12@gmail.com","failureCode":"11","failureReason":"Invalid Format, Bank Routing Number","firstName":"David","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"71.82.99.243","initialPeriod":"30","lastName":"Benning","paymentType":"CHECK","postalCode":"48430","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"none","state":"MI","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-18 02:13:13"}
  121. processed: 1
  122. *************************** 21. row ***************************
  123. logId: 467
  124. eventType: NewSaleFailure
  125. dateTime: 2016-03-18 09:14:32
  126. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"3417 arbor dr","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Fenton","country":"US","email":"benningdavid12@gmail.com","failureCode":"11","failureReason":"Invalid Format, Bank Routing Number","firstName":"David","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"71.82.99.243","initialPeriod":"30","lastName":"Benning","paymentType":"CHECK","postalCode":"48430","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"none","state":"XX","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-18 02:14:32"}
  127. processed: 1
  128. *************************** 22. row ***************************
  129. logId: 472
  130. eventType: NewSaleFailure
  131. dateTime: 2016-03-18 09:37:57
  132. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"3417 arbor dr","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Fenton","country":"US","email":"benningdavid12@gmail.com","failureCode":"11","failureReason":"Invalid Format, Bank Routing Number","firstName":"David","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"71.82.99.243","initialPeriod":"30","lastName":"Benning","paymentType":"CHECK","postalCode":"48430","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"none","state":"MI","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-18 02:13:13"}
  133. processed: 1
  134. *************************** 23. row ***************************
  135. logId: 474
  136. eventType: NewSaleFailure
  137. dateTime: 2016-03-18 09:46:35
  138. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"3417 arbor dr","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Fenton","country":"US","email":"benningdavid12@gmail.com","failureCode":"11","failureReason":"Invalid Format, Bank Routing Number","firstName":"David","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"71.82.99.243","initialPeriod":"30","lastName":"Benning","paymentType":"CHECK","postalCode":"48430","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"none","state":"XX","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-18 02:14:32"}
  139. processed: 1
  140. *************************** 24. row ***************************
  141. logId: 475
  142. eventType: NewSaleFailure
  143. dateTime: 2016-03-18 10:03:41
  144. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"3417 arbor dr","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Fenton","country":"US","email":"benningdavid12@gmail.com","failureCode":"11","failureReason":"Invalid Format, Bank Routing Number","firstName":"David","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"71.82.99.243","initialPeriod":"30","lastName":"Benning","paymentType":"CHECK","postalCode":"48430","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"none","state":"MI","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-18 02:13:13"}
  145. processed: 1
  146. *************************** 25. row ***************************
  147. logId: 478
  148. eventType: NewSaleFailure
  149. dateTime: 2016-03-18 10:12:11
  150. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"3417 arbor dr","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Fenton","country":"US","email":"benningdavid12@gmail.com","failureCode":"11","failureReason":"Invalid Format, Bank Routing Number","firstName":"David","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"71.82.99.243","initialPeriod":"30","lastName":"Benning","paymentType":"CHECK","postalCode":"48430","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"none","state":"XX","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-18 02:14:32"}
  151. processed: 1
  152. *************************** 26. row ***************************
  153. logId: 496
  154. eventType: NewSaleSuccess
  155. dateTime: 2016-03-18 11:49:35
  156. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleSuccess","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 552","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.macka@gmail.com","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","initialPeriod":"30","ipAddress":"73.220.212.81","lastName":"Ayala","nextRenewalDate":"2016-04-15","paymentAccount":"0428da47bda69f95a29f4ddc8d66d174","paymentType":"CHECK","postalCode":"93640","priceDescription":"","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionId":"0116076306000004177","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:54:10","transactionId":"0116076306000004177"}
  157. processed: 1
  158. *************************** 27. row ***************************
  159. logId: 513
  160. eventType: NewSaleSuccess
  161. dateTime: 2016-03-18 12:50:09
  162. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleSuccess","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"Po box 1160 ","avsResponse":"N","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","cardType":"VISA","city":"Four oaks","country":"US","cvv2Response":"M","email":"johnearl980@yahoo.com","firstName":"John ","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","initialPeriod":"30","ipAddress":"70.197.129.187","lastName":"Earl","nextRenewalDate":"2016-04-17","paymentAccount":"bbd7bcab04d3099f452cb1a8cdbcf90f","paymentType":"CREDIT","postalCode":"27524","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"http:\/\/m.xdating.com\/profile\/view\/id\/38d1c0d2326d756ce4f6147418e17be8","state":"NC","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionId":"0116078501000016565","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-18 05:38:06","transactionId":"0116078501000016565"}
  163. processed: 1
  164. *************************** 28. row ***************************
  165. logId: 519
  166. eventType: NewSaleFailure
  167. dateTime: 2016-03-18 13:16:13
  168. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"1909 state route 401","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"nesalle","country":"US","email":"pattysixdoor01@gmail.com","failureCode":"50","failureReason":"Email address exceeds Transaction Throttle","firstName":"timothy","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"159.203.92.9","initialPeriod":"30","lastName":"sauls","paymentType":"CHECK","postalCode":"98638","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"none","state":"WA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-18 06:16:13"}
  169. processed: 0
  170. 28 rows in set (0.01 sec)
  171.  
  172. ERROR:
  173. No query specified
  174.  
  175. mysql> SELECT * FROM CCBillPostbackLog WHERE eventType <> 'Cancellation' AND requestContent NOT LIKE '%X-eid%' \G;
  176. *************************** 1. row ***************************
  177. logId: 188
  178. eventType: NewSaleFailure
  179. dateTime: 2016-03-17 01:49:57
  180. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 557","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Rodriguez ","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:49:56","transactionId":"0116076306000004172"}
  181. processed: 1
  182. *************************** 2. row ***************************
  183. logId: 190
  184. eventType: NewSaleFailure
  185. dateTime: 2016-03-17 01:51:38
  186. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 557","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Rodriguez ","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:51:38","transactionId":"0116076306000004173"}
  187. processed: 1
  188. *************************** 3. row ***************************
  189. logId: 192
  190. eventType: NewSaleFailure
  191. dateTime: 2016-03-17 01:52:51
  192. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 552","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Ayala","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:52:51","transactionId":"0116076306000004175"}
  193. processed: 1
  194. *************************** 4. row ***************************
  195. logId: 194
  196. eventType: NewSaleSuccess
  197. dateTime: 2016-03-17 01:54:10
  198. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleSuccess","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 552","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.macka@gmail.com","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","initialPeriod":"30","ipAddress":"73.220.212.81","lastName":"Ayala","nextRenewalDate":"2016-04-15","paymentAccount":"0428da47bda69f95a29f4ddc8d66d174","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionId":"0116076306000004177","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:54:10","transactionId":"0116076306000004177"}
  199. processed: 1
  200. *************************** 5. row ***************************
  201. logId: 197
  202. eventType: NewSaleFailure
  203. dateTime: 2016-03-17 02:20:26
  204. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 557","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Rodriguez ","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:49:56","transactionId":"0116076306000004172"}
  205. processed: 1
  206. *************************** 6. row ***************************
  207. logId: 198
  208. eventType: NewSaleFailure
  209. dateTime: 2016-03-17 02:20:26
  210. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 557","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Rodriguez ","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:51:38","transactionId":"0116076306000004173"}
  211. processed: 1
  212. *************************** 7. row ***************************
  213. logId: 199
  214. eventType: NewSaleSuccess
  215. dateTime: 2016-03-17 02:20:26
  216. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleSuccess","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 552","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.macka@gmail.com","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","initialPeriod":"30","ipAddress":"73.220.212.81","lastName":"Ayala","nextRenewalDate":"2016-04-15","paymentAccount":"0428da47bda69f95a29f4ddc8d66d174","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionId":"0116076306000004177","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:54:10","transactionId":"0116076306000004177"}
  217. processed: 1
  218. *************************** 8. row ***************************
  219. logId: 200
  220. eventType: NewSaleFailure
  221. dateTime: 2016-03-17 02:20:26
  222. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 552","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Ayala","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:52:51","transactionId":"0116076306000004175"}
  223. processed: 1
  224. *************************** 9. row ***************************
  225. logId: 204
  226. eventType: NewSaleFailure
  227. dateTime: 2016-03-17 02:46:15
  228. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 557","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Rodriguez ","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:49:56","transactionId":"0116076306000004172"}
  229. processed: 1
  230. *************************** 10. row ***************************
  231. logId: 205
  232. eventType: NewSaleFailure
  233. dateTime: 2016-03-17 02:46:15
  234. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 557","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Rodriguez ","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:51:38","transactionId":"0116076306000004173"}
  235. processed: 1
  236. *************************** 11. row ***************************
  237. logId: 206
  238. eventType: NewSaleSuccess
  239. dateTime: 2016-03-17 02:46:15
  240. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleSuccess","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 552","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.macka@gmail.com","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","initialPeriod":"30","ipAddress":"73.220.212.81","lastName":"Ayala","nextRenewalDate":"2016-04-15","paymentAccount":"0428da47bda69f95a29f4ddc8d66d174","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionId":"0116076306000004177","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:54:10","transactionId":"0116076306000004177"}
  241. processed: 1
  242. *************************** 12. row ***************************
  243. logId: 207
  244. eventType: NewSaleFailure
  245. dateTime: 2016-03-17 02:46:15
  246. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 552","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.mavka@gmail.com","failureCode":"BE-900","failureReason":"transaction declined","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"73.220.212.81","initialPeriod":"30","lastName":"Ayala","paymentType":"CHECK","postalCode":"93640","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:52:51","transactionId":"0116076306000004175"}
  247. processed: 1
  248. *************************** 13. row ***************************
  249. logId: 273
  250. eventType: NewSaleFailure
  251. dateTime: 2016-03-17 11:09:03
  252. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"4738 Penny Lane","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","cardType":"MASTERCARD","city":"Oklahoma","country":"US","email":"terryjohnsonbusiness@yahoo.com","failureCode":"BE-102","failureReason":"Pickup Card","firstName":"Brade ","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"209.54.37.12","initialPeriod":"30","lastName":"Constantine","paymentType":"CREDIT","postalCode":"73127","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781?email=terryjohnsonbusniness@yahoo.com","pid":"2990036","eid":"b79ebbb8004cca75b59f3f1a86087267","username":"terryjoh890","state":"OK","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-17 04:09:03","transactionId":"0116077401000010511"}
  253. processed: 1
  254. *************************** 14. row ***************************
  255. logId: 275
  256. eventType: NewSaleFailure
  257. dateTime: 2016-03-17 11:36:27
  258. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"Avenue 123","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","cardType":"MASTERCARD","city":"New York","country":"RO","email":"doru@dginternational.com","failureCode":"BE-123","firstName":"Doru","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"193.231.83.66","initialPeriod":"30","lastName":"Test","paymentType":"CREDIT","postalCode":"333555","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/sandbox-api.ccbill.com\/wap-frontflex-sandbox\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"B","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-17 04:36:26"}
  259. processed: 1
  260. *************************** 15. row ***************************
  261. logId: 279
  262. eventType: NewSaleFailure
  263. dateTime: 2016-03-17 12:03:15
  264. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"Avenue 123","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","cardType":"MASTERCARD","city":"New York","country":"RO","email":"doru@dginternational.com","failureCode":"BE-123","firstName":"Doru","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"193.231.83.66","initialPeriod":"30","lastName":"Test","paymentType":"CREDIT","postalCode":"333555","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/sandbox-api.ccbill.com\/wap-frontflex-sandbox\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"B","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-17 04:36:26"}
  265. processed: 1
  266. *************************** 16. row ***************************
  267. logId: 281
  268. eventType: NewSaleFailure
  269. dateTime: 2016-03-17 12:11:28
  270. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"Avenue 123","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","cardType":"MASTERCARD","city":"New York","country":"RO","email":"doru@dginternational.com","failureCode":"BE-123","firstName":"Doru","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"193.231.83.66","initialPeriod":"30","lastName":"Test","paymentType":"CREDIT","postalCode":"333555","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/sandbox-api.ccbill.com\/wap-frontflex\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781?email=125asdasd@sfg.ro","pid":"24771","eid":"ecfc8410bc4471732928d08aff320d73","username":"BlueKryp0123","state":"B","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-17 05:11:28"}
  271. processed: 1
  272. *************************** 17. row ***************************
  273. logId: 285
  274. eventType: NewSaleFailure
  275. dateTime: 2016-03-17 12:16:52
  276. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"Avenue 123","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","cardType":"MASTERCARD","city":"New York","country":"RO","email":"doru@dginternational.com","failureCode":"BE-123","firstName":"Doru","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"193.231.83.66","initialPeriod":"30","lastName":"Test","paymentType":"CREDIT","postalCode":"333555","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/sandbox-api.ccbill.com\/wap-frontflex\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781?email=125asdasd@sfg.ro","pid":"24772","eid":"4dbfdb3c7f63d0f0ca203fdad7cdeef1","username":"BlueKryp0123","state":"B","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-17 05:16:52"}
  277. processed: 1
  278. *************************** 18. row ***************************
  279. logId: 289
  280. eventType: NewSaleFailure
  281. dateTime: 2016-03-17 12:30:02
  282. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"Avenue 123","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","cardType":"MASTERCARD","city":"New York","country":"RO","email":"doru@dginternational.com","failureCode":"BE-123","firstName":"Doru","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"193.231.83.66","initialPeriod":"30","lastName":"Test","paymentType":"CREDIT","postalCode":"333555","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/sandbox-api.ccbill.com\/wap-frontflex-sandbox\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"B","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-17 04:36:26"}
  283. processed: 1
  284. *************************** 19. row ***************************
  285. logId: 349
  286. eventType: NewSaleFailure
  287. dateTime: 2016-03-17 22:05:22
  288. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"1141 ave I so","billedCurrency":"CAD","billedCurrencyCode":"124","billedInitialPrice":"42.15","billedRecurringPrice":"42.15","cardType":"MASTERCARD","city":"Saskatoon","country":"CA","email":"bigbabyblue69@gmail.com","failureCode":"BE-103","failureReason":"Do not honor","firstName":"Walter ","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"174.2.90.246","initialPeriod":"30","lastName":"Horbay","paymentType":"CREDIT","postalCode":"S7M1Z7","priceDescription":"&#36;42.15(CAD) for 30 days then &#36;42.15(CAD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781?email=bigbabyblue69@gmail.com","pid":"2992406","eid":"d8863f63a3b6006c33081205fa6f4311","username":"bigbabyb00","state":"SK","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-17 15:05:22","transactionId":"0116077401000037890"}
  289. processed: 1
  290. *************************** 20. row ***************************
  291. logId: 466
  292. eventType: NewSaleFailure
  293. dateTime: 2016-03-18 09:13:13
  294. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"3417 arbor dr","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Fenton","country":"US","email":"benningdavid12@gmail.com","failureCode":"11","failureReason":"Invalid Format, Bank Routing Number","firstName":"David","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"71.82.99.243","initialPeriod":"30","lastName":"Benning","paymentType":"CHECK","postalCode":"48430","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"none","state":"MI","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-18 02:13:13"}
  295. processed: 1
  296. *************************** 21. row ***************************
  297. logId: 467
  298. eventType: NewSaleFailure
  299. dateTime: 2016-03-18 09:14:32
  300. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"3417 arbor dr","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Fenton","country":"US","email":"benningdavid12@gmail.com","failureCode":"11","failureReason":"Invalid Format, Bank Routing Number","firstName":"David","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"71.82.99.243","initialPeriod":"30","lastName":"Benning","paymentType":"CHECK","postalCode":"48430","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"none","state":"XX","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-18 02:14:32"}
  301. processed: 1
  302. *************************** 22. row ***************************
  303. logId: 472
  304. eventType: NewSaleFailure
  305. dateTime: 2016-03-18 09:37:57
  306. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"3417 arbor dr","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Fenton","country":"US","email":"benningdavid12@gmail.com","failureCode":"11","failureReason":"Invalid Format, Bank Routing Number","firstName":"David","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"71.82.99.243","initialPeriod":"30","lastName":"Benning","paymentType":"CHECK","postalCode":"48430","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"none","state":"MI","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-18 02:13:13"}
  307. processed: 1
  308. *************************** 23. row ***************************
  309. logId: 474
  310. eventType: NewSaleFailure
  311. dateTime: 2016-03-18 09:46:35
  312. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"3417 arbor dr","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Fenton","country":"US","email":"benningdavid12@gmail.com","failureCode":"11","failureReason":"Invalid Format, Bank Routing Number","firstName":"David","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"71.82.99.243","initialPeriod":"30","lastName":"Benning","paymentType":"CHECK","postalCode":"48430","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"none","state":"XX","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-18 02:14:32"}
  313. processed: 1
  314. *************************** 24. row ***************************
  315. logId: 475
  316. eventType: NewSaleFailure
  317. dateTime: 2016-03-18 10:03:41
  318. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"3417 arbor dr","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Fenton","country":"US","email":"benningdavid12@gmail.com","failureCode":"11","failureReason":"Invalid Format, Bank Routing Number","firstName":"David","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"71.82.99.243","initialPeriod":"30","lastName":"Benning","paymentType":"CHECK","postalCode":"48430","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"none","state":"MI","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-18 02:13:13"}
  319. processed: 1
  320. *************************** 25. row ***************************
  321. logId: 478
  322. eventType: NewSaleFailure
  323. dateTime: 2016-03-18 10:12:11
  324. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"3417 arbor dr","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Fenton","country":"US","email":"benningdavid12@gmail.com","failureCode":"11","failureReason":"Invalid Format, Bank Routing Number","firstName":"David","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"71.82.99.243","initialPeriod":"30","lastName":"Benning","paymentType":"CHECK","postalCode":"48430","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"none","state":"XX","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-18 02:14:32"}
  325. processed: 1
  326. *************************** 26. row ***************************
  327. logId: 496
  328. eventType: NewSaleSuccess
  329. dateTime: 2016-03-18 11:49:35
  330. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleSuccess","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"P o box 552","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"Mendota","country":"US","email":"shorty.macka@gmail.com","firstName":"Jose","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","initialPeriod":"30","ipAddress":"73.220.212.81","lastName":"Ayala","nextRenewalDate":"2016-04-15","paymentAccount":"0428da47bda69f95a29f4ddc8d66d174","paymentType":"CHECK","postalCode":"93640","priceDescription":"","rebills":"99","recurringPeriod":"30","referringUrl":"https:\/\/api.ccbill.com\/wap-frontflex-live\/flexforms\/070c6c36-dd64-4161-88ac-f5c508569781","state":"CA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionId":"0116076306000004177","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-16 18:54:10","transactionId":"0116076306000004177"}
  331. processed: 1
  332. *************************** 27. row ***************************
  333. logId: 513
  334. eventType: NewSaleSuccess
  335. dateTime: 2016-03-18 12:50:09
  336. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleSuccess","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"Po box 1160 ","avsResponse":"N","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","cardType":"VISA","city":"Four oaks","country":"US","cvv2Response":"M","email":"johnearl980@yahoo.com","firstName":"John ","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","initialPeriod":"30","ipAddress":"70.197.129.187","lastName":"Earl","nextRenewalDate":"2016-04-17","paymentAccount":"bbd7bcab04d3099f452cb1a8cdbcf90f","paymentType":"CREDIT","postalCode":"27524","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"http:\/\/m.xdating.com\/profile\/view\/id\/38d1c0d2326d756ce4f6147418e17be8","state":"NC","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionId":"0116078501000016565","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-18 05:38:06","transactionId":"0116078501000016565"}
  337. processed: 1
  338. *************************** 28. row ***************************
  339. logId: 519
  340. eventType: NewSaleFailure
  341. dateTime: 2016-03-18 13:16:13
  342. requestContent: {"clientAccnum":"948565","clientSubacc":"0000","eventType":"NewSaleFailure","eventGroupType":"Subscription","accountingCurrency":"USD","accountingCurrencyCode":"840","accountingInitialPrice":"29.95","accountingRecurringPrice":"29.95","address1":"1909 state route 401","billedCurrency":"USD","billedCurrencyCode":"840","billedInitialPrice":"29.95","billedRecurringPrice":"29.95","city":"nesalle","country":"US","email":"pattysixdoor01@gmail.com","failureCode":"50","failureReason":"Email address exceeds Transaction Throttle","firstName":"timothy","flexId":"070c6c36-dd64-4161-88ac-f5c508569781","formName":"UpgradeForm","ipAddress":"159.203.92.9","initialPeriod":"30","lastName":"sauls","paymentType":"CHECK","postalCode":"98638","priceDescription":"&#36;29.95(USD) for 30 days then &#36;29.95(USD) recurring every 30 days","rebills":"99","recurringPeriod":"30","referringUrl":"none","state":"WA","subscriptionCurrency":"USD","subscriptionCurrencyCode":"840","subscriptionInitialPrice":"29.95","subscriptionRecurringPrice":"29.95","subscriptionTypeId":"0000000037","timestamp":"2016-03-18 06:16:13"}
  343. processed: 0
  344. 28 rows in set (0.00 sec)
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!