¹Ý°©½À´Ï´Ù. COMPUZ.com ¸ðÁú¶óÀÔ´Ï´Ù.
>
> // counter_main¿¡¼ ¿À´Ã³¯Â¥ ÇàÀÌ ¾øÀ¸¸é Ãß°¡.
> $check=mysql_fetch_array(mysql_query("select count(*) from counter_main where date='$today'",$connect));
> if(!$check[0])
> {
> mysql_query("insert into counter_main (date, unique_counter, pageview) values ('$today', '0', '0')", $connect);
> }
>
> // Áö±Ý ¾ÆÀÌÇÇ·Î Á¢¼ÓÇÑ »ç¶÷ÀÌ ¿À´Ã óÀ½ ¿Â »ç¶÷ÀÎÁö °Ë»ç
> $check=mysql_fetch_array(mysql_query("select count(*) from counter_ip where date>=$today and date<$tomorrow and ip='$user_ip'",$connect));
> // ¿À´Ã óÀ½¿ÔÀ»¶§
> if($check[0]==0)
> {
> // Àüü¶û ¿À´Ã Ä«¿îÅÍ ¿Ã¸²
> mysql_query("update counter_main set unique_counter=unique_counter+1, pageview=pageview+1 where no=1 or date='$today'", $connect);
>
> // ¿À´Ã ½Ã°£´ëº° ip ÀÔ·Â
> mysql_query("insert into counter_ip (date, ip) values ('$time','$user_ip')",$connect);
> }
> // ¿À´Ã Çѹø ÀÌ»ó ¿Â »óÅÂÀ϶§
> else
> {
> // ÆäÀÌÁöºä ¿Ã¸²
> mysql_query("update counter_main set pageview=pageview+1 where no=1 or date='$today'", $connect);
> }
>
> // referer °ª ÀúÀå
> $check2=mysql_fetch_array(mysql_query("select count(*) from counter_referer where date=$today and referer='$referer'",$connect));
> if($check2[0]==0)
> {
> mysql_query("insert into counter_referer (date, referer, hit) values ('$today','$referer','1')", $connect);
> }
> else
> {
> mysql_query("update counter_referer set hit=hit+1 where date=$today and referer='$referer'", $connect);
> }
>
>¿¡¼ ¾î¶²°ÍÀ» ºü¼¾ß ÇÒÁö ¸ð¸£°Ù³×¿©... À̰͸¸ ÇÏ¸é ´ë´Âµ¥.. °¥ÃÄÁÖ¼¼¿± ¤Ð,.¤Ð
Áߺ¹µÈ ¾ÆÀÌÇÇ¿¡¼ÀÇ Á¢¼Óµµ ¹æ¹®ÀÚ¼ö¿¡ Ãß°¡µÇµµ·Ï ÇϽŴٴ ¸»¾¸À̽ÅÁö¿ä?
±×·¸´Ù¸é ¾Æ·¡¿Í °°ÀÌ ¼öÁ¤ÇÏ½Ã¸é µÉ°Í °°½À´Ï´Ù. ^^
// counter_main¿¡¼ ¿À´Ã³¯Â¥ ÇàÀÌ ¾øÀ¸¸é Ãß°¡.
$check=mysql_fetch_array(mysql_query("select count(*) from counter_main where date='$today'",$connect));
if(!$check[0])
{
mysql_query("insert into counter_main (date, unique_counter, pageview) values ('$today', '0', '0')", $connect);
}
// Áö±Ý ¾ÆÀÌÇÇ·Î Á¢¼ÓÇÑ »ç¶÷ÀÌ ¿À´Ã óÀ½ ¿Â »ç¶÷ÀÎÁö °Ë»ç
$check=mysql_fetch_array(mysql_query("select count(*) from counter_ip where date>=$today and date<$tomorrow and ip='$user_ip'",$connect));
// ¿À´Ã óÀ½¿ÔÀ»¶§
if($check[0]==0)
{
// Àüü¶û ¿À´Ã Ä«¿îÅÍ ¿Ã¸²
mysql_query("update counter_main set unique_counter=unique_counter+1, pageview=pageview+1 where no=1 or date='$today'", $connect);
// ¿À´Ã ½Ã°£´ëº° ip ÀÔ·Â
mysql_query("insert into counter_ip (date, ip) values ('$time','$user_ip')",$connect);
}
// ¿À´Ã Çѹø ÀÌ»ó ¿Â »óÅÂÀ϶§
else
{
// Àüü¶û ¿À´Ã Ä«¿îÅÍ ¿Ã¸²
mysql_query("update counter_main set unique_counter=unique_counter+1, pageview=pageview+1 where no=1 or date='$today'", $connect);
// ¿À´Ã ½Ã°£´ëº° ip ÀÔ·Â
mysql_query("insert into counter_ip (date, ip) values ('$time','$user_ip')",$connect);
}
// referer °ª ÀúÀå
$check2=mysql_fetch_array(mysql_query("select count(*) from counter_referer where date=$today and referer='$referer'",$connect));
if($check2[0]==0)
{
mysql_query("insert into counter_referer (date, referer, hit) values ('$today','$referer','1')", $connect);
}
else
{
mysql_query("update counter_referer set hit=hit+1 where date=$today and referer='$referer'", $connect);
}
°¨»çÇÕ´Ï´Ù.
My Internet Space - COMPUZ.com
|
|