Welcome to Geeklog Monday, November 29 2021 @ 12:12 am EST

Geeklog Forums

Stories By Topic Block

Page navigation


Status: offline

beewee

Forum User
Full Member
Registered: 05/08/03
Posts: 969
Location:The Netherlands, where else?
I just love this block, it's really great. But since we're all using GL1.3.10 and 1.3.11 we can change the story ID. I found out that the Stories By Topic Block now lists the wrong stories since they are sorted by story ID instead of submission date. The result is that a story with ID=zzzzzzzzz submitted ages ago will be listed as a new story while a brand new story with ID=aaaaaaaa is not listed as a new story.

How can I change that?
Dutch Geeklog sites about camping/hiking: www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
 Quote

Status: offline

beewee

Forum User
Full Member
Registered: 05/08/03
Posts: 969
Location:The Netherlands, where else?
Well, I'm no developer but I succeeded in changing the sorting from 'sid' to 'date'. I've uploaded the file to GL.

BTW this should be a default GL block IMHO Mr. Green
Dutch Geeklog sites about camping/hiking: www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
 Quote

Status: offline

geKow

Forum User
Full Member
Registered: 12/01/03
Posts: 445
I can't download your file Sad SQL error.

geKow
 Quote

Status: offline

beewee

Forum User
Full Member
Registered: 05/08/03
Posts: 969
Location:The Netherlands, where else?
I don't think it's already through the submission que
Dutch Geeklog sites about camping/hiking: www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
 Quote

Status: offline

geKow

Forum User
Full Member
Registered: 12/01/03
Posts: 445
ah, I see...
so I would guess, that it's a kind of bug that I can find the file using the search Very Happy

geKow
 Quote

Status: offline

beewee

Forum User
Full Member
Registered: 05/08/03
Posts: 969
Location:The Netherlands, where else?
Yes, I think it's a bug. This is the second time I noticed it so I'll report it. If you're in a hurry I can mail the file if you like.
Dutch Geeklog sites about camping/hiking: www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
 Quote

Status: offline

geKow

Forum User
Full Member
Registered: 12/01/03
Posts: 445
oh, I'm not in a hurry. ... but on the other hand... Very Happy
 Quote

Status: offline

geKow

Forum User
Full Member
Registered: 12/01/03
Posts: 445
Thanks a lot Smile
But I have a problem, maybe I missed something?
All the links to the stories appear without $sid
like this
PHP Formatted Code
http://gekow.net/article.php?story=
 


geKow
 Quote

Status: offline

beewee

Forum User
Full Member
Registered: 05/08/03
Posts: 969
Location:The Netherlands, where else?
Oooops, Mr. Green Mr. Green , I overlooked something while copying it from my own lib-custom.php:

Around line 151 change this:
PHP Formatted Code
            // pull only the stories the visitor is allowed to view
            $sql = "SELECT title, date FROM {$_TABLES['stories']} WHERE ";
 


to
PHP Formatted Code
            // pull only the stories the visitor is allowed to view
            $sql = "SELECT title, sid FROM {$_TABLES['stories']} WHERE ";
 


So change 'date' to sid'

Sorry for the mistake, I'll upload a new version right away if this change helps... Mr. Green
Dutch Geeklog sites about camping/hiking: www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
 Quote

Status: offline

geKow

Forum User
Full Member
Registered: 12/01/03
Posts: 445
it IS allready written the way you said. It says sid at this point, so I guess it is something else?
Could it be sometihing on my side?

geKow

---------
oh wait... I didn't check my mail Smile brb
 Quote

Status: offline

geKow

Forum User
Full Member
Registered: 12/01/03
Posts: 445
ok, everything looks fine, now. Thanks again and greetings to NL, my dear neighbour. Big Celebration
 Quote

Status: offline

drshakagee

Forum User
Full Member
Registered: 01/10/03
Posts: 231
Just curious but what does this block do that you can't do with content syndication and a portal block?
Yes I am mental.
 Quote

Status: offline

geKow

Forum User
Full Member
Registered: 12/01/03
Posts: 445
Hey, I understand your question Smile

the difference I see is, that you can have a limited number of topics from different categories (!) merged to one list or separated by categories.

I have made an experimental install here at my sitere, you can see the block under " die letzten 3" where "gekow.news" shows the last couple of entries from all categories using a portal block.
(sorry, german Wink )
geKow
 Quote

Status: offline

drshakagee

Forum User
Full Member
Registered: 01/10/03
Posts: 231
I gotcha, nice stuff! I just downloaded it to play with. Thanks for the efforts.
Yes I am mental.
 Quote

Status: offline

clunk

Forum User
Newbie
Registered: 09/06/05
Posts: 9
Location:London
Is there any chance of this block being able to also display the intro text for each story headline as well as just the headline?
Clunk! Thud! Clank!
 Quote

Status: offline

beewee

Forum User
Full Member
Registered: 05/08/03
Posts: 969
Location:The Netherlands, where else?
This should be possible, but I don't know how . I'm no developer, so updating the block was already quite something for me. Embarassed
Dutch Geeklog sites about camping/hiking: www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
 Quote

Status: offline

clunk

Forum User
Newbie
Registered: 09/06/05
Posts: 9
Location:London
Does anybody know how? I'm just staring. Banging your head
Clunk! Thud! Clank!
 Quote

noob

Anonymous
I too would like to have some or all of the intro listed with the headline. did anyone come up with a way t do this?
 Quote

Status: offline

beewee

Forum User
Full Member
Registered: 05/08/03
Posts: 969
Location:The Netherlands, where else?
Did you try to change the PHP file yourself? Shouldn't be that hard..
Dutch Geeklog sites about camping/hiking: www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
 Quote

noob

Anonymous
wish i could. don't know anything about editing scripts. have to rely on other people's generosity.
 Quote

Page navigation

All times are EST. The time is now 12:12 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