The Ultimate Quote Hack!!

IF THIS HACK DOESN'T RANDOMIZE WELL FOR YOU, DO THIS:
(by Boofo)
"You need to change the RAND() to RAND(NOW()) to make it more random with the new versions of mySQL since version .54

The NOW will seed it and make it more random that it was before. "

That should fix the problem for a lack of randomized quotes.
ALSO NOTE THIS:
There's a bit of code going around that's 'unofficial' (ie. looks like it's from this hack, but it's adjusted and now flawed), saying "ORDER BY id" in the Query that gets the random quote. This is BAD CODE as it doesn't randomize anything at all. It should say "ORDER BY RAND(NOW())" instead.

</end Hack Issue Fix>


*drumroll*

It's here!

What does this hack do:

* it's an extension (big time!) on the Admin-only controlled hack I released earlier. If you installed that hack already, it should be pretty clear for you which steps you should ignore in the Instructions for this hack. What you Cannot ignore is the step about your Admin Panel, and the lines to add to admin/index.php !

* It lists a random quote either on your Forum Home, or in your Header. Next to that, it adds a Quote List, which is just a massive database of quotes that works just like the Memberlist, but with your quotes. It's searchable, and with the Add-on (see post #2!) users can also add quotes in it (which need moderation, before showing up online).

* Quotes can be added, edited and deleted from your Admin Panel. With the add-on, you can moderate quotes from your AP as well.

* There are no hard-coded colors. All colors are taken from your style, so all pages will appear in concordance of whatever style it is you're using.

Install instructions are in the zipfile: uqh_instructions.txt

For the add-on, see the second post, instructions file: w-add_instructions.txt


Have fun!

[KuraFire]

Xiph: no, this hack does not, in any way, keep track of what user submits which and how many quotes. If you want that, use Lesane's hack. Mine is a more neutral, unbiased hack with an add-on that makes it a bit less neutral and unbiased, but still more than Lesane's.

If you want the total amount of quotes on forumhome, you should be able to easily add a query for that. Something like this:


in root/index.php find:

PHP Code:

// get total posts 


ADD ABOVE:

PHP Code:

$quotetotal=$DB_site->query_first('SELECT COUNT(*) AS count FROM quotes'); 


(or, to include only quotes that are moderated, if you use the Add-on hack: )

PHP Code:

$quotetotal=$DB_site->query_first("SELECT COUNT(*) AS count FROM quotes WHERE mod!='N'"); 


And I've not been in IRC much because of this and other things. Project 3.5 is 99% done, I'm almost ready to send everything online and do the online debugging before opening up. ^_^

Boofo: No, not really. The only difference really, is that the old hack used a Text Input field for Quote, and the new (this) hack uses a Textarea field for Quote, in the Edit page. That, and the new hack doesn't allow empty entries...

[Roxie]

I don't have

// ###################### Start templates #######################

in my global.php

[Roxie]

Nevermind. :/

[Roxie]

Is there away to delete the quotes that come with the hack?
Thanks

[Roxie]

Nevermind :/

I really should think before I ask these dumb questions.

[KuraFire]

That's a valuable lesson in life, don't forget it.

[KuraFire]

Okay, out of boredom I added user-submission-tracking to this hack. It tracks which quotes a user submits, and shows the total number of quotes on their profile (only moderated quotes, not unmoderated submissions), and lastly, it uses the quotelist.php to display all the quotes that one particular user submitted, but in a silent way.

So in the end, it's got the same basic things as Lesane's hack, but taken to a whole new level with better code and a big searchable listing. :/

Instructions for user-tracking only on request by PM/mail, btw.

[Kalen]

this may sound stupid but what is phpmyadmin? =\ thats the only part of the instructions i havent finished because i dont know what it is

[KuraFire]

phpMyAdmin is a 3rd Party Program to run on your server. It's a graphical interface for Database control.

You can find it at www.phpwizards.net I believe, or at phpmyadmin.scourgeforge.net - most webservers have phpMyAdmin pre-installed for you anyway, so check that first!

Basically, it allows you to edit, alter, and add to your database(s). Much easier than doing all that through the mysql command prompt.

[Floris]

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT COUNT(id) AS usertotal FROM quote WHERE ok='Y'
mysql error: Table 'baz.quote' doesn't exist

mysql error number: 1146

Date: Sunday 02nd of June 2002 11:07:11 PM
Script: http://www.marietje.nl/vbb/vbb/userquote.php

Everytime a google searches my site, I get that error. I installed that extra query + result of array to display the quotetotal on the frontpage.