Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Fetching contributors…

Cannot retrieve contributors at this time

executable file 53 lines (48 sloc) 3.285 kb
#!/usr/bin/perl -w
# This code is a part of Slash, and is released under the GPL.
# Copyright 1997-2005 by Open Source Technology Group. See README
# and COPYING for more information, or see http://slashcode.com/.
# $Id$
# Quick script to convert the mysql data to postgresql.
# -Brian
open (FILE, $ARGV[0]) or die "Can not open original\n";
while(<FILE>) {
next if /^#/;
next if /^ /;
next if /^INSERT INTO users/;
print $_;
}
print qq|INSERT INTO users (uid,nickname,realname,passwd,matchname) VALUES (1,'Anonymous Coward','Anonymous Coward','eb399bcaca686f8609137153307eecf1','anonymouscoward');|;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,points,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,posttype,'html'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,maxcommentsize,'4096'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,hardthresh,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,clbig,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,clsmall,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,reparent,'1'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,nosigs,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,commentlimit,'100'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,commentspill,'50'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,commentsort,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,noscores,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,mode,'thread'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,threshold,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,extid,''); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,exaid,''); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,exsect,''); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,exboxes,''); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,maxstories,'30'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,noboxes,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,totalmods,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,bio,''); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,tokens,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,maillist,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,totalcomments,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,lastmmid,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,session_login,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,willing,'1'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,dfid,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,tzcode,'edt'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,noicons,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,light,'0'); |;
print qq| INSERT INTO users_param (uid, name, value) VALUES (1,mylinks,''); |;
Jump to Line
Something went wrong with that request. Please try again.