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]

[magnus]

Originally Posted by DrkFusion

Thanks for this hack! Works great on a friends board, I modified it to take quotes from this website which provides RSS feeds of quotes. I developed an importer which takes the feeds and puts them into a database for this hack, I might release it as an addon. Doesn't seem stable as there is no interface for it pure backend.

This hack seems to be working fine, and is an asset since I had this incorporated on the main portal page.

Regards & Nice job!

DrkFusion, I'm glad you like the hack. Thanks!

Also, I've noticed a couple of you have implemented this into your portals. Perhaps a few other people could benefit? If you'd like, you could post the modifications required here as per which portal (vbIndex, vBadvanced, etc..) and I could provide a link to them in the first thread.

Or, you could release them in the Add-On section. I have an upgrade coming out soon, which will include the moderating of posts, list sorting and user options toggle. I've decided to release these now, as their pretty much completed rather than waiting for v2.0.

Instead, v2.0 will have a few more configurations and user/admin-options and from the response so far, categories, lol.

DrkFusion, I like your idea of incorporating RSS feeds. That's a great idea.

[daFish]

Originally Posted by magnus

Hrm.. I'll consider categories, we'll see.

As for when to display, do you mean it displays 1 quote per day/week/month rather than randomly changing every refresh?

I mean if day is sunday, show only quotes from category X otherwise show from all categories.

[magnus]

v1.1 -> v1.2 UPGRADE INSTRUCTIONS

1. Download quoteit1.2.zip from the first post and uncompress it.

2. Upload quotes.php to your forum ROOT directory, overwriting the existing one.

3. Upload quoteadmin.php to your ADMINCP directory.

4. Run the following SQL queries:
[SQL]
INSERT INTO `setting` (`varname` , `grouptitle` , `value` , `defaultvalue` , `optioncode` , `displayorder` , `advanced` , `volatile` ) VALUES ( 'moderatequotes', 'forumhome', '0', '0', 'yesno', '6', '0', '1');
[/SQL]
[SQL]
INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'setting_moderatequotes_title', 'Disable Quote Moderation?', '5000');
[/SQL]
[SQL]
INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'setting_moderatequotes_desc', 'Selecting "No" will require all quotes to be approved before being displayed.', '5000' );
[/SQL]
[SQL]
INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'quote_x_has_been_approved', 'Quote ({1}) has been approved.', '9000' );
[/SQL]
[SQL]
INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'quote_x_has_been_deleted', 'Quote ({1}) has been deleted.', '9000' );
[/SQL]
[SQL]
INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'moderate_quotes', 'Moderate Quotes', '9' );
[/SQL]
[SQL]
INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'no_quotes_awaiting_moderation', 'No Quotes awaiting moderation', '2' );
[/SQL]

5. Make the following FILE edits:

5a. In INDEX.PHP:

Find:

PHP Code:

    $result_quote = $DB_site->query("
        SELECT * FROM quotes ORDER BY rand() LIMIT 1
    "); 


REPLACE with:

PHP Code:

    $result_quote = $DB_site->query("
        SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1
    "); 


5b. In ADMINCP/INDEX.PHP:

Find:

PHP Code:

        construct_nav_group($vbphrase['moderation'], '<hr />', "$df"); 


Add ABOVE:

PHP Code:

        construct_nav_option($vbphrase['moderate_quotes'], "quoteadmin.php?do=moderate"); 


Done !!

You will now have a new option under the "Moderation" category in the AdminCP, titled "Moderate Quotes". Quote moderating can be toggled via vBulletin Options -> Forums Home Page Options -> Disable Quote Moderation?

[Sting]

hey i get this error while trying to do an install

Parse error: parse error in /home/###/public_html/forum/admincp/install_quoteit.php on line 325

[magnus]

Originally Posted by Sting

hey i get this error while trying to do an install

Parse error: parse error in /home/###/public_html/forum/admincp/install_quoteit.php on line 325

Woops, my fault. Re-download the .ZIP in the first post.

[Giveit2u43]

vbindex integration..

in vbindex.php (or whatever you renamed it to) find:

'vbindex_customblock_6'

and change it to:

'vbindex_customblock_6',
'randomquote'

next find:

// ## USERS IGNORE ##
if (trim($bbuserinfo['ignorelist'])) {
	$ignorelist = 'AND thread.postuserid NOT IN ('.str_replace(' ', ',', $bbuserinfo['ignorelist']).')';
}

and add BENEATH it:

$result_quote = $DB_site->query("
			SELECT quotes.*,user.username AS quotename FROM 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[quote];
			$randomquote[author] = $quote[author];
			$randomquote[userid] = $quote[userid];
			$randomquote[username] = $quote[quotename];
			$randomquote[approved] = $quote[approved];
		}
		$DB_site->free_result($result_quote);
	
		eval('$showrandomquote .= "' . fetch_template('randomquote') . '";');

Then edit your VBINDEX template and place:

$showrandomquote

after:

$home[news]

You can actually place $showrandomquote anywhere you`d like the quotes to show up..

[gmarik]

Nice one, Giveit!
Any ideas about the category option?

[magnus]

Originally Posted by gmarik

Nice one, Giveit!
Any ideas about the category option?

Yup, categories are in the works as we speak.

[Acido]

where i can place the query code in vbadvance homepage ?

I'm not sure iditing adv_index.php, can you help me ?

[magnus]

Originally Posted by Acido

where i can place the query code in vbadvance homepage ?

I'm not sure iditing adv_index.php, can you help me ?

I'm not too familiar with vBadvanced, however, you should just be able to place the $result_quote call anywhere near the beginning of the main call, and call it with the $showrandomquote in one of the templates.

You'll need to fiddle with it, because like I said, I don't use vBadvanced.