FreenetIS verze: 1.1.0~beta3
PHP verze: 5.3.3-7+squeeze17
Nahlasil: Ondrej Fibich
Popis: Razeni v tabulce IP adres clena nefunguje - chyba v parametrech predanych metode modelu.
Chyba se vyskytla na radku 374 souboru system/libraries/drivers/Database/Mysql.php.
Mysql_Result->__construct( )
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, '660' 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 ('2013-11-07' 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 = '660' OR ip.member_id = '660'
GROUP BY ip.id
ORDER BY `DESC` desc,
m.self_cancel DESC, mip.datetime ASC
LIMIT 0, 0
)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 `DESC` desc, m.self_cancel DESC, mip.datetime ASC LIMIT 0, 0 , 660, 2013-11-07, 660, 660 )
Ip_address_Model->get_ips_and_redirections_of_member( 660 )
Members_Controller->show( 660, ip_address, DESC, page, 1 )
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.4
[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] => 3
)
[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, '660' 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 ('2013-11-07' 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 = '660' OR ip.member_id = '660'
GROUP BY ip.id
ORDER BY `DESC` 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] => 660
[user_id] => 532
[registration] => 1
[name] => Vlastislav Janacek
[address_point_id] => 500
[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] => 2007-01-12
[entrance_date] => 2007-01-01
[entrance_form_received] =>
[entrance_form_accepted] =>
[leaving_date] => 0000-00-00
[applicant_registration_datetime] =>
[applicant_connected_from] =>
[locked] => 0
[voip_billing_limit] => 0
[voip_billing_type] => prepaid
[comment] =>
[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] => 500
[name] =>
[country_id] => 55
[town_id] => 13
[street_id] => 183
[street_number] => 60
[gps] => ��������ƻ#c�H@9^��I�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] => 183
[town_id] => 13
[street] => Bohuslavice nad Vlari
[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, '660' 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 ('2013-11-07' 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 = '660' OR ip.member_id = '660'
GROUP BY ip.id
ORDER BY `DESC` 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] => 13
[zip_code] => 76321
[town] => Bohuslavice nad Vlari
[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, '660' 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 ('2013-11-07' 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 = '660' OR ip.member_id = '660'
GROUP BY ip.id
ORDER BY `DESC` 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, '660' 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 ('2013-11-07' 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 = '660' OR ip.member_id = '660'
GROUP BY ip.id
ORDER BY `DESC` 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, '660' 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 ('2013-11-07' 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 = '660' OR ip.member_id = '660'
GROUP BY ip.id
ORDER BY `DESC` 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, '660' 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 ('2013-11-07' 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 = '660' OR ip.member_id = '660'
GROUP BY ip.id
ORDER BY `DESC` 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, '660' 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 ('2013-11-07' 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 = '660' OR ip.member_id = '660'
GROUP BY ip.id
ORDER BY `DESC` 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, '660' 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 ('2013-11-07' 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 = '660' OR ip.member_id = '660'
GROUP BY ip.id
ORDER BY `DESC` 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] => 660
[1] => ip_address
[2] => DESC
[3] => page
[4] => 1
)
)Kohana::instance( )
call_user_func( Array
(
[0] => Kohana
[1] => instance
)
)Event::run( system.execute )
require( system/core/Bootstrap.php )