I've been trying to work on some certain toplists to use in our site. I got the basics but am going bald and turning grey on some certain ones I need...
I have a link type called "sponsor", which we use for paid advertisers who get a "Featured Listing'. Now, on our site's front pages (which is outside of WSN Links), I'm wanting to put a toplist showing a random listing. SO far, I've been making the toplist a custom .tpl file and including it in my front page using header&footer=no..but I'm completely lost on how exactly to make the toplist for this random listing.
I also need to see how to limit them to a certain category,and show that category in the output, linked.
Now, is it possible for it to be set to one category and it's subcategories?
Example...I want to feature the clubs I have listed in North Carolina, but the NC category is broken down into City subcategories..so I need it to be a statewide random toplist but drawing from the city subcats.
Probably it's that you need to group your terms when you use both "or" and "and" and have in mind some specific way it should be interpreted. Also, shouldn't the 'and' before catid=2 be an 'or'? I would think you want (catid=1 or parentids LIKE '%, 1, %' or catid=2 or parentids LIKE '%, 2, %') and type='recip'
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on Toplist Help Needed
Beginner
Usergroup: Customer
Joined: Mar 31, 2004
Location: Gastonia, NC
Total Topics: 1
Total Comments: 3
I've been trying to work on some certain toplists to use in our site. I got the basics but am going bald and turning grey on some certain ones I need...
I have a link type called "sponsor", which we use for paid advertisers who get a "Featured Listing'.
Now, on our site's front pages (which is outside of WSN Links), I'm wanting to put a toplist showing a random listing. SO far, I've been making the toplist a custom .tpl file and including it in my front page using header&footer=no..but I'm completely lost on how exactly to make the toplist for this random listing.
I also need to see how to limit them to a certain category,and show that category in the output, linked.
Thanks in advance,
David T.
On Yahoo: davidt2974
Beginner
Usergroup: Customer
Joined: Mar 31, 2004
Location: Gastonia, NC
Total Topics: 1
Total Comments: 3
Ok...I've figured out the random thing...
Now, is it possible for it to be set to one category and it's subcategories?
Example...I want to feature the clubs I have listed in North Carolina, but the NC category is broken down into City subcategories..so I need it to be a statewide random toplist but drawing from the city subcats.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
See the bottom of scripts.webmastersite.net/w...nks/wsnmanual/articles/158 for how to show a toplist of links beneth a category.
Beginner
Usergroup: Customer
Joined: Mar 31, 2004
Location: Gastonia, NC
Total Topics: 1
Total Comments: 3
Awesome...almost got this all figured out...one last thing...
I need recip links only in categories 1 and 2 and all the ones beneath those..I'm trying the following:
<CONFIG>links,rand(),1,descending,catid=1 OR parentids LIKE '%, 1, %' and catid=2 OR parentids LIKE '%, 2, %' and type='recip'</CONFIG>
But in testing looks like it's only displaying cat 2 and those beneath it.
What do I need to change to have it display both?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Probably it's that you need to group your terms when you use both "or" and "and" and have in mind some specific way it should be interpreted. Also, shouldn't the 'and' before catid=2 be an 'or'? I would think you want
(catid=1 or parentids LIKE '%, 1, %' or catid=2 or parentids LIKE '%, 2, %') and type='recip'