def manage_user(): if request.method == 'POST': first_name = request.form['signUp_firstName'] last_name = request.form['signUp_lastName'] or None username = request.form['signUp_username'] password = request.form['signUp_password'] # Validate values if first_name and username and password: hashed_password = generate_password_hash(password) db.create_user(first_name, last_name, username, hashed_password) return json.dumps({'html':'<span>All fields good !!</span>'}) else: return json.dumps({'html':'<span>Enter the required fields</span>'}) elif request.method == 'DELETE': # id = request.form['id'] username = request.form['username'] password = request.form['password'] # Secure enough? if username and password: user = db.find_user_by_username(username) if check_password_hash(user.password, password): print('Yepp they match') db.delete_user(username) return json.dumps({'deleted': 'ok'}) return json.dumps({'error': 'missing user or password'}), 400
def delete(): db.connect() username = request.form['username'] username = username.strip() db.delete_user(username) db.close() return render_template('deleteSuccessful.html', username=username)
def manage_user(): if request.method == 'POST': first_name = request.form['signUp_firstName'] last_name = request.form['signUp_lastName'] or None username = request.form['signUp_username'] password = request.form['signUp_password'] # Validate values if first_name and username and password: hashed_password = generate_password_hash(password) db.create_user(first_name, last_name, username, hashed_password) return json.dumps({'html': '<span>All fields good !!</span>'}) else: return json.dumps( {'html': '<span>Enter the required fields</span>'}) elif request.method == 'DELETE': # id = request.form['id'] username = request.form['username'] password = request.form['password'] # Secure enough? if username and password: user = db.find_user_by_username(username) if check_password_hash(user.password, password): print('Yepp they match') db.delete_user(username) return json.dumps({'deleted': 'ok'}) return json.dumps({'error': 'missing user or password'}), 400
def remove_users(): ## SQLite3 inactive_user database initialization inactive_user_table() # Open delete users worksheet sheet = access_spreadsheet() remove_sheet = sheet.get_worksheet(1) # Get number of rows (new user registrations) number_of_users = (remove_sheet.row_count - 1) print('Number of user(s) to remove: ' + str(number_of_users)) # Loop through new user registrations for x in range(number_of_users): remove_user = remove_sheet.row_values(2 + x) print('Delete user ' + str(x + 1) + ': ' + str(remove_user)) # Formatting user data email = remove_user[1] reason = remove_user[2] store = remove_user[3].split(',', 1)[0] # Delete user from user database delete_user(email, reason, store) # Send confirmation email for deleted user delete_email(email, store) # Loop through and delete user entries in sheet print('Deleting delete user entries from sheet...') for x in range(number_of_users): remove_sheet.delete_row((number_of_users + 1) - x)
def main_delete(): if not check_admin(): return redirect('/login') db.connect() username = request.form['username'] username = username.strip() db.delete_user(username) return render_template('deleteSuccessful.html', username=username)
def user(): if db.get_user('testadmin'): db.delete_user('testadmin') user = db.create_user( 'testadmin', '*****@*****.**', 'testadmin2020' ) yield user
def delete_dating_user(self, dating_users): for new_event in longpoll.listen(): if new_event.type == VkEventType.MESSAGE_NEW and new_event.to_me: if int(new_event.message) in dating_users: db.delete_user(new_event.message) return write_msg(self.user_id, DELETE_MESSAGE) elif int(new_event.message) == 0: return write_msg(self.user_id, RETURN_MESSAGE) else: write_msg(self.user_id, UNKNOWN_ID_MESSAGE)
def command_end(message): """ обработка команды /end удаление пользователя из бд """ user_id = message.chat.id logger.info( LOG_STR_USR_DO.format(user_id, '/reset_author', COMMANDS['reset_author'])) db.restart_useractive(user_id=user_id) db.delete_user(user_id=user_id) bot.send_message(user_id, 'Прощай, я буду скучать')
def moderate_reply(): if session["csrf_token"] != request.form["csrf_token"]: abort(403) reply_id = request.form["reply_id"] if request.form["delete"] == "3": db.delete_report(reply_id, "reply") if request.form["delete"] == "2": user_id = db.find_reply_author(reply_id) db.delete_user(user_id) if request.form["delete"] == "1": db.delete_reply(reply_id) return redirect("/reports")
def moderate_comment(): if session["csrf_token"] != request.form["csrf_token"]: abort(403) comment_id = request.form["comment_id"] if request.form["delete"] == "3": db.delete_report(comment_id, "comment") if request.form["delete"] == "2": user_id = db.find_comment_author(comment_id) db.delete_user(user_id) if request.form["delete"] == "1": db.delete_comment(comment_id) return redirect("/reports")
async def on_member_update(self, before, after): secure = client.get_channel(chan) for role_for_plex in roleid: role = after.guild.get_role(int(role_for_plex)) if (role in after.roles and role not in before.roles): await after.send( 'Welcome To ' + PLEX_SERVER_NAME + '. Just reply with your email so we can add you to Plex!') await after.send( 'I will wait 10 minutes for your message, if you do not send it by then I will cancel the command.' ) def check(m): return m.author == after and not m.guild try: email = await client.wait_for('message', timeout=600, check=check) except asyncio.TimeoutError: await after.send( 'Timed Out. Message Server Admin So They Can Add You Manually.' ) return else: await asyncio.sleep(5) await after.send( 'Got it we will be processing your email shortly') print(email.content) #make it go to a log channel plexname = str(email.content) if plexadd(plexname): if auto_remove_user: db.save_user(str(after.id), email.content) await asyncio.sleep(20) await after.send('You have Been Added To Plex!') await secure.send(plexname + ' ' + after.mention + ' was added to plex') else: await after.send( 'There was an error adding this email address. Message Server Admin.' ) return elif (role not in after.roles and role in before.roles): if auto_remove_user: try: user_id = after.id email = db.get_useremail(user_id) plexremove(email) deleted = db.delete_user(user_id) if deleted: print("Removed {} from db".format(email)) await secure.send(plexname + ' ' + after.mention + ' was removed from plex') else: print("Cannot remove this user from db.") except: print("Cannot remove this user from plex.") return
def send_picture_to_all(): logger.info("Sending today's picture to all users") json_resp = get_photo().json() users = db.get_all_users("sent = false") if users: for user in users: try: send_action(user['id'], json_resp) message_string = f"Hi! This is the image of today. Enjoy it!\n" \ f"**{json_resp['title']}**\n\n" \ f"{json_resp['explanation']}" if 'copyright' in json_resp: message_string += f"\n\n__© {json_resp['copyright']}__" bot.send_message(user['id'], message_string) except BadRequest: logger.error(f'Bad request sending picture to user @{user["username"]} ' f'({user["id"]}). Deleting the user.') db.delete_user(user['id']) db.change_sent(True)
def user(): if request.method=='POST': action=request.form['action'] if action=='DELETE': delete_user_form= DeleteUserForm() if delete_user_form.validate(): username=request.form['username'] if username=='admin' or username=='guest': flash("admin and guest accounts can't be deleted",'error') else: ok=db.delete_user(get_db(),username) if ok: flash('Deleted %s'%username,'ok') else: flash('Failed to delete %s'%username,'error') else: flash('delete form failed to validate','error') elif action=='CREATE': add_user_form = AddUserForm() # create from current form values if add_user_form.validate(): password=add_user_form.password.data password_hash=encrypt(password) ok=db.create_user(get_db(),add_user_form.name.data,add_user_form.email.data,password_hash) if ok: flash('New user %s created'%add_user_form.name.data,'ok') else: flash('Sorry, could not create user %s'%add_user_form.name.data,'error') # validation OK, but DB failed else: # posted a invalid form flash('Please fill in all fields','warning') elif action=="ADMIN": admin_form=UserAdminForm() db.set_user_admin(get_db(),admin_form.username.data,admin_form.admin.data) # By default reget the page, can't return a new render here as the existing form would pollute the creation values of the new forms return redirect('/users') else: # GET add_user_form = AddUserForm() userlist=db.get_users(get_db()) # Since get_users doesnt return a list of result, we have to convert the structure in order to insert the delete # user form into the list userlist2=[] for user in userlist: name=user['name'] isadmin=user['admin'] newrow=list(user)+[DeleteUserForm(username=name),UserAdminForm(username=name,admin=isadmin)] userlist2.append(newrow) return render_template('user.html', add_user_form=add_user_form, userlist=userlist2)
async def on_member_remove(self, member): if auto_remove_user: try: user_id = member.id ## not there email = db.get_useremail(user_id) plexremove(email) deleted = db.delete_user(user_id) if deleted: print("Removed {} from db".format(email)) else: print("Cannot remove this user from db.") except: print("Cannot remove this user from plex.")
async def on_member_remove(self, member): if auto_remove_user: try: user_id = member.id ## not there email = db.get_useremail(user_id) plexremove(email) deleted = db.delete_user(user_id) if deleted: print("Entfernt {} aus DB".format(email)) else: print("Kann User nicht aus DB entfernen.") except: print("Kann User nicht von **StreamNet** entfernen.")
def stats_delete(bot, user, call, *args): if len(args) != 1: return # Keine doppelte Bestätigung, nur ein Argument clear_username = args[0].replace("@", "").lower() if clear_username != user.get_name(): return # Check if delete process already running for requested user for run_process in running_time_processes: if isinstance(run_process, StatsDeleteProcess): if run_process.user.get_name() == clear_username: if call == "confirm": db.delete_user(user) bot.send_message( f"{user.name}, deine Statistik wurde gelöscht. Vielen Dank fürs dabei sein." ) return if call == "delete": return if call == "confirm": return delete_process = StatsDeleteProcess(bot, user) running_time_processes.append(delete_process) bot.send_message( f"{user.name}, bist du sicher, dass du deine Statistiken löschen möchtest? " f"Wenn ja, gib den Befehl: <!confirm @username> innerhalb von {DELETEANSWERTIME} ein." )
async def on_member_remove(self, member): if auto_remove_user: try: user_id = member.id ## not there email = db.get_useremail(user_id) plexremove(email) deleted = db.delete_user(user_id) if deleted: print("Removed {} from db".format(email)) secure = client.get_channel(chan) await secure.send(email + ' ' + member.mention + 'was removed from plex because they left the server') else: print("Cannot remove this user from db.") except: print("Cannot remove this user from plex.")
def delete_account(): try: print() print("Are you sure u want to delete your account?") print("1. Yes \n2. No ") print() selection = int(input("Select an option: ")) if (selection == 1): deleted = db.delete_user(current_user["email"]) if deleted: print("Hope to see you again soon") else: operations() except: print("Something went wrong")
def echo(): user_id = request.json['session']['user_id'] end = False if request.json['session']['new'] and not db.get_state(user_id): response = { 'version': request.json['version'], 'session': request.json['session'], 'response': { 'text': 'Привет! Как тебя зовут?' } } db.set_state(user_id, 0) else: state = db.get_state(user_id) inp = request.json['request']['original_utterance'] if inp.lower() in ('удалить', 'убрать'): if not db.delete_user(user_id): text = 'О вас еще нет информации' else: text = 'Удалена вся информация о вас! :)\n Можете снова её добавить. Как вас зовут?' db.set_state(user_id, 0) elif inp.lower() in ('мои данные', 'данные'): name = db.get_user(user_id).name city = db.get_user(user_id).city text = f'Твое имя: {name}\nТвой город: {city}' elif state == 0: db.set_name(user_id, inp) db.set_state(user_id, 1) text = 'Круто! А откуда ты?' elif state == 1: db.set_city(user_id, inp) db.set_state(user_id, 2) text = 'Хороший город! Ладно, я все записал' end = True else: text = 'Я уже все записал' response = { 'version': request.json['version'], 'session': request.json['session'], 'response': { 'text': text, 'end_session': end } } return response
async def on_member_update(self, before, after): secure = client.get_channel(chan) for role_for_plex in roleid: role = after.guild.get_role(int(role_for_plex)) if (role in after.roles and role not in before.roles): await after.send("Welcome to Neptune! 🔱 Reply to this message with the email linked to your Plex account and I'll send you an invite.") await after.send("If I don't hear from you in 10 minutes, I'll cancel this request.") def check(m): return m.author == after and not m.guild try: email = await client.wait_for('message', timeout=600, check=check) except asyncio.TimeoutError: await after.send("Time's up! ⏰ Contact the admin to have them add you manually.") return else: await asyncio.sleep(5) await after.send("Thanks! You'll get an email with your invitation soon. 💌") print(email.content) #make it go to a log channel plexname = str(email.content) if plexadd(plexname): if auto_remove_user: db.save_user(str(after.id), email.content) await asyncio.sleep(20) await after.send("You're in! 🎉 Enjoy your time with Neptune and let us know if you have any questions.") await secure.send(plexname + ' ' + after.mention + ' was added to plex') else: await after.send('There was an error adding this email address. Message the admin for help.') return elif(role not in after.roles and role in before.roles): if auto_remove_user: try: user_id = after.id email = db.get_useremail(user_id) plexremove(email) deleted = db.delete_user(user_id) if deleted: print("Removed {} from db".format(email)) await secure.send(plexname + ' ' + after.mention + ' was removed from plex') else: print("Cannot remove this user from db.") except: print("Cannot remove this user from plex.") return
def delete_user(): username = input('Enter username to delete> ') if not db.get_single_user(username): return confirm_string = f'Are you sure you want to delete {username} (yes/no)? ' print() confirm = input(confirm_string).lower() while confirm != 'yes'.lower() and confirm != 'no'.lower(): print() print('Please type yes or no') confirm = input(confirm_string).lower() if confirm == 'no': return if db.delete_user(username): print() print('Deleted.')
def delete_check_user(CHECK_USER): username = CHECK_USER[0] if db.get_user(username): db.delete_user(username)
def manage_users(self): self.client_socket.send( ('Welcome to User Management').encode() ) conn = sqlite3.connect('interview.db') while(True): option = self.client_socket.recv(1024).decode() if (option == '1'): users = str(db.retrieve_user_all(conn)) self.client_socket.send((users).encode()) check_user = self.client_socket.recv(1024).decode() print("check user" + check_user) user_id = '' user_conf= '' try: user_id = db.retrieve_user_by_name(conn, check_user) user_conf = check_user self.client_socket.send( (user_conf).encode() ) except TypeError: user_conf = 'User does not exist' self.client_socket.send( (user_conf).encode() ) break #self.client_socket.send( (user_conf).encode() ) new_auth = self.client_socket.recv(1024).decode() if (new_auth == 'Invalid Authorization Level'): print(new_auth) break print('Assigning new Authorization Level') db.update_user_auth(conn, user_id, new_auth) conf = ('User ' + check_user + ' has been reassigned an Authorization level') self.client_socket.send( (conf).encode() ) break elif (option == '2'): users = str(db.retrieve_user_all(conn)) self.client_socket.send((users).encode()) check_user = self.client_socket.recv(1024).decode() user_id = '' user_conf= '' try: user_id = str(db.retrieve_user_by_name(conn, check_user)) user_conf = check_user self.client_socket.send( (user_conf).encode() ) except TypeError: user_conf = 'User does not exist' self.client_socket.send( (user_conf).encode() ) break second_conf = self.client_socket.recv(1024).decode() response = '' if (second_conf.upper() == 'Y'): db.delete_user(conn, user_id) response = ('user ' + check_user + ' has been deleted') else: response = ('Operation has been cancelled') self.client_socket.send( (response).encode() ) break else: break print('Exiting User Management') return
async def on_member_update(self, before, after): secure = client.get_channel(chan) for role_for_plex in roleid: role = after.guild.get_role(int(role_for_plex)) if (role in after.roles and role not in before.roles): await after.send('**Willkommen** bei **' + PLEX_SERVER_NAME + '**.') await after.send( 'Antworte einfach mit deiner **PLEX Mail**, damit ich dich bei **StreamNet** hinzufügen kann!' ) await after.send( 'Ich werde 10 Minuten auf deine Nachricht warten. Wenn du bis dahin nicht geantwortet hast, werde ich den Befehl abbrechen.' ) def check(m): return m.author == after and not m.guild try: email = await client.wait_for('message', timeout=600, check=check) except asyncio.TimeoutError: await after.send( 'Zeitüberschreitung. Wende dich an den Server Admin damit der dich manuell hinzufügen kann.' ) return else: await asyncio.sleep(5) await after.send( '**GOTCHA**, wir werden deine Email in kürze bearbeiten.' ) print(email.content) #make it go to a log channel plexname = str(email.content) if plexadd(plexname): if auto_remove_user: db.save_user(str(after.id), email.content) await asyncio.sleep(20) await after.send( 'Du wurdest bei **StreamNet** hinzugefügt!') await secure.send( plexname + ' ' + after.mention + ' wurde bei **StreamNet** hinzugefügt') else: await after.send( 'Es gab ein Fehler beim Hinzufügen deiner Email. Bitte kontaktiere den Server Admin.' ) return elif (role not in after.roles and role in before.roles): if auto_remove_user: try: user_id = after.id email = db.get_useremail(user_id) plexremove(email) deleted = db.delete_user(user_id) if deleted: print("Entfernt {} aus DB".format(email)) await secure.send( plexname + ' ' + after.mention + ' wurde von **StreamNet** entfernt') else: print( "Konnte diesen User nicht aus der DB entfernen." ) except: print( "Konnte diesen User nicht von **StreamNet** entfernen." ) return
def delete_user(userid): db.delete_user(userid) return redirect('/list')
def delete_user(user_id: int): db.delete_user(user_id) return {"user_id":user_id,"status":"Deleted"}
elif update_choice == 'last_name': db.update_data_last_name(update_value, username1) print('data updated') elif update_choice == 'age': db.update_data_age(update_value, username1) print('data updated') elif update_choice == 'email': db.update_data_email(update_value, username1) print('data updated') elif update_choice == 'country': db.update_data_country(update_value, username1) print('data updated') # Show user data elif exists_choice == 'show': db.show_user(username1) # Delete user data elif exists_choice == 'delete': delete_user = pyip.inputYesNo(prompt='Are you sure?(yes/no): \n') if delete_user == 'yes': db.delete_user(username1) print('User deleted.') else: print('Uff, so close!') print('\nThank you, have a good day!') # Mostrar usuarios base de datos # db.show_all_users()
async def on_message(self, message): secure = client.get_channel(chan) if message.author.id == self.user.id: return if message.author.guild_permissions.administrator: if message.content.startswith('-plex add'): mgs = message.content.replace('-plex add ','') if plexadd(mgs): await secure.send('The email has been added! {0.author.mention}'.format(message)) else: await secure.send('Error Check Logs! {0.author.mention}'.format(message)) if message.content.startswith('-plex rm'): mgs = message.content.replace('-plex rm ','') if plexremove(mgs): await secure.send('The email has been removed! {0.author.mention}'.format(message)) else: await secure.send('Error Check Logs! {0.author.mention}'.format(message)) if message.author.guild_permissions.administrator: if message.content.startswith('-db add'): mgs = message.content.replace('-db add ','') try: mgs = mgs.split(' ') email = mgs[0] if(plexadd(email)): await message.channel.send('User has been added to plex.') else: await message.channel.send('Error adding email to plex. Ignore this if the email already exist in plex.') bad_chars = ['<','>','@','!'] user_id = mgs[1] for i in bad_chars: user_id = user_id.replace(i, '') db.save_user(user_id, email) await message.channel.send(email + ' ' + mgs[1] + ' was added to the database.') except: await message.channel.send('Cannot add this user to db.') print("Cannot add this user to db.") #await message.delete() if message.author.guild_permissions.administrator: if message.content.startswith('-db ls') or message.content.startswith('-db rm'): embed = discord.Embed(title='Invitarr Database.') all = db.read_useremail() table = texttable.Texttable() table.set_cols_dtype(["t", "t", "t"]) table.set_cols_align(["c", "c", "c"]) header = ("#", "Name", "Email") table.add_row(header) for index, peoples in enumerate(all): index = index + 1 id = int(peoples[1]) dbuser = client.get_user(id) dbemail = peoples[2] try: username = dbuser.name except: username = "******" embed.add_field(name=f"**{index}. {username}**", value=dbemail+'\n', inline=False) table.add_row((index, username, dbemail)) if message.content.startswith('-db ls'): total = str(len(all)) if(len(all)>25): f = open("db.txt", "w") f.write(table.draw()) f.close() await message.channel.send("Database too large! Total: {total}".format(total = total),file=discord.File('db.txt')) else: await message.channel.send(embed = embed) else: try: position = message.content.replace("-db rm", "") position = int(position) - 1 id = all[position][1] email = db.get_useremail(id) deleted = db.delete_user(id) if deleted: print("Removed {} from db".format(email)) await secure.send("Removed {} from db".format(email)) else: print("Cannot remove this user from db.") except Exception as e: print(e) if message.content.startswith('-help'): embed = discord.Embed(title='Invitarr Bot Commands', description='Made by [Sleepingpirates](https://github.com/Sleepingpirates/Invitarr), [Join Discord Server](https://discord.gg/vcxCytN)') embed.add_field(name='-plex add <email>', value='This command is used to add an email to plex', inline=False) embed.add_field(name='-plex rm <email>', value='This command is used to remove an email from plex', inline=False) embed.add_field(name='-db ls', value='This command is used list Invitarrs database', inline=False) embed.add_field(name='-db add <email> <@user>', value='This command is used to add exsisting users email and discord id to the DB. Bot tries to add email to plex', inline=False) embed.add_field(name='-db rm <position>', value='This command is used remove a record from the Db. Use -db ls to determine record position. ex: -db rm 1', inline=False) await message.channel.send(embed = embed)
def delete_user(user_id): try: db.delete_user(user_id) except: pass
def deleteUser(): if request.method=='POST': print("Delete route") value=request.form['user_id'] db.delete_user(value) return redirect('adminUsers')
def test_delete_user(user): assert db.delete_user(user.username) == True
def stop(update, context): context.bot.send_message(chat_id=update.effective_chat.id, text="You will no longer recieve notifications.") for user in user_list: if str(user[0]) == str(update.effective_chat.id): user_list.remove(user) delete_user(update.effective_chat.id)