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
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...
The linkbit is a repeated area, repeated as many times as there are links on the page, so if you use a static number it won't be unique. You may be able to use {NUMBER} as the toplist number, not sure.
The {NUMBER} idea was good, but still doesn't show the results, just finds them...
Query 18: 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 < 1212180415 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.97 seconds.
Query 19: 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 < 1212180415 AND alias=0 AND inalbum=0 ORDER BY id ASC LIMIT 0,5
Well, before I impliment a way to do it, can you explain to me why anyone would ever want a toplist in the link bit? It doesn't seem like a place where it'd logically be useful, to me.
I want to have users who have the same information fields as the properties (links). As the admin, I would like to list all the properties in a table, and next to each property, I would like to show the users in the database who match the search query for that property (using the information in their profile). So for each link, the system will have to create a new toplist, running a whole lot of queries (as if submitting an advanced search).
The idea is to see a list of users who are looking for a similar property than the current listing. Does this make sense? Or perhaps there is an easier way to automatically perform an advanced search amongst users for each link list in the Display Links page?
So it's like the simliar links or related links, but for profiles?
Or perhaps there is an easier way to automatically perform an advanced search amongst users for each link list in the Display Links page?
There are easier ways to link to results, but not to display them right there. Displaying them in the link bit is really going to tax your server though, querying the members table an additional 15 times per page (if you have 15 listings per page). Even on my nearly empty local database with no visitors other than me it makes it painfully slow. If the database tables grow large and there are a lot of visitors, it could slow down to the point of being unuseable even on a dedicated server.
Anyhow, the problem here is that {LINK and {MEMBER template vars in the linkbit are already replaced with the appropriate values for the link. When toplists are processed it recognizes that there ought to be template variables there, so it goes back to re-extract from the original copy of the template... but that original copy doesn't have {NUMBER} replaced, so it can't find the toplist number.
At any rate, the {NUMBER} approach still kills all the other non-{NUMBER} toplists on the page so it's not a good solution. I'll have to come up with a sytax to allow numberless toplists, though they won't be able to use pagination. (This will only be in 4.2, of course, since it's very likely to create obscure bugs.)
I see. Yes, it would be something like the similar links. Actually, what i created the members as just another type of link? would that change anything? i guess not, since the query would still have to be done that many times.... but then again, what if: - somehow do an advanced search amongst the members, using the values from a new link, and generate static html of the results with a unique file that reflects the id of the new link - load this static page in an iframe next to the link in the linkbit
or better yet, save the output of a search result as html, right into a DB field for that link???
Am i crazy? Technically it should be possible? Any thoughts?
I don't see how in the world a link can be a member, since they're totally different sorts of things. A member is something you log in as, you can't log in as a link. Members are associated with links, but there's no clear way to associate a link with another type of link.
Anyhow an iframe would offer no advantage over the clear way of generating static pages with usewrapper=no and inserting them with <?php echo file_get_contents("yourstaticbitcontent.html"); ?>. However, since you're talking about a potentially infinite number of such static files, you would need a complicated system to handle all this generation.
Just finished implimenting numberless toplists. I'm actually getting 37 total queries, 4.33 seconds on it now (compared to 3 seconds without those toplists)... somehow it was slower when it didn't work. If you reduce the links per page to 10 it might work out.
If you can use the cache system (I mean the one at Admin -> Settings -> General at the top, not the much more complicated one you're proposing), that would take care of the load for sure.
My bad. I wasn't clear about the members there. I would have members, but a member would have an email, password, and phone. then they would be able to 'submit' a link that is a specific type (doesn't show on the site, doesn't count to anything). then when the admin pulls up the normal property listings, next to each property, are the results to the search query for that property which shows the 'member' type links that matched that search query.
so I'll download the latest version and see how I can use it? so anything special I should know about these numberless toplists?
If I put that in an iframe, it should do exactly what I wanted. BUT as soon as I add the custom template variable to the above url,
&custom=yes&TID=adminlisting
I get this error:
Load time so far: 0.08 seconds.
Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 93
Load time so far: 0.1 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.11 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.15 seconds.
Query 5: 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 0
Creating search with new as new
Query 6: INSERT INTO wsnlinks_searches(`value`,`memberid`,`catid`,`time`) VALUES('test','0','','1213030442')
Load time so far: 0.21 seconds.
Query 7: 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 inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1213030442) AND ((title LIKE '% test %' OR title = 'test' OR title LIKE 'test %' OR title LIKE '% test' OR title REGEXP (" test[\r]?[\n]") OR title REGEXP ("[\r]?[\n]test ") OR title REGEXP ("[\r]?[\n]test[\r]?[\n]")))) ORDER BY hits DESC LIMIT 0,60
Load time so far: 0.21 seconds.
Query 8: SELECT COUNT(id) FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1213030442) AND ((title LIKE '% test %' OR title = 'test' OR title LIKE 'test %' OR title LIKE '% test' OR title REGEXP (" test[\r]?[\n]") OR title REGEXP ("[\r]?[\n]test ") OR title REGEXP ("[\r]?[\n]test[\r]?[\n]")))) Count is 1
Number of rows is 1
Creating link with Array as row
Load time so far: 0.25 seconds.
Query 9: 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
Load time so far: 0.25 seconds.
Query 10: 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
Load time so far: 0.28 seconds.
Query 11: 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='81.183.138.40' AND memberid=0
Number of rows is 1
Creating online with Array as row
Load time so far: 0.28 seconds.
Query 12: UPDATE wsnlinks_sessions SET starttime='1213023087', time='1213030442', location='http://xxxxxxx.com/search.php?action=filter&&whichtype=links&titlecondition=like&titlesearch=test&usewrapper=no&custom=yes&TID=adminlisting', catid='', threadid='', areaname='Search Results', nopermission='0', inchat='0', ip='xx.183.138.40' WHERE id=35
and it seems like it finds the link, but it just shows the placeholders where the link's information should be. that custom admin template contains only this:
<IF {SHOWREGULAR}> <table {STANDARDTABLE}> <!-- BEGIN REGULAR LINKS --> {LINKTITLE} <!-- END REGULAR LINKS --> </table> </IF>
If I can use a custom template for a search that I submit via URL, then this issue is solved.
Please check my previous post, as it offers another solution to this, but needs to be able to call custom templates to a search.
Now, as for testing the above things in the 4.2.0 alpha 13. I put this into the Display Links template:
<!-- BEGIN TOPLIST 2{NUMBER} --> <CONFIG>links,id,5,ascending,title="testlinktitle",,,0,0,0,0,0,0,,0</CONFIG> {LINKID} {LINKDESCRIPTION} - for each link, the ID, in the Show Links in Category <!-- END TOPLIST 2{NUMBER} -->
I listed the link properly, but also showed the toplist Config settings before the results of the toplist, like this:
links,id,5,ascending,title="testlinktitle",,,0,0,0,0,0,0,,0 1 asdasdasd - for each link, the ID, in the Show Links in Category
This is the debug info:
Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE 1=1
Load time so far: 0.06 seconds.
Query 3: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder
Load time so far: 0.07 seconds.
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
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 1=1
Load time so far: 0.07 seconds.
Query 5: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader`,`kiado` FROM wsnlinks_members WHERE id = '1' AND validated = 1
Load time so far: 0.08 seconds.
Query 6: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder
Load time so far: 0.1 seconds.
Number of rows is 14
Query 7: 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`,`specialurl` FROM wsnlinks_categories WHERE id=1
Load time so far: 0.12 seconds.
Query 8: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10
Load time so far: 0.12 seconds.
Number of rows is 0
Query 9: SELECT `memberid`,`starttime`,`time` FROM wsnlinks_sessions WHERE time < 1213085718 AND memberid > 0
Load time so far: 0.13 seconds.
Number of rows is 0
Load time so far: 0.13 seconds.
Query 10: DELETE FROM wsnlinks_sessions WHERE time < 1213085718
Query 11: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid`,`importurl` FROM wsnlinks_attachments WHERE importurl != '' ORDER BY id ASC LIMIT 0,1
Load time so far: 0.14 seconds.
Number of rows is 0
Query 12: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader`,`kiado` FROM wsnlinks_members WHERE banned='' AND notifykeywords != '' AND keychecktime < 1213000218 ORDER BY id ASC LIMIT 0,1
Load time so far: 0.14 seconds.
Number of rows is 0
Query 13: 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`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longitude`,`zip`,`kiado` FROM wsnlinks_links WHERE deleted=0 AND pagerank=0 ORDER BY rand() LIMIT 0,1
Load time so far: 0.14 seconds.
Number of rows is 1
Creating link with Array as row
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`,`specialurl` FROM wsnlinks_categories WHERE id=1
Load time so far: 0.15 seconds.
Load time so far: 0.16 seconds.
Query 15: SELECT name,COUNT(name) AS num FROM wsnlinks_tags WHERE link=1 GROUP BY name ORDER BY num DESC
Number of rows is 0
Load time so far: 0.16 seconds.
Query 16: UPDATE wsnlinks_links SET tags='' WHERE id=1
Load time so far: 0.16 seconds.
Query 17: SELECT COUNT(id) FROM wsnlinks_links WHERE alias=1 AND validated=1 Count is 0
Query 18: SELECT `votevalue` FROM wsnlinks_ratings WHERE linkid = 1 AND custom=''
Load time so far: 0.17 seconds.
Number of rows is 0
Query 19: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader`,`kiado` FROM wsnlinks_members WHERE id='1'
Load time so far: 0.17 seconds.
Number of rows is 1
Query 20: SELECT `id`,`ownerid`,`postername`,`time` FROM wsnlinks_comments WHERE linkid=1 AND validated=1 AND deleted=0 AND hide=0 ORDER BY time DESC
Load time so far: 0.17 seconds.
Number of rows is 0
Load time so far: 0.17 seconds.
Query 21: UPDATE wsnlinks_comments SET catid='1' WHERE linkid=1
Load time so far: 0.17 seconds.
Query 22: UPDATE wsnlinks_comments SET parentids='' WHERE linkid=1
Load time so far: 0.17 seconds.
Query 23: UPDATE wsnlinks_comments SET linkname='testlinktitle' WHERE linkid=1
Query 25: SELECT COUNT(id) FROM wsnlinks_links WHERE alias=1 AND validated=1 Count is 0
Query 26: SELECT `id`,`frequency`,`filename`,`nextrun` FROM wsnlinks_crons WHERE nextrun < 1213086618 ORDER BY id ASC LIMIT 0,1
Load time so far: 0.17 seconds.
Number of rows is 0
Query 27: 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`,`specialurl` FROM wsnlinks_categories WHERE id=1
Load time so far: 0.18 seconds.
Query 28: 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`,`specialurl` FROM wsnlinks_categories WHERE parent=1 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC LIMIT 0,40
Load time so far: 0.2 seconds.
Number of rows is 0
Query 29: 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`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longitude`,`zip`,`kiado` FROM wsnlinks_links WHERE catid=1 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1213086618 ORDER BY time DESC,title ASC LIMIT 0,14
Load time so far: 0.2 seconds.
Number of rows is 1
Creating link with Array as row
Load time so far: 0.22 seconds.
Query 30: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=1 AND validated=1 AND hide=0 AND deleted=0 AND type='regular' AND effectivetime < 1213086618 Count is 1
Load time so far: 0.22 seconds.
Query 31: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=1 AND validated=1 AND hide=0 AND deleted=0 AND type='recip' AND effectivetime < 1213086618 Count is 0
Query 32: 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`,`specialurl` FROM wsnlinks_categories WHERE deleted=0 AND validated=1 AND isalbum=0 AND alias=0 AND hide=0 AND MATCH (name) AGAINST('Example Category') AND id != 1 LIMIT 0,5
Load time so far: 0.22 seconds.
Number of rows is 0
Load time so far: 0.22 seconds.
Query 33: SELECT COUNT(id) FROM wsnlinks_categories WHERE deleted=0 AND validated=1 AND isalbum=0 AND alias=0 AND hide=0 AND MATCH (name) AGAINST('Example Category') AND id != 1 Count is 0
Query 34: SELECT COUNT(id) FROM wsnlinks_linkexchanges WHERE (member2='1' && (stage='initial' OR stage='awaiting2')) OR (member1='1' && stage='awaiting1') Count is 0
Query 35: 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 > 1213085718 AND (catid=1 AND memberid>0) ORDER BY time DESC LIMIT 0,100
Load time so far: 0.27 seconds.
Number of rows is 1
Creating online with Array as row
Query 36: 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 memberid=1
Load time so far: 0.38 seconds.
Number of rows is 1
Creating online with Array as row
Load time so far: 0.38 seconds.
Query 37: UPDATE wsnlinks_sessions SET starttime='1213085399', time='1213086618', location='http://localhost/wsnlinks/wsnlinks/index.php?action=displaycat&catid=1', catid='1', threadid='', areaname='Example Category', nopermission='0', inchat='0', ip='127.0.0.1' WHERE id=2
I tried putting this into the Linkbit template:
<!-- BEGIN TOPLIST 2{NUMBER} --> <CONFIG>links,id,5,ascending,title="testlinktitle",,,0,0,0,0,0,0,,0</CONFIG> {LINKID} {LINKDESCRIPTION} - for each link, the ID, in the Show Links in Category <!-- END TOPLIST 2{NUMBER} -->
It produced literally nothing that I could see. Here is the debug info:
Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE 1=1
Load time so far: 0.07 seconds.
Query 3: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder
Load time so far: 0.08 seconds.
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
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 1=1
Load time so far: 0.08 seconds.
Query 5: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader`,`kiado` FROM wsnlinks_members WHERE id = '1' AND validated = 1
Load time so far: 0.09 seconds.
Query 6: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder
Load time so far: 0.11 seconds.
Number of rows is 14
Query 7: 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`,`specialurl` FROM wsnlinks_categories WHERE id=1
Load time so far: 0.13 seconds.
Query 8: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10
Load time so far: 0.14 seconds.
Number of rows is 0
Query 9: SELECT `memberid`,`starttime`,`time` FROM wsnlinks_sessions WHERE time < 1213086026 AND memberid > 0
Load time so far: 0.15 seconds.
Number of rows is 0
Load time so far: 0.15 seconds.
Query 10: DELETE FROM wsnlinks_sessions WHERE time < 1213086026
Query 11: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid`,`importurl` FROM wsnlinks_attachments WHERE importurl != '' ORDER BY id ASC LIMIT 0,1
Load time so far: 0.15 seconds.
Number of rows is 0
Query 12: SELECT `id`,`frequency`,`filename`,`nextrun` FROM wsnlinks_crons WHERE nextrun < 1213086926 ORDER BY id ASC LIMIT 0,1
Load time so far: 0.15 seconds.
Number of rows is 0
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`,`specialurl` FROM wsnlinks_categories WHERE id=1
Load time so far: 0.16 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`,`specialurl` FROM wsnlinks_categories WHERE parent=1 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC LIMIT 0,40
Load time so far: 0.18 seconds.
Number of rows is 0
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`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longitude`,`zip`,`kiado` FROM wsnlinks_links WHERE catid=1 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1213086926 ORDER BY time DESC,title ASC LIMIT 0,14
Load time so far: 0.18 seconds.
Number of rows is 1
Creating link with Array as row
Load time so far: 0.21 seconds.
Query 16: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=1 AND validated=1 AND hide=0 AND deleted=0 AND type='regular' AND effectivetime < 1213086926 Count is 1
Load time so far: 0.21 seconds.
Query 17: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=1 AND validated=1 AND hide=0 AND deleted=0 AND type='recip' AND effectivetime < 1213086926 Count is 0
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`,`specialurl` FROM wsnlinks_categories WHERE deleted=0 AND validated=1 AND isalbum=0 AND alias=0 AND hide=0 AND MATCH (name) AGAINST('Example Category') AND id != 1 LIMIT 0,5
Load time so far: 0.21 seconds.
Number of rows is 0
Load time so far: 0.21 seconds.
Query 19: SELECT COUNT(id) FROM wsnlinks_categories WHERE deleted=0 AND validated=1 AND isalbum=0 AND alias=0 AND hide=0 AND MATCH (name) AGAINST('Example Category') AND id != 1 Count is 0
Query 20: SELECT COUNT(id) FROM wsnlinks_linkexchanges WHERE (member2='1' && (stage='initial' OR stage='awaiting2')) OR (member1='1' && stage='awaiting1') Count is 0
Query 21: 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 > 1213086026 AND (catid=1 AND memberid>0) ORDER BY time DESC LIMIT 0,100
Load time so far: 0.26 seconds.
Number of rows is 1
Creating online with Array as row
Query 22: 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`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longitude`,`zip`,`kiado` FROM wsnlinks_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (title="testlinktitle" AND invisibleto NOT LIKE '%|3|%') AND effectivetime < 1213086926 AND alias=0 AND inalbum=0 ORDER BY id ASC LIMIT 0,5
Load time so far: 0.27 seconds.
Number of rows is 1
Creating link with Array as row
Query 23: 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 memberid=1
Load time so far: 0.39 seconds.
Number of rows is 1
Creating online with Array as row
Load time so far: 0.39 seconds.
Query 24: UPDATE wsnlinks_sessions SET starttime='1213085399', time='1213086926', location='http://localhost/wsnlinks/wsnlinks/index.php?action=displaycat&catid=1', catid='1', threadid='', areaname='Example Category', nopermission='0', inchat='0', ip='127.0.0.1' WHERE id=2
Comments on toplist in linkbit not working
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
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:
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:
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
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
The linkbit is a repeated area, repeated as many times as there are links on the page, so if you use a static number it won't be unique. You may be able to use {NUMBER} as the toplist number, not sure.
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
Hi Paul,
The {NUMBER} idea was good, but still doesn't show the results, just finds them...
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Well, before I impliment a way to do it, can you explain to me why anyone would ever want a toplist in the link bit? It doesn't seem like a place where it'd logically be useful, to me.
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
Simple.
I want to have users who have the same information fields as the properties (links). As the admin, I would like to list all the properties in a table, and next to each property, I would like to show the users in the database who match the search query for that property (using the information in their profile). So for each link, the system will have to create a new toplist, running a whole lot of queries (as if submitting an advanced search).
The idea is to see a list of users who are looking for a similar property than the current listing. Does this make sense? Or perhaps there is an easier way to automatically perform an advanced search amongst users for each link list in the Display Links page?
Thanks
David
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
So it's like the simliar links or related links, but for profiles?
Or perhaps there is an easier way to automatically perform an advanced search amongst users for each link list in the Display Links page?
There are easier ways to link to results, but not to display them right there. Displaying them in the link bit is really going to tax your server though, querying the members table an additional 15 times per page (if you have 15 listings per page). Even on my nearly empty local database with no visitors other than me it makes it painfully slow. If the database tables grow large and there are a lot of visitors, it could slow down to the point of being unuseable even on a dedicated server.
Anyhow, the problem here is that {LINK and {MEMBER template vars in the linkbit are already replaced with the appropriate values for the link. When toplists are processed it recognizes that there ought to be template variables there, so it goes back to re-extract from the original copy of the template... but that original copy doesn't have {NUMBER} replaced, so it can't find the toplist number.
At any rate, the {NUMBER} approach still kills all the other non-{NUMBER} toplists on the page so it's not a good solution. I'll have to come up with a sytax to allow numberless toplists, though they won't be able to use pagination. (This will only be in 4.2, of course, since it's very likely to create obscure bugs.)
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
- somehow do an advanced search amongst the members, using the values from a new link, and generate static html of the results with a unique file that reflects the id of the new link
- load this static page in an iframe next to the link in the linkbit
or better yet, save the output of a search result as html, right into a DB field for that link???
Am i crazy? Technically it should be possible? Any thoughts?
Thanks
David
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I don't see how in the world a link can be a member, since they're totally different sorts of things. A member is something you log in as, you can't log in as a link. Members are associated with links, but there's no clear way to associate a link with another type of link.
Anyhow an iframe would offer no advantage over the clear way of generating static pages with usewrapper=no and inserting them with <?php echo file_get_contents("yourstaticbitcontent.html"); ?>. However, since you're talking about a potentially infinite number of such static files, you would need a complicated system to handle all this generation.
Just finished implimenting numberless toplists. I'm actually getting 37 total queries, 4.33 seconds on it now (compared to 3 seconds without those toplists)... somehow it was slower when it didn't work. If you reduce the links per page to 10 it might work out.
If you can use the cache system (I mean the one at Admin -> Settings -> General at the top, not the much more complicated one you're proposing), that would take care of the load for sure.
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
My bad. I wasn't clear about the members there. I would have members, but a member would have an email, password, and phone. then they would be able to 'submit' a link that is a specific type (doesn't show on the site, doesn't count to anything). then when the admin pulls up the normal property listings, next to each property, are the results to the search query for that property which shows the 'member' type links that matched that search query.
so I'll download the latest version and see how I can use it? so anything special I should know about these numberless toplists?
Thanks
David
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I haven't released anything since the last post. The next 4.2 release will probably be in the next 3 days or so.
Nothing you need to know.
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
did you know that with the above feature, you could use the script for a dating site feature, like showing a member who matches their profile...
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
If I put that in an iframe, it should do exactly what I wanted.
and it seems like it finds the link, but it just shows the placeholders where the link's information should be. that custom admin template contains only this:
If I can use a custom template for a search that I submit via URL, then this issue is solved.
Thanks
David
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
Hi Paul,
Please check my previous post, as it offers another solution to this, but needs to be able to call custom templates to a search.
Now, as for testing the above things in the 4.2.0 alpha 13. I put this into the Display Links template:
I listed the link properly, but also showed the toplist Config settings before the results of the toplist, like this:
This is the debug info:
I tried putting this into the Linkbit template:
It produced literally nothing that I could see.
Thanks
David
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
I thought I found a solution... never mind. I'll wait for the 4.2 release.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
If I put that in an iframe, it should do exactly what I wanted.
Can you tell me where the error is in that? I don't see one.
that custom admin template contains only this:
Compare with the normal template. I think you're missing the link start declaration.