DZone Snippets: Mornlee's Code Snippets

ISAPI URL Rewrite

mornlee (mornlee) — Fri, 29 Jun 2007 08:01:32 GMT

// description of your code here



#include 

#include 



#define MAX_URL_LEN 4096



BOOL WINAPI GetFilterVersion(HTTP_FILTER_VERSION * pVer)

{

      pVer->dwFlags = (SF_NOTIFY_SECURE_PORT | SF_NOTIFY_NONSECURE_PORT | SF_NOTIFY_PREPROC_HEADERS | SF_NOTIFY_ORDER_HIGH);

      pVer->dwFilterVersion = HTTP_FILTER_REVISION;

      strcpy_s(pVer->lpszFilterDesc,9,"Blah blah blah");

      return TRUE;

}



void ReMapURLs(CHAR* pUrl,HTTP_FILTER_CONTEXT* pfc,PHTTP_FILTER_PREPROC_HEADERS pHeaders)

{

      if (pUrl[0] != '/') return;



      CHAR *iUrl = 0;

      BOOL doSet = FALSE;



      char *sOldUrls[] = { "/test/", "/TEST/" };

      char *sNewUrls[] = { "/go/", "/GO/" };



      for (int i=0; i<2; i++)

      {

            if (iUrl = strstr(pUrl,sOldUrls[i]))

            {

                  doSet = TRUE;

                  memcpy(iUrl,sNewUrls[i],strlen(sNewUrls[i]));

            }

      }



      if (doSet) pHeaders->SetHeader(pfc, "url", pUrl);

}



DWORD WINAPI HttpFilterProc(HTTP_FILTER_CONTEXT *pfc,DWORD NotificationType,VOID * pvData)

{

      PHTTP_FILTER_PREPROC_HEADERS pHeaders;

      DWORD cUrlOrig = MAX_URL_LEN;

      DWORD cUrl = cUrlOrig;

      CHAR rgUrl[MAX_URL_LEN];

      CHAR *pUrl;

      BOOL result;



      switch ( NotificationType )

      {

            case SF_NOTIFY_PREPROC_HEADERS:

                  pHeaders = (PHTTP_FILTER_PREPROC_HEADERS) pvData;

                  result = pHeaders->GetHeader(pfc, "url", rgUrl, &cUrl);



                  if (!result && cUrl > cUrlOrig)

                  {

                        pUrl = (CHAR*)LocalAlloc(0, cUrl);

                        result = pHeaders->GetHeader(pfc, "url", pUrl, &cUrl);

                        if (!result)

                        {

                              LocalFree(pUrl);

                              break;

                        }

                        ReMapURLs(pUrl, pfc, pHeaders);

                        LocalFree(pUrl);

                  }

                  else

                        ReMapURLs(rgUrl, pfc, pHeaders);

                  break;

            default:

                  break;

      }

      return SF_STATUS_REQ_NEXT_NOTIFICATION;

}

SQL 2005 TSQL Script to list tables, indexes, file groups along with file names

mornlee (mornlee) — Mon, 25 Jun 2007 15:16:09 GMT

// description of your code here



select 'table_name'=object_name(i.id)  ,i.indid

,'index_name'=i.name  ,i.groupid

,'filegroup'=f.name  ,'file_name'=d.physical_name

,'dataspace'=s.name from sys.sysindexes i

,sys.filegroups f  ,sys.database_files d

,sys.data_spaces s

where objectproperty(i.id,'IsUserTable') = 1

and f.data_space_id = i.groupid

and f.data_space_id = d.data_space_id

and f.data_space_id = s.data_space_id

order by f.name,object_name(i.id),groupid

go

HTTP Post

mornlee (mornlee) — Wed, 20 Jun 2007 21:43:44 GMT

// description of your code here



            HttpWebRequest  request = (HttpWebRequest)WebRequest.Create(URL);



            byte[]    postDataBytes = Encoding.ASCII.GetBytes(postData);

            request.AllowAutoRedirect = true;



            request.Method        = "POST";

            request.ContentType   = "application/x-www-form-urlencoded";

            request.ContentLength = postDataBytes.Length;

            request.Referer = URL;

            request.UserAgent = "Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4";

            request.Accept = "text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5";

            request.Headers.Add("Accept-Language","en-us,en;q=0.5");

            request.Headers.Add("Accept-Encoding","gzip,deflate");

            request.Headers.Add("Accept-Charset","ISO-8859-1,utf-8;q=0.7,*;q=0.7");

            

            if (cookie != "")

                request.Headers.Add("Cookie",cookie);



            Stream requestStream  = request.GetRequestStream();



            requestStream.Write(postDataBytes, 0 ,postDataBytes.Length);

            requestStream.Close();

	    

	    request.CookieContainer = new CookieContainer();

            // Get response

            resp = (HttpWebResponse)request.GetResponse();

            StreamReader responseReader =  new StreamReader(resp.GetResponseStream());

XML file to SQL

mornlee (mornlee) — Mon, 18 Jun 2007 09:54:58 GMT

// XML file to SQL



CREATE TABLE XmlImportTest ( xmlFileName VARCHAR(300), xml_data xml ) 

GO 

DECLARE @xmlFileName VARCHAR(300) 

SELECT @xmlFileName = 'c:\TestXml.xml' 

-- dynamic sql is just so we can use @xmlFileName variable in OPENROWSET 

EXEC(' INSERT INTO XmlImportTest(xmlFileName, xml_data) SELECT ''' + @xmlFileName + ''', xmlData FROM ( SELECT * FROM OPENROWSET (BULK ''' + @xmlFileName + ''' , SINGLE_BLOB) AS XMLDATA ) AS FileImport (XMLDATA) ') 

GO 

SELECT * FROM XmlImportTest 

DROP TABLE XmlImportTest

Digg Del.icio.us DotNetKicks javascript snippets

mornlee (mornlee) — Fri, 20 Oct 2006 05:57:13 GMT

// description of your code here















		

			Add to del.icio.us

Cool Effects in Browser

mornlee (mornlee) — Sun, 15 Oct 2006 07:12:49 GMT

// description of your code here



javascript:R=0; x1=.1; y1=.05; x2=.25; y2=.24; x3=1.6; y3=.24; x4=300; y4=200; x5=300; y5=200; DI=document.images; DIL=DI.length; function A(){for(i=0; i-DIL; i++){DIS=DI[ i ].style; DIS.position='absolute'; DIS.left=Math.sin(R*x1+i*x2+x3)*x4+x5; DIS.top=Math.cos(R*y1+i*y2+y3)*y4+y5}R++}setInterval('A()',5); void(0);

èŽ·å?–Exchangeæœªè¯»é‚®ä»¶æ•°

mornlee (mornlee) — Sun, 15 Oct 2006 07:10:59 GMT

// description of your code here



private int GetUnReadMailCount()

{

string url=â€œhttp://mail.felixwoo.com/exchange/â€?; //æŒ‡å®šExchangeæœ?åŠ¡å™¨åœ°å?€ 

System.Net.HttpWebRequest Request;

System.Net.WebResponse Response;

System.Net.CredentialCache MyCredentialCache;

string strUserName = â€œwufâ€?; //æŒ‡å®šç™»å½•çš„ç”¨æˆ·å??

string strRootURI = url+strUserName ; //å¾—åˆ°è¦?è®¿é—®é‚®ç®±çš„WebDAVåœ°å?€

string strPassword = â€œ123456â€?; //æŒ‡å®šè¯¥ç”¨æˆ·çš„å¯†ç ?

string strDomain = â€œfelixwoo.comâ€?; //æŒ‡å®šåŸŸå??

string strQuery ="";

byte[] bytes = null;

System.IO.Stream RequestStream = null;

System.IO.Stream ResponseStream = null;

XmlDocument ResponseXmlDoc = null;

XmlNodeList HrefNodes= null;

XmlNodeList SizeNodes= null;

int count=0;

try

{

  // ç”¨SQLæŸ¥è¯¢WebDAVè¿”å›žç»“æžœä¸çš„unreadcountèŠ‚ç‚¹.

  strQuery = ""

   + "SELECT \"DAV:displayname\",\"urn:schemas:httpmail:unreadcount\" FROM \"" + strRootURI + "\""

   + "";



  // åˆ›å»ºæ–°çš„CredentialCacheå¯¹è±¡ï¼Œæž„å»ºèº«ä»½å‡æ?®

  MyCredentialCache = new System.Net.CredentialCache();

  MyCredentialCache.Add( new System.Uri(strRootURI),

   "NTLM",

   new System.Net.NetworkCredential(strUserName, strPassword, strDomain)

   );



  // Create the HttpWebRequest object.

  Request = (System.Net.HttpWebRequest)HttpWebRequest.Create(strRootURI);



  // æŒ‡å®šHttpWebRequestçš„èº«ä»½å‡æ?®ï¼Œæ¤å¤„ä¸ºå…³é”®æ‰€åœ¨ã€‚å¦‚æžœä½¿ç”¨ä¹‹å‰?

  // åˆ›å»ºçš„MyCredentialCacheï¼Œåˆ™è¿™ä¸ªèº«ä»½å‡æ?®æ˜¯å?¯ä»¥ä»ŽWebæœ?åŠ¡å™¨ä¼ é€’

  // åˆ°Exchangeæœ?åŠ¡å™¨çš„ï¼Œä½†æ˜¯è¿™æ ·å¸¦æ?¥çš„é—®é¢˜ä¹Ÿå¾ˆæ˜Žæ˜¾ï¼Œå°±æ˜¯ä¸?èƒ½å¤Ÿè‡ª

  // åŠ¨èŽ·å?–å½“å‰?ç™»å½•åˆ°åŸŸçš„ç”¨æˆ·çš„èº«ä»½ã€‚å?³ä¾¿å·²ç»?æˆ?åŠŸç™»å½•åˆ°åŸŸï¼Œé‚£ä¹Ÿå?ª

  // èƒ½é€šè¿‡formå†?æ¬¡è¾“å…¥ç”¨æˆ·å??å¯†ç ?ã€‚å› æ¤ï¼Œæˆ‘åœ¨è¿™é‡Œç”¨çš„æ˜¯

  // Request.Credentials = CredentialCache.DefaultCredentialsï¼Œ

  // è¿™æ ·ä¾¿å?¯ä»¥èŽ·å¾—å½“å‰?ç”¨æˆ·çš„å‡æ?®ï¼Œä½†æ˜¯è¿™æ ·å¸¦æ?¥çš„é—®é¢˜ä¾¿æ˜¯ä¸Šé?¢æ??åˆ°çš„

  // èº«ä»½å‡æ?®æ— æ³•ä¼ é€’çš„é—®é¢˜ï¼Œè§£å†³æ–¹æ³•è¯·å…³æ³¨ä¸‹ç¯‡æ–‡ç« ã€‚

  Request.Credentials = MyCredentialCache;



  // æŒ‡å®šWebDAVçš„SEARCHæ–¹æ³•

  Request.Method = "SEARCH";



  // Encode the body using UTF-8.

  bytes = Encoding.UTF8.GetBytes((string)strQuery);



  // Set the content header length. This must be

  // done before writing data to the request stream.

  Request.ContentLength = bytes.Length;



  // Get a reference to the request stream.

  RequestStream = Request.GetRequestStream();



  // Write the SQL query to the request stream.

  RequestStream.Write(bytes, 0, bytes.Length);



  // Close the Stream object to release the connection

  // for further use.

  RequestStream.Close();



  // Set the content type header.

  Request.ContentType = "text/xml";



  // Send the SEARCH method request and get the

  // response from the server.

  Response = (HttpWebResponse)Request.GetResponse();



  // Get the XML response stream.

  ResponseStream = Response.GetResponseStream();



  // åˆ›å»ºXmlDocumentå¯¹è±¡ï¼Œå¹¶èŽ·å?–æ”¶ä»¶ç®±çš„unreadcountèŠ‚ç‚¹çš„å€¼

  ResponseXmlDoc = new XmlDocument();

  ResponseXmlDoc.Load(ResponseStream);

  HrefNodes = ResponseXmlDoc.GetElementsByTagName("a:displayname");

  SizeNodes = ResponseXmlDoc.GetElementsByTagName("d:unreadcount");

  for(int i=0;i  {

   if(HrefNodes[i].InnerText=="æ”¶ä»¶ç®±")

    count=int.Parse(SizeNodes[i].InnerText);

  }

  ResponseStream.Close();

  Response.Close();

}

catch(Exception)

{

  // Catch any exceptions. Any error codes from the SEARCH

  // method request on the server will be caught here, also.

  return -1;

}

return count;

}

èŽ·å?–å½“å‰?ç™»é™†ç”¨æˆ·çš„ç™»é™†å??

mornlee (mornlee) — Sun, 15 Oct 2006 04:24:55 GMT

// description of your code here



http://support.microsoft.com/default.aspx?scid=kb;zh-CN;832769

//èŽ·å?–å½“å‰?ç™»é™†ç”¨æˆ·çš„ç™»é™†å?? 

WindowsPrincipal wp = (WindowsPrincipal)Thread.CurrentPrincipal; 

string wpname = wp.Identity.Name.ToString(); 

int j = wpname.LastIndexOf("\\"); 

string userName = wpname.Substring(j+1); 

string domainName = wpname.Substring(0,j);

javascript

mornlee (mornlee) — Fri, 10 Feb 2006 13:06:59 GMT

// description of your code here

Search box

mornlee (mornlee) — Thu, 09 Feb 2006 07:05:45 GMT

// description of your code here











  







Artists similar to: 



Artists named:



Artists near zipcode: 





Artists in genre: 





Events near zipcode: 





Search whole site: