YourWBB

$result = $db->query("SELECT p.*, pc.cache,
		u.userposts, u.regdate, u.signature, u.email, u.homepage, u.icq, u.aim, u.yim, u.msn, u.showemail, u.receivepm, u.usercanemail, u.ratingcount, u.ratingpoints, u.gender, u.invisible, u.title, u.lastactivity, u.allowsigsmilies, u.allowsightml, u.allowsigbbcode, u.allowsigimages, u.disablesignature,
		r.ranktitle, r.rankimages,
		at.attachmentname, at.attachmentid, at.attachmentextension, at.attachmentsize, at.counter,
		i.iconpath, i.icontitle
		$userfields
		$avatar
		$marking
		FROM bb".$n."_posts p 
		LEFT JOIN bb".$n."_users u USING (userid)
		LEFT JOIN bb".$n."_ranks r USING (rankid)
		LEFT JOIN bb".$n."_attachments at ON (p.attachmentid=at.attachmentid)
		LEFT JOIN bb".$n."_icons i ON (p.iconid=i.iconid)
		LEFT JOIN bb".$n."_postcache pc ON (p.postid=pc.postid)
		$userfieldsjoin
		$avatarjoin
		$markingjoin
		WHERE p.postid IN (0".$this->postids.")".$this->orderBy);

 ALTER TABLE `bbx_users` ADD `away_message` TEXT NOT NULL ,
ADD `away_from` DATE NOT NULL ,
ADD `away_to` DATE NOT NULL ;
 

 ALTER TABLE `bb2_users` ADD `away_message2` TEXT NOT NULL ,
ADD `away_from` DATE NOT NULL ,
ADD `away_to` DATE NOT NULL ;