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}switches ; drop table if exists {PREFIX}markup ; drop table if exists {PREFIX}modlog ; drop table if exists {PREFIX}attachments ; drop table if exists {PREFIX}helpcategory ; drop table if exists {PREFIX}helpitem ; drop table if exists {PREFIX}crons ; drop table if exists {PREFIX}im ; drop table if exists {PREFIX}pm ; create table {PREFIX}links ( `id` int NOT NULL auto_increment, `title` text NOT NULL, `url` varchar(255) 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, `notify` text NOT NULL, `suspect` tinyint(1) 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, `lastposterid` int default '0' NOT NULL, `lastpostername` varchar(255) NOT NULL, `ownername` varchar(255) NOT NULL, `deleted` int default '0' NOT NULL, `deletionreason` varchar(255) NOT NULL, `movedto` int default '0' NOT NULL, `deletedby` int default '0' NOT NULL, `timevalidated` int default '0' NOT NULL, `filefield` varchar(255) NOT NULL, `message` text NOT NULL, `sticky` int default '0' NOT NULL, `downloads` int default '0' NOT NULL, `pollid` int default '0' NOT NULL, `posticon` varchar(255) NOT NULL, `savedby` text 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, `alias` int default '0' NOT NULL, `catcols` text NOT NULL, `linkcols` text NOT NULL, `sponsorlinks` text NOT NULL, `views` int default '0' NOT NULL, `customwrap` text NOT NULL, `deleted` int default '0' NOT NULL, `reqlinks` int default '0' NOT NULL, `reqcoms` int default '0' NOT NULL, `reqlinksdelay` int default '0' NOT NULL, `priority` int default '0' NOT NULL, `levelsdeep` int default '0' NOT NULL, `lastposterid` int default '0' NOT NULL, `lastpostername` varchar(255) NOT NULL, `lastcommenttime` int default '0' NOT NULL, `lastthreadid` int default '0' NOT NULL, `lastthreadtitle` varchar(255) NOT NULL, `linkshere` int default '0' NOT NULL, `unvalidatedlinks` int default '0' NOT NULL, `unvalidatedcomments` int default '0' NOT NULL, `actaslink` varchar(255) NOT NULL, `countposts` text NOT NULL, `subcatshtml` 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, `deleted` int default '0' NOT NULL, `deletionreason` varchar(255) NOT NULL, `usernoteon` int default '0' NOT NULL, `modnote` int default '0' NOT NULL, `filefield` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `deletedby` int default '0' NOT NULL, `parentids` text NOT NULL, `disablesmilies` int default '0' NOT NULL, `disablesig` int default '0' NOT NULL, `icon` varchar(255) NOT NULL, `disablewsn` tinyint(1) default '0' NOT NULL, `disablehtml` tinyint(1) default '0' NOT NULL, `originalmessage` text NOT NULL, `flagged` int 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, `location` varchar(255) NOT NULL, `homepage` varchar(255) NOT NULL, `occupation` varchar(255) NOT NULL, `bio` text NOT NULL, `aim` varchar(255) NOT NULL, `icq` varchar(255) NOT NULL, `msn` varchar(255) NOT NULL, `yahoo` varchar(255) NOT NULL, `inactive` int default '0' NOT NULL, `timeonline` int default '0' NOT NULL, `totalpms` int default '0' NOT NULL, `buddies` text NOT NULL, `ignored` text NOT NULL, `isonline` int default '0' NOT NULL, `acceptims` varchar(255) NOT NULL, `adminpermissions` text NOT NULL, `referrer` int default '0' NOT NULL, `groupreverttime` int default '0' NOT NULL, `grouprevertto` int default '0' NOT NULL, `moderationpm` varchar(255) NOT NULL, `secondarygroups` text NOT NULL, `linksperpage` int default '0' NOT NULL, `commentsperpage` int default '0' NOT NULL, `shouts` int default '0' NOT NULL, `customtitle` varchar(255) NOT NULL, `shoutban` int default '0' NOT NULL, `topicbans` text NOT NULL, `forumbans` text NOT NULL, `visibility` text NOT NULL, `birthdate` date, `lastsession` int default '0' NOT NULL, `interests` text NOT NULL, `posteditor` varchar(255) NOT NULL, `forumaccess` text NOT NULL, `pmpopup` int default '0' NOT NULL, `pmnotify` varchar(255) NOT NULL, `modnotes` int default '0' NOT NULL, `guestnotes` int default '0' NOT NULL, `salt` varchar(255) NOT NULL, `lastmodnote` int default '0' NOT NULL, `newpms` int default '0' NOT NULL, `imflag` int default '0' NOT NULL, `orderalbums` varchar(255) NOT NULL, `lastguestnote` int default '0' NOT NULL, `autosubscribe` varchar(255) NOT NULL, `notifymethod` varchar(255) NOT NULL, `showavatars` varchar(255) NOT NULL, `showsigs` varchar(255) NOT NULL, `warninglevel` int default '0' NOT NULL, `topics` int default '0' NOT NULL, `posts` int default '0' NOT NULL, `chatcolor` 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` tinyint(1) default '0' NOT NULL, `canusehtml` tinyint(1) 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, `canpm` int default '0' NOT NULL, `canim` int default '0' NOT NULL, `canharddelete` int default '0' NOT NULL, `limitpms` varchar(255) NOT NULL, `limitpmsdaily` varchar(255) NOT NULL, `canviewdeleted` int default '0' NOT NULL, `cansubmitpolls` int default '0' NOT NULL, `candeletepolls` int default '0' NOT NULL, `candeleteownpolls` int default '0' NOT NULL, `caneditpolls` int default '0' NOT NULL, `caneditownpolls` int default '0' NOT NULL, `attachperpost` int default '0' NOT NULL, `attachperpm` int default '0' NOT NULL, `canviewshouts` int default '0' NOT NULL, `caneditshouts` int default '0' NOT NULL, `caneditownshouts` int default '0' NOT NULL, `candeleteshouts` int default '0' NOT NULL, `candeleteownshouts` int default '0' NOT NULL, `cansubmitshouts` int default '0' NOT NULL, `canpollvote` int default '0' NOT NULL, `customtitle` int default '0' NOT NULL, `canviewinvisible` int default '0' NOT NULL, `namestyle` varchar(255) NOT NULL, `canpmimportant` int default '0' NOT NULL, `canviewmodlog` int default '0' NOT NULL, `isleader` int default '0' NOT NULL, `cansubmitquotes` int default '0' NOT NULL, `validatequotes` int default '0' NOT NULL, `candeletequotes` int default '0' NOT NULL, `candeleteownquotes` int default '0' NOT NULL, `canreport` int default '0' NOT NULL, `canusesearch` int default '0' NOT NULL, `attachperlink` int default '0' NOT NULL, `validateattachments` tinyint(1) default '0' NOT NULL, `caneditownquotes` int default '0' NOT NULL, `caneditallquotes` int default '0' NOT NULL, `canviewchat` int default '0' NOT NULL, `caneditownevents` int default '0' NOT NULL, `caneditallevents` int default '0' NOT NULL, `candeleteownevents` int default '0' NOT NULL, `candeleteevents` int default '0' NOT NULL, `cansubmitevents` int default '0' NOT NULL, `validateevents` int default '0' NOT NULL, `bulkpms` int default '0' NOT NULL, `issupermod` tinyint(1) default '0' 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, `lastsearch` int default '0' NOT NULL, `nopermission` int default '0' NOT NULL, `inchat` tinyint(1) default '0' NOT NULL, `name` varchar(255) NOT NULL, `isrobot` int default '0' NOT NULL, `lastchat` int default '0' NOT NULL, `groupnamestyle` varchar(255) NOT NULL, `acceptims` varchar(255) NOT NULL, `visibility` varchar(255) 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}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) NOT NULL, `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) ); create table {PREFIX}modlog ( `id` int NOT NULL auto_increment, `topicid` int default '0' NOT NULL, `postid` int default '0' NOT NULL, `type` varchar(255) NOT NULL, `nature` varchar(255) NOT NULL, `reason` text NOT NULL, `moderatorid` int default '0' NOT NULL, `source` int default '0' NOT NULL, `destination` int default '0' NOT NULL, `time` int default '0' NOT NULL, `catid` int default '0' NOT NULL, `memberid` int default '0' NOT NULL, UNIQUE KEY id (id) ); create table {PREFIX}attachments ( `id` int NOT NULL auto_increment, `type` varchar(255) NOT NULL, `objectid` int default '0' NOT NULL, `filename` varchar(255) NOT NULL, `filetitle` varchar(255) NOT NULL, `filesize` int default '0' NOT NULL, `width` int default '0' NOT NULL, `height` int default '0' NOT NULL, `memberid` int default '0' NOT NULL, `time` int default '0' NOT NULL, `deleted` tinyint(1) default '0' NOT NULL, `field` varchar(255) NOT NULL, `downloads` int default '0' NOT NULL, `validated` tinyint(1) default '0' NOT NULL, `ownerip` varchar(255) NOT NULL, UNIQUE KEY id (id) ); create table {PREFIX}helpcategory ( `id` int NOT NULL auto_increment, `name` varchar(255) NOT NULL, `numsubjects` int default '0' NOT NULL, `priority` int default '0' NOT NULL, UNIQUE KEY id (id) ); create table {PREFIX}helpitem ( `id` int NOT NULL auto_increment, `subject` varchar(255) NOT NULL, `helptext` text NOT NULL, `priority` int default '0' NOT NULL, `category` int default '0' NOT NULL, UNIQUE KEY id (id) ); create table {PREFIX}crons ( `id` int NOT NULL auto_increment, `frequency` int default '0' NOT NULL, `nextrun` int default '0' NOT NULL, `filename` varchar(255) NOT NULL, `native` tinyint(1) default '0' NOT NULL, UNIQUE KEY id (id) ); create table {PREFIX}im ( `id` int NOT NULL auto_increment, `toid` int default '0' NOT NULL, `fromid` int default '0' NOT NULL, `message` text NOT NULL, `time` int default '0' NOT NULL, `isread` tinyint(1) default '0' NOT NULL, `timeread` int default '0' NOT NULL, `deleted` 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` text NOT NULL, `deleted` tinyint(1) default '0' NOT NULL, `flag` int default '0' NOT NULL, `filefield` varchar(255) NOT NULL, `important` int default '0' NOT NULL, `replyto` int default '0' NOT NULL, `replied` int default '0' NOT NULL, `sentdeleted` 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,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) 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', 'yes', '0', '0', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Administrator', '0', '', '', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', 'sdg', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO {PREFIX}crons(id,frequency,nextrun,filename,native) VALUES ('6', '3600', '1151447175', 'hourly.php', '1'); INSERT INTO {PREFIX}crons(id,frequency,nextrun,filename,native) VALUES ('8', '86400', '1151530142', 'daily.php', '0'); INSERT INTO {PREFIX}crons(id,frequency,nextrun,filename,native) VALUES ('9', '43200', '1150633210', '12hours.php', '0'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('1', 'wsncode', '[b]', '', 'Put text in bold.', '[/b]', '', '1'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('3', 'wsncode', '[i]', '', 'Put text in italics.', '[/i]', '', '2'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('10', 'smilie', ':D', 'grin', 'grin', '', '', '3'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('8', 'smilie', ':)', 'smiling face', 'smiling face', '', '', '1'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('9', 'smilie', '{semicolon})', 'wink', 'wink', '', '', '2'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('11', 'smilie', ':confused:', 'confused', 'confused', '', '', '8'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('12', 'smilie', ':cool:', 'cool', 'cool', '', '', '4'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('13', 'smilie', ':eek:', 'shocked', 'shocked', '', '', '9'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('14', 'smilie', ':eyebrow:', 'raised eyebrow', 'raised eyebrow', '', '', '7'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('15', 'smilie', ':(', 'sad', 'sad', '', '', '13'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('16', 'smilie', ':mad:', 'mad', 'mad', '', '', '14'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('17', 'smilie', ':no:', 'shaking head', 'shaking head', '', '', '10'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('18', 'smilie', ':nod:', 'nod', 'nod', '', '', '5'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('19', 'smilie', ':nono:', 'disapproval', 'disapproval', '', '', '11'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('20', 'smilie', ':rolleyes:', 'rolling eyes', 'rolling eyes', '', '', '12'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('21', 'smilie', ':p', 'sticking out tongue', 'sticking out tongue', '', '', '6'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('23', 'wsncode', '[quote={PARAM}]', '
{PARAM} wrote:
', 'Quote text written by someone.', '[/quote]', '
', '4'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('24', 'wsncode', '[quote]', '
', 'Quote without attribution.', '[/quote]', '
', '5'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('25', 'wsncode', '[code]', '
', 'Type code such as HTML, PHP, C++, etc.', '[/code]', '
', '9'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('26', 'wsncode', '[url={PARAM}]', '', 'Link text to a URL.', '[/url]', '', '6'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('27', 'wsncode', '[url]', '', 'Link a URL.', '[/url]', '', '7'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('33', 'wsncode', '[color={PARAM}]', '', 'Places text in specified color.', '[/color]', '', '10'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('29', 'wsncode', '[size={PARAM}]', '', 'Set the size of text.', '[/size]', '', '11'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('30', 'wsncode', '[*]', '
  • ', 'Bullet point inside a list.', '', '', '13'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('31', 'wsncode', '[list]', '', '12'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('32', 'wsncode', '[u]', '', 'Underline text', '[/u]', '', '3'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('34', 'wsncode', '[font={PARAM}]', '', 'Put text in the specified font.', '[/font]', '', '15'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('35', 'wsncode', '[hr]', '
    ', 'Horizontal rule.', '', '', '16'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('36', 'wsncode', '[numbered]', '
      ', 'Numbered list.', '[/numbered]', '
    ', '14'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('37', 'wsncode', '[center]', '
    ', 'Center text.', '[/center]', '
    ', '17'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('38', 'wsncode', '[highlight={PARAM}]', '', 'Set background color for text.', '[/highlight]', '', '20'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('39', 'wsncode', '[indent={PARAM}]', '
    ', 'Indent by specified number of pixels.', '[/indent]', '
    ', '19'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('40', 'wsncode', '[right]', '
    ', 'Align text to right.', '[/right]', '
    ', '18'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('42', 'wsncode', '[email]', '', 'Clickable email address.', '[/email]', '', '21'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('43', 'wsncode', '[img]', '', '8'); INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('44', 'wsncode', '[strike]', '', 'Cross out text.', '[/strike]', '', '22');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) 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'); 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) 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','0','0','0','0','0','0','1','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) 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','0','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','0','0','0','0','0','0','1','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','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','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',''); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('148','parsecodemembers',''); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('149','smiliesmembers',''); 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',''); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('111','menustate','expanded'); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('110','uniquetotal','171'); 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|||aftereditavatar[,]|||afterreportlink[,]|||afterreportpost[,]comments.php?id={LINKID}|||afteremaillink[,]'); 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="&6"& cellpadding="&6"&'); 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','../styles/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','1151443742'); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('95','backupfile',''); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('94','lastupdate','1150590009'); 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','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="&_blank"&'); 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','500'); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('156','linebreakmembers',''); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('155','linebreakcomments',''); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('154','linebreakcategories',''); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('228','pagestoshow','10'); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('153','linebreaklinks',''); 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','1151443575'); 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','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','15'); 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}.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','1151443575'); 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','1149957557'); 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','<&option value="&{CATID}"&>&{CATINDENT} {CATNAME}<&/option>&'); 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','1150590010'); 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->&links * 2) + $this->&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 ('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',''); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('230','smiliespms',''); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('231','parsecodepms',''); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('232','linebreakpms',''); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('233','linkimportance','$importance = ($this->&hitsoutpermonth() + $this->&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','15'); 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}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 ('278','contactforum',''); 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=WYSIWYG[,]links=0[,]comments=0[,]'); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('386','sponsoreachtype','no'); 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','20000'); 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','44cac466012927f7bb7b21463037c5e8.wsn'); 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="&background-image: url('&{TEMPLATESDIR}/images/columnheader.png'&){semicolon} background-repeat: repeat-x{semicolon}"&'); 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','2'); 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 <&br>& %X'); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('327','digesttime','1151443575'); 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.) <&br>&<&br>& - You may not submit illegal content. <&br>&<&br>& - Attempting to flood with many submissions is not allowed, nor are automated submissions are allowed. <&br>&<&br>& - Comment posts may not be abusive. <&br>&<&br>& - 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 ('352','consecutiveshouts','100'); 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 ('362','rewritelinkname','links/{LINKTITLE}-{LINKID}.html'); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('363','rewritethreadnames','no'); 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 ('366','necroposts','0'); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('367','necrodays','0'); 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 ('374','chatdelay','5'); 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 ('377','chatminutes','2000'); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('378','chatlimit','75'); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('379','chatactivity',' '); 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','no'); INSERT INTO {PREFIX}settings(id,name,content) VALUES ('387','staticasadmin','no'); 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','0'); 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','0'); INSERT INTO {PREFIX}switches(id,name,value) VALUES ('25','inlinestyle','0'); INSERT INTO {PREFIX}switches(id,name,value) VALUES ('26','buddyignore','0'); INSERT INTO {PREFIX}switches(id,name,value) VALUES ('27','guestbook','0'); INSERT INTO {PREFIX}switches(id,name,value) VALUES ('28','usernotes','0'); INSERT INTO {PREFIX}switches(id,name,value) VALUES ('29','modnotify','0'); INSERT INTO {PREFIX}switches(id,name,value) VALUES ('30','similar','0'); INSERT INTO {PREFIX}switches(id,name,value) VALUES ('31','shoutbox','0'); INSERT INTO {PREFIX}switches(id,name,value) VALUES ('32','shoutbox','0'); 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','0'); 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','0'); 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','1'); INSERT INTO {PREFIX}switches(id,name,value) VALUES ('57','emaillogin','0'); INSERT INTO {PREFIX}switches(id,name,value) VALUES ('58','trader','1'); CREATE INDEX wsnindex ON {PREFIX}links (catid,time,title(5)); CREATE INDEX wsnindex ON {PREFIX}categories (priority); CREATE INDEX wsnindex ON {PREFIX}comments (linkid,time); CREATE INDEX wsnindex ON {PREFIX}members (id,time); ALTER TABLE {PREFIX}links ADD FULLTEXT `titleindex` (`title`); ALTER TABLE {PREFIX}comments ADD FULLTEXT `messageindex` (`message`);