$stmt = pdo()->prepare("INSERT INTO `freeroll` (`name_turnament`, `prize`, `password`, `data`, `time`, `category_id`, `prize_symbol`, `buyin` , `buyin_symbol`, `category_name`, `category_img`, `category_url`)
SELECT :name_turnament, :prize, :password, .......... и тд, name, img, url FROM category WHERE id = :category_id");
$stmt->execute([
'name_turnament' => $_POST['name_turnament'],
'prize' => $_POST['prize'],
'password' => $_POST['password'],
'data' => $_POST['data'],
'time' => $_POST['time'],
'prize_symbol' => $_POST['symbol'],
'buyin' => $_POST['buyin'],
'buyin_symbol' => $_POST['buyin_symbol'],
'category_id' => $category_id
]);
$query = ("
INSERT INTO `order_archive`(`id`, `user_id`, `articul_id`, `barcode`, `quantity`, `supply_id`) VALUES ($supply_id)
SELECT `id`, `user_id`, `articul_id`, `barcode`, `quantity`, " . $supply_id . " as supply_id FROM `order` WHERE `id` IN ($ids);
DELETE FROM `order` WHERE `id` IN ($ids)");
@bot.message_handler(commands=['start'])
def start(message):
msg = bot.send_message(message.chat.id,'Здравствуйте, отправьте адреса кошельков что бы между адресами был пробел(запятая и перевод строки не подходят),')
bot.register_next_step_handler(msg, sender)
@bot.message_handler(func=lambda m: True)
def sender(message):
urls_list = []
price_list = []
user_id = message.from_user.id
number = (len(message.text.split(' ')))
for count in range(0,number):
addresses = message.text.split(' ')[count]
response = requests.get(url = f'https://api.debank.com/hi/user/info?id={addresses}', headers=HEADERS).text
price = response.split('"usd_value":')[1].split(',')[0].split('.')[0]
print(price)
urls_list.append('https://debank.com/profile/' + addresses)
price_list.append(price)
df = pd.DataFrame ({'urls':urls_list,'amounts':price_list})
df.to_excel(f'D:\PYTHON\DeBank\{user_id}.xlsx', sheet_name='Info', index=False)
file = open(f'D:\PYTHON\DeBank\{user_id}.xlsx','rb')
bot.send_document(message.chat.id,file)
#Здесь удали файл 'D:\PYTHON\DeBank\{user_id}.xlsx'
public function updateDevMode(){
$devices_dep = "YOUR_TABLE_NAME";
$device_mode=htmlspecialchars(strip_tags($this->device_mode));
$id=htmlspecialchars(strip_tags($this->id));
$sqlQuery = "UPDATE $devices_dep SET device_mode=$device_mode WHERE id=$id";
$this->db->query($sqlQuery);
if($this->db->affected_rows > 0){
return true;
}
return false;
}