-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathupdate2014_07_07.sql
94 lines (87 loc) · 25.6 KB
/
update2014_07_07.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
INSERT INTO `admin_pages` (`id`, `f_id`, `name`, `url`, `icon`, `order`, `page_map_reorders`) VALUES
(91, 30, 'User History', 'user-history', '', 0, 0);
INSERT INTO `admin_pages` (`id`, `f_id`, `name`, `url`, `icon`, `order`, `page_map_reorders`) VALUES
(92, 30, 'History Actions', 'history-actions', '', 15, 0);
CREATE TABLE history_actions (id INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ) ENGINE = MYISAM;
ALTER TABLE history_actions ADD `name_en` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE history_actions ADD `name_es` VARCHAR( 255 ) NOT NULL ;
INSERT INTO `admin_controls` (`id`, `page_id`, `tab_id`, `action`, `class`, `arguments`, `order`, `is_static`) VALUES
(258, 92, 0, 'form', 'Form', 'a:10:{s:4:"name";s:15:"history_actions";s:6:"method";s:0:"";s:5:"class";s:0:"";s:5:"table";s:15:"history_actions";s:18:"start_on_construct";s:0:"";s:9:"go_to_url";s:0:"";s:12:"go_to_action";s:0:"";s:12:"go_to_is_tab";s:0:"";s:6:"target";s:0:"";s:14:"return_to_self";s:0:"";}', 0, 'N'),
(259, 92, 0, '', 'MultiList', 'a:4:{s:5:"class";s:0:"";s:8:"rootname";s:15:"History Actions";s:14:"row_end_button";s:0:"";s:8:"dragdrop";s:0:"";}', 0, 'N');
INSERT INTO `admin_controls_methods` (`id`, `method`, `arguments`, `order`, `control_id`, `p_id`) VALUES
(2138, 'textInput', 'a:13:{s:4:"name";s:4:"name_en";s:7:"caption";s:4:"Name (EN)";s:8:"required";s:1:"1";s:5:"value";s:0:"";s:2:"id";s:0:"";s:13:"db_field_type";s:0:"";s:5:"class";s:0:"";s:7:"jscript";s:0:"";s:5:"style";s:0:"";s:15:"is_manual_array";s:0:"";s:9:"is_unique";s:0:"";s:12:"default_text";s:0:"";s:17:"delete_whitespace";s:0:"";}', 0, 258, 0),
(2142, 'textInput', 'a:13:{s:4:"name";s:4:"name_es";s:7:"caption";s:4:"Name (ES)";s:8:"required";s:1:"1";s:5:"value";s:0:"";s:2:"id";s:0:"";s:13:"db_field_type";s:0:"";s:5:"class";s:0:"";s:7:"jscript";s:0:"";s:5:"style";s:0:"";s:15:"is_manual_array";s:0:"";s:9:"is_unique";s:0:"";s:12:"default_text";s:0:"";s:17:"delete_whitespace";s:0:"";}', 0, 258, 0),
(2139, 'submitButton', 'a:6:{s:4:"name";s:4:"Save";s:5:"value";s:4:"Save";s:2:"id";s:0:"";s:5:"class";s:0:"";s:7:"jscript";s:0:"";s:5:"style";s:0:"";}', 2, 258, 0),
(2140, 'cancelButton', 'a:4:{s:5:"value";s:6:"Cancel";s:2:"id";s:0:"";s:5:"class";s:0:"";s:5:"style";s:0:"";}', 1, 258, 0),
(2141, 'addTable', 'a:8:{s:5:"table";s:15:"history_actions";s:12:"table_fields";a:1:{s:4:"name_en";s:4:"name_en";}s:3:"url";s:0:"";s:6:"parent";s:0:"";s:5:"class";s:0:"";s:14:"target_elem_id";s:8:"edit_box";s:10:"url_is_tab";s:0:"";s:15:"accept_children";s:0:"";}', 0, 259, 0);
INSERT INTO `history_actions` (`id`, `name_en`, `name_es`) VALUES
(1, 'Login', 'Login'),
(2, 'Buy Order', 'Orden Compra'),
(3, 'Sell Order', 'Orden Venta'),
(4, 'Deposit', 'Depositar'),
(5, 'Withdraw', 'Retirar');
CREATE TABLE history ( id INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ) ENGINE = MYISAM;
ALTER TABLE history ADD `date` DATETIME NOT NULL;
ALTER TABLE history ADD `ip` VARCHAR( 255 ) NOT NULL;
ALTER TABLE history ADD `history_action` INT( 10 ) NOT NULL;
ALTER TABLE history ADD `order_id` INT( 10 ) NOT NULL;
ALTER TABLE history ADD `bitcoin_address` VARCHAR( 255 ) NOT NULL;
ALTER TABLE history ADD `site_user` INT( 10 ) NOT NULL;
ALTER TABLE history ADD `request_id` INT( 10 ) NOT NULL;
INSERT INTO `admin_controls` (`id`, `page_id`, `tab_id`, `action`, `class`, `arguments`, `order`, `is_static`) VALUES
(261, 91, 0, 'form', 'Form', 'a:10:{s:4:"name";s:7:"history";s:6:"method";s:0:"";s:5:"class";s:0:"";s:5:"table";s:7:"history";s:18:"start_on_construct";s:0:"";s:9:"go_to_url";s:0:"";s:12:"go_to_action";s:0:"";s:12:"go_to_is_tab";s:0:"";s:6:"target";s:0:"";s:14:"return_to_self";s:0:"";}', 0, 'N'),
(262, 91, 0, 'record', 'Record', 'a:1:{s:5:"table";s:7:"history";}', 0, 'N'),
(263, 91, 0, '', 'Grid', 'a:24:{s:5:"table";s:7:"history";s:4:"mode";s:0:"";s:13:"rows_per_page";s:0:"";s:5:"class";s:0:"";s:12:"show_buttons";s:1:"Y";s:14:"target_elem_id";s:8:"edit_box";s:9:"max_pages";s:0:"";s:16:"pagination_label";s:0:"";s:18:"show_list_captions";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:10:"save_order";s:0:"";s:12:"enable_graph";s:0:"";s:12:"enable_table";s:0:"";s:11:"enable_list";s:0:"";s:17:"enable_graph_line";s:0:"";s:16:"enable_graph_pie";s:0:"";s:15:"button_link_url";s:0:"";s:18:"button_link_is_tab";s:0:"";s:10:"sql_filter";s:0:"";s:16:"alert_condition1";s:0:"";s:16:"alert_condition2";s:0:"";s:8:"group_by";s:0:"";s:11:"no_group_by";s:0:"";}', 0, 'N'),
(264, 0, 30, 'form', 'Tabs', 'a:5:{s:5:"class";s:0:"";s:11:"target_elem";s:8:"edit_box";s:8:"callback";s:0:"";s:8:"is_inset";s:1:"1";s:1:"i";s:0:"";}', 1, 'N'),
(265, 0, 30, 'record', 'Tabs', 'a:5:{s:5:"class";s:0:"";s:11:"target_elem";s:8:"edit_box";s:8:"callback";s:0:"";s:8:"is_inset";s:1:"1";s:1:"i";s:0:"";}', 0, 'N');
INSERT INTO `admin_controls_methods` (`id`, `method`, `arguments`, `order`, `control_id`, `p_id`) VALUES
(2144, 'dateWidget', 'a:19:{s:4:"name";s:4:"date";s:7:"caption";s:4:"Date";s:8:"required";s:0:"";s:4:"time";s:1:"1";s:4:"ampm";s:1:"1";s:9:"req_start";s:0:"";s:7:"req_end";s:0:"";s:5:"value";s:0:"";s:7:"link_to";s:0:"";s:2:"id";s:0:"";s:5:"class";s:0:"";s:6:"format";s:0:"";s:7:"jscript";s:0:"";s:5:"style";s:0:"";s:19:"is_filter_range_end";s:0:"";s:14:"document_ready";s:0:"";s:9:"only_time";s:0:"";s:16:"regular_interval";s:0:"";s:13:"only_interval";s:0:"";}', 1, 261, 0),
(2145, 'selectInput', 'a:20:{s:4:"name";s:14:"history_action";s:7:"caption";s:6:"Action";s:8:"required";s:0:"";s:5:"value";s:0:"";s:13:"options_array";s:0:"";s:8:"subtable";s:15:"history_actions";s:15:"subtable_fields";a:1:{s:7:"name_en";s:7:"name_en";}s:13:"subtable_f_id";s:0:"";s:2:"id";s:0:"";s:5:"class";s:0:"";s:7:"jscript";s:0:"";s:5:"style";s:0:"";s:10:"f_id_field";s:0:"";s:12:"default_text";s:0:"";s:10:"depends_on";s:0:"";s:20:"function_to_elements";s:0:"";s:16:"first_is_default";s:0:"";s:5:"level";s:0:"";s:11:"concat_char";s:0:"";s:9:"is_catsel";s:0:"";}', 3, 261, 0),
(2146, 'textInput', 'a:13:{s:4:"name";s:2:"ip";s:7:"caption";s:10:"IP Address";s:8:"required";s:0:"";s:5:"value";s:0:"";s:2:"id";s:0:"";s:13:"db_field_type";s:0:"";s:5:"class";s:0:"";s:7:"jscript";s:0:"";s:5:"style";s:0:"";s:15:"is_manual_array";s:0:"";s:9:"is_unique";s:0:"";s:12:"default_text";s:0:"";s:17:"delete_whitespace";s:0:"";}', 2, 261, 0),
(2147, 'passiveField', 'a:14:{s:4:"name";s:8:"order_id";s:7:"caption";s:8:"Order ID";s:8:"subtable";s:0:"";s:15:"subtable_fields";s:0:"";s:8:"link_url";s:9:"order-log";s:11:"concat_char";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:15:"create_db_field";s:3:"int";s:13:"default_value";s:0:"";s:23:"dont_fill_automatically";s:0:"";}', 9, 261, 0),
(2148, 'textInput', 'a:13:{s:4:"name";s:15:"bitcoin_address";s:7:"caption";s:15:"Bitcoin Address";s:8:"required";s:0:"";s:5:"value";s:0:"";s:2:"id";s:0:"";s:13:"db_field_type";s:0:"";s:5:"class";s:0:"";s:7:"jscript";s:0:"";s:5:"style";s:0:"";s:15:"is_manual_array";s:0:"";s:9:"is_unique";s:0:"";s:12:"default_text";s:0:"";s:17:"delete_whitespace";s:0:"";}', 4, 261, 0),
(2149, 'passiveField', 'a:14:{s:4:"name";s:9:"order_btc";s:7:"caption";s:9:"Order BTC";s:8:"subtable";s:9:"order_log";s:15:"subtable_fields";a:1:{s:3:"btc";s:3:"btc";}s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:10:"f_id_field";s:29:"history.order_id,order_log.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:15:"create_db_field";s:0:"";s:13:"default_value";s:0:"";s:23:"dont_fill_automatically";s:0:"";}', 10, 261, 0),
(2150, 'passiveField', 'a:14:{s:4:"name";s:15:"order_btc_price";s:7:"caption";s:15:"Order BTC Price";s:8:"subtable";s:9:"order_log";s:15:"subtable_fields";a:1:{s:9:"btc_price";s:9:"btc_price";}s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:10:"f_id_field";s:29:"history.order_id,order_log.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:15:"create_db_field";s:0:"";s:13:"default_value";s:0:"";s:23:"dont_fill_automatically";s:0:"";}', 11, 261, 0),
(2151, 'passiveField', 'a:14:{s:4:"name";s:14:"order_currency";s:7:"caption";s:14:"Order Currency";s:8:"subtable";s:10:"currencies";s:15:"subtable_fields";a:1:{s:8:"currency";s:8:"currency";}s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:10:"f_id_field";s:62:"history.order_id,order_log.id,order_log.currency,currencies.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:15:"create_db_field";s:0:"";s:13:"default_value";s:0:"";s:23:"dont_fill_automatically";s:0:"";}', 12, 261, 0),
(2152, 'submitButton', 'a:6:{s:4:"name";s:4:"Save";s:5:"value";s:4:"Save";s:2:"id";s:0:"";s:5:"class";s:0:"";s:7:"jscript";s:0:"";s:5:"style";s:0:"";}', 13, 261, 0),
(2153, 'cancelButton', 'a:4:{s:5:"value";s:6:"Cancel";s:2:"id";s:0:"";s:5:"class";s:0:"";s:5:"style";s:0:"";}', 14, 261, 0),
(2154, 'field', 'a:14:{s:4:"name";s:4:"date";s:7:"caption";s:4:"Date";s:8:"subtable";s:0:"";s:15:"subtable_fields";s:0:"";s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:7:"in_form";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:14:"override_value";s:0:"";s:13:"link_id_field";s:0:"";}', 0, 262, 0),
(2155, 'field', 'a:14:{s:4:"name";s:2:"ip";s:7:"caption";s:10:"IP Address";s:8:"subtable";s:0:"";s:15:"subtable_fields";s:0:"";s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:7:"in_form";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:14:"override_value";s:0:"";s:13:"link_id_field";s:0:"";}', 2, 262, 0),
(2156, 'field', 'a:14:{s:4:"name";s:15:"bitcoin_address";s:7:"caption";s:15:"Bitcoin Address";s:8:"subtable";s:0:"";s:15:"subtable_fields";s:0:"";s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:7:"in_form";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:14:"override_value";s:0:"";s:13:"link_id_field";s:0:"";}', 4, 262, 0),
(2157, 'field', 'a:14:{s:4:"name";s:14:"history_action";s:7:"caption";s:6:"Action";s:8:"subtable";s:15:"history_actions";s:15:"subtable_fields";a:1:{s:7:"name_en";s:7:"name_en";}s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:7:"in_form";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:14:"override_value";s:0:"";s:13:"link_id_field";s:0:"";}', 3, 262, 0),
(2158, 'field', 'a:14:{s:4:"name";s:8:"order_id";s:7:"caption";s:8:"Order ID";s:8:"subtable";s:0:"";s:15:"subtable_fields";s:0:"";s:8:"link_url";s:9:"order-log";s:11:"concat_char";s:0:"";s:7:"in_form";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:14:"override_value";s:0:"";s:13:"link_id_field";s:0:"";}', 9, 262, 0),
(2159, 'field', 'a:14:{s:4:"name";s:9:"order_btc";s:7:"caption";s:9:"Order BTC";s:8:"subtable";s:9:"order_log";s:15:"subtable_fields";a:1:{s:3:"btc";s:3:"btc";}s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:7:"in_form";s:0:"";s:10:"f_id_field";s:29:"history.order_id,order_log.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:14:"override_value";s:0:"";s:13:"link_id_field";s:0:"";}', 10, 262, 0),
(2160, 'field', 'a:14:{s:4:"name";s:15:"order_btc_price";s:7:"caption";s:15:"Order BTC Price";s:8:"subtable";s:9:"order_log";s:15:"subtable_fields";a:2:{s:3:"btc";s:3:"btc";s:9:"btc_price";s:9:"btc_price";}s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:7:"in_form";s:0:"";s:10:"f_id_field";s:29:"history.order_id,order_log.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:14:"override_value";s:0:"";s:13:"link_id_field";s:0:"";}', 11, 262, 0),
(2161, 'field', 'a:14:{s:4:"name";s:14:"order_currency";s:7:"caption";s:14:"Order Currency";s:8:"subtable";s:10:"currencies";s:15:"subtable_fields";a:1:{s:8:"currency";s:8:"currency";}s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:7:"in_form";s:0:"";s:10:"f_id_field";s:62:"history.order_id,order_log.id,order_log.currency,currencies.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:14:"override_value";s:0:"";s:13:"link_id_field";s:0:"";}', 12, 262, 0),
(2162, 'cancelButton', 'a:4:{s:5:"value";s:2:"OK";s:2:"id";s:0:"";s:5:"class";s:0:"";s:5:"style";s:0:"";}', 13, 262, 0),
(2163, 'passiveField', 'a:14:{s:4:"name";s:10:"request_id";s:7:"caption";s:10:"Request ID";s:8:"subtable";s:0:"";s:15:"subtable_fields";s:0:"";s:8:"link_url";s:8:"requests";s:11:"concat_char";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:1:"1";s:16:"limit_is_curdate";s:0:"";s:15:"create_db_field";s:3:"int";s:13:"default_value";s:0:"";s:23:"dont_fill_automatically";s:0:"";}', 5, 261, 0),
(2164, 'passiveField', 'a:14:{s:4:"name";s:14:"request_amount";s:7:"caption";s:14:"Request Amount";s:8:"subtable";s:8:"requests";s:15:"subtable_fields";a:1:{s:6:"amount";s:6:"amount";}s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:10:"f_id_field";s:30:"history.request_id,requests.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:15:"create_db_field";s:0:"";s:13:"default_value";s:0:"";s:23:"dont_fill_automatically";s:0:"";}', 6, 261, 0),
(2165, 'passiveField', 'a:14:{s:4:"name";s:16:"request_currency";s:7:"caption";s:16:"Request Currency";s:8:"subtable";s:10:"currencies";s:15:"subtable_fields";a:1:{s:8:"currency";s:8:"currency";}s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:10:"f_id_field";s:62:"history.request_id,requests.id,requests.currency,currencies.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:15:"create_db_field";s:0:"";s:13:"default_value";s:0:"";s:23:"dont_fill_automatically";s:0:"";}', 7, 261, 0),
(2166, 'passiveField', 'a:14:{s:4:"name";s:15:"request_account";s:7:"caption";s:20:"Request Bank Account";s:8:"subtable";s:8:"requests";s:15:"subtable_fields";a:1:{s:7:"account";s:7:"account";}s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:10:"f_id_field";s:30:"history.request_id,requests.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:15:"create_db_field";s:0:"";s:13:"default_value";s:0:"";s:23:"dont_fill_automatically";s:0:"";}', 8, 261, 0),
(2167, 'field', 'a:14:{s:4:"name";s:10:"request_id";s:7:"caption";s:10:"Request ID";s:8:"subtable";s:0:"";s:15:"subtable_fields";s:0:"";s:8:"link_url";s:8:"requests";s:11:"concat_char";s:0:"";s:7:"in_form";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:1:"1";s:16:"limit_is_curdate";s:0:"";s:14:"override_value";s:0:"";s:13:"link_id_field";s:0:"";}', 5, 262, 0),
(2168, 'field', 'a:14:{s:4:"name";s:14:"request_amount";s:7:"caption";s:14:"Request Amount";s:8:"subtable";s:8:"requests";s:15:"subtable_fields";a:1:{s:6:"amount";s:6:"amount";}s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:7:"in_form";s:0:"";s:10:"f_id_field";s:30:"history.request_id,requests.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:14:"override_value";s:0:"";s:13:"link_id_field";s:0:"";}', 6, 262, 0),
(2169, 'field', 'a:14:{s:4:"name";s:15:"request_account";s:7:"caption";s:20:"Request Bank Account";s:8:"subtable";s:8:"requests";s:15:"subtable_fields";a:1:{s:7:"account";s:7:"account";}s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:7:"in_form";s:0:"";s:10:"f_id_field";s:30:"history.request_id,requests.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:14:"override_value";s:0:"";s:13:"link_id_field";s:0:"";}', 7, 262, 0),
(2170, 'field', 'a:14:{s:4:"name";s:16:"request_currency";s:7:"caption";s:16:"Request Currency";s:8:"subtable";s:10:"currencies";s:15:"subtable_fields";a:1:{s:8:"currency";s:8:"currency";}s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:7:"in_form";s:0:"";s:10:"f_id_field";s:62:"history.request_id,requests.id,requests.currency,currencies.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:14:"override_value";s:0:"";s:13:"link_id_field";s:0:"";}', 8, 262, 0),
(2171, 'field', 'a:18:{s:4:"name";s:4:"date";s:8:"subtable";s:0:"";s:14:"header_caption";s:4:"Date";s:6:"filter";s:1:"Y";s:8:"link_url";s:0:"";s:15:"subtable_fields";s:0:"";s:22:"subtable_fields_concat";s:0:"";s:5:"class";s:0:"";s:18:"aggregate_function";s:0:"";s:12:"thumb_amount";s:0:"";s:12:"media_amount";s:0:"";s:10:"media_size";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:8:"is_media";s:0:"";}', 2, 263, 0),
(2172, 'field', 'a:18:{s:4:"name";s:2:"ip";s:8:"subtable";s:0:"";s:14:"header_caption";s:2:"IP";s:6:"filter";s:1:"Y";s:8:"link_url";s:0:"";s:15:"subtable_fields";s:0:"";s:22:"subtable_fields_concat";s:0:"";s:5:"class";s:0:"";s:18:"aggregate_function";s:0:"";s:12:"thumb_amount";s:0:"";s:12:"media_amount";s:0:"";s:10:"media_size";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:8:"is_media";s:0:"";}', 3, 263, 0),
(2173, 'autoComplete', 'a:22:{s:4:"name";s:9:"site_user";s:7:"caption";s:4:"User";s:8:"required";s:0:"";s:5:"value";s:0:"";s:8:"multiple";s:0:"";s:13:"options_array";s:0:"";s:8:"subtable";s:10:"site_users";s:15:"subtable_fields";a:2:{s:10:"first_name";s:10:"first_name";s:9:"last_name";s:9:"last_name";}s:13:"subtable_f_id";s:0:"";s:2:"id";s:0:"";s:5:"class";s:0:"";s:7:"jscript";s:0:"";s:5:"style";s:0:"";s:10:"depends_on";s:0:"";s:10:"depend_url";s:0:"";s:10:"f_id_field";s:0:"";s:17:"list_field_values";s:0:"";s:12:"default_text";s:0:"";s:17:"delete_whitespace";s:0:"";s:12:"is_tokenizer";s:0:"";s:16:"get_table_fields";s:0:"";s:16:"first_is_default";s:0:"";}', 0, 261, 0),
(2174, 'field', 'a:14:{s:4:"name";s:9:"site_user";s:7:"caption";s:4:"User";s:8:"subtable";s:10:"site_users";s:15:"subtable_fields";a:3:{s:4:"user";s:4:"user";s:10:"first_name";s:10:"first_name";s:9:"last_name";s:9:"last_name";}s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:7:"in_form";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:14:"override_value";s:0:"";s:13:"link_id_field";s:0:"";}', 1, 262, 0),
(2175, 'field', 'a:18:{s:4:"name";s:9:"site_user";s:8:"subtable";s:10:"site_users";s:14:"header_caption";s:4:"User";s:6:"filter";s:1:"Y";s:8:"link_url";s:0:"";s:15:"subtable_fields";a:3:{s:4:"user";s:4:"user";s:10:"first_name";s:10:"first_name";s:9:"last_name";s:9:"last_name";}s:22:"subtable_fields_concat";s:0:"";s:5:"class";s:0:"";s:18:"aggregate_function";s:0:"";s:12:"thumb_amount";s:0:"";s:12:"media_amount";s:0:"";s:10:"media_size";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:8:"is_media";s:0:"";}', 1, 263, 0),
(2176, 'field', 'a:18:{s:4:"name";s:14:"history_action";s:8:"subtable";s:15:"history_actions";s:14:"header_caption";s:6:"Action";s:6:"filter";s:1:"Y";s:8:"link_url";s:0:"";s:15:"subtable_fields";a:1:{s:7:"name_en";s:7:"name_en";}s:22:"subtable_fields_concat";s:0:"";s:5:"class";s:0:"";s:18:"aggregate_function";s:0:"";s:12:"thumb_amount";s:0:"";s:12:"media_amount";s:0:"";s:10:"media_size";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:8:"is_media";s:0:"";}', 4, 263, 0),
(2177, 'field', 'a:18:{s:4:"name";s:15:"bitcoin_address";s:8:"subtable";s:0:"";s:14:"header_caption";s:9:"BTC Addr.";s:6:"filter";s:1:"Y";s:8:"link_url";s:0:"";s:15:"subtable_fields";s:0:"";s:22:"subtable_fields_concat";s:0:"";s:5:"class";s:0:"";s:18:"aggregate_function";s:0:"";s:12:"thumb_amount";s:0:"";s:12:"media_amount";s:0:"";s:10:"media_size";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:8:"is_media";s:0:"";}', 5, 263, 0),
(2178, 'field', 'a:18:{s:4:"name";s:10:"request_id";s:8:"subtable";s:0:"";s:14:"header_caption";s:7:"Req. ID";s:6:"filter";s:1:"Y";s:8:"link_url";s:8:"requests";s:15:"subtable_fields";s:0:"";s:22:"subtable_fields_concat";s:0:"";s:5:"class";s:0:"";s:18:"aggregate_function";s:0:"";s:12:"thumb_amount";s:0:"";s:12:"media_amount";s:0:"";s:10:"media_size";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:1:"1";s:16:"limit_is_curdate";s:0:"";s:8:"is_media";s:0:"";}', 6, 263, 0),
(2179, 'field', 'a:18:{s:4:"name";s:8:"order_id";s:8:"subtable";s:0:"";s:14:"header_caption";s:8:"Order ID";s:6:"filter";s:1:"Y";s:8:"link_url";s:9:"order-log";s:15:"subtable_fields";s:0:"";s:22:"subtable_fields_concat";s:0:"";s:5:"class";s:0:"";s:18:"aggregate_function";s:0:"";s:12:"thumb_amount";s:0:"";s:12:"media_amount";s:0:"";s:10:"media_size";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:8:"is_media";s:0:"";}', 10, 263, 0),
(2180, 'field', 'a:18:{s:4:"name";s:14:"request_amount";s:8:"subtable";s:8:"requests";s:14:"header_caption";s:11:"Req. Amount";s:6:"filter";s:1:"Y";s:8:"link_url";s:0:"";s:15:"subtable_fields";a:1:{s:6:"amount";s:6:"amount";}s:22:"subtable_fields_concat";s:0:"";s:5:"class";s:0:"";s:18:"aggregate_function";s:0:"";s:12:"thumb_amount";s:0:"";s:12:"media_amount";s:0:"";s:10:"media_size";s:0:"";s:10:"f_id_field";s:30:"history.request_id,requests.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:8:"is_media";s:0:"";}', 7, 263, 0),
(2181, 'field', 'a:18:{s:4:"name";s:15:"request_account";s:8:"subtable";s:8:"requests";s:14:"header_caption";s:9:"Bank Acc.";s:6:"filter";s:1:"Y";s:8:"link_url";s:0:"";s:15:"subtable_fields";a:1:{s:7:"account";s:7:"account";}s:22:"subtable_fields_concat";s:0:"";s:5:"class";s:0:"";s:18:"aggregate_function";s:0:"";s:12:"thumb_amount";s:0:"";s:12:"media_amount";s:0:"";s:10:"media_size";s:0:"";s:10:"f_id_field";s:30:"history.request_id,requests.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:8:"is_media";s:0:"";}', 9, 263, 0),
(2182, 'field', 'a:18:{s:4:"name";s:16:"request_currency";s:8:"subtable";s:10:"currencies";s:14:"header_caption";s:10:"Req. Curr.";s:6:"filter";s:1:"Y";s:8:"link_url";s:0:"";s:15:"subtable_fields";a:1:{s:8:"currency";s:8:"currency";}s:22:"subtable_fields_concat";s:0:"";s:5:"class";s:0:"";s:18:"aggregate_function";s:0:"";s:12:"thumb_amount";s:0:"";s:12:"media_amount";s:0:"";s:10:"media_size";s:0:"";s:10:"f_id_field";s:62:"history.request_id,requests.id,requests.currency,currencies.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:8:"is_media";s:0:"";}', 8, 263, 0),
(2183, 'field', 'a:18:{s:4:"name";s:9:"order_btc";s:8:"subtable";s:9:"order_log";s:14:"header_caption";s:8:"Ord. BTC";s:6:"filter";s:1:"Y";s:8:"link_url";s:0:"";s:15:"subtable_fields";a:1:{s:3:"btc";s:3:"btc";}s:22:"subtable_fields_concat";s:0:"";s:5:"class";s:0:"";s:18:"aggregate_function";s:0:"";s:12:"thumb_amount";s:0:"";s:12:"media_amount";s:0:"";s:10:"media_size";s:0:"";s:10:"f_id_field";s:29:"history.order_id,order_log.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:8:"is_media";s:0:"";}', 11, 263, 0),
(2184, 'field', 'a:18:{s:4:"name";s:14:"order_currency";s:8:"subtable";s:10:"currencies";s:14:"header_caption";s:10:"Ord. Curr.";s:6:"filter";s:1:"Y";s:8:"link_url";s:0:"";s:15:"subtable_fields";a:1:{s:8:"currency";s:8:"currency";}s:22:"subtable_fields_concat";s:0:"";s:5:"class";s:0:"";s:18:"aggregate_function";s:0:"";s:12:"thumb_amount";s:0:"";s:12:"media_amount";s:0:"";s:10:"media_size";s:0:"";s:10:"f_id_field";s:62:"history.order_id,order_log.id,order_log.currency,currencies.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:8:"is_media";s:0:"";}', 13, 263, 0),
(2185, 'field', 'a:18:{s:4:"name";s:11:"order_price";s:8:"subtable";s:9:"order_log";s:14:"header_caption";s:14:"Ord. BTC Price";s:6:"filter";s:1:"Y";s:8:"link_url";s:0:"";s:15:"subtable_fields";a:1:{s:9:"btc_price";s:9:"btc_price";}s:22:"subtable_fields_concat";s:0:"";s:5:"class";s:0:"";s:18:"aggregate_function";s:0:"";s:12:"thumb_amount";s:0:"";s:12:"media_amount";s:0:"";s:10:"media_size";s:0:"";s:10:"f_id_field";s:29:"history.order_id,order_log.id";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:8:"is_media";s:0:"";}', 12, 263, 0),
(2186, 'filterAutocomplete', 'a:6:{s:10:"field_name";s:17:"history.site_user";s:7:"caption";s:4:"User";s:13:"options_array";s:0:"";s:8:"subtable";s:10:"site_users";s:15:"subtable_fields";a:3:{s:4:"user";s:4:"user";s:10:"first_name";s:10:"first_name";s:9:"last_name";s:9:"last_name";}s:5:"class";s:0:"";}', 0, 263, 0),
(2187, 'makeTab', 'a:7:{s:4:"name";s:7:"History";s:3:"url";s:7:"history";s:9:"variables";s:0:"";s:10:"identifier";s:0:"";s:6:"is_tab";s:0:"";s:14:"inset_id_field";s:9:"site_user";s:8:"selected";s:0:"";}', 68, 264, 0),
(2188, 'makeTab', 'a:7:{s:4:"name";s:7:"History";s:3:"url";s:7:"history";s:9:"variables";s:0:"";s:10:"identifier";s:0:"";s:6:"is_tab";s:0:"";s:14:"inset_id_field";s:9:"site_user";s:8:"selected";s:0:"";}', 0, 265, 0);
INSERT INTO `lang` (`id`, `key`, `esp`, `eng`, `order`, `p_id`) VALUES
(332, 'history', 'Historial', 'History', '', 0),
(333, 'history-ip', 'Dirección IP', 'IP Address', '', 332);
INSERT INTO `lang` (`id`, `key`, `esp`, `eng`, `order`, `p_id`) VALUES
(334, 'buy-errors-outbid-self', 'No se le permite comprar a mayor precio de lo que está vendiendo, o vender a menor precio de lo que está comprando.', 'You cannot buy higher than you are selling, or sell lower than you are buying.', '', 17);