Update points in table Players after each (won) round
authorBenjamin Auder <benjamin.auder@somewhere>
Tue, 26 Oct 2021 08:00:02 +0000 (10:00 +0200)
committerBenjamin Auder <benjamin.auder@somewhere>
Tue, 26 Oct 2021 08:00:02 +0000 (10:00 +0200)
rpsls.js
server.py

index bf5df63..77213ed 100644 (file)
--- a/rpsls.js
+++ b/rpsls.js
@@ -63,6 +63,7 @@ let Play = {
     Play.oppselect = Play.oppmove; //reveal opponent's move only now
     if (Win[Play.mymove].includes(Play.oppmove)) {
       if (++Play.mypoints == MAX_POINTS) Play.endGame(true);
+      socket.emit("inc_pts", {uid: getV("uid"), gid:Play.gid});
     }
     else if (Win[Play.oppmove].includes(Play.mymove)) {
       if (++Play.oppoints == MAX_POINTS) Play.endGame(false);
index 61a01aa..94b3788 100644 (file)
--- a/server.py
+++ b/server.py
@@ -91,6 +91,16 @@ def move(sid, data):
     con.commit()
     con.close()
 
+@sio.event
+def inc_pts(sid, data):
+    """ Add a point to the player (who won last round) """
+    con = sqlite3.connect(DB_PATH)
+    cur = con.cursor()
+    cur.execute("update Players set points=points+1 where uid=? and gid=?",
+                (data["uid"],data["gid"]))
+    con.commit()
+    con.close()
+
 static_files = {
     '/': RPSLS_PATH + 'index.html',
     '/rpsls.js': RPSLS_PATH + 'rpsls.js',