drop table if exists {PREFIX}links ;
 drop table if exists {PREFIX}categories ;
 drop table if exists {PREFIX}comments ;
 drop table if exists {PREFIX}settings ;
 drop table if exists {PREFIX}members ;
 drop table if exists {PREFIX}membergroups ;
 drop table if exists {PREFIX}email ;
 drop table if exists {PREFIX}sessions ;
 drop table if exists {PREFIX}ratings ;
 drop table if exists {PREFIX}pm ;
 drop table if exists {PREFIX}switches ;
 drop table if exists {PREFIX}markup ;
 create table {PREFIX}links
 (
     `id` int  NOT NULL auto_increment,
       `title` text NOT NULL,
       `url` text NOT NULL,
       `description` text NOT NULL,
       `rating` real default '0' NOT NULL,
       `votes` int default '0' NOT NULL,
       `validated` tinyint(1) default '0' NOT NULL,
       `catid` int default '0' NOT NULL,
       `sumofvotes` int default '0' NOT NULL,
       `email` text NOT NULL,
       `time` int default '0' NOT NULL,
       `hits` int default '0' NOT NULL,
       `numcomments` int default '0' NOT NULL,
       `hide` tinyint(1) default '0' NOT NULL,
       `ownerid` int default '0' NOT NULL,
       `voterips` text NOT NULL,
       `voterids` text NOT NULL,
       `lastedit` int default '0' NOT NULL,
       `type` text NOT NULL,
       `filename` text NOT NULL,
       `filetitle` text NOT NULL,
       `notify` text NOT NULL,
       `suspect` tinyint(1) default '0' NOT NULL,
       `downloads` int default '0' NOT NULL,
       `pendingedit` text NOT NULL,
       `funds` real default '0' NOT NULL,
       `suspended` tinyint(1) default '0' NOT NULL,
       `alias` int default '0' NOT NULL,
       `expire` int default '0' NOT NULL,
       `ip` text NOT NULL,
       `inalbum` tinyint(1) default '0' NOT NULL,
       `typeorder` int default '0' NOT NULL,
       `recipurl` text NOT NULL,
       `hitsin` int default '0' NOT NULL,
       `recipwith` text NOT NULL,
       `hitsinips` text NOT NULL,
       `hitsoutips` text NOT NULL,
       `lastcomment` int default '0' NOT NULL,
       `related` text NOT NULL,
       `inhidden` tinyint(1) default '0' NOT NULL,
       `viewers` text NOT NULL,
       `threadviewers` text NOT NULL,
       `hitsintemp` int default '0' NOT NULL,
       `hitsouttemp` int default '0' NOT NULL,
       `origtype` text NOT NULL,
       `importance` real default '0' NOT NULL,
       `parentids` text NOT NULL,
       `timesdead` int default '0' NOT NULL,
       `timesemailed` int default '0' NOT NULL,
       `threadclosed` tinyint(1) default '0' NOT NULL,
       `threadposters` text NOT NULL,
       `price` real default '0' NOT NULL,
       `longdescription` text NOT NULL,
       `xwidth` int default '0' NOT NULL,
       `yheight` int default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}categories
 (
     `id` int  NOT NULL auto_increment,
       `name` text NOT NULL,
       `parent` int default '0' NOT NULL,
       `validated` tinyint(1) default '0' NOT NULL,
       `description` text NOT NULL,
       `time` int default '0' NOT NULL,
       `parentnames` text NOT NULL,
       `parentids` text NOT NULL,
       `numlinks` int default '0' NOT NULL,
       `hide` tinyint(1) default '0' NOT NULL,
       `lastlinktime` int default '0' NOT NULL,
       `custom` text NOT NULL,
       `lastedit` text NOT NULL,
       `moderators` text NOT NULL,
       `headerinfo` text NOT NULL,
       `related` text NOT NULL,
       `numsub` int default '0' NOT NULL,
       `type` text NOT NULL,
       `permissions` text NOT NULL,
       `subscribers` text NOT NULL,
       `subscriber` text NOT NULL,
       `mixtypes` text NOT NULL,
       `isalbum` tinyint(1) default '0' NOT NULL,
       `orderlinks` text NOT NULL,
       `totalcomments` int default '0' NOT NULL,
       `ulsearchmax` int default '0' NOT NULL,
       `ulsearchquery` text NOT NULL,
       `ulsearchadult` text NOT NULL,
       `alias` int default '0' NOT NULL,
       `catcols` text NOT NULL,
       `linkcols` text NOT NULL,
       `dmozpath` text NOT NULL,
       `sponsorlinks` text NOT NULL,
       `views` int default '0' NOT NULL,
       `customwrap` text NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}comments
 (
     `id` int  NOT NULL auto_increment,
       `linkid` int default '0' NOT NULL,
       `postername` text NOT NULL,
       `message` text NOT NULL,
       `time` int default '0' NOT NULL,
       `linkname` text NOT NULL,
       `validated` int default '0' NOT NULL,
       `ip` text NOT NULL,
       `ownerid` int default '0' NOT NULL,
       `lastedit` text NOT NULL,
       `type` text NOT NULL,
       `approved` int default '0' NOT NULL,
       `votes` int default '0' NOT NULL,
       `hide` int default '0' NOT NULL,
       `typeorder` int default '0' NOT NULL,
       `lasteditby` text NOT NULL,
       `catid` int default '0' NOT NULL,
       `editreason` text NOT NULL,
       `preventedit` tinyint(1) default '0' NOT NULL,
       `inhidden` tinyint(1) default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}settings
 (
     `id` int  NOT NULL auto_increment,
       `name` text NOT NULL,
       `content` text NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}members
 (
     `id` int  NOT NULL auto_increment,
       `name` text NOT NULL,
       `links` int default '0' NOT NULL,
       `comments` int default '0' NOT NULL,
       `time` int default '0' NOT NULL,
       `usergroup` int default '0' NOT NULL,
       `password` text NOT NULL,
       `ip` text NOT NULL,
       `totalhits` int default '0' NOT NULL,
       `totalhitsin` int default '0' NOT NULL,
       `email` text NOT NULL,
       `validated` tinyint(1) default '0' NOT NULL,
       `template` text NOT NULL,
       `language` text NOT NULL,
       `lastattempt` text NOT NULL,
       `allowemail` text NOT NULL,
       `signature` text NOT NULL,
       `avatarname` text NOT NULL,
       `stylesheet` text NOT NULL,
       `allowuseremail` text NOT NULL,
       `albumid` int default '0' NOT NULL,
       `failedattempts` int default '0' NOT NULL,
       `totalbytes` int default '0' NOT NULL,
       `funds` real default '0' NOT NULL,
       `notifyoflinks` text NOT NULL,
       `lastvisit` int default '0' NOT NULL,
       `timezone` real default '0' NOT NULL,
       `rating` real default '0' NOT NULL,
       `pmfolders` text NOT NULL,
       `notifyofpms` text NOT NULL,
       `acceptpms` text NOT NULL,
       `cookieduration` int default '0' NOT NULL,
       `banned` text NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}membergroups
 (
     `id` int  NOT NULL auto_increment,
       `title` text NOT NULL,
       `caneditown` tinyint(1) default '0' NOT NULL,
       `caneditall` tinyint(1) default '0' NOT NULL,
       `canvote` tinyint(1) default '0' NOT NULL,
       `isadmin` tinyint(1) default '0' NOT NULL,
       `canpost` tinyint(1) default '0' NOT NULL,
       `canemail` tinyint(1) default '0' NOT NULL,
       `validatecats` tinyint(1) default '0' NOT NULL,
       `validatecomments` tinyint(1) default '0' NOT NULL,
       `validatelinks` tinyint(1) default '0' NOT NULL,
       `validateedits` tinyint(1) default '0' NOT NULL,
       `cansubmitlinks` tinyint(1) default '0' NOT NULL,
       `cansubmitcategories` tinyint(1) default '0' NOT NULL,
       `cansubmitcomments` tinyint(1) default '0' NOT NULL,
       `caneditownlinks` tinyint(1) default '0' NOT NULL,
       `caneditowncategories` tinyint(1) default '0' NOT NULL,
       `caneditowncomments` tinyint(1) default '0' NOT NULL,
       `caneditownprofile` tinyint(1) default '0' NOT NULL,
       `caneditalllinks` tinyint(1) default '0' NOT NULL,
       `caneditallcategories` tinyint(1) default '0' NOT NULL,
       `caneditallcomments` tinyint(1) default '0' NOT NULL,
       `caneditallprofiles` tinyint(1) default '0' NOT NULL,
       `candownloadfiles` tinyint(1) default '0' NOT NULL,
       `canupload` tinyint(1) default '0' NOT NULL,
       `canviewip` tinyint(1) default '0' NOT NULL,
       `limitlinks` text NOT NULL,
       `canemailmembers` int default '0' NOT NULL,
       `canusehtml` int default '0' NOT NULL,
       `limitlinksdaily` text NOT NULL,
       `canalias` tinyint(1) default '0' NOT NULL,
       `cancopy` tinyint(1) default '0' NOT NULL,
       `candeleteown` tinyint(1) default '0' NOT NULL,
       `candeleteall` tinyint(1) default '0' NOT NULL,
       `candofulledit` tinyint(1) default '0' NOT NULL,
       `candeletecategories` tinyint(1) default '0' NOT NULL,
       `candeletecomments` tinyint(1) default '0' NOT NULL,
       `candeleteowncategories` tinyint(1) default '0' NOT NULL,
       `candeleteowncomments` tinyint(1) default '0' NOT NULL,
       `candeletemembers` tinyint(1) default '0' NOT NULL,
       `candeleteownmembers` tinyint(1) default '0' NOT NULL,
       `canaliascategories` tinyint(1) default '0' NOT NULL,
       `canviewpages` tinyint(1) default '0' NOT NULL,
       `caneditvotes` tinyint(1) default '0' NOT NULL,
       `numaliases` int default '0' NOT NULL,
       `canviewvotes` tinyint(1) default '0' NOT NULL,
       `canhideownlinks` tinyint(1) default '0' NOT NULL,
       `canhideowncategories` tinyint(1) default '0' NOT NULL,
       `canhideowncomments` tinyint(1) default '0' NOT NULL,
       `canhidealllinks` tinyint(1) default '0' NOT NULL,
       `canhideallcategories` tinyint(1) default '0' NOT NULL,
       `canhideallcomments` tinyint(1) default '0' NOT NULL,
       `canratecomments` tinyint(1) default '0' NOT NULL,
       `bytespermem` text NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}email
 (
     `id` int  NOT NULL auto_increment,
       `to` text NOT NULL,
       `subject` text NOT NULL,
       `message` text NOT NULL,
       `headers` text NOT NULL,
       `timesent` int default '0' NOT NULL,
       `ip` text NOT NULL,
       `replacement` text NOT NULL,
       `mime` tinyint(1) default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}sessions
 (
     `id` int  NOT NULL auto_increment,
       `memberid` int default '0' NOT NULL,
       `location` text NOT NULL,
       `time` int default '0' NOT NULL,
       `ip` text NOT NULL,
       `browser` text NOT NULL,
       `starttime` int default '0' NOT NULL,
       `catid` int default '0' NOT NULL,
       `threadid` int default '0' NOT NULL,
       `areaname` text NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}ratings
 (
     `id` int  NOT NULL auto_increment,
       `votevalue` int default '0' NOT NULL,
       `time` int default '0' NOT NULL,
       `memberid` int default '0' NOT NULL,
       `ip` text NOT NULL,
       `custom` text NOT NULL,
       `linkid` int default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}pm
 (
     `id` int  NOT NULL auto_increment,
       `toid` int default '0' NOT NULL,
       `fromid` int default '0' NOT NULL,
       `timeread` int default '0' NOT NULL,
       `message` text NOT NULL,
       `subject` text NOT NULL,
       `time` int default '0' NOT NULL,
       `icon` text NOT NULL,
       `folderid` int default '0' NOT NULL,
       `deleted` tinyint(1) default '0' NOT NULL,
       `attachment` text NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}switches
 (
     `id` int  NOT NULL auto_increment,
       `name` text NOT NULL,
       `value` tinyint(1) default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}markup
 (
     `id` int  NOT NULL auto_increment,
       `type` varchar(255),
       `original` text NOT NULL,
       `replacement` text NOT NULL,
       `description` text NOT NULL,
       `originalclose` text NOT NULL,
       `replacementclose` text NOT NULL,
       `sortorder` int default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   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) VALUES ('0', '{USERNAME}', '0', '0', '{TIME}', '3', '{PASSWORD}', '{IP}', '0', '0', '{ACCOUNTEMAIL}', '1', '{OURTEMPLATESDIR}', '{OURDEFAULTLANG}', '0', '0', '', '', 'default', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('1', 'wsncode', '[b]', '<b>', 'Put text in bold.', '[/b]', '</b>', '0');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('3', 'wsncode', '[i]', '<i>', 'Put text in italics.', '[/i]', '</i>', '1');
  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', '', '', '2');
  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="smile">', 'smile', '', '', '0');
  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', '', '', '1');
  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', '', '', '7');
  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', '', '', '3');
  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', '', '', '8');
  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', '', '', '6');
  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', '', '', '12');
  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', '', '', '13');
  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', '', '', '9');
  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', '', '', '4');
  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', '', '', '10');
  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', '', '', '11');
  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', '', '', '5');
  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>', '2');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('24', 'wsncode', '[quote]', '<div class="quote">', 'Quote without attribution.', '[/quote]', '</div>', '3');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) 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',''); 
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) 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',''); 
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) VALUES ('3','admin','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','1','1','1','1','1','1','1','1','1','1','1','1','1','0','1','1','1','1','1','1','1','1',''); 
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','2'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('121','ulsearchid','1'); 
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','yes'); 
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}.htm'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('114','accountemail','{ACCOUNTEMAIL}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('127','rewritenames','no'); 
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'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('149','smiliesmembers','signature'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('144','commentsperpage','15'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('145','parsecodelinks',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('146','parsecodecategories',''); 
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','4864'); 
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 ('102','compress','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'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('103','searchperpage','15'); 
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','1117328209'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('95','backupfile',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('94','lastupdate','1116895420'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('61','debittime','1117328209'); 
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','1000'); 
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','6'); 
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'); 
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,longdescription'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('52','resetscript',''); 
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 ('49','uploadpath','{UPLOADPATH}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('48','ratingdecimal','2'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('44','resettime','1117328209'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('43','resetfields',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('45','floodcheck','20'); 
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','30'); 
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,price,longdescription'); 
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','2'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('18','dirurl','{DIRURL}'); 
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}.htm'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('6','ordercats','ORDER BY name 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','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('3','catcols','3'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('159','rewritecategoryspace','_'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('160','linkcols','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('183','lastrotation','1117328209'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('161','passwordlength','7'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('164','htmlautogeneratecom','comments{LINKID}{PAGE}.htm'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('194','htmlautogenerateabsurl',''); 
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','custom-html_wrapper'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('172','customfoot','custom-html_footer'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('173','customindex','custom-html_main'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('174','customcat','custom-html_displaylinks'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('175','customitem','custom-html_details'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('176','customcomments','custom-html_viewcomments'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('179','hitstempdays','30'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('250','htmlautogenerateindex','index.htm'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('180','hitstempreset','1115181981'); 
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','random'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('190','categoryselector',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('184','currentletter','M'); 
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','yes'); 
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','15'); 
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','1117328209'); 
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 + $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'); 
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','300'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('188','adminips',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('189','securityimage','no'); 
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','ulsearch'); 
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','1'); 
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','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('7','getmeta','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('8','pm','0'); 
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','1'); 
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','1'); 

CREATE INDEX wsnindex ON {PREFIX}links (catid,time,title(5));
CREATE INDEX wsnindex ON {PREFIX}categories (name(5));
CREATE INDEX wsnindex ON {PREFIX}comments (linkid,time);
CREATE INDEX wsnindex ON {PREFIX}members (id,time);
CREATE INDEX wsnindex ON {PREFIX}membergroups (id);