[TECK]

sorry Chen.. yesterday i was really tired. i did not see the query_first and "." change.

i tried this code:

PHP Code:

$getnewsql=$DB_site->query_first("SELECT * FROM post WHERE threadid='$newthreadid' ORDER BY postid ASC LIMIT 1");
  $newtime=vbdate($timeformat,$new[dateline]);
  $newdate=vbdate($dateformat,$new[dateline]);
  $newpagetext=$new[pagetext];
  $newpagetext=bbcodeparse($newpagetext); 


it's working great. once again you help people. how do you get the time to do all this?

i decided to remove the code for now. due to copy and paste reasons . with this script basically you will have the same news frontpage as vbulletin.org with a little twist, right Chen? . i will work now on the comments code and also maybe in a category module.. if Firefly is willing to help me a little..

i will see if Firefly accepts for me to release the code here to everyone... but since he never decided to publish his, i will respect his way of administrating this forum. also, i know that i'm not a good PHPer as many code writers here, but i love the challange.. so far PPN and Firefly were very helpfull and pointed me into the right direction with the code. i can only say one word: thanks.