Welcome to Geeklog, Anonymous Friday, October 11 2024 @ 10:08 am EDT
Geeklog Forums
Stories By Topic Block
Page navigation
Status: offline
beewee
Forum User
Full Member
Registered: 08/05/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
How can I change that?
Dutch Geeklog sites about camping/hiking:
www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
37
33
Quote
Status: offline
beewee
Forum User
Full Member
Registered: 08/05/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
Dutch Geeklog sites about camping/hiking:
www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
BTW this should be a default GL block IMHO
Dutch Geeklog sites about camping/hiking:
www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
42
22
Quote
Status: offline
beewee
Forum User
Full Member
Registered: 08/05/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
Dutch Geeklog sites about camping/hiking:
www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
27
35
Quote
Status: offline
beewee
Forum User
Full Member
Registered: 08/05/03
Posts: 969
Location:The Netherlands, where else?
Oooops, , I overlooked something while copying it from my own lib-custom.php:
Around line 151 change this:
$sql = "SELECT title, date FROM {$_TABLES['stories']} WHERE ";
to
$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...
Dutch Geeklog sites about camping/hiking:
www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
Around line 151 change this:
Text Formatted Code
// pull only the stories the visitor is allowed to view $sql = "SELECT title, date FROM {$_TABLES['stories']} WHERE ";
to
Text 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...
Dutch Geeklog sites about camping/hiking:
www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
39
22
Quote
Status: offline
drshakagee
Forum User
Full Member
Registered: 10/01/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.
Yes I am mental.
33
22
Quote
Status: offline
geKow
Forum User
Full Member
Registered: 01/12/03
Posts: 445
Hey, I understand your question
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 )
geKow
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 )
geKow
27
20
Quote
Status: offline
drshakagee
Forum User
Full Member
Registered: 10/01/03
Posts: 231
I gotcha, nice stuff! I just downloaded it to play with. Thanks for the efforts.
Yes I am mental.
Yes I am mental.
28
21
Quote
Status: offline
beewee
Forum User
Full Member
Registered: 08/05/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.
Dutch Geeklog sites about camping/hiking:
www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
Dutch Geeklog sites about camping/hiking:
www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
31
24
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?
23
25
Quote
Status: offline
beewee
Forum User
Full Member
Registered: 08/05/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
Dutch Geeklog sites about camping/hiking:
www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
28
24
Quote
noob
Anonymous
wish i could. don't know anything about editing scripts. have to rely on other people's generosity.
24
24
Quote
Page navigation
All times are EDT. The time is now 10:08 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