Last active
April 27, 2025 20:25
-
-
Save mesmere/0739dbfa43b7fa4e651c113978559d6f to your computer and use it in GitHub Desktop.
Alphacross play stats
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| if [ $(id -u) -ne 0 ] | |
| then echo "Please run this script as root." | |
| exit | |
| fi | |
| /data/data/com.termux/files/usr/bin/sqlite3 /data/data/org.akop.crosswords/databases/crosswords |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| .mode column | |
| .header on | |
| select | |
| case sizeRank | |
| when 0 then 'xsmall' | |
| when 1 then 'small' | |
| when 2 then 'medium' | |
| when 3 then 'large' | |
| when 4 then 'xlarge' | |
| end as grid_size, | |
| count(*) as completed, | |
| concat(sum(playTimeMillis)/1000/60/60,' hours') as time, | |
| concat(round( | |
| cast(sum(squaresCheated) as real)/sum(squaresTotal)*100, | |
| 2),'%') as cheated | |
| from Crosswords | |
| where status = 2 | |
| group by sizeRank; |
Author
mesmere
commented
Apr 27, 2025
Author
note that this includes archived and trashed grids. filter on folderId to exclude
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment