Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
QuoteIt! - Quote Database Details »
QuoteIt! - Quote Database
Mod Version: 3.17, by Cap'n Steve (Member) Cap'n Steve is offline
Developer Last Online: May 2010 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.6.0 Rating: (19 votes - 4.63 average) Installs: 205
Released: 02 Jan 2007 Last Update: 01 May 2008 Downloads: 1338
Not Supported DB Changes Uses Plugins Template Edits Additional Files Re-usable Code Translations  

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

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	screenshot-list.gif
Views:	3944
Size:	40.0 KB
ID:	58351   Click image for larger version

Name:	screenshot-options.gif
Views:	1077
Size:	30.5 KB
ID:	58352   Click image for larger version

Name:	screenshot-moderation.gif
Views:	765
Size:	26.3 KB
ID:	58353   Click image for larger version

Name:	screenshot-bbcodes.gif
Views:	2809
Size:	39.7 KB
ID:	58354  

Click image for larger version

Name:	screenshot-random.gif
Views:	2824
Size:	36.6 KB
ID:	58355  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
QuoteIt! - Quote Database Cap'n Steve vBulletin 3.5 Add-ons 419 23 Jun 2007 11:20
QuoteIt! 2.0 - Quote Management System Cap'n Steve vBulletin 3.0 Full Releases 257 03 Aug 2006 06:03
QuoteIt! Quote Management System v1.2 magnus vBulletin 3.0 Full Releases 376 14 Jul 2005 06:05

  #211  
Old 06 Feb 2007, 15:27
BaconDelight BaconDelight is offline
 
Join Date: Jan 2005
Originally Posted by MaestroX View Post
Thanks Cap'n Steve

But i've came across another problem. HTML is not parsed. The raw HTML is outputted using "show random quote" variable.

I've checked all options and it seems to be correct.

Thanks
Did you click to save the settings? Even if you don't change them, click the save button once. I was having the same problem with BBCode after the last upgrade and saving the parsing settings once solved it.
Reply With Quote
  #212  
Old 06 Feb 2007, 15:39
thepub thepub is offline
 
Join Date: Aug 2006
so far everything working well except I only have one quotation mark showing on my homepage instead of both.
Reply With Quote
  #213  
Old 06 Feb 2007, 16:01
mamashid mamashid is offline
 
Join Date: Jan 2007
I did something.....I added this hack to my page, now we cant do anything on the board, i cant even get into the admin panel
Reply With Quote
  #214  
Old 06 Feb 2007, 22:35
Cap'n Steve's Avatar
Cap'n Steve Cap'n Steve is offline
 
Join Date: Feb 2004
mamashid - Could you tell me what the problem was? You can disable the plugin system by following these instructions.
Reply With Quote
  #215  
Old 09 Feb 2007, 08:05
ubblite ubblite is offline
 
Join Date: Jan 2006
First off, nice mod Cap'n Steve - thanks.

I am receiving the following error after trying to delete a quote (not from the view all quotes area, but on the top of the quote itself from the forumhome page):


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Also, the end quote is uneven with the text quite a bit.
Reply With Quote
  #216  
Old 09 Feb 2007, 10:05
ubblite ubblite is offline
 
Join Date: Jan 2006
I have discovered some more problems.

QuoteIt is not centered and looks different from your screenshot. The collapse button is also out of place. And when you go to add a quote, under category if the name is a bit long it will cut it off. This happens with both IE & FF and I'm using the default vBulletin style. I've attached a screenshot of the forumhome page.

One more thing. In Firefox's Error Console it shows "fillStars is not defined" & "emptyStars is not defined" continuously as you browse over the quote ratings.
Attached Images
File Type: jpg quoteit.jpg (21.6 KB, 17 views)

Last edited by ubblite; 09 Feb 2007 at 10:11.
Reply With Quote
  #217  
Old 09 Feb 2007, 21:30
Cap'n Steve's Avatar
Cap'n Steve Cap'n Steve is offline
 
Join Date: Feb 2004
ubblite - It's not finding the CSS files. Is that on a vBadvanced page? Could you post a link?
Reply With Quote
  #218  
Old 10 Feb 2007, 03:57
ubblite ubblite is offline
 
Join Date: Jan 2006
Well I guess CMPS was the problem, Steve. I had a CMPS module integrated into my forumhome page and I guess it was treated as a CMPS page. For some reason, other stuff like the Shoutbox is just a forumhome integration hack that doesn't have a problem w/it. Strange but not a big deal - I just removed CMPS from the forumhome.

I do get the same problem here as mentioned earlier in this thread with Languages. It shows an "-a" as another language with this hack installed.

Everything else seems fine for the most part.

Thanks for your help.
Reply With Quote
  #219  
Old 10 Feb 2007, 08:19
Cap'n Steve's Avatar
Cap'n Steve Cap'n Steve is offline
 
Join Date: Feb 2004
ubblite - Are you sure you have the latest version? That bug should have been fixed for good.
Reply With Quote
  #220  
Old 11 Feb 2007, 05:06
ubblite ubblite is offline
 
Join Date: Jan 2006
Originally Posted by Cap'n Steve View Post
ubblite - Are you sure you have the latest version? That bug should have been fixed for good.
Yup, I definitely have the latest version installed.

I also have the same problem as another user in this thread who has PhotoPost Pro. When viewing 'Who's Online', under location it is completely blank if they are viewing Photopost.

Thanks
Reply With Quote
  #221  
Old 12 Feb 2007, 01:33
Sadie Frost's Avatar
Sadie Frost Sadie Frost is offline
 
Join Date: Dec 2001
Originally Posted by Alien View Post
Hey!

I went over the table structure carefully, and I have everything you showed above in your table structure EXCEPT for this in the quotes table:

date => INT (10) UNSIGNED NOT NULL DEFAULT 0
views => INT (10) UNSIGNED NOT NULL DEFAULT 0
categoryid => INT (10) UNSIGNED DEFAULT NULL
postid => INT (10) UNSIGNED DEFAULT NULL
I upgraded from the 3.5 version (version 2.1 it says in the Product Manager?) on 5 boards (lol), and it worked fine on 4 of them. The fifth though I seem to be having the same problem as Alien did above (page 9/10 of this thread).

I tried to add the missing fields to the tables but I get this error in phpmyadmin:

ALTER TABLE `quotes` ADD `date` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
ADD `views` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
ADD `categoryid` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
ADD `postid` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'

MySQL said:

#1060 - Duplicate column name 'quoteid'
I am using MySql version 4.1.21 there. I also get the same errors if I try to use the latest version from the 3.5 version thread. I also did choose the allow overwrite.

Does anyone have any ideas for me? Is it jsut a MySQL version problem?

Also I know that I read this somewhere but I just read through the thread again and couldn't find it, so I'm sorry. But all my dates on my quotes are "12-31-1969"? Is that just because I've just installed the new version?

Thanks
__________________
[buffy-boards]

Last edited by Sadie Frost; 12 Feb 2007 at 03:38.
Reply With Quote
  #222  
Old 12 Feb 2007, 04:35
Cap'n Steve's Avatar
Cap'n Steve Cap'n Steve is offline
 
Join Date: Feb 2004
ubblite - I'm not sure if you saw the post in the other thread, but could you tell me how many languages you normally have, or even better, give me a link? I can't really test the Photopost problem, but I'll take another look.

Sadie Frost - Try adding each column individually. Try using the phpMyAdmin interface instead of typing it in manually ("add new field" at the bottom of the page when viewing table structure). The date problem is because of the incomplete install, but it will default to the date you installed it when the quote doesn't have a date stored (which is all of the ones added before this version).

I'd love to know what's causing that problem, but I have no clues so far.
Reply With Quote
  #223  
Old 12 Feb 2007, 20:25
Sadie Frost's Avatar
Sadie Frost Sadie Frost is offline
 
Join Date: Dec 2001
Hi Cap'n Thanks for the response I really do love this hack, and have been using it for a while. It's so odd that out of five upgrades done exactly the same at the same time that only one would have a problem when the rest were fine.

The one with the problems is on a different server than the other four, but both are using MySql 4.1.21.

The way I tried to add the new fields before was through the phpmyadmin interface. I tried doing them one by one and trying to do it by just running a query for it, but I still get that duplicate quoteid column message.

Weird! lol
__________________
[buffy-boards]
Reply With Quote
  #224  
Old 13 Feb 2007, 05:46
Cap'n Steve's Avatar
Cap'n Steve Cap'n Steve is offline
 
Join Date: Feb 2004
Well, the only thing I can think of is to make a backup of your quotes and quoteratings tables, delete them, reimport the product, and then restore the backup (making sure you don't have it add any drop table statements when you export).
Reply With Quote
  #225  
Old 13 Feb 2007, 08:18
Cap'n Steve's Avatar
Cap'n Steve Cap'n Steve is offline
 
Join Date: Feb 2004
I just uploaded a new version with a few small improvements, including improving the style, especially on vBadvanced pages and especially in Internet Explorer.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

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


New To Site? Need Help?

All times are GMT. The time now is 21:33.

Layout Options | Width: Wide Color: