Welcome to Geeklog, Anonymous Tuesday, December 10 2024 @ 12:46 am EST
Geeklog Forums
Busted Older Stories Block
squatty
My problems have all centered on the COM_olderstuff function in lib-common.php.
Thus far I've narrowed it down to two issues:
//DB_delete($_TABLES['blocks'],'title',"''");
//DB_save($_TABLES['blocks'],'title,blockorder,content',"'','','$string'");
DB_delete('blocks','title','Older Stories');
DB_save('blocks','title,blockorder,content',"'Older Stories','7','$string'");
Has anyone run across similar issues? If so how did you correct the problem?
Thanks,
Danny
In a world without walls and fences, who needs Windows and Gates?
Tony
The reason people blame things on previous generations is that there's only one other choice.
squatty
The lib-common.php code included in the 1.3.3 distribution has the following SQL query in the COM_olderstuff function:
$result = DB_query("SELECT sid,title,comments,unix_timestamp(date) AS day FROM "
. $_TABLES['stories'] . " WHERE draft_flag = 1 ORDER BY date desc LIMIT , ");
$nrows = DB_numRows($result);
As I stated in the first issue, all of my stories have a draft_flag = 0. You also pointed out that this is correct. Why is the SQL looking for draft_flag = 0?
As for my install, I am running Geeklog 1.3.3 on RedHat 7.2 with Apache 1.3.23 and PHP 4.1.1.
Thanks,
Danny
In a world without walls and fences, who needs Windows and Gates?
Tony
The reason people blame things on previous generations is that there's only one other choice.
lopez
Tony
squatty
$_CONF['olderstuff'] = 1; //1 = on 0= off
The block is created for you. The code for the block is in lib-common.php.
In a world without walls and fences, who needs Windows and Gates?
lopez
Tony
The reason people blame things on previous generations is that there's only one other choice.
lopez
lopez
squatty
In a world without walls and fences, who needs Windows and Gates?
lopez
Tony
The reason people blame things on previous generations is that there's only one other choice.
- 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