// 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