This website is now dead. I have my own server and I will at some point soon remove this totally. My new stuff will be at think.textdriven.com until I get a domain. I don't think anyone really read this anyway :) but I thoiught I'd post just incase.
I only just realised what time it is. I should go home and Salsa! Anyway I was only going to post to offer gmail invites in case anyone wants em. I didn't even notice I had them until just now :)
I didnt' realise people have actually been reading my blog (I guess I knew that kinda but still) Anyway I know it's been almost a month since they commented but you never know
Well I'v e nev er been very good at anything regfular so updates have been very sparse. Since I last updated I have
I suggested to my mum she should have a look at Amazon.com: Creating a Web Page with HTML : Visual QuickProject Guide (Visual Quickproject Series) as suggested by Zeldman and she came back with this:
I ordered what looks like the next one up...has sections on style sheets....it seems idiot guides etc don't expect mums to be fiddling about with style sheets....I looked at one link from the last site you recommended and was informed that obviously, since I was reading this page, I wasn't going to be a mum, I was going to be selling something :)
But then most mums don't seem to have sons who know what their mums ought to be doing.
I've actually been very remiss about updates. Totally ignoring a very random weekend in manchester, a tragic friday rthat went totally wrong and well a wednesday not that dissimiliar (oh and a friday again bu t that makes the update) but I have two recent things I feel like sharing.
I just watched Bruce almighty. Wasn't bad wasn't thaqt great. Light entertainment and Carrey was quite funny in his wacky way. However it had two great little bits.
Can I ask you about free will?to which God replies
Yes you can, that's the beauty of it. Brilliant and when Morgan Freeman says it I can almost give it credibility.
Are you two letting down tyres?
No
Are you sure?
Yes honest.
Are you sure?
Yes, We weren't I promise!
Right
Shaun Inmans rather spiffy shortstats has always looked nice to me but until lately I coudln't run it as I don't use MySQL. So I hacked it and with Shaun's permission here is a guide how.
$SI_db['con'] = 0; to the database section to provide a connection resource for all your PostgreSQL actions.$SI_db['con'] and pg_query so the code reads if (@ pg_query($SI_db['con'],"SELECT * FROM $SI_tables[stats]") && @ pg_query($SI_db['con'],"SELECT * FROM $SI_tables[searchterms]"))
$query = "CREATE TABLE ".$SI_tables['stats']." (
id SERIAL,
remote_ip varchar(15) NOT NULL,
country varchar(50) NOT NULL,
domain varchar(255) NOT NULL,
referer varchar(255) NOT NULL,
resource varchar(255) NOT NULL,
user_agent varchar(255) NOT NULL,
platform varchar(50) NOT NULL,
browser varchar(50) NOT NULL,
version varchar(15) NOT NULL,
dt int4 NOT NULL default '0',
PRIMARY KEY (\"id\")
)";
$query_search = "CREATE TABLE $SI_tables[searchterms] (
id SERIAL,
searchterms varchar(255) NOT NULL,
count int4 NOT NULL default '0',
PRIMARY KEY (id)
)";
$r1 = @ pg_query($SI_db['con'],$query);
$r2 = @ pg_query($SI_db['con'],$query_search);
if ($r1 && $r2)
pg_query($SI_db['con'],$query); using our database connection and PostgreSQL.SI_pconnect() needs a PostreSQL connection string like$SI_db['con'] =@ pg_connect("host=".$SI_db['server']." user=".$SI_db['username']." password=".$SI_db['password']." dbname=".$SI_db['database']); and you can replace the logic after with if ($SI_db['con'] = 0) die($horribly); mysql_query($query); calls and have them replaced with pg_query($SI_db['con'],$query); as well as adding global $SI_db; at the start of every single function.SI_getDomains()
SELECT
domain,
referer,
COUNT(*) AS total,
MAX(dt) as last_access
FROM
$SI_tables[stats]
WHERE
domain !='".
SI_trimReferer($_SERVER['SERVER_NAME'])."'
AND
domain!=''
GROUP BY
domain,referer
ORDER BY
total DESC,
last_access DESC
