vb.org Archive - Modification Help

Okay, I've made a small modification to my forum that enables Administrators to post little blast messages. For example, some users don't browse the entire forum and might miss an important message about a clan war -- this will hopefully prevent that. It's basically a shoutbox, but all the shoutbox hacks I found here were too feature-full, I wanted something REALLY basic, just a quick form to post a message, that's it. So I've created a form and when submitted, the data is inserted into the sql db. I then created a plugin to pull the data from the db and then display the text on the forumhome page.

This is the plugin code I'm using:

PHP Code:


		
			
switch (strtolower($vbulletin->config['Database']['dbtype']))
{
// load standard MySQL class
case 'mysql':
case '':
{
$db_temp =& new vB_Database($vbulletin);
break;
}
// load MySQLi class
case 'mysqli':
{
$db_temp =& new vB_Database_MySQLi($vbulletin);
break;
}
}
 
$blast = $db->query_first("SELECT * FROM blastmsg ORDER BY date DESC");

And this is the INSERT code I'm using:

PHP Code:


		
			
$db->query_write("INSERT INTO blastmsg (user, message, date) VALUES 
('$username', '$message', '$date')");

So, now that you hopefully understand what I'm trying to do here. Perhaps someone can answer a few issues I'm having.

First off, how can I wrap the message text to the next line? At the moment, it just increases the page width to fit the text. I'm using $blast[message] to post the user's message. I tried using a PHP wordwrap function, but couldn't get it to work -- is it possible to wrap an array?

Secondly, how can I post all rows in the table? At the moment, I've only been able to get it to post the most recent.

Finally, if anyone has an idea on improving efficiency with it, I'm all ears -- I'm rather new at creating hacks.

Thanks in advance for any help you guys can offer.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01022 seconds Memory Usage 1,713KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (1)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: