<?php
$params = [
'types' => 'sss',
'endtime' => $time_ms . '000',
'restart' => $time_ms . '999',
'id' => $serverid
];
$query = 'UPDATE %s
SET endtime = ?, evcomment = "Errors: Interrupted"
WHERE starttime = endtime
AND starttime < ?
AND server = ?';
foreach ([ 'events', 'ongoing_events' ] as $table) {
printf($query, $table);
echo PHP_EOL;
print_r($params);
echo PHP_EOL;
}
- Output for 8.0.0 - 8.0.30, 8.1.0 - 8.1.27, 8.2.0 - 8.2.17, 8.3.0 - 8.3.4
- Warning: Undefined variable $time_ms in /in/9FUHh on line 5
Warning: Undefined variable $time_ms in /in/9FUHh on line 6
Warning: Undefined variable $serverid in /in/9FUHh on line 7
UPDATE events
SET endtime = ?, evcomment = "Errors: Interrupted"
WHERE starttime = endtime
AND starttime < ?
AND server = ?
Array
(
[types] => sss
[endtime] => 000
[restart] => 999
[id] =>
)
UPDATE ongoing_events
SET endtime = ?, evcomment = "Errors: Interrupted"
WHERE starttime = endtime
AND starttime < ?
AND server = ?
Array
(
[types] => sss
[endtime] => 000
[restart] => 999
[id] =>
)
- Output for 7.0.0 - 7.0.20, 7.1.0 - 7.1.25, 7.2.0 - 7.2.33, 7.3.0 - 7.3.31, 7.4.0 - 7.4.33
- Notice: Undefined variable: time_ms in /in/9FUHh on line 5
Notice: Undefined variable: time_ms in /in/9FUHh on line 6
Notice: Undefined variable: serverid in /in/9FUHh on line 7
UPDATE events
SET endtime = ?, evcomment = "Errors: Interrupted"
WHERE starttime = endtime
AND starttime < ?
AND server = ?
Array
(
[types] => sss
[endtime] => 000
[restart] => 999
[id] =>
)
UPDATE ongoing_events
SET endtime = ?, evcomment = "Errors: Interrupted"
WHERE starttime = endtime
AND starttime < ?
AND server = ?
Array
(
[types] => sss
[endtime] => 000
[restart] => 999
[id] =>
)
- Output for 7.3.32 - 7.3.33
- UPDATE events
SET endtime = ?, evcomment = "Errors: Interrupted"
WHERE starttime = endtime
AND starttime < ?
AND server = ?
Array
(
[types] => sss
[endtime] => 000
[restart] => 999
[id] =>
)
UPDATE ongoing_events
SET endtime = ?, evcomment = "Errors: Interrupted"
WHERE starttime = endtime
AND starttime < ?
AND server = ?
Array
(
[types] => sss
[endtime] => 000
[restart] => 999
[id] =>
)
- Output for 5.5.24 - 5.5.35, 5.6.8 - 5.6.28
- Notice: Undefined variable: time_ms in /in/9FUHh on line 5
Notice: Undefined variable: time_ms in /in/9FUHh on line 6
Notice: Undefined variable: serverid in /in/9FUHh on line 8
UPDATE events
SET endtime = ?, evcomment = "Errors: Interrupted"
WHERE starttime = endtime
AND starttime < ?
AND server = ?
Array
(
[types] => sss
[endtime] => 000
[restart] => 999
[id] =>
)
UPDATE ongoing_events
SET endtime = ?, evcomment = "Errors: Interrupted"
WHERE starttime = endtime
AND starttime < ?
AND server = ?
Array
(
[types] => sss
[endtime] => 000
[restart] => 999
[id] =>
)
preferences:
172.39 ms | 403 KiB | 193 Q