<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
	<channel>
				<title><![CDATA[덧글에 ip 노출]]></title>
		<link>https://www.cosmosfarm.com/threads/rss/document/7843</link>
		<description><![CDATA[<p><a href="http://www.cosmosfarm.com/threads/document/6668">http://www.cosmosfarm.com/threads/document/6668</a></p>

<p>위 링크 참고로</p>

<p><strong>KBCommentList.class.php </strong>파일</p>

<p>public function add($parent_uid, $user_uid, $user_display, $content, $password=''){<br />
        global $wpdb;<br />
        $content_uid = $this-&gt;content_uid;<br />
        $parent_uid = intval($parent_uid);<br />
        $user_uid = intval($user_uid);<br />
        $user_display = addslashes(kboard_xssfilter(kboard_htmlclear(trim($user_display))));<br />
        $content = addslashes(trim($content));<br />
        $password = addslashes(kboard_xssfilter(kboard_htmlclear(trim($password))));<br />
        $created = current_time('YmdHis');<br />
        <strong>$ip = $_SERVER['REMOTE_ADDR'];</strong><br />
        <br />
        $wpdb-&gt;query("INSERT INTO `{$wpdb-&gt;prefix}kboard_comments` (`content_uid`, `parent_uid`, `user_uid`, `user_display`, `content`, `created`, `password`, '<strong>ip</strong>') VALUE ('$content_uid', '$parent_uid', '$user_uid', '$user_display', '$content', '$created', '$password', '$<strong>ip</strong>')");</p>

<p> </p>

<p><strong>index.php</strong></p>

<p>function kboard_comments_activation_execute(){<br />
    global $wpdb;<br />
    <br />
    $wpdb-&gt;query("CREATE TABLE IF NOT EXISTS `{$wpdb-&gt;prefix}kboard_comments` (<br />
        `uid` bigint(20) unsigned NOT NULL auto_increment,<br />
        `content_uid` bigint(20) unsigned NOT NULL,<br />
        `parent_uid` bigint(20) unsigned default NULL,<br />
        `user_uid` bigint(20) unsigned default NULL,<br />
        `user_display` varchar(127) default NULL,<br />
        `content` longtext NOT NULL,<br />
        `created` char(14) NOT NULL,<br />
        `password` varchar(127) default NULL,<br />
       <strong> `ip` varchar(127) default NULL,</strong></p>

<p> </p>

<p><strong>list-template.php</strong></p>

<p> </p>

<p>&lt;div class="comments-list-username" itemprop="author"&gt;&lt;?php echo $comment-&gt;user_display?&gt;&lt;/div&gt;<br />
            &lt;div class="comments-list-create" itemprop="dateCreated"&gt;&lt;?php echo date("Y-m-d H:i", strtotime($comment-&gt;created))?&gt;&lt;/div&gt;<br />
            <strong>&lt;div class="comments-list-ip" itemprop="ip"&gt;&lt;?php echo $comment-&gt;ip?&gt;&lt;/div&gt;</strong></p>

<p> </p>

<p><strong>위와 같이 추가해 봤습니다</strong></p>

<p><strong>그리고 </strong>&lt;?php print_r($comment)?&gt; 넣어서 테스트 했는데 아이피값이 보이지 않습니다</p>

<p>어딜 수정해야 할지 알수있을까요?<br /><br />
감사합니다</p>

<p> </p>

<p> </p>
]]></description>
		<copyright>Copyright 2026, 코스모스팜</copyright>
				<item>
			<title><![CDATA[DB 접속해서 실제로 확인해보세요.

ip 컬럼이 생성됐는지, 값이 입력됐는지 등등 실제로 확인해보세요....]]></title>
			<link>https://www.cosmosfarm.com/threads/document/7847</link>
			<description><![CDATA[<p>DB 접속해서 실제로 확인해보세요.</p>

<p>ip 컬럼이 생성됐는지, 값이 입력됐는지 등등 실제로 확인해보세요.</p>

<p>보통 호스팅 이용하고 계시면 phpMyAdmin 제공해줄겁니다. 접속해보세요~</p>

<p> </p>
]]></description>
			<author>스레드봇</author>
			<pubDate>Fri, 26 Feb 2016 00:30:52 +0000</pubDate>
			<category>KBoard</category>
		</item>
			</channel>
</rss>