<?php
include "include.php";
$sqlRequest = $db->query('SELECT r.id, r.itemUniqueId, botId, tradeUrl FROM requests r INNER JOIN users u ON u.id = r.userId INNER JOIN stocks s ON s.itemUniqueId = r.itemUniqueId WHERE state = 1');
$data = [];
while($request = $sqlRequest->fetch())
{
    $requestId = $request['id'];
    $tradeUrl = $request['tradeUrl'];
    $botId = $request['botId'];
    $itemId = $request['itemUniqueId'];
    $tradeUrlParams = explode("?", $request['tradeUrl'])[1];
    parse_str($tradeUrlParams, $params);
    $userSteamId = $params['partner'] + 76561197960265728;
    $userToken = $params['token'];
    $listing = array(
        'order_id' => (string)$requestId,
        'user_id' => $userSteamId,
        'bot_id' => $botId,
        'token' => $userToken,
        'item' => $itemId
    );
    array_push($data, array(
        'event' => 'requestItems',
        'data' => $listing)
    );
}
echo json_encode($data);
?>