vb.org Archive - QuoteIt! - Quote Database

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - QuoteIt! - Quote Database (https://vborg.vbsupport.ru/showthread.php?t=97585)

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

https://vborg.vbsupport.ru/showthrea...252#post924252

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

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

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

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

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

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

Gladly.

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

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.

Did both - no joy.

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

PHP Code:


		
			
<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',EndColorStr='#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 />

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.

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

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

Quote:

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?

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:

PHP Code:


		
			
unset($threshold);

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

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?

Quote:

Originally Posted by SnM-Loki

Try telling the module not to use the module shell template.

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?

Quote:

Originally Posted by halpern

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.

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?

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

Quote:

Originally Posted by Cap'n Steve

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

Thanks alot, got it working now :D!

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.

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

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

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

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?

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

[sql]UPDATE $TPsetting SET value = 1 WHERE varname = "showquote"[/sql]

[sql]UPDATE $TPdatastore SET data = "" WHERE title = "options"[/sql]

Quote:

Originally Posted by Cap'n Steve

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.

Code:

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. ;)

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

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

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

Quote:

Originally Posted by username12

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?

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

Jaks

Cataegories will definitely be in version 3.0.

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.

There's no search feature yet.

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

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

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.

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.

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01648 seconds Memory Usage 1,910KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: