[wiredinoc]

Originally Posted by Xtrm2Matt

I fixed your script for you -> http://www.opticalgaming.com/forums/test2.php

Code changes:

PHP Code:

<?php 
$countposts=$vbulletin->db->query_first('SELECT COUNT(*) AS posts FROM prefix_post'); 
$totalposts=number_format($countposts['posts']); 
$numbersmembers=$vbulletin->db->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM prefix_user'); 
$numbermembers=number_format($numbersmembers['users']); 
echo "Total Posts: $totalposts";
echo "<br>";
echo "Total Members: $numbermembers";
?>

Originally Posted by i-Symbian.Com

I will answer my own question here

How to limit News to certain characters?

Open vBexternal.php

Find

PHP Code:

'post'         => $bbcode_parser->parse(unhtmlspecialchars($News['pagetext']), $f), 


Replace with

PHP Code:

'post'         => $bbcode_parser->parse(unhtmlspecialchars(substr ($News['pagetext'],0,250)), $f), 


Change 250 to any numbers you wish and this will be pulled from the database.

Guys, this kicks complete ass! I'm a new user, but I'm quickly getting up to speed with the help of you fine folks!!

I have 2 questions:

1. Considering the code above, how would I apply it to the title of latest posts, and display "..." if the title goes beyond the desired limit?

2. Where do I place the "total members" code above? I'm kinda at a loss with this one. Does it go into vbexternal.php? How is it called?

Thanks soo much guys, this is awesome.

MD