vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   One Problem, Now another. (https://vborg.vbsupport.ru/showthread.php?t=61920)

RixiuS 02-25-2004 08:41 PM
One Problem, Now another.
 
I'm making my own news backend for vB3.. and it used to be working fine, everything pulled from the DB correctly, I just had to add bbcode parsing. BUT, now that I have gotten the bbcode parsing to work.. everything else that is pullled from the DB comes out with F or W. I have it pulling two posts from forumid 1, and the first post displays

Author: F
Title: F
Replycount: F

And the second, the same, but with W. Both are also showing a postdate for February 3, 2004. :\

>_< WTf is wrong?

(Demo: http://eightbitmonster.com)

vbmechanic 02-25-2004 10:15 PM
That is strange! Can you post your code for the select and fetch_array?

RixiuS 02-25-2004 10:20 PM
Quote:
Originally Posted by vbmechanic
That is strange! Can you post your code for the select and fetch_array?
Code:
                $data = $DB_site->query("
                                SELECT thread.threadid, thread.title, thread.replycount, thread.postusername, thread.postuserid, thread.dateline,
                                IF(views<=replycount, replycount+1, views) AS views, forumid, post.postid, pagetext
                                FROM " . TABLE_PREFIX . "thread AS thread
                                LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = thread.firstpostid)
                                WHERE forumid IN($newsforumid)
                                GROUP BY post.postid
                                ORDER BY dateline DESC");

                while( $news = mysql_fetch_array($data) ) {
                        $postdate = vbdate("F d, Y", $news['dateline']);                // FORMAT DATELINE
                        $news = parse_bbcode2($news['pagetext'], no, yes, $allowsmilie, yes);;
                        echo("<table class=tborder cellpadding=6 cellspacing=0 border=0 width=100% align=center><tbody>");
                        echo("<tr><td width=1% class=tcat><img src=\"images/byte/caticon.gif\" alt=\"Replies: ".$news["replycount"]."\" border=0></td>");
                        echo("<td class=tcat><a href=./forum/showthread.php?t=".$news["threadid"].">".$news["title"]."</a>");
                        echo("<div class=smallfont>Posted by:&nbsp;<a href=./forum/member.php?u=".$news["postuserid"].">".$news["postusername"]."</a></div></td></tr></tbody>");
                        echo("<tbody><tr><td class=alt1 colspan=2><div class=smallfont>$news</div>");
                        echo("<div class=right>$postdate</div></tr></td></tbody></table><br />");
                }

Andreas 02-25-2004 10:28 PM
You should change
PHP Code:
while( $news = mysql_fetch_array($data) ) {
  $postdate = vbdate("F d, Y", $news['dateline']); 
To
PHP Code:
while( $news = $DB_site->fetch_array($data) ) {
  $postdate = vbdate("F d, Y", $news['dateline'], false, false); 
Otherwise you might run into mySQL and locale problems. Furthermore it's normally not a good idea to use hard-coded date/time formats.

And for your F-Problem:
It should be
PHP Code:
$news['pagetext'] = parse_bbcode2($news['pagetext'], no, yes, $allowsmilie, yes); 
Otherwise you are overwriting the whole $news array ;)

RixiuS 02-25-2004 10:47 PM
Quote:
Originally Posted by KirbyDE
You should change
PHP Code:
while( $news = mysql_fetch_array($data) ) {
  $postdate = vbdate("F d, Y", $news['dateline']); 
To
PHP Code:
while( $news = $DB_site->fetch_array($data) ) {
  $postdate = vbdate("F d, Y", $news['dateline'], false, false); 
Otherwise you might run into mySQL and locale problems. Furthermore it's normally not a good idea to use hard-coded date/time formats.

And for your F-Problem:
It should be
PHP Code:
$news['pagetext'] = parse_bbcode2($news['pagetext'], no, yes, $allowsmilie, yes); 
Otherwise you are overwriting the whole $news array ;)
I love you Kirby. Thx SO much. :) Everything works perfectly, ty!


All times are GMT. The time now is 07:51 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01174 seconds
  • Memory Usage 1,749KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (6)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete