サポート #158

広告主変更

山本 義治 が9年以上前に追加. 9年以上前に更新.

ステータス:終了開始日:2015/04/16
優先度:今すぐ期日:2015/04/16
担当者:-進捗 %:

100%

カテゴリ:データ調整予定工数:1.00時間
対象バージョン:-作業時間の記録:1.00時間

説明

01535〜01542の8案件

00241:株式会社フォアキャストコミュニケーションズ
↓
00316:株式会社フォアキャストコミュニケーションズ2

に変更

履歴

#1 山本 義治 が9年以上前に更新

  • ステータス を 新規 から 終了 に変更
  • 進捗 % を 0 から 100 に変更
/www/aff/maintenance/convert_c_owner_id.php 

#!/usr/local/bin/php -q
<?
require("/www/aff/ad/const.inc");

$mysql_id = __mysql_con_ex();

$c_id_list = array(1535,1536,1537,1538,1539,1540,1541,1542);
$c_owner_id = 316;

foreach($c_id_list as $c_id){
    $sql = "update listing_list set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
    $sql = "update keyword set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
    $sql = "update content_yoyaku set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
    $sql = "update content set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
    $sql = "update content_list set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
    $sql = "update asp_list set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
    $sql = "update click_log_201504 set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
    $sql = "update action_log_201504 set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
    $sql = "update access_action_log_201504 set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
    $sql = "update stat_log_201504 set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
    $sql = "update stat_log_asp_201504 set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
    $sql = "update stat_log_client_201504 set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
    $sql = "update stat_log_asp_media_201504 set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
    $sql = "update stat_log_banner_201504 set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
    $sql = "update stat_log_item_201504 set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
    $sql = "update stat_log_listing_201504 set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
    $sql = "update stat_log_shop_201504 set c_owner_id = '$c_owner_id' where c_id = '$c_id'";
print($sql."\n");
    $res = __mysql_query_ex($sql);
}

?>

他の形式にエクスポート: Atom PDF