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]

[ncangler]

Based on the error message:
Database error in vBulletin 3.0.6:
Invalid SQL:
SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1
mysql error: Table 'thestudi_cafe.quotes' doesn't exist
mysql error number: 1146

I wonder if the coding is pulling the 'database name' instead of the 'database prefix' (vb_). I'd really like to get this fixed but right now I'm just getting database errors. So I need to uninstall the hack. What files or database additions are made by the install program?

Thanks.

Originally Posted by CtrlAltDel

this script doesn't explicitly define the table prefix in the code. it reads the prefix from your config file. Best bet is to go replace all the 'TABLE_PREFIX' with what your table prefix really is. Not sure how else to help you on the table prefix error.

[Marco van Herwaarden]

Edit your index.php.
find:

PHP Code:

        $result_quote = $DB_site->query("
            SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1 


change to:

PHP Code:

        $result_quote = $DB_site->query("
            SELECT * FROM ". TABLE_PREFIX . "quotes WHERE approved=1 ORDER BY rand() LIMIT 1 


That's the only place i could find where the coder missed a table prefix, for the rest all looked nice coded.

[Marco van Herwaarden]

PS I have feeling that if you would read this thread from teh beginning, that this solution would already be there somewhere.

[ncangler]

That didn't do it.

BTW I have read this thread start to finish. But I took your advice and went through them all again. I came across one post about earlier MySQL versions with an attached code fix to work on the earlier versions. After making that change everything worked! Apparently all of us that are/were having the 'databasename'.quotes doesn't exist error just have earlier versions of MySQL.

Thanks to all for your help.

Originally Posted by MarcoH64

PS I have feeling that if you would read this thread from teh beginning, that this solution would already be there somewhere.

[Marco van Herwaarden]

Well i'll leave it to magnus then, but i think this is what should have fixed it

[ncangler]

Marco, I reloaded clean files, went through the install again, made your suggested change, all with the same result. Then it all started working about five minutes ago. Bizarre! Only a couple of minor quirks to fix but it seems to be working. It apparently was the earlier version of MySQL fix.

Originally Posted by MarcoH64

Well i'll leave it to magnus then, but i think this is what should have fixed it

[ncangler]

Does anyone else have the Add A Quote entry screen layout that mine is showing in the attached image? Seems like the first entry box should be located beside the "Quote Author" item.

[ncangler]

I went into the addquote template and changed the code to clean this up. It now looks like the window below.

Originally Posted by ncangler

Does anyone else have the Add A Quote entry screen layout that mine is showing in the attached image? Seems like the first entry box should be located beside the "Quote Author" item.

[iamboard]

Magnus,

I saw this on someone's site that uses vBadvanced and it looks very interesting. Is it easy for someone to add their own quotes and have those pull automatically and change daily? or do they pull randomly?

Thanks
J

[ncangler]

It is setup for registered members and admins to add quotes. Quotes that members add go into a moderation que and are not posted to confirmed by the admin, although you can turn the moderation feature off if you desire. The quotes are setup to randomly change with page refreshes.

Originally Posted by iamboard

Magnus, I saw this on someone's site that uses vBadvanced and it looks very interesting. Is it easy for someone to add their own quotes and have those pull automatically and change daily? or do they pull randomly?

Thanks
J