QuoteIt! 2.0 - Quote Management System

QuoteIt! version 2.0

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. This was developed on vBulletin 3.0.7, but should work on 3.0.0 and above.

You can see a demo on forums.monkeycrap.com.
Instructions for adding a random quote to vBadvanced and vBindex are in this post.


Features (features new to 2.0 are in yellow)

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
- the quote shown is much more random than in previous versions

Quote Database
- quotes can only be edited or deleted by an administrator
- quotes can be viewed individually or listed on several pages
- quotes can be sorted by total score, average score, author, submitter, or date added
- quotes now have a "context" field that can be turned on or off to include more information about the quote
- 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 administrator can now edit quotes
- the quote moderation que is now more like the que for posts, enabling the moderation of several quotes at once



Don't forget to click

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

You may release translations of this hack as long as the original credits are included. Otherwise, you not redistribute this hack without permission from me.

[anarchystar]

bingo .... that looks like it may be the problem. When I went to that part of vBoptions I got the following error at the top of the page:

Parse error: parse error, unexpected T_STRING, expecting ']' in /var/www/forums/includes/adminfunctions_options.php(96) : eval()'d code on line 1

and, the setting to display the random quotes in that area was not there, also there were no options listed for the quote rating system value.

That must be where the problem is. Unfortunatly, I am on a friends computer now, so I will have to wait untill I get home to look at the code in adminfunctions_operations.php .

Hopefully I can get that fixed up later and get this thing working again.

[Cap'n Steve]

That's weird, I'm getting that error now too, but my settings work fine. It's a problem with the options list for the quote ratings. Upload the attached file to your admincp and run it once to fix it.

[anarchystar]

Alright, i ran that script and it did clear up that parse error that I posted earlier, but it does'nt show up anywhere where I put $showrandomquote ...

In the post you made earlier, you said that there should be an option to display random quote in the forum home page options. I don't have that option there, all I have is an option to select the rating scale for quoteit, random quote average threshhold, and random quote total threshhold. Am I missing an option there?

Also when I select a quote rating option from forum home page options and save it, it will always display disabled no matter what I pick, but it will diplay the option I chose in the quoteit options.

[Cap'n Steve]

Yes, you are missing an option and I can't see how that would happen, since that option is actually left over from the old version. I've updated the quoteit_fix.php to fix the problem of the wrong option being selected. You can run it again to have it show the correct setting, although that's not what's causing your main problem.

To manually set the "showquote" variable, you can run this SQL query:

UPDATE $TPsetting SET value = 1
WHERE varname="showquote"

If for some reason you don't have that variable, the first query will
give you an error and you should run this one instead:

INSERT INTO $TPsetting
(varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES
("showquote", "forumhome", 1, 1, "yesno", 5, 0, 0)

Be sure to replace $TP with your table prefix.

[anarchystar]

I ran the first query from your last post with no errors in my phpmyadmin.

It's still not showing up, lol .... on the bright side, I also ran the new fix script you made, and it cleared up that other issue ... at least it's progress, right?

Can you tell me specifically what code I need to look for to confirm that option that should be in forum home page settings?

I am going to re-check my code again, just to be extra, extra sure I have it all right ... would it help if I attached any of those .php files for you to look at yourself? If you want to check any of them just tell me which ones you need.

[Cap'n Steve]

The first one is my fault, I forgot that it needs to rebuild the datastore. You can just run this query:

DELETE FROM $TPdatastore WHERE title = "options"

and it will rebuild it with the new options the next time someone loads a page. That should get the random quote to show up. To see if you have the appropriate options saved in the database, run these queries and post what they return:

SELECT * FROM $TPphrase WHERE varname = "setting_showquote_desc" OR varname = "setting_showquote_title"

SELECT * FROM $TPsetting WHERE varname = "showquote"

Don't forget to replace $TP with your table prefix.

[anarchystar]

ok, I ran the first query, but the missing option is still MIA ... no luck with that :disappointed:

Ran the next 2 queries and did a screen capture of the output for you.

[emtee]

anarchystar, note that you have to approve the quote after you add it. It's under Moderation/Moderate Quotes. If you don't approve, you won't see anything in forumhome.

[anarchystar]

I have moderate quotes turned off

[anarchystar]

Originally Posted by Cap'n Steve

and it will rebuild it with the new options the next time someone loads a page. That should get the random quote to show up. To see if you have the appropriate options saved in the database, run these queries and post what they return:

SELECT * FROM $TPphrase WHERE varname = "setting_showquote_desc" OR varname = "setting_showquote_title"

SELECT * FROM $TPsetting WHERE varname = "showquote"

Don't forget to replace $TP with your table prefix.

On a whim I went back and ran that 2nd query from this post even though I did not get an error from teh first query. That fixed the problem! I can see the mod now, thanks for the awesome support!