prosody: tools/jabberd14sql2prosody.lua@0598d822614f (annotated)

5109 12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	1	#!/usr/bin/env lua
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	2
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	3
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	4	do
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	5
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	6
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	7	local _parse_sql_actions = { [0] =
5776 bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	8	0, 1, 0, 1, 1, 2, 0, 2, 2, 0, 9, 2, 0, 10, 2, 0, 11, 2, 0, 13,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	9	2, 1, 2, 2, 1, 6, 3, 0, 3, 4, 3, 0, 3, 5, 3, 0, 3, 7, 3, 0,
5109 12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	10	3, 8, 3, 0, 3, 12, 4, 0, 2, 3, 7, 4, 0, 3, 8, 11
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	11	};
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	12
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	13	local _parse_sql_trans_keys = { [0] =
5776 bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	14	0, 0, 45, 45, 10, 10, 42, 42, 10, 42, 10, 47, 82, 82,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	15	69, 69, 65, 65, 84, 84, 69, 69, 32, 32, 68, 84, 65,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	16	65, 84, 84, 65, 65, 66, 66, 65, 65, 83, 83, 69, 69,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	17	9, 47, 9, 96, 45, 45, 10, 10, 42, 42, 10, 42, 10, 47,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	18	10, 96, 10, 96, 9, 47, 9, 59, 45, 45, 10, 10, 42,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	19	42, 10, 42, 10, 47, 65, 65, 66, 66, 76, 76, 69, 69,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	20	32, 32, 73, 96, 70, 70, 32, 32, 78, 78, 79, 79, 84, 84,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	21	32, 32, 69, 69, 88, 88, 73, 73, 83, 83, 84, 84, 83,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	22	83, 32, 32, 96, 96, 10, 96, 10, 96, 32, 32, 40, 40,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	23	10, 10, 32, 41, 32, 32, 75, 96, 69, 69, 89, 89, 32, 32,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	24	96, 96, 10, 96, 10, 96, 10, 10, 82, 82, 73, 73, 77,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	25	77, 65, 65, 82, 82, 89, 89, 32, 32, 75, 75, 69, 69,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	26	89, 89, 32, 32, 78, 78, 73, 73, 81, 81, 85, 85, 69, 69,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	27	32, 32, 75, 75, 10, 96, 10, 96, 10, 10, 10, 59, 10,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	28	59, 82, 82, 79, 79, 80, 80, 32, 32, 84, 84, 65, 65,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	29	66, 66, 76, 76, 69, 69, 32, 32, 73, 73, 70, 70, 32, 32,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	30	69, 69, 88, 88, 73, 73, 83, 83, 84, 84, 83, 83, 32,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	31	32, 96, 96, 10, 96, 10, 96, 59, 59, 78, 78, 83, 83,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	32	69, 69, 82, 82, 84, 84, 32, 32, 73, 73, 78, 78, 84, 84,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	33	79, 79, 32, 32, 96, 96, 10, 96, 10, 96, 32, 32, 40,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	34	86, 10, 41, 32, 32, 86, 86, 65, 65, 76, 76, 85, 85,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	35	69, 69, 83, 83, 32, 32, 40, 40, 39, 78, 10, 92, 10, 92,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	36	41, 44, 44, 59, 32, 78, 48, 57, 41, 57, 48, 57, 41,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	37	57, 85, 85, 76, 76, 76, 76, 34, 116, 79, 79, 67, 67,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	38	75, 75, 32, 32, 84, 84, 65, 65, 66, 66, 76, 76, 69, 69,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	39	83, 83, 32, 32, 96, 96, 10, 96, 10, 96, 32, 32, 87,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	40	87, 82, 82, 73, 73, 84, 84, 69, 69, 69, 69, 84, 84,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	41	32, 32, 10, 59, 10, 59, 78, 83, 76, 76, 79, 79, 67, 67,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	42	75, 75, 32, 32, 84, 84, 65, 65, 66, 66, 76, 76, 69,
5109 12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	43	69, 83, 83, 69, 69, 9, 85, 0
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	44	};
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	45
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	46	local _parse_sql_key_spans = { [0] =
5776 bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	47	0, 1, 1, 1, 33, 38, 1, 1, 1, 1, 1, 1, 17, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	48	39, 88, 1, 1, 1, 33, 38, 87, 87, 39, 51, 1, 1, 1, 33, 38, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	49	1, 24, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 87, 87, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	50	1, 10, 1, 22, 1, 1, 1, 1, 87, 87, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	51	1, 1, 1, 1, 1, 1, 1, 1, 1, 87, 87, 1, 50, 50, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	52	1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 87, 87, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	53	1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 87, 87, 1, 47, 32, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	54	1, 1, 1, 1, 40, 83, 83, 4, 16, 47, 10, 17, 10, 17, 1, 1, 1, 83, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	55	1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 87, 87, 1, 1, 1, 1, 1, 1, 1, 1,
5109 12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	56	1, 50, 50, 6, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 77
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	57	};
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	58
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	59	local _parse_sql_index_offsets = { [0] =
5776 bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	60	0, 0, 2, 4, 6, 40, 79, 81, 83, 85, 87, 89, 91, 109, 111, 113, 115, 117, 119, 121,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	61	123, 163, 252, 254, 256, 258, 292, 331, 419, 507, 547, 599, 601, 603, 605, 639, 678, 680, 682, 684,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	62	686, 688, 713, 715, 717, 719, 721, 723, 725, 727, 729, 731, 733, 735, 737, 739, 741, 829, 917, 919,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	63	921, 923, 934, 936, 959, 961, 963, 965, 967, 1055, 1143, 1145, 1147, 1149, 1151, 1153, 1155, 1157, 1159, 1161,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	64	1163, 1165, 1167, 1169, 1171, 1173, 1175, 1177, 1179, 1181, 1269, 1357, 1359, 1410, 1461, 1463, 1465, 1467, 1469, 1471,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	65	1473, 1475, 1477, 1479, 1481, 1483, 1485, 1487, 1489, 1491, 1493, 1495, 1497, 1499, 1501, 1503, 1591, 1679, 1681, 1683,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	66	1685, 1687, 1689, 1691, 1693, 1695, 1697, 1699, 1701, 1703, 1705, 1793, 1881, 1883, 1931, 1964, 1966, 1968, 1970, 1972,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	67	1974, 1976, 1978, 1980, 1982, 2023, 2107, 2191, 2196, 2213, 2261, 2272, 2290, 2301, 2319, 2321, 2323, 2325, 2409, 2411,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	68	2413, 2415, 2417, 2419, 2421, 2423, 2425, 2427, 2429, 2431, 2433, 2521, 2609, 2611, 2613, 2615, 2617, 2619, 2621, 2623,
5109 12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	69	2625, 2627, 2678, 2729, 2736, 2738, 2740, 2742, 2744, 2746, 2748, 2750, 2752, 2754, 2756, 2758, 2760
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	70	};
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	71
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	72	local _parse_sql_indicies = { [0] =
5776 bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	73	0, 1, 2, 0, 3, 1, 4, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	74	3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 5, 3,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	75	4, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	76	3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 5, 3, 3, 3, 3, 6, 3, 7,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	77	1, 8, 1, 9, 1, 10, 1, 11, 1, 12, 1, 13, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	78	1, 1, 1, 1, 1, 1, 1, 14, 1, 15, 1, 16, 1, 17, 1, 18, 1, 19, 1, 20,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	79	1, 21, 1, 22, 23, 22, 22, 22, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	80	1, 1, 1, 1, 1, 1, 22, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 24,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	81	1, 25, 1, 22, 23, 22, 22, 22, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	82	1, 1, 1, 1, 1, 1, 22, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 24,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	83	1, 25, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	84	1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	85	1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 26, 1, 27, 1, 23, 27, 28, 1, 29, 28,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	86	28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	87	28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 30, 28, 29, 28, 28, 28, 28, 28, 28, 28,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	88	28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	89	28, 28, 28, 28, 30, 28, 28, 28, 28, 22, 28, 32, 31, 31, 31, 31, 31, 31, 31, 31,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	90	31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	91	31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	92	31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	93	31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 1, 31, 32,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	94	31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	95	31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	96	31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	97	31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	98	31, 31, 31, 31, 31, 33, 31, 34, 35, 34, 34, 34, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	99	1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 34, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	100	1, 1, 1, 36, 1, 37, 1, 34, 35, 34, 34, 34, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	101	1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 34, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	102	1, 1, 1, 36, 1, 37, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 6, 1, 38,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	103	1, 35, 38, 39, 1, 40, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	104	39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 41, 39, 40,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	105	39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	106	39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 41, 39, 39, 39, 39, 34, 39, 42, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	107	43, 1, 44, 1, 45, 1, 46, 1, 47, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	108	1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 48, 1, 49, 1, 50, 1, 51, 1, 52,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	109	1, 53, 1, 54, 1, 55, 1, 56, 1, 57, 1, 58, 1, 59, 1, 60, 1, 61, 1, 48,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	110	1, 63, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	111	62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	112	62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	113	62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	114	62, 62, 62, 62, 62, 62, 62, 1, 62, 65, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	115	64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	116	64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	117	64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	118	64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 66, 64, 67, 1, 68,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	119	1, 69, 1, 70, 1, 1, 1, 1, 1, 1, 1, 1, 71, 1, 72, 1, 73, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	120	1, 74, 1, 1, 1, 1, 75, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 76, 1, 77,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	121	1, 78, 1, 79, 1, 80, 1, 82, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	122	81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	123	81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	124	81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	125	81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 1, 81, 82, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	126	81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	127	81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	128	81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	129	81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	130	81, 83, 81, 69, 83, 84, 1, 85, 1, 86, 1, 87, 1, 88, 1, 89, 1, 90, 1, 91,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	131	1, 92, 1, 93, 1, 83, 1, 94, 1, 95, 1, 96, 1, 97, 1, 98, 1, 99, 1, 73,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	132	1, 101, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	133	100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	134	100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	135	100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	136	100, 100, 100, 100, 100, 100, 100, 1, 100, 103, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	137	102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	138	102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	139	102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	140	102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 104, 102, 105, 83, 106,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	141	71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	142	71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	143	71, 71, 71, 71, 71, 71, 71, 71, 107, 71, 108, 71, 71, 71, 71, 71, 71, 71, 71, 71,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	144	71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	145	71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 107,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	146	71, 109, 1, 110, 1, 111, 1, 112, 1, 113, 1, 114, 1, 115, 1, 116, 1, 117, 1, 118,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	147	1, 119, 1, 120, 1, 121, 1, 122, 1, 123, 1, 124, 1, 125, 1, 126, 1, 127, 1, 128,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	148	1, 129, 1, 131, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	149	130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	150	130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	151	130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	152	130, 130, 130, 130, 130, 130, 130, 130, 130, 1, 130, 131, 130, 130, 130, 130, 130, 130, 130, 130,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	153	130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	154	130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	155	130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	156	130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 132, 130, 6,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	157	1, 133, 1, 134, 1, 135, 1, 136, 1, 137, 1, 138, 1, 139, 1, 140, 1, 141, 1, 142,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	158	1, 143, 1, 144, 1, 146, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	159	145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	160	145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	161	145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	162	145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 1, 145, 148, 147, 147, 147, 147, 147, 147,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	163	147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	164	147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	165	147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	166	147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 149,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	167	147, 150, 1, 151, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	168	1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	169	1, 1, 1, 1, 1, 1, 1, 1, 1, 152, 1, 153, 151, 151, 151, 151, 151, 151, 151, 151,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	170	151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	171	151, 151, 154, 151, 155, 1, 152, 1, 156, 1, 157, 1, 158, 1, 159, 1, 160, 1, 161, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	172	162, 1, 163, 1, 1, 1, 1, 1, 164, 1, 1, 165, 165, 165, 165, 165, 165, 165, 165, 165,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	173	165, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	174	1, 166, 1, 168, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	175	167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 169, 167, 167, 167, 167, 167, 167, 167,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	176	167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	177	167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	178	167, 167, 167, 167, 167, 170, 167, 172, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	179	171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 173, 171, 171, 171,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	180	171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	181	171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	182	171, 171, 171, 171, 171, 171, 171, 171, 171, 174, 171, 175, 1, 1, 176, 1, 161, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	183	1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 177, 1, 178, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	184	163, 1, 1, 1, 1, 1, 164, 1, 1, 165, 165, 165, 165, 165, 165, 165, 165, 165, 165, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	185	1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 166,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	186	1, 179, 179, 179, 179, 179, 179, 179, 179, 179, 179, 1, 180, 1, 1, 181, 1, 182, 1, 179,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	187	179, 179, 179, 179, 179, 179, 179, 179, 179, 1, 183, 183, 183, 183, 183, 183, 183, 183, 183, 183,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	188	1, 180, 1, 1, 181, 1, 1, 1, 183, 183, 183, 183, 183, 183, 183, 183, 183, 183, 1, 184,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	189	1, 185, 1, 186, 1, 171, 1, 1, 171, 1, 171, 1, 1, 1, 1, 1, 1, 1, 1, 171,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	190	1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	191	1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	192	1, 171, 1, 171, 1, 1, 171, 1, 1, 171, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	193	1, 171, 1, 1, 1, 171, 1, 171, 1, 187, 1, 188, 1, 189, 1, 190, 1, 191, 1, 192,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	194	1, 193, 1, 194, 1, 195, 1, 196, 1, 197, 1, 198, 1, 200, 199, 199, 199, 199, 199, 199,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	195	199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	196	199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	197	199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	198	199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	199	199, 200, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	200	199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	201	199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	202	199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	203	199, 199, 199, 199, 199, 199, 199, 201, 199, 202, 1, 203, 1, 204, 1, 205, 1, 206, 1, 132,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	204	1, 207, 1, 208, 1, 209, 1, 210, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	205	209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	206	209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 211, 209, 2, 209,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	207	209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	208	209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	209	209, 209, 209, 209, 209, 209, 209, 211, 209, 212, 1, 1, 1, 1, 213, 1, 214, 1, 215, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	210	216, 1, 217, 1, 218, 1, 219, 1, 220, 1, 221, 1, 222, 1, 223, 1, 132, 1, 127, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	211	6, 2, 6, 6, 6, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	212	1, 1, 1, 6, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 224, 1, 225, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	213	1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 6, 1, 1, 1, 1, 1, 1, 1, 226, 227,
5109 12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	214	1, 1, 1, 1, 228, 1, 1, 229, 1, 1, 1, 1, 1, 1, 230, 1, 231, 1, 0
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	215	};
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	216
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	217	local _parse_sql_trans_targs = { [0] =
5776 bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	218	2, 0, 196, 4, 4, 5, 196, 7, 8, 9, 10, 11, 12, 13, 36, 14, 15, 16, 17, 18,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	219	19, 20, 21, 21, 22, 24, 27, 23, 25, 25, 26, 28, 28, 29, 30, 30, 31, 33, 32, 34,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	220	34, 35, 37, 38, 39, 40, 41, 42, 56, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	221	54, 55, 57, 57, 57, 57, 58, 59, 60, 61, 62, 92, 63, 64, 71, 82, 89, 65, 66, 67,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	222	68, 69, 69, 70, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	223	90, 90, 90, 90, 91, 70, 92, 93, 196, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	224	106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 116, 117, 119, 120, 121, 122, 123, 124, 125,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	225	126, 127, 128, 129, 130, 131, 131, 131, 131, 132, 133, 134, 137, 134, 135, 136, 138, 139, 140, 141,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	226	142, 143, 144, 145, 150, 151, 154, 146, 146, 147, 157, 146, 146, 147, 157, 148, 149, 196, 144, 151,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	227	148, 149, 152, 153, 155, 156, 147, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	228	171, 172, 173, 174, 175, 176, 177, 179, 180, 181, 181, 182, 184, 195, 185, 186, 187, 188, 189, 190,
5109 12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	229	191, 192, 193, 194, 1, 3, 6, 94, 118, 158, 178, 183
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	230	};
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	231
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	232	local _parse_sql_trans_actions = { [0] =
5776 bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	233	1, 0, 3, 1, 3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	234	1, 1, 1, 3, 1, 1, 1, 1, 1, 3, 1, 1, 3, 1, 1, 3, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	235	3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	236	1, 1, 5, 20, 1, 3, 30, 1, 1, 3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	237	1, 1, 3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	238	5, 20, 1, 3, 26, 3, 3, 1, 23, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	239	1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	240	1, 1, 1, 1, 1, 5, 20, 1, 3, 42, 1, 1, 1, 3, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	241	1, 1, 11, 1, 5, 5, 1, 5, 20, 46, 5, 1, 3, 34, 1, 14, 1, 17, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	242	51, 38, 1, 1, 1, 1, 8, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	243	3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 1, 1, 1, 1, 1, 1, 1, 1, 1,
5109 12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	244	1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	245	};
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	246
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	247	local parse_sql_start = 196;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	248	local parse_sql_first_final = 196;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	249	local parse_sql_error = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	250
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	251	local parse_sql_en_main = 196;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	252
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	253
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	254
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	255
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	256	local _sql_unescapes = setmetatable({
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	257	["\\0"] = "\0";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	258	["\\'"] = "'";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	259	["\\\""] = "\"";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	260	["\\b"] = "\b";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	261	["\\n"] = "\n";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	262	["\\r"] = "\r";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	263	["\\t"] = "\t";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	264	["\\Z"] = "\26";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	265	["\\\\"] = "\\";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	266	["\\%"] = "%";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	267	["\\_"] = "_";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	268	},{ __index = function(t, s) assert(false, "Unknown escape sequences: "..s); end });
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	269
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	270	function parse_sql(data, h)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	271	local p = 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	272	local pe = #data + 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	273	local cs;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	274
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	275	local pos_char, pos_line = 1, 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	276
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	277	local mark, token;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	278	local table_name, columns, value_lists, value_list, value_count;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	279
5776 bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	280
5109 12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	281	cs = parse_sql_start;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	282
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	283	-- ragel flat exec
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	284
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	285	local testEof = false;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	286	local _slen = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	287	local _trans = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	288	local _keys = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	289	local _inds = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	290	local _acts = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	291	local _nacts = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	292	local _tempval = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	293	local _goto_level = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	294	local _resume = 10;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	295	local _eof_trans = 15;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	296	local _again = 20;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	297	local _test_eof = 30;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	298	local _out = 40;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	299
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	300	while true do -- goto loop
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	301	local _continue = false;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	302	repeat
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	303	local _trigger_goto = false;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	304	if _goto_level <= 0 then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	305
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	306	-- noEnd
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	307	if p == pe then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	308	_goto_level = _test_eof;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	309	_continue = true; break;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	310	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	311
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	312
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	313	-- errState != 0
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	314	if cs == 0 then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	315	_goto_level = _out;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	316	_continue = true; break;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	317	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	318	end -- _goto_level <= 0
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	319
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	320	if _goto_level <= _resume then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	321	_keys = cs * 2; -- LOCATE_TRANS
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	322	_inds = _parse_sql_index_offsets[cs];
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	323	_slen = _parse_sql_key_spans[cs];
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	324
5776 bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	325	if _slen > 0 and
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	326	_parse_sql_trans_keys[_keys] <= data:byte(p) and
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	327	data:byte(p) <= _parse_sql_trans_keys[_keys + 1] then
bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	328	_trans = _parse_sql_indicies[ _inds + data:byte(p) - _parse_sql_trans_keys[_keys] ];
5109 12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	329	else _trans =_parse_sql_indicies[ _inds + _slen ]; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	330
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	331	cs = _parse_sql_trans_targs[_trans];
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	332
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	333	if _parse_sql_trans_actions[_trans] ~= 0 then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	334	_acts = _parse_sql_trans_actions[_trans];
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	335	_nacts = _parse_sql_actions[_acts];
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	336	_acts = _acts + 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	337
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	338	while _nacts > 0 do
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	339	_nacts = _nacts - 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	340	_acts = _acts + 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	341	_tempval = _parse_sql_actions[_acts - 1];
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	342
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	343	-- start action switch
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	344	if _tempval == 0 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	345	-- line 34 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	346	pos_char = pos_char + 1; -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	347	elseif _tempval == 1 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	348	-- line 35 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	349	pos_line = pos_line + 1; pos_char = 1; -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	350	elseif _tempval == 2 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	351	-- line 38 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	352	mark = p; -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	353	elseif _tempval == 3 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	354	-- line 39 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	355	token = data:sub(mark, p-1); -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	356	elseif _tempval == 4 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	357	-- line 52 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	358	table.insert(columns, token); columns[#columns] = token; -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	359	elseif _tempval == 5 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	360	-- line 58 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	361	table_name,columns = token,{}; -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	362	elseif _tempval == 6 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	363	-- line 59 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	364	h.create(table_name, columns); -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	365	elseif _tempval == 7 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	366	-- line 65 "sql.rl" -- end of line directive
5776 bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	367
5109 12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	368	value_count = value_count + 1; value_list[value_count] = token:gsub("\\.", _sql_unescapes);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	369	-- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	370	elseif _tempval == 8 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	371	-- line 68 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	372	value_count = value_count + 1; value_list[value_count] = tonumber(token); -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	373	elseif _tempval == 9 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	374	-- line 69 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	375	value_count = value_count + 1; -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	376	elseif _tempval == 10 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	377	-- line 71 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	378	value_list,value_count = {},0; -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	379	elseif _tempval == 11 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	380	-- line 71 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	381	table.insert(value_lists, value_list); -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	382	elseif _tempval == 12 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	383	-- line 74 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	384	table_name,value_lists = token,{}; -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	385	elseif _tempval == 13 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	386	-- line 75 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	387	h.insert(table_name, value_lists); -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	388	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	389	-- line 355 "sql.lua" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	390	-- end action switch
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	391	end -- while _nacts
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	392	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	393
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	394	if _trigger_goto then _continue = true; break; end
5776 bd0ff8ae98a8 Remove all trailing whitespace Florian Zeitz <florob@babelmonkeys.de> parents: 5696 diff changeset	395	end -- endif
5109 12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	396
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	397	if _goto_level <= _again then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	398	if cs == 0 then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	399	_goto_level = _out;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	400	_continue = true; break;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	401	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	402	p = p + 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	403	if p ~= pe then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	404	_goto_level = _resume;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	405	_continue = true; break;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	406	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	407	end -- _goto_level <= _again
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	408
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	409	if _goto_level <= _test_eof then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	410	end -- _goto_level <= _test_eof
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	411
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	412	if _goto_level <= _out then break; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	413	_continue = true;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	414	until true;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	415	if not _continue then break; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	416	end -- endif _goto_level <= out
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	417
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	418	-- end of execute block
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	419
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	420
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	421	if cs < parse_sql_first_final then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	422	print("parse_sql: there was an error, line "..pos_line.." column "..pos_char);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	423	else
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	424	print("Success. EOF at line "..pos_line.." column "..pos_char)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	425	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	426	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	427
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	428	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	429
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	430	-- import modules
6147 852bd69ba148 tools/jabberd14sql2prosody: Fix package.path (thanks daurnimator) Kim Alvefur <zash@zash.se> parents: 5696 diff changeset	431	package.path = package.path..";../?.lua;";
5696 9fba74a28e0c package{,c}path fixes for migration tools Vadim Misbakh-Soloviov <mva@mva.name> parents: 5216 diff changeset	432
9fba74a28e0c package{,c}path fixes for migration tools Vadim Misbakh-Soloviov <mva@mva.name> parents: 5216 diff changeset	433	local my_name = arg[0];
9fba74a28e0c package{,c}path fixes for migration tools Vadim Misbakh-Soloviov <mva@mva.name> parents: 5216 diff changeset	434	if my_name:match("[/\\]") then
9fba74a28e0c package{,c}path fixes for migration tools Vadim Misbakh-Soloviov <mva@mva.name> parents: 5216 diff changeset	435	package.path = package.path..";"..my_name:gsub("[^/\\]+$", "../?.lua");
9fba74a28e0c package{,c}path fixes for migration tools Vadim Misbakh-Soloviov <mva@mva.name> parents: 5216 diff changeset	436	package.cpath = package.cpath..";"..my_name:gsub("[^/\\]+$", "../?.so");
9fba74a28e0c package{,c}path fixes for migration tools Vadim Misbakh-Soloviov <mva@mva.name> parents: 5216 diff changeset	437	end
9fba74a28e0c package{,c}path fixes for migration tools Vadim Misbakh-Soloviov <mva@mva.name> parents: 5216 diff changeset	438
5109 12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	439
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	440	-- ugly workaround for getting datamanager to work outside of prosody :(
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	441	prosody = { };
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	442	prosody.platform = "unknown";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	443	if os.getenv("WINDIR") then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	444	prosody.platform = "windows";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	445	elseif package.config:sub(1,1) == "/" then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	446	prosody.platform = "_posix";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	447	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	448	package.loaded["util.logger"] = {init = function() return function() end; end}
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	449
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	450	local dm = require "util.datamanager";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	451	dm.set_data_path("data");
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	452
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	453	local datetime = require "util.datetime";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	454
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	455	local st = require "util.stanza";
5216 63db6f281708 tools/jabberd14sql2prosody: Use util.xml. Waqas Hussain <waqas20@gmail.com> parents: 5109 diff changeset	456	local parse_xml = require "util.xml".parse;
5109 12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	457
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	458	function store_password(username, host, password)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	459	-- create or update account for username@host
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	460	local ret, err = dm.store(username, host, "accounts", {password = password});
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	461	print("["..(err or "success").."] stored account: "..username.."@"..host.." = "..password);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	462	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	463
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	464	function store_vcard(username, host, stanza)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	465	-- create or update vCard for username@host
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	466	local ret, err = dm.store(username, host, "vcard", st.preserialize(stanza));
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	467	print("["..(err or "success").."] stored vCard: "..username.."@"..host);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	468	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	469
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	470	function store_roster(username, host, roster_items)
11685 e270d22b11d9 tools/jabberd14sql2prosody: Tweak wording in comments Kim Alvefur <zash@zash.se> parents: 6149 diff changeset	471	-- fetch current roster-table for username@host if they already have one
5109 12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	472	local roster = dm.load(username, host, "roster") or {};
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	473	-- merge imported roster-items with loaded roster
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	474	for item_tag in roster_items:childtags() do
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	475	-- jid for this roster-item
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	476	local item_jid = item_tag.attr.jid
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	477	-- validate item stanzas
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	478	if (item_tag.name == "item") and (item_jid ~= "") then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	479	-- prepare roster item
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	480	-- TODO: is the subscription attribute optional?
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	481	local item = {subscription = item_tag.attr.subscription, groups = {}};
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	482	-- optional: give roster item a real name
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	483	if item_tag.attr.name then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	484	item.name = item_tag.attr.name;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	485	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	486	-- optional: iterate over group stanzas inside item stanza
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	487	for group_tag in item_tag:childtags() do
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	488	local group_name = group_tag:get_text();
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	489	if (group_tag.name == "group") and (group_name ~= "") then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	490	item.groups[group_name] = true;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	491	else
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	492	print("[error] invalid group stanza: "..group_tag:pretty_print());
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	493	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	494	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	495	-- store item in roster
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	496	roster[item_jid] = item;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	497	print("[success] roster entry: " ..username.."@"..host.." - "..item_jid);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	498	else
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	499	print("[error] invalid roster stanza: " ..item_tag:pretty_print());
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	500	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	501
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	502	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	503	-- store merged roster-table
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	504	local ret, err = dm.store(username, host, "roster", roster);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	505	print("["..(err or "success").."] stored roster: " ..username.."@"..host);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	506	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	507
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	508	function store_subscription_request(username, host, presence_stanza)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	509	local from_bare = presence_stanza.attr.from;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	510
11685 e270d22b11d9 tools/jabberd14sql2prosody: Tweak wording in comments Kim Alvefur <zash@zash.se> parents: 6149 diff changeset	511	-- fetch current roster-table for username@host if they already have one
5109 12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	512	local roster = dm.load(username, host, "roster") or {};
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	513
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	514	local item = roster[from_bare];
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	515	if item and (item.subscription == "from" or item.subscription == "both") then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	516	return; -- already subscribed, do nothing
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	517	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	518
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	519	-- add to table of pending subscriptions
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	520	if not roster.pending then roster.pending = {}; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	521	roster.pending[from_bare] = true;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	522
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	523	-- store updated roster-table
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	524	local ret, err = dm.store(username, host, "roster", roster);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	525	print("["..(err or "success").."] stored subscription request: " ..username.."@"..host.." - "..from_bare);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	526	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	527
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	528	local os_date = os.date;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	529	local os_time = os.time;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	530	local os_difftime = os.difftime;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	531	function datetime_parse(s)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	532	if s then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	533	local year, month, day, hour, min, sec, tzd;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	534	year, month, day, hour, min, sec, tzd = s:match("^(%d%d%d%d)%-?(%d%d)%-?(%d%d)T(%d%d):(%d%d):(%d%d)%.?%d([Z+%-]?.)$");
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	535	if year then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	536	local time_offset = os_difftime(os_time(os_date("t")), os_time(os_date("!t"))); -- to deal with local timezone
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	537	local tzd_offset = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	538	if tzd ~= "" and tzd ~= "Z" then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	539	local sign, h, m = tzd:match("([+%-])(%d%d):?(%d*)");
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	540	if not sign then return; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	541	if #m ~= 2 then m = "0"; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	542	h, m = tonumber(h), tonumber(m);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	543	tzd_offset = h * 60 * 60 + m * 60;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	544	if sign == "-" then tzd_offset = -tzd_offset; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	545	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	546	sec = (sec + time_offset) - tzd_offset;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	547	return os_time({year=year, month=month, day=day, hour=hour, min=min, sec=sec, isdst=false});
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	548	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	549	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	550	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	551
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	552	function store_offline_messages(username, host, stanza)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	553	-- TODO: maybe use list_load(), append and list_store() instead
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	554	-- of constantly reopening the file with list_append()?
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	555	--for ch in offline_messages:childtags() do
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	556	--print("message :"..ch:pretty_print());
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	557	stanza.attr.node = nil;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	558
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	559	local stamp = stanza:get_child("x", "jabber:x:delay");
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	560	if not stamp or not stamp.attr.stamp then print(2) return; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	561
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	562	for i=1,#stanza do if stanza[i] == stamp then table.remove(stanza, i); break; end end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	563	for i=1,#stanza.tags do if stanza.tags[i] == stamp then table.remove(stanza.tags, i); break; end end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	564
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	565	local parsed_stamp = datetime_parse(stamp.attr.stamp);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	566	if not parsed_stamp then print(1, stamp.attr.stamp) return; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	567
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	568	stanza.attr.stamp, stanza.attr.stamp_legacy = datetime.datetime(parsed_stamp), datetime.legacy(parsed_stamp);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	569	local ret, err = dm.list_append(username, host, "offline", st.preserialize(stanza));
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	570	print("["..(err or "success").."] stored offline message: " ..username.."@"..host.." - "..stanza.attr.from);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	571	--end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	572	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	573
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	574	-- load data
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	575	local arg = ...;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	576	local help = "/? -? ? /h -h /help -help --help";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	577	if not arg or help:find(arg, 1, true) then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	578	print([[XEP-227 importer for Prosody
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	579
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	580	Usage: jabberd14sql2prosody.lua filename.sql
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	581	]]);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	582	os.exit(1);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	583	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	584	local f = io.open(arg);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	585	local s = f:read("*a");
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	586	f:close();
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	587
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	588	local table_count = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	589	local insert_count = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	590	local row_count = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	591	-- parse
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	592	parse_sql(s, {
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	593	create = function(table_name, columns)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	594	--[[print(table_name);]]
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	595	table_count = table_count + 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	596	end;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	597	insert = function(table_name, value_lists)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	598	--[[print(table_name, #value_lists);]]
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	599	insert_count = insert_count + 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	600	row_count = row_count + #value_lists;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	601
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	602	for _,value_list in ipairs(value_lists) do
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	603	if table_name == "users" then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	604	local user, realm, password = unpack(value_list);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	605	store_password(user, realm, password);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	606	elseif table_name == "roster" then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	607	local user, realm, xml = unpack(value_list);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	608	local stanza,err = parse_xml(xml);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	609	if stanza then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	610	store_roster(user, realm, stanza);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	611	else
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	612	print("[error] roster: XML parsing failed for "..user.."@"..realm..": "..err);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	613	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	614	elseif table_name == "vcard" then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	615	local user, realm, name, email, nickname, birthday, photo, xml = unpack(value_list);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	616	if xml then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	617	local stanza,err = parse_xml(xml);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	618	if stanza then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	619	store_vcard(user, realm, stanza);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	620	else
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	621	print("[error] vcard: XML parsing failed for "..user.."@"..realm..": "..err);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	622	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	623	else
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	624	--print("[warn] vcard: NULL vCard for "..user.."@"..realm..": "..err);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	625	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	626	elseif table_name == "storedsubscriptionrequests" then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	627	local user, realm, fromjid, xml = unpack(value_list);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	628	local stanza,err = parse_xml(xml);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	629	if stanza then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	630	store_subscription_request(user, realm, stanza);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	631	else
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	632	print("[error] storedsubscriptionrequests: XML parsing failed for "..user.."@"..realm..": "..err);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	633	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	634	elseif table_name == "messages" then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	635	--local user, realm, node, correspondent, type, storetime, delivertime, subject, body, xml = unpack(value_list);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	636	local user, realm, type, xml = value_list[1], value_list[2], value_list[5], value_list[10];
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	637	if type == "offline" and xml ~= "" then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	638	local stanza,err = parse_xml(xml);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	639	if stanza then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	640	store_offline_messages(user, realm, stanza);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	641	else
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	642	print("[error] offline messages: XML parsing failed for "..user.."@"..realm..": "..err);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	643	print(unpack(value_list));
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	644	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	645	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	646	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	647	end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	648	end;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	649	});
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	650
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	651	print("table_count", table_count);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	652	print("insert_count", insert_count);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	653	print("row_count", row_count);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing). Waqas Hussain <waqas20@gmail.com> parents: diff changeset	654

author	Matthew Wild <mwild1@gmail.com>
	Mon, 20 Feb 2023 18:10:15 +0000
branch	0.12
changeset 12898	0598d822614f
parent 11685	e270d22b11d9
child 13146	879a6a33c21b
permissions	-rw-r--r--