http://hojuu.net/log/view.php
Å×Å©³ëÆ® Ä«¿îÅÍ°¡ Á¢¼Ó°æ·Î Ãâ·ÂÀÌ 5000°³·Î Á¦ÇѵǾî ÀÖ¾î¼ °£´ÜÇÏ°Ô À¯ÀÔ°æ·Î¸¸ ºÐ¼®ÇÒ ¼ö ÀÖ´Â Ä«¿îÅ͸¦ ¸¸µé¾îºÃ½À´Ï´Ù. ¿ì¼± ¾Æ·¡ DBÅ×À̺í(refurl)¸¦ Ãß°¡ÇϽðí CREATE TABLE IF NOT EXISTS `refurl` ( `no` int(30) NOT NULL auto_increment, `su` int(30) default NULL, `ref` varchar(255) NOT NULL, `times` int(15) NOT NULL, `year` int(4) NOT NULL, `mon` int(2) NOT NULL, `day` int(2) NOT NULL, `ips` varchar(24) NOT NULL, PRIMARY KEY (`no`) ) ENGINE=MyISAM DEFAULT CHARSET=euckr AUTO_INCREMENT=1 ; ÷ºÎµÈ ¾ÐÃàÆÄÀÏÀ» ´Ù¿î¹Þ¾Æ¼ Ç®¾îº¸¸é db.php ÆÄÀÏÀ» ÀÚ½ÅÀÇ °èÁ¤¿¡ ¸Â°Ô º¯°æÇϽŠÈÄ À¥¿¡ ¾÷·Îµå Çϼ¼¿ä À¯ÀÔ°æ·Î¸¦ ºÐ¼®ÇÒ htmlÆÄÀÏ head¿¡´Â ¾Æ·¡ Äڵ带 »ðÀÔÇϼ¼¿ä. <script language="JavaScript"> count_board_URL="http://hojuu.net/log/log.php"; tempimg= new Image(); tempimg.src=count_board_URL+"?link_page_url="+(document.referrer)+'&tm='+((new Date()).getMilliseconds());; </script> ·Î±× ºÐ¼® ÆäÀÌÁö´Â http://hojuu.net/log/view.php ip´ç ¸ÅÀÏ 1¹ø¸¸ Ä«¿îÅÍ¿¡ ¹Ý¿µµË´Ï´Ù.
°ü¸®ÀÚ¸ðµåÀÇ DB°ü¸®¿¡¼
ÇÏ´Ü¿¡ Mysql Äõ¸®½ÇÇà
CREATE TABLE IF NOT EXISTS `refurl` ( `no` int(30) NOT NULL auto_increment, `su` int(30) default NULL, `ref` varchar(255) NOT NULL, `times` int(15) NOT NULL, `year` int(4) NOT NULL, `mon` int(2) NOT NULL, `day` int(2) NOT NULL, `ips` varchar(24) NOT NULL, PRIMARY KEY (`no`) )
ENGINE=MyISAM DEFAULT CHARSET=euckr AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `refurl` ( `no` int(30) NOT NULL auto_increment, `su` int(30) default NULL, `ref` varchar(255) NOT NULL, `times` int(15) NOT NULL, `year` int(4) NOT NULL, `mon` int(2) NOT NULL, `day` int(2) NOT NULL, `ips` varchar(24) NOT NULL, PRIMARY KEY (`no`) );
ENGINE=MyISAM DEFAULT CHARSET=euckr AUTO_INCREMENT=1 <-- ÀÌ ºÎºÐ »©°í ÇØ º¸¼¼¿ä
|