Graal Database Site

[darkslayer2004]

Hey everyone!

For some time now, ive been working on a big Graal database. In it, youll be able to find all items, weapons, armour, monsters and other info, along with the current player price.

Ive spend quite some time in it, and i feel like i can upload it now.
You can find it on www.mmorpglibrary.net

However, much needs to be done. There is still a lot more items to add, and i want the info to be as accurate as possible, and i cant do that on my own. If youre browsing the database and see an item is missing, or its info is incorrect, please contact me at [email protected] or send me a PM (Forum or ingame)

Also, please let me know what you think. Are you missing something? What info do you want to see when youre looking for an item? Let me know and ill do my best!

Thanks a lot!
Dash

[MajinDragon]

Is Bjorns old database website still operational? I forgot the address...

[darkslayer2004]

http://graal.logic-games.net/index.php?site=Home

[Tigairius]

Looks like you need a little help with the design :P

[darkslayer2004]

Ill get on the layout later, design isnt priority content is

[Twinny]

Yeah...... 'padding: 15px;' ...... seriously.

Also, too ambiguous a domain name?

[cbk1994]

Originally Posted by Tigairius

Looks like you need a little help with the design :P

?????

Looks good to me


Design could use some work, but it is good besides that. Nice work. Lots of content.

[darkslayer2004]

Ok since it does seem to be of priority, ill fix the layout...

[DraydenAlcander]

Originally Posted by darkslayer2004

Ok since it does seem to be of priority, ill fix the layout...

Good thinking, especially since if you just decided to release it, a decent layout would be helpful.

[AbsoluteMonkey]

AHH. I want your mysql export for the graal kingdoms.

[WhiteDragon]

Pagination, memcached, better queries, less joins, faster server, lighttpd.

Make it suck less.

Edit: I should probably make it clear it is a nice site, and I don't hate you as a person. :P

[darkslayer2004]

Originally Posted by WhiteDragon

Pagination, memcached, better queries, less joins, faster server, lighttpd.

Make it suck less.

Edit: I should probably make it clear it is a nice site, and I don't hate you as a person. :P

You know, this is actually the first thread which gives me some tips Ill try to get as many of these done, but ill stick with this server for some time. Rest can be done something about

Thanks

[WhiteDragon]

Originally Posted by darkslayer2004

You know, this is actually the first thread which gives me some tips Ill try to get as many of these done, but ill stick with this server for some time. Rest can be done something about

Thanks

memcached and lighttpd will be impossible to implement unless you have shell access (and linux experience).

However the queries should be able to be improved.

Edit: Post 100. =D

[darkslayer2004]

Yup i noticed today, i didnt knew what it was so i looked it up.

Pagination, Joining, Queries and lesser sucking will be taken care off as much as possible

[WhiteDragon]

Originally Posted by darkslayer2004

Yup i noticed today, i didnt knew what it was so i looked it up.

Pagination, Joining, Queries and lesser sucking will be taken care off as much as possible

1. I realized that you more or less got rid of "View All", so the pagination is already taken care of by alphabet.

2. Make sure the ids are the primary key of the table.

3. If you REALLY wanted to, you could have another column which you would set to the first letter of the weapon title and index it for way way faster lookups by letter, but it's not really necessary with your amount of data, and introduces a little hassle if you want to update the title.