$curdate = '';
while (($row = $result_set -> fetch_assoc()) != false) {
$date = sdate("M Y", 0, $row["date"]);
if ($curdate != $date) {
echo "<h2>Отчетность за ".sdate("M Y", 0, $row["date"])."</h2>";
$curdate = $date;
}
echo "<a href=\"".$row["link"]."\">".$row["name"]."</a>";
echo "<span>(".fdate("d M Y h:i", 0, $row["date"]).")</span><hr>";
}$params["image_url"] = (isset($array['image_url']) ? $array['image_url'] : NULL);
UPDATE ... `image_url` = IFNULL(:image_url, `image_url`) ...<?php
$json = file_get_contents('730.json');
$result = array();
$data = json_decode($json, true);
foreach ($data as $name => $value) {
$result[] = array("market_hash_name" => $name,
"price" => array_shift(array_pop($value)));
}
file_put_contents('opskins.json', json_encode(array("prices" => $result)));
?>SET NAMES cp866
SELECT `s`.`user`, `u`.`name`, `s`.`OCI`, `s`.`OCO`, `s`.`CCP`, `s`.`PV`, `us`.`total_games`,
`s2`.`total_games` AS `today_games`, `s3`.`total_games` AS `yesterday_games`,
`s4`.`date` AS `high_OCI_date`
FROM `qz_user_stat_date` AS `s`
JOIN `qz_users` AS `u` ON `u`.`id` = `s`.`user`
JOIN `qz_user_stat` AS `us` ON `us`.`user` = `s`.`user`
LEFT JOIN `qz_user_stat_date` AS `s2` ON `s2`.`user` = `s`.`user` AND `s2`.`date` = :today
LEFT JOIN `qz_user_stat_date` AS `s3` ON `s3`.`user` = `s`.`user` AND `s3`.`date` = :yesterday
LEFT JOIN (
SELECT `t`.`user` AS `usr`, min(`t`.`date`) AS `date`
FROM `qz_user_stat_date` AS `t`
JOIN (
SELECT `user`, max(`OCI`) AS `oci`
FROM `qz_user_stat_date`
GROUP BY `user`
) AS `o` ON `o`.`user` = `t`.`user` AND `o`.`oci` = `t`.`OCI`
GROUP BY `t`.`user`
) AS `s4` ON `s4`.`usr` = `s`.`user`SELECT `post_id` FROM `posts` WHERE `author_id` IN (:id1, :id2, :id3)SELECT `p1`.`post_id`
FROM `posts` AS `p1`
JOIN `posts` AS `p2`
ON `p2`.`post_id` = `p1`.`post_id` AND `p2`.`author_id` = :id2
JOIN `posts` AS `p3`
ON `p3`.`post_id` = `p1`.`post_id` AND `p3`.`author_id` = :id3
WHERE `p1`.`author_id` = :id1