| Line 229 | Line 229 |
|---|
}
$sql_ary = array(
|
}
$sql_ary = array(
|
'user_id' => $user_id,
'log_ip' => $log_ip,
| 'user_id' => !empty($user_id) ? $user_id : ANONYMOUS,
'log_ip' => !empty($log_ip) ? $log_ip : '',
|
'log_time' => $log_time,
'log_operation' => $log_operation,
);
| 'log_time' => $log_time,
'log_operation' => $log_operation,
);
|
| Line 402 | Line 402 |
|---|
}
}
|
}
}
|
$sql = 'DELETE FROM ' . LOG_TABLE . "
| $sql = 'DELETE FROM ' . $this->log_table . "
|
$sql_where";
$this->db->sql_query($sql);
| $sql_where";
$this->db->sql_query($sql);
|
| Line 535 | Line 535 |
|---|
'ORDER_BY' => $sort_by,
);
|
'ORDER_BY' => $sort_by,
);
|
if($log_time)
| if ($log_time)
|
{
$get_logs_sql_ary['WHERE'] = 'l.log_time >= ' . (int) $log_time . '
AND ' . $get_logs_sql_ary['WHERE'];
| {
$get_logs_sql_ary['WHERE'] = 'l.log_time >= ' . (int) $log_time . '
AND ' . $get_logs_sql_ary['WHERE'];
|
| Line 893 | Line 893 |
|---|
$forum_auth = array('f_read' => array(), 'm_' => array());
$topic_ids = array_unique($topic_ids);
|
$forum_auth = array('f_read' => array(), 'm_' => array());
$topic_ids = array_unique($topic_ids);
|
$sql = 'SELECT topic_id, forum_id
FROM ' . TOPICS_TABLE . '
WHERE ' . $this->db->sql_in_set('topic_id', array_map('intval', $topic_ids));
| $sql_ary = array(
'SELECT' => 'topic_id, forum_id',
'FROM' => array(
TOPICS_TABLE => 't',
),
'WHERE' => $this->db->sql_in_set('topic_id', array_map('intval', $topic_ids)),
);
/**
* Allow modifying SQL query before topic data is retrieved.
*
* @event core.phpbb_log_get_topic_auth_sql_before
* @var array topic_ids Array with unique topic IDs
* @var array sql_ary SQL array
* @since 3.1.11-RC1
*/
$vars = array(
'topic_ids',
'sql_ary',
);
extract($this->dispatcher->trigger_event('core.phpbb_log_get_topic_auth_sql_before', compact($vars)));
$sql = $this->db->sql_build_query('SELECT', $sql_ary);
|
$result = $this->db->sql_query($sql);
while ($row = $this->db->sql_fetchrow($result))
| $result = $this->db->sql_query($sql);
while ($row = $this->db->sql_fetchrow($result))
|
