I can See Again
I can See Again
I've been putting this on my blog last few days but not sure anyone is looking So I'll put it here too..
Added a 'last28' field into the boinc users table rather than computing it on the fly. Not quite 3rd normal form for a database but it allows it to be indexed and sorted in the front end. Coded the perl scripts to calculate it and fixed the 'users' php script to allow sorting.
Amended the nightly script which calculates a users 'main' team across boinc projects. This is a bit of a grey area really. The script basically uses a temporary table which I do a group by insert ignore on each users team. The on with the highest hits gets inserted, the others are ignored. However this meant that say a user was originally in team A for 15 projects way back when and now moved to team B for an additional 5 projects, it would still say they were in team A overall which is not quite true. Would be ok if they could change their team on the original 15 projects but a lot of the older projects are either closed down or not exporting new xml so that's impossible. Likely does not affect too many users, but I altered the script slightly to only use projects deemed as 'active'.
Refixed the coprocessor string sent out in the xml. I'd hoped to get the BOINC devs to separate out he components but no go, so I'm showing it on the host pages undiluted again..
In the movement page like here re-fixed it so that it shows teammovement To AND from the team in question. Added some url links on the fields too.
On the teammovement page linked from a teambycpid page like here added the current score as well as the score at the time to see if the users are still running the project actively.
Amended the historic team movemement on the user page to contain the real teamnames rather than id's only, added hyperlinks. A good example is here which shows lots of movement.
Come on Let's hear a round for our 2 SUPPER Admins here at Free-DC
They put in countless hours here to make sure Every thing is just perfect
_gopher_yarrowzoo___and___Bok
Thank You LaurenU2, it does make us feel appreciated and useful and not just banging our heads of a wall trying to do things that maybe no-one notices.
I'm almost done with the radar and well it works but the layout needs a tweak so it will go live when it is ready as soon as I figure out how to do some on the fly changes. Oh Idea - I'm going to try that one later but first time to warm the car up and go forth to work it was a nice mild -9C (15F) here overnight..
Semi-retired from Free-DC...
I have some time to help.....
I need a new laptop,but who needs a laptop when you have a phone...
Now to remember my old computer specs..
Every one Notices , But all member are not as outspoken as I am ,after all I am the team Blabbermouth
I am Sure I can speak for any member/visitor (except Bot's) that we appreciate all the Time Effort and money Bok and gopher put in to providing this service to the DC World
THANK YOU
Does this thread show up on the new list in HOME page http://www.free-dc.org/forum/ (miss labeled I guess)
Seems to me like it should me http://www.free-dc.org/home/ But heck you know me he he
I think I seem to only see it show up when I do New http://www.free-dc.org/forum/search.php?searchid=4868
Thanks for the update. Have been playing around with this and it works great for BOINC projects. For some reason it doesn't seem to be working for any non_BOINCers:
http://stats.free-dc.org/stats.php?p...ad&sort=last28
http://stats.free-dc.org/stats.php?p...sp&sort=last28
http://stats.free-dc.org/stats.php?p...es&sort=last28
http://stats.free-dc.org/stats.php?p...aj&sort=last28
Separate tables - I only did the BOINC ones. Will do nonBOINC as soon as I can.
Could sudoku@vtaiwan be replaced with the new project name sudoku and update the stats? The site is now at http://sudoku.nctu.edu.tw
It's the same project, with the same stats (as long as you re-registered they gave your old credits back), unfortunately the xml stats have not been updated since Jan 18th If we look in tables.xml the update_time is 1295328302, using an Epoch Convertor this translates to Tue, 18 Jan 2011 05:25:02 GMT.
So, the stats here are still checking of course and once they detect a change they'll update...
1) Fixed the userbycpid and userbycpid2 pages so that it correctly displays the latest milestone for each project. These get archived periodically so it's coming from two different tables.
2) Whilst in there, I added a link out to a new page showing all milestones for a user within an individual project (projusermilestones) (I just used the >> symbol here, if you can think of something better feel free)
3) renamed the old projusermilestones -> projusersmilestones as it is recent milestones for all users across a project linked from the proj page
4) As there was not much data displayed on screen here I added some dummy columns on either side to move it in to the middle a bit. Whenever I see this in other pages I'll do the same thing.