Seamless
JDB Platform API
Functions
Report-Related
Action 64: Search for Old Details of Transactions in Games

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.
  • 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:
    1. If a player bets 10 and wins 100 points in the game
      bet = -10, gambleBet = 0, win = 100, total = 90, hasGamble = 0
    2. 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

Parameter

ParameterFormatMandatoryDescription
actionIntegerY64
tsLongYCurrent system time
parentString(50)YAgent ID
starttimeString(19)YStart time of the searching range (dd-MM-yyyy HH:mm:ss)
endtimeString(19)YEnd time of the searching range (dd-MM-yyyy HH:mm:ss)
gTypesInteger ArrayNGame 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

ParameterFormatDescription
statusString(4)Success: 0000

Error: See Error Codes in Appendix
No Data: 0000
dataJSON ArrayThe returned data will be listed in the following tables.
err_textString(255)Error message

Betting records in slot games: gType = 0, 66, 90


ParameterFormatDescription
historyIdString(100)Game History ID

See Explanation of historyId

playerIdString(50)Player ID
gTypeIntegerGame types

See Game Provider

mtypeIntegerMachine Types
gameDateString(19)Date of playing. (dd-MM-yyyy HH:mm:ss)
betDoubleBet amount
winDoubleWinning points in the game
totalDoubleTotal Win Loss
currencyString(10)Currency types

See Currency Code

jackpotDoubleThe amount of the jackpot won
jackpotContributeDoubleJackpot contributions
denomDoubleBet denomination
lastModifyTimeString(19)Last modified time
playerIpString(50)Player login IP
clientTypeString(20)Player login from website or mobile device.
hasFreegameIntegerFree game
0: No
1: Yes
systemTakeWinIntegerMark this as the interruption if the game and it will be settled by the system.
0: No
1: Yes
beforeBalanceString(20)Balance before playing
afterBalanceString(20)Balance after playing
transferIdLongTransfer ID

Betting records in fishing game: gType = 7, 67, 91


ParameterFormatDescription
historyIdString(100)Game History ID

See Explanation of historyId

playerIdString(50)Player ID
gTypeIntegerGame types

See Game Provider

mtypeIntegerMachine Types
gameDateString(19)Date of playing. (dd-MM-yyyy HH:mm:ss)
roomTypeIntegerGame Room
-1: Lobby (Achievement Game)
0: Small Bet
1: Medium sized bet
2: Large bet
Real naming of game room differentiated by Machine Type
currencyString(10)Currency types

See  Currency Code

betDoubleBet amount
winDoubleWinning points in the game
totalDoubleTotal Win Loss
denomDoubleBet denomination
beforeBalanceDoubleBalance before playing
afterBalanceDoubleBalance after playing
lastModifyTimeString(19)Last modified time. (dd - MM - yyyy HH: mm: ss)
playerIpString(50)Player login IP
clientTypeString(20)Player login from website or mobile device
transferIdLongTransfer ID
If 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


ParameterFormatDescription
historyIdString(100)Game History ID

See Explanation of historyId

playerIdString(50)Player ID
gTypeIntegerGame types

See Game Provider

mtypeIntegerMachine Types
gameDateString(19)Date of playing. (dd-MM-yyyy HH:mm:ss)
betDoubleBet amount
gambleBetDoubleBet amount in Gambling games
winDoubleWinning points in the game
totalDoubleTotal Win Loss
currencyString(10)Currency types

See  Currency Code

denomDoubleBet denomination
lastModifyTimeString(19)Last modified time. (dd - MM - yyyy HH: mm: ss)
playerIpString(50)Player login IP
clientTypeString(20)Player login from website or mobile device
hasBonusGameIntegerBonus game
0: No
1: Yes
hasGambleIntegerGambling Game
0: No
1: Yes
beforeBalanceString(20)Balance before playing
afterBalanceString(20)Balance after playing
transferIdLongTransfer ID

Betting records in Lottery Game: gType = 12


ParameterFormatDescription
historyIdString(100)Game History ID

See Explanation of historyId

playerIdString(50)Player ID
gTypeIntegerGame types

See Game Provider

mtypeIntegerMachine Types
gameDateString(19)Date of playing. (dd-MM-yyyy HH:mm:ss)
betDoubleBet amount
winDoubleWinning points in the game
totalDoubleTotal Win Loss
currencyString(10)Currency types

See  Currency Code

denomDoubleBet denomination
lastModifyTimeString(19)Last modified time. (dd - MM - yyyy HH: mm: ss)
playerIpString(50)Player login IP
clientTypeString(20)Player login from website or mobile device
hasBonusGameIntegerBonus game
0: No
1: Yes
beforeBalanceString(20)Balance before playing
afterBalanceString(20)Balance after playing
transferIdLongTransfer ID

Betting records in Card Games: gType = 18, 93


ParameterFormatDescription
historyIdString(100)Game History ID

See Explanation of historyId

roundSeqNoLongGame round sequence number
playerIdString(50)Player ID
gTypeIntegerGame types

See Game Provider

mtypeIntegerMachine Types
gameDateString(19)Date of playing. (dd-MM-yyyy HH:mm:ss)
betDoubleBet amount
winDoubleWinning points in the game
taxDoublePlayer pay winning tax in the game
totalDoubleTotal Win Loss
currencyString(10)Currency types

See  Currency Code

lastModifyTimeString(19)Last modified time. (dd - MM - yyyy HH: mm: ss)
playerIpString(50)Player login IP
clientTypeString(20)Player login from website or mobile device
validBetDoubleValid Bet Amount
beforeBalanceString(20)Balance before playing
afterBalanceString(20)Balance after playing
transferIdLongTransfer 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)


ParameterFormatDescription
historyIdString(100)Game History ID

See Explanation of historyId

playerIdString(50)Player ID
gTypeIntegerGame types

See Game Provider

mtypeIntegerMachine Types
gameDateString(19)Date of playing. (dd-MM-yyyy HH:mm:ss)
betDoubleBet amount
winDoubleWinning points in the game
totalDoubleTotal Win Loss
currencyString(10)Currency types

See  Currency Code

lastModifyTimeString(19)Last modified time. (dd - MM - yyyy HH: mm: ss)
beforeBalanceString(20)Balance before playing
afterBalanceString(20)Balance after playing
transferIdLongTransfer ID

Betting records in HRG: gType = 41


ParameterFormatDescription
historyIdString(100)Game History ID

See Explanation of historyId

roundSeqNoString(30)Game round sequence number
playerIdString(50)Player ID
gTypeIntegerGame types

See Game Provider

mtypeIntegerMachine Types
gameDateString(19)Date of playing. (dd-MM-yyyy HH:mm:ss)
betDoubleBet amount
winDoubleWinning points in the game
validBetDoubleValid Bet Amount
commissionDoubleRebate
totalDoubleTotal Win Loss
currencyString(10)Currency types

See  Currency Code

lastModifyTimeString(19)Last modified time. (dd - MM - yyyy HH: mm: ss)
beforeBalanceString(20)Balance before playing
afterBalanceString(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":[]
}