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]

[Deyth]

I added the hack, followed the instructions, turned it on, and I don't see anything. Is it because there are no quotes in the table? If so, how are quotes to be submitted?

[Deyth]

It's showing up in one style but not the other yet I modified the FORUMHOME template in both the same way.

Edit:
Turns out the installation only put in custom templates for one style instead of all. Anyone know a quick fix for this?

[Deyth]

I found a hack that does this easily and am sharing it here for anyone else that will encounter this same problem later. You have to copy over quotelistbit, quote_addquote, quote_delquote, quote_listquote, randomquote.

[Deyth]

Your query isn't checking quotes.approved = 1

[QUOTE=Giveit2u43]Yeah just noticed that as I was looking at the code.. I changed your query to:

$result_quote = $DB_site->query("
			SELECT quotes.*,user.username AS quotename FROM ".TABLE_PREFIX."quotes AS quotes
			LEFT JOIN ".TABLE_PREFIX."user AS user ON (user.userid = quotes.userid)
			ORDER BY rand() LIMIT 1
		");
	
		while ($quote = $DB_site->fetch_Array($result_quote)) {
			$randomquote[quoteid] = $quote[quoteid];
			$randomquote[quote] = $quote

	
	

			
				;
			$randomquote[author] = $quote[author];
			$randomquote[username] = $quote[quotename];
		}
		$DB_site->free_result($result_quote);
	
		eval('$showrandomquote .= "' . fetch_template('randomquote') . '";');
			
		

and then you can place $randomquote[username] where you want the submitters username to show

[CtrlAltDel]

Originally Posted by Deyth

It's showing up in one style but not the other yet I modified the FORUMHOME template in both the same way.


Edit:
Turns out the installation only put in custom templates for one style instead of all. Anyone know a quick fix for this?

yeah just make your default style another style
run the install script and just install the templates and they'll get laid down

it runs on 3.0.3, thats what im running and my addon works with that too

yeah my addon wasnt perfect, thanks for the clean up guys

[anarchystar]

I tried to install quote-it 1.2 in vB 3.0.5 into my test site and got the following error when I turned the option on.

Database error in vBulletin 3.0.5:

Invalid SQL: 
			SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1
		
mysql error: Table 'database_-_test.quotes' doesn't exist

mysql error number: 1146

I turned it off again, and everything is fine. I'm wondering if this problem is specific to 3.0.5?

[Deyth]

Originally Posted by anarchystar

I tried to install quote-it 1.2 in vB 3.0.5 into my test site and got the following error when I turned the option on.

Database error in vBulletin 3.0.5:

Invalid SQL: 
			SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1
		
mysql error: Table 'database_-_test.quotes' doesn't exist

mysql error number: 1146

I turned it off again, and everything is fine. I'm wondering if this problem is specific to 3.0.5?

It's saying the quotes table doesn't exist. I don't think any vBulletin upgrades would drop tables it doesn't even expect to be there.

[Silverdawn222]

Edit: Never mind, fixed my own problem.

[Deyth]

Looks like the upgrade from 3.0.3 to 3.0.5 knocked it out for me too although I can't figure out why yet. Did anyone else do the upgrade?

[Deyth]

Ok it knocked out the settings. Just rerun these 2 queries:

INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('showquote', 'forumhome', '0', '0', 'yesno', 5, 0, 1)

INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('moderatequotes', 'forumhome', '0', '1', 'yesno', 6, 0, 1)

That will get them to display at least. I'm still getting errors when I try to add, it's missing the value for $vboptions[moderatequotes] even though I figured the above would insert it.