summaryrefslogtreecommitdiffstats
path: root/notFinishedCode/tricode/DbClass.pyc
blob: 16f63955cce6425ed5d0f33135881ab71afc6d4b (plain)
ofshex dumpascii
0000 03 f3 0d 0a 0f d1 6c 4e 63 00 00 00 00 00 00 00 00 03 00 00 00 40 00 00 00 73 2f 00 00 00 64 00 ......lNc............@...s/...d.
0020 00 64 01 00 6c 00 00 5a 00 00 64 00 00 64 01 00 6c 01 00 5a 01 00 64 02 00 64 04 00 64 03 00 84 .d..l..Z..d..d..l..Z..d..d..d...
0040 00 00 83 00 00 59 5a 02 00 64 01 00 53 28 05 00 00 00 69 ff ff ff ff 4e 74 11 00 00 00 44 42 4d .....YZ..d..S(....i....Nt....DBM
0060 79 53 51 4c 43 6f 6e 6e 65 63 74 69 6f 6e 63 00 00 00 00 00 00 00 00 01 00 00 00 42 00 00 00 73 ySQLConnectionc............B...s
0080 7d 00 00 00 65 00 00 5a 01 00 64 00 00 84 00 00 5a 02 00 64 01 00 84 00 00 5a 03 00 64 02 00 84 }...e..Z..d.....Z..d.....Z..d...
00a0 00 00 5a 04 00 64 03 00 84 00 00 5a 05 00 64 04 00 84 00 00 5a 06 00 64 05 00 84 00 00 5a 07 00 ..Z..d.....Z..d.....Z..d.....Z..
00c0 64 06 00 84 00 00 5a 08 00 64 07 00 84 00 00 5a 09 00 64 08 00 84 00 00 5a 0a 00 64 09 00 84 00 d.....Z..d.....Z..d.....Z..d....
00e0 00 5a 0b 00 64 0a 00 84 00 00 5a 0c 00 64 0b 00 84 00 00 5a 0d 00 64 0c 00 84 00 00 5a 0e 00 52 .Z..d.....Z..d.....Z..d.....Z..R
0100 53 28 0d 00 00 00 63 05 00 00 00 05 00 00 00 02 00 00 00 43 00 00 00 73 6a 00 00 00 7c 01 00 7c S(....c............C...sj...|..|
0120 00 00 5f 00 00 7c 02 00 7c 00 00 5f 01 00 7c 03 00 7c 00 00 5f 02 00 7c 04 00 7c 00 00 5f 03 00 .._..|..|.._..|..|.._..|..|.._..
0140 64 01 00 7c 00 00 5f 04 00 74 05 00 83 00 00 7c 00 00 5f 06 00 74 05 00 83 00 00 7c 00 00 5f 07 d..|.._..t.....|.._..t.....|.._.
0160 00 64 00 00 7c 00 00 5f 09 00 64 01 00 7c 00 00 5f 0a 00 64 00 00 7c 00 00 5f 0b 00 64 01 00 61 .d..|.._..d..|.._..d..|.._..d..a
0180 0c 00 64 00 00 53 28 02 00 00 00 4e 69 00 00 00 00 28 0d 00 00 00 74 05 00 00 00 75 73 65 72 6e ..d..S(....Ni....(....t....usern
01a0 74 05 00 00 00 70 61 73 73 77 74 04 00 00 00 68 6f 73 74 74 02 00 00 00 64 62 74 11 00 00 00 63 t....passwt....hostt....dbt....c
01c0 6f 6e 6e 65 63 74 69 6f 6e 43 72 65 61 74 65 64 74 04 00 00 00 6c 69 73 74 74 09 00 00 00 74 61 onnectionCreatedt....listt....ta
01e0 73 6b 73 4c 69 73 74 74 0b 00 00 00 63 61 6c 6c 65 72 4c 69 73 74 73 74 04 00 00 00 4e 6f 6e 65 sksListt....callerListst....None
0200 74 07 00 00 00 65 72 72 43 6f 64 65 74 07 00 00 00 6c 6f 63 6b 53 65 74 74 0c 00 00 00 64 65 76 t....errCodet....lockSett....dev
0220 69 63 65 55 70 64 61 74 65 74 09 00 00 00 64 65 62 75 67 4d 6f 64 65 28 05 00 00 00 74 04 00 00 iceUpdatet....debugMode(....t...
0240 00 73 65 6c 66 74 08 00 00 00 75 73 65 72 6e 61 6d 65 74 08 00 00 00 70 61 73 73 77 6f 72 64 52 .selft....usernamet....passwordR
0260 03 00 00 00 74 06 00 00 00 64 62 6e 61 6d 65 28 00 00 00 00 28 00 00 00 00 73 1b 00 00 00 2f 76 ....t....dbname(....(....s..../v
0280 61 72 2f 77 77 77 2f 74 72 69 63 6f 64 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 08 00 00 00 5f 5f ar/www/tricode/DbClass.pyt....__
02a0 69 6e 69 74 5f 5f 05 00 00 00 73 16 00 00 00 00 02 09 01 09 01 09 01 09 01 09 01 0c 01 0c 01 09 init__....s.....................
02c0 01 09 01 09 02 63 01 00 00 00 03 00 00 00 05 00 00 00 43 00 00 00 73 c5 00 00 00 79 56 00 74 00 .....c............C...s....yV.t.
02e0 00 6a 01 00 7c 00 00 6a 02 00 7c 00 00 6a 03 00 7c 00 00 6a 04 00 7c 00 00 6a 05 00 83 04 00 7c .j..|..j..|..j..|..j..|..j.....|
0300 00 00 5f 06 00 64 01 00 7c 00 00 6a 06 00 5f 07 00 7c 00 00 6a 06 00 6a 08 00 83 00 00 7c 00 00 .._..d..|..j.._..|..j..j.....|..
0320 5f 09 00 64 02 00 7c 00 00 5f 0a 00 64 02 00 53 57 6e 68 00 04 74 00 00 6a 0b 00 6b 0a 00 72 c0 _..d..|.._..d..SWnh..t..j..k..r.
0340 00 01 7d 01 00 01 74 0c 00 7c 01 00 83 01 00 7d 02 00 7c 02 00 64 02 00 64 03 00 21 64 04 00 6b ..}...t..|.....}..|..d..d..!d..k
0360 02 00 72 8e 00 64 05 00 53 7c 02 00 64 02 00 64 03 00 21 64 06 00 6b 02 00 72 a5 00 64 07 00 53 ..r..d..S|..d..d..!d..k..r..d..S
0380 74 0d 00 64 02 00 6b 02 00 72 b9 00 7c 02 00 47 48 6e 00 00 64 08 00 53 6e 01 00 58 64 00 00 53 t..d..k..r..|..GHn..d..Sn..Xd..S
03a0 28 09 00 00 00 4e 74 06 00 00 00 66 6f 72 6d 61 74 69 01 00 00 00 69 05 00 00 00 74 04 00 00 00 (....Nt....formati....i....t....
03c0 31 30 34 35 69 00 00 00 00 74 04 00 00 00 32 30 30 32 69 02 00 00 00 69 03 00 00 00 28 0e 00 00 1045i....t....2002i....i....(...
03e0 00 74 07 00 00 00 4d 79 53 51 4c 64 62 74 07 00 00 00 63 6f 6e 6e 65 63 74 52 03 00 00 00 52 01 .t....MySQLdbt....connectR....R.
0400 00 00 00 52 02 00 00 00 52 04 00 00 00 74 0b 00 00 00 64 61 74 42 61 73 65 43 6f 6e 6e 74 0a 00 ...R....R....t....datBaseConnt..
0420 00 00 70 61 72 61 6d 73 74 79 6c 65 74 06 00 00 00 63 75 72 73 6f 72 74 03 00 00 00 63 75 72 52 ..paramstylet....cursort....curR
0440 05 00 00 00 74 05 00 00 00 45 72 72 6f 72 74 03 00 00 00 73 74 72 52 0d 00 00 00 28 03 00 00 00 ....t....Errort....strR....(....
0460 52 0e 00 00 00 74 01 00 00 00 65 74 05 00 00 00 65 72 72 6f 72 28 00 00 00 00 28 00 00 00 00 73 R....t....et....error(....(....s
0480 1b 00 00 00 2f 76 61 72 2f 77 77 77 2f 74 72 69 63 6f 64 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 ..../var/www/tricode/DbClass.pyt
04a0 09 00 00 00 63 6f 6e 6e 65 63 74 44 42 14 00 00 00 73 1e 00 00 00 00 01 03 02 27 01 0c 01 12 01 ....connectDB....s........'.....
04c0 09 01 08 02 12 02 0c 01 13 02 04 01 13 02 04 02 0c 01 08 01 63 01 00 00 00 03 00 00 00 05 00 00 ....................c...........
04e0 00 43 00 00 00 73 76 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 6e 00 79 22 00 7c 00 00 6a .C...sv...|..j..d..k..rn.y".|..j
0500 01 00 6a 02 00 83 00 00 01 7c 00 00 6a 03 00 6a 02 00 83 00 00 01 64 01 00 53 57 71 72 00 04 74 ..j......|..j..j......d..SWqr..t
0520 04 00 6a 05 00 6b 0a 00 72 6a 00 01 7d 01 00 01 74 06 00 64 01 00 6b 02 00 72 66 00 74 07 00 7c ..j..k..rj..}...t..d..k..rf.t..|
0540 01 00 83 01 00 7d 02 00 7c 02 00 47 48 6e 00 00 64 02 00 53 58 6e 04 00 64 03 00 53 64 00 00 53 .....}..|..GHn..d..SXn..d..Sd..S
0560 28 04 00 00 00 4e 69 01 00 00 00 69 03 00 00 00 69 00 00 00 00 28 08 00 00 00 52 05 00 00 00 52 (....Ni....i....i....(....R....R
0580 1b 00 00 00 74 05 00 00 00 63 6c 6f 73 65 52 18 00 00 00 52 16 00 00 00 52 1c 00 00 00 52 0d 00 ....t....closeR....R....R....R..
05a0 00 00 52 1d 00 00 00 28 03 00 00 00 52 0e 00 00 00 52 1e 00 00 00 52 1f 00 00 00 28 00 00 00 00 ..R....(....R....R....R....(....
05c0 28 00 00 00 00 73 1b 00 00 00 2f 76 61 72 2f 77 77 77 2f 74 72 69 63 6f 64 65 2f 44 62 43 6c 61 (....s..../var/www/tricode/DbCla
05e0 73 73 2e 70 79 74 0b 00 00 00 63 6c 6f 73 65 44 42 43 6f 6e 6e 2b 00 00 00 73 16 00 00 00 00 02 ss.pyt....closeDBConn+...s......
0600 0f 01 03 02 0d 01 0d 01 08 01 12 02 0c 01 0c 01 08 01 08 03 63 01 00 00 00 07 00 00 00 05 00 00 ....................c...........
0620 00 43 00 00 00 73 f3 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 eb 00 79 82 00 7c 00 00 6a .C...s....|..j..d..k..r..y..|..j
0640 01 00 6a 02 00 64 02 00 83 01 00 01 7c 00 00 6a 01 00 6a 03 00 83 00 00 7d 01 00 78 4b 00 7c 01 ..j..d......|..j..j.....}..xK.|.
0660 00 44 5d 43 00 7d 02 00 74 04 00 83 00 00 7d 03 00 78 21 00 7c 02 00 44 5d 19 00 7d 04 00 7c 03 .D]C.}..t.....}..x!.|..D]..}..|.
0680 00 6a 05 00 74 06 00 7c 04 00 83 01 00 83 01 00 01 71 4e 00 57 7c 00 00 6a 07 00 6a 05 00 7c 03 .j..t..|.........qN.W|..j..j..|.
06a0 00 83 01 00 01 71 38 00 57 7c 00 00 6a 07 00 73 8c 00 64 03 00 53 64 01 00 53 57 71 ef 00 04 74 .....q8.W|..j..s..d..Sd..SWq...t
06c0 08 00 6a 09 00 6b 0a 00 72 e7 00 01 7d 05 00 01 74 06 00 7c 05 00 83 01 00 7d 06 00 7c 06 00 64 ..j..k..r...}...t..|.....}..|..d
06e0 01 00 64 04 00 21 64 05 00 6b 02 00 72 c9 00 64 06 00 53 74 0a 00 64 01 00 6b 02 00 72 e3 00 74 ..d..!d..k..r..d..St..d..k..r..t
0700 06 00 7c 05 00 83 01 00 47 48 6e 00 00 64 07 00 53 58 6e 04 00 64 03 00 53 64 00 00 53 28 08 00 ..|.....GHn..d..SXn..d..Sd..S(..
0720 00 00 4e 69 01 00 00 00 73 1b 00 00 00 53 45 4c 45 43 54 20 2a 20 46 52 4f 4d 20 54 65 6d 70 54 ..Ni....s....SELECT.*.FROM.TempT
0740 61 73 6b 54 61 62 6c 65 69 00 00 00 00 69 05 00 00 00 74 04 00 00 00 31 31 34 36 69 02 00 00 00 askTablei....i....t....1146i....
0760 69 03 00 00 00 28 0b 00 00 00 52 05 00 00 00 52 1b 00 00 00 74 07 00 00 00 65 78 65 63 75 74 65 i....(....R....R....t....execute
0780 74 08 00 00 00 66 65 74 63 68 61 6c 6c 52 06 00 00 00 74 06 00 00 00 61 70 70 65 6e 64 52 1d 00 t....fetchallR....t....appendR..
07a0 00 00 52 07 00 00 00 52 16 00 00 00 52 1c 00 00 00 52 0d 00 00 00 28 07 00 00 00 52 0e 00 00 00 ..R....R....R....R....(....R....
07c0 74 06 00 00 00 6f 75 74 70 75 74 74 06 00 00 00 72 65 63 6f 72 64 74 07 00 00 00 63 6f 6c 75 6d t....outputt....recordt....colum
07e0 6e 73 74 05 00 00 00 65 6e 74 72 79 52 1e 00 00 00 52 1f 00 00 00 28 00 00 00 00 28 00 00 00 00 nst....entryR....R....(....(....
0800 73 1b 00 00 00 2f 76 61 72 2f 77 77 77 2f 74 72 69 63 6f 64 65 2f 44 62 43 6c 61 73 73 2e 70 79 s..../var/www/tricode/DbClass.py
0820 74 0c 00 00 00 61 6e 79 54 61 73 6b 73 54 6f 44 6f 3d 00 00 00 73 28 00 00 00 00 02 0f 01 03 01 t....anyTasksToDo=...s(.........
0840 10 01 0f 04 0d 01 09 01 0d 01 17 02 14 02 09 01 04 02 08 01 12 01 0c 01 13 01 04 01 0c 01 0e 01 ................................
0860 08 02 63 01 00 00 00 01 00 00 00 02 00 00 00 43 00 00 00 73 22 00 00 00 7c 00 00 6a 00 00 64 01 ..c............C...s"...|..j..d.
0880 00 6b 02 00 72 1a 00 7c 00 00 6a 01 00 32 64 01 00 53 64 02 00 53 64 00 00 53 28 03 00 00 00 4e .k..r..|..j..2d..Sd..Sd..S(....N
08a0 69 01 00 00 00 69 00 00 00 00 28 02 00 00 00 52 05 00 00 00 52 07 00 00 00 28 01 00 00 00 52 0e i....i....(....R....R....(....R.
08c0 00 00 00 28 00 00 00 00 28 00 00 00 00 73 1b 00 00 00 2f 76 61 72 2f 77 77 77 2f 74 72 69 63 6f ...(....(....s..../var/www/trico
08e0 64 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 0e 00 00 00 63 6c 65 61 6e 54 61 73 6b 73 4c 69 73 74 de/DbClass.pyt....cleanTasksList
0900 5b 00 00 00 73 08 00 00 00 00 01 0f 01 07 01 04 02 63 02 00 00 00 0a 00 00 00 05 00 00 00 43 00 [...s............c............C.
0920 00 00 73 e7 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 df 00 79 76 00 7c 00 00 6a 01 00 6a ..s....|..j..d..k..r..yv.|..j..j
0940 02 00 64 02 00 7c 01 00 83 02 00 7d 02 00 7c 00 00 6a 01 00 6a 03 00 83 00 00 7d 03 00 64 03 00 ..d..|.....}..|..j..j.....}..d..
0960 7d 04 00 78 41 00 7c 03 00 44 5d 39 00 7d 05 00 74 04 00 83 00 00 7d 06 00 78 21 00 7c 05 00 44 }..xA.|..D]9.}..t.....}..x!.|..D
0980 5d 19 00 7d 07 00 7c 06 00 6a 05 00 74 06 00 7c 07 00 83 01 00 83 01 00 01 71 59 00 57 7c 06 00 ]..}..|..j..t..|.........qY.W|..
09a0 7d 04 00 71 43 00 57 7c 04 00 53 57 71 e3 00 04 74 07 00 6a 08 00 6b 0a 00 72 db 00 01 7d 08 00 }..qC.W|..SWq...t..j..k..r...}..
09c0 01 74 06 00 7c 08 00 83 01 00 7d 09 00 7c 09 00 64 01 00 64 04 00 21 64 05 00 6b 02 00 72 bd 00 .t..|.....}..|..d..d..!d..k..r..
09e0 64 06 00 53 74 09 00 64 01 00 6b 02 00 72 d7 00 74 06 00 7c 08 00 83 01 00 47 48 6e 00 00 64 07 d..St..d..k..r..t..|.....GHn..d.
0a00 00 53 58 6e 04 00 64 08 00 53 64 00 00 53 28 09 00 00 00 4e 69 01 00 00 00 73 6a 00 00 00 53 45 .SXn..d..Sd..S(....Ni....sj...SE
0a20 4c 45 43 54 20 60 70 6f 72 74 4e 61 6d 65 60 2c 60 6e 75 6d 62 65 72 60 2c 20 60 75 73 65 72 6e LECT.`portName`,`number`,.`usern
0a40 61 6d 65 60 2c 20 60 70 61 73 73 77 6f 72 64 60 2c 20 60 73 65 72 76 65 72 60 20 46 52 4f 4d 20 ame`,.`password`,.`server`.FROM.
0a60 44 65 76 69 63 65 41 64 64 72 65 73 73 54 61 62 6c 65 20 77 68 65 72 65 20 60 64 65 76 69 63 65 DeviceAddressTable.where.`device
0a80 4e 61 6d 65 60 3d 25 73 74 00 00 00 00 69 05 00 00 00 52 23 00 00 00 69 02 00 00 00 69 03 00 00 Name`=%st....i....R#...i....i...
0aa0 00 69 00 00 00 00 28 0a 00 00 00 52 05 00 00 00 52 1b 00 00 00 52 24 00 00 00 52 25 00 00 00 52 .i....(....R....R....R$...R%...R
0ac0 06 00 00 00 52 26 00 00 00 52 1d 00 00 00 52 16 00 00 00 52 1c 00 00 00 52 0d 00 00 00 28 0a 00 ....R&...R....R....R....R....(..
0ae0 00 00 52 0e 00 00 00 74 0a 00 00 00 64 65 76 69 63 65 4e 61 6d 65 74 0a 00 00 00 73 75 63 63 65 ..R....t....deviceNamet....succe
0b00 73 73 66 75 6c 52 27 00 00 00 74 0a 00 00 00 64 65 76 69 63 65 41 64 64 72 52 28 00 00 00 52 29 ssfulR'...t....deviceAddrR(...R)
0b20 00 00 00 52 2a 00 00 00 52 1e 00 00 00 52 1f 00 00 00 28 00 00 00 00 28 00 00 00 00 73 1b 00 00 ...R*...R....R....(....(....s...
0b40 00 2f 76 61 72 2f 77 77 77 2f 74 72 69 63 6f 64 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 0d 00 00 ./var/www/tricode/DbClass.pyt...
0b60 00 64 65 76 69 63 65 41 64 64 72 65 73 73 63 00 00 00 73 26 00 00 00 00 01 0f 01 03 01 15 01 0f .deviceAddressc...s&............
0b80 01 06 01 0d 01 09 01 0d 01 17 01 0a 02 08 01 12 01 0c 01 13 01 04 01 0c 01 0e 01 08 02 63 04 00 .............................c..
0ba0 00 00 06 00 00 00 05 00 00 00 43 00 00 00 73 80 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 ..........C...s....|..j..d..k..r
0bc0 78 00 79 32 00 64 02 00 7c 02 00 17 64 03 00 17 7c 03 00 17 64 04 00 17 7c 01 00 17 64 05 00 17 x.y2.d..|...d...|...d...|...d...
0be0 7d 04 00 7c 00 00 6a 01 00 6a 02 00 7c 04 00 83 01 00 01 57 71 7c 00 04 74 03 00 6a 04 00 6b 0a }..|..j..j..|......Wq|..t..j..k.
0c00 00 72 74 00 01 7d 05 00 01 74 05 00 64 01 00 6b 02 00 72 70 00 74 06 00 7c 05 00 83 01 00 47 48 .rt..}...t..d..k..rp.t..|.....GH
0c20 6e 00 00 64 06 00 53 58 6e 04 00 64 07 00 53 64 00 00 53 28 08 00 00 00 4e 69 01 00 00 00 73 2b n..d..SXn..d..Sd..S(....Ni....s+
0c40 00 00 00 55 50 44 41 54 45 20 44 65 76 69 63 65 41 64 64 72 65 73 73 54 61 62 6c 65 20 53 45 54 ...UPDATE.DeviceAddressTable.SET
0c60 20 20 70 6f 72 74 4e 61 6d 65 20 3d 20 27 73 0d 00 00 00 27 2c 20 6e 75 6d 62 65 72 20 3d 20 27 ..portName.=.'s....',.number.=.'
0c80 73 17 00 00 00 27 20 57 48 45 52 45 20 20 64 65 76 69 63 65 4e 61 6d 65 20 3d 20 27 74 01 00 00 s....'.WHERE..deviceName.=.'t...
0ca0 00 27 69 03 00 00 00 69 00 00 00 00 28 07 00 00 00 52 05 00 00 00 52 1b 00 00 00 52 24 00 00 00 .'i....i....(....R....R....R$...
0cc0 52 16 00 00 00 52 1c 00 00 00 52 0d 00 00 00 52 1d 00 00 00 28 06 00 00 00 52 0e 00 00 00 52 2e R....R....R....R....(....R....R.
0ce0 00 00 00 74 0b 00 00 00 6e 65 77 50 6f 72 74 4e 61 6d 65 74 09 00 00 00 6e 65 77 4e 75 6d 62 65 ...t....newPortNamet....newNumbe
0d00 72 74 04 00 00 00 73 74 6d 74 52 1e 00 00 00 28 00 00 00 00 28 00 00 00 00 73 1b 00 00 00 2f 76 rt....stmtR....(....(....s..../v
0d20 61 72 2f 77 77 77 2f 74 72 69 63 6f 64 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 0f 00 00 00 75 70 ar/www/tricode/DbClass.pyt....up
0d40 64 61 74 65 47 53 4d 44 65 76 69 63 65 7a 00 00 00 73 12 00 00 00 00 01 0f 01 03 01 1e 01 14 02 dateGSMDevicez...s..............
0d60 12 01 0c 01 0e 01 08 02 63 07 00 00 00 0a 00 00 00 09 00 00 00 43 00 00 00 73 d5 00 00 00 7c 00 ........c............C...s....|.
0d80 00 6a 00 00 64 01 00 6b 02 00 72 cd 00 79 87 00 7c 00 00 6a 01 00 6a 02 00 64 02 00 74 03 00 7c .j..d..k..r..y..|..j..j..d..t..|
0da0 02 00 83 01 00 74 03 00 7c 03 00 83 01 00 74 03 00 7c 04 00 83 01 00 74 03 00 7c 05 00 83 01 00 .....t..|.....t..|.....t..|.....
0dc0 74 03 00 7c 06 00 83 01 00 74 03 00 7c 01 00 83 01 00 66 06 00 16 83 01 00 7d 07 00 7c 00 00 6a t..|.....t..|.....f......}..|..j
0de0 01 00 6a 04 00 83 00 00 7d 08 00 74 05 00 64 01 00 6b 02 00 72 81 00 7c 08 00 47 48 6e 00 00 7c ..j.....}..t..d..k..r..|..GHn..|
0e00 07 00 64 03 00 6b 02 00 72 91 00 64 01 00 53 64 04 00 53 57 71 d1 00 04 74 06 00 6a 07 00 6b 0a ..d..k..r..d..Sd..SWq...t..j..k.
0e20 00 72 c9 00 01 7d 09 00 01 74 05 00 64 01 00 6b 02 00 72 c5 00 74 08 00 7c 09 00 83 01 00 47 48 .r...}...t..d..k..r..t..|.....GH
0e40 6e 00 00 64 05 00 53 58 6e 04 00 64 03 00 53 64 00 00 53 28 06 00 00 00 4e 69 01 00 00 00 73 66 n..d..SXn..d..Sd..S(....Ni....sf
0e60 00 00 00 55 50 44 41 54 45 20 50 69 6e 67 52 65 73 75 6c 74 54 61 62 6c 65 20 53 45 54 20 73 69 ...UPDATE.PingResultTable.SET.si
0e80 70 53 65 72 76 65 72 3d 25 69 2c 20 73 69 70 47 61 74 65 3d 25 69 2c 20 75 6e 69 73 69 70 3d 25 pServer=%i,.sipGate=%i,.unisip=%
0ea0 69 2c 20 67 73 6d 42 6f 78 31 3d 25 69 2c 20 67 73 6d 42 6f 78 32 3d 25 69 20 57 48 45 52 45 20 i,.gsmBox1=%i,.gsmBox2=%i.WHERE.
0ec0 74 61 73 6b 4e 6f 3d 25 69 69 00 00 00 00 69 04 00 00 00 69 03 00 00 00 28 09 00 00 00 52 05 00 taskNo=%ii....i....i....(....R..
0ee0 00 00 52 1b 00 00 00 52 24 00 00 00 74 03 00 00 00 69 6e 74 74 08 00 00 00 66 65 74 63 68 6f 6e ..R....R$...t....intt....fetchon
0f00 65 52 0d 00 00 00 52 16 00 00 00 52 1c 00 00 00 52 1d 00 00 00 28 0a 00 00 00 52 0e 00 00 00 74 eR....R....R....R....(....R....t
0f20 06 00 00 00 74 61 73 6b 4e 6f 74 09 00 00 00 73 69 70 53 65 72 76 65 72 74 07 00 00 00 73 69 70 ....taskNot....sipServert....sip
0f40 47 61 74 65 74 06 00 00 00 75 6e 69 73 69 70 74 07 00 00 00 67 73 6d 42 6f 78 31 74 07 00 00 00 Gatet....unisipt....gsmBox1t....
0f60 67 73 6d 42 6f 78 32 52 2f 00 00 00 52 27 00 00 00 52 1e 00 00 00 28 00 00 00 00 28 00 00 00 00 gsmBox2R/...R'...R....(....(....
0f80 73 1b 00 00 00 2f 76 61 72 2f 77 77 77 2f 74 72 69 63 6f 64 65 2f 44 62 43 6c 61 73 73 2e 70 79 s..../var/www/tricode/DbClass.py
0fa0 74 10 00 00 00 75 70 64 61 74 65 50 69 6e 67 52 65 73 75 6c 74 87 00 00 00 73 1c 00 00 00 00 01 t....updatePingResult....s......
0fc0 0f 01 03 01 4c 01 0f 02 0c 01 08 01 0c 01 04 02 08 03 12 01 0c 01 0e 01 08 02 63 02 00 00 00 05 ....L.....................c.....
0fe0 00 00 00 05 00 00 00 43 00 00 00 73 a5 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 9d 00 79 .......C...s....|..j..d..k..r..y
1000 57 00 7c 00 00 6a 01 00 6a 02 00 64 02 00 74 03 00 7c 01 00 83 01 00 16 83 01 00 7d 02 00 7c 00 W.|..j..j..d..t..|.........}..|.
1020 00 6a 01 00 6a 04 00 83 00 00 7d 03 00 74 05 00 64 01 00 6b 02 00 72 51 00 7c 03 00 47 48 6e 00 .j..j.....}..t..d..k..rQ.|..GHn.
1040 00 7c 02 00 64 01 00 6b 02 00 72 61 00 64 01 00 53 64 03 00 53 57 71 a1 00 04 74 06 00 6a 07 00 .|..d..k..ra.d..Sd..SWq...t..j..
1060 6b 0a 00 72 99 00 01 7d 04 00 01 74 05 00 64 01 00 6b 02 00 72 95 00 74 08 00 7c 04 00 83 01 00 k..r...}...t..d..k..r..t..|.....
1080 47 48 6e 00 00 64 04 00 53 58 6e 04 00 64 05 00 53 64 00 00 53 28 06 00 00 00 4e 69 01 00 00 00 GHn..d..SXn..d..Sd..S(....Ni....
10a0 73 29 00 00 00 44 45 4c 45 54 45 20 46 52 4f 4d 20 54 65 6d 70 54 61 73 6b 54 61 62 6c 65 20 57 s)...DELETE.FROM.TempTaskTable.W
10c0 48 45 52 45 20 74 61 73 6b 49 44 3d 25 69 69 04 00 00 00 69 03 00 00 00 69 00 00 00 00 28 09 00 HERE.taskID=%ii....i....i....(..
10e0 00 00 52 05 00 00 00 52 1b 00 00 00 52 24 00 00 00 52 37 00 00 00 52 38 00 00 00 52 0d 00 00 00 ..R....R....R$...R7...R8...R....
1100 52 16 00 00 00 52 1c 00 00 00 52 1d 00 00 00 28 05 00 00 00 52 0e 00 00 00 74 06 00 00 00 74 61 R....R....R....(....R....t....ta
1120 73 6b 49 44 52 2f 00 00 00 52 27 00 00 00 52 1e 00 00 00 28 00 00 00 00 28 00 00 00 00 73 1b 00 skIDR/...R'...R....(....(....s..
1140 00 00 2f 76 61 72 2f 77 77 77 2f 74 72 69 63 6f 64 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 0e 00 ../var/www/tricode/DbClass.pyt..
1160 00 00 64 65 6c 65 74 65 54 65 6d 70 54 61 73 6b 9c 00 00 00 73 1c 00 00 00 00 01 0f 01 03 01 1c ..deleteTempTask....s...........
1180 01 0f 02 0c 01 08 02 0c 01 04 02 08 01 12 01 0c 01 0e 01 08 03 63 03 00 00 00 07 00 00 00 05 00 .....................c..........
11a0 00 00 43 00 00 00 73 d4 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 cc 00 79 63 00 7c 00 00 ..C...s....|..j..d..k..r..yc.|..
11c0 6a 01 00 6a 02 00 64 02 00 74 03 00 7c 01 00 83 01 00 74 03 00 7c 02 00 83 01 00 66 02 00 16 83 j..j..d..t..|.....t..|.....f....
11e0 01 00 7d 03 00 7c 00 00 6a 01 00 6a 04 00 83 00 00 7d 04 00 74 05 00 64 01 00 6b 02 00 72 5d 00 ..}..|..j..j.....}..t..d..k..r].
1200 7c 04 00 47 48 6e 00 00 7c 03 00 64 01 00 6b 02 00 72 6d 00 64 01 00 53 64 03 00 53 57 71 d0 00 |..GHn..|..d..k..rm.d..Sd..SWq..
1220 04 74 06 00 6a 07 00 6b 0a 00 72 c8 00 01 7d 05 00 01 74 08 00 7c 05 00 83 01 00 7d 06 00 7c 06 .t..j..k..r...}...t..|.....}..|.
1240 00 64 01 00 64 04 00 21 64 05 00 6b 02 00 72 aa 00 64 06 00 53 74 05 00 64 01 00 6b 02 00 72 c4 .d..d..!d..k..r..d..St..d..k..r.
1260 00 74 08 00 7c 05 00 83 01 00 47 48 6e 00 00 64 07 00 53 58 6e 04 00 64 08 00 53 64 00 00 53 28 .t..|.....GHn..d..SXn..d..Sd..S(
1280 09 00 00 00 4e 69 01 00 00 00 73 3b 00 00 00 49 4e 53 45 52 54 20 49 4e 54 4f 20 52 65 73 75 6c ....Ni....s;...INSERT.INTO.Resul
12a0 74 54 61 62 6c 65 28 74 61 73 6b 49 44 2c 20 72 65 73 75 6c 74 29 20 56 41 4c 55 45 53 20 28 27 tTable(taskID,.result).VALUES.('
12c0 25 69 27 2c 20 27 25 69 27 29 69 04 00 00 00 69 05 00 00 00 74 04 00 00 00 31 30 36 32 69 02 00 %i',.'%i')i....i....t....1062i..
12e0 00 00 69 03 00 00 00 69 00 00 00 00 28 09 00 00 00 52 05 00 00 00 52 1b 00 00 00 52 24 00 00 00 ..i....i....(....R....R....R$...
1300 52 37 00 00 00 52 38 00 00 00 52 0d 00 00 00 52 16 00 00 00 52 1c 00 00 00 52 1d 00 00 00 28 07 R7...R8...R....R....R....R....(.
1320 00 00 00 52 0e 00 00 00 52 40 00 00 00 74 06 00 00 00 72 65 73 75 6c 74 52 2f 00 00 00 52 27 00 ...R....R@...t....resultR/...R'.
1340 00 00 52 1e 00 00 00 52 1f 00 00 00 28 00 00 00 00 28 00 00 00 00 73 1b 00 00 00 2f 76 61 72 2f ..R....R....(....(....s..../var/
1360 77 77 77 2f 74 72 69 63 6f 64 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 09 00 00 00 61 64 64 52 65 www/tricode/DbClass.pyt....addRe
1380 73 75 6c 74 b1 00 00 00 73 22 00 00 00 00 01 0f 01 03 01 28 01 0f 02 0c 01 08 01 0c 01 04 02 08 sult....s".........(............
13a0 01 12 01 0c 01 13 01 04 01 0c 01 0e 01 08 02 63 02 00 00 00 06 00 00 00 05 00 00 00 43 00 00 00 ...............c............C...
13c0 73 ad 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 a5 00 79 3c 00 7c 00 00 6a 01 00 6a 02 00 s....|..j..d..k..r..y<.|..j..j..
13e0 64 02 00 7c 01 00 83 02 00 7d 02 00 7c 00 00 6a 01 00 6a 03 00 83 00 00 7d 03 00 7c 03 00 64 03 d..|.....}..|..j..j.....}..|..d.
1400 00 19 7c 00 00 5f 04 00 7c 00 00 6a 04 00 53 57 71 a9 00 04 74 05 00 6a 06 00 6b 0a 00 72 a1 00 ..|.._..|..j..SWq...t..j..k..r..
1420 01 7d 04 00 01 74 07 00 7c 04 00 83 01 00 7d 05 00 7c 05 00 64 01 00 64 04 00 21 64 05 00 6b 02 .}...t..|.....}..|..d..d..!d..k.
1440 00 72 83 00 64 06 00 53 74 08 00 64 01 00 6b 02 00 72 9d 00 74 07 00 7c 04 00 83 01 00 47 48 6e .r..d..St..d..k..r..t..|.....GHn
1460 00 00 64 07 00 53 58 6e 04 00 64 03 00 53 64 00 00 53 28 08 00 00 00 4e 69 01 00 00 00 73 3b 00 ..d..SXn..d..Sd..S(....Ni....s;.
1480 00 00 53 45 4c 45 43 54 20 64 65 73 63 72 69 70 74 69 6f 6e 20 46 52 4f 4d 20 45 72 72 6f 72 43 ..SELECT.description.FROM.ErrorC
14a0 6f 64 65 54 61 62 6c 65 20 77 68 65 72 65 20 60 65 72 72 6f 72 63 6f 64 65 60 3d 25 73 69 00 00 odeTable.where.`errorcode`=%si..
14c0 00 00 69 05 00 00 00 52 23 00 00 00 69 02 00 00 00 69 03 00 00 00 28 09 00 00 00 52 05 00 00 00 ..i....R#...i....i....(....R....
14e0 52 1b 00 00 00 52 24 00 00 00 52 38 00 00 00 52 0a 00 00 00 52 16 00 00 00 52 1c 00 00 00 52 1d R....R$...R8...R....R....R....R.
1500 00 00 00 52 0d 00 00 00 28 06 00 00 00 52 0e 00 00 00 74 04 00 00 00 63 6f 64 65 52 2f 00 00 00 ...R....(....R....t....codeR/...
1520 74 04 00 00 00 64 61 74 61 52 1e 00 00 00 52 1f 00 00 00 28 00 00 00 00 28 00 00 00 00 73 1b 00 t....dataR....R....(....(....s..
1540 00 00 2f 76 61 72 2f 77 77 77 2f 74 72 69 63 6f 64 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 09 00 ../var/www/tricode/DbClass.pyt..
1560 00 00 65 72 72 6f 72 43 6f 64 65 c8 00 00 00 73 1c 00 00 00 00 01 0f 01 03 01 15 01 0f 01 0d 01 ..errorCode....s................
1580 0b 02 12 01 0c 01 13 01 04 01 0c 01 0e 01 08 02 63 02 00 00 00 07 00 00 00 05 00 00 00 43 00 00 ................c............C..
15a0 00 73 21 01 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 19 01 79 b0 00 7c 00 00 6a 01 00 6a 02 .s!...|..j..d..k..r..y..|..j..j.
15c0 00 64 02 00 83 01 00 7d 02 00 7c 00 00 6a 01 00 6a 03 00 83 00 00 7d 03 00 7c 03 00 64 03 00 19 .d.....}..|..j..j.....}..|..d...
15e0 64 01 00 6b 02 00 72 a6 00 7c 00 00 6a 01 00 6a 02 00 64 04 00 74 04 00 7c 01 00 83 01 00 16 83 d..k..r..|..j..j..d..t..|.......
1600 01 00 7d 02 00 7c 00 00 6a 01 00 6a 03 00 83 00 00 7d 04 00 7c 04 00 64 03 00 19 64 01 00 6b 02 ..}..|..j..j.....}..|..d...d..k.
1620 00 72 8b 00 64 01 00 7c 00 00 5f 05 00 64 01 00 53 7c 04 00 64 03 00 19 64 03 00 6b 02 00 72 9f .r..d..|.._..d..S|..d...d..k..r.
1640 00 64 05 00 53 64 06 00 53 6e 18 00 7c 03 00 64 03 00 19 64 03 00 6b 02 00 72 ba 00 64 07 00 53 .d..Sd..Sn..|..d...d..k..r..d..S
1660 64 08 00 53 57 71 1d 01 04 74 06 00 6a 07 00 6b 0a 00 72 15 01 01 7d 05 00 01 74 08 00 7c 05 00 d..SWq...t..j..k..r...}...t..|..
1680 83 01 00 7d 06 00 7c 06 00 64 01 00 64 08 00 21 64 09 00 6b 02 00 72 f7 00 64 0a 00 53 74 09 00 ...}..|..d..d..!d..k..r..d..St..
16a0 64 01 00 6b 02 00 72 11 01 74 08 00 7c 05 00 83 01 00 47 48 6e 00 00 64 0b 00 53 58 6e 04 00 64 d..k..r..t..|.....GHn..d..SXn..d
16c0 03 00 53 64 00 00 53 28 0c 00 00 00 4e 69 01 00 00 00 73 26 00 00 00 53 45 4c 45 43 54 20 49 53 ..Sd..S(....Ni....s&...SELECT.IS
16e0 5f 46 52 45 45 5f 4c 4f 43 4b 28 27 53 6f 66 74 77 61 72 65 53 74 61 72 74 65 64 27 29 69 00 00 _FREE_LOCK('SoftwareStarted')i..
1700 00 00 73 26 00 00 00 53 45 4c 45 43 54 20 47 45 54 5f 4c 4f 43 4b 28 27 53 6f 66 74 77 61 72 65 ..s&...SELECT.GET_LOCK('Software
1720 53 74 61 72 74 65 64 27 2c 20 25 69 29 69 07 00 00 00 69 06 00 00 00 69 04 00 00 00 69 05 00 00 Started',.%i)i....i....i....i...
1740 00 52 42 00 00 00 69 02 00 00 00 69 03 00 00 00 28 0a 00 00 00 52 05 00 00 00 52 1b 00 00 00 52 .RB...i....i....(....R....R....R
1760 24 00 00 00 52 38 00 00 00 52 37 00 00 00 52 0b 00 00 00 52 16 00 00 00 52 1c 00 00 00 52 1d 00 $...R8...R7...R....R....R....R..
1780 00 00 52 0d 00 00 00 28 07 00 00 00 52 0e 00 00 00 74 07 00 00 00 73 65 63 6f 6e 64 73 52 2f 00 ..R....(....R....t....secondsR/.
17a0 00 00 52 27 00 00 00 74 07 00 00 00 6f 75 74 70 75 74 31 52 1e 00 00 00 52 1f 00 00 00 28 00 00 ..R'...t....output1R....R....(..
17c0 00 00 28 00 00 00 00 73 1b 00 00 00 2f 76 61 72 2f 77 77 77 2f 74 72 69 63 6f 64 65 2f 44 62 43 ..(....s..../var/www/tricode/DbC
17e0 6c 61 73 73 2e 70 79 74 09 00 00 00 6c 6f 63 6b 4d 75 74 65 78 da 00 00 00 73 30 00 00 00 00 01 lass.pyt....lockMutex....s0.....
1800 0f 01 03 01 12 01 0f 01 10 02 1c 02 0f 01 10 02 09 01 04 01 10 01 04 02 07 01 10 01 04 03 08 01 ................................
1820 12 01 0c 01 13 01 04 01 0c 01 0e 01 08 02 63 01 00 00 00 06 00 00 00 05 00 00 00 43 00 00 00 73 ..............c............C...s
1840 36 01 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 2e 01 79 c5 00 7c 00 00 6a 01 00 64 01 00 6b 6...|..j..d..k..r..y..|..j..d..k
1860 02 00 72 cf 00 7c 00 00 6a 02 00 6a 03 00 64 02 00 83 01 00 7d 01 00 7c 00 00 6a 02 00 6a 04 00 ..r..|..j..j..d.....}..|..j..j..
1880 83 00 00 7d 02 00 7c 02 00 64 03 00 19 64 01 00 6b 02 00 72 5f 00 64 03 00 7c 00 00 5f 01 00 64 ...}..|..d...d..k..r_.d..|.._..d
18a0 04 00 53 7c 02 00 64 03 00 19 64 03 00 6b 02 00 72 c8 00 7c 00 00 6a 02 00 6a 03 00 64 05 00 83 ..S|..d...d..k..r..|..j..j..d...
18c0 01 00 7d 01 00 7c 00 00 6a 02 00 6a 04 00 83 00 00 7d 03 00 64 03 00 7c 00 00 5f 01 00 7c 03 00 ..}..|..j..j.....}..d..|.._..|..
18e0 64 03 00 19 64 01 00 6b 02 00 72 ad 00 64 01 00 53 7c 03 00 64 03 00 19 64 03 00 6b 02 00 72 c1 d...d..k..r..d..S|..d...d..k..r.
1900 00 64 06 00 53 64 07 00 53 71 d3 00 64 06 00 53 6e 04 00 64 08 00 53 57 71 32 01 04 74 05 00 6a .d..Sd..Sq..d..Sn..d..SWq2..t..j
1920 06 00 6b 0a 00 72 2a 01 01 7d 04 00 01 74 07 00 7c 04 00 83 01 00 7d 05 00 7c 05 00 64 01 00 64 ..k..r*..}...t..|.....}..|..d..d
1940 06 00 21 64 09 00 6b 02 00 72 0c 01 64 0a 00 53 74 08 00 64 01 00 6b 02 00 72 26 01 74 07 00 7c ..!d..k..r..d..St..d..k..r&.t..|
1960 04 00 83 01 00 47 48 6e 00 00 64 0b 00 53 58 6e 04 00 64 03 00 53 64 00 00 53 28 0c 00 00 00 4e .....GHn..d..SXn..d..Sd..S(....N
1980 69 01 00 00 00 73 26 00 00 00 53 45 4c 45 43 54 20 49 53 5f 46 52 45 45 5f 4c 4f 43 4b 28 27 53 i....s&...SELECT.IS_FREE_LOCK('S
19a0 6f 66 74 77 61 72 65 53 74 61 72 74 65 64 27 29 69 00 00 00 00 69 04 00 00 00 73 26 00 00 00 53 oftwareStarted')i....i....s&...S
19c0 45 4c 45 43 54 20 52 45 4c 45 41 53 45 5f 4c 4f 43 4b 28 27 53 6f 66 74 77 61 72 65 53 74 61 72 ELECT.RELEASE_LOCK('SoftwareStar
19e0 74 65 64 27 29 69 05 00 00 00 69 06 00 00 00 69 07 00 00 00 52 42 00 00 00 69 02 00 00 00 69 03 ted')i....i....i....RB...i....i.
1a00 00 00 00 28 09 00 00 00 52 05 00 00 00 52 0b 00 00 00 52 1b 00 00 00 52 24 00 00 00 52 38 00 00 ...(....R....R....R....R$...R8..
1a20 00 52 16 00 00 00 52 1c 00 00 00 52 1d 00 00 00 52 0d 00 00 00 28 06 00 00 00 52 0e 00 00 00 52 .R....R....R....R....(....R....R
1a40 2f 00 00 00 52 27 00 00 00 52 49 00 00 00 52 1e 00 00 00 52 1f 00 00 00 28 00 00 00 00 28 00 00 /...R'...RI...R....R....(....(..
1a60 00 00 73 1b 00 00 00 2f 76 61 72 2f 77 77 77 2f 74 72 69 63 6f 64 65 2f 44 62 43 6c 61 73 73 2e ..s..../var/www/tricode/DbClass.
1a80 70 79 74 0c 00 00 00 72 65 6c 65 61 73 65 4d 75 74 65 78 fb 00 00 00 73 36 00 00 00 00 01 0f 01 pyt....releaseMutex....s6.......
1aa0 03 01 0f 01 12 01 0f 01 10 02 09 01 04 02 10 03 12 01 0f 01 09 01 10 02 04 02 10 02 04 03 07 04 ................................
1ac0 07 03 08 02 12 01 0c 01 13 01 04 01 0c 01 0e 01 08 02 28 0f 00 00 00 74 08 00 00 00 5f 5f 6e 61 ..................(....t....__na
1ae0 6d 65 5f 5f 74 0a 00 00 00 5f 5f 6d 6f 64 75 6c 65 5f 5f 52 12 00 00 00 52 20 00 00 00 52 22 00 me__t....__module__R....R....R".
1b00 00 00 52 2b 00 00 00 52 2c 00 00 00 52 31 00 00 00 52 36 00 00 00 52 3f 00 00 00 52 41 00 00 00 ..R+...R,...R1...R6...R?...RA...
1b20 52 44 00 00 00 52 47 00 00 00 52 4a 00 00 00 52 4b 00 00 00 28 00 00 00 00 28 00 00 00 00 28 00 RD...RG...RJ...RK...(....(....(.
1b40 00 00 00 73 1b 00 00 00 2f 76 61 72 2f 77 77 77 2f 74 72 69 63 6f 64 65 2f 44 62 43 6c 61 73 73 ...s..../var/www/tricode/DbClass
1b60 2e 70 79 52 00 00 00 00 04 00 00 00 73 1a 00 00 00 06 01 09 0f 09 17 09 12 09 1e 09 08 09 17 09 .pyR........s...................
1b80 0d 09 15 09 15 09 17 09 12 09 21 28 00 00 00 00 28 03 00 00 00 52 16 00 00 00 74 06 00 00 00 73 ..........!(....(....R....t....s
1ba0 74 72 69 6e 67 52 00 00 00 00 28 00 00 00 00 28 00 00 00 00 28 00 00 00 00 73 1b 00 00 00 2f 76 tringR....(....(....(....s..../v
1bc0 61 72 2f 77 77 77 2f 74 72 69 63 6f 64 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 08 00 00 00 3c 6d ar/www/tricode/DbClass.pyt....<m
1be0 6f 64 75 6c 65 3e 01 00 00 00 73 04 00 00 00 0c 01 0c 02 odule>....s........