Thanks but it seems that there's an error that's arising presumably with 'catparentid' from my toplist at main.tpl:
Query 22: 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`,------------`timedeleted` FROM econo_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (type != "prioridad_maxima" and catparentid =185 AND invisibleto NOT LIKE '%|3|%') AND effectivetime < 1202441767 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 0,35
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\proyects\nndomain\nndomain\databases\mysqli.php on line 20
Number of rows is Unknown column 'catparentid' in 'where clause'
Also, pleas note that 'catparentid' does not appears at the toplist list of link variables nor at the add fields list of link variables.
It isn't a field, it's just a template variable, so you can't sort a toplist by it. Unless it's a category toplist in which case you use parent, of course.
Comments on {LINKPARENTID}
Forum Regular
Usergroup: Customer
Joined: Aug 09, 2004
Location: Chile
Total Topics: 172
Total Comments: 462
Paul,
Please review if this variable is working.
I need to make toplists of links from my main categories, (links published at their subcategories) but this variable seems to be not working .
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
There is no such {LINKPARENTID} variable and never has been. Link variables: scripts.webmastersite.net/w...les/link-variables-10.html
Presumably you want either {LINKCATID} or {LINKCATPARENTID}.
Forum Regular
Usergroup: Customer
Joined: Aug 09, 2004
Location: Chile
Total Topics: 172
Total Comments: 462
Thanks but it seems that there's an error that's arising presumably with 'catparentid' from my toplist at main.tpl:
Query 22: 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`,------------`timedeleted` FROM econo_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (type != "prioridad_maxima" and catparentid =185 AND invisibleto NOT LIKE '%|3|%') AND effectivetime < 1202441767 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 0,35
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\proyects\nndomain\nndomain\databases\mysqli.php on line 20
Number of rows is Unknown column 'catparentid' in 'where clause'
Also, pleas note that 'catparentid' does not appears at the toplist list of link variables nor at the add fields list of link variables.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It isn't a field, it's just a template variable, so you can't sort a toplist by it. Unless it's a category toplist in which case you use parent, of course.
Forum Regular
Usergroup: Customer
Joined: Aug 09, 2004
Location: Chile
Total Topics: 172
Total Comments: 462
OK I have it finally working by using parentids LIKE '%, 1, %' as explained at:
scripts.webmastersite.net/w...ced-toplist-tasks-158.html
Thanks.