[QUOTE=Dolamite]ok i got it.... for anyone else who might want to do this....

below require_once('./global.php');(in your portal.php, adv_index.php whatever)

add:

[QUOTE] // ### QUOTEIT ################################################## #######
if ($vboptions['showquote'])
{
$result_quote = $DB_site->query("
SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1
");

while ($quote = $DB_site->fetch_Array($result_quote)) {
$randomquote[quoteid] = $quote[quoteid];
$randomquote still waiting for an answer to my last reply above. :/

I am using this as a jokes system. Would love to see ratings.

well, my quotes won't frickin rotate for ++++, and i have it set so it doesnt need to be moderated.

whatever, they don't support afterall i guess....

seangworld: your quote may not be rotating properly due to the SQL statement that is selecting the quote...check that to see if the SQL statement is correct.

ratings are something that would be nice as well lionel, i'll see what i can do

After a long wait, I'm proud to release QuoteIt! 2.0. It's got some major improvements, I suggest everyone with version 1.2 installed go check it out.

Wow...thanks a bunch....but what a stinker.... I just found this excellent mod and installed it today....now it's 2.0 for me.

Thanks a bunch installing now...

Okay I keep getting this error, I tried re-installing the hack but it wouldn't work, would someone tell me how to fix it or be willingly to fix it for me *blush*. Please put it basically not gd with understanding all this VB, PHP etc stuff!

Invalid SQL:
CREATE TABLE vb3_quotes (
`quoteid` int(10) unsigned NOT NULL auto_increment,
`quote` mediumtext NOT NULL,
`author` mediumtext NOT NULL,
`userid` int(10) unsigned NOT NULL default '0',
`approved` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`quoteid`,`quoteid`),
KEY `approved` (`approved`)
) TYPE=MyISAM AUTO_INCREMENT=1

mysql error: Duplicate column name 'quoteid'

PRIMARY KEY (`quoteid`,`quoteid`),

remove one of the quoteid's

Which templates are modified by the installer?

Yes it looks better :) Could you post the code here for us please?