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]

[The Realist]

Ran this but it says duplicate entries.

Originally Posted by 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.

[CtrlAltDel]

go into you admincp and make sure you check the two settings for the quotes, save them, and then check.

and what part exactly isnt working?

[The Realist]

I have checked the boxes in options. The quotebox is showing on the homepage but its not looking correct.

See picture attached.

Laters

[CtrlAltDel]

approve your quotes
edit a phrase and save, so the phrases work

[The Realist]

Thanks.

Edited a phase and saved it and now its working, strange?

Also have you any ideas how I can get thetop right tab to blend into my template (see pic)

Thanks.

Originally Posted by CtrlAltDel

approve your quotes
edit a phrase and save, so the phrases work

[docvader]

So much for progress. When adding a quote, I get this error:

Database error in vBulletin 3.0.6:

Invalid SQL:
INSERT INTO quotes (quote, author, userid, approved) VALUES ('When losing a battle, whether it be of the body, the mind or the heart, it is only a set up to win the next battle in which the reward is much greater.', 'Tsu Chin', 1, )

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

mysql error number: 1064

Date: Monday 24th of January 2005 11:31:37 AM
Script: http://x.russbo.com/vb/quotes.php
Referer:
Username: xxx
IP Address: xxxxx

Otherwise, it all seems to work. Any ideas?

rich
http://x.russbo.com/vb/index.php

[CtrlAltDel]

reread my fix, and run the second query
then updated your admin settings and you will be fine

as for The Realist's problems...thats your template just acting odd, just change the template to look like you other boxes and you will be good to go.

[docvader]

Thanks. Think that did it. Impressive how you took command of this hack, you should really think about improving it, since you seem to be the only one that understands it.

Great feature, my members love it. Thanks for helping me get it back online.
rich

[LKJR]

maybe I"m lost mine looks like realist's does with the marks but empty (image attached a page or two back)

the boxes are checked I"ve tried running the queries again with no luck, it just says they already exsist.

Also I noticed I don't have a line in the moderate box in admincp to approve quotes like is shown on the initial post.
maybe that's the problem with mine?

[CtrlAltDel]

you need to edit a phrase and save, to update the phrases database