function load_project($username, $project_url_name)
{
$account = account_id_from_username($username);
$sql = "SELECT project_head.project, name, spec_link, img_link, created, modified";
$sql .= " FROM project_info";
$sql .= " INNER JOIN project_head";
$sql .= " ON project_head.project = project_info.project";
$sql .= " WHERE project_head.owner={$account}";
$sql .= " AND project_info.url_name='{$project_url_name}'";
$result = query($sql);
if ($result == false || mysqli_num_rows($result) <= 0) {
echo "project-not-found";
return;
}
print_r(sql_to_json($result));
}
IF(vend_log.enq_datetime >= DATE_SUB(NOW(), INTERVAL 1 DAY), members.member_id, NULL) AS last_day,
IF(vend_log.enq_datetime >= DATE_SUB(NOW(), INTERVAL 1 WEEK), members.member_id, NULL) AS last_week,
IF(vend_log.enq_datetime >= DATE_SUB(NOW(), INTERVAL 1 MONTH), members.member_id, NULL) AS last_month,
IF(vend_log.enq_datetime >= DATE_SUB(NOW(), INTERVAL 1 QUARTER), members.member_id, NULL) AS last_quarter,
IF(vend_log.enq_datetime >= DATE_SUB(NOW(), INTERVAL 1 YEAR), members.member_id, NULL) AS last_year,
members.member_id AS anytime
FROM
members
JOIN vend_log ON members.member_id = vend_log.member_id
JOIN
(
SELECT
vend_log.member_id,
MAX(vend_log.enq_datetime) max_enq_datetime
FROM
vend_log
GROUP BY
vend_log.member_id
) max_vend_log ON
vend_log.member_id = max_vend_log.member_id
AND
vend_log.enq_datetime = max_vend_log.max_enq_datetime
WHERE
members.member_status = 5
) stats;
SQL;
print sql_to_json(db_pdo_link(), $sql);
function load_blog_body($blog_id)
{
$sqlBlogInfo = "SELECT * FROM blog_info WHERE blog={$blog_id}";
$result = query($sqlBlogInfo);
if (mysqli_num_rows($result) != 1) {
echo '{"result": "load-blog-body-error"}';
return;
}
echo sql_to_json($result);
}
