ENIGMA Forums

General fluff => Announcements => Topic started by: Josh @ Dreamland on August 17, 2011, 02:28:07 am

Title: New Hardware
Post by: Josh @ Dreamland on August 17, 2011, 02:28:07 am
In case you missed that MASSIVE fifteen minute downtime (longest fifteen minutes I've ever waited patiently through as CPanel did all the work)... *cough*


Let's try this over. Hello, everyone! We're on new hardware.

Everyone give a big thanks to the following:
= IsmAvatar for forking over half the price of the server
= Gary for installing the gobs of software we apparently depend on
= a2h for debugging his CSS and apparent dependency on the aforementioned software
= And of course, me, for my expedient remedy of all other aspects of this migration

Now you should be able to click a fucking wiki link without sixteen minutes of latency.
Enjoy.

@a2h: these fonts are oversized and hideous. Please fix them.
Title: Re: New Hardware
Post by: polygone on August 17, 2011, 06:07:42 am
Thank god, it was getting very bad before and would have likely pushed away new people visiting the site. We should really thank you and ism extra though since you're paying for it :]

Hopefully it should hold together now, right?
Title: Re: New Hardware
Post by: TheExDeus on August 17, 2011, 06:36:45 am
Great. I also thank Ism and Josh for this (and Gary and a2h).

On a related note: Is there a way I could get to wiki's sql? I don't want to modify anything, but I am trying to create a manual type of thing and what I do now is get the whole page and just cut out the article. It would be a lot faster, less bandwidth intensive and easier if I could get the article from the database at the first place. Maybe some read only account could be made (is there even such a thing)?
Title: Re: New Hardware
Post by: notachair on August 17, 2011, 06:53:54 am
Fixed the font stuff! Was a minor error in the asset serving script.
Title: Re: New Hardware
Post by: TheExDeus on August 17, 2011, 07:02:58 am
I didn't notice anything, but I wasn't looking for anything either.
Title: Re: New Hardware
Post by: notachair on August 17, 2011, 07:10:12 am
I didn't notice anything, but I wasn't looking for anything either.

It's because my asset thingo tells your browser to cache the stylesheet for a bit =P
Title: Re: New Hardware
Post by: daz on August 17, 2011, 09:24:11 am
So far, it's so much faster  :v:
Title: Re: New Hardware
Post by: Josh @ Dreamland on August 17, 2011, 09:45:53 am
And you'll be hearing about it if this thing ever slows down, daz. Since you recommended it to us, you are implicitly liable for any and all bitching.
Title: Re: New Hardware
Post by: IsmAvatar on August 17, 2011, 01:37:58 pm
Great. I also thank Ism and Josh for this (and Gary and a2h).

On a related note: Is there a way I could get to wiki's sql? I don't want to modify anything, but I am trying to create a manual type of thing and what I do now is get the whole page and just cut out the article. It would be a lot faster, less bandwidth intensive and easier if I could get the article from the database at the first place. Maybe some read only account could be made (is there even such a thing)?

Consider using the wiki's bot API. It won't get you direct access to the mysql, but it will bypass the parser that generates the html for the page.
http://enigma-dev.org/docs/wiki/api.php?action=query&prop=revisions&rvprop=content&rvlimit=1&format=xml&titles=<<PageTitleGoesHere>>
Title: Re: New Hardware
Post by: TheExDeus on August 17, 2011, 05:10:23 pm
Quote
Consider using the wiki's bot API. It won't get you direct access to the mysql, but it will bypass the parser that generates the html for the page.
http://enigma-dev.org/docs/wiki/api.php?action=query&prop=revisions&rvprop=content&rvlimit=1&format=xml&titles=<<PageTitleGoesHere>>
Thank you. I will look into this. Looks promising. Though it seems that I will somehow need to get formatting back.

edit: Who would of taught.. after several hours of checking the API and looking into ways to parse wikitext markup I came up on this:
"http://enigma-dev.org/docs/wiki/index.php?title=<<PageTitleGoesHere>>&action=render"
That returns just what I need.
Title: Re: New Hardware
Post by: kkg on August 20, 2011, 11:52:54 am
Awesome news, I got sick of literally being able to fetch a beverage whilst waiting for a page to load.
Ta for paying for the site, guys ^_^