Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.6 > vBulletin 3.6 Add-ons
FAQ Community Calendar Today's Posts Search

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
  #52  
Old 01-07-2007, 06:08 PM
CtrlAltDel CtrlAltDel is offline
 
Join Date: Feb 2002
Location: Ohio
Posts: 107
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

nice upgrade steve
Reply With Quote
  #53  
Old 01-08-2007, 12:39 AM
thepub thepub is offline
 
Join Date: Aug 2006
Posts: 226
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

not working and I just typed a long post explaining what the heck was going on and somehow lost it *grrr* I am having trouble installing this and there is no Quote it maintenance thing in my admin cp. Also, if I revert my templates (as suggested) to upgrade the quoter then I lose all of my other hacks and addins, is this the only way to do it?
Reply With Quote
  #54  
Old 01-08-2007, 12:44 AM
thepub thepub is offline
 
Join Date: Aug 2006
Posts: 226
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I tried to import the product and got an error message saying:

Quote:
Database error in vBulletin 3.6.2:

Invalid SQL:

INSERT INTO datastore
(title, data) VALUES
("quote_settings", "a:14:{s:13:\"enablecontext\";s:1:\"0\";s:14:\"mod eratequotes\";s:1:\"1\";s:16:\"numbertomoderate\"; s:1:\"0\";s:9:\"allowhtml\";i:0;s:11:\"allowbbcode \";i:1;s:12:\"allowsmilies\";i:1;s:11:\"allowimage s\";i:0;s:15:\"allowlinebreaks\";i:1;s:13:\"contin uousids\";i:1;s:12:\"saveascookie\";i:0;s:11:\"upg radedate\";i:1168224147;s:16:\"enablecategories\"; i:1;s:14:\"showunapproved\";i:1;s:12:\"reportemail s\";s:0:\"\";}");

MySQL Error : Duplicate entry 'quote_settings' for key 1
Error Number : 1062
Date : Sunday, January 7th 2007 @ 09:42:28 PM
Script : http://www.theneighborhoodpub.com/ad...=productimport
Referrer : http://www.theneighborhoodpub.com/ad...?do=productadd
IP Address : (deleted by thepub)
Username : (deleted by thepub)
Classname : vb_database
can you tell me what this means and why it's happening?
Reply With Quote
  #55  
Old 01-08-2007, 12:52 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

Quote:
Originally Posted by Defkalion View Post
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); 
Reply With Quote
  #56  
Old 01-08-2007, 03:12 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

All installation database errors should be fixed. The closing quotation mark is hidden in Internet Explorer on the random quote and the quote bbcodes until it learns to stop wandering off.

thepub - You should only revert the QuoteIt! templates, and you only need to do that if you customized them in an earlier version.

Calash - What version of IE is that? Check under Help -> About. Also, try shift + refresh and see if that changes anything.

Defkalion - Do you have any other mods installed? If you could post the code on and around that line number, that might help, since it seems to be different in older versions.

The latest version I can download is 3.6.1, can anyone confirm that this works on newer versions?
Reply With Quote
  #57  
Old 01-08-2007, 08:28 AM
Defkalion Defkalion is offline
 
Join Date: Jan 2007
Location: Athens, Greece
Posts: 201
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ok I did a rebuild of the bitfields and now everything seems to be ok.

Many thanks for your quick reply Steve.
Reply With Quote
  #58  
Old 01-08-2007, 09:22 AM
GrabAssGirl GrabAssGirl is offline
 
Join Date: Feb 2005
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Can you tell me why the quotations are located so far apart. The image on the right is located almost outside the quoteIt box. It's even doing this on your "live demo" site. Is there any way for me fix this? (don't know if this will work, but here's an image of what I am talking about...

Reply With Quote
  #59  
Old 01-08-2007, 09:24 AM
GrabAssGirl GrabAssGirl is offline
 
Join Date: Feb 2005
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

or, is there anyway to just do away with the images and have nothing but the quote there?
Reply With Quote
  #60  
Old 01-08-2007, 10:53 AM
Calash's Avatar
Calash Calash is offline
 
Join Date: Jun 2006
Location: East Coast, USA
Posts: 297
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Both IE6 and IE7. Firefox does not throw a visible error but the edit button does not work.

I am also having the issue with the quotes being spaced way too much, but that appears to be a skin issue so I am going to work to resolve that via editing the templates.

I am also having a problem getting the vBadvanced module to work. The block just will not show up no matter what I do and I am not sure how to get any error messages to help diagnose the problem.
Reply With Quote
  #61  
Old 01-08-2007, 10:55 AM
zetetic's Avatar
zetetic zetetic is offline
 
Join Date: Apr 2004
Posts: 338
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Cap'n Steve View Post
All installation database errors should be fixed.
Doh! I got impatient yesterday so I dumped the quotes table to a flat file, then uninstalled and reinstalled QuoteIt. Unfortunately I can't seem to get the QuoteIt file import to work. I keep getting this error: "Invalid Query: Column Count Doesn't Match Value Count At Row 1".

Exactly what format does a file have to be in? I'm trying just quote, author, userid, context separated by semicolons. Sorry, I know just enough to be dangerous!

Quote:
The latest version I can download is 3.6.1, can anyone confirm that this works on newer versions?
The clean install went fine on 3.6.4, but I can't be sure it worked until I get the import done.
Reply With Quote
Reply


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 03:58 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07089 seconds
  • Memory Usage 2,322KB
  • Queries Executed 25 (?)
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_php
  • (4)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_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