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)
