Major Additions - QuoteIt! - Quote Database

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

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

Originally Posted by Cap'n Steve

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=...te&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!?