RSS feed from specific category: WSN Support

WSN Support » WSN Links » RSS feed from specific category » RSS feed from specific category

RSS feed from specific category
Can't get this to work...

Version: 3.15

RSS feed from specific category

tobz
Beginner

Usergroup: Customer
Joined: Jan 08, 2004
Total Topics: 2
Total Posts: 3

Posted 06/05/05 - 04:47 AM:	#1
Hi, I can't seem to get this to work, I want an RSS feed for just one category - I've tried adding &catid=7 to the url of the RSS feed: rssfeed.php?type=links&number=5&field=time&ascdesc=descending&catid=7 but this doesn't have any effect. Can anyone help? I have read the manual and it says "Just as for toplists, you can specify the ordering and type and number of items listed by tacking the info onto the end of the URL." Now, using catid=7 in the filter section of the toplist generator works as expected... Thanks.
tobz

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6316

Posted 06/05/05 - 10:29 AM:	#2
&condition=catid=7 would be the proper way.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

tobz
Beginner

Usergroup: Customer
Joined: Jan 08, 2004
Total Topics: 2
Total Posts: 3

Posted 06/05/05 - 11:19 AM:	#3
Ah, top man, thanks Paul - works a treat
tobz

bigdogglen
Beginner

Usergroup: Customer
Joined: Jul 08, 2005
Total Topics: 1
Total Posts: 2

Posted 07/27/05 - 12:09 PM:	#4
The way rssfeed.php is set up, the rss is displayed so the WSN Directory links are shown pointing to their original links. For example: Yahoo Yahoo's site descprition... How could I change it so the link goes to the details page of my directory, instead of straight to the site? I know it sounds confusing, but basically what I want to happen is the links from the rss feeds to go to my directory before they click out to the listed site.

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6316

Posted 07/27/05 - 08:06 PM:

One way is to edit the rss feed template to use http://www.webmastersite.net/forums/link.php?id={LINKID} as the link. Alternately you can change rssfeed.php to replace

   if ($thisone->url != '') $linkstuff = $thisone->url; 
   else $linkstuff = $settings->dirurl .'/link.php?id='. $thisone->id;

with

   if ($thisone->url != '' && !$useredirlin) $linkstuff = $thisone->url; 
   else $linkstuff = $settings->dirurl .'/link.php?id='. $thisone->id;

and pass useredirlin=1 in the url (this will be applied in future versions).

"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

david
Forum Regular

Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 88
Total Posts: 304

Posted 08/10/05 - 06:52 PM:	#6
Hey Paul, replacing the {THELINK} with http://www.webmastersite.net/forums/link.php?={LINKID} doesn't work. Load time so far: 0.11 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1; Load time so far: 0.12 seconds. Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ; Number of rows is 52 for Resource id #37 Load time so far: 0.12 seconds. Performing query: SELECT original,replacement,description,id,sortorder FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder ; Number of rows is 14 for Resource id #38 Load time so far: 0.12 seconds. 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 FROM wsnlinks_membergroups WHERE id>0 ; Load time so far: 0.13 seconds. 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 FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ; Number of rows is 50 for Resource id #44 Load time so far: 0.15 seconds. Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE; Load time so far: 0.15 seconds. 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 #45 Load time so far: 0.15 seconds. Performing query: UNLOCK TABLES; Load time so far: 0.15 seconds. Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,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,xwidth,yheight,lastposterid,lastpostername,sticky,ownername,deleted,deletionreason,movedto,pollid,deletedby,posticon,timevalidated,filefield,tier,payoutamount,payouttype,payoutmore,investment,recurring,minpayout,payduration,paymethod,tracksoftware,availability,check,opened,rssfeed,businessphone,phone,skype,searchpayoutmore,meanpayoutamount,searchinvestment,searchminpayout,searchrecurring,affiliate,affiliateurl FROM wsnlinks_links WHERE id={LINKID} LIMIT 0,1; Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/anmlmdirectory.com/public_html/classes/database.php on line 94 Mysql error while fetching row for :You have an error in your SQL syntax near '} LIMIT 0,1' at line 1 Load time so far: 0.15 seconds. Performing query: UPDATE wsnlinks_links SET hits='1', hitsouttemp='1', importance='6' WHERE id=; You have an error in your SQL syntax near '} LIMIT 0,1' at line 1 Load time so far: 0.15 seconds. Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,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,xwidth,yheight,lastposterid,lastpostername,sticky,ownername,deleted,deletionreason,movedto,pollid,deletedby,posticon,timevalidated,filefield,tier,payoutamount,payouttype,payoutmore,investment,recurring,minpayout,payduration,paymethod,tracksoftware,availability,check,opened,rssfeed,businessphone,phone,skype,searchpayoutmore,meanpayoutamount,searchinvestment,searchminpayout,searchrecurring,affiliate,affiliateurl FROM wsnlinks_links WHERE alias= ; You have an error in your SQL syntax near '' at line 1 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/anmlmdirectory.com/public_html/classes/database.php on line 108 Number of rows is for You have an error in your SQL syntax near '' at line 1 Load time so far: 0.15 seconds. Performing query: UPDATE wsnlinks_settings SET content='338' WHERE name='totalhits'; You have an error in your SQL syntax near '' at line 1 Load time so far: 0.16 seconds. Performing query: UPDATE wsnlinks_members SET totalhits='1', rating='0' WHERE id=0; Setting cookie with name hits, value and duration 1123728512 Warning: Cannot modify header information - headers already sent by (output started at /home/anmlmdirectory.com/public_html/classes/database.php:276) in /home/anmlmdirectory.com/public_html/commonfuncs.php on line 439 Warning: Cannot modify header information - headers already sent by (output started at /home/anmlmdirectory.com/public_html/classes/database.php:276) in /home/anmlmdirectory.com/public_html/commonfuncs.php on line 448 Fatal error: Call to a member function on a non-object in /home/anmlmdirectory.com/public_html/link.php on line 156 David

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6316

Posted 08/10/05 - 09:03 PM:	#7
replacing the {THELINK} with http://www.webmastersite.net/forums/link.php?={LINKID} doesn't work. I didn't tell you to replace it with http://www.webmastersite.net/forums/link.php?={LINKID}. I'll assume though you did what I said and just wrote it wrong in your post, and check on it shortly. Edit: Confirmed a problem with that, link variables only apply in the description, handled throught the rsstemplate language item. In 3.23 you can pass useredirlin=1 in the url to make it use a link.php redirect. I'm not sure if that worked in previous versions. Edited by Paul on 08/10/05 - 09:09 PM
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.

Please login or register.