QuoteIt! Quote Management System v1.2

[hr]-[/hr]

QuoteIt! Development has been continued in this thread. Please use this link for the latest version!

[hr]-[/hr]

QuoteIt! 1.2

Description
This hack will allow you to maintain a database of quotes which can be added by users and displayed on FORUMHOME. Admin function includes the ability to delete quotes from the database.

Yes, you can use multi-line quotes.

Information
Requested by djohn (re: https://vborg.vbsupport.ru/showthread.php?t=62420)

Thanks to Giveit2u43 for the username code!

Tested on RC4, should work on RC1+

Version History
v1.0 - Initial Release
v1.1 - Added ability to list all quotes as well as direct quote linking
v1.2 - Added quote moderation abilities

Planned Features
v2.0
- Quote rating system
- Top {X} Quotes

If you use this, please click

[hr]-[/hr]
UPGRADES

v1.1 -> v1.2 UPGRADE INSTRUCTIONS

v1.0 -> v1.1 UPGRADE INSTRUCTIONS

[hr]-[/hr]
3RD PARTY MODIFICATIONS/ADD-ONS

[high]1. Add QuoteIt! to your vbIndex homepage! by [name]Giveit2u43[/name][/high]
[high]2. Add Who's Online Locations for QuoteIt! by [name]Acido[/name][/high]

[seangworld]

[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

= $quote

that last bit is what finally did it for me:

eval('$navbar = "' . fetch_template('navbar') . '";');

still waiting for an answer to my last reply above. :/

[Lionel]

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

[seangworld]

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....

[CtrlAltDel]

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

[Cap'n Steve]

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.

[YLP1]

Originally Posted by Cap'n Steve

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...

[Dark Aura]

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'

[CtrlAltDel]

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

remove one of the quoteid's

[Bubble #5]

Which templates are modified by the installer?

[Bubble #5]

Originally Posted by ncangler

I went into the addquote template and changed the code to clean this up.

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