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]

[daFish]

Nice hack. Installed it on my testsystem and its running fine.
Looking forward to verison 2.

[Giveit2u43]

My members are loving this hack and having great fun adding quotes.. One feature they did request was that It showed up the name of the member who submitted the quote.. I`ll be adding this myself on my installation but thought it might be a nice addition for the official version, maybe with an admin on/off option??

[magnus]

Originally Posted by Giveit2u43

My members are loving this hack and having great fun adding quotes.. One feature they did request was that It showed up the name of the member who submitted the quote.. I`ll be adding this myself on my installation but thought it might be a nice addition for the official version, maybe with an admin on/off option??

Yea, that'll be added. I store the userid of the person who submitted the quote, so it's just a matter of tossing $randomquote[userid] out somewhere.

[Giveit2u43]

Originally Posted by magnus

Yea, that'll be added. I store the userid of the person who submitted the quote, so it's just a matter of tossing $randomquote[userid] out somewhere.

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

[magnus]

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]
INSERT INTO phrase (languageid, varname, text, phrasetypeid) VALUES (0, 'view_all_quotes', 'View All', 1);
[/SQL]

3. Edit the randomquote TEMPLATE:

Find:

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

<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

$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

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

[NuclioN]

"this is a test" ( | | )test quote <-- is what i see. No username and no link to submit or display all quotes

[Leah]

Originally Posted by NuclioN

"this is a test" ( | | )test quote <-- is what i see. No username and no link to submit or display all quotes

I had the same problem, but when I clicked edit on one of the phrases and saved it without doing anything in the admincp it fixed it somehow.

[Leah]

Does anyone know why I get this error message on the indexpage?

Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /usr/home/sites/xxxxxx/www/forum/index.php(115) : eval()'d code on line 19

Parse error: parse error, expecting `']'' in /usr/home/sites/xxxxxxx/www/forum/index.php(115) : eval()'d code on line 19

[magnus]

Originally Posted by NuclioN

"this is a test" ( | | )test quote <-- is what i see. No username and no link to submit or display all quotes

Yea, like kie said. Open up the phrase manager, click "edit" on any thread (it doesn't matter which), and then click save. In some cases you need to reload(?) the phrase database. I have no idea why, but I've run into this myself before.

[magnus]

Originally Posted by kie

Does anyone know why I get this error message on the indexpage?

Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /usr/home/sites/xxxxxx/www/forum/index.php(115) : eval()'d code on line 19

Parse error: parse error, expecting `']'' in /usr/home/sites/xxxxxxx/www/forum/index.php(115) : eval()'d code on line 19

Looks like a cut & paste gone wrong? I'm assuming line 19 is the QuoteIt! code. It looks like you left off a few trailing characters, open up the readme file and cut/paste again.