// votepoints value has changed
if (is_null($errorMessage) && isChanged($voteid, "votepoints", $votepoints, $server)) {
// votepoints is invalid
if ($votepoints < Flux::config('VotePointsMin') && $votepoints > Flux::config('votePointsMax')) {
$errorMessage = sprintf(Flux::message("InvalidVotePoints"), Flux::config('VotePointsMin'), Flux::config('VotePointsMax'));
} else {
// failed to update the value
if (!updateValue($voteid, "votepoints", $votepoints, $server)) {
$errorMessage = sprintf(Flux::message("FailedToUpdate"), "Vote Points");
} else {
$hasUpdate = TRUE;
}
}
}
// imageurl value has changed
if (is_null($errorMessage) && isChanged($voteid, "imgurl", $imageurl, $server) && $imageurl !== "") {
// imageurl is not a valid url
if (!filter_var($imageurl, FILTER_VALIDATE_URL)) {
$errorMessage = sprintf(Flux::message("InvalidURL"), 'Image URL');
} else {
// failed to update the value
if (!updateValue($voteid, "imgurl", $imageurl, $server)) {
$errorMessage = sprintf(Flux::message("FailedToUpdate"), "Image URL");
} else {
$hasUpdate = TRUE;
}
}
}
// updating imagename
if (is_null($errorMessage) && $imageurl === "" && $uploadimg['error'] === 0) {
$ext = explode(".", $uploadimg['name']);
kyoto_user_card_tbl
WHERE
{$user_key} = {$key_value}
SQL;
$aryResult = $oMgr->oDb->getAll($sql);
if (count($aryResult) > 1) {
echo $cnt . "行目：キー項目[" . $user_key . ":" . $aryImp[$user_key] . "]は複数のレコードにヒットしたため処理できませんでした。\n";
continue;
}
$aryRet = $aryResult[0];
//print_r($aryRet);
//print_r($aryImp);
//
// 比較
//
if (isChanged($aryRet, $aryImp)) {
$key_number = $oMgr->sqlItemChar($aryImp['key_number']);
$belong_info_1 = $oMgr->sqlItemChar($aryImp['belong_info_1']);
$belong_info_2 = $oMgr->sqlItemChar($aryImp['belong_info_2']);
$belong_info_3 = $oMgr->sqlItemChar($aryImp['belong_info_3']);
$belong_info_4 = $oMgr->sqlItemChar($aryImp['belong_info_4']);
$card_type = $oMgr->sqlItemChar($aryImp['card_type']);
$uid = $oMgr->sqlItemChar($aryImp['uid']);
$start_date = $oMgr->sqlItemChar($aryImp['start_date']);
$end_date = $oMgr->sqlItemChar($aryImp['end_date']);
$suspend_flg = $oMgr->sqlItemFlg($aryImp['suspend_flg']);
// DBを更新
$sql = <<<SQL
UPDATE
kyoto_user_card_tbl
SET
