lastxpostsxtopix.php for PHPBB_14 error

Forum Index » Public Forums » Web Development

Author	Message
spiderb Joined: Dec 08, 2003 Posts: 10 Other Topics	Posted Mar 09, 2004 at 4:07:00 AM Subject: lastxpostsxtopix.php for PHPBB_14 error Hello, I absolutely need this block for my site but it doesn't run. First I changed the line 20 from include('modules/phpBB_14/phpBB_14/pntables.php'); to include('modules/phpBB_14/pntables.php'); I asked me why this error is here, noone can use the module whith this !?!? Ok, after this I tryed to edit the block in the postnuke admin but I receive this error: Error accesing to the database 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS f, AS c WHERE f.cat_id = c.cat_id This error I can not correct it because I'm not so the best with coding Please, someone can help me ? send me a link to download a running module ? or maybe someone know is someone else create such a kind of block ? [addsig]
Back to top
Chad Kraeft Joined Apr 30, 2006 Posts: 546 Location:Austin, TX Other Topics	Posted: Mar 09, 2004 8:58:00 AM Subject: lastxpostsxtopix.php for PHPBB_14 error What version of PHPBB_14 are you running? [edit] good catch on the table reference line. i'll get that fixed and repost the module! [/edit][addsig]
Back to top
Anonymous Joined Sep 09, 2010 Posts: 10 Other Topics	Posted: Mar 12, 2004 2:10:00 PM Subject: lastxpostsxtopix.php for PHPBB_14 error hello I use the 1.7.5
Back to top
spiderb Joined Dec 08, 2003 Posts: 10 Other Topics	Posted: Mar 12, 2004 2:22:00 PM Subject: lastxpostsxtopix.php for PHPBB_14 error I downloaded your new version, but it crash :-( btw just before it was me, I use the 1.7.5 ;-) Here is the full error: Warning: main(modules/phpBB_14/phpBB_14tables.php): failed to open stream: No such file or directory in /modules/phpBB_14/pnblocks/lastxpostsxtopic.php on line 20 Warning: main(): Failed opening 'modules/phpBB_14/phpBB_14tables.php' for inclusion (include_path='.:/usr/share/pear') in /modules/phpBB_14/pnblocks/lastxpostsxtopic.php on line 20 Error accesing to the database 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS f, AS c WHERE f.cat_id = c.cat_id [addsig]
Back to top
Chad Kraeft Joined Apr 30, 2006 Posts: 546 Location:Austin, TX Other Topics	Posted: Mar 12, 2004 5:38:00 PM Subject: lastxpostsxtopix.php for PHPBB_14 error The version available for download has been fixed.[addsig]
Back to top
spiderb Joined Dec 08, 2003 Posts: 10 Other Topics	Posted: Mar 13, 2004 4:10:00 AM Subject: lastxpostsxtopix.php for PHPBB_14 error :) Thanks it run now but it miss something for my site. Ok, I try to explain what I need, maybe someone can tell me how to modify the block or maybe someone will be interested to do it for fun ;-) So,so, I have a multilingual site, my forum is construct like this: French Zone Topic1 thread1 blabla1 blabla2 thread2 Topic2 thread1 German Zone Topic1 thread1 Topic2 thread2 English Zone Topic1 thread1 Topic2 thread2 So, your great block is made to check what's happend by Topic and I'm really interested to have it by Forum (ex: German Zone) is is useful for me and maybe some other users to separate the forum by language or all is mixed on the main page of my site. Do you think it is possible to modify easyly the code to do so ? Someone to help do do it ? Many thanks for your help.[addsig]
Back to top
Chad Kraeft Joined Apr 30, 2006 Posts: 546 Location:Austin, TX Other Topics	Posted: Mar 13, 2004 5:02:00 PM Subject: lastxpostsxtopix.php for PHPBB_14 error Based on phpBB_14 naming conventions, you are looking for a block that allows you to display the last x posts in a forum category (vs. the current forum topic). It would probably take about an hour to hack that from the existing block code. I may do that this evening, as I see a use for it on MirageLab as well. Thanks for piping up![addsig]
Back to top
spiderb Joined Dec 08, 2003 Posts: 10 Other Topics	Posted: Mar 13, 2004 9:11:00 PM Subject: lastxpostsxtopix.php for PHPBB_14 error Hey MANY THANKS, you'll make my site really more better And yes, by category instead topic is exactely what I need because it is no other way to have something really multilingual and actually all lang are mixed up on my centerblock I'll come back here later, Thanks again for your support and work All the best SpiderB [addsig]
Back to top
Chad Kraeft Joined Apr 30, 2006 Posts: 546 Location:Austin, TX Other Topics	Posted: Mar 13, 2004 9:30:00 PM Subject: lastxpostsxtopix.php for PHPBB_14 error get it: download see it: MirageLab Dev Forums Homepage (towards the bottom)[addsig]
Back to top
spiderb Joined Dec 08, 2003 Posts: 10 Other Topics	Posted: Mar 14, 2004 5:19:00 AM Subject: lastxpostsxtopix.php for PHPBB_14 error Well done ! This perfect, you are really fast, thanks. Just one more thing, I don't want to abuse of you, but is there any possibility to also show the name (pseudo) of the last poster in the center block sized forum in table ? Many thanks[addsig]
Back to top
Chad Kraeft Joined Apr 30, 2006 Posts: 546 Location:Austin, TX Other Topics	Posted: Mar 14, 2004 5:22:00 AM Subject: lastxpostsxtopix.php for PHPBB_14 error good idea! that would have been helpful for me just now, in fact, checking to see if you had a chance to try the block out. lol gimme a bit and i'll get it posted...[addsig]
Back to top
Chad Kraeft Joined Apr 30, 2006 Posts: 546 Location:Austin, TX Other Topics	Posted: Mar 14, 2004 5:33:00 AM Subject: lastxpostsxtopix.php for PHPBB_14 error Quote: get it: download see it: MirageLab Dev Forums Homepage (towards the bottom) archive has updated block file that shows username of last poster. enjoy.[addsig]
Back to top
Chad Kraeft Joined Apr 30, 2006 Posts: 546 Location:Austin, TX Other Topics	Posted: Mar 14, 2004 6:09:00 AM Subject: lastxpostsxtopix.php for PHPBB_14 error forum subscription test - ignore.[addsig]
Back to top
Chad Kraeft Joined Apr 30, 2006 Posts: 546 Location:Austin, TX Other Topics	Posted: Mar 14, 2004 6:12:00 AM Subject: lastxpostsxtopix.php for PHPBB_14 error i wonder if there is a new release of phpBB_14 that fixes this problem?[addsig]
Back to top
Chad Kraeft Joined Apr 30, 2006 Posts: 546 Location:Austin, TX Other Topics	Posted: Mar 14, 2004 6:14:00 AM Subject: lastxpostsxtopix.php for PHPBB_14 error looks like i had a userid of 0 used in the subscription table. dunno wassup w/that...[addsig]
Back to top
spiderb Joined Dec 08, 2003 Posts: 10 Other Topics	Posted: Mar 14, 2004 6:27:00 AM Subject: lastxpostsxtopix.php for PHPBB_14 error Wow, you are too fast, I'm just checking your first version and come back here to ask again something to make it better, it can be cool to also add the hour and not only the date of the posts? like it is with the original centerblock given with phpbb_14 (date@hour) I think the new phpbb_14 1.7.6 is near to be out.... I'll appreciate it because it messed up the forum when you remove a user from the site I'll check out your new version and come back in one hour or so [addsig]
Back to top
spiderb Joined Dec 08, 2003 Posts: 10 Other Topics	Posted: Mar 14, 2004 9:43:00 AM Subject: lastxpostsxtopix.php for PHPBB_14 error Hummm, after some test, I saw bugs. My option is on 10 last Here are bugs: I see only the first last in the first two forum's in one category. I think the code needs to check the whole posts and not only one forum after one and stop when it is arrived to the limit fixed in options. MAybe to check out the hour and not only the date ? I don't know really where it is wrong "Sticked" threads always stay at the top of lastXcathegory, even if someone post a new message in another thread. I think it must be necessary to check the date and not the position in the list in the database (sorry I can not explain very good) MAybe give me your email if you think it is more easy to discuss or we can stay here, no problem. Thanks [addsig]
Back to top
spiderb Joined Dec 08, 2003 Posts: 10 Other Topics	Posted: Mar 18, 2004 3:13:00 AM Subject: lastxpostsxtopix.php for PHPBB_14 error Hello, Any news ? :cry: [addsig]
Back to top
Chad Kraeft Joined Apr 30, 2006 Posts: 546 Location:Austin, TX Other Topics	Posted: Mar 21, 2004 3:49:00 PM Subject: lastxpostsxtopix.php for PHPBB_14 error Tied up in a couple other projects, but will get on it as soon as I have a chance.[addsig]
Back to top
spiderb Joined Dec 08, 2003 Posts: 10 Other Topics	Posted: Mar 21, 2004 3:52:00 PM Subject: lastxpostsxtopix.php for PHPBB_14 error Ok, I'll wait with exitement to have the final running version of this block :D [addsig]
Back to top
Chad Kraeft Joined Apr 30, 2006 Posts: 546 Location:Austin, TX Other Topics	Posted: Mar 21, 2004 8:37:00 PM Subject: lastxpostsxtopix.php for PHPBB_14 error Quote: Here are bugs: I see only the first last in the first two forum's in one category. I think the code needs to check the whole posts and not only one forum after one and stop when it is arrived to the limit fixed in options. MAybe to check out the hour and not only the date ? I don't know really where it is wrong "Sticked" threads always stay at the top of lastXcathegory, even if someone post a new message in another thread. I think it must be necessary to check the date and not the position in the list in the database (sorry I can not explain very good) I had left it set to group by sticky and by category, which had the whole list outa whack. Newest versions posted are fixed. I think that next round I will add a few more settings fields for the block, starting with truncation length for shortened entries, date format, etc. The date format was determined by the core date constant used (_DATETIMEBRIEF). This has been changed to _DATETIMEBRIEF, which has the times shown. get it: download [addsig]
Back to top

Forum Index » Public Forums » Web Development