Posted to tcl by Vadtec at Wed May 09 04:23:22 GMT 2007view raw

  1. sqlite> select id, domain, ip, longip from domain order by id;
  2. id domain ip longip
  3. ---------- ---------------------- ------------ ----------
  4. 1 you.cant.be.vadtec.net 72.20.27.122 1209277306
  5. 2 you.cant.be.vadtec.net 72.20.27.122 1209277306
  6. 3 you.cant.be.vadtec.net 72.20.27.122 1209277306
  7. 4 you.cant.be.vadtec.net 72.20.27.122 1209277306
  8. 5 you.cant.be.vadtec.net 72.20.27.122 1209277306
  9. 6 you.cant.be.vadtec.net 72.20.27.122 1209277306
  10. 7 i.am.so.s3xy.de 72.20.33.222 1209278942
  11. 8 host130-121.pool80182.
  12. 9 217-20-120-56.internet 66.254.109.1 1123970445
  13. 10 stone7.plus.com 84.92.244.13 1415378051
  14. 11 jo0.got.pwnd.in.jo0r.n 72.20.55.193 1209284545
  15. 12 encrypted.de 204.8.223.18 -871833674
  16. 13 4x4jeep.net 72.20.17.3 1209274627
  17. 14 ddos.jp 72.20.16.29 1209274397
  18. 15 cesur.net 72.20.46.25 1209282073
  19. 16 voodoohosting-71D7CEA6
  20. 17 so-1-0-0.oc192.manches 72.20.42.253 1209281277
  21. 18 136F2BCC.E4BFB21C.E829
  22. 19 need.some.more-weed.ne 72.20.35.144 1209279376
  23. 20 need.some.more-weed.ne 72.20.35.144 1209279376
  24. 21 voodoohosting-E76D926B
  25. 22 voodoohosting-71D7CEA6
  26. 23 this-server.has-no-ip. 72.20.41.203 1209280971
  27. 24 207.255.135.122 207.255.135. -805337222
  28. 25 bnshells.net 72.20.5.18 1209271570
  29. 26 OverLord.NormalPeopleH 72.20.40.124 1209280636
  30. 27 always.here.with-me.or 72.20.32.76 1209278540
  31. 28 85-210-180-208.dsl.pip 85.210.180.2 1439872208
  32. 29 72.37.175.2 72.37.175.2 1210429186
  33. 30 c-75-67-212-35.hsd1.ma 75.67.212.35 1262736419
  34. 31 34.33.88.65.cust.cfl.r 34.33.88.65. 572610625
  35. 32 pc-1007.ds5.tuniv.szcz
  36. 33 cpe-238-108-31-26.nyc.
  37. 34 207.255.135.122 207.255.135. -805337222
  38. 35 170-201.82-139.bia.tkb
  39. 36 cpe-67-9-85-210.hot.re 67.9.85.210 1124685266
  40. 37 kablenet.hu
  41. 38 netadmin.voodoohosting
  42. 39 voodoohosting-842A210F
  43. 40 4270D75.3DB7DEFD.8B266
  44. 41 voodoohosting-97AC4147
  45. 42 sofakingwetodded.info 72.20.42.222 1209281246
  46. 43 voodoohosting-C2C6BE02
  47. 44 gawd.biz 69.31.73.217 1159678425
  48. 45 voodoohosting-EFD26719
  49. 46 clj6-170.dial-up.arnez
  50. 47 cq253.internetdsl.tpgn
  51. 48 voodoohosting-FAF59B8E
  52. 49 200.66.1.135 200.66.1.135 -935198329
  53. 50 flameboy.org 72.20.34.185 1209279161
  54. 51 200.77.126.82 200.77.126.8 -934445486
  55. 52 cesur.net 72.20.46.25 1209282073
  56. 53 netadmin.voodoohosting
  57. 54 adsl-154-35-207.asm.be 68.154.35.20 1150952399
  58. 55 2001:618:400:346a:1337 2001:618:400 0
  59. 56 olimp.troep.net.pl
  60. 57 voodoohosting-927BBF44
  61. 58 voodoohosting-865B51D7
  62. 59 voodoohosting-7036AA6B
  63. 60 ip-188-252.sn1.eutelli
  64. 61 cpe-76-49-216-115.buff 76.49.216.11 1278335091
  65. 62 blackhat-hosting.com 72.20.51.199 1209283527
  66. 63 blackhat-hosting.com 72.20.51.199 1209283527
  67. 64 hax0rs.info 72.20.51.193 1209283521
  68. 65 dirty.south.solj.us 72.20.42.124 1209281148
  69. 66 dirty.south.solj.us 72.20.42.124 1209281148
  70. 67 one.step.ahead.with.un 72.20.2.158 1209270942
  71. 68 Sm0kE.W33D.WiV.BLooDzX 72.20.38.37 1209280037
  72. 69 136F2BCC.E4BFB21C.E829
  73. 70 ti511110a080-5864.bb.o 85.167.238.2 1437069034
  74. 71 BSN-77-175-106.dsl.sio 66.45.238.61 1110306365
  75. 72 admin.xsroute.com 64.32.4.40 1075840040
  76. 73 admin.drifternet.org 67.43.232.66 1126950978
  77. 74 us.army.li 66.252.4.193 1123812545
  78. 75 83.141.108.140 83.141.108.1 1401777292
  79. 76 bitch.you.will.be.ro0t 64.18.149.20 1074959818
  80. 77 voodoohosting-D7243D1E
  81. 78 ti511110a080-5864.bb.o 85.167.238.2 1437069034
  82. 79 voodoohosting-832FDFD5
  83. 80 voodoohosting-832FDFD5
  84. 81 bnshells.net 72.20.5.18 1209271570
  85. 82 d90-128-80-9.cust.tele 90.128.80.9 1518358537
  86. 83 need.some.more-weed.ne 72.20.35.144 1209279376
  87. 84 need.some.more-weed.ne 72.20.35.144 1209279376
  88. 85 spc2-stok7-0-0-cust969 82.9.219.202 1376377802
  89. 86 you.cant.be.vadtec.net 72.20.27.122 1209277306
  90. 87 adsl-70-113-291-12.dsl
  91. 88 host-69-59-90-134.nctv 69.59.90.134 1161517702
  92. 89 d83-189-3-175.cust.tel 83.189.3.175 1404896175
  93. 90 ncarc6.biblio.arch.uny
  94. 91 voodoohosting-7295603C
  95. 92 voodoohosting-ABCD5907
  96. 93 supid.pl
  97. 94 voodoohosting-86E19CA3
  98. 95 voodoohosting-7295603C
  99. 96 efnet.opers.juped.us 72.20.18.92 1209274972
  100. 97 adsl-72-20-49-129.stat 72.20.49.129 1209282945
  101. 98 voodoohosting-E76D926B
  102. 99 ipchains.secured.my.c0 72.20.49.134 1209282950
  103. 100 AC846ECB.ipt.aol.com 172.132.110. -140060702
  104. 101 72.20.27.122 72.20.27.122 1209277306
  105. 102 cmb2-250.dial-up.arnez
  106. 103 69.26.69.188 69.26.69.188 1159349692
  107. 104 69.26.69.188 69.26.69.188 1159349692
  108. 105 69.26.69.188 69.26.69.188 1159349692
  109. 106 dirty.south.solj.us 72.20.42.124 1209281148
  110. 107 adsl-72-20-42-205.dsl. 72.20.42.241 1209281265
  111. 108 adsl-72-20-42-205.dsl. 72.20.42.241 1209281265
  112. 109 ur.little.princess.is.
  113. 110 using.the.next.door.ne
  114. 111 208.68.93.90
  115. 112 stfu.thnx.org
  116. 113 phatty.phat.pimp.org
  117. 114 68.191.197.211
  118. 115 drunk.cuz.i.emptied.th
  119. 116 akill.ws
  120. 117 thor.novashells.com
  121. 118 proxy.shahrul.org
  122. 119 wanted.by.the.fbi.be
  123. 120 dayz.is.a.decepti.com
  124. 121 87-194-94-254.bethere.
  125. 122 drunk.cuz.i.emptied.th
  126. 123 dirty.south.solj.us
  127. 124 virtual.elitehacker.or
  128. 125 72.20.51.22
  129. 126 AC846ECB.ipt.aol.com
  130. 127 voodoohosting-EC612B1C
  131. 128 netadmin.voodoohosting
  132. 129 just.do.it.cx
  133. 130 194.126.241.199
  134. 131 c-69-254-237-218.hsd1.
  135. 132 64.139.226.80
  136. 133 voodoohosting-EE037726
  137. 134 207.255.135.122
  138. 135 staff.bnshells.net
  139. 136 gets.paid.to.have.irc-
  140. 137 staff.acmeshells.com
  141. 138 voodoohosting-1D67B5C0
  142. 139 ip68-13-182-133.om.om.
  143. 140 72.20.13.16
  144. 141 phishbox.phisher1.com
  145. 142 voodoohosting-10BCD9EB
  146. 143 netadmin.voodoohosting
  147. 144 voodoohosting-FAF59B8E
  148. 145 voodoohosting-3B17D4D2
  149. 146 200.77.126.82
  150. 147 B00M.US
  151. 148 2001:618:400:346a:1337
  152. 149 65.23.156.189
  153. 150 ti511110a080-5864.bb.o
  154. 151 staff.tengkorak.org
  155. 152 136F2BCC.E4BFB21C.E829
  156. 153 netadmin.voodoohosting
  157. 154 ip67-88-209-29.z209-88
  158. 155 72.20.33.222
  159. 156 voodoohosting-FAF59B8E
  160. 157 65.23.156.189
  161. 158 200.103.131.120
  162. 159 d060206.adsl.hansenet.
  163. 160 i.am.so.s3xy.de
  164. 161 blackhat-hosting.com
  165. 162 blackhat-hosting.com
  166. 163 your.mother.gave.you.a
  167. 164 massive.voltage.co.il
  168. 165 72.20.34.181
  169. 166 admin.xsroute.com
  170. 167 voodoohosting-92CF3BB1
  171. 168 64.32.4.40
  172. 169 psych0.us
  173. 170 cpe-069-133-022-091.r0
  174. 171 cpe-069-133-022-091.r0
  175. 172 dayz.is.a.decepti.com
  176. 173 voodoohosting-ABCD5907
  177. 174 cpe-67-9-85-210.hot.re
  178.  
  179. This is how many rows are in the table, total.
  180. sqlite> select count(id) as count, id, domain, ip, longip from domain order by id;
  181. count id domain ip longip
  182. ---------- ---------- ------------------------------ ---------- ----------
  183. 174 174 cpe-67-9-85-210.hot.res.rr.com
  184.  
  185.  
  186. These are the rows that are returned and should have empty ip and longip fields. It should return 71 rows instead of 37.
  187. sqlite> select id, domain, ip, longip from domain where ip ="" and longip isnull order by id;
  188. id domain ip longip
  189. ---------- -------------------------------------- ---------- ----------
  190. 8 host130-121.pool80182.interbussines.it
  191. 16 voodoohosting-71D7CEA6.nott.cable.ntl.
  192. 18 136F2BCC.E4BFB21C.E829E8B5.IP
  193. 21 voodoohosting-E76D926B.dsl.hstntx.swbe
  194. 22 voodoohosting-71D7CEA6.nott.cable.ntl.
  195. 32 pc-1007.ds5.tuniv.szczcecin.pl
  196. 33 cpe-238-108-31-26.nyc.res.rr.com
  197. 35 170-201.82-139.bia.tkbb.net.pl
  198. 37 kablenet.hu
  199. 38 netadmin.voodoohosting.com
  200. 39 voodoohosting-842A210F.ipt.aol.com
  201. 40 4270D75.3DB7DEFD.8B266299.IP
  202. 41 voodoohosting-97AC4147.area3.spcsdns.n
  203. 43 voodoohosting-C2C6BE02.ipt.aol.com
  204. 45 voodoohosting-EFD26719.hsd1.or.comcast
  205. 46 clj6-170.dial-up.arnez.si
  206. 47 cq253.internetdsl.tpgnet.pl
  207. 48 voodoohosting-FAF59B8E.hsd1.fl.comcast
  208. 53 netadmin.voodoohosting.com
  209. 56 olimp.troep.net.pl
  210. 57 voodoohosting-927BBF44.alt.east.verizo
  211. 58 voodoohosting-865B51D7.cpe.net.cable.r
  212. 59 voodoohosting-7036AA6B.cfl.res.rr.com
  213. 60 ip-188-252.sn1.eutellia.it
  214. 69 136F2BCC.E4BFB21C.E829E8B5.IP
  215. 77 voodoohosting-D7243D1E.ipt.aol.com
  216. 79 voodoohosting-832FDFD5.xs4all.nl
  217. 80 voodoohosting-832FDFD5.xs4all.nl
  218. 87 adsl-70-113-291-12.dsl.snfc21.sbcgloba
  219. 90 ncarc6.biblio.arch.unyfi.it
  220. 91 voodoohosting-7295603C.carolina.res.rr
  221. 92 voodoohosting-ABCD5907.bethere.co.uk
  222. 93 supid.pl
  223. 94 voodoohosting-86E19CA3.socal.res.rr.co
  224. 95 voodoohosting-7295603C.carolina.res.rr
  225. 98 voodoohosting-E76D926B.dsl.hstntx.swbe
  226. 102 cmb2-250.dial-up.arnez.si
  227.  
  228. This is how many rows this query returns.
  229. sqlite> select count(id) as count, id, domain, ip, longip from domain where ip ="" and longip isnull order by id;
  230. count id domain ip longip
  231. ---------- ---------- ------------------------- ---------- ----------
  232. 37 102 cmb2-250.dial-up.arnez.si
  233.  
  234.  
  235. This is how many rows have data in the longip field.
  236. sqlite> select count(longip) from domain;
  237. count(longip)
  238. -------------
  239. 71
  240.  
  241. 71 - 37 = 66