prosody
12fb961c8f27
tools/jabberd14sql2prosody.lua

Find changesets by keywords by author, files, the commit message, revision number or hash, or revset expression.

Software / code / prosody

Annotate

tools/jabberd14sql2prosody.lua @ 5109:12fb961c8f27

tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
author Waqas Hussain <waqas20@gmail.com>
date Tue, 28 Aug 2012 05:52:30 +0500
child 5216:63db6f281708
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
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] =
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
8 0, 1, 0, 1, 1, 2, 0, 2, 2, 0, 9, 2, 0, 10, 2, 0, 11, 2, 0, 13,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
9 2, 1, 2, 2, 1, 6, 3, 0, 3, 4, 3, 0, 3, 5, 3, 0, 3, 7, 3, 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
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] =
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
14 0, 0, 45, 45, 10, 10, 42, 42, 10, 42, 10, 47, 82, 82,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
15 69, 69, 65, 65, 84, 84, 69, 69, 32, 32, 68, 84, 65,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
16 65, 84, 84, 65, 65, 66, 66, 65, 65, 83, 83, 69, 69,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
17 9, 47, 9, 96, 45, 45, 10, 10, 42, 42, 10, 42, 10, 47,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
18 10, 96, 10, 96, 9, 47, 9, 59, 45, 45, 10, 10, 42,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
19 42, 10, 42, 10, 47, 65, 65, 66, 66, 76, 76, 69, 69,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
20 32, 32, 73, 96, 70, 70, 32, 32, 78, 78, 79, 79, 84, 84,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
21 32, 32, 69, 69, 88, 88, 73, 73, 83, 83, 84, 84, 83,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
22 83, 32, 32, 96, 96, 10, 96, 10, 96, 32, 32, 40, 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
23 10, 10, 32, 41, 32, 32, 75, 96, 69, 69, 89, 89, 32, 32,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
24 96, 96, 10, 96, 10, 96, 10, 10, 82, 82, 73, 73, 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
25 77, 65, 65, 82, 82, 89, 89, 32, 32, 75, 75, 69, 69,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
26 89, 89, 32, 32, 78, 78, 73, 73, 81, 81, 85, 85, 69, 69,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
27 32, 32, 75, 75, 10, 96, 10, 96, 10, 10, 10, 59, 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
28 59, 82, 82, 79, 79, 80, 80, 32, 32, 84, 84, 65, 65,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
29 66, 66, 76, 76, 69, 69, 32, 32, 73, 73, 70, 70, 32, 32,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
30 69, 69, 88, 88, 73, 73, 83, 83, 84, 84, 83, 83, 32,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
31 32, 96, 96, 10, 96, 10, 96, 59, 59, 78, 78, 83, 83,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
32 69, 69, 82, 82, 84, 84, 32, 32, 73, 73, 78, 78, 84, 84,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
33 79, 79, 32, 32, 96, 96, 10, 96, 10, 96, 32, 32, 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
34 86, 10, 41, 32, 32, 86, 86, 65, 65, 76, 76, 85, 85,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
35 69, 69, 83, 83, 32, 32, 40, 40, 39, 78, 10, 92, 10, 92,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
36 41, 44, 44, 59, 32, 78, 48, 57, 41, 57, 48, 57, 41,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
37 57, 85, 85, 76, 76, 76, 76, 34, 116, 79, 79, 67, 67,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
38 75, 75, 32, 32, 84, 84, 65, 65, 66, 66, 76, 76, 69, 69,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
39 83, 83, 32, 32, 96, 96, 10, 96, 10, 96, 32, 32, 87,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
40 87, 82, 82, 73, 73, 84, 84, 69, 69, 69, 69, 84, 84,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
41 32, 32, 10, 59, 10, 59, 78, 83, 76, 76, 79, 79, 67, 67,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
42 75, 75, 32, 32, 84, 84, 65, 65, 66, 66, 76, 76, 69,
12fb961c8f27 tools/jabberd14sql2prosody: 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] =
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
47 0, 1, 1, 1, 33, 38, 1, 1, 1, 1, 1, 1, 17, 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
48 39, 88, 1, 1, 1, 33, 38, 87, 87, 39, 51, 1, 1, 1, 33, 38, 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
49 1, 24, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 87, 87, 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
50 1, 10, 1, 22, 1, 1, 1, 1, 87, 87, 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
51 1, 1, 1, 1, 1, 1, 1, 1, 1, 87, 87, 1, 50, 50, 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
52 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 87, 87, 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
53 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 87, 87, 1, 47, 32, 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
54 1, 1, 1, 1, 40, 83, 83, 4, 16, 47, 10, 17, 10, 17, 1, 1, 1, 83, 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
55 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 87, 87, 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
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] =
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
60 0, 0, 2, 4, 6, 40, 79, 81, 83, 85, 87, 89, 91, 109, 111, 113, 115, 117, 119, 121,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
61 123, 163, 252, 254, 256, 258, 292, 331, 419, 507, 547, 599, 601, 603, 605, 639, 678, 680, 682, 684,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
62 686, 688, 713, 715, 717, 719, 721, 723, 725, 727, 729, 731, 733, 735, 737, 739, 741, 829, 917, 919,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
63 921, 923, 934, 936, 959, 961, 963, 965, 967, 1055, 1143, 1145, 1147, 1149, 1151, 1153, 1155, 1157, 1159, 1161,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
64 1163, 1165, 1167, 1169, 1171, 1173, 1175, 1177, 1179, 1181, 1269, 1357, 1359, 1410, 1461, 1463, 1465, 1467, 1469, 1471,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
65 1473, 1475, 1477, 1479, 1481, 1483, 1485, 1487, 1489, 1491, 1493, 1495, 1497, 1499, 1501, 1503, 1591, 1679, 1681, 1683,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
66 1685, 1687, 1689, 1691, 1693, 1695, 1697, 1699, 1701, 1703, 1705, 1793, 1881, 1883, 1931, 1964, 1966, 1968, 1970, 1972,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
67 1974, 1976, 1978, 1980, 1982, 2023, 2107, 2191, 2196, 2213, 2261, 2272, 2290, 2301, 2319, 2321, 2323, 2325, 2409, 2411,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
68 2413, 2415, 2417, 2419, 2421, 2423, 2425, 2427, 2429, 2431, 2433, 2521, 2609, 2611, 2613, 2615, 2617, 2619, 2621, 2623,
12fb961c8f27 tools/jabberd14sql2prosody: 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] =
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
73 0, 1, 2, 0, 3, 1, 4, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 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
74 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 5, 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
75 4, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 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
76 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 5, 3, 3, 3, 3, 6, 3, 7,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
77 1, 8, 1, 9, 1, 10, 1, 11, 1, 12, 1, 13, 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
78 1, 1, 1, 1, 1, 1, 1, 14, 1, 15, 1, 16, 1, 17, 1, 18, 1, 19, 1, 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
79 1, 21, 1, 22, 23, 22, 22, 22, 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
80 1, 1, 1, 1, 1, 1, 22, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 24,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
81 1, 25, 1, 22, 23, 22, 22, 22, 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
82 1, 1, 1, 1, 1, 1, 22, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 24,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
83 1, 25, 1, 1, 1, 1, 1, 1, 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
84 1, 1, 1, 1, 1, 1, 1, 1, 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
85 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 26, 1, 27, 1, 23, 27, 28, 1, 29, 28,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
86 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
87 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 30, 28, 29, 28, 28, 28, 28, 28, 28, 28,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
88 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
89 28, 28, 28, 28, 30, 28, 28, 28, 28, 22, 28, 32, 31, 31, 31, 31, 31, 31, 31, 31,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
90 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
91 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
92 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
93 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 1, 31, 32,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
94 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
95 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
96 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
97 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
98 31, 31, 31, 31, 31, 33, 31, 34, 35, 34, 34, 34, 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
99 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 34, 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
100 1, 1, 1, 36, 1, 37, 1, 34, 35, 34, 34, 34, 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
101 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 34, 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
102 1, 1, 1, 36, 1, 37, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 6, 1, 38,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
103 1, 35, 38, 39, 1, 40, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
104 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 41, 39, 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
105 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
106 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 41, 39, 39, 39, 39, 34, 39, 42, 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
107 43, 1, 44, 1, 45, 1, 46, 1, 47, 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
108 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 48, 1, 49, 1, 50, 1, 51, 1, 52,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
109 1, 53, 1, 54, 1, 55, 1, 56, 1, 57, 1, 58, 1, 59, 1, 60, 1, 61, 1, 48,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
110 1, 63, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
111 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
112 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
113 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
114 62, 62, 62, 62, 62, 62, 62, 1, 62, 65, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
115 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
116 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
117 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
118 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 66, 64, 67, 1, 68,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
119 1, 69, 1, 70, 1, 1, 1, 1, 1, 1, 1, 1, 71, 1, 72, 1, 73, 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
120 1, 74, 1, 1, 1, 1, 75, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 76, 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
121 1, 78, 1, 79, 1, 80, 1, 82, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
122 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
123 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
124 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
125 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 1, 81, 82, 81, 81, 81, 81,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
126 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
127 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
128 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
129 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
130 81, 83, 81, 69, 83, 84, 1, 85, 1, 86, 1, 87, 1, 88, 1, 89, 1, 90, 1, 91,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
131 1, 92, 1, 93, 1, 83, 1, 94, 1, 95, 1, 96, 1, 97, 1, 98, 1, 99, 1, 73,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
132 1, 101, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
133 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
134 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
135 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
136 100, 100, 100, 100, 100, 100, 100, 1, 100, 103, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
137 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
138 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
139 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
140 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 104, 102, 105, 83, 106,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
141 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 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
142 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 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
143 71, 71, 71, 71, 71, 71, 71, 71, 107, 71, 108, 71, 71, 71, 71, 71, 71, 71, 71, 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
144 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 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
145 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 107,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
146 71, 109, 1, 110, 1, 111, 1, 112, 1, 113, 1, 114, 1, 115, 1, 116, 1, 117, 1, 118,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
147 1, 119, 1, 120, 1, 121, 1, 122, 1, 123, 1, 124, 1, 125, 1, 126, 1, 127, 1, 128,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
148 1, 129, 1, 131, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
149 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
150 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
151 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
152 130, 130, 130, 130, 130, 130, 130, 130, 130, 1, 130, 131, 130, 130, 130, 130, 130, 130, 130, 130,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
153 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
154 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
155 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
156 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 132, 130, 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
157 1, 133, 1, 134, 1, 135, 1, 136, 1, 137, 1, 138, 1, 139, 1, 140, 1, 141, 1, 142,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
158 1, 143, 1, 144, 1, 146, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
159 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
160 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
161 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
162 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 1, 145, 148, 147, 147, 147, 147, 147, 147,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
163 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
164 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
165 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
166 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 149,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
167 147, 150, 1, 151, 1, 1, 1, 1, 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
168 1, 1, 1, 1, 1, 1, 1, 1, 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
169 1, 1, 1, 1, 1, 1, 1, 1, 1, 152, 1, 153, 151, 151, 151, 151, 151, 151, 151, 151,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
170 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
171 151, 151, 154, 151, 155, 1, 152, 1, 156, 1, 157, 1, 158, 1, 159, 1, 160, 1, 161, 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
172 162, 1, 163, 1, 1, 1, 1, 1, 164, 1, 1, 165, 165, 165, 165, 165, 165, 165, 165, 165,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
173 165, 1, 1, 1, 1, 1, 1, 1, 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
174 1, 166, 1, 168, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
175 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 169, 167, 167, 167, 167, 167, 167, 167,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
176 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
177 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
178 167, 167, 167, 167, 167, 170, 167, 172, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
179 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 173, 171, 171, 171,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
180 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
181 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
182 171, 171, 171, 171, 171, 171, 171, 171, 171, 174, 171, 175, 1, 1, 176, 1, 161, 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
183 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 177, 1, 178, 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
184 163, 1, 1, 1, 1, 1, 164, 1, 1, 165, 165, 165, 165, 165, 165, 165, 165, 165, 165, 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
185 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 166,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
186 1, 179, 179, 179, 179, 179, 179, 179, 179, 179, 179, 1, 180, 1, 1, 181, 1, 182, 1, 179,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
187 179, 179, 179, 179, 179, 179, 179, 179, 179, 1, 183, 183, 183, 183, 183, 183, 183, 183, 183, 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
188 1, 180, 1, 1, 181, 1, 1, 1, 183, 183, 183, 183, 183, 183, 183, 183, 183, 183, 1, 184,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
189 1, 185, 1, 186, 1, 171, 1, 1, 171, 1, 171, 1, 1, 1, 1, 1, 1, 1, 1, 171,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
190 1, 1, 1, 1, 1, 1, 1, 1, 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
191 1, 1, 1, 1, 1, 1, 1, 1, 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
192 1, 171, 1, 171, 1, 1, 171, 1, 1, 171, 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
193 1, 171, 1, 1, 1, 171, 1, 171, 1, 187, 1, 188, 1, 189, 1, 190, 1, 191, 1, 192,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
194 1, 193, 1, 194, 1, 195, 1, 196, 1, 197, 1, 198, 1, 200, 199, 199, 199, 199, 199, 199,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
195 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
196 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
197 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
198 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 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
199 199, 200, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
200 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
201 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
202 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
203 199, 199, 199, 199, 199, 199, 199, 201, 199, 202, 1, 203, 1, 204, 1, 205, 1, 206, 1, 132,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
204 1, 207, 1, 208, 1, 209, 1, 210, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
205 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
206 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 211, 209, 2, 209,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
207 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
208 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
209 209, 209, 209, 209, 209, 209, 209, 211, 209, 212, 1, 1, 1, 1, 213, 1, 214, 1, 215, 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
210 216, 1, 217, 1, 218, 1, 219, 1, 220, 1, 221, 1, 222, 1, 223, 1, 132, 1, 127, 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
211 6, 2, 6, 6, 6, 1, 1, 1, 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
212 1, 1, 1, 6, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 224, 1, 225, 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
213 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 6, 1, 1, 1, 1, 1, 1, 1, 226, 227,
12fb961c8f27 tools/jabberd14sql2prosody: 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] =
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
218 2, 0, 196, 4, 4, 5, 196, 7, 8, 9, 10, 11, 12, 13, 36, 14, 15, 16, 17, 18,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
219 19, 20, 21, 21, 22, 24, 27, 23, 25, 25, 26, 28, 28, 29, 30, 30, 31, 33, 32, 34,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
220 34, 35, 37, 38, 39, 40, 41, 42, 56, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
221 54, 55, 57, 57, 57, 57, 58, 59, 60, 61, 62, 92, 63, 64, 71, 82, 89, 65, 66, 67,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
222 68, 69, 69, 70, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
223 90, 90, 90, 90, 91, 70, 92, 93, 196, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
224 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 116, 117, 119, 120, 121, 122, 123, 124, 125,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
225 126, 127, 128, 129, 130, 131, 131, 131, 131, 132, 133, 134, 137, 134, 135, 136, 138, 139, 140, 141,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
226 142, 143, 144, 145, 150, 151, 154, 146, 146, 147, 157, 146, 146, 147, 157, 148, 149, 196, 144, 151,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
227 148, 149, 152, 153, 155, 156, 147, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171,
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
228 171, 172, 173, 174, 175, 176, 177, 179, 180, 181, 181, 182, 184, 195, 185, 186, 187, 188, 189, 190,
12fb961c8f27 tools/jabberd14sql2prosody: 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] =
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
233 1, 0, 3, 1, 3, 1, 1, 1, 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
234 1, 1, 1, 3, 1, 1, 1, 1, 1, 3, 1, 1, 3, 1, 1, 3, 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
235 3, 1, 1, 1, 1, 1, 1, 1, 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
236 1, 1, 5, 20, 1, 3, 30, 1, 1, 3, 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
237 1, 1, 3, 1, 1, 1, 1, 1, 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
238 5, 20, 1, 3, 26, 3, 3, 1, 23, 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
239 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 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
240 1, 1, 1, 1, 1, 5, 20, 1, 3, 42, 1, 1, 1, 3, 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
241 1, 1, 11, 1, 5, 5, 1, 5, 20, 46, 5, 1, 3, 34, 1, 14, 1, 17, 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
242 51, 38, 1, 1, 1, 1, 8, 1, 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
243 3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 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
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
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
280
12fb961c8f27 tools/jabberd14sql2prosody: 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
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
325 if _slen > 0 and
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
326 _parse_sql_trans_keys[_keys] <= data:byte(p) and
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
327 data:byte(p) <= _parse_sql_trans_keys[_keys + 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
328 _trans = _parse_sql_indicies[ _inds + data:byte(p) - _parse_sql_trans_keys[_keys] ];
12fb961c8f27 tools/jabberd14sql2prosody: 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
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
367
12fb961c8f27 tools/jabberd14sql2prosody: 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
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
395 end -- endif
12fb961c8f27 tools/jabberd14sql2prosody: 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
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
431 package.path = [[C:\Documents and Settings\Waqas\Desktop\mercurial\prosody-hg\?.lua;]]..package.path;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
432
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
433 -- 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
434 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
435 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
436 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
437 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
438 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
439 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
440 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
441 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
442
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
444 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
445
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
447
12fb961c8f27 tools/jabberd14sql2prosody: 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 local lxp = require "lxp";
12fb961c8f27 tools/jabberd14sql2prosody: 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 local st = require "util.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
450
12fb961c8f27 tools/jabberd14sql2prosody: 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 local parse_xml = (function()
12fb961c8f27 tools/jabberd14sql2prosody: 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 local ns_prefixes = {
12fb961c8f27 tools/jabberd14sql2prosody: 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 ["http://www.w3.org/XML/1998/namespace"] = "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
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 ns_separator = "\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
456 local ns_pattern = "^([^"..ns_separator.."]*)"..ns_separator.."?(.*)$";
12fb961c8f27 tools/jabberd14sql2prosody: 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 return function(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
458 local handler = {};
12fb961c8f27 tools/jabberd14sql2prosody: 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 local stanza = st.stanza("root");
12fb961c8f27 tools/jabberd14sql2prosody: 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 function handler:StartElement(tagname, attr)
12fb961c8f27 tools/jabberd14sql2prosody: 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 local curr_ns,name = tagname:match(ns_pattern);
12fb961c8f27 tools/jabberd14sql2prosody: 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 if 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
463 curr_ns, name = "", curr_ns;
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
465 if curr_ns ~= "" 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
466 attr.xmlns = curr_ns;
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
468 for i=1,#attr 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
469 local k = attr[i];
12fb961c8f27 tools/jabberd14sql2prosody: 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 attr[i] = 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
471 local ns, nm = k:match(ns_pattern);
12fb961c8f27 tools/jabberd14sql2prosody: 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 if nm ~= "" 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
473 ns = ns_prefixes[ns];
12fb961c8f27 tools/jabberd14sql2prosody: 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 if ns 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
475 attr[ns..":"..nm] = attr[k];
12fb961c8f27 tools/jabberd14sql2prosody: 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 attr[k] = 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
477 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
478 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
479 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
480 stanza:tag(name, attr);
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
482 function handler:CharacterData(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
483 stanza:text(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
484 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
485 function handler:EndElement(tagname)
12fb961c8f27 tools/jabberd14sql2prosody: 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 stanza:up();
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
488 local parser = lxp.new(handler, "\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
489 local ok, err, line, col = parser:parse(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
490 if ok then ok, err, line, col = parser:parse(); 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
491 --parser: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
492 if ok 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
493 return stanza.tags[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
494 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
495 return ok, err.." (line "..line..", col "..col..")";
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
497 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
498 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
499
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
501 -- 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
502 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
503 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
504 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
505
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
507 -- 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
508 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
509 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
510 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
511
12fb961c8f27 tools/jabberd14sql2prosody: 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 function store_roster(username, host, roster_items)
12fb961c8f27 tools/jabberd14sql2prosody: 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 -- fetch current roster-table for username@host if he already has one
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
515 -- 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
516 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
517 -- 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
518 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
519 -- 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
520 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
521 -- 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
522 -- 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
523 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
524 -- 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
525 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
526 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
527 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
528 -- 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
529 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
530 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
531 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
532 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
533 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
534 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
535 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
536 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
537 -- 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
538 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
539 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
540 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
541 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
542 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
543
12fb961c8f27 tools/jabberd14sql2prosody: 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 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 -- 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
546 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
547 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
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
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
551 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
552
12fb961c8f27 tools/jabberd14sql2prosody: 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 -- fetch current roster-table for username@host if he already has one
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
555
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
557 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
558 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
559 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
560
12fb961c8f27 tools/jabberd14sql2prosody: 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 -- 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
562 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
563 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
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 -- 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
566 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
567 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
568 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
569
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
571 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
572 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
573 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
574 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
575 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
576 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
577 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
578 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
579 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
580 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
581 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
582 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
583 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
584 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
585 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
586 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
587 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
588 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
589 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
590 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
591 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
592 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
593
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
595 -- 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
596 -- 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
597 --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
598 --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
599 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
600
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
602 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
603
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
605 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
606
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
608 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
609
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
611 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
612 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
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 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
615
12fb961c8f27 tools/jabberd14sql2prosody: 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 -- 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
617 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
618 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
619 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
620 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
621
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
623 ]]);
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
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 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
627 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
628 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
629
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
631 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
632 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
633 -- 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
634 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
635 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
636 --[[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
637 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
638 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
639 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
640 --[[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
641 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
642 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
643
12fb961c8f27 tools/jabberd14sql2prosody: 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 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
645 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
646 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
647 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
648 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
649 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
650 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
651 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
652 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
653 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
654 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
655 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
656 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
657 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
658 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
659 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
660 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
661 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
662 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
663 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
664 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
665 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
666 --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
667 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
668 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
669 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
670 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
671 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
672 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
673 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
674 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
675 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
676 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
677 --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
678 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
679 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
680 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
681 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
682 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
683 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
684 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
685 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
686 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
687 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
688 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
689 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
690 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
691 });
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
692
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
693 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
694 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
695 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
696