Is it possible to edit stats? | General GC | Forums

Avatar
Please consider registering
guest
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_TopicIcon
Is it possible to edit stats?
July 29, 2010
7:22 am
Avatar
David
Member
Members
Forum Posts: 646
Member Since:
March 20, 2010
sp_UserOfflineSmall Offline
493sp_Permalink sp_Print

Genegene,

Thanks for the reply - I finally just editted the stats file because I ran into major problems after I had logged about 1300 caches with the GC - the unit became unusable. I finally had to restore the unit to an original load and just edit the file so that the little machine dosn't choke it's self to death on data!!!

David


 

 

 

July 29, 2010
4:00 am
Avatar
genegene
New Member
Members
Forum Posts: 2
Member Since:
February 21, 2010
sp_UserOfflineSmall Offline
492sp_Permalink sp_Print

DWCARR1:

There is a much easier way to do it then what you have posted. The only problem is, you will not gain any awards on those finds that you input manually as far as I can tell.

June 23, 2010
1:23 pm
Avatar
all4buck
Member
Members
Forum Posts: 5
Member Since:
March 8, 2010
sp_UserOfflineSmall Offline
394sp_Permalink sp_Print

i did the same thing thankfully i only had 300 or so to go through :pinch: :woohoo:

June 23, 2010
8:49 am
Avatar
David
Member
Members
Forum Posts: 646
Member Since:
March 20, 2010
sp_UserOfflineSmall Offline
393sp_Permalink sp_Print

Ok, it had been rumored that I'm certifiably insane, but now even I beleive it - I loaded my MyFinds.gpx into my GC and spent the good part of the evening loggin almost 1200 caches as found. So I guess there is a way to get the GC up to date with your real stats - but it isn't easy! And trust me, I backed up the database file after doing that!!! At least now all of my number and awards are up to date and tomorrow I go caching! :woohoo:

One plus, the joystick on the GC is losened up a little now!


 

 

 

June 22, 2010
3:41 pm
Avatar
cmoewes
Member
Members
Forum Posts: 60
Member Since:
April 28, 2010
sp_UserOfflineSmall Offline
392sp_Permalink sp_Print

Also, definitely make a backup of the Database.db file before you do any of this. None of this should cause a problem with the system, but just in case, as long as you can boot up into disk mode you can replace the database file.

Also, I like to use the SQLite Manager for firefox.

June 22, 2010
3:39 pm
Avatar
cmoewes
Member
Members
Forum Posts: 60
Member Since:
April 28, 2010
sp_UserOfflineSmall Offline
391sp_Permalink sp_Print

The summary data seems to get updated every time you make another find based on the data from other tables.

If you truly want it to be accurate you need to select (from your gsak sqlite database) the gc.com code for all the found caches you have.

Then for each of those, you need to select the geocache id from the explorists caches table and insert a record for every one of them in the cache history table. This table seems to store the history of the found caches (and not found caches) independent of the caches table so that if a cache is removed from he table it will remember it when it gets reloaded.

It uses some kind of either calculated or derived value for the internal cache id.

I can provide some sql examples.

June 22, 2010
7:21 am
Avatar
David
Member
Members
Forum Posts: 646
Member Since:
March 20, 2010
sp_UserOfflineSmall Offline
390sp_Permalink sp_Print

Ok, this is most definetly at your own risk! But I downloaded SQLite Database Browser from http://sqlitebrowser.sourceforge.net and was able to open /App/Database.db and was able to browse the data in the GeocacheSummary records and was able to edit eGSF_LifetimeFound and eGSF_LifetimeNotFound to match my numbers on GC.com. If your going to try this, PLEASE make sure to backup your database.db file before hand!!!


 

 

 

June 22, 2010
1:00 am
Avatar
David
Member
Members
Forum Posts: 646
Member Since:
March 20, 2010
sp_UserOfflineSmall Offline
388sp_Permalink sp_Print

I would like to see them, I spent 10 years writting relational databases for the NSA and I USED to know SQL like the back of my hand, but then again, after being out of it for 10 years I'm finding that there are a lot of things that I USED to know!!! :blink:

Thanks,
David


 

 

 

June 21, 2010
8:15 pm
Avatar
cmoewes
Member
Members
Forum Posts: 60
Member Since:
April 28, 2010
sp_UserOfflineSmall Offline
387sp_Permalink sp_Print

I don't think that there is any supported mechanism to do it.

I messed around with the database directly to get mine updated using the database from GSAK to know which caches I found.

It worked fine, but I wouldn't recommend it for anyone who isn't comfortable with SQL.

I can maybe write up the steps I did, but they require some tools (SQLite) to do them.

June 21, 2010
7:16 am
Avatar
David
Member
Members
Forum Posts: 646
Member Since:
March 20, 2010
sp_UserOfflineSmall Offline

I was wondering if anyone knows a way to edit the stats on the GC. I'd like to be able to set the "Lifetime Found" to the actual number that I have on GC.com.

Thanks,
David


 

 

 

Forum Timezone: America/New_York
Most Users Ever Online: 99
Currently Online:
Guest(s) 3
Currently Browsing this Page:
1 Guest(s)
Top Posters:
phild31: 1479
David: 646
denisetdoris: 400
pprass: 264
S!G: 251
ShortcutHicksy: 250
jmebd: 184
Sockeye: 170
Caotix: 143
Paganel: 116
Member Stats:
Guest Posters: 5
Members: 805
Moderators: 0
Admins: 3
Forum Stats:
Groups: 15
Forums: 42
Topics: 921
Posts: 7306
Newest Members:
savannahtindale, Wat, KHB3, ethanwetherspoon, EmilyAnges, cletachristie0, Robert Temple, OSS-SAS
Administrators: jg_the_Prophet: 29, mike_the_Enforcer: 0, OSS-SAS: 1

Leave a Reply