{"header":{"message":"Add choice between game and web password reset","description":null,"timestamp":"2022-09-16T19:01:23.914826744Z","authors":[{}]},"hash":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC","authors":[{"login":"O01eg","key":"6xbZsEkjnZZpiD9GashW1D8feyXEWg43TbWGcJeUX1KQ"}],"deps":{"hashes":[["CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC","Add choice between game and web password reset"],["AA",null],["DGGFYSEG2LV5QWDFVI4LZN57Z7IJDV5CR7PDR6K7C55TQNRAWRKAC","Use non-escaped template for Atom XML"],["SQO74MUY2SFVMAWYWFZPWKYPJR3IX5QTYSNOKJOLXSSDVGUHO7PQC","Add field to choose type of password to reset"],["LTQCLSBUUATO4LYIXEW6R2QF6EZ7ETGXGSHWXP2U3JQOTU7QQGSQC","Split database usage in pages"],["5UYVIBUMRPOX5ZK6UZ34BSDNJCA24FOLBME67ZA6UKU7KSAT5XTQC","Update game password from page"],["3HT5CE6SDTPZAV7EN6FDMY2744JVFJCXHZXEQLK6IEFGPRGSBTXAC","Manage TTL duration in config"],["WW3KRXX63EYWW4563QM3VSEN4PGCPR76KJQBYIKCKOCNMDG6JW4QC","Add page for reset game password"],["TRBYOQBIJPJ72SX3TPI2OAKBUQH6FWVHTKT45LS2HVMBCAWCTULQC","Check CSRF and user existence"],["WVHXYKCVPKAFVMXBEMD3IHG54RKOIDSOCVNR3OIPEZQG36IGYJZQC","Add postgresql pools"],["WLWTNO4YJ4VBMJYVTP2LGPFQAJTOB524BD5INJFA44X2FKAX76DQC","Create form to request game password change link"],["I6SOPEQFWSSOZL7SWTQQK7OXEYZX62WVCLAMCKHFWGBA3OYALSJAC","Create and store reset password token"],["4JK5O45HRXZ7BFIGM226RMFEUFXNX2O4IHCFRDSBH356DUG5674QC","Start support for XMPP game password change"],["ZE5UFPX4K6VZXOJCYRIOUN32BFNWISSLG2BHIEJBLSUXCUITOM7AC","Add TTL cache for CSRF"],["HTYEGVBU6MODOOW4UPEGSHLH4CQFYCDSFVAF2MRQW2RCDP7ITNXQC","Add data to reset password page"],["I7JG43BJOGKQCPWGEGQMPJ3BIMBVMWXK7G7YAWITR6EATVQGVYUQC","Rename cache to use yet another"],["RAXDAROSIIJBXZHCH3RKJU5N4VED5O36ZOIEC62C7G6NKLL6UEFAC","Split base URL to protocol and domain"],["HZDCKIXQ3LCD7YPL7ZZBCRMD7YMKDJ2QAALETTG3FYMBF4TNFUBAC","Use constants for templates"],["EVP2FSBHQUCAXQ6IIMBD6IS24ODKHP6HFWYCHIMYG6KOFRQG3RVQC","Split index page"]],"deps":["DGGFYSEG2LV5QWDFVI4LZN57Z7IJDV5CR7PDR6K7C55TQNRAWRKAC","SQO74MUY2SFVMAWYWFZPWKYPJR3IX5QTYSNOKJOLXSSDVGUHO7PQC"],"known":["WW3KRXX63EYWW4563QM3VSEN4PGCPR76KJQBYIKCKOCNMDG6JW4QC","WVHXYKCVPKAFVMXBEMD3IHG54RKOIDSOCVNR3OIPEZQG36IGYJZQC","HTYEGVBU6MODOOW4UPEGSHLH4CQFYCDSFVAF2MRQW2RCDP7ITNXQC","ZE5UFPX4K6VZXOJCYRIOUN32BFNWISSLG2BHIEJBLSUXCUITOM7AC","3HT5CE6SDTPZAV7EN6FDMY2744JVFJCXHZXEQLK6IEFGPRGSBTXAC","5UYVIBUMRPOX5ZK6UZ34BSDNJCA24FOLBME67ZA6UKU7KSAT5XTQC","WLWTNO4YJ4VBMJYVTP2LGPFQAJTOB524BD5INJFA44X2FKAX76DQC","I7JG43BJOGKQCPWGEGQMPJ3BIMBVMWXK7G7YAWITR6EATVQGVYUQC","TRBYOQBIJPJ72SX3TPI2OAKBUQH6FWVHTKT45LS2HVMBCAWCTULQC","I6SOPEQFWSSOZL7SWTQQK7OXEYZX62WVCLAMCKHFWGBA3OYALSJAC","4JK5O45HRXZ7BFIGM226RMFEUFXNX2O4IHCFRDSBH356DUG5674QC","RAXDAROSIIJBXZHCH3RKJU5N4VED5O36ZOIEC62C7G6NKLL6UEFAC","LTQCLSBUUATO4LYIXEW6R2QF6EZ7ETGXGSHWXP2U3JQOTU7QQGSQC"]},"hunks":[{"Replacement":{"inode":{"change":4,"pos":44},"path":"src/templates/reset-game-pwd.html","line":19,"ins":{"up_context":[{"change":4,"pos":169}],"down_context":[{"change":4,"pos":223}],"flag":"BLOCK","start":0,"end":105,"inode":{"change":4,"pos":44}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":169},"to":{"change":4,"start":169,"end":223},"introduced_by":4}],"inode":{"change":4,"pos":44}},"ins_contents":[{"Add":{"text":"Enter data to set new ","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:30"}},{"Add":{"text":"{{#if is_game_pwd }}","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:51"}},{"Add":{"text":"game","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:56"}},{"Add":{"text":"{{else}}","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:65"}},{"Add":{"text":"web","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:69"}},{"Add":{"text":"{{/if}}","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:77"}},{"Add":{"text":" password:","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:104"}}],"del_contents":[{"Del":{"text":"Enter data to set new game password:","pos":"HTYEGVBU6MODOOW4UPEGSHLH4CQFYCDSFVAF2MRQW2RCDP7ITNXQC:222"}}]}},{"Replacement":{"inode":{"change":18,"pos":50},"path":"src/templates/query-reset-game-pwd.html","line":30,"ins":{"up_context":[{"change":3,"pos":155}],"down_context":[{"change":3,"pos":233}],"flag":"BLOCK","start":106,"end":175,"inode":{"change":18,"pos":50}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":155},"to":{"change":3,"start":155,"end":233},"introduced_by":3}],"inode":{"change":18,"pos":50}},"ins_contents":[{"Add":{"text":" Web
","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:174"}}],"del_contents":[{"Del":{"text":" ","pos":"SQO74MUY2SFVMAWYWFZPWKYPJR3IX5QTYSNOKJOLXSSDVGUHO7PQC:232"}}]}},{"Edit":{"inode":{"change":4,"pos":597},"path":"src/pages/reset_game_pwd.rs","line":15,"atom":{"NewVertex":{"up_context":[{"change":4,"pos":987}],"down_context":[{"change":4,"pos":0}],"flag":"BLOCK","start":176,"end":199,"inode":{"change":4,"pos":597}}},"contents":[{"Add":{"text":" is_game_pwd: bool,","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:198"}}]}},{"Replacement":{"inode":{"change":4,"pos":597},"path":"src/pages/reset_game_pwd.rs","line":47,"ins":{"up_context":[{"change":4,"pos":1500}],"down_context":[{"change":4,"pos":1657}],"flag":"BLOCK","start":200,"end":383,"inode":{"change":4,"pos":597}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":1500},"to":{"change":4,"start":164,"end":334},"introduced_by":4}],"inode":{"change":4,"pos":597}},"ins_contents":[{"Add":{"text":" let stmt = match dbclient.prepare(\"select player_name, last_error, is_game_pwd from auth.reset_tokens where token = $1 and NOW() < create_ts + interval '1 day' limit 1;\").await {","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:382"}}],"del_contents":[{"Del":{"text":" let stmt = match dbclient.prepare(\"select player_name, last_error from auth.reset_tokens where token = $1 and NOW() < create_ts + interval '1 day' limit 1;\").await {","pos":"5UYVIBUMRPOX5ZK6UZ34BSDNJCA24FOLBME67ZA6UKU7KSAT5XTQC:333"}}]}},{"Edit":{"inode":{"change":4,"pos":597},"path":"src/pages/reset_game_pwd.rs","line":70,"atom":{"NewVertex":{"up_context":[{"change":4,"pos":432}],"down_context":[{"change":4,"pos":2345}],"flag":"BLOCK","start":384,"end":429,"inode":{"change":4,"pos":597}}},"contents":[{"Add":{"text":" let is_game_pwd = row.get::<_, bool>(2);","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:428"}}]}},{"Replacement":{"inode":{"change":4,"pos":597},"path":"src/pages/reset_game_pwd.rs","line":77,"ins":{"up_context":[{"change":4,"pos":40}],"down_context":[{"change":4,"pos":59}],"flag":"BLOCK","start":430,"end":489,"inode":{"change":4,"pos":597}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":40},"to":{"change":4,"start":433,"end":479},"introduced_by":4}],"inode":{"change":4,"pos":597}},"ins_contents":[{"Add":{"text":" (token, player_name.to_string(), is_game_pwd),","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:488"}}],"del_contents":[{"Del":{"text":" (token, player_name.to_string()),","pos":"5UYVIBUMRPOX5ZK6UZ34BSDNJCA24FOLBME67ZA6UKU7KSAT5XTQC:478"}}]}},{"Edit":{"inode":{"change":4,"pos":597},"path":"src/pages/reset_game_pwd.rs","line":88,"atom":{"NewVertex":{"up_context":[{"change":4,"pos":2529}],"down_context":[{"change":4,"pos":2529}],"flag":"BLOCK","start":490,"end":515,"inode":{"change":4,"pos":597}}},"contents":[{"Add":{"text":" is_game_pwd,","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:514"}}]}},{"Replacement":{"inode":{"change":4,"pos":597},"path":"src/pages/reset_game_pwd.rs","line":110,"ins":{"up_context":[{"change":4,"pos":712}],"down_context":[{"change":4,"pos":771}],"flag":"BLOCK","start":516,"end":588,"inode":{"change":4,"pos":597}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":712},"to":{"change":4,"start":712,"end":771},"introduced_by":4}],"inode":{"change":4,"pos":597}},"ins_contents":[{"Add":{"text":" let (cached_token, cached_login, is_game_pwd) = match cached_data {","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:587"}}],"del_contents":[{"Del":{"text":" let (cached_token, cached_login) = match cached_data {","pos":"5UYVIBUMRPOX5ZK6UZ34BSDNJCA24FOLBME67ZA6UKU7KSAT5XTQC:770"}}]}},{"Replacement":{"inode":{"change":4,"pos":597},"path":"src/pages/reset_game_pwd.rs","line":154,"ins":{"up_context":[{"change":4,"pos":2441}],"down_context":[{"change":4,"pos":2585}],"flag":"BLOCK","start":589,"end":853,"inode":{"change":4,"pos":597}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":2441},"to":{"change":4,"start":2441,"end":2585},"introduced_by":4}],"inode":{"change":4,"pos":597}},"ins_contents":[{"Add":{"text":" let stmt = match dbclient.prepare(if is_game_pwd { \"update auth.users set game_password = crypt($1, gen_salt('bf', 8)) where player_name = $2;\" } else { \"update auth.users set web_password = crypt($1, gen_salt('bf', 8)) where player_name = $2;\" }).await {","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:852"}}],"del_contents":[{"Del":{"text":" let stmt = match dbclient.prepare(\"update auth.users set game_password = crypt($1, gen_salt('bf', 8)) where player_name = $2;\").await {","pos":"5UYVIBUMRPOX5ZK6UZ34BSDNJCA24FOLBME67ZA6UKU7KSAT5XTQC:2584"}}]}},{"Replacement":{"inode":{"change":18,"pos":557},"path":"src/pages/query_reset_game_pwd.rs","line":123,"ins":{"up_context":[{"change":4,"pos":407}],"down_context":[{"change":3,"pos":337}],"flag":"BLOCK","start":854,"end":912,"inode":{"change":18,"pos":557}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":407},"to":{"change":3,"start":273,"end":337},"introduced_by":3}],"inode":{"change":18,"pos":557}},"ins_contents":[{"Add":{"text":" let is_game_pwd = match form.password_type.as_str() {","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:911"}}],"del_contents":[{"Del":{"text":" let _is_game_password = match form.password_type.as_str() {","pos":"SQO74MUY2SFVMAWYWFZPWKYPJR3IX5QTYSNOKJOLXSSDVGUHO7PQC:336"}}]}},{"Replacement":{"inode":{"change":18,"pos":557},"path":"src/pages/query_reset_game_pwd.rs","line":169,"ins":{"up_context":[{"change":4,"pos":283}],"down_context":[{"change":4,"pos":369}],"flag":"BLOCK","start":913,"end":1003,"inode":{"change":18,"pos":557}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":283},"to":{"change":4,"start":283,"end":369},"introduced_by":4}],"inode":{"change":18,"pos":557}},"ins_contents":[{"Add":{"text":" .prepare(\"insert into auth.reset_tokens values ($1, $2, NULL, NOW(), NULL, $3);\")","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:1002"}}],"del_contents":[{"Del":{"text":" .prepare(\"insert into auth.reset_tokens values ($1, $2, NULL, NOW(), NULL);\")","pos":"I6SOPEQFWSSOZL7SWTQQK7OXEYZX62WVCLAMCKHFWGBA3OYALSJAC:368"}}]}},{"Replacement":{"inode":{"change":18,"pos":557},"path":"src/pages/query_reset_game_pwd.rs","line":179,"ins":{"up_context":[{"change":4,"pos":633}],"down_context":[{"change":4,"pos":717}],"flag":"BLOCK","start":1004,"end":1124,"inode":{"change":18,"pos":557}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":633},"to":{"change":4,"start":633,"end":717},"introduced_by":4}],"inode":{"change":18,"pos":557}},"ins_contents":[{"Add":{"text":" let inserted = match dbclient_rw","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:1040"}},{"Add":{"text":" .execute(&stmt, &[&form.login, &token, &is_game_pwd])","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:1102"}},{"Add":{"text":" .await","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:1117"}},{"Add":{"text":" {","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:1123"}}],"del_contents":[{"Del":{"text":" let inserted = match dbclient_rw.execute(&stmt, &[&form.login, &token]).await {","pos":"I6SOPEQFWSSOZL7SWTQQK7OXEYZX62WVCLAMCKHFWGBA3OYALSJAC:716"}}]}},{"Replacement":{"inode":{"change":19,"pos":50},"path":"src/pages/mod.rs","line":35,"ins":{"up_context":[{"change":2,"pos":144}],"down_context":[{"change":4,"pos":2116}],"flag":"BLOCK","start":1125,"end":1200,"inode":{"change":19,"pos":50}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":559},"to":{"change":4,"start":198,"end":267},"introduced_by":4}],"inode":{"change":19,"pos":50}},"ins_contents":[{"Add":{"text":" pub cache_reset_game_pwd: Mutex>,","pos":"CX3CY2GESJSNBJIVTYHFK4VIHR6WCN3RDIHE234OOLVIE65LKR5QC:1199"}}],"del_contents":[{"Del":{"text":" pub cache_reset_game_pwd: Mutex>,","pos":"I7JG43BJOGKQCPWGEGQMPJ3BIMBVMWXK7G7YAWITR6EATVQGVYUQC:266"}}]}}],"owner":"O01eg","repo":"freeorion-test-web","token":"eJmT17OyPwOY+wz+EbZhcKJSZVmlaZXCldBu12WBbuQ=","login":null}

…

Dependencies

Change contents

Review