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

[Cap'n Steve]

I'm not familiar with that mod, do the codes work in a normal post? You can also try saving the QuoteIt! options again.

[Tanapangarap]

Hi, I'm looking to apply a very simple random quotation function on my vBulletin. I found yours, I found it much more than what I'm wanting. I was wondering if you--the author of the modification showcased on this thread--might have interest in undertaking such a project? I posted much detail about my request here.

Regards,

Kevin

[Cap'n Steve]

I probably won't have time, but it looks like what you want is pretty simple. I don't think you'll have a problem finding someone to write it (or you could probably write it yourself if you don't mind spending some time reading tutorials).

[Tanapangarap]

Well, I am trying to learn about coding on the vBulletin software, but I've been using it for only a few days (converted from phpBB2, the only forum software I've used beforehand), so I've got a lot of reading to do.

If you do end up having some free time, and would choose to attempt to code my requested modification, I would much appreciate that. Here is the URL for more info and download of the modification I used on my phpBB installation: http://www.phpbbhacks.com/viewhack.php?id=431
There's very little code. I believe it was one or two edits and the uploading of the text file.

[Antwerp]

So, I screwed up when I upgraded my forum from 3.5.4 to 3.6.8

I uninstalled all hacks for a fresh clean install.
But I do have a functioning backup of the 3.5.4 with hacks still installed.

What I'm trying to do is restore the quotes
Namely;
vb3_quote.sql & vb3_quoteratings.sql

I exported the files from the AdminCP in VB.
I put them in the root directory via FTP.
I'm ready to add them via SSH.
I can't get MyPHPAdmin to work.

Basically I don't want to overwrite the current database, I want to append to it.

So I have SecureCRT and I'm ready to do the SSH upload.

I've been trying to read up on this, but I am confused and I don't want to nuke my current database.

Suggestions / Help Appreciated!
- Ant

[expatdirectory]

Hi Steve,
have been using this mod for a while now and quotes are starting to build up. I have noticed however that my users quote count (in stats section on postbit) is showing as 0 (even for those who have posted quotes. Am I missing something??

Also,

I removed a fair bit of the script to reduce the size of the box on my forum index (as most people do). I now note that there is no-where to rate quotes. Is there a way to add the rate this quote etc in the Quotes page (seen after clicking view all quotes)?

[Cap'n Steve]

Antwerp - If you open your backup SQL file in a text editor, you should be able to see what part is the table structure and what part is the actual data. If you just delete the table structure parts, the data might be able to be inserted without problems. The only conflict I could think of is the id column of the quotes table, which is the same number as the quoteid column of the quoteratings table. If new quotes have been added to your database since you upgraded, you'll have to adjust these numbers to avoid conflict (any number will work, as long as it's consistent). Be sure to backup your current database before you try anything.

expatdirectory - Try the "Rebuild Quote Counts" option in your control panel. If you open the product XML file in a text editor and search for the name of the template (quote_randomquote for the home page, quote_listbit for the main quotes page, etc.) you'll find the default template and should be able to spot the portion that handles ratings. Look for this:

<if condition="$quoteitpermissions['canratequotes']">

[Antwerp]

Thanks for you response.

Now, is the only way to upload the tables through MyPHPAdmin?

[Cap'n Steve]

Originally Posted by Antwerp

Now, is the only way to upload the tables through MyPHPAdmin?

Yes, unless you have shell access on your server.

[Mum]

Uninstalled. I have rebuilt bitfields like it says to in the instructions, but i still can't moderate quotes.