Modificare il chat save per selezionare luogo e ora

<?php
#################################################################################
# ##
# Save Chat HTML 1.3 - Author eLDiabolo ##
# ##
# e-mail: http://www.gdr-online.com/email.asp?email=eldiabolo ##
# ##
##################################################################################
#################################################################################

session_start();

/* Includo i file necessari */
include('includes/constant_values.inc.php');
include('config.inc.php');
include('vocabulary/' . $PARAMETERS['languages']['set'] . '.vocabulary.php');
include('includes/functions.inc.php');

/* Eseguo la connessione al database */
$handleDBConnection = gdrcd_connect();

$typeOrder = ($PARAMETERS['mode']['chat_from_bottom'] == 'ON') ? 'DESC' : 'ASC';

/*Query per caricamento dati dalla chat corrente, carica le azioni degli ultimi 240 min - 4 ore !! NON SALVA LE CHAT PRIVATE !!*/

if ($PARAMETERS['mode']['chatsavepvt'] == 'ON')
{
$query = gdrcd_query(" SELECT chat.id, chat.imgs, chat.mittente, chat.destinatario, chat.tipo, chat.ora, chat.testo, personaggio.url_img_chat, mappa.ora_prenotazione, mappa.privata
FROM chat
INNER JOIN mappa ON mappa.id = chat.stanza
LEFT JOIN personaggio ON personaggio.nome = chat.mittente
WHERE stanza = " . $_SESSION['luogo'] . " AND DATE_SUB(NOW(), INTERVAL 240 MINUTE) < ora ORDER BY id " . $typeOrder,
'result');
}

<?php
#################################################################################
# ##
# Save Chat HTML 1.3 - Author eLDiabolo ##
# ##
# e-mail: http://www.gdr-online.com/email.asp?email=eldiabolo ##
# ##
##################################################################################
#################################################################################
session_start();

/* Includo i file necessari */
include ('includes/constant_values.inc.php');
include ('config.inc.php');
include ('vocabulary/' . $PARAMETERS['languages']['set'] . '.vocabulary.php');
include ('includes/functions.inc.php');

/* Eseguo la connessione al database */
$handleDBConnection = gdrcd_connect();

$typeOrder = ($PARAMETERS['mode']['chat_from_bottom'] == 'ON') ? 'DESC' : 'ASC';

/*Query per caricamento dati dalla chat corrente, carica le azioni degli ultimi 1440 min - 24 ore !! NON SALVA LE CHAT PRIVATE !!*/

?>
Usa il form seguente per selezionare la data e l'ora della chat da salvare <br><br>
<form action="chat_save_gestori.proc.php"
method="post">
<?php
$result = gdrcd_query("SELECT nome, id FROM mappa WHERE chat=1 ORDER BY nome", 'result'); ?>

<div class='form_label'>
<?php echo gdrcd_filter('out',
$MESSAGE['interface']['administration']['log']['chat']['begin']); ?>
</div>
<div class='form_field'>
<!-- Giorno -->
<select name="day_b" class="day">
<?php for ($i = 1; $i <= 31; $i++)
{ ?>
<option value="<?php echo $i; ?>"><?php echo $i; ?></option>
<?php }//for
?>
</select>
<!-- Mese -->
<select name="month_b" class="month">
<?php for ($i = 1; $i <= 12; $i++)
{ ?>
<option value="<?php echo $i; ?>"><?php echo $i; ?></option>
<?php }//for
?>
</select>
<!-- Anno -->
<select name="year_b" class="year">
<?php for ($i = 2019; $i <= strftime('%Y') + 20; $i++)
{ ?>
<option value="<?php echo $i; ?>"><?php echo $i; ?></option>
<?php }//for
?>
</select> -
<!-- Ora -->
<select name="hour_b" class="month">
<?php for ($i = 0; $i <= 23; $i++)
{ ?>
<option value="<?php echo $i; ?>"><?php echo sprintf('%02s', $i); ?></option>
<?php }//for
?>
</select>:
<!-- Minuto -->
<select name="minut_b" class="month">
<?php for ($i = 0; $i <= 60; $i += 5)
{ ?>
<option value="<?php echo $i; ?>"><?php echo sprintf('%02s', $i); ?></option>
<?php }//for
?>
</select>
</div>
<div class='form_label'>
<?php echo gdrcd_filter('out',
$MESSAGE['interface']['administration']['log']['chat']['end']); ?>
</div>
<div class='form_field'>
<!-- Giorno -->
<select name="day_e" class="day">
<?php for ($i = 1; $i <= 31; $i++)
{ ?>
<option value="<?php echo $i; ?>"><?php echo $i; ?></option>
<?php }//for
?>
</select>
<!-- Mese -->
<select name="month_e" class="month">
<?php for ($i = 1; $i <= 12; $i++)
{ ?>
<option value="<?php echo $i; ?>"><?php echo $i; ?></option>
<?php }//for
?>
</select>
<!-- Anno -->
<select name="year_e" class="year">
<?php for ($i = 2021; $i <= strftime('%Y') + 20; $i++)
{ ?>
<option value="<?php echo $i; ?>"><?php echo $i; ?></option>
<?php }//for
?>
</select> -
<!-- Ora -->
<select name="hour_e" class="month">
<?php for ($i = 0; $i <= 23; $i++)
{ ?>
<option value="<?php echo $i; ?>"><?php echo sprintf('%02s', $i); ?></option>
<?php }//for
?>
</select>:
<!-- Minuto -->
<select name="minut_e" class="month">
<?php for ($i = 0; $i <= 60; $i += 5)
{ ?>
<option value="<?php echo $i; ?>"><?php echo sprintf('%02s', $i); ?></option>
<?php }//for
?>
</select>
</div>
<!-- bottoni -->
<div class='form_submit'>
<input type="hidden"
value="view_date"
name="op"/>
<input type="submit"
value="<?php echo gdrcd_filter('out',
$MESSAGE['interface']['forms']['submit']); ?>"/>
</div>

</form>

<?php

if ($PARAMETERS['mode']['chatsavepvt'] == 'ON')
{
if (isset($_REQUEST['op']) == 'view_date') {
$date_b = gdrcd_filter('num', $_REQUEST['year_b']) . '-' . sprintf('%02s',
gdrcd_filter('num', $_REQUEST['month_b'])) . '-' . sprintf('%02s',
gdrcd_filter('num', $_REQUEST['day_b'])) . ' ' . sprintf('%02s',
gdrcd_filter('num', $_REQUEST['hour_b'])) . ':' . sprintf('%02s',
gdrcd_filter('num', $_REQUEST['minut_b'])) . ':00';
$date_e = gdrcd_filter('num', $_REQUEST['year_e']) . '-' . sprintf('%02s',
gdrcd_filter('num', $_REQUEST['month_e'])) . '-' . sprintf('%02s',
gdrcd_filter('num', $_REQUEST['day_e'])) . ' ' . sprintf('%02s',
gdrcd_filter('num', $_REQUEST['hour_e'])) . ':' . sprintf('%02s',
gdrcd_filter('num', $_REQUEST['minut_e'])) . ':00';

$query = gdrcd_query(" SELECT chat.id, chat.imgs, chat.mittente, chat.destinatario, chat.tipo, chat.ora, chat.testo, personaggio.url_img_chat, personaggio.url_img_chat_alterego, personaggio.url_img_chat_mutante, personaggio.alterego, personaggio.mutante, personaggio.url_img_razza, personaggio.url_img, personaggio.url_img_classe, personaggio.url_img_classe2, personaggio.nome_razza, personaggio.nome_classe, personaggio.nome_classe2, personaggio.pnpnome, personaggio.pnpimg, mappa.ora_prenotazione, mappa.privata
FROM chat
INNER JOIN mappa ON mappa.id = chat.stanza
LEFT JOIN personaggio ON personaggio.nome = chat.mittente
WHERE stanza = " . $_SESSION['luogo'] . " AND ora >= '" . $date_b . "' AND ora <= '" . $date_e . "' ORDER BY id " . $typeOrder, 'result');
}
}

//{GENERAZIONE DEL FORM DI SELEZIONE PERIODO}

if (isset($_REQUEST['op']) && $_REQUEST['op'] == 'view_date') {

if ($PARAMETERS['mode']['chatsavepvt'] == 'ON')
{
//{QUERY CHAT PRIVATE}
} else {
//{QUERY CHAT PUBBLICHE}
}

// {ADD_CHAT}

// {Eseguo la query e le formattazioni}

...
}

$rand = rand(1, 10000000);
$file = md5($file . $rand);
$file = $file . ".html";

/* Scrivo tutto in un file di testo */
$file = date('Y-m-d_H-i-s') . '_' . $_SESSION['login'] . '_' . $_SESSION['luogo'] . ".html";