TABLE link FIELDS id int default '0' NOT NULL auto_increment,title text NOT NULL,url text NOT NULL,description text NOT NULL,rating real,votes int default '0' NOT NULL,validated int 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 int 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 int default '0' NOT NULL,downloads int default '0' NOT NULL,pendingedit text NOT NULL,funds real,suspended int default '0' NOT NULL,alias int default '0' NOT NULL,expire int default '0' NOT NULL,ip text NOT NULL,inalbum int 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 int 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,parentids text NOT NULL,timesdead int default '0' NOT NULL,timesemailed int default '0' NOT NULL,threadclosed int default '0' NOT NULL,threadposters text NOT NULL,price real,longdescription text NOT NULL,xwidth int default '0' NOT NULL,yheight int default '0' NOT NULLTABLE category FIELDS id int default '0' NOT NULL auto_increment,name text NOT NULL,parent int default '0' NOT NULL,validated int 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 int 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 int 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 NULLTABLE comment FIELDS id int default '0' 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 int default '0' NOT NULL,inhidden int default '0' NOT NULLTABLE member FIELDS id int default '0' 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 int 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,notifyoflinks text NOT NULL,lastvisit int default '0' NOT NULL,timezone real,rating real,pmfolders text NOT NULL,notifyofpms text NOT NULL,acceptpms text NOT NULL,cookieduration int default '0' NOT NULL,banned text NOT NULLTABLE usergroup FIELDS id int default '0' NOT NULL auto_increment,title text NOT NULL,caneditown int default '0' NOT NULL,caneditall int default '0' NOT NULL,canvote int default '0' NOT NULL,isadmin int default '0' NOT NULL,canpost int default '0' NOT NULL,canemail int default '0' NOT NULL,validatecats int default '0' NOT NULL,validatecomments int default '0' NOT NULL,validatelinks int default '0' NOT NULL,validateedits int default '0' NOT NULL,cansubmitlinks int default '0' NOT NULL,cansubmitcategories int default '0' NOT NULL,cansubmitcomments int default '0' NOT NULL,caneditownlinks int default '0' NOT NULL,caneditowncategories int default '0' NOT NULL,caneditowncomments int default '0' NOT NULL,caneditownprofile int default '0' NOT NULL,caneditalllinks int default '0' NOT NULL,caneditallcategories int default '0' NOT NULL,caneditallcomments int default '0' NOT NULL,caneditallprofiles int default '0' NOT NULL,candownloadfiles int default '0' NOT NULL,canupload int default '0' NOT NULL,canviewip int 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 int default '0' NOT NULL,cancopy int default '0' NOT NULL,candeleteown int default '0' NOT NULL,candeleteall int default '0' NOT NULL,candofulledit int default '0' NOT NULL,candeletecategories int default '0' NOT NULL,candeletecomments int default '0' NOT NULL,candeleteowncategories int default '0' NOT NULL,candeleteowncomments int default '0' NOT NULL,candeletemembers int default '0' NOT NULL,candeleteownmembers int default '0' NOT NULL,canaliascategories int default '0' NOT NULL,canviewpages int default '0' NOT NULL,caneditvotes int default '0' NOT NULL,numaliases int default '0' NOT NULL,canviewvotes int default '0' NOT NULL,canhideownlinks int default '0' NOT NULL,canhideowncategories int default '0' NOT NULL,canhideowncomments int default '0' NOT NULL,canhidealllinks int default '0' NOT NULL,canhideallcategories int default '0' NOT NULL,canhideallcomments int default '0' NOT NULL,canratecomments int default '0' NOT NULL,bytespermem text NOT NULLTABLE email FIELDS id int default '0' 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 int default '0' NOT NULLTABLE session FIELDS id int default '0' 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 NULLTABLE rating FIELDS id int default '0' 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 NULLTABLE pm FIELDS id int default '0' 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 int default '0' NOT NULL,attachment text NOT NULLTABLE switches FIELDS id int default '0' NOT NULL auto_increment,name text NOT NULL,value int default '0' NOT NULLTABLE markup FIELDS id int default '0' NOT NULL auto_increment,type char(),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 [ITEM] detailhits [DEFAULT] yes[ITEM] ulsearchadult [DEFAULT] 1[ITEM] ulsearchlinktype [DEFAULT] [ITEM] ulsearchmax [DEFAULT] 2[ITEM] ulsearchid [DEFAULT] 1[ITEM] ulsearch [DEFAULT] no[ITEM] sponsorrevert [DEFAULT] [ITEM] sponsorusergroup [DEFAULT] [ITEM] confirmvote [DEFAULT] yes[ITEM] iplength [DEFAULT] 12[ITEM] expirecookie [DEFAULT] 365[ITEM] htmlautogeneratecat [DEFAULT] cat{CATID}{PAGE}.htm[ITEM] accountemail [DEFAULT] [ITEM] rewritenames [DEFAULT] no[ITEM] cookiepolicy [DEFAULT] www.somesite.com/w3c/p3p.xml[ITEM] restricthitsbyip [DEFAULT] no[ITEM] rewriteignorelinks [DEFAULT] yes[ITEM] alloweddups [DEFAULT] [ITEM] onlinedate [DEFAULT] %x - %X[ITEM] nohttp [DEFAULT] yes[ITEM] smilieslinks [DEFAULT] [ITEM] parsecodecomments [DEFAULT] message[ITEM] parsecodemembers [DEFAULT] signature[ITEM] smiliesmembers [DEFAULT] signature[ITEM] commentsperpage [DEFAULT] 15[ITEM] parsecodelinks [DEFAULT] [ITEM] parsecodecategories [DEFAULT] [ITEM] submittervote [DEFAULT] yes[ITEM] cookiedomain [DEFAULT] [ITEM] cookieduration [DEFAULT] 100000000[ITEM] smiliescategories [DEFAULT] [ITEM] smiliescomments [DEFAULT] message[ITEM] menustate [DEFAULT] expanded[ITEM] uniquetotal [DEFAULT] 4864[ITEM] totalmembers [DEFAULT] 0[ITEM] mime [DEFAULT] plain text[ITEM] checkoutnum [DEFAULT] [ITEM] queue [DEFAULT] yes[ITEM] checkfordupdomain [DEFAULT] no[ITEM] cookiepath [DEFAULT] [ITEM] htmlautogeneratesubs [DEFAULT] no[ITEM] htmlautogeneratedir [DEFAULT] admin/htmloutput[ITEM] htmlautogenerate [DEFAULT] no[ITEM] timeout [DEFAULT] 15[ITEM] onlineusers [DEFAULT] yes[ITEM] sendconfirmation [DEFAULT] no[ITEM] fixedwidth [DEFAULT] [ITEM] compress [DEFAULT] no[ITEM] checkfordup [DEFAULT] no[ITEM] redirects [DEFAULT] 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[ITEM] searchperpage [DEFAULT] 15[ITEM] totalmembers [DEFAULT] 0[ITEM] backupdelay [DEFAULT] [ITEM] logsearches [DEFAULT] no[ITEM] skiptocat [DEFAULT] [ITEM] standardtable [DEFAULT] cellspacing="6" cellpadding="6"[ITEM] secondsdelay [DEFAULT] 3[ITEM] standardsize [DEFAULT] 30[ITEM] modapprove [DEFAULT] yes[ITEM] stylesheet [DEFAULT] default[ITEM] apacherewrite [DEFAULT] no[ITEM] orderlinks2 [DEFAULT] ORDER BY title ASC[ITEM] commenttypes [DEFAULT] regular[ITEM] mixcomments [DEFAULT] yes[ITEM] maximageheight [DEFAULT] 5000[ITEM] maximagewidth [DEFAULT] 5000[ITEM] marknewupdates [DEFAULT] 5[ITEM] lastdaily [DEFAULT] 1117328209[ITEM] backupfile [DEFAULT] [ITEM] lastupdate [DEFAULT] 1116895420[ITEM] debittime [DEFAULT] 1117328209[ITEM] sponsoruselink [DEFAULT] no[ITEM] sponsorlinktype [DEFAULT] [ITEM] sponsorcharge [DEFAULT] [ITEM] totalhits [DEFAULT] 0[ITEM] totalhitsin [DEFAULT] 0[ITEM] sponsoritem [DEFAULT] [ITEM] lastautocron [DEFAULT] 1089756505[ITEM] totallinks [DEFAULT] 0[ITEM] totalcomments [DEFAULT] 0[ITEM] avatarsize [DEFAULT] 50000[ITEM] avatarwidth [DEFAULT] 100[ITEM] avatarheight [DEFAULT] 100[ITEM] avatartypes [DEFAULT] gif,jpg,jpeg,png[ITEM] descriplength [DEFAULT] 1000[ITEM] cattypes [DEFAULT] regular[ITEM] mainmeta [DEFAULT] [ITEM] maplevels [DEFAULT] 6[ITEM] externallinks [DEFAULT] target="_blank"[ITEM] minvote [DEFAULT] 1[ITEM] maxvote [DEFAULT] 5[ITEM] dontcount [DEFAULT] no[ITEM] integration [DEFAULT] [ITEM] censor [DEFAULT] [ITEM] perqueue [DEFAULT] 10[ITEM] memberlistorder [DEFAULT] ORDER BY time DESC[ITEM] selectorlevels [DEFAULT] 2[ITEM] expiretime [DEFAULT] 72[ITEM] linebreakmembers [DEFAULT] signature[ITEM] linebreakcomments [DEFAULT] message[ITEM] linebreakcategories [DEFAULT] description[ITEM] pagestoshow [DEFAULT] 10[ITEM] linebreaklinks [DEFAULT] description,longdescription[ITEM] resetscript [DEFAULT] [ITEM] filesize [DEFAULT] 10000000[ITEM] filetypes [DEFAULT] gif,jpg,jpeg,png,zip,gz,txt,lng,pdf[ITEM] uploadpath [DEFAULT] /var/www/wsnlinks315/attachments/[ITEM] ratingdecimal [DEFAULT] 2[ITEM] resettime [DEFAULT] 1117328209[ITEM] resetfields [DEFAULT] [ITEM] floodcheck [DEFAULT] 20[ITEM] registration [DEFAULT] direct[ITEM] admindir [DEFAULT] admin[ITEM] resetdelay [DEFAULT] 7[ITEM] requiredmembers [DEFAULT] name,password,email[ITEM] requiredcomments [DEFAULT] message[ITEM] requiredcategories [DEFAULT] name[ITEM] bannedips [DEFAULT] [ITEM] requiredlinks [DEFAULT] title[ITEM] maxsubcats [DEFAULT] 30[ITEM] defaultlang [DEFAULT] default[ITEM] allowhtml [DEFAULT] no[ITEM] linktypes [DEFAULT] regular,recip[ITEM] clicktimer [DEFAULT] 60[ITEM] condition [DEFAULT] [ITEM] ordercomments [DEFAULT] ORDER BY time ASC[ITEM] searchfields [DEFAULT] title,url,description,price,longdescription[ITEM] mixrecip [DEFAULT] yes[ITEM] notify [DEFAULT] yes[ITEM] myurl [DEFAULT] [ITEM] perpage [DEFAULT] 14[ITEM] marknew [DEFAULT] 7[ITEM] dateformat [DEFAULT] %x[ITEM] locale [DEFAULT] english[ITEM] templatesdir [DEFAULT] templates/default[ITEM] excludedtoadmin [DEFAULT] [ITEM] ulsearchcatmax [DEFAULT] 2[ITEM] dirurl [DEFAULT] http://localhost/wsnlinks315[ITEM] adminbypass [DEFAULT] no[ITEM] commentsdateformat [DEFAULT] %x - %X[ITEM] debug [DEFAULT] 0[ITEM] email [DEFAULT] [ITEM] htmlautogeneratelin [DEFAULT] link{LINKID}.htm[ITEM] ordercats [DEFAULT] ORDER BY name ASC[ITEM] orderlinks [DEFAULT] ORDER BY time DESC[ITEM] subcatcols [DEFAULT] 1[ITEM] catcols [DEFAULT] 3[ITEM] rewritecategoryspace [DEFAULT] _[ITEM] linkcols [DEFAULT] 1[ITEM] lastrotation [DEFAULT] 1117328209[ITEM] passwordlength [DEFAULT] 7[ITEM] htmlautogeneratecom [DEFAULT] comments{LINKID}{PAGE}.htm[ITEM] htmlautogenerateabsurl [DEFAULT] [ITEM] htmlautogeneratepagesep [DEFAULT] -[ITEM] jsexporttoplist [DEFAULT] [ITEM] jsexportnamelist [DEFAULT] [ITEM] backupname [DEFAULT] backup.sql[ITEM] trackviews [DEFAULT] no[ITEM] countalbums [DEFAULT] no[ITEM] customhead [DEFAULT] custom-html_wrapper[ITEM] customfoot [DEFAULT] custom-html_footer[ITEM] customindex [DEFAULT] custom-html_main[ITEM] customcat [DEFAULT] custom-html_displaylinks[ITEM] customitem [DEFAULT] custom-html_details[ITEM] customcomments [DEFAULT] custom-html_viewcomments[ITEM] hitstempdays [DEFAULT] 30[ITEM] htmlautogenerateindex [DEFAULT] index.htm[ITEM] hitstempreset [DEFAULT] 1115181981[ITEM] sponsorlinkrevert [DEFAULT] [ITEM] sendsponsorendemail [DEFAULT] yes[ITEM] sendexpirationemail [DEFAULT] no[ITEM] emailsig [DEFAULT] [ITEM] searchcols [DEFAULT] 1[ITEM] sendvalidation [DEFAULT] yes[ITEM] attachmentmethod [DEFAULT] random[ITEM] categoryselector [DEFAULT] [ITEM] currentletter [DEFAULT] M[ITEM] paypalemail [DEFAULT] [ITEM] searchhighlightexclude [DEFAULT] [ITEM] backuppath [DEFAULT] [ITEM] optionscontent [DEFAULT] <option value="{CATID}">{CATINDENT} {CATNAME}</option>[ITEM] sponsorugcharge [DEFAULT] [ITEM] sponsorugitem [DEFAULT] [ITEM] sponsoruseug [DEFAULT] no[ITEM] waterthumbs [DEFAULT] [ITEM] sponsorcatresults [DEFAULT] 5[ITEM] sponsorsearchresults [DEFAULT] 5[ITEM] sponsorseparate [DEFAULT] yes[ITEM] offsetfromgmt [DEFAULT] -8[ITEM] defaulttimezone [DEFAULT] -8[ITEM] searchlax [DEFAULT] yes[ITEM] defaultsearchtype [DEFAULT] and[ITEM] membersperpage [DEFAULT] 15[ITEM] staticexporturllist [DEFAULT] [ITEM] staticexportnamelist [DEFAULT] [ITEM] staticexporttime [DEFAULT] 1117328209[ITEM] emailf [DEFAULT] no[ITEM] alternateemails [DEFAULT] [ITEM] ipbanfrom [DEFAULT] whole site[ITEM] memberrating [DEFAULT] $rating = $this->links + $this->comments[ITEM] searchlinksorder [DEFAULT] ORDER BY rating DESC[ITEM] searchcatsorder [DEFAULT] ORDER BY numlinks DESC[ITEM] searchcomsorder [DEFAULT] ORDER BY time DESC[ITEM] searchmemsorder [DEFAULT] ORDER BY name ASC[ITEM] sitemaporder [DEFAULT] [ITEM] spideragents [DEFAULT] googlebot slurp[ITEM] allowrevote [DEFAULT] no[ITEM] rewritelink [DEFAULT] links[ITEM] rewritethread [DEFAULT] thread[ITEM] sigchars [DEFAULT] 1000[ITEM] siglines [DEFAULT] 20[ITEM] comchars [DEFAULT] 1[ITEM] ulsearchdefaultquery [DEFAULT] [ITEM] catsperpage [DEFAULT] 300[ITEM] adminips [DEFAULT] [ITEM] securityimage [DEFAULT] no[ITEM] pmsperpage [DEFAULT] 20[ITEM] requiredpms [DEFAULT] message,subject[ITEM] smiliespms [DEFAULT] message[ITEM] parsecodepms [DEFAULT] message[ITEM] linebreakpms [DEFAULT] message[ITEM] linkimportance [DEFAULT] $importance = ($this->hitsoutpermonth() + $this->numcomments) + 6[ITEM] onlinemembersmax [DEFAULT] 0|||0[ITEM] onlineguestsmax [DEFAULT] 0|||0[ITEM] commenthits [DEFAULT] no[ITEM] searchhighlight [DEFAULT] yes[ITEM] onlinetotalmax [DEFAULT] 0|||0[ITEM] sponsoruseppc [DEFAULT] no[ITEM] subscriptionexclusion [DEFAULT] [ITEM] memberdecriment [DEFAULT] yes[ITEM] sponsorbonuscutoff [DEFAULT] [ITEM] sponsorbonuspercent [DEFAULT] [ITEM] wordwrap [DEFAULT] 60[ITEM] sitetitle [DEFAULT] Links Directory[ITEM] sitedescription [DEFAULT] [ITEM] maxusernamelength [DEFAULT] 20[ITEM] comwords [DEFAULT] 1[ITEM] illegaldomains [DEFAULT] [ITEM] magickpath [DEFAULT] /usr/bin/convert[ITEM] graphicsprog [DEFAULT] GD[ITEM] thumbwidth [DEFAULT] 100[ITEM] thumbheight [DEFAULT] 100[ITEM] fixedsize [DEFAULT] no[ITEM] offlinereason [DEFAULT] [ITEM] offline [DEFAULT] no[ITEM] orderalbum [DEFAULT] ORDER BY title ASC[ITEM] topsearcheslength [DEFAULT] 3[ITEM] perpagealbums [DEFAULT] 14[ITEM] dontcountowner [DEFAULT] no[ITEM] sessiondelete [DEFAULT] 15[ITEM] ppcprovider [DEFAULT] ulsearch [ITEM] members [DEFAULT] 1[ITEM] ratings [DEFAULT] 1[ITEM] hits [DEFAULT] 1[ITEM] comments [DEFAULT] 1[ITEM] subscriptions [DEFAULT] 1[ITEM] albums [DEFAULT] 1[ITEM] getmeta [DEFAULT] 1[ITEM] pm [DEFAULT] 0[ITEM] wsncodes [DEFAULT] 1[ITEM] smilies [DEFAULT] 1[ITEM] showsubs [DEFAULT] 1[ITEM] searchincat [DEFAULT] 1[ITEM] catselector [DEFAULT] 1[ITEM] onlineusers [DEFAULT] 1[ITEM] styleselect [DEFAULT] 0[ITEM] templateselect [DEFAULT] 0[ITEM] linkcheckers [DEFAULT] 1[ITEM] reports [DEFAULT] 1[ITEM] sortcats [DEFAULT] 1[ITEM] sortlinks [DEFAULT] 1[ITEM] attachmentstree [DEFAULT] 0[ITEM] requirerecip [DEFAULT] 0[ITEM] tos [DEFAULT] 1