x-tools / xtools

                      WHERE date = '$date'

                      AND tool = '$tool'";

        if (count($conn->query($existsSql)->fetchAll()) === 0) {

            $createSql = "INSERT INTO usage_timeline

                          VALUES(NULL, '$date', '$tool', 1)";

            $conn->query($createSql);

        } else {

            $updateSql = "UPDATE usage_timeline

                          SET count = count + 1

                          WHERE tool = '$tool'

                          AND date = '$date'";

            $conn->query($updateSql);

        }

        // Update per-project usage, if applicable

        if (!$this->container->getParameter('app.single_wiki')) {

                          WHERE tool = '$tool'

                          AND project = '$project'";

            if (count($conn->query($existsSql)->fetchAll()) === 0) {

                $createSql = "INSERT INTO usage_projects

                              VALUES(NULL, '$tool', '$project', 1)";

                $conn->query($createSql);

            } else {

                $updateSql = "UPDATE usage_projects

                              SET count = count + 1

                              WHERE tool = '$tool'

                              AND project = '$project'";

                $conn->query($updateSql);

            }

        }

        $response->setStatusCode(Response::HTTP_NO_CONTENT);

                      WHERE date = '$date'

                      AND endpoint = '$endpoint'";

        if (count($conn->query($existsSql)->fetchAll()) === 0) {

            $createSql = "INSERT INTO usage_api_timeline

                          VALUES(NULL, '$date', '$endpoint', 1)";

            $conn->query($createSql);

        } else {

            $updateSql = "UPDATE usage_api_timeline

                          SET count = count + 1

                          WHERE endpoint = '$endpoint'

                          AND date = '$date'";

            $conn->query($updateSql);

        }

    }

}