create table {PREFIX}links
 (
     id INTEGER PRIMARY KEY,
       title text,
       url varchar(255),
       description text,
       rating double default '0',
       votes int default '0',
       validated tinyint(1) default '0',
       catid int default '0',
       sumofvotes int default '0',
       email text,
       time int default '0',
       hits int default '0',
       numcomments int default '0',
       hide tinyint(1) default '0',
       ownerid int default '0',
       voterips text,
       voterids text,
       lastedit int default '0',
       type text,
       notify text,
       suspect tinyint(1) default '0',
       pendingedit text,
       funds double default '0',
       suspended tinyint(1) default '0',
       alias int default '0',
       expire int default '0',
       ip text,
       inalbum tinyint(1) default '0',
       typeorder int default '0',
       recipurl text,
       hitsin int default '0',
       recipwith text,
       hitsinips text,
       hitsoutips text,
       lastcomment int default '0',
       related text,
       inhidden tinyint(1) default '0',
       viewers text,
       threadviewers text,
       hitsintemp int default '0',
       hitsouttemp int default '0',
       origtype text,
       importance double default '0',
       parentids text,
       timesdead int default '0',
       timesemailed int default '0',
       threadclosed tinyint(1) default '0',
       threadposters text,
       lastposterid int default '0',
       lastpostername varchar(255),
       ownername varchar(255),
       deleted int default '0',
       deletionreason varchar(255),
       movedto int default '0',
       deletedby int default '0',
       timevalidated int default '0',
       filefield tinyint(1) default '0',
       message text,
       sticky int default '0',
       downloads int default '0',
       pollid int default '0',
       posticon varchar(255),
       savedby text,
       validatedemail tinyint(1) default '0',
       unpaid tinyint(1) default '0',
       recipverified tinyint(1) default '0',
       effectivetime int default '0',
       sugcatid int default '0',
       pagerank int default '0',
       wysihtml tinyint(1) default '0',
       movedid int default '0',
       unrevised int default '0',
       feedurl text,
       feedcache text,
       feedcachetime int default '0');
   
   create table {PREFIX}categories
 (
     id INTEGER PRIMARY KEY,
       name text,
       parent int default '0',
       validated tinyint(1) default '0',
       description text,
       time int default '0',
       parentnames text,
       parentids text,
       numlinks int default '0',
       hide tinyint(1) default '0',
       lastlinktime int default '0',
       custom text,
       lastedit text,
       moderators text,
       headerinfo text,
       related text,
       numsub int default '0',
       type text,
       permissions text,
       subscribers text,
       subscriber text,
       mixtypes text,
       isalbum tinyint(1) default '0',
       orderlinks text,
       totalcomments int default '0',
       ulsearchmax int default '0',
       ulsearchquery text,
       ulsearchadult text,
       alias int default '0',
       catcols text,
       linkcols text,
       dmozpath text,
       sponsorlinks text,
       views int default '0',
       customwrap text,
       deleted int default '0',
       reqlinks int default '0',
       reqcoms int default '0',
       reqlinksdelay int default '0',
       priority int default '0',
       levelsdeep int default '0',
       lastposterid int default '0',
       lastpostername varchar(255),
       lastcommenttime int default '0',
       lastthreadid int default '0',
       lastthreadtitle varchar(255),
       linkshere int default '0',
       unvalidatedlinks int default '0',
       unvalidatedcomments int default '0',
       actaslink varchar(255),
       countposts text,
       subcatshtml text,
       linksperpage varchar(5),
       wysihtml tinyint(1) default '0',
       numonline int default '0');
   
   create table {PREFIX}comments
 (
     id INTEGER PRIMARY KEY,
       linkid int default '0',
       postername text,
       message text,
       time int default '0',
       linkname text,
       validated int default '0',
       ip text,
       ownerid int default '0',
       lastedit text,
       type text,
       approved int default '0',
       votes int default '0',
       hide int default '0',
       typeorder int default '0',
       lasteditby text,
       catid int default '0',
       editreason text,
       preventedit tinyint(1) default '0',
       inhidden tinyint(1) default '0',
       deleted int default '0',
       deletionreason varchar(255),
       usernoteon int default '0',
       modnote int default '0',
       filefield varchar(255),
       title varchar(255),
       deletedby int default '0',
       parentids text,
       disablesmilies int default '0',
       disablesig int default '0',
       icon varchar(255),
       disablewsn tinyint(1) default '0',
       disablehtml tinyint(1) default '0',
       originalmessage text,
       flagged int default '0',
       wysihtml tinyint(1) default '0',
       unrevised int default '0');
   
   create table {PREFIX}settings
 (
     id INTEGER PRIMARY KEY,
       name text,
       content text);
   
   create table {PREFIX}members
 (
     id INTEGER PRIMARY KEY,
       name text,
       links int default '0',
       comments int default '0',
       time int default '0',
       usergroup int default '0',
       password text,
       ip text,
       totalhits int default '0',
       totalhitsin int default '0',
       email text,
       validated tinyint(1) default '0',
       template text,
       language text,
       lastattempt text,
       allowemail text,
       signature text,
       avatarname text,
       stylesheet text,
       allowuseremail text,
       albumid int default '0',
       failedattempts int default '0',
       totalbytes int default '0',
       funds double default '0',
       notifyoflinks text,
       lastvisit int default '0',
       timezone double default '0',
       rating double default '0',
       pmfolders text,
       notifyofpms text,
       acceptpms text,
       cookieduration int default '0',
       banned text,
       location varchar(255),
       homepage varchar(255),
       occupation varchar(255),
       bio text,
       aim varchar(255),
       icq varchar(255),
       msn varchar(255),
       yahoo varchar(255),
       inactive int default '0',
       timeonline int default '0',
       totalpms int default '0',
       buddies text,
       ignored text,
       isonline int default '0',
       acceptims varchar(255),
       adminpermissions text,
       referrer int default '0',
       groupreverttime int default '0',
       grouprevertto int default '0',
       moderationpm varchar(255),
       secondarygroups text,
       linksperpage int default '0',
       commentsperpage int default '0',
       shouts int default '0',
       customtitle varchar(255),
       shoutban int default '0',
       topicbans text,
       forumbans text,
       visibility text,
       birthdate text,
       lastsession int default '0',
       interests text,
       posteditor varchar(255),
       forumaccess text,
       pmpopup int default '0',
       pmnotify varchar(255),
       modnotes int default '0',
       guestnotes int default '0',
       salt varchar(255),
       lastmodnote int default '0',
       newpms int default '0',
       imflag int default '0',
       orderalbums varchar(255),
       lastguestnote int default '0',
       autosubscribe varchar(255),
       notifymethod varchar(255),
       showavatars varchar(255),
       showsigs varchar(255),
       warninglevel int default '0',
       topics int default '0',
       posts int default '0',
       chatcolor text,
       traderrating int default '0',
       invitessent int default '0',
       validatedemail tinyint(1) default '0',
       calsub tinyint(1) default '0',
       macros text);
   
   create table {PREFIX}membergroups
 (
     id INTEGER PRIMARY KEY,
       title text,
       caneditown tinyint(1) default '0',
       caneditall tinyint(1) default '0',
       canvote tinyint(1) default '0',
       isadmin tinyint(1) default '0',
       canpost tinyint(1) default '0',
       canemail tinyint(1) default '0',
       validatecats tinyint(1) default '0',
       validatecomments tinyint(1) default '0',
       validatelinks tinyint(1) default '0',
       validateedits tinyint(1) default '0',
       cansubmitlinks tinyint(1) default '0',
       cansubmitcategories tinyint(1) default '0',
       cansubmitcomments tinyint(1) default '0',
       caneditownlinks tinyint(1) default '0',
       caneditowncategories tinyint(1) default '0',
       caneditowncomments tinyint(1) default '0',
       caneditownprofile tinyint(1) default '0',
       caneditalllinks tinyint(1) default '0',
       caneditallcategories tinyint(1) default '0',
       caneditallcomments tinyint(1) default '0',
       caneditallprofiles tinyint(1) default '0',
       candownloadfiles tinyint(1) default '0',
       canupload tinyint(1) default '0',
       canviewip tinyint(1) default '0',
       limitlinks text,
       canemailmembers tinyint(1) default '0',
       canusehtml tinyint(1) default '0',
       limitlinksdaily text,
       canalias tinyint(1) default '0',
       cancopy tinyint(1) default '0',
       candeleteown tinyint(1) default '0',
       candeleteall tinyint(1) default '0',
       candofulledit tinyint(1) default '0',
       candeletecategories tinyint(1) default '0',
       candeletecomments tinyint(1) default '0',
       candeleteowncategories tinyint(1) default '0',
       candeleteowncomments tinyint(1) default '0',
       candeletemembers tinyint(1) default '0',
       candeleteownmembers tinyint(1) default '0',
       canaliascategories tinyint(1) default '0',
       canviewpages tinyint(1) default '0',
       caneditvotes tinyint(1) default '0',
       numaliases int default '0',
       canviewvotes tinyint(1) default '0',
       canhideownlinks tinyint(1) default '0',
       canhideowncategories tinyint(1) default '0',
       canhideowncomments tinyint(1) default '0',
       canhidealllinks tinyint(1) default '0',
       canhideallcategories tinyint(1) default '0',
       canhideallcomments tinyint(1) default '0',
       canratecomments tinyint(1) default '0',
       bytespermem text,
       canpm int default '0',
       canim int default '0',
       canharddelete int default '0',
       limitpms varchar(255),
       limitpmsdaily varchar(255),
       canviewdeleted int default '0',
       cansubmitpolls int default '0',
       candeletepolls int default '0',
       candeleteownpolls int default '0',
       caneditpolls int default '0',
       caneditownpolls int default '0',
       attachperpost int default '0',
       attachperpm int default '0',
       canviewshouts int default '0',
       caneditshouts int default '0',
       caneditownshouts int default '0',
       candeleteshouts int default '0',
       candeleteownshouts int default '0',
       cansubmitshouts int default '0',
       canpollvote int default '0',
       customtitle int default '0',
       canviewinvisible int default '0',
       namestyle varchar(255),
       canpmimportant int default '0',
       canviewmodlog int default '0',
       isleader int default '0',
       cansubmitquotes int default '0',
       validatequotes int default '0',
       candeletequotes int default '0',
       candeleteownquotes int default '0',
       canreport int default '0',
       canusesearch int default '0',
       attachperlink int default '0',
       validateattachments tinyint(1) default '0',
       caneditownquotes int default '0',
       caneditallquotes int default '0',
       canviewchat int default '0',
       caneditownevents int default '0',
       caneditallevents int default '0',
       candeleteownevents int default '0',
       candeleteevents int default '0',
       cansubmitevents int default '0',
       validateevents int default '0',
       bulkpms int default '0',
       issupermod tinyint(1) default '0',
       numinv int default '0',
       allowugspec int default '0',
       validateemails tinyint(1) default '0',
       validatesponsorlinks tinyint(1) default '0');
   
   create table {PREFIX}email
 (
     id INTEGER PRIMARY KEY,
       to text,
       subject text,
       message text,
       headers text,
       timesent int default '0',
       ip text,
       replacement text,
       mime tinyint(1) default '0');
   
   create table {PREFIX}sessions
 (
     id INTEGER PRIMARY KEY,
       memberid int default '0',
       location text,
       time int default '0',
       ip text,
       browser text,
       starttime int default '0',
       catid int default '0',
       threadid int default '0',
       areaname text,
       lastsearch int default '0',
       nopermission int default '0',
       inchat tinyint(1) default '0',
       name varchar(255),
       isrobot int default '0',
       lastchat int default '0',
       groupnamestyle varchar(255),
       acceptims varchar(255),
       visibility varchar(255));
   
   create table {PREFIX}ratings
 (
     id INTEGER PRIMARY KEY,
       votevalue int default '0',
       time int default '0',
       memberid int default '0',
       ip text,
       custom text,
       linkid int default '0',
       type varchar(20));
   
   create table {PREFIX}switches
 (
     id INTEGER PRIMARY KEY,
       name text,
       value tinyint(1) default '0');
   
   create table {PREFIX}markup
 (
     id INTEGER PRIMARY KEY,
       type varchar(255),
       original text,
       replacement text,
       description text,
       originalclose text,
       replacementclose text,
       sortorder int default '0');
   
   create table {PREFIX}modlog
 (
     id INTEGER PRIMARY KEY,
       topicid int default '0',
       postid int default '0',
       type varchar(255),
       nature varchar(255),
       reason text,
       moderatorid int default '0',
       source int default '0',
       destination int default '0',
       time int default '0',
       catid int default '0',
       memberid int default '0');
   
   create table {PREFIX}attachments
 (
     id INTEGER PRIMARY KEY,
       type varchar(255),
       objectid int default '0',
       filename varchar(255),
       filetitle varchar(255),
       filesize int default '0',
       width int default '0',
       height int default '0',
       memberid int default '0',
       time int default '0',
       deleted tinyint(1) default '0',
       field varchar(255),
       downloads int default '0',
       validated tinyint(1) default '0',
       ownerip varchar(20),
       catid int default '0');
   
   create table {PREFIX}helpcategory
 (
     id INTEGER PRIMARY KEY,
       name varchar(255),
       numsubjects int default '0',
       priority int default '0');
   
   create table {PREFIX}helpitem
 (
     id INTEGER PRIMARY KEY,
       subject varchar(255),
       helptext text,
       priority int default '0',
       category int default '0');
   
   create table {PREFIX}crons
 (
     id INTEGER PRIMARY KEY,
       frequency int default '0',
       nextrun int default '0',
       filename varchar(255),
       native tinyint(1) default '0');
   
   create table {PREFIX}im
 (
     id INTEGER PRIMARY KEY,
       toid int default '0',
       fromid int default '0',
       message text,
       time int default '0',
       isread tinyint(1) default '0',
       timeread int default '0',
       deleted int default '0');
   
   create table {PREFIX}pm
 (
     id INTEGER PRIMARY KEY,
       toid int default '0',
       fromid int default '0',
       timeread int default '0',
       message text,
       subject text,
       time int default '0',
       icon text,
       folderid text,
       deleted tinyint(1) default '0',
       flag int default '0',
       filefield varchar(255),
       important int default '0',
       replyto int default '0',
       replied int default '0',
       sentdeleted int default '0',
       wysihtml tinyint(1) default '0',
       cc text);
   
   create table {PREFIX}trader
 (
     id INTEGER PRIMARY KEY,
       ratingof int default '0',
       ratingby int default '0',
       value int default '0',
       summary varchar(255),
       report text,
       time int default '0',
       type varchar(255),
       linkid int default '0',
       morecomments text);
   
   create table {PREFIX}searches
 (
     id INTEGER PRIMARY KEY,
       value varchar(255),
       memberid int default '0',
       catid int default '0',
       time int default '0');
   
   create table {PREFIX}calendar
 (
     id INTEGER PRIMARY KEY,
       ownerid int default '0',
       title varchar(255),
       description text,
       joined text,
       starttime int default '0',
       endtime int default '0',
       date varchar(30),
       reminded text,
       validated tinyint(1) default '0',
       time int default '0');
   
   create table {PREFIX}invites
 (
     id INTEGER PRIMARY KEY,
       inviter int default '0',
       invitee varchar(255),
       time int default '0',
       usergroup int default '0',
       taken tinyint(1) default '0',
       code varchar(30));
   
   INSERT INTO {PREFIX}members(id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating,invitessent,validatedemail,calsub,macros) VALUES ('', '{USERNAME}', '', '', '{TIME}', '3', '{PASSWORD}', '{IP}', '', '', '{ACCOUNTEMAIL}', '1', '{OURTEMPLATESDIR}', '{OURDEFAULTLANG}', '', '', '', '', 'default', '', '0', '', '', '', '', '', '', '', '', '', 'yes', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Administrator', '', '', '', '', '', '', '', '', '', '', '', '', '', 'sdg', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
  INSERT INTO {PREFIX}crons(id,frequency,nextrun,filename,native) VALUES ('6', '3600', '1180804249', 'hourly.php', '1');
  INSERT INTO {PREFIX}crons(id,frequency,nextrun,filename,native) VALUES ('8', '86400', '1180887056', 'daily.php', '0');
  INSERT INTO {PREFIX}crons(id,frequency,nextrun,filename,native) VALUES ('9', '43200', '1180843860', '12hours.php', '0');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('1', 'wsncode', '[b]', '<b>', 'Put text in bold.', '[/b]', '</b>', '1');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('3', 'wsncode', '[i]', '<i>', 'Put text in italics.', '[/i]', '</i>', '2');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('10', 'smilie', ':D', '<img src="{TEMPLATESDIR}/images/smilies/biggrin.gif" border="0" alt="grin">', 'grin', '', '', '3');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('8', 'smilie', ':)', '<img src="{TEMPLATESDIR}/images/smilies/smile.gif" border="0" alt="smiling face">', 'smiling face', '', '', '1');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('9', 'smilie', '{semicolon})', '<img src="{TEMPLATESDIR}/images/smilies/wink.gif" border="0" alt="wink">', 'wink', '', '', '2');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('11', 'smilie', ':confused:', '<img src="{TEMPLATESDIR}/images/smilies/confused.gif" border="0" alt="confused">', 'confused', '', '', '8');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('12', 'smilie', ':cool:', '<img src="{TEMPLATESDIR}/images/smilies/cool.gif" border="0" alt="cool">', 'cool', '', '', '4');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('13', 'smilie', ':eek:', '<img src="{TEMPLATESDIR}/images/smilies/eek.gif" border="0" alt="shocked">', 'shocked', '', '', '9');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('14', 'smilie', ':eyebrow:', '<img src="{TEMPLATESDIR}/images/smilies/eyebrow.gif" border="0" alt="raised eyebrow">', 'raised eyebrow', '', '', '7');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('15', 'smilie', ':(', '<img src="{TEMPLATESDIR}/images/smilies/frown.gif" border="0" alt="sad">', 'sad', '', '', '13');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('16', 'smilie', ':mad:', '<img src="{TEMPLATESDIR}/images/smilies/mad.gif" border="0" alt="mad">', 'mad', '', '', '14');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('17', 'smilie', ':no:', '<img src="{TEMPLATESDIR}/images/smilies/no.gif" border="0" alt="shaking head">', 'shaking head', '', '', '10');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('18', 'smilie', ':nod:', '<img src="{TEMPLATESDIR}/images/smilies/nod.gif" border="0" alt="nod">', 'nod', '', '', '5');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('19', 'smilie', ':nono:', '<img src="{TEMPLATESDIR}/images/smilies/nono.gif" border="0" alt="disapproval">', 'disapproval', '', '', '11');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('20', 'smilie', ':rolleyes:', '<img src="{TEMPLATESDIR}/images/smilies/rolleyes.gif" border="0" alt="rolling eyes">', 'rolling eyes', '', '', '12');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('21', 'smilie', ':p', '<img src="{TEMPLATESDIR}/images/smilies/tongue.gif" border="0" alt="sticking out tongue">', 'sticking out tongue', '', '', '6');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('23', 'wsncode', '[quote={PARAM}]', '<div class="quote"><span class="quoteby">{PARAM} wrote:</span><br>', 'Quote text written by someone.', '[/quote]', '</div>', '4');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('24', 'wsncode', '[quote]', '<div class="quote">', 'Quote without attribution.', '[/quote]', '</div>', '5');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('25', 'wsncode', '[code]', '<div class="code">', 'Type code such as HTML, PHP, C++, etc.', '[/code]', '</div>', '9');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('26', 'wsncode', '[url={PARAM}]', '<a target="_blank" href={PARAM}>', 'Link text to a URL.', '[/url]', '</a>', '6');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('27', 'wsncode', '[url]', '<a target="_blank" href={CONTENT}>', 'Link a URL.', '[/url]', '</a>', '7');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('33', 'wsncode', '[color={PARAM}]', '<span style="color: {PARAM}">', 'Places text in specified color.', '[/color]', '</span>', '10');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('29', 'wsncode', '[size={PARAM}]', '<font size={PARAM}>', 'Set the size of text.', '[/size]', '</font>', '11');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('30', 'wsncode', '[*]', '<li>', 'Bullet point inside a list.', '', '', '13');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('31', 'wsncode', '[list]', '<ul>', 'List of bullet points.', '[/list]', '</ul>', '12');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('32', 'wsncode', '[u]', '<u>', 'Underline text', '[/u]', '</u>', '3');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('34', 'wsncode', '[font={PARAM}]', '<span style="font-family: {PARAM}">', 'Put text in the specified font.', '[/font]', '</span>', '15');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('35', 'wsncode', '[hr]', '<hr style="width: 100%{semicolon} height: 2px{semicolon}">', 'Horizontal rule.', '', '', '16');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('36', 'wsncode', '[numbered]', '<ol>', 'Numbered list.', '[/numbered]', '</ol>', '14');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('37', 'wsncode', '[center]', '<div style="text-align: center{semicolon}">', 'Center text.', '[/center]', '</div>', '17');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('38', 'wsncode', '[highlight={PARAM}]', '<span style="background-color: {PARAM}">', 'Set background color for text.', '[/highlight]', '</span>', '20');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('39', 'wsncode', '[indent={PARAM}]', '<div style="margin-left: {PARAM}px{semicolon}">', 'Indent by specified number of pixels.', '[/indent]', '</div>', '19');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('40', 'wsncode', '[right]', '<div style="text-align: right{semicolon}">', 'Align text to right.', '[/right]', '</div>', '18');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('42', 'wsncode', '[email]', '<a href="mailto:{CONTENT}">', 'Clickable email address.', '[/email]', '</a>', '21');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('43', 'wsncode', '[img]', '<img src="', 'Display an image from a URL.', '[/img]', '" border="0">', '8');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('44', 'wsncode', '[strike]', '<strike>', 'Cross out text.', '[/strike]', '</strike>', '22');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('45', 'wsncode', '[youtube]', '<object width="425" height="350"><param name="movie" value="{CONTENT}"></param><param name="wmode" value="transparent"></param><embed src="http://www.youtube.com/v/', 'Embeds a YouTube video.', '[/youtube]', '" type="application/x-shockwave-flash" wmode="transparent" width="425" height="350"></embed></object>', '23');INSERT INTO {PREFIX}membergroups(id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,numinv,allowugspec,validateemails,validatesponsorlinks) VALUES ('1','Guest','0','0','1','0','0','0','1','1','1','0','1','1','1','0','0','0','0','0','0','0','0','1','1','0','','0','0','','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','','0','0','0','','','0','0','0','0','0','0','5','0','0','0','0','0','0','0','0','0','0','','0','0','0','0','0','0','0','1','1','5','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0'); 
INSERT INTO {PREFIX}membergroups(id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,numinv,allowugspec,validateemails,validatesponsorlinks) VALUES ('2','Member','0','0','1','0','0','1','1','0','1','1','1','1','1','1','0','1','1','0','0','0','0','1','1','0','','1','0','','0','0','1','0','0','0','0','0','1','0','1','0','1','0','0','0','0','0','0','0','0','0','1','','1','1','0','','','0','0','0','0','0','0','5','5','0','0','0','0','0','0','0','0','0','','0','0','0','0','0','0','0','1','1','5','0','0','0','0','1','0','1','0','1','1','0','0','50','0','0','0'); 
INSERT INTO {PREFIX}membergroups(id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,numinv,allowugspec,validateemails,validatesponsorlinks) VALUES ('3','Administrator','0','0','1','1','0','1','0','0','0','0','1','1','1','1','1','1','1','1','1','1','1','1','1','1','','1','0','','1','0','1','1','1','1','1','1','1','1','1','1','1','1','100','1','1','1','1','1','1','1','1','','1','1','1','','','1','0','0','0','0','0','5','5','0','0','0','0','0','0','0','1','1','admincolor','1','1','1','0','0','0','0','1','1','5','0','0','0','0','1','1','1','1','1','0','0','0','50','0','0','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('213','detailhits','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('124','ulsearchadult','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('123','ulsearchlinktype',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('122','ulsearchmax','3'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('121','ulsearchid',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('120','ulsearch','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('119','sponsorrevert',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('118','sponsorusergroup',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('117','confirmvote','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('116','iplength','12'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('115','expirecookie','365'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('162','htmlautogeneratecat','cat{CATID}{PAGE}.html'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('114','accountemail','{ACCOUNTEMAIL}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('127','rewritenames','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('143','cookiepolicy','www.somesite.com/w3c/p3p.xml'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('126','restricthitsbyip','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('129','rewriteignorelinks','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('128','alloweddups',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('135','onlinedate','%x - %X'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('131','nohttp','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('152','smilieslinks',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('147','parsecodecomments','message'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('148','parsecodemembers','signature,bio'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('149','smiliesmembers','signature,bio'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('144','commentsperpage','14'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('145','parsecodelinks','description'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('146','parsecodecategories','description'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('132','submittervote','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('141','cookiedomain',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('142','cookieduration','100000000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('151','smiliescategories',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('150','smiliescomments','message'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('111','menustate','expanded'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('110','uniquetotal','2285'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('108','totalmembers','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('113','mime','plain text'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('109','checkoutnum',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('112','queue','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('107','checkfordupdomain','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('140','cookiepath','/'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('139','htmlautogeneratesubs','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('138','htmlautogeneratedir','admin/htmloutput'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('137','htmlautogenerate','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('136','timeout','15'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('134','onlineusers','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('133','sendconfirmation','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('106','fixedwidth',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('400','sponsorhidden','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('104','checkfordup','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('105','redirects','afterlink[,]index.php?action=displaycat&catid={LINKCATID}|||aftercat[,]|||aftercom[,]comments.php?id={LINKID}|||afterreg[,]|||aftereditlink[,]index.php?action=displaycat&catid={LINKCATID}|||aftereditcat[,]index.php?action=displaycat&catid={CATID}|||aftereditcom[,]comments.php?id={LINKID}|||aftereditprofile[,]|||afterlogin[,]|||afterlogout[,]|||afterresetpass[,]index.php?action=userlogin|||aftersubscribecom[,]comments.php?id={ID}|||aftersubscribecat[,]index.php?action=displaycat&catid={CATID}|||afterdellink[,]index.php?action=displaycat&catid={LINKCATID}|||afterdelcat[,]index.php?action=displaycat&catid={PARENT}|||afterdelcom[,]comments.php?id={LINKID}|||afterrate[,]index.php?action=displaycat&catid={LINKCATID}|||afterratefail[,]|||afteractivate[,]|||afterloginfail[,]index.php?action=userlogin|||afterresetfail[,]index.php?action=userlogin|||aftersearchfail[,]search.php|||aftersearchfailseconds[,]7|||aftereditavatar[,]|||afterreportlink[,]|||afterreportpost[,]comments.php?id={LINKID}|||afteremaillink[,]'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('103','searchperpage','14'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('101','totalmembers','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('97','backupdelay',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('96','logsearches','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('86','skiptocat',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('85','standardtable','cellspacing=&#34&6&#34& cellpadding=&#34&6&#34&'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('84','secondsdelay','3'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('83','standardsize','30'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('82','modapprove','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('81','stylesheet','default'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('93','apacherewrite','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('92','orderlinks2','ORDER BY title ASC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('91','commenttypes','regular'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('90','mixcomments','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('89','maximageheight','5000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('88','maximagewidth','5000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('87','marknewupdates','5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('99','lastdaily','1180800656'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('95','backupfile',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('94','lastupdate','1180545118'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('61','debittime','1120315713'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('220','sponsoruselink','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('63','sponsorlinktype',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('64','sponsorcharge',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('65','totalhits','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('66','totalhitsin','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('69','sponsoritem',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('67','lastautocron','1089756505'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('68','totallinks','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('70','totalcomments','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('71','avatarsize','50000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('72','avatarwidth','100'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('73','avatarheight','100'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('74','avatartypes','gif,jpg,jpeg,png'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('75','descriplength','200'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('76','cattypes','regular'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('78','mainmeta',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('79','maplevels','50'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('77','externallinks','target=&#34&_blank&#34&'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('60','minvote','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('59','maxvote','5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('58','dontcount','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('57','integration',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('56','censor',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('157','perqueue','10'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('54','memberlistorder','ORDER BY time DESC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('47','selectorlevels','2'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('55','expiretime','72'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('156','linebreakmembers','signature,bio'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('155','linebreakcomments','message'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('154','linebreakcategories','description'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('228','pagestoshow','10'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('153','linebreaklinks','description'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('51','filesize','10000000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('50','filetypes','gif,jpg,jpeg,png,zip,gz,txt,lng,pdf'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('408','dirurl','{DIRURL}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('48','ratingdecimal','2'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('44','resettime','1180435028'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('43','resetfields',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('45','floodcheck','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('46','registration','direct'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('41','admindir','{OURADMINDIR}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('42','resetdelay','7'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('39','requiredmembers','name,password,email'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('38','requiredcomments','message'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('37','requiredcategories','name'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('34','bannedips',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('36','requiredlinks','title'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('33','maxsubcats','7'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('185','defaultlang','{OURDEFAULTLANG}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('30','allowhtml','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('29','linktypes','regular,recip'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('26','clicktimer','60'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('25','condition',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('24','ordercomments','ORDER BY time ASC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('23','searchfields','title,url,description'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('22','mixrecip','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('8','notify','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('9','myurl',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('10','perpage','14'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('11','marknew','7'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('12','dateformat','%x'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('13','locale','english'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('14','templatesdir','{OURTEMPLATESDIR}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('17','excludedtoadmin',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('125','ulsearchcatmax','3'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('409','uploadpath','{UPLOADPATH}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('98','adminbypass','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('20','commentsdateformat','%x - %X'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('21','debug','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('7','email','{ACCOUNTEMAIL}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('163','htmlautogeneratelin','link{LINKID}.html'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('6','ordercats','ORDER BY priority ASC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('5','orderlinks','ORDER BY time DESC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('4','subcatcols','2'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('3','catcols','2'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('159','rewritecategoryspace','_'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('160','linkcols','2'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('183','lastrotation','1180800649'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('161','passwordlength','7'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('164','htmlautogeneratecom','comments{LINKID}{PAGE}.html'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('194','htmlautogenerateabsurl','http://localhost/wsnlinks/admin/htmloutput'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('165','htmlautogeneratepagesep','-'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('166','jsexporttoplist',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('167','jsexportnamelist',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('168','backupname','backup.sql'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('169','trackviews','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('170','countalbums','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('171','customhead',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('172','customfoot','custom-html_footer'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('173','customindex',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('174','customcat',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('175','customitem',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('176','customcomments',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('179','hitstempdays','30'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('250','htmlautogenerateindex','index.html'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('180','hitstempreset','1180263042'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('202','sponsorlinkrevert',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('203','sendsponsorendemail','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('204','sendexpirationemail','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('205','emailsig',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('206','searchcols','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('182','sendvalidation','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('181','attachmentmethod','natural'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('190','categoryselector',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('437','promoteatlogin',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('184','currentletter','Y'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('186','paypalemail',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('255','searchhighlightexclude',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('256','backuppath',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('226','optionscontent','&lt&option value=&#34&{CATID}&#34&&gt&{CATINDENT} {CATNAME}&lt&/option&gt&'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('218','sponsorugcharge',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('219','sponsorugitem',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('221','sponsoruseug','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('222','waterthumbs',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('223','sponsorcatresults','5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('224','sponsorsearchresults','5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('225','sponsorseparate','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('207','offsetfromgmt','-8'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('208','defaulttimezone','-8'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('210','searchlax','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('211','defaultsearchtype','and'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('212','membersperpage','14'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('251','staticexporturllist',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('252','staticexportnamelist',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('253','staticexporttime','1180800660'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('254','emailf','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('192','alternateemails',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('195','ipbanfrom','whole site'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('196','memberrating','$rating = ($this-&gt&links * 2) + $this-&gt&comments'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('197','searchlinksorder','ORDER BY rating DESC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('199','searchcatsorder','ORDER BY numlinks DESC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('200','searchcomsorder','ORDER BY time DESC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('201','searchmemsorder','ORDER BY name ASC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('191','sitemaporder',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('214','spideragents','googlebot
Slurp
msnbot
Teoma
Jeeves
ZyBorg
Gigabot
WeatherBot
Mediapartners
BecomeBot
fast-search-engine.com
BigCliqueBOT
Amfibibot
noxtrumbot
aipbot
sohu-search
sherlock
Nutch
OmniExplorer_Bot
EasyDL'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('215','allowrevote','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('216','rewritelink','links'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('217','rewritethread','thread'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('257','sigchars','1000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('258','siglines','20'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('260','comchars','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('209','ulsearchdefaultquery',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('187','catsperpage','40'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('189','securityimage','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('227','pmsperpage','20'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('229','requiredpms','message,subject'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('230','smiliespms','message'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('231','parsecodepms','message'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('232','linebreakpms','message'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('233','linkimportance','$importance = ($this-&gt&hitsoutpermonth() + $this-&gt&numcomments) + 6'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('234','onlinemembersmax','0|||0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('235','onlineguestsmax','0|||0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('236','commenthits','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('237','searchhighlight','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('240','onlinetotalmax','0|||0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('239','sponsoruseppc','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('241','subscriptionexclusion',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('248','memberdecriment','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('242','sponsorbonuscutoff',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('243','sponsorbonuspercent',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('244','wordwrap','60'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('245','sitetitle','Links Directory'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('246','sitedescription',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('247','maxusernamelength','20'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('261','comwords','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('262','illegaldomains',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('263','magickpath','/usr/bin/convert'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('264','graphicsprog','GD'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('265','thumbwidth','100'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('266','thumbheight','100'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('267','fixedsize','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('269','offlinereason',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('268','offline','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('270','orderalbum','ORDER BY title ASC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('271','topsearcheslength','3'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('272','perpagealbums','14'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('273','dontcountowner','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('274','sessiondelete','15'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('275','ppcprovider','searchfeed'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('276','newestmember','{NEWESTMEMBER}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('277','contact','email'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('279','resizewidth',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('280','numsimilar','5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('281','shownoperm','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('282','ranks','New[,]0[,]10[,]posts[,][END]Junior Member[,]11[,]99[,]posts[,][END]Senior Member[,]100[,]99999[,]posts[,][END]'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('283','registrationdefaults','name=[,]email=[,]signature=[,]customtitle=[,]stylesheet=[,]thetemplate=[,]thelanguage=[,]allowemail=yes[,]allowuseremail=no[,]notifyoflinks=no[,]autosubscribe=no[,]notifymethod=instant[,]cookieduration=31536000[,]commentsperpage=[,]linksperpage=[,]location=[,]homepage=[,]occupation=[,]bio=[,]interests=[,]aim=[,]icq=[,]msn=[,]yahoo=[,]birthmonth=[,]birthday=[,]birthyear=[,]visibility=everyone[,]posteditor=plain[,]links=0[,]comments=0[,]'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('405','sponsorlinkrevert',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('284','nobotsearches','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('285','nobumping','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('286','quotespercent','100'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('287','resizeavatars','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('288','membersdateformat','%b %d, %Y'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('289','inactivecutoff','365'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('290','modusergroup','2'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('291','iminterval','20'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('292','pmharddelete','60'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('293','searchdelay','10'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('294','imdelete','30'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('295','imdimensions','width=300,height=300'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('296','resizeheight',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('297','usewater','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('298','watermark',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('299','resize','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('300','removeextensions','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('301','redirectduration','365'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('302','requiredpolls',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('303','nodouble','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('304','pagelist','5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('305','similarincat','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('306','titlelength','50'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('307','editgrace','4'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('308','customtitlelength','25'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('309','autoipban','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('310','chmoddirectories','0777'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('311','banreasons','spam
low submission quality
TOS violation'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('312','reports','email all'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('313','reportsforum',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('314','columnheader','style=&#34&background-image: url(&#39&{TEMPLATESDIR}/images/columnheader.png&#39&){semicolon} background-repeat: repeat-x{semicolon}&#34&'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('315','shoutsperpage','25'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('316','passencode','md5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('317','searchcommentfields','message,linkname'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('318','searchlimit','500'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('319','contactbanned','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('320','sendregconfirmation','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('321','totalsubcats','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('322','bannedtitle','banned'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('323','removeredirects','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('324','autoipbanexempt','172.128
172.192
172.208
202.67.66
202.67.68
202.67.72
202.67.80
202.67.96'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('325','allowallextensions','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('326','topiclistdateformat','%x &lt&br&gt& %X'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('327','digesttime','1180800649'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('328','digestprogress','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('329','termsofservice','- The site administrators reserve the right to edit or remove any content you submit. Your content may also be reused in different places in different contexts around the site. (This means what you type in your submissions, of course, not anything on your own site.)
&lt&br&gt&&lt&br&gt&
- You may not submit illegal content.
&lt&br&gt&&lt&br&gt&
- Attempting to flood with many submissions is not allowed, nor are automated submissions are allowed.
&lt&br&gt&&lt&br&gt&
- Comment posts may not be abusive.
&lt&br&gt&&lt&br&gt&
- Usage of the email features (if enabled) may not be abused to attempt to send spam.'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('330','bannedemails',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('331','throw404s',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('332','expirationwarningdays','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('333','sponsorexpirationwarningdays','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('334','topicedittimelimit','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('335','postedittimelimit','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('336','cookienameuserid','wsnuser'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('337','cookienamepass','wsnpass'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('338','posthistory','15'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('339','titlescheme','{LANG_TITLE_BASE}{LANG_TITLE_DIVIDER}{AREA}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('340','subscribeunique','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('341','deletedmarkers','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('342','colsatt',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('343','attachcolumns','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('344','nobotsmostplaces','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('345','birthdaycache','[DAY:04-21][DAY:04-20][DAY:04-22]'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('346','autopromote',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('347','defaultnoaccess',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('348','maxcomchars','50000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('349','nocross','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('350','warningips',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('351','ordercats2','ORDER BY name ASC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('353','feeduration','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('354','ugpromotelink',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('355','sponsorrequired','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('356','modinherit','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('357','notifyedits','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('358','expirationdelete','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('359','otherreggroups',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('360','staticqueue','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('361','staticqueueitems',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('410','googlemapprefs','0,'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('411','googleauto','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('412','googleothermaps',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('413','gfreqpri','daily,weekly,yearly,weekly,yearly|0.9,0.6,0.3,0.5,0.1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('430','ulsearchtrack',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('414','watertext',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('415','waterpadding','7'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('416','watertextsize','5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('417','watertextcolor','255,0,0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('418','memberlistorder2','ORDER BY name ASC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('427','nochexemail',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('428','bannedhosts',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('429','maptype','google'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('431','version','4.0.17'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('432','minforpm',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('433','searchcatfields','name,description'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('362','rewritelinkname','links/{LINKTITLE}-{LINKID}.html'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('363','rewritethreadnames','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('364','sponsorugrequired','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('365','adbanner',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('383','watercorner','southeast'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('384','exemptreggroup',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('368','votequery',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('369','emailbirthdays','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('370','keeporiginals','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('371','warningpm','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('372','warningdemotelevel',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('373','warningdemotegroup',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('375','sigimages','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('376','degradebrowsers','Safari'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('380','calbdays','365'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('381','flagterms',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('382','regcookie','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('385','rewritelower','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('386','sponsoreachtype','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('387','invitesalt','7bde0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('388','invitebuddy','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('389','staticasadmin','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('391','rewriteoriginals',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('390','importerschema','\n[|sep|],[|sep|][|sep|]url=0[|sep|]title=1[|sep|]descrip=2[|sep|]votes=[|sep|]sumofvotes=[|sep|]rating=[|sep|]hitsout=[|sep|]hitsin=[|sep|]catid=3[|sep|]email=[|sep|]type='); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('392','rewritereplacements',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('393','expirationdefault',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('394','emailheaders',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('395','emailasadmin','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('396','submissionrules',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('397','uniquecattotal','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('398','htmlstart',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('399','checkwords',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('401','otherrecipurls',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('402','sponsorsort',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('403','htaccessextras',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('404','emaillogsize','500'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('406','rewriteautowrite','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('407','rewriteprofiles','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('434','chatorder',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('435','feedtimeout','720'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('436','flvres','400x300'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('438','tagcloud',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('439','cachegroups',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('440','cachemaxsize','1000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('441','bannedredirect',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('442','cacherandom','20'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('443','cacheexpiration','1000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('444','cacheload',' '); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('445','nocatpermissions',' '); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('1','members','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('2','ratings','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('3','hits','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('4','comments','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('5','subscriptions','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('6','albums','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('7','getmeta','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('8','pm','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('9','wsncodes','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('10','smilies','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('11','showsubs','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('12','searchincat','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('13','catselector','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('14','onlineusers','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('15','styleselect','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('16','templateselect','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('17','linkcheckers','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('18','reports','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('19','sortcats','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('20','sortlinks','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('21','attachmentstree','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('22','requirerecip','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('23','tos','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('24','ims','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('25','inlinestyle','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('26','buddyignore','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('27','guestbook','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('28','usernotes','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('29','modnotify','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('30','similar','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('31','shoutbox','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('72','feeds','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('33','modcolumn','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('34','maintoplist','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('35','forumviews','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('36','posttypes','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('37','topictypes','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('38','birthdays','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('39','timeonline','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('40','contact','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('41','posthistory','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('42','memberratings','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('43','memberhits','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('44','quotes','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('45','help','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('46','quickregistration','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('47','posticons','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('48','detailcomments','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('49','wysidescrip','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('50','languageselector','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('51','attachments','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('52','pagerank','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('53','warnings','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('54','coppa','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('55','revisions','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('56','chat','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('57','emaillogin','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('58','trader','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('59','invites','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('60','calendar','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('61','searchlog','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('62','frameset','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('63','wysi','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('64','autoregister','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('65','chat','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('66','savedlinks','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('67','macros','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('68','sitethumbs','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('69','blogrss','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('70','onlineforum','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('71','slideshow','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('73','flv','0');