The secure CMS.

Welcome to Geeklog, Anonymous Tuesday, April 16 2024 @ 06:14 am EDT

Geeklog Forums

RSS By Authors - where in database?

 New Topic  Post Reply
 12/09/04 10:10pm (Read 951 times)  
Status: offline

RickW

Forum User
Full Member
Registered: 01/28/04
Posts: 240
Location:United States
Okay I'm attempting to create my own RSS By Authors plugin/hack.

I'm studying the lib-syndication.php file where all the magic happens. Dirk, you're right, this entire file would basically need to be rewritten.

I see where the list of topics are coming from. $_TABLES['topics'] Is the list of authors $_TABLES['authors']?
www.antisource.com
 Quote
 12/11/04 01:21pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by RickW: I see where the list of topics are coming from. $_TABLES['topics'] Is the list of authors $_TABLES['authors']?

$_TABLES['topics'] is just a variable that holds the name of the database table that contains the topics. There is no such table for the authors.

An SQL request that returns a list of all authors (i.e. every user that has posted a story) can be found in function editpreferences in usersettings.php (search for "SELECT DISTINCT").

bye, Dirk
 Quote
 12/11/04 02:26pm  
Status: offline

RickW

Forum User
Full Member
Registered: 01/28/04
Posts: 240
Location:United States
I'm looking through the code in users.php, it already lists the last 10 posts for that author so I'll borrow that code.
www.antisource.com
 Quote
 New Topic  Post Reply
All times are EDT. The time is now 06:14 am.
  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content