73 lines
2.4 KiB
PHP
73 lines
2.4 KiB
PHP
<?php
|
|
/**
|
|
* MSIN-3487 — Point d'entrée QR court.
|
|
*
|
|
* Modes :
|
|
* 1) Résultats événement :
|
|
* /kc.php?t=eve&id={eve_id}
|
|
* → inscriptions_evenements_extra.eve_resultats_url
|
|
* → sinon fallback https://ms1.ca
|
|
*
|
|
* 2) Key chain (porte-clés / véhicules) — inchangé :
|
|
* /kc.php?param1={pk_key_chain}
|
|
* → key_chain.key_chain_http
|
|
* → sinon insert + fallback https://ms1.ca
|
|
*/
|
|
session_start();
|
|
global $objDatabase, $vDomaine, $strLangue;
|
|
require_once 'php/inc_fonctions.php';
|
|
|
|
$strType = isset($_GET['t']) ? strtolower(trim((string) $_GET['t'])) : '';
|
|
|
|
// --- MSIN-3487 : redirect résultats par eve_id ---
|
|
if ($strType === 'eve') {
|
|
$intEveId = 0;
|
|
if (isset($_GET['id'])) {
|
|
$intEveId = intval($_GET['id']);
|
|
} elseif (isset($_GET['eve_id'])) {
|
|
$intEveId = intval($_GET['eve_id']);
|
|
}
|
|
|
|
header('Location: ' . fxEveExtraResolveResultatsUrl($intEveId));
|
|
exit;
|
|
}
|
|
|
|
// --- Key chain historique ---
|
|
$key_chain_id = !empty($_GET['param1']) ? intval($_GET['param1']) : 0;
|
|
$defaut_landingpage = fxEveExtraResultatsFallbackUrl();
|
|
|
|
$sqlkey_chain = 'SELECT * FROM key_chain WHERE pk_key_chain = ' . $key_chain_id;
|
|
$infoCompte = $objDatabase->fxGetRow($sqlkey_chain);
|
|
if (!$infoCompte == null) {
|
|
|
|
$mem_count = $infoCompte['key_chain_count'] + 1;
|
|
$update_plus = '';
|
|
if ($infoCompte['key_chain_com_id'] == 0 && isset($_SESSION['com_id'])) {
|
|
$update_plus = 'key_chain_com_id=' . intval($_SESSION['com_id']) . ',';
|
|
}
|
|
|
|
$sqlUpdate = 'UPDATE key_chain SET ' . $update_plus
|
|
. "key_chain_adress_ip='" . $objDatabase->fxEscape($_SERVER['REMOTE_ADDR']) . "',"
|
|
. 'key_chain_count = ' . intval($mem_count)
|
|
. ' WHERE pk_key_chain = ' . $key_chain_id;
|
|
$qryUpdate = $objDatabase->fxQuery($sqlUpdate);
|
|
|
|
header('Location: ' . $infoCompte['key_chain_http']);
|
|
} else {
|
|
if (isset($_SESSION['com_id'])) {
|
|
$mem_com_id = intval($_SESSION['com_id']);
|
|
} else {
|
|
$mem_com_id = 0;
|
|
}
|
|
|
|
$sqlUpdate = 'INSERT key_chain SET key_chain_com_id=' . $mem_com_id
|
|
. ',key_chain_timestamp=now(),'
|
|
. "key_chain_http='" . $objDatabase->fxEscape($defaut_landingpage) . "',"
|
|
. "key_chain_adress_ip='" . $objDatabase->fxEscape($_SERVER['REMOTE_ADDR']) . "',"
|
|
. 'key_chain_count = 1,pk_key_chain=' . $key_chain_id;
|
|
$qryUpdate = $objDatabase->fxQuery($sqlUpdate);
|
|
|
|
header('Location: ' . $defaut_landingpage);
|
|
}
|
|
exit;
|