'noimage.jpg';";$result=@mysql_query($strsql,$my_con); $strsql ="UPDATE `coolfishtest`.cool_shohinmaster SET shohin_kubun2 = 0 WHERE stockoutflg = 1 or zaiko=0 ;";$result=@mysql_query($strsql,$my_con); echo "COOL-COOLTEST終了"; } elseif(($_POST[sql]=="kotocopy") and ($_POST[sql2]=="websystemgoo")) { $strsql ="TRUNCATE kototest.koto_comeinfix;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_comeindata;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_comein_order ;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_directsupply ;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_orderdirect;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_ordermain ;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_ordersheet ;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_salesdetail ;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_shohinlocation ;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_shukka ;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_shukkafuteikan ;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_stockdata;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_status ;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_stockarrange ;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_shozokumaster ;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_shozokushohin ;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_shohinmaster ;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.koto_shukka_box ;";$result=@mysql_query($strsql,$my_con); $strsql ="TRUNCATE kototest.tableedit ;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_comeinfix` SELECT * FROM `kotodb`.`koto_comeinfix`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_comeindata` SELECT * FROM `kotodb`.`koto_comeindata`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_comein_order` SELECT * FROM `kotodb`.`koto_comein_order`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_directsupply` SELECT * FROM `kotodb`.`koto_directsupply`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_orderdirect` SELECT * FROM `kotodb`.`koto_orderdirect`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_ordermain` SELECT * FROM `kotodb`.`koto_ordermain`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_ordersheet` SELECT * FROM `kotodb`.`koto_ordersheet`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_salesdetail` SELECT * FROM `kotodb`.`koto_salesdetail`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_shohinlocation` SELECT * FROM `kotodb`.`koto_shohinlocation`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_shukka` SELECT * FROM `kotodb`.`koto_shukka`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_shukkafuteikan` SELECT * FROM `kotodb`.`koto_shukkafuteikan`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_stockdata` SELECT * FROM `kotodb`.`koto_stockdata`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_status` SELECT * FROM `kotodb`.`koto_status`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_stockarrange` SELECT * FROM `kotodb`.`koto_stockarrange`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_shozokumaster` SELECT * FROM `kotodb`.`koto_shozokumaster`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_shozokushohin` SELECT * FROM `kotodb`.`koto_shozokushohin`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_shohinmaster` SELECT * FROM `kotodb`.`koto_shohinmaster`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`koto_shukka_box` SELECT * FROM `kotodb`.`koto_shukka_box`;";$result=@mysql_query($strsql,$my_con); $strsql ="INSERT INTO `kototest`.`tableedit` SELECT * FROM `kotodb`.`tableedit`;";$result=@mysql_query($strsql,$my_con); $strsql ="UPDATE `kototest`.`koto_shozokumaster` set shozokuname= concat('○○○',substring(shozokuname,4)),address3 = concat('○○',substring(address3,3,8),'-15'),tel='03-9999-9999";$result=@mysql_query($strsql,$my_con); echo "KOTO-KOTOTEST終了"; } ?>