Universal Stats Development

leigon · Post by **leigon** » Fri Mar 18, 2005 1:39 pm

Lets play a game... spot the error

Now this shouldent happen cause I use the same values to create the tables

maby the server is Dyslexic

leigon · Post by **leigon** » Fri Mar 25, 2005 7:21 pm

Ok I fixed it and got the an old stats.txt to test it... so far its looking promicing

And the site is a LOT faster

http://www.theuniversalstats.com/worlds ... d=7&pnum=0

Post by **Mit** » Fri Mar 25, 2005 8:15 pm

lookin good :]

Techboy · Post by **Techboy** » Fri Mar 25, 2005 10:41 pm

nice.
maybe you could have the link disappar when you're on the right page

...that makes v/ little sense

leigon · Post by **leigon** » Sat Mar 26, 2005 12:02 am

what link? make more sence

Techboy · Post by **Techboy** » Sat Mar 26, 2005 12:08 am

shush it joo

Technel · Post by **Technel** » Sat Mar 26, 2005 12:34 am

Hey legion,

I am curious as to how you made the system, and with what? It looks like phpMyAdmin on your screenshot there (MySQL). I know PHP and MySQL, and now I am starting on C (which I eventually want to develop into C++), and I am just curious as to how you made this system and how it fetches the stats?

Looks really cool,

- Tech

leigon · Post by **leigon** » Sat Mar 26, 2005 1:03 am

The whole site is php based...
It takes the stats from a txt exported from the world.exe... This txt eather uploaded (with the world.exe) directly to the site or is hosted on the atualy machen itself and linked to.

The CORE of the site checks these txt's every 1 hour, if anything is diffrent it converts the txt to mysql data. I can't tell you much about the core itself cause I put a lot of work into this and don't want anyone 'nabbing it'

Anyhow the system is going to cheg the pages changed every hour as well... co ensiding with the mysql updates...

This not only saves on bandwith but will increase page load time for normal 56k users.
These pages can also be inported (blank with a css) into other peoples websites.

All and all I am desiging it so no more software is needed for the world hoster to run, its going to be fast, fully dynamic, and easy to use.

I personaly just finshed a BETC National, and to tell you the trough you will be better "skipping" ahead into C++... work on that for a bit then look at C#... (the other way round gave me a lot of headakes)

.

leigon · Post by **leigon** » Sat Mar 26, 2005 3:48 am

Ime off to bed now... but I got most of the players section done

Check it out and also try clicking on a player name... I still have to finish it but you get the genaral idea.

leigon · Post by **leigon** » Sat Mar 26, 2005 3:50 pm

the above url don't work now... the new one is http://www.theuniversalstats.com/worldstats/?wid=7

Post by **Mit** » Sat Mar 26, 2005 5:19 pm

melikes the sort

all seems nice n responsive too.

..lil feature request :].. can we have a checkbox for 'exclude dead ppl from list' so u can easily see who's the richest alive etc.

Technel · Post by **Technel** » Sat Mar 26, 2005 5:29 pm

leigon wrote:The whole site is php based...
It takes the stats from a txt exported from the world.exe... This txt eather uploaded (with the world.exe) directly to the site or is hosted on the atualy machen itself and linked to.

The CORE of the site checks these txt's every 1 hour, if anything is diffrent it converts the txt to mysql data. I can't tell you much about the core itself cause I put a lot of work into this and don't want anyone 'nabbing it'

Anyhow the system is going to cheg the pages changed every hour as well... co ensiding with the mysql updates...

This not only saves on bandwith but will increase page load time for normal 56k users.
These pages can also be inported (blank with a css) into other peoples websites.

All and all I am desiging it so no more software is needed for the world hoster to run, its going to be fast, fully dynamic, and easy to use.

I personaly just finshed a BETC National, and to tell you the trough you will be better "skipping" ahead into C++... work on that for a bit then look at C#... (the other way round gave me a lot of headakes) .

Alright, cool. Good luck on finishing it up

leigon · Post by **leigon** » Sat Mar 26, 2005 9:36 pm

Mit wrote:..lil feature request :].. can we have a checkbox for 'exclude dead ppl from list' so u can easily see who's the richest alive etc.

Yep this is in my to do list... with a very big X nexto it

Ile finish it tonight ;P

Techboy · Post by **Techboy** » Sun Mar 27, 2005 1:56 am

on msn leig wrote:Leigon says:
I FEEL DIZY MY HEAD IS SPINNING

finish it tonight? lol i dont think so

leigon · Post by **leigon** » Sun Mar 27, 2005 3:26 pm

its not that simple... you have to be registerd first.

Once your name is on: http://www.theuniversal.net/worldpage.php follow the guide in the world owners section.

leigon · Post by **leigon** » Fri Apr 01, 2005 4:45 am

Done

Took a lot of work but to stop the url getting too messy I have added a binary system for options.

&hide=100100011

This allows the code to run faster and the url to still be linkable for post topics and msn convo's etc

.

The following link is an example of what the code now does

http://www.theuniversalstats.com/worlds ... id=2&aid=1

I have also added user profiles... As you can see its not finished (won't be till finish the building list) but you get the idea what ime up 2

http://www.theuniversalstats.com/worlds ... 7&playid=2

oh ya just so you are wondering what all these options on the url's stand for (like you would

)...

../worldstats/?pid=*page id*&wid=*world id*&sid=*sort by id*&aid=*sort by assending/desending flag*

252-rer · Post by **252-rer** » Fri Apr 01, 2005 5:33 am

Wow nice work!

leigon · Post by **leigon** » Thu May 12, 2005 7:39 am

I am adding a new map system.

p.s. Note to mit "Please activate php files as images" Or at least from autherised servers

Above is an example of the script, hopefully I will be able to make it work on all worlds and be able to size the image by adding an extra &x=100&y=100 for faster loading as a thumbnail or normal sized. I am also trying to make it use an on click function so you can zoom into arias that are crouded.

Post by **Mit** » Thu May 12, 2005 8:57 am

sweet