| Message Text |
Hi Paul,
Just started a new site, got the latest version of your very fine script. 
Small hiccup or my rusted memory on how to use certain things in WSN Links? The problem:
<!-- BEGIN TOPLIST 5 -->
<CONFIG>links,id,5,ascending,title='testlinktitle',,,0,0,0,0,0,0,,0</CONFIG>
{LINKID} - for each link, the ID, in the Show Links in Category
<!-- END TOPLIST 5 -->
I put the above toplist, for testing purposes, into the 'Show Links in Category' and the 'Linkbit' template. Obviously the toplist numbers are different, and I changed the end of the sentence of what should show up in a toplist item from 'Show Links in Category' to 'Linkbit', so I can clearly see what I am testing. This is all fine.
Oddly enough, the Linkbit toplist doesn't display the results, even though it does find them. In reality there is only one link to find, but that's besides the point.
Here is the debug info:
Load time so far: 0.25 seconds.
Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 93
Load time so far: 0.25 seconds.
Query 3: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 26
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Load time so far: 0.25 seconds.
Query 4: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,`canpost`,`canemail`,`validatecats`,`validatecomments`,`validatelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategories`,`cansubmitcomments`,`caneditownlinks`,`caneditowncategories`,`caneditowncomments`,`caneditownprofile`,`caneditalllinks`,`caneditallcategories`,`caneditallcomments`,`caneditallprofiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitlinks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`canalias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit`,`candeletecategories`,`candeletecomments`,`candeleteowncategories`,`candeleteowncomments`,`candeletemembers`,`candeleteownmembers`,`canaliascategories`,`canviewpages`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideowncategories`,`canhideowncomments`,`canhidealllinks`,`canhideallcategories`,`canhideallcomments`,`canratecomments`,`bytespermem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpmsdaily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`candeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachperpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`caneditownshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmitshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`namestyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubmitquotes`,`validatequotes`,`candeletequotes`,`candeleteownquotes`,`canreport`,`canusesearch`,`attachperlink`,`validateattachments`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes`,`canviewownfulltrc`,`canviewallfulltrc` FROM wsnlinks_membergroups WHERE id>0
Load time so far: 0.34 seconds.
Query 5: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM wsnlinks_categories WHERE id=6
Load time so far: 0.34 seconds.
Query 6: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10
Number of rows is 2
Load time so far: 0.34 seconds.
Query 7: SELECT COUNT(id) FROM wsnlinks_email WHERE `to`='testemail@gmail.com' AND subject='Submission declined' AND message='The link you submitted, ( ), has been declined. It was not added to the directory. ' AND timesent > 1212071470
Count is 1
Load time so far: 0.35 seconds.
Query 8: SELECT COUNT(id) FROM wsnlinks_email WHERE `to`='testemail@gmail.com' AND subject='Submission declined' AND message='The link you submitted, ( ), has been declined. It was not added to the directory. ' AND timesent > 1212071470
Count is 1
Load time so far: 0.4 seconds.
Query 9: SELECT `catid` FROM wsnlinks_sessions WHERE catid>0 AND time > 1212090570
Number of rows is 2
Load time so far: 0.41 seconds.
Query 10: UPDATE wsnlinks_categories SET numonline='0' WHERE 1=1
Load time so far: 0.41 seconds.
Query 11: UPDATE wsnlinks_categories SET numonline='2' WHERE id=6
Load time so far: 0.41 seconds.
Query 12: SELECT `id`,`frequency`,`filename`,`nextrun` FROM wsnlinks_crons WHERE nextrun < 1212091470 ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.41 seconds.
Query 13: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,
`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM wsnlinks_categories WHERE id=6
Load time so far: 0.44 seconds.
Query 14: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM wsnlinks_categories WHERE parent=6 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC LIMIT 0,40
Number of rows is 0
Load time so far: 0.45 seconds.
Query 15: SELECT `id`,`title`,`url`,`description`,`rating`,`votes`,`validated`,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,`suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`recipurl`,`hitsin`,`recipwith`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parentids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposters`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`deletionreason`,`movedto`,`deletedby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloads`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`helyseg`,`ar`,`varos`,`epitoanyag`,`alapterulet`,`kertmeret`,`epiteseve`,`szobaszam`,`felszobaszam`,`erkely`,`franciaerkely`,`galeria`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`emeleten`,`parkolas`,`parkolasautok`,`lakasallapot`,`epuletallapot`,`extrak`,`butorozott`,`emeletek`,`kiadoelado`,`milyenar` FROM wsnlinks_links WHERE catid=6 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1212091470 ORDER BY time DESC,title ASC LIMIT 0,20
Number of rows is 1
Creating link with Array as row
Load time so far: 0.47 seconds.
Query 16: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=6 AND validated=1 AND hide=0 AND deleted=0 AND type='regular' AND effectivetime < 1212091470
Count is 1
Load time so far: 0.47 seconds.
Query 17: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=6 AND validated=1 AND hide=0 AND deleted=0 AND type='recip' AND effectivetime < 1212091470
Count is 0
Load time so far: 0.47 seconds.
Query 18: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM wsnlinks_categories WHERE id=2
Setting cookie with name returnto, value http://testsite.com/index.php?action=displaycat&catid=6 and expiration time 0
Load time so far: 0.65 seconds.
Query 19: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE time > 1212090570 AND (catid=6 AND memberid>0) ORDER BY time DESC LIMIT 0,100
Number of rows is 1
Creating online with Array as row
Load time so far: 0.65 seconds.
Query 20: SELECT `id`,`title`,`url`,`description`,`rating`,`votes`,`validated`,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,`suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`recipurl`,`hitsin`,`recipwith`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parentids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposters`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`deletionreason`,`movedto`,`deletedby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloads`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`helyseg`,`ar`,`varos`,`epitoanyag`,`alapterulet`,`kertmeret`,`epiteseve`,`szobaszam`,`felszobaszam`,`erkely`,`franciaerkely`,`galeria`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`emeleten`,`parkolas`,`parkolasautok`,`lakasallapot`,`epuletallapot`,`extrak`,`butorozott`,`emeletek`,`kiadoelado`,`milyenar` FROM wsnlinks_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (title='testlinktitle' AND invisibleto NOT LIKE '%|1|%') AND effectivetime < 1212091470 AND alias=0 AND inalbum=0 ORDER BY id ASC LIMIT 0,5
Number of rows is 1
Creating link with Array as row
Load time so far: 0.66 seconds.
Query 21: SELECT `id`,`title`,`url`,`description`,`rating`,`votes`,`validated`,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,`suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`recipurl`,`hitsin`,`recipwith`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parentids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposters`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`deletionreason`,`movedto`,`deletedby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloads`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`helyseg`,`ar`,`varos`,`epitoanyag`,`alapterulet`,`kertmeret`,`epiteseve`,`szobaszam`,`felszobaszam`,`erkely`,`franciaerkely`,`galeria`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`emeleten`,`parkolas`,`parkolasautok`,`lakasallapot`,`epuletallapot`,`extrak`,`butorozott`,`emeletek`,`kiadoelado`,`milyenar` FROM wsnlinks_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (title='testlinktitle' AND invisibleto NOT LIKE '%|1|%') AND effectivetime < 1212091470 AND alias=0 AND inalbum=0 ORDER BY id ASC LIMIT 0,5
Number of rows is 1
Creating link with Array as row
Load time so far: 0.68 seconds.
Query 22: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE ip='78.92.7.154' AND memberid=0
Number of rows is 1
Creating online with Array as row
Load time so far: 0.7 seconds.
Query 23: UPDATE wsnlinks_sessions SET starttime='1212090526', time='1212091470', location='http://testsite.com/index.php?action=displaycat&catid=6', catid='6', threadid='', areaname='Családi Ház', nopermission='0', inchat='0', ip='78.92.7.154' WHERE id=18
So the Display Links template displays the link with the title='testlinktitle', while the Linkbit doesn't. Originally I had a single toplist in the Linkbit template, but when it didn't show up results for a while, I tried this approach, to see if this is a problem with my toplist, or with toplists in Linkbits.
What do you think Paul? Is there a remedy?
By the way, something is not right with posting a CODE here. I posted the toplist on top of this post, and the word 'ascending' turned into 'ascendArrayle'. At least, when I previewed my post.... let's see if the same happens when I submit...
Thanks
David |
