vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - QuoteIt! - Quote Database (https://vborg.vbsupport.ru/showthread.php?t=135297)

AfterWorldForum 12-12-2009 07:14 PM

That did not seem to do anything for me. I must admit though that I've been working on an attempt of my own to implement a new module, but so far have not been succesful. I might have accidently messed up the template in the process.

Once again, though, thanks for all your help and effort. By far the best support I've seen on any mod.

Cap'n Steve 12-13-2009 08:14 AM

I edited the plugin in the previous post, try uploading it again. I included some code that might give me a little more information, but if this doesn't help, I'm running out of ideas.

AfterWorldForum 12-17-2009 03:33 PM

Man, you're going to hit me or something, but I figured it out.

When looking at the main options, I noticed it stated something in the field for the Portal Output Global Variables, that one page (which would be my portal) was not configured to use the default.

After I added the showrandomquotes to the variables list there, it worked. I need to figure out the proper layout to use, but at least things seem to finally work :)

I'm feeling all embarrassed now for it bieng so obvious, and having wasted your time like that :(

Cap'n Steve 12-17-2009 11:44 PM

Yeah, I knew it had to be something simple I wasn't seeing. Glad you got it working!

Sadie Frost 12-20-2009 12:46 AM

I still have a problem with unapproved quotes being viewable to all members - has anyone had this problem and found a fix?

:)

Cap'n Steve 12-21-2009 05:26 AM

I don't know what would cause that problem. Try re-saving your QuoteIt! options, and your usergroup permissions. If that doesn't work, enable debug mode and then view the quotes page on a non-moderator account, show the queries being run and post any quotes related queries that you see.

Sadie Frost 12-21-2009 08:14 PM

It's only with the random quote on the index page where the unapproved quotes show. I have three boards that have used quote it for years with the same problem. I did a clean install of vb and QuoteIt and got the same thing happening.

Here are the quote-related queries on the index page:


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

SELECT quotes.*, categories.title AS category, users.username FROM quotes AS quotes
LEFT JOIN user AS users ON quotes.userid = users.userid
LEFT JOIN quotecategories AS categories ON categories.categoryid = quotes.categoryid WHERE quotes.average >= 0 AND quotes.rating >= 0 LIMIT 281, 1

SELECT rating AS yourvote FROM quoteratings WHERE quoteid = 575 AND userid = 6370

Thanks Steve :) I love QuoteIt, whether regular members see the spam or not ;) :)

Cap'n Steve 12-23-2009 05:36 AM

Ok, try this. In includes/functions_quoteit.php find this

PHP Code:

    $threshold is_array($threshold) ? 'WHERE ' implode(' AND '$threshold) : ''

and above that, add this

PHP Code:

    $threshold[] = 'quotes.approved = 1'


Dr. Bantham 01-24-2010 12:15 PM

Has anyone tried this mod out with VB4.0?

Sadie Frost 01-25-2010 03:36 AM

Quote:

Originally Posted by Cap'n Steve (Post 1936103)
Ok, try this. In includes/functions_quoteit.php find this

PHP Code:

    $threshold is_array($threshold) ? 'WHERE ' implode(' AND '$threshold) : ''

and above that, add this

PHP Code:

    $threshold[] = 'quotes.approved = 1'


That seems to be working now - at least on my test board. Thank you so much Steve! You're awesome - much appreciated! :)


All times are GMT. The time now is 01:05 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02028 seconds
  • Memory Usage 1,747KB
  • 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
  • (4)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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