I added the effectivetime as you listed it in your post to my config line and now I do not get any links. I've submitted a test link with an effective date of 11/1/08 just to make 100% sure that there actually are links with effective dates on the site, but still I get nothing.
Regarding the showing of the number of links I will get back to you on that, I'm not sure it is quite that important. Would it make a difference to have the number of links in the category to include non-live links as well instead of making it a separate variable?
1. Ah, since you want the future you want to change effectivetime < {TIME} to effectivetime > {TIME}
2. About the same time, since I'd have to add a setting to select which behavior to use. Probably it'd be under 1 hour for both, actually.
<?php global $db; echo $db->selectcount('linkstable', 'catid={CATID} AND deleted=0 AND validated=1'); ?>
would be a quick hack solution, but putting that in your template will slow down the pages a lot, and probably grind the server to a halt if you have large categories.
Sorry Paul, but that doesn't work either - here's the full CONFIG line I used -
<CONFIG>links,effectivetime,20,ascending,ownerid={THISMEMBERID} AND effectivetime < {TIME} to effectivetime > {TIME}</CONFIG>
Which did not work and spit out a bunch of errors, but only one line caught my eye -
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'to effectivetime > 1224029668 AND invisibleto NOT LIKE '%|3|%') AND effectivetim' at line 1
If you notice the last "effectivetim" is missing the 'e' at the end.
Ok, I got a little bit more clarification on this. Thank you for that hack, but I had misunderstood what was requested so that link total number is not needed.
Instead if I can get either that toplist to work or maybe have a link much like the one in the Editorial Controls section - Show/undelete deleted links - highaspirations.com/portal/...catid=121&type=showdeleted. Instead of showing the the type=deleted maybe there a way to only show the upcoming (or non-live) links?
Whichever method I can get to work is fine as long as I can easily see which links are not yet live. Thanks.
Well, Paul, I must be really dense. I still can't get this to work. I've copied the line you gave me, taken out and left in the "AND effectivetime > 0" part from post #2, changed the order and even changed < to >.
I see there's a global override filtering not-yet-effective items. Enabled automatic removal of the restriction when effectivetime > is in the toplist condition.
0/5
1
2
3
4
5
Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.
Comments on toplist of upcoming links
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
I'd like a list of links which are not live yet so I can see what links are coming up, but I can't get the toplist to work. What am I doing wrong?
<CONFIG>links,effectivetime,20,ascending,o wnerid= {THISMEMBERID},effectivetime > 0</CONFIG>
Also is it possible to show how many links submitted to the category are not yet in effect? Much like the {CATNUMLINKS} variable.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
ownerid={THISMEMBERID} AND effectivetime > 0 AND effectivetime < {TIME}
Also is it possible to show how many links submitted to the category are not yet in effect? Much like the {CATNUMLINKS} variable.
No; or as an estimate, 1-2 hours / $50-$100.
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
I added the effectivetime as you listed it in your post to my config line and now I do not get any links. I've submitted a test link with an effective date of 11/1/08 just to make 100% sure that there actually are links with effective dates on the site, but still I get nothing.
Regarding the showing of the number of links I will get back to you on that, I'm not sure it is quite that important. Would it make a difference to have the number of links in the category to include non-live links as well instead of making it a separate variable?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
1. Ah, since you want the future you want to change effectivetime < {TIME} to effectivetime > {TIME}
2. About the same time, since I'd have to add a setting to select which behavior to use. Probably it'd be under 1 hour for both, actually.
<?php global $db; echo $db->selectcount('linkstable', 'catid={CATID} AND deleted=0 AND validated=1'); ?>would be a quick hack solution, but putting that in your template will slow down the pages a lot, and probably grind the server to a halt if you have large categories.Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
Sorry Paul, but that doesn't work either - here's the full CONFIG line I used -
Which did not work and spit out a bunch of errors, but only one line caught my eye -
If you notice the last "effectivetim" is missing the 'e' at the end.
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
Ok, I got a little bit more clarification on this. Thank you for that hack, but I had misunderstood what was requested so that link total number is not needed.
Instead if I can get either that toplist to work or maybe have a link much like the one in the Editorial Controls section - Show/undelete deleted links - highaspirations.com/portal/...catid=121&type=showdeleted. Instead of showing the the type=deleted maybe there a way to only show the upcoming (or non-live) links?
Whichever method I can get to work is fine as long as I can easily see which links are not yet live. Thanks.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I was telling you to change one thing to the other -- not to write "to" literally.
ownerid={THISMEMBERID} AND effectivetime > {TIME}
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
Well, Paul, I must be really dense. I still can't get this to work. I've copied the line you gave me, taken out and left in the "AND effectivetime > 0" part from post #2, changed the order and even changed < to >.
Can you actually get this to work?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I see there's a global override filtering not-yet-effective items. Enabled automatic removal of the restriction when effectivetime > is in the toplist condition.