- 1
- 2
- 3
- 4
- 5
- 6
with conn:
cursor = conn.cursor()
cursor.execute('UPDATE users SET creferals = creferals + 1 WHERE cid = ?', (inviter,))
cursor.execute('INSERT INTO users VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)',
(datetime.strftime(datetime.now(),"%H:%M:%S %d.%m.%Y"), cid, username, 'main', 0, 0, 0, 0, 0, 0, 0, inviter, 'RUS'))
conn.commit()