prepare('SELECT itemUniqueId, name FROM stocks WHERE botId = ?');
$sqlRequest->execute([$botId]);
$stocksBdd = $sqlRequest->fetchAll();
$stocksBddUniqueIds = [];
$stocksBddName = [];
foreach($stocksBdd as $itemBdd) //Ajout des stocks de la bdd dans deux variables pour les IDs et le noms
{
$stocksBddUniqueIds[] = $itemBdd['itemUniqueId'];
$stocksBddName[] = $itemBdd['name'];
}
$countIdsBot = count($itemUniqueIdsBot); //Nombre d'items du bot
$countIdsBdd = count($stocksBddUniqueIds); //Nombre d'items dans la bdd
$requestInsert = $db->prepare('INSERT INTO stocks (itemUniqueId, name, image, botId, value) VALUES (?, ?, ?, ?, ?)');
$priceItems = [];
for($i = 0 ; $i < $countIdsBot ; $i++)
{
if(!in_array($itemUniqueIdsBot[$i], $stocksBddUniqueIds)) //Si il manque un item on l'ajoute
{
if(!isset($priceItems[$itemNamesBot[$i]]))
{
$priceUrl = "http://csgo.steamlytics.xyz/api/v1/prices/" . $itemNamesBot[$i] . "?key=ef9d9ac33d9ddea444cb1f9961771c39";
$fileText = file_get_contents($priceUrl);
$fileJson = json_decode($fileText);
$price = $fileJson->median_price;
$priceItems[$itemNamesBot[$i]] = $price;
}
else
{
$price = $priceItems[$itemNamesBot[$i]];
}
$requestInsert->execute([$itemUniqueIdsBot[$i], $itemNamesBot[$i], $itemImagesBot[$i], $botId, $price]);
echo "Adding item #" . $itemUniqueIdsBot[$i] . '\n';
$sqlrskin = "INSERT INTO raffle VALUES ('','$nskin','$iskin','$vskin','0','$nbskin','$catskin')";
$sqlrskin = $db->exec($sqlrskin);
if($sqlrskin === false)
{
die('Erreur SQL !
'.$db->errorInfo()[2]);
}
$uid=$db->lastInsertId();
$nomtraffle = 'raffle'.$uid;
$nomtrafflehisto = 'raffle'.$uid.'histo';
$sqlbdd = $db->exec("CREATE TABLE IF NOT EXISTS $nomtraffle (
`id` int(255) NOT NULL AUTO_INCREMENT,
`userid` varchar(255) NOT NULL,
`ticketstart` int(255) NOT NULL,
`ticketend` int(255) NOT NULL,
PRIMARY KEY (`id`)
)");
$sqlbddd = $db->exec("CREATE TABLE IF NOT EXISTS $nomtrafflehisto (
`id` int(255) NOT NULL AUTO_INCREMENT,
`userid` varchar(255) NOT NULL,
`combien` int(255) NOT NULL,
PRIMARY KEY (`id`)
)");
$sqlbbd = "INSERT INTO ".$nomtraffle." VALUES ('','0','0','0')";
$sqlbbdok = $db->exec($sqlbbd );
if($sqlbbdok === false)
{
die('Erreur SQL !
'.$db->errorInfo()[2]);
}
}
}
$requestDelete = $db->prepare('DELETE FROM stocks WHERE itemUniqueId = ?');
for($i = 0 ; $i < $countIdsBdd ; $i++)
{
if(!in_array($stocksBddUniqueIds[$i], $itemUniqueIdsBot)) //Si il y en a un en trop on le retire
{
$requestDelete->execute([$stocksBddUniqueIds[$i]]);
echo "Deleting item #" . $stocksBddUniqueIds[$i] . '\n';
}
}
}
?>