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