blob: 2b772770018a09eae012af2aaf9a37b1df726b8d [file] [log] [blame]
<?php
/*
* hores
* Copyright (c) 2023 Adrià Vilanova Martínez
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public
* License along with this program.
* If not, see http://www.gnu.org/licenses/.
*/
class help {
const PLACE_INCIDENT_FORM = 0;
const PLACE_VALIDATION_PAGE = 1;
const PLACE_REGISTRY_PAGE = 2;
const PLACE_EXPORT_REGISTRY_PAGE = 3;
public static $places = [0, 1, 2, 3];
public static $placesName = [
0 => "Formulario de incidencias",
1 => "Página de validación",
2 => "Página de listado de registros",
3 => "Página de exportar registro"
];
public static function exists($place) {
global $con;
$splace = (int)$place;
$query = mysqli_query($con, "SELECT 1 FROM help WHERE place = $splace");
return (mysqli_num_rows($query) > 0);
}
public static function set($place, $url) {
global $con;
if (!in_array($place, self::$places)) return -1;
if ($url !== "" && !filter_var($url, FILTER_VALIDATE_URL)) return 1;
$splace = (int)$place;
$surl = db::sanitize($url);
if (self::exists($place)) return (mysqli_query($con, "UPDATE help SET url = '$surl' WHERE place = $splace LIMIT 1") ? 0 : -1);
else return (mysqli_query($con, "INSERT INTO help (place, url) VALUES ('$splace', '$surl')") ? 0 : -1);
}
public static function get($place) {
global $con;
if (!in_array($place, self::$places)) return false;
$splace = (int)$place;
$query = mysqli_query($con, "SELECT url FROM help WHERE place = $splace");
if (mysqli_num_rows($query) > 0) {
$url = mysqli_fetch_assoc($query)["url"];
return ($url === "" ? false : $url);
} else return false;
}
}