Database Design

[revlimiter]

Check out this database design:
One-Handed Axes - Items - Wowhead

What I love about it is how fast it loads.. You can sort each column by name, bunch of game stats.. I'm not after the game itself, but the technology used. Does anybody know for certain how it was put together and if it would be easy to replicate?

Thanks!

 

[illusion]

Just learn a bit of the AJAX and then implement it with the mysql commands such as ORDER BY desc/asc

Check out the member list of vBulletin, they got the same except it is not AJAX just normal PHP, just replicate that

 

[revlimiter]

Thanks for the tip, illusion. But I can't say I like the normal PHP sort order as much..

What I like the most about the AJAX system is the mouse-over color (on the entire row) and the JavaScript box mouse-over. I'm thinking I will change the design but include an iStockPhoto type effect where the rollover displays an image but follows the cursor.
iStockPhoto.com example

Anyways, probably a lot easier said than done. Can anybody lead me in the right direction? I am hoping to find a "kit" that will let me re-create this And then I can work from there...

 

[Stanley]

Just learn a bit of the AJAX and then implement it with the mysql commands such as ORDER BY desc/asc

Check out the member list of vBulletin, they got the same except it is not AJAX just normal PHP, just replicate that

actually to get that instant Order By stuff to work you need to learn XSL, which is a bit more difficult than the common xmlhttprequest protocol

 

[waz67]

Couldn't you just load the data into an array of javascript objects, and then sort and update the page via javascript as necessary?

 

[Stanley]

Couldn't you just load the data into an array of javascript objects, and then sort and update the page via javascript as necessary?

that's XSL, as far as I understand.

Any .NET or C# developers in here?

 

[dvsf]

Couldn't you just load the data into an array of javascript objects, and then sort and update the page via javascript as necessary?

Unless the data needs to be up-to-the-second realtime, just do one query, then as you said... sort the data out via javascript. Use Ajax for additional updates/queries.

Couple of Examples...

sorttable: Make all your tables sortable

JavaScript Toolbox - Sortable Table

if you can, write it yourself. I'd steer clear of using a big library that will do it for you (ActiveWidgets, etc). You'll end up forcing your users to download a 200 kb javascript library to view one dataset.


From personal experience, learn JSON formatting, it will make the process of formatting your ajax/server data a lot smoother.

JSON-PHP Pear Class = amazing time saver

JSON Formatting (can be tricky, but worth it. watch those double quotes)


Same goes for ASP or any other server-side lang.
cheers, and best of luck.