If I do a search where I select 'For Rent' and leave the categories at 'in all categories', then it returns all the result for all 'For Rent' listings. This is fine.
If I do a search where I select 'For Rent' and select a category where I KNOW there aren't any links listed, it STILL returns the same values as in the previous search. As if it did an 'or' type search.
I tried to even use a '=' type search, but I get the same problem.
I just don't get it. I tried to change the default search type to 'all the words' and then manually using '=' in the form action as well. I even tried a combination of those, with changing the conditions of the search fields (kiadoeladocondition,incatcondition) to '=' and 'and' but still bringing up results, where the actual link doesn't match the catid.
Here is a search. I don't see where it would restrict the results to CATID 12 (for example, in this search):
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1;
Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 57 for Resource id #38
Performing query: 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 FROM wsnlinks_membergroups WHERE id>0 ;
Performing query: 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,publicname,publiccompany,publicphone,publicaddress,publicemail,privatename,privatecompany,privateaddress,privatephone,publicdescription FROM wsnlinks_members WHERE id=1 AND validated=1 ;
Performing query: 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 FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ;
Performing query: 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 for Resource id #49
Performing query: UNLOCK TABLES;
Performing query: 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,kiadoelado,helyseg,varos,ar,epitoanyag,alapterulet,kertmeret,epiteseve,szobaszam,felszobaszam,erkely,franciaerkely,futes,fekves,tajolas,komfort,lift,emeleten,parkolas,parkolasautok,lakasallapot,epuletallapot,extrak,butorozott,terkep,galeria,dirtitle,emeletek,milyenar,ownernamefromid FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND (((kiadoelado LIKE '%Eladó%'))) ORDER BY ar ASC LIMIT 0,45;
Performing query: 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 (((kiadoelado LIKE '%Eladó%'))) ;
Number of rows is 2 for Resource id #54
Performing query: SELECT id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated FROM wsnlinks_attachments WHERE type='link' AND objectid=10 ORDER BY time ASC LIMIT 0,1;
Number of rows is 1 for Resource id #56
Performing query: SELECT id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated FROM wsnlinks_attachments WHERE type='link' AND objectid=12 ORDER BY time ASC LIMIT 0,1;
Using what's already there when you switch 'search in categories' on, when I search for something in a different category than the one I'm in, it doesn't show up in the search. Give me a way to reproduce. And use the code tags to avoid messing up threads.
Unless perhaps you mean you want to restrict to the category itself excluding its subcategories. For that you'd use catid instead of incat I think. Can't find it in the manual.
Comments on search isn't exact
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
Hey Paul,
Another problem with searching. Consider this simple search:
<form action="search.php?action=filter&filled=1&whichtype=links&condition=and" method="post" >
-------------------
<input type="hidden" name="kiadoeladocondition" value="and" />
<select name="kiadoeladosearch">
<option value="For Rent">For Rent</option>
<option value="For Sale">For Sale</option>
</select>
<input type="hidden" name="incatcondition" value="and" />
<select name="incatsearch">
<option value="">In all categories</option>
{ CATOPTIONS }
</select>
-------------------
If I do a search where I select 'For Rent' and leave the categories at 'in all categories', then it returns all the result for all 'For Rent' listings. This is fine.
If I do a search where I select 'For Rent' and select a category where I KNOW there aren't any links listed, it STILL returns the same values as in the previous search. As if it did an 'or' type search.
I tried to even use a '=' type search, but I get the same problem.
Thanks
David
Forum Regular
Usergroup: Customer
Joined: Feb 19, 2004
Location: Michigan
Total Topics: 57
Total Comments: 185
Does this work?
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
Hey mrowton,
Thanks for the input, but this didn't work either. Now it simply doesn't search the categories for some reason.
David
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
I just don't get it. I tried to change the default search type to 'all the words' and then manually using '=' in the form action as well. I even tried a combination of those, with changing the conditions of the search fields (kiadoeladocondition,incatcondition) to '=' and 'and' but still bringing up results, where the actual link doesn't match the catid.
David
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
Here is a search. I don't see where it would restrict the results to CATID 12 (for example, in this search):
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Using what's already there when you switch 'search in categories' on, when I search for something in a different category than the one I'm in, it doesn't show up in the search. Give me a way to reproduce. And use the code tags to avoid messing up threads.
Unless perhaps you mean you want to restrict to the category itself excluding its subcategories. For that you'd use catid instead of incat I think. Can't find it in the manual.
{ CATOPTIONS }
What's with the odd spacing?
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
That was it.
if I search incat, then it brings up results from all categoried, but if I use catid, then it restricts it to that id.
Thanks
David