Pages

12/01/2019

《李敖有话说》全集目录

第001集 2004.03.08.我终于有一个机会在这里抛头露面
第002集 2004.03.09.台湾人说想独立全国人民都笑了
第003集 2004.03.10.沐猴而冠和Democrazy
第004集 2004.03.11.膀胱容尿有力立院审案好处多
第005集 2004.03.12.民主政治的不当之处
第006集 2004.03.15.泄露天机 看看李登辉的嘴脸
第007集 2004.03.16.李登辉是个认贼作祖的小人
第008集 2004.03.17.“公投”丐词魔术骗你不商量
第009集 2004.03.18.没有台湾问题,根本是中美的问题
第010集 2004.03.19.给奴才做奴才的奴才

5/12/2019

How to Close Excel without Prompting Dialogue

ALT + F11, insert a new module.



VBA: Close without Saving


Sub Auto_Close()

    ThisWorkbook.Saved = True

End Sub

VBA: Close with saving.


Sub Auto_Close()
    If ThisWorkbook.Saved = False Then
        ThisWorkbook.Save
    End If
End Sub

5/10/2019

Force Excel Column to Proper/Lower Case

It need to be VBA function to force it happen:


  1. Open Excel
  2. Alt + F11 to open developer mode
  3. Add following code 



VBA code: Force text string to Lowercase
1
2
3
4
Private Sub Worksheet_Change(ByVal Target As Range)
'Update 20140603
Target.Value = VBA.LCase(Target.Value)
End Sub
VBA code: Force text string to proper case
1
2
3
4
Private Sub Worksheet_Change(ByVal Target As Range)
'Update 20140603
Target.Value = Application.WorksheetFunction.Proper(Target.Value)
End Sub

4/01/2019

How to Avoid Disk 100% for Utorrent

Follow these steps:

1. Make sure you are using uTorrent 2.2.1, because that's the most stable and most allowed torrent client on every torrent site. You can download it from http://utorrent.hu/download/utorrent-2-2-1-2/
2. Open the uTorrent settings (CTRL+P)
3. Tick the preallocate files button and untick all the updating and data sending related things
4. Go to advanced settings
5. Set bt.prio_first_last_piece to true
6. Set diskio.coalesce_write_size to 8388608
7. Set diskio.flush_files to false
8. Set diskio.sparse_files to true
9. Go to cache settings
10. Tick the override default cache, and set the cache size to 368MB
11. Apply and save the settings
12. After restarting uTorrent you will see way less or maybe absolutely no disk overload issues anymore

12/08/2018

网上泄露的各种数据库

ed2k://|file|2010.06-江西移动全库-408万-access.7z|1329999527|5231E1EC5EE1123C6E694AD6399F9807|h=DORZC7XFNG63ZWX6C3RSN3Q7CWZXG5G4|/
ed2k://|file|2012.01-千脑-70万-csv.rar|34017079|A30DD3EF32C03C86E71032CDCA1C5EF9|h=2Z7TKJED7P2NJCKUCINNHMWLXV3KVVS4|/
ed2k://|file|2012.02-AcFun-15万-txt.rar|2241909|C2439FAB2BC7322273DE5D512A530A83|h=QJWQ3LWZ3UFJMPQHPD6WGXYYZHPRLQ43|/
ed2k://|file|2012.03-圆通数据库-mssql.rar|127496748|75F92807F541FB0EBB4773BA83D5157A|h=YAOCNQEUXCNBBTIM226NNZLJA7SMMSDS|/
ed2k://|file|2012.07-yahoo-45万-txt.bz2|6871089|8769EC2314C1AF2C98237DF58C7076D2|h=VSJ52KZ6O6JUZNZKXKT7F3LRXHBKJKMN|/
ed2k://|file|2012.08-小米论坛-828万-mysql.rar|518891223|87704FEA5B191C21F605A0C135BAF98E|h=6UQWS3OQ4VGUXLYW2L6H6TL2GKZOJAUA|/
ed2k://|file|2012.08-小米论坛-828万-txt.rar|361627120|2ED96D2F0E515321F67A31E84DC77B3C|h=UNNVFRMNWNP7UAIXZ6Y6AFCKOLBFJILW|/
ed2k://|file|2013.04-DNF-700万-mysql.zip|306178725|169CE4FA4D4F467BCB7F8297CE6EE032|h=C3KZ6C637ARBAPD5UNF2YMYMT5LTS2UK|/
ed2k://|file|2013.08-酒店开房记录-2000万-excel.rar|610164988|26F994CA1ABA72051ECE497F9AB7959A|h=EDLQDIHSRAJHB5SVNDQVMNPHOXVO3XB6|/
ed2k://|file|2013.08-酒店开房记录-2000万-mssql.bak|8030079488|6FCCDC6DE213DC72A4EFEE19AF2FC1AC|h=5YJSQJY46OYKYMQA5P4G3DUAQGATYDFI|/
ed2k://|file|2014.08-企业400号段数据-mssql.rar|46506453|4F44726413F3B9F9F701635FB498EAAB|h=LP47JMAJGOX233HQR2V3K673G7LE22RI|/
ed2k://|file|2014.08-台湾某财经电视台数据库-2014-txt.zip|53519|95160AAE4A9E3074BACB04C606C0748F|h=3KQJJ4ADWKNOGNJIZIICBXQ5SLPD62R5|/
ed2k://|file|2014.08-房产网-11万-sql.7z|6095432|D99DE175A27D179A5EB9F34D2D975FB0|h=2GN2RLDSDDVZ4POQZVIEJODQJVH2CJ4G|/
ed2k://|file|2014.09-mail.ru邮箱地址-466万-txt.7z|30715779|5247DC686608FD2317A31E8BA67899F4|h=DFVLYBFEQQLDZSXIEOWHWY2BMA5DKDBO|/
ed2k://|file|2014.09-yandex.ru-100万-txt.zip|16200283|80C4A344D51DBAE12F0A0D50202E9313|h=RA2KA6RRGELDAMXBAKXVFI3W7SIJ6TEE|/
ed2k://|file|2014.12-12306-13万-txt.7z|4470710|7B25F299C7862BFA855B63B04BB00E2A|h=VURCVAXE4UVFI2TOIEC6DIZUBSYELY76|/
ed2k://|file|2016.04-卡塔尔国家银行QNB-csv.zip|534384790|D7D81061307568AE47A3EE6C894D6C6C|h=VRQGQASTAHXFRGBZXAAIABVTFJRRIV7G|/
ed2k://|file|2016.04-土耳其公民数据mernis-5000万-sql.gz|1555520122|22B660CB494D89FC84198A6EEA66E3B6|h=HYBIW22P3G56CUB7RR34CJVD7RKO34BS|/
ed2k://|file|2011.03-多玩游戏网-800万-txt.rar|227441723|F8388A178222518978550D3E64B6129B|h=XMR2CYVQI3HOMKVRGUCCFGYZ3JVHKLCG|/
ed2k://|file|2011.03-当当网买家信息-101万-Excel.zip|7822098|1F66086AE57B74D69BF75A2EF7900B2E|h=VRWZME24KH7UTIF3HPTCO5V5KNTEHUAQ|/
ed2k://|file|2011.04-766游戏网-12万-sql.rar|5031951|BBE2D87564A2A8E4B083B57C697FD24E|h=DUFDLSY2A4F5SPZMMCN5JP7TE2HWA4EV|/
ed2k://|file|2011.04-IS语音-969万-txt.zip|177030850|B153DDF9FE16EFFF30C589664592F85A|h=HCB5NVNHVGVGKMDCS7HXHI4MNQASG5SY|/
ed2k://|file|2011.04-亚马逊中国买家信息-20万.zip|7570413|356D9E9C07D62243EF8A62745819E85C|h=BXLWB7OFKIFTCSCUU4Y47DHMX67GF7DO|/
ed2k://|file|2011.04-凡客诚品买家信息-20万-Excel.zip|7784030|AEC527EA7E816DBD75FF92B0C26BC480|h=VXC2RO23H23OCZISUXTEO62RTVHGQFPZ|/
ed2k://|file|2011.04-爱拍游戏网-1100万-txt.zip|267845795|87F9FFE887B0F53CAFD2A11205CB6C52|h=G6AQRSNJ7CHDTX5MTV6RYGB2OHYOAEXA|/
ed2k://|file|2011.05-木蚂蚁-13万-sql.zip|8598547|680F8999D4E27174553D1C11118DF978|h=5G2YZ7Z6RAQ5M5XUNCEFNX7ZYAITMZPZ|/
ed2k://|file|2011.07-土木在线-540万-sql.zip|645903048|4ED3B64224752DE3AB11B11D2FD9DA06|h=UL3F74NI266IR4IHI7UHDKMZRQMX3PFX|/
ed2k://|file|2011.10-178游戏网-1000万-txt.rar|108534783|FFCD04A52339701C8CB5197BDCF9F4DC|h=C2UYTR264YXVM6NSJNUV5R2PC5VZNAYU|/
ed2k://|file|2011.10-CSDN.NET-600万-sql.rar|109942505|A29D9468556CF73AFB48A3A8427629DC|h=VTPXT56G3BGRTHBROKQEWW6XAQTMYPLZ|/
ed2k://|file|2011.10-嘟嘟牛-66277-txt.rar|215666725|EF7187E33A8EBD9FD806343B7B1CAA82|h=Z5YU2Z6P6GUT5DUKQ6L4X5YFMZZNZ4YZ|/
ed2k://|file|2011.11-7k7k小游戏-2000万-txt.rar|203648704|6EB70910C1C193F5BE04610B503EF4A0|h=Y4ITT7C5Z5LOOREJPWXA25TM2NLKEEDX|/
ed2k://|file|2011.11-人人网-500万-txt.rar|51969611|8CD19B7A2EB9F1F74CB8BFBDE7BD144D|h=SDNOOZCYR6PXZIRZTZPEICNRNZ67BQJJ|/
ed2k://|file|2011.12-天涯社区-4000万-txt.rar|493480455|E4E0CFD85E2A783A3C3BD2539AA28FC3|h=4FB7J7QPRWRIPX7QWWTYVZCKMWDZ5VIQ|/
ed2k://|file|2011.12-淘宝买家卖家邮箱-2500万-txt.zip|135534861|F40C3C9F32F2C30B1A2484FAB3CB1257|h=GLUDUAAYPAALG3GPHD4EHT5OB6V6WBVB|/
ed2k://|file|2012.10-QQ精准客户名单-4500万-txt.rar|131416815|134F81AA90B27F55818E7A521D3CB35B|h=NRF2HAH2IXDT635UV6NDEGSA2HSOSSHZ|/
ed2k://|file|2012.06-LinkedIn-16737万-txt.rar|7503170474|A50C488915FC70E1DE644AA5F3432D6F|h=E2NEXLXOOA6PONPKUGVRVIMEU54EC6P4|/
ed2k://|file|2013.06-Myspace.com-36021万-txt.7z|12419587039|A1B14F88891885D636DE9F642A3E06DF|h=3QBXWEHRBUSUEWJOSHCF47B7HEC4Q5BM|/

VERYCD simplecd-desktop-db
ed2k://|file|simplecd-desktop-db-2010-10-12.7z|838755392|E539C1381381F1BB6075304B3BDCEAF9|h=3EMKTLZD6GIIYZ4JJ57P76EJ3GGXE3Q4|/ 


人人网500w
ed2k://|file|%C8%CB%C8%CB%CD%F8500W_16610.rar|51969611|8CD19B7A2EB9F1F74CB8BFBDE7BD144D|/

CSDN-中文IT社区-600万
ed2k://|file|CSDN-中文IT社区-600万.rar|109942505|A29D9468556CF73AFB48A3A8427629DC|/

7k7k两千万用户密码数据库
ed2k://|file|7k7k2000%CD%F2_2047.rar|203648704|6EB70910C1C193F5BE04610B503EF4A0|/

178一千万用户数据库
ed2k://|file|178(1000w)_3087.rar|108534783|FFCD04A52339701C8CB5197BDCF9F4DC|/


**Amazon.Cn:7.22MB**
ed2k://|file|Amazon.Cn_亚马逊.zip|7570413|356D9E9C07D62243EF8A62745819E85C|/

**DangDang.Com:7.46MB**
ed2k://|file|DangDang.Com_当当网.zip|7822098|1F66086AE57B74D69BF75A2EF7900B2E|/

**ISpeak.Cn:168.83MB**
ed2k://|file|ISpeak.Cn_IS语音.zip|177030850|B153DDF9FE16EFFF30C589664592F85A|/

**MuMaYi.Com:8.20MB**
ed2k://|file|MuMaYi.Com_木蚂蚁.zip|8598547|680F8999D4E27174553D1C11118DF978|/

**TaoBao.Com:129.26MB**
ed2k://|file|TaoBao.Com_淘宝网.zip|135534861|F40C3C9F32F2C30B1A2484FAB3CB1257|/

**Vancl.Com:7.42MB**
ed2k://|file|Vancl.Com_凡客诚品.zip|7784030|AEC527EA7E816DBD75FF92B0C26BC480|/

**163.Com:21.03MB**
ed2k://|file|163.Com_网易.zip|22056264|E69B66C629748E803DF13E36B9741913|/

**AiPai.Com:255.44MB**
ed2k://|file|AiPai.Com_爱拍游戏网.zip|267845795|87F9FFE887B0F53CAFD2A11205CB6C52|/

**Co188.Com:615.98MB**
ed2k://|file|Co188.Com_Co土木在线.zip|645903048|4ED3B64224752DE3AB11B11D2FD9DA06|/

2/05/2018

奥克兰 Albany Full Licence 路考路线

2017年11月与2018年2月路考线路是一模一样的。
具体如图:
注意事项:全程限速50KMPH

  • VTNZ 出门右转后左进 Paul Matthews Road
  • 转盘RoundAbout左转进Bush Road, 二转盘RoundAbout右转进 William Pickering Dr
  • 右转进Te Kea Place, 掉头, 右转回William Pickering Dr
  • 三转盘RoundAbout 右转进Douglas Alexander Parade,
  • 右转进Rosedale Road(多练习这里,最容易fail)
  • 右转进Airborne Road
  • 左转进Tarndale Grove
  • 右转进Bush Road
  • 右转进Piemark Drive
  • 左转回 William Pickering Dr
  • 右转进Ruthwell Avenue
  • 左转上Albany Highway
  • 左转下Highway, 进Bush Road
  • 返回VTNZ




Tennis Court in Queenstown area

Some courts are not open to public  Quail Rise -45.002353534957564, 168.75157230875968 Arrowtown -44.94668233699295, 168.82240587902302 lowe...