Choose Your Theme
Warren Shea

Archive for February, 2013

Cost Co.

Thursday, February 28th, 2013 at 9:13 pm


Sorry everyone. My blog’s a good reference site. So here is something Z and I wanted to post (for our reference).
Gonna compare these prices with other places…

worldofwarren – CSS & PNGs optimized…sorta

Wednesday, February 27th, 2013 at 11:38 am

So when I built worldofwarren.com, I thought it’d be a great idea to use 1 CSS file (in PHP), and pass the theme as a parameter into the “css” file via querystring and have the php figure out what to output. I guess the + side is that the php would do server-side compilation of the code. So I thought maybe it was faster. Also, I’d only have to maintain 1 css file and I wouldn’t have that much css duplication in the php file because styles that could apply to 2 themes could go under the same if statement.

But…I realized…that was probably incorrect, in terms of optimization. Because each time a user requested the “css” file, the server would have to serve up different php compiled code, based on the querystring. I don’t think such a file can be cached as well (can php be cached? it likely changes all the time…)…and cache without the need for server-side code is probably the fastest method to achieve quick load times.

So I’ve created separate CSS files, 1 for each theme, to improve load.


I’ve also re-optimized my PNGs. Someone told me about a site, http://tinypng.org/ that greatly reduces PNG size, while keeping the quality relatively similar. I’ve cut down the images on warrenshea.com from 6MB to 2MB. It was like shopping at a closing Zellers: HUGE SAVINGS!

I guess I’m learning more and more about the web and thought it’d be good to apply these optimization methods to my sites. One of my interview questions is “How would you optimize page load of a site” so if anyone ever asks me that, I not only want to be prepared, I want practical experience!

I’ve also been doing quite a bit of photography lately. I’m at 13/43 statues. From 1/8 to 1/3 done :) I’m getting there…

(Almost) all my sites are migrated!

Friday, February 22nd, 2013 at 12:25 am

(mt) = Media Temple

Decided to combine everything into one compact email for reference purposes. I may need to remember the stuff I’ve done here…so good to document it all.

horderockcafe.com
Migrated domain to (mt), migrated content to (mt), changed nameservers to (mt), recoded to PHP

warrenshea.com
Migrated domain (pending due to domain transfer lockout), migrated content to (mt), changed nameservers to (mt)

seasaltfishandchips.com
Migrated domain to (mt), migrated content to (mt), backed up WordPress/mySQL DB from IXWebhosting, restored WordPress/mySQL DB on (mt), editing WordPress Config File, changed nameservers to (mt)

kotobishoujo.com
Migrated domain to (mt), migrated content to (mt), backed up WordPress/mySQL DB from IXWebhosting, restored WordPress/mySQL DB on (mt), editing WordPress Config File, changed nameservers to (mt)
kotobishoujo.com Post Migration: many pages didn’t work due to how my 404/permalinks is set up.
Thankfully, I made my own post: Tutorial: Setting up WordPress permalinks without index.php on IIS server which reminded me what I had done. I had to replicate my changes but rather than use IIS/CMS, I used the .htaccess file
# BEGIN WordPress

RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]

# END WordPress

worldofwarren.com
Migrated domain to (mt), migrated content to (mt), backed up WordPress/mySQL DB from IXWebhosting, restored WordPress/mySQL DB on (mt), editing WordPress Config File, changed nameservers to (mt)

mySQL Backup
For all backup purposes, I used phpMyAdmin to back up the SQL to a .sql file.
To restore the file, I used BigDump which is a script that runs your .sql file (because you can’t upload a .sql file over 10MB) and creates everything. I did run into an error: It failed due to 3000+ lines of commands. To fix this, I simply changed
define (‘MAX_QUERY_LINES’,300);
to
define (‘MAX_QUERY_LINES’,999999);
Not sure if that’s the “best” way to fix it, but it worked. So I’m happy!

And I wrote all this for next time…so I remember :)

Hopefully the migration went well. I still have to test/debug and check everything. Probably be a couple days of fixing things…

warrenshea.com – Migrated!

Thursday, February 21st, 2013 at 5:53 pm

2 websites (horderockcafe.com & warrenshea.com) migrated. 3 to go…all the others, seasaltfishandchips.com, kotobishoujo.com, worldofwarren.com, have wordpress on them.

So they need a mySQL database export…and import. I’ve only done that once so far…but I’m sure by the end of the night (if I do it tonight) and do all 3, I’ll be proz.

That is all. The new server seems awesomes so far.


EDIT 6:45PM : seasaltfishandchips.com has been migrated !
Only kotobishoujo.com, worldofwarren.com left!

HordeRockCafe.com updates!

Wednesday, February 20th, 2013 at 3:26 pm

LULUL touched this site like, 2 times in 7 years.

Recoded ASPX to PHP

horderockcafe.com

It’s crazy to see the code there from 7 years ago.
TABLES EVERYWHERE.
SPACER FUNCTION EVERYWHERE.
INLINE CSS EVERYWHERE.
I didn’t really understand CSS at the time.