def init(update,context): bot = context.bot connector = Connection() usr = str(update.message.reply_to_message.from_user.id) chat = str(update.message.chat_id) default_count = '1' msg_usr = update.message.reply_to_message.from_user usr_format = "@"+msg_usr.username or msg_usr.first_name query = Sql_Warn.SQL_Sel_Warn connector.cur.execute(query,(usr,chat)) row = connector.cur.fetchone() if row is None: save_warn = Connection() insert_warn = Sql_Warn.SQL_Ins_Warn save_warn.cur.execute(insert_warn,(usr,default_count,chat)) bot.send_message(update.message.chat_id,str_service.WARN_START .format(usr_format)) return True elif row[0] == MIN_WARN: Connection().cur.execute(Sql_Warn.SQL_Upd_Warn,(usr,chat)) bot.send_message(update.message.chat_id,str_service.WARN_1 .format(usr_format)) elif row[0] == '2': Connection().cur.execute(Sql_Warn.SQL_Upd_Warn,(usr,chat)) bot.send_message(update.message.chat_id,str_service.WARN_2 .format(usr_format)) elif row[0] == MAX_WARN: bot.send_message(update.message.chat_id,str_service.WARN_END .format(usr_format)) bot.kick_chat_member(update.message.chat_id,update.message.reply_to_message.from_user.id)
def init(update, context): try: bot = context.bot dbsel = Connection() chat = update.effective_chat.id usr = str(update.message.reply_to_message.from_user.id) msg_usr = update.message.reply_to_message.from_user usr_format = "@" + msg_usr.username or msg_usr.first_name usr_control = str(update.effective_user.id) query = Sql_reputation.SQL_Select dbsel.cur.execute(query, (usr, chat)) rows = dbsel.cur.fetchall() if rows: for score in rows: if score[1] == usr_control.id: bot.send_message(chat, "Non puoi toglierti il voto da solo!") elif score[1] != usr_control.id: dbup = Connection() sql = Sql_reputation.SQL_Update2 dbup.cur.execute(sql, (usr, chat)) message = '<a href="tg://user?id={userid}">{user}</a> ha rimossso il voto a {usr_vote} !'.format( userid=usr_control.id, user=update.effective_user.username or update.effective_user.first_name, usr_vote=usr_format) bot.send_message(chat, message, parse_mode='HTML') else: bot.send_message(chat, "L'utente non è abilitato alle votazioni!") except: bot.send_message( chat, "Questo comando si utilizza in risposta ad un utente!")
def init(update, context): bot = context.bot chat = update.effective_chat.id chat_title = update.message.chat.title for member in update.message.new_chat_members: if not member.is_bot: if member.username is not None: connector = Connection() usr_connector = Connection() u_id = str(member.id) u_username = str("@" + member.username) query = Sql_Welcome.SQL save_user = Sql_SaveUser.SQL connector.cur.execute(query, [chat]) usr_connector.cur.execute(save_user, [u_id, u_username]) row = connector.cur.fetchone() if row is not None: parsed_message = row[0].replace( '{first_name}', update.message.from_user.first_name).replace( '{chat_name}', update.message.chat.title).replace( '{username}', "@" + member.username) connector = Connection() db_query = Sql_Buttons.SQL_1 connector.cur.execute(db_query, [chat]) rows = connector.cur.fetchall() buttons = [] for link in rows: buttons.append( InlineKeyboardButton(text=link[1], url=link[2])) menu = utils.build_menu(buttons, 2) welcome_message = "{}".format(parsed_message) update.message.reply_text( welcome_message, reply_markup=InlineKeyboardMarkup(menu), parse_mode='HTML') else: bot.send_message( chat, str_service.DEFAULT_WELCOME.format(username="******" + member.username, chat=chat_title)) else: bot.send_message( chat, "{} set a username!\n You were kicked for safety!".format( update.message.from_user.id)) bot.kick_chat_member(chat, update.message.from_user.id, until_date=int(time.time() + 30)) else: bot.send_message(chat, str_service.BOT_WELCOME.format(chat_title))
def init(update, context): bot = context.bot u_id = str(update.message.from_user.id) connector = Connection() query = Sql_GDPR.SQL connector.cur.execute(query, [u_id]) bot.send_message(update.message.chat_id, text="You have been deleted from our database")
def init(update, context): message = update.message.text[8:].strip() connector = Connection() chatid = str(update.message.chat_id) query = Sql_Insert_BW.SQL connector.cur.execute(query, [message, chatid]) connector.db.commit() connector.cur.close() connector.db.close()
def receive_id(update, context): chatid = str(update.message.chat_id) connector = Connection() ids = update.effective_message.text.split(", ") for actual_id in ids: query = Sql_Buttons.SQL_2 connector.cur.execute(query,[actual_id,chatid]) update.effective_message.reply_text("Ho cancellato i bottoni!") return -1
def init(update, context): bot = context.bot connector = Connection() query = Sql_Help.SQL connector.cur.execute(query) row = connector.cur.fetchone() help_message = "{}\n\nRelease info: {source}".format(row[0], source=Config.SOURCE) bot.send_message(update.message.chat_id, help_message, parse_mode='HTML')
def init(update, context): bot = context.bot dbsel = Connection() chat = update.effective_chat.id usr = str(update.message.reply_to_message.from_user.id) msg_usr = update.message.reply_to_message.from_user usr_format = "@"+msg_usr.username or msg_usr.first_name query = Sql_reputation.SQL_Select dbsel.cur.execute(query,(usr,chat)) row = dbsel.cur.fetchone() if row is None: dbins = Connection() default_rep = '0' sql = Sql_reputation.SQL_Insert dbins.cur.execute(sql,(usr,chat,default_rep)) message = "{} Ora sei abilitato alle votazioni !".format(usr_format) bot.send_message(chat,message,parse_mode='HTML') else: bot.send_message(chat, "Questo utente è già abilitato alle votazioni!")
def init(update, context): bot = context.bot for member in update.message.new_chat_members: if member.username is not None: connector = Connection() chatid = str(update.message.chat_id) query = Sql_Welcome.SQL connector.cur.execute(query, [chatid]) row = connector.cur.fetchone() if row is not None: parsed_message = row[0].replace( '{first_name}', update.message.from_user.first_name).replace( '{chat_name}', update.message.chat.title).replace( '{username}', "@" + member.username) connector = Connection() db_query = Sql_Buttons.SQL_1 connector.cur.execute(db_query, [chatid]) rows = connector.cur.fetchall() buttons = [] for link in rows: buttons.append( InlineKeyboardButton(text=link[1], url=link[2])) menu = utils.build_menu(buttons, 2) welcome_message = "{}".format(parsed_message) update.message.reply_text( welcome_message, reply_markup=InlineKeyboardMarkup(menu), parse_mode='HTML') else: bot.send_message( update.message.chat_id, str_service.DEFAULT_WELCOME.format( username="******" + member.username, chat=update.message.chat.title)) else: bot.send_message( update.message.chat_id, "{} imposta un username!\nSei stato kickato per sicurezza!". format(update.message.from_user.id)) bot.kick_chat_member(update.message.chat_id, update.message.from_user.id)
def init(update, context): bot = context.bot connector = Connection() query = Sql_Joke.SQL connector.cur.execute(query) row = connector.cur.fetchone() if row is not None: bot.send_message(update.message.chat_id, text=row[1], parse_mode='HTML') row = connector.cur.fetchone() connector.cur.close() connector.db.close()
def init(update, context): bot = context.bot chatid = str(update.message.chat_id) connector = Connection() query = "SELECT language_set FROM language WHERE id_group = %s" connector.cur.execute(query,[chatid]) row = connector.cur.fetchone() print(row[0]) if row[0] == "IT": bot.send_message(update.message.chat_id, text= "ITALIANO") if row[0] == "EN": bot.send_message(update.message.chat_id, text="ENGLISH")
def init(update, context): connector = Connection() chatid = str(update.message.chat_id) query = Sql_Badword_Select.SQL connector.cur.execute(query, [chatid]) rows = connector.cur.fetchall() string = "" for link in rows: string += f"<code>{link[0]}:</code> <a href=\"{link[2]}\">{link[1]}</a>\n" message = "Ecco la lista delle parole proibite per questo gruppo:" update.effective_message.reply_html(message + "\n\nLista badwords:\n" + string)
def init(update, context): connector = Connection() chatid = str(update.effective_chat.id) usr = str(update.effective_user.id) sql = Sql_reputation.SQL_Select connector.cur.execute(sql,(usr,chatid)) row = connector.cur.fetchone() if row is not None: message = "{} il tuo <b>punteggio</b> nella chat {} è di <code>{}</code> punti!".format(update.effective_user.first_name,update.message.chat.title,row[3]) update.effective_message.reply_html(message) else: update.effective_message.reply_html("Non sei abilitato al voto!\nContatta un admin per l'abilitazione!")
def init(update, context): bot = context.bot chatid = str(update.message.chat_id) button_text = update.message.text[4:].strip() if button_text != "": x = button_text.split(',') connector = Connection() query = Sql_Add_Buttons.SQL connector.cur.execute(query,[x[0],x[1],chatid]) bot.send_message(update.message.chat_id,"Hai aggiunto un bottone al menu Welcome!") else: bot.send_message(update.message.chat_id,str_service.BUTTONS_INSERT,parse_mode='HTML')
def init(update, context): bot = context.bot chatid = str(update.message.chat_id) connector = Connection() query = Sql_Pin.SQL connector.cur.execute(query,[chatid]) row = connector.cur.fetchone() message_text = "{}".format(row[0]) bot.send_message(update.message.chat_id, text=message_text, parse_mode='HTML') bot.pin_chat_message(update.message.chat_id, update.message.message_id+1, disable_notification=True) connector.cur.close() connector.db.close()
def init(update, context): connector = Connection() chatid = str(update.message.chat_id) query = Sql_Welcome.SQL connector.cur.execute(query, [chatid]) row = connector.cur.fetchone() if row is not None: message = "<b>Ecco il welcome del tuo gruppo:</b>\n<code>{}</code>".format( row[0]) update.effective_message.reply_html(message) else: update.effective_message.reply_html( "Non hai impostato nessun Welcome per questo gruppo!")
def init(update, context): chatid = str(update.message.chat_id) connector = Connection() query = Sql_Buttons.SQL_1 connector.cur.execute(query,[chatid]) rows = connector.cur.fetchall() string = "" for link in rows: string += f"<code>{link[0]}:</code> <a href=\"{link[2]}\">{link[1]}</a>\n" message = "Ok, rispondi a questo messaggio con gli ID per i link(pulsanti) che vuoi eliminare. Nel formato " \ "<code>0,1,2</code>. Non scrivere nient'altro nel messaggio. Oppure usa /cancel" update.effective_message.reply_html(message + "\n\nLista bottoni:\n" + string) return RECEIVE_ID
def init(update, context): bot = context.bot connector = Connection() usr = str(update.message.reply_to_message.from_user.id) chat = str(update.message.chat_id) msg_usr = update.message.reply_to_message.from_user usr_format = "@" + msg_usr.username or msg_usr.first_name query = Sql_Warn.SQL_Del_Warn connector.cur.execute(query, (usr, chat)) bot.send_message(update.message.chat_id, text="Hai rimosso i warn di {}".format(usr_format)) bot.unban_chat_member(update.message.chat_id, update.message.reply_to_message.from_user.id)
def init(update, context): bot = context.bot connector = Connection() query = Sql_Buttons.SQL_1 connector.cur.execute(query) rows = connector.cur.fetchall() buttons = [] for link in rows: buttons.append(InlineKeyboardButton(text=link[1], url=link[2])) menu = utils.build_menu(buttons, 2) bot.send_message(update.message.chat_id, "Le Nostre Community su Telegram:", reply_markup=InlineKeyboardMarkup(menu))
def init(update, context): bot = context.bot message = update.message.text[10:] connector = Connection() chatid = str(update.message.chat_id) query = Sql_Pin.SQL_SET connector.cur.execute(query, [message, chatid]) connector.cur.close() connector.db.close() bot.send_message( update.message.chat_id, text="<b>Hai salvato il seguente pin per il tuo gruppo:</b>\n\n{}". format(message), parse_mode='HTML')
def init(update, context): bot = context.bot connector = Connection() ban_user = str(update.effective_user.id) query = Sql_Super_Ban.SQL connector.cur.execute(query, [ban_user]) rows = connector.cur.fetchall() if rows: bot.send_message( update.message.chat_id, text="<b>IL SUPERBAN HA BANNATO:</b> <code>{id}!</code>".format( id=update.message.from_user.id), parse_mode='HTML') bot.kick_chat_member(update.message.chat_id, update.message.from_user.id)
def init(update, context): bot = context.bot message = str(update.message.text[9:]).strip() if message != "": chatid = str(update.message.chat_id) connector = Connection() query = Sql_Insert_Rules.SQL connector.cur.execute(query, [message, chatid]) connector.db.commit() bot.send_message(update.message.chat_id, text="Hai creato il regolamento del gruppo", parse_mode='HTML') else: bot.send_message(update.message.chat_id, str_service.RULES_HELP, parse_mode='HTML')
def action(update, context): bot = context.bot connector = Connection() chatid = str(update.message.chat_id) query = Sql_Rules.SQL connector.cur.execute(query, [chatid]) row = connector.cur.fetchone() if row is not None: rules_message = "{}".format(row[0]) bot.send_message(update.message.chat_id, rules_message, parse_mode='HTML') else: bot.send_message(update.message.chat_id, str_service.RULES_MESSAGE, parse_mode='HTML')
def init(update, context): bot = context.bot try: connector = Connection() chatid = str(update.message.chat_id) bad_var = str(update.effective_message.text) query = Sql_Badword.SQL connector.cur.execute(query, [bad_var, chatid]) rows = connector.cur.fetchall() if rows: message = "{} hai utilizzato una parola proibita!\nLeggi le /regole".format( update.message.from_user.first_name) bot.delete_message(update.message.chat_id, update.message.message_id) bot.send_message(update.message.chat_id, message) except: print("questa chat non ha badword")
def init(update, context): bot = context.bot message = str(update.message.text[14:]) if message != "": chatid = str(update.message.chat_id) connector = Connection() query = Sql_Update_W.SQL connector.cur.execute(query, (message, chatid)) connector.db.commit() bot.send_message( update.message.chat_id, text="Hai aggiornato correttamente il messaggio di Benvenuto!", parse_mode='HTML') else: bot.send_message(update.message.chat_id, str_service.INSERT_W, parse_mode='HTML')
def customhandler(update, context): connector = Connection() chatid = str(update.message.chat_id) var_answer = str(update.message.text).lower() query = Sql_Custom_Handler.SQL connector.cur.execute(query, ([var_answer], [chatid])) row = connector.cur.fetchone() if row is not None: parsed_message = row[0].replace( '{first_name}', update.message.from_user.first_name).replace( '{chat_title}', update.message.chat.title).replace( '{username}', "@" + update.message.from_user.username) message = "{}".format(parsed_message) update.message.reply_text(text=message, parse_mode='HTML') row = connector.cur.fetchone() connector.cur.close() connector.db.close()
def init(update, context): bot = context.bot connector = Connection() chat = update.effective_chat.id ban_user = str(update.effective_user.id) query = Sql_Super_Ban.SQL connector.cur.execute(query, [ban_user]) rows = connector.cur.fetchall() if rows: bot.send_message( chat, text="<b>The superban has banned:</b> <code>{id}!</code>\n" "Open https://hersel.it/apinebula.php".format( id=update.message.from_user.id), parse_mode='HTML') bot.delete_message(chat, update.message.message_id) bot.kick_chat_member(chat, update.message.from_user.id)
def init(update, context): bot = context.bot message = str(update.message.text[11:]).strip() if message != "": chatid = str(update.message.chat_id) default_b = 0 connector = Connection() query = Sql_Insert_W.SQL connector.cur.execute(query, (chatid, message, default_b)) connector.db.commit() bot.send_message( update.message.chat_id, text="Hai inserito correttamente il messaggio di Benvenuto!", parse_mode='HTML') else: bot.send_message(update.message.chat_id, str_service.INSERT_W, parse_mode='HTML')
def init(update, context): bot = context.bot message = update.message.text[11:] connector = Connection() query = Sql_Insert_J.SQL_1 connector.cur.execute(query, [message]) row = connector.cur.fetchone() if row is None: query = Sql_Insert_J.SQL_2 connector.cur.execute(query,[message]) connector.db.commit() else: bot.send_message(update.message.chat_id, text="<b>Perfavore inserisci un'altra battuta questa esiste già!</b>", parse_mode='HTML') connector.cur.close() connector.db.close()
def init(update, context): bot = context.bot message = str(update.message.text[9:]) if message != "": save_user_id = update.message.reply_to_message.from_user.id save_date = datetime.strftime(datetime.today(), '%H:%M del %d/%m/%Y') connector = Connection() query = Sql_Superban.SQL connector.cur.execute(query, [save_user_id, message, save_date]) connector.db.commit() bot.send_message(update.message.chat_id, text="Hai SUPERBANNATO {id}".format( id=update.message.reply_to_message.from_user.id), parse_mode='HTML') else: bot.send_message(update.message.chat_id, str_service.MESSAGE_SB, parse_mode='HTML')