Change API call and rewrite some API calls

Work to be done using Teamviewer on my Server with linux centos. 1st. GAME NEW API call example PLAYER has 5 ENTRIES Add “customerplay_id” when customer makes purchase from POS or Bill Acceptor sweepstickets column "sweeps_id" "ticket" "prize" “customer_id”, “issued”, “revealed”, “customerplay_id” sweep_id ticket prize update only update only 7 12 0 5 2017-07-02 09:08:57 NULL 4180 74 13 0 5 2017-07-02 09:08:57 NULL 4181 74 14 1400 5 2017-07-02 09:08:57 NULL 4182 74 15 120 5 2017-07-02 09:08:57 NULL 4183 74 16 0 5 2017-07-02 09:08:57 NULL 4184 Example: The tickets above belong to player number 5 (customer_id ) No other player can play these tickets (records) How the game API call works now in game play and what you should change Now when the game is played the API call get tickets randomly when played it updates record Record is updates as you see below sweepstickets column “customer_id”, “issued”, “revealed”, “customerplay_id” 5 2017-07-02 09:08:57 2017-07-02 10:08:57 4180 You would just remove from the API call where it updates the “customer id” The NEW API call should only update “revealed” & “customerplay_id” Example of played record You have to make sure the changes don't brake anything in the database =================================-================================= See webpage [login to view URL] I’m on skype all the time syitsmagic 2nd. NEW API CALL WOULD LOOK SOMETHING LIKE THIS BELOW 2nd Write API to show player's next play without changing anything in the database. [login to view URL]{32c15901-df6a-4a36-9de7-1d578567bf1e}&random=879%2E9989707767963&pot=62&req=nextplay Also need new API for REVEAL. I think not sure If you can do this job easy then I have other work on POS and Bill Acceptor