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]

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

while( $news = mysql_fetch_array($data) ) {
$postdate = vbdate("F d, Y", $news['dateline']);


To

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

$news['pagetext'] = parse_bbcode2($news['pagetext'], no, yes, $allowsmilie, yes);


Otherwise you are overwriting the whole $news array ;)

[RixiuS]

You should change

while( $news = mysql_fetch_array($data) ) {
$postdate = vbdate("F d, Y", $news['dateline']);


To

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

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