Tannerjc net

Recovered from the older tannerjc.net wiki snapshot dated January 23, 2016.

main page

• http://net.tutsplus.com/tutorials/html-css-techniques/html-5-and-css-3-the-techniques-youll-soon-be-using/
• http://www.color-hex.com/color/1f8a68

wordpress

nowiki WordPress will be installed to http://www.tannerjc.net/blog/ within 10 minutes (using your tannerjc_net_1 database).

You will then receive an email from us with final instructions to configure your new software. Thanks, The Happy DreamHost 1-Click Robot! /nowiki

nowiki Success! WordPress has been installed. Were you expecting more steps? Sorry to disappoint.

Username jtanner Password Your chosen password. /nowiki

zenphoto

http://simbul.bzaar.net/zenphotopress/

ssh tannerjc@tannerjc.net
cd tannerjc.net
mkdir filestore
cd filestore
wget http://zenphoto.googlecode.com/files/zenphoto-1.3.1.2.tar.gz
gunzip zenphoto-1.3.1.2.tar.gz
cd ..
tar xvf zenphoto-1.3.1.2.tar

http://tannerjc.net/blog/wp-admin/

mediawiki

mediawiki admin

• anti-spam http://www.mediawiki.org/wiki/Anti-spam_feature

• database connection

ssh user@tannerjc.net
mysql -h mysql.tannerjc.net -p
use tannerjc_net
show tables

• users with integers in their name

select user_id,user_name from user where user_name REGEXP[0-9];

• delete users with integers in their name

delete from user where user_name REGEXP [0-9];

• delete a range of user_ids

delete from user where user_id BETWEEN 33 and 132;

• new pages

select page_id,page_title from page order by page_id;

• delete pages

delete from page where page_id = '213';