66 lines
1.4 KiB
PHP
66 lines
1.4 KiB
PHP
|
<?php
|
||
|
|
|
||
|
|
include_once('../../function.php');
|
||
|
|
|
||
|
|
for ($a = 0; $a <= 1; $a++) {
|
||
|
|
|
||
|
|
if ($a == 0)
|
||
|
|
$db_table = '';
|
||
|
|
else
|
||
|
|
$db_table = '_active';
|
||
|
|
|
||
|
|
$sql_anketa = sisplet_query("SELECT id FROM srv_anketa ORDER BY id");
|
||
|
|
while ($row_anketa = mysqli_fetch_array($sql_anketa)) {
|
||
|
|
|
||
|
|
$sql_user = sisplet_query("SELECT id FROM srv_user WHERE ank_id = '$row_anketa[id]'");
|
||
|
|
while ($row_user = mysqli_fetch_array($sql_user)) {
|
||
|
|
|
||
|
|
$prev = null;
|
||
|
|
|
||
|
|
$sql_grupa = sisplet_query("SELECT id, vrstni_red FROM srv_grupa WHERE ank_id = '$row_anketa[id]' ORDER BY vrstni_red");
|
||
|
|
while ($row_grupa = mysqli_fetch_array($sql_grupa)) {
|
||
|
|
|
||
|
|
|
||
|
|
$sql_user_grupa = sisplet_query("SELECT * FROM srv_user_grupa".$db_table." WHERE usr_id='$row_user[id]' AND gru_id='$row_grupa[id]'");
|
||
|
|
$row_user_grupa = mysqli_fetch_array($sql_user_grupa);
|
||
|
|
|
||
|
|
if ($prev != null) {
|
||
|
|
|
||
|
|
if (diff($row_user_grupa['time_edit'], $prev) <= 1) {
|
||
|
|
|
||
|
|
$s = sisplet_query("UPDATE srv_user_grupa".$db_table." SET preskocena='1' WHERE usr_id='$row_user[id]' AND gru_id='$row_grupa[id]'");
|
||
|
|
if (!$s) echo mysqli_error($GLOBALS['connect_db']);
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
$prev = $row_user_grupa['time_edit'];
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
echo 'done';
|
||
|
|
|
||
|
|
/**
|
||
|
|
* odsteje dva datuma, $d1 - D2
|
||
|
|
*
|
||
|
|
*/
|
||
|
|
function diff ($d1, $d2) {
|
||
|
|
$d1 = (is_string($d1) ? strtotime($d1) : $d1);
|
||
|
|
$d2 = (is_string($d2) ? strtotime($d2) : $d2);
|
||
|
|
|
||
|
|
$diff_secs = abs($d1 - $d2);
|
||
|
|
|
||
|
|
return $diff_secs;
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
?>
|