import praw
import time
import datetime
import sqlite3

'''USER CONFIGURATION'''

USERNAME =
#This is the bot's Username. In order to send mail, he must have some amount of Karma.
PASSWORD =
#This is the bot's Password.
USERAGENT =
#This is a short description of what the bot does. For example uGoldenSights' Newsletter Bot
SUBREDDIT = GoldTesting
#This is the sub or list of subs to scan for new posts. For a single sub, use sub1. For multiple subreddits, use sub1+sub2+sub3+...
MAXPOSTS = 30
#This is how many posts you want to retreieve all at once. PRAW will download 100 at a time.
WAIT = 20
#This is how many seconds you will wait between cycles. The bot is completely inactive during this time.
TSTRING = [request]
#This is the part of the title that you want to look for
DELAY = 172800
#This is the time limit between a user's posts, IN SECONDS. 1h = 3600  12h = 43200  24h = 86400  144h = 518400

'''All done!'''






WAITS = str(WAIT)
try
    import bot #This is a file in my python library which contains my Bot's username and password. I can push code to Git without showing credentials
    USERNAME = bot.getuG()
    PASSWORD = bot.getpG()
    USERAGENT = bot.getaG()
except ImportError
    pass
sql = sqlite3.connect('sql.db')
print('Loaded SQL Database')
cur = sql.cursor()
cur.execute('CREATE TABLE IF NOT EXISTS users(name TEXT, lastpost TEXT)')
print('Loaded Users')
cur.execute('CREATE TABLE IF NOT EXISTS oldposts(id TEXT)')
print('Loaded Oldposts')
sql.commit()

r = praw.Reddit(USERAGENT)

Trying = True
while Trying
        try
                r.login(USERNAME, PASSWORD)
                print('Successfully logged in')
                Trying = False
        except praw.errors.InvalidUserPass
                print('Wrong Username or Password')
                quit()
        except Exception as e
                print(%s % e)
                time.sleep(5)

def getTime(bool)
        timeNow = datetime.datetime.now(datetime.timezone.utc)
        timeUnix = timeNow.timestamp()
        if bool == False
                return timeNow
        else
                return timeUnix

def scan()
        print('Scanning ' + SUBREDDIT)
        subreddit = r.get_subreddit(SUBREDDIT)
        posts = subreddit.get_new(limit=MAXPOSTS)
        for post in posts
                try
                        pauthor = post.author.name
                except Exception
                        pauthor = '[deleted]'
                pid = post.id
                plink = post.short_link
                ptime = post.created_utc
                ptitle = post.title.lower()
                if TSTRING.lower() in ptitle
                        cur.execute('SELECT  FROM oldposts WHERE id=%s' % pid)
                        if not cur.fetchone()
                                cur.execute('SELECT  FROM users WHERE name=%s' % pauthor)
                                if not cur.fetchone()
                                        print('Found new user ' + pauthor)
                                        cur.execute('INSERT INTO users VALUES(%s, %s)' % (pauthor, pid))
                                        r.send_message(pauthor, 'Welcome to rpkmntcgtrades!','Dear ' + pauthor + ',nn Our bot has determined that this is your first time posting in rpkmntcgtrades. Please take the time to read [the guidelines](httpwww.reddit.comrpkmntcgtradeswikiguidelines) to understand how the subreddit works.nnIf you have any questions, feel free to [message the moderators.](httpwww.reddit.commessagecomposeto=%2Fr%2Fpkmntcgtrades) Thanks, and happy trading!', captcha=None)
                                        sql.commit()
                                        print('t' + pauthor + ' has been added to the database.')
                                        time.sleep(5)
                                else
                                        cur.execute('SELECT  FROM users WHERE name=%s' % pauthor)
                                        fetch = cur.fetchone()
                                        print('Found post by known user ' + pauthor)
                                        previousid = fetch[1]
                                        previous = r.get_info(thing_id='t3_'+previousid)
                                        previoustime = previous.created_utc
                                        if ptime  previoustime
                                                curtime = getTime(True)
                                                difference = curtime - previoustime
                                                if difference = DELAY
                                                        print('tPost complies with timelimit guidelines. Permitting')
                                                        cur.execute('DELETE FROM users WHERE name=%s' % pauthor)
                                                        cur.execute('INSERT INTO users VALUES(%s, %s)' % (pauthor, pid))
                                                        sql.commit()
                                                        print('t' + pauthor + 's database info has been reset.)
                                                else
                                                        differences = str(DELAY - difference)
                                                        print('tPost does not comply with timelimit guidelines. Author must wait ' + differences)
                                                        print('t' + pauthor + 's database info remains unchanged)
                                                        response = post.add_comment('You are posting here too frequently, so your post has been deleted. Please refer to the rule Submit no more than one post per 7 days in [the guidelines.](httpwww.reddit.comrpkmntcgtradeswikiguidelines#wiki_rules)')
                                                        response.distinguish()
                                                        post.remove(spam=False)
                                                        time.sleep(5)
                                cur.execute('INSERT INTO oldposts VALUES(%s)' % pid)
                sql.commit()




while True
        try
                scan()
        except Exception as e
                print('An error has occured', e)
        print('Running again in ' + WAITS + ' seconds.n')
        time.sleep(WAIT)