NT+5.1;+SV1;+.NET+CLR+1.1.4322;+MAXTHON+2.0) 200 0 0 2007-08-21 02:10:49 W3SVC103337877 58.61.156.23 GET /cn/CSS/CS.css - 80 - 116.215.162.146 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322;+MAXTHON+2.0) 304 0 0 2007-08-21 02:10:49 W3SVC103337877 58.61.156.23 GET /cn/Flash/TOP.swf - 80 - 116.215.162.146 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322;+MAXTHON+2.0) 304 0 0 2007-08-21 02:10:49 W3SVC103337877 58.61.156.23 GET /cn/Flash/wuhuan.swf - 80 - 116.215.162.146 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322;+MAXTHON+2.0) 304 0 0 2007-08-21 02:10:49 W3SVC103337877 58.61.156.23 GET /cn/js/menu.js - 80 - 116.215.162.146 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322;+MAXTHON+2.0) 304 0 0 2007-08-21 02:10:49 W3SVC103337877 58.61.156.23 GET /favicon.ico - 80 - 116.215.162.146 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322;+MAXTHON+2.0) 404 0 64 2007-08-21 02:10:49 W3SVC103337877 58.61.156.23 GET /cn/Pro/bg.gif - 80 - 116.215.162.146 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322;+MAXTHON+2.0) 404 0 3 2007-08-21 02:11:03 W3SVC103337877 58.61.156.23 GET /cn/index.asp - 80 - 116.215.162.146 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322;+MAXTHON+2.0) 200 0 0 2007-08-21 02:11:03 W3SVC103337877 58.61.156.23 GET /cn/images/ad.gif - 80 - 116.215.162.146 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322;+MAXTHON+2.0) 200 0 0 #Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2007-08-21 02:49:03 #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status 2007-08-21 02:49:03 W3SVC103337877 58.61.156.23 GET /robots.txt - 80 - 66.249.73.105 Mozilla/5.0+(compatible;+Googlebot/2.1;++http://www.google.com/bot.html) 404 0 2 2007-08-21 02:49:03 W3SVC103337877 58.61.156.23 GET /cn01/products.asp userlb=201 80 - 66.249.73.105 Mozilla/5.0+(compatible;+Googlebot/2.1;++http://www.google.com/bot.html) 404 0 3 #Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2007-08-21 03:08:00 #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status 2007-08-21 03:08:00 W3SVC103337877 58.61.156.23 GET /cn01/news.asp - 80 - 66.249.73.105 Mozilla/5.0+(compatible;+Googlebot/2.1;++http://www.google.com/bot.html) 404 0 3 #Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2007-08-21 03:36:41 #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status 2007-08-21 03:36:41 W3SVC103337877 58.61.156.23 GET /robots.txt - 80 - 74.6.27.119 Mozilla/5.0+(compatible;+Yahoo!+Slurp;+http://help.yahoo.com/help/us/ysearch/slurp) 404 0 2 2007-08-21 03:36:42 W3SVC103337877 58.61.156.23 GET /default.htm - 80 - 74.6.24.134 Mozilla/5.0+(compatible;+Yahoo!+Slurp;+http://help.yahoo.com/help/us/ysearch/slurp) 404 0 2 2007-08-21 03:39:48 W3SVC103337877 58.61.156.23 GET /robots.txt - 80 - 202.160.180.108 Mozilla/5.0+(compatible;+Yahoo!+Slurp+China;+http://misc.yahoo.com.cn/help.html) 404 0 2 2007-08-21 03:39:48 W3SVC103337877 58.61.156.23 GET /cn01/product.asp id=2891 80 - 202.160.178.139 Mozilla/5.0+(compatible;+Yahoo!+Slurp+China;+http://misc.yahoo.com.cn/help.html) 404 0 3 2007-08-21 03:43:05 W3SVC103337877 58.#Software: Microsoft HTTP API 1.0 #Version: 1.0 #Date: 2007-08-21 02:26:50 #Fields: date time c-ip c-port s-ip s-port cs-version cs-method cs-uri sc-status s-siteid s-reason s-queuename 2007-08-21 02:26:50 61.135.166.228 41159 58.61.156.23 80 HTTP/1.1 GET /tcompany/SortId16/14428/Tradeinfo_1.html 400 - Hostname - 2007-08-21 02:26:50 220.181.38.171 57134 58.61.156.23 80 HTTP/1.1 GET / 400 - Hostname - 2007-08-21 02:26:50 220.181.19.165 12506 58.61.156.23 80 HTTP/1.1 GET /tradeinfo/info.asp?info_id=20217 400 - Hostname - 2007-08-21 02:26:50 61.135.166.235 40919 58.61.156.23 80 HTTP/1.1 HEAD /seller/sal/r25/200721311293812252.html 400 - Hostname - 2007-08-21 02:26:50 220.181.19.159 42401 58.61.156.23 80 HTTP/1.1 GET /seller/list.asp?typeid=1550 400 - Hostname - 2007-08-21 02:26:51 220.181.19.184 20744 58.61.156.23 80 HTTP/1.1 GET /seller/info.asp?info_id=4344 400 - Hostname - 2007-08-21 02:26:51 60.24.58.45 1700 58.61.156.23 80 HTTP/1.1 GET / 400 - Hostname - 2007-08-21 02:26:51 220.181.19.164 13722 58.61.156.23 80 HTTP/1.1 GET /tradeinfo/info.asp?info_id=26955 400 - Hostname - 2007-08-21 02:26:51 220.181.19.171 53254 58.61.156.23 80 HTTP/1.1 GET /tradeinfo/info.asp?info_id=20076 400 - Hostname - 2007-08-21 02:26:51 60.24.58.45 1701 58.61.156.23 80 HTTP/1.1 GET /favicon.ico 400 - Hostname - 2007-08-21 02:26:51 61.135.166.235 41128 58.61.156.23 80 HTTP/1.1 HEAD /tradeinfo/tra/w18/200762611343179261.html 400 - Hostname - 2007-08-21 02:26:51 124.115.0.25 36704 58.61.156.23 80 HTTP/1.1 GET /tcompany/SortId19/423/Link.html 400 - Hostname - 2007-08-21 02:26:52 61.135.166.228 41581 58.61.156.23 80 HTTP/1.1 GET /default.htm 400 - Hostname - 2007-08-21 02:26:52 220.181.38.171 57386 58.61.156.23 80 HTTP/1.1 GET / 400 - Hostname - 2007-08-21 02:26:53 121.13.67.176 52039 58.61.156.23 80 HTTP/1.1 GET / 400 - Hostname - 2007-08-21 02:26:53 61.135.166.235 41416 58.61.156.23 80 HTTP/1.1 HEAD /seller/sal/r22/200761414355068525.html 400 - Hostname - 2007-08-21 02:26:53 220.181.38.171 57460 58.61.156.23 80 HTTP/1.1 GET / 400 - Hostname - 2007-08-21 02:26:53 220.181.19.166 2957 58.61.156.23 80 HTTP/1.1 GET /seller/sal/r29/200731214523827953.html 400 - Hostname - 2007-08-21 02:26:53 61.135.166.228 41968 58.61.156.23 80 HTTP/1.1 GET /tradeinfo/tra/w21/200727954572538.html 400 - Hostname - 2007-08-21 02:26:53 220.181.19.162 39845 58.61.156.23 80 HTTP/1.1 GET /tradeinfo/tra/w12/20077415373292720.html 400 - Hostname - 2007-08-21 02:26:55 74.6.25.168 55317 58.61.156.23 80 HTTP/1.0 GET /robots.txt 400 - Hostname - 2007-08-21 02:26:55 220.181.19.181 4444 58.61.156.23 80 HTTP/1.1 GET /corporation/mylist.asp?typeid=1128 400 - Hostname - 2007-08-21 02:26:55 220.181.38.171 57559 58.61.156.23 80 HTTP/1.1 GET / 400 - Hostname - 2007-08-21 02:26:55 220.181.19.183 49257 58.61.156.23 80 HTTP/1.1 GET /seller/list.asp?typeid=795 400 - Hostname - 2007-08-21 02:26:55 61.135.166.235 41772 58.61.156.23 80 HTTP/1.1 HEAD /tradeinfo/tra/w18/20077983127104660.html 400 - Hostname - 2007-08-21 02:26:56 60.191.80.112 47734 58.61.156.23 80 HTTP/1.1 GET /picture/409520061226183335.jpg 400 - Hostname - 2007-08-21 02:26:56 60.191.80.112 57701 58.61.156.23 80 HTTP/1.1 GET /picture/415320061229142016.jpg 400 - Hostname - 2007-08-21 02:26:56 60.191.80.112 57808 58.61.156.23 80 HTTP/1.1 GET /picture/365320061130134854.jpg 400 - Hostname - 2007-08-21 02:26:56 74.6.24.22 51268 58.61.156.23 80 HTTP/1.0 GET /forum/ForumArticleList.asp?ClassId=176 400 - Hostname - 2007-08-21 02:26:56 60.191.80.112 45587 58.61.156.23 80 HTTP/1.1 GET /picture/412320061228105338.jpg 400 - Hostname - 2007-08-21 02:26:56 60.191.80.112 49530 58.61.156.23 80 HTTP/1.1 GET /picture/196620061120113050.jpg 400 - Hostname - 2007-08-21 02:26:56 60.191.80.112 42425 58.61.156.23 80 HTTP/1.1 GET /picture/119720061115130554.jpg 400 - Hostname - 2007-08-21 02:26:56 61.135.166.228 42422 58.61.156.23 80 HTTP/1.1 HEAD /productshow/list.asp?typeid=1185 400 - Hostname - 2007-08-21 02:26:56 60.191.80.112 55037 58.61.156.23 80 HTTP/1.1 GET /picture/292920061028103647.jpg 400 - Hostname - 2007-08-21 02:26:56 220.181.19.169 9261 58.61.156.23 80 HTTP/1.1 GET /productshow/show_product.asp?id=1109 400 - Hostname - 2007-08-21 02:26:56 220.181.19.172 20090 58.61.156.23 80 HTTP/1.1 GET /tradeinfo/info.asp?info_id=221703 400 - Hostname - 2007-08-21 02:26:57 220.181.19.180 40546 58.61.156.23 80 HTTP/1.1 GET /Seller/list_1717.html 400 - Hostname - 2007-08-21 02:26:57 61.135.166.235 42086 58.61.156.23 80 HTTP/1.1 HEAD /tradeinfo/tra/w4/20077516243894975.html 400 - Hostname - 2007-08-21 02:26:57 220.181.19.166 3614 58.61.156.23 80 HTTP/1.1 GET /corporation/list.asp?typeid=1604 400 - Hostname - 2007-08-21 02:26:58 220.181.19.169 9614 58.61.156.23 80 HTTP/1.1 GET /company/1/tradeinfo.asp?id=9104 400 - Hostname - 2007-08-21 02:26:58 60.191.80.112 35289 58.61.156.23 80 HTTP/1.1 GET /picture/382620061212134818.jpg 400 - Hostname - 2007-08-21 02:26:58 60.191.80.112 59570 58.61.156.23 80 HTTP/1.1 GET /picture/419420061231173625.jpg 400 - Hostname - 2007-08-21 02:26:58 60.191.80.112 54790 58.61.156.23 80 HTTP/1.1 GET /picture/359520061126234625.jpg 400 - Hostname - 2007-08-21 02:26:58 220.181.38.171 57863 58.61.156.23 80 HTTP/1.1 GET / 400 - Hostname - 2007-08-21 02:26:58 220.181.19.184 22058 58.61.156.23 80 HTTP/1.1 GET /productshow/list.asp?typeid=206 400 - Hostname - 2007-08-21 02:26:58 220.181.38.171 57939 58.61.156.23 80 HTTP/1.1 GET / 400 - Hostname - 2007-08-21 02:26:58 220.181.19.186 58675 58.61.156.23 80 HTTP/1.1 GET /tradeinfo/info.asp?info_id=20362 400 - Hostname - 2007-08-21 02:26:59 220.181.19.160 25977 58.61.156.23 80 HTTP/1.1 GET /company/1/index.asp?id=3827 400 - Hostname - 2007-08-21 02:26:59 60.213.167.100 7922 58.61.156.23 80 - - - - - Timer_ConnectionIdle - 2007-08-21 02:26:59 220.181.38.171 57996 58.61.156.23 80 HTTP/1.1 GET / 400 - Hostname - 2007-08-21 02:26:59 220.181.19.165 14512 58.61.156.23 80 HTTP/1.1 GET /tradeinfo/info.asp?info_id=19906 400 - Hostname - 2007-08-21 02:26:59 61.135.166.235 42462 58.61.156.23 80 HTTP/1.1 HEAD /tradeinfo/tra/w21/2007713163545120742.html 400 - Hostname - 2007-08-21 02:26:59 60.191.80.112 54057 58.61.156.23 80 HTTP/1.1 GET /picture/383520061212155316.jpg 400 - Hostname - 2007-08-21 02:26:59 60.191.80.112 37972 58.61.156.23 80 HTTP/1.1 GET /picture/399320061220180457.jpg 400 - Hostname - 2007-08-21 02:27:00 220.181.19.159 43673 58.61.156.23 80 HTTP/1.1 GET /seller/list.asp?typeid=1551 400 - Hostname - 2007-08-21 02:27:00 220.181.19.184 22730 58.61.156.23 80 HTTP/1.1 GET /seller/info.asp?info_id=4342 400 - Hostname - 2007-08-21 02:27:00 220.181.19.164 15229 58.61.156.23 80 HTTP/1.1 GET /tradeinfo/info.asp?info_id=1433 400 - Hostname - 2007-08-21 02:27:00 124.115.0.168 35935 58.61.156.23 80 HTTP/1.1 GET /trustadv/rempost.asp?id=5191 400 - Hostname - 2007-08-21 02:27:00 220.181.19.171 55045 58.61.156.23 80 HTTP/1.1 GET /tradeinfo/info.asp?info_id=20075 400 - Hostname - 2007-08-21 02:27:00 61.135.166.228 43254 58.61.156.23 80 HTTP/1.1 GET / 400 - Hostname - 2007-08-21 02:27:02 60.191.80.112 49224 58.61.156.23 80 HTTP/1.1 GET /picture/415320061229141162.jpg 400 - Hostname - 2007-08-21 02:27:02 60.191.80.112 53749 58.61.156.23 80 HTTP/1.1 GET /picture/404520061222204530.jpg 400 - Hostname - 2007-08-21 02:27:02 60.191.80.112 53750 58.61.156.23 80 HTTP/1.1 GET /picture/386120061213193158.jpg 400 - Hostname - 2007-08-21 02:27:03 38.99.44.105 34097 58.61.156.23 80 HTTP/1.0 GET /company/1/contact.asp?id=3648 400 - Hostname - 2007-08-21 02:27:03 220.181.38.171 58312 58.61.156.23 80 HTTP/1.1 GET / 400 - Hostname - 2007-08-21 02:27:04 220.181.19.166 4886 58.61.156.23 80 HTTP/1.1 GET /seller/sal/r29/20072131119209124.html 400 - Hostname - 2007-08-21 02:27:04 61.135.166.235 43089 58.61.156.23 80 HTTP/1.1 HEAD /company/1/trustadv.asp?id=10161 400 - Hostname - 2007-08-21 02:27:04 220.181.19.162 41478 58.61.156.23 80 HTTP/1.1 GET /productshow/pro/s5/20076251659213979.html 400 - Hostname - 2007-08-21 02:27:04 125.45.50.94 2001 58.61.156.23 80 HTTP/1.1 GET /china/add.asp 400 - Hostname - 2007-08-21 02:27:04 220.181.38.171 58404 58.61.156.23 80 HTTP/1.1 GET / 400 - Hostname - 2007-08-21 02:27:04 60.213.167.100 7933 58.61.156.23 80 - - - - - Timer_ConnectionIdle - 2007-08-21 02:27:04 125.45.50.94 2012 58.61.156.23 80 HTTP/1.1 GET / 400 - Hostname - 2007-08-21 02:27:05 220.181.38.171 58497 58.61.156.23 80 HTTP/1.1 GET / 400 - Hostname - 2007-08-21 02:27:05 220.181.19.183 50942 58.61.156.23 80 HTTP/1.1 GET /seller/list.asp?typeid=797 400 - Hostname - 2007-08-21 02:27:05 61.135.166.235 42834 58.61.156.23 80 HTTP/1.1 HEAD /corporation/mylist.asp?typeid=1536 400 - Hostname - 2007-08-21 02:27:05 220.181.19.181 7079 58.61.156.23 80 HTTP/1.1 GET /corporation/mylist.asp?typeid=1130 400 - Hostname - 2007-08-21 02:27:06 220.181.19.169 11174 58.61.156.23 80 HTTP/1.1 GET /productshow/show_product.asp?id=1108 400 - Hostname - 2007-08-21 02:27:06 60.191.80.112 39316 58.61.156.23 80 HTTP/1.1 GET /picture/368120061130162155.jpg 400 - Hostname - 2007-08-21 02:27:06 60.191.80.112 47592 58.61.156.23 80 HTTP/1.1 GET /picture/387220061216152135.jpg 400 - Hostname - 2007-08-21 02:27:06 60.191.80.112 44207 58.61.156.23 80 HTTP/1.1 GET /picture/217520061030161219.jpg 400 - Hostname - 2007-08-21 02:27:06 61.135.166.235 43480 58.61.156.23 80 HTTP/1.1 HEAD /tradeinfo/tra/w14/200771314183119958.html 400 - Hostname - 2007-08-21 02:27:06 222.86.151.171 40240 58.61.156.23 80 HTTP/1.1 GET /css/css.css 400 - Hostname - 2007-08-21 02:27:06 222.86.151.171 39411 58.61.156.23 80 HTTP/1.1 GET /images/searchlist_bg_gray1.gif 400 - Hostname - 2007-08-21 02:27:06 222.86.151.171 47285 58.61.156.23 80 HTTP/1.1 GET /images/icon_down.gif 400 - Hostname - 2007-08-21 02:27:06 222.86.151.171 59956 58.61.156.23 80 HTTP/1.1 GET /images/logo.gif 400 - Hostname - 2007-08-21 02:27:06 222.86.151.171 54115 58.61.156.23 80 HTTP/1.1 GET /images/searchlist_bg_gray2.gif 400 - Hostname - 2007-08-21 02:27:06 222.86.151.171 46959 58.61.156.23 80 HTTP/1.1 GET /images/icon_arrow.gif 400 - Hostname - 2007-08-21 02:27:06 220.181.19.172 22092 58.61.156.23 80 HTTP/1.1 GET /company/1/product.asp?id=8379 400 - Hostname - 2007-08-21 02:27:06 220.181.19.180 42209 58.61.156.23 80 HTTP/1.1 GET /Seller/list_1706.html 400 - Hostname - 2007-08-21 02:27:06 222.86.151.171 57125 58.61.156.23 80 HTTP/1.1 GET /images/icon_qyxyss_white.gif 400 - Hostname - 2007-08-21 02:27:06 222.86.151.171 41712 58.61.156.23 80 HTTP/1.1 GET /images/bg_orgbuttononbackground_1x.gif 400 - Hostname - 2007-08-21 02:27:06 222.86.151.171 50983 58.61.156.23 80 HTTP/1.1 GET /images/bg_buttonbackground_1x21.gif 400 - Hostname - 2007-08-21 02:27:06 222.86.151.171 42225 58.61.156.23 80 HTTP/1.1 GET /images/trustpass_logo_min.gif 400 - Hostname - 2007-08-21 02:27:06 222.86.151.171 59618 58.61.156.23 80 HTTP/1.1 GET /images/bgimg_alibabalogo.gif 400 - Hostname - 2007-08-21 02:27:07 222.86.151.171 37181 58.61.156.23 80 HTTP/1.1 GET /seller/images/line.gif 400 - Hostname - 2007-08-21 02:27:07 61.135.166.228 44424 58.61.156.23 80 HTTP/1.1 GET /index_sendfriend.asp 400 - Hostname - 2007-08-21 02:27:07 222.86.151.171 49593 58.61.156.23 80 HTTP/1.1 GET /images/1.SWF 400 - Hostname - 2007-08-21 02:27:07 38.99.44.104 49162 58.61.156.23 80 HTTP/1.0 GET /company/1/company.asp?id=1933 400 - Hostname - 2007-08-21 02:27:07 220.181.38.171 58702 58.61.156.23 80 HTTP/1.1 GET / 400 - Hostname - 2007-08-21 02:27:07 222.86.151.171 46187 58.61.156.23 80 HTTP/1.1 GET /images/shadowh.gif 400 - Hostname - 2007-08-21 02:27:07 222.86.151.171 33299 58.61.156.23 80 HTTP/1.1 GET /images/shadowsh.gif 400 - Hostname - 2007-08-21 02:27:07 222.86.151.171 42910 58.61.156.23 80 HTTP/1.1 GET /images/icon_warning_24x24.gif 400 - Hostname - 2007-08-21 02:27:07 222.86.151.171 48505 58.61.156.23 80 HTTP/1.1 GET /images/login_button.gif 400 - Hostname - 2007-08-21 02:27:07 222.86.151.171 60513 58.61.156.23 80 HTTP/1.1 GET /images/icon_point.gif 400 - Hostname - 2007-08-21 02:27:07 222.86.151.171 57384 58.61.156.23 80 HTTP/1.1 GET /images/register_button.gif 400 - Hostname - 2007-08-21 02:27:07 222.86.151.171 34766 58.61.156.23 80 HTTP/1.1 GET /images/bjlogo.gif 400 - Hostname - 2007-08-212007-08-21 02:10:34 #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status 2007-08-21 02:10:33 W3SVC295736952 58.61.156.23 GET /Default.asp - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 02:10:33 W3SVC295736952 58.61.156.23 GET /images/styles.css - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 304 0 0 2007-08-21 02:10:33 W3SVC295736952 58.61.156.23 GET /cn/index.asp - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 02:10:33 W3SVC295736952 58.61.156.23 GET /images/products_r1_c2.gif - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 304 0 0 2007-08-21 02:10:33 W3SVC295736952 58.61.156.23 GET /images/box2.gif - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 304 0 0 2007-08-21 02:10:33 W3SVC295736952 58.61.156.23 GET /images/products_r1_c4.gif - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 304 0 0 2007-08-21 02:10:33 W3SVC295736952 58.61.156.23 GET /images/products_r2_c4.gif - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 304 0 0 2007-08-21 02:10:34 W3SVC295736952 58.61.156.23 GET /images/main.jpg - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 304 0 0 2007-08-21 02:10:34 W3SVC295736952 58.61.156.23 GET /images/right.jpg - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 304 0 0 2007-08-21 02:10:39 W3SVC295736952 58.61.156.23 GET /Default.asp - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 02:10:39 W3SVC295736952 58.61.156.23 GET /favicon.ico - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 404 0 64 2007-08-21 02:10:39 W3SVC295736952 58.61.156.23 GET /images/styles.css - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 304 0 0 2007-08-21 02:10:39 W3SVC295736952 58.61.156.23 GET /images/products_r1_c2.gif - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 304 0 0 2007-08-21 02:10:39 W3SVC295736952 58.61.156.23 GET /images/box2.gif - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 304 0 0 2007-08-21 02:10:40 W3SVC295736952 58.61.156.23 GET /images/products_r1_c4.gif - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 304 0 0 2007-08-21 02:10:40 W3SVC295736952 58.61.156.23 GET /cn/index.asp - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 02:10:40 W3SVC295736952 58.61.156.23 GET /images/products_r2_c4.gif - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 304 0 0 2007-08-21 02:10:42 W3SVC295736952 58.61.156.23 GET /images/main.jpg - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 304 0 0 2007-08-21 02:10:42 W3SVC295736952 58.61.156.23 GET /images/right.jpg - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 304 0 0 2007-08-21 02:15:22 W3SVC295736952 58.61.156.23 GET /Default.asp - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 02:15:22 W3SVC295736952 58.61.156.23 GET /cn/index.asp - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 02:15:22 W3SVC295736952 58.61.156.23 GET /images/styles.css - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 64 2007-08-21 02:15:22 W3SVC295736952 58.61.156.23 GET /images/products_r1_c2.gif - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 64 2007-08-21 02:15:22 W3SVC295736952 58.61.156.23 GET /images/box2.gif - 80 - 219.130.132.229 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) 200 0 0 2007-08-21 02:15:22 W3SVC295736952 58.61.156.23 GET /images/products_r1_c4.gif - 80 - 219.130.132.229/*------------------------------------------------------------------------------ 80SP3-TOOLS.SQL THIS SCRIPT TAKES THE TOOLS STORED PROCS FROM 8.0, SP1, AND SP2 TO SP3. Changes in this file reflects changes in the following files: INSTMSDB.SQL SQLDMO.SQL XPSTAR.SQL SQLTRACE.SQL WEB.SQL Notes: 80SP1-TOOLS.SQL AND 80SP2-TOOLS.SQL WILL *NOT* RUN WHEN APPLYING SP3 ------------------------------------------------------------------------------*/ PRINT N'' PRINT N'Updating database objects, executing 80SP3-TOOLS.SQL' PRINT N'Started at ' + convert(nvarchar(25), getdate()) PRINT N'' go -------------------------------------------------------------------------------- -- VERIFY Server is started in single-user-mode (catalog-updates enabled), -- and start marking of system-objects. -------------------------------------------------------------------------------- use master go exec dbo.sp_configure 'allow updates',1 go reconfigure with override go exec sp_MS_upd_sysobj_category 1 go -------------------------------------------------------------------------------- -- BEGIN OF CHANGE SECTION: -- Add change sprocs between here and the END OF CHANGE SECTION comment. -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -- SQLDMO stored procedures added after release into sqldmo.sql file -- -- sp_MSobjectprivs -------------------------------------------------------------------------------- /**************************************************************/ /* sp_MSobjectprivs */ /**************************************************************/ if exists (select * from master..sysobjects where (OBJECTPROPERTY(id, N'IsProcedure') = 1 or OBJECTPROPERTY(id, N'IsExtendedProc') = 1) and name = N'sp_MSobjectprivs') drop procedure dbo.sp_MSobjectprivs go print N'' print N'Creating procedure sp_MSobjectprivs...' go create proc dbo.sp_MSobjectprivs @objname nvarchar(776) = null, @mode nvarchar(10) = N'object', @objid int = null, @srvpriv int = null, @prottype int = null, @grantee nvarchar(258) = null, @flags int = 0, @rollup int = 0 as create table #objs(id int NOT NULL) /* Temp table will hold output for final select */ create table #output ( action int NOT NULL, colid int NULL, uid int NOT NULL, protecttype int NOT NULL, id int NOT NULL, grantor int ) create table #tmp( action int NOT NULL, uid int NOT NULL, protecttype int NOT NULL, ) /* mode : 'object', 'user' or 'column'*/ /* * Note: This was expanded for 6.5 due to changes in sysprotects.columns usage, affecting * CPermission::ListPrivilegeColumns. The following additional parameters are for this. */ /* objid : ID of the object we're querying */ /* srvpriv : privilege that we're querying for (e.g. select) */ /* prottype: Protect type, e.g. GRANT/REVOKE */ /* grantee : Grantee name. */ /*** @flags added for DaVinci uses. If the bit isn't set, use 6.5 ***/ /*** sp_MSobjectprivs '%s' ***/ /* 8.0: mode 'column', and grantee != null, we want user column level permissions for CTable/CView::ListUserColumnPermissions */ /* @rollup added to indicate special rollup result set for column level permission, set to 1 to roll up */ /* @flags is for daVinci */ if (@flags is null) select @flags = 0 /* If @objid is not null, this is for the new query for perm cols. */ if (@objid is not null) begin select u.name, o.name, a = col_name(p.id, a.number), a.low, a.high, a.number from master.dbo.spt_values a, dbo.sysprotects p, dbo.sysobjects o, dbo.sysusers u where p.id = @objid and p.action = @srvpriv and p.protecttype = @prottype and p.uid = user_id(@grantee) and p.columns != 0x01 and o.id = p.id and u.uid = o.uid and convert(tinyint, substring(isnull(p.columns, 0x01), a.low, 1)) & -- 6.5 changed so that the bit 0 position is an "invert the bits" indicator: -- when 0, behaviour is the same as in prior versions, and other bits -- indicate columns with the specified privilege -- when 1, the other bits are indicate columns lacking the specified privilege a.high <> (case when (substring(isnull(p.columns, 0x00), 1, 1) & 1 = 0) then 0 else a.high end) and col_name(p.id, a.number) is not null and a.type = N'P' and a.number <= (select count(*) from dbo.syscolumns where id = @objid) order by a return 0 end set nocount on /* * To get around a 4.21 subquery bug where returning count(*) of 0 (for proc cols) * causes the result set to return no rows, we need two passes; one to get the * objects, and another to explicitly use a value (@cols) instead of a subquery. */ declare @id int, @uid int, @cols int select @id = null, @uid = null if (@mode like N'us%') begin select @uid = user_id(@objname) end else if (@mode like N'col%') and (@objname is null) and (@grantee is not null) begin /* 8.0, special path to get column level permissions from all objects on the specified user */ select @uid = user_id(@grantee) end else begin select @id = object_id(@objname) end if (@id is null and @uid is null) begin RAISERROR (15001, -1, -1, @objname) return 1 end /* Get a temp list of objects we're interested in. Do not include repl_* users. */ /* This is the original code */ insert #objs select distinct p.id from dbo.sysprotects p where (@id is null or p.id = @id) and (@uid is null or p.uid = @uid) and p.action in (193, 195, 196, 197, 224, 26) and p.uid not in (16382, 16383) /* Use a "fake cursor" by deleting successive id's from #objs, as this must run on 4.21 */ select @id = min(id) from #objs while (@id is not null) begin select @cols = count(*) from dbo.syscolumns c where c.id = @id /* sysprotects.columns is for SELECT and UPDATE, NULL if it is INSERT or DELETE, since INSERT and DELETE can not be applied to column level */ insert #output select p.action, (case when p.columns is null then -1 else a.number end), p.uid, p.protecttype, p.id, p.grantor from master.dbo.spt_values a, dbo.sysprotects p where convert(tinyint, substring( isnull(p.columns, 0x01), a.low, 1)) & a.high !=0 and (p.id = @id) and (@uid is null or p.uid = @uid) and a.number <= @cols and a.type = N'P' declare @count int, @whataction int, @whatid int, @dup int, @whatprot int /* First pass to correct duplicates */ select @count = count(*) from #output where id = @id and colid in (0, -1) and protecttype in (205, 204) if ( @count > 0 ) begin /* We might have duplicate rows for permission on single coulmn(s) at this point */ /* Use a fake cursor to remove the duplicates first. */ insert #tmp select action, uid, protecttype from #output where id = @id and colid in (0, -1) and protecttype in (205, 204) select @whataction = min(action) from #tmp select @whatid = uid from #tmp where action = @whataction while (@whataction is not null) begin if (@mode like N'col%') and (@objname is null) and (@grantee is not null) begin /* Special case for column level permissions on ALL objects for the specified user, we don't want the row(s) on the entire table */ /* and we don't want the possible duplicate rows in single column(s) */ delete #output where (@whatid = uid) and (colid not in (0, -1)) and (protecttype in (205, 204)) and action = @whataction and (exists (select * from #output where (@whatid = uid) and (colid in (0, -1)) and action = @whataction) and (id = @id)) delete #output where (@whatid = uid) and (colid in (0, -1)) and (action = @whataction) and (id = @id) end else if (@mode like N'use%') and (@objname is not null) begin /* Special case for the user mode, we do want to keep the entire table permissions */ delete #output where (@whatid = uid) and (colid not in (0, -1)) and (protecttype in (205, 204)) and action = @whataction and (id = @id) end else begin /* Other cases */ delete #output where (@whatid = uid) and (colid not in (0, -1)) and (protecttype in (205, 204)) and action = @whataction end delete #tmp where @whatid = uid select @whataction = min(action) from #tmp select @whatid = uid from #tmp where action = @whataction end delete #tmp end /* Second pass to correct protect type */ select @count = count(*) from #output where id = @id and colid in (0, -1) if ( @count > 0 ) begin /* use another fake cursor to correct the protecttype */ /* if there are multiple rows in #output for the same id and action, and if colid = 0 exist */ /* then other rows should have different protecttype from the one in colid = 0 row */ insert #tmp select action, uid, protecttype from #output where id = @id and colid in (0, -1) select @whataction = min(action) from #tmp select @whatid = uid from #tmp where action = @whataction select @whatprot = protecttype from #tmp where uid = @whatid and action = @whataction while (@whataction is not null) begin delete #output where id = @id and colid not in (0, -1) and @whataction = action and @whatid = uid and @whatprot = protecttype delete #tmp where action = @whataction and @whatid = uid select @whataction = min(action) from #tmp select @whatid = uid from #tmp where action = @whataction select @whatprot = protecttype from #tmp where uid = @whatid and action = @whataction end delete #tmp end /* Increment our "fake cursor" column and get the next one. */ delete #objs where id = @id select @id = min(id) from #objs end /* * Organize so that the non-collist privileges are returned first.. this allows * scripting to combine them. sysprotects.action is tinyint, so the hibyte won't conflict. */ update #output set action = action | 0x10000000 where colid <> 0 /* * BUG 58252 * Delete the columns that was droped */ delete from #output where colid not in (0, -1) and col_name(id, colid) is null /* * Order output by uid so Public will script before other groups (we need to script privs for public before * other groups, before users; otherwise sysprotects doesn't hold onto things right). Sub-order is by object id * so we know when we're done with one object and onto the next, then by protecttype to group all GRANTs and * REVOKEs together, and lastly by action (including ORDER_ACTION_BIT so scripting can be more efficient) * because we may have multiple rows for columns. */ set nocount off if (@mode not like N'col%') begin /* Mode is not 'column', do the regular stuff */ select p.action & ~convert(int, 0x10000000), N'column' = col_name(p.id, p.colid), p.uid, N'username' = user_name(p.uid), p.protecttype, o.name, N'owner' = user_name(o.uid), p.id, N'grantor' = user_name(p.grantor) from #output p, dbo.sysobjects o where o.id = p.id order by p.uid, p.id, p.protecttype, p.action end else /* Below are spcial cases for column level permissions */ if (@objname is null) and (@grantee is not null) and (@rollup = 0) begin /* 8.0, special path to get column level permissions from all objects on the specified user */ select N'ObjectName' = o.name, N'Owner' = user_name(o.uid), N'ColumnName' = col_name(p.id, p.colid), o.sysstat & 0x0f, p.id, p.action & ~convert(int, 0x10000000), p.protecttype from #output p, dbo.sysobjects o where p.id = o.id and p.uid = user_id(@grantee) and col_name(p.id, p.colid) is not null order by p.uid, p.id, p.protecttype, p.action end else if (@objname is not null) and (@grantee is not null) and (@rollup = 0) begin /* 8.0, mode 'column', and grantee != null, we want column level permissions on this object for this user */ select N'column' = col_name(p.id, p.colid), N'owner' = user_name(o.uid), N'username' = user_name(p.uid), o.sysstat & 0x0f, p.id, p.action & ~convert(int, 0x10000000), p.protecttype from #output p, dbo.sysobjects o where o.id = p.id and p.uid = user_id(@grantee) and col_name(p.id, p.colid) is not null order by p.uid, p.id, p.protecttype, p.action end else if (@objname is not null) and (@grantee is null) and (@rollup = 0) begin /* 8.0, mode 'column', and grantee = null, we want column level permissions on this object for all users */ select N'column' = col_name(p.id, p.colid), N'owner' = user_name(o.uid), N'username' = user_name(p.uid), o.sysstat & 0x0f, p.id, p.action & ~convert(int, 0x10000000), p.protecttype from #output p, dbo.sysobjects o where o.id = p.id and col_name(p.id, p.colid) is not null order by p.uid, p.id, p.protecttype, p.action end else if (@objname is null) and (@grantee is not null) and (@rollup <> 0) begin /* 8.0, roll up version of the special path to get column level permissions from all objects on the specified user */ select distinct N'ObjectName' = o.name, N'owner' = user_name(o.uid), N'Select' = (case when ((p.action & ~convert(int, 0x10000000))=193) then 1 else 0 end), N'Update' = (case when ((p.action & ~convert(int, 0x10000000))=197) then 1 else 0 end), N'Type' = p.protecttype from #output p, dbo.sysobjects o where p.id = o.id and p.uid = user_id(@grantee) and col_name(p.id, p.colid) is not null order by o.name end else if (@objname is not null) and (@grantee is null) and (@rollup <> 0) begin /* 8.0, roll up version of the special path to return column level permissions on this object for all users */ select distinct N'UserName' = user_name(p.uid), N'Select' = (case when ((p.action & ~convert(int, 0x10000000))=193) then 1 else 0 end), N'Update' = (case when ((p.action & ~convert(int, 0x10000000))=197) then 1 else 0 end), N'Type' = p.protecttype from #output p, dbo.sysobjects o where o.id = p.id and col_name(p.id, p.colid) is not null order by user_name(p.uid) end else begin raiserror 55555 N'Invalid parameter combinations.' return 1 end go /* End sp_MSobjectprivs */ exec sp_MS_marksystemobject sp_MSobjectprivs go grant execute on sp_MSobjectprivs to public -------------------------------------------------------------------------------- -- END SQLDMO SECTION -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -- Changes made to XPSTAR.sql file for SP1 -- -- xp_adsirequest -- sp_ActiveDirectory_Obj -- xp_GetAdminGroupName -- sp_ActiveDirectory_SCP -------------------------------------------------------------------------------- /**************************************************************/ /* xp_terminate_process */ /**************************************************************/ if exists (select * from master.dbo.sysobjects where name = N'xp_terminate_process' and type = N'X') exec sp_dropextendedproc N'xp_terminate_process' go /**************************************************************/ /* xp_adsirequest */ /**************************************************************/ if exists (select * from sysobjects where name = N'xp_adsirequest' and type = N'X') exec sp_dropextendedproc N'xp_adsirequest' go print N'' print N'Creating extended stored procedure xp_adsirequest...' go exec sp_addextendedproc N'xp_adsirequest',N'xpstar.dll' go /**************************************************************/ /* sp_ActiveDirectory_Obj */ /**************************************************************/ if exists (select * from sysobjects where name = N'sp_ActiveDirectory_Obj' and type = N'P') drop procedure sp_ActiveDirectory_Obj go print N'' print N'Creating procedure sp_ActiveDirectory_Obj...' go create proc dbo.sp_ActiveDirectory_Obj @Action nvarchar(10) = N'create', -- create, update, delete @ObjType nvarchar(15) = N'database', -- database, publication @ObjName sysname = null, -- object name @DatabaseName sysname = null, -- database name for publication object @GUIDName sysname = null -- GUID for publication update and delete as begin /* create : create the object under the current SCP object. */ /* update : update the object under the SCP object. */ /* delete : delete the object under the SCP object. */ SET NOCOUNT ON DECLARE @isdbowner int DECLARE @cmd nvarchar(255) DECLARE @commonname nvarchar(300) DECLARE @retcode int DECLARE @nAction nvarchar(3) DECLARE @Tmp nvarchar(10) DECLARE @dbname sysname DECLARE @retval int DECLARE @SQLADSI_COM_ERROR int DECLARE @SQLADSI_UNEXP_ERROR int DECLARE @SQLADSI_SCP_NOT_FOUND int DECLARE @SQLADSI_SVC_ACCT_ERROR int DECLARE @SQLADSI_CANNOT_START_HLP int DECLARE @SQLADSI_TIMEOUT_WAIT_HLP int DECLARE @SQLADSI_AD_NOT_INSTALLED int DECLARE @SQLADSI_PROXY_ACCT_ERROR int SELECT @SQLADSI_COM_ERROR = 536870913 SELECT @SQLADSI_UNEXP_ERROR = 536870914 SELECT @SQLADSI_SCP_NOT_FOUND = 536870915 SELECT @SQLADSI_SVC_ACCT_ERROR = 536870916 SELECT @SQLADSI_CANNOT_START_HLP = 536870917 SELECT @SQLADSI_TIMEOUT_WAIT_HLP = 536870918 SELECT @SQLADSI_AD_NOT_INSTALLED = 536870919 SELECT @SQLADSI_PROXY_ACCT_ERROR = 536870920 /* check permissions IF (not is_srvrolemember(N'sysadmin') = 1) begin raiserror(15003,-1,-1, N'sysadmin') return 1 end */ /* If publication object, we need both object name and database name */ if ((UPPER(@ObjType) in (N'PUBLICATION')) and ((@ObjName is null) or (@DatabaseName is null))) begin raiserror(14200, -1, -1, N'@ObjName or @DatabaseName') return 1 end /* check parameters */ if (@Action is null OR UPPER(@Action) not in (N'CREATE', N'UPDATE', N'DELETE')) begin raiserror(14266, -1, -1, N'@Action', N'CREATE, UPDATE, DELETE') return 1 end if (@ObjType is null OR UPPER(@ObjType) not in (N'DATABASE', N'REPOSITORY', N'PUBLICATION')) begin raiserror(14266, -1, -1, N'@ObjType', N'DATABASE, REPOSITORY, PUBLICATION') return 1 end if (@ObjName is null) begin raiserror(14200, -1, -1, N'@ObjName') return 1 end /* If publication object update or delete, we need GUID also */ if ((UPPER(@ObjType) in (N'PUBLICATION')) and UPPER(@Action) in (N'UPDATE', N'DELETE') and (@GUIDName is null)) begin raiserror(14200, -1, -1, N'@GUIDNName') return 1 end if (UPPER(@ObjType) in (N'PUBLICATION')) select @dbname = @DatabaseName else select @dbname = @ObjName -- Make sure the database exists -- if not exists (select * from master.dbo.sysdatabases where name = @dbname) begin raiserror(15010,-1,-1,@dbname) return (1) end /* Check permissions. */ SELECT @cmd = 'USE ' + quotename(@dbname) + ' SELECT @isdbowner = is_member(''db_owner'')' EXEC @retcode = sp_executesql @cmd, N'@isdbowner int output', @isdbowner output IF @@error <> 0 or @retcode <> 0 return 1 IF (is_srvrolemember('sysadmin') <> 1 and isnull(@isdbowner, 0) <> 1) BEGIN raiserror(21050, 14, -1) return 1 END /* common name length check */ if (UPPER(@ObjType) in (N'PUBLICATION')) SELECT @commonname = @ObjName + N':' + @DatabaseName else SELECT @commonname = @ObjName IF (LEN(@commonname) > 64) RAISERROR(14357, -1, -1, @commonname) select @Tmp = UPPER(@Action) if (UPPER(@Tmp) like N'CRE%') select @nAction = N'1' else if (UPPER(@Tmp) like N'UPD%') select @nAction = N'2' else if (UPPER(@Tmp) like N'DEL%') select @nAction = N'3' declare @nObjType nvarchar(3) select @Tmp = UPPER(@ObjType) if (UPPER(@Tmp) like N'DATAB%') select @nObjType = N'2' else if (UPPER(@Tmp) like N'REPOS%') select @nObjType = N'3' else if (UPPER(@Tmp) like N'PUBL%') select @nObjType = N'4' /* are we running on Windows 2000 or NT4 SP5 with AD enabled? continue only if TRUE */ EXECUTE @retval = master.dbo.xp_MSADEnabled if (@retval = 0) begin /* prepare parameters */ declare @InstanceName