QuoteIt! - Quote Database

[gettingbetter]

I've enabled the moderation option in my QuoteIt settings, yet users have somehow been able to bypass it and their quotes show up right away on the page. What could be the problem here?

Moderate Quotes is set to YES.

[Cap'n Steve]

That is strange. Try saving the options again and try creating a new user and adding a quote with that account. Does it still get automatically approved? A link to your site might help, too.

[Dr. Bantham]

Is it feasible to be able to add additional fields to quote entries? I wish to add a URL reference field and a media file path field.

[Cap'n Steve]

I don't have time to do it right now, but it shouldn't be that hard. Just add the appropriate database columns, then add the fields in the quote_listbit and quote_manager templates and a little bit of code in quotes.php to insert the fields in the right columns.

[Dr. Bantham]

The quotes and randomquote BBCodes are not functional on my board, though they have been in the past. No content of any nature appears. I double checked the settings, and they are turned on. I saved all QuoteIt options, rebuilt bitfields, re-uploaded all files and re-imported the product. No dice. The BBCodes are there, but the Replacement fields are blank. Furthermore, the randomquote BBCode entries are stripped entirely from the post content after saving.

UPDATE #1
I deleted the BBCodes and repeated all procedures above. Now the quotes BBCode is functional, but the randomquote is still defunct.

UPDATE #2
Perhaps I spoke too soon. The quotes BBCode appears to be functional after first saving and displaying post content, however it reverts back to displaying plain text tags thereafter. When viewing the BBCodes within the BBCode manager of ACP, it displays {Q1201967627:42} in the HTML and Replacement columns for quotes and {R1201967627:0} for these respective fields for randomquote. When you edit both quotes and randomquote BBCodes, the Replacement box is empty.

UPDATE #3
I have discovered that the quotes BBCode is working only on quick replies and quick edits, and only when first displaying the post immediately thereafter. Refreshing the page or going back later to view the post reverts to plain text tags (ie "246". Again, randomquote disappears regardless.

[Cap'n Steve]

Ooh, that random quote does look pretty broken, although I don't see what you mean about the [quotes] BBCode. I'm not sure what update caused that problem, but I'll take a look at it tomorrow. Ignore the BBCodes in the admincp, though. That was originally just an example and probably should have been taken out. :o

[Dr. Bantham]

Ooh, that random quote does look pretty broken, although I don't see what you mean about the [quotes] BBCode. I'm not sure what update caused that problem, but I'll take a look at it tomorrow. Ignore the BBCodes in the admincp, though. That was originally just an example and probably should have been taken out. :oThanks for taking a look, Steve. As for the [quotes] BBCode, it appears to work upon preview and the first display of a quick reply or quick edit. However, if you refresh the post or go back later, it reverts to text as if the BBCode is unrecognized.

[Cap'n Steve]

Ok, it appears that something changed with the removal of empty BBCodes. For the time being, just put anything between the randomquote tags, like this:
oug
I still can't duplicate the [quotes] problem, though. I'd like to try it on your site, do you want to make a hidden forum or something so I can test it out?

[Dr. Bantham]

Ok, it appears that something changed with the removal of empty BBCodes. For the time being, just put anything between the randomquote tags, like this:
oug
This resulted in a blank post, though it does now retain the BBCode instead of having it stripped.I still can't duplicate the [quotes] problem, though. I'd like to try it on your site, do you want to make a hidden forum or something so I can test it out?I'm OK with a public test. You can delete your post when finished, or I can clean it up later.
As for the forum, how about this one:
http://www.ligotti.net/forumdisplay.php?f=86

Thanks again!

[Cap'n Steve]

Try reuploading the latest files and reinstalling (without uninstalling) the product. If that doesn't work, edit the "Finalize BBCode" plugin that uses the "newpost_preview" hook and replace this:

}

with this:

header('Content-type: text/plain');
die('quotes = ' . print_r($quotebbcodeids, true) . "\n random = " . print_r($randomquotes, true));
}

Then try previewing a post with a few [quotes] and [randomquote] bbcodes in it and tell me what the output is. This will break the post preview, so undo the edit after you're done.

[Dr. Bantham]

Try reuploading the latest files and reinstalling (without uninstalling) the product. If that doesn't work, edit the "Finalize BBCode" plugin that uses the "newpost_preview" hook and replace this:

}

with this:

header('Content-type: text/plain');
die('quotes = ' . print_r($quotebbcodeids, true) . "\n random = " . print_r($randomquotes, true));
}

Then try previewing a post with a few [quotes] and [randomquote] bbcodes in it and tell me what the output is. This will break the post preview, so undo the edit after you're done.I have tried the full reinstall several times previously. As for the output test, it results in the following:quotes =
random = I do have one issue which I should point out. After importing quotes on multiple occasions, the reference numbers where out of sync. At one time, Quote #1 was actually had a reference number of 400+. I "fixed" this by manually changing all of the reference numbers with phpMyAdmin, starting from 1 on. However, I noticed that any new quotes would be given a much higher number than simply the last quote number + 1. Apparently there must be a counter setting which needs to be reset. Could this be the problem? If not, I would still like to know where this number is stored and how I can change it.

[Cap'n Steve]

That is very strange. The ids are managed by MySQL, so it doesn't really matter what they are, but you should be able to reset them with this query (replacing $TP with your table prefix), although I wouldn't mess with that unless it really bothers you (that's what the "Show Continuous Quote IDs" option is for):

ALTER TABLE $TPquotes AUTO_INCREMENT = 1

The only thing I can suggest to try is finding this in includes/functions_quoteit.php:
$quotebbcodeclasses[$quoteid] = $bgclass;

and after that, adding this:


if ($vbulletin->userinfo['userid'] == 859) {
header('Content-type: text/plain', true);
echo "DEBUG: Found quote $quoteid, returning {Q" . QUOTE_BBCODE_ID . ":$quoteid}.\n";
}

Then I'll try to gather some more information tomorrow.

[Dr. Bantham]

That is very strange. The ids are managed by MySQL, so it doesn't really matter what they are, but you should be able to reset them with this query (replacing $TP with your table prefix), although I wouldn't mess with that unless it really bothers you (that's what the "Show Continuous Quote IDs" option is for):

ALTER TABLE $TPlinks AUTO_INCREMENT = 1I am not clear on this and thus reluctant to run the query. Is the table prefix "quotes"? My database name? Will this renumber the entries sequentially, but not impact quotes added thereafter? I really do want to get the numbering straight, as it does bug me considerably to have 500+ integers separating quote runs.The only thing I can suggest to try is finding this in includes/functions_quoteit.php:
$quotebbcodeclasses[$quoteid] = $bgclass;

and after that, adding this:


if ($vbulletin->userinfo['userid'] == 859) {
header('Content-type: text/plain', true);
echo "DEBUG: Found quote $quoteid, returning {Q" . QUOTE_BBCODE_ID . ":$quoteid}.\n";
}

Then I'll try to gather some more information tomorrow.This had no impact that I could discern. HOWEVER, while repeatedly working with this, I re-imported the product again (as I had done several times before). Voila! Both BBCodes now work consistently. I swear I had done this several times. As with a previous problem, importing and saving settings seem to be subject to whimsy, as there is often a variable impact. Saving settings with no change or re-importing repeatedly can sometimes fix problems - eventually - maybe - curious. Anyway, this procedure deleted the two additional fields and related data which I had created, but a quick query using a table backup fixed this. And yes, the problem was evident before I started creating new fields. At least that is the way I remember it! I am beginning to wonder, at this point. Anywho, many thanks for the persistent assistance!

[Cap'n Steve]

About the alter query, that was a typo and it should actually be run on the quotes table. :o The table prefix is whatever you chose in your config.php. I have no experience altering the auto_increment value, but it should only affect new quotes. I'm not sure how the gaps would get there in the first place; have you restored backups of the quotes table before? That's the only thing I can think of that might mess with the auto_increment value.

The edits I had you do would only show up for me (859 is my userid on your site), but if it fixed itself you can go ahead and remove them. I swear the bbcode parser has a mind of its own sometimes.

[cookiepants]

What a great mod! I have installed it and so far everything was great until I turned it on. My forumhome page was totally white. No error message. When I turned it off then it came back. I deleted the forumhome Quotes coding, and still the same problem until I turned off Quotes.

Any ideas? I'd love to use this but I'm not sure how I can turn it on and have my forum home available.

Thanks so much!

[Dr. Bantham]

About the alter query, that was a typo and it should actually be run on the quotes table. :o The table prefix is whatever you chose in your config.php. I have no experience altering the auto_increment value, but it should only affect new quotes. I'm not sure how the gaps would get there in the first place; have you restored backups of the quotes table before? That's the only thing I can think of that might mess with the auto_increment value.I fixed this with:
ALTER TABLE quotes AUTO_INCREMENT=252Instead of using 1 as the variable, I used the next desired quote number. This set the Next Autoindex to the desired value. The huge gaps occurred when I had repeatedly deleted and imported quotes from a text file. Thanks for the lead!

[Boofo]

The gaps are from quotes that have been deleted. That is normal procedure in the increment world. My home-grown quotes hack does the same thing. Be careful messing with the auto-increment too much as it can cause more headaches than it's worth sometimes. I am proof of that. ;)

[Cap'n Steve]

Thanks for posting information about the auto incrementing. I would have expected it to reuse the ids of deleted quotes, but I guess not.

cookiepants - Can you check your server's error log? Something might have shown up there. If not, try adding a quote before turning on the random quote by going to quotes.php?do=addquote on your site. You can also try reuploading the files and reimporting the product.

[cookiepants]

It worked out great, thanks! My members LOVE this feature.

Is there a way to make the font and or the quote box a bit smaller? Thanks!

[Boofo]

Thanks for posting information about the auto incrementing. I would have expected it to reuse the ids of deleted quotes, but I guess not.

No way it can, that is why it is called "auto-increment". It only increments. It doesn't care if you mess with what it did before. And those missing rows don't do anything harmful at all. It's as if they never existed except for the numbering.

[Dr. Bantham]

No way it can, that is why it is called "auto-increment". It only increments. It doesn't care if you mess with what it did before. And those missing rows don't do anything harmful at all. It's as if they never existed except for the numbering.My quotes had a gap which was greater than 500, which I found annoying and I feared confusion when members attempted a BBCode reference. Prior to executing this command, I sequentially re-numbered all existing quotes starting from 1. Otherwise, I understand that there would be a point where it would be assigning numbers which were pre-existing. That would not be a good thing!

[Boofo]

Auto-increment will not touch any rows below the last increment. Any rows it has already incrented to would never be rassigned. That's not how auto-increment works. It might have bothered you for unknown reasons but it would not have hurt anything leaving it was it was. I have over 1670 quotes in my quotes table and the increment is now at 2,000 and something. And it works like it should. The missing rows do nothing.

[Cap'n Steve]

Is there a way to make the font and or the quote box a bit smaller? Thanks!

There's a few suggestions in this thread, like this one.

[cillianok]

"Warning: Invalid argument supplied for foreach() in \includes\functions.php on line 3717"

Getting this error, all I've done is upload the files...

[cillianok]

I rebuilt bit fields and its ok.

//edit:

Is there any way to make the box smaller in height?

[Cap'n Steve]

You could either remove some information or change the spacing between rows.

[iou1]

I just installed this by uploading the xml to my forum and now I can't access my ACP without getting this error:

Warning: Invalid argument supplied for foreach() in /includes/functions.php on line 3717

[Cap'n Steve]

<a href="showthread.php?p=1153153#post1153153" title="vBulletin.org Forum - Post 1153153">Disable the plugin system</a> to get into your admincp. Then try reuploading the files and reinstalling before re-enabling the plugins.

[iBaker]

I have installed this in v3.7.0 BETA 5 and it all works ok except for the edit button in the quote - (I have given myself full edit/delete rights).

In Firefox nothing happens when I click edit - in I.E. I get this error message:
76826

Any suggestions on how to fix this would be greatly appreciated as this mod is a great enhancement - thanks Capt

[Cap'n Steve]

Try editing clientscript/quoteit_moderation.js. Find this:
var author = agent.handler.responseXML.documentElement.getEleme ntsByTagName('author')[0].firstChild.data;

and above that, add this:
alert(agent.handler.responseText);

Then try and edit a quote and tell me what the popup says.

[iBaker]

Thanks Cap't
Unfortunately now I get this msg popup followed by the msg in the bottom of the attachment - note this is on my test installation that isn't moded at all
77018

When I can get this final thing working I will post the code changes I made to get these following layouts including a random quote in a left column on the forum home without using any extra mods, addons or plugins - if any one is interested:
77028 77029

or if you prefer across the bottom of the home page:
https://vborg.vbsupport.ru/attachment.php?attachmentid=63684&d=1177652340

[Cap'n Steve]

Does the other AJAX stuff (like voting) work properly? Try reuploading the Javascript files.

[cookiepants]

How do I delete a quote I have already approved?
I would also like to make the Quote it box smaller. How do I do this?

thanks for a great mod!

[Cap'n Steve]

There should be a delete button when you're viewing a quote. Just make sure you've given yourself the proper permissions.

Like I said earlier, there are a few posts in the thread like this one that have edited styles.

[iBaker]

Does the other AJAX stuff (like voting) work properly? Try reuploading the Javascript files.
Hi Capt
I have just completely deleted QuoteIT from my test forum (note this is vb v3.7.0 BETA 5), downloaded QuoteIT again, installed it, made no template mods. The results are that:

- In Firefox v2.0.0.12
1. Quote rating works although you have to refresh the page to show that you have scored it (the same as in vb v3.6.8)
2. Clicking the highlight check box works
3. Delete works but again you have to refresh the page manually to see that it is deleted
4. When you add a quote and click submit the page returns only showing the newly added quote not the list of quotes
5. Clicking edit in a quote does nothing

- In I.E. 7.0.5730.11
1. Quote rating brings up an error "Line: 87 Error: Object expected" but rating was successful after you refresh the page
2. Clicking the highlight check box works but brings up the error "Line: 61 Error: Object expected" on both select and unselect
3. Delete brings up an error "Line: 87 Error: Object expected" but delete was successful after you refresh the page
4. Same as in Firefox
5. Clicking Edit brings up the error "Line: 312 Error: 'agent.handler.responseXML.documentElement' is null or is not an object

Hope this helps and screen shots of my settings are attached.

[Cap'n Steve]

Ok, one more thing to try. In quotes.php, find
require_once('./global.php');
require_once(DIR . '/includes/functions_quoteit.php');

and replace that with
$ajaxrequest = $_REQUEST['ajax'];
require_once('./global.php');
require_once(DIR . '/includes/functions_quoteit.php');
$_REQUEST['ajax'] = $ajaxrequest;

[iBaker]

Thanks Cap't - that worked :)

However (there is always an however) - the only thing that seems to cause an error now is the clicking of the highlight check box and only in I.E. - the one that turns the quote background yellow - all though what it is for I do not know

Thanks again Cap't!

[Cap'n Steve]

Thanks for bringing that to my attention. I guess Jelsoft decided to mess with $_REQUEST['ajax'] in global.php for some reason. I'll release a fixed update as soon as the final version of 3.7 is released.

What do you mean about the highlighting? It's used with the list at the bottom for inline moderation if that's what you're asking. What's the error?

[iBaker]

Thanks for bringing that to my attention. I guess Jelsoft decided to mess with $_REQUEST['ajax'] in global.php for some reason. I'll release a fixed update as soon as the final version of 3.7 is released.

What do you mean about the highlighting? It's used with the list at the bottom for inline moderation if that's what you're asking. What's the error?
Pleasure is all mine Cap't - glad I could help.

The error in I.E. only on the moderation select box that highlights the quote yellow is:
"Line: 61 Error: Object expected"
but it still works once you clear the error box. If you select to debug the error it is in the quoteit_common.js file and is the line that says "array_push(groupElements, allTags[i]);"

If that helps!

[romanticyao]

are you goin to release a new version for vb3.70? great new and it gonna be another MOMth!

[Cap'n Steve]

I'll release a slightly updated version to fix the AJAX problems when 3.7 is finalized.

[Megareus Rex]

EDIT: It works now. Dunno why it didn't at first.

Anyways, some more questions/problems:
1: How can I edit quotes? There's no longer an option under the quotes on the display page, nor one on the admin CP.

2: It won't let me moderate quotes. It keeps saying I don't have the necessary admin permissions, but there's no "quotes admin" option in the admin permission list.

Any help is much appreciated.

[Cap'n Steve]

What happens when you go to quotes.php?do=editquote&quoteid={insert a quote's id here}? It could be a permissions problem, try saving the permissions even if you don't need to change anything.

The moderation permission is called "Can Approve Quotes" and it's in with the regular usergroup permissions.

[Megareus Rex]

Ah, that solves things. Didn't realize that the permissions were in usergroups, lol.

The edit problem was that no edit link appeared, and it still doesn't, although I think that could be because I had my style guy edit the display to be how it used to be (back in 3.5 or whatever version), and he may have edited out the edit link by mistake. I'll post again if there's still a problem.

EDIT: We also have a problem with un-moderated quotes still showing up in the random quote box. Any ideas? It's not that big of a deal, but it kind of defeats the purpose (our use of the quotebox revolves completely around the random display, pretty much).

[Cap'n Steve]

Try setting "Show unapproved quotes to moderators" to no in the QuoteIt! Options. They should just be showing up for you because you're logged in.

[Megareus Rex]

Try setting "Show unapproved quotes to moderators" to no in the QuoteIt! Options. They should just be showing up for you because you're logged in.
I'll try that. And my style guy did indeed edit out the links for editing/deleting/etc, so that should be working soon.

Thanks for the help.

[Megareus Rex]

Ok, more problems (mostly surrounding random quote):

1: The delete shout button's pop-up box has no text, only ok/cancel buttons. Why?

2: The random quote box doesn't recognize line breaks. While on other views, multi-line quotes (such as two people talking) are correctly interpreted (seperate lines), in the random quote they all run together in one big line (only going to the next line when it reaches the end of the box).

Basically, this (in quote views besides the random quotebox):
guy 1: dshbnjhfh

guy 2: adrhethj

becomes this (in the random quotebox):
guy 1: dshbnjhfh guy 2: adrhethj

3: How would I go about putting a border around the quotebox? Specifically I want a way to seperate the quotes on the vieq quotes page, because there's no seperation at all how it is at the moment (one solid color background, no lines that divide the quotes). My coder is looking at it but he can't figure it out because apparently the coding is such a mess (no offense).

[Cap'n Steve]

1. Sounds like a phrase isn't getting output. Look in the source of the page (in your browser) and see what it says on the line containing "quotes_phrase_are_you_sure".

2. It sometimes does that. Try editing and resaving it.

3. Lol. "quoterow" is the class given to each quote. It also uses "alt1" and "alt2" for alternating rows.

[Megareus Rex]

Nope, the problem of quotes in the random box not reading line breaks remains, even after re-saving them. Any other ideas?

[Cap'n Steve]

Nope, right now I'm not sure what's causing it, sorry.

[Neutral Singh]

so 3.7 is finally coming!! is new quotes database too coming... :)

[Cap'n Steve]

Nope, sorry. I'm still too busy with other projects to really work on this. I'll add the fix to make sure it works with 3.7, though.

[Cap'n Steve]

A new version has been uploaded to make the AJAX compatible with vBulletin 3.7.

[SemperFideles]

A new version has been uploaded to make the AJAX compatible with vBulletin 3.7.

Thank you. Works great.

[Erika]

For the life of me I've tried installing the CMPS Module for a random quote and I've followed the steps 10 times and still I can't get it to appear on my homepage.

I've uploaded the modules (both sideblock and regular)
I've created a PHP File Module and entered the correct templates to use

I've uploaded the plugin as well, though there is no instruction to...

Anyone help please :)

I love this mod though - great work!

[Cap'n Steve]

Try this:

Admin CP => vBa CMPS => Default Settings => Main Options => Portal Output Global Variables
Go there, add 'quoteitoptions' (without the quotes) to that setting, and see if it helps.

If that doesn't work, have you enabled the random quote in the QuoteIt! Options? What version of of vBadvanced are you running? You could try posting a screenshot of the module's options, too.

[trackpads]

I am having the same problem, not showing for a new instal in 3.7. If you want to look let me know and I will send a login to you.

Thanks again for all the work!

-Jason

[Deyth]

I have it working just fine but the line breaks are really annoying. They vanish, I edit, they come back, they later vanish again.

[Cap'n Steve]

trackpads - What problem? The one with vBadvanced? Did you try the advice in the post above yours?

Deyth - I know, the BBCode and other formatting is pretty flakey. I don't know why, though. :(

[trackpads]

Sorry, I didnt quote the post. I am having the same VBCMPS issue regardless but I looked at it last night and the forumhome mode is really what I am going to use so np.

Thanks again for working on the hack Steve. I appreciate it!!!!!

-Jason

[Dr. Bantham]

I would like very much to have the capability of installing multiple QuoteIt! databases within the same domain. These would be wholly independent of one another, but still function within the same VB database. I assume this would entail different database prefixes and possible duplication and renaming of key QuoteIt! files to maintain correlation to the intended access. Is this a feasible effort or a manic pipe dream?

[Cap'n Steve]

I'm not quite sure what you mean. You want multiple QuoteIt! installations within the same MySQL database? Would they be accessed through the same quotes.php? What would the actual differences be between these databases from the user's perspective?

[gpc10347]

I hope I'm not duplicating a prior question so, apologies in advance: Is there a means by which one could insert something in the signature field to have these quotes randomly work for a couple of 'chosen' users? Thanks!

[Cap'n Steve]

You should be able to use the [quotes] and [randomquote] bbcodes in signatures, but you can't limit them to specific users.

[gpc10347]

You should be able to use the [quotes] and [randomquote] bbcodes in signatures, but you can't limit them to specific users.
Thanks Cap'n but I'm having a tard moment with this:

Allow Quote BB Code No is everywhere in the Signature Permissions visible on the user entry screen (UserCP). I've went through the permissions I can't seem to find/toggle the appropriate entry...

Could someone spell it out clearly enough that Stevie Wonder could see it? [randomquote] in a signature would translate into exactly what I'm looking for

Thanks for your assistance, patience and tolerance!

[Cap'n Steve]

Well, ordinarily the option to enable quote bbcodes is under "QuoteIt! Options", although now that I try it on my site, vBulletin 3.7 seems to have broken something with the bbcodes. :( Can you get [quotes] or [randomquote] working anywhere on your site?

[gpc10347]

Well, ordinarily the option to enable quote bbcodes is under "QuoteIt! Options", although now that I try it on my site, vBulletin 3.7 seems to have broken something with the bbcodes. :( Can you get [quotes] or [randomquote] working anywhere on your site?
Nope (although I admit I've not tried it extensively) - I did notice that attempting to edit the keys and values from BB Code Manager was interesting.

{R1211286651:0}
{R1211286652:0}

42
{Q1211286651:42}
{Q1211286652:42}

Neither seems to allow an Edit (as opposed to the creation of New) - The system states that "quotes" for instance, already exists. So, deleting them was a thought. At first glance, they appear to delete however, a subsequent shot at re-entry states that they're still there and in fact, they mysteriously pop back in ...

(This is under Custom BB Codes)


Yours work in the FAQ display? (Mine does but I'm too new to find how it's called)



**** UPDATE: I uninstalled and found that my editing capability with BB Code is back. Could there be a header issue? I'd love to get this one working on 3.7

[Cap'n Steve]

The entries in the bbcode manager are just for show, the actual bbcodes are controlled with plugins. You're right about the FAQ; for some reason that's the only place the bbcode seems to work, which is very strange. I'll have to investigate more as soon as I get some free time.

[gpc10347]

The entries in the bbcode manager are just for show, the actual bbcodes are controlled with plugins. You're right about the FAQ; for some reason that's the only place the bbcode seems to work, which is very strange. I'll have to investigate more as soon as I get some free time.


Good luck with the free time! Let me know if you get excess as I need some too..
Thanks

[Dr. Bantham]

I'm not quite sure what you mean. You want multiple QuoteIt! installations within the same MySQL database?Yes.
Would they be accessed through the same quotes.php?Not necessarily. If the table references necessitated a duplication and renaming of functional files, then that would be acceptable.
What would the actual differences be between these databases from the user's perspective?My site is dedicated to an author. I have even customized the standard QuoteIt! entries to accommodate MP3 readings and forum thread references. The random quotation block is limited to these quotes. I would like the ability to have a separate quote database of alternate source material, with the access controlled by my own menu and labeling efforts. I have ruled out separating the material within a single database by the author field alone. I want the initial database purely dedicated to a single author. Possible?

[gpc10347]

The entries in the bbcode manager are just for show, the actual bbcodes are controlled with plugins. You're right about the FAQ; for some reason that's the only place the bbcode seems to work, which is very strange. I'll have to investigate more as soon as I get some free time.


Is it my imagination or is it working like a charm on 3.7 at MonkeyCrap.com?
(I'm lurking awaiting the say I can paste something into a signature and have a random quote pulled up..._

[Cap'n Steve]

gpc10347 - Where are you seeing it work on my site? I still can't get it to work, so maybe it is your imagination. ;)



Dr. Bantham -

First of all, have you tried the categories? That might be able to do what you want. If not:

WARNING: None of this has been tested, so don't try it on your live website.

I guess the simplest way to do this would be to to copy and rename quotes.php, admincp/quoteadmin.php, modcp/quotemod.php, and includes/functions_quoteit.php. Edit the new files and replace all mentions of any of those file names with the names you gave to the new copies.

Next, duplicate all the QuoteIt! database tables (quotes, quoteratings, guestquoteratings, and quotecategories) and rename them. Edit the files you created in the previous step and replace all references to the old tables with references to the renamed ones.

Your new quotes database would share settings, templates, and permissions with the "real" installation, and quotes in the new database won't be available for things like the bbcodes, but it should basically work.

[gpc10347]

gpc10347 - Where are you seeing it work on my site? I still can't get it to work, so maybe it is your imagination. ;)


Our father, which programmeth in vBulletin, helpeth out our brother Cap'n Steve and provideth him with time. Time to walk on water, time to part the sea, and perhaps even time to make QuoteIt work with 3.7.1. Lead me not into Michigan, for I art in Ohio and the SEC calleth me out in temptation of Big 10 issues... Let not his heart be troubled... perhaps even let the Wolverines score a few times this year despite them laughing at us during bowl games.

[Cap'n Steve]

Lol!

Are you still able to use the quote bbcodes on my site, though? Where at exactly?

[Dr. Bantham]

Well, ordinarily the option to enable quote bbcodes is under "QuoteIt! Options", although now that I try it on my site, vBulletin 3.7 seems to have broken something with the bbcodes. :( Can you get [quotes] or [randomquote] working anywhere on your site?I am running QuoteIt on vBulletin 3.7 with not evident issues. QUOTE and RANDOMQUOTE bbCode references seem to be working well. I have not, however, upgraded QuoteIt to the release of 5/1/08. I am running the version just prior to this.

[gpc10347]

Lol!

Are you still able to use the quote bbcodes on my site, though? Where at exactly?

I apparently lied - maybe I was drunk, however, I'm 17 pages into the thread again. Reinstalled again and again and mysteriously, I did get the bbcodes working in the threads (would love to turn on for signatures as well but can't seem to get that far..)

Dr. Bantham: Can you make [quotes] or work in signatures? Also, do you open and close the tag with any characters required between them ( [randomquote]stuff )


*** No luck whatsoever with vbAdvanced CMPS regardless of what I do in it's admin area. I sure could use a hint or two more on this one....


Thanks for the hints here and there though - As of this morning, I have a forumhome template displaying a random quote, bbcodes work (sort of) inside thread messages. I can add, edit and delete quotes
(all together now) However ; )

I've found that a prior mod (the one used here at The Org) is interfering in the style selection: The White Quote symbol is coming from another hack and refers to .quote for it's style: See attached image please...

/* ***** open and close quotes images ***** */
.quote {
margin:15px 10px;
background: url(blak_ice/misc/q.gif) 0 0 no-repeat;
padding-left:25px}
blockquote.bq {
background: url(blak_ice/misc/q1.gif) no-repeat bottom right;
font: italic 10pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;
border-left:3px solid #ccc;
margin:0px;
padding:0 5px}


Would there be a chance that the use of the word quote might be causing all the grief? (And what's a good remedy without giving up either?)

Whew... It must be 5 somewhere..

[gpc10347]

I know I know. Now, I'm talking to myself - however, all gowds chillun talk to themselves - them self... whatever.

I have the Bbcodes working. A little wierd with the oddball characters needed but I can deal with it. Still hoping for a means to place it in the signature... Anyone?

I also have random quote capabilities with vBad Vanced but turning it on, moves the calendar and essentially destroys the page layout. (Most like a TD isn't ended properly or a missing table tag...)

Looks fantastic on the forum pages though.. (whew)

What's the best file to begin editing to get the CMPS addition to behave in the center column?

[Cap'n Steve]

The newest QuoteIt! version shouldn't make any difference, especially since the only changes were in quotes.php, which isn't even used for the bbcode.

I don't know how the bbcodes broke before, but if you've got them working in posts now, they should also work in signatures. Even if they don't work fully, there should be at least some output in the form of {R:$bunchofnumbers}. So is there anything happening with bbcode in signatures or do the tags just vanish?

The other mod might make things ugly (like with the two images shown in the screenshot), but they'd still work. To fix it, just rename .quote to something else in either mod and replace all of that mod's references to the quote class (look for class="quote in the templates) with references to the new name you gave it.

vBadvanced quotes just use the quote_randomquote template along with the additional CSS in clientscript/vbulletin_css/quoteit_vbadvanced.css.

Finally, what do you mean by "oddball characters"?

[gpc10347]

The newest QuoteIt! version shouldn't make any difference, especially since the only changes were in quotes.php, which isn't even used for the bbcode.

I don't know how the bbcodes broke before, but if you've got them working in posts now, they should also work in signatures. Even if they don't work fully, there should be at least some output in the form of {R:$bunchofnumbers}. So is there anything happening with bbcode in signatures or do the tags just vanish?

The other mod might make things ugly (like with the two images shown in the screenshot), but they'd still work. To fix it, just rename .quote to something else in either mod and replace all of that mod's references to the quote class (look for class="quote in the templates) with references to the new name you gave it.

vBadvanced quotes just use the quote_randomquote template along with the additional CSS in clientscript/vbulletin_css/quoteit_vbadvanced.css.

Finally, what do you mean by "oddball characters"?


Got it.

The oddball characters are specifically the Magic Stuff between the randomquote tags that makes it work.

Previewing my signature might be what prevented me from seeing it. The { } encased numbers are what I see previewed but if I save and view a post - it's there!

Still having issues with it breaking the tables on vbAdvanced but - I'm 95% where I hoped I'd be...

Thanks much!

[Cap'n Steve]

The oddball characters are specifically the Magic Stuff between the randomquote tags that makes it work.

I'm almost afraid to ask, but what exactly did you put between the tags? That shouldn't affect anything.

Previewing my signature might be what prevented me from seeing it. The { } encased numbers are what I see previewed but if I save and view a post - it's there!

There must be a hook for previewing signatures that I missed. If you're feeling adventurous, you could look at the other "Finalize BBCode" plugins and try to copy that code to a plugin at whatever hook is called when previewing.

Still having issues with it breaking the tables on vbAdvanced but - I'm 95% where I hoped I'd be...

I don't think it's a missing end tag, but running it through http://validator.w3.org/ might help you pinpoint the problem.

[gpc10347]

I'm almost afraid to ask.

As well you should be. Actually, anything I place between the open and close randomquote - even just a space -allows it to function. So I'm good here...


There must be a hook for previewing signatures that I missed. If you're feeling adventurous, you could look at the other "Finalize BBCode" plugins and try to copy that code to a plugin at whatever hook is called when previewing.

That's next.

I don't think it's a missing end tag, but running it through http://validator.w3.org/ might help you pinpoint the problem.

Oh thanks for that. I need constant reminders of how poor the rest of my pages are!

Here's an off the wall issue that might be related. Viewing source from an interior page that works shows this:
<script type="text/javascript">

and it may be a co-incidence but the bad page (from CMPS) shows this view source:
<script type=\"text/javascript\">

Escaped quotes mean anything to you?

UPDATE: Commented out line 809 in functions_quoteit.php and it's officially working on my front page in vBavanced.

$tempinclude = str_replace('"', '\"', $tempinclude);

I'll shut up for a little while!

[Cap'n Steve]

Well, that information is a little disturbing, but will probably be very helpful when I get around to writing the next version. I don't know what was changed in the bbcode or in vBadvanced, but thanks for giving me some clues.

[cillianok]

Is there any *easy* way to make it smaller, height-wise?

[Cap'n Steve]

I don't know what you consider easy, but you can edit the padding in clientscript/vbulletin_css/quoteit_main.css or remove the information you don't need displayed in the quote_listbit template.

[Dr. Bantham]

A new version has been uploaded to make the AJAX compatible with vBulletin 3.7.Can you tell us what files/templates have changed in this most recent release? I have made a number of custom modifications and I would rather integrate new revisions as opposed to trying to replicate all my past work again. This would be a great help!

[gpc10347]

Can you tell us what files/templates have changed in this most recent release? I have made a number of custom modifications and I would rather integrate new revisions as opposed to trying to replicate all my past work again. This would be a great help!

(Warning: Off Topic)

Dr. Bantham.. Apologies for the interruption however, your site has got o be one of the best examples of vBulletin going. Seriously. Intriguing to the point of engaging - it's an extraordinary showpiece that I've recommended to others...

(Please continue)

[Dr. Bantham]

(Warning: Off Topic)

Dr. Bantham.. Apologies for the interruption however, your site has got o be one of the best examples of vBulletin going. Seriously. Intriguing to the point of engaging - it's an extraordinary showpiece that I've recommended to others...

(Please continue)Wow! I am truly grateful for the generous praise. I have put a lot of work into the content and general aesthetics of my site, but I must give much credit to the wealth of resources within this site. I am especially proud of many of the custom styles I have developed, many of which graphically mimic certain book layouts or story concepts published by the author the site is dedicated to. As with many vBulletin efforts, the focal group of mine is admittedly small. It has been a great boon to gathering fans, introducing new readers and discussing similar interests. Again, many thanks for the kind words!

[Cap'n Steve]

The latest version is just a two line workaround in quotes.php, as shown in this post.

[dimples]

I love the mod and everything seems to be working great so far. I have one question though and I apologize if this has been asked earlier. Is there a way we can take out the two quote gifs that default around the quote in the random quote box. They never seem to line up right and I would rather just eliminate them if I could.

Thank you much!

[Cap'n Steve]

Just remove these sections from the quote_listbit template:

<img src="{$stylevar['imgdir_misc']}/quotation-open.png" alt="“" width="60px" height="51px" class="quoteimage openquote" />
<span width="60px" height="51px" class="openquote ieimage">&nbsp;</span>

<span width="60px" height="51px" class="closequote ieimage">&nbsp;</span>
<if condition="!$sidebar">
<img src="{$stylevar['imgdir_misc']}/quotation-close.png" alt="”" width="60px" height="51px" class="quoteimage closequote" />
</if>

[eyeoftiger]

I downloaded and installed from this link -
https://vborg.vbsupport.ru/showthread.php?t=135297&highlight=private+message

http://sportsunit.com/forum <- Please check here, it's my forum.

it's giving me error messages all of a sudden.

I can't even go into admin panel .

Also I can not go into threads or posts.

I have over 1000 members logging to my forum, i need this fixed asap.

Please help me .

[Cap'n Steve]

Disable the plugin system as shown in this post. Then uninstall the product, re-enable the plugin system, reupload the QuoteIt! files and reinstall it.

[forumrunt]

will this work with 3.7

[Cap'n Steve]

Yes, it works on vBulletin 3.7.x.

[DBs]

Hi Cap'n Steve,

Got a little problem with my QuoteIt installation. Ever since a version back (not sure exactly) I now find that I cannot save certain options in the control panel like moderate quotes. If I select yes then hit save it goes thru the motion but upon the refresh shows it still as off.

Can you advise on where these options are stored in the database so I can go hunt for them or failing that tell me how to get the datastore setting rebuilt.

I have uninstalled the product, reinstalled and tried again with a fresh install. Same problem.

Any help much appreciated.

[Cap'n Steve]

Try running this query (replace $TP with your table prefix):
DELETE FROM $TPdatastore
WHERE title = "quote_settings"

Then go to your language manager and run "Rebuild All Languages". Finally, reupload all of the QuoteIt! files and then try to save settings again.

[DBs]

Try running this query (replace $TP with your table prefix):
DELETE FROM $TPdatastore
WHERE title = "quote_settings"

Then go to your language manager and run "Rebuild All Languages". Finally, reupload all of the QuoteIt! files and then try to save settings again.

Hi,

Tried all that and didn' work (even reimported the product with overwrite). I downloaded the zip in this thread and the quoteadmin.php is dated back in 2007, is this correct?

Now, the settings look correct when I look at the datastore thru a mysql tool but only some of the settings are being reflected in the control panel. Very strange.

Any other ideas?

[thepub]

*sigh* I tried to install this yet again and this time there is nothing showing at all. I checked my settings and followed the instructions so why would nothing at all show?

[Cap'n Steve]

thepub - Do you have any quotes in the database? If not, try going to quotes.php?do=addquote and adding one. The only thing that I can think of is somehow you got a partial install, so try reinstalling.

DBs - Yes, quoteadmin.php hasn't been changed in a while.

Do you have any sort of caching enabled (APC or something similar)? Any other mods installed?

I really have no idea what would cause this, but try posting a screenshot of the options page along with what's actually in the datastore under quote_settings and I'll take a look at it.

[DBs]

Cap'n Steve,

Yes I use XCache. As a test I disabled XCache and the options are working correctly so I guess that there is an issue between XCache and QuoteIT ?

Let me know if you need me to test anything in an effort to solve this. Appreciate any help.

[thepub]

thepub - Do you have any quotes in the database? If not, try going to quotes.php?do=addquote and adding one. The only thing that I can think of is somehow you got a partial install, so try reinstalling.

DBs - Yes, quoteadmin.php hasn't been changed in a while.

Do you have any sort of caching enabled (APC or something similar)? Any other mods installed?

I really have no idea what would cause this, but try posting a screenshot of the options page along with what's actually in the datastore under quote_settings and I'll take a look at it.

there isn't even a quoter showing is what I am saying. If I followed the instructions and only got a partial install then I have no idea how that is possible.

[Cap'n Steve]

DBs - I'm not sure why that would cause problems. I don't know anything about how vBulletin handles caching systems, but I'll put it on the list of things to look at. In the meantime, I guess you'll just have to disable it, which hopefully won't slow things down too much.

thepub - Try approving some of the quotes on your site.

[thepub]

I get a message saying I do not have permission to perform that action.

[Cap'n Steve]

Where were you trying to approve from? The moderate quotes section in your admincp? Make sure your permissions are set properly, then rebuild bitfields (admincp/index.php?do=buildbitfields).

[Dr. Bantham]

I have installed vBExperience (https://vborg.vbsupport.ru/showthread.php?threadid=171014) and would like very much to create a custom points count and award based on the quote count from QuoteIt!. Can anyone help with this? I am looking into the method as outlined, but if someone has performed this already it would save me time. If I end up creating this myself, I will be sure to share!

[Dr. Bantham]

I have installed vBExperience (https://vborg.vbsupport.ru/showthread.php?threadid=171014) and would like very much to create a custom points count and award based on the quote count from QuoteIt!. Can anyone help with this? I am looking into the method as outlined, but if someone has performed this already it would save me time. If I end up creating this myself, I will be sure to share!It seems that I managed to pull this one off myself. I am attaching the final file to share with anyone interested. Let me know if there are any issues encountered. It seems to be working for me flawlessly.

[Cooleyvol]

I have a custom template I've bought. This doesnt show up on forumhome upon implementation.

It shows on the default vb template.

Any help is appreciated.

Using 3.71, so this might not even work with 3.7

[Cooleyvol]

Ok, tell me how to fix the delete function please. I go to the list, select the one I want to delete and click delete.

The pop up box comes up saying its been deleted, but its still there.

[Cap'n Steve]

Cooleyvol - Did you add $showrandomquote to the customized template? Post a few lines from around that point, if you can. As for the deleting, do you have soft delete enabled? If you do, they'll still be visible to you, but they'll go back in the moderation queue. If not, try opening the delete link in a new tab or window.

Dr. Bantham - Looks cool, good work.

[Kaycee123]

It seems that I managed to pull this one off myself. I am attaching the final file to share with anyone interested. Let me know if there are any issues encountered. It seems to be working for me flawlessly.


Thanks! I like this idea - I've added your product, seems to be fine so far:)

[Cooleyvol]

Cooleyvol - Did you add $showrandomquote to the customized template? Post a few lines from around that point, if you can. As for the deleting, do you have soft delete enabled? If you do, they'll still be visible to you, but they'll go back in the moderation queue. If not, try opening the delete link in a new tab or window.

Dr. Bantham - Looks cool, good work.


Thanks dude. I got that worked out.

With moderation mode 'on', new quotes are still showing on the website immediately even though they're in the moderation panel to be approved.

How can I make them so that they don't appear until they are approved?

[Cap'n Steve]

Is "show unapproved quotes to moderators?" on in the QuoteIt! options? Turn it off if it is.

[Cooleyvol]

Is "show unapproved quotes to moderators?" on in the QuoteIt! options? Turn it off if it is.

Turned it off.

Are you saying that only the mods were seeing the unapproved quotes on the boards?

[Cap'n Steve]

Only people who have permission to approve quotes should be able to see unapproved ones. Try logging out and seeing if you can still see them.

[savingsangel]

Been using this for a while - love this mod! Updated to 3.7.2 + templates and reinstalled latest quoteit. I've always had the quoteit mod display at the bottom of my home page (not under nav bar).

Everything is fine - except my close quote image is where it would be if my quoteit were under the navbar. It's just kind of floating behind stuff! The open quote is where it would be normally. Is this something I can adjust in the css file?

[Cap'n Steve]

Yes, it's in clientscript/vbulletin_css/quoteit_main.css under the .closequote class. It's a pain to get it looking good in all browsers, so if your visitors use a wide variety of browsers, you might want to just remove it completely.

[expatdirectory]

Does anyone know where I can hold of a VBadvanced module intergration for this mod. I love the mod and have used it for a long time on one of my forums but I would like to move it over to a side column etc.

Any help is appriciated.

[Cap'n Steve]

Did you try the module included in the extras directory?

[KevinL]

For some reason I could not get this to install on 3.7.2 without a bunch of errors.

[expatdirectory]

Did you try the module included in the extras directory?

I tried the add on but I just get a space where the module should be. I will try again from scratch and see if there is something obvious that I am overlooking (it wouldn't be the first time :D )

[Cap'n Steve]

KevinL - What errors?

expatdirectory - Try experimenting with the module settings when you add it. vBadvanced may have added some new options since the last time it was updated.

[KevinL]

KevinL - What errors?


When I check 'show random quote' I get these errors:

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 31

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 32

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 33

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 34

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 35

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 36

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 37

Any ideas? I did do a search but came up with nothing...

Thank you

EDIT** now I'm also getting this

Warning: Cannot modify header information - headers already sent by (output started at [path]/includes/class_core.php:3243) in [path]/includes/functions_quoteit.php on line 1198

[Dr. Bantham]

I would love for this mod to have a feature to auto-create a thread as new quotes are entered. I have managed to create new fields for this mod and could create another for thread title. My site has quotations constantly appearing within the forums for discussion. I end up replicating quotations myself within QuoteIt! and editing their post to include the reference. I would think that this feature would not be too complicated, but it is beyond my current ability. I would be satisfied if the forum was fixed as a option variable, but having forum selection within a dropdown list would be even better. The thread content would consist only of [quotes]quotenumber. If you do not have time to dedicate to this, Cap'n Steve, then any suggestions with the approach would be greatly appreciated. I think that tying QuoteIt! to the forums in such a manner would be the ideal feature for promoting additional installations and forum discussion of the quotes themselves.

[KevinL]

When I check 'show random quote' I get these errors:

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 31

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 32

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 33

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 34

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 35

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 36

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 37

Any ideas? I did do a search but came up with nothing...

Thank you

EDIT** now I'm also getting this

Warning: Cannot modify header information - headers already sent by (output started at [path]/includes/class_core.php:3243) in [path]/includes/functions_quoteit.php on line 1198

Hmm I'm glad that this was bumped :)

Has anyone ever seen this?

[Cap'n Steve]

KevinL - Try removing this chunk of code from includes/functions_quoteit.php (also, post a list of the other mods you have installed):

$settings[1] =& $quoteitoptions['ratings'];
$settings[3] =& $quoteitoptions['moderatequotes'];
$settings[0] =& $quoteitoptions['showrandomquote'];
$settings[4] =& $quoteitoptions['numbertomoderate'];
$settings[2] =& $quoteitoptions['averagethreshold'];
$settings[7] =& $quoteitoptions['totalthreshold'];
$settings[5] =& $quoteitoptions['enablecontext'];

Dr. Bantham - I've never used the post datamanager, so I'm not sure how to do it off the top of my head, but you'll want to add it at the end of the add_quote function in includes/functions_quoteit.php.

[KevinL]

KevinL - Try removing this chunk of code from includes/functions_quoteit.php (also, post a list of the other mods you have installed):

$settings[1] =& $quoteitoptions['ratings'];
$settings[3] =& $quoteitoptions['moderatequotes'];
$settings[0] =& $quoteitoptions['showrandomquote'];
$settings[4] =& $quoteitoptions['numbertomoderate'];
$settings[2] =& $quoteitoptions['averagethreshold'];
$settings[7] =& $quoteitoptions['totalthreshold'];
$settings[5] =& $quoteitoptions['enablecontext'];


This works wonders!

Got it up and running. Now I had this on my site since the first version. I did a dump of the old database (before we had to close for a bit) and want to add them back in. Now when I tried to do that I started getting these errors:

Database error in vBulletin 3.7.2:

Invalid SQL:

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

LIMIT 17, 1;

MySQL Error : Unknown column 'quotes.categoryid' in 'on clause'
Error Number : 1054
Request Date : Saturday, August 2nd 2008 @ 07:12:28 AM
Error Date : Saturday, August 2nd 2008 @ 07:12:28 AM


I understand what it's saying but what I don't understand is why inserting them back into the database is giving me this error (since this is actually the 2nd time doing it like this). Also what is the table 'on clause'?

Thanks for your help!

[Cap'n Steve]

You don't have the categoryid column in your quotes table somehow. I'm guessing your database dump dropped the tables and then recreated them. Try re-importing the product (without uninstalling it). After that, you'll have to edit the dump file and remove all the DROP TABLE and CREATE TABLE statements before you can safely import it.

[KevinL]

Worked wonders!!

Thank you

[gpc10347]

Mod still working wonders and looks great!

I need something that is probably right under my nose but - here goes:

I have a style specifically for cell phones and disable as much as I can..

To date, I have the following:

//Disables Cyb Chatbox
$vbulletin->options['cybchatbox_enable_product']=0;
//Disables MGC Chatbox
$vbulletin->options['mgc_cb_evo_active']=0;
//Disable Moods?
$vbulletin->options['vmoods_active']=0;
What would the proper string be to disable QuoteIt for this situation only?

Thanks in advance!!

[Cap'n Steve]

Do you mean just the random quote? For that, try this (although it needs to execute after QuoteIt!'s "Initialize Global Options/Permissions" plugin):

$quoteitoptions['showrandomquote'] = false;

[thepub]

Hey Cap'n Steve! Thanks for the help with my forum. I am having a few small problems though. The submit quote button is not showing despite me performing the template edits and uploading the image. Also the quotation images are not showing up properly, one is at the top of my forum on the far right of the screen (by the log in and unread posts) and the other one on the left is at the top of the quote on the left side. How can I adjust this? The actual size of my quoter is perfect though. Also, the bb code images are not showing in the quotes (smileys etc...) despite being enabled in the admin cp.

[gpc10347]

Do you mean just the random quote? For that, try this (although it needs to execute after QuoteIt!'s "Initialize Global Options/Permissions" plugin):

$quoteitoptions['showrandomquote'] = false;

As always - Thanks for the response!

Welp - it forced me to read a little deeper -
"This may only work with some products which include options to disable/enable them which are not initiated before the style_fetch hook is called. You need to be able to read a products XML file to check for such an option."

I bet there isn't an on/off for the whole plug-in is there?
(I making that assumption as there's no master Enable QuoteIt! that I see in the Admin CP)

No biggie but if you happen to think of anything, I'll take it!

UPDATE: This appears to be doing what I need. It just still appears in the CMPS page which is likely a different issue (I commented out the entirety of quote_randomquote and voila, it works...)

[Cap'n Steve]

thepub - It looks like a search and replace went wrong. In your modification of the postbit template, you've got $stylevar['canaddquotes'], which doesn't exist. It should be $quoteitpermissions['canaddquotes']. I don't see any problems with the quotation mark images, what bowser are you using? If you want to edit their placement, it's controlled by the .openquote and .closequote classes in clientscript/vbulletin_css/quoteit_main.css. As for the smilies, try saving the options again and try editing and saving the quote. The bbcode and smilie parsing has always been a little sketchy, sorry.

gpc10347 - I'm not sure what you mean. Using the code I gave you should disable the vBadvanced module as well, as long as it runs after $quoteitoptions is defined (in the plugin I mentioned), but before the module is loaded. But if you've got it working then don't worry about it, I guess.

[Forgott3n]

Hi we're using vB 3.7.2 and it will not sort the top quotes:

http://www.avrilbandaids.com/forums/quotes.php?page=1&perpage=10&sortby=rating&order=desc

What's going on?

[Gio Takahashi]

I can confirm this on 3.7.0, sorting does not seem to work at all.

also, deleting does not work at all, but if I delete it through moderation option, it just puts it in moderation, rather than deleting it.

[Cap'n Steve]

Gio Takahashi - Set "Soft Delete Quotes" to no in the QuoteIt! Options.

I'm not sure how the sorting ended up broken, but try this and see if it helps. In includes/functions_quoteit.php, find this:
WHERE quotes.quoteid IN (' . $prefetched . ')
');

and replace it with this:
WHERE quotes.quoteid IN (' . $prefetched . ')
ORDER BY ' . $quotedisplay['order']
);

[Neutral Singh]

Is there anybody who has got this working on 3.7.x? if yes please oblige us by uploading a zipped file with full instructions to install... Cap'n, can't you release a updated version working in 3.7.x.

[Cap'n Steve]

I've been running it on 3.7 for a while now. What problem are you having?

[glowinggal]

I can confirm this on 3.7.0, sorting does not seem to work at all.

also, deleting does not work at all, but if I delete it through moderation option, it just puts it in moderation, rather than deleting it.


ditto on this - we get people posting "spam" quotes and we can't get them out of there uness i actually do it directly from the database itself via phpmyadmin

[Cap'n Steve]

Do you have "soft delete quotes" on? If so, deleting them sends them back to the moderation queue, where you can delete them permanently.

[Neutral Singh]

I've been running it on 3.7 for a while now. What problem are you having?

1. I am getting the following error at http://www.sikhism.us/quotes.php



Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 31

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 32

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 33

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 34

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 35

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 36

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 37

Warning: Cannot modify header information - headers already sent by (output started at [path]/includes/class_core.php:3239) in [path]/includes/functions_quoteit.php on line 1198

2. The random quote shows like the attachement which is quite untidy.


Please advice how to get it right. Thanks

[L2V]

Is there a way to disable this in certain templates? I am using a mobile template (https://vborg.vbsupport.ru/showthread.php?t=174375) under 3.7.3 and the javascript loads on every page. Quotes isn't visible from this mobile template and I'd love to reduce the overall page size by turning off the script includes for this... Any idea how?

[Cap'n Steve]

Neutral Singh - Try the instructions in this post.

L2V - I'm sure you could use a conditional to check the styleid, but I'm not sure off the top of my head what variable it's stored in.

[L2V]

L2V - I'm sure you could use a conditional to check the styleid, but I'm not sure off the top of my head what variable it's stored in.

Thanks. Do you know what part would have the conditional? Does that go in the plugin itself? Or a template?

[Neutral Singh]

Neutral Singh - Try the instructions in this post.


Alright that made the first problem vanish. What about the second. I have kept it live on my forum for your analysis.

Please advice. Thanks

[Cap'n Steve]

L2V - Actually, try adding it to the conditional on line 768 in includes/functions_quoteit.php. The updated code should look something like this. Replace $styleid with whatever variable holds the current styleid (just search around this site to find the right one) and $yourstyle with whatever the styleid of your mobile style is.

if (!defined('THIS_IS_A_QUOTE') AND $styleid != $yourstyle) {

Neutral Singh - That is strange. Try removing this line from includes/functions_quoteit.php.

$tempinclude = str_replace('"', '\"', $tempinclude);

[L2V]

L2V - Actually, try adding it to the conditional on line 768 in includes/functions_quoteit.php. The updated code should look something like this. Replace $styleid with whatever variable holds the current styleid (just search around this site to find the right one) and $yourstyle with whatever the styleid of your mobile style is.

if (!defined('THIS_IS_A_QUOTE') AND $styleid != $yourstyle) {

Brilliant! That worked perfectly.
For anyone else who needs it... The following line number mentioned above can be
if (!defined('THIS_IS_A_QUOTE') AND $vbulletin->userinfo['styleid'] != xx) {
change the xx to the style id number that you don't want the info to show up in.

Thanks Cap'n Steve!

[Forgott3n]

Sorry to bother again Cap'n Steve, but do you have an idea what could be going on? We're running 3.7.3 PL1

Hi we're using vB 3.7.2 and it will not sort the top quotes:

http://www.avrilbandaids.com/forums/quotes.php?page=1&perpage=10&sortby=rating&order=desc

What's going on?

[Cap'n Steve]

Try the advice from this post.

[Forgott3n]

Try the advice from this post.

That seems to have fixed it, thank you!

[EDIT] I've seem to be getting a lot of errors since I've made the fix:

Database error in vBulletin 3.7.3:

Invalid SQL:

INSERT INTO guestquoteratings
(ip, quoteid, date, rating) VALUES
("208.101.13.14", 21, 1223328061, 4);

MySQL Error : Duplicate entry '21-208.101.13.14' for key 1
Error Number : 1062
Request Date : Monday, October 6th 2008 @ 05:21:01 PM
Error Date : Monday, October 6th 2008 @ 05:21:09 PM
Script : http://www.avrilbandaids.com/forums/quotes.php?do=rate&quoteid=21&vote=4
Referrer : http://www.avrilbandaids.com/forums/quotes.php?page=1&perpage=10&sortby=rating&order=desc
IP Address : 208.101.13.14
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :

[Forgott3n]

Ok a moderator informed me that, after deleted a spam quote entry, he was redirected do this empty quote:

http://www.avrilbandaids.com/forums/quotes.php?do=view&quoteid=874

Once he tried to delete it, he got this database error:

Database error in vBulletin 3.7.3:

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 : Sunday, October 12th 2008 @ 01:16:46 AM
Error Date : Sunday, October 12th 2008 @ 01:16:46 AM
Script : http://www.avrilbandaids.com/forums/quotes.php
Referrer : http://www.avrilbandaids.com/forums/quotes.php?page=&do=delquote&quoteid=
IP Address : 24.87.85.233
Username : Forgott3n
Classname : vB_Database_MySQLi
MySQL Version : 5.0.51a-community

[Cap'n Steve]

That's really strange. Try going to this page (http://www.avrilbandaids.com/forums/quotes.php?do=del&quoteid=874) (while logged in as a moderator or administrator).

[Forgott3n]

That's really strange. Try going to this page (http://www.avrilbandaids.com/forums/quotes.php?do=del&quoteid=874) (while logged in as a moderator or administrator).

Once I navigate there, it brings me to the "quotes.php?" page. Also, I tried putting in a bogus quote id:

http://www.avrilbandaids.com/forums/quotes.php?do=view&quoteid=999999

seems to give the blank one. Perhaps its the default null result?

[Cap'n Steve]

Yes, the blank page is what happens if it gets sent an invalid id. I don't know what happened originally, but as long as it's not showing up when you list quotes, I guess it's safely deleted.

[ArnyVee]

I'm going to start to search for the answer through the 44 pages of info, but is there a way to simply have the quotes appear as an added 'touch' to the site rather than having the ratings and self-submission piece of the mod?

My site is Disney related and I'll have mainly quotes from Walt Disney that I already have typed up. So, I'll be preloading them into the system and just have them display. Is that possible?

[Cap'n Steve]

Yes, you can disable the ratings system in the options and set up the usergroup permissions so that only you have permission to add quotes.

[ArnyVee]

Thanks for the quick response Cap'n Steve! :D

I'll look into adding this tonight or tomorrow to my site.

[Forgott3n]

It appears we have another bug, it may have been from the sql edit we made.

For some reason, the AdminCP option of Moderate Quotes remains No, no matter how many times we set it to Yes. Once we set it to Yes and hit Save, it refreshes back to No.

Also, we're now running vBulletin 3.7.3 PL1 so that could also be a factor.

Thanks for the help!

[Cap'n Steve]

Run this query and tell me what the output is (replace $TP with your table prefix):

SELECT * FROM $TPdatastore
WHERE title = "quote_settings"

[shane greer]

As soon as I installed it I got this.

Now my whole forum is down. HELP!!

Warning: require_once([path]/includes/functions_quoteit.php) [function.require-once]: failed to open stream: No such file or directory in [path]\includes\class_bbcode.php(2428) : eval()'d code on line 3

Fatal error: require_once() [function.require]: Failed opening required 'C:\Inetpub\vhosts\thefewgoodmen.ieasysite.com\htt pdocs\forum/includes/functions_quoteit.php' (include_path='.;./includes;./pear') in C:\Inetpub\vhosts\thefewgoodmen.ieasysite.com\http docs\forum\includes\class_bbco de.php(2428) : eval()'d code on line 3

[shane greer]

Any help appreciated guys. I cant even get into my admin now as it states..

Warning: Invalid argument supplied for foreach() in [path]includes\functions.php on line 3951

[Forgott3n]

Run this query and tell me what the output is (replace $TP with your table prefix):

SELECT * FROM $TPdatastore
WHERE title = "quote_settings"

quote_settings a:26:{s:15:"showrandomquote";i:1;s:7:"ratings";i:2;s:16:"averagethreshold";s:0:"";s:14:"totalthreshold";s:0:"";s:14:"showquotecount";i:1;s:12:"enablebbcode";i:0;s:14:"showquotestats";i:1;s:7:"version";s:4:"3.12";s:12:"freshinstall";i:0;s:12:"usemegaquery";i:0;s:20:"randomquotefrequency";s:5:"every";s:11:"cachebbcode";i:0;s:14:"randomcategory";i:0;s:13:"enablecontext";i:0;s:13:"languagecount";s:1:"1";s:12:"reportquotes";i:0;s:14:"moderatequotes";i:1;s:16:"numbertomoderate";i:10;s:17:"enableguestvoting";i:0;s:13:"requireauthor";i:0;s:10:"softdelete";i:0;s:16:"enablecategories";i:0;s:13:"continuousids";i:0;s:14:"showunapproved";i:0;s:12:"saveascookie";i:0;s:12:"reportemails";s:0:"";} 0

[shane greer]

Upload everything in the upload directory to your forum directory.

Go to your administrator control panel and select "Plugin System", then "Manage Products", then "Add/Import Product". Follow the instructions to import product-quoteit.xml. If you have a previous version of QuoteIt! installed, be sure to set "Allow Overwrite" to yes.

It was at this point when everything crashed. :(

I will run a query like you asked.

[shane greer]

Im completely new to this. what exactly am I to type in.... what is the code below?

Do I type in SELECT * FROM $TPdatastore
WHERE title = "quote_settings"

And replace $TP with my database name?

quote_settings a:26:{s:15:"showrandomquote";i:1;s:7:"ratings";i:2;s:16:"averagethreshold";s:0:"";s:14:"totalthreshold";s:0:"";s:14:"showquotecount";i:1;s:12:"enablebbcode";i:0;s:14:"showquotestats";i:1;s:7:"version";s:4:"3.12";s:12:"freshinstall";i:0;s:12:"usemegaquery";i:0;s:20:"randomquotefrequency";s:5:"every";s:11:"cachebbcode";i:0;s:14:"randomcategory";i:0;s:13:"enablecontext";i:0;s:13:"languagecount";s:1:"1";s:12:"reportquotes";i:0;s:14:"moderatequotes";i:1;s:16:"numbertomoderate";i:10;s:17:"enableguestvoting";i:0;s:13:"requireauthor";i:0;s:10:"softdelete";i:0;s:16:"enablecategories";i:0;s:13:"continuousids";i:0;s:14:"showunapproved";i:0;s:12:"saveascookie";i:0;s:12:"reportemails";s:0:"";} 0

[shane greer]

Ok I deleted the files via FTP and reuploaded them.

Im getting this error...

Warning: Invalid argument supplied for foreach() in [path]includes\functions.php on line 3951

when I try to enter my admincp and also at the top of my forum.

[shane greer]

Any help appreciated guys. :)

I know some folk had similar problems... any of you able to help a fellow vB user out?

[Forgott3n]

Im completely new to this. what exactly am I to type in.... what is the code below?

Do I type in SELECT * FROM $TPdatastore
WHERE title = "quote_settings"

And replace $TP with my database name?

Sorry Shane, that support was directed at me.

I am unsure on how to proceed with your issue. Did you backup before installing QuoteIt? Your best bet is to contact vbulletin.com member support.

[shane greer]

Ok thanks. Do the guys over at vbulletin.com offer support for this mod?

Cap'n Steve already answered someone else with this problem... Im not sure where Im to put this.

Originally Posted by Defkalion
Is there a way to disable the module now that I do not have access to the admin cp? Any help would be appreciated. Thanks.

Add this to includes/config.php:
PHP Code:
define('DISABLE_HOOKS', 1);

[Forgott3n]

Ok thanks. Do the guys over at vbulletin.com offer support for this mod?

Cap'n Steve already answered someone else with this problem... Im not sure where Im to put this.

Ok, what you need to do is edit your config.php file which is located at yoursite.com/forumpath/includes/config.php

add
define('DISABLE_HOOKS', 1);

to the end of the file.

[Cap'n Steve]

shane greer - Sorry, I've been busy. Glad to see you found the solution. Once you're able to get back in the admincp, you can reinstall the product.

Forgott3n - It seems to be saved properly. Are you sure the quotes aren't going into the moderation queue? A link to your site would also be helpful.

[Forgott3n]

shane greer - Sorry, I've been busy. Glad to see you found the solution. Once you're able to get back in the admincp, you can reinstall the product.

Forgott3n - It seems to be saved properly. Are you sure the quotes aren't going into the moderation queue? A link to your site would also be helpful.

I am sure. The website is www.avrilbandaids.com and the moderation queue is empty.

http://screencast.com/t/cT6iYo1R

That is the problem.

[Cap'n Steve]

Ok, try this: First, reupload all the QuoteIt! files and reinstall the product (do not uninstall it first). Then run this query (replacing $TP with your table prefix):

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

Finally, go to the language manager and save a language (you don't have to edit it). This will reset all the options and you can try saving it again.

If all that doesn't work, then I have no idea what's wrong, but you could use this workaround to make sure moderation is enabled:

In includes/functions_quoteit.php, find this
$quoteitoptions = array_merge($mainsettings, unserialize($vbulletin->languagecache['quoteit_settings']));

and after that, add this
$quoteitoptions['moderatequotes'] = 1;

[cmiller1014]

I cannot get past the:

Sorry, you don't have permission to access the administrative controls on this page.

If you need to access this page, ask your lead administrator to enable your permissions for this page using the Administrator Permissions section of the control panel.

I have rebuilt the bitfields. I desperately need this :(

[Cap'n Steve]

Which page do you get that on? Double-check the QuoteIt! section of your usergroup permissions, save it, then try reinstalling if it still doesn't work.

[cmiller1014]

I had to turn it off all together for now. I am using a custom template, and enabling this product causes formatting issues with content in my header template. Any reason why? My "Search" button which is in my header gets shoved down about an inch and messes up the entire page.

[Cooleyvol]

Is there a way to make it so that quotes don't show up until you moderate them? I'm getting uber spam quotes added and they show up on the site before I moderate them. I have to go to the cpanel and delete them, but I'd like new quotes not to show up until I approve them.

Registered members are letting me know they are showing up and that usergroup does not have moderator permissions for QuoteIt, so as I understand it, they should not be seeing them at all.

Any help is appreciated.

[Cap'n Steve]

cmiller1014 - Does it happen on your forum home page or just the quote listing page? Enable it and post a link to your site if you want me to take a look.

Cooleyvol - Double-check that "moderate quotes" is set to yes and save the QuoteIt! options again. If that still doesn't work, I could use a link to your site. As a work-around, you could also deny guests the ability to submit quotes.

[Cooleyvol]

Cooleyvol - Double-check that "moderate quotes" is set to yes and save the QuoteIt! options again. If that still doesn't work, I could use a link to your site. As a work-around, you could also deny guests the ability to submit quotes.

Moderate was set to yes. Options saved again.


Guests were set to deny submission of quotes already.

[cmiller1014]

cmiller1014 - Does it happen on your forum home page or just the quote listing page? Enable it and post a link to your site if you want me to take a look.


Thanks for the offer to help! This is with it enabled, without even adding the call for the quotes. See the search at the top right? Should be all on one line....

http://www.distributortalk.com/forum/

I have issues when I add the code too... I try to add it above our long banner there, but under the nav bar and it miraculously spans the width of the entire page. If I can get this working, it would be GREAT!

Thanks in advance!

[Cap'n Steve]

cmiller1014 - I see now. It's because your searchbox and the QuoteIt! one both share the same class: "searchfield". You can rename the QuoteIt! one in clientscript/vbulletin_css/quoteit_main.css and the quoteit_listquote template.

Cooleyvol - Very strange. I was able to submit a quote as a guest (which is wrong), but I wasn't able to see the quote I submitted (which is right). Can you see a quote that just says "test"? My only suggestion at this point is to rebuild your bitfields or try reinstalling the product (be sure not to uninstall it first).

[cmiller1014]

Thanks, bud... but I see no reference to "searchfield" in either quote_listquote or quote_listbit.

I changed the name of the class name of "searchfield" to "quoteitsearchfield" within clientscript/vbulletin_css/quoteit_main.css but it did not fix our problem on the home page.

Thanks again

[cmiller1014]

Opps... I lied. It did fix my problem... but still no ref to that class name in those templates.

Thanks!

[Cap'n Steve]

Sorry, I forgot that was moved to the quote_searchbit template. But if your quotes page looks fine, you don't even really need to change that.

[cmiller1014]

I cannot seem to keep the spammers off of this thing. Guests have NO access to it, set all to NO in usergroup perms but they just keep filling it up. There must be a hole in it: Plus they are putting them live without going through the mod queue!

http://www.distributortalk.com/forum/quotes.php?do=view&quoteid=186

[cmiller1014]

I should also note, they cannot be deleted. Attempting to does nothing...

[cmiller1014]

SPam is turning out to be a major issue in this thing.... they are landing in the queue, but appearing anyway. Its making a mess out of the site. Is there a fix or should I just disable it?

Thanks

[Cap'n Steve]

I'm guessing you figured out how to delete them. If you have "soft delete" set to yes, they just go back into the moderation queue and have to be permanently removed from there. It looks like the guest permissions aren't saving properly. Do they show up correctly in your usergroup manager?

[Cooleyvol]

I'm guessing you figured out how to delete them. If you have "soft delete" set to yes, they just go back into the moderation queue and have to be permanently removed from there. It looks like the guest permissions aren't saving properly. Do they show up correctly in your usergroup manager?


They show up correctly in my usergroup manager, but still they can post. I'm leary to reinstall the mod, b/c I had the quote specially coded into my board and don't want to screw that up by uploading the app again.

Should that change anything in my template setup if I reup the app?

[Cap'n Steve]

I'm still not sure why they're not saving properly, and I'm not sure what you mean about it being specially coded, so here's a quick workaround to prevent guests from adding quotes.

in includes/functions_quoteit.php, find
$quoteitpermissions = convert_bits_to_array($permissions['quoteitpermissions'], $vbulletin->bf_ugp_quoteitpermissions);

and below that, add
if ($vbulletin->userinfo['usergroupid'] == 1) {
$quoteitpermissions['canaddquotes'] = 0;
}

[Cooleyvol]

Thanks. I've made that edit and will let you know if it continues to occur.

[scville]

The first step says to upload the upload folder into your forum directory. How do you go about doing this step? I have only done simple mods and not sure how to start this one. Thanks!

[Cap'n Steve]

The same way you got the vBulletin files uploaded to your site. Usually this means an FTP client, but some people have a way to upload through a web-based control panel that their host gives them. Oh, and don't upload the upload folder itself, just everything inside of it.

[Chadi]

This mod does not work with this one:
https://vborg.vbsupport.ru/showthread.php?t=132716

The code that must be used is outputting as text only:

$showrandomquote

It won't pull when placed in the code box for the mentioned mod. However, it works fine in forumdisplay template.

Do you know of any workaround to this?

Thanks.

[Cap'n Steve]

Are you saying you're putting $showrandomquote in the "Custom HTML Code" box on that mod's admincp page? That's probably not possible, but you can try following the instructions to enable a global random quote and see if that helps. If not, you'll just have to place it in a template.

[DBs]

DBs - I'm not sure why that would cause problems. I don't know anything about how vBulletin handles caching systems, but I'll put it on the list of things to look at. In the meantime, I guess you'll just have to disable it, which hopefully won't slow things down too much.

thepub - Try approving some of the quotes on your site.

Hi Cap'n Steve,

Any news on the above issue?

[Cap'n Steve]

Sorry, I really haven't been able to work on this at all. Do you have any other mods installed that add to the datastore and do they work ok?

[Neutral Singh]

Unable to delete quotes, states:


Warning: Invalid argument supplied for foreach() in /home/xxxxxx/public_html/xxxxxx/quotes.php on line 726

Database error in vBulletin 3.8.0:

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 : Saturday, January 31st 2009 @ 04:41:49 AM
Error Date : Saturday, January 31st 2009 @ 04:41:49 AM

[Cap'n Steve]

Were you trying to delete multiple quotes? Have you been able to delete multiple quotes before?

[Chadi]

Strange problem in 3.8.1

It seems the Show Random Quote option gets turned off automatically by itself for some reason. Not sure what is causing it.

[Chadi]

Another bug:

Messes up forum display columns when enabled.

Disabled:
https://vborg.vbsupport.ru/external/2009/02/84.png

Enabled:
https://vborg.vbsupport.ru/external/2009/02/85.png

[Deyth]

Edit: Have something showing in header but it's not what I wanted to see.

[Deyth]

Strange problem in 3.8.1

It seems the Show Random Quote option gets turned off automatically by itself for some reason. Not sure what is causing it.
This might actually be my problem. I'm on 3.8.0 and the random quote isn't working anywhere. Even though I have two quotes submitted all I get is "No quotes matched your search."

[Cap'n Steve]

Sorry guys, I haven't upgraded to 3.8.1 yet. I'll do that soon, and hopefully figure out your problems.

[Cap'n Steve]

Have you tried saving the QuoteIt! Options? That worked for me. Chadi, I'm not sure what you mean. Does it only screw up the listing of threads that have been deleted?

[Chadi]

Have you tried saving the QuoteIt! Options? That worked for me. Chadi, I'm not sure what you mean. Does it only screw up the listing of threads that have been deleted?

Yes, just the soft-deleted threads (and this is obviously admin/mod view in that screenshot).

[Chadi]

Hey Steve, would appreciate any help on this please.

Still facing both problems:

- mod disables itself automatically (turns off) every now and then out of the blue for some reason
- the thread listing issue still there when viewing soft deleted threads and mod enabled

[Cap'n Steve]

Sorry, I forgot to check this thread recently. Are you rebuilding languages or bitfields or anything like that when it turns off the random quote? Could you post the HTML source of the page where the layout is messed up?

[Neutral Singh]

will you ever get time to support this plugin... what a waste of an idea...

[Cap'n Steve]

What support do you need? If you mean updating it, I'm currently talking with someone about possibly taking over the mod, so keep your fingers crossed. Free time is somewhat of a moot point now, since I'm not planning on using vB4 because of the pricing changes.

[AfterWorldForum]

I coudln't get this to work on my frontpage.

I run vb 3.8.4, and vbAdvanced 3.2.1. Using the extra xml file, nor the modules did the trick for me. I tried using the global variable, but that did not do it. I tried creating a new template with that in it, but that also did nothing to show up on the frontsite.

However, I could see it work when looking at the Preview button.

Not sure what I did wrong... Any ideas?

[Cap'n Steve]

I'm not really sure how to help you since my license is expired and I haven't kept up with the latest vBadvanced versions. Could you post a screenshot of the module settings page that you're using? You might try asking at the vBadvanced forums, too.

[AfterWorldForum]

I'm not really sure how to help you since my license is expired and I haven't kept up with the latest vBadvanced versions. Could you post a screenshot of the module settings page that you're using? You might try asking at the vBadvanced forums, too.

Hey, and thanks for answering. I did ask at vbAdvanced, but haven't seen any activity in my thread there.

I'm guessing the problem is the global variable that is used (also because I can preview it from the Preview, but on the frontpage, it just shows up blank).

I tried various values for the global variable, but somehow cannot get it to work. I also tried using different module ways, like the PHP files you added to the zip file, and stripping functionality out of the standard templates to see if anything in there was maybe causing issues.

If you're willing to look into things, I can set you up with an account you could use to have a look at the settings. PM me if you'd be open for something like that, please.

Thanks again for taking the time to help me out, though. I see a lot of potential in the mod, and would love to be able to add it to my site(s).

Best,

Peter

[Cap'n Steve]

Did you install the plugin-globalquote.xml from the extras folder (note that it's a plugin, not a product)? The $showrandomquote variable is unset by default. Either try that or upload the included modules so I can try it as a file-based module.

[AfterWorldForum]

Did you install the plugin-globalquote.xml from the extras folder (note that it's a plugin, not a product)? The $showrandomquote variable is unset by default. Either try that or upload the included modules so I can try it as a file-based module.

Aye, Cap'n I did. The extra modules have been uploaded.

Sorry about the late reply, I checked for PMs, but forgot to check the thread. Worst case scenario, I'll build a quick PHP page to pull the data from the database, and slap that inside a module.

Thanks foryour help so far :)

[kalisekj]

Be Warned This Totally crashed My 3.8 VB Site. Had to do a file restore to get it back to operational.

[Cap'n Steve]

Sorry about the late reply, I checked for PMs, but forgot to check the thread.

Yeah, I like to make any support public, just in case it might help someone else. Try editing the "Global Random Quote" plugin and changing the execution order to 1.

Be Warned This Totally crashed My 3.8 VB Site. Had to do a file restore to get it back to operational.

What error did it give you? What other products do you have installed? For future reference, you can disable the plugin system with a line in includes/config.php in case of emergency.

[AfterWorldForum]

Yeah, I like to make any support public, just in case it might help someone else. Try editing the "Global Random Quote" plugin and changing the execution order to 1.

That did not seem to do anything for me.

Thanks for the suggestion, though :)

[Cap'n Steve]

Turn on debug mode and see what queries are being run the vBadvanced main page. Do any of them reference the quotes table? It should look something like this:
SELECT * FROM vb_quotes

[AfterWorldForum]

Turn on debug mode and see what queries are being run the vBadvanced main page. Do any of them reference the quotes table? It should look something like this:
SELECT * FROM vb_quotes

Sorry for the late reply. I've been awfully busy lately.

Here's the result:

Time Before: 0.43164
Time After: 0.43169
Time Taken: 0.00005

Memory Before: 10,869.234 KB
Memory After: 10,869.313 KB
Memory Used: 0.078 KB

Tip of the day module generated in 0.00005 seconds with 0 queries.
0 seconds doing MySQL queries and 0.00005 doing PHP things.

Looks like the global variable did actually not kick in :(

[Cap'n Steve]

Ok, try uploading the attached plugin. It's not the best method, but it should work with the template you were using.

[AfterWorldForum]

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]

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]

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]

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

[Sadie Frost]

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]

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]

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]

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

$threshold = is_array($threshold) ? 'WHERE ' . implode(' AND ', $threshold) : '';

and above that, add this

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

[Dr. Bantham]

Has anyone tried this mod out with VB4.0?

[Sadie Frost]

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

$threshold = is_array($threshold) ? 'WHERE ' . implode(' AND ', $threshold) : '';

and above that, add this

$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]

Has anyone tried this mod out with VB4.0?

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

[L2V]

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]

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]

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

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]

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

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]

Thanks works perfect using vb 3.8.4
Really like it

[lovegirl]

thanks for the mod gonna try it soon

[S@NL - BlackBik]

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]

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]

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]

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:


.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]

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]

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

lovegirl - What version of vBulletin are you using?

[lovegirl]

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

lovegirl - What version of vBulletin are you using?

i use 3.8

[Cap'n Steve]

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

[lovegirl]

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=25&sortby=quoteid&order=asc&page=5&do=delquote&quoteid=132
IP Address : xxx
Username : xxx
Classname : vB_Database
MySQL Version : 5.0.67.d7-ourdelta-log

[Cap'n Steve]

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]

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]

Qdbs(www.qdbs.org)

Is there a converter for QdbS to QuoteIt!?