Need a small coding help! Thanks

[gifforums]

Hai .. need a small help

I wrote a code to fetch latest threads .. [Its a plugin in VB not PHP file]

Its working perfect ..
I need a small change
Here i want to limit the characters of the title to 30 ..
Help me in that

Here it is

PHP Code:

global $db, $vbulletin;


$latest_Threads_order="order by thread.dateline Desc";

$leader_movies_f='18,19,20,21,22,23,49,50,51,52,53,54,63,64,65,66,47';
$leader_music_f='24,25,26,27,55,56,57,58,97,98,48';

$leader_moviess = $db->query_read("
     SELECT thread.threadid,
            thread.title AS tht,
            thread.postusername,
            thread.replycount,
            thread.lastposter,
            thread.views,
            thread.attach,
            forum.title AS fot
     FROM " . TABLE_PREFIX . "thread AS thread, " . TABLE_PREFIX . "forum AS forum
     WHERE thread.forumid = forum.forumid
     AND thread.forumid IN ($leader_movies_f)
     $latest_Threads_order
     LIMIT 20
     ");

while ($leader_movies = $db->fetch_array($leader_moviess))        

    {
$leader_movie.="
<div class='alt1'>
<a href='showthread.php?t=$leader_movies[threadid]'><b>$leader_movies[tht]</b></a><br>
<br>
</div>
";
}

eval('$latestthreadsd = "' . fetch_template('developer-threads') . '";'); 


[Disasterpiece]

PHP Code:

global $db, $vbulletin;


$latest_Threads_order="order by thread.dateline Desc";

$leader_movies_f='18,19,20,21,22,23,49,50,51,52,53,54,63,64,65,66,47';
$leader_music_f='24,25,26,27,55,56,57,58,97,98,48';

$leader_moviess = $db->query_read("
     SELECT thread.threadid,
            thread.title AS tht,
            thread.postusername,
            thread.replycount,
            thread.lastposter,
            thread.views,
            thread.attach,
            forum.title AS fot
     FROM " . TABLE_PREFIX . "thread AS thread, " . TABLE_PREFIX . "forum AS forum
     WHERE thread.forumid = forum.forumid
     AND thread.forumid IN ($leader_movies_f)
     $latest_Threads_order
     LIMIT 20
     ");

while ($leader_movies = $db->fetch_array($leader_moviess))        

    {
$leader_movie.="
<div class='alt1'>
<a href='showthread.php?t=$leader_movies[threadid]'><b>".substr($leader_movies['tht'],0,30)."</b></a><br>
<br>
</div>
";
}

eval('$latestthreadsd = "' . fetch_template('developer-threads') . '";'); 


Should do the trick if I got your idea correctly.

[Lynne]

Or lookup the function vbchop in the API.