I want to make a crawl monster database...


If you are interested in helping with tiles, vaults, patches or documentation, this is the place for that.

Crypt Cleanser

Posts: 714

Joined: Tuesday, 29th November 2011, 11:04

Post Tuesday, 3rd March 2015, 07:41

I want to make a crawl monster database...

And don't really know where to start. I mean, I know how to code and know SQL, but I don't know much about how client-servers work. I would like to make a simple website in plain html, where you can sort entries by their MR, AC etc. but I never did anything internet related and I'm somewhat confused.
Can someone guide me (where should I put it, what server software could I use) or point me to resource about it?
"Damned, damned be the legions of the damned..."

Ziggurat Zagger

Posts: 5728

Joined: Tuesday, 30th October 2012, 19:06

Post Tuesday, 3rd March 2015, 16:57

Re: I want to make a crawl monster database...

Well, you imply that you want to store the monster data in a database (This is done already BTW, see https://lookupdb.guy.ht/ for someone who implemented it as a search page) but then say you want it "in plain html" the two statements are a little contradictory, plain HTML has everything the browser needs to display the page in one file, which is downloaded to the browser, typically if you want to access an external database you'll need to use a higher-level scripting language of some sort (like PHP)

So first you need to learn how to get a server and install a web server application on it, there's plenty of free/cheap webservers around use google (I used 000webhost for a free website when I wanted a place to put an example on http://colorclock.freeiz.com/ it adds interstatial ads to your website (so on-load pop ups) but it's free)

Then you need to learn how to write HTML, I recommend w3schools, although there's plenty of other options.

If you're just looking to statically embed everything in the page (I don't recommend that, it'd make loading the page really slow and annoying) you can do all that in HTML, if you want to make the page *do* things in the browser you also need to learn javascript (again you can use w3schools for that)

If you want to pull data from a database and place it *in* the web page, you'll need to learn a scripting language, for example PHP would work and is probably the type of code that 30-40% of the internet uses for this purpose right now, although there's a lot of other options.

If you want to have the website display some data, and have it be able to *update* that data without re-loading the whole page, you'll need to use AJAX (which is actually just a specific subset of javascript, along with some server code of some sort to get the data and send it back to the client) again you can use w3schools (or your learning resource of your choice for that)
Spoiler: show
This high quality signature has been hidden for your protection. To unlock it's secret, send 3 easy payments of $9.99 to me, by way of your nearest theta band or ley line. Complete your transmission by midnight tonight for a special free gift!

Vaults Vanquisher

Posts: 428

Joined: Friday, 17th December 2010, 22:07

Post Tuesday, 3rd March 2015, 22:39

Re: I want to make a crawl monster database...

I'm guessing there are no more than 1000 critters in the game, if if you put those into a json record, it shouldn't be too bad.

Once that record is cached on the client, lookups by a given property should be relatively quick, and dynamically loading those records in a table should render in no more than a couple of seconds, even shorter if you only load the first n records.

The real challenge is keeping that initial date up-to-date with the game, since the monsters are stored in code. If there's a raw data file out there that can be updated every day or so via cron on the server-side, it should be pretty doable.

Return to Contributions

Who is online

Users browsing this forum: No registered users and 1 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by ST Software for PTF.