jms_gears1
Premium Member
MySql? Unless im reading this wrong, couldnt you have a php script automatically place the time where it needs to be in the DB, then just draw the table with the info in it?
New UWR page!
- Thread starter ben1996123
- Start date
MySql? Unless im reading this wrong, couldnt you have a php script automatically place the time where it needs to be in the DB, then just draw the table with the info in it?
PatrickJameson
Premium Member
Stefan just said he was going to change and update the previous UWR page, so I wouldn't bother if I were you.
Stefan
Legend
I'm working on it and making good progress, though yeah, not quite as fast as I wanted. I'm porting the old data to a proper database, which it wasn't before, and properly analyzing the data and correcting errors presents a bigger challenge than I had thought. Not really hard, just cumbersome. But it'll be ready soon.
Last edited:
That70sShowDude
Veteran
Last Update: 2009-05-21
Today: 2010-05-18
Getting closer.
Today: 2010-05-18
Getting closer.
That70sShowDude
Veteran
Sorry for the double post, but today marks the 1 year anniversery of the last updated Unofficial World Record.
Stefan
Legend
Little update: It's not quite ready to show, but I'm about done gathering/correcting/merging/converting the old data into the new database, which was more work than I had thought because of irregularities (and because it's a lot of data). And I'm a slacker, though I also did have some other important stuff to do. I'll be in California for a week now, have a job interview there (getting to this point was one of the things that kept me busy). When this is done and I'm back, the UWRs will have top priority. Sorry for the delay.
joey
Member
That70sShowDude
Veteran
BUMP!!!
TheCubeMaster5000
Veteran
speedcubing.com/
What was the point of this post?
Toad
Premium Member
Postcount+1 tbh.
TheCubeMaster5000
Veteran
UWR website.
Learn to read.
Stefan
Legend
I know, sorry. I just have a huge mental block, being somewhat scared to undertake big important things, instead doing small stupid stuff. I'll leave for US Nationals tomorrow, when I'm back I'll have someone help me, and I'll give frequent status updates for this and my other cube projects.
That70sShowDude
Veteran
rahulkadukar
Veteran
No offense to anyone but I think the V8 will be released before a UWR site comes up. I am on a 2 week vacation and have simply nothing to do, so I am planning to make a clone of the WCA website with some minor adjustments.
1. The table for competitions will not be required as we are submitting personal times and there is no competition
2. Allow users to add a Event Type and the format.
3. The Event Type and the formats get approved as we do not want to see events like 7x7x7 Average of 10000
4. Allow individuals to post times along with proof which can be moderated by a group of people.
5. I don't think real time update is an option as the load on the server would be enormous (and I am thinking of a free hosting site), what can be done is a manual update every say 2 days wherein I can generate all the selections that can possibly be made on my Home PC and then place those static HTML files on the web server.
I will have a demo running by EOD tomorrow.
1. The table for competitions will not be required as we are submitting personal times and there is no competition
2. Allow users to add a Event Type and the format.
3. The Event Type and the formats get approved as we do not want to see events like 7x7x7 Average of 10000
4. Allow individuals to post times along with proof which can be moderated by a group of people.
5. I don't think real time update is an option as the load on the server would be enormous (and I am thinking of a free hosting site), what can be done is a manual update every say 2 days wherein I can generate all the selections that can possibly be made on my Home PC and then place those static HTML files on the web server.
I will have a demo running by EOD tomorrow.
Stefan
Legend
No way.
Sorry again it's taking so long. But at least I prepared a little preview now. I have more than that, but it's under development (mainly working on the data now). Anyway, the preview already has what I consider the two main new features: summary views and user views. There are of course still the old lists, for example 5x5x5 onehanded single.
The new summary views show top records of different such lists that have something in common (puzzle/category/type). For example:
3x3x3 average records
blindsolving single records
single records
3x3x3 records
Navigate around with the choices at the top and the links in the tables.
The new user views show the records of one user. Simple list in this preview, this will of course become a lot more structured and pretty.
http://stefan-pochmann.info/uwr2/?usr=426
http://stefan-pochmann.info/uwr2/?usr=666
If Ron wants, we can keep the old top menu and its group pages, possibly enhancing them with records. Gotta talk with Ron about that and other stuff.
The entry page, where no puzzle/category/type is selected yet, also contains some information:
http://stefan-pochmann.info/uwr2/
Last edited:
That70sShowDude
Veteran
Noice
kinch2002
Premium Member
Could you have it so that once you select a puzzle from the drop-down, the second menu would then change, so that only suitable categories could be clicked on. For example, I can still try to view the gigaminx 'executing all PLLs' average of 100 records, even though they clearly don't exist.
Awesome that they'll finally be going again soon
Awesome that they'll finally be going again soon
Stefan
Legend
Problem is, you might want to break out, go to a view where you need two or three changes. And if I take away routes, you might not get there so easily. But I might mark the options somehow so you can see which lead to non-empty sets. Thanks for the suggestion.
Similar threads
