JleUTeHaHT's questions

import pymysql, time, asyncio, requests, sys, threading, os, socks
from telethon import TelegramClient, events
from telethon.tl.functions.channels import JoinChannelRequest

pid = os.getpid()
print(pid)

r = requests.post('http://ip:5000/api/select/account', json={"token": ""})
if r.json()['Status'] == 2:
    print("Нет доступных аккаунтов")
    sys.exit()
else:
    x, Phone, Api_id, Api_hash = r.json()['Id'], r.json()['Phone'], r.json()['Api_id'], r.json()['Api_hash']

client = TelegramClient(session=str(f'C:\\Users\\Админ\\Desktop\\RG\\new\\session{x}'), api_id=Api_id, api_hash=Api_hash).start()

a = requests.post('http://ip:5000/api/set/status/pid', json={"token": "", "x": x, "pid": pid})

@client.on(events.NewMessage(func=lambda e: e.is_private))
async def handler(event):
    try:
        print(event.message.message)#текст
        await client.get_dialogs()
        id = event.message.peer_id.user_id#юзерка пользователя
        info = await client.get_entity(event.message.peer_id.user_id)
        print(info.to_dict()['username'])#юзерка
        username = info.to_dict()['username']
        if username is None:
            username = "None"
        z = requests.post('http://ip:5000/api/upload/message', json={"token": "", "x": x, "Text": event.message.message, "User_id": id, "Username": username, "Number": Phone, "id": x})
    except Exception as e:
        print(e)

async def join(Task, client):
    print("1")
    print(Task)
    return await client(JoinChannelRequest(Task))

async def send(Task, Message, client):
    print("2")
    print(Task, Message)
    return await client.send_message(f"{Task}", f"{Message}")

#/api/check/task/account
def t():
    while True:
        r = requests.post('http://ip:5000/api/check/task/account', json={"token": "", "Phone": Phone})
        if r.json()['status'] == 2:
            time.sleep(2)
        else:
            Type = r.json()['Type']
            if Type == "join":
                Task = r.json()['Task']
                _thread = threading.Thread(target=asyncio.run, args=(join(Task, client),)).start()
            if Type == "send":
                Task = r.json()['Task']
                Message = r.json()['Message']
                _thread = threading.Thread(target=asyncio.run, args=(send(Task, Message, client),)).start()

threading.Thread(target=t, args=()).start()

client.run_until_disconnected()

当向函数发送任务（加入、发送）时，它们根本不会被执行，尽管如果它不是以异步方式启动，一切正常。

bb = "user_1"
user_id = "555454455445"
peer_id = "20000000000000003"


cur.execute(f"UPDATE rooms SET '{bb}' = '{peer_id}' WHERE peer_id = '{peer_id}'")
con.commit()

pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that 
corresponds to your MariaDB server version for the right syntax to use near ''user_1' = 
'555454455445' WHERE peer_id = '2000000003'' at line 1")

如果你简单地说user_1，那么一切正常，如果它是变量的形式，那么它就会崩溃。

它可以与什么连接？

import requests
import vk_api
from vk_api.bot_longpoll import VkBotLongPoll, VkBotEventType
import random

bot_session = vk_api.VkApi(token="Токен сообщества-бота, доступ ко всему")
bot_api = bot_session.get_api()
while True:
    longpoll = VkBotLongPoll(bot_session, "id сообщества-бота")
    try:
        for event in longpoll.listen():
        #...
    except requests.exceptions.ReadTimeout as timeout:
        continue

谁有GROUP TO CHAT的WORKING机器人， 以便机器人只响应 CHAT。搜索互联网，发现没有任何工作。

from vk_api.longpoll import VkLongPoll, VkEventType
from vk_api.keyboard import VkKeyboard, VkKeyboardColor
import vk_api
from datetime import datetime
import random
import time
import json, requests, hashlib, time, re, urllib.request, os, pymysql

vk_session = vk_api.VkApi(token='XXXXXXXX')
session_api = vk_session.get_api()
longpoll = VkLongPoll(vk_session)
chat_id = session_api.messages.searchConversations(q='Chat_BotInfo(Beta)', count=1)['items'][0]['peer']['local_id']
print(chat_id)

while(True):
    session_api.messages.send("chat_id": 6,{"message":"Привет!!!", "random_id":123456})
    time.sleep(900)

错误：

File "test1.py", line 14
session_api.messages.send("chat_id": 6,{"message":"Привет!!!", "random_id":123456})
                                       ^
SyntaxError: invalid syntax

如何每 15 分钟向 chat_id 发送一条消息？

from telethon import TelegramClient
import socks
client = TelegramClient('session_id',
api_id=12345, api_hash='0123456789abcdef0123456789abcdef',
proxy=(socks.SOCKS5, 'localhost', 4444))

如何使用私人代理？图书馆说要使用PySocks <- 链接。怎么做才对？

from pycoingecko import CoinGeckoAPI
cg = CoinGeckoAPI()
a = cg.get_price(ids='litecoin', vs_currencies='rub')
#{'litecoin': {'rub': 4451.29}}
print(a)

如何取款 (#{'litecoin': {'rub': 4451.29}}) - 仅收费？

如何在 Telegram 中显示频道 ID。

for mes in msgs:
        with TelegramClient(Phone, api_id, api_hash) as client:
            result = client(functions.messages.GetAllChatsRequest(
                except_ids=[42]
            ))
            print(result.stringify('id')) 
            был такой еще вариант
            print(result.stringify(['channel', 'id']))
            #my_file = open('test.txt', 'a')
            #my_file.write(result.stringify()+'\n')
            #print("TEST")
            time.sleep(6) 

它只是显示有关频道的所有信息。

错误

print(result.stringify('id')) TypeError: stringify() 接受 1 个位置参数，但给出了 2 个

Channel(
        id=1499501182,
        title='Тут было название канала',
        photo=ChatPhoto(
            photo_small=FileLocationToBeDeprecated(
                volume_id=200006400504,
                local_id=390002
            ),
            photo_big=FileLocationToBeDeprecated(
                volume_id=200006400504,
                local_id=390004
            ),
            dc_id=2
        ),
        date=datetime.datetime(2020, 7, 14, 11, 15, 37, tzinfo=datetime.timezone.utc),
        version=0,
        creator=False,
        left=False,
        broadcast=True,
        verified=False,
        megagroup=False,
        restricted=False,
        signatures=False,
        min=False,
        scam=False,
        has_link=False,
        has_geo=False,
        slowmode_enabled=False,
        access_hash=6797022806759780742,
        username='Тут было название канала',
        restriction_reason=[
        ],
        admin_rights=None,
        banned_rights=None,
        default_banned_rights=None,
        participants_count=None
    ),

SELECT DATE_ADD( Date, INTERVAL 4 Hour) AS EndFROM LogWHERE Id= 3 - 这只是进行选择，但如何将其写入另一列，并且此过程是否有任何自动化，以便在添加后它本身加起来？该表仅用于测试目的。

在代码中，只加入频道本身。

url_rec = messages[0].reply_markup.rows[0].buttons[0].url
client(JoinChannelRequest(url_rec))
button_data = mes.reply_markup.rows[0].buttons[1].data
message_id = mes.id
from telethon.tl.functions.messages import GetBotCallbackAnswerRequest
resp = client(GetBotCallbackAnswerRequest(
   tegmo,
   message_id,
   data=button_data
   ))
print("applyjoin")