PrimeGrid
Please visit donation page to help the project cover running costs for this month

Toggle Menu

Join PrimeGrid

Returning Participants

Community

Leader Boards

Results

Other

drummers-lowrise

Advanced search

Message boards : General discussion : Stats

Author Message
MenipeProject donor
Volunteer tester
Send message
Joined: 2 Jan 08
Posts: 235
ID: 17041
Credit: 104,757,590
RAC: 18,389
Found 1 prime in the 2020 Tour de Primes321 LLR Amethyst: Earned 1,000,000 credits (1,372,158)Cullen LLR Ruby: Earned 2,000,000 credits (2,786,489)ESP LLR Amethyst: Earned 1,000,000 credits (1,023,818)Generalized Cullen/Woodall LLR Amethyst: Earned 1,000,000 credits (1,144,031)PPS LLR Jade: Earned 10,000,000 credits (12,957,688)PSP LLR Ruby: Earned 2,000,000 credits (2,790,155)SoB LLR Amethyst: Earned 1,000,000 credits (1,110,322)SR5 LLR Ruby: Earned 2,000,000 credits (2,148,686)SGS LLR Ruby: Earned 2,000,000 credits (2,397,101)TPS LLR (retired) Bronze: Earned 10,000 credits (30,981)TRP LLR Ruby: Earned 2,000,000 credits (3,494,692)Woodall LLR Ruby: Earned 2,000,000 credits (2,478,017)321 Sieve (suspended) Ruby: Earned 2,000,000 credits (2,157,656)Cullen/Woodall Sieve (suspended) Ruby: Earned 2,000,000 credits (2,919,475)Generalized Cullen/Woodall Sieve (suspended) Amethyst: Earned 1,000,000 credits (1,410,644)PPS Sieve Sapphire: Earned 20,000,000 credits (21,836,903)Sierpinski (ESP/PSP/SoB) Sieve (suspended) Gold: Earned 500,000 credits (712,299)TRP Sieve (suspended) Amethyst: Earned 1,000,000 credits (1,064,240)AP 26/27 Jade: Earned 10,000,000 credits (13,141,112)GFN Sapphire: Earned 20,000,000 credits (22,428,031)WW Silver: Earned 100,000 credits (328,000)PSA Turquoise: Earned 5,000,000 credits (5,024,361)
Message 69118 - Posted: 12 Sep 2013 | 15:00:41 UTC

Does anyone know of a way to get the raw numbers for our stats?

I'm looking for something like what is generated with the cell phone link:
http://www.primegrid.com/userw.php?id=17041

But with all the data we get on the account screen:
http://www.primegrid.com/home.php


____________

Profile [DPC]CamulosProject donor
Send message
Joined: 23 Mar 11
Posts: 86
ID: 91898
Credit: 105,677,919
RAC: 7,462
321 LLR Gold: Earned 500,000 credits (650,015)Cullen LLR Gold: Earned 500,000 credits (820,374)ESP LLR Gold: Earned 500,000 credits (550,246)Generalized Cullen/Woodall LLR Gold: Earned 500,000 credits (607,632)PPS LLR Jade: Earned 10,000,000 credits (11,146,743)PSP LLR Gold: Earned 500,000 credits (539,445)SoB LLR Gold: Earned 500,000 credits (627,950)SR5 LLR Amethyst: Earned 1,000,000 credits (1,023,449)SGS LLR Ruby: Earned 2,000,000 credits (2,389,355)TRP LLR Gold: Earned 500,000 credits (523,441)Woodall LLR Gold: Earned 500,000 credits (718,450)Cullen/Woodall Sieve (suspended) Ruby: Earned 2,000,000 credits (4,084,280)Generalized Cullen/Woodall Sieve (suspended) Gold: Earned 500,000 credits (510,148)PPS Sieve Sapphire: Earned 20,000,000 credits (41,714,774)TRP Sieve (suspended) Gold: Earned 500,000 credits (560,644)AP 26/27 Turquoise: Earned 5,000,000 credits (5,336,760)GFN Sapphire: Earned 20,000,000 credits (33,510,955)PSA Silver: Earned 100,000 credits (357,578)
Message 69209 - Posted: 16 Sep 2013 | 20:42:20 UTC - in response to Message 69118.

raw stats? ofc.. just check : http://www.primegrid.com/stats/

:D Only read the data into your own database and long live your stats ^^
Good luck!
____________
Member of the Dutch Power Cows
My Stats

MenipeProject donor
Volunteer tester
Send message
Joined: 2 Jan 08
Posts: 235
ID: 17041
Credit: 104,757,590
RAC: 18,389
Found 1 prime in the 2020 Tour de Primes321 LLR Amethyst: Earned 1,000,000 credits (1,372,158)Cullen LLR Ruby: Earned 2,000,000 credits (2,786,489)ESP LLR Amethyst: Earned 1,000,000 credits (1,023,818)Generalized Cullen/Woodall LLR Amethyst: Earned 1,000,000 credits (1,144,031)PPS LLR Jade: Earned 10,000,000 credits (12,957,688)PSP LLR Ruby: Earned 2,000,000 credits (2,790,155)SoB LLR Amethyst: Earned 1,000,000 credits (1,110,322)SR5 LLR Ruby: Earned 2,000,000 credits (2,148,686)SGS LLR Ruby: Earned 2,000,000 credits (2,397,101)TPS LLR (retired) Bronze: Earned 10,000 credits (30,981)TRP LLR Ruby: Earned 2,000,000 credits (3,494,692)Woodall LLR Ruby: Earned 2,000,000 credits (2,478,017)321 Sieve (suspended) Ruby: Earned 2,000,000 credits (2,157,656)Cullen/Woodall Sieve (suspended) Ruby: Earned 2,000,000 credits (2,919,475)Generalized Cullen/Woodall Sieve (suspended) Amethyst: Earned 1,000,000 credits (1,410,644)PPS Sieve Sapphire: Earned 20,000,000 credits (21,836,903)Sierpinski (ESP/PSP/SoB) Sieve (suspended) Gold: Earned 500,000 credits (712,299)TRP Sieve (suspended) Amethyst: Earned 1,000,000 credits (1,064,240)AP 26/27 Jade: Earned 10,000,000 credits (13,141,112)GFN Sapphire: Earned 20,000,000 credits (22,428,031)WW Silver: Earned 100,000 credits (328,000)PSA Turquoise: Earned 5,000,000 credits (5,024,361)
Message 69553 - Posted: 2 Oct 2013 | 14:28:13 UTC

Does anyone know what format the files are or what I can read the data with once I've unzipped the files?
____________

[DPC]Charley
Send message
Joined: 15 Apr 11
Posts: 803
ID: 95137
Credit: 94,993,523
RAC: 0
321 LLR Amethyst: Earned 1,000,000 credits (1,009,885)Cullen LLR Amethyst: Earned 1,000,000 credits (1,440,123)ESP LLR Amethyst: Earned 1,000,000 credits (1,008,511)PPS LLR Ruby: Earned 2,000,000 credits (2,389,215)PSP LLR Amethyst: Earned 1,000,000 credits (1,080,442)SoB LLR Amethyst: Earned 1,000,000 credits (1,143,918)SR5 LLR Amethyst: Earned 1,000,000 credits (1,853,162)SGS LLR Amethyst: Earned 1,000,000 credits (1,344,963)TRP LLR Amethyst: Earned 1,000,000 credits (1,140,037)Woodall LLR Amethyst: Earned 1,000,000 credits (1,130,355)Cullen/Woodall Sieve (suspended) Ruby: Earned 2,000,000 credits (4,038,617)PPS Sieve Sapphire: Earned 20,000,000 credits (36,643,348)Sierpinski (ESP/PSP/SoB) Sieve (suspended) Ruby: Earned 2,000,000 credits (2,000,717)TRP Sieve (suspended) Amethyst: Earned 1,000,000 credits (1,298,244)GFN Jade: Earned 10,000,000 credits (17,346,536)PSA Sapphire: Earned 20,000,000 credits (20,125,451)
Message 69554 - Posted: 2 Oct 2013 | 14:33:32 UTC

Why not start with downloading the compressed file and seeing what comes out?

If you're not sure what format a file is, you can always start with looking at it in a text editor like NotePad++ or Sublime Text. If you do so with these files you'll quickly see that they're XML files. You can read this with a plethora of programs like text editors, spread sheet programs, some database programs and many programming languages will also have tools available to interact with XML files. Depending on what your needs are you'll have to pick the program that best suits your needs.


____________
PrimeGrid Challenge Overall standings --- Last update: From Pi to Paddy (2016)

MenipeProject donor
Volunteer tester
Send message
Joined: 2 Jan 08
Posts: 235
ID: 17041
Credit: 104,757,590
RAC: 18,389
Found 1 prime in the 2020 Tour de Primes321 LLR Amethyst: Earned 1,000,000 credits (1,372,158)Cullen LLR Ruby: Earned 2,000,000 credits (2,786,489)ESP LLR Amethyst: Earned 1,000,000 credits (1,023,818)Generalized Cullen/Woodall LLR Amethyst: Earned 1,000,000 credits (1,144,031)PPS LLR Jade: Earned 10,000,000 credits (12,957,688)PSP LLR Ruby: Earned 2,000,000 credits (2,790,155)SoB LLR Amethyst: Earned 1,000,000 credits (1,110,322)SR5 LLR Ruby: Earned 2,000,000 credits (2,148,686)SGS LLR Ruby: Earned 2,000,000 credits (2,397,101)TPS LLR (retired) Bronze: Earned 10,000 credits (30,981)TRP LLR Ruby: Earned 2,000,000 credits (3,494,692)Woodall LLR Ruby: Earned 2,000,000 credits (2,478,017)321 Sieve (suspended) Ruby: Earned 2,000,000 credits (2,157,656)Cullen/Woodall Sieve (suspended) Ruby: Earned 2,000,000 credits (2,919,475)Generalized Cullen/Woodall Sieve (suspended) Amethyst: Earned 1,000,000 credits (1,410,644)PPS Sieve Sapphire: Earned 20,000,000 credits (21,836,903)Sierpinski (ESP/PSP/SoB) Sieve (suspended) Gold: Earned 500,000 credits (712,299)TRP Sieve (suspended) Amethyst: Earned 1,000,000 credits (1,064,240)AP 26/27 Jade: Earned 10,000,000 credits (13,141,112)GFN Sapphire: Earned 20,000,000 credits (22,428,031)WW Silver: Earned 100,000 credits (328,000)PSA Turquoise: Earned 5,000,000 credits (5,024,361)
Message 69561 - Posted: 2 Oct 2013 | 21:39:08 UTC - in response to Message 69554.

I am able to view the XML files. I have decompressed the .gz files with 7zip and there is no clue in the data of the what format the file is. That is why I was asking if anyone knew anything about the files.

Are these extracts of the database, are they MySQL files, or are they compressed with something else. there is no file extension showing in the compressed file, only the same file name.
____________

[DPC]Charley
Send message
Joined: 15 Apr 11
Posts: 803
ID: 95137
Credit: 94,993,523
RAC: 0
321 LLR Amethyst: Earned 1,000,000 credits (1,009,885)Cullen LLR Amethyst: Earned 1,000,000 credits (1,440,123)ESP LLR Amethyst: Earned 1,000,000 credits (1,008,511)PPS LLR Ruby: Earned 2,000,000 credits (2,389,215)PSP LLR Amethyst: Earned 1,000,000 credits (1,080,442)SoB LLR Amethyst: Earned 1,000,000 credits (1,143,918)SR5 LLR Amethyst: Earned 1,000,000 credits (1,853,162)SGS LLR Amethyst: Earned 1,000,000 credits (1,344,963)TRP LLR Amethyst: Earned 1,000,000 credits (1,140,037)Woodall LLR Amethyst: Earned 1,000,000 credits (1,130,355)Cullen/Woodall Sieve (suspended) Ruby: Earned 2,000,000 credits (4,038,617)PPS Sieve Sapphire: Earned 20,000,000 credits (36,643,348)Sierpinski (ESP/PSP/SoB) Sieve (suspended) Ruby: Earned 2,000,000 credits (2,000,717)TRP Sieve (suspended) Amethyst: Earned 1,000,000 credits (1,298,244)GFN Jade: Earned 10,000,000 credits (17,346,536)PSA Sapphire: Earned 20,000,000 credits (20,125,451)
Message 69562 - Posted: 2 Oct 2013 | 21:49:21 UTC - in response to Message 69561.

I am able to view the XML files. I have decompressed the .gz files with 7zip and there is no clue in the data of the what format the file is. That is why I was asking if anyone knew anything about the files.

Are these extracts of the database, are they MySQL files, or are they compressed with something else. there is no file extension showing in the compressed file, only the same file name.


There is a hint, in the first five characters. These are
<?XML


There is no such thing as "MySQL files". As I said in my previous post, there's a plethora of programs you can use to read or process this kind of file.
____________
PrimeGrid Challenge Overall standings --- Last update: From Pi to Paddy (2016)

MenipeProject donor
Volunteer tester
Send message
Joined: 2 Jan 08
Posts: 235
ID: 17041
Credit: 104,757,590
RAC: 18,389
Found 1 prime in the 2020 Tour de Primes321 LLR Amethyst: Earned 1,000,000 credits (1,372,158)Cullen LLR Ruby: Earned 2,000,000 credits (2,786,489)ESP LLR Amethyst: Earned 1,000,000 credits (1,023,818)Generalized Cullen/Woodall LLR Amethyst: Earned 1,000,000 credits (1,144,031)PPS LLR Jade: Earned 10,000,000 credits (12,957,688)PSP LLR Ruby: Earned 2,000,000 credits (2,790,155)SoB LLR Amethyst: Earned 1,000,000 credits (1,110,322)SR5 LLR Ruby: Earned 2,000,000 credits (2,148,686)SGS LLR Ruby: Earned 2,000,000 credits (2,397,101)TPS LLR (retired) Bronze: Earned 10,000 credits (30,981)TRP LLR Ruby: Earned 2,000,000 credits (3,494,692)Woodall LLR Ruby: Earned 2,000,000 credits (2,478,017)321 Sieve (suspended) Ruby: Earned 2,000,000 credits (2,157,656)Cullen/Woodall Sieve (suspended) Ruby: Earned 2,000,000 credits (2,919,475)Generalized Cullen/Woodall Sieve (suspended) Amethyst: Earned 1,000,000 credits (1,410,644)PPS Sieve Sapphire: Earned 20,000,000 credits (21,836,903)Sierpinski (ESP/PSP/SoB) Sieve (suspended) Gold: Earned 500,000 credits (712,299)TRP Sieve (suspended) Amethyst: Earned 1,000,000 credits (1,064,240)AP 26/27 Jade: Earned 10,000,000 credits (13,141,112)GFN Sapphire: Earned 20,000,000 credits (22,428,031)WW Silver: Earned 100,000 credits (328,000)PSA Turquoise: Earned 5,000,000 credits (5,024,361)
Message 69563 - Posted: 2 Oct 2013 | 22:22:46 UTC - in response to Message 69562.

I can view the db_dump.xml and tables.xml files with no problems.

I understand XML but there must be something with the encoding of the file. For example, once I have extracted the "team" file from the team.gz, it still is a jumble of characters.

The team file starts with

‹¾LRteamÌ\ësÛF’ÿž¿¢£ÔFI


____________

[DPC]Charley
Send message
Joined: 15 Apr 11
Posts: 803
ID: 95137
Credit: 94,993,523
RAC: 0
321 LLR Amethyst: Earned 1,000,000 credits (1,009,885)Cullen LLR Amethyst: Earned 1,000,000 credits (1,440,123)ESP LLR Amethyst: Earned 1,000,000 credits (1,008,511)PPS LLR Ruby: Earned 2,000,000 credits (2,389,215)PSP LLR Amethyst: Earned 1,000,000 credits (1,080,442)SoB LLR Amethyst: Earned 1,000,000 credits (1,143,918)SR5 LLR Amethyst: Earned 1,000,000 credits (1,853,162)SGS LLR Amethyst: Earned 1,000,000 credits (1,344,963)TRP LLR Amethyst: Earned 1,000,000 credits (1,140,037)Woodall LLR Amethyst: Earned 1,000,000 credits (1,130,355)Cullen/Woodall Sieve (suspended) Ruby: Earned 2,000,000 credits (4,038,617)PPS Sieve Sapphire: Earned 20,000,000 credits (36,643,348)Sierpinski (ESP/PSP/SoB) Sieve (suspended) Ruby: Earned 2,000,000 credits (2,000,717)TRP Sieve (suspended) Amethyst: Earned 1,000,000 credits (1,298,244)GFN Jade: Earned 10,000,000 credits (17,346,536)PSA Sapphire: Earned 20,000,000 credits (20,125,451)
Message 69564 - Posted: 2 Oct 2013 | 22:53:08 UTC

Interesting. 7zip made something useful out of it straight away, but with winrar I needed to open the file inside the .gz file again with winrar to be able to get to the xml. Not sure what file format it is, I just used "view file" in both winrar and 7zip.
____________
PrimeGrid Challenge Overall standings --- Last update: From Pi to Paddy (2016)

MenipeProject donor
Volunteer tester
Send message
Joined: 2 Jan 08
Posts: 235
ID: 17041
Credit: 104,757,590
RAC: 18,389
Found 1 prime in the 2020 Tour de Primes321 LLR Amethyst: Earned 1,000,000 credits (1,372,158)Cullen LLR Ruby: Earned 2,000,000 credits (2,786,489)ESP LLR Amethyst: Earned 1,000,000 credits (1,023,818)Generalized Cullen/Woodall LLR Amethyst: Earned 1,000,000 credits (1,144,031)PPS LLR Jade: Earned 10,000,000 credits (12,957,688)PSP LLR Ruby: Earned 2,000,000 credits (2,790,155)SoB LLR Amethyst: Earned 1,000,000 credits (1,110,322)SR5 LLR Ruby: Earned 2,000,000 credits (2,148,686)SGS LLR Ruby: Earned 2,000,000 credits (2,397,101)TPS LLR (retired) Bronze: Earned 10,000 credits (30,981)TRP LLR Ruby: Earned 2,000,000 credits (3,494,692)Woodall LLR Ruby: Earned 2,000,000 credits (2,478,017)321 Sieve (suspended) Ruby: Earned 2,000,000 credits (2,157,656)Cullen/Woodall Sieve (suspended) Ruby: Earned 2,000,000 credits (2,919,475)Generalized Cullen/Woodall Sieve (suspended) Amethyst: Earned 1,000,000 credits (1,410,644)PPS Sieve Sapphire: Earned 20,000,000 credits (21,836,903)Sierpinski (ESP/PSP/SoB) Sieve (suspended) Gold: Earned 500,000 credits (712,299)TRP Sieve (suspended) Amethyst: Earned 1,000,000 credits (1,064,240)AP 26/27 Jade: Earned 10,000,000 credits (13,141,112)GFN Sapphire: Earned 20,000,000 credits (22,428,031)WW Silver: Earned 100,000 credits (328,000)PSA Turquoise: Earned 5,000,000 credits (5,024,361)
Message 69569 - Posted: 3 Oct 2013 | 12:13:25 UTC - in response to Message 69564.

Unzipping the file again inside the .gz did the trick.

Thanks for your help and patience!
____________

Message boards : General discussion : Stats

[Return to PrimeGrid main page]
DNS Powered by DNSEXIT.COM
Copyright © 2005 - 2021 Rytis Slatkevičius (contact) and PrimeGrid community. Server load 1.00, 1.64, 1.67
Generated 21 Sep 2021 | 21:09:31 UTC