{"id":9286,"date":"2024-06-20T09:28:00","date_gmt":"2024-06-20T00:28:00","guid":{"rendered":"https:\/\/www.auctionpro.co.kr\/?p=9286"},"modified":"2025-05-13T16:02:34","modified_gmt":"2025-05-13T07:02:34","slug":"sql-%ec%9d%b8%ec%a0%9d%ec%85%98-%ec%8b%9c%eb%8f%84-%ec%b0%a8%eb%8b%a8","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=9286","title":{"rendered":"SQL \uc778\uc81d\uc158 \uc2dc\ub3c4 \ucc28\ub2e8"},"content":{"rendered":"\n<p>\uc6cc\ub4dc\ud504\ub808\uc2a4\uc5d0\uc11c \ud2b9\uc815\ud55c SQL \uc778\uc81d\uc158 \uc2dc\ub3c4\uc640 \uac19\uc774 \uc704\ud5d8\ud55c \ud30c\ub77c\uba54\ud130\ub97c \ucc28\ub2e8\ud558\ub294 \ubc29\ubc95\uc5d0\ub294 \uc5ec\ub7ec \uac00\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc81c\uc2dc\ub41c \ud30c\ub77c\uba54\ud130\ub294 SQL \uc778\uc81d\uc158 \uacf5\uaca9\uc744 \uc2dc\ub3c4\ud558\ub294 \uac83\uc73c\ub85c \ubcf4\uc785\ub2c8\ub2e4. \uc774\ub97c \ubc29\uc9c0\ud558\uae30 \uc704\ud55c \uba87 \uac00\uc9c0 \ubc29\ubc95\uc744 \uc18c\uac1c\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\uc6f9 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158 \ubc29\ud654\ubcbd(WAF) \uc0ac\uc6a9<\/strong>: \uc6cc\ub4dc\ud504\ub808\uc2a4 \uc0ac\uc774\ud2b8\ub97c \ubcf4\ud638\ud558\ub294 \uac00\uc7a5 \ud6a8\uacfc\uc801\uc778 \ubc29\ubc95 \uc911 \ud558\ub098\ub294 WAF\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. WAF\ub294 \uc545\uc758\uc801\uc778 \ud2b8\ub798\ud53d\uacfc \uacf5\uaca9\uc744 \ucc28\ub2e8\ud558\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, Cloudflare\ub098 Sucuri\uc640 \uac19\uc740 \uc11c\ube44\uc2a4\ub294 SQL \uc778\uc81d\uc158 \uacf5\uaca9\uc744 \uc790\ub3d9\uc73c\ub85c \ucc28\ub2e8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\ubcf4\uc548 \ud50c\ub7ec\uadf8\uc778 \uc124\uce58<\/strong>: \uc5ec\ub7ec \uc6cc\ub4dc\ud504\ub808\uc2a4 \ubcf4\uc548 \ud50c\ub7ec\uadf8\uc778\uc774 SQL \uc778\uc81d\uc158\uacfc \uac19\uc740 \uacf5\uaca9\uc744 \ub9c9\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, &#8216;Wordfence Security&#8217;\ub098 &#8216;iThemes Security&#8217;\ub294 \uc545\uc758\uc801\uc778 \uc694\uccad\uc744 \uac10\uc9c0\ud558\uace0 \ucc28\ub2e8\ud558\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>.htaccess \ud30c\uc77c \uc218\uc815<\/strong>: \uc6f9\uc11c\ubc84\uc758 \uc124\uc815 \ud30c\uc77c\uc778 .htaccess\ub97c \uc218\uc815\ud558\uc5ec \ud2b9\uc815 \uc720\ud615\uc758 \uc694\uccad\uc744 \ucc28\ub2e8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub2e4\uc74c\uacfc \uac19\uc740 \uaddc\uce59\uc744 \ucd94\uac00\ud558\uc5ec SQL \uc778\uc81d\uc158\uc744 \uc2dc\ub3c4\ud558\ub294 \ucffc\ub9ac \ubb38\uc790\uc5f4\uc744 \ud3ec\ud568\ud55c \uc694\uccad\uc744 \ucc28\ub2e8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \">RewriteEngine On\nRewriteCond %{QUERY_STRING} (\\%27)|(\\')|(\\-\\-)|(\\%23)|(#)\nRewriteRule .* - [F]\n<\/pre><\/div>\n\n\n\n<p>\uc774 \uaddc\uce59\uc740 \uc77c\ubc18\uc801\uc778 SQL \uc778\uc81d\uc158 \ud328\ud134\uc744 \ud3ec\ud568\ud55c \uc694\uccad\uc744 \ucc3e\uc544\ub0b4\uc11c \ucc28\ub2e8\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">RewriteEngine On<\/h3>\n\n\n\n<p>\uc774 \ub77c\uc778\uc740 URL \uc7ac\uc791\uc131 \uc5d4\uc9c4\uc744 \ud65c\uc131\ud654\ud569\ub2c8\ub2e4. Apache \uc6f9 \uc11c\ubc84\ub294 <code>.htaccess<\/code> \ud30c\uc77c\uc5d0\uc11c URL \uc7ac\uc791\uc131 \uaddc\uce59\uc744 \uc801\uc6a9\ud558\uae30 \uc704\ud574 RewriteEngine\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc774 \uc124\uc815\uc774 \ucf1c\uc838 \uc788\uc5b4\uc57c \ub098\uba38\uc9c0 \uc7ac\uc791\uc131 \uaddc\uce59\uc774 \uc791\ub3d9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">RewriteCond %{QUERY_STRING} (%27)|(&#8216;)|(&#8211;)|(%23)|(#)<\/h3>\n\n\n\n<p>\uc774 \ub77c\uc778\uc740 \uc870\uac74\uc744 \uc124\uc815\ud558\ub294 \uac83\uc73c\ub85c, \ud2b9\uc815 \uc870\uac74\uc774 \ub9cc\uc871\ub420 \ub54c\ub9cc \uc544\ub798\uc758 RewriteRule\uc774 \uc801\uc6a9\ub429\ub2c8\ub2e4. \uc5ec\uae30\uc11c <code>%{QUERY_STRING}<\/code>\uc740 \uc694\uccad\ub41c URL\uc758 \ucffc\ub9ac \ubb38\uc790\uc5f4\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \uad04\ud638 \uc548\uc758 \ud328\ud134\uc740 \ucc28\ub2e8\ud558\ub824\ub294 \ud2b9\uc815 \ubb38\uc790\uc5f4\uc744 \ud3ec\ud568\ud558\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>(\\%27)<\/code>: <code>%27<\/code>\uc740 URL \uc778\ucf54\ub529\ub41c \uc544\ud3ec\uc2a4\ud2b8\ub85c\ud53c(\u2018)\uc785\ub2c8\ub2e4. \uc774\ub97c \ud3ec\ud568\ud558\ub294 \ucffc\ub9ac \ubb38\uc790\uc5f4\uc744 \ucc28\ub2e8\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>(\\')<\/code>: \uc9c1\uc811 \uc785\ub825\ub41c \uc544\ud3ec\uc2a4\ud2b8\ub85c\ud53c(\u2018)\ub97c \ud3ec\ud568\ud558\ub294 \ucffc\ub9ac \ubb38\uc790\uc5f4\uc744 \ucc28\ub2e8\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>(\\-\\-)<\/code>: SQL \uc8fc\uc11d \uc2dc\uc791 \ubb38\uc790\uc5f4 <code>--<\/code>\ub97c \ud3ec\ud568\ud558\ub294 \ucffc\ub9ac \ubb38\uc790\uc5f4\uc744 \ucc28\ub2e8\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>(\\%23)<\/code>: <code>%23<\/code>\uc740 URL \uc778\ucf54\ub529\ub41c \uc0f5(#) \uae30\ud638\uc785\ub2c8\ub2e4. \uc774\ub97c \ud3ec\ud568\ud558\ub294 \ucffc\ub9ac \ubb38\uc790\uc5f4\uc744 \ucc28\ub2e8\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>(#)<\/code>: \uc9c1\uc811 \uc785\ub825\ub41c \uc0f5(#) \uae30\ud638\ub97c \ud3ec\ud568\ud558\ub294 \ucffc\ub9ac \ubb38\uc790\uc5f4\uc744 \ucc28\ub2e8\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p>\uc774 \ud328\ud134\ub4e4\uc740 SQL \uc778\uc81d\uc158 \uacf5\uaca9\uc5d0\uc11c \uc790\uc8fc \uc0ac\uc6a9\ub418\ub294 \ubb38\uc790\ub4e4\uc744 \ud3ec\ud568\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">RewriteRule .* &#8211; [F]<\/h3>\n\n\n\n<p>\uc774 \ub77c\uc778\uc740 \uc870\uac74\uc774 \ub9cc\uc871\ub420 \ub54c \uc801\uc6a9\ub418\ub294 \uaddc\uce59\uc744 \uc815\uc758\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>.*<\/code>: \ubaa8\ub4e0 \uc694\uccad\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>-<\/code>: \uc7ac\uc791\uc131\ud560 URL\uc774 \uc5c6\uc74c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \uc989, URL\uc744 \ubcc0\uacbd\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>[F]<\/code>: Forbidden\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. \uc870\uac74\uc774 \ub9cc\uc871\ub418\uba74 \uc11c\ubc84\ub294 403 Forbidden \uc0c1\ud0dc \ucf54\ub4dc\ub97c \ubc18\ud658\ud558\uace0 \uc694\uccad\uc744 \ucc28\ub2e8\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\uc885\ud569 \uc124\uba85<\/h3>\n\n\n\n<p>\uc774 <code>.htaccess<\/code> \uc124\uc815\uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \uc694\uccad\uc744 \ucc28\ub2e8\ud569\ub2c8\ub2e4:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>URL \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 URL \uc778\ucf54\ub529\ub41c \uc544\ud3ec\uc2a4\ud2b8\ub85c\ud53c(<code>%27<\/code>)\uac00 \ud3ec\ud568\ub41c \uacbd\uc6b0<\/li>\n\n\n\n<li>URL \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 \uc9c1\uc811 \uc785\ub825\ub41c \uc544\ud3ec\uc2a4\ud2b8\ub85c\ud53c(<code>'<\/code>)\uac00 \ud3ec\ud568\ub41c \uacbd\uc6b0<\/li>\n\n\n\n<li>URL \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 SQL \uc8fc\uc11d \uc2dc\uc791 \ubb38\uc790\uc5f4(<code>--<\/code>)\uc774 \ud3ec\ud568\ub41c \uacbd\uc6b0<\/li>\n\n\n\n<li>URL \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 URL \uc778\ucf54\ub529\ub41c \uc0f5 \uae30\ud638(<code>%23<\/code>)\uac00 \ud3ec\ud568\ub41c \uacbd\uc6b0<\/li>\n\n\n\n<li>URL \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 \uc9c1\uc811 \uc785\ub825\ub41c \uc0f5 \uae30\ud638(<code>#<\/code>)\uac00 \ud3ec\ud568\ub41c \uacbd\uc6b0<\/li>\n<\/ul>\n\n\n\n<p>\uc774\ub97c \ud1b5\ud574 SQL \uc778\uc81d\uc158 \uacf5\uaca9\uc744 \uc2dc\ub3c4\ud558\ub294 \uc545\uc758\uc801\uc778 \uc694\uccad\uc744 \ucc28\ub2e8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <code>.htaccess<\/code> \ud30c\uc77c\uc744 \uc218\uc815\ud55c \ud6c4, \uc6f9 \uc11c\ubc84\ub97c \ub2e4\uc2dc \uc2dc\uc791\ud558\uac70\ub098 \uad6c\uc131\uc744 \uc0c8\ub85c \uace0\uccd0\uc57c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ubcc0\uacbd \uc0ac\ud56d\uc774 \uc801\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \">RewriteEngine on\nRewriteCond %{HTTP_REFERER} !^$\nRewriteCond %{HTTP_REFERER} !^https:\/\/www.auctionpro.co.kr [NC]\nRewriteCond %{HTTP_REFERER} !^http(s)?:\/\/(www.)?google.com [NC]\nRewriteRule .(jpg|jpeg|png|gif)$ \u2013 [NC,F,L]<\/pre><\/div>\n\n\n\n<p>\uc704\uc758 <code>.htaccess<\/code> \ud30c\uc77c \ub0b4\uc6a9\uc740 \ud2b9\uc815 \uc0ac\uc774\ud2b8\uc5d0\uc11c\ub9cc \uc774\ubbf8\uc9c0 \ud30c\uc77c\uc744 \ucc38\uc870\ud560 \uc218 \uc788\ub3c4\ub85d \uc81c\ud55c\ud558\ub294 \uc124\uc815\uc785\ub2c8\ub2e4. \uac01 \ub77c\uc778\uc758 \uc758\ubbf8\ub97c \uc790\uc138\ud788 \uc124\uba85\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">RewriteEngine on<\/h3>\n\n\n\n<p>\uc774 \ub77c\uc778\uc740 URL \uc7ac\uc791\uc131 \uc5d4\uc9c4\uc744 \ud65c\uc131\ud654\ud569\ub2c8\ub2e4. Apache \uc6f9 \uc11c\ubc84\ub294 <code>.htaccess<\/code> \ud30c\uc77c\uc5d0\uc11c URL \uc7ac\uc791\uc131 \uaddc\uce59\uc744 \uc801\uc6a9\ud558\uae30 \uc704\ud574 RewriteEngine\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc774 \uc124\uc815\uc774 \ucf1c\uc838 \uc788\uc5b4\uc57c \ub098\uba38\uc9c0 \uc7ac\uc791\uc131 \uaddc\uce59\uc774 \uc791\ub3d9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">RewriteCond %{HTTP_REFERER} !^$<\/h3>\n\n\n\n<p>\uc774 \ub77c\uc778\uc740 HTTP_REFERER \ud5e4\ub354\uac00 \ube44\uc5b4 \uc788\uc9c0 \uc54a\uc744 \ub54c\ub9cc \uc870\uac74\uc744 \ub9cc\uc871\ud558\ub3c4\ub85d \ud569\ub2c8\ub2e4. HTTP_REFERER\ub294 \uc0ac\uc6a9\uc790\uac00 \uc774\uc804\uc5d0 \ubc29\ubb38\ud55c \ud398\uc774\uc9c0\uc758 URL\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. <code>!^$<\/code>\ub294 \ube48 \ubb38\uc790\uc5f4\uc774 \uc544\ub2cc \uacbd\uc6b0\ub97c \uc758\ubbf8\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">RewriteCond %{HTTP_REFERER} !^<a href=\"https:\/\/www.auctionpro.co.kr\">https:\/\/www.auctionpro.co.kr<\/a> [NC]<\/h3>\n\n\n\n<p>\uc774 \ub77c\uc778\uc740 HTTP_REFERER \ud5e4\ub354\uac00 <code>https:\/\/www.auctionpro.co.kr<\/code>\ub85c \uc2dc\uc791\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0 \uc870\uac74\uc744 \ub9cc\uc871\ud558\uac8c \ud569\ub2c8\ub2e4. <code>[NC]<\/code>\ub294 \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\uc9c0 \uc54a\ub3c4\ub85d \ud569\ub2c8\ub2e4 (No Case-sensitive).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">RewriteCond %{HTTP_REFERER} !^http(s)?:\/\/(<a href=\"http:\/\/www.)?google.com\">www.)?google.com<\/a> [NC]<\/h3>\n\n\n\n<p>\uc774 \ub77c\uc778\uc740 HTTP_REFERER \ud5e4\ub354\uac00 <code>http:\/\/www.google.com<\/code>, <code>https:\/\/www.google.com<\/code>, <code>http:\/\/google.com<\/code>, \ub610\ub294 <code>https:\/\/google.com<\/code>\ub85c \uc2dc\uc791\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0 \uc870\uac74\uc744 \ub9cc\uc871\ud558\uac8c \ud569\ub2c8\ub2e4. <code>http(s)?<\/code>\ub294 <code>http<\/code> \ub610\ub294 <code>https<\/code>\ub97c \uc758\ubbf8\ud558\uba70, <code>(www\\.)?<\/code>\ub294 <code>www.<\/code>\uac00 \uc788\uc744 \uc218\ub3c4 \uc788\uace0 \uc5c6\uc744 \uc218\ub3c4 \uc788\uc74c\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. <code>[NC]<\/code>\ub294 \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\uc9c0 \uc54a\ub3c4\ub85d \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">RewriteRule .(jpg|jpeg|png|gif)$ \u2013 [NC,F,L]<\/h3>\n\n\n\n<p>\uc774 \ub77c\uc778\uc740 \uc870\uac74\uc774 \ub9cc\uc871\ub420 \ub54c \uc801\uc6a9\ub418\ub294 \uaddc\uce59\uc744 \uc815\uc758\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>\\.(jpg|jpeg|png|gif)$<\/code>: URL\uc774 <code>.jpg<\/code>, <code>.jpeg<\/code>, <code>.png<\/code>, \ub610\ub294 <code>.gif<\/code>\ub85c \ub05d\ub098\ub294 \uacbd\uc6b0\ub97c \uc758\ubbf8\ud569\ub2c8\ub2e4. \uc774\ub294 \uc774\ubbf8\uc9c0 \ud30c\uc77c\uc744 \ub300\uc0c1\uc73c\ub85c \ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>\u2013<\/code>: \uc7ac\uc791\uc131\ud560 URL\uc774 \uc5c6\uc74c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \uc989, URL\uc744 \ubcc0\uacbd\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>[NC]<\/code>: \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\uc9c0 \uc54a\ub3c4\ub85d \ud569\ub2c8\ub2e4 (No Case-sensitive).<\/li>\n\n\n\n<li><code>[F]<\/code>: Forbidden\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. \uc870\uac74\uc774 \ub9cc\uc871\ub418\uba74 \uc11c\ubc84\ub294 403 Forbidden \uc0c1\ud0dc \ucf54\ub4dc\ub97c \ubc18\ud658\ud558\uace0 \uc694\uccad\uc744 \ucc28\ub2e8\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>[L]<\/code>: \uc774 \uaddc\uce59\uc774 \ub9c8\uc9c0\ub9c9 \uaddc\uce59\uc784\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \uc774 \uaddc\uce59\uc774 \uc801\uc6a9\ub418\uba74 \ub354 \uc774\uc0c1\uc758 \uc7ac\uc791\uc131 \uaddc\uce59\uc744 \uc801\uc6a9\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\uc885\ud569 \uc124\uba85<\/h3>\n\n\n\n<p>\uc774 <code>.htaccess<\/code> \uc124\uc815\uc740 \uc774\ubbf8\uc9c0 \ud30c\uc77c (<code>.jpg<\/code>, <code>.jpeg<\/code>, <code>.png<\/code>, <code>.gif<\/code>)\uc5d0 \ub300\ud55c \uc694\uccad\uc744 \ucc28\ub2e8\ud569\ub2c8\ub2e4. \ub2e4\ub9cc, \ub2e4\uc74c \uc870\uac74\uc5d0 \ud574\ub2f9\ud558\ub294 \uacbd\uc6b0\ub294 \uc608\uc678\uc785\ub2c8\ub2e4:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>HTTP_REFERER \ud5e4\ub354\uac00 \ube44\uc5b4 \uc788\ub294 \uacbd\uc6b0 (\uc9c1\uc811 URL\uc744 \uc785\ub825\ud558\uac70\ub098 \ubd81\ub9c8\ud06c\uc5d0\uc11c \uc811\uadfc\ud558\ub294 \uacbd\uc6b0)<\/li>\n\n\n\n<li>HTTP_REFERER \ud5e4\ub354\uac00 <code>https:\/\/www.auctionpro.co.kr<\/code>\ub85c \uc2dc\uc791\ud558\ub294 \uacbd\uc6b0<\/li>\n\n\n\n<li>HTTP_REFERER \ud5e4\ub354\uac00 <code>http(s):\/\/(www.)?google.com<\/code>\ub85c \uc2dc\uc791\ud558\ub294 \uacbd\uc6b0<\/li>\n<\/ul>\n\n\n\n<p>\uc774\ub97c \ud1b5\ud574 \uc774\ubbf8\uc9c0 \ud30c\uc77c\uc774 \ud2b9\uc815 \uc0ac\uc774\ud2b8\uc5d0\uc11c\ub9cc \ucc38\uc870\ub420 \uc218 \uc788\ub3c4\ub85d \uc81c\ud55c\ud558\uc5ec \ubb34\ub2e8 \ub9c1\ud06c\ub97c \ubc29\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <code>.htaccess<\/code> \ud30c\uc77c\uc744 \uc218\uc815\ud55c \ud6c4, \uc6f9 \uc11c\ubc84\ub97c \ub2e4\uc2dc \uc2dc\uc791\ud558\uac70\ub098 \uad6c\uc131\uc744 \uc0c8\ub85c \uace0\uccd0\uc57c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ubcc0\uacbd \uc0ac\ud56d\uc774 \uc801\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>4o<\/p>\n\n\n\n<p>IIS \uc5d0\uc11c\ub3c4 \uc791\ub3d9\ud558\uac8c \ud558\ub294 \ubc29\ubc95ChatGPT<\/p>\n\n\n\n<p>IIS(Internet Information Services)\uc5d0\uc11c \uc704\uc640 \uac19\uc740 \ub9ac\ud37c\ub7ec \uae30\ubc18 \uc774\ubbf8\uc9c0 \ucc28\ub2e8 \uaddc\uce59\uc744 \uc124\uc815\ud558\ub824\uba74 URL Rewrite \ubaa8\ub4c8\uc744 \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774 \ubaa8\ub4c8\uc744 \uc0ac\uc6a9\ud558\uba74 \uc6f9 \uc11c\ubc84\uc5d0 \ub300\ud55c URL \uc7ac\uc791\uc131 \uaddc\uce59\uc744 \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 IIS\uc5d0\uc11c \uc720\uc0ac\ud55c \uae30\ub2a5\uc744 \uc124\uc815\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. URL Rewrite \ubaa8\ub4c8 \uc124\uce58<\/h3>\n\n\n\n<p>IIS\uc5d0 URL Rewrite \ubaa8\ub4c8\uc774 \uc124\uce58\ub418\uc5b4 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uc124\uce58\ub418\uc5b4 \uc788\uc9c0 \uc54a\ub2e4\uba74 <a>Microsoft\uc758 \uacf5\uc2dd \uc0ac\uc774\ud2b8<\/a>\ub97c \ud1b5\ud574 \ub2e4\uc6b4\ub85c\ub4dc\ud558\uace0 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. web.config \ud30c\uc77c \uc218\uc815<\/h3>\n\n\n\n<p>\uc0ac\uc774\ud2b8\uc758 \ub8e8\ud2b8 \ub514\ub809\ud1a0\ub9ac\uc5d0 \uc788\ub294 <code>web.config<\/code> \ud30c\uc77c\uc5d0 \ub2e4\uc74c \ub0b4\uc6a9\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:xhtml decode:true \" >&lt;configuration&gt;\n    &lt;system.webServer&gt;\n        &lt;rewrite&gt;\n            &lt;rules&gt;\n                &lt;rule name=\"Block image hotlinking\" stopProcessing=\"true\"&gt;\n                    &lt;match url=\".*\\.(jpg|jpeg|png|gif)$\" ignoreCase=\"true\" \/&gt;\n                    &lt;conditions logicalGrouping=\"MatchAll\" trackAllCaptures=\"false\"&gt;\n                        &lt;add input=\"{HTTP_REFERER}\" pattern=\"^$\" negate=\"true\" \/&gt;\n                        &lt;add input=\"{HTTP_REFERER}\" pattern=\"^https:\/\/www.auctionpro.co.kr\" negate=\"true\" ignoreCase=\"true\" \/&gt;\n                        &lt;add input=\"{HTTP_REFERER}\" pattern=\"^http(s)?:\/\/(www\\.)?google.com\" negate=\"true\" ignoreCase=\"true\" \/&gt;\n                    &lt;\/conditions&gt;\n                    &lt;action type=\"CustomResponse\" statusCode=\"403\" statusReason=\"Forbidden\" statusDescription=\"Hotlinking forbidden\" \/&gt;\n                &lt;\/rule&gt;\n            &lt;\/rules&gt;\n        &lt;\/rewrite&gt;\n    &lt;\/system.webServer&gt;\n&lt;\/configuration&gt;<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\uc124\uba85<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>&lt;match url=\".*\\.(jpg|jpeg|png|gif)$\" ignoreCase=\"true\" \/&gt;<\/code>: URL\uc774 <code>.jpg<\/code>, <code>.jpeg<\/code>, <code>.png<\/code>, \ub610\ub294 <code>.gif<\/code>\ub85c \ub05d\ub098\ub294 \uacbd\uc6b0\ub97c \ub9e4\uce6d\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>&lt;conditions logicalGrouping=\"MatchAll\" trackAllCaptures=\"false\"&gt;<\/code>: \ubaa8\ub4e0 \uc870\uac74\uc774 \ub9cc\uc871\ud574\uc57c\ub9cc \uaddc\uce59\uc774 \uc801\uc6a9\ub418\ub3c4\ub85d \uc124\uc815\ud569\ub2c8\ub2e4.\n<ul class=\"wp-block-list\">\n<li><code>&lt;add input=\"{HTTP_REFERER}\" pattern=\"^$\" negate=\"true\" \/&gt;<\/code>: HTTP_REFERER\uac00 \ube44\uc5b4 \uc788\uc9c0 \uc54a\uc740 \uacbd\uc6b0\uc5d0\ub9cc \uc870\uac74\uc744 \ub9cc\uc871\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>&lt;add input=\"{HTTP_REFERER}\" pattern=\"^https:\/\/www.auctionpro.co.kr\" negate=\"true\" ignoreCase=\"true\" \/&gt;<\/code>: HTTP_REFERER\uac00 <code>https:\/\/www.auctionpro.co.kr<\/code>\ub85c \uc2dc\uc791\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uc5d0\ub9cc \uc870\uac74\uc744 \ub9cc\uc871\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>&lt;add input=\"{HTTP_REFERER}\" pattern=\"^http(s)?:\/\/(www\\.)?google.com\" negate=\"true\" ignoreCase=\"true\" \/&gt;<\/code>: HTTP_REFERER\uac00 <code>http(s):\/\/(www.)?google.com<\/code>\uc73c\ub85c \uc2dc\uc791\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uc5d0\ub9cc \uc870\uac74\uc744 \ub9cc\uc871\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>&lt;action type=\"CustomResponse\" statusCode=\"403\" statusReason=\"Forbidden\" statusDescription=\"Hotlinking forbidden\" \/&gt;<\/code>: \uc870\uac74\uc774 \ub9cc\uc871\ub418\uba74 403 Forbidden \uc751\ub2f5\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">3. IIS \uc7ac\uc2dc\uc791<\/h3>\n\n\n\n<p><code>web.config<\/code> \ud30c\uc77c\uc744 \uc218\uc815\ud55c \ud6c4 IIS\ub97c \uc7ac\uc2dc\uc791\ud558\uac70\ub098 \uc6f9\uc0ac\uc774\ud2b8\ub97c \uc7ac\uc2dc\uc791\ud558\uc5ec \ubcc0\uacbd \uc0ac\ud56d\uc774 \uc801\uc6a9\ub418\ub3c4\ub85d \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774 \uc124\uc815\uc744 \ud1b5\ud574 \ud2b9\uc815 \ub9ac\ud37c\ub7ec\uc5d0\uc11c\ub9cc \uc774\ubbf8\uc9c0\ub97c \ucc38\uc870\ud560 \uc218 \uc788\uac8c \ub418\uc5b4, \ub2e4\ub978 \uc0ac\uc774\ud2b8\uc5d0\uc11c \ubb34\ub2e8\uc73c\ub85c \uc774\ubbf8\uc9c0\ub97c \ub9c1\ud06c\ud558\ub294 \uac83\uc744 \ubc29\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>RewriteEngine On RewriteCond %{QUERY_STRING} (%27)|(&#8216;)|(&#8211;)|(%23)|(#) RewriteRule .* &#8211; [F]<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">IIS \uc5d0\uc11c \uc138\ud305ChatGPT<\/h3>\n\n\n\n<p>IIS(Internet Information Services)\uc5d0\uc11c \uc704\uc640 \uac19\uc740 URL \uc7ac\uc791\uc131 \uaddc\uce59\uc744 \uc124\uc815\ud558\ub824\uba74 URL Rewrite \ubaa8\ub4c8\uc744 \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774 \ubaa8\ub4c8\uc744 \ud1b5\ud574 Apache\uc758 <code>.htaccess<\/code> \ud30c\uc77c\uc5d0\uc11c \uc124\uc815\ud55c \uac83\uacfc \uc720\uc0ac\ud55c \uaddc\uce59\uc744 \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 IIS\uc5d0\uc11c \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 \ud2b9\uc815 \ud328\ud134\uc744 \ud3ec\ud568\ud558\ub294 \uc694\uccad\uc744 \ucc28\ub2e8\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. URL Rewrite \ubaa8\ub4c8 \uc124\uce58<\/h3>\n\n\n\n<p>IIS\uc5d0 URL Rewrite \ubaa8\ub4c8\uc774 \uc124\uce58\ub418\uc5b4 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uc124\uce58\ub418\uc5b4 \uc788\uc9c0 \uc54a\ub2e4\uba74 <a>Microsoft\uc758 \uacf5\uc2dd \uc0ac\uc774\ud2b8<\/a>\uc5d0\uc11c \ub2e4\uc6b4\ub85c\ub4dc\ud558\uace0 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. web.config \ud30c\uc77c \uc218\uc815<\/h3>\n\n\n\n<p>\uc0ac\uc774\ud2b8\uc758 \ub8e8\ud2b8 \ub514\ub809\ud1a0\ub9ac\uc5d0 \uc788\ub294 <code>web.config<\/code> \ud30c\uc77c\uc5d0 \ub2e4\uc74c \ub0b4\uc6a9\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \">&lt;configuration&gt;\n    &lt;system.webServer&gt;\n        &lt;rewrite&gt;\n            &lt;rules&gt;\n                &lt;rule name=\"Block SQL Injection Patterns\" stopProcessing=\"true\"&gt;\n                    &lt;match url=\".*\" \/&gt;\n                    &lt;conditions logicalGrouping=\"MatchAny\" trackAllCaptures=\"false\"&gt;\n                        &lt;add input=\"{QUERY_STRING}\" pattern=\"%27\" \/&gt;\n                        &lt;add input=\"{QUERY_STRING}\" pattern=\"\\'\" \/&gt;\n                        &lt;add input=\"{QUERY_STRING}\" pattern=\"\\-\\-\" \/&gt;\n                        &lt;add input=\"{QUERY_STRING}\" pattern=\"%23\" \/&gt;\n                        &lt;add input=\"{QUERY_STRING}\" pattern=\"#\" \/&gt;\n                    &lt;\/conditions&gt;\n                    &lt;action type=\"CustomResponse\" statusCode=\"403\" statusReason=\"Forbidden\" statusDescription=\"Forbidden\" \/&gt;\n                &lt;\/rule&gt;\n            &lt;\/rules&gt;\n        &lt;\/rewrite&gt;\n    &lt;\/system.webServer&gt;\n&lt;\/configuration&gt;<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\uc124\uba85<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>&lt;match url=\".*\" \/&gt;<\/code>: \ubaa8\ub4e0 URL\uc744 \ub9e4\uce6d\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>&lt;conditions logicalGrouping=\"MatchAny\" trackAllCaptures=\"false\"&gt;<\/code>: \ud558\ub098\ub77c\ub3c4 \uc870\uac74\uc774 \ub9cc\uc871\ub418\uba74 \uaddc\uce59\uc774 \uc801\uc6a9\ub418\ub3c4\ub85d \uc124\uc815\ud569\ub2c8\ub2e4.\n<ul class=\"wp-block-list\">\n<li><code>&lt;add input=\"{QUERY_STRING}\" pattern=\"%27\" \/&gt;<\/code>: \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 <code>%27<\/code>(URL \uc778\ucf54\ub529\ub41c \uc544\ud3ec\uc2a4\ud2b8\ub85c\ud53c)\uc774 \ud3ec\ud568\ub41c \uacbd\uc6b0.<\/li>\n\n\n\n<li><code>&lt;add input=\"{QUERY_STRING}\" pattern=\"\\'\" \/&gt;<\/code>: \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 \uc544\ud3ec\uc2a4\ud2b8\ub85c\ud53c(<code>'<\/code>)\uac00 \ud3ec\ud568\ub41c \uacbd\uc6b0.<\/li>\n\n\n\n<li><code>&lt;add input=\"{QUERY_STRING}\" pattern=\"\\-\\-\" \/&gt;<\/code>: \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 SQL \uc8fc\uc11d \uc2dc\uc791 \ubb38\uc790\uc5f4(<code>--<\/code>)\uc774 \ud3ec\ud568\ub41c \uacbd\uc6b0.<\/li>\n\n\n\n<li><code>&lt;add input=\"{QUERY_STRING}\" pattern=\"%23\" \/&gt;<\/code>: \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 <code>%23<\/code>(URL \uc778\ucf54\ub529\ub41c \uc0f5 \uae30\ud638)\uc774 \ud3ec\ud568\ub41c \uacbd\uc6b0.<\/li>\n\n\n\n<li><code>&lt;add input=\"{QUERY_STRING}\" pattern=\"#\" \/&gt;<\/code>: \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 \uc0f5 \uae30\ud638(<code>#<\/code>)\uac00 \ud3ec\ud568\ub41c \uacbd\uc6b0.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>&lt;action type=\"CustomResponse\" statusCode=\"403\" statusReason=\"Forbidden\" statusDescription=\"Forbidden\" \/&gt;<\/code>: \uc870\uac74\uc774 \ub9cc\uc871\ub418\uba74 403 Forbidden \uc751\ub2f5\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">3. IIS \uc7ac\uc2dc\uc791<\/h3>\n\n\n\n<p><code>web.config<\/code> \ud30c\uc77c\uc744 \uc218\uc815\ud55c \ud6c4 IIS\ub97c \uc7ac\uc2dc\uc791\ud558\uac70\ub098 \uc6f9\uc0ac\uc774\ud2b8\ub97c \uc7ac\uc2dc\uc791\ud558\uc5ec \ubcc0\uacbd \uc0ac\ud56d\uc774 \uc801\uc6a9\ub418\ub3c4\ub85d \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774 \uc124\uc815\uc744 \ud1b5\ud574 \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 \ud2b9\uc815 \ud328\ud134\uc774 \ud3ec\ud568\ub41c \uc694\uccad\uc744 \ucc28\ub2e8\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub294 SQL \uc778\uc81d\uc158 \uacf5\uaca9\uc744 \ubc29\uc9c0\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>%23 %27 \ubb38\uc790\ub294?ChatGPT<\/p>\n\n\n\n<p>IIS\uc5d0\uc11c <code>%23<\/code>(URL \uc778\ucf54\ub529\ub41c #) \ubc0f <code>%27<\/code>(URL \uc778\ucf54\ub529\ub41c &#8216;)\uc640 \uac19\uc740 URL \uc778\ucf54\ub529\ub41c \ubb38\uc790\ub97c \ud3ec\ud568\ud55c \ucffc\ub9ac \ubb38\uc790\uc5f4\uc744 \ucc28\ub2e8\ud558\ub294 \ubc29\ubc95\uc744 <code>web.config<\/code> \ud30c\uc77c\uc744 \ud1b5\ud574 \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574 URL Rewrite \ubaa8\ub4c8\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud2b9\uc815 \ud328\ud134\uc744 \uac10\uc9c0\ud558\uace0 \ud574\ub2f9 \uc694\uccad\uc744 \ucc28\ub2e8\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub2e4\uc74c\uc740 \uc774\ub97c \uad6c\ud604\ud558\uae30 \uc704\ud55c <code>web.config<\/code> \ud30c\uc77c\uc758 \uc124\uc815 \uc608\uc2dc\uc785\ub2c8\ub2e4:<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \">&lt;configuration&gt;\n    &lt;system.webServer&gt;\n        &lt;rewrite&gt;\n            &lt;rules&gt;\n                &lt;rule name=\"Block SQL Injection Patterns\" stopProcessing=\"true\"&gt;\n                    &lt;match url=\".*\" \/&gt;\n                    &lt;conditions logicalGrouping=\"MatchAny\" trackAllCaptures=\"false\"&gt;\n                        &lt;add input=\"{QUERY_STRING}\" pattern=\"%2527\" \/&gt;\n                        &lt;add input=\"{QUERY_STRING}\" pattern=\"%27\" \/&gt;\n                        &lt;add input=\"{QUERY_STRING}\" pattern=\"\\'\" \/&gt;\n                        &lt;add input=\"{QUERY_STRING}\" pattern=\"\\-\\-\" \/&gt;\n                        &lt;add input=\"{QUERY_STRING}\" pattern=\"%2523\" \/&gt;\n                        &lt;add input=\"{QUERY_STRING}\" pattern=\"%23\" \/&gt;\n                        &lt;add input=\"{QUERY_STRING}\" pattern=\"#\" \/&gt;\n                    &lt;\/conditions&gt;\n                    &lt;action type=\"CustomResponse\" statusCode=\"403\" statusReason=\"Forbidden\" statusDescription=\"Forbidden\" \/&gt;\n                &lt;\/rule&gt;\n            &lt;\/rules&gt;\n        &lt;\/rewrite&gt;\n    &lt;\/system.webServer&gt;\n&lt;\/configuration&gt;<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\uc124\uba85<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>&lt;match url=\".*\" \/&gt;<\/code>: \ubaa8\ub4e0 URL\uc744 \ub9e4\uce6d\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>&lt;conditions logicalGrouping=\"MatchAny\" trackAllCaptures=\"false\"&gt;<\/code>: \ud558\ub098\ub77c\ub3c4 \uc870\uac74\uc774 \ub9cc\uc871\ub418\uba74 \uaddc\uce59\uc774 \uc801\uc6a9\ub418\ub3c4\ub85d \uc124\uc815\ud569\ub2c8\ub2e4.\n<ul class=\"wp-block-list\">\n<li><code>&lt;add input=\"{QUERY_STRING}\" pattern=\"%2527\" \/&gt;<\/code>: \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 \uc774\uc911 URL \uc778\ucf54\ub529\ub41c <code>%27<\/code>(\uc989, <code>%2527<\/code>)\uc774 \ud3ec\ud568\ub41c \uacbd\uc6b0.<\/li>\n\n\n\n<li><code>&lt;add input=\"{QUERY_STRING}\" pattern=\"%27\" \/&gt;<\/code>: \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 URL \uc778\ucf54\ub529\ub41c <code>%27<\/code>(\uc544\ud3ec\uc2a4\ud2b8\ub85c\ud53c)\uc774 \ud3ec\ud568\ub41c \uacbd\uc6b0.<\/li>\n\n\n\n<li><code>&lt;add input=\"{QUERY_STRING}\" pattern=\"\\'\" \/&gt;<\/code>: \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 \uc544\ud3ec\uc2a4\ud2b8\ub85c\ud53c(<code>'<\/code>)\uac00 \ud3ec\ud568\ub41c \uacbd\uc6b0.<\/li>\n\n\n\n<li><code>&lt;add input=\"{QUERY_STRING}\" pattern=\"\\-\\-\" \/&gt;<\/code>: \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 SQL \uc8fc\uc11d \uc2dc\uc791 \ubb38\uc790\uc5f4(<code>--<\/code>)\uc774 \ud3ec\ud568\ub41c \uacbd\uc6b0.<\/li>\n\n\n\n<li><code>&lt;add input=\"{QUERY_STRING}\" pattern=\"%2523\" \/&gt;<\/code>: \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 \uc774\uc911 URL \uc778\ucf54\ub529\ub41c <code>%23<\/code>(\uc989, <code>%2523<\/code>)\uc774 \ud3ec\ud568\ub41c \uacbd\uc6b0.<\/li>\n\n\n\n<li><code>&lt;add input=\"{QUERY_STRING}\" pattern=\"%23\" \/&gt;<\/code>: \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 URL \uc778\ucf54\ub529\ub41c <code>%23<\/code>(\uc0f5 \uae30\ud638)\uc774 \ud3ec\ud568\ub41c \uacbd\uc6b0.<\/li>\n\n\n\n<li><code>&lt;add input=\"{QUERY_STRING}\" pattern=\"#\" \/&gt;<\/code>: \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 \uc0f5 \uae30\ud638(<code>#<\/code>)\uac00 \ud3ec\ud568\ub41c \uacbd\uc6b0.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>&lt;action type=\"CustomResponse\" statusCode=\"403\" statusReason=\"Forbidden\" statusDescription=\"Forbidden\" \/&gt;<\/code>: \uc870\uac74\uc774 \ub9cc\uc871\ub418\uba74 403 Forbidden \uc751\ub2f5\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\uc774\uc911 URL \uc778\ucf54\ub529<\/h3>\n\n\n\n<p>\ud2b9\uc815 \uc0c1\ud669\uc5d0\uc11c\ub294 <code>%27<\/code>(\uc544\ud3ec\uc2a4\ud2b8\ub85c\ud53c)\uc640 <code>%23<\/code>(\uc0f5 \uae30\ud638)\uac00 \uc774\uc911\uc73c\ub85c \uc778\ucf54\ub529\ub41c <code>%2527<\/code> \ubc0f <code>%2523<\/code>\uc73c\ub85c \ub098\ud0c0\ub0a0 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub294 <code>%<\/code> \ubb38\uc790\uac00 \ub2e4\uc2dc URL \uc778\ucf54\ub529\ub418\uc5b4 <code>%25<\/code>\ub85c \ubcc0\ud658\ub418\uc5c8\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uc774 \uacbd\uc6b0\uc5d0\ub3c4 \ucc28\ub2e8\ud560 \uc218 \uc788\ub3c4\ub85d \ud328\ud134\uc5d0 \uc774\uc911 \uc778\ucf54\ub529\ub41c \uac12\uc744 \ucd94\uac00\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc801\uc6a9 \ubc29\ubc95<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><code>web.config<\/code> \ud30c\uc77c\uc744 \uc218\uc815\ud558\uc5ec \uc704\uc758 \ub0b4\uc6a9\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li>\ubcc0\uacbd \uc0ac\ud56d\uc744 \uc801\uc6a9\ud558\uae30 \uc704\ud574 IIS\ub97c \uc7ac\uc2dc\uc791\ud558\uac70\ub098 \ud574\ub2f9 \uc6f9\uc0ac\uc774\ud2b8\ub97c \uc7ac\uc2dc\uc791\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n<p>\uc774 \uc124\uc815\uc744 \ud1b5\ud574 \ucffc\ub9ac \ubb38\uc790\uc5f4\uc5d0 \ud2b9\uc815 \ud328\ud134\uc774 \ud3ec\ud568\ub41c \uc694\uccad\uc744 \ucc28\ub2e8\ud558\uc5ec SQL \uc778\uc81d\uc158 \uacf5\uaca9\uc744 \ubc29\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>\uc6cc\ub4dc\ud504\ub808\uc2a4\uc5d0\uc11c \ud2b9\uc815\ud55c SQL \uc778\uc81d\uc158 \uc2dc\ub3c4\uc640 \uac19\uc774 \uc704\ud5d8\ud55c \ud30c\ub77c\uba54\ud130\ub97c \ucc28\ub2e8\ud558\ub294 \ubc29\ubc95\uc5d0\ub294 \uc5ec\ub7ec \uac00\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc81c\uc2dc\ub41c \ud30c\ub77c\uba54\ud130\ub294 SQL \uc778\uc81d\uc158 \uacf5\uaca9\uc744 \uc2dc\ub3c4\ud558\ub294 \uac83\uc73c\ub85c \ubcf4\uc785\ub2c8\ub2e4. \uc774\ub97c \ubc29\uc9c0\ud558\uae30 \uc704\ud55c \uba87 <a class=\"mh-excerpt-more\" href=\"https:\/\/www.auctionpro.co.kr\/?p=9286\" title=\"SQL \uc778\uc81d\uc158 \uc2dc\ub3c4 \ucc28\ub2e8\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[17],"tags":[],"class_list":["post-9286","post","type-post","status-publish","format-standard","hentry","category-17"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL \uc778\uc81d\uc158 \uc2dc\ub3c4 \ucc28\ub2e8 - AuctionPro<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.auctionpro.co.kr\/?p=9286\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL \uc778\uc81d\uc158 \uc2dc\ub3c4 \ucc28\ub2e8 - AuctionPro\" \/>\n<meta property=\"og:description\" content=\"\uc6cc\ub4dc\ud504\ub808\uc2a4\uc5d0\uc11c \ud2b9\uc815\ud55c SQL \uc778\uc81d\uc158 \uc2dc\ub3c4\uc640 \uac19\uc774 \uc704\ud5d8\ud55c \ud30c\ub77c\uba54\ud130\ub97c \ucc28\ub2e8\ud558\ub294 \ubc29\ubc95\uc5d0\ub294 \uc5ec\ub7ec \uac00\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc81c\uc2dc\ub41c \ud30c\ub77c\uba54\ud130\ub294 SQL \uc778\uc81d\uc158 \uacf5\uaca9\uc744 \uc2dc\ub3c4\ud558\ub294 \uac83\uc73c\ub85c \ubcf4\uc785\ub2c8\ub2e4. \uc774\ub97c \ubc29\uc9c0\ud558\uae30 \uc704\ud55c \uba87 [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.auctionpro.co.kr\/?p=9286\" \/>\n<meta property=\"og:site_name\" content=\"AuctionPro\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-20T00:28:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-13T07:02:34+00:00\" \/>\n<meta name=\"author\" content=\"golgol\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"golgol\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"4\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=9286#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=9286\"},\"author\":{\"name\":\"golgol\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#\\\/schema\\\/person\\\/d3dbae599b06cd55f5b14a3e2116f7a2\"},\"headline\":\"SQL \uc778\uc81d\uc158 \uc2dc\ub3c4 \ucc28\ub2e8\",\"datePublished\":\"2024-06-20T00:28:00+00:00\",\"dateModified\":\"2025-05-13T07:02:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=9286\"},\"wordCount\":193,\"commentCount\":0,\"articleSection\":[\"[DEV]\ubcf4\uc548\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=9286#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=9286\",\"url\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=9286\",\"name\":\"SQL \uc778\uc81d\uc158 \uc2dc\ub3c4 \ucc28\ub2e8 - AuctionPro\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#website\"},\"datePublished\":\"2024-06-20T00:28:00+00:00\",\"dateModified\":\"2025-05-13T07:02:34+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#\\\/schema\\\/person\\\/d3dbae599b06cd55f5b14a3e2116f7a2\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=9286#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=9286\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=9286#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\ud648\",\"item\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL \uc778\uc81d\uc158 \uc2dc\ub3c4 \ucc28\ub2e8\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#website\",\"url\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/\",\"name\":\"AuctionPro\",\"description\":\"\uc625\uc158\ud504\ub85c\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#\\\/schema\\\/person\\\/d3dbae599b06cd55f5b14a3e2116f7a2\",\"name\":\"golgol\",\"url\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?author=6\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL \uc778\uc81d\uc158 \uc2dc\ub3c4 \ucc28\ub2e8 - AuctionPro","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.auctionpro.co.kr\/?p=9286","og_locale":"ko_KR","og_type":"article","og_title":"SQL \uc778\uc81d\uc158 \uc2dc\ub3c4 \ucc28\ub2e8 - AuctionPro","og_description":"\uc6cc\ub4dc\ud504\ub808\uc2a4\uc5d0\uc11c \ud2b9\uc815\ud55c SQL \uc778\uc81d\uc158 \uc2dc\ub3c4\uc640 \uac19\uc774 \uc704\ud5d8\ud55c \ud30c\ub77c\uba54\ud130\ub97c \ucc28\ub2e8\ud558\ub294 \ubc29\ubc95\uc5d0\ub294 \uc5ec\ub7ec \uac00\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc81c\uc2dc\ub41c \ud30c\ub77c\uba54\ud130\ub294 SQL \uc778\uc81d\uc158 \uacf5\uaca9\uc744 \uc2dc\ub3c4\ud558\ub294 \uac83\uc73c\ub85c \ubcf4\uc785\ub2c8\ub2e4. \uc774\ub97c \ubc29\uc9c0\ud558\uae30 \uc704\ud55c \uba87 [...]","og_url":"https:\/\/www.auctionpro.co.kr\/?p=9286","og_site_name":"AuctionPro","article_published_time":"2024-06-20T00:28:00+00:00","article_modified_time":"2025-05-13T07:02:34+00:00","author":"golgol","twitter_card":"summary_large_image","twitter_misc":{"\uae00\uc4f4\uc774":"golgol","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"4\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.auctionpro.co.kr\/?p=9286#article","isPartOf":{"@id":"https:\/\/www.auctionpro.co.kr\/?p=9286"},"author":{"name":"golgol","@id":"https:\/\/www.auctionpro.co.kr\/#\/schema\/person\/d3dbae599b06cd55f5b14a3e2116f7a2"},"headline":"SQL \uc778\uc81d\uc158 \uc2dc\ub3c4 \ucc28\ub2e8","datePublished":"2024-06-20T00:28:00+00:00","dateModified":"2025-05-13T07:02:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.auctionpro.co.kr\/?p=9286"},"wordCount":193,"commentCount":0,"articleSection":["[DEV]\ubcf4\uc548"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.auctionpro.co.kr\/?p=9286#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.auctionpro.co.kr\/?p=9286","url":"https:\/\/www.auctionpro.co.kr\/?p=9286","name":"SQL \uc778\uc81d\uc158 \uc2dc\ub3c4 \ucc28\ub2e8 - AuctionPro","isPartOf":{"@id":"https:\/\/www.auctionpro.co.kr\/#website"},"datePublished":"2024-06-20T00:28:00+00:00","dateModified":"2025-05-13T07:02:34+00:00","author":{"@id":"https:\/\/www.auctionpro.co.kr\/#\/schema\/person\/d3dbae599b06cd55f5b14a3e2116f7a2"},"breadcrumb":{"@id":"https:\/\/www.auctionpro.co.kr\/?p=9286#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.auctionpro.co.kr\/?p=9286"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.auctionpro.co.kr\/?p=9286#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\ud648","item":"https:\/\/www.auctionpro.co.kr\/"},{"@type":"ListItem","position":2,"name":"SQL \uc778\uc81d\uc158 \uc2dc\ub3c4 \ucc28\ub2e8"}]},{"@type":"WebSite","@id":"https:\/\/www.auctionpro.co.kr\/#website","url":"https:\/\/www.auctionpro.co.kr\/","name":"AuctionPro","description":"\uc625\uc158\ud504\ub85c","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.auctionpro.co.kr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Person","@id":"https:\/\/www.auctionpro.co.kr\/#\/schema\/person\/d3dbae599b06cd55f5b14a3e2116f7a2","name":"golgol","url":"https:\/\/www.auctionpro.co.kr\/?author=6"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/9286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9286"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/9286\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}