Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

How do you get a usernam who joined the cat?

E
elysha last edited by
I need to get a user name on the database that joined my cat. PyTelegramBotApi, MySQL database To get username, use a message from_user.username. I'm doing this on the database file.
```
self.cursor.execute("INSERT INTO `users` (`username` ) VALUES (?,?)", (message.from_user.username))
```
It doesn't work.
Reply Quote 0
1 Reply Last reply
M
meriah last edited by

You're telling me to put one value in it, and you wrote two playhulders.
"INSERT INTO users (sighs)username VALUES (??"
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

G

MySQL join/inner join 3 tables
Software Programming • mysql sql join • • gionna

2

0
Votes

2
Posts

0
Views

C

I think you better remove the inner condition and put it in a where:$query = "SELECT f.date, s.id, s.title, s.rate, s.thumbnail, u.username FROM favorites AS f INNER JOIN submissions AS s ON f.id_submission = s.id INNER JOIN users AS u ON f.id_user = u.id WHERE f.id_user = ".$user[0]["id"]." ORDER BY f.date DESC LIMIT 6";
R

InlineQuery and mp3 file
Software Programming • python python 3.x telebot pytelegrambotapi • • Rossere

2

0
Votes

2
Posts

0
Views

G

Give me a simple example when handler works in any way.import telebot from telebot import types bot = telebot.TeleBot('token') @bot.inline_handler(func=lambda query: len(query.query) > 0) def query_text(query): inline_btn = types.InlineQueryResultAudio( id='1', # уникальный идентификатор audio_url='', # ваша ссылка на аудиофайл title='Eisenmann', performer='Unheilig' ) bot.answer_inline_query(query.id, [inline_btn]) bot.polling(none_stop=True) https://core.telegram.org/bots/api#inlinequeryresultcachedaudio method - shipment of already stored Telegram audio fileIt's easier here. Give me a unique message. idand audio_file_id♪import telebot from telebot import types bot = telebot.TeleBot('token') @bot.message_handler(content_types=['audio']) def start(message): print(message.audio.file_id) # для получения audio_file_id аудиозаписи @bot.inline_handler(func=lambda query: len(query.query) > 0) def query_text(query): inline_btn = types.InlineQueryResultCachedAudio( id='1', audio_file_id='', # валидный file_id аудиофайла ) bot.answer_inline_query(query.id, [inline_btn]) bot.polling(none_stop=True) It looks like:
K

How do you get JSON's AppMetrica Yandex? Problem with GET
Software Programming • java android any language okhttp yandex metrika api • • Kadyn

2

0
Votes

2
Posts

0
Views

E

The mistake was stupid. The logCat was a filter that cleans up the logic. The NUJON returns on URL from question. This code is working.public static void getAppInstals(String appId, String token) { OkHttpClient client = new OkHttpClient(); String url = "https://beta.api-appmetrika.yandex.ru/logs/v1/export/installations.json?application_id=" + appId + "&fields=install_timestamp&date_since=2016-07-01 00:00:00&date_until=2016-07-14 00:00:00&oauth_token=" + token; Request request = new Request.Builder() .url(url) .get() .build(); client.newCall(request).enqueue(new Callback() { @Override public void onFailure(Call call, IOException e) { Log.d(TAG, "onFailure"); e.printStackTrace(); } @Override public void onResponse(Call call, Response response) throws IOException { Log.d(TAG, "onResponse"); Log.d(TAG, "response.code(): " + response.code()); String res = response.body().string(); Log.d(TAG, "response.body().string(): " + res); if (!response.isSuccessful()) { Log.d(TAG, "IOException"); throw new IOException("Unexpected code " + response); } } }); }
J

join 2 bases with join in R
Software Programming • join • • jules

2

0
Votes

2
Posts

0
Views

B

I guess you tried the following:library(dplyr) HRFINAL %>% left_join(SMFINAL ,by = "interview_id ") And you got duplicates.most likely it is that in the base SMFINAL the variable you want to make join It has duplicates, this you can check with:table(duplicated(SMFINAL$interview_id)) A possible solution is to remove duplicates of that variable by doing the following:SMFINAL = SMFINAL %>% distinct(interview_id , .keep_all = T) and then back to do the join:HRFINAL_SMFINAL = HRFINAL %>% left_join(SMFINAL ,by = "interview_id ")
K

How do you get a GET JS parameter?
Software Programming • javascript jquery ajax • • kalyn

2

0
Votes

2
Posts

0
Views

D

In js, there's an interface that defines the service methods for the url request line in more detail here. https://developer.mozilla.org/ru/docs/Web/API/URLSearchParams :var url = new URL('http://wer.com/js/chat.js?id=1&location=http://site.ru'); var searchParams = new URLSearchParams(url.search.substring(1)); var id = searchParams.get("id"), loc = searchParams.get("location"); console.log("id=" + id + " location=" + loc);
Y

How do you get a request to get data in one way?
Software Programming • mysql • • yajahira

2

0
Votes

2
Posts

0
Views

I think so. SELECT COUNT(name) AS cnt, month AS month FROM calendar GROUP BY month; And add WHERE If you need to.
D

How can a sample of goods and other goods be made up the message field aiogram
Software Programming • python python 3.x telegram bot pytelegrambotapi aiogram • • Duquan

2

0
Votes

2
Posts

0
Views

C

I should've gone a little more. It's called an online regime. Here you go. https://mastergroosha.github.io/telegram-tutorial-2/inline_mode/
K

How to hide the reference in the word pytelegramapi.
Software Programming • python python 3.x pytelegrambotapi • • kalyn

2

0
Votes

2
Posts

0
Views

J

bot.send_message(message.chat.id, "[какой-нибудь текст](https://google.com)", parse_mode="MarkdownV2") In your case:bot.send_message(message.chat.id, f"[какой-нибудь текст]({linck})", parse_mode="MarkdownV2")
J

Get id with username
Software Programming • php mysql mysqli • • jonetta

2

0
Votes

2
Posts

0
Views

J

After SELECT, you point the fields you want from the table. You can tell me. SELECT user_id, username FROM ... or anything like this: SELECT * FROM ...You don't have to do it on a request for every user.$preparedForSQLUsernames = []; foreach ($usernames as $username) { //экранируем строки (для защиты от инъекций) и оборачиваем в кавычки чтобы потом использовать в запросе $preparedForSQLUsernames[] = "'" . mysqli_real_escape_string($dbconn, $username) "'";} $query = "SELECT * FROM tb_users WHERE username IN (" . implode(",", $preparedForSQLUsernames) . ")"; If you don't do this shit, look at PDO class. http://php.net/manual/ru/class.pdo.php
How do you get a telegram link from TdApi?
Software Programming • telegram telegram api • • emmalee

2

0
Votes

2
Posts

0
Views

C

GetSupergroup accepts id type int containing a username that I've been looking for.
J

Trying to inline buttons on aiogram, but it'll make a mistake.
Software Programming • python python 3.x telegram aiogram • • jonetta

2

0
Votes

2
Posts

0
Views

R

Instead of creating one keyboard and appointing a button, you create 34 keyboards on one button in each, it's an incorrect logic. All of your tasks can be placed in several lines of the code:async def cmd_inline_url(message: types.Message): keyboard = types.InlineKeyboardMarkup() for i in range(1, 35): keyboard.add(types.InlineKeyboardButton(text=f"Номер {i}", callback_data=f"num{i}")) await message.answer("Номера", reply_markup=keyboard)
B

How do you put the button on the side of the telegram to allow the user to enter the required data?
Software Programming • python telegram telebot • • Burma

2

0
Votes

2
Posts

0
Views

R

Without optimization:@bot.message_handler(commands=['start']) def start(message): markup = types.InlineKeyboardMarkup() key_1 = types.InlineKeyboardButton(text='Создать заказ', callback_data="order") markup.add(key_1) bot.send_message(message.chat.id, 'Пожелание', reply_markup=markup) @bot.callback_query_handler(func=lambda call: True) def handler(call): if call.data == 'order': msg = bot.send_message(call.message.chat.id, 'Введите название товара: ') bot.register_next_step_handler(msg, product_name) elif call.data == 'order_Yes': save(order) bot.answer_callback_query(call.id, 'Yes') else: print('else') bot.answer_callback_query(call.id, 'else') def product_name(message): order.append(message.text) sleep(1) bot.delete_message(message.chat.id, message.message_id) msg = bot.edit_message_text(chat_id=message.chat.id, message_id=message.message_id - 1, text='Введите стоимость товара: ') bot.register_next_step_handler(msg, product_price) def product_price(message): order.append(message.text) sleep(1) bot.delete_message(message.chat.id, message.message_id) msg = bot.edit_message_text(chat_id=message.chat.id, message_id=message.message_id - 2, text='Введите описание товара: ') bot.register_next_step_handler(msg, product_description) def product_description(message): order.append(message.text) sleep(1) bot.delete_message(message.chat.id, message.message_id) markup = types.InlineKeyboardMarkup() key_1 = types.InlineKeyboardButton(text='Да', callback_data="order_Yes") key_2 = types.InlineKeyboardButton(text='Нет', callback_data="order_No") markup.add(key_1, key_2) bot.edit_message_text(chat_id=message.chat.id, message_id=message.message_id - 3, text=f'Имя товара: {order[0]}\nСтоймость товара: {order[1]}\n' f'Описание товара: {order[2]}\n\nСохранить позицию?', reply_markup=markup) def save(order_list): print(order_list)
J

How do you get these data out of the firebase? They're added with the List from androids, I need to get them out.
Software Programming • android firebase database • • juvenalb

2

0
Votes

2
Posts

0
Views

A

You can try that. Write the way to the right data, and then get to it. resultsyou'll get the data you need from all the data on it.UPDATETo collect all the data from all the lower nodes resultsMay be announced ArrayList and write down the lines received.private DatabaseReference mDatabase; private ArrayList<String> list; private String currentUserId = "ID пользователя, чьи результаты Вы хотите получить"; mDatabase = FirebaseDatabase.getInstance().getReference(); mDatabase.child("Users").child(currentUserId).child("results").get().addOnCompleteListener(new OnCompleteListener<DataSnapshot>() { @Override public void onComplete(@NonNull Task<DataSnapshot> task) { if (!task.isSuccessful()) { Log.e("firebase", "Ошибка при получении данных", task.getException()); } else { list = new ArrayList<String>(); DataSnapshot snapshot = task.getResult(); for (DataSnapshot dschild : snapshot.getChildren()) { String str0 = dschild.child("0").getValue().toString(); //строка 0 String str1 = dschild.child("1").getValue().toString(); //строка 1 list.add(str0); list.add(str1); } } } });
D

telegraf.js error in bot launch
Software Programming • javascript node.js telegram bot telegram telegram api • • Duquan

2

0
Votes

2
Posts

0
Views

Error: 401: Unauthorized That means you've indicated an incorrect token of the bot. Can you get it in @BotFather?
C

How do I call an asynchronous choir in a function that is initialized in a thread?
Software Programming • python python 3.x telegram bot telegram thread • • courtlanda

2

0
Votes

2
Posts

0
Views

E

General or you use asynchronous code for things in parallel, or uses code in multiple threads. It can mix both - and it is common to have time-consuming tasks running on other threads, and you control it from asynchronous code.The fact is that a function that is declared with async def, when it is called, it is not executed. Only when you perform await in the item that is returned from such a function is that it is actually executed. (so the "warning": it is not that you made a mistake - but you prepared the entire environment to run the code in a certain function, and never called that code, which was then not executed. What calls the code is the expression await)Only where another catch comes in: you can't just use await in a normal function, which is not created with async def.If your code is parallelized using threads, and not async, and you just want to call this function, a way to do is to start and close the loop by doing just that call. An asyncio loop started on a thread will be restricted to that thread.In short, a simple way to call your client.get_participants is pdir to asyncio boot a new loop, run to the end, and close the loop with the call asyncio.run:all_participants = asyncio.run(client.get_participants(PeerChannel(canal_id), aggressive=True)) the call asyncio.run, new in Python 3.7, unlike loop.run_until_complete of version 3.4, creates a new event loop automatically even if it is not in the main thread, expects the completion of the co-routine passed as parameter, and returns its result. In a normal design, it would be the entry point of the routines declared with async def - and it would be called once.Could be that you still have problems, since the library is designed for a parallelism with async, and you are forcing a thread template up. If problems persisitrem, better re-write all your code to use asyncio (and there you no longer need threads)

How do you get a usernam who joined the cat?

Suggested Topics

MySQL join/inner join 3 tables Software Programming • mysql sql join • • gionna

InlineQuery and mp3 file Software Programming • python python 3.x telebot pytelegrambotapi • • Rossere

How do you get JSON's AppMetrica Yandex? Problem with GET Software Programming • java android any language okhttp yandex metrika api • • Kadyn

join 2 bases with join in R Software Programming • join • • jules

How do you get a GET JS parameter? Software Programming • javascript jquery ajax • • kalyn

How do you get a request to get data in one way? Software Programming • mysql • • yajahira

How can a sample of goods and other goods be made up the message field aiogram Software Programming • python python 3.x telegram bot pytelegrambotapi aiogram • • Duquan

How to hide the reference in the word pytelegramapi. Software Programming • python python 3.x pytelegrambotapi • • kalyn

Get id with username Software Programming • php mysql mysqli • • jonetta

How do you get a telegram link from TdApi? Software Programming • telegram telegram api • • emmalee

Trying to inline buttons on aiogram, but it'll make a mistake. Software Programming • python python 3.x telegram aiogram • • jonetta

How do you put the button on the side of the telegram to allow the user to enter the required data? Software Programming • python telegram telebot • • Burma

How do you get these data out of the firebase? They're added with the List from androids, I need to get them out. Software Programming • android firebase database • • juvenalb

telegraf.js error in bot launch Software Programming • javascript node.js telegram bot telegram telegram api • • Duquan

How do I call an asynchronous choir in a function that is initialized in a thread? Software Programming • python python 3.x telegram bot telegram thread • • courtlanda

MySQL join/inner join 3 tables
Software Programming • mysql sql join • • gionna

InlineQuery and mp3 file
Software Programming • python python 3.x telebot pytelegrambotapi • • Rossere

How do you get JSON's AppMetrica Yandex? Problem with GET
Software Programming • java android any language okhttp yandex metrika api • • Kadyn

join 2 bases with join in R
Software Programming • join • • jules

How do you get a GET JS parameter?
Software Programming • javascript jquery ajax • • kalyn

How do you get a request to get data in one way?
Software Programming • mysql • • yajahira

How can a sample of goods and other goods be made up the message field aiogram
Software Programming • python python 3.x telegram bot pytelegrambotapi aiogram • • Duquan

How to hide the reference in the word pytelegramapi.
Software Programming • python python 3.x pytelegrambotapi • • kalyn

Get id with username
Software Programming • php mysql mysqli • • jonetta

How do you get a telegram link from TdApi?
Software Programming • telegram telegram api • • emmalee

Trying to inline buttons on aiogram, but it'll make a mistake.
Software Programming • python python 3.x telegram aiogram • • jonetta

How do you put the button on the side of the telegram to allow the user to enter the required data?
Software Programming • python telegram telebot • • Burma

How do you get these data out of the firebase? They're added with the List from androids, I need to get them out.
Software Programming • android firebase database • • juvenalb

telegraf.js error in bot launch
Software Programming • javascript node.js telegram bot telegram telegram api • • Duquan

How do I call an asynchronous choir in a function that is initialized in a thread?
Software Programming • python python 3.x telegram bot telegram thread • • courtlanda