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]

[anarchystar]

I did'nt do an upgrade, I tried to install quote-it on a fresh copy of vb3.0.5 ... but for some reason, it looks like the install script did'nt insert the table into my database. ... weird ...

[Mr.Monkey]

The database is there if you ran the script (try using phpmyadmin to see it), but the script appears unable to call it after the 305 patch is installed.

[Deyth]

I still haven't figured out why the values in $vboptions aren't there. I can get the quotes to show up but when someone tries to do an add it fails because the $vboptions[moderatequotes] value is blank. Maybe that's all related.

[Cap'n Steve]

I don't want to complain, but magnus hasn't posted in this thread in 8 months. Maybe it's time for someone else to try making a rating system?

[anarchystar]

I eventually did get this to work just fine in 3.0.5, I just had to add the sql table prefixs, and correct one one line in quotes.php.

I am trying to find the the line now that redirects the user after the quote is added. i want to change it to go to my homepage, and not the forum index page. hav'nt found it yet though ... any ideas?

[memobug]

I apologize for not knowing the ins and outs of your hack. However, I wanted to have a Quote of the Day that will remain the same throughout the day. I was thinking that this would allow people the opportunity to think about the quote, contemplate and reply to it rather than having different quotes fly by with every refresh.

I gather from the mysql I see that yours does not do this (from INDEX.PHP mod step 4a. in part:

SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1

This appears to be a simple random query that would change on every refresh? Anyway, after researching this a little, I have the following suggestion as an alternative, using the date as a seed to give a consistent quote throughout the day:

SELECT * FROM quotes WHERE approved=1 ORDER BY RAND(TO_DAYS(NOW())) LIMIT 1

Which I believe will produce this result The problem I have found in other applications is: if someone adds a quote to the database, the quote of the day will shift because the total number of rows changes. At least that is what I have found to be true in another hack. This isn't necessarily a terrible result, but it is not the intended operation, and I would be interested if anyone knows a method to keep the quote random but changing daily.

Anyway if someone wants to try this it would be of interest to me. I am not currently using this hack, but would be interested in the result.

Regards,

Matt

[Deyth]

Originally Posted by anarchystar

I eventually did get this to work just fine in 3.0.5, I just had to add the sql table prefixs, and correct one one line in quotes.php.

I am trying to find the the line now that redirects the user after the quote is added. i want to change it to go to my homepage, and not the forum index page. hav'nt found it yet though ... any ideas?

Can you post the details of what you did? I still get errors when someone tries to add a quote.

[docvader]

Originally Posted by Deyth

Can you post the details of what you did? I still get errors when someone tries to add a quote.

Yes, I wiped mine out too with the 3.05 upgrade. Would greatly appreciate a nicely detailed explanation as to how you fixed it anarchystar.

Nice name, by the way. You'll have to tell us how you came up with that one.
rich

[Cyn]

I upgraded to vB 3.0.5 and lost Quoteit in part. I have made the changes to the php files as outlined in the quoteit_readme_txt file and have verified that the custom templates for QuoteIt are still present as well as the template changes necessary. But I'm still not getting a display of QuoteIt on the forum. Any idea what's missing? If I runa reinstall will I lose our database of quotes? Where are the quotes located?

[nineball]

I had the same problem.

I went into the install script for quote php and copied and pasted the insert of the settings and put them into phpmysql and reinserted them. It seems that as part of the upgrade the settings get wriped out.

I then go into the forum home settings and set it to display on the forum home.

That is the only change I made and everything works fine