def login():
try:
if request.method == "POST":
db = database()
username = request.form['username']
data = db.read(
'''SELECT Username,password,AuthKey,GUID,B3ID,level FROM users WHERE username = (?)''',
username)
if len(data) == 0:
data = db.read(
'''SELECT Username,password,AuthKey,GUID,B3ID,level FROM users WHERE username = (?)''',
username)
db.close()
if len(data) == 1 and sha256_crypt.verify(request.form['password'],
data[0][1]):
session['logged_in'] = True
session['username'] = data[0][0]
session['authkey'] = data[0][2]
session['guid'] = data[0][3]
session['b3id'] = data[0][4]
session['level'] = data[0][5]
flash('You Have Successfully Logged in !')
return redirect(request.referrer)
else:
flash('Invalid credentials. Try Again.')
return redirect(request.referrer)
except Exception as e:
return redirect(request.referrer)
def requestsongs():
try:
if request.method == "POST":
name = request.form['name']
email = request.form['email']
songname = request.form['songname']
artists = request.form['artists']
starttime = int(request.form['starttime'])
url = "https://www.youtube.com/embed/{}?start={}&end={}".format(
request.form['videoid'], starttime, starttime + 10)
db = database()
x = db.read("SELECT * FROM KMusic WHERE Name LIKE (?)", name)
if len(x) > 0:
flash('Song is Already in the Request List')
return render_template("requestsongs.html")
db.write(
'''INSERT INTO KMusic(Name,Email,Song,Artist,URL) VALUES(?,?,?,?,?)''',
name, email, songname, artists, url)
db.close()
flash('Your Request is Send to Admins')
return render_template("cod4/requestsongs.html")
except:
flash('There was Error while sending the request')
return render_template("cod4/requestsongs.html")
def register():
try:
if request.method == "POST":
db = database()
displayname = request.form['displayname']
username = request.form['username']
password = sha256_crypt.encrypt(str(request.form['password']))
email = request.form['email']
AuthKey = ''.join(
random.choice(string.ascii_uppercase + string.digits)
for _ in range(8))
x = db.read("SELECT * FROM users WHERE Username = (?)", username)
y = db.read("SELECT * FROM users WHERE Email = (?)", email)
if len(x) > 0:
flash('Username Already in Use')
return redirect(request.referrer)
if len(y) > 0:
flash('Your Email is already Registered')
return redirect(request.referrer)
db.write(
'''INSERT INTO users(Name,Username,Password,Email,AuthKey) VALUES(?,?,?,?,?)''',
displayname, username, password, email, AuthKey)
db.close()
flash('You Have Successfully Registered !')
return redirect(request.referrer)
except Exception as e:
return render_template("home.html")
def submitss():
try:
if request.method == "POST" and request.form[
'secretkey'] == 'WK3vKwJs4ZDCV5HrthRnOGreY12mEYwS2ljpm0AI':
db = database()
try:
id = int(db.read('''SELECT ID FROM ScreenShots''')[-1][0]) + 1
except:
id = 1
name = request.form['name'][:-2]
b3id = int(request.form['b3id'])
connections = int(request.form['connections'])
aliases = request.form['aliases']
guid = request.form['guid']
penalties = int(request.form['penalties'])
ip = request.form['ip']
score = request.form['score']
try:
with urllib.request.urlopen(
"https://ipinfo.io/{}/json".format(ip)) as url:
data = json.loads(url.read().decode())
address = '{}, {}'.format(data['city'], data['country'])
except:
address = 'Not Found'
f = request.files['ss']
f.save('static/screenshots/{}.jpg'.format(id))
query = '''INSERT INTO ScreenShots (Name,B3ID,Connections,Aliases,GUID,Address,IP,Penalties,Score) VALUES ('{}',{},{},'{}','{}','{}','{}',{},{})'''.format(
name, b3id, connections, aliases, guid, address, ip, penalties,
score)
db.write(query)
db.close()
return jsonify('Got IT')
except Exception as e:
print(e, file=open('/home/ba_error.log', 'a'))
return jsonify('Something Went Wrong')
def __init__(self):
self.db_equipment = database('equipment')
handlers = [(r"/", IndexHandler), (r"/issuedManager", IssuedManager),
(r"/getEquipment", CreateEquipment),
(r"/getSpecificEquipmentIssueEquipment",
SpecificEquipmentIssueEquipment),
(r"/isseuEquipment", IssueEquipment)]
tornado.web.Application.__init__(self, handlers)
def post(self):
data = request.get_json(force=True)
if(data['password']=="123456"and data['username']=="BBT"):
return database().query()
else:
return jsonify({
"errcode":400,
"errmsg":"用户名或密码错误"
})
def __init__(self, cnx=None, host='catalogservice.cbufftirwvx9.us-east-2.rds.amazonaws.com', db='CatalogService',
user=None, password=None, key_columns = None, notIncludedCols = None):
self.cnx = cnx
if not cnx:
db = database(host=host, db=db, user=user, password=password)
self.cnx = db.cnx
self.key_columns, self.notIncludedCols = key_columns, notIncludedCols
if not key_columns: self.key_columns = ['name', 'byline', 'categories', 'experience']
if not notIncludedCols: self.notIncludedCols = ['fields', 'limit', 'offset']
def post(self):
time = checkTime()
if not time['errcode']:
data = request.get_json(force=True)
check = database().isRecruit(data['tele'])
if check['errcode'] == 401:
result = checkInfo(data['name'], data['gender'], data['grade'],
data['college'], data['campus'],
data['tele'], data['time'])
if result['errcode'] == 0:
#时间数组转字符串
data['time'] = ','.join(data['time'])
return database().updateUser(data)
else:
return result
else:
return check
else:
return time
def ssview():
try:
db = database()
data = db.read(
'''SELECT ID,Name,B3ID,GUID,Score FROM ScreenShots WHERE Banned IS NULL ORDER BY ID DESC'''
)
db.close()
return render_template("cod4/ssviewer.html", data=data)
except:
flash('Something Went Wrong')
return render_template("cod4/ssviewer.html")
def banned():
try:
db = database()
data = db.read(
'''SELECT * FROM ScreenShots WHERE Banned IS NOT NULL ORDER BY ID DESC'''
)
db.close()
return render_template("cod4/banlist.html", data=data, fullwidth=True)
except:
flash('Something Went Wrong')
return render_template("cod4/banlist.html")
def homepage():
try:
db = database()
data = db.read(
'''SELECT ID,Name FROM ScreenShots WHERE Banned IS NULL ORDER BY ID DESC'''
)[:100]
db.close()
shuffle(data)
return render_template("home.html", fullwidth=True, ss=data[:6])
except:
return render_template("home.html", fullwidth=True)
def __init__(self):
db = database()
db.select(["title", "content", "is_test"])
# db.where("is_test = false")
db.table("eng_texts_tab")
all_datas = db.get_result()
tot_num_words = 0
for data in all_datas:
all_data.append(data[0])
all_data.append(data[1])
titles.append(data[0])
contents.append(data[1])
tot_num_words += len(data[0])
tot_num_words += len(data[1])
def get_word_index(self):
db = database()
db.select(["pre_title", "pre_content", "is_test"])
db.table("eng_texts_tab")
datas = db.get_result()
token_data = []
for data in datas:
token_data.append(self.listToString(data[0]))
token_data.append(self.listToString(data[1]))
tokenizer = Tokenizer(num_words=MAX_NUM_WORDS)
tokenizer.fit_on_texts(token_data)
list_tokenized = tokenizer.texts_to_sequences(token_data)
# tokenized_datas = pad_sequences(list_tokenized, maxlen=MAX_SEQUENCE_LENGTH)
word_index = tokenizer.word_index
return word_index
def submitss():
try:
if request.method == "POST" and request.form[
'secretkey'] == 'WK3vKwJs4ZDCV5HrthRnOGreY12mEYwS2ljpm0AI':
db = database()
b3id = int(request.form['b3id'])
guid = request.form['guid']
level = int(request.form['level'])
authkey = request.form['authkey']
db.write(
'''UPDATE users SET b3id = (?), guid = (?) ,level = (?), authkey = (?) WHERE authkey = (?)''',
b3id, guid, level, None, authkey)
db.close()
return render_template("home.html")
except Exception as e:
return render_template("home.html")
def imageview():
try:
db = database()
data = db.read('''SELECT * FROM ScreenShots WHERE ID = (?)''',
request.args.get('ssid'))
db.close()
metadata = [
'screenshots/{}'.format(data[0][0]),
'Screenshot of {} (@{})'.format(data[0][1], data[0][2]),
'ss/view/?ssid={}'.format(data[0][0])
]
return render_template("cod4/imageview.html",
data=data,
metadata=metadata)
except:
flash('Something Went Wrong :/')
return redirect(request.referrer)
def banplayer():
try:
db = database()
id = str(
db.read('''SELECT B3ID from ScreenShots where ID = (?)''',
str(int(request.args.get('ssid'))))[0][0])
m = MultipartEncoder(
fields={
"b3id":
str(session['b3id']),
"cmd":
'ban',
"args":
'@' + id,
"args2":
'^3WallHacker^0|^1Proof- blackassassins.tk/ss/view/?ssid=' +
str(int(request.args.get('ssid'))),
"secretkey":
'WK3vKwJs4ZDCV5HrthRnOGreY12mEYwS2ljpm0AI'
})
r = str(
requests.post('http://188.166.187.32:5001/wufcw66i5aetl2w1f1zp24',
data=m,
headers={
'Content-Type': m.content_type
}).text)
if 'true' in str(r):
data = db.write(
'''UPDATE ScreenShots SET banned = (?) WHERE ID = (?)''',
session['username'], str(int(request.args.get('ssid'))))
flash('Player Was Successfully Banned')
else:
flash(
'There was a error while banning the player, Try Again in Bit !'
)
flash('Make Sure You are Connected to Server Before Banning Again')
db.close()
return redirect(request.referrer)
except:
flash('Something Went Wrong')
return redirect(request.referrer)
def reportadmin():
try:
db = database()
emails = db.read('''SELECT Email from users where Level >= 64''')
emaillist = []
for email in emails:
emaillist.append(email[0])
data = request.args.get('data')
adminid = request.args.get('adminid')
reason = str(request.args.get('reason'))
if len(data) != int(adminid) + 20:
flash('Something Went Wrong :(')
return redirect(request.referrer)
data = data.split(';;;')
try:
msg = Message("{} Made a Ban appeal".format(data[2]),
sender="*****@*****.**",
recipients=emaillist)
msg.body = '''Ban appeal by {}\n
{} Think Following Penalty is unfair becouse {} \n
Penalty ID :- {} \nPenalty Type :- {} \nPlayer Name :- {} \n
Reason for Penalty :- {} \n
Admin Name :- {} \n
Expire Time :- {}'''.format(data[2], data[2], reason,
data[0], data[1], data[2],
data[3], data[4], data[5])
msg.html = render_template('/emails/report_admin.html',
data=data,
reason=reason)
mail.send(msg)
flash('Your Appeal was successfully send to Responsible Persons')
except:
flash(
'There was errro while making the Appeal, Try Again later :(')
return redirect(request.referrer)
except:
flash(str(e))
flash('There was errro while making the Appeal, Try Again later :(')
return redirect(request.referrer)
def post(self):
data = request.get_json(force=True)
return database().isRecruit(data['tele'])
def post(self):
data = request.get_json(force=True)
return database().showCollege(data['campus'])
#!/usr/bin/python # -*- coding: utf-8 -*- from bottle import run import json from database.database import DataBaseManager as database import sys import os os.environ['NLS_LANG'] = 'AMERICAN_AMERICA.UTF8' """ App.__init__.py: Script principal do Aplicativo, controla o servidor e a conexção com o banco. A variavel db é global e é importada onde a conexão com o banco é necessaria. """ #Cria o objeto de conexão com o banco de dados. db = database() # Importa os controladores. import controller as __name__ #Função responsavel pelo inico do servidor. def runserver(host, port): run(host=host, port=port)
from database.database import database
from nltk.corpus import stopwords
from nltk.tokenize import word_tokenize
from nltk.stem import WordNetLemmatizer
from snowballstemmer import stemmer
import json
import psycopg2 as psycopg2
from jpype import JClass, JString, getDefaultJVMPath, shutdownJVM, startJVM, java
ZEMBEREK_PATH = r'C:\Users\casper\PycharmProjects\title_generate\zemberek-full.jar'
startJVM(getDefaultJVMPath(),
'-ea',
f'-Djava.class.path={ZEMBEREK_PATH}',
convertStrings=False)
db = database()
stopWords = set(stopwords.words('turkish'))
lemmatizer = WordNetLemmatizer()
stemmer = stemmer('turkish')
class preprocessing:
def __init__(self):
self.preprocess()
def preprocess(self):
sql = """ UPDATE texts_tab
SET pre_title = %s, pre_content = %s
WHERE id = %s"""
conn = None
import os
import sys
import jwt
import requests
from flask import Flask, Response
from flask import request
from flask import render_template
from database.database import database
from database.tutors import tutorsDatabase
from database.catalog import catalogDatabase
from database.categories import categoriesDatabase
from database.bookings import bookingsDatabase
db = database(host='catalogservice.cbufftirwvx9.us-east-2.rds.amazonaws.com',
db='CatalogService',
user=None,
password=None)
cnx = db.cnx
tutorD = tutorsDatabase(cnx)
catalogD = catalogDatabase(cnx)
categoriesD = categoriesDatabase(cnx)
bookingsD = bookingsDatabase(cnx)
cwd = os.getcwd()
sys.path.append(cwd)
application = Flask('CatalogService')
def response400(e):
return Response('Error: {}'.format(str(e)), status=400)