Pablo Grassi's questions

I have a table of matches where I want to obtain the sum of the points of the players, the player is crossed with the player table where the id is the identifier, in the game table the player can appear in both player_a and player_b, that is, when I do the sum of the points of the players I look for the id of the player in the two columns. I get stuck a bit with the query and I can't solve it, it adds the points only when the id corresponds to player_a, but it doesn't add when the points correspond to the id of player_b.

SELECT
    (puntos_a + puntos_b) AS puntos,
    id
FROM
    (
    SELECT
        SUM(puntos_jugador_a) AS puntos_a,
        0 AS puntos_b,
        jugador_a AS id
    FROM
        game
    WHERE
        torneo_organizacion = "MZF-CAB"
    GROUP BY
        jugador_a
    UNION ALL
SELECT
    0 AS puntos_a,
    SUM(puntos_jugador_b) AS puntos_b,
    jugador_b AS id
FROM
    game
WHERE
    torneo_organizacion = "MZF-CAB"
GROUP BY
    jugador_b
) t
GROUP BY
    id

I want to join these two queries into one and add the two results:

SELECT torneo_organizacion, jugador_a, SUM( puntos_jugador_a ) AS total FROM game
WHERE torneo_organizacion = "MZF-CAB" AND jugador_a = 125
AND fecha_partido >= ( CURDATE( ) - INTERVAL 365 DAY ) 

SELECT torneo_organizacion, jugador_b, SUM( puntos_jugador_b ) AS total FROM game
WHERE torneo_organizacion = "MZF-CAB" AND jugador_b = 125
AND fecha_partido >= ( CURDATE( ) - INTERVAL 365 DAY ) 

I have a problem in a part of the code where I get the error Warning: Each child in a list should have a unique "key" prop. , I have added the key property but having an if inside the map gives me that warning. If I delete the if and try leaving one of the components the error is not shown but if I do the if it is shown.

return(
       
            <div className="main">
                {video.map(vid => (
                    <>
                    { vid.video !== '' ? (  
                         <VideoPlayer id={vid.id} video={vid.video} name={vid.name} poster={vid.poster} key={vid.id}  />
                    ) : (
                        <ImgNoVideo id={vid.id} url={vid.url} name={vid.name} poster={vid.poster} key={vid.id} />
                    )}
                    </>
                ))}
            </div>
    );

I have a table of players where I have all the data of the players, in this case the name and surname, then I have another table where I have match results, in that match results table I have two fields called player_a and player_b ( these two fields are part of the same record), these fields have the id that corresponds to the id of the players table. What I need is to know how I get the name and surname of the two players in the same query. I can only get the first and last name of one of the players but not both. I leave the query I made as an example.

SELECT nombre.jugadores, apellido.jugadores from jugadores INNER JOIN juegos ON jugadores.id = juegos.jugador_a WHERE id = 170  

I have the following code where I am validating receipts in an api and then I do an update in my base of what has changed in that receipt; what is happening to me is that at this moment in the base I have more than 1000 results but it is updating only one after it does the verification in the api, it updates one and throws a warning and does nothing else.

The mistake is. Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, string given in /var/www/custom-webservices/public/lemonchilli/cron/cron.php on line 23

require_once '../db_connect.php';

if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$query = "SELECT * FROM jsonapple WHERE status='freetrial' AND expires_date_formatted_pst < (CURDATE() + INTERVAL 7 DAY) OR status='Active' AND expires_date_formatted_pst < (CURDATE() + INTERVAL 7 DAY) OR status='freetrial' AND auto_renew_status='false'";

$result = mysqli_query($conn, $query);

$sql = '';

if ($result) {

$count = 0;
while ($row = mysqli_fetch_assoc($result)) {
    $count++;
    $latest_receipt = $row["latest_receipt"];

    $url = 'https://xxx/apple/verifyReceipt';

    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_POST, 2);
    curl_setopt($ch, CURLOPT_POSTFIELDS, 'token=xxx&receiptb64=' . $latest_receipt . '');
    $result = curl_exec($ch);
    //print $result;
    curl_close($ch);

    if (($count % 200) == 0) {
        sleep(5);
    }

    $obj = json_decode($result, true);

    if ($obj["auto_renew_status"] == 1) {
        $auto_renew_status = 'true';
    } else {
        $auto_renew_status = 'false';
    }

    $status = $obj["status"];
    if (isset($obj["expiration_intent"])) {
        $expiration_intent = $obj["expiration_intent"];
    } else {
        $expiration_intent = '';
    }
    if (isset($obj["is_in_billing_retry_period"])) {
        $is_in_billing_retry_period = $obj["is_in_billing_retry_period"];
    } else {
        $is_in_billing_retry_period = '';
    }


    if ($status == 0 || $status == 21006) {

        if ($status == 21006) {
            $status_row = 'Expired';
        } else {
            if ($obj["auto_renew_status"] == 1 && $obj["latest_receipt_info"]["is_trial_period"] == 'true') {
                $status_row = 'Active';
            }
            elseif ($obj["auto_renew_status"] == 0 && $obj["latest_receipt_info"]["is_trial_period"] == 'true') {
                $status_row = 'FreeTrial';
            }
            elseif ($obj["auto_renew_status"] == 1 && $obj["latest_receipt_info"]["is_trial_period"] == 'false') {
                $status_row = 'Active';
                $payment    = 1;
            }
            elseif ($obj["auto_renew_status"] == 0 && $obj["latest_receipt_info"]["is_trial_period"] == 'false') {
                $status_row = 'Expired';
            }

        }

    } else {
        $status_row = 'Review response';
    }
    $sql .= "UPDATE jsonapple SET status='$status_row', expiration_intent='$expiration_intent', auto_renew_status='$auto_renew_status', is_in_billing_retry_period='$is_in_billing_retry_period', status_code ='$status', payment='$payment' WHERE latest_receipt='$latest_receipt'; ";
}


if ($conn->query($sql) === TRUE) {
    echo "Successfully" . $sql . "<br>";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}
} 

$conn->close();

I have these 2 queries in phpwhich I use them to show a table, the first groups all the results by the idlargest registered in the database, based on the field u nique_vendor_identifierand the second query, adds the field paymentand groups it based on the field, unique_vendor_identifierignoring the duplicate entries that are exactly the same in all of their rows.

What I want is to join the 2 queries into one, that is, to combine them, so that the table continues to show grouped by unique_vendor_identifierthe last of that identifier in all its rows and in turn shows me in the field paymentthe sum of the field paymentgrouped by unique_vendor_identifier.

question 1

SELECT * 
FROM jsonapple 
WHERE id IN ( SELECT MAX(id) FROM jsonapple GROUP BY unique_vendor_identifier)

query 2

SELECT payment, SUM(payment) 
FROM (SELECT unique_vendor_identifier, payment 
FROM jsonapple 
GROUP BY unique_vendor_identifier, payment) A group by unique_vendor_identifier

TABLE

CREATE TABLE `jsonapple` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `latest_receipt` varchar(8000) DEFAULT NULL,
  `original_purchase_date_pst` varchar(255) DEFAULT NULL,
  `quantity` int(100) DEFAULT NULL,
  `unique_vendor_identifier` varchar(255) DEFAULT NULL,
  `original_purchase_date_ms` bigint(255) DEFAULT NULL,
  `expires_date_formatted` varchar(255) DEFAULT NULL,
  `is_in_intro_offer_period` varchar(255) DEFAULT NULL,
  `purchase_date_ms` bigint(255) DEFAULT NULL,
  `expires_date_formatted_pst` varchar(255) DEFAULT NULL,
  `is_trial_period` varchar(100) DEFAULT NULL,
  `item_id` bigint(255) DEFAULT NULL,
  `unique_identifier` varchar(255) DEFAULT NULL,
  `original_transaction_id` bigint(255) DEFAULT NULL,
  `expires_date` bigint(255) DEFAULT NULL,
  `app_item_id` bigint(255) DEFAULT NULL,
  `transaction_id` bigint(255) DEFAULT NULL,
  `bvrs` int(100) DEFAULT NULL,
  `web_order_line_item_id` bigint(255) DEFAULT NULL,
  `version_external_identifier` bigint(255) DEFAULT NULL,
  `bid` varchar(255) DEFAULT NULL,
  `product_id` varchar(255) DEFAULT NULL,
  `purchase_date` varchar(255) DEFAULT NULL,
  `purchase_date_pst` varchar(255) DEFAULT NULL,
  `original_purchase_date` varchar(255) DEFAULT NULL,
  `environment` varchar(100) DEFAULT NULL,
  `auto_renew_status` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `auto_renew_product_id` varchar(255) DEFAULT NULL,
  `notification_type` varchar(255) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `status_code` int(20) DEFAULT NULL,
  `campaign` varchar(1000) DEFAULT NULL,
  `traffic_source` varchar(255) DEFAULT NULL,
  `expiration_intent` int(11) DEFAULT NULL,
  `is_in_billing_retry_period` int(11) DEFAULT NULL,
  `acquisition_campaign` varchar(20) DEFAULT NULL,
  `payment` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;