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

Cap'n Steve 01-27-2010 05:21 AM

Quote:

Originally Posted by Dr. Bantham (Post 1965164)
Has anyone tried this mod out with VB4.0?

I'd be very surprised if it worked on vB4 without any changes.

L2V 02-04-2010 12:38 AM

Quote:

Originally Posted by Cap'n Steve (Post 1967683)
I'd be very surprised if it worked on vB4 without any changes.

Cap'n Steve,
Are you open to financial incentives to update this mod for vb4?

Cap'n Steve 02-04-2010 09:14 PM

Thanks, but that's not really the issue. I just don't have the time right now to give it the attention it needs, especially since the licensing changes mean that I'm probably going to stop using vBulletin completely.

Dr. Bantham 02-07-2010 11:56 AM

Quote:

Originally Posted by Cap'n Steve (Post 1974973)
Thanks, but that's not really the issue. I just don't have the time right now to give it the attention it needs, especially since the licensing changes mean that I'm probably going to stop using vBulletin completely.

Steve, this is sad news indeed. QuoteIt! is one of a handful of modifications which I deem essential to my vBulletin installation. Will you be permitting another developer to take over this modification? Unfortunately, I am not talented enough to offer this service myself. I have invested in VB4 already but will not be upgrading until key modifications are compatible (not to mention remaining bugs and shortcomings).

I receive the following errors on forumhome when I enable QuoteIt! within an upgraded test installation:
Quote:

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: quote_listbit in [path]/includes/functions.php on line 3893

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in [path]/includes/class_bootstrap.php(1146) : eval()'d code on line 67

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: quote_randomquote in [path]/includes/functions.php on line 3893
Executing quotes.php results in the following:
Quote:

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in [path]/includes/class_bootstrap.php(1146) : eval()'d code on line 67

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: quote_listbit in [path]/includes/functions.php on line 3893
(REPEATED SEVERAL TIMES)

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: navbar in [path]/includes/functions.php on line 3893

Parse error: syntax error, unexpected T_STRING in /ROOT DIRECTORY (REFERENCE REMOVED)/quotes.php(172) : eval()'d code on line 1

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: quote_filterbit in [path]/includes/functions.php on line 3893

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: quote_listquote in [path]/includes/functions.php on line 3893
Note that the page resolves normally after these error messages, though the style format is heavily broken when viewing the quotes page.

Viewing a post with an embedded quote displays the following, with no page resolution thereafter:
Quote:

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in [path]/includes/class_bootstrap.php(1146) : eval()'d code on line 67

Warning: Cannot modify header information - headers already sent by (output started at [path]/includes/class_core.php:4501) in [path]/includes/functions.php on line 3742
Does anyone know where to start with resolving these issues?

MagicThemeParks 02-07-2010 12:37 PM

Although it is very basic, I've started to use this mod now: https://vborg.vbsupport.ru/showthread.php?t=230010

Steve, I understand about the licensing issues with vB as I'm also sticking with 3.8x until the 'end of life'. I'm testing out other forum software in the meantime to see which way I'd like to move. Good luck to you! :up:

Cap'n Steve 02-12-2010 07:55 AM

Quote:

Originally Posted by Dr. Bantham (Post 1976585)
Will you be permitting another developer to take over this modification?

I edited the original post and posted a link in the Private Coders Discussion forum a while ago to see if anyone was interested in taking over the mod. No takers so far. :(

Quote:

Originally Posted by Dr. Bantham (Post 1976585)
I receive the following errors on forumhome when I enable QuoteIt! within an upgraded test installation:

I guess they changed the way you use templates. Unfortunately, I have no idea what specific changes they made.

Frank Sinatra 02-14-2010 02:28 AM

Thanks works perfect using vb 3.8.4
Really like it

lovegirl 04-19-2010 02:50 PM

thanks for the mod gonna try it soon

S@NL - BlackBik 04-28-2010 08:29 PM

I have a strange layout problem in IE8.
Please check the attachment.
The quotation-close.png is off place.
Does anyone have any clue how this can be solved?

Cap'n Steve 05-05-2010 05:33 AM

I'm not sure what causes that, but it happens in some versions of IE. The only way I could solve it was to hide the closing quotation mark.

S@NL - BlackBik 05-05-2010 06:28 AM

Could it have something to do with cascading style sheets?
I know IE is not very good in interpreting those.
But I'm sorry to say I have no knowledge of CSS....

S@NL - BlackBik 05-05-2010 03:39 PM

I've found the problem and as I suspected it's in the style sheets.
I edited three style elements in quoteit_main.css and now the layout is acceptable in IE8, Firefox, Safari and Chrome.
Note: this what I found acceptable. You may not like it. So if you're going to try it out, make sure you back-up the original css file. That way you can always revert to the original style.

Here's what I've cooked up:

Code:

.quotetext {
        position: relative;
        margin-left: 10px;
        margin-right: 10px;
        z-index: 10;
        max-width: 55%;
}

/* IE ignores percent margins */
.openquote {
        position: absolute;
        vertical-align: super;
        position: relative;
        margin-left: -75px;
        right: 0;
        margin-bottom: -40px;
        z-index: 5;
        font-size: 7em;
        color: #E3E9F2;
        font-family: "Bernard MT Condensed", "ITC Garamond", "Trebuchet MS", Garamond;
}

.closequote {
        position: relative;
        vertical-align: super;
        margin-top: -10px;
        margin-right: 100px;
        margin-bottom: -40px;
        z-index: 5;
        font-size: 7em;
        color: #E3E9F2;
        font-family: "Bernard MT Condensed", "ITC Garamond", "Trebuchet MS", Garamond;
}


lovegirl 05-12-2010 03:10 AM

i get this error when i try to delete

Warning: Invalid argument supplied for foreach() in [path]/quotes.php on line 726
and a db error

Cap'n Steve 05-12-2010 11:52 PM

Thanks for the updated CSS, S@NL - BlackBik.

lovegirl - What version of vBulletin are you using?

lovegirl 05-13-2010 06:06 AM

Quote:

Originally Posted by Cap'n Steve (Post 2036052)
Thanks for the updated CSS, S@NL - BlackBik.

lovegirl - What version of vBulletin are you using?

i use 3.8

Cap'n Steve 05-13-2010 09:42 PM

I don't know what the problem is, but try deleting each quote individually using the "delete this quote" link. That should work.

lovegirl 05-14-2010 08:04 AM

thats what i'm doing , and i had an old version 2.1 i think, it worked perfectly , since i upgrade it , it gives that error i don't know whats wrong but i hope this one will get fixed cause its nicer and it has more options :( . if i back up would this error affect it or no on restore ?
thanks for support and your time

PS: this is the full error hope it will help to be fixed
Warning: Invalid argument supplied for foreach() in [path]/quotes.php on line 726


Database error in vBulletin 3.8.5:

Invalid SQL:

SELECT * FROM quotes
WHERE quoteid IN ();

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 ')' at line 2
Error Number : 1064
Request Date : Friday, May 14th 2010 @ 03:07:35 AM
Error Date : Friday, May 14th 2010 @ 03:07:35 AM
Script : http://url/forum/quotes.php
Referrer : http://url/forum/quotes.php?perpage=...te&quoteid=132
IP Address : xxx
Username : xxx
Classname : vB_Database
MySQL Version : 5.0.67.d7-ourdelta-log

Cap'n Steve 05-20-2010 06:24 AM

That's weird, so the quote is getting deleted, right? It just seems to have an error displaying the page after the deletion. Try using the checkboxes and dropdown menu to delete quotes.

Amiga Harrison 06-09-2010 02:39 PM

Any plans for a vB4 release?

Or does anyone know of a similar mod for vB4 that could be used as a replacement? I've been using this great mod for a Poster of the Month competition for the past years, with members quoting posts, and the one with the most votes winning that member the month's title.

tyteen4a03 06-12-2010 03:49 AM

Qdbs(www.qdbs.org)

Is there a converter for QdbS to QuoteIt!?

docvader 07-23-2010 05:12 PM

I don't think Capn Steve is going to update it, as per his posts. Hopefully someone else will take over this great mod (I've been using it for years, and had to stop because I'm using vb4...). A lot of my users have been wondering where it went.

vivamexico55 10-14-2010 06:35 AM

+1 to a request for VB4 version of this mod...

career 05-07-2011 10:10 AM

Ajax voting feature doesn't work properly when quote placed in forumhome page.
Can anyone help?

rinkrat 08-15-2011 03:20 AM

Need 4.x.x version

rinkrat 09-05-2011 08:21 PM

This is a GREAT community-building mod because you use quotes from your own users. Can someone PLEASE resurrect it for VB4? I still have the data and quotes in my database.

If I could write code I'd be all over this but I don't have a clue.

Anyone??

NTMID8 09-06-2011 02:50 AM

Yes... this is re-usable code. Who wants to take on a new version to support v4.x?

Megareus Rex 09-08-2011 06:58 PM

Does anyone know how it would be possible to remove some queries this adds to forumhome? I checked and it apparently adds a massive FIVE queries to that page. Surely there's a way to trim that down, for anyone adept at coding.

rinkrat 07-10-2012 04:35 PM

Wow, still no VB 4.X.X version.

We need this back!!

Draffi 09-09-2012 04:30 PM

Yes, please!

Can somebody code a vb 4.x version?

Would be nice...

rinkrat 07-31-2013 09:27 PM

Someone needs to update this. One of the mods that builds community.


All times are GMT. The time now is 03:47 AM.

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.02885 seconds
  • Memory Usage 1,840KB
  • 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
  • (4)bbcode_php_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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