def firstsale(userid):
now = datetime.utcnow()
usera = db.session.query(UserAchievements).filter_by(userid=userid).first()
if usera.v1 != 1:
usera.v1 = 1
usera.v1_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=12,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
def firsttrade_customer(userid):
usera = db.session.query(UserAchievements).filter_by(userid=userid).first()
now = datetime.utcnow()
if usera.c3 != 1:
usera.c3 = 1
usera.c3_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=19,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
def obtainedtrustlevel(userid):
now = datetime.utcnow()
usera = db.session.query(UserAchievements).filter_by(userid=userid).first()
if usera.v3 != 1:
usera.v3 = 1
usera.v3_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=17,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
def firstpurchase(userid):
usera = db.session.query(UserAchievements).filter_by(userid=userid).first()
now = datetime.utcnow()
if usera.c2 != 1:
usera.c2 = 1
usera.c2_date = now
db.session.add(usera)
db.session.commit()
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=20,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
def howmanytrades_vendor(userid, number):
usera = db.session.query(UserAchievements).filter_by(userid=userid).first()
now = datetime.utcnow()
if number >= 10:
if usera.v11 != 1:
usera.v11 = 1
usera.v11_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=36,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 100:
if usera.v12 != 1:
usera.v12 = 1
usera.v12_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=37,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 1000:
if usera.v13 != 1:
usera.v13 = 1
usera.v13_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=38,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 2500:
if usera.v14 != 1:
usera.v14 = 1
usera.v14_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=39,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 5000:
if usera.v15 != 1:
usera.v15 = 1
usera.v15_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=40,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 10300:
if usera.v16 != 1:
usera.v16 = 1
usera.v16_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=41,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
def howmanyitemssold_vendor(userid, number):
usera = db.session.query(UserAchievements).filter_by(userid=userid).first()
now = datetime.utcnow()
if number >= 10:
if usera.v5 != 1:
usera.v5 = 1
usera.v5_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=26,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 100:
if usera.v6 != 1:
usera.v6 = 1
usera.v6_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=27,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 1000:
if usera.v7 != 1:
usera.v7 = 1
usera.v7_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=28,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 2500:
if usera.v8 != 1:
usera.v8 = 1
usera.v8_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=29,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 5000:
if usera.v9 != 1:
usera.v9 = 1
usera.v9_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=30,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 10000:
if usera.v10 != 1:
usera.v10 = 1
usera.v10_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=31,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
def howmanytrades_customer(userid, number):
usera = db.session.query(UserAchievements).filter_by(userid=userid).first()
now = datetime.utcnow()
if number >= 10:
##ach id 32
if usera.c9 != 1:
usera.c9 = 1
usera.c9_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=32,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 100:
##ach id 33
if usera.c10 != 1:
usera.c10 = 1
usera.c10_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=33,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 500:
##ach id 34
if usera.c11 != 1:
usera.c11 = 1
usera.c11_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=34,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 1000:
##ach id 35
if usera.c12 != 1:
usera.c12 = 1
usera.c12_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=34,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
def howmanyitemsbought_customer(userid, number):
usera = db.session.query(UserAchievements).filter_by(userid=userid).first()
now = datetime.utcnow()
if number >= 10:
##ach id 32
if usera.c4 != 1:
usera.c4 = 1
usera.c4_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=21,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 100:
##ach id 32
if usera.c5 != 1:
usera.c5 = 1
usera.c5_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=22,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 1000:
##ach id 32
if usera.c6 != 1:
usera.c6 = 1
usera.c6_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=23,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 2500:
##ach id 32
if usera.c7 != 1:
usera.c7 = 1
usera.c7_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=24,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
if number >= 5000:
##ach id 32
if usera.c8 != 1:
usera.c8 = 1
usera.c8_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=25,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass
def levelawards(userid):
now = datetime.utcnow()
user = db.session.query(User).filter_by(id=userid).first()
usera = db.session.query(UserAchievements).filter_by(userid=userid).first()
if usera.level == 2:
if usera.e1 != 1:
# id = 4
#give user some admin roles
usera.e1 = 1
usera.e1_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=4,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
elif usera.level == 5:
if usera.e2 != 1:
# id = 2
usera.e2 = 1
usera.e2_date = now
user.admin_role = 1
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=2,
achievement_date=now,
viewed=0,
)
db.session.add(user)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
elif usera.level == 10:
if usera.e3 != 1:
# id = 3
usera.e3 = 1
usera.e3_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=3,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
elif usera.level == 25:
if usera.e4 != 1:
# id = 5
usera.e4 = 1
usera.e4_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=5,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
elif usera.level == 50:
if usera.e5 != 1:
# id = 6
usera.e5 = 1
usera.e5_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=6,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
elif usera.level == 100:
if usera.e6 != 1:
# id = 7
usera.e6 = 1
usera.e6_date = now
addit = UserAchievements_recent(
userid=usera.userid,
username=usera.username,
ach_id=7,
achievement_date=now,
viewed=0,
)
db.session.add(addit)
db.session.add(usera)
db.session.commit()
else:
pass
else:
pass