i-generation

店舗IDリストテーブル

create table digimerce_c_id_list (
 list_id int primary key auto_increment,
 s_id varchar(16),
 m_id_d varchar(8),
 m_id_e varchar(8)
)

mysql> LOAD DATA LOCAL INFILE '/home/admin/digimerce_c_id_list.csv' INTO TABLE digimerce_c_id_list FIELDS TERMINATED BY ',';

[admin@web1 cl]$ diff click.php /www/aff/ad/www/cl/click.php
386d385
< /*
420,444d418
< */
< 
< if($m_id == 760){
<     $referer_parse_url = parse_url($referer);    
<     $referer_query = $referer_parse_url["query"];
<     foreach(explode("&", $referer_query) as $query){
<         list($param, $value) = explode("=", $query);
<         if($param == "sid")
<             $referer_s_id = $value;
<         else if($param == "ca")
<             $referer_carrier = $value;
<     }
<     if($referer_s_id && $referer_carrier){
<         $sql = "select * from digimerce_c_id_list where s_id = '$referer_s_id'";
<         $res = __mysql_query_ex($sql);
<         if(mysql_num_rows($res)){
<             $row = mysql_fetch_array($res);
<             if($referer_carrier == "d")
<                 $link_url = preg_replace("/##MID##/", $row["m_id_d"], $link_url);
<             else if($referer_carrier == "ez")
<                 $link_url = preg_replace("/##MID##/", $row["m_id_e"], $link_url);
<             $referer_delete_flg = 1;
<         }
<     }
< }