|
Active Member
Регистрация: 17.10.2018
Сообщений: 262
С нами:
3986966
Репутация:
1
|
|
Сообщение от TOX1C
китайская смекалочка, столкнувшись с дефицитом MAC адресов, решила использовать одни и те же адреса дважды, а может даже и трижды. Или больше?
Трижды, как минимум.
up
распишу-ка здесь чуть подробнее:
Код:
MariaDB [Tenda]> select tenda_pin8('04:95:E6:62:F3:50,7314868,2');
*************************** 1. row ***************************
tenda_pin8('04:95:E6:62:F3:50,7314868,2'): PinFound,27,HalfFound,18,XPin,1,XHalf,1,Xh,1,XMax,3,XhMax,3,mPin,174,mHalf,337,Delta1,-376,MAC1,04:95:E6:62:F1:D8,Delta2,-592,MAC2,04:95:E6:62:F1:00,Delta3,616,MAC3,04:95:E6:62:F5:B8,Delta4,-784,MAC4,04:95:E6:62:F0:40,Delta5,-792,MAC5,04:95:E6:62:F0:38,Delta6,1096,MAC6,04:95:E6:62:F7:98,Delta7,1584,MAC7,04:95:E6:62:F9:80,Delta8,1608,MAC8,04:95:E6:62:F9:98
1 row in set (1.27 sec)
MariaDB [Tenda]> select * from tmp_TendaHalfs where X order by n;
+------+------+------+------+------+------+------+------+------+------+------+------+------+
| n | Half | X | Xh | m | m1 | m2 | m3 | m4 | m5 | m6 | m7 | m8 |
+------+------+------+------+------+------+------+------+------+------+------+------+------+
| 1 | 1129 | 3 | 3 | 1145 | 0 | 736 | 12 | 0 | 173 | 0 | 0 | 224 |
| 2 | 5906 | 3 | 3 | 137 | 0 | 49 | 13 | 0 | 57 | 0 | 0 | 18 |
| 3 | 1195 | 3 | 3 | 118 | 0 | 31 | 19 | 0 | 23 | 0 | 0 | 45 |
| 4 | 5907 | 3 | 3 | 37 | 0 | 6 | 2 | 0 | 11 | 0 | 0 | 18 |
| 5 | 6906 | 2 | 2 | 948 | 0 | 0 | 507 | 0 | 281 | 0 | 0 | 160 |
| 6 | 6972 | 2 | 2 | 769 | 0 | 0 | 616 | 0 | 87 | 0 | 0 | 66 |
| 7 | 1064 | 2 | 2 | 688 | 0 | 410 | 0 | 0 | 115 | 0 | 0 | 163 |
| 8 | 6841 | 2 | 2 | 491 | 0 | 0 | 48 | 0 | 299 | 0 | 0 | 144 |
| 9 | 6907 | 2 | 2 | 247 | 0 | 0 | 94 | 0 | 52 | 0 | 0 | 101 |
| 10 | 5841 | 2 | 3 | 121 | 0 | 39 | 1 | 0 | 62 | 0 | 0 | 19 |
| 11 | 7906 | 2 | 2 | 55 | 0 | 0 | 10 | 0 | 21 | 0 | 0 | 24 |
| 12 | 5972 | 2 | 3 | 46 | 0 | 1 | 26 | 0 | 14 | 0 | 0 | 5 |
| 13 | 7972 | 2 | 2 | 23 | 0 | 0 | 9 | 0 | 11 | 0 | 0 | 3 |
| 14 | 7907 | 2 | 2 | 21 | 0 | 0 | 2 | 0 | 4 | 0 | 0 | 15 |
| 15 | 7249 | 1 | 1 | 753 | 306 | 0 | 0 | 447 | 0 | 0 | 0 | 0 |
| 16 | 7091 | 1 | 1 | 477 | 0 | 0 | 0 | 0 | 0 | 379 | 98 | 0 |
| 17 | 7026 | 1 | 1 | 433 | 0 | 0 | 0 | 0 | 0 | 250 | 183 | 0 |
| 18 | 7314 | 1 | 1 | 337 | 151 | 0 | 0 | 186 | 0 | 0 | 0 | 0 |
| 19 | 7315 | 1 | 1 | 173 | 75 | 0 | 0 | 98 | 0 | 0 | 0 | 0 |
| 20 | 6249 | 1 | 1 | 146 | 40 | 0 | 0 | 106 | 0 | 0 | 0 | 0 |
| 21 | 7092 | 1 | 1 | 106 | 0 | 0 | 0 | 0 | 0 | 15 | 91 | 0 |
| 22 | 6026 | 1 | 1 | 95 | 0 | 0 | 0 | 0 | 0 | 60 | 35 | 0 |
| 23 | 6091 | 1 | 1 | 87 | 0 | 0 | 0 | 0 | 0 | 74 | 13 | 0 |
| 24 | 8249 | 1 | 1 | 82 | 44 | 0 | 0 | 38 | 0 | 0 | 0 | 0 |
| 25 | 9129 | 1 | 1 | 60 | 0 | 41 | 0 | 0 | 0 | 0 | 0 | 19 |
| 26 | 7157 | 1 | 1 | 59 | 0 | 0 | 0 | 0 | 0 | 32 | 27 | 0 |
| 27 | 6314 | 1 | 1 | 57 | 15 | 0 | 0 | 42 | 0 | 0 | 0 | 0 |
| 28 | 8026 | 1 | 1 | 56 | 0 | 0 | 0 | 0 | 0 | 24 | 32 | 0 |
| 29 | 8091 | 1 | 1 | 52 | 0 | 0 | 0 | 0 | 0 | 39 | 13 | 0 |
| 30 | 8314 | 1 | 1 | 49 | 26 | 0 | 0 | 23 | 0 | 0 | 0 | 0 |
| 31 | 7841 | 1 | 1 | 40 | 0 | 0 | 0 | 0 | 19 | 0 | 0 | 21 |
| 32 | 9064 | 1 | 1 | 39 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 9 |
| 33 | 1130 | 1 | 1 | 34 | 0 | 13 | 0 | 0 | 0 | 0 | 0 | 21 |
| 34 | 8092 | 1 | 1 | 24 | 0 | 0 | 0 | 0 | 0 | 5 | 19 | 0 |
| 35 | 1194 | 1 | 1 | 20 | 0 | 0 | 7 | 0 | 13 | 0 | 0 | 0 |
| 36 | 8315 | 1 | 1 | 18 | 7 | 0 | 0 | 11 | 0 | 0 | 0 | 0 |
| 37 | 6315 | 1 | 1 | 17 | 6 | 0 | 0 | 11 | 0 | 0 | 0 | 0 |
| 38 | 6092 | 1 | 1 | 16 | 0 | 0 | 0 | 0 | 0 | 2 | 14 | 0 |
| 39 | 6157 | 1 | 1 | 14 | 0 | 0 | 0 | 0 | 0 | 10 | 4 | 0 |
| 40 | 8157 | 1 | 1 | 11 | 0 | 0 | 0 | 0 | 0 | 4 | 7 | 0 |
| 41 | 1289 | 1 | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 0 |
| 42 | 9130 | 1 | 1 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 |
| 43 | 7730 | 1 | 1 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |
| 44 | 1626 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 |
+------+------+------+------+------+------+------+------+------+------+------+------+------+
44 rows in set (0.00 sec)
MariaDB [Tenda]> select * from tmp_TendaHalfs where X order by m1+m4 desc;
+------+------+------+------+------+------+------+------+------+------+------+------+------+
| n | Half | X | Xh | m | m1 | m2 | m3 | m4 | m5 | m6 | m7 | m8 |
+------+------+------+------+------+------+------+------+------+------+------+------+------+
| 15 | 7249 | 1 | 1 | 753 | 306 | 0 | 0 | 447 | 0 | 0 | 0 | 0 |
| 18 | 7314 | 1 | 1 | 337 | 151 | 0 | 0 | 186 | 0 | 0 | 0 | 0 |
| 19 | 7315 | 1 | 1 | 173 | 75 | 0 | 0 | 98 | 0 | 0 | 0 | 0 |
| 20 | 6249 | 1 | 1 | 146 | 40 | 0 | 0 | 106 | 0 | 0 | 0 | 0 |
| 24 | 8249 | 1 | 1 | 82 | 44 | 0 | 0 | 38 | 0 | 0 | 0 | 0 |
| 27 | 6314 | 1 | 1 | 57 | 15 | 0 | 0 | 42 | 0 | 0 | 0 | 0 |
| 30 | 8314 | 1 | 1 | 49 | 26 | 0 | 0 | 23 | 0 | 0 | 0 | 0 |
| 36 | 8315 | 1 | 1 | 18 | 7 | 0 | 0 | 11 | 0 | 0 | 0 | 0 |
| 37 | 6315 | 1 | 1 | 17 | 6 | 0 | 0 | 11 | 0 | 0 | 0 | 0 |
| 43 | 7730 | 1 | 1 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |
| 1 | 1129 | 3 | 3 | 1145 | 0 | 736 | 12 | 0 | 173 | 0 | 0 | 224 |
| 38 | 6092 | 1 | 1 | 16 | 0 | 0 | 0 | 0 | 0 | 2 | 14 | 0 |
| 29 | 8091 | 1 | 1 | 52 | 0 | 0 | 0 | 0 | 0 | 39 | 13 | 0 |
| 11 | 7906 | 2 | 2 | 55 | 0 | 0 | 10 | 0 | 21 | 0 | 0 | 24 |
| 2 | 5906 | 3 | 3 | 137 | 0 | 49 | 13 | 0 | 57 | 0 | 0 | 18 |
| 39 | 6157 | 1 | 1 | 14 | 0 | 0 | 0 | 0 | 0 | 10 | 4 | 0 |
| 21 | 7092 | 1 | 1 | 106 | 0 | 0 | 0 | 0 | 0 | 15 | 91 | 0 |
| 12 | 5972 | 2 | 3 | 46 | 0 | 1 | 26 | 0 | 14 | 0 | 0 | 5 |
| 3 | 1195 | 3 | 3 | 118 | 0 | 31 | 19 | 0 | 23 | 0 | 0 | 45 |
| 40 | 8157 | 1 | 1 | 11 | 0 | 0 | 0 | 0 | 0 | 4 | 7 | 0 |
| 31 | 7841 | 1 | 1 | 40 | 0 | 0 | 0 | 0 | 19 | 0 | 0 | 21 |
| 22 | 6026 | 1 | 1 | 95 | 0 | 0 | 0 | 0 | 0 | 60 | 35 | 0 |
| 13 | 7972 | 2 | 2 | 23 | 0 | 0 | 9 | 0 | 11 | 0 | 0 | 3 |
| 4 | 5907 | 3 | 3 | 37 | 0 | 6 | 2 | 0 | 11 | 0 | 0 | 18 |
| 41 | 1289 | 1 | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 0 |
| 32 | 9064 | 1 | 1 | 39 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 9 |
| 23 | 6091 | 1 | 1 | 87 | 0 | 0 | 0 | 0 | 0 | 74 | 13 | 0 |
| 14 | 7907 | 2 | 2 | 21 | 0 | 0 | 2 | 0 | 4 | 0 | 0 | 15 |
| 5 | 6906 | 2 | 2 | 948 | 0 | 0 | 507 | 0 | 281 | 0 | 0 | 160 |
| 42 | 9130 | 1 | 1 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 |
| 33 | 1130 | 1 | 1 | 34 | 0 | 13 | 0 | 0 | 0 | 0 | 0 | 21 |
| 6 | 6972 | 2 | 2 | 769 | 0 | 0 | 616 | 0 | 87 | 0 | 0 | 66 |
| 34 | 8092 | 1 | 1 | 24 | 0 | 0 | 0 | 0 | 0 | 5 | 19 | 0 |
| 25 | 9129 | 1 | 1 | 60 | 0 | 41 | 0 | 0 | 0 | 0 | 0 | 19 |
| 16 | 7091 | 1 | 1 | 477 | 0 | 0 | 0 | 0 | 0 | 379 | 98 | 0 |
| 7 | 1064 | 2 | 2 | 688 | 0 | 410 | 0 | 0 | 115 | 0 | 0 | 163 |
| 44 | 1626 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 |
| 35 | 1194 | 1 | 1 | 20 | 0 | 0 | 7 | 0 | 13 | 0 | 0 | 0 |
| 26 | 7157 | 1 | 1 | 59 | 0 | 0 | 0 | 0 | 0 | 32 | 27 | 0 |
| 17 | 7026 | 1 | 1 | 433 | 0 | 0 | 0 | 0 | 0 | 250 | 183 | 0 |
| 8 | 6841 | 2 | 2 | 491 | 0 | 0 | 48 | 0 | 299 | 0 | 0 | 144 |
| 9 | 6907 | 2 | 2 | 247 | 0 | 0 | 94 | 0 | 52 | 0 | 0 | 101 |
| 28 | 8026 | 1 | 1 | 56 | 0 | 0 | 0 | 0 | 0 | 24 | 32 | 0 |
| 10 | 5841 | 2 | 3 | 121 | 0 | 39 | 1 | 0 | 62 | 0 | 0 | 19 |
+------+------+------+------+------+------+------+------+------+------+------+------+------+
44 rows in set (0.00 sec)
MariaDB [Tenda]> select * from tmp_TendaHalfs where X order by m6+m7 desc;
+------+------+------+------+------+------+------+------+------+------+------+------+------+
| n | Half | X | Xh | m | m1 | m2 | m3 | m4 | m5 | m6 | m7 | m8 |
+------+------+------+------+------+------+------+------+------+------+------+------+------+
| 16 | 7091 | 1 | 1 | 477 | 0 | 0 | 0 | 0 | 0 | 379 | 98 | 0 |
| 17 | 7026 | 1 | 1 | 433 | 0 | 0 | 0 | 0 | 0 | 250 | 183 | 0 |
| 21 | 7092 | 1 | 1 | 106 | 0 | 0 | 0 | 0 | 0 | 15 | 91 | 0 |
| 22 | 6026 | 1 | 1 | 95 | 0 | 0 | 0 | 0 | 0 | 60 | 35 | 0 |
| 23 | 6091 | 1 | 1 | 87 | 0 | 0 | 0 | 0 | 0 | 74 | 13 | 0 |
| 26 | 7157 | 1 | 1 | 59 | 0 | 0 | 0 | 0 | 0 | 32 | 27 | 0 |
| 28 | 8026 | 1 | 1 | 56 | 0 | 0 | 0 | 0 | 0 | 24 | 32 | 0 |
| 29 | 8091 | 1 | 1 | 52 | 0 | 0 | 0 | 0 | 0 | 39 | 13 | 0 |
| 34 | 8092 | 1 | 1 | 24 | 0 | 0 | 0 | 0 | 0 | 5 | 19 | 0 |
| 38 | 6092 | 1 | 1 | 16 | 0 | 0 | 0 | 0 | 0 | 2 | 14 | 0 |
| 39 | 6157 | 1 | 1 | 14 | 0 | 0 | 0 | 0 | 0 | 10 | 4 | 0 |
| 40 | 8157 | 1 | 1 | 11 | 0 | 0 | 0 | 0 | 0 | 4 | 7 | 0 |
| 41 | 1289 | 1 | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 0 |
| 44 | 1626 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 |
| 1 | 1129 | 3 | 3 | 1145 | 0 | 736 | 12 | 0 | 173 | 0 | 0 | 224 |
| 20 | 6249 | 1 | 1 | 146 | 40 | 0 | 0 | 106 | 0 | 0 | 0 | 0 |
| 11 | 7906 | 2 | 2 | 55 | 0 | 0 | 10 | 0 | 21 | 0 | 0 | 24 |
| 2 | 5906 | 3 | 3 | 137 | 0 | 49 | 13 | 0 | 57 | 0 | 0 | 18 |
| 30 | 8314 | 1 | 1 | 49 | 26 | 0 | 0 | 23 | 0 | 0 | 0 | 0 |
| 12 | 5972 | 2 | 3 | 46 | 0 | 1 | 26 | 0 | 14 | 0 | 0 | 5 |
| 3 | 1195 | 3 | 3 | 118 | 0 | 31 | 19 | 0 | 23 | 0 | 0 | 45 |
| 31 | 7841 | 1 | 1 | 40 | 0 | 0 | 0 | 0 | 19 | 0 | 0 | 21 |
| 13 | 7972 | 2 | 2 | 23 | 0 | 0 | 9 | 0 | 11 | 0 | 0 | 3 |
| 4 | 5907 | 3 | 3 | 37 | 0 | 6 | 2 | 0 | 11 | 0 | 0 | 18 |
| 32 | 9064 | 1 | 1 | 39 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 9 |
| 14 | 7907 | 2 | 2 | 21 | 0 | 0 | 2 | 0 | 4 | 0 | 0 | 15 |
| 5 | 6906 | 2 | 2 | 948 | 0 | 0 | 507 | 0 | 281 | 0 | 0 | 160 |
| 42 | 9130 | 1 | 1 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 |
| 33 | 1130 | 1 | 1 | 34 | 0 | 13 | 0 | 0 | 0 | 0 | 0 | 21 |
| 24 | 8249 | 1 | 1 | 82 | 44 | 0 | 0 | 38 | 0 | 0 | 0 | 0 |
| 15 | 7249 | 1 | 1 | 753 | 306 | 0 | 0 | 447 | 0 | 0 | 0 | 0 |
| 6 | 6972 | 2 | 2 | 769 | 0 | 0 | 616 | 0 | 87 | 0 | 0 | 66 |
| 43 | 7730 | 1 | 1 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |
| 25 | 9129 | 1 | 1 | 60 | 0 | 41 | 0 | 0 | 0 | 0 | 0 | 19 |
| 7 | 1064 | 2 | 2 | 688 | 0 | 410 | 0 | 0 | 115 | 0 | 0 | 163 |
| 35 | 1194 | 1 | 1 | 20 | 0 | 0 | 7 | 0 | 13 | 0 | 0 | 0 |
| 8 | 6841 | 2 | 2 | 491 | 0 | 0 | 48 | 0 | 299 | 0 | 0 | 144 |
| 36 | 8315 | 1 | 1 | 18 | 7 | 0 | 0 | 11 | 0 | 0 | 0 | 0 |
| 27 | 6314 | 1 | 1 | 57 | 15 | 0 | 0 | 42 | 0 | 0 | 0 | 0 |
| 18 | 7314 | 1 | 1 | 337 | 151 | 0 | 0 | 186 | 0 | 0 | 0 | 0 |
| 9 | 6907 | 2 | 2 | 247 | 0 | 0 | 94 | 0 | 52 | 0 | 0 | 101 |
| 37 | 6315 | 1 | 1 | 17 | 6 | 0 | 0 | 11 | 0 | 0 | 0 | 0 |
| 19 | 7315 | 1 | 1 | 173 | 75 | 0 | 0 | 98 | 0 | 0 | 0 | 0 |
| 10 | 5841 | 2 | 3 | 121 | 0 | 39 | 1 | 0 | 62 | 0 | 0 | 19 |
+------+------+------+------+------+------+------+------+------+------+------+------+------+
44 rows in set (0.00 sec)
|