function registDomain($intRkwid = 0)
{
if ($intRkwid == 0) {
return;
}
require 'cin/SQLConnect_jas.php';
$sqlRkw = " SELECT rkw_id, rkw_word, rkw_domid, rkw_url, rkw_rclid FROM rank_keyword ";
$sqlRkw .= " WHERE TRUE ";
$sqlRkw .= " AND rkw_domid = 0 ";
$sqlRkw .= " AND rkw_id = {$intRkwid} ";
$sqlRkw .= " AND rkw_url != '' ";
print $sqlRkw . "<br />";
$rsRkw = mysql_db_query($dbName, $sqlRkw);
$rsRkwCount = mysql_num_rows($rsRkw);
$rowRkw = mysql_fetch_array($rsRkw);
if ($rowRkw[rkw_word] == true && (int) $rowRkw[rkw_domid] === 0) {
#ドメインIDが保存されてないとき
$strDomainName = getUrlDomain3($rowRkw[rkw_url]);
$sqlDom = " SELECT * FROM domain_mgt ";
$sqlDom .= " WHERE TRUE ";
$sqlDom .= " AND dom_domain = '{$strDomainName}'";
$rsDom = mysql_db_query($dbName, $sqlDom);
$rsCountDom = mysql_num_rows($rsDom);
print $sqlDom . "<br />";
if ($rsCountDom === 0) {
#ドメインが保存されていない場合
$_POST[dom_rclid] = $rowRkw[rkw_rclid];
$_POST[dom_registdate] = date('Y-m-d');
$_POST[dom_domain] = $strDomainName;
print DataJasInsertString(domain_mgt) . "<br />";
$_POST[rkw_domid] = DataJasInsert(domain_mgt);
} else {
#既にドメインが保存されているとき
$rowDom = mysql_fetch_array($rsDom);
$_POST[rkw_domid] = $rowDom['dom_id'];
}
//End if
$sqlUpDate = " UPDATE rank_keyword SET rkw_domid = {$_POST[rkw_domid]} ";
$sqlUpDate .= " WHERE TRUE ";
$sqlUpDate .= " AND rkw_id = {$intRkwid} ";
print $sqlUpDate . "<br />";
mysql_db_query($dbName, $sqlUpDate);
}
//End if
require 'cin/SQLClose.php';
}
function registDomain($intRkwid = 0)
{
if ($intRkwid == 0) {
return;
}
require 'cin/SQLConnect.php';
$sqlRkw = " SELECT rkw_id, rkw_domid, rkw_url, rkw_rclid FROM rank_keyword ";
$sqlRkw .= " WHERE TRUE ";
$sqlRkw .= " AND rkw_domid = 0 ";
if ($intRkwid) {
$sqlRkw .= " AND rkw_id = {$intRkwid} ";
}
$sqlRkw .= " AND rkw_url != '' ";
print $sqlRkw . "<br />";
#exit;
$rsRkw = mysql_db_query($dbName, $sqlRkw);
$rsRkwCount = mysql_num_rows($rsRkw);
if ($rsRkwCount) {
for ($intRkw = 0; $intRkw < $rsRkwCount; $intRkw++) {
$rowRkw = mysql_fetch_array($rsRkw);
$strDomain = getUrlDomain3($rowRkw[rkw_url]);
$sqlDom = " SELECT * FROM domain_mgt ";
$sqlDom .= " WHERE TRUE ";
$sqlDom .= " AND dom_domain = '{$strDomain}'";
$rsDom = mysql_db_query($dbName, $sqlDom);
$rsCountDom = mysql_num_rows($rsDom);
print $sqlDom . "<br />";
if (!$rsCountDom) {
#ドメインが保存されていない場合
$_POST[dom_rclid] = $rowRkw[rkw_rclid];
$_POST[dom_registdate] = date('Y-m-d');
$_POST[dom_domain] = $strDomainName;
print DataInsertString(domain_mgt) . "<br />";
$_POST[rkw_domid] = DataInsert(domain_mgt);
$sqlUpDate = " UPDATE rank_keyword SET rkw_domid = {$_POST[rkw_domid]} ";
$sqlUpDate .= " WHERE TRUE ";
$sqlUpDate .= " AND rkw_id = {$intRkwid} ";
# print $sqlUpDate . "<br />";
mysql_db_query($dbName, $sqlUpDate);
}
//End if
}
//End for
}
//End if
require 'cin/SQLClose.php';
}
