''"); $rs=$query->fetch_assoc(); //echo $rs["SUM(TransactionFee+gasPrice)"] ; $query = mysqli_query($link, "Select Count(seqno) from AutoWord Where YN = 'N'"); $rs=$query->fetch_assoc(); $Count = htmlspecialchars($rs["Count(seqno)"]) ; if ( $Count == 0 ) { $i = 1; //i변수에 1을 대입합니다. while($i<=100) //i가 10보다 작거나 같을 때 반복합니다 { $SQL = "INSERT INTO AutoWord " ; $SQL = $SQL . " (" ; $SQL = $SQL . " word " ; $SQL = $SQL . ") values (" ; $SQL = $SQL . " '".AuthWord()."' " ; $SQL = $SQL . " )" ; mysqli_query($link,$SQL); $i++; //i를 1씩 증가합니다.(증감식) } } $query = mysqli_query($link, "Select word from AutoWord Where YN = 'N' and Confirm = 'N' ORDER BY RAND() LIMIT 1"); $rs=$query->fetch_assoc(); $AutoWord = htmlspecialchars($rs["word"]) ; $SQL = "UPDATE AutoWord set YN = 'Y' Where word = '".$AutoWord."' and YN = 'N' and Confirm = 'N'" ; mysqli_query($link,$SQL); $query = mysqli_query($link, "Select * from users Where UserEmail = '".$_SESSION['UserEmail']."'"); $rs=$query->fetch_assoc(); $deposit_address = base64_decode(htmlspecialchars($rs["deposit_address"])) ; $cash = htmlspecialchars($rs["cash"]) ; $query = mysqli_query($link, "Select * from users Where UserEmail = '".$_SESSION['UserEmail']."'"); $rs=$query->fetch_assoc(); $deposit_address = base64_decode(htmlspecialchars($rs["deposit_address"])) ; $cash = htmlspecialchars($rs["cash"]) ; $mobile_certification = htmlspecialchars($rs["mobile_certification"]) ; $strSQL = "Select arte_usdt " ; $strSQL = $strSQL . " from setting " ; $query = mysqli_query($link, $strSQL ); $quote_rs=$query->fetch_assoc(); $arte_usdt = $quote_rs["arte_usdt"]; function EXCHANGE_QUOTE() { $env = parse_ini_file('./.env'); $apikey = $env["apikey_2"]; $url = "https://v6.exchangerate-api.com/v6/".$apikey."/latest/USD" ; $headers = array( 'Content-Type: application/x-www-form-urlencoded' ); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); $result = curl_exec($ch); if ($result === FALSE) { die('Curl failed: ' . curl_error($ch)); } curl_close($ch); return $result; } $message_status = EXCHANGE_QUOTE(); $data = json_decode($message_status); $krw_quote = $data->conversion_rates->KRW ; $cny_quote = $data->conversion_rates->CNY ; $jpy_quote = $data->conversion_rates->JPY ; $php_quote = $data->conversion_rates->PHP ; $vnd_quote = $data->conversion_rates->VND ; $usdt_quote = sprintf("%.5f", 1/$krw_quote) ; $cny_quote = $krw_quote ; $jpy_quote = $krw_quote ; $php_quote = $krw_quote ; $vnd_quote = $krw_quote ; $usdt_quote = $krw_quote ; ?>