Webmastersite.net
Register Log In
  1. WSN Support Forums
  2. Paid Scripts Support
  3. Next link navigation

Next link navigation

Comments on Next link navigation

•david
Forum Regular

Usergroup: Customer
Joined: Jun 22, 2005

Total Topics: 91
Total Comments: 305
•david
#1 - Quote - Permalink
Posted Oct 09, 2007 - 7:17 PM:

Hi Paul,

I need to put a NEXT and PREVIOUS link on the detailedcomments template page for a link. I couldn't find anything obvious in the template variables, so I wanted to create a toplist for this.


<!-- BEGIN TOPLIST 21 -->
<CONFIG>links,id,1,descending,id<{ID}</CONFIG>
<!-- END TOPLIST 21 -->

This is the error:
Query 24: 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`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl` FROM wsnlinks_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (id<={ID} AND invisibleto NOT LIKE '%|3|%') AND effectivetime < 1191982522 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 0,1

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/csiprodsa/public_html/wsn/databases/mysql.php on line 26

Number of rows is 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 '} AND invisibleto NOT LIKE '%|3|%') AND effectivetime < 1191982522 AND alias=0 A' at line 1

Load time so far: 0.28 seconds.

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 '} AND invisibleto NOT LIKE '%|3|%') AND effectivetime < 1191982522 AND alias=0 A' at line 1


How can I make this work?

Thanks
David
•Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
•Paul
#2 - Quote - Permalink
Posted Oct 10, 2007 - 4:08 AM:

The same as in details.tpl should work I think: 
<p align="center">
<IF {PREVIOUSEXISTS}><a href="{PREVIOUSURL}">{LANG_DETAILS_PREVIOUS}</a></IF> 
<IF {PREVIOUSEXISTS} and {NEXTEXISTS}> | </IF>
<IF {NEXTEXISTS}><a href="{NEXTURL}">{LANG_DETAILS_NEXT}</a></IF>
</p>
•david
Forum Regular

Usergroup: Customer
Joined: Jun 22, 2005

Total Topics: 91
Total Comments: 305
•david
#3 - Quote - Permalink
Posted Oct 10, 2007 - 4:31 AM:

Hi Paul,

Negative. Just checked on comments.php

THanks
David
•Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
•Paul
#4 - Quote - Permalink
Posted Oct 10, 2007 - 6:04 PM:

Fixed.
•david
Forum Regular

Usergroup: Customer
Joined: Jun 22, 2005

Total Topics: 91
Total Comments: 305
•david
#5 - Quote - Permalink
Posted Oct 10, 2007 - 11:34 PM:

Hi Paul,

Thank You.

David
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.