{"id":642,"date":"2002-10-31T00:28:01","date_gmt":"2002-10-31T00:28:01","guid":{"rendered":"http:\/\/dev.jblove.net\/?p=642"},"modified":"2002-10-31T00:28:01","modified_gmt":"2002-10-31T00:28:01","slug":"%ec%a0%91%ec%86%8d%ec%9e%90-%eb%b3%b4%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/jblove.net\/?p=642","title":{"rendered":"\uc811\uc18d\uc790 \ubcf4\uae30"},"content":{"rendered":"<p>\ud604\uc7ac \uc811\uc18d\uc911\uc778 \uc0ac\uc6a9\uc790\ub97c \ud3b8\ubc95\uc774\ub098\ub9c8 \uc54c\ub824\uc8fc\ub294 \ucf54\ub4dc\uc785\ub2c8\ub2e4 ^^<\/p>\n<p>\uac1c\uc778\ud648\ud398\uc774\uc9c0\ub098 \uc0ac\uc6a9\uc790\uac00 \ubb34\uc9c0 \ub9ce\uc740\uacf3\ub9cc \uc544\ub2c8\ub77c\uba74 \uac04\ub2e8\ud558\uac8c \uc0ac\uc6a9\ud558\uc138\uc694 ^^<\/p>\n<p>by \uc624\uae38\ud638 (prince@kilho.net, http:\/\/k2lab.com)<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n* \uc124\uce58\ubc29\ubc95<\/p>\n<p>1. config.php \uac12\uc744 \uc54c\uc544\uc11c \ub9de\ucda5\ub2c8\ub2e4(\uac01 \ub514\ube44\uc5d0 \ub9de\ucdb0\uc11c ^^)<br \/>\n2. make_table.php \uc744 \ud55c\ubc88\uc2e4\ud589\uc2dc\ucf1c\uc11c \ud14c\uc774\ube14 \uc0dd\uc131\ud558\uace0 \ucd08\uae30\uac12\uc744 \ub123\uc5b4\uc90d\ub2c8\ub2e4<br \/>\n3. \ud544\uc694\ud55c \ubd80\ubd84\uc5d0 \uba54\uc778\uc18c\uc2a4\ub97c \ub123\uc2b5\ub2c8\ub2e4.<br \/>\n   (\uba54\uc778\uc18c\uc2a4\ub294 \ucea1\uc290\ud654 \uc2dc\ucf1c\uc11c \ud55c\uad70\ub370 \ub123\uc5b4\ub193\uace0 \ud544\uc694\uc2dc \ubfcc\ub9ac\uba74 \ub420\uaecd\ub2c8\ub2e4 ^^)<\/p>\n<p>* \ub3d9\uc791\uc6d0\ub9ac<\/p>\n<p>1. \ud398\uc774\uc9c0\ub97c \uc62e\uae38\ub54c\ub9c8\ub2e4 \uc0ac\uc6a9\uc790\uc758 \uc811\uc18d\uc2dc\uac04\uc744 \uccb4\ud06c\ud569\ub2c8\ub2e4.<br \/>\n2. \ubd88\ud2b9\uc815 \uc0ac\uc6a9\uc790\uac00 \uc77c\uc815\uc2dc\uac04\uc774\ud6c4 \uc811\uc18d\uc2dc \uc4f0\ub808\uae30\uac12(?)\ub4e4\uc744 \uc9c0\uc6c1\ub2c8\ub2e4.<br \/>\n3. DB\uc5d0 \uc800\uc7a5\ub41c\uac12\ub4e4 \ucd9c\ub825~<\/p>\n<p>* \ud68c\uc6d0\uc81c\ub77c\uba74 NICKNAME \uc5d0 ID\uac12\uc774\ub098 \ub2c9\ub124\uc784\uac12\uc744 \ub123\uc5b4\uc8fc\uace0 \uc57d\uac04 \ubcc0\uacbd\ud558\uba74 \ud68c\uc6d0\ub4e4\uc758<br \/>\n  \uc811\uc18d\uc0c1\ud0dc\ub9cc \uc54c\uc544\ub0bc\uc218 \uc788\uc744\uaecd\ub2c8\ub2e4 ^^<\/p>\n<p>&#8212;&#8212; config.php \uc18c\uc2a4 &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\n<?<br \/>\n  $khost = &#8216;localhost&#8217;; \/\/host<br \/>\n  $kuser = &#8216;xxxxx&#8217;;     \/\/user<br \/>\n  $kpassword=&#8217;xxxxx&#8217;;   \/\/DB password<br \/>\n  $kdataname=&#8217;xxxxx&#8217;;   \/\/DB name<\/p>\n<p>\/\/ DB connect<br \/>\n  $db=mysql_connect(&#8220;$khost&#8221;,&#8221;$kuser&#8221;,&#8221;$kpassword&#8221;);<br \/>\n  mysql_select_db(&#8220;$kdataname&#8221;,$db);<br \/>\n?><\/p>\n<p>&#8212;&#8212; make_table.php \uc18c\uc2a4 &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<br \/>\n<? <br \/>\n   \/\/ \uc2e4\uc2dc\uac04(?) \uc811\uc18d\uc790 \ubcf4\uc5ec\uc8fc\uae30 by \uc624\uae38\ud638(prince@kilho.net\/k2lab.com)<br \/>\n   \/\/ <br \/>\n   \/\/ Subject : \ucd08\uae30 \ud14c\uc774\ube14 \uc124\uc815<\/p>\n<p>   include &#8220;config.php&#8221;;<br \/>\n   mysql_query(&#8220;create table KILHO_NOWUSER (ip char(16) not null primary key, nickname varchar(40), regdate datetime,index (regdate))&#8221;,$db) OR die (mysql_error());<br \/>\n   mysql_query(&#8220;insert into KILHO_NOWUSER values (&#8216;CHECKID&#8217;,&#8217;CHECKID&#8217;,now())&#8221;,$db) OR die (mysql_error());<br \/>\n   mysql_close($db);                       <br \/>\n?>                        <\/p>\n<p>&#8212;&#8212; \uba54\uc778\ubd80\ubd84 \uc18c\uc2a4 &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n<?<br \/>\n   \/\/ \uc2e4\uc2dc\uac04(?) \uc811\uc18d\uc790 \ubcf4\uc5ec\uc8fc\uae30 by \uc624\uae38\ud638(prince@kilho.net\/k2lab.com)<br \/>\n   \/\/ <br \/>\n   \/\/ Subject : \uba54\uc778 \ub8e8\ud2f4<br \/>\n   \/\/ Comment : \ubcf4\uc5ec\uc904 \ud398\uc774\uc9c0\ub9c8\ub2e4 \uc544\ub798\ub97c \ucd94\uac00\ud55c\ub2e4. include\ub4f1\uc744 \uc774\uc6a9\ud558\uba74 \uc88b\uc744\ub4ef<br \/>\n   \/\/           \uc774 \uc18c\uc2a4\ub97c \ucea1\uc290\ud654 \ud574\uc11c \uc0ac\uc6a9\ud558\uba74 \ub354 \ub0ab\uac9f\uc848? \u314b\u3137<\/p>\n<p>   \/\/ \ud604\uc7ac \uc811\uc18d\uc911\uc778 \uc544\uc774\ub514(\ub2c9\ub124\uc784)\ub97c $NICKNAME\uc5d0\ub2e4\uac00 \ub123\uc5b4\uc8fc\uba74<br \/>\n   \/\/ \uc811\uc18d\uc911\uc778 \ud68c\uc6d0\ub4e4\ub9cc \ubf51\uc544\ub0b4\ub294\uac83\uc744 \ucc98\ub9ac\ud560\uc218 \uc788\uc744\uac83\uc774\ub2e4. (\ud655\uc7a5\uc131 \uace0\ub824??)<\/p>\n<p>   include &#8220;config.php&#8221;;<\/p>\n<p>   \/\/ \ubcc0\uc218 \ucd08\uae30\ud654 <br \/>\n   $limittime=60; \/\/ 1\ubd84\ub9c8\ub2e4 \uac80\uc0ac\ud568<br \/>\n   $REMOTE_ADDR = $HTTP_SERVER_VARS[&#8216;REMOTE_ADDR&#8217;]; <\/p>\n<p>   \/\/ \uc0ac\uc6a9\uc790 IP\uac00 \uc788\ub294\uc9c0 \uccb4\ud06c<br \/>\n   \/\/ \uc788\uc73c\uba74 \uc811\uc18d\uc2dc\uac04\ub9cc \uc5c5\ub370\uc774\ud2b8 \uc2dc\ucf1c\uc900\ub2e4, \uc5c6\uc73c\uba74 IP\uc640 \uc811\uc18d\uc2dc\uac04\uc744 \ucd94\uac00\uc2dc\ud0a8\ub2e4<br \/>\n   $chkip=mysql_fetch_row(mysql_query(&#8220;select count(ip) from KILHO_NOWUSER where ip=&#8217;$REMOTE_ADDR'&#8221;));<\/p>\n<p>   if($chkip[0])<br \/>\n    mysql_query(&#8220;update KILHO_NOWUSER set nickname=&#8217;$NICKNAME&#8217;,regdate=now() where ip=&#8217;$REMOTE_ADDR'&#8221;); <br \/>\n   else<br \/>\n    mysql_query(&#8220;insert into KILHO_NOWUSER (ip,nickname,regdate) values (&#8216;$REMOTE_ADDR&#8217;,&#8217;$NICKNAME&#8217;,now()-&#8216;$limittime&#8217;)&#8221;); <\/p>\n<p>   \/\/ \uccb4\ud06c\ud55c \uc2dc\uac04\uc774 3\ubd84\uc774 \ub118\ub294\uc9c0 \uc54c\uc544\ubcf8\ub2e4<br \/>\n   \/\/ 3\ubd84\uc774 \ub118\uc73c\uba74 \uccb4\ud06c\uac12\uc744 \ucd08\uae30\ud654 \uc2dc\ud0a4\uace0, 3\ubd84\uc774 \ub118\uc740 \ub370\uc774\ud130\ub97c \uc9c0\uc6b4\ub2e4.<br \/>\n   \/\/ 180 \uc774\ub77c\uace0 \uc801\ud78c\ubd80\ubd84\uc774 3\ubd84\uc744 \uc758\ubbf8\ud568 ^^<br \/>\n   $row=mysql_fetch_row(mysql_query(&#8220;select regdate from KILHO_NOWUSER where ip=&#8217;CHECKID&#8217; and regdate<now()-'$limittime'\"));<br \/>\n   if($row[0])<br \/>\n   { <br \/>\n     mysql_query(&#8220;update KILHO_NOWUSER set regdate=now() where ip=&#8217;CHECKID'&#8221;); <br \/>\n     mysql_query(&#8220;delete from KILHO_NOWUSER where regdate<now()-'$limittime'\"); <br \/>\n   }<\/p>\n<p>   \/\/ \ucd9c\ub825\uc2dc\ucf1c\uc900\ub2e4. ^^<br \/>\n   $result=mysql_query(&#8220;select ip,nickname from KILHO_NOWUSER where ip<>&#8216;CHECKID'&#8221;);<br \/>\n   while($row=mysql_fetch_row($result))<br \/>\n    echo $row[1].'[&#8216;.$row[0].&#8217;]<br \/>&#8216;;<\/p>\n<p>   mysql_close();<br \/>\n?> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud604\uc7ac \uc811\uc18d\uc911\uc778 \uc0ac\uc6a9\uc790\ub97c \ud3b8\ubc95\uc774\ub098\ub9c8 \uc54c\ub824\uc8fc\ub294 \ucf54\ub4dc\uc785\ub2c8\ub2e4 ^^ \uac1c\uc778\ud648\ud398\uc774\uc9c0\ub098 \uc0ac\uc6a9\uc790\uac00 \ubb34\uc9c0 \ub9ce\uc740\uacf3\ub9cc \uc544\ub2c8\ub77c\uba74 \uac04\ub2e8\ud558\uac8c \uc0ac\uc6a9\ud558\uc138\uc694 ^^ by \uc624\uae38\ud638 (prince@kilho.net, http:\/\/k2lab.com) &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; * \uc124\uce58\ubc29\ubc95 1. config.php \uac12\uc744 \uc54c\uc544\uc11c \ub9de\ucda5\ub2c8\ub2e4(\uac01 \ub514\ube44\uc5d0 \ub9de\ucdb0\uc11c ^^) 2. make_table.php \uc744 \ud55c\ubc88\uc2e4\ud589\uc2dc\ucf1c\uc11c \ud14c\uc774\ube14 \uc0dd\uc131\ud558\uace0 \ucd08\uae30\uac12\uc744 \ub123\uc5b4\uc90d\ub2c8\ub2e4 3. \ud544\uc694\ud55c \ubd80\ubd84\uc5d0 \uba54\uc778\uc18c\uc2a4\ub97c \ub123\uc2b5\ub2c8\ub2e4. (\uba54\uc778\uc18c\uc2a4\ub294 \ucea1\uc290\ud654 \uc2dc\ucf1c\uc11c \ud55c\uad70\ub370 \ub123\uc5b4\ub193\uace0 \ud544\uc694\uc2dc \ubfcc\ub9ac\uba74 \ub420\uaecd\ub2c8\ub2e4 ^^) * \ub3d9\uc791\uc6d0\ub9ac 1. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[51],"tags":[],"class_list":["post-642","post","type-post","status-publish","format-standard","hentry","category-papa-php"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/642","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=642"}],"version-history":[{"count":0,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/642\/revisions"}],"wp:attachment":[{"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}