Convert PHP script to MySQL Stored Procedure

Hello, I need help converting 2 PHP scripts into a MySQL stored procedure. In a nutshell: SCRIPT 1: [login to view URL] 1. The script reads from a the database to get a list of "EVENT_ID"s to update 2. For each of the EVENT_IDs, the script calls a STUBHUB API to retrieve latest TICKETs 3. The scripts reads the JSON result and writes the results to the database. 4. The script then calls a STUBHUB API to update the EVENT table with the lastest information SCRIPT 2: [login to view URL] 1. This script reads the MYTICKETS table to identify tickets to update. 2. The script then updates the record with the latest run date for the EVENT_ID (Events Table) and the TICKET_ID (tickets table).