QuoteIt! Quote Management System v1.2

QuoteIt! Quote Management System v1.2

Mod Version: 1.00, by magnus

This modification is in the archives.

vB Version: 3.0.0	Rating: (0 vote - 0 average)	Installs: 151
Released: 14 Mar 2004	Last Update: Never	Downloads: 22
Not Supported

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

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

UPGRADES

v1.1 -> v1.2 UPGRADE INSTRUCTIONS

Spoiler (click to open)

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 Query: (how to run queries)

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

SQL Query: (how to run queries)

INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'setting_moderatequotes_title', 'Disable Quote Moderation?', '5000');

SQL Query: (how to run queries)

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 Query: (how to run queries)

INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'quote_x_has_been_approved', 'Quote ({1}) has been approved.', '9000' );

SQL Query: (how to run queries)

INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'quote_x_has_been_deleted', 'Quote ({1}) has been deleted.', '9000' );

SQL Query: (how to run queries)

INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'moderate_quotes', 'Moderate Quotes', '9' );

SQL Query: (how to run queries)

INSERT INTO `phrase` ( `phraseid` , `languageid` , `varname` , `text` , `phrasetypeid` ) VALUES ( '', '0', 'no_quotes_awaiting_moderation', 'No Quotes awaiting moderation', '2' );

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?

v1.0 -> v1.1 UPGRADE INSTRUCTIONS

Spoiler (click to open)

v1.0 -> v1.1 UPGRADE INSTRUCTIONS

1. Download the quoteit1.1.zip from the first post, and upload the new quotes.php to your forum ROOT directory.

2. Run the following SQL query (or, you can insert the following phrase manually into the GLOBAL category):

SQL Query: (how to run queries)

INSERT INTO phrase (languageid, varname, text, phrasetypeid) VALUES (0, 'view_all_quotes', 'View All', 1);

3. Edit the randomquote TEMPLATE:

Find:

HTML Code:

<if condition="$bbuserinfo['userid']">(<a href=$vboptions[bburl]/quotes.php?do=addquote>$vbphrase[add_a_quote]</a><if condition="$bbuserinfo['permissions']['adminpermissions']"> | <a href="$vboptions[bburl]/quotes.php?do=delquote&quoteid=$randomquote[quoteid]">$vbphrase[delete_this_quote]</a></if>)</if>

REPLACE with:

HTML Code:

<if condition="$bbuserinfo['userid']">(<a href=$vboptions[bburl]/quotes.php?do=addquote>$vbphrase[add_a_quote]</a><if condition="$bbuserinfo['permissions']['adminpermissions']"> | <a href="$vboptions[bburl]/quotes.php?do=delquote&quoteid=$randomquote[quoteid]">$vbphrase[delete_this_quote]</a></if> | <a href="$vboptions[bburl]/quotes.php?do=list">$vbphrase[view_all_quotes]</a>)</if>

4. Create the following NEW templates:

TEMPLATE: quote_listquote

HTML Code:

$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head><title>$vboptions[bbtitle] - $vbphrase[random_quote]</title>
$headinclude
</head>
<body>
$header
$navbar
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="0" border="0" width="$stylevar[tablewidth]" align="center">
<thead>
	<tr>
		<td class="tcat" colspan="2">
			<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_randomquote')"><img id="collapseimg_forumhome_randomquote" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_forumhome_randomquote].gif" alt="" border="0" /></a>
			$vbphrase[random_quote]
		</td>
	</tr>
</thead>
<tbody id="collapseobj_forumhome_randomquote" style="$vbcollapse[collapseobj_forumhome_randomquote]">
$quotelistbit
</tbody>
</table><br />
$pagenav
$footer
</body>
</html>

TEMPLATE: quotelistbit

HTML Code:

<table class="tborder" cellpadding="3" cellspacing="0" border="0" width="$stylevar[tablewidth]" align="center">
	<tr>
		<td class="alt1 smallfont" align="left">
		Added by: <a href="$vboptions[bburl]/member.php?userid=$randomquote[userid]">$randomquote[username]
		</td>
		<td class="alt1" align="right">
		<a href="$vboptions[bburl]/quotes.php?do=view&quoteid=$randomquote[quoteid]">#$randomquote[quoteid]</a>
		</td>
	</tr>
	<tr>
		<td class="alt1" align="center" colspan="2">
		<i>"$randomquote[quote]"</i>
		</td>
	</tr>
	<tr>
		<td class="alt1 smallfont" align="left">
		<if condition="$bbuserinfo['permissions']['adminpermissions']">(<a href="$vboptions[bburl]/quotes.php?do=delquote&quoteid=$randomquote[quoteid]">$vbphrase[delete_this_quote]</a>)</if>
		</td>
		<td class="alt1" align="right">
		- <b>$randomquote[author]</b>
		</td>
	</tr>
</table>

Done !!

3RD PARTY MODIFICATIONS/ADD-ONS

1. Add QuoteIt! to your vbIndex homepage!

Spoiler (click to open)

vbindex integration..

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

Code:

'vbindex_customblock_6'

and change it to:

Code:

'vbindex_customblock_6', 'randomquote'

next find:

Code:

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

and add BENEATH it:

Code:

$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:

Code:

$showrandomquote

after:

Code:

$home[news]

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

Close

by Giveit2u43
2. Add Who's Online Locations for QuoteIt!

Spoiler (click to open)

Who's On Line Locations for Quote.php Functions:

in includes/functions_online.php

find:

PHP Code:

case 'bugs.php':   $userinfo['activity'] = 'bugs';   break;

Below add:

PHP Code:

case 'quotes.php':   if ($values['do'] == 'list')   {    $userinfo['activity'] = 'listaquotes';   }   else if ($values['do'] == 'addquote')   {    $userinfo['activity'] = 'agregaquotes';   }   else if ($values['do'] == 'delquote')   {    $userinfo['activity'] = 'borraquotes';   }   break;

Find:

PHP Code:

case 'modcplogin':    $userinfo['action'] = $vbphrase['moderator_control_panel_login'];    break;

Below add:

PHP Code:

case 'listaquotes':             $userinfo['action'] = '<a href="quotes.php?do=list">Quote List</a>';             break;   case 'agregaquotes':             $userinfo['action'] = '<a href="quotes.php?do=addquote">Adding Quotes</a>';             break;   case 'borraquotes':             $userinfo['action'] = 'Deleting Quotes';             break;

Done :squareeyed:
If you have skill, you can change the labels with custom phrases.
Hope Help

Close

by Acido

Download

This modification is archived and cannot be downloaded.

Screenshots

Major Additions QuoteIt! - Quote Database	vBulletin 3.6 Add-ons
QuoteIt! - Quote Database	vBulletin 3.5 Add-ons
QuoteIt! 2.0 - Quote Management System	vBulletin 3.0 Full Releases

vBulletin LTS

Spoiler (click to open)

Spoiler (click to open)

Spoiler (click to open)

Spoiler (click to open)