Skip to content

Instantly share code, notes, and snippets.

View garvinhicking's full-sized avatar

Garvin Hicking garvinhicking

View GitHub Profile
@garvinhicking
garvinhicking / gist:7823333
Created December 6, 2013 12:57
Quick and dirty IMDB comparison
<?php
$myself = 'garvin';
$compare = 'andih';
# Usage:
# - wget a URL like this:
# http://www.imdb.com/list/export?list_id=ratings&author_id=ur0555872 (garvin)
# - save it as imdb_ratings_XXX.csv (see below when it gets called)
# - do the same with the CSV of the second user you want to compare with
# - enter the proper user names/file names at the bottom of this file
CREATE TABLE serendipity_spamblocklog (
timestamp int(10) default null,
type varchar(255),
reason text,
entry_id int(10) not null default '0',
author varchar(80),
email varchar(200),
url varchar(200),
useragent varchar(255),
ip varchar(15),