[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?

Anyone...? Please.

This hack is no longer supported, as I said in my post above, you should install this one instead.

To answer your question, the installer doesn't actually modify any existing templates, but to use the random quote you have to modify the FORUMHOME template by hand.

thanks alooooooooot

Just installed it, and have a small problem.

The Quote Moderation thing only displays one quote. How can I change it?

90% of 2.0 is overkill for our needs and would not be used :( Thanks anyway though...

how do I do that?

As I mentioned earlier, this hack is old and you should use the new version.

If you're still set on using this one, though, open install_quoteit.php, find:

and replace it with: