Revize 2205
Přidáno uživatelem Ondřej Fibich před asi 11 roky(ů)
| freenetis/branches/1.1/application/models/ip_address.php | ||
|---|---|---|
|
LEFT JOIN ifaces i ON ip.iface_id = i.id
|
||
|
LEFT JOIN devices d ON i.device_id = d.id
|
||
|
LEFT JOIN users u ON d.user_id = u.id
|
||
|
LEFT JOIN members_whitelists mw ON mw.member_id = u.member_id OR mw.member_id = ip.member_id
|
||
|
LEFT JOIN members_whitelists mw ON (mw.member_id = u.member_id OR mw.member_id = ip.member_id)
|
||
|
AND (? BETWEEN mw.since AND mw.until)
|
||
|
LEFT JOIN messages_ip_addresses mip ON mip.ip_address_id = ip.id
|
||
|
LEFT JOIN messages m ON m.id = mip.message_id
|
||
|
WHERE u.member_id = ? OR ip.member_id = ?
|
||
| ... | ... | |
|
ORDER BY $order_by $order_by_direction,
|
||
|
m.self_cancel DESC, mip.datetime ASC
|
||
|
LIMIT " . intval($sql_offset) . ", " . intval($limit_results) . "
|
||
|
", $member_id, $member_id, $member_id);
|
||
|
", $member_id, date('Y-m-d'), $member_id, $member_id);
|
||
|
}
|
||
|
|
||
|
/**
|
||
Také k dispozici: Unified diff
Opravy:
- oprava chybneho zobrazeni bile listiny v seznamu presmerovani clena (nebyla ta podminka na aktualni datum, takze predchozi bile listiny se zobrazovali jako aktualni)