| Message Text |
Hi Paul,
I have a feeling I ran into the same issue as before in this old post: www.webmastersite.net/forum...orums/comments.php?id=7730
I have a member field, and I got a multiselect dropdown I use for creating it's values. so the values in the DB look like: , 32, 33 and the field can be nicely edited.
BUT I cannot display it's contents. All I get is 'yes'.
I wanted to use it in a toplist, like this:
<!-- BEGIN TOPLIST 28 -->
<CONFIG>members,id,5,ascending,latta OR ', 31',,,0,0,0,0,0,0,,0</CONFIG>
{MEMBERLATTA}
<!-- END TOPLIST 28 -->
and all i get is:
Load time so far: 0.05 seconds.
Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 93
Load time so far: 0.05 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.05 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.06 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`,`helyseg`,`minar`,`maxar`,`varos`,`epitoanyag`,`minalapterulet`,`maxalapterulet`,`minkertmeret`,`maxkertmeret`,`minepiteseve`,`maxepiteseve`,`minszobaszam`,`maxszobaszam`,`minfelszobaszam`,`maxfelszobaszam`,`erkely`,`franciaerkely`,`galeria`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`minemeleten`,`maxemeleten`,`parkolas`,`parkolasautok`,`lakasallapot`,`epuletallapot`,`extrak`,`butorozott`,`minemeletek`,`maxemeletek`,`kiadoelado`,`milyenar`,`telefon`,`kategoria`,`latta` FROM wsnlinks_members WHERE id='1' AND validated=1
Load time so far: 0.08 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 0
Load time so far: 0.1 seconds.
Query 7: SELECT `catid` FROM wsnlinks_sessions WHERE catid>0 AND time > 1213128435
Number of rows is 0
Load time so far: 0.1 seconds.
Query 8: UPDATE wsnlinks_categories SET numonline='0' WHERE 1=1
Load time so far: 0.1 seconds.
Query 9: SELECT `id`,`frequency`,`filename`,`nextrun` FROM wsnlinks_crons WHERE nextrun < 1213129335 ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.11 seconds.
Query 10: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=0 AND deleted=0 AND hide=0 AND isalbum=0 AND validated=1
Count is 1
Load time so far: 0.11 seconds.
Query 11: 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=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0 ORDER BY priority ASC,name ASC LIMIT 0,40
Number of rows is 1
Creating category with Array as row
Load time so far: 0.12 seconds.
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`,`helyseg`,`minar`,`maxar`,`varos`,`epitoanyag`,`minalapterulet`,`maxalapterulet`,`minkertmeret`,`maxkertmeret`,`minepiteseve`,`maxepiteseve`,`minszobaszam`,`maxszobaszam`,`minfelszobaszam`,`maxfelszobaszam`,`erkely`,`franciaerkely`,`galeria`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`minemeleten`,`maxemeleten`,`parkolas`,`parkolasautok`,`lakasallapot`,`epuletallapot`,`extrak`,`butorozott`,`minemeletek`,`maxemeletek`,`kiadoelado`,`milyenar`,`telefon`,`kategoria`,`latta` FROM wsnlinks_members WHERE 1=1 AND (latta OR ', 31') ORDER BY id ASC LIMIT 0,5
Number of rows is 0
Load time so far: 0.12 seconds.
Query 13: 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
Creating online with Array as row
Load time so far: 0.12 seconds.
Query 14: UPDATE wsnlinks_sessions SET starttime='1213117840', time='1213129335', location='http://xxx.com/index.php?usewrapper=no&custom=yes&TID=membersonlinks', catid='0', threadid='', areaname='Main', nopermission='0', inchat='0', ip='78.92.0.250' WHERE id=40
14 total queries
This page was created in 0.12 seconds
Memory used: 4690648 bytes
Server Status: time since last reboot is 26 days, 16:17, load average: 6.28, 5.76, 5.00
Of course, if I remove the filter in the toplist, then I get a 'yes' for all the members who have any value in this MEMBERLATTA field.
So is this something I just messed up, or this is that feature that hasn't been implemented yet?
Thanks
David |
