vb.org Archive

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

thepub 06-26-2008 08:37 PM

Quote:

Originally Posted by Cap'n Steve (Post 1559827)
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 06-29-2008 08:04 PM

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 06-30-2008 12:58 AM

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

Cap'n Steve 06-30-2008 02:00 AM

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 07-05-2008 03:31 PM

I have installed vBExperience 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 07-06-2008 01:37 PM

Quote:

Originally Posted by Dr. Bantham (Post 1567428)
I have installed vBExperience 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 07-06-2008 04:39 PM

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 07-08-2008 12:29 AM

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 07-08-2008 07:09 AM

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 07-10-2008 04:17 AM

Quote:

Originally Posted by Dr. Bantham (Post 1568162)
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 07-11-2008 10:53 AM

Quote:

Originally Posted by Cap'n Steve (Post 1569883)
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 07-13-2008 12:07 AM

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

Cooleyvol 07-14-2008 05:19 PM

Quote:

Originally Posted by Cap'n Steve (Post 1573887)
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 07-17-2008 03:03 AM

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 07-17-2008 08:15 AM

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 07-19-2008 06:07 AM

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 07-25-2008 09:09 AM

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 07-28-2008 12:33 AM

Did you try the module included in the extras directory?

KevinL 07-28-2008 05:24 AM

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

expatdirectory 07-28-2008 03:14 PM

Quote:

Originally Posted by Cap'n Steve (Post 1585591)
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 07-28-2008 09:56 PM

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 07-28-2008 10:16 PM

Quote:

Originally Posted by Cap'n Steve (Post 1586263)
KevinL - What errors?

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

Code:

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

Code:

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 08-01-2008 11:37 PM

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 [quotes] 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[/quotes]. 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 08-02-2008 03:05 AM

Quote:

Originally Posted by KevinL (Post 1586273)
When I check 'show random quote' I get these errors:

Code:

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

Code:

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 08-02-2008 05:09 AM

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

PHP Code:

$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 08-02-2008 12:53 PM

Quote:

Originally Posted by Cap'n Steve (Post 1589674)
KevinL - Try removing this chunk of code from includes/functions_quoteit.php (also, post a list of the other mods you have installed):

PHP Code:

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

Code:

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 08-03-2008 02:09 AM

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 08-03-2008 10:41 AM

Worked wonders!!

Thank you

gpc10347 08-05-2008 01:18 PM

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:

PHP Code:

//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 08-06-2008 02:39 AM

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

PHP Code:

$quoteitoptions['showrandomquote'] = false


thepub 08-06-2008 02:49 AM

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 08-06-2008 02:55 AM

Quote:

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

PHP Code:

$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 08-10-2008 06:39 AM

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 08-13-2008 02:36 AM

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

http://www.avrilbandaids.com/forums/...ing&order=desc

What's going on?

Gio Takahashi 08-14-2008 05:25 AM

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 08-14-2008 10:44 PM

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

                                        WHERE quotes.quoteid IN (' . $prefetched . ')
                        ');

and replace it with this:
Code:

                                        WHERE quotes.quoteid IN (' . $prefetched . ')
                                        ORDER BY ' . $quotedisplay['order']
                        );


Neutral Singh 08-22-2008 04:38 PM

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 08-22-2008 09:35 PM

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

glowinggal 09-11-2008 01:09 PM

Quote:

Originally Posted by Gio Takahashi (Post 1598216)
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 09-18-2008 07:12 AM

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


All times are GMT. The time now is 06:14 PM.

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

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01972 seconds
  • Memory Usage 1,866KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (7)bbcode_code_printable
  • (5)bbcode_php_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete