QuoteIt! Quote Management System v1.2

[hr]-[/hr]

QuoteIt! Development has been continued in this thread. Please use this link for the latest version!

[hr]-[/hr]

QuoteIt! 1.2

Description
This hack will allow you to maintain a database of quotes which can be added by users and displayed on FORUMHOME. Admin function includes the ability to delete quotes from the database.

Yes, you can use multi-line quotes.

Information
Requested by djohn (re: https://vborg.vbsupport.ru/showthread.php?t=62420)

Thanks to Giveit2u43 for the username code!

Tested on RC4, should work on RC1+

Version History
v1.0 - Initial Release
v1.1 - Added ability to list all quotes as well as direct quote linking
v1.2 - Added quote moderation abilities

Planned Features
v2.0
- Quote rating system
- Top {X} Quotes

If you use this, please click

[hr]-[/hr]
UPGRADES

v1.1 -> v1.2 UPGRADE INSTRUCTIONS

v1.0 -> v1.1 UPGRADE INSTRUCTIONS

[hr]-[/hr]
3RD PARTY MODIFICATIONS/ADD-ONS

[high]1. Add QuoteIt! to your vbIndex homepage! by [name]Giveit2u43[/name][/high]
[high]2. Add Who's Online Locations for QuoteIt! by [name]Acido[/name][/high]

[docvader]

I tried that (this method worked for the Webpage / Guestbook hack), but I'm getting mysql errors

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near '" . TABLE_PREFIX . "phrase (languageid, varname, text, phrasetypeid) VALUES (0, ' at line 1

Did you do something with the "table prefix" comment? Take it out? (I don't have prefixes in my database, as I was an upgrade from vb 2.xx)

[docvader]

OK, maybe someone can figure this out.

My phrases and templates are all in there. However, when I add a quote directly to the quotes.php page, I get this response:

Database error in vBulletin 3.0.5:

Invalid SQL:
INSERT INTO quotes (quote, author, userid, approved) VALUES ('this is a test submission to get this working again.', 'xxxxx', 1, )

mysql error: You have an error in your SQL syntax near ')
' at line 2

mysql error number: 1064

Date: Sunday 16th of January 2005 12:15:45 PM
Script: http://x.russbo.com/vb/quotes.php
Referer:
Username: xxxx
IP Address:xxxxxxxxxxx

It's trying to call to $vboptions[moderatequotes], which is in quotes.php.

The quotes are all still in the database; the upgrade did not affect them.



Should we reinsert the sql queries like this:

INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('moderatequotes', 'forumhome', '0', '0', 'yesno', 6, 0, 1)

instead of what's called for in the instructions:

INSERT INTO " . TABLE_PREFIX . "setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('moderatequotes', 'forumhome', '0', '0', 'yesno', 6, 0, 1)

Anyone have any idea?

[LKJR]

well ok, I tried this once on a new install of 3.0.5 and it didn't work so I tried running the sql queries again. didn't change anything

so I completely removed my test forum and database

new install and fresh database.

same thing. any ideas? I"d really like this on my site.

[LKJR]

has everyone given up on this?

[Deviant++]

you mean this mod dosn't work on 3.0.6 ?

[docvader]

Originally Posted by Deviant++

you mean this mod dosn't work on 3.0.6 ?

It stopped working on 3.05, and we can't figure out how to get it to function. It's a shame, because it was one of the more popular hacks that I have on my site. I really wish someone would figure this out.

[TurboTwoLiter]

same here, i had it on my old site, upgraded to 3.0.5 after server failure,

i wish it was compatable

[LKJR]

I tried it on a fresh install of 3.0.5 twice with no luck.

[CtrlAltDel]

I figured it out.

For some reason the VB 3.0.5/6 upgrade somewhere along the line kills the 'Forum Home Page Settings' database table...or at least nukes the entry needed for the quotes thing. So basically, nothing is broken, but its just like you check the 'off' button for the quotes.

You need to rerun this query.

INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('showquote', 'forumhome', '0', '0', 'yesno', 5, 0, 1);

and this one

INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('moderatequotes', 'forumhome', '0', '0', 'yesno', 6, 0, 1)

If your table has a prefix, put that on there.

Then go into your home page options and re-enable the settings.

Everything should be back to normal now.

[docvader]

YOU ARE THE MAN!

Impressive...

(but the "add to quotes" funcition, in each postbit, draws a white page of death).