Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.6 > vBulletin 3.6 Add-ons

Reply
 
Thread Tools
QuoteIt! - Quote Database Details »»
QuoteIt! - Quote Database
Version: 3.17, by Cap'n Steve Cap'n Steve is offline
Developer Last Online: May 2010 Show Printable Version Email this Page

Category: Major Additions - Version: 3.6.0 Rating:
Released: 01-01-2007 Last Update: 04-30-2008 Installs: 207
DB Changes Uses Plugins Template Edits
Re-useable Code Additional Files Translations  
No support by the author.

QuoteIt! version 3.1

I'm no longer able to put very much time into this mod, so I've set up a Subversion repository at http://www.vbulletinprogramming.com/projects/quoteit/ to allow others to help out. You can use the login "vbuser" with the password "vbulletin" to edit files. If someone would like to completely take over the mod, please contact me.


QuoteIt! allows you to have a database of quotes integrated with your forum. Users submit quotes that can then be voted on by the other users, using your choice of two rating systems. The average installation will show a random quote on the forum home page, but you can include it on any vBulletin page or on your portal home page.

If you'd like to see a demo, go to forums.monkeycrap.com.

Features:

Random Quote
- a random quote can be shown on any vBulletin powered page
- the administrator can set a default rating threshold that quotes must meet before showing up as the random quote
- a new random quote can be chosen at a specific interval of time, to reduce server load

Quote Database
- quotes can be searched, filtered, and sorted by many different criteria
- quotes have a "context" field that can be turned on or off to include more information about the quote
- quotes can be embedded in posts with bbcode
- each post and private message now has a "Submit to Quotes" link that allows users to quote things said on your forum more easily

Quote Ratings System
- quotes can be rated either plus/minus or on a scale from 1 to 5
- quotes below a certain total score or average score can be filtered out

Quote Management
- quotes can either be automatically approved or moderated
- the quote moderation que is like the que for posts, enabling the moderation of several quotes at once
- usergroup permissions are used for adding, editing, deleting, rating and viewing quotes
- most actions use AJAX to avoid page reloads

Don't forget to click install!

Currently known problems are listed here.

The files needed to edit the included images are attached to this post.

This hack is based on QuoteIt! 1.2, originally by magnus. The "submit post" feature was inspired by an addon by CtrlAltDel.

Older versions (no longer in development): QuoteIt! 3 for vBulletin 3.5.x | QuoteIt! 2.03 for vBulletin 3.0.x

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #652  
Old 10-12-2008, 04:19 AM
Forgott3n Forgott3n is offline
 
Join Date: Oct 2007
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

http://www.avrilbandaids.com/forums/...ew&quoteid=874

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

Code:
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
Reply With Quote
  #653  
Old 10-12-2008, 04:36 AM
Cap'n Steve's Avatar
Cap'n Steve Cap'n Steve is offline
 
Join Date: Feb 2004
Location: Kalamazoo, MI, USA
Posts: 745
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That's really strange. Try going to this page (while logged in as a moderator or administrator).
Reply With Quote
  #654  
Old 10-12-2008, 05:03 AM
Forgott3n Forgott3n is offline
 
Join Date: Oct 2007
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Cap'n Steve View Post
That's really strange. Try going to this page (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/...quoteid=999999

seems to give the blank one. Perhaps its the default null result?
Reply With Quote
  #655  
Old 10-14-2008, 03:01 AM
Cap'n Steve's Avatar
Cap'n Steve Cap'n Steve is offline
 
Join Date: Feb 2004
Location: Kalamazoo, MI, USA
Posts: 745
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #656  
Old 10-17-2008, 12:37 PM
ArnyVee's Avatar
ArnyVee ArnyVee is offline
 
Join Date: Mar 2008
Posts: 944
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #657  
Old 10-17-2008, 03:33 PM
Cap'n Steve's Avatar
Cap'n Steve Cap'n Steve is offline
 
Join Date: Feb 2004
Location: Kalamazoo, MI, USA
Posts: 745
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #658  
Old 10-17-2008, 04:23 PM
ArnyVee's Avatar
ArnyVee ArnyVee is offline
 
Join Date: Mar 2008
Posts: 944
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for the quick response Cap'n Steve!

I'll look into adding this tonight or tomorrow to my site.
Reply With Quote
  #659  
Old 10-26-2008, 02:40 AM
Forgott3n Forgott3n is offline
 
Join Date: Oct 2007
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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!
Reply With Quote
  #660  
Old 10-27-2008, 06:41 AM
Cap'n Steve's Avatar
Cap'n Steve Cap'n Steve is offline
 
Join Date: Feb 2004
Location: Kalamazoo, MI, USA
Posts: 745
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

[sql]SELECT * FROM $TPdatastore
WHERE title = "quote_settings"[/sql]
Reply With Quote
  #661  
Old 10-27-2008, 02:48 PM
shane greer shane greer is offline
 
Join Date: Oct 2008
Posts: 65
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:24 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.12507 seconds
  • Memory Usage 2,308KB
  • Queries Executed 27 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete