| Message Text |
Hi Paul,
I thought I ran into this before, but no idea how it was solved. I would like the following to be ALL on the same page (perhaps the link details page):
<!-- BEGIN LINK ATTACHMENTS -->
<a href="{ATTACHDOWNLOADURL}"><img src="thumbnail.php?id={ATTACHTHUMBURL}"></a>
<!-- END LINK ATTACHMENTS -->
<!-- BEGIN 1 LINK ATTACHMENTS -->
<a href="{ATTACHDOWNLOADURL}"><img src="{ATTACHDOWNLOADURL}"></a>
<!-- END LINK ATTACHMENTS -->
<!-- BEGIN TOPLIST 8 -->
<CONFIG>links,id,999,ascending,,,,0,0,0,0,0,0,</CONFIG>
<!-- BEGIN 1 LINK
ATTACHMENTS -->
<a href="{LINKDETAILSURL}"><img src="thumbnail.php?id={LINKID}&attachid={ATTACHID}"></a>
<!-- END 1 LINK ATTACHMENTS -->
<!-- END TOPLIST 8 -->
Yet only the first Attachments sections works. Not sure if it helps, but here are the queries:
Load time so far: 0.13 seconds.
Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 85
Load time so far: 0.14 seconds.
Query 3: 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` FROM wsnlinks_membergroups WHERE id>0
Load time so far: 0.14 seconds.
Query 4: 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` FROM wsnlinks_members WHERE id=1 AND validated=1
Load time so far: 0.15 seconds.
Query 5: 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` FROM wsnlinks_links WHERE id=7
Load time so far: 0.16 seconds.
Query 6: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`subscriber`,`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 7: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE
Load time so far: 0.16 seconds.
Query 8: 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
Query 9: UNLOCK TABLES
Load time so far: 0.17 seconds.
Query 10: 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` FROM wsnlinks_members WHERE id=1
Number of rows is 1
Setting cookie with name returnto, value http://www.csi-productions.com/wsn/comments.php?id=7 and expiration time 0
Load time so far: 0.2 seconds.
Query 11: SELECT COUNT(id) FROM wsnlinks_comments WHERE linkid=7 AND validated=1 AND hide=0 AND internalto=0 AND deleted=1
Count is 0
Load time so far: 0.2 seconds.
Query 12: SELECT `time` FROM wsnlinks_comments WHERE linkid=7 AND validated=1 AND hide=0 AND internalto=0 AND deleted=0 ORDER BY time ASC LIMIT 0,1
Load time so far: 0.2 seconds.
Query 13: SELECT COUNT(id) FROM wsnlinks_comments WHERE linkid=7 AND validated=1 AND hide=0 AND internalto=0 AND deleted=1
Count is 0
Load time so far: 0.2 seconds.
Query 14: SELECT COUNT(id) FROM wsnlinks_comments WHERE linkid=7 AND validated=1 AND hide=0 AND internalto=0 AND deleted=0
Count is 0
Load time so far: 0.2 seconds.
Query 15: SELECT `deleted` FROM wsnlinks_comments WHERE linkid=7 AND validated=1 AND hide=0 AND internalto=0 ORDER BY time DESC LIMIT 0,1
Load time so far: 0.2 seconds.
Query 16: SELECT `id`,`linkid`,`postername`,`message`,`time`,`linkname`,`validated`,`ip`,`ownerid`,`lastedit`,`type`,`approved`,`votes`,`hide`,`typeorder`,`lasteditby`,`catid`,`editreason`,`preventedit`,`inhidden`,`deleted`,`deletionreason`,`usernoteon`,`modnote`,`filefield`,`title`,`deletedby`,`parentids`,`disablesmilies`,`disablesig`,`icon`,`disablewsn`,`disablehtml`,`originalmessage`,`flagged`,`wysihtml`,`unrevised`,`internalto`,`hasinternal`,`invisibleto`,`hostname` FROM wsnlinks_comments WHERE linkid=7 AND validated=1 AND hide=0 AND internalto=0 ORDER BY time ASC LIMIT 0,14
Number of rows is 0
Freeing result.
Load time so far: 0.21 seconds.
Query 17: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid` FROM wsnlinks_attachments WHERE type='link' AND objectid=7 ORDER BY time ASC
Number of rows is 3
Load time so far: 0.23 seconds.
Query 18: 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` FROM wsnlinks_members WHERE id=1
Number of rows is 1
Load time so far: 0.29 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 > 1191617034 AND (threadid=7 AND memberid>0) ORDER BY time DESC LIMIT 0,100
Number of rows is 1
Load time so far: 0.29 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` FROM wsnlinks_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (invisibleto NOT LIKE '%|3|%') AND effectivetime < 1191617934 AND alias=0 AND inalbum=0 ORDER BY id ASC LIMIT 0,999
Number of rows is 2
Load time so far: 0.3 seconds.
Query 21: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid` FROM wsnlinks_attachments WHERE type='link' AND objectid=6 ORDER BY time ASC LIMIT 0,1
Number of rows is 1
Load time so far: 0.31 seconds.
Query 22: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid` FROM wsnlinks_attachments WHERE type='link' AND objectid=7 ORDER BY time ASC LIMIT 0,1
Number of rows is 1
Load time so far: 0.5 seconds.
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
Number of rows is 1
Load time so far: 0.5 seconds.
Query 24: UPDATE wsnlinks_sessions SET starttime='1191609159', time='1191617934', location='http://www.csi-productions.com/wsn/comments.php?id=7', catid='2', threadid='7', areaname='Comments on Girl 036', nopermission='0', inchat='0', ip='78.92.1.244' WHERE id=6
Thanks
David |
