def ts_view(bot, update, message_id=None, chat_id=None): message = update.message if is_allow(update.effective_user.id): res = get_ts_view() keyboard = [[ InlineKeyboardButton(_("Update"), callback_data='TS_UPDATE') ]] reply_markup = InlineKeyboardMarkup(keyboard) if message_id and chat_id: bot.edit_message_text(text=res, chat_id=chat_id, message_id=message_id, reply_markup=reply_markup, parse_mode='Markdown') else: bot.send_message(message.chat.id, res, reply_to_message_id=message.message_id, reply_markup=reply_markup, parse_mode='Markdown') else: bot.send_message(message.chat.id, _("You aren't allow to use this"), reply_to_message_id=message.message_id)
def send_ts_users_in_group(bot, update, chat_data, group_id=None): message = update.effective_message text = 'π₯ ' + _('*Group users:*') + '\n\n' \ + _('Here is a list of all users in this group, pressing any of them will take you to his detail.') if group_id is not None: chat_data[message.message_id]['group_id'] = group_id else: group_id = chat_data[message.message_id]['group_id'] users = get_ts_users_in_group(group_id) users = sorted(users, key=lambda user: user['client_lastconnected'], reverse=True) back_button_row = [ InlineKeyboardButton('π ' + _('Back'), callback_data='GROUP_DETAIL_USERS_%s_BACK' % group_id) ] paginate_items(bot, update, chat_data, items=users, principal_property='client_nickname', backend_property='client_database_id', text=text, callback='GROUP_DETAIL_USERS', additional_row=back_button_row)
def send_delete_user_from_group(bot, update, chat_data, group_id=None): message = update.effective_message text = 'π₯ ' + _('*Select an user to delete from group:*') if group_id is not None: chat_data[message.message_id]['group_id'] = group_id else: group_id = chat_data[message.message_id]['group_id'] users = get_ts_users_in_group(group_id) users = sorted(users, key=lambda user: user['client_lastconnected'], reverse=True) back_button_row = [ InlineKeyboardButton('π ' + _('Back'), callback_data='GROUP_%s_DEL_BACK' % group_id) ] paginate_items(bot, update, chat_data, items=users, principal_property='client_nickname', backend_property='client_database_id', text=text, callback='GROUP_%s_DEL' % group_id, additional_row=back_button_row)
def markup_append_pagination(bot, update, items, markup, page, callback, items_per_page=10): pag_max = math.ceil(len(items) / items_per_page) pag_button = InlineKeyboardButton(_('Page') + ' %s/%s' % (str(page), str(pag_max)), callback_data='%s_PG_NEXT' % callback) if len(items) >= items_per_page: if page == 1: sig_button = InlineKeyboardButton( _('Page') + ' %s/%s β©' % (str(page), str(pag_max)), callback_data='%s_PG_NEXT' % callback) markup.append([sig_button]) elif 1 < page < pag_max: ant_button = InlineKeyboardButton('βͺ ' + _('Prev'), callback_data='%s_PG_PREV' % callback) sig_button = InlineKeyboardButton('β© ' + _('Next'), callback_data='%s_PG_NEXT' % callback) markup.append([ant_button, pag_button, sig_button]) elif page == pag_max: ant_button = InlineKeyboardButton( _('Page') + ' %s/%s βͺ' % (str(page), str(pag_max)), callback_data='%s_PG_PREV' % callback) markup.append([ant_button]) return markup
def mention_toggle(bot, update): message = update.message if not utils.is_allow(message.from_user.id): text = _("You aren't allow to use this") elif message.chat.type == 'private': text = _('Use this command in the group where you want to activate/disable the notifications') else: text = utils.mention_toggle(bot, update, message.chat_id, message.from_user.id) bot.sendMessage(message.chat_id, text, reply_to_message_id=message.message_id)
def generate_invitation(bot, update): message = update.message token = utils.generate_invitation() link = 'https://telegram.me/%s?start=%s' % (bot.username, token) share_link = 'https://telegram.me/share/url?url={0}&text=Click%20the%20link%20to%20join%20the%20teamspeak%20bot'.format(link) keyboard = [[InlineKeyboardButton(_('Join'), url=link)], [InlineKeyboardButton(_('Share link'), url=share_link)]] reply_markup = InlineKeyboardMarkup(keyboard) bot.sendMessage(message.chat_id, 'π ' + _('Welcome to TeamSpeak bot') + ' π\n\n' + _('This is an invitation to use the TeamSpeak bot'), reply_markup=reply_markup)
def send_ts_groups(bot, update, chat_data): text = 'π₯ ' + _('*Group list:*') + '\n\n' \ + _('Here is a list of your TeamSpeak groups, pressing any of them will take you to his detail.') paginate_items(bot, update, chat_data, items=get_ts_groups(), principal_property='name', backend_property='sgid', text=text, callback='GROUP')
def ts_stats(bot, update): try: ts_users = ts_connect() text = 'πβπ¨ ' + _('Users online:') + '\n' if len(ts_users) == 0: text = _('There is no one right now') else: for client in ts_users: text += '%s\n' % client return text except Exception as exception: return exception
def ts_stats(bot, update): message = update.message if utils.is_allow(message.from_user.id): stats = utils.ts_stats(bot, update) else: stats = _("You aren't allow to use this") bot.send_message(message.chat.id, stats, reply_to_message_id=message.message_id)
def send_users_tsdb(bot, update, chat_data): text = 'π ' + _('*User list:*') + '\n\n' \ + _('Here is a list of all your TeamSpeak users, pressing any of them will take you to his detail.') users = get_users_tsdb() users = sorted(users, key=lambda user: user['client_lastconnected'], reverse=True) paginate_items(bot, update, chat_data, items=users, principal_property='client_nickname', backend_property='cldbid', text=text, callback='USER')
def pre_send_gm(bot, update): message = update.message if is_allow(message.from_user.id): text = _( "Ok, what message do you want to send?\nUse /cancel to cancel the command." ) bot.send_message(message.chat_id, text, reply_to_message_id=message.message_id, reply_markup=ForceReply(selective=True)) return 0 else: text = _("You aren't allow to use this") bot.send_message(message.chat_id, text, reply_to_message_id=message.message_id) return ConversationHandler.END
def paginate_items(bot, update, chat_data, items, principal_property, backend_property, text, callback, additional_row=None): message = update.effective_message chat_id = message.chat_id markup = [] first_message = bool(update.message) page = chat_data[message.message_id]['pages'] if not first_message else 1 start = 10 * (page - 1) if page > 1 else 0 end = start + 10 if start + 10 < len(items) else len(items) for i in range(start, end, 2): item1 = items[i] row = [ InlineKeyboardButton(item1[principal_property], callback_data='%s_DETAIL_%s' % (callback, str(item1[backend_property]))) ] if i + 1 < len(items): item2 = items[i + 1] row.append( InlineKeyboardButton(item2[principal_property], callback_data='%s_DETAIL_%s' % (callback, str(item2[backend_property])))) markup.append(row) markup = markup_append_pagination(bot, update, items, markup, page, callback) if additional_row is not None: markup.append(additional_row) reply_markup = InlineKeyboardMarkup(markup) if len(items) == 0: text = _('No results') if not first_message: bot.edit_message_text(text, chat_id=chat_id, message_id=message.message_id, reply_markup=reply_markup, parse_mode='Markdown') else: msg = bot.send_message(chat_id, text, disable_notification=True, reply_markup=reply_markup, parse_mode='Markdown') chat_data[msg.message_id] = dict() chat_data[msg.message_id]['pages'] = page
def send_gm(bot, update): message = update.message ts_gm(message.text) text = _("Global message has been sent to server successfully.") bot.send_message(message.chat_id, text, reply_to_message_id=message.message_id) return ConversationHandler.END
def start(bot, update, args): message = update.message user = message.from_user res = False link = "http://www.teamspeak.com/invite/%s/" % TS_HOST reply_markup = InlineKeyboardMarkup([[InlineKeyboardButton(_('Connect TS'), url=link)]]) if args: res = utils.validate_invitation_token(token=args[0], user_id=user.id, name=user.first_name) if res: text = _("Welcome %s you're now activated, using /who or /ts you can check who's in teamspeak.") % \ user.first_name elif utils.is_allow(user.id): text = _("Hello %s, using /who or /ts you can check who's in teamspeak.") % user.first_name else: reply_markup = None text = _("Welcome, ask admin to generate an invitation link by /generate") bot.sendMessage(message.chat_id, text, reply_to_message_id=message.message_id, reply_markup=reply_markup)
def send_ts_groups_by_user(bot, update, chat_data, cldbid): text = 'π₯ ' + _('*Group list:*') + '\n\n' \ + _('Here is the TeamSpeak group list of this user, pressing any of them will take you to his detail.') back_button_row = [ InlineKeyboardButton('π ' + _('Back'), callback_data='GROUP_BY_USER_%s_BACK' % cldbid) ] clean_pages(chat_data, update.effective_message.message_id) paginate_items(bot, update, chat_data, items=get_ts_groups_by_client_id(cldbid), principal_property='name', backend_property='sgid', text=text, callback='GROUP', additional_row=back_button_row)
def assign_user_alias_step1(bot, update, chat_data, cldbid): chat_id = update.effective_chat.id text = 'πββοΈ ' + _('Ok, give me an *alias* for that user') message_sent = bot.send_message(chat_id, text, reply_markup=ForceReply(), parse_mode='Markdown') if 'alias_cldbid' not in chat_data: chat_data['alias_cldbid'] = dict() chat_data['alias_cldbid'][str(message_sent.message_id)] = '', cldbid chat_data['bot_update'] = bot, update
def kick_ts_user(bot, update, cldbid, kick_type): with ts3.query.TS3Connection(ts_host) as ts3conn: try: ts3conn.login(client_login_name=ts_user, client_login_password=ts_pass) except ts3.query.TS3QueryError as err: print("Login failed:", err.resp.error["msg"]) exit(1) ts3conn.use(sid=1) try: cluid = ts3conn.clientdbinfo( cldbid=cldbid).parsed[0]['client_unique_identifier'] clid = ts3conn.clientgetids(cluid=cluid).parsed[0]['clid'] ts3conn.clientkick(reasonid=kick_type, clid=clid, reasonmsg="Kicked from TeamSpeakBot") bot.answer_callback_query(update.callback_query.id, _('User kicked successfully')) except ts3.query.TS3QueryError: bot.answer_callback_query(update.callback_query.id, _('Something went wrong'))
def mention_toggle(bot, update, group_id, user_id): con = pymysql.connect(DB_HOST, DB_USER, DB_PASS, DB_NAME) try: with con.cursor() as cur: cur.execute( "SELECT EXISTS(SELECT 1 FROM TsMentions WHERE Group_id=%s and User_id=%s LIMIT 1)", (str(group_id), str(user_id))) mention = bool(cur.fetchone()[0]) if not mention: cur.execute("INSERT INTO TsMentions VALUES (%s, %s)", (str(group_id), str(user_id))) return 'β ' + _('Activated mentions') else: cur.execute( 'DELETE FROM TsMentions WHERE Group_id = %s and User_id = %s', (str(group_id), str(user_id))) return 'β ' + _('Disabled mentions') except Exception: logger.error('Fatal error in mention_toggle', exc_info=True) finally: if con: con.commit() con.close()
def delete_ts_user_to_group(bot, update, chat_data, group_id, cldbid): with ts3.query.TS3Connection(ts_host) as ts3conn: try: ts3conn.login(client_login_name=ts_user, client_login_password=ts_pass) except ts3.query.TS3QueryError as err: print("Login failed:", err.resp.error["msg"]) exit(1) ts3conn.use(sid=1) ts3conn.servergroupdelclient(sgid=group_id, cldbid=cldbid) bot.answer_callback_query(update.callback_query.id, _('User deleted from group successfully')) del chat_data[update.effective_message.message_id]['pages'] send_ts_group_details(bot, update, chat_data, group_id=group_id)
def unban_ts_user(bot, update, chat_data, cldbid, banid): with ts3.query.TS3Connection(ts_host) as ts3conn: try: ts3conn.login(client_login_name=ts_user, client_login_password=ts_pass) except ts3.query.TS3QueryError as err: print("Login failed:", err.resp.error["msg"]) exit(1) ts3conn.use(sid=1) ts3conn.bandel(banid=banid) bot.answer_callback_query(update.callback_query.id, _('User unbanned successfully')) if cldbid: details_user_ts(bot, update, chat_data, cldbid=cldbid) else: send_users_tsdb(bot, update, chat_data)
def assign_user_alias_step3(bot, update, chat_data, telegram_id): message = update.effective_message alias, cldbid = chat_data['alias_cldbid'][str(message.message_id)] skip = bool(int(telegram_id) == 0) if skip: add_user(telegram_id, alias, cldbid) else: assign_name_tsid(telegram_id, name=alias, ts_id=cldbid) bot.delete_message(chat_id=message.chat_id, message_id=message.message_id) bot.answer_callback_query(update.callback_query.id, _('Alias assigned successfully'), show_alert=True) menu_bot, menu_update = chat_data['bot_update'] del chat_data['bot_update'] send_users_tsdb(menu_bot, menu_update, chat_data)
def ban_ts_user(bot, update, chat_data, cldbid, ban_type): user = get_user_ts_info(cldbid) with ts3.query.TS3Connection(ts_host) as ts3conn: try: ts3conn.login(client_login_name=ts_user, client_login_password=ts_pass) except ts3.query.TS3QueryError as err: print("Login failed:", err.resp.error["msg"]) exit(1) ts3conn.use(sid=1) if ban_type == 'ID': ts3conn.banadd(uid=user['client_unique_identifier']) elif ban_type == 'IP': ts3conn.banadd(ip=user['client_lastip']) else: ts3conn.banadd(name=user['client_nickname']) bot.answer_callback_query(update.callback_query.id, _('User banned successfully')) details_user_ts(bot, update, chat_data, cldbid=int(cldbid))
def send_ts_group_details(bot, update, chat_data, group_id=None): message = update.effective_message chat_id = message.chat_id if group_id is not None: chat_data[message.message_id]['group_id'] = group_id else: group_id = chat_data[message.message_id]['group_id'] ts_group = get_ts_group(group_id) if int(ts_group['savedb']) == 0: bot.answer_callback_query(update.callback_query.id, _('Access to default group is forbidden')) return False text = 'π *' + ts_group['name'] + ' ' + _('group:') + '*' markup = [[ InlineKeyboardButton('π₯ ' + _('List users'), callback_data='GROUP_DETAIL_USERS_%s' % group_id) ], [ InlineKeyboardButton('β ' + _('Add user'), callback_data='GROUP_%s_ADD' % group_id), InlineKeyboardButton('β ' + _('Delete user'), callback_data='GROUP_%s_DEL' % group_id) ], [ InlineKeyboardButton('π ' + _('Back'), callback_data='GROUP_DETAIL_BACK') ]] reply_markup = InlineKeyboardMarkup(markup) bot.edit_message_text(text, chat_id=chat_id, message_id=message.message_id, reply_markup=reply_markup, parse_mode='Markdown')
def unknown(bot, update): bot.sendMessage(chat_id=update.message.chat_id, text=_("Sorry, I didn't understand that command."))
def cancel(bot, update): message = update.message bot.sendMessage(chat_id=message.chat_id, text=_('Global text has been cancelled.'), reply_to_message_id=message.message_id, reply_markup=ReplyKeyboardRemove(selective=True)) return ConversationHandler.END
def callback_query_handler(bot, update, chat_data): query_data = update.callback_query.data message = update.effective_message no_chat_data = message.message_id not in chat_data or 'pages' not in chat_data[ message.message_id] if update.effective_user.id == ADMIN_ID and no_chat_data: chat_data[message.message_id] = dict() chat_data[message.message_id]['pages'] = 1 if query_data.startswith('TS_UPDATE'): a = get_ts_view() if a == message.text_markdown: bot.answer_callback_query(update.callback_query.id, _('No changes')) else: ts_view(bot, update, message_id=message.message_id, chat_id=update.effective_chat.id) bot.answer_callback_query(update.callback_query.id, _('Successfully updated')) elif update.effective_user.id != ADMIN_ID: bot.answer_callback_query(update.callback_query.id, _('You must be admin')) elif query_data.startswith('USER'): if 'PG' in query_data: chat_data[message. message_id]['pages'] += 1 if 'NEXT' in query_data else -1 send_users_tsdb(bot, update, chat_data) elif query_data.startswith('USER_BAN'): if query_data.startswith('USER_BAN_ID'): cldbid, ban_type = int( query_data.split('USER_BAN_ID_')[1]), 'ID' elif query_data.startswith('USER_BAN_IP'): cldbid, ban_type = int( query_data.split('USER_BAN_IP_')[1]), 'IP' else: cldbid, ban_type = int( query_data.split('USER_BAN_NAME_')[1]), 'NAME' ban_ts_user(bot, update, chat_data, cldbid=cldbid, ban_type=ban_type) elif query_data.startswith('USER_UNBAN'): cldbid, banid = query_data.split("USER_UNBAN_")[1].split("_") unban_ts_user(bot, update, chat_data, banid=int(banid), cldbid=int(cldbid)) elif query_data.startswith('USER_DETAIL'): cldbid = query_data.split("USER_DETAIL_")[1] details_user_ts(bot, update, chat_data, cldbid=int(cldbid)) elif query_data.startswith('USER_KICK'): uid, kick_type = query_data.split("USER_KICK_")[1].split("_") kick_ts_user(bot, update, int(uid), int(kick_type)) elif query_data.startswith('USER_ALIAS'): if query_data.startswith('USER_ALIAS_PRE'): cldbid = query_data.split("USER_ALIAS_PRE_")[1] assign_user_alias_step1(bot, update, chat_data, cldbid) elif query_data.startswith('USER_ALIAS_PG'): chat_data[ message.message_id]['pages'] += 1 if query_data.startswith( 'USER_ALIAS_PG_NEXT') else -1 assign_user_alias_step2(bot, update, chat_data) elif query_data.startswith('USER_ALIAS'): telegram_id = query_data.split("USER_ALIAS_")[1] assign_user_alias_step3(bot, update, chat_data, telegram_id) elif query_data.startswith('USER_BACK'): send_users_tsdb(bot, update, chat_data) elif query_data.startswith('GROUP'): if 'PG' in query_data: chat_data[message. message_id]['pages'] += 1 if 'NEXT' in query_data else -1 if query_data.startswith('GROUP_DETAIL_USERS'): send_ts_users_in_group(bot, update, chat_data) elif 'ADD' in query_data: group_id = query_data.split("GROUP_")[1].split("_ADD")[0] send_add_user_to_group(bot, update, chat_data, group_id=int(group_id)) elif 'DEL' in query_data: group_id = query_data.split("GROUP_")[1].split("_DEL")[0] send_delete_user_from_group(bot, update, chat_data, group_id=int(group_id)) else: send_ts_groups(bot, update, chat_data) elif query_data.startswith('GROUP_BY_USER'): cldbid = query_data.split("GROUP_BY_USER_")[1].split("_BACK")[0] if 'BACK' in query_data: details_user_ts(bot, update, chat_data, cldbid=int(cldbid)) else: send_ts_groups_by_user(bot, update, chat_data, cldbid=cldbid) elif query_data.startswith('GROUP_DETAIL_USERS'): if query_data.startswith('GROUP_DETAIL_USERS_DETAIL'): cldbid = query_data.split("GROUP_DETAIL_USERS_DETAIL_")[1] details_user_ts(bot, update, chat_data, cldbid=int(cldbid)) else: group_id = query_data.split("GROUP_DETAIL_USERS_")[1].split( "_BACK")[0] if 'BACK' in query_data: send_ts_group_details(bot, update, chat_data, group_id=int(group_id)) else: send_ts_users_in_group(bot, update, chat_data, group_id=int(group_id)) elif query_data.startswith('GROUP_DETAIL'): if 'BACK' in query_data: send_ts_groups(bot, update, chat_data) else: group_id = query_data.split("GROUP_DETAIL_")[1] send_ts_group_details(bot, update, chat_data, group_id=int(group_id)) elif 'ADD' in query_data: if query_data.endswith('ADD') or query_data.endswith('ADD_BACK'): group_id = query_data.split("GROUP_")[1].split( "_ADD")[0].split("_BACK")[0] if 'BACK' in query_data: send_ts_group_details(bot, update, chat_data, group_id=int(group_id)) else: send_add_user_to_group(bot, update, chat_data, group_id=int(group_id)) elif 'ADD_DETAIL' in query_data: group_id, cldbid = query_data.split("GROUP_")[1].split( '_ADD_DETAIL_') add_ts_user_to_group(bot, update, chat_data, group_id=int(group_id), cldbid=int(cldbid)) elif 'DEL' in query_data: if query_data.endswith('DEL') or query_data.endswith('DEL_BACK'): group_id = query_data.split("GROUP_")[1].split( "_DEL")[0].split("_ADD")[0].split("_BACK")[0] if 'BACK' in query_data: send_ts_group_details(bot, update, chat_data, group_id=int(group_id)) else: send_delete_user_from_group(bot, update, chat_data, group_id=int(group_id)) elif 'DEL_DETAIL' in query_data: group_id, cldbid = query_data.split("GROUP_")[1].split( '_DEL_DETAIL_') delete_ts_user_to_group(bot, update, chat_data, group_id=int(group_id), cldbid=int(cldbid))
def assign_user_alias_step2(bot, update, chat_data): message = update.effective_message chat_id = update.effective_chat.id markup = [] first_message = bool(update.message) page = chat_data[message.message_id]['pages'] if not first_message else 1 user_ids = get_user_ids() start = 10 * (page - 1) if page > 1 else 0 end = start + 10 if start + 10 < len(user_ids) else len(user_ids) for i in range(start, end, 2): j = i + 1 try: user1 = bot.get_chat_member(chat_id=user_ids[i], user_id=user_ids[i]).user username1 = '@' + user1.username if user1.username else user1.first_name except TelegramError: username1 = 'ID: ' + str(user_ids[i]) row = [ InlineKeyboardButton(username1, callback_data='USER_ALIAS_%s' % str(user_ids[i])) ] if j < len(user_ids): try: user2 = bot.get_chat_member(chat_id=user_ids[j], user_id=user_ids[j]).user username2 = '@' + user2.username if user2.username else user2.first_name except TelegramError: username2 = 'ID: ' + str(user_ids[j]) row.append( InlineKeyboardButton(username2, callback_data='USER_ALIAS_%s' % str(user_ids[j]))) markup.append(row) markup = markup_append_pagination(bot, update, user_ids, markup, page, 'USER_ALIAS') markup.append([ InlineKeyboardButton('π ' + _('Skip'), callback_data='USER_ALIAS_%s' % str(0)) ]) reply_markup = InlineKeyboardMarkup(markup) text = 'π ' + _('Ok, is this user on Telegram?') if not first_message: msg = bot.edit_message_text(text, chat_id=chat_id, message_id=message.message_id, reply_markup=reply_markup, parse_mode='Markdown') elif len(user_ids) == 0: msg = bot.send_message(chat_id, _('No results')) else: msg = bot.send_message(chat_id, text, disable_notification=True, reply_markup=reply_markup, parse_mode='Markdown') chat_data[msg.message_id] = dict() chat_data[msg.message_id]['pages'] = page if message.reply_to_message: cldbid = chat_data['alias_cldbid'][str( message.reply_to_message.message_id)][1] del chat_data['alias_cldbid'][str(message.reply_to_message.message_id)] bot.delete_message(chat_id=chat_id, message_id=message.reply_to_message.message_id) chat_data['alias_cldbid'][str(msg.message_id)] = message.text, cldbid
def details_user_ts(bot, update, chat_data, cldbid): message = update.effective_message chat_id = message.chat_id user = get_user_ts_info(cldbid) user_clid = get_user_clid(user['client_unique_identifier']) markup = list() banid = check_user_banned(uid=user['client_unique_identifier']) text = ('π« ' + _('ID banned')) if banid else ('β ' + _('ID unbanned')) action = 'USER_BAN_ID_%s' % cldbid if not banid else 'USER_UNBAN_%s_%s' % ( cldbid, banid[0]) markup_banid = InlineKeyboardButton(text, callback_data=action) banid = check_user_banned(ip=user['client_lastip']) text = ('π« ' + _('IP banned')) if banid else ('β ' + _('IP unbanned')) action = 'USER_BAN_IP_%s' % cldbid if not banid else 'USER_UNBAN_%s_%s' % ( cldbid, banid[0]) markup_banip = InlineKeyboardButton(text, callback_data=action) markup.append([markup_banid, markup_banip]) banid = check_user_banned(name=user['client_nickname']) text = ('π« ' + _('Name banned')) if banid else ('β ' + _('Name unbanned')) action = 'USER_BAN_NAME_%s' % cldbid if not banid else 'USER_UNBAN_%s_%s' % ( cldbid, banid[0]) markup.append([InlineKeyboardButton(text, callback_data=action)]) if user_clid: channel_kick = InlineKeyboardButton(_('Channel kick'), callback_data='USER_KICK_%s_4' % cldbid) server_kick = InlineKeyboardButton(_('Server kick'), callback_data='USER_KICK_%s_5' % cldbid) markup.append([channel_kick, server_kick]) markup.append([ InlineKeyboardButton('πββοΈ ' + _('Assign alias'), callback_data='USER_ALIAS_PRE_%s' % cldbid), InlineKeyboardButton('π₯ ' + _('Groups'), callback_data='GROUP_BY_USER_%s' % cldbid) ]) markup.append( [InlineKeyboardButton('π ' + _('Back'), callback_data='USER_BACK')]) reply_markup = InlineKeyboardMarkup(markup) connected = ' πβπ¨' if user_clid else '' last_connection = datetime.fromtimestamp(int( user['client_lastconnected'])).strftime('%d/%m/%Y %H:%M:%S') last_connection_text = last_connection if connected == '' else _( 'ONLINE') + ' ' + _('since') + ' ' + last_connection alias = '\n*Alias:* ' + get_name(cldbid) if get_name( cldbid) is not None else '' text = 'π ' + _('*User details:*') + '\n' + '\n' + _('*Name:*') + ' ' + user['client_nickname'] + connected \ + alias \ + '\n' + _('*Last connection:*') + ' ' + last_connection_text \ + '\n' + _('*Last IP:*') + ' ' + user['client_lastip'] \ + '\n' + _('*Client DB identifier:*') + ' ' + str(cldbid) \ + '\n' + _('*Client Unique identifier:*') + ' ' + user['client_unique_identifier'] \ + '\n\n' + _('*Date creation:*') + ' ' + \ datetime.fromtimestamp(int(user['client_created'])).strftime('%d/%m/%Y %H:%M:%S') \ + '\n' + _('*Total connections:*') + ' ' + user['client_totalconnections'] bot.edit_message_text(text, chat_id=chat_id, message_id=message.message_id, reply_markup=reply_markup, parse_mode='Markdown')