One Problem, Now another.

[RixiuS]

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]

That is strange! Can you post your code for the select and fetch_array?

[RixiuS]

Originally Posted by vbmechanic

That is strange! Can you post your code for the select and fetch_array?

		$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]

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]

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!