QuoteIt! - Quote Database

[tarot]

tarot - I think it is the Forumdisplay template. As for the second step, go to your Plugin Manager, edit the plugin called "Random Quote", change the hook to "global_start" and add that piece of code at the end.

jaks - Parsing bbcode would require you to modify the code, and I can't really help you since I haven't gotten around to learning how to do it myself.

Thank you Cap'n Steve, that did it, one more silly question how would I do multiple forums. I repeated the if line and changed the variable it worked but I'm sure it is really dirty. I tried commas and spaces neither worked, I bet it is a semicolon am I right? Thanks again.

[Cap'n Steve]

Try something like this:

<if condition="in_array($_REQUEST['f'], array(forumid1, forumid2, forumid3))">$showrandomquote</if>

[NoPonies]

Try something like this:

<if condition="in_array($_REQUEST['f'], array(forumid1, forumid2, forumid3))">$showrandomquote</if>

Thank you very much I will put that in.

[Dolamite]

i installed it.... and it worked.... then for reasons i cannot explain.... it now says this

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT COUNT(*) AS count FROM quotes AS quotes
WHERE approved = 1 AND quotes.average >= 0 AND quotes.rating >= 0;

MySQL Error : Unknown column 'quotes.average' in 'where clause'
Error Number : 1054

[Cap'n Steve]

Run this query and tell me what it says:

SHOW CREATE TABLE $TPquotes

Replace the $TP with your table prefix.

[Dolamite]

i don't use a table prefix so i ran it as $quotes.... got some error...

anyways i uninstalled, and reinstalled... and it works again.... but... now i'm wondering if that reinstall.... wiped all my old quotes? And if so... I have the old database.... so it must be possible to import them somehow....

[Cap'n Steve]

You should also have removed the dollar sign. Uninstalling will delete all your quotes, but if you have the backup you can restore your quotes table through phpMyAdmin or just run all the queries.

[majoreyeswater]

In moderation, when I attempt to moderate one (happens in delete, or approve) I get this:

Could not find phrase 'quote_x_has_been_approved'.

Aside from the missing phrase, it approves or deletes properly.

I also get this, can anyone advise where I can amend it.

Also, and atthe risk of looking extremely dim, what are the following for:

Average Threshold and Total Threshhold. Also, what does 'enable context' do? Is that for BB code?

Any help appreciated.

[Cap'n Steve]

Don't worry about the phrase, it's harmless.

An explanation of those options is in this post.

[majoreyeswater]

Bubble #5 - Sorry, it explains it under the Forum Home Options, but not under the QuoteIt! Options, here's an explanation:

Total Threshold - Quotes won't show up as the Random Quote unless their total rating is at least this number.

Average Threshold - Quotes won't show up as the Random Quote unless their average rating is at least this number.

Context - This is just an extra text box where users can include extra information, like where the quote came from.
Thanks for that, and sorry if I am going over old ground, but my questions is:

If they aren't allowed to show up in random posts until a certain rating is received, how do they appear at all to get their rating? I suppose I had just better try the threshold options and see what happens.

Thanks for this feature, really adds to the site.

[Cap'n Steve]

They'll still show up when browsing the list of quotes, just not in the random quote on your forum home page.

[Dolamite]

Run this query and tell me what it says:

SHOW CREATE TABLE $TPquotes

Replace the $TP with your table prefix.


quotes CREATE TABLE `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`), KEY `approved` (`approved`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1

[Cap'n Steve]

You somehow reverted to the old quotes table. Run these queries to fix it, replacing $TP with your table prefix:

ALTER TABLE $TPquotes ADD COLUMN votes int (5) unsigned not null default 0

ALTER TABLE $TPquotes ADD COLUMN rating int (10) not null default 0

ALTER TABLE $TPquotes ADD COLUMN average float (3, 2) not null default 0.00

ALTER TABLE $TPquotes ADD COLUMN context varchar (250)

[Dolamite]

sweet man... fixed it...appreciate your help

[HumourForum.com]

Great! However is there anyway I can make the random quote bit smaller? Thanks.

[Cap'n Steve]

You'd have to edit the quote_randomquote template and rearrange it to your liking.

[S@NL - BlackBik]

Thanks Cap'n Steve, installed and works fine :)

[S@NL - BlackBik]

I've made a little modification that shows the name and avatar of the user that posted a quote. This is only shown in the random quote at forumhome. Maybe someone else also likes this so I thought to share it with you people :)
Here goes:
Open the phrasemanager and add a new global phrase "added_by".
Open the plugin "Random Quote" and find:
eval('$showrandomquote = "' . fetch_template('quote_randomquote') . '";'); (this is at the bottom of the code)
Above it, insert:
require_once('./includes/functions_user.php');
$userinfo[avatarurl] = fetch_avatar_url($randomquote[userid]);
if (!$userinfo[avatarurl]) {
$userinfo[avatarurl] = "";
} else {
$userinfo[avatarurl] = $vbulletin->options['bburl'] . '/' . $userinfo[avatarurl][0];
}
Save the plugin and open the templates editor and the template: "quote_randomquote".
Find <tr><td class="alt1" width="30%"></td>

and replace by:
<tr><td class="alt1" width="20%">$vbphrase[added_by]:<br>
<if condition="$userinfo[avatarurl]">
<a href="member.php?u=$randomquote[userid]"><img src="$userinfo[avatarurl]" border="0" alt="$randomquote[username]" height="50" width="50"/>
</if></a>
<a href="$vboptions[bburl]/member.php?userid=$randomquote[userid]">$randomquote[username]</a></td>
And you're done :)
Check http://forum.seti.nl/ for a demo.

Enjoy

Thanks go to amykhar, cause I used part of her code from her avatar on WOL (https://vborg.vbsupport.ru/showthread.php?t=94671) hack :)

[HumourForum.com]

Awesome! Thanks for sharing!

[kizzmet]

I am running vb 3.5.4 and CMPS v2

Everything works fine in the forum, and it shows up in moderation sections, it also kept the old quotes from my previous version which is awesome. Over all I cannot thank you enough for posting this Captain.

The problem I am having is this:

When I create the module for the CMPS home page, I follow your directions but when I hit Save or whatever, I get this message:

You already have a Module with an identifier of ''. Please select a different identifier.

Any ideas? I checked the modules page and no I don't already have anything for quote it in there. And I reverted my old quote it templates before installing.

I appreciate any thoughts on it.

[Cap'n Steve]

Does it actually say the identifier is blank? Can you take and post a screenshot of the values you have filled out before you hit save?

[kizzmet]

Does it actually say the identifier is blank? Can you take and post a screenshot of the values you have filled out before you hit save?

Here you go..the fields I enter and the results it gives me.

[Cap'n Steve]

Just put whatever you want in the Identifier field. I suggest "Random Quote".

[kizzmet]

*sigh* so simple too. That worked thank you.

And noticing the 18 pages of questions and you being on the ball to answer each one, thanks for doing such an awesome job. Your hack is great and your support is great. *cheers*

[Torqued]

I upgraded from vB 3.0.7 -> 3.5.4.

What do I need to do to upgrade this mod? When I try to run the install xml, I get this:

Invalid SQL:

INSERT INTO datastore
(title, data) VALUES
("quote_settings", "1:0::1:5:0:::");

MySQL Error : Duplicate entry 'quote_settings' for key 1
Error Number : 1062

I'd really like to not lose all my quotes. :(

tnx

[Cap'n Steve]

Try using this instead of the version in the zip file:

[Torqued]

Thanksk, Cap'n Steve! That worked!!

[Christie189]

Awesome hack!

Is there anyway to make this so that guests/unregistered users wouldn't be able to see it on my main page? Thanks in advance. :)

Oh and also, in the postbit. How do I change the link (submit to quotes) to an image?

[S@NL - BlackBik]

Is there anyway to make this so that guests/unregistered users wouldn't be able to see it on my main page? Thanks in advance. :)
As far as I know not at this moment.
Oh and also, in the postbit. How do I change the link (submit to quotes) to an image?
First make an image. Then upload it to directory images/_s2/buttons on your server, where _s2 is the dir for your style.
Then edit the link like this:

<!-- hack: BEGIN QuoteIt! -->
<a href="$vboptions[bburl]/quotes.php?$session[sessionurl]do=submitpost&amp;postid=$post[postid]"><img src="$stylevar[imgdir_button]/quoteit.gif" alt="$vbphrase[submit_to_quotes]" border="0" /></a>
<!-- END QuoteIt! -->

[Cap'n Steve]

To hide the quote from guests, in your FORUMHOME template find
$showrandomquote

and replace it with
<if condition="$vbulletin->userinfo[userid]">
$showrandomquote
</if>

[Robbed]

Would this help out at all, so it will parse?

https://vborg.vbsupport.ru/showthread.php?p=924252#post924252

[Cap'n Steve]

Thanks for the link, bbcode is definitely going to be included in the next version.

[dieselpowered]

I ended up removing this hack as it messes with the location of guest in the whose online page, some show locations, others just show a blank field.

Other than that, a very nice hack :)

[Cap'n Steve]

Do you have any other products installed? Would you happen to know what pages they were on when it showed up blank?

[Greebo]

Steve - sorry I was in the wrong thread before - I may have pulled down the wrong code just recently in trying to update.

Let me redo everything and see if it works then.

Thanks

[Greebo]

Ok, I've reinstalled everything and even have the random quote showing up on the forum index for now - but even reinstalling the module for CMPS I can't seem to get the module to display.

The url again (so you don't have to dig) is http://www.pilotsofamerica.com

Thanks for any advice you can offer.

Chuck

[Cap'n Steve]

Well I just upgraded to the latest vBadvanced and had no problems, could you post a screenshot of your random quote module settings?

[Greebo]

Gladly.

These are the pertinent settings - permissions are all set to yes:

[Cap'n Steve]

I bet your problem is that "Display Order" is set to 0. If changing that doesn't fix it, try setting "Use Module Shell Template" to no.

[Greebo]

Did both - no joy.

Here is the quote_randomquote template - I believe its current - anything look wrong here?

<style type="text/css">
.vote {
color:$stylevar[smallfont_fgcolor];
font-family:'trebuchet ms',helvetica,sans-serif;
font-size:110%;
font-weight:bold;
background-color:$stylevar[button_bgcolor];
<if condition="$vbulletin->options[ratequote]==1">
width:25px;
height:25px;
</if>
border-top-color:$stylevar[alt2_bgcolor];
border-left-color:$stylevar[alt2_bgcolor];
border-right-color:$stylevar[alt1_bgcolor];
border-bottom-color:$stylevar[alt1_bgcolor];
filter:progid:DXImageTransform.Microsoft.Gradient
(GradientType=0,StartColorStr='#aa$gradient1',EndC olorStr='#aa$gradient2');}
}
</style>
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="0" border="0" width="$stylevar[tablewidth]" align="center">
<thead>
<tr>
<td class="tcat">
$vbphrase[random_quote]
</td><td class="tcat" align="right">
<div align="right">

(<a href="$vboptions[bburl]/quotes.php?do=addquote">$vbphrase[add_a_quote]</a>

<if condition="$vbulletin->userinfo['permissions']['adminpermissions']">
| <a href="$vboptions[bburl]/quotes.php?do=delquote&quoteid=$randomquote[quoteid]">$vbphrase[delete_this_quote]</a> | <a href="$vboptions[bburl]/quotes.php?do=editquote&quoteid=$randomquote[quoteid]">$vbphrase[edit_this_quote]</a>
</if>

| <a href="$vboptions[bburl]/quotes.php?do=list">$vbphrase[view_all_quotes]</a>)
</div>
</td><td class="tcat" style="width:15px;">
<div style="float:right;" align="right">
<a 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></div>

</td>
</tr>
</thead>
<tbody id="collapseobj_forumhome_randomquote" style="$vbcollapse[collapseobj_forumhome_randomquote]">
<tr><td class="alt1" width="30%"></td>
<td class="alt1"><div style="font-style:italic;margin-right:10%;">
<p>&quot;$randomquote[quote]&quot;</p>
<p style="font-weight:bold;margin-left:25%;">- $randomquote[author]<if condition="$randomquote[context]"> ($randomquote[context])</if></p>
</div>
</td><td class="alt1" valign="top">
<a style="float:$stylevar[right];" href="$vboptions[bburl]/quotes.php?do=view&quoteid=$randomquote[quoteid]">#$randomquote[quoteid]</a>
</td>

</tr>
<if condition="$vbulletin->options[ratequote]==3">
<tr><td class="alt1" align="left" colspan="3">
$vbphrase[total_rating]: $randomquote[rating] - $vbphrase[average]: $randomquote[average]
</td>
</if>

<if condition="$vbulletin->options[ratequote]==1">
<tr><td class="alt1" align="left">
$vbphrase[total_rating]: $randomquote[rating] - $vbphrase[average]: $randomquote[average]
</td>
<td class="alt1" align="right" colspan="2">$vbphrase[rate_this_quote]:
<form name="rateplus" action="$vboptions[bburl]/quotes.php">
<input type="hidden" name="do" id="do" value="rate" />
<input type="hidden" name="quoteid" id="quoteid" value="$randomquote[quoteid]" />
<input type="hidden" name="vote" id="vote" value="plus" />
<input type="submit" value="+" class="vote" />
</form>
&nbsp;
<form name="rateminus" action="$vboptions[bburl]/quotes.php">
<input type="hidden" name="do" id="do" value="rate" />
<input type="hidden" name="quoteid" id="quoteid" value="$randomquote[quoteid]" />
<input type="hidden" name="vote" id="vote" value="minus" />
<input type="submit" value="-" class="vote" /></form>
</td>
</if>
<if condition="$vbulletin->options[ratequote]==2">
<tr><td class="alt1" align="left">
$vbphrase[total_rating]: $randomquote[rating] - $vbphrase[average]: $randomquote[average]
</td>
<td class="alt1" align="right" colspan="2">$vbphrase[rate_this_quote]:
<form name="voting" id="voting" action="$vboptions[bburl]/quotes.php">
<input type="hidden" name="do" id="do" value="rate" />
<input type="hidden" name="quoteid" id="quoteid" value="$randomquote[quoteid]" />
<select name="vote" id="vote" onchange="document.voting.submit();">
<option value=""></option>
<option value="1">&nbsp;&nbsp;1&nbsp;&nbsp;</option>
<option value="2">&nbsp;&nbsp;2&nbsp;&nbsp;</option>
<option value="3">&nbsp;&nbsp;3&nbsp;&nbsp;</option>
<option value="4">&nbsp;&nbsp;4&nbsp;&nbsp;</option>
<option value="5">&nbsp;&nbsp;5&nbsp;&nbsp;</option>
</select>
</form>
</td>
</if>

</tr>
</tbody>
</table><br />

[Cap'n Steve]

I don't think it would be a template problem, and since my module settings are the exact same as yours except for the two I mentioned, my only advice at this point is to reupload the files and reinstall (don't uninstall first, just make sure "allow overwrite" is checked). You could also revert all your quote templates, but that shouldn't make a difference.

[Serial Killer]

This hack looks pretty cool. Will it work with 3.5.4?

[Borgs8472]

Steve! Oh god of this wonderful hack!

I recently renamed my forum index from index.php to forums.php, now I can't do quotes.php?do=list, I get

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT COUNT(*) AS quotes FROM quotes
WHERE AND quotes.average >= 0 AND quotes.rating >= 0 approved = 1;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND quotes.average >= 0 AND quotes.rating >= 0 approved = 1' a
Error Number : 1064
Date : Friday, April 14th 2006 @ 08:56:21 PM
Script : http://www.torrentforge.com/quotes.php?do=list
Referrer : http://www.torrentforge.com/forumdisplay.php?f=15
IP Address : XX.xx.xx.xx
Username : Borgs
Classname : vb_database
How can I fix this?

[Cap'n Steve]

Serial Killer - Yes, it works with all versions of 3.5

Borgs8472 - Are you sure that's the only thing you changed? The only thing I could think of that would cause that is if you changed the random quote to be on every page. Try adding this to the end of the Random Quote plugin:

unset($threshold);

[Borgs8472]

It is fixed! Praised be to Steve the Quote God!

( I say this as this is my favourite hack ever I think ;) )

I indeed have random quotes on every page, on the sidebar in fact. Take a look, it's sexy :) http://www.torrentforge.com/forum.php

[SnM-Loki]

Anyone else have a template problem such as this? All I did was do the edits exactly as instructed and put the module in the center block .. this is the result (see screenshot)...

Anyone know the quick fix?

[Snort_2005]

Anyone else have a template problem such as this? All I did was do the edits exactly as instructed and put the module in the center block .. this is the result (see screenshot)...

Anyone know the quick fix?
Try telling the module not to use the module shell template.

[halpern]

Is there anyway to add this mod as a left block within vbadvance cmps? i find, for my liking that is, that i would prefer having it be a smaller block and not as a center block. On my site theofficeforum.net, I have another quote mod on the left side in a small block. I'd like it that way with the option to still add a quote and view them. Is this possible? Also, what happens if I have a quote which involves multiple people talking for example:

Michael Scott: I'm also part Native American Indian.
Oscar: What part Native American?
Michael Scott: Two-fifteenths.
Oscar: That fraction doesn't make any sense.
Michael Scott: Well you know its kind of hard for me to talk about... there's suffering.

Would this mod be able to list multiple quotes from different people like that in one view? In the pics of the sample mod it seems as though we only see a quote from 1 person. Thx

Also, it seems like the HTML is a little messed up..There is an enormous amount of space towards the left side of the box. Is there any way to adjust the size of the box the quotes are in?

[Cap'n Steve]

Would this mod be able to list multiple quotes from different people like that in one view? In the pics of the sample mod it seems as though we only see a quote from 1 person. Thx

It's geared toward single authors right now, there may be multiple authors in the future.

The default template will probably not look good in a side block on your CMPS, you'll need to edit the quote_randomquote template.

[Conspiracy]

Everything works fine accept I want to put the random quote in my footer so it shows up on every page, but when I do this the quote thing doesn't show up at all, how do I fix this?

[Cap'n Steve]

See this post for instructions on adding it to other templates.

[Conspiracy]

See this post for instructions on adding it to other templates.

Thanks alot, got it working now :D!

[username12]

The quote part of it works. It's getting it to show up that's causing me problems. My settings don't seem to be saving. Don't know whether that's as desired or if it's the problem.

[Cap'n Steve]

You mean the random quote isn't showing up? Try enabling it through vBulletin Options->Forum Home Page Options.

[username12]

Don't have an option there. Perhaps I missed something?

[Cap'n Steve]

Try reinstalling. It sounds like the settings never got created somehow.

[username12]

No luck. The settings to me just don't seem to be saving (when I go to the page again, they're back to the way they were at first). How would I go about manually editing the settings?

[Cap'n Steve]

Run these queries to enable it manually, replace the $TP with your table prefix:

UPDATE $TPsetting SET value = 1 WHERE varname = "showquote"

UPDATE $TPdatastore SET data = "" WHERE title = "options"

[nitro]

Attached are instructions for adding a random quote block to vBadvanced CMPS. vBportal seems to have become a commercial product, if anyone knows how to create addons for that, please let me know.

UPDATE: Added instructions for adding quotes to the quick moderation block.
Should be fairly simple to make the vba portal module work in vbPortal:

Not tested, Do try this @ Home first
You can never have enough db backups
Dont blame me if you havent followed the above

Code box used for vb licenced users veiwing only.


Copy the content of this vbA modules php (quote.php) code to your fav text editor dropping the <?php and the ?> (first and last line).

Add this global line probably before any other.

global $vbpoptions, $vbplingual, $vboptions, $vbphrase, $db;

Find:
eval('$home[$mods[\'modid\']][\'content\'] .= "' . fetch_template('quote_randomquote') . '";');

and change to:
eval('$showrandquote = "' . fetch_template('quote_randomquote') . '";');

and add below it:
return $showrandquote;


Now hop into your vbPortal CP and add a new block

Type: php
Title: Random quote
Weight: any number above 0
Link: (optional add link to the quote page if you want)
Uses templates: No (*for now)

save and then add your new php code to the text area and save again.

Preview block in the vbPortal CP

All good go toggle it on where you like in your module manager.

*Dont like the display ( portal block output )?

Copy the quote_randomquote template to P_quote_randomquote

Edit your block and change this line from:
eval('$showrandquote = "' . fetch_template('quote_randomquote') . '";');

to:
eval('$showrandquote = "' . fetch_template('P_quote_randomquote') . '";');

Now you can edit the portal output without affecting the forum home output. You may wish to try setting the block to use templates now. :)


Note this is not tested and is only show random quote with rating, but I think I may know someone who wants to try it out. ;)

Final note: ensure your quoteit threshold setting is such that you will get a random quote or you might not get displayed what was expected.

Thanks to Sandman53 for being the guineapig. ;)

[sandman53]

I can confirm that nitro's solution for vbportal works perfectly.

[username12]

First query didn't find anything. Second query worked.

[Cap'n Steve]

Thanks for the vBportal code guys, I'll be sure to include instructions in the next version.

First query didn't find anything. Second query worked.

Do you remember what the error was? The first query is the one that actually sets the option, the second just clears the cache. Anyway, does it work now?

[jaks]

Cap'n have you thought about adding categories to this? That would be sweet.

Jaks

[Cap'n Steve]

Cataegories will definitely be in version 3.0.

[Ophelia]

Is there any way to easily search the quotes? I would like to install this on our board, but it's importance is being able to search a key word and bring up any quotes that have that keyword.

Thanks.

[Cap'n Steve]

There's no search feature yet.

[TPOCJames]

So how exactly do you add a quote? I have to edit quotes.php?

[Cap'n Steve]

No, if you have no quotes it should redirect you to the add quote page the first time you go to quotes.php. If it's not doing this, go to quotes.php?do=addquote

[TRR]

I love this mod! I removed the table and placed it right above my "what's going on" box. Until my users start submitting quotes, I have it filled with Chuck Norris "Facts". lol.

If you want to see, clicky (http://forums.sportbikesite.com).

[Canis Firebrand]

Installed this and love it.

The only weird thing I see, is this. I have it set to have it place all new submitted quotes in a moderation queue.
When I, as administrator, go in and approve a quote, I get this message after I click on approve and before it takes me back to the quote moderation screen.

I followed the instructions in the zip file, except for the part in postbit_legacy.

I see it was mentioned a few times in earlier posts, from the beginning of the year.

Hoping for an update at least. I know it doesnt stop anything from working. Its just odd beause the phrase does exist in the phrase manager.

Oh well.

Thanks again for a nice quote add-on.

[Cap'n Steve]

The rogue phrase is one of many things that will be fixed in the next version. I know it's taken a long time, but it's getting close to being done. ;)

[Canis Firebrand]

Good to hear. I really like the plugin. Looking forward to the new release. :)

[jaks]

I guess there would have to be an update to the a VBA module aswell?

Jaks :knockedout:

[hurry]

Hello. I wanted an option to switch off the rating system as it takes up too much vertical space on the forum pages. How can I do this?

[Bubble #5]

Guess this doesn't work with 3.6 :(

[Cap'n Steve]

You can disable the rating system in your admincp.

Thanks for the heads up about 3.6. I haven't even downloaded it yet.

[Alien]

This works fine at least if you already have it installed before upgrading to 3.6, I haven't tested a fresh install. :)

[TPOCJames]

Question:

Can you set it so that only administrators can view the quotes.php page?

Maybe I should just do an <if> tag on all of the content? ;)

[Cap'n Steve]

You could do that, but it'd probably be better to do this:

In quotes.php, find
require_once('./global.php');

after that, add
if (!$vbulletin->userinfo['permissions']['adminpermissions']) {
print_no_permission();
exit;
}

[MortysTW]

Attached are instructions for adding a random quote block to vBadvanced CMPS. vBportal seems to have become a commercial product, if anyone knows how to create addons for that, please let me know.

UPDATE: Added instructions for adding quotes to the quick moderation block.

I think you might be linking to the wrong file or something. There aren't any instructions on how to add it to the Quick Moderation block. But besides that, I can't seem to get it to work at all. No errors, its just invisible.

I add and remove modules and create my own all the time. So I'm familiar with vBadvanced. But for the life of me I'm not sure why this block isn't appearing at all.

I've got RANDOM turned on in the vBulletin Options > QuoteIt and also in the vbulletin options>vbulletin options>forumhome

But I'm trying to get it to appear in the vBadvanced home page. I don't want it in my forums so I haven't edited those templates to get it to appear there at all.

Only thing I can figure is that with the "THRESHOLD" boxes, it says to leave it BLANK yet when I delete the ZERO and hit save, when I go back, there is a ZERO again. But making those a 1 or 3 has no affect. :(

[Cap'n Steve]

Quick moderation instructions are in the README.html file, in the second part.

Could you post a screenshot of the options you filled out for the Random Quote module?

[MortysTW]

As for the Clean File Output, I've tried it both on and off.

Here's the snapshot.

[MortysTW]

And as for the instructions in the 2nd part you are talking about, you list it as vBindex so I assumed that was some sort of other portal system. Not sure what "2nd part" you are referring to.

[Cap'n Steve]

I'm not sure where you're seeing vBindex. In the main post, there's a link to the fourth post in this thread where the vBadvanced instructions are attached. In the README.html file from that post, the instructions for quick moderating quotes are below this heading (which is in red):

These are instructions for adding quick quote moderation to your portal homepage. You must have QuoteIt! 2.1 already installed.

For your other problem: Try setting Use Module Shell Template to no. If that doesn't work, try doing the modification to the FORUMHOME template. Does the quote show up there? Do they show up when you go to quotes.php?

[MortysTW]

WTF? Okay, I'm an idiot. I must of kept opening the wrong zip. When I saved them to my PC, the only difference is the ! in the file name. And I was reading the one that showed how to add the actual vba module and on that readme, it shows the vbindex instructions too. Sorry.

And as for forumhome, the quotes don't show. The box and everything does, but the actual words don't. Its just a pair of "" in an empty box. And yes they appear when I do the quotes.php and I can add them just fine. They just won't show. I'll go try the shell OFF right now. If I don't reply, that means it still doesn't work.

[MortysTW]

Nope. Still no luck. Help me Oh Mighty Man of Quoting :)

[Cap'n Steve]

So you have quotes in the database, right? Try running these queries, replacing $TP with your table prefix, if you're using one:

UPDATE $TPsetting SET
value = 1
WHERE varname = "showquote"

UPDATE $TPsetting SET
value = ""
WHERE varname = "totalthreshold"

UPDATE $TPsetting SET
value = ""
WHERE varname = "averagethreshold"

[AAN]

Not sure if this has been asked, but how do I get the quotes to come up on every page? right now they're only coming up on the front of the forum..

[ambrosious]

Is there a graphic for the "Submit to Quotes" line that comes up in each thread? If so, where and how do I use it?!

GREAT HACK!

[MortysTW]

Alright, got it working in ForumHome finally. Thanks for the DB edit.

As for the vbadvanced part, its odd. Its not even "calling" the quotes.php file at all. I view my source code of my vbadvanced page and its nowhere in the file.

[Cap'n Steve]

AAN - This post has instructions for adding it to other pages.

ambrosious - Not right now, but I'm working on one.

MortysTW -
In modules/quote.php find this
eval('$home[$mods[\'modid\']][\'content\'] .= "' . fetch_template('quote_randomquote') . '";');

and replace that with this
eval('print_output("' . fetch_template('quote_randomquote') . '");');

Then turn Clean File Output on again. If that doesn't work, then I really don't have any idea why. You might want to ask the vBadvanced guys.

[TPOCJames]

Getting this error:

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT COUNT(*) AS quotes FROM quotes
WHERE AND quotes.average >= 0 AND quotes.rating >= 0 approved = 1;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND quotes.average >= 0 AND quotes.rating >= 0 approved = 1' at line 2
Error Number : 1064
Date : Tuesday, August 29th 2006 @ 12:20:41 AM
Script : http://www.into-thin-air.com/quotes.php
Referrer :
IP Address : removed
Username : removed
Classname : vb_database

A moron admin deleted my entire forum and this was after a backup soo... yeah.

[Cap'n Steve]

Do you have the Random Quote set to use the golbal_start hook? If that's the case, you need to edit that plugin and add this at the end:
unset($threshold);

[TPOCJames]

Thanks, I'll try that and tell you how it goes. :)

Working fine. Thanks. :)

[Antwerp]

Is there a graphic for the "Submit to Quotes" line that comes up in each thread? If so, where and how do I use it?!

GREAT HACK!

I made this button, but I'm using the old school buttons, I don't like the new ones.
http://www.driveaddictforum.com/gif/submitquote.gif

To get it to work, I used this in the postbit
<!-- BEGIN QuoteIt! -->
<a href="$vboptions[bburl]/quotes.php?$session[sessionurl]do=submitpost&amp;postid=$post[postid]">
<img src="$stylevar[imgdir_button]/submitquote.gif" alt="$vbphrase[submit_to_quotes]" border="0" /></a>
<!-- END QuoteIt! -->

Also, I changed the Phrase "Submit_to_Quote" in the phrase manager to say:
"Submit Quote to Hall of Fame"

Works Great! Love the Hack!
Thanks :)

[opteek]

Does this work with 3.6 and if not, what changes would need to be made? This is an awesome mod!

[Cap'n Steve]

It may or may not work on 3.6. If you're worried about it, you can just wait until the official 3.6 version is released, which shouldn't be too long.

[Lionel]

This does not work for me on 3.60. This is really too bad.

[Bubble #5]

you can just wait until the official 3.6 version is released, which shouldn't be too long.
Any update on this please? ;)

[Alien]

While I can't verify if it works installing it fresh, I do know that it works fine on 3.6.1 here already installed..

Can't wait for an update on this, Capt! Been a year since last, man time flies..

[Cap'n Steve]

I'm having some trouble with the Javascript right now, but it should be on my site soon for a beta test, and then released soon after. There's quite a few changes, so I want to make sure it'll work smoothly.

[Lionel]

Hum, I take it back... In uninstalled a couple of hacks, and looks like it is working now.

[murrtex]

Hello Cap'n Steve thanks for this hack and for the others.

I want to do some Please help me.
I use redirection link code ( This ) (https://vborg.vbsupport.ru/showthread.php?t=128113&highlight=interceptor)

And I want to put random quate to attention page. (at the this (https://vborg.vbsupport.ru/showthread.php?t=128113&highlight=interceptor) hack to RLI_error_message temalate)

I put
<if condition="$randomquote[context]">
( $randomquote[context] )
</if>

or

$randomquote[context]

but nothing happens

pleasa help me .How we can do that.
Thanks

[Cap'n Steve]

You want to add the random quote to the link interceptor template? This post has instructions for adding the quote to any template.

[murrtex]

yes..thank you Cap'n Steve.I'll try.

yes its done..thank you again.

[dobbs]

Steve, whats the word on the new version? Should i wait or intsall this one?

[Cap'n Steve]

It depends how patient you are. I hope to have it open to the public for testing within a week and then released a litle while later. There's no harm in installing this one and then upgrading, though.

[dobbs]

10-4, thanks

I have had it running on my 3.0.7. board for a long time and it's always worked great.

[Cap'n Steve]

It's up right now on http://forums.monkeycrap.com/quotes.php. Any feedback is appreciated.

[dobbs]

How would I get all the quotes out of a database on an old board and insert them into the database on a new board?


Also, why is doesn't the outline color around the title bar match the outline around the other title bars. I made my own style by editing color in the css. But can seem to find where the setting is for this border color.

if you want to take a peak, http://315er.net

[Robbed]

It's up right now on http://forums.monkeycrap.com/quotes.php. Any feedback is appreciated.

Where you able to have it parse bbcode?

[Cap'n Steve]

dobbs - I'm not sure about the border. Do you have a backup from the old database? If you do, you can just open it in a text editor and it should be fairly easy to find the sections from the quotes and quoteratings tables. After that you can just run those queries.

Robbed - Yes, that should be working fine. Try it out on my site if want to check.

[dobbs]

I don't know what version i had on my old board but i did an "export" of the quote table from phpmyadmin, i then went to the new database and deleted the quote table and did an import. Works fine.

Have you given any thought into making a module for vbadvanced that works on a side column. Seems like i am giving up a lot of screen real estate for one sentence and a name.

[Cap'n Steve]

I plan on doing a side block template for the random quote but haven't gotten to it yet. Any ideas on what should be taken out to make room?

[Robbed]

dobbs - I'm not sure about the border. Do you have a backup from the old database? If you do, you can just open it in a text editor and it should be fairly easy to find the sections from the quotes and quoteratings tables. After that you can just run those queries.

Robbed - Yes, that should be working fine. Try it out on my site if want to check.

Most on your site are one line quotes, but the the ones that are quoted don't look like they show up right.


"Phil- &quot;If I have sex with you Josh, can I have unlimited drink vetos?&quot;
Josh- &quot;I don't know. I guess it depends if you are giving or receiving.&quot;"

"&amp;quot;UNDERPANTS UNDERPANTS UNDERPANTS!...&amp;quot;"

[dobbs]

whose site are you talking about, those don't look like quotes from mine?

the side module:
i think all you would need is the quote and author. lose who it was added by, the #, and the "edit /delete / add" links i the nav bar.

If you had one link to the "view all" you could do all the rest of the edit/add/deletes from there. Maybe make the text in the title of the module link to "view all" . This would make it very slim and clean. If you wanted all fancy stuff like ratings you would still have to run it as a center module.

[Cap'n Steve]

Thanks for pointing that out, Robbed. I already have the code to fix that, I just need to run it.

That sounds pretty good dobbs, but I think I'll try and leave the quote number in, if at all possible, so it's easier to edit/rate/etc.

[dobbs]

true, it is small and probably wouldn't have an impact on the size of the module if it was in there

[Kadi]

Is this add on available for 3.6.2 yet?

[Cap'n Steve]

Nope.

[dobbs]

I have it installed on 3.6.2
runs fine, no problems

[Kadi]

A few questions if you dont mind.

My forum is in Arabic...right to left. Will this be a problem?
Plus its a health forum so eyesight is an issue. Will I be able to control font size?

I really could use this mod for inspirational quotes.

Thank you.

[Robbed]

One small thing.

If you can have it show the latest quotes when someone clicks on the quotes page.

[Cap'n Steve]

Robbed - You'll be able to sort them by date and also view quotes added since the last time you visited.

Kadi - The text direction will use your forum settings. The controls will stay on the right, but you can adjust that and the font size if you edit the css file.

[oz_moses]

I plan on doing a side block template for the random quote but haven't gotten to it yet. Any ideas on what should be taken out to make room?
I think someone's already done it.
https://vborg.vbsupport.ru/showthread.php?p=869008&highlight=title#post869008

[dobbs]

woah.. how did i miss that, looks perfect

[Robbed]

Robbed - You'll be able to sort them by date and also view quotes added since the last time you visited.

Kadi - The text direction will use your forum settings. The controls will stay on the right, but you can adjust that and the font size if you edit the css file.

Sounds good.

[Kadi]

Thats great. Can't wait to add it to my forum. :)

[vivamexico55]

Man, can we get this for 3.6.3?

[Cap'n Steve]

Soon.

[dobbs]

I plan on doing a side block template for the random quote but haven't gotten to it yet. Any ideas on what should be taken out to make room?


I made a side block template for vbadvanced. Thanks to jaks, I took his code and frankensteined it to make it look like what I wanted.

http://upload.315er.net/files/1/quotescreenshit.jpg

[thepub]

will this work with 3.6.2? I've been dying to get a quoter for my forum.

[thepub]

ok I thought I would take a gamble after reading this whole danged thread and install it. I followed the instructions for installing 100% with the exception of addingthe optional template change for the postbit/postbit_legacy and there is nothing. the files are in my ftp, the product is imported but there is nothing for me to edit options, enable or tweak :( I looked in vboptions and there is nothing about a quoter in anything. I'm bummed, my members have been asking for this forever too.

[Cap'n Steve]

It apparently works if you installed before upgrading to 3.6. Don't worry though, the official 3.6 version is coming up.

[dobbs]

i installed into 3.6.2 without any problems, just followed the instructions

[thepub]

i installed into 3.6.2 without any problems, just followed the instructions

braggar! ;)

I cannot wait for the new version, this has been anticipated highly!

[HellRazor]

Think you could add a feature in the new version?

It would be neat to have an option that either allows or disallows a usergroup to add quotes to the database.

[Cap'n Steve]

Already done. Real permissions was one of the first items on the list.

[HellRazor]

Already done. Real permissions was one of the first items on the list.

Excellent! :)

Looking forward to the VB 3.6.4 version!

[thepub]

how long until the release?

[thepub]

ok by some stroke of something, the quoter I installed magically appeared and started working! I'm so happy! I have a couple questions about it though. In the cp it asks about average threshold? What does that mean? I left both of those numbers at 0 until I find out what to do from here. Also, the quoter is under my shoutbox, is there a way to bring it higher up on the forum index, like maybe under the banner or something? And last question (for now), i there any way to remove the bars and box that surround the quot itself, so that it's just the text on the screen instead of a box? Like the words are floating (sort of)? Thanks! If you would like to take a look check it out at www.theneighborhoodpub.com

[Cap'n Steve]

The average and total threshold are the minimum average and total rating that a quote must have to show up as the random quote. To move the random quote, just move the $showrandomquote variable in your FORUMHOME template. If you want it to look different, you have to edit the quote_randomquote template.

[thepub]

If you want it to look different, you have to edit the quote_randomquote template.

thank you for your response. I embarrassingly admit that I have no clue how to change templates or any of the like. I only find the text specified and then paste whatever text is required lol. I don't venture on my own in the templates at all simply because I have no clue. What specifically would I need to edit or delete to make the quoter look like I want?

[Cap'n Steve]

Well $randomquote[quote] contains the quote and $randomquote[author] contains the author, so you could use just those two things. I suggest you find an HTML tutorial somewhere on the Internet and then you can adjust it better.

[Kat-Sybermoms]

For this being my very first hack I installed all on my own, it worked great!!!

I even managed to make the quoter visible to only certain usergroups and in one specific forum as well.

THANK YOU!!!

[BaconDelight]

I'm itching to install this. Any idea when it might be ported to 3.6.4?

[dobbs]

just install it, it'll work

[BaconDelight]

just install it, it'll work
According to the Cap'n himself, it only works on 3.6 if you installed it on 3.5 before upgrading (see the previous page...)

[Cap'n Steve]

That's just what I've heard. I don't have 3.6 installed anywhere yet.

[thepub]

I installed it on 3.6.2 and t's working beautifully for me. I do have a question about moderating quotes. How do you do it? I don't understand what the threshold and average threshold are and how to set them, I don't know how to moderate the quotes in that is there a que somewhere that I can view to decide what gets used and what doesn't? Sorry to sound so lame, but can someone teach me how to use this LOL!

thanks!

[BaconDelight]

Don't know about moderating, haven't tried, but the thresholds I can explain. Basically, if you have the rating system active, setting a threshold will set a minimum rating a quote must have before it will show up in the random quotes display. So if you want only quotes that have a rating of 2 or better to who up, you put "2" in the average threshold (assuming you're using the 5 point rating system).

And, for the record, I've installed it on 3.6.4 and it works fine.

[Cap'n Steve]

There should be a "Moderate Quotes" link in the Moderation section of your control panel.

[monstermunch]

Hi,
Im having trouble with this mod, it all seems to be installed ok but when i try and add a quote it only displays a " character and nothing else, if i try to edit or delete the quote is not there..

I have tried uploading it again but same problem.. any ideas what the problem is?

thanks

(update - i have fixed it - it was me!!! )

[CtrlAltDel]

Looks good Steve, thanks for keeping this one alive!

[glowinggal]

would love to add that it would be FAB to be able to have categories as well :)

[thepub]

when I approve or do anything as far as moderating quotes I get a message that says "cannot find phrase "x_has been_approved" what is that?

[Cap'n Steve]

You don't need to worry about that.

[ubblite]

ubblite - Are you sure you have the latest version? That bug should have been fixed for good.

Yup, I'm using the latest version for sure.

FYI:

If you have Photopost installed, this mod's who is online process will cause issues with Photopost's Who is online not working correctly with vB.

I have this same problem with Photopost Pro. Under 'Who's Online', it will show a blank space under 'Location' if the user is viewing the Photopost Pro Gallery.

Any ideas on how to fix this, Steve?

Thanks

[Cap'n Steve]

I'll take another look, could you tell me how many languages you normally have?

Also, you're in the wrong thread. This is for the vBulletin 3.5.x version.

[stabmyback]

Nice hack, it works very well for me. I just have a couple questions. Is there a way to edit/delete a quote? If so, how can you do it?

[Cap'n Steve]

If you have permission to edit or delete quotes (set in the usergroup manager) then there'll be an edit or delete button in the top right of each quote. You can also prune quotes from the "Quote Maintenance" page.

[stabmyback]

Oh, cool! I didn't notice that part. :D Also, one more question. Some users have said that with longer quotes, they run off the table and it's very hard to read. Is there any way to fix this? I'm not the greatest coder in the world, and I couldn't really see anything.

[Cap'n Steve]

That shouldn't happen, what browser are they using? Also, this version is a little outdated. If you're running vBulletin 3.6, you'll want to use this version instead.

[stabmyback]

I think that's the reason, they're using IE6, and I'm using IE7 and FireFox. And yeah, I noticed that it was outdated, but I don't have the capabilities to install 3.6 sadly.

[Cap'n Steve]

Well, you could try getting the templates and the css files from the 3.6 version, but I'm not sure how well that would work with this version.

[tarot]

ok, I was upgrading to the latest version on one of the boards I admin and I think I missed a version because it hosed my adminCP. I disabled plugins and got back in to disable the hack itself.

So, what can I do?

People got this message when trying to post:

Warning: require_once(/home/gottwinz/public_html/forums/includes/functions_quoteit.php) [function.require-once]: failed to open stream: No such file or directory in /showthread.php(102) : eval()'d code on line 1

Fatal error: require_once() [function.require]: Failed opening required '/home/gottwinz/public_html/forums/includes/functions_quoteit.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/gottwinz/public_html/forums/showthread.php(102) : eval()'d code on line 1

And in the ACP, it said something about functions.php/line 3701

[Cap'n Steve]

It looks like the QuoteIt! files either aren't there or are in the wrong place. Either way, you should upgrade to vBulletin 3.6 and then use the QuoteIt! for that version if you can.

[tarot]

I upgraded to 3.6.7 when this happened, so I'll try the quote it upgrade again :)

[Cap'n Steve]

Well if you don't already know, you're in the thread for the 3.5 version. Make sure you're using this version instead.

[tarot]

I got it working, thanks!