![]() |
Today ! |
Thread Tools | Search this Thread |
|
|
|
|
Tech-Babe
![]() Posts: 3,340
Name: Cindy
Karma:
![]() ![]() ![]()
|
Ooooo two months ! you lucky Man, hope you enjoy it Christopher
![]()
__________________
. .New Members please read > TNT Rules . Main Rig - Asus P5N-T Deluxe nForce 780i , Intel Core 2 Quad Q9300 , OCZ 4GB (2x2GB) PC2-8000C5 1000MHz ReaperX HPC Enhanced Bandwidth Edition , ATI Radeon HD 3870 X2 1024MB GDDR3 TV-Out/Dual DVI/HDMI, W/D Raptors X 150GB 10000RPM SATA 16MB Cache, X3 (2 in RAID 0 - 1 none RAID), Dual Boot XP Pro SP3 / Vista Ultimate SP1 |
|
|
|
|
|
|
|
Elite Member
Posts: 927
Name: nick
Karma:
![]()
|
2 months Today worked on some new laptops ![]()
__________________
My Opera Blog |
|
|
|
|
|
|
|
Elite Member
Posts: 517
Name: Ken
Karma:
|
Btw, congrats Christopher! Enjoy!
__________________
(\__/) (='.'=) (")_(") |
|
|
|
|
|
|
|
Tech-Babe
![]() Posts: 3,340
Name: Cindy
Karma:
![]() ![]() ![]()
|
Today Gym first then I'm having my hair done and Lee is off duty today
__________________
. .New Members please read > TNT Rules . Main Rig - Asus P5N-T Deluxe nForce 780i , Intel Core 2 Quad Q9300 , OCZ 4GB (2x2GB) PC2-8000C5 1000MHz ReaperX HPC Enhanced Bandwidth Edition , ATI Radeon HD 3870 X2 1024MB GDDR3 TV-Out/Dual DVI/HDMI, W/D Raptors X 150GB 10000RPM SATA 16MB Cache, X3 (2 in RAID 0 - 1 none RAID), Dual Boot XP Pro SP3 / Vista Ultimate SP1 |
|
|
|
|
|
|
||
|
Elite Member
Posts: 370
Name: The Duke of URL
Karma:
|
Quote:
? Is he an officer of the law, or military man? (If so, VERY cool, either way - IF I made an incorrect assumption here, my bad... it just sounds as if he is law enforcement or militiary is all) EDIT: Hey Cat? IF he is an officer of the law, & is into computers (especially ones that use Windows NT-based OS of today) by some chance? WELL - Have I got a wallpaper for him (see here, it is part of this one, i.e.-> The "Windows NT process traffic cop" illustration portion) you can give him as a "techie present" from you: http://www.thenewtech.com/forums/chi...html#post14906 (Maybe, just maybe? He'd like it... let me know, I can send it your way, to you, to give to he) APK P.S.=> Quote:
Getting notepad.exe to do an EDIT menu, REPLACE function (displacing 127.0.0.1 for 0.0.0.0 which is smaller & thus, loads faster & takes up less RAM) takes FOREVER & a day... but, worth it in the long haul! When that's done? Then, I still have to "normalize" it (meaning replacing any duplicated entries, so its that much more efficient)... It's @ 4.5mb in size, & I am sure I can cut it down to around 2-3 mb easily by doing this & ALL unique entries only! I have to do this, because I use several sources ontop of my own file to create this file so it is as 'comprehensive as possible', & duplicates happen like mad... that slows down its loads (but, the local DNS cache, afaik @ least? Doesn't permit duplicates though... so, it's to make it have as fast a loadtime as is possible really only - not for less memory occupancy). I built an app to do this: ![]() ![]() However, my app, when used on the HOSTS file entries formats of others, has one small catch - Each entry in said HOSTS file has to be in this form: 0.0.0.0 (single space) URL {enter key/cr+lf} & if it's not? My app "hangs up" on those entries (a lot of hosts file makers use a tab instead of a 'single space' as I do, throws my app, & I haven't corrected for it, yet) or, if others whose source HOSTS files I am importing leave a trailing character JUST BEFORE the {enter keypress/cr+lf} @ the end of each line in this file for THEIR entries I import (some do, I have NO idea why - makes NO SENSE for efficiency of structure, but, they do) (PLUS, my program above is merely a simple "brute force" replace engine (compares first entry, to all others, & keeps it if unique, & goes to 2nd entry & does the same, all the way thru the Nth entry (comparing to first item in original list, skipping itself, & going all the way to the end etc.))).... THUS - I am going to see, however, IF SQL is my friend here! (After speaking to sepulchre above in regards to this? It gave me an idea, to save time... & I think it will be one that does so, as I am going to import this to Access, & let the "JET ENGINE" do this - & quite possibly, faster than my 'brute force' de-duplicator/normalizer engine can). One column on the db import will be the 0.0.0.0. & the other will be the URL... then, a SQL statement of: SELECT DISTINCT column_name(s) FROM table_name Should make far shorter work of it than my program would, w/ out the screwups I see due to formats others use in this file that throws my "home grown app" for this... (One day, I'll correct mine for the formats others use, as I only generally used it to process the HOSTS files I created... this time, I am using ALL OTHER KNOWN SOURCES too - to make this file the 'best one there is in existence' etc.) "A GEEKS' WORK IS NEVER DONE" (Cat - some advice, IF you take advice? Don't marry a geek/tech/nerd etc. ... we're BORING! lol...) apk
__________________
"I'm Reese: Sgt. TechComVN38416, assigned to protect you - You've been TARGETTED FOR TERMINATION!" Last edited by APK; Jun 4, 2008 at 08:39am. |
||
|
|
|
|
|
|
|
Elite Member
Posts: 370
Name: The Duke of URL
Karma:
|
SELECT DISTINCT AccessImportAdbannerBlockTextToNormalize.IP, AccessImportAdbannerBlockTextToNormalize.URL INTO NORMALIZED
FROM AccessImportAdbannerBlockTextToNormalize WHERE AccessImportAdbannerBlockTextToNormalize.IP='0.0.0 .0 '; ----- That SQL "make table" Query was my "best friend", yesterday! (& Access' "Rushmore Technology" JET engine, & it's superior indexed speed (by far I found out, vs. the brute force string replace engine I built above - this shows me that E.F. Codd (relational db inventor basically) is/was by FAR, my superior in understanding of this field imo!))... Access & its SQLQueries + Tables were used for the purposes of "normalizing" (database term, means removal of repeated entries basically) the base custom HOSTS file I had, & that I have been building up since 1997, which I have been building up more all week now making it absolutely current + as comprehensive as is possible... Imported, normalized, output in alphabetical order... minus duplicates & excessive comments lines. Today? I will finally be putting out what is probably the MOST comprehensive bad adbanner/bad site blocking custom HOSTS file on the planet, because of it! (In part - because I still have to pull the repeated entries that had # type comments on them, which made them totally "new & distinct" entries (even though many times most of those had one just like them, minus the #comment attached @ the end - this is probably like 100++ entries to pull, making it tinier still))... ![]() * That's part of my day later on today, it's finally getting there! Fully internally documented on how ALL parts of it work, & the badware/adbanner blocking section is TOTALLY alphabetized on all of its entries too, for easier maintenance by you, the end-user/consumer of it. (It also lists ALL the sources I used, so you can "self-populate" it yourself too, if you wish to keep up on that kind of thing also) I formed the file from the one I had originally, fed by:
http://en.wikipedia.org/wiki/Hosts_file APK P.S.=> Right now, it's 3.5mb in size (&, will be smaller still soon, for faster loads & less memory occupancy in the local DNS cache), but ALL unique entries that are from valid & reputable sources + ones that are VERY current as well & ones that have "stood the test of time" over 11 yrs. now, also... apk
__________________
"I'm Reese: Sgt. TechComVN38416, assigned to protect you - You've been TARGETTED FOR TERMINATION!" Last edited by APK; Jun 5, 2008 at 08:57am. |
|
|
|
|
|
|
|
|
Elite Member
Posts: 927
Name: nick
Karma:
![]()
|
Quote:
![]()
__________________
My Opera Blog |
|
|
|
|
| Thread Tools | Search this Thread |