async def randomimgin(self, ctx, room_name): functions.log(ctx.guild.name, ctx.author, ctx.command) room = functions.get_room_json(room_name) if room: embed = discord.Embed( colour=discord.Colour.orange(), description= f"<a:spinning:804022054822346823> Loading >10,000 pictures taken in `^{room['Name']}`, and picking one randomly..." ) functions.embed_footer(ctx, embed) loading = await ctx.send(embed=embed) room_photos = functions.get_photos_in_room(room_name) if room_photos: random_photo = room_photos[random.randint( 0, len(room_photos) - 1)] embed = functions.image_embed(random_photo) else: embed = functions.error_msg( ctx, f"Not a single picture has been taken in `^{room['Name']}`" ) else: embed = functions.error_msg(ctx, f"Room `^{room_name}` doesn't exist!") await loading.delete() functions.embed_footer(ctx, embed) # get default footer from function await ctx.send(f"Random image in `^{room['Name']}`", embed=embed)
async def clear_error(self, ctx, error): if isinstance(error, commands.MissingRequiredArgument): embed = functions.error_msg(ctx, "Please include in an username!") await ctx.send(embed=embed) else: pass
async def clear_error(self, ctx, error): if isinstance(error, commands.MissingRequiredArgument): embed = functions.error_msg( ctx, "Please include in an username and room!\nUsage: `.randomimgofin <user> <room>`" ) await ctx.send(embed=embed) else: pass
async def randomimgofin(self, ctx, profile, room_name): functions.log(ctx.guild.name, ctx.author, ctx.command) account = functions.check_account_existence_and_return(profile) if account: profile = account['username'] room = functions.get_room_json(room_name) if room: photos = functions.id_to_feed(account['account_id']) if photos: found_photos = [] # find photos in room for photo in photos: if photo['RoomId'] == room['RoomId']: found_photos.append(photo) if found_photos: random_photos = found_photos[random.randint( 0, len(found_photos) - 1)] embed = functions.image_embed(random_photos) else: embed = functions.error_msg( ctx, f"User `@{account['username']}` doesn't appear in `^{room['Name']}`!" ) else: embed = functions.error_msg( ctx, f"User `@{profile}` doesn't appear in `^{room_name}` at all!" ) else: embed = functions.error_msg( ctx, f"Room `^{room_name}` doesn't exist!") else: embed = functions.error_msg(ctx, f"User `@{profile}` doesn't exist!") functions.embed_footer(ctx, embed) # get default footer from function await ctx.send(f"Random image of `@{profile}`, in `^{room['Name']}`", embed=embed)
async def randomimgof(self, ctx, profile): functions.log(ctx.guild.name, ctx.author, ctx.command) account = functions.check_account_existence_and_return(profile) if account: profile = account['username'] feed = functions.id_to_feed(account['account_id']) if feed: random_feed = feed[random.randint(0, len(feed) - 1)] embed = functions.image_embed(random_feed) else: embed = functions.error_msg( ctx, f"User `@{profile}` doesn't appear in any post!") else: embed = functions.error_msg(ctx, f"User `@{profile}` doesn't exist!") functions.embed_footer(ctx, embed) # get default footer from function await ctx.send(f"Random image of `@{profile}`", embed=embed)
async def randomimgby(self, ctx, profile): functions.log(ctx.guild.name, ctx.author, ctx.command) account = functions.check_account_existence_and_return(profile) if account: profile = account['username'] photos = functions.id_to_photos(account['account_id']) if photos: random_photos = photos[random.randint(0, len(photos) - 1)] embed = functions.image_embed(random_photos) else: embed = functions.error_msg( ctx, f"User `@{account['username']}` hasn't shared a single post!" ) else: embed = functions.error_msg(ctx, f"User `@{profile}` doesn't exist!") functions.embed_footer(ctx, embed) # get default footer from function await ctx.send(f"Random image by `@{profile}`", embed=embed)
async def eventsearch(self, ctx, word): functions.log(ctx.guild.name, ctx.author, ctx.command) keyword = str(word) if len(keyword) < 2: embed = functions.error_msg( ctx, "Keyword must be at least 2 characters long!") await ctx.send(embed=embed) else: events_found = functions.event_search(keyword) embed = discord.Embed( colour=discord.Colour.orange(), title=f"Events found with keyword \"{keyword}\"", ) events = 0 if events_found: for event in events_found: if (functions.contains_word(event['Name'], keyword) or functions.contains_word(event['Description'], keyword)): description = event['Description'] if not description: description = "None" events += 1 embed.add_field( name=event['Name'], value= f"**[\"{event['Name']}\"](https://rec.net/event/{event['PlayerEventId']})** | [`{functions.id_to_display_name(event['CreatorPlayerId'])}`](https://rec.net/user/{functions.id_to_username(event['CreatorPlayerId'])})```{description}```👥 Attending: `{event['AttendeeCount']}`\n\n~~~~~~~~~~", inline=False) if not events: embed.add_field( name="None!", value= f"Couldn't find any event that contains the word `{keyword}`", inline=False) functions.embed_footer(ctx, embed) # get default footer from function await ctx.send(embed=embed)
def Reload(DATE, INDEX_ID, CALENDAR_ID): #Getting Required requests QUE = "select * from d_dailydatareq where INDEX_ID = {0}" Q = QUE.format(INDEX_ID) con = ms.connect("127.0.0.1", "root", "123456789+", "epic_trust_vvr") Meas = pd.read_sql(Q, con=con) con.close() Meas = Meas.drop(columns={"SLNO", "VALID_FLAG"}) # Dropping serial Number #Seperating Request Types CA_REQ = Meas[Meas["FIELD"] == 'CA'] PRICE_REQ = Meas[Meas["FIELD"] == 'PX_SETTLE'] CURR_REQ = Meas[Meas["FIELD"] == 'CURR'] #Fetching data for corresponding Request types. #CA IMPORT. Currenty only looking for dividends. if (len(CA_REQ) > 0): r_data = CA_DATALOAD(DATE).rename(columns={'IDENTIFIER': 'ISIN'}) CA_dat = pd.merge(CA_REQ[['ISIN']], r_data, on='ISIN', how='left', left_index=False, right_index=False) CA_dat = CA_dat[[ "ACTION_ID", "CORPORATE_ACTION", "COUNTRY_CODE", "CURRENCY", "DATAPROVIDER", "EX_DATE", "ISIN", "IDENTIFIER_NAME", "MODIFY_DATE", "NAME", "SYMBOL", "TICKER", 'VALUES' ]] CA_dat = CA_dat.dropna() try: if CA_dat.empty != 1: CA_dat = CA_dat[CA_dat['CORPORATE_ACTION'] == 'DVD_CASH'] up_pack = CA_dat['VALUES'] up_pack.index = CA_dat['ISIN'] #CA_dat.index = CA_dat['ISIN'] tr = pd.DataFrame(up_pack) tr2 = pd.DataFrame() for i in range(len(tr)): R1 = tr.iloc[i] sd = R1.values.tolist() r1 = DataFrame.from_records(sd[0]) tr1 = r1.set_index('name').T x = tr1[[ 'CP_GROSS_AMT', 'Frequency', 'Paydate', 'CP_DVD_TYP', 'Recdate' ]] tr2 = pd.concat([tr2, x]).reset_index() tr2.loc[i, 'ISIN'] = R1.name #tr2['ISIN'] = R1.name #tr2['ISIN'] = CA_dat['ISIN']#CA_dat.index tr2 = tr2.drop(columns={'index', 'level_0'}) CA_dat_f = pd.merge(CA_dat, tr2, on='ISIN', how='inner', left_index=False, right_index=False) CA_dat_f = CA_dat_f.rename(columns={ 'Recdate': 'Record_date', 'Paydate': 'PAYMENT_DATE' }) CA_dat_f.columns = map(str.upper, CA_dat_f.columns) CA_dat_f['TICKER'] = CA_dat_f['TICKER'].str.upper() CA_dat_f = CA_dat_f[[ "TICKER", "ISIN", "EX_DATE", "CORPORATE_ACTION", "CP_GROSS_AMT", "CURRENCY", "RECORD_DATE", "PAYMENT_DATE", "DATAPROVIDER", "CP_DVD_TYP", "FREQUENCY" ]] vals = CA_dat_f.values.tolist() d_ca_DATALOAD(vals) TICK = list(CA_dat_f['TICKER'].unique()) pa.Period_Divisor(DATE, TICK, CALENDAR_ID, INDEX_ID) except Exception as e: s = repr(e) con = ms.connect("127.0.0.1", "root", "123456789+", "epic_trust_vvr") cursor = con.cursor() vals = [exec_time, 'Reload_Func', str(INDEX_ID), s, 'N'] cursor.execute( "insert into d_run_exceptions (Runtimeid, Job_Failed, Index_ID, Error_Message, Resolution_Found) values (%s,%s,%s,%s,%s);", vals) con.commit() con.close() func.error_msg(s, 'CA not fulfilled.') #PRICE IMPORT if (len(PRICE_REQ) > 0): r_data = PRICE_DATALOAD(DATE) PRICE_dat = pd.merge(PRICE_REQ[['ISIN', 'TICKER', 'FIELD']], r_data[['ISIN', 'DATE', 'PRICE']], on='ISIN', how='left', left_index=False, right_index=False) PRICE_dat['DATA_SOURCE'] = 'BLOOMBERG' PRICE_dat = PRICE_dat.drop(columns={"ISIN"}) PRICE_dat = PRICE_dat[[ 'DATE', 'TICKER', 'FIELD', 'PRICE', 'DATA_SOURCE' ]] PRICE_dat = PRICE_dat.dropna() PRICE_dat['TICKER'] = PRICE_dat['TICKER'].str.upper() vals = PRICE_dat.values.tolist() d_price_DATALOAD(vals) #CURR IMPORT if (len(CURR_REQ) > 0): r_data = CURR_DATALOAD(DATE).rename( columns={'CURRENCY_TICKER': 'TICKER'}) CURR_dat = pd.merge(CURR_REQ[['TICKER', 'FIELD']], r_data[['TICKER', 'DATE', 'PRICE']], on='TICKER', how='left', left_index=False, right_index=False) CURR_dat['DATA_SOURCE'] = 'BLOOMBERG' CURR_dat = CURR_dat[[ 'DATE', 'TICKER', 'FIELD', 'PRICE', 'DATA_SOURCE' ]] CURR_dat['TICKER'] = CURR_dat['TICKER'].str.upper() vals = CURR_dat.values.tolist() d_price_DATALOAD(vals)
async def cringebiocheck(self, ctx, profile): functions.log(ctx.guild.name, ctx.author, ctx.command) account = functions.check_account_existence_and_return(profile) if account: bio = functions.get_bio(account['account_id']) pfp = functions.id_to_pfp(account['account_id'], True) print( f"{ctx.command} > {account['account_id']}, {account['username']}, {bio}, {pfp}" ) embed = functions.default_embed() embed.add_field(name=f"{account['username']}'s bio:", value=f"```{bio}```") flags = "" cringe_check_list = functions.load("cringe_word_list.json") cringe_score = 0 cringe_rating_dict = { 0: "Not cringe!", 1: "A little cringe!", 2: "Cringe!", 3: "Very cringe!", 4: "Yikes..!", 5: "Radically cringe!", 6: "Super cringe!", 7: "Mega cringe!", 8: "Ultra cringe!", 9: "THE CRINGIEST!", 10: "All hope for humanity has been lost!" } if bio: split_bio = bio.split(" ") for word in split_bio: for flag in cringe_check_list: if flag.casefold() in word.casefold(): cringe_score += 1 flags += f"`{flag}`, " if cringe_score > len(cringe_rating_dict) - 1: cringe_rating = cringe_rating_dict[len(cringe_rating_dict) - 1] else: cringe_rating = cringe_rating_dict[cringe_score] embed.add_field(name="Cringe score", value=f"`{cringe_score}` ({cringe_rating})", inline=False) if flags: embed.add_field( name="Flags", value= f"||{flags}||\nThis command is just for fun, and not meant to shame anybody!", inline=False) embed.set_author(name=f"🔗 {account['username']}'s profile", url=f"https://rec.net/user/{account['username']}", icon_url=pfp) else: embed = functions.error_msg(ctx, f"User `@{profile}` doesn't exist!") functions.embed_footer(ctx, embed) # get default footer from function await ctx.send(embed=embed)
async def cringenamecheck(self, ctx, profile): functions.log(ctx.guild.name, ctx.author, ctx.command) account = functions.check_account_existence_and_return(profile) if account: embed = functions.default_embed() cringe_check_list = functions.load("cringe_word_list.json") cringe_score = 0 cringe_rating = { 0: "Not cringe!", 1: "Maybe a little cringe?", 2: "Little cringe.", 3: "A bit cringe!", 4: "Cringe!", 5: "Quite cringe!", 6: "Very cringe!", 7: "Super cringe!", 8: "Incredibly cringe!", 9: "Ludicrously cringe!", 10: "THE CRINGIEST!" } display_name = functions.id_to_display_name(account['account_id']) cringe_words = [ ele for ele in cringe_check_list if (ele.casefold() in display_name.casefold()) ] cringe_score = len(cringe_words) * 2 for char in display_name: if not char.isalpha(): cringe_score += 1 cringe_words.append(char) if cringe_score > 10: cringe_score = 10 embed.add_field(name=f"{account['username']}'s display name:", value=f"```{display_name}```") embed.add_field( name="Cringe score", value=f"`{cringe_score}` ({cringe_rating[cringe_score]})", inline=False) flags = "" for flag in cringe_words: flags += f"`{flag}`, " if flags: embed.add_field( name="Flags", value= f"||{flags}||\nThis command is just for fun, and not meant to shame anybody!", inline=False) pfp = functions.id_to_pfp(account['account_id'], True) embed.set_author(name=f"🔗 {account['username']}'s profile", url=f"https://rec.net/user/{account['username']}", icon_url=pfp) else: embed = functions.error_msg(ctx, f"User `@{profile}` doesn't exist!") functions.embed_footer(ctx, embed) # get default footer from function await ctx.send(embed=embed)
msg, user_auth_public_key) if sig_verified: print("The signature is authentic") pwmsg_parts = pwmsg.split("|".encode()) uid = pwmsg_parts[0] USER_PATH = user_path_dic.get(uid.decode()) ts = pwmsg_parts[2] pwd_hash = SHA256.new(pwmsg_parts[1]) if not functions.is_timestamp_valid( time.time(), float(ts)): print("Timestamp error") error_msg = functions.error_msg( "Timestamp error", user_enc_public_key, server_auth_privatekey) netif.send_msg(CLIENT, error_msg) status, msg = netif.receive_msg(blocking=False) serverauth = False continue else: with open('server_machine/info.json') as json_file: data = json.load(json_file) # check the user ID exists valid_header = "VALID|".encode() if pwmsg_parts[0].decode() in data: # check password if pwd_hash.hexdigest() == data[ uid.decode()].lower():