• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

** Stats are Updated!! ** Team Anandtech United Devices Statistics Page

C

CyGoR

Platinum Member
Hi fellow UD users,

In the past few days I started working on a stats page for UD because I couldn't find one..
There are ofcourse the stats pages for all the users, but you can only see your own.
And because we are a Team we, ofcourse, want to know how we are doing against other Team mates...
The page I created gets all the stats from the UD page and compares it to the stats from the day before.
I keep all stats in a database, so there will be weekly stats, maybe estimate times before you advance a spot etc etc..

The page isn't online as of now, but I did save it as an html file and put it up right HERE
These are the stats for today, and it isn't dynamic, so tomorrow it won't update.. I will be having my own webspace but php isn't installed yet
so I have to be patient..

* The page is in its very early development stage!! There is very much more to come!! *
* You cannot sort on Results yet, I'm almost done with that.. 😉 *

I created this topic also for you to ask questions and give me advice. My home language isn't Englisch, so when the page will be updated and there are some spelling faults, please tell me about it!! 🙂

I've written the page 100% myself and is fully written in Notepad. I'm using PHP for the page displaying the stats and Perl scripts to get the stats from the UD page. Do not look at the colors (I know, it doesn't look good..😉) but when the page is final and up and running I'll ask for anyone to make me a nice style sheet 🙂

The pages will also be shifted so there will be 100 users at every page. The page is rather large so I think that's really necessary..
I just hope that you'll like the page or my effort creating it 😉
If not, well. I have a nice stats page for myself 😛
 
Cool !!!

Good work that man..

A side effect of this will be increased production.... You know how we all love stats....

mmmmm stats.....

🙂

Col
 
Looks good CyGoR-

A worthy project like UD deserves a good stat page. I didn't realize how many people participated in UD for TA.
 
:Q reply's!! 😀

Well, I've been coding a bit and here's an update... Unfortunatly it's only a screenshot. I won't save all the pages to html and put them online, but I will update the stats page tomorrow, so that will work..
The new screenshot can be found HERE .
Updates are: pages are divided by 100. records in the database are checked so when loads of members join the links will automatically update 🙂
New style, the links to the pages weren't visible.. (Note: I did the style in a minute, it's not final😉)
Sorting by Results is now done, as you can see in the screenshot...
Thanks guys!
 
Looks great Cygor! Glad to see you're making progress on this project.

It definitely gives the stat junkies a bit more incentive to maybe add themselves to the team since I know that's a big complaint of a lot of the people here since they like to see how they're doing relative to others on the team.

Keep us posted on the progress. Once you get that thing live I'm going to add it to my sig line (every little bit helps - I still get PMs every now and then from new members who spotted my sig line. If enough of us do it it'll eventually add up.)
 
If there is anything I can do to help you let me know, I could add things like allowing users to select how many results are returned per page, and searching for a user by name.

How do you have the MySQL setup? Do you poll the website at certain intervals and update the info in MySQL or do you check the website and parse out the info each time a user connects?

Anyhow, let me know if theres anything I can help with, PHP/MySQL is my forte and if I could lend anyhelp or give you any examples to go by, feel free to ask.
 
I now still need to manually run a perl script to extract the numbers from the UD page. This is done once a day since that's how many times the stats page is updated. The Perl script is writing it's data in a few text files. After that I run a php file which inserts the data in the MySQL database. It reads the data from the text files (using arrays). But because I'm a bit new to programming php and using MySQL I use two tables, one to sort for Points and another one to sort on Results. If you go to the team page you can also sort on those things.. Between now and the final stats page there will be many totall refreshments of everything 🙂 Why? well, this is really my first internet page I made... So I'm still experimenting. But everything is still going like I want it to.. I will make a list of things that need to be done. I'll post that later on today (combine it with a bump 😛) and you can add what ever you like to that list. And if I don't have any idea about how to solve that, Balthasar might jump in and save me 😉

--Another thing, it might also be usefull to other teams. I only need to change the URL from where the perl scripts get their info and you'd have another stats page for a different team 🙂
Thanks again!!
 
You know, a quick and easy way around the whole "manual run" thing would be to have a text file containing a single line, start it out with the current date and each time the page is loaded have it check that files contents, compare it to todays date and if its not the same, then have the script run the PERL script and get the new results, then update the value in the folder to the current date. If it checks that file and sees the current date it goes on about it's business.

Also if you give me a copy of your PERL file I am sure I could convert that over to PHP for you, make it ALOT easier to mesh the two together.

🙂
 
Ok, I'll send you the perl file... Can I send them to your e-mail adress?
Could you be so kind to put some comment in it so that I can also learn from you? 😉
I'll merge all the php files together myself.. You will ofcourse get to see the final result which probably can be made 50% smaller 😉
 
Todays stats are already updated in the new style. The top links aren't working for the page numbers, because then I had to save all the pages in html and edit all the links.. 🙂
These pages are just for the stats and are still not final!
You can find them sorted at Points Here
And sorted at Results can be found Here
Didn't have any time to do other updates..
 
If you get bored, you may want to consider modifying your sorts so that users with the same points or results get the same rank. I've found that users tend to appreciate that, although it might make things confusing for people if you break your table into separate pages.

I am doing that when I calculate the team rankings for the SETI project, but will eventually do it for any project in which I download all team data (which would be all of them if I had the time, but currently just SETI and Evolution@home, because I have no choice).
 
Thanks Insidious and thanks MereMortal for the advice..
But I haven't seen much stats pages where there are people sharing ranks. And I do know how to do it but I'm not sure if I want to 😉

There won't be any stats today, I'm sorry but the database for yesterday is still at work so I don't have anything to compare with..
And I'm so glad it's weekend, finally spending some ours away from the pc 😉
I'll continue my devep on monday and then the stats will also be updated..

I still have a few nice things to add in my mind, you'll see that soon!
Btw, in the html files put online you can see that some users have in the "username" area the whole URL. That's because it's saved as an html file, when it's online on php this "bug" is gone..

Thanks again for the support.. 🙂
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top