Action 64: Search for Old Details of Transactions in Games
Function Description
- Integrate details of game history transactions for all games and sort them by gType (game type).
- We query transactions of specified game types if request contains
gTypes
.
- We query transactions of specified game types if request contains
- Search for a single parent ID’s details of game history settled transaction with a given time range (search by lastModifyTime).
- The values of ss(seconds) in start time and end time must be 00.
- The maximum time range for each search is 5 minutes.
- To obtain better response when huge data and heavy traffic, specifying a time range less than 1 minute for each search is recommended.
- The function searches for the data according to the game date of the game record. Therefore, if the number of transactions found and transaction data on the win/loss statement are not matching, that is because the record has not cleared yet in the time range you searched.
- Provide game history transaction information between 1 hour and 60 days.
- Each gambling game is considered as a transaction. When “hasGamble” is 1, it means that this is a gambling games transaction. Only JDB Bar(gType=9) games have gambling game.
Example:
- If a player bets 10 and wins 100 points in the game
bet = -10, gambleBet = 0, win = 100, total = 90, hasGamble = 0 - Same as above, if a player uses winning points to play gambling games and wins
bet = 0, gambleBet = -100, win = 200, total = 100, hasGamble = 1
- If a player bets 10 and wins 100 points in the game
Parameter
Parameter | Format | Mandatory | Description |
---|---|---|---|
action | Integer | Y | 64 |
ts | Long | Y | Current system time |
parent | String(50) | Y | Agent ID |
starttime | String(19) | Y | Start time of the searching range (dd-MM-yyyy HH:mm:ss) |
endtime | String(19) | Y | End time of the searching range (dd-MM-yyyy HH:mm:ss) |
gTypes | Integer Array | N | Game types See Game Provider |
Example
{
"action": 64,
"ts": 1447452951820,
"parent": "testag",
"starttime": "08-12-2016 17:45:00",
"endtime": "08-12-2016 17:46:00",
"gTypes": [0,7]
}
Return Results
Parameter | Format | Description |
---|---|---|
status | String(4) | Success: 0000 Error: See Error Codes in Appendix No Data: 0000 |
data | JSON Array | The returned data will be listed in the following tables. |
err_text | String(255) | Error message |
Betting records in slot games: gType = 0, 66, 90
Parameter | Format | Description |
---|---|---|
historyId | String(100) | Game History ID |
playerId | String(50) | Player ID |
gType | Integer | Game types See Game Provider |
mtype | Integer | Machine Types |
gameDate | String(19) | Date of playing. (dd-MM-yyyy HH:mm:ss) |
bet | Double | Bet amount |
win | Double | Winning points in the game |
total | Double | Total Win Loss |
currency | String(10) | Currency types See Currency Code |
jackpot | Double | The amount of the jackpot won |
jackpotContribute | Double | Jackpot contributions |
denom | Double | Bet denomination |
lastModifyTime | String(19) | Last modified time |
playerIp | String(50) | Player login IP |
clientType | String(20) | Player login from website or mobile device. |
hasFreegame | Integer | Free game 0: No 1: Yes |
systemTakeWin | Integer | Mark this as the interruption if the game and it will be settled by the system. 0: No 1: Yes |
beforeBalance | String(20) | Balance before playing |
afterBalance | String(20) | Balance after playing |
transferId | Long | Transfer ID |
Betting records in fishing game: gType = 7, 67, 91
Parameter | Format | Description |
---|---|---|
historyId | String(100) | Game History ID |
playerId | String(50) | Player ID |
gType | Integer | Game types See Game Provider |
mtype | Integer | Machine Types |
gameDate | String(19) | Date of playing. (dd-MM-yyyy HH:mm:ss) |
roomType | Integer | Game Room -1: Lobby (Achievement Game) 0: Small Bet 1: Medium sized bet 2: Large bet Real naming of game room differentiated by Machine Type |
currency | String(10) | Currency types See Currency Code |
bet | Double | Bet amount |
win | Double | Winning points in the game |
total | Double | Total Win Loss |
denom | Double | Bet denomination |
beforeBalance | Double | Balance before playing |
afterBalance | Double | Balance after playing |
lastModifyTime | String(19) | Last modified time. (dd - MM - yyyy HH: mm: ss) |
playerIp | String(50) | Player login IP |
clientType | String(20) | Player login from website or mobile device |
transferId | Long | Transfer IDIf the fish game pay mode is PrepayBalance, the transaction number will be the same as the transferId of action 14 |
Betting records in Arcade games: gType = 9, 92
Parameter | Format | Description |
---|---|---|
historyId | String(100) | Game History ID |
playerId | String(50) | Player ID |
gType | Integer | Game types See Game Provider |
mtype | Integer | Machine Types |
gameDate | String(19) | Date of playing. (dd-MM-yyyy HH:mm:ss) |
bet | Double | Bet amount |
gambleBet | Double | Bet amount in Gambling games |
win | Double | Winning points in the game |
total | Double | Total Win Loss |
currency | String(10) | Currency types See Currency Code |
denom | Double | Bet denomination |
lastModifyTime | String(19) | Last modified time. (dd - MM - yyyy HH: mm: ss) |
playerIp | String(50) | Player login IP |
clientType | String(20) | Player login from website or mobile device |
hasBonusGame | Integer | Bonus game 0: No 1: Yes |
hasGamble | Integer | Gambling Game 0: No 1: Yes |
beforeBalance | String(20) | Balance before playing |
afterBalance | String(20) | Balance after playing |
transferId | Long | Transfer ID |
Betting records in Lottery Game: gType = 12
Parameter | Format | Description |
---|---|---|
historyId | String(100) | Game History ID |
playerId | String(50) | Player ID |
gType | Integer | Game types See Game Provider |
mtype | Integer | Machine Types |
gameDate | String(19) | Date of playing. (dd-MM-yyyy HH:mm:ss) |
bet | Double | Bet amount |
win | Double | Winning points in the game |
total | Double | Total Win Loss |
currency | String(10) | Currency types See Currency Code |
denom | Double | Bet denomination |
lastModifyTime | String(19) | Last modified time. (dd - MM - yyyy HH: mm: ss) |
playerIp | String(50) | Player login IP |
clientType | String(20) | Player login from website or mobile device |
hasBonusGame | Integer | Bonus game 0: No 1: Yes |
beforeBalance | String(20) | Balance before playing |
afterBalance | String(20) | Balance after playing |
transferId | Long | Transfer ID |
Betting records in Card Games: gType = 18, 93
Parameter | Format | Description |
---|---|---|
historyId | String(100) | Game History ID |
roundSeqNo | Long | Game round sequence number |
playerId | String(50) | Player ID |
gType | Integer | Game types See Game Provider |
mtype | Integer | Machine Types |
gameDate | String(19) | Date of playing. (dd-MM-yyyy HH:mm:ss) |
bet | Double | Bet amount |
win | Double | Winning points in the game |
tax | Double | Player pay winning tax in the game |
total | Double | Total Win Loss |
currency | String(10) | Currency types See Currency Code |
lastModifyTime | String(19) | Last modified time. (dd - MM - yyyy HH: mm: ss) |
playerIp | String(50) | Player login IP |
clientType | String(20) | Player login from website or mobile device |
validBet | Double | Valid Bet Amount |
beforeBalance | String(20) | Balance before playing |
afterBalance | String(20) | Balance after playing |
transferId | Long | Transfer ID |
Betting records in SPRIBE, FC, AMB, SWG, MANCALA, YB, Onlyplay, CreedRoomz, ZestPlay, SmartSoft: gType = SPRIBE(22), FC(30, 31, 32), AMB(50), SWG(55, 56, 70), MANCALA(57, 75), YB(58, 59, 60), Onlyplay(80, 81), CreedRoomz(101), ZestPlay(120), SmartSoft(130, 131, 132)
Parameter | Format | Description |
---|---|---|
historyId | String(100) | Game History ID |
playerId | String(50) | Player ID |
gType | Integer | Game types See Game Provider |
mtype | Integer | Machine Types |
gameDate | String(19) | Date of playing. (dd-MM-yyyy HH:mm:ss) |
bet | Double | Bet amount |
win | Double | Winning points in the game |
total | Double | Total Win Loss |
currency | String(10) | Currency types See Currency Code |
lastModifyTime | String(19) | Last modified time. (dd - MM - yyyy HH: mm: ss) |
beforeBalance | String(20) | Balance before playing |
afterBalance | String(20) | Balance after playing |
transferId | Long | Transfer ID |
Betting records in HRG: gType = 41
Parameter | Format | Description |
---|---|---|
historyId | String(100) | Game History ID |
roundSeqNo | String(30) | Game round sequence number |
playerId | String(50) | Player ID |
gType | Integer | Game types See Game Provider |
mtype | Integer | Machine Types |
gameDate | String(19) | Date of playing. (dd-MM-yyyy HH:mm:ss) |
bet | Double | Bet amount |
win | Double | Winning points in the game |
validBet | Double | Valid Bet Amount |
commission | Double | Rebate |
total | Double | Total Win Loss |
currency | String(10) | Currency types See Currency Code |
lastModifyTime | String(19) | Last modified time. (dd - MM - yyyy HH: mm: ss) |
beforeBalance | String(20) | Balance before playing |
afterBalance | String(20) | Balance after playing |
Operation Sample
// Http Request
http://{API_Address}/apiRequest.do?dc=jb&x=udbFVt_xv0tsAmLDpz5Z3Ct4-p0gedUPdQOUWsfd6PHz9Ky-wM3mIC9El4kwl_SlX3lpraVaCLnpK0WsgKmpYTV9XpYncHzbtvn591qfaAwpGyOvsS4v1Yj7OvpRw_iU4554RuSsvHpI9jaj4XUgTK5yzb
WKEddANjAAbxF0s=
// Http Response (success)
{
"status": "0000",
"data": [
{
"historyId": "5250145823902",
"playerId": "test01",
"gType": 0,
"mtype": 8001,
"gameDate": "06-06-2017 09:56:09",
"bet": -0.4,
"win": 0.4,
"total": 0,
"currency": "RB",
"jackpot": 0,
"jackpotContribute": -0.002,
"denom": 0.02,
"lastModifyTime": "06-06-2017 09:56:09",
"playerIp": "10.20.6.86",
"clientType": "WEB",
"hasFreegame": 0,
"systemTakeWin": 0,
"transferId":100001,
"beforeBalance": "8477.425",
"afterBalance": "8477.425"
},
{
"historyId": "5250228066060",
"playerId": "test01",
"gType": 0,
"mtype": 14001,
"gameDate": "18-07-2023 14:24:22",
"bet": -1,
"win": 2.3,
"total": 1.3,
"currency": "RB",
"jackpot": 0,
"jackpotContribute": -0.005,
"denom": 0.05,
"lastModifyTime": "18-07-2023 14:24:22",
"playerIp": "10.20.6.86",
"clientType": "WEB",
"hasFreegame": 0,
"systemTakeWin": 0,
"transferId":100002,
"beforeBalance": "8477.425",
"afterBalance": "8478.725"
},
{
"historyId": "43579741",
"playerId": "test01",
"gameDate": "07-06-2017 16:21:48",
"gType": 7,
"mtype": 7001,
"roomType": 1,
"currency": "RB",
"bet": -62.5,
"win": 19.75,
"total": -42.75,
"denom": 5,
"beforeBalance": 200095.6,
"afterBalance": 200052.85,
"lastModifyTime": "07-06-2017 16:21:55",
"playerIp": "10.20.6.86",
"clientType": "WEB",
"transferId":100003
},
{
"historyId": "5250152072553",
"playerId": "test01",
"gType": 9,
"mtype": 9001,
"gameDate": "25-07-2018 18:49:01",
"bet": -90,
"gambleBet": 0,
"win": 20,
"total": -70,
"currency": "RB",
"denom": 1,
"lastModifyTime": "25-07-2018 18:49:06",
"playerIp": "10.20.9.250",
"clientType": "WEB",
"hasBonusGame": 0,
"hasGamble": 0,
"transferId":100004,
"beforeBalance": "8477.425",
"afterBalance": "8407.425"
},
{
"historyId": "5250152072557",
"playerId": "test01",
"gType": 9,
"mtype": 9001,
"gameDate": "25-07-2018 18:49:10",
"bet": 0,
"gambleBet": -20,
"win": 40,
"total": 20,
"currency": "RB",
"denom": 1,
"lastModifyTime": "25-07-2018 18:49:15",
"playerIp": "10.20.9.250",
"clientType": "WEB",
"hasBonusGame": 0,
"hasGamble": 1,
"transferId":100005,
"beforeBalance": "8477.425",
"afterBalance": "8497.425"
},
{
"historyId": "5250147282661",
"playerId": "test01",
"gType": 12,
"mtype": 12001,
"gameDate": "14-05-2018 14:53:53",
"bet": -0.08,
"win": 0.05,
"total": -0.03,
"currency": "TB",
"denom": 0.01,
"lastModifyTime": "14-05-2018 14:53:53",
"playerIp": "10.20.9.250",
"clientType": "WEB",
"hasBonusGame": 0,
"transferId":100006,
"beforeBalance": "8477.425",
"afterBalance": "8477.395"
},
{
"historyId": "5250147282662",
"playerId": "test01",
"gType": 12,
"mtype": 12001,
"gameDate": "14-05-2018 14:53:57",
"bet": -0.08,
"win": 0.05,
"total": -0.03,
"currency": "TB",
"denom": 0.01,
"lastModifyTime": "14-05-2018 14:53:57",
"playerIp": "10.20.9.250",
"clientType": "WEB",
"hasBonusGame": 0,
"transferId":100007,
"beforeBalance": "8477.425",
"afterBalance": "8477.395"
},
{
"historyId": "525056886488",
"playerId":"testpl01",
"gType":66,
"mtype":66001,
"gameDate":"03-05-2019 16:34:29",
"bet":-0.05,
"win":0,
"total":-0.05,
"currency":"TB",
"jackpot":0,
"jackpotContribute":-0.00025,
"denom":0.001,
"lastModifyTime":"03-05-2019 16:34:29",
"gameName":"",
"playerIp":"10.20.9.250",
"clientType":"WEB",
"hasFreegame":0,
"systemTakeWin":0,
"transferId":100008,
"beforeBalance": "8477.425",
"afterBalance": "8483.125"
},
{
"historyId": "5250568864780",
"playerId":"testpl01",
"gameDate":"03-05-2019 16:32:42",
"gType":67,
"mtype":67001,
"roomType":0,
"gameName":"",
"currency":"TB",
"bet":-0.22,
"win":0,
"total":-0.22,
"denom":1,
"beforeBalance":111656.22,
"afterBalance":111656,
"lastModifyTime":"03-05-2019 16:32:42",
"playerIp":"10.20.9.250",
"clientType":"WEB",
"transferId":100009,
"beforeBalance": "8477.425",
"afterBalance": "8477.205"
},
{
"historyId": "5250155819867",
"roundSeqNo":5558,
"playerId":"test888",
"gType":18,
"mtype":18001,
"gameDate":"13-07-2018 14:07:33",
"bet":-2,
"win":6,
"tax":-0.3,
"total":5.7,
"currency":"TB",
"lastModifyTime":"13-07-2018 14:07:33",
"playerIp":"10.20.9.250",
"clientType":"WEB",
"validBet":-2,
"transferId":100010,
"beforeBalance": "8477.425",
"afterBalance": "8483.125"
},
{
"historyId": "5250189245682",
"playerId": "test01",
"gType": 22,
"mtype": 22004,
"gameDate": "07-12-2021 17:46:18",
"bet": -50,
"win": 60,
"total": 10,
"currency": "TB",
"lastModifyTime": "07-12-2021 17:46:18",
"playerIp": "1.2.3.4",
"clientType": "desktop",
"roundSeqNo":"1159054520",
"beforeBalance": "8477.425",
"afterBalance": "8477.125",
"transferId":100011
},
{
"historyId": "asf135456b4gt",
"playerId": "test01",
"gType": 30,
"mtype": 30001,
"gameDate": "20-10-2022 15:33:41",
"bet": -0.4,
"win": 0.0,
"total": -0.4,
"currency": "RB",
"lastModifyTime": "20-10-2022 15:33:41",
"beforeBalance": "8477.425",
"afterBalance": "8477.025",
"transferId":100012
},
{
"historyId": "iu4541gf6v",
"playerId": "test01",
"gType": 31,
"mtype": 31003,
"gameDate": "20-10-2022 15:34:15",
"bet": -4.0,
"win": 100.0,
"total": 96.0,
"currency": "RB",
"lastModifyTime": "20-10-2022 15:34:15",
"beforeBalance": "8477.425",
"afterBalance": "9453.425",
"transferId":100013
},
{
"historyId": "y74u6854v1a",
"playerId": "test01",
"gType": 32,
"mtype": 32016,
"gameDate": "20-10-2022 15:34:58",
"bet": -0.5,
"win": 0.0,
"total": -0.5,
"currency": "RB",
"lastModifyTime": "20-10-2022 15:34:58",
"beforeBalance": "8477.425",
"afterBalance": "8476.925",
"transferId":100014
},
{
"historyId":"1846626470",
"playerId": "ybtest01",
"gType": 58,
"mtype": 58001,
"gameDate": "12-10-2023 16:23:15",
"bet": -6.0,
"win": 4.8,
"total": -1.2,
"currency": "RB",
"lastModifyTime": "12-10-2023 16:23:15",
"beforeBalance": "8477.425",
"afterBalance": "8476.225",
"transferId":100015
},
{
"historyId":"1846626471",
"playerId": "ybtest01",
"gType": 59,
"mtype": 59001,
"gameDate": "12-10-2023 16:23:15",
"bet": -6.0,
"win": 4.8,
"total": -1.2,
"currency": "RB",
"lastModifyTime": "12-10-2023 16:23:15",
"beforeBalance": "8477.425",
"afterBalance": "8476.225",
"transferId":100016
},
{
"historyId":"1846626472",
"playerId": "ybtest01",
"gType": 60,
"mtype": 60001,
"gameDate": "12-10-2023 16:23:15",
"bet": -6.0,
"win": 4.8,
"total": -1.2,
"currency": "RB",
"lastModifyTime": "12-10-2023 16:23:15",
"beforeBalance": "8477.425",
"afterBalance": "8476.225",
"transferId":100017
},
{
"historyId": "AAA-212256709",
"gameRoundSeqNo": "RND-0020107870010",
"playerId": "testpl01",
"gType": 41,
"mtype": 41001,
"gameDate": "14-11-2023 16:13:16",
"bet": -500,
"win": 0,
"validBet": 0,
"commission": 0,
"total": -500,
"currency": "RB",
"lastModifyTime": "14-11-2023 16:14:04",
"beforeBalance": "8477.425",
"afterBalance": "7977.425"
},
{
"historyId": "57762",
"playerId": "test01",
"gType": 120,
"mtype": 120001,
"gameDate": "18-10-2024 16:23:15",
"bet": -0.4,
"win": 0.0,
"total": -0.4,
"currency": "RB",
"lastModifyTime": "18-10-2024 16:23:15",
"beforeBalance": "8477.425",
"afterBalance": "8477.025",
"transferId":100018
},
{
"historyId": "d9ffdc62-557a-4961-8d08-57d4e01c36cb",
"playerId": "smartsoft01",
"gType": 130,
"mtype": 130001,
"gameDate": "18-11-2024 16:23:15",
"bet": -5.4,
"win": 0.0,
"total": -5.4,
"currency": "RB",
"lastModifyTime": "18-11-2024 16:23:15",
"beforeBalance": "8477.425",
"afterBalance": "8472.025",
"transferId":100019
}
]
}
// Http Response (error)
{
"status":"9005",
"err_text":"Assertion(SAML) didn't pass the timestamp validation."
}
// Http Response (no data)
{
"status":"0000",
"data":[]
}