Universal Forum Archive

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

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

lookin good :]

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

...that makes v/ little sense

what link? make more sence

shush it joo

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

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) .

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.

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

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.

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

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

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

finish it tonight? lol i dont think so

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.

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*

Wow nice work!

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.

sweet