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]

[magnus]

Originally Posted by Chris-FH

Great work...

But I have a problem. For testing, I added some quotes, but on forumhome, only one, always the same one, is shown...

Before you ask, I set the Disable Quote Moderation to yes, and all the quotes were shown on quotes.php?do=list... ;-)

Any suggestion to fix the problem?

C.

//Only the last Post I added is shown...

//I checked all the templates, I dropped the quotes table und created it new, now the first quote I added is shown...

What version of MySQL/PHP are you running?

[magnus]

Originally Posted by sean289855

Will this work in VB 3.0.1. The reaso I ask is I ma getting nothing to display.

Yes. It should work fine. What's not showing up exactly? Are you seeing the Random Quote box, or are you just not seeing quotes? Etc..

[Chris-FH]

Hey magnus...

PHP v4.3.1 and MySQL v3.23.53 is running. Last night, I got some help, and now, it works:

Find:

PHP Code:

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


and change it to

PHP Code:

        srand((double)microtime()*1000000000); 
        $rand_v = rand(); 
        $result_quote = $DB_site->query("
            SELECT * FROM quotes WHERE approved = 1 ORDER BY rand($rand_v) 


C.

[magnus]

Originally Posted by Chris-FH

Hey magnus...

PHP v4.3.1 and MySQL v3.23.53 is running. Last night, I got some help, and now, it works:

Find:

PHP Code:

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


and change it to

PHP Code:

        srand((double)microtime()*1000000000); 
        $rand_v = rand(); 
        $result_quote = $DB_site->query("
            SELECT * FROM quotes WHERE approved = 1 ORDER BY rand($rand_v) 


C.

Yup. The earlier MySQL workaround. Good job! Glad you got it working.

[Wifey]

Hey When someone is looking at the quotes page in Who's Online, it shows them as being on a weird page - I'm pretty sure it said quotes.php? Any way to fix that? No hurry, it's not a big deal and I know you're busy

[ryancooper]

I ran the script and did all the updates but I get no quote. Made sure it was turned on and everything. Looks like some phrases are missing. See pic..

Thanks for any help . ..

[ryancooper]

Originally Posted by ryancooper

I ran the script and did all the updates but I get no quote. Made sure it was turned on and everything. Looks like some templaes are missing. See pic..


Thanks for any help . ..

Just checked all phrases and templatyes and they are all there. Any ideas? I would really love to get this up an running<

thanks

[djohn]

Magnus, maybe i could help you finish off the hack faster, if you shared what you have done so far. Or beta test it.

[nineball]

Here is a module you can upload to your modules directory to add a quote block to the latest version of vbadvanced

[eob]

You could adapt this hack very easily to make a comments hack, where users could add comments to the end of news articles and non-VB pages...! Any chance of making it happen or would you be offended if I altered it myself?