|
<html><body><h1>Chyba nahlasena z: . members/show/84/message/ASC/page/1 (file: 374, line: 374)</h1><p>FreenetIS verze: 1.1.0~rc1</p><p>PHP verze: 5.3.3-7+squeeze17</p><p>Nahlasil: Ondrej Fibich</p><p>Popis: Zjisteno z logu</p><h2>Kohana_Database_Exception</h2><p></p><p class="message">Chyba v SQL dotazu - Unknown column 'ASC' in 'order clause'</p><p class="detail">Chyba se vyskytla na <strong>radku 374</strong> souboru <strong>system/libraries/drivers/Database/Mysql.php</strong>.</p><div><ul class="backtrace"><li><strong>system/libraries/drivers/Database/Mysql.php [99]:</strong><pre>Mysql_Result->__construct( )</pre></li>
|
|
<li><strong>system/libraries/Database.php [187]:</strong><pre>Database_Mysql_Driver->query(
|
|
SELECT ip.id AS ip_address_id, ip.ip_address, m.id AS message_id,
|
|
m.name AS message, m.type, '84' AS member_id,
|
|
mip.datetime AS active_redir_datetime,
|
|
IF(mw.id IS NULL, 0, 2 - mw.permanent) AS whitelisted
|
|
FROM ip_addresses ip
|
|
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)
|
|
AND ('2014-01-05' 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 = '84' OR ip.member_id = '84'
|
|
GROUP BY ip.id
|
|
ORDER BY `ASC` desc,
|
|
m.self_cancel DESC, mip.datetime ASC
|
|
LIMIT 0, 0
|
|
)</pre></li>
|
|
<li><strong>application/models/ip_address.php [562]:</strong><pre>Database->query(
|
|
SELECT ip.id AS ip_address_id, ip.ip_address, m.id AS message_id,
|
|
m.name AS message, m.type, ? AS member_id,
|
|
mip.datetime AS active_redir_datetime,
|
|
IF(mw.id IS NULL, 0, 2 - mw.permanent) AS whitelisted
|
|
FROM ip_addresses ip
|
|
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)
|
|
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 = ?
|
|
GROUP BY ip.id
|
|
ORDER BY `ASC` desc,
|
|
m.self_cancel DESC, mip.datetime ASC
|
|
LIMIT 0, 0
|
|
, 84, 2014-01-05, 84, 84 )</pre></li>
|
|
<li><strong>application/controllers/members.php [1656]:</strong><pre>Ip_address_Model->get_ips_and_redirections_of_member( 84 )</pre></li>
|
|
<li><pre>Members_Controller->show( 84, message, ASC, page, 1 )</pre></li>
|
|
<li><strong>system/core/Kohana.php [363]:</strong><pre>call_user_func_array( Array
|
|
(
|
|
[0] => Members_Controller Object
|
|
(
|
|
[_member_id:protected] =>
|
|
[arr] =>
|
|
[settings] => Settings Object
|
|
(
|
|
)
|
|
|
|
[popup] => 0
|
|
[dialog] => 0
|
|
[noredirect] =>
|
|
[user_has_voip] =>
|
|
[ip_address_span] => 10.143.135.5
|
|
[unread_user_mails] => 0
|
|
[count_of_unclosed_logged_errors] => 0
|
|
[devices_down_count] => 0
|
|
[user_favourites_pages] => Mysql_Result Object
|
|
(
|
|
[fetch_type:protected] => mysql_fetch_object
|
|
[return_type:protected] => stdClass
|
|
[result:protected] => Resource id #64
|
|
[insert_id:protected] =>
|
|
[sql:protected] =>
|
|
SELECT * FROM user_favourite_pages
|
|
WHERE user_id = '2454'
|
|
ORDER BY `title` asc
|
|
LIMIT 0, 50
|
|
|
|
[current_row:protected] => 0
|
|
[total_rows:protected] => 4
|
|
)
|
|
|
|
[axo_doc_access] => 1
|
|
[member_id:protected] => 313
|
|
[user_id:protected] => 2454
|
|
[member_account_id:protected] => 323
|
|
[session:protected] => Session Object
|
|
(
|
|
[input:protected] => Input Object
|
|
(
|
|
[use_xss_clean:protected] =>
|
|
[ip_address] =>
|
|
[user_agent] =>
|
|
)
|
|
|
|
)
|
|
|
|
[groups_aro_map:Controller:private] => Groups_aro_map_Model Object
|
|
(
|
|
[table_names_plural:protected] =>
|
|
[has_one:protected] => Array
|
|
(
|
|
)
|
|
|
|
[belongs_to:protected] => Array
|
|
(
|
|
)
|
|
|
|
[has_many:protected] => Array
|
|
(
|
|
)
|
|
|
|
[has_and_belongs_to_many:protected] => Array
|
|
(
|
|
)
|
|
|
|
[load_with:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object:protected] => Array
|
|
(
|
|
[group_id] => 0
|
|
[aro_id] => 0
|
|
)
|
|
|
|
[changed:protected] => Array
|
|
(
|
|
)
|
|
|
|
[related:protected] => Array
|
|
(
|
|
)
|
|
|
|
[loaded:protected] =>
|
|
[saved:protected] =>
|
|
[sorting:protected] => Array
|
|
(
|
|
[id] => asc
|
|
)
|
|
|
|
[object_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[changed_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object_name:protected] => groups_aro_map
|
|
[object_plural:protected] => groups_aro_maps
|
|
[table_name:protected] => groups_aro_map
|
|
[table_columns:protected] => Array
|
|
(
|
|
[group_id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
)
|
|
|
|
[aro_id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
)
|
|
|
|
)
|
|
|
|
[ignored_columns:protected] =>
|
|
[primary_key:protected] => id
|
|
[primary_val:protected] => name
|
|
[foreign_key:protected] => Array
|
|
(
|
|
)
|
|
|
|
[reload_on_wakeup:protected] => 1
|
|
[db:protected] => Database Object
|
|
(
|
|
[config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysql
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[driver:protected] => Database_Mysql_Driver Object
|
|
(
|
|
[link:protected] => Resource id #36
|
|
[db_config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysql
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[query_cache:protected] =>
|
|
)
|
|
|
|
[link:protected] => Resource id #36
|
|
[select:protected] => Array
|
|
(
|
|
)
|
|
|
|
[set:protected] => Array
|
|
(
|
|
)
|
|
|
|
[from:protected] => Array
|
|
(
|
|
)
|
|
|
|
[join:protected] => Array
|
|
(
|
|
)
|
|
|
|
[where:protected] => Array
|
|
(
|
|
)
|
|
|
|
[orderby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[order:protected] => Array
|
|
(
|
|
)
|
|
|
|
[groupby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[having:protected] => Array
|
|
(
|
|
)
|
|
|
|
[distinct:protected] =>
|
|
[limit:protected] =>
|
|
[offset:protected] =>
|
|
[last_query:protected] =>
|
|
SELECT ip.id AS ip_address_id, ip.ip_address, m.id AS message_id,
|
|
m.name AS message, m.type, '84' AS member_id,
|
|
mip.datetime AS active_redir_datetime,
|
|
IF(mw.id IS NULL, 0, 2 - mw.permanent) AS whitelisted
|
|
FROM ip_addresses ip
|
|
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)
|
|
AND ('2014-01-05' 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 = '84' OR ip.member_id = '84'
|
|
GROUP BY ip.id
|
|
ORDER BY `ASC` desc,
|
|
m.self_cancel DESC, mip.datetime ASC
|
|
LIMIT 0, 0
|
|
|
|
[query_history:protected] => Array
|
|
(
|
|
)
|
|
|
|
)
|
|
|
|
[db_applied:protected] => Array
|
|
(
|
|
[where] => where
|
|
[select] => select
|
|
[orderby] => orderby
|
|
)
|
|
|
|
[with_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[is_in_transaction:protected] =>
|
|
[is_logger_on:protected] => Array
|
|
(
|
|
[add] => 1
|
|
[update] => 1
|
|
[delete] => 1
|
|
)
|
|
|
|
)
|
|
|
|
[load] => Loader Object
|
|
(
|
|
)
|
|
|
|
[uri] => URI Object
|
|
(
|
|
)
|
|
|
|
[input] => Input Object
|
|
(
|
|
[use_xss_clean:protected] =>
|
|
[ip_address] =>
|
|
[user_agent] =>
|
|
)
|
|
|
|
[is_favourite] =>
|
|
[member] => Member_Model Object
|
|
(
|
|
[has_one:protected] => Array
|
|
(
|
|
[0] => allowed_subnets_count
|
|
[1] => members_traffic
|
|
[2] => members_domicile
|
|
)
|
|
|
|
[has_many:protected] => Array
|
|
(
|
|
[0] => allowed_subnets
|
|
[1] => invoices
|
|
[2] => users
|
|
[3] => accounts
|
|
[4] => transfers
|
|
[5] => bank_accounts
|
|
[6] => membership_interrupts
|
|
[7] => connection_requests
|
|
[8] => members_whitelists
|
|
)
|
|
|
|
[belongs_to:protected] => Array
|
|
(
|
|
[0] => address_point
|
|
[1] => user
|
|
[2] => speed_class
|
|
)
|
|
|
|
[has_and_belongs_to_many:protected] => Array
|
|
(
|
|
)
|
|
|
|
[load_with:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object:protected] => Array
|
|
(
|
|
[id] => 84
|
|
[user_id] => 121
|
|
[registration] => 1
|
|
[name] => Petr Bor
|
|
[address_point_id] => 2584
|
|
[type] => 2
|
|
[external_type] =>
|
|
[organization_identifier] =>
|
|
[vat_organization_identifier] =>
|
|
[speed_class_id] =>
|
|
[entrance_fee] => 2000
|
|
[debt_payment_rate] => 0
|
|
[entrance_fee_left] => 2000
|
|
[entrance_fee_date] => 2006-01-03
|
|
[entrance_date] => 2006-01-01
|
|
[entrance_form_received] => 2006-01-01
|
|
[entrance_form_accepted] => 2006-01-01
|
|
[leaving_date] => 0000-00-00
|
|
[applicant_registration_datetime] =>
|
|
[applicant_connected_from] =>
|
|
[locked] => 0
|
|
[voip_billing_limit] => 0
|
|
[voip_billing_type] => prepaid
|
|
[comment] => Spravce AP Luksin; IPTV povolena
|
|
[notification_by_redirection] => 1
|
|
[notification_by_email] => 1
|
|
[notification_by_sms] => 1
|
|
)
|
|
|
|
[changed:protected] => Array
|
|
(
|
|
)
|
|
|
|
[related:protected] => Array
|
|
(
|
|
[address_point] => Address_point_Model Object
|
|
(
|
|
[has_many:protected] => Array
|
|
(
|
|
[0] => members
|
|
[1] => devices
|
|
)
|
|
|
|
[belongs_to:protected] => Array
|
|
(
|
|
[0] => town
|
|
[1] => street
|
|
[2] => country
|
|
)
|
|
|
|
[has_one:protected] => Array
|
|
(
|
|
)
|
|
|
|
[has_and_belongs_to_many:protected] => Array
|
|
(
|
|
)
|
|
|
|
[load_with:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object:protected] => Array
|
|
(
|
|
[id] => 2584
|
|
[name] =>
|
|
[country_id] => 55
|
|
[town_id] => 1
|
|
[street_id] => 25
|
|
[street_number] => 806
|
|
[gps] => ����������H@����y�1@
|
|
)
|
|
|
|
[changed:protected] => Array
|
|
(
|
|
)
|
|
|
|
[related:protected] => Array
|
|
(
|
|
[street] => Street_Model Object
|
|
(
|
|
[has_many:protected] => Array
|
|
(
|
|
[0] => address_points
|
|
)
|
|
|
|
[belongs_to:protected] => Array
|
|
(
|
|
[0] => town
|
|
[1] => street
|
|
)
|
|
|
|
[has_one:protected] => Array
|
|
(
|
|
)
|
|
|
|
[has_and_belongs_to_many:protected] => Array
|
|
(
|
|
)
|
|
|
|
[load_with:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object:protected] => Array
|
|
(
|
|
[id] => 25
|
|
[town_id] => 1
|
|
[street] => K Parku
|
|
[gps] =>
|
|
)
|
|
|
|
[changed:protected] => Array
|
|
(
|
|
)
|
|
|
|
[related:protected] => Array
|
|
(
|
|
)
|
|
|
|
[loaded:protected] => 1
|
|
[saved:protected] => 1
|
|
[sorting:protected] => Array
|
|
(
|
|
[id] => asc
|
|
)
|
|
|
|
[object_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[changed_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object_name:protected] => street
|
|
[object_plural:protected] => streets
|
|
[table_name:protected] => streets
|
|
[table_columns:protected] => Array
|
|
(
|
|
[id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
[sequenced] => 1
|
|
)
|
|
|
|
[town_id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
[null] => 1
|
|
)
|
|
|
|
[street] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 30
|
|
)
|
|
|
|
[gps] => Array
|
|
(
|
|
[type] => string
|
|
[binary] => 1
|
|
[null] => 1
|
|
)
|
|
|
|
)
|
|
|
|
[ignored_columns:protected] =>
|
|
[primary_key:protected] => id
|
|
[primary_val:protected] => name
|
|
[foreign_key:protected] => Array
|
|
(
|
|
)
|
|
|
|
[table_names_plural:protected] => 1
|
|
[reload_on_wakeup:protected] => 1
|
|
[db:protected] => Database Object
|
|
(
|
|
[config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysql
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[driver:protected] => Database_Mysql_Driver Object
|
|
(
|
|
[link:protected] => Resource id #36
|
|
[db_config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysql
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[query_cache:protected] =>
|
|
)
|
|
|
|
[link:protected] => Resource id #36
|
|
[select:protected] => Array
|
|
(
|
|
)
|
|
|
|
[set:protected] => Array
|
|
(
|
|
)
|
|
|
|
[from:protected] => Array
|
|
(
|
|
)
|
|
|
|
[join:protected] => Array
|
|
(
|
|
)
|
|
|
|
[where:protected] => Array
|
|
(
|
|
)
|
|
|
|
[orderby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[order:protected] => Array
|
|
(
|
|
)
|
|
|
|
[groupby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[having:protected] => Array
|
|
(
|
|
)
|
|
|
|
[distinct:protected] =>
|
|
[limit:protected] =>
|
|
[offset:protected] =>
|
|
[last_query:protected] =>
|
|
SELECT ip.id AS ip_address_id, ip.ip_address, m.id AS message_id,
|
|
m.name AS message, m.type, '84' AS member_id,
|
|
mip.datetime AS active_redir_datetime,
|
|
IF(mw.id IS NULL, 0, 2 - mw.permanent) AS whitelisted
|
|
FROM ip_addresses ip
|
|
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)
|
|
AND ('2014-01-05' 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 = '84' OR ip.member_id = '84'
|
|
GROUP BY ip.id
|
|
ORDER BY `ASC` desc,
|
|
m.self_cancel DESC, mip.datetime ASC
|
|
LIMIT 0, 0
|
|
|
|
[query_history:protected] => Array
|
|
(
|
|
)
|
|
|
|
)
|
|
|
|
[db_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[with_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[is_in_transaction:protected] =>
|
|
[is_logger_on:protected] => Array
|
|
(
|
|
[add] => 1
|
|
[update] => 1
|
|
[delete] => 1
|
|
)
|
|
|
|
)
|
|
|
|
[town] => Town_Model Object
|
|
(
|
|
[has_many:protected] => Array
|
|
(
|
|
[0] => address_points
|
|
[1] => streets
|
|
)
|
|
|
|
[has_one:protected] => Array
|
|
(
|
|
)
|
|
|
|
[belongs_to:protected] => Array
|
|
(
|
|
)
|
|
|
|
[has_and_belongs_to_many:protected] => Array
|
|
(
|
|
)
|
|
|
|
[load_with:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object:protected] => Array
|
|
(
|
|
[id] => 1
|
|
[zip_code] => 76321
|
|
[town] => Slavicin
|
|
[quarter] =>
|
|
[gps] =>
|
|
)
|
|
|
|
[changed:protected] => Array
|
|
(
|
|
)
|
|
|
|
[related:protected] => Array
|
|
(
|
|
)
|
|
|
|
[loaded:protected] => 1
|
|
[saved:protected] => 1
|
|
[sorting:protected] => Array
|
|
(
|
|
[id] => asc
|
|
)
|
|
|
|
[object_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[changed_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object_name:protected] => town
|
|
[object_plural:protected] => towns
|
|
[table_name:protected] => towns
|
|
[table_columns:protected] => Array
|
|
(
|
|
[id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
[sequenced] => 1
|
|
)
|
|
|
|
[zip_code] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 10
|
|
)
|
|
|
|
[town] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 50
|
|
)
|
|
|
|
[quarter] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 50
|
|
[null] => 1
|
|
)
|
|
|
|
[gps] => Array
|
|
(
|
|
[type] => string
|
|
[binary] => 1
|
|
[null] => 1
|
|
)
|
|
|
|
)
|
|
|
|
[ignored_columns:protected] =>
|
|
[primary_key:protected] => id
|
|
[primary_val:protected] => name
|
|
[foreign_key:protected] => Array
|
|
(
|
|
)
|
|
|
|
[table_names_plural:protected] => 1
|
|
[reload_on_wakeup:protected] => 1
|
|
[db:protected] => Database Object
|
|
(
|
|
[config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysql
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[driver:protected] => Database_Mysql_Driver Object
|
|
(
|
|
[link:protected] => Resource id #36
|
|
[db_config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysql
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[query_cache:protected] =>
|
|
)
|
|
|
|
[link:protected] => Resource id #36
|
|
[select:protected] => Array
|
|
(
|
|
)
|
|
|
|
[set:protected] => Array
|
|
(
|
|
)
|
|
|
|
[from:protected] => Array
|
|
(
|
|
)
|
|
|
|
[join:protected] => Array
|
|
(
|
|
)
|
|
|
|
[where:protected] => Array
|
|
(
|
|
)
|
|
|
|
[orderby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[order:protected] => Array
|
|
(
|
|
)
|
|
|
|
[groupby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[having:protected] => Array
|
|
(
|
|
)
|
|
|
|
[distinct:protected] =>
|
|
[limit:protected] =>
|
|
[offset:protected] =>
|
|
[last_query:protected] =>
|
|
SELECT ip.id AS ip_address_id, ip.ip_address, m.id AS message_id,
|
|
m.name AS message, m.type, '84' AS member_id,
|
|
mip.datetime AS active_redir_datetime,
|
|
IF(mw.id IS NULL, 0, 2 - mw.permanent) AS whitelisted
|
|
FROM ip_addresses ip
|
|
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)
|
|
AND ('2014-01-05' 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 = '84' OR ip.member_id = '84'
|
|
GROUP BY ip.id
|
|
ORDER BY `ASC` desc,
|
|
m.self_cancel DESC, mip.datetime ASC
|
|
LIMIT 0, 0
|
|
|
|
[query_history:protected] => Array
|
|
(
|
|
)
|
|
|
|
)
|
|
|
|
[db_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[with_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[is_in_transaction:protected] =>
|
|
[is_logger_on:protected] => Array
|
|
(
|
|
[add] => 1
|
|
[update] => 1
|
|
[delete] => 1
|
|
)
|
|
|
|
)
|
|
|
|
[country] => Country_Model Object
|
|
(
|
|
[has_many:protected] => Array
|
|
(
|
|
[0] => address_points
|
|
[1] => phone_operators
|
|
)
|
|
|
|
[has_and_belongs_to_many:protected] => Array
|
|
(
|
|
[0] => contacts
|
|
)
|
|
|
|
[has_one:protected] => Array
|
|
(
|
|
)
|
|
|
|
[belongs_to:protected] => Array
|
|
(
|
|
)
|
|
|
|
[load_with:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object:protected] => Array
|
|
(
|
|
[id] => 55
|
|
[country_name] => Czech Republic
|
|
[country_iso] => CZE
|
|
[country_code] => 420
|
|
[enabled] => 1
|
|
)
|
|
|
|
[changed:protected] => Array
|
|
(
|
|
)
|
|
|
|
[related:protected] => Array
|
|
(
|
|
)
|
|
|
|
[loaded:protected] => 1
|
|
[saved:protected] => 1
|
|
[sorting:protected] => Array
|
|
(
|
|
[id] => asc
|
|
)
|
|
|
|
[object_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[changed_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object_name:protected] => country
|
|
[object_plural:protected] => countries
|
|
[table_name:protected] => countries
|
|
[table_columns:protected] => Array
|
|
(
|
|
[id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 32767
|
|
[unsigned] =>
|
|
[sequenced] => 1
|
|
)
|
|
|
|
[country_name] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 100
|
|
)
|
|
|
|
[country_iso] => Array
|
|
(
|
|
[type] => string
|
|
[exact] => 1
|
|
[length] => 3
|
|
)
|
|
|
|
[country_code] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 4
|
|
)
|
|
|
|
[enabled] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 127
|
|
[unsigned] =>
|
|
)
|
|
|
|
)
|
|
|
|
[ignored_columns:protected] =>
|
|
[primary_key:protected] => id
|
|
[primary_val:protected] => name
|
|
[foreign_key:protected] => Array
|
|
(
|
|
)
|
|
|
|
[table_names_plural:protected] => 1
|
|
[reload_on_wakeup:protected] => 1
|
|
[db:protected] => Database Object
|
|
(
|
|
[config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysql
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[driver:protected] => Database_Mysql_Driver Object
|
|
(
|
|
[link:protected] => Resource id #36
|
|
[db_config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysql
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[query_cache:protected] =>
|
|
)
|
|
|
|
[link:protected] => Resource id #36
|
|
[select:protected] => Array
|
|
(
|
|
)
|
|
|
|
[set:protected] => Array
|
|
(
|
|
)
|
|
|
|
[from:protected] => Array
|
|
(
|
|
)
|
|
|
|
[join:protected] => Array
|
|
(
|
|
)
|
|
|
|
[where:protected] => Array
|
|
(
|
|
)
|
|
|
|
[orderby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[order:protected] => Array
|
|
(
|
|
)
|
|
|
|
[groupby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[having:protected] => Array
|
|
(
|
|
)
|
|
|
|
[distinct:protected] =>
|
|
[limit:protected] =>
|
|
[offset:protected] =>
|
|
[last_query:protected] =>
|
|
SELECT ip.id AS ip_address_id, ip.ip_address, m.id AS message_id,
|
|
m.name AS message, m.type, '84' AS member_id,
|
|
mip.datetime AS active_redir_datetime,
|
|
IF(mw.id IS NULL, 0, 2 - mw.permanent) AS whitelisted
|
|
FROM ip_addresses ip
|
|
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)
|
|
AND ('2014-01-05' 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 = '84' OR ip.member_id = '84'
|
|
GROUP BY ip.id
|
|
ORDER BY `ASC` desc,
|
|
m.self_cancel DESC, mip.datetime ASC
|
|
LIMIT 0, 0
|
|
|
|
[query_history:protected] => Array
|
|
(
|
|
)
|
|
|
|
)
|
|
|
|
[db_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[with_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[is_in_transaction:protected] =>
|
|
[is_logger_on:protected] => Array
|
|
(
|
|
[add] => 1
|
|
[update] => 1
|
|
[delete] => 1
|
|
)
|
|
|
|
)
|
|
|
|
)
|
|
|
|
[loaded:protected] => 1
|
|
[saved:protected] => 1
|
|
[sorting:protected] => Array
|
|
(
|
|
[id] => asc
|
|
)
|
|
|
|
[object_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[changed_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object_name:protected] => address_point
|
|
[object_plural:protected] => address_points
|
|
[table_name:protected] => address_points
|
|
[table_columns:protected] => Array
|
|
(
|
|
[id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
[sequenced] => 1
|
|
)
|
|
|
|
[name] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 255
|
|
[null] => 1
|
|
)
|
|
|
|
[country_id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 32767
|
|
[unsigned] =>
|
|
)
|
|
|
|
[town_id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
)
|
|
|
|
[street_id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
[null] => 1
|
|
)
|
|
|
|
[street_number] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 50
|
|
[null] => 1
|
|
)
|
|
|
|
[gps] => Array
|
|
(
|
|
[type] => string
|
|
[binary] => 1
|
|
[null] => 1
|
|
)
|
|
|
|
)
|
|
|
|
[ignored_columns:protected] =>
|
|
[primary_key:protected] => id
|
|
[primary_val:protected] => name
|
|
[foreign_key:protected] => Array
|
|
(
|
|
)
|
|
|
|
[table_names_plural:protected] => 1
|
|
[reload_on_wakeup:protected] => 1
|
|
[db:protected] => Database Object
|
|
(
|
|
[config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysql
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[driver:protected] => Database_Mysql_Driver Object
|
|
(
|
|
[link:protected] => Resource id #36
|
|
[db_config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysql
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[query_cache:protected] =>
|
|
)
|
|
|
|
[link:protected] => Resource id #36
|
|
[select:protected] => Array
|
|
(
|
|
)
|
|
|
|
[set:protected] => Array
|
|
(
|
|
)
|
|
|
|
[from:protected] => Array
|
|
(
|
|
)
|
|
|
|
[join:protected] => Array
|
|
(
|
|
)
|
|
|
|
[where:protected] => Array
|
|
(
|
|
)
|
|
|
|
[orderby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[order:protected] => Array
|
|
(
|
|
)
|
|
|
|
[groupby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[having:protected] => Array
|
|
(
|
|
)
|
|
|
|
[distinct:protected] =>
|
|
[limit:protected] =>
|
|
[offset:protected] =>
|
|
[last_query:protected] =>
|
|
SELECT ip.id AS ip_address_id, ip.ip_address, m.id AS message_id,
|
|
m.name AS message, m.type, '84' AS member_id,
|
|
mip.datetime AS active_redir_datetime,
|
|
IF(mw.id IS NULL, 0, 2 - mw.permanent) AS whitelisted
|
|
FROM ip_addresses ip
|
|
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)
|
|
AND ('2014-01-05' 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 = '84' OR ip.member_id = '84'
|
|
GROUP BY ip.id
|
|
ORDER BY `ASC` desc,
|
|
m.self_cancel DESC, mip.datetime ASC
|
|
LIMIT 0, 0
|
|
|
|
[query_history:protected] => Array
|
|
(
|
|
)
|
|
|
|
)
|
|
|
|
[db_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[with_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[is_in_transaction:protected] =>
|
|
[is_logger_on:protected] => Array
|
|
(
|
|
[add] => 1
|
|
[update] => 1
|
|
[delete] => 1
|
|
)
|
|
|
|
)
|
|
|
|
[members_domicile] => Members_domicile_Model Object
|
|
(
|
|
[belongs_to:protected] => Array
|
|
(
|
|
[0] => address_point
|
|
[1] => member
|
|
)
|
|
|
|
[has_one:protected] => Array
|
|
(
|
|
)
|
|
|
|
[has_many:protected] => Array
|
|
(
|
|
)
|
|
|
|
[has_and_belongs_to_many:protected] => Array
|
|
(
|
|
)
|
|
|
|
[load_with:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object:protected] => Array
|
|
(
|
|
[id] => 0
|
|
[member_id] => 0
|
|
[address_point_id] => 0
|
|
)
|
|
|
|
[changed:protected] => Array
|
|
(
|
|
)
|
|
|
|
[related:protected] => Array
|
|
(
|
|
[address_point] => Address_point_Model Object
|
|
(
|
|
[has_many:protected] => Array
|
|
(
|
|
[0] => members
|
|
[1] => devices
|
|
)
|
|
|
|
[belongs_to:protected] => Array
|
|
(
|
|
[0] => town
|
|
[1] => street
|
|
[2] => country
|
|
)
|
|
|
|
[has_one:protected] => Array
|
|
(
|
|
)
|
|
|
|
[has_and_belongs_to_many:protected] => Array
|
|
(
|
|
)
|
|
|
|
[load_with:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object:protected] => Array
|
|
(
|
|
[id] => 0
|
|
[name] =>
|
|
[country_id] => 0
|
|
[town_id] => 0
|
|
[street_id] =>
|
|
[street_number] =>
|
|
[gps] =>
|
|
)
|
|
|
|
[changed:protected] => Array
|
|
(
|
|
)
|
|
|
|
[related:protected] => Array
|
|
(
|
|
)
|
|
|
|
[loaded:protected] =>
|
|
[saved:protected] =>
|
|
[sorting:protected] => Array
|
|
(
|
|
[id] => asc
|
|
)
|
|
|
|
[object_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[changed_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object_name:protected] => address_point
|
|
[object_plural:protected] => address_points
|
|
[table_name:protected] => address_points
|
|
[table_columns:protected] => Array
|
|
(
|
|
[id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
[sequenced] => 1
|
|
)
|
|
|
|
[name] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 255
|
|
[null] => 1
|
|
)
|
|
|
|
[country_id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 32767
|
|
[unsigned] =>
|
|
)
|
|
|
|
[town_id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
)
|
|
|
|
[street_id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
[null] => 1
|
|
)
|
|
|
|
[street_number] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 50
|
|
[null] => 1
|
|
)
|
|
|
|
[gps] => Array
|
|
(
|
|
[type] => string
|
|
[binary] => 1
|
|
[null] => 1
|
|
)
|
|
|
|
)
|
|
|
|
[ignored_columns:protected] =>
|
|
[primary_key:protected] => id
|
|
[primary_val:protected] => name
|
|
[foreign_key:protected] => Array
|
|
(
|
|
)
|
|
|
|
[table_names_plural:protected] => 1
|
|
[reload_on_wakeup:protected] => 1
|
|
[db:protected] => Database Object
|
|
(
|
|
[config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysql
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[driver:protected] => Database_Mysql_Driver Object
|
|
(
|
|
[link:protected] => Resource id #36
|
|
[db_config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysql
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[query_cache:protected] =>
|
|
)
|
|
|
|
[link:protected] => Resource id #36
|
|
[select:protected] => Array
|
|
(
|
|
)
|
|
|
|
[set:protected] => Array
|
|
(
|
|
)
|
|
|
|
[from:protected] => Array
|
|
(
|
|
)
|
|
|
|
[join:protected] => Array
|
|
(
|
|
)
|
|
|
|
[where:protected] => Array
|
|
(
|
|
)
|
|
|
|
[orderby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[order:protected] => Array
|
|
(
|
|
)
|
|
|
|
[groupby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[having:protected] => Array
|
|
(
|
|
)
|
|
|
|
[distinct:protected] =>
|
|
[limit:protected] =>
|
|
[offset:protected] =>
|
|
[last_query:protected] =>
|
|
SELECT ip.id AS ip_address_id, ip.ip_address, m.id AS message_id,
|
|
m.name AS message, m.type, '84' AS member_id,
|
|
mip.datetime AS active_redir_datetime,
|
|
IF(mw.id IS NULL, 0, 2 - mw.permanent) AS whitelisted
|
|
FROM ip_addresses ip
|
|
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)
|
|
AND ('2014-01-05' 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 = '84' OR ip.member_id = '84'
|
|
GROUP BY ip.id
|
|
ORDER BY `ASC` desc,
|
|
m.self_cancel DESC, mip.datetime ASC
|
|
LIMIT 0, 0
|
|
|
|
[query_history:protected] => Array
|
|
(
|
|
)
|
|
|
|
)
|
|
|
|
[db_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[with_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[is_in_transaction:protected] =>
|
|
[is_logger_on:protected] => Array
|
|
(
|
|
[add] => 1
|
|
[update] => 1
|
|
[delete] => 1
|
|
)
|
|
|
|
)
|
|
|
|
)
|
|
|
|
[loaded:protected] =>
|
|
[saved:protected] =>
|
|
[sorting:protected] => Array
|
|
(
|
|
[id] => asc
|
|
)
|
|
|
|
[object_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[changed_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object_name:protected] => members_domicile
|
|
[object_plural:protected] => members_domiciles
|
|
[table_name:protected] => members_domiciles
|
|
[table_columns:protected] => Array
|
|
(
|
|
[id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
[sequenced] => 1
|
|
)
|
|
|
|
[member_id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
)
|
|
|
|
[address_point_id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
)
|
|
|
|
)
|
|
|
|
[ignored_columns:protected] =>
|
|
[primary_key:protected] => id
|
|
[primary_val:protected] => name
|
|
[foreign_key:protected] => Array
|
|
(
|
|
)
|
|
|
|
[table_names_plural:protected] => 1
|
|
[reload_on_wakeup:protected] => 1
|
|
[db:protected] => Database Object
|
|
(
|
|
[config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysql
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[driver:protected] => Database_Mysql_Driver Object
|
|
(
|
|
[link:protected] => Resource id #36
|
|
[db_config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysql
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[query_cache:protected] =>
|
|
)
|
|
|
|
[link:protected] => Resource id #36
|
|
[select:protected] => Array
|
|
(
|
|
)
|
|
|
|
[set:protected] => Array
|
|
(
|
|
)
|
|
|
|
[from:protected] => Array
|
|
(
|
|
)
|
|
|
|
[join:protected] => Array
|
|
(
|
|
)
|
|
|
|
[where:protected] => Array
|
|
(
|
|
)
|
|
|
|
[orderby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[order:protected] => Array
|
|
(
|
|
)
|
|
|
|
[groupby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[having:protected] => Array
|
|
(
|
|
)
|
|
|
|
[distinct:protected] =>
|
|
[limit:protected] =>
|
|
[offset:protected] =>
|
|
[last_query:protected] =>
|
|
SELECT ip.id AS ip_address_id, ip.ip_address, m.id AS message_id,
|
|
m.name AS message, m.type, '84' AS member_id,
|
|
mip.datetime AS active_redir_datetime,
|
|
IF(mw.id IS NULL, 0, 2 - mw.permanent) AS whitelisted
|
|
FROM ip_addresses ip
|
|
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)
|
|
AND ('2014-01-05' 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 = '84' OR ip.member_id = '84'
|
|
GROUP BY ip.id
|
|
ORDER BY `ASC` desc,
|
|
m.self_cancel DESC, mip.datetime ASC
|
|
LIMIT 0, 0
|
|
|
|
[query_history:protected] => Array
|
|
(
|
|
)
|
|
|
|
)
|
|
|
|
[db_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[with_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[is_in_transaction:protected] =>
|
|
[is_logger_on:protected] => Array
|
|
(
|
|
[add] => 1
|
|
[update] => 1
|
|
[delete] => 1
|
|
)
|
|
|
|
)
|
|
|
|
)
|
|
|
|
[loaded:protected] => 1
|
|
[saved:protected] => 1
|
|
[sorting:protected] => Array
|
|
(
|
|
[id] => asc
|
|
)
|
|
|
|
[object_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[changed_relations:protected] => Array
|
|
(
|
|
)
|
|
|
|
[object_name:protected] => member
|
|
[object_plural:protected] => members
|
|
[table_name:protected] => members
|
|
[table_columns:protected] => Array
|
|
(
|
|
[id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
[sequenced] => 1
|
|
)
|
|
|
|
[user_id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
[null] => 1
|
|
)
|
|
|
|
[registration] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 127
|
|
[unsigned] =>
|
|
)
|
|
|
|
[name] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 100
|
|
)
|
|
|
|
[address_point_id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
)
|
|
|
|
[type] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 127
|
|
[unsigned] =>
|
|
[null] => 1
|
|
)
|
|
|
|
[external_type] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 127
|
|
[unsigned] =>
|
|
[null] => 1
|
|
)
|
|
|
|
[organization_identifier] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 20
|
|
[null] => 1
|
|
)
|
|
|
|
[vat_organization_identifier] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 30
|
|
[null] => 1
|
|
)
|
|
|
|
[speed_class_id] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
[null] => 1
|
|
)
|
|
|
|
[entrance_fee] => Array
|
|
(
|
|
[type] => float
|
|
[null] => 1
|
|
)
|
|
|
|
[debt_payment_rate] => Array
|
|
(
|
|
[type] => float
|
|
[null] => 1
|
|
)
|
|
|
|
[entrance_fee_left] => Array
|
|
(
|
|
[type] => float
|
|
[null] => 1
|
|
)
|
|
|
|
[entrance_fee_date] => Array
|
|
(
|
|
[type] => string
|
|
[format] => 0000-00-00
|
|
[null] => 1
|
|
)
|
|
|
|
[entrance_date] => Array
|
|
(
|
|
[type] => string
|
|
[format] => 0000-00-00
|
|
[null] => 1
|
|
)
|
|
|
|
[entrance_form_received] => Array
|
|
(
|
|
[type] => string
|
|
[format] => 0000-00-00
|
|
[null] => 1
|
|
)
|
|
|
|
[entrance_form_accepted] => Array
|
|
(
|
|
[type] => string
|
|
[format] => 0000-00-00
|
|
[null] => 1
|
|
)
|
|
|
|
[leaving_date] => Array
|
|
(
|
|
[type] => string
|
|
[format] => 0000-00-00
|
|
)
|
|
|
|
[applicant_registration_datetime] => Array
|
|
(
|
|
[type] => string
|
|
[format] => 0000-00-00 00:00:00
|
|
[null] => 1
|
|
)
|
|
|
|
[applicant_connected_from] => Array
|
|
(
|
|
[type] => string
|
|
[format] => 0000-00-00
|
|
[null] => 1
|
|
)
|
|
|
|
[locked] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 127
|
|
[unsigned] =>
|
|
)
|
|
|
|
[voip_billing_limit] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 2147483647
|
|
[unsigned] =>
|
|
)
|
|
|
|
[voip_billing_type] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 10
|
|
)
|
|
|
|
[comment] => Array
|
|
(
|
|
[type] => string
|
|
[length] => 250
|
|
[null] => 1
|
|
)
|
|
|
|
[notification_by_redirection] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 127
|
|
[unsigned] =>
|
|
)
|
|
|
|
[notification_by_email] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 127
|
|
[unsigned] =>
|
|
)
|
|
|
|
[notification_by_sms] => Array
|
|
(
|
|
[type] => int
|
|
[max] => 127
|
|
[unsigned] =>
|
|
)
|
|
|
|
)
|
|
|
|
[ignored_columns:protected] =>
|
|
[primary_key:protected] => id
|
|
[primary_val:protected] => name
|
|
[foreign_key:protected] => Array
|
|
(
|
|
)
|
|
|
|
[table_names_plural:protected] => 1
|
|
[reload_on_wakeup:protected] => 1
|
|
[db:protected] => Database Object
|
|
(
|
|
[config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysql
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[driver:protected] => Database_Mysql_Driver Object
|
|
(
|
|
[link:protected] => Resource id #36
|
|
[db_config:protected] => Array
|
|
(
|
|
[benchmark] =>
|
|
[persistent] =>
|
|
[connection] => Array
|
|
(
|
|
[type] => mysql
|
|
[user] => freenetis
|
|
[pass] =>
|
|
[host] => localhost
|
|
[port] =>
|
|
[socket] =>
|
|
[database] => freenetis
|
|
)
|
|
|
|
[character_set] => utf8
|
|
[table_prefix] =>
|
|
[object] => 1
|
|
[cache] =>
|
|
[escape] => 1
|
|
)
|
|
|
|
[query_cache:protected] =>
|
|
)
|
|
|
|
[link:protected] => Resource id #36
|
|
[select:protected] => Array
|
|
(
|
|
)
|
|
|
|
[set:protected] => Array
|
|
(
|
|
)
|
|
|
|
[from:protected] => Array
|
|
(
|
|
)
|
|
|
|
[join:protected] => Array
|
|
(
|
|
)
|
|
|
|
[where:protected] => Array
|
|
(
|
|
)
|
|
|
|
[orderby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[order:protected] => Array
|
|
(
|
|
)
|
|
|
|
[groupby:protected] => Array
|
|
(
|
|
)
|
|
|
|
[having:protected] => Array
|
|
(
|
|
)
|
|
|
|
[distinct:protected] =>
|
|
[limit:protected] =>
|
|
[offset:protected] =>
|
|
[last_query:protected] =>
|
|
SELECT ip.id AS ip_address_id, ip.ip_address, m.id AS message_id,
|
|
m.name AS message, m.type, '84' AS member_id,
|
|
mip.datetime AS active_redir_datetime,
|
|
IF(mw.id IS NULL, 0, 2 - mw.permanent) AS whitelisted
|
|
FROM ip_addresses ip
|
|
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)
|
|
AND ('2014-01-05' 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 = '84' OR ip.member_id = '84'
|
|
GROUP BY ip.id
|
|
ORDER BY `ASC` desc,
|
|
m.self_cancel DESC, mip.datetime ASC
|
|
LIMIT 0, 0
|
|
|
|
[query_history:protected] => Array
|
|
(
|
|
)
|
|
|
|
)
|
|
|
|
[db_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[with_applied:protected] => Array
|
|
(
|
|
)
|
|
|
|
[is_in_transaction:protected] =>
|
|
[is_logger_on:protected] => Array
|
|
(
|
|
[add] => 1
|
|
[update] => 1
|
|
[delete] => 1
|
|
)
|
|
|
|
)
|
|
|
|
)
|
|
|
|
[1] => show
|
|
)
|
|
, Array
|
|
(
|
|
[0] => 84
|
|
[1] => message
|
|
[2] => ASC
|
|
[3] => page
|
|
[4] => 1
|
|
)
|
|
)</pre></li>
|
|
<li><pre>Kohana::instance( )</pre></li>
|
|
<li><strong>system/core/Event.php [217]:</strong><pre>call_user_func( Array
|
|
(
|
|
[0] => Kohana
|
|
[1] => instance
|
|
)
|
|
)</pre></li>
|
|
<li><strong>system/core/Bootstrap.php [55]:</strong><pre>Event::run( system.execute )</pre></li>
|
|
<li><strong>index.php [112]:</strong><pre>require( system/core/Bootstrap.php )</pre></li></ul></div></body></html>
|